Problem The quarterly sales data (number of copies sold) for a college textbook over the past...

Transcribed Image Text:

Problem The quarterly sales data (number of copies sold) for a college textbook over the past three years are shown. Quarter year 1 Year 2 Year 3 Total 1 1690 1800 1850 5340 2 940 900 1100 2940 3 2625 2900 2930 8455 4 2500 2360 2615 7475 Total 7755 7960 8495 e) Suppose we want predict quarterly sales using Holt's Method using the previous one year data. What is the forecast sales for year 4 quarter 1? Use = 0.35, p = 0.25. Suppose the actual sales for year 4 quarter 1 turns out to be 1750. What is the forecast for quarter 2? (5+5 = 10 marks) Suppose we want to use Trend Projection Method to make forecast for each season. Using the entire 3 year data, determine the forecast for quarter 1 and quarter 2 of year 4. Use Excel Regression Tool to solve this problem. Make a printout of your Excel Output to include with the assignment. (5 marks) Problem The quarterly sales data (number of copies sold) for a college textbook over the past three years are shown. Quarter year 1 Year 2 Year 3 Total 1 1690 1800 1850 5340 2 940 900 1100 2940 3 2625 2900 2930 8455 4 2500 2360 2615 7475 Total 7755 7960 8495 e) Suppose we want predict quarterly sales using Holt's Method using the previous one year data. What is the forecast sales for year 4 quarter 1? Use = 0.35, p = 0.25. Suppose the actual sales for year 4 quarter 1 turns out to be 1750. What is the forecast for quarter 2? (5+5 = 10 marks) Suppose we want to use Trend Projection Method to make forecast for each season. Using the entire 3 year data, determine the forecast for quarter 1 and quarter 2 of year 4. Use Excel Regression Tool to solve this problem. Make a printout of your Excel Output to include with the assignment. (5 marks)