Public Budgeting Variance Analysis
Vicky-shema
PUBLICWORKS2016to2019Variance.xlsBudget Analysis
| ARAPAHOE COUNTY ADOPTED BUDGETS -- | Public Works and Development | |||||
| Expenditure Category | 2016 Adop- ted Budget | 2017 Adop- ted Budget | 2018 Adop- ted Budget | 2019 Adop- ted Budget | ||
| Salaries and Wages | $8,086,791 | $8,232,077 | $8,570,370 | $9,083,584 | ||
| Employee Benefits | $2,501,179 | $2,474,823 | $2,589,033 | $2,737,221 | ||
| Supplies | $2,579,989 | $3,008,160 | $3,382,160 | $4,226,311 | ||
| Services & Other | $12,943,006 | $6,527,952 | $6,766,833 | $6,146,518 | ||
| Community Programs | $0 | $0 | $0 | $0 | ||
| Capital Outlay | $1,832,918 | $7,842,175 | $7,823,512 | $7,601,208 | ||
| Central Services | $2,683,073 | $2,671,716 | $2,744,050 | $2,790,071 | ||
| Transfers | $384,962 | $511,563 | $157,895 | $514,765 | ||
| Total | $31,011,918 | $31,268,466 | $32,033,853 | $33,099,678 | ||
| ARAPAHOE COUNTY ACTUAL EXPENDITURES-- | Public Works and Development | |||||
| Expenditure Category | 2016 Actual | 2017 Actual | 2018 Actual | 2019 Estimate (closest to actual we can get) | ||
| Salaries and Wages | $8,121,269 | $8,111,896 | $8,287,486 | $8,618,425 | ||
| Employee Benefits | $2,455,193 | $2,301,161 | $2,382,580 | $2,483,711 | ||
| Supplies | $3,830,504 | $2,685,150 | $3,035,595 | $2,366,248 | ||
| Services & Other | $15,243,282 | $11,763,340 | $12,068,563 | $11,502,632 | ||
| Community Programs | $0 | $0 | $0 | $0 | ||
| Capital Outlay | $4,830,954 | $3,547,262 | $3,375,400 | $2,625,819 | ||
| Central Services | $2,554,904 | $2,446,007 | $2,646,653 | $2,588,051 | ||
| Transfers | $874,344 | $528,373 | $172,126 | $514,765 | ||
| Total | $37,910,450 | $31,383,189 | $31,968,403 | $30,699,651 | ||
| ARAPAHOE COUNTY BUDGETED VS. ACTUAL-- | Public Works and Development | |||||
| Expenditure Category | % Vari- ance 2016 | % Vari- ance 2017 | % Vari- ance 2018 | % Vari- ance 2019 | % Variance 2016-18 | % Variance 2017-19 |
| Salaries and Wages | -0.4% | 1.5% | 3.3% | 5.1% | 1.4% | 3.3% |
| Employee Benefits | 1.8% | 7.0% | 8.0% | 9.3% | 5.6% | 8.1% |
| Supplies | -48.5% | 10.7% | 10.2% | 44.0% | -9.2% | 21.7% |
| Services & Other | -17.8% | -80.2% | -78.3% | -87.1% | -58.8% | -81.9% |
| Community Programs | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% |
| Capital Outlay | -163.6% | 54.8% | 56.9% | 65.5% | -17.3% | 59.0% |
| Central Services | 4.8% | 8.4% | 3.5% | 7.2% | 5.6% | 6.4% |
| Transfers | -127.1% | -3.3% | -9.0% | 0.0% | -46.5% | -4.1% |
| Total | -22.2% | -0.4% | 0.2% | 7.3% | -7.5% | 2.4% |
Gibson:
Replaced #DIV/0! with 0.
Gibson:
Replaced #DIV/0! with 0.
