Which plan do you think is the best option? Provide a thorough analysis of the pros and cons of the option you have selected. The analysis must be evidenced based and realistic to earn full marks. Using the numbers provided, calculate the number of workers you will use for your assessment for part b [see Question 3 or instructions provided in Moodle]: 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 1 employee) Answer: Upload a single Excel file here. FORMATIING: 1. Set the decimals to zero \\( (0) \\) so that the numbers appear as whole numbers in your cells. 2 Provide all parts of the analysis on a single sheet. GRADING: 1. Aggregate Production Planning Requirements [ 3 marks] 2. Production Plan a [5 marks] 3. Production Plan b [ 5 marks] 4. Production Plan c [5 marks] 5. Production Plan d [5 marks] 6. Comparison of All Plans [ 3 marks] 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 information. Demand and Working Days Costs 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 l employee) 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: Cost Comparison 36 Production Plan 1: Exact Production; Vary Workforce Read T 63 imentory cost 64 Straight time cost 65 Total Monthly cost of production \\begin{tabular}{l} 65 \\\\ 67 \\\\ 65 \\\\ \\hline 61 \\\\ \\hline 69 \\\\ \\hline \\end{tabular} A 69. Production Plan 3: Constant low Workforce; Subcontract Solution W23 sheet? Sheet3 Beady \\( t \\) Inventory Before continuing provide the marginal cost of subcontracting in the space below