Please help me find the weighted moving average for all three!!

. Weighted Moving Avg NA N/A NA N/A NA 18 20 20 21 23 Month Sales Moving Avg (5) Weighted Moving Ave Moving Avg 16) Weighted Moving Ave Moving Ave 2 January 20 N/A NA N/A N/A NA February 21 N/A NA N/A NA NA 4 March 15 N/A N/A NA N/A 5 April 14 N/A N/A NA N/A NA May 13 N/A N/A NA 7 June 16 16.6 N/A NA July 17 158 16.5 N/A 9 August 15 16 10 September 15.6 15.5 11 October 16.8 16.3 12 November 182 173 13 December 192 13.7 14 awary 20.4 19 15 February 21.2 16 March 21 NON 17 April 212 21 21 19 20 1. Generate as many valid forecasts as you can for a five period moving averasi period moving a period moving avere 21 and a weighted average forecast with weights 04.03.02, and for the most recent data, the next most recent data and so forth, respectively 22 2. Calculate MAD for each forecast (Use common data periods only insert columns as necessary 23 3. Recommend a forecast and explain why that is your choice 24 4. Use Excel for all calculations 25 25 16.6 16,3 16.1 16.9 17.9 103 2 15 21 2003 201 20.4 20.9