I am really stuck and need help with figuring this question out or if
you can guide where I can go to get directions, your assistance is
greatly appreciated. I need to have this answered by Monday, April
19th. Thank you.
Here is the question:
"Using the classical decomposition method, calculate the seasonal
ratios from the data, and determine the trend and average levels. Use
these ratios and estimates of trend and level to make a forecast for
the next year."
You will need to use the following chart to calculate the seasonal ratios.
Month Year 1 Demand Year 2 Demand Year 3 Demand Seasonal Ratio
Jan $12,400 $11,800 $13,600 0.8
Feb 23,000 24,111 21,800 1.8
Mar 15,800 16,500 14,900 0.9
Apr 20,500 21,000 19,400 1.6
May 25,100 24,300 26,000 2.0
June 16,200 15,800 16,500 1.0
July 12,000 11,500 12,400 0.7
Aug 10,300 10,100 10,800 0.6
Sept 11,800 11,000 12,500 0.7
Oct 14,000 14,300 13,800 1.2
Nov 10,700 10,900 10,600 0.9
Dec 7,600 7,200 8,100 0.6 |