PLEASE SHOW EXCEL FORMULAS NOT JUST ANSWERS AS I WANT TO LEARN WHAT I AM DOING WRONG, THANK YOU!

B D E F G H 3 4 5 6 8 The following inventory pattern has been observed in the Zahm Corporation over 12 1 months: 2 Month Inventory 16-Apr 1,544 16-May 1,913 16-Jun 2,028 16-Jul 1,178 7 16-Aug 1,554 16-Sep 1,910 9 16-Oct 1,208 10 16-Nov 2,467 16-Dec 2,101 12 17-Jan 1,662 13 17-Feb 2,432 14 17-Mar 2,443 15 16 Use both three-month and five-month moving- 17 18 average models to forecast the inventory for the next January. Use mean absolute percentage error 19 (MAPE) to evaluate these two forecasts. no