a$.$ What is the forecast for quarter $6$ using the Bobcat model? Show all your calculations $($do not use $000$s in your calculations, only remember to include them in the final answer$).$ You can use an Excel spreadsheet, in which case the spreadsheet should be submitted as an attachment to email, and the cell formulae should be visible.

Cumulative sales:

Q$1$: $275$

Q$2$: $(275+345)=620$

Q$3$: $(275+345+380)=1000$

Q$4$: $(275+345+380+390)=1390$

Q$5$: $(275+345+380+390)=1740$

Forecast for Q$6$: S$6=340+0\mathrm{.}12(1740)0\mathrm{.}00005^2$

S$6=408\mathrm{.}08$

The forecasted sales for Quarter $6$ are $408,080$ units sold.

b$.$ Was the Bass model able to predict the downturn in sales when it occurred? Explain.