Answered step by step
Verified Expert Solution
Question
1 Approved Answer
For each of the four revenues set an estimate for the 2020 budget. In order to make the estimate, examine the pattern of amount and
For each of the four revenues set an estimate for the 2020 budget. In order to make the estimate, examine the pattern of amount and percent change and the averages for each revenue (that you calculated in 1., above). See if there is a pattern of change to guide your job in establishing a budget estimate for 2020 (assume that you don't know that the COVID-19 pandemic was coming in 2020). Provide a one-sentence reason or logic for your 2020 estimate in the space available under each revenue.
Trend Report for City of Buffalo | Budget Year | Budget Estimate | ||||||
2014 | 2015 | 2016 | 2017 | 2018 | 2019 | Average Change | 2020 | |
Revenues | ||||||||
Utilities Gross Receipts Tax | $8,578,707.00 | $10,252,619.00 | $7,597,549.00 | $8,299,294.00 | $7,748,401.00 | $9,578,834.00 | $8,675,900.67 | |
Amout Change | $1,673,912.00 | -$2,655,070.00 | $701,745.00 | -$550,893.00 | $1,830,433.00 | $200,025.40 | ||
Percent Change | 19.51% | -25.90% | 9.24% | -6.64% | 23.62% | 4% | ||
Reason for 2020 Estimate | ||||||||
State Aid, Revenue Sharing | $173,285,233.00 | $161,285,233.00 | $161,285,233.00 | $161,285,233.00 | $161,527,752.00 | $161,285,233.00 | $163,325,652.83 | |
Amout Change | -$12,000,000.00 | $0.00 | $0.00 | $242,519.00 | -$242,519.00 | -$2,400,000.00 | ||
Percent Change | -7% | 0% | 0% | 0% | 0% | -1% | ||
Reason for 2020 Estimate | ||||||||
Sales Tax | $75,464,896.00 | $80,265,980.00 | $81,958,947.00 | $82,053,440.00 | $84,916,124.00 | $87,707,325.00 | $82,061,118.67 | |
Amout Change | $4,801,084.00 | $1,692,967.00 | $94,493.00 | $2,862,684.00 | $2,791,201.00 | $2,448,485.80 | ||
Percent Change | 6% | 2% | 0% | 3% | 3% | 3% | ||
Reason for 2020 Estimate | ||||||||
Metered Water Sales | $35,652,757.00 | $34,652,165.00 | $35,037,733.00 | $35,438,769.00 | $34,597,070.00 | $39,017,861.00 | $35,732,725.83 | |
Amout Change | -$1,000,592.00 | $385,568.00 | $401,036.00 | -$841,699.00 | $4,420,791.00 | $673,020.80 | ||
Percent Change | -3% | 1% | 1% | -2% | 13% | 2% | ||
Reason for 2020 Estimate |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started