Problem $3-7($Algo$)$

Freight car loadings over an $18-$week period at a busy port are as follows:

Week Number

$1360$

$2375$

$3390$

$4375$

$5390$

$6400$

$7430$

$8450$

$9470$

$10455$

$11475$

$12495$

$13505$

$14515$

$15545$

$16560$

$17575$

$18590$

Click here for the Excel Data File

Determine a linear trend line for expected freight car loadings.

Note: Round your intermediate calculations and final answers to $2$ decimal places.

Use the above trend equation to predict expected loadings for Weeks $20$ & $21.$

Note: Round your final answers to $2$ decimal places.

The manager intends to install new equipment when the volume exceeds $940$ loadings per week. Assuming the current trend continues, in which week $($at the earliest$)$ should the loading volume reach that level?

Note: Use the rounded answers, as required, from any previous part of this problem. Do not round any other intermediate calculations. Round your final answer to $2$ decimal places.