Question: Use the following data for problems 27 - 30 Month Sales Jan 48 Feb 62 Mar 75 Apr 68 May 77 June Using a two-month
Use the following data for problems 27 - 30
| Month | Sales | |||||
| Jan | 48 | |||||
| Feb | 62 | |||||
| Mar | 75 | |||||
| Apr | 68 | |||||
| May | 77 | |||||
| June |
- Using a two-month moving average, what is the forecast for June?
- 37.5
- 71.5
- 72.5
- 68.5
- Using a two-month weighted moving average, compute a forecast for June with weights of 0.4, and 0.6 (oldest data to newest data, respectively).
- 37.8
- 69.8
- 72.5
- 73.4
- Using exponential smoothing, with an alpha value of 0.2 and assuming the forecast for Jan is 46, what is the forecast for June?
- 61.2
- 57.3
- 36.1
- 32.4
- What is the MAD value for the two-month moving average?
- 8.67
- 9.12
- 10.30
- 12.36
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
