Question: 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. 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. Each of these mixes contains a predictable amount of five ingredients needed daily to keep the average horse healthy. The table below shows these minimum requirements, units of each nutrient per pound of feed mix, and costs for the three mixes.
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
10-1 Solve the problem using excel solver for the optimal daily mix
A horse stable needs to decide optimal mix of feed. Various nutrients should be supplied to horses on a daily basis. There are three main sources of nutrients: Oats, Grain and Minerals. Each of these provide various nutrients as per the content. The stable needs to decide optimal mix of feed that meets nutrient requirements and minimizes cost of feed. This problem is addressed through Linear Programming and solve process demonstrated through Excel Solver.