Question
Use a simple exponential smoothing model (SES) with alpha of .4. The forecast for period 8...
Use a simple exponential smoothing model (SES) with alpha of .4.
The forecast for period 8 is?
|
period |
Y |
|
1 |
50 |
|
2 |
85 |
|
3 |
65 |
|
4 |
90 |
|
5 |
88 |
|
6 |
90 |
|
7 |
110 |
|
8 |
Forecast period 8 =
Homework Answers
Answer #1
| smoothing factor | t | yt | forecast | abs error | error^2 |
| 1 | 50 | #N/A | #N/A | ||
| 0.4 | 2 | 85 | 50.00 | 35.00 | 1225 |
| 3 | 65 | 64.00 | 1.00 | 1 | |
| 4 | 90 | 64.40 | 25.60 | 655.4 | |
| 5 | 88 | 74.64 | 13.36 | 178.5 | |
| 6 | 90 | 79.98 | 10.02 | 100.3 | |
| 7 | 110 | 83.99 | 26.01 | 676.5 | |
| 8 | 94.39 |
Forecast period 8=94.39
Not the answer you're looking for?
Similar Questions
Following are time-series data for ten different periods. Use exponential smoothing to forecast the values for...
Following are time-series data for ten different periods. Use
exponential smoothing to forecast the values for periods 3 through
10. Use the value for the first period as the forecast for the
second period. Compute forecasts using α = 0.8. Compute the MAD and
MSE.
Time period
Value
1
27
2
31
3
58
4
63
5
59
6
66
7
71
8
86
9
101
10
97
For the data given below, forecast period 17 using following methods and suggest the best forecasting...
For the data given below, forecast period 17 using following
methods and suggest the best forecasting model
1. Simple Moving Average (Three Period)
2. Weighted Average (50% on t-1, 30% on t-2, 20% on t-3)
3. Exponential Smoothing (α=.1), F1= y intercept from
regression)
4. Exponential Smoothing (α=.3), F1= y intercept from
regression)
5. Exponential Smoothing with trend (α=.3) and (δ=.3), F1= y
intercept from regression)**
5. Exponential Smoothing with trend (α=.1) and (δ=.3), F1= y
intercept from regression)**
6....
A) Forecast the demand for the next 4 periods using Exponential Constant Smoothing. Demand for 6...
A) Forecast the demand for the next 4 periods using Exponential
Constant Smoothing.
Demand for 6 periods is as follows: Period 1 2 3 4 5 6
Demand 20 22 21 18 19 28
B) Determine the bias
Use exponential smoothing, with alpha=0.2, to calculate the forecasts for percent utilization below. June's forecast was...
Use exponential smoothing, with alpha=0.2, to calculate the
forecasts for percent utilization below. June's forecast was 90%
utilization and actual usage was 94% utilization.
a.
Calculate the forecast of percent utilization for July.
(Round your final answer to 2 decimal places.)
Forecast for July
______percent of utilization
b.
If usage in July was 98 percent, calculate the forecast of
percent utilization for August. (Round your answer to 2
decimal places.)
Forecast for August
_____percent of capacity
Following are time-series data for ten different periods. Use exponential smoothing to forecast the values for...
Following are time-series data for ten different periods. Use
exponential smoothing to forecast the values for periods 3 through
10. Use the value for the first period as the forecast for the
second period. Compute forecasts using α = 0.1. Compute the MAD and
MSE.
Time period
Value
1
27
2
31
3
58
4
63
5
59
6
66
7
71
8
86
9
101
10
97
Group of answer choices
A) MAD=296.6, MSE=1266.5
B) MAD=296.6 , MSE=11398.5
C)...
Following are time-series data for ten different periods. Use exponential smoothing to forecast the values for...
Following are time-series data for ten different periods. Use
exponential smoothing to forecast the values for periods 3 through
10. Use the value for the first period as the forecast for the
second period. Compute forecasts using α = 0.8. Compute the MAD and
MSE.
Time period
Value
1
27
2
31
3
58
4
63
5
59
6
66
7
71
8
86
9
101
10
97
Group of answer choices
a) MAD=9.7, MSE=1585.6
b) MAD=9.7, MSE=176.2
c) MAD=10.2,...
1.)In exponential smoothing forecast, forecasted sale for period 2 is given by αY1 + (1 –...
1.)In exponential smoothing forecast, forecasted sale for period
2 is given by αY1 + (1 – α) F1......True or FAlse
2.) In exponential smoothing, your goal is to find the α that
minimizes mean squared error... True or false
In Excel, create forecasts for periods 6-13 using each of the following methods: 5 period simple...
In Excel, create forecasts for periods 6-13 using each of the
following methods: 5 period simple moving average; 4 period
weighted moving average (0.63, 0.26, 0.08, 0.03); exponential
smoothing (alpha = 0.23 and the forecast for period 5 = 53); linear
regression with the equation based on all 12 periods; and quadratic
regression with the equation based on all 12
periods. Round all numerical answers to two
decimal places.
The actual values for 12 periods (shown in order) are:
(1) 45 (2)...
Using ? = 0.5 and the following data, compute exponential smoothing forecasts for periods 2 through...
Using ? = 0.5 and the following data, compute exponential
smoothing forecasts for periods 2 through 8. (Round your
intermediate calculations and final answers to 2 decimal places.)
Period: 1 2 3 4 5 6 7 Forecast: 10 Actual demand: 12 15 11 13 11 11
10
Create the following forecasts: a 4-period moving average forecast, an exponential smoothing forecast with alpha=0.2, and...
Create the following forecasts:
a 4-period moving average
forecast,
an exponential smoothing forecast
with alpha=0.2,
and a linear trend forecast for your
data.
Calculate the MSE and MAPE for each.
Plot the original series, and each of the forecasts.
Create forecasts for 2017 Q1, 2017 Q2, 2017 Q3 and 2017 Q4 using
each of these three techniques. If you had to choose one of these,
which would you choose and why?
Given your data, and this time period, would you...
ADVERTISEMENT
Need Online Homework Help?
Get Answers For Free
Most questions answered within 1 hours.
ADVERTISEMENT
Active Questions
asked 28 minutes ago
asked 54 minutes ago
asked 54 minutes ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago