An analyst is using exponential smoothing to forecast the daily demand for a key product. The analyst starts with a naive forecast for time period 2, then begins using exponential smoothing with a smoothing constant of 0.15. The table below shows some of the calculations. period actual forecast 1 125 2 136 125 3 144 126.65 4 157 129.25 5 181 ? What is the predicted demand for time period 5? Round your answer to two decimal places.
Period | Actual | Forecast |
1 | 125 | |
2 | 136 | 125 |
3 | 144 | 126.65 |
4 | 157 | 129.25 |
5 | 181 | ? |
The predicted demand for the time
actual is 181 for 5th period and smoothing constant is 0.15
forecast demand FT = FT-1 +$(AT-1 - FT-1 )
WHERE FT = NEW FORECAST DEMAND
FT-1 = PREVIOUS PERIOD FORECAST
$ = SMOOTHING CONSTANT
AT-1 = PREVIOUS PERIOD ACTUAL DEMAND
FT-1 = PREVIOUS PERIOD FORECAST
based in these = 129.25+0.5(157-129.25)
= 129.75 + 27.75
= 157.50
SO THE PREDICTED DEMAND FOR PERIOD 5 IS 157.50
An analyst is using exponential smoothing to forecast the daily demand for a key product. The...
A management analyst is using exponential smoothing to predict merchandise returns at an upscale branch of a department store chain. Given an actual number of returns of 35 items in the most recent period completed, a forecast of 49 items for that period, and a smoothing constant of 0.50, what is the forecast for the next period? Round your answer to 2 decimal places.
Today's forecast equals yesterday's actual demand" is referred as A. a moving average B. exponential smoothing C. the naive approach. D. the Delphi method
Given the following data, use exponential smoothing (α=0.2) to develop a demand forecast. Assume the forecast for the initial period is 5. Period Demand 4 5 7 913 8 The exponential smoothing forecast is (round your responses to two decimal places): Period 3 刄 7 Forecast 5.00
The manager of a travel agency has been using a seasonally adjusted forecast to predict demand for packaged tours. the actual and predicted values are as follows: Period Demand Predicted 1 124 113 2 184 200 3 144 150 4 79 102 5 74 80 6 119 135 7 114 128 8 141 124 9 106 109 10 161 150 11 116 94 12 101 80 13 136 140 14 146 128 a) Compute MAD for the fifth period, then...
Compute the forecast using exponential smoothing with a smoothing constant of 0.15 and a forecast for Week 1 of 20,000. What is the MAD? Week Miles 1 21,000 2 25,000 3 24,000 4 26,000 5 22,000 6 25,000 7 24,000 8 24,000 9 22,000 10 24,000 11 23,000 12 24,000 13 23,000 14 22,000 15 24,000
(a) A firm uses simple exponential smoothing with a = 0.1 to forecast demand. The forecast for the week of January 1 was 500 units, whereas actual demand turned out to be 450 units. Determine the forecast demand for the week of January 8. (b) What is the difference between a causal model and a time-series model?
Using exponential smoothing with α = 0.2, if the forecast for Period 5 was 270 and the actual for Period 5 was 250, what is your forecast for Period 6? Round your answer to one decimal place.
Following are the daily sales for pens at Paula’s store. Predict week 6 using the following approaches: 1. Naive 2. 4 period moving average 3. Exponential smoothing using smoothing constant (a)= 0.6 and forecast of time period 3 is 45 Time period 1 2 3 4 5 Sales 45 53 48 46 54
Use Solver to determine the alpha that minimizes the MAD for the exponential smoothing forecast for the data that appear in this table. Use the actual demand of period 1 as the forecast for period 2 and then use the forecasts for periods 2 through 9 to calculate MAD. Period Demand 1 272 2 278 3 269 4 280 5 267 6 258 7 278 8 298 9 286 10 290 0.43 0.36 0.54 0.62
Use Solver to determine the alpha that minimizes the MSE for the exponential smoothing forecast for the data that appear in this table. Use the actual demand of period 1 as the forecast for period 2 and then use the forecasts for periods 2 through 9 to calculate MSE. Period Demand 1 272 2 278 3 269 4 280 5 267 6 258 7 278 8 298 9 286 10 290 0.66 0.39 0.57 0.48