Problem 1
A farm has been experimenting with a special diet for itshorses. The feed components for the diet are
a standard feed product, a vitamin-enriched oat product, and anew vitamin and mineral feed additive
(detail below). The minimum daily diet requirements for eachhorse are 3 units of ingredient A, 6 units
of ingredient B, and 4 units of ingredient C. In addition, tocontrol the weight of the horses, the total
daily feed for a horse should not exceed 6 pounds. The farmwould like to determine the minimum-
cost mix that will satisfy the daily diet requirements.
Ingredients [in units] to Produce One Pound of Special Die
Feed Component | Standard | Enriched Oat | Additive |
Ingredient A | 0.8 | 0.2 | 0.0 |
Ingredient B | 1.0 | 1.5 | 3.0 |
Ingredient C | 0.1 | 0.6 | 2.0 |
Cost Per Pound | $0.25 | $0.50 | $3.00 |
On a separate piece of paper, define the variables and formulatethe mathematical model for this problem.
Enter the model into Excel's Solver and solve it. How manypounds of Standard product, Enriched Oat, and Additive should beused in the mix to generate the lowest possible total cost?
Please complete on excel using solver so I can see how to formatand what cells to link
