I NEED EXPLENATION WITHOUT MICROSOFT EXCELL. CAN YOU WRITE FORMULAS TOO PLEASE.

MOVING AVERAGE AND trend-projection method IS VERY CONFUSING TO ME.

IM OK WITH EXPONENTIAL SMOOTHING THE QUESTIONS THAT I HAVE ANSWERED

As you can see in the following table, demand for heart transplant surgery at Washington General Hospital has increased steadily in the past few years: The director of medical services predicted 6 years ago that demand in year 1 would be 42.0 surgeries. a) Using exponential smoothing with of 0.60 and the given forecast for year 1 , the forecasts for years 2 through 6 are (round your responses to one decimal place): For the forecast made using exponential smoothing with =0.60 and the given forecast for year 1 , MAD=4.8 surgeries (round your response to one decimal place). Using exponential smoothing with of 0.90 and the given forecast for year 1 , the forecasts for years 2 through 6 are (round your responses to one decimal place): For the forecast made using exponential smoothing with =0.90 and the given forecast for year 1 , MAD=3.6 surgeries (round your response to one decimal place). b) Forecasts for years 4 through 6 using a 3-year moving average are (round your responses to one decimal place): b) Forecasts for years 4 through 6 using a 3-year moving average are (round your responses to one decimal place): For forecasts made using a 3-year moving average, MAD = surgeries (round your response to one decimal place). c) Forecasts for years 1 through 6 using the trend-projection method are (round your responses to one decimal place): For forecasts made using the trend-projection method, MAD = surgeries (round your response to one decimal place). d) Based on the comparison of MAD, the best forecast is achieved using the method. Exponential Sinoothing with Alpha =0.6