| % variance in sales tax: original budget v actual receipts.P&DA-Planning & Data Analytics |
Measure Definition & Importance |
Sales tax is the 2nd major source of revenue for the City's General Fund and primary source for the Crime Control and Prevention District. By more accurately budgeting the amount of sales tax, the City will be able to ensure it doesn't overbudget or underbudget due to inaccurate projections. This ensures the City doesn't overcommitt resources and it also ensures the City knows what is sustainable.
Green = +/- 3>#/p###
Yellow = between
Red = +/- 5>#/p###
Analysis | |
$ sales tax: original budget v actual receipts |
% variance in sales tax: original budget v actual receipts |
Service Areas |
-
PDA.2.3 Forecast & Analysis
P&DA-Planning & Data Analytics
Attachments |
Measure Data | Last Calculated 8 months ago |
| Period | | Status | Actual | Overall Target | Originally budgeted | Actual Receipts | +10 | High Variance (FY Target) | Low Variance | -3, | -5, | -10 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| FY2013 |  | Insufficient Progress | 8.30% | $ 108,798,434.00 | $ 118,646,424.00 | 3.00% | 5.00% | |||||
| FY2014 |  | Lagging | 3.67% | $ 120,934,328.00 | $ 125,547,039.00 | 3.00% | 5.00% | |||||
| FY2015 | | Lagging | 3.29% | $ 126,013,570.00 | $ 130,298,917.00 | 10.00% | 3.00% | 5.00% | -3.00% | -5.00% | -10.00% | |
| FY2016 |  | On Target | 2.46% | $ 135,065,427.00 | $ 138,475,263.00 | 10.00% | 3.00% | 5.00% | -3.00% | -5.00% | -10.00% | |
| FY2017 | | Insufficient Progress | 5.31% | $ 140,468,044.00 | $ 148,343,548.00 | 10.00% | 3.00% | 5.00% | -3.00% | -5.00% | -10.00% | |
| FY2018 | | On Target | 1.76% | $ 154,573,000.00 | $ 157,346,086.00 | 10.00% | -3.00% | -5.00% | -10.00% | |||
| FY2019 | | On Target | 0.80% | $ 163,151,802.00 | $ 164,472,264.00 | 10.00% | -3.00% | -5.00% | -10.00% | |||
| FY2020 | | Not Defined | ||||||||||
| FY2021 | | Not Defined | ||||||||||
| FY2022 | | Not Defined |
Data Source Details & Calculation Information |
The orginal budget for property taxes compared to the actual amount collected for the same time period. The analysis will be saved on an Excel spreadsheet, named "Property Tax KPI", and can be retrieved on the following shared drive: \\fs100\finance\KPI\Budget
Actual = 100- ((Original budget for property taxes / actual property taxes)*100)
This series is evaluated based on a RANGE of items and not directly against any other series. (see Actual --> Advanced --> Evaluation)
GREEN = 0% to 3% or 0% to -3%
YELLOW = 3.1% to 4.9% or -3.1% to -4.9%
RED = any value greater than or equal to 5%, or less than or equal to -5%
Performance Liaison |
| |
Measure Type |
Data Owner |
Measure ID |
Performance Liaison Notes |
Administrator Notes |