please do step by step on excel

07. (35 Points) The Cancun Tace Quick Stop Restaurant After tallying the recipes for their first year of operation, the family owners of the Coeun Tuco Quick Stop are encouraged Sales of their artisanal tacos, made from such exotic ingredients as ground beef, cheese and beam have been strong and seem to give hope to the coming your Cancun Tace sales revenue by month are shown in the table below. Date in the table will be used to rever parts of Sales Rev 474 45 501 SR 579 Time Period Month January 2 February 3 March April 5 May 6 Junc 7 July 8 Ausst 9 September 10 October 11 November December 594 679 0 732 a) Ammed only with her fingers, the owner operator decides that the safest demand forecasting approach is a moving average of a periods. Her fingers are aching by the time she reaches the month of May and she is womed about her ability to stuff taies during tomorrow's dinner rush. Help her out by finding the forecast for the month of June sales revenge b) Aemsed only with her fingers, the owner operator decides that the safest demand forecasting peach is a weighted moving average using 0.6.0.3. and 0.1 for the most recent there. Her fingers reaching by the time she reaches May and she is worried about his ability to stuff tacos during tomorrow's dinner rush Help her by finding the sales demand forecast for June ) Amed only with her fingers, the owner operator decides that the safest demand forecasting approach is exponential mething with an alpha of 0.x. She uses the January sales demand and the January demand forecast just to get the ball rolling. Her fingers are aching by the time she reaches March and she is also worried about her ability to stuff tacos during Somorrow's dinner wash Help her out by finding the sales demand forecast for April d) Amed only with her fingers, the owner Operator decides that the safest forecasting approach is a linearted Nime. Hier fingers are aching by the time she reaches May and she is worried about her ability to stuff taco during tomorrow's dinner rush Help her out by finding the sales demand forecast for June e) Armed only with his fingers, the owner decides that the safest forecasting approach is a weighted movies average using 0.6, 0.3and 0.1 for the most recent three Generate a forecast for the year using this toch and then calculate forecast errors using MAD. What is the mean blue deviation for this fecasting approach? 1) Amed only with her fingers, the owner decides that the safest forecasting approach is exponential swing with an alpha ofl. She uses the January sales demand and the January sales demand forecast just to get the hall rolling Generate a forecast for the year using this technique and then calculate forecast mees esing MAD What is the mean absolute deviation for this demand forecasting approach B) Armed only with his fingers, the owner decides that the safest forecasting approach is a lincur trendine Generate a forecast for the year using this technique and then calculate forecast moes using MAD. What is the man absolute deviation for this forecasting approach? h) Armed only with his fingers, the owner decides that the safest forecasting approach is exponential smoothing with an alpha of Ox Hesses the January demand and the January forecas just to get the ball rolling Generate a forecast for the year using this technique and the calculate forecast errors using MSE What is the man squared error for this forecasting approach