Sales data for two years are as attached. Data are aggregated with two months of sales in each "period".

TOM $3320$ HW$2$ Q$3$ Data.xlsx Download TOM $3320$ HW$2$ Q$3$ Data.xlsx

a$)$ After plotting the data, we can observe that the most appropriate forecasting technique is

$[$ Select $]$

$.$

b$)$ The overall average of demand across all provided periods is

$[$ Select $]$

units.

c$)$ For each period, select the multiplicative seasonal index factor from the dropdown list.

Period Seasonal Factor

Jan$-$Feb

$[$ Select $]$

Mar$-$Apr

$[$ Select $]$

May$-$Jun

$[$ Select $]$

Jul$-$Aug

$[$ Select $]$

Sep$-$Oct

$[$ Select $]$

Nov$-$Dec

$[$ Select $]$

d$)$ The regression line fitting the deseasonalized demand has an intercept of

$[$ Select $]$

and a slope of

$[$ Select $]$

$.$

e$)$ Using the results from the previous parts, what is the forecast including trend and seasonality $($FITS$)$ for each period of the next year?

Period FITS

Jan$-$Feb

$[$ Select $]$

Mar$-$Apr

$[$ Select $]$

May$-$Jun

$[$ Select $]$

Jul$-$Aug

$[$ Select $]$

Sep$-$Oct

$[$ Select $]$

Nov$-$Dec

$[$ Select $]$