Your Perfect Assignment is Just a Click Away
We Write Custom Academic Papers

100% Original, Plagiarism Free, Customized to your instructions!

glass
pen
clip
papers
heaphones

Engineering and technology

Engineering and technology

All-Natural Coop makes three breakfast cereals, A, B, and C, from four ingredients: rolled oats, raisins, shredded coconuts, and slivered almonds. The daily availabilities of the ingredients are 5 tons, 2 tons, 1 ton, and 1 ton, respectively. The corresponding costs per ton are $100, $120, $110, and $200. Cereal A is a 50:5:2 mix of oats, raisins and almond. Cereal B is a 60:2:3 mix of oats, coconut, and almond. Cereal C is a 60:3:4:2 mix of oats, raisins, coconut, and almond. The cereals are produced in jumbo 5-lb sizes. All-Natural sells A, B, and C at $2, $2.50, $3.00 per box, respectively. The minimum daily demand for cereals A, B, and C is 500, 600, and 500 boxes, respectively. Develop an LP model to determine the optimal production mix of the cereals and the associated amounts of ingredients, and find the solution using Solver in Excel.

Order Solution Now