c) What is the MSE? 4.16 Refer to Solved Problem 4.1 on page 144. a) Using the trend-projection (regression) method, develop a fore- cast for the sales of Volkswagen Beetles in Nevada through year 6. b) What is the MAD? PX c) What is the MSE? hlom 4 1 on page 144. Using smooth-

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

Please help solve 4.16 a b & c. Thanks

MOITUJOS
Problems
Note: PY means the problem may be solved with PO
Problems 4.1–4.42 relate to Time-Series Forecasting
4.1
The following gives the number of pints of type B
blood used at Woodlawn Hospital in the past 6 weeks:
WEEK OF
PINTS USED
August 318
20360 a
Pecent
and the
September 7
389
September 14
410
forecast the
September 21
ontli 381
moy
September 28
368
October 5
374
a) Forecast the demand for the week of October 12 using a
3-week moving average.
Transcribed Image Text:MOITUJOS Problems Note: PY means the problem may be solved with PO Problems 4.1–4.42 relate to Time-Series Forecasting 4.1 The following gives the number of pints of type B blood used at Woodlawn Hospital in the past 6 weeks: WEEK OF PINTS USED August 318 20360 a Pecent and the September 7 389 September 14 410 forecast the September 21 ontli 381 moy September 28 368 October 5 374 a) Forecast the demand for the week of October 12 using a 3-week moving average.
46
Following are two weekly forecasts
hods for the number of gallons of gasoline, in thou.
hods for the of of in thou-
anded at a local station. Also are
Refer to 4.1 on page 144.
Following are two forecasts:
illustration
B = .4, we fo
lations for m
the process f
In this pi
FORECASTS
METHOD 2
ACTUAL DEMAND
to 0.70
F, T, and
1.00
4.22
exponentia
and 9. Co
1.20
00 0
4.
What are the MAD and MSE for each mo
00
those in T
• 4.15
.• 4.23
in Carbo
Refer to Solved Problem 4.1 on page 144.
a) Use a 3-year moving average to forecast the sales of
Volkswagen Beetles in Nevada through year 6.
b) What is the MAD? PX
c) What is the MSE?
preparec
ing and
May, ar
4.16
00
Refer to Solved Problem 4.1 on page 144.
a) Using the trend-projection (regression) method, develop a fore-
cast for the sales of Volkswagen Beetles in Nevada throuigh year 6.
b) What is the MAD? PX
c) What is the MSE?
4.17
Refer to Solved Problem 4.1 on page 144. Using smooth-
ing constants of .6 and .9, develop forecasts for the sales of VW
Beetles. What effect did the smoothing constant have on the forecast?
Use MAD to determine which of the three smoothing constants (.3,
.6, or .9) gives the most accurate forecast. PX (MyLab Operations
Management also includes a shorter (brief) version of this problem.)
...• 4.18 Consider the following actual (A) and forecast (F)
demand levels for a commercial multiline telephone at Office Max.
TIME
PERIOD, t
ACTUAL
DEMAND, A,
FORECAST
DEMAND, F,
50ols no 50
b)
2.
42
woll!
(c)
3.
48
4.
Transcribed Image Text:46 Following are two weekly forecasts hods for the number of gallons of gasoline, in thou. hods for the of of in thou- anded at a local station. Also are Refer to 4.1 on page 144. Following are two forecasts: illustration B = .4, we fo lations for m the process f In this pi FORECASTS METHOD 2 ACTUAL DEMAND to 0.70 F, T, and 1.00 4.22 exponentia and 9. Co 1.20 00 0 4. What are the MAD and MSE for each mo 00 those in T • 4.15 .• 4.23 in Carbo Refer to Solved Problem 4.1 on page 144. a) Use a 3-year moving average to forecast the sales of Volkswagen Beetles in Nevada through year 6. b) What is the MAD? PX c) What is the MSE? preparec ing and May, ar 4.16 00 Refer to Solved Problem 4.1 on page 144. a) Using the trend-projection (regression) method, develop a fore- cast for the sales of Volkswagen Beetles in Nevada throuigh year 6. b) What is the MAD? PX c) What is the MSE? 4.17 Refer to Solved Problem 4.1 on page 144. Using smooth- ing constants of .6 and .9, develop forecasts for the sales of VW Beetles. What effect did the smoothing constant have on the forecast? Use MAD to determine which of the three smoothing constants (.3, .6, or .9) gives the most accurate forecast. PX (MyLab Operations Management also includes a shorter (brief) version of this problem.) ...• 4.18 Consider the following actual (A) and forecast (F) demand levels for a commercial multiline telephone at Office Max. TIME PERIOD, t ACTUAL DEMAND, A, FORECAST DEMAND, F, 50ols no 50 b) 2. 42 woll! (c) 3. 48 4.
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
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.