Question: the top part us correct need help with part b. Cannister, Inc., specializes in the manufacture of plastic containers. E Click the icon to view

the top part us correct need help with part b.
the top part us correct need help with part b.
Cannister, Inc., specializes in the manufacture of plastic containers. E Click the icon to view the data on the monthly sales of 10-ounce shampoo bottles for the past five years. a. Using the multiplicative seasonal method, calculate the monthly seasonal indices. (Enter your responses rounded to three decimal places.) Month Average seasonal index January 0.719 February 0.765 March 0.767 April 0.895 May 1.092 June 1.195 July 1.261 August 1.171 September 1.164 October 1.254 November 0.922 December 0.796 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 = 0.46 + 1147.31 X. (Enter your responses rounded to one decimal place.) Cannister, Inc., specializes in the manufacture of plastic containers. E Click the icon to view the data on the monthly sales of 10-ounce shampoo bottles for the past five years. a. Using the multiplicative seasonal method, calculate the monthly seasonal indices. (Enter your responses rounded to three decimal places.) Month Average seasonal index January 0.719 February 0.765 March 0.767 April 0.895 May 1.092 June 1.195 July 1.261 August 1.171 September 1.164 October 1.254 November 0.922 December 0.796 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 = 0.46 + 1147.31 X. (Enter your responses rounded to one decimal place.)

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!