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 |