Using the same data, forecast demand using exponential smoothing. You are given an initial forecast for year $1,$ quarter $1$ of $17\mathrm{.}0.$ When generating your forecasts, assume that the smoothing coefficient is $0\mathrm{.}10.$

Note: Leave no cells blank $-$ be certain to enter $"0"$ wherever required. Negative answers should be indicated by a minus sign. Round your forecast answers to $1$ decimal place. Then, starting with quarter $1$ of year $2,$ use these rounded forecast values to compute the error and absolute error answers. Enter those answers to $1$ decimal place also.

Show less

YearQuarterDemandExponential SmoothingErrorAbsolute Value ErrorYear $1$Q$117$Q$219$Q$318$Q$420$Year $2$Q$12417\mathrm{.}6$Q$22618\mathrm{.}3$Q$32619\mathrm{.}1$Q$42919\mathrm{.}7$Year $3$Q$129$Q$232$Q$334$Q$433$Year $4$Q$133$Q$236$Q$339$Q$442$Year $5$Q$145$Q$245$Q$347$Q$447$Year $6$Q$148$Q$247$Q$350$Q$453$Year $7$Q$154$Q$253$Q$355$Q$458$Year $8$Q$158$Q$262$Q$365$Q$468$MFEMAD