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

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!