Solve this using clear and consice formatting in excel. Please show values and formulas step by step.

a) Using a 2-year moving average, the forecast for year 6=3750 miles (round your response to the nearest whole number). b) It a 2-year moving average is used to make the forecast, the MAD based on this = miles (round your response to one decimal place). (Hint You will have on 3 years of matched data.) c) The forecast for year 6 using a weighted 2 -year moving average whth weights of 0.40 and 0.60 (the weight of 0.60 is for the most recent penod) = (round your response to the nearest whole number). The MAD for the forecast developed using a weighted 2 -year moving average with woights of 0.40 and 0.60= miles (round your response to one decimal place), (Hint: You will have only 3 years of matched data) d) Using exponenlial smoothing with a=0,30 and the forecast for year 1 being 3,100 , the forecast for year 6=3,571 miles (round your response fo the nearest whole number)