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.

Price: $2.99
See Solution: The solution consists of 2 pages
Type of Deliverable: Word Document

log in to your account

Don't have a membership account?
REGISTER

reset password

Back to
log in

sign up

Back to
log in