Question: Solve LP problems via Excel Solver. Report your answers in detail, and submit an Excel worksheet on Canvas. Question 1 is one of in-class exercises

Solve LP problems via Excel Solver. Report yourSolve LP problems via Excel Solver. Report your

Solve LP problems via Excel Solver. Report your answers in detail, and submit an Excel worksheet on Canvas. Question 1 is one of in-class exercises Question 2 is one of problems from Homework 4 Question 3 is new. Thus, please also submit a paper-based formulation as well. 3. All-Natural Coop makes 3 breakfast cereals, A, B and C from 4 ingredients: rolled oats, raisins, shredded coconut and slivered almonds. The daily availabilities of these ingredients are 5 tons, 2 tons, 1 ton and 1 ton, respectively. The costs per ton are $100, $120, $110 and $200 respectively. Cereal A is 85% oats, 12% raisins and 3% almonds by weight. Cereal B is 90% oats, 4% coconut and 6% almonds by weight. Cereal C is 82% oats, 6% raisins, 8% coconut and 4% almonds by weight. The cereals are produced in 5 pound containers. Cereal A sells for $2 per container, while cereals B and C sell for $2.50 and $3 per container each. Formulate a linear program that can be used to determine how much of each cereal to make each day to maximize profit. (50 points]

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!