Problem $3-27($Static$)$

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

$a.$ find a line using regression in Excel.

b$.$ find the trend and seasonal indexes.

Forecast sales for next year. $4$ periods

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