Use the data in the Excel file for this assignment. These data represents sales (in units) of a new dessert item recently added to a restaurant's menu. So far the restaurant has been selling the item for 12 weeks, and wants to forecast what sales will be in the upcoming week (week 13).

Construct both a moving average and a linear trend forecast. For the moving average forecast, average the previous five periods. For each technique, provide the forecasted values for both week 13 as well as all of the previous weeks that the technique will allow. Calculate the errors and MAD and MAPE. Based on these metrics, state which forecasting technique seems to work better for these data.

AutoSave Of HW 2 Data (3) (1) - Excel O Search Elise Storkamp ES 7 File Home Insert Page Layout Formulas Data Review View Help Share Comments Calibri 11 ~AI AutoSum = = a Wrap Text General ID DIA Normal Bad Good Neutral AT TIX HA 47 F Fill X Cut Lo Copy Paste Format Painter Clipboard BIU Check Cell 40 00 .000 E & Merge & Center Insert Delete Format Conditional Format as Calculation Formatting Table Explanatory... Input Clear Sort & Find & Filter Select Editing Analyze Data Font Alignment Number Styles Cells Analysis C17 X D E F H 1 J L M N 0 P Q R S U V w Y z AA AB A Period 1 Forecast B Sales (UNITS) 120 132 1 2 3 4 2 3 129 4 143 5 162 151 6 7 150 s 173 9 10 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 11 167 192 201 221 ??? 12 13 22