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.