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 LAST, FIRST NAME: BOLD your answers . Marks are allocated for Neat tables and Logical presentation of the file. I will have to be able to click the cell and verify your Excel calculations Label Work-in-progress as DRAFT. SUBMIT ONE Excel FILE called FINAL when done with all answers- ABC Manufacturing has the following data for their Shampoo sales. Use the following data to answer the Questions:Copy these two columns for every answer (for Q 1 to 5) and create additional columns to show your work relevant to that Question. All answers to 3 Decimal Places Questions All Ans to 3 Decimal Places 2015Actual 1Use the Naiive method to forecast for Aug - Feb 2016 JAN2200 2Calculate a 2-period moving average forecast for periods-Mar to Aug FEB1800 3Calulate a weighted forecast for periods-Mar to Aug with 0.65, 0.25,0.1 MARC3201 4Calculate the Forecast for Aug to Feb with a smoothing constant = 0.35 and the Forecast for FEB = 2550 APRIL1599 5Calculate the MAD, MSE and the MAPE for the exponential Forecast Values MAY3425 JUNE3600 Please be very organized with the answers - Have each answer vertically done and NOT as one big table that makes it hard for meto mark- Marks are allocated for Verifiable Calculations/formulas/Organization, Neatness of data and accuracy of Calculations JULY 3400 5% for Accuracy of answers, 5% for visibility of Calculations, 2.5% for Neatness and Organization of Answer Formats Ans 1: Ans 2: etc