Palomino Farms is experimenting with a special diet for its racehorses. The feed components availabl
Question: Palomino Farms is experimenting with a special diet for its racehorses. The feed components available are a standard horse feed product, a vitamin enriched oat product, and a new vitamin and mineral feed additive. For each nutrient found in the feed components, the nutritional values in units per kg of feed, and the minimum daily nutrient requirement per horse are shown in the table below. The cost per kg of feed component is also shown in the table. To control the weight of the horses, the total daily feed for each horse should not exceed 6 kg.
Standard (per kg) | Enriched Oat (per kg) | Additive (per kg) | Minimum daily nutrient requirement | |
Nutrient 1 | 0.8 | 0.2 | 0.0 | 3 |
Nutrient 2 | 1.0 | 1.5 | 3.0 | 6 |
Nutrient 3 | 0.1 | 0.6 | 2.0 | 4 |
Cost | $1.50 | $3.00 | $18.00 |
a) Formulate this as a cost minimization problem. Minimum daily nutrient requirements need to be satisfied.
b) Use Excel solver to find the optimal decision. Include your Excel spreadsheet as part of your assignment.
c) What is the optimal cost value?
d) Identify the binding and slack constraints and explain what the implications are.
Type of Deliverable: Word Document
