please explain a,b,c, d parts properly using excel . explain this properly step by step

Sales of Cool-Man air conditioners have grown steadily during the past 5 years according to the following table: (a) The sales manager had predicted, before the business started, that year l's sales would be 410 air conditioners. Using exponential smoothing with a weight of a=0.3, develop forecasts for years 2 through 6. (b) Use a three-year moving average forecasting model to forecast the sales of Cool- Man air conditioners. (c) Using the trend projection method, develop a forecasting model for the sales of Cool-Man air conditioners. (d) Would you use exponential smoothing with a smoothing constant of 0.3, a 3-year moving average, or a trend to predict the sales of Cool-Man air conditioners? Answer based on MAD measure. Year Sales 1 450 2 495 3 518 4 563 5 584 6