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


Excel Online Activity: Exponential Smoothing A retail store records customer demand during each sales period. The data has been collected in the Microsoft Excel Online le below. Use the Microso Excel Online file below to develop the single exponential smoothing forecast and answer the following questions. Open spreadsheet Questions 1. What is the forecast for the 13th period based on the single exponential smoothing? Round your answer to two decimal places. 12.42 0 A B C D E F G H I J K Exponential Smoothing Forecasting WNH Smoothing constant 0.3 -A Time Period Observation Forecast Error Error 2 Formulas 92 #N/A 92 #N/A #N/A V #N/A 87 #N/A #N/A V #N/A 88 #N/A #N/A #N/A 10 CO OO VO UA W N- 94 #N/A #N/A #N/A 11 88 #N/A V #N/A #N/A 12 90 #N/A #N/A #N/A 13 88 #N/A #N/A #N/A 14 91 #N/A #N/A V #N/A 15 10 91 #N/A 7 #N/A V #N/A 16 11 87 #N/A #N/A #N/A 17 12 97 #N/A #N/A #N/A 18 Next period forecast: 13 #N/A 19 20 MSE #N/A 21 22 23 24 25 26
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
