The weekly demand (in cases) for a particular brand of automatic dishwasher detergent for a chain of grocery stores located in Columbus, Ohio, follows. Week Demand O 1 2 3 4 5 30- 6 7 8 9 10 25+ 20 15- 10+ 5+ 0+ 22 0 18 23 21 17 24 20 (a) Construct a time series plot. 19 18 21 1 2 3 4 5 6 7 8 Week What type of pattern exists in the data? O The time series plot indicates a seasonal pattern. O The time series plot indicates a horizontal pattern. O The time series plot indicates a trend pattern. The time series plot indicates a cyclical pattern. cases 9 10 cases 30 T 25 20 15- 10+ 5+ 0 0 1 2 3 4 5 6 7 8 9 10 Week (b) Use a three-week moving average to develop a forecast (in cases) for week 11. (Round your answer to two decimal places.) O 30 25 20 15- 10+ 5+ 0 0 1 2 3 4 5 6 7 8 9 10 Week (c) Use exponential smoothing with a smoothing constant of a 0.3 to develop a forecast (in cases) for week 11. (Round your answer to two decimal places.) 20- F 15- 10+ 0- 01 23 4 5 30T 25+ 5- 6 7 8 9 10 Week
The weekly demand (in cases) for a particular brand of automatic dishwasher detergent for a chain of grocery stores located in Columbus, Ohio, follows. Week Demand O 1 2 3 4 5 30- 6 7 8 9 10 25+ 20 15- 10+ 5+ 0+ 22 0 18 23 21 17 24 20 (a) Construct a time series plot. 19 18 21 1 2 3 4 5 6 7 8 Week What type of pattern exists in the data? O The time series plot indicates a seasonal pattern. O The time series plot indicates a horizontal pattern. O The time series plot indicates a trend pattern. The time series plot indicates a cyclical pattern. cases 9 10 cases 30 T 25 20 15- 10+ 5+ 0 0 1 2 3 4 5 6 7 8 9 10 Week (b) Use a three-week moving average to develop a forecast (in cases) for week 11. (Round your answer to two decimal places.) O 30 25 20 15- 10+ 5+ 0 0 1 2 3 4 5 6 7 8 9 10 Week (c) Use exponential smoothing with a smoothing constant of a 0.3 to develop a forecast (in cases) for week 11. (Round your answer to two decimal places.) 20- F 15- 10+ 0- 01 23 4 5 30T 25+ 5- 6 7 8 9 10 Week
Functions and Change: A Modeling Approach to College Algebra (MindTap Course List)
6th Edition
ISBN:9781337111348
Author:Bruce Crauder, Benny Evans, Alan Noell
Publisher:Bruce Crauder, Benny Evans, Alan Noell
Chapter5: A Survey Of Other Common Functions
Section5.3: Modeling Data With Power Functions
Problem 6E: Urban Travel Times Population of cities and driving times are related, as shown in the accompanying...
Related questions
Question
100%
Transcribed Image Text:The weekly demand (in cases) for a particular brand of automatic dishwasher detergent for a chain of grocery stores located in Columbus, Ohio, follows.
O
Week
Demand (in cases)
30
25
20
15
1
0
2
3
10-
5
4
5
6
7
8
9
10
Demand
22
0 1 2
18
23
(a) Construct a time series plot.
21
17
24
20
8
19
18
21
3 4 5
6
Week
What type of pattern exists in the data?
cases
7 8 9 10
The time series plot indicates a seasonal pattern.
O The time series plot indicates a horizontal pattern.
O The time series plot indicates a trend pattern.
O The time series plot indicates a cyclical pattern.
cases
30-
25
20
15+
10-
5
0 +
0 1 2 3 4
5
Week
6
7
8
(b) Use a three-week moving average to develop a forecast (in cases) for week 11. (Round your answer to two decimal places.)
F11 =
9 10
30
25
20+
15
10+
5+
0
+
0 1 2
3 4 5 6
6 7 8 9 10
Week
(c) Use exponential smoothing with a smoothing constant of a = 0.3 to develop a forecast (in cases) for week 11. (Round your answer to two decimal places.)
F11 =
Demand (in cases)
301
25
20
15-
10+
5+
0
+
01
2
3 4 5 6 7 8 9 10
Week
Ⓡ
Transcribed Image Text:(b) Use a three-week moving average to develop a forecast (in cases) for week 11. (Round your answer to two decimal places.)
F11
=
cases
(c) Use exponential smoothing with a smoothing constant of a = 0.3 to develop a forecast (in cases) for week 11. (Round your answer to two decimal places.)
F11
cases
=
(d) Which of the two methods do you prefer? Why?
O The 3-week moving average is preferable since it has a larger MSE compared to exponential smoothing with a = 0.3.
Exponential smoothing with a = 0.3 is preferable since it has a smaller MSE compared to the 3-week moving average.
Exponential smoothing with a = 0.3 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.3.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 5 steps with 1 images
Recommended textbooks for you
Functions and Change: A Modeling Approach to Coll…
Algebra
ISBN:
9781337111348
Author:
Bruce Crauder, Benny Evans, Alan Noell
Publisher:
Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
Functions and Change: A Modeling Approach to Coll…
Algebra
ISBN:
9781337111348
Author:
Bruce Crauder, Benny Evans, Alan Noell
Publisher:
Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
Trigonometry (MindTap Course List)
Trigonometry
ISBN:
9781337278461
Author:
Ron Larson
Publisher:
Cengage Learning
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL