Excel File Edit View insert Format Tools Data Window Help A Thu Mar 24 8:43 PM o AutoSave OFF ASP Homework 3.-1 Home Insert Draw Page Layout Formulas Data Review View Tell me & Share Comments Calibri (Body) V v 11 YA I = = Oy & Wrao Text General Y O 9 Insert Delete Format 27-O Paste B TU Merge & Center $ % % Conditional Format Cell Formatting as Table Styles Sort & Filter Find & Select Analyze Data Open recovered workbooks? Your recent changes were saved. Da you want to continue working where you left off? Yes Na J23 fx A B C D E F G H E G H R S T UV W X Y Z 2 Period Sales M N 0 Use 3 period moving average and exponential smoothing technique to forecast demand for period 16. For exponential smoothing use c = 9 and a =.S. Then by using MAD or MAPE see which technique gives more accurate stimation. The Rubric 3-period moving av 0.50 point a=.5 0.25 point 0.25 point MAD ar MAPE 1.00 point 4 S 6 7 1 2 3 " 4 5 6 7 9 10 11 12 13 14 15 16 17 **** 23******** 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 TI Aggregate Planning (2 points) seasonality (2 points) Exponetial Smothing (2 points) Ready CI 2502 1 24 tv N 7 A A