please show the work if possible so i know how to solve problems like this in the future.

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: Click here for the Excel Data File Compute MAD for each set of forecasts. Given your results, which forecast appears to be more accurate? (Round your answers to 1 decimal place.) b. Compute the MSE for each set of forecasts. Given your results, which forecast appears to be more accurate? (Round your answers to 2 decimal places.) d. Compute MAPE for each data set. Which forecast appears to be more accurate? (Round your intermediate calculations and final answers to 2 decimal places.)