The follwing table shows total collections from User Fees for the city of Taxylv

Question

The follwing table shows total collections from User Fees for the city of Taxylvania for the last 7 years.   Use this data to forecast total user fee revenue for each of the next three years (2016 - 2018).

Year               Total User Charges

2009                      481,984

2010                    494,149

2011                      511,218

2012                    530,184

2013                  531,157

2014                    541,850

2015                550,000

2016                        ???

2017                        ???

2018                        ???

What is the estimate for 2016 user fee revenues? _______________

Explanation / Answer

Below is the forecasting done for the next months on the basis of three months moving average method- The Forecast for year 2016 is the moving average for the year before that i.e. the moving average for Year 2015= Y7= 541002.

Year Y Amt Three months moving Average 2009 Y1 481984 2010 Y2 494149 2011 Y3 511218 495784 2012 Y4 530184 511850 2013 Y5 531157 524186 2014 Y6 541850 534397 2015 Y7 550000 541002 2016 Y8 541002 544284 2017 Y9 544284 545095 2018 Y10 545095 543461

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.