The accounting department needs to forecast electricity expense for one of the buildings. The data for several months is supplied below. Beside each of the actual numbers in black, the forecast #1 is provided in red, forecast #2 is in green, and forecast #3 is in blue. The goal is to find the best forecast method using MAD. Be careful since the data is listed beginning with the most recent. Enter the lowest MAD of the three forecasts and select which is the best forecast: red, green or blue. Please round to two decimal places.

Select the best forecast Red Green Blue

Please enter the lowest MAD here--->

Jul 2020: 1105, 1006, 939, 1006 Jun 2020: 1425, 1325, 1268, 1354 May 2020: 1424, 1638, 1609, 1595 Apr 2020: 1119, 1029, 1029, 985 Mar 2020: 1431, 1245, 1245, 1359 ||Feb 2020: 1460, 1679, 1650, 1679||Jan 2020: 1172, 1289, 1324, 1348 Dec 2019: 1456, 1267, 1369, 1354 Nov 2019: 1395, 1283, 1228, 1214||Oct 2019: 1000, 880, 920, 920 Sep 2019: 1198, 1366, 1270, 1378 ||Aug 2019: 1446, 1518, 1648, 1648 Jul 2019: 1003, 1143, 1113, 1153 Jun 2019: 1420, 1576, 1576, 1576 May 2019: 1423, 1580, 1508, 1494|Apr 2019: 1169, 1227, 1227, 1274 Mar 2019: 1182, 1312, 1265, 1312 ||Feb 2019: 1284, 1438, 1438, 1477| Jan 2019: 1285, 1208, 1157, 1195 Dec 2018: 1075, 1204, 1215, 1226 Nov 2018: 1129, 1050, 971, 982 Oct 2018: 1155, 1317, 1247, 1236 Sep 2018: 1165, 1025, 990, 990 Aug 2018: 1154, 1096, 981, 1085 Jul 2018: 1489, 1295, 1400, 1415 Jun 2018: 1495, 1615, 1674, 1570 May 2018: 1101, 969, 1002, 958 Apr 2018: 1200, 1020, 1104, 1128 Mar 2018: 1107, 952, 941,985 Feb 2018: 1373, 1442, 1551, 1469