- Cannister Inc Specializes In The Manufacture Of Plastic Containers Click The Icon To View The Data On The Monthly Sa 1 (40.36 KiB) Viewed 23 times
b. Develop a simple linear regression equation to forecast annual sales. For this regression, the dependent variable, Y, 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). The regression is given by the equation Y=+X (Enter your responses rounded to one decimal place.) c. Forecast the annual sales for year 6 by using the regression model you developed in part b. The forecast of annual sales for year 6 is bottles (Enter your response rounded to the nearest whole number.) d. Prepare the seasonal forecast for each month by using the monthly seasonal indices calculated in part a and the forecast of annual sales for year 6 calculated in part c. (Enter your responses rounded to the nearest whole numbers.) c. 6 (forecast) Year January February March April May June July August September October November December 1 813 666 869 851 932 1,111 1,083 1,316 1,263 1,052 901 857 2 3 812 967 669 762 867 978 885 1,008 1,001 1,106 1,227 1,330 1,208 1,221 1,449 1,536 1,396 1,528 1,217 1,374 996 1,100 975 1,097 Sales 4 1,022 830 1,031 1,062 1,176 1,426 1,404 1,655 1,659 1,521 1,333 1,283 5 1,101 1,001 1,219 1,238 1,370 1,641 1,529 1,708 1,583 1,341 1,049 1,087
Year January February March April May June July August September October November December 1 813 666 869 851 932 1,111 1,083 1,316 1,263 1,052 901 857 2 812 669 867 885 1,001 1,227 1,208 1,449 1,396 1,217 996 975 3 967 762 978 1,008 1,106 1,330 1,221 1,536 1,528 1,374 1,100 1,097 4 1,022 830 1,031 1,062 1,176 1,426 1,404 1,655 1,659 1,521 1,333 1,283 5 1,101 1,001 1,219 1,238 1,370 1,641 1,529 1,708 1,583 1,341 1,049 1,087