Use the description below for the next THREE questions:

A local restaurant has recorded the demand for bottled water in each of the last $15$ months of business. Use the recorded demand data below to develop three$-$period and four$-$period moving$-$average forecasts for bottles of water.

Round off all calculations to two decimal places. Maintaining two decimal places is required for all calculations.

$\backslash$table$[[$Per$$od$,$Demand,Period,Demand,Period,Demand$],[1,795,6,910,11,835],[2,890,7,915,12,875],[3,925,8,780,13,855],[4,980,9,900,14,920],[5,850,10,805,15,780]]$

Data in the above table can be found in the $\text{'}$MA$\_$Data' worksheet of the Homework $1$ Excel file darr.

What is the Mean Absolute Deviation $($MAD$)$ for the four$-$period movingaverage forecast in period $15?$

Less than or equal to $45\mathrm{.}00$

Greater than $45\mathrm{.}00$ but less than or equal to $49\mathrm{.}00$

Greater than $49\mathrm{.}00$ but less than or equal to $53\mathrm{.}00$

Greater than $53\mathrm{.}00$

Question $8$

$0\mathrm{.}5pts$

What is the forecast for period $16$ using the four$-$period moving average method? $($your answer should be rounded off to the nearest whole number$).$

Less than or equal to $855$

Greater than $855$ but less than or equal to $867$

Greater than $867$ but less than or equal to $879$

Greater than $879$

Which forecast is the "best" $($the three$-$period or four$-$period moving average method$)?$ Provide a justification for your answer in terms of measures of forecast accuracy AND bias.

Edit View Insert Format Tools Table

$12$ pt $vv$ Paragraph $vv|B,$I,$A_{v}v{U}_{v}v{T}^{2}vv|vdots$