QUESTION Bengu Industries is expanding its prodct line to include tree new products: M, N and o These are to be produced on the same production equipment and the objective 1510 puder the demands for the three products using overtime where necessary. The demand forecast once text four months in boars required to-make each product is as strobale Product Junewy August September 700 500 900 M 7000 N 600 800 700 1200 800 600 800 900 Because the products deteriorate rapidly, there's a high loss in quality and, consequently , a high carrying cost when a produdeis made and carried in inventory to meet future demand. Each hour's production carried into future months costs R50 per production hour for Model M, R70 for Model N, and R90 for Model O. Production can take place either during regular working hours or during overtime Regular time is paid at R80 when working on M, R90 for N, and R100 for 0. The overtime premium is 60 percent of the regular time cost per hour. The number of production hours available for regular time and overtime is: June July August September Regular time 1600 1400 1700 1900 Overtime 600 750 800 900 Set up the problem in a spreadsheet and an optimal solution for total cost of the aggregate production plan using the Excel Solver