Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.

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

Note:-

  • Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism.
  • Answer completely.
  • You will get up vote for sure.
Here are the actual tabulated demands for an item for a nine-month period (January through September). Your supervisor wants to test
two forecasting methods to see which method was better over this period.
MONTH
January
February
March
April
May
June
July
August
September
Month
April
May
June
July
August
September
ACTUAL
199
128
a. Forecast April through September using a three-month moving average.
Note: Round your answers to 2 decimal places.
145
164
155
173
135
133
136
Month
April
May
June
July
August
September
Three-Month
Moving Average
b. Use simple exponential smoothing with an alpha of 0.10 to estimate April through September, using the average of January through
March as the initial forecast for April.
Note: Round your answers to 2 decimal places.
Exponential
Smoothing
Transcribed Image Text:Here are the actual tabulated demands for an item for a nine-month period (January through September). Your supervisor wants to test two forecasting methods to see which method was better over this period. MONTH January February March April May June July August September Month April May June July August September ACTUAL 199 128 a. Forecast April through September using a three-month moving average. Note: Round your answers to 2 decimal places. 145 164 155 173 135 133 136 Month April May June July August September Three-Month Moving Average b. Use simple exponential smoothing with an alpha of 0.10 to estimate April through September, using the average of January through March as the initial forecast for April. Note: Round your answers to 2 decimal places. Exponential Smoothing
c-1. Calculate Mean Absolute Deviation for each method.
Note: Round your answers to 2 decimal places.
Three-month moving average
Exponential smoothing
Mean Absolute
Deviation
c-2. Use Mean Absolute Deviation to decide which method produced the better forecast over the six-month period.
O Exponential smoothing
O Three-month moving average
Transcribed Image Text:c-1. Calculate Mean Absolute Deviation for each method. Note: Round your answers to 2 decimal places. Three-month moving average Exponential smoothing Mean Absolute Deviation c-2. Use Mean Absolute Deviation to decide which method produced the better forecast over the six-month period. O Exponential smoothing O Three-month moving average
Expert Solution
steps

Step by step

Solved in 4 steps with 6 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.