Complete the table

Question 2 Using the given information about forecasts for an aggregate planning spanning through September 2019- March 2020 (production in hours) with 100 production hour in September 2019, and of which starting and ending inventories of 50 have been proposed. The following costs have been earmarked: production per hour cost $200, and inventory carrying cost/production hour/per month is $60. S/N Month Forecast D. 1 Sept., 2019 40 2 Oct., 2019 50 3 Nov., 2019 140 4 Dec., 2019 110 5 Jan., 2020 80 6 Feb., 2020 60 HI 7 Mar. 2020 40 (a) Prepare an aggregate planning using the two pure plans (hint: you may use the template below) End of Level Chase Month Production Cumulative Expected Expected Production Cumulative Expected Expected Available Cumulative Ending Available Cumulative Ending (production) Demand Inventory Demand Inventory 50 1 100 2. 100 3 100 4 100 5 100 100 50 ON