Please show all EXCEL FORMULAS and EXCEL SOLVER FORMULAS WITH STEPS.

The number of plumbing repair jobs performed by Auger's Plumbing Service in each of the last nine months are listed below. Month March April May Jobs 272 285 260 Month June July August Jobs 272 298 315 Month September October November Jobs 278 272 300 a. b. Develop forecasts using a three-period simple moving average. What is your forecasts using a three-period weighted moving average with weights of .50, .35, and .15? How does it compare with your forecast from part (a) (compare them with all error measures)? B D E F H 1 j K L M N R S T U V W X Develop forecasts using a three-period simple moving average 1 Mean Error MAE MSE MAPE 285 2 Weeks Sales 3-Period WMA Error 3 March 272 4 April 5 May 260 6 June 272 7 July 298 8 August 315 9 September 278 10 October 272 11 November 300 12 13 14 How does it compare with your forecast from part (a)? 15 What is your forecasts using a three-period weighted moving average with weights of 60,.25, and .15? Weeks Sales 3-Period WMA Error Mean Error MAE MSE MAPE March 272 April 285 May 260 June 272 July 298 August 315 September 278 October 272 November 300 16 17 18 19 20