Question: Your manager is trying to determine what forecasting method to use. Based upon the following historical data, calculate the following forecast and specify what procedure

Your manager is trying to determine what forecasting method to use. Based upon the following historical data, calculate the following forecast and specify what procedure you would utilize.

MONTH DEMAND
January 59
February 65
March 65
April 67
May 71
June 70
July 77
August 77
September 77
October 75
November 83
December 81

Question 26 (1 point)

Saved

ListenReadSpeaker webReader: Listen

Calculate the simple three-month moving average forecast for April through December. What is the forecast for December? (Round your answer to 2 decimal places)

Question 26 options:

76.33

77.00

78.33

74.67

Question 27 (1 point)

Saved

ListenReadSpeaker webReader: Listen

Calculate the single exponential smoothing forecast for February through December using an initial forecast (F1=F-January) of 63. (Use alpha of 0.2) What is the forecast for December? (Round your answer to 2 decimal places)

Question 27 options:

71.52

72.22

74.37

66.30

Question 28 (1 point)

Saved

ListenReadSpeaker webReader: Listen

Calculate the mean absolute deviation (MAD) for the forecasts made by each technique in April through December. Which forecasting method do you prefer? (Round your answer to 2 decimal places)

Question 28 options:

Exponential smoothing method (alpha=0.2) (3.58)

3-month moving average (6.93)

3-month moving average (4.15)

Exponential smoothing method (alpha=0.2) (4.15)

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!