Answer Happy

Dhengu Industries is expanding its product line in inchide three new products. M. Nand O. These are to be produced on the same production equipment and the objective is in meet the demands for the three products using overlue where necesseuy. The demand faxrecast for the next four months in hours required to make each produd is as shown below Product June July August September M 100 000 1000 N 000 3:00 100 800 800 300 900 Because the products deteriorate rapidly, there is a high loss in quality and. consequently, a high carrying cost when a product is made and camed 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 con take place either during regular working hours or during overtime. Reguler time is peid at R80 when working on M, RDO for N, and R100 for O. 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 Regular time September 1800 1400 AD Overtime 1900 000 750 300 30/0 Set up the problem in s spreadsheet and an optimal solution for total cost of the aggregate production plan using the Edcel Solver Nose-