MUST USE EXCEL & SHOW FORMULAS. ABC Stable feeds horses. The owner recognizes the need to set a nutritional diet for the horses, and at the same time, wants to keep the overall daily cost of feed to a minimum.

The feed mixes available for the horses' diet are an oat product, an enriched grain, and a mineral product. Each of these mixes contains a certain amount of five ingredients. The table below shows these minimum requirements, units of each ingredient per pound of feed mix, and cost for the three mixes. In addition, 6 pounds of feed per day are the most that a horse needs.

Ingredients	Oat (Units/lb.)	Grain (Units/lb.)	Mineral (Units/lb.)	Minimum Daily Requirement (Units)
A	2	3	1	6
B	0.5	1	0.5	2
C	3	5	6	9
D	1	1.5	2	8
E	0.5	0.5	1.5	5
Cost/lb.	$0.09	$0.14	$0.17

Formulate this problem as a linear program and solve for the optimal daily mix of the three feeds with Excel Solver. Note that this is a minimization problem, not maximization. The minimized cost should be $0.687.