Homework Problems, Please Help!!!!

[trufay]

I am not good in Excel and this is a required class for my major.

Heavenly Hound Kennels
Specification
Grain Product A B C
Cost per Pound $0.45 $0.38 $0.27
Protein 0.62 0.55 0.36
Carbohydrate 0.05 0.10 0.20
Fat 0.03 0.02 0.01 Totals Reqs.
Blend Ounces
Protein Contribution
Carbo Contribution
Fat Contribution
Cost Constribution
Above is my assignment: I have to make sure that each dog consumes at least 8 ounces of protein, 1 ounce of carbo, and no more than 0.5 ounces of fat each day. I have to use set of Solver to optimize and minimize costs and use the RWB layout convention. Rows A, B, and C contain the ounces to be blended. This model is Linear.

I really need help because I don't understand Excel well enough to apply any theories. I have hit a wall.

[Jay Petrulis]

Hi,

We cannot do your homework for you, but here are some hints....

You want to minimize total costs, which is equal to

Oz of A * Cost/oz of A
+
Oz of B * Cost/oz of B
+
Oz of C * Cost/oz of B

Note carefully that the prices you are given are per lb (=16 ounces).

Set up your data to calculate to total cost based on the above formula (Use SUM of the 3 intermediate formulas)

Try some values for A, B, and C to see if your cost calculations are correct.

Then, find out how much protein, carbs and fat are included in the amounts you have tried. Get a total for each of the types.

Then, look at the Solver setup.

Try this first step and report back any problems/questions.

Be sure to tell us exactly what you did.

Bye,
Jay

[trufay]

Jay

Thank You! I will start working on it, wish me luck.