The manager of the I-85 Carpet outlet needs to be able toforecast accurately the demand for Soft Shag carpet (its biggest seller). If the manager does not order enough car-pet from the carpet mill, customers will buy their carpets from one of the outlets many competitors. The managerhas collected the following demand data for the past eightmonths. a. Compute a three-month moving average forecast formonths 4 through 9. b. Compute a weighted three-month moving average fore-cast for months 4 through 9. Assign weights of 0.55, 0.33, and 0.12 to the months in sequence, starting withthe most recent month.c. Compare the two forecasts using MAD. Which forecastappears to be more accurate? Month Demand for Soft Shag Carpet (1000 yd)1 52 103 64 85 146 107 98 12
The manager of the I-85 Carpet outlet needs to be able toforecast accurately the demand for Soft Shag carpet (its biggest seller). If the manager does not order enough car-pet from the carpet mill, customers will buy their carpets from one of the outlets many competitors. The managerhas collected the following demand data for the past eightmonths. a. Compute a three-month moving average forecast formonths 4 through 9. b. Compute a weighted three-month moving average fore-cast for months 4 through 9. Assign weights of 0.55, 0.33, and 0.12 to the months in sequence, starting withthe most recent month.c. Compare the two forecasts using MAD. Which forecastappears to be more accurate? Month Demand for Soft Shag Carpet (1000 yd)1 52 103 64 85 146 107 98 12
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
The manager of the I-85 Carpet outlet needs to be able to
biggest seller). If the manager does not order enough car-
pet from the carpet mill, customers will buy their carpets
from one of the outlets many competitors. The manager
has collected the following demand data for the past eight
months.
a. Compute a three-month moving average forecast for
months 4 through 9.
b. Compute a weighted three-month moving average fore-
cast for months 4 through 9. Assign weights of 0.55,
0.33, and 0.12 to the months in sequence, starting with
the most recent month.
c. Compare the two forecasts using MAD. Which forecast
appears to be more accurate?
Month Demand for Soft Shag Carpet (1000 yd)
1 5
2 10
3 6
4 8
5 14
6 10
7 9
8 12
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 4 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.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.