The company has decided to produce the product in standard shipping batches. To cope with the new product, an adjustment to production needs to be made on the lines that will make it. The company has given you the following information:

Design an optimizer on Microsoft Excel and use the Solver add-on to advise the company how many batches of each product it should make to maximize profit.

 

  

Transcribed Image Text:

Profit (Objective) Batches to Make Semi-skilled labour time Skilled labour time Materials Product A Product B New Product £500 £750 ? ? Materials Required per Pallet Type Available Units 50 5 500 £1,100 ? 50 15 400 100 10 300 6,000 hours 800 hours 31,000 units Profit (Objective) Batches to Make Semi-skilled labour time Skilled labour time Materials Product A Product B New Product £500 £750 ? ? Materials Required per Pallet Type Available Units 50 5 500 £1,100 ? 50 15 400 100 10 300 6,000 hours 800 hours 31,000 units

Answer rating: 100% (QA)

To design an optimizer in Microsoft Excel and use the Solver addon to maximize profit follow these steps Step 1 Set up the Excel spreadsheet Create a ... View the full answer