OPM 400 A 1 (10%) USE ONLY EXCEL formulas for work - I will need to be able to verify You may answer all your answers on this one sheet in a logical manner.. DUE by FRIDAY, OCT 9, 2020 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 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 and create additional columns to show your work relevant to that Question. All answers to 2 Decimal Places QUESTIONS Use the Nalive method to forecast for Aug - Feb 2015 Actual Calculate a 2-period moving average forecast for periods-Mar to Aug JAN 2000 3 Calulate a weighted forecast for periods-Mar to Aug with 0.75, 0.25 FEB 1652 4 Calculate the Forecast for Aug to Feb with a smoothing constant a = 0.45 and the Forecast for FEB = 2450 MARC 3201 5 Calculate the MAD, MSE and the MAPE APRIL 1599 MAY 3425 Please be very organized with the answers- Marks are allocated for Verifiable Calculations/formulas/Organization, Neatness of data and accuracy of Calculations JUNE 3522 JULY 3395 Ans 1: Ans 2: etc