give solution with calculation on excel

AA 2 1 OPM 400 A 1 (12.5%) USE ONLY EXCEL formulas for work - I will need to be able to verify every cell. You may answer all your answers on this one sheet in a logical manner.. DUE by MONDAY, Feb 7, 2022 3 LAST, FIRST NAME: BOLD your answers . Marks are allocated for Neat tables and Logical presentation of the file. 4 will have to be able to click the cell and verify your Excel calculations 5 SUBMIT ONE Excel FILE called FINAL when done with all answers- 6 7 Kate Manufacturing has the following data for their cutting tool sales. 8 Use the following data to answer the questions: Copy these two columns for every answer (for Q1 to 5) and create additional columns to show your work relevant to that Question. 9 All answers to 3 Decimal Places 10 QUESTIONS All Ans to 3 Decimal Places 11 2020 Actual 1 Use the Naiive method to forecast for Feb -Aug 2021 12 JAN 1000 2 Calculate a 2-period moving average forecast 13 FEB 899 3 Calulate a weighted forecast with 0.55, 0.25, 0.2 14 MARC 1892 4 Calculate the Forecast with a smoothing constant = 0.35 and the Forecast for FEB = 1982 15 APRIL 2225 5 Calculate the MAD, MSE and the MAPE for the Exponential Smoothing Forecasts 16 MAY 2250 17 JUNE 3251 Please be very organized with the answers- Marks are allocated for Verifiable formulas/Calculations, Organization, Neatness of data and accuracy of calculations 18 JULY 2750 5% for Accuracy of answers, 5% for visibility of Calculations, 2.5% for Neatness and Organization of Answer Formats 19 20 Ans 1: 21 22 23 Ans 2: 24 5 25 etc... 26