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.
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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
