Question
The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 34 2 37 3 38 4 37 5 40 6
The following table contains the demand from the last 10 months:
MONTH | ACTUAL DEMAND |
1 | 34 |
2 | 37 |
3 | 38 |
4 | 37 |
5 | 40 |
6 | 37 |
7 | 42 |
8 | 44 |
9 | 41 |
10 | 42 |
a. Calculate the single exponential smoothing forecast for these data using an ? of 0.20 and an initial forecast (F1) of 34. (Round your intermediate calculations and answers to 2 decimal places.)
Month | Exponential Smoothing |
1 | |
2 | |
3 | |
4 | |
5 | |
6 | |
7 | |
8 | |
9 | |
10 | |
b. Calculate the exponential smoothing with trend forecast for these data using an ? of 0.20, a ? of 0.30, an initial trend forecast (T1) of 1.00, and an initial exponentially smoothed forecast (F1) of 33. (Round your intermediate calculations and answers to 2 decimal places.)
Month | FITt |
1 | |
2 | |
3 | |
4 | |
5 | |
6 | |
7 | |
8 | |
9 | |
10 | |
c-1. Calculate the mean absolute deviation (MAD) for the last nine months of forecasts. (Round your intermediate calculations and answers to 2 decimal places.)
MAD | |
Single exponential smoothing forecast? | |
Exponential smoothing with trend forecast? | |
c-2. Which is best?
Single exponential smoothing forecast | |
Exponential smoothing with trend forecast |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
The detailed answer for the above question is provided below Calculating Exponential Smoothing Forec...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started