please solve it and give the equation for each answer in excel.

OPM 400 A 1(12.5%) DUE by MONDAY, Feb 7, 2022 LAST, FIRST NAME: 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.. 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 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 Q1 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 2015 Actual 1 Use the Naiive method to forecast for Aug - Feb 2016 JAN 2000 2 Calculate a 2-period moving average forecast for periods-Mar to Aug 1652 Calulate a weighted forecast for periods-Mar to Aug with 0.65, 0.25,0.1 MARC 3201 4 Calculate the Forecast for Aug to Feb with a smoothing constant = 0.45 and the Forecast for FEB = 2350 APRIL 1599 5 Calculate the MAD, MSE and the MAPE for the exponential Forecast Values 3425 JUNE 3522 Please be very organized with the answers- Marks are allocated for Verifiable Calculations/formulas/Organization, Neatness of data and accuracy of Calculations 5% for Accuracy of answers, 5% for visibility of Calculations, 2.5% for Neatness and Organization of Answer Formats FEB 3 MAY JULY 3395 Ans 1: Ans 2: etc