Problem $18-27($Algo$)$

Tucson Machinery, Incorporated manufactures numerically controlled machines, which sell for an average price of $\backslash (\backslash$$ $0\mathrm{.}5\backslash )$ million each. Sales for these NCMs for the past two years were as follows: Use Exhibit $18\mathrm{.}10.$

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

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

Answer is complete but not entirely correct.

b$.$ Compute trend and seasonal factor from a linear regression line obtained with Excel. Note: Do not round intermediate calculations. Round your answers to $3$ decimal places. c$.$ Forecast sales for next year using the above seasonal factors.

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

$\backslash$begin$\{$tabular$\}\{|$l$|$c$|$l$|\}$

$\backslash$hline & Period & Forecast $($Units$)\backslash \backslash$

$\backslash$hline Next Year & $9$ & $\backslash \backslash$

$\backslash$hline & $10$ & $\backslash \backslash$

$\backslash$hline & $11$ & $\backslash \backslash$

$\backslash$hline & $12$ & $\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$