Question: Below is an attachment containing data. These data reflect the number of shipments leaving a distribution center per week. Use these data to answer the
Below is an attachment containing data. These data reflect the number of shipments leaving a distribution center per week. Use these data to answer the following questions.
1. What is the 4-period simple moving average forecast for week 53?
2. What is the exponential smoothing forecast for week 53 with alpha=1?
3.What is the exponential smoothing forecast for week 53 using alpha=0?
| Period | ACTUAL Demand | |
| 1 | 635 | |
| 2 | 740 | |
| 3 | 835 | |
| 4 | 926 | |
| 5 | 1004 | |
| 6 | 1074 | |
| 7 | 1125 | |
| 8 | 1196 | |
| 9 | 1257 | |
| 10 | 1338 | |
| 11 | 1404 | |
| 12 | 1461 | |
| 13 | 1531 | |
| 14 | 1609 | |
| 15 | 1659 | |
| 16 | 1741 | |
| 17 | 1807 | |
| 18 | 1863 | |
| 19 | 1925 | |
| 20 | 1997 | |
| 21 | 2066 | |
| 22 | 2127 | |
| 23 | 2185 | |
| 24 | 2263 | |
| 25 | 2330 | |
| 26 | 2252 | |
| 27 | 2398 | |
| 28 | 2533 | |
| 29 | 2598 | |
| 30 | 2670 | |
| 31 | 2727 | |
| 32 | 2890 | |
| 33 | 2844 | |
| 34 | 2925 | |
| 35 | 3002 | |
| 36 | 3054 | |
| 37 | 3134 | |
| 38 | 3200 | |
| 39 | 3257 | |
| 40 | 3335 | |
| 41 | 3391 | |
| 42 | 3467 | |
| 43 | 3533 | |
| 44 | 3575 | |
| 45 | 3662 | |
| 46 | 3734 | |
| 47 | 3791 | |
| 48 | 3861 | |
| 49 | 3877 | |
| 50 | 3977 | |
| 51 | 3971 | |
| 52 | 3824 | |
| 53 | 3824 | |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
