The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 34 2
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 | 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 |
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill