Use the data file $A3Q2.xlsxto$ answer this question. United Dairies, Inc., supplies milk $to$

several independent grocers. Managers $at$ United Dairies want $to$ develop a forecast $of$ the

number $of$ half gallons $of$ milk sold per week.

$a.$ Construct a time series plot. What type $of$ pattern exists $in$ the data?

$b.$ Use exponential smoothing with $=0\mathrm{.}65to$ develop a forecast $of$ demand for week $17.$

What $is$ the resulting MAPE?

$c.$ Use a moving average with $k=2to$ develop a forecast $of$ demand for week $17.$ What

$is$ the resulting MAPE?

$d.$ Using the above forecasting techniques, what $is$ the forecasts for the next time period?