please do year 6 forecast

wwe e seasonal method, calculate the monthly seasonal indices. (Enter your responses roun'ed to three decin Month Average seasonal index ore Info Year January February March April May June 1 821 628 723 854 1,014 1,062 1,067 1.289 1.155 1.162 1,040 824 2 820 631 721 888 1,083 1,178 1.192 1,422 1.288 1,327 1,135 942 3 975 724 832 1,011 1.188 1,281 1,205 1,509 1,420 1,484 1,239 1,064 4 1,030 792 885 1,065 1,258 1,377 1,388 1,628 1,551 1,631 1,472 1.250 5 1,109 963 1,073 1,241 1,452 1.592 1,513 1,681 1,475 1,451 1,188 1,054 July August September October November December Print Done in the edit fields and then click Check Answer g Clear All w Focus O u Petsch Homy 53 FU FT & % 5 4 6 7 8 9 Csak the conta www the data on the monthly sales of 10-cunde shampoo bottles for the past five years. sing the multiplicative seasonal method, calculate the monthly seasonal indices (Enter your responses rounded to three decam places) Average seasonal index Month January February March April May June July August September October November December 0.823 0.647 0.733 0.876 1.038 1.124 1.102 1.303 1.193 1.221 1,052 0.889 b. Develop a simple linear regression equation to forecast annual sales. For this regression, the depondent variable, Y, ist demand in each year and the Independent variable, X. In the index for the year (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 = 10561.6 100.6 X. (Enter your responses rounded to ono decimal place) C. Forecast the eles for year 6 by using the regression mode you developed in part be The forecast of unul sales for your bis 171652 bottles (Enter your response rounded to the powest whole number) Enter your answer in the edit fields and then click Check Answer All parts showing Clear All Check Alter re search O PLE Prisen Home Erd 3 5 6 7 8 9 0 E R. Y U 0 F G H . K 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 17165.2 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 parta and the forecast of annual sales for year 6 calculated in partc. (Enter your responses rounded to the nearest whole numbers.) 1 821 6 (forecast) Year January February March April May June July August September October November December 628 723 854 1,014 1,062 1,067 2 820 631 721 888 1,083 1,178 1.192 1,422 1.288 1,327 1,135 942 Sales 3 4 975 1.030 724 792 832 885 1,011 1,065 1,188 1.258 1,281 1,377 1.205 1,388 1,509 1,628 1,420 1,551 1,484 1,631 1.239 1.472 1.064 1.250 5 1,109 963 1,073 1,241 1,452 1,592 1,513 1,681 1,475 1.451 1,188 1,054 1.155 1,162 1,040 824 Enter your answer in the edit fields and then click Check Answer All parts showing Clear All Check Answe w Ad dish (United States focus earch O RE * Presen Home End &