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
Get step-by-step solutions from verified subject matter experts
