Description about Horse Feed Mix Planning
Problem: A boarding stable feeds and houses work horses used to pull tourist-filled carriages through the streets of a historic city. The stable owner wishes to strike a balance between a healthy nutritional standard for the horses and the daily cost of feed.
Part 1- This type of horse must consume exactly 5 pounds of feed per day. The feed mixes available are an oat product, a highly enriched grain, and a mineral product.
Part 2- Each of these mixes contains a predictable amount of five ingredients needed daily to keep the average horse healthy.
Part 3- The table below shows these minimum requirements, units of each nutrient per pound of feed mix, and costs for the three mixes.
FEED MIX
Nutrient Oat/lbs Grain/lbs Mineral/lbs. Needed/per day
A 2.0 3.0 1.0 6
B 0.5 1.0 0.5 2
C 3.0 5.0 6.0 9
D 1.0 1.5 2.0 8
E 0.5 0.5 1.5 5
Cost/lb $ 0.33 $ 0.44 $ 0.57
Part 4- Solve the problem using excel solver for the optimal daily mix
I need help to explain the mixing plan used for horse feed. Also describe minimum requirements of each nutrient per unit pound of feed mix.