Fill in the table for each plan A, B and C using a different table each.

QUESTION 2 The production manager of a company is to prepare an aggregate plan that will cover six months of production of brackets. The forecasted demand for the product in the next six months is as shown below: Month July Aug Sept Oct Nov Dec Forecasted 600 600 1000 1400 1600 1200 demand (units) Additional information: Regular wage Overtime rate Labour requirement Cost of hiring Cost of firing Current workforce Subcontract cost Inventory cost Beginning inventory Normal working time : RM10/hr : RM15/hr (on working days only, subject to 4 hrs max per day) :2 hrs to produce 1 unit of product : RM1,000 per worker :RM1,500 per worker : 11 workers (i.e. workforce available at the beginning of July) : RM40/unit : RM10/unit/month held :0 unit (.e. at the beginning of July) :8 hours/day, 25 days/month All monthly demands must be fulfilled immediately (i.e. backlog or backorder is not allowed). The manager is considering 3 possible plans as follows: Plan A: Maintain the current workforce (11 workers) and use inventory only to absorb changes in demand. Plan B: Use minimum possible regular workforce, vary over time and subcontract as necessary. For this plan it is not allowed to have inventory. Plan C: Vary the number of workers employed to exactly meet the forecasted monthly demand. (Assume the workers remaining at the end of December will not be laid-off). Propose the best possible plan to adopt. . Is there any Plan that you would exclude from consideration in case of strong opposition from the union for laying off workers? Any other reason why you should not favor this Plan? Month July Aug Sep Oct Nov Dec Total Forecast Production schedule Regular time Part time Overtime Subcontract Extra/shortage Inventory Beginning Ending Average Backorder Cost Regular time Part time Overtime Subcontract Hire/layoff Inventory Backorders Total