Question 1 (5 points) Using ratio and time series analyses, conduct an analysis for the demand for sales employees with the following steps. Assume we are now at the end of 2021, and we are forecasting the demand for sales staff for 2022 NOTE! Provide how you will calculate the answers and NOT a numeric answer. For example, your answer should be something like 3200/171, and you are NOT expected to calculate the result. Part 1: A simple ratio analysis 1 Calculate the employee requirement ratio in 2021 (cell b). b (In the remaining parts of this question, use "b" to denote this value if you need to use it.) 2. Assuming the employee requirement ratio in 2022 will remain the same as 2021, forecast the number of sales employees needed in 2022 (cell d). d= Part 2: Time-series analysis 3 Calculate 3-year moving average of employee requirement ratio to cell c) (In the remaining parts of this question, use "c" to denote this value if you need to use it.) 4. Use the ratio you calculated in step 3 to forecast the number of sales employees needed in 2022 (cell d). d= Forecast # of Employees Required Year Operational Actual # of Employee Forecast Index- Sales Employees Requirement Employee (s thousand) Ratio Requirement Ratio 2019 3095 162 19.10 2020 3200 171 18.71 (a) 2021 3600 185 (b) (c) 2022 3800 (d) Blank # 1 A/ Blank # 2 Blank #3 Blank #4