Posted: February 7th, 2016
What is the maximum possible daily profit, and how many of each product should be produced in order to achieve this?
| Shambles have selected the “Mythical Beasts” range and decided to concentrate on “Pegasus” and “Phoenix.” They would now like to find the right mix of these two products in order to maximise profit. Each 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 possible daily profit, and how many of each product should be produced in order to achieve this? |
| Use “Solver” in Microsoft Excel to solve this problem. Include: |
| a print-out of cell values [2 marks] |
| a print-out of cell formulae [3 marks] |
| a print-out of the Solver dialogue box with optimisation conditions and constraints [3 marks] |
| an Answer Report from Solver [1 mark] |
| a statement of the answer in words [1 mark] |
Expert paper writers are just a few clicks away
Place an order in 3 easy steps. Takes less than 5 mins.