2.
Freight car loadings over an 18-week period at a busy port areas follows:
| Week | Number | Week | Number | Week | Number |
| 1 | 410 | 7 | 460 | 13 | 540 |
| 2 | 420 | 8 | 480 | 14 | 550 |
| 3 | 430 | 9 | 500 | 15 | 570 |
| 4 | 420 | 10 | 490 | 16 | 580 |
| 5 | 430 | 11 | 510 | 17 | 590 |
| 6 | 440 | 12 | 530 | 18 | 600 |
a. Determine a linear trend line for expected freight carloadings. (Round your intermediate calculations and finalanswers to 2 decimal places.)
YˆY^ = __ + __ t
b. Use the above trend equation to predictexpected loadings for Weeks 20 & 21. (Round your finalanswers to 2 decimal places.)
The forecasted demand for Week 20 is andfor Week 21 is .
c. The manager intends to install new equipmentwhen the volume exceeds 990 loadings per week. Assuming the currenttrend continues, in which week (at the earliest) should the loadingvolume reach that level? (Use the rounded answers, asrequired, from any previous part of this problem. Do not round anyother intermediate calculations. Round your final answer to 2decimal places.)
It should reach 990 loadings in Week .