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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!