State which forecast is best on the result for a., b., and c. forecasts. Explain your answer.

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

State which forecast is best on the result for a., b., and c. forecasts. Explain your answer.

A
В
F
H.
Forecast
Absolute deviation
Week
Demand"
Naïve
3-week MA 9-week MA
Naïve
3-week MA
9-week MA
3
1
800
4
2
1400
800
600
5
3
1000
1400
400
6
4
1500
1000
1066.667
500
433.33
5
1500
1500
1300.000
200.00
8
6
1300
1500
1333.333
200
33.33
7
1800
1300
1433.333
500
366.67
10
8
1700
1800
1533.333
100
166.67
11
9
1300
1700
1600.000
400
300.00
12
10
1700
1300
600.000
1366.667
400
100.00
333.333
13
11
1500
1700
1566.667
1400
200
66.67
100
14
12
2300
1500
1500.000
1470
800
800.00
830
15
13
2300
2300
1833.333
1560
466.67
740
16
14
2000
2300
2033.333
1690
300
33.33
310
17
15
2000
2000
2200.000
1740
200.00
260
18
16
2100
2000
2100.000
1790
100
0.00
310
19
17
2200
2100
2033.333
1870
100
166.67
330
20
18
2300
2200
2100.000
1910
100
200
390
21
19
2300
2200.000
1970
22
23
Naïve
3-week MA
9-week MA
24
MAD
276.47
235.56
400.37
25
Transcribed Image Text:A В F H. Forecast Absolute deviation Week Demand" Naïve 3-week MA 9-week MA Naïve 3-week MA 9-week MA 3 1 800 4 2 1400 800 600 5 3 1000 1400 400 6 4 1500 1000 1066.667 500 433.33 5 1500 1500 1300.000 200.00 8 6 1300 1500 1333.333 200 33.33 7 1800 1300 1433.333 500 366.67 10 8 1700 1800 1533.333 100 166.67 11 9 1300 1700 1600.000 400 300.00 12 10 1700 1300 600.000 1366.667 400 100.00 333.333 13 11 1500 1700 1566.667 1400 200 66.67 100 14 12 2300 1500 1500.000 1470 800 800.00 830 15 13 2300 2300 1833.333 1560 466.67 740 16 14 2000 2300 2033.333 1690 300 33.33 310 17 15 2000 2000 2200.000 1740 200.00 260 18 16 2100 2000 2100.000 1790 100 0.00 310 19 17 2200 2100 2033.333 1870 100 166.67 330 20 18 2300 2200 2100.000 1910 100 200 390 21 19 2300 2200.000 1970 22 23 Naïve 3-week MA 9-week MA 24 MAD 276.47 235.56 400.37 25
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 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.