a. A manufacturing firm manufactures electric motors. The sales during the last four months (starting from the first month) has been: 96, 75, 89, and 68 units. The forecast for the first month was 80 units. Using the exponential smoothing method with a = .70, predict the next month's sales. Calculate the mean absolute percent deviation for this data and comment on the performance of the forecasting method. b. Using the rule lot size=multiple of 50, determine the planned order releases for each week in the following MRP record. The lead time is 2 weeks.
a. A manufacturing firm manufactures electric motors. The sales during the last four months (starting from the first month) has been: 96, 75, 89, and 68 units. The forecast for the first month was 80 units. Using the exponential smoothing method with a = .70, predict the next month's sales. Calculate the mean absolute percent deviation for this data and comment on the performance of the forecasting method. b. Using the rule lot size=multiple of 50, determine the planned order releases for each week in the following MRP record. The lead time is 2 weeks.
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter13: Regression And Forecasting Models
Section13.6: Moving Averages Models
Problem 22P: The file P13_22.xlsx contains total monthly U.S. retail sales data. While holding out the final six...
Related questions
Question
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 2 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,
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing