Weekday. Students 1 92 2 73 3 119 4 124 5 81 6 127 7 121 8 128 9 141 10 125 11 107 12 94 13 131 14 166 15 206 16 158 17 153 18 119 19 78 20 31 21 24 22 67 23 72 24 110 25 58 26 80 27 57 28 32 29 72 30 39 31 53 32 92 33 114 34 106 35 133 36 128 37 107 38 157 39 169 40 183 Food trucks have become a common sight on American campuses. They serve scores of hungry students strolling through campus and looking for trendy food served fast. The accompanying data file contains the number of students served on weekdays on a small campus in California. Click here for the Excel Data File a. Use the 3-period moving average to make a forecast for Weekday 41. Note: Do not round intermediate calculations. Round final answer to 2 decimal places. 941= b. Use the 5-period moving average to make a forecast for Weekday 41. Note: Do not round intermediate calculations. Round final answer to 2 decimal places. ŷ41 = c-1. Report the performance measures for the techniques in parts a and b. Note: Do not round intermediate calculations. Round final answers to 2 decimal places. Technique MSE 3-period moving average 5-period moving average MAD MAPE (%) c-2. Which is the preferred technique for making the forecast? because it has the out of 3 performance measures
Weekday. Students 1 92 2 73 3 119 4 124 5 81 6 127 7 121 8 128 9 141 10 125 11 107 12 94 13 131 14 166 15 206 16 158 17 153 18 119 19 78 20 31 21 24 22 67 23 72 24 110 25 58 26 80 27 57 28 32 29 72 30 39 31 53 32 92 33 114 34 106 35 133 36 128 37 107 38 157 39 169 40 183 Food trucks have become a common sight on American campuses. They serve scores of hungry students strolling through campus and looking for trendy food served fast. The accompanying data file contains the number of students served on weekdays on a small campus in California. Click here for the Excel Data File a. Use the 3-period moving average to make a forecast for Weekday 41. Note: Do not round intermediate calculations. Round final answer to 2 decimal places. 941= b. Use the 5-period moving average to make a forecast for Weekday 41. Note: Do not round intermediate calculations. Round final answer to 2 decimal places. ŷ41 = c-1. Report the performance measures for the techniques in parts a and b. Note: Do not round intermediate calculations. Round final answers to 2 decimal places. Technique MSE 3-period moving average 5-period moving average MAD MAPE (%) c-2. Which is the preferred technique for making the forecast? because it has the out of 3 performance measures
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
Transcribed Image Text:Weekday.
Students
1
92
2
73
3
119
4
124
5
81
6
127
7
121
8
128
9
141
10
125
11
107
12
94
13
131
14
166
15
206
16
158
17
153
18
119
19
78
20
31
21
24
22
67
23
72
24
110
25
58
26
80
27
57
28
32
29
72
30
39
31
53
32
92
33
114
34
106
35
133
36
128
37
107
38
157
39
169
40
183
Transcribed Image Text:Food trucks have become a common sight on American campuses. They serve scores of hungry students strolling through campus
and looking for trendy food served fast. The accompanying data file contains the number of students served on weekdays on a small
campus in California.
Click here for the Excel Data File
a. Use the 3-period moving average to make a forecast for Weekday 41.
Note: Do not round intermediate calculations. Round final answer to 2 decimal places.
941=
b. Use the 5-period moving average to make a forecast for Weekday 41.
Note: Do not round intermediate calculations. Round final answer to 2 decimal places.
ŷ41 =
c-1. Report the performance measures for the techniques in parts a and b.
Note: Do not round intermediate calculations. Round final answers to 2 decimal places.
Technique
MSE
3-period moving average
5-period moving average
MAD
MAPE (%)
c-2. Which is the preferred technique for making the forecast?
because it has the
out of 3 performance measures
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 2 steps
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
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
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
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…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.