Based on given data, generate aggregate planning table and find total cost for Plan B and C respectively.

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 Forecasted demand (units) July 600 Aug 600 Sept 1000 Oct 1400 Nov 1600 Dec 1200 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 (i.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 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)