The following table shows total retail sales for the city of Taxylvania for the
ID: 2644665 • Letter: T
Question
The following table shows total retail sales for the city of Taxylvania for the last 11 years. The city is considering implementing a 1% retail sales tax in 2016. Estimate collections from a 1% retail sales tax for each of the next 3 years (2016 - 2018). Note, the data provided in the chart is total retail sales. We are forecasting a tax that is equal to 1% of all retail sales.
Year Total Retail Sales
2005 40,826,702
2006 42,045,324
2007 43,414,770
2008 44,748,197
2009 45,960,890
2010 47,382,130
2011 48,897,359
2012 50,161,860
2013 51,728,282
2014 53,256,193
2015 54,417,181
2016 ???
2017 ???
2018 ???
What is the estimate for 2018 sales tax revenues? ____________
Explanation / Answer
Step1: Computation of Gross sale and 1% sales tax for 2016.We have,
The expected gross sale is calculated by applying 3-years moving average.
Expected gross sale for 2016 = (51,728,282 + 53,256,193 + 54,417,181)/3 = $ 53,133,885
Hence, The expected gross sale for 2016 = $ 53,133,885
Sale tax revenue = 1% of $ 53,133,885 = $ 531,338.85
Hence, The expected sale tax revenue is $ 531,338.85
Step2: Computaiton of expected gross sale for 2017.We have,
3-year moving average = (53,256,193 + 54,417,181 + 53,133,885) /3 = $ 53,602,420
Hence, The expected gross sale for 2017 is $ 53,602,420.
Step3: Computation of Gross sale and 1% sales tax for 2018.We have,
3-year moving average= ( 54,417,181 + 53,133,885 + 53,602,420)/3 = $ 53,717,829
Hence, The expected gross sale for 2018 is $ 53,717,829.
1% sales tax revenue = $ 53,717,829 x 1% = $ 537,178.29
Hence, estimate for 2018 sales tax revenues is $ 537,178.29.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.