Cannister, Inc. specializes in the manufacture of plastic containers. The data on the monthly sales of 10-ounce shampoo bottles for the past five years are as follows:

a. Using the multiplicative seasonal method, calculate the monthly seasonal indices.
b. Develop a simple linear regression equation to forecast annual sales. For this regression, the dependent variable, V is the demand in each year and the independent variable. X is the index for the year (i.e. X = 1 for year 1, X =2 for year 2. and so on until X 5 for year 5).
c. Forecast the annual sales for year 6 by using the regression model you developed in part (b).
d. Prepare the seasonal forecast for each month by using the monthly seasonal indices calculated in part(a).

Transcribed Image Text:

Year 2 742 741 896 9511030 697 700 793 861,032 776 774 85 38 126 898 932 1055 1,109 1,285 1.030 1099 1,204 1,274 1,468 1107 223 1,326 42 1637 1,165 1,290 1,303 1486 1611 1,216 1349 1,436 1,555 1,608 September1.208 1,341 1473 1,604 1,528 Dctober1131 1296 1,453 1,600 1,420 November 971 1,066 1170 1,403 1,119 783 90 1023 1,209 1,013 January March April May Juily August December