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. Do not round any values until your final answer.
| 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 |
a. What is the 5-period weighted moving average, with weights of 20, 10, 5, 2.5, and 1 (weights listed with most recent period first).
b. What is the exponential smoothing forecast for week 53 with alpha=1?
c. What is the exponential smoothing forecast for week 53 using alpha=0
d. What is the exponential smoothing forecast for week 53 using alpha = 0.8
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
