Explain and show your work for part C and D.

Columbus Municipal Government has asked you to forecast the sales tax revenue it will collect in Year 6, Year 7 and Year 8. Data on revenue in recent years is presented below. The annual data are aranhed helner a. Estimate annual sales tax revenue for Year 6, Year 7 and Year 8 using a moving average "3-day" (MA3) model. Please clearly show the process you use to come up with your estimates. ( 5 points) b. Estimate annual sales tax revenue for Year 6 , Year 7, and Year 8 using a moving average "4-day" (MA4) model. Please clearly show the process you use to come up with your estimates. ( 5 points) c. Forecast the expected annual sales tax revenue for Year 6 , Year 7 and Year 8 using the trend regression model. ( 5 points) d. Do you recommend that the trend regression model be employed in this case? Why or why not? (5 points) Columbus Municipal Government has asked you to forecast the sales tax revenue it will collect in Year 6, Year 7 and Year 8. Data on revenue in recent years is presented below. The annual data are aranhed helner a. Estimate annual sales tax revenue for Year 6, Year 7 and Year 8 using a moving average "3-day" (MA3) model. Please clearly show the process you use to come up with your estimates. ( 5 points) b. Estimate annual sales tax revenue for Year 6 , Year 7, and Year 8 using a moving average "4-day" (MA4) model. Please clearly show the process you use to come up with your estimates. ( 5 points) c. Forecast the expected annual sales tax revenue for Year 6 , Year 7 and Year 8 using the trend regression model. ( 5 points) d. Do you recommend that the trend regression model be employed in this case? Why or why not? (5 points)