a. Compute MAD for each set of forecasts. Given your results, which forecast appears to be more accurate? (Round your answers to 2 decimal places.) MAD F1 MAD F2 Answer is complete and correct. 5.00 4.38

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...
icon
Related questions
Question
100%
10:48
Done
Chapter 3 Assignment i
Help Save & Exit Submit
Check my work mode: This shows what is correct or incorrect for the work you have
completed so far. It does not indicate completion.
14
1.66
points
Mc
Graw
Hill
<
Period
1
ezto.mheducation.com AA
used to forecast demand for cases of bottled water. Actual
demand and the two sets of forecasts are as follows:
2
3
4
5
6
7
8
F2
Demand
68
75
70
74
69
72
80
78
MAD F1
MAD F2
Click here for the Excel Data File
PREDICTED DEMAND
F1
F2
62
64
66
62
71
70
67
73
73
76
79
79
80
67
73
77
a. Compute MAD for each set of forecasts. Given your
results, which forecast appears to be more accurate?
(Round your answers to 2 decimal places.)
MSE F1
MSE F2
Saved
✔Answer is complete and correct.
5.00✔
4.38✔
✔Answer is complete and correct.
appears to be more accurate.
b. Compute the MSE for each set of forecasts. Given your
results, which forecast appears to be more accurate?
(Round your answers to 2 decimal places.)
✔Answer is complete and correct.
36.86✔✔
41.29✔
< Prev
Return to question
14 of 15
Next >
P
Transcribed Image Text:10:48 Done Chapter 3 Assignment i Help Save & Exit Submit Check my work mode: This shows what is correct or incorrect for the work you have completed so far. It does not indicate completion. 14 1.66 points Mc Graw Hill < Period 1 ezto.mheducation.com AA used to forecast demand for cases of bottled water. Actual demand and the two sets of forecasts are as follows: 2 3 4 5 6 7 8 F2 Demand 68 75 70 74 69 72 80 78 MAD F1 MAD F2 Click here for the Excel Data File PREDICTED DEMAND F1 F2 62 64 66 62 71 70 67 73 73 76 79 79 80 67 73 77 a. Compute MAD for each set of forecasts. Given your results, which forecast appears to be more accurate? (Round your answers to 2 decimal places.) MSE F1 MSE F2 Saved ✔Answer is complete and correct. 5.00✔ 4.38✔ ✔Answer is complete and correct. appears to be more accurate. b. Compute the MSE for each set of forecasts. Given your results, which forecast appears to be more accurate? (Round your answers to 2 decimal places.) ✔Answer is complete and correct. 36.86✔✔ 41.29✔ < Prev Return to question 14 of 15 Next > P
Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
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
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
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…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.