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.