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
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...
Related questions
Question
Hi,
could you help solve 4.2 a b c & d. Thanks

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

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

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 4 steps with 3 images

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.