Bhengu Industries ia expanding is product line to incude ula O. There are to be produced on the same production equipmen

[answerhappygod]

Bhengu Industries Ia Expanding Is Product Line To Incude Ula O There Are To Be Produced On The Same Production Equipmen 1 (381.63 KiB) Viewed 24 times

Bhengu Industries ia expanding is product line to incude ula O. There are to be produced on the same production equipment and the objective is to meet the demands for the three products using overtime where necessary. The demand forecast for the next four months in hours required to make each product is as shown below. Product July August 900 September 1000 M 700 N 800 800 7:00 1200 800 800 800 Because the products deteriorate rapidly, there is a high loss in quality and, consequently, a high camying cost when a product is made and camed in inventory to meet future demand. Each hour's production camed 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 st R30 when working on M, R90 for N and R100 for 0. The overtime premium is 80 percent of the regular time cost per hour. The number of preduction houssailele for reguler time and evertime is: July August September Regular time 1800 Overtime 800 Set up the problem in a spreadsheet and an cotimal solution for total cost of the aggregate production plan using the Excel Solver Note.