PLEASE WITH COMPLETE SOLUTION NO JUST FROM EXCEL

4. Accuracy and control of forecasts. The manager of a large manufacturer of industrial pumps must choose between two alternative forecasting techniques. Both techniques have been used to prepare forecasts for a six-month period. Using MAD as a criterion, which technique has the better performance record? FORECAST Month Demand Technique 1 Technique 2 1 492 488 495 2 484 482 3 485 480 478 4 493 490 488 5 498 497 492 6 492 493 493 470 AN