4.2 2 3. 4 6. 7 8. 6. 10 11 YEAR 1 7 9. 9. 13 8. 12 13 6. 11 7 DEMAND a) Plot the above data on a graph. Do you observe any trend, cycles, or random variations? b) Starting in year 4 and going to year 12, forecast demand using a 3-year moving average. Plot your forecast on the same graph as the original data. 08.0 5sVI bns III

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

Hi, 

could you help solve 4.2 a b c & d. Thanks 

9.
-0,800
= .9014
Thus, r = (.9014)² = ,8125, meaning that about 81% of the
variability in sales can be explained by the regression model
with advertising as the independent variable.
101 basmab yhoheu
SOTAED bHOBTEWe
20
red with POM for Windows and/or Excel OM.
b) Use a 3-week weighted moving average, with weights of .1, .3,
and .6, using .6 for the most recent week. Forecast demand for
the week of October 12.
pe B
c) Compute the forecast for the week of October 12 using exponential
smoothing with a forecast for August 31 of 360 and = .2. Px
4.2
YEAR
8.
13
11
10
11
1.
2.
3.
4.
5.
9.
DEMAND
5.
6.
8.
12
6.
6.
a) Plot the above data on a graph. Do you observe any trend,
cycles, or random variations?
b) Starting in year 4 and going to year 12, forecast demand using
a 3-year moving average. Plot your forecast on the same graph
as the original data.
86
ga
Transcribed Image Text:9. -0,800 = .9014 Thus, r = (.9014)² = ,8125, meaning that about 81% of the variability in sales can be explained by the regression model with advertising as the independent variable. 101 basmab yhoheu SOTAED bHOBTEWe 20 red with POM for Windows and/or Excel OM. b) Use a 3-week weighted moving average, with weights of .1, .3, and .6, using .6 for the most recent week. Forecast demand for the week of October 12. pe B c) Compute the forecast for the week of October 12 using exponential smoothing with a forecast for August 31 of 360 and = .2. Px 4.2 YEAR 8. 13 11 10 11 1. 2. 3. 4. 5. 9. DEMAND 5. 6. 8. 12 6. 6. a) Plot the above data on a graph. Do you observe any trend, cycles, or random variations? b) Starting in year 4 and going to year 12, forecast demand using a 3-year moving average. Plot your forecast on the same graph as the original data. 86 ga
The is the purchase
c) Why might this be an forecasting method for
b) If the 45 in be
cast was 42 A of .2 is used.
a Starting in year to year 12, forecast demand using
a 3-year moving average with weights of .1, .3, and .6, using 6
for the most recent year. Plot this forecast on the same graph.
4 and going
using
a) Plc
b) Fo
d) As you compare forecasts with the original data, which seems to
give the better results?X (MyLab Operations Management
also includes a shorter (brief) version of this problem.)
• 4.3
Refer to Problem 4.2. Develop a forecast for years 2
through 12 using exponential smoothing with oa = .4 and a fore-
cast for year 1 of 6. Plot your new forecast on a graph with the
actual data and the naive forecast. Based on a visual inspection,
which forecast is better? P
%3D
A check-processing center uses exponential smooth-
ng to forecast the number of incoming checks each month. The
number of checks received in June was 40 million, while the fore-
4.4
Cast was 42 million. A smoothing constant of .2 is used.
a) What is the forecast for July?
wny might this be an inappropriate forecasting method for
this situation? PX
the forecast for August?
UTLarbondale Hospital is considering the purchase
vill rest partly on the antici-
ven during the
Transcribed Image Text:The is the purchase c) Why might this be an forecasting method for b) If the 45 in be cast was 42 A of .2 is used. a Starting in year to year 12, forecast demand using a 3-year moving average with weights of .1, .3, and .6, using 6 for the most recent year. Plot this forecast on the same graph. 4 and going using a) Plc b) Fo d) As you compare forecasts with the original data, which seems to give the better results?X (MyLab Operations Management also includes a shorter (brief) version of this problem.) • 4.3 Refer to Problem 4.2. Develop a forecast for years 2 through 12 using exponential smoothing with oa = .4 and a fore- cast for year 1 of 6. Plot your new forecast on a graph with the actual data and the naive forecast. Based on a visual inspection, which forecast is better? P %3D A check-processing center uses exponential smooth- ng to forecast the number of incoming checks each month. The number of checks received in June was 40 million, while the fore- 4.4 Cast was 42 million. A smoothing constant of .2 is used. a) What is the forecast for July? wny might this be an inappropriate forecasting method for this situation? PX the forecast for August? UTLarbondale Hospital is considering the purchase vill rest partly on the antici- ven during the
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 3 images

Blurred answer
Similar 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.