please solve with excel all parts. Excel, excel, excel.

Q7.035 Points) The Cancun Tace Quick Stop Restaurant After tallying the receipts for their first year of operation, the family owners of the Cancun Tace Quick Stop are encouraged. Sales of their artisanal tacos, made from such exotic ingredients as ground beef cheese and beans, have been strong and seem to give hope to the coming year. Cancun Taco sales revenue by month are shown in the table below. Date in this table will be tower parts to Time Period Month Sales Revenge January 474 2 February 435 3 March SO 4 April SER 5 May 579 6 Jung 7 July 394 8 Auct 679 9 September 60% 10 October 699 November 732 December 732 673 a) Amed only with her fingers, the owner operator decides that the safest demand forecasting approach is a moving average of nove periods. Her fingers are aching by the time she reaches the month of May and she is worried about her ability to stuff tacos during tomorrow's dinner rush Help het out by finding the forecast for the month of June sales revenue b) Amed only with her fingers, the owner operator decides that the safest demand forecasting approach is a weighted moving average using 0.6 0.3. and O.1 for the most recent three. Her fingers teaching by the time she reaches May and she is worried about his ability to stuff tacos during tomorrow's dinner rush Help her out by finding the sales demand forecast for Junc. c) Amed only with her fingers, the owner operator decides that the safest demand forecasting approach is exponential smoothing with an alpha of 0.3 She uses the January sales demand and the lanary 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 tomorrow's dinner rush. Help her out by finding the sales demand forecast for April d) Armed only with her fingers, the owner operator decides that the safest forecasting approach is a linearted line. Her fingers are aching by the time she reaches May and she is worried about her ability to stufaces during tomorrow's dinner rush. Help her out by finding the sales demand forecast for June c) Armed only with his fingers, the owner decides that the safest forecasting approach is a weighted moving average using 0.6, 0.3, and 0.1 for the most recent three Generate a forecast for the year using this technique and then calculate forecast erros using MAD. What is the mean absolute deviation for this forecasting approach? ) Armed only with her fingers, the outer decides that the safest forecasting approach is exponential smothing with an alpha of .x. She uses the January sales demand and the January sales demand forecast just to get the ball rolling Generate a forecast for the year using this technique and then calculate forecast errors using MAD What is the mean absolute deviation for this demand forecasting approach? ) Armed only with his fingers, the owner decides that the safest forecasting approach is a linear trendline Generate a forecast for the year using this technique and then calculate forecast errors asing MAD What is the mean absolute deviation for this forecasting approach? h Amed only with his fingers, the owner decides that the safest forecasting approach is exponential smoothing with an alpha of 0.. He uses the January demand and the January forecast just to get the ball rolling Generate a forecast for the year using this technique and then calculate forecast erroes using MSE. What is the mean squared error for this forecasting approach