A farm has been experimenting with a special diet for its horses. The feed components for the diet are a standard feed product, a vitamin-enriched oat product, and a new vitamin and mineral feed additive (detail below). The minimum daily diet requirements for each horse are 3 units of ingredient A, 6 units of ingredient B, and 4 units of ingredient C. In addition, to control the weight of the horses, the total daily feed for a horse should not exceed 6 pounds. The farm would 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 formulate the mathematical model for this problem.
Enter the model into Excel's Solver and solve it. How many pounds of Standard product, Enriched Oat, and Additive should be used in the mix to generate the lowest possible total cost?
Please complete on excel using solver so I can see how to format and what cells to link