Question: How do I solve section B using Excel Solver? Problem A-4 (Static) A diet is being prepared for the University of Arizona dorms. The objective


How do I solve section B using Excel Solver?
Problem A-4 (Static) A diet is being prepared for the University of Arizona dorms. The objective is to feed the students at the least cost, but the diet must have between 1,800 and 3,600 calories. No more than 1,400 calories can be starch, and no fewer than 400 can be protein. The varied diet is to be made of two foods: A and B. Food A costs $0.75 per pound and contains 600 calories, 400 of which are protein and 200 starch. No more than 2 pounds of food A can be used per resident. Food B costs $0.15 per pound and contains 900 calories, of which 700 are starch, 100 are protein, and 100 are fat. a. Write the equations representing this information. (Leave no cells blank - be certain to enter "O" wherever required. Round your answers to 2 decimal places.) Minimize z = 0.75 A + 0.15 B s.t Calories 900 Bs 3,600 1,800 + Calories 900 Starch + 600 A + 600 A + 200 A 400A + 1 A 1,400 700 BS 100 B 2 Protein + 400 Amount of A I b. What is the optimal solution? (Round your answers to 2 decimal places.) Decision for A Decision for B TotalStep by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
