Sheet Deliverables:

In cell range D$3$:D$1045,$ insert a formula that will calculate the Exponential Smoothing forecast for each day. Ensure you cell reference the alpha $()$ that is located in II$.$

In cell range E$2$:E$1045,$ to start calculating MAD, insert a formula that will calculate the deviation of the forecast away from the actual daily demand.

In cell range F$2$:F$1045,$ to continue calculating MAD, insert a function that will calculate the absolute value of the deviations you calculated in column $E.$

In $14,$ to finish calculating MAD, insert a function that will calculate the mean of the absolute deviations you calculated in column $F.$

"Weighted Moving Average Data" Sheet $-$Each column holds information you may find helpful in your analysis. The following is a data dictionary for the listed information:

"Date" $-$ Date of Usage $($same as $$Exponential Smoothing Data" Sheet$)$

"Day" $-$ Day of the week $($Monday $-$ Friday$)($same as "Exponential Smoothing Data" Sheet$)$

"Ground Beef Demanded $($oz$.)"-$ How many ounces of ground beef were demanded by customers on this day $($same as "Exponential Smoothing Data" Sheet$)$