Question: (For Questions 4, 5---use the worksheet Forecasting-2) The table below shows 5-year record of quarterly sales of a discount store Aodi. a Aodi's 4th quarter

(For Questions 4, 5---use the worksheet
(For Questions 4, 5---use the worksheet
(For Questions 4, 5---use the worksheet
(For Questions 4, 5---use the worksheet "Forecasting-2") The table below shows 5-year record of quarterly sales of a discount store Aodi. a Aodi's 4th quarter includes Thanksgiving, Hanukah, Christmas. Year 1 1Q 2Q 3Q 4Q 1Q Year ben 10 2 2Q 3Q 4Q Year 3 1Q 20 3Q 4Q $31,295 $32,167 $32,320 $42,936 $34,512 $35,334 $35,616 $43,496 $34,814 $35,414 $36,008 $45,000 $35,157 $36,000 $36,492 $49,015 $37,005 $38,694 $39,180 $50,646 Year 4 1Q 2Q 3Q Year 5 4Q 1Q 2Q 30 4Q You are hired to make a sales forecast for each quarter in Year 6. As the 4Q includes holiday shopping season and 4Q sales have been much higher than those of other quarters in the last 5 years, you decided to use as a forecasting method. To use the method, you need a forecast of Year 6 total annual sales. You first calculate the annual sales figures for the last 5 years, and see if there is a pattern. The annual sales figures show trend. Using the 5 annual sales data, you decide to establish a linear regression model to forecast Year 6 annual sales. In the linear regression, the independent variable is and the dependent variable is You get the regression equation with a slope Thus you forecast Year 6 annual sales ass thousand

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!