1 OPM400 NZZ 2237 Student Name: Student Name: Part A Forecasting (10 Points) Background: Your company has done well for four straight years staring in 2017. ABC Corporation, launched a new sophisticated data collection device using unique, patented, semiconductors chips, supplied from China. As sales grew, ABC added the necessary manpower to keep pace with demand. The data is summarized below: Year Sales Fcst Manpower Fcst 2017 30 25 60 55 2018 35 33 70 65 2019 55 45 80 74 2020 70 60 100 85 2021 A M1 2022 B M2 To be done using Excel a. Given the data given above, develop a forecast for variable A and B using the exponential smoothing with an alpha value of 0.5. What is the forecasted value of 2021(A)____________? Please round to a whole number. No decimals required. b. Using the same method, but with an alpha value of 0.2, forecast the anticipated manpower. What is the forecasted value of 2021 (M1)____________? 2022 Please round to a whole number. No decimals required. c. On your spreadsheet, calculate the % change for each variable. Part A (Continued) d. Create two line graphs, one for Sales and one for Manpower, in the same Excel spreadsheet