Question: Excel Online Activity: Moving Average A- A retail store records customer demand during each sales period. The data has been collected in the Microsoft Excel

Excel Online Activity: Moving Average A- A retail

Excel Online Activity: Moving Average A- A retail store records customer demand during each sales period. The data has been collected in the Microsoft Excel Online file below. Use the Microsoft Excel Online file below to develop three-period and four-period moving average forecasts and answer the following questions. Open spreadsheet Questions 1. What is the forecast for the 13th period based on the three-period moving average? Round your answer to two decimal places. 94.33 2. What is the MSE for the three-period moving average? Round your answer to two decimal places. 27.56 3. Choose the correct graph for the three-period moving average forecast. The correct graph is graph D 4. What is the forecast for the 13th period based on the four-period moving average? Round your answer to two decimal places. 94 5. What is the MSE for the four-period moving average? Round your answer to two decimal places. 9.10 X B C D E F G H I J K Moving Average Forecasting U HNM+ Periods in moving average 3 4 Demand Forecast Error Error^2 Time Period 1 Formulas 86.67 #N/A #N/A #N/A novo AWN 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 93 86 81 82 93 85 85 90 93 95 91 97 =AVERAGE(C6:08) #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A Next period forecast: MSE #N/A U Periods in moving average 4 Demand Forecast Error Error^2 Time Period 1 2 3 4 5 6 7 8 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 93 86 81 82 93 AVERAGE(C27:C30) 85 85 90 93 95 91 97 #N/A #N/A #N/A NEDOVOWN #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A 9 #N/A 10 11 12 #N/A #N/A #N/A #N/A #N/A Next period forecast: 13 MSE #N/A Which moving average is best? #N/A 43 44

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

A retail store records customer demand during each sales period. The data has been collected in the Microsoft Excel Online file below. Use the Microsoft Excel Online file below to develop the single...

Exponential Smoothing Forecasting Use the area below to draw a line chart for single exponential smoothing forecast. Smoothing constant 0.1 Observation Forecast Error Error2 Formulas Time Period 1 2...

undefined Exponential Smoothing Forecasting 1 2 B 1 Smoothing constant 0.3 Observation Forecast Error Error^2 5. Time Period 1 2 5 7 3. 3 4 5 6 7 90 94 89 90 86 87 87 83 86 90 86 92 0 1 2 3 4 5 6 7 8...

The equity section of Jeans Incorporated is as follows: Required Calculate the amount of dividends allocated to common and preferred stockholders under the following situations: (a) $18,000 of total...

(1) Why do budgetary and fiscal policies formulated by The President cannot be implemented immediately? (2) What are examples of transfer payments? (3) Is unemployment an automatic stabilizer? (4)...

Consider the closed-loop system in Figure CP4.9, whose transfer function is G(s) == 10s s + 100 5 and H(s): = s + 50 (a) Obtain the closed-loop transfer function T(s) = Y(s)/R(s) and the unit step...

lab 10, question 2 Consider two countries with the same level of potential GDP, say $100 billion, todayl Suppose potential GDP grows at an annual rate of 22 percent in Country One and 5.2 percent in...