Modify the Holiday Meal Turkey Ranch Problem in Figure 2.22 to include a third brand (Brand C). Brand C feed costs $0.12 per pound. Each pound of Brand C feed contains 12 protein units, 2 vitamin units, and 0.20 iron units. Use Excel to solve the problem.

Figure 2.22

Transcribed Image Text:

1 Holiday Meal Turkey Ranch Use 4.2 pounds of A and 2.4 pounds of B. 2 3 Brand A Brand B 4 5 Number of pounds 6 Cost 7 Constraints: 8 Protein required 9 Vitamin required 10 Iron required 11 (Minimum cost is $0.78.) $O.78 4.20 2.40 $0.10 S0.15 45.0 >= 45.0 24.0 10 24.0 >= 0.5 2.1 >= 1.5 LHS Sign RHS 12 solver Parameters 13 15 16 $D$6 Set Objective: 17 O Min C Value Of: To: Max The Make Unconstrained Variables Non-Negative box must be checked and the solving method must be set to Simplex LP. 18 19 By Changing Variable Cells: 20 $8$5:$C$5 21 22 subject to the Constraints: 23 SD $8: SO$10 >= ȘF$8:$F$10 24 This is a cost Problem involves three 2 constraints. minimization problem. 54 456 7