What is the solutions the linear programming model where it should include a graphic and i need to understand about it.
Linear Programming (Optimisation) Model)
Shambles have selected the "Mythical Beasts" range and decided to contemplate on "Pegasus" and "Phoenix." They would now like to find the right mix of these two products in order to maximise profit. Every toy has to go through two processes during manufacture: sewing and stuffing.
Pegasus takes 30 minutes to sew whilst Phoenix takes 20 minutes; there are 10 hours (600 minutes) available for sewing each day.
Pegasus takes 20 minutes to stuff whilst Phoenix takes 25 minutes; there are 10 hours (600 minutes) available for stuffing each day.
Pegasus generates £4 profit per toy whilst Phoenix generates £5 profit per toy.
What is the maximum probable daily profit, and how many of each product must be produced in order to achieve this?
Use "Solver" in Microsoft Excel to solve this problem. Include:
i) A print-out of cell values
ii) A print-out of cell formulae
iii) A print-out of the Solver dialogue box with optimisation conditions and constraints
iv) An Answer Report from Solver
v) A statement of the answer in words