1. (TCO 3) Using the following information regarding actual sales
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 |
(Points : 4) y = 264.92 + 2.79x
y = 264.92 + 1.67x
y = 283.64 + 2.79x
y = 283.64 + 1.67x
| Question 2. 2. (TCO 3) Using the following information regarding actual sales for Paradise Pools, project sales for May of Year 3 using simple linear regression: Sales for Paradise Pools ($000s)MonthFirst YearSecond YearJanuary8484February8082March8898April100120May150160June200210July240250August220215September180195October160165November120130December92100(Points : 4)168.79 174.52 178.35 180.26 |
| Question 3. 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 ($)DayWeek 1Week 2Monday1,7001,800Tuesday1,9002,000Wednesday2,1002,100Thursday2,3002,200Friday4,2004,300Saturday4,4004,600Sunday2,1002,200(Points : 4)0.84 0.95 1.58 1.70 |
| Question 4. 4. (TCO 3) Using the following information regarding actual sales for Sam’s Ski Supplies, calculate the seasonal forecast of sales for November of Year 3: Sales for Sam’s Ski Supplies ($000s)MonthFirst YearSecond YearJanuary380400February340360March320330April280290May265270June230235July220230August200205September210220October250270November400450December450502(Points : 4)400 450 465 521 |
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"
