Question: 100 points total. Show work for partial credit. Use this table to answer the following. Use a linear regression forecast and a double exponential smoothing
100 points total. Show work for partial credit.
- Use this table to answer the following. Use a linear regression forecast and a double exponential smoothing forecast (alpha = 0.3, beta = 0.6, F(1) = 250, T(1) = 0). (6+6 = 12)
| Period | Demand | LR Forecast | DES Forecast | F(t) | T(t) |
| 1 | 260 |
|
|
|
|
| 2 | 255 |
|
|
|
|
| 3 | 273 |
|
|
|
|
| 4 | 260 |
|
|
|
|
| 5 | 259 |
|
|
|
|
| 6 | 283 |
|
|
|
|
| 7 | 286 |
|
|
|
|
| 8 | 271 |
|
|
|
|
| 9 | 299 |
|
|
|
|
| 10 | 307 |
|
|
|
|
| 11 | 303 |
|
|
|
|
| 12 | 296 |
|
|
|
|
| 13 | 295 |
|
|
|
|
| 14 | 315 |
|
|
|
|
| 15 | 326 |
|
|
|
|
| 16 | 332 |
|
|
|
|
| 17 | 337 |
|
|
|
|
| 18 | 345 |
|
|
|
|
| 19 | 323 |
|
|
|
|
| 20 | 335 |
|
|
|
|
| 21 | 320 |
|
|
|
|
| 22 | 315 |
|
|
|
|
| 23 | 322 |
|
|
|
|
| 24 | 312 |
|
|
|
|
| 25 |
|
|
|
|
|
- Calculate the Mean Forecast Error for the 24 periods. (2)
MFE(LR) = _________, MFE(DES) = _________
- Calculate the Mean Absolute Deviation for the 24 periods. (2)
MAD(LR) = _________, MAD(DES) = _________
- Calculate the Mean Absolute Percent Error for the 24 periods. (2)
MAPE(LR) = _________, MAPE(DES) = _________
- Which forecast is better? (1) Why? (1)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
