Problem $3-27($Algo$)$

Tucson Machinery, Incorporated, manufactures numerically controlled machines, which sell for an average price of $$16\mathrm{.}0$ million each.

Sales for these NCMs for the past two years were as follows: Use Exhibit $3\mathrm{.}10.$

a$.$ Find the equation of a simple linear regression line using Excel.

Note: Round your answers to $3$ decimal places.

$=,|+Z,t$

b$.$ Compute trend and seasonal factor from a linear regression line obtained with Excel.

Note: Do not round Intermedlate caleulations. Round your answers to $3$ decimal places.

c$.$ Forecast sales for next year using the above seasonal factors.

Note: Do not round Intermedlate calculations. Round your answers to $2$ decimal places.