Please answer questions above by using Aggregate Planning Table for each plan A,B and C as stated because i really need to see the tabled data!!

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 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