BUS 278 WEEK 2 HOME WORK Assignment II
1 Question TCO 3 Using the following information regarding actual sales for Sam- Ski Supplies, calculate the regression (trend) line:
Sales for Sam- Ski Supplies ($000s)
Month First Year Second Year
January 380 400
February 340 360
March 320 330
April 280 290
May 265 270
June 230 235
July 220 230
August 200 205
September 210 220
October 250 270
November 400 450
December 450 502
Question 2. Question : (TCO 3) Using the following information regarding actual sales for Sam- Ski Supplies, project sales for March of Year 3 using simple linear regression:
Sales for Sam- Ski Supplies ($000s)
Month First Year Second Year
January 380 400
February 340 360
March 320 330
April 280 290
May 265 270
June 230 235
July 220 230
August 200 205
September 210 220
October 250 270
November 400 450
December 450 502
Question 3. Question : (TCO 3) Using the following information regarding actual sales for Paradise Pools, calculate the seasonal ratio for June of Year 3:
Sales for Paradise Pools ($000s)
Month First Year Second Year
January 84 84
February 80 82
March 88 98
April 100 120
May 150 160
June 200 210
July 240 250
August 220 215
September 180 195
October 160 165
November 120 130
December 92 100
Question 4. Question : (TCO 3) Using the following information regarding actual sales for Seafood City, calculate the seasonal forecast of sales for Friday of Week 3:
Sales for Seafood City ($)
Day Week 1 Week 2
Monday 1,700 1,800
Tuesday 1,900 2,000
Wednesday 2,100 2,100
Thursday 2,300 2,200
Friday 4,200 4,300
Saturday 4,400 4,600
Sunday 2,100 2,200
Question 5. Question : (TCO 3) The regression statistic that measures the accuracy of regression predictions is the: