Question: The quarterly sales for a specific educational software over the past five years are given in the following table. Year 1 Year 2 Year 3
The quarterly sales for a specific educational software over the past five years are given in the following table.
|
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
| Quarter 1 | 1710 | 1820 | 1830 | 1870 |
|
| Quarter 2 |
| 910 | 1090 | 1120 | 1180 |
| Quarter 3 | 2720 |
| 2900 |
| 2980 |
| Quarter 4 | 2430 | 2200 | 2590 | 2710 | 2820 |
| Year Total |
|
|
|
|
|
0. Fill in the blank spaces with your own data
a. Forecast the total annual demand for Year 6, using past annual sales. Use 2-year Moving Average
b. Forecast the total annual demand for Year 6, using past annual sales. Use Single Exponential Smoothing with =0.5 You can make an educated guess for F0 if you need to.
c. Using MAD or MSE, decide which of the above methods will give a more accurate forecast for the total annual demand.
d. Compute the four seasonal factors and then forecast the demand for each quarter of Year 6.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
