solve one using excel solver add-in on an excel sheet, include A word document describing the steps you follow in detail. You should also include the excel document that includes the excel solver model. Get a sensitivity report and describe in detail the report sections on the word document. Describe what does objective function coefficient sensitivity analysis and RHS value sensitivity analysis tell you about the model? 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, respectively. 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.00, $2.50, and $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 AMPL, Solver, or TORA.