5.
It is between 1.1 and 1.2
The calculated values are shown below
Year 1 | Year 2 | Year 3 | ||
Day 1 | 13578 | 14471 | 15421 | |
Day 2 | 21659 | 21630 | 21124 | |
Day 3 | 20051 | 20558 | 20367 | |
Day 4 | 12035 | 12820 | 13315 | |
Day 5 | 12264 | 12924 | 12077 | |
Day 6 | 13139 | 13875 | 13818 | |
Day 7 | 18754 | 18801 | 19491 | |
Day 8 | 21670 | 22213 | 22366 | |
Day 9 | 24637 | 25331 | 25299 | |
Day 10 | 23003 | 23152 | 23656 | |
Average | 18079 | 18577.5 | 18693.4 | |
Index | Year 1 | Year 2 | Year 3 | Avg Index |
Day 1 | 0.751037 | 0.778953 | 0.824944 | 0.784978 |
Day 2 | 1.19802 | 1.164312 | 1.130025 | 1.164119 |
Day 3 | 1.109077 | 1.106607 | 1.089529 | 1.101738 |
Day 4 | 0.665689 | 0.690082 | 0.712283 | 0.689352 |
Day 5 | 0.678356 | 0.69568 | 0.646057 | 0.673364 |
Day 6 | 0.726755 | 0.746871 | 0.739191 | 0.737606 |
Day 7 | 1.037336 | 1.012031 | 1.042667 | 1.030678 |
Day 8 | 1.198628 | 1.195694 | 1.196465 | 1.196929 |
Day 9 | 1.362741 | 1.363531 | 1.353365 | 1.359879 |
Day 10 | 1.27236 | 1.246239 | 1.265473 | 1.261357 |
7.
The best technique is weighted moving average as their CFE is the least.
The calculated values are shown below. The total CFE is the last value (highlighted in yellow).
Month | Mistakes | Exp | SMA | WMA | CFE(Exp) | CFE(SMA) | CFE(WMA) |
1 | 121 | ||||||
2 | 125 | 121 | |||||
3 | 119 | 122.2 | |||||
4 | 118 | 121.2 | 121.7 | 120.7 | -3.2 | -3.7 | -2.7 |
5 | 125 | 120.3 | 120 | 119 | 1.5 | 1.3 | 3.3 |
6 | 130 | 121.7 | 120.7 | 122.7 | 9.8 | 10.6 | 10.6 |
7 | 126 | 124.2 | 124.3 | 127.6 | 11.6 | 12.3 | 9 |
8 | 108 | 124.7 | 127 | 126.9 | -5.1 | -6.7 | -9.9 |
9 | 133 | 119.7 | 121.3 | 114.7 | 8.2 | 5 | 8.4 |
10 | 134 | 123.7 | 122.3 | 126.1 | 18.5 | 16.7 | 16.3 |
CFE | CFE | CFE |
8.
Correct answer is 12.7
The calculated values are shown below.
Day | Demand | 3MA | AD |
1 | 1042 | ||
2 | 1042 | ||
3 | 1044 | ||
4 | 1029 | 1042.667 | 13.66667 |
5 | 1025 | 1038.333 | 13.33333 |
6 | 1050 | 1032.667 | 17.33333 |
7 | 1069 | 1034.667 | 34.33333 |
8 | 1048 | 1048 | 0 |
9 | 1063 | 1055.667 | 7.333333 |
10 | 1057 | 1060 | 3 |
12.71429 | |||
MAD |
QUESTION 5 A carnival runs for 10 days a year. Attendance for each day in each of the past three years has been captured and is provided in the table below. sing the multiplicative seasonal met...
Please answer each question and highlight each answer or the table. Starbucks has a Isrge, global supply chain that must eficienty supply over 17,000 stores. Although the stores might appesr to be very similse, they are actualy very difierent. Depending on the locaion of the store, its size, and the prolile of the oustomers served, Starbucks management oonfigures the store offerings to take maimum advantage of the space available and customer preferenoes. Starbucks' actual distribution system is much more complex,...