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 optimiser on Microsoft Excel and use the Solver add-on to advise the company how many batches of each product it should make to maximise profit.

Product A Product B New Product Profit (Objective) Batches to Make 500 750 ? 1,100 ? Materials Required per Pallet Type Available Units Semi-skilledlabourtimeSkilledlabourtimeMaterials5055005015400100103006,00080031,000hourshoursunits