Microsoft Excel Activity #2: Weighted Moving Average Forecast 0 X Question 1 0/10 Submit Consider the demand for some product over the last 12 periods. The weights of 0.4, 0.2, 0.2, and 0.2 are assigned to the most recent, second most recent, third most recent, and fourth most recent periods, respectively. The data has been collected in the Microsoft Excel Online file below. Use the Microsoft Excel Online file below to clevelop the four-period weighted moving average forecast and answer the following questions. A-Z Open spreadsheet Questions 1. Calculate the forecast for the periods from 5 to 13 using a four-period weighted moving average. Do not round intermediate calculations. Round your answers to the nearest whole number Period Forecast G B 9 10 11 12 13 2. Choose the correct graph for the four-period weighted moving average forecast. Back Next 1 Type here to search 16C Partly sunny T! ENG 2:56 PM 2021-10-21 Microsoft Excel Activity #2: Weighted Moving Average Forecast X Question 1 010 2. Choose the correct graph for the four-period weighted moving average forecast. Submit The correct graph is Actual Demand Forecast Weighted Moving Average Porecast son 4000 3000 2000 1000 9 10 11 12 13 2 Period Actual Demand Forecast Weighted Moving Average Forecast 5000 Back Next 1 Type here to search 16C Partly sunny T! ENG 2:56 PM 2021-10-21 Microsoft Excel Activity #2: Weighted Moving Average Forecast 0 X Question 1 0/10 Forecast Weighted Moving Average Forecast 5000 Submit 4000 3000 B. 2000 1000- 10 11 12 13 14 Period Actual Demand Forecast Weighted Moving Average Forecast 5000 4000 3000 2000 Back Next 1 Type here to search 16C Partly sunny T! ENG 2:57 PM 2021-10-21 Microsoft Excel Activity #2: Weighted Moving Average Forecast X Question 1 0/10 30001 Submit c. 2000 1000 10 11 12 13 14 Period Actual Demand Forecast Weighted Moving Average Forecast 5000 4000 3000 D 2000 1000 9 10 11 12 13 14 Purina Rack Next 1 Type here to search 16C Partly sunny T! ENG 2:57 PM 2021-10-21 Excel template Search (All + 0) File Home Insert Draw Page Layout Formulas Data Review View Help Editing Comments 20 $ Arial B V A V Merge $ O E 4 Ov .. V C15 E F G H 1 K L M N 0 P Q R S 1 1 Use the area below lo draw a line chart for the four-period weighled moving average. A B D 1 Weighted Moving Average Forecast (4 periods) 2 3 3 Description Weight 4 Fourth most recent period 0.2 5 Third most recent period 0.2 6 Second most recent period 0.2 Most recent period 0.4 8 B Total 10 9 10 Period Actual Demand Forecast Formulas 11 1 1,400 12 2 2,300 13 3 2,100 14 4 1,400 15 5 2.600 16 6 3,900 17 / 3,200 18 8 3 3,100 19 9 4,300 20 10 4,500 21 11 4,100 22 12 4.300 23 13 24 25 26 27 28 1 = Sheet1 + Waiting for excelofficepaslive.com... #N/A UNA #NA UNA ANA #N/A #N/A #NA #N/A Type here to search Loading Add-ins - Give Feedback to Microsoft - 100% + 2:58 PM 16C Partly sunny Aloa 4. ENG 2021-10-21 O Et