A retail store records customer demand during each sales period. The data has been collected in the Microsoft Excel Online file below. Use the Microsoft Excel Online file below to develon three ceried four-period moving average forecasts and answer the following questions. X Open spreadsheet Questions 1. What is the forecast for the 13th period based on the three-period moving average? Round your answer to two decimal places. 2. What is the MSE for the three-period moving average? Round your answer to two decimal places. 3. Choose the correct graph for the three-period moving average forecast. The correct graph i graph A graph B 100- graph C Three-Period Moving Average Forecaat graph D 95 90 A. 85- 804 Time Period 10 11 12 13 14 Observation Three-Period Moving Average Forecaat 100- Next
A retail store records customer demand during each sales period. The data has been collected in the Microsoft Excel Online file below. Use the Microsoft Excel Online file below to develon three ceried four-period moving average forecasts and answer the following questions. X Open spreadsheet Questions 1. What is the forecast for the 13th period based on the three-period moving average? Round your answer to two decimal places. 2. What is the MSE for the three-period moving average? Round your answer to two decimal places. 3. Choose the correct graph for the three-period moving average forecast. The correct graph i graph A graph B 100- graph C Three-Period Moving Average Forecaat graph D 95 90 A. 85- 804 Time Period 10 11 12 13 14 Observation Three-Period Moving Average Forecaat 100- Next
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
Related questions
Question
I could use a hand with this
![M
O YouTube
9 Maps
Operations Manag. O
B Apps
Gmail
P Search (Option + Q)
Excel template - Saved v
Insert
Draw
Page Layout
Formulas
Data
Review
View
Help
O Editing v
File
Home
v 10 v
Ev ab
2$
Arial
B
A V ..
E
Merge v
Number
E Conditional Formatting
.00
0
D9
fx
A
B
D.
H
I
M
P
Q
R.
5.
1 Moving Average Forecasting
2.
3 Periods in moving average
Use the area below to draw a line chart for the three-period moving average.
3
4.
Time Demand Forecast
Period
Eror 2
Error
Formulas
6.
90
92
3.
87
* #N/A
F
V #N/A
9
10
4
88
#N/A
#N/A
#N/A
#N/A
NIA
F NN/A
11
83
#N/A
#N/A
89
#N/A
#N/A
12
#N/A
#N/A
FNIA
FENIA
FENIA
F NN/A #N/A
13
8
92
#N/A
#N/A
F ANIA
14
9
95
#N/A
15
10
91
#N/A
11
#N/A
#N/A
87
96
16
17
12
#N/A
18
Next period forecast:
13
#N/A
19
MSE
N/A
20
21
22
23
Jse the area below to draw a line chart for the four-period moving average.
24 Periods in moving average
25
4
Time
Demand Forecast
Error Error"2
Period
26
27
28
1
90
2
92
29
3
87
88
84
83
89
30
4
#N/A
BN/A
FaN/A
FNIA
31
#N/A
#N/A
32
#N/A
33
#NIA
#N/A
92
INIA
#N/A
ENA
34
35
36
9
95
#N/A
NIA
#N/A
#N/A
FEN/A
10
91
#N/A
UNIA
NIA
#N/A
37
11
87
#N/A
38
12
96
#N/A
#N/A
39
Next period forecast:
13
#N/A
40
MSE
IN/A
41
42
Which moving average is best?
43
#N/A
44
45
46
A Sheeti
+
Calculation Mode: Automatic Workbook Statistics
80
DII
DD
esc
F1
F2
F3
F4
F5
F7
*
!
#
$
&
1
3
4
6.
8
Q
W
E
R
Y
tab
A
S
G
K
caps lock
C
V
B
N
M.
shift](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F0b0ab463-4d4c-475b-97de-464c7d60d430%2Fe3e058f8-fc1f-4105-900b-0240f42747f4%2Fhnbackl_processed.jpeg&w=3840&q=75)
Transcribed Image Text:M
O YouTube
9 Maps
Operations Manag. O
B Apps
Gmail
P Search (Option + Q)
Excel template - Saved v
Insert
Draw
Page Layout
Formulas
Data
Review
View
Help
O Editing v
File
Home
v 10 v
Ev ab
2$
Arial
B
A V ..
E
Merge v
Number
E Conditional Formatting
.00
0
D9
fx
A
B
D.
H
I
M
P
Q
R.
5.
1 Moving Average Forecasting
2.
3 Periods in moving average
Use the area below to draw a line chart for the three-period moving average.
3
4.
Time Demand Forecast
Period
Eror 2
Error
Formulas
6.
90
92
3.
87
* #N/A
F
V #N/A
9
10
4
88
#N/A
#N/A
#N/A
#N/A
NIA
F NN/A
11
83
#N/A
#N/A
89
#N/A
#N/A
12
#N/A
#N/A
FNIA
FENIA
FENIA
F NN/A #N/A
13
8
92
#N/A
#N/A
F ANIA
14
9
95
#N/A
15
10
91
#N/A
11
#N/A
#N/A
87
96
16
17
12
#N/A
18
Next period forecast:
13
#N/A
19
MSE
N/A
20
21
22
23
Jse the area below to draw a line chart for the four-period moving average.
24 Periods in moving average
25
4
Time
Demand Forecast
Error Error"2
Period
26
27
28
1
90
2
92
29
3
87
88
84
83
89
30
4
#N/A
BN/A
FaN/A
FNIA
31
#N/A
#N/A
32
#N/A
33
#NIA
#N/A
92
INIA
#N/A
ENA
34
35
36
9
95
#N/A
NIA
#N/A
#N/A
FEN/A
10
91
#N/A
UNIA
NIA
#N/A
37
11
87
#N/A
38
12
96
#N/A
#N/A
39
Next period forecast:
13
#N/A
40
MSE
IN/A
41
42
Which moving average is best?
43
#N/A
44
45
46
A Sheeti
+
Calculation Mode: Automatic Workbook Statistics
80
DII
DD
esc
F1
F2
F3
F4
F5
F7
*
!
#
$
&
1
3
4
6.
8
Q
W
E
R
Y
tab
A
S
G
K
caps lock
C
V
B
N
M.
shift
![MINDTAP
Activity: Moving Average
A retail store records customer demand during each sales period. The data has been collected in the Microsoft Excel Online file below. Use the Microsoft Excel Online file below to develop three-period and
four-period moving average forecasts and answer the following questions.
X
Open spreadsheet
Questions
1. What is the forecast for the 13th period based on the three-period moving average? Round your answer to two decimal places.
2. What is the MSE for the three-period moving average? Round your answer to two decimal places.
3. Choose the correct graph for the three-period moving average forecast.
The correct graph
graph A
graph B
graph C
Three-Period Moving Average Forecast
100-
graph D
95
90-
85
80
Time Period
11
12 13 14
10
Three-Period Moving Average Forecast
100
Observation
-
Next
Back
DII
80
F7
F8
F9
F10
F11
F12
F2
F3
F4
F6
F1
(@
23
$
&
8
9
delete
%3D
2
3
4
{
Q
W
E
Y
P
A
S
F
G
H
J
K
re
>
C
V
N
M
command
option
command](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F0b0ab463-4d4c-475b-97de-464c7d60d430%2Fe3e058f8-fc1f-4105-900b-0240f42747f4%2Flsbs7x7_processed.jpeg&w=3840&q=75)
Transcribed Image Text:MINDTAP
Activity: Moving Average
A retail store records customer demand during each sales period. The data has been collected in the Microsoft Excel Online file below. Use the Microsoft Excel Online file below to develop three-period and
four-period moving average forecasts and answer the following questions.
X
Open spreadsheet
Questions
1. What is the forecast for the 13th period based on the three-period moving average? Round your answer to two decimal places.
2. What is the MSE for the three-period moving average? Round your answer to two decimal places.
3. Choose the correct graph for the three-period moving average forecast.
The correct graph
graph A
graph B
graph C
Three-Period Moving Average Forecast
100-
graph D
95
90-
85
80
Time Period
11
12 13 14
10
Three-Period Moving Average Forecast
100
Observation
-
Next
Back
DII
80
F7
F8
F9
F10
F11
F12
F2
F3
F4
F6
F1
(@
23
$
&
8
9
delete
%3D
2
3
4
{
Q
W
E
Y
P
A
S
F
G
H
J
K
re
>
C
V
N
M
command
option
command
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 5 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
![Operations Management](https://www.bartleby.com/isbn_cover_images/9781259667473/9781259667473_smallCoverImage.gif)
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
![Operations and Supply Chain Management (Mcgraw-hi…](https://www.bartleby.com/isbn_cover_images/9781259666100/9781259666100_smallCoverImage.gif)
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
![Operations Management](https://www.bartleby.com/isbn_cover_images/9781259667473/9781259667473_smallCoverImage.gif)
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
![Operations and Supply Chain Management (Mcgraw-hi…](https://www.bartleby.com/isbn_cover_images/9781259666100/9781259666100_smallCoverImage.gif)
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
![Business in Action](https://www.bartleby.com/isbn_cover_images/9780135198100/9780135198100_smallCoverImage.gif)
![Purchasing and Supply Chain Management](https://www.bartleby.com/isbn_cover_images/9781285869681/9781285869681_smallCoverImage.gif)
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
![Production and Operations Analysis, Seventh Editi…](https://www.bartleby.com/isbn_cover_images/9781478623069/9781478623069_smallCoverImage.gif)
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.