Saved Help Save & Ex Topic 6 Assignment i Chec Analytics Exercise 18-1 (Algo) Starbucks has a large, global supply chain that must efficiently supply over 17,000 stores. Although the stores might appear to be very 3 similar, they are actually very different. Depending on the location of the store, its size, and the profile of the customers served, points Starbucks management configures the store offerings to take maximum advantage of the space available and customer preferences Starbucks' actual distribution system is much more complex, but for the purpose of our exercise let's focus on a single item that is eBook currently distributed through five distribution centers in the United States. Our item is a logo-branded coffeemaker that is sold at some Print of the larger retail stores. The coffeemaker has been a steady seller over the years due to its reliability and rugged construction. Starbucks does not consider this a seasonal product, but there is some variability in demand. Demand for the product over the past 13 References' weeks is shown in the following table. (week -1 is the week before week 1 in the table, -2 is two weeks before week 1, etc.). Management would like you to experiment with some forecasting models to determine what should be used in a new system to be implemented. The new system is programmed to use one of two forecasting models: simple moving average or exponential smoothing. 7 8 9 10 11 12 13 -4 -1 1 55 41 WEEK 2 3 32 54 34 33 45 35 54 26 20 45 36 25 Atlanta 42 35 40 45 46 60 45 32 45 52 47 Boston 60 26 48 41 33 34 24 96 35 44 Chicago 54 22 68 42 44 48 68 46 50 62 68 50 40 35 42 42 36 38 62 45 46 38 52 48 Dallas 38 34 LA 42 53 43 182 210 243 267 246 206 25 255 172 230 9 242 194 Total 241 161 239 170 184 Pre of 10 Next > MC 9 tly cloudyTopic 6 Assignment i Saved Help Save a. Consider using a simple moving average model. Experiment with models using five weeks' and three weeks' past data. (Round your answers to 2 decimal places.) 3-week MA 3 points Week ATL BOS CHI DAL LA Total e Book 2 Print 3 References' 8 10 12 13 Mc Graw re of 10 Next 89.F U 9 Mostly cloudy5-week MA BOS DAL Total 3 points eBook Print References IN Mc Graw Prev 1 of 10 Next > Hill M13 oints b. Evaluate the forecasts that would have been made over the 13 weeks using the overall (at the end of the 13 weeks) mean absolute deviation, mean absolute percent error, and tracking signal as criteria, (Negative values should be indicated by a minus sign. Round eBook all answers to 2 decimal places. Enter "MAPE" answers as a percentage rounded to 2 decimal places.) Print ATL BOS CHI DAL LA Avg of DCs References 3-week MA MAD MAPE TS 5-week MA MAD MAPE TS Prev 1 of 10 Next > Search b pCheck my work mode : This shows what is correct or incorrect for the work you have completed so far. It does not indicate completion. Return to qu 1 b. Evaluate the forecasts that would have been made over the 13 weeks using the overall (at the end of the 13 weeks) mean absolute deviation, mean absolute percent error, and tracking signal as criteria. (Negative values should be indicated by a minus sign. Round all answers to 2 decimal places. Enter "MAPE" answers as a percentage rounded to 2 decimal places.) Ints x Answer is complete but not entirely correct. ATL BOS CHI DAL LA Avg of DCs 3-week MA MAD 11.59 8.44 19.23 12.21 7.33 11.76 MAPE 29.78 (X 19.90 X 41.25 x 27.31 x 16.30 x 26.91 X TS 0.20 x 1.34 X (0.59) 0.22 X 0.41 x 5-week MA MAD 11.15 8.75 18.06 13.38 7.37 11.74 MAPE 28.66 (X 20.65 X 38.75 ( 29.95 X 16.38 x 26.88 x TS 0.25) (X 1.23 X 0.09 (0.30) 0.68 X aw Prey 1 of 10 Next > DELL Ox prtsc home end F1 F2 F3 F4 F5 F6 F7 F8 F9 F10 F11 F12Atlanta Boston Chicago Dallas LA Avg of DCs 3-week M. MAD 11.59 8.44 19.23 12.21 7.33 11.76 MAPE 33.35 22.58 46.13 30.20 16.77 29.80 TS 0.46 1.94 0.35 1.37 1.82 0.50 2 5-week M. MAD 11.15 8.75 18.06 13.38 7.37 11.74 MAPE 31.45 22.93 43.83 31.48 16.67 29.27 TS 0.41 2.31 0.47 1.26 1.55 0.70