Sign in e A W Z AA AB AC Formulas fx B C D E F 23 Home Insert Page Layout Data Review View Help Tell me what you want to do Enable Editing PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit it's safer to stay in Protected View. A OPM400 A1 VD [Protected View] - Excel G H L M N 0 P Q R S OPM 400 A 1 (12.5%) U 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.. B LAST, FIRST NAME: DUE by MONDAY, Feb 7, 2022 4 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 5 Label Work-in-progress as DRAFT. 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 Q 1 to 5) and create additional columns to show your work relevant to that Question. 9 All answers to 3 Decimal Places 12 10 11 2020 Actual 12 JAN 1000 2 13 FEB 899 3 14 MARC 1892 15 APRIL 2225 16 MAY 2250 17 JUNE 3251 18 JULY 2750 19 45 QUESTIONS All Ans to 3 Decimal Places Use the Naiive method to forecast for Feb -Aug 2021 Calculate a 2-period moving average forecast Calulate a weighted forecast with 0.55, 0.25, 0.2 Calculate the Forecast with a smoothing constant = 0.35 and the Forecast for FEB = 1982 Calculate the MAD, MSE and the MAPE for the Exponential Smoothing Forecasts Please be very organized with the answers-Have the answers done in a vertical manner and not as one big table that makes it difficult for me to mark. Marks are allocated for Verifi 5% for Accuracy of answers, 5% for visibility of Calculations, 2.5% for Neatness and Organization of Answer Formats 20 Ans 1: 21 22 22 22 23 Ans 2: 24 25 etc... 26 27 28 29 30 31 32 33 34 Ready Sheet1 Type here to search DOLL 9 + 14C Sunny 9:14 AM 6/2/2022 Bell 100% D