1. (TCO 3) Using the following information regarding actual sales for Sam’s Ski Supplies, calculate the regression (trend) line:
Sales for Sam’s 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 |
2. (TCO 3) Using the following information regarding actual sales for Sam’s Ski Supplies, project sales for March of Year 3 using simple linear regression:
Sales for Sam’s 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 |
3 |
301.7308 |
3. (TCO 3) Using the following information regarding actual sales for Seafood City, calculate the seasonal ratio for Saturday 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 |
4. (TCO 3) Using the following information regarding actual sales for Paradise Pools, calculate the seasonal forecast of sales for April 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 |