Use a three$-$month moving average to make a forecast for July.

$14\mathrm{.}5.$ For the data in Exercise $14,4,$ use an $$ of $0\mathrm{.}1$ to make a forecast for July.

$14\mathrm{.}6.$ For the data in Exercise $14\mathrm{.}4,$ use an $$ of $0\mathrm{.}1$ and a $$ of $0\mathrm{.}2$ to make a forecast for

July and August. Calculate the MAD for your January through June forecasts.

$14\mathrm{.}7.$ Prepare a spreadsheet model for the Saturday hotel occupancy data in Table $14\mathrm{.}3$

and recalculate the forecasts using an $$ of $0\mathrm{.}3.$ What is the new MAD?

$14\mathrm{.}8.$ Prepare a spreadsheet model for the commuter airline's weekly load factor data in

Table $14\mathrm{.}4,$ and recalculate the forecasts using an $$ of $0\mathrm{.}2$ and a $$ of $0\mathrm{.}2.$ Have yoll

$14\mathrm{.}9.$ improved on the original MAD?

Prepare a spreadsheet model for the ferry passenger data in Table $14\mathrm{.}5,$ and realt

ing the forecasts using an $$ of $0\mathrm{.}3$ and a $$ of $0\mathrm{.}2.$ Has this change in the smo of th

$14\mathrm{.}10.$ Prepareants improved the MAD?

culate the foreadsheet model for the ferry passenger data in Table $14\mathrm{.}6,$ and reat

the smoothing corts using an $$ of $0\mathrm{.}3,$ a $$ of $0\mathrm{.}1,$ and a $$ of $0\mathrm{.}2.$ Has this change in