PLEASE show thorough calculations on excel and excel formulas. Thank you!

Problem 3-21 (Algo) Two different forecasting techniques (F1 and F2) were used to forecast demand for cases of bottled water. Actual demand and the two sets of forecasts are as follows: 62 Period 1 2 3 4 5 6 7 Demand 68 75 70 74 69 72 80 78 000 W PREDICTED DEMAND F1 F2 67 69 68 72 70 66 70 72 65 76 74 79 74 85 73 01 8 Click here for the Excel Data File a. Compute MAD for each set of forecasts. Given your results, which forecast appears to be more accurate? (Round your answers to 2 decimal places.) MAD F1 MAD F2 appears to be more accurate. d. Compute MAPE for each data set. Which forecast appears to be more accurate? (Round your intermediate calculations to 2 decimal places and and final answers to 2 decimal places.) MAPE F1 % MAPE F2 % appears to be more accurate. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 5 6 A Period 1 2 3 34 4 567 8 B Demand 68 75 70 74 69 72 80 78 C D PREDICTED F1 F2 62 67 69 68 72 70 66 70 73 72 65 76 74 79 74 85 E F G H