pls share steps

A company produces sound systems for household use. Demand for the first 6 months of the upcoming year can be seen in the table below, You have been commissioned to create the aggregate plan based on the following intormation. Demand and Working Days Costs Inventory Before continuing, provide the marginal cost of subcontracting in the space below. Using the data provided in question 1, create an aggregate plan analysis in Excel using the following 4 production strategies: a) Produce exactly to meet demand; vary workforce (assuming workforce equal to first month's requirements) b) Constant workforce based on average production over the 6 th months using stock outs and inventory only (calculate the workforce: total demand/total work hours per lemployee) c) Constant low workforce based on production requirements for lowest month, use subcontracting to meet demand d) Constant workforce of 2 less workers than the workforce required in part b, use overtime to meet demand You must also provide a table comparing the costs calculated from your analysis that looks like this: A company produces sound systems for household use. Demand for the first 6 months of the upcoming year can be seen in the table below, You have been commissioned to create the aggregate plan based on the following intormation. Demand and Working Days Costs Inventory Before continuing, provide the marginal cost of subcontracting in the space below. Using the data provided in question 1, create an aggregate plan analysis in Excel using the following 4 production strategies: a) Produce exactly to meet demand; vary workforce (assuming workforce equal to first month's requirements) b) Constant workforce based on average production over the 6 th months using stock outs and inventory only (calculate the workforce: total demand/total work hours per lemployee) c) Constant low workforce based on production requirements for lowest month, use subcontracting to meet demand d) Constant workforce of 2 less workers than the workforce required in part b, use overtime to meet demand You must also provide a table comparing the costs calculated from your analysis that looks like this