- 1 10 Points Details Aswsbe14 17 E 041 0 2 Submissions Used Ask Your Teacher Practice Another My Notes Datafile Di 1 (69.34 KiB) Viewed 34 times
1. [-/10 Points] DETAILS ASWSBE14 17.E.041. 0/2 Submissions Used ASK YOUR TEACHER PRACTICE ANOTHER MY NOTES DATAfile: Dishwasher The weekly demand (in cases) for a particular brand of automatic dishwasher detergent for a chain of grocery stores located in Columbus, Ohio, follows. Demand (in cases) p Demand (in cases) Week Demand 22 O 30 1 5 2 0 3 4 20 15 5 10 10 6 7 8 25+ 20+ 15+ 9 10- (a) Construct a time series plot. 30 T 25 0 1 18 2 23 21 17 24 20 19 18 21 3 5 01 4 + + 0 1 2 3 4 5 + 4 6 7 8 9 10 cases Week + 4 5 6 7 8 Week What type of pattern exists in the data? 4 E + 9 10 The time series plot indicates a seasonal pattem. The time series plct indicates a trend pattern. The time series plct indicates a horizontal pattern. The time series plot indicates a cyclical pattern. O @O Demand (in emand (in cases) 30 25- 20 15- 10- 5 0- 30- 25 20 15 10 01 1 2 3 4 5- 0 4 0 1 1 2 3 5 6 Week 7 8 9 10 B I 4 + 4 I 4 4 5 6 7 8 9 10 Week G 7 (b) Usu a three-week moving average to develop a forecast (in cases) for week 11. (Round your answer to two decimal places.) cases F₁ = 19:33 (c) Use exponential smoothing with a smoothing constant of a 0.6 to develop a forecast (in cases) for week 11. (Round your answer to two decimal places.) F11 = (d) Which of the two methods de you prefer? Why? O Exponential smoothing with a = 0.5 is preferable since it has a smaller MSE compered to the 3-week moving average. O The 3-week moving average is preferable since it has a larger MSE compared to exponential smoothing with a = 0.6. Exponential smoothing with a = 0.6 is preferable since it has a larger MSE compared to the 3-week moving average. O The 3-week moving average is preferable since it has a smaller MSE compared to exponential smoothing with a 0.6.