Question: Question 9 . A company would like to develop a short - term forecasting model for its retail operations and is focusing on the exponential

Question 9. A company would like to develop a short-term forecasting model for its retail operations and is focusing on the exponential smoothing and moving average methods. The actual data for the last six periods for an operation are: (see image)
9a)(4 points) Implement Exponential Smoothing with alpha=1//2 and forecast the number of units for Week
What is the forecast for week 7?
9b)(2 points) What is the MAD for this method?
9c)(4 points) implement a 3-Period Moving Average and forecast the number of units for Week 7. What is the forecast for week 7?
9d)(2 points) What is the MAD for this method?
9e)(3 points) Which of these methods performs better for the company? (1 point) Why? (2 points)
9f)(4 points) Using the MA(3) forecast, if the company wanted to achieve a 90% service level, how much should they order for week 7?
Z value: 0.00.4330.6751.041.281.652.32
Probability: 50%66.7%75%85%90%95%99%
Question 9 . A company would like to develop a

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!