B2 X V fx A B C D E F G H I J K L M N O P Q Week Demand Nancy's Foreast (t) ( F+ ) 1245 1225 Weekly demand has been provided, along with a forecast provided by Nancy (column 'C'). Please: A W N H 1232 a) In column D, determine the Mean Absolute Error (MAD) for Nancy's forecasts. Use all of her forecasts 1224 [weeks 5-35, inclusive). Report the MAD, to two decimals. 1241 1234.50 1235 1232.50 b) In column E, develop weighted moving average (WMA) forecasts over the same time period (weeks 5- 1235 1232.50 35, inclusive). Use weights of 0.6, 0.2, 0.1, 0.1 with the larger weight being on more recent demand. 1240 1232.50 Report your forecast for week 36, to two decimals. 1255 1238.00 10 1272 1245.00 c) Determine the MAD for the WMA forecasts, in column F (over weeks 5-35, inclusive). 11 1263 1253.50 12 1256 1256.00 13 1267 1263.50 14 1248 1264.00 15 1254 1257.50 16 1254 1257.50 17 1246 1257.50 18 1241 1250.00 19 1250 1247.50 20 1255 1247.50 21 1239 1248.00 22 1255 1247.00 23 1236 1247.00 24 1216 1245.50 25 1233 1235.50 26 1230 1235.50 27 1231 1226.00 28 1224 1224.50 29 1216 1228.50 30 1216 1223.50 31 1232 1223.50 32 1217 1224.00 3 3 1228 1224.00 34 1243 1224.00 35 1236 1230.00