| ARAPAHOE COUNTY BUDGET PROJECTION 1ST WAY (Regression)-- | | | | Public Works |
| | Adopted Budgets for 2014 through 2017 | | | | (by regression)
2018 Projection |
| Expenditure Category | 2014 | 2015 | 2016 | 2017 | 2018 |
| Salaries and Wages | $ 7,491,467 | $ 7,804,584 | $ 8,086,791 | $ 8,232,077 | $ 8,529,739 | <-- DO NOT COPY FROM HERE |
| Employee Benefits | $ 2,365,082 | $ 2,419,845 | $ 2,501,179 | $ 2,474,823 | $ 2,542,872 | <-- AND PASTE INTO HERE |
| Supplies | $ 2,511,620 | $ 2,350,798 | $ 2,579,989 | $ 3,008,160 | $ 3,042,345 | [Read instruction #14, after "IMPORTANT"] |
| Services & Other | $ 10,081,347 | $ 11,704,317 | $ 12,943,006 | $ 6,527,952 | $ 7,958,782 |
| Community Programs | $ - | $ - | $ - | $ - | $ - |
| Capital Outlay | $ 1,350,092 | $ 2,014,569 | $ 1,832,918 | $ 7,842,175 | $ 8,083,588 |
| Central Services | $ 2,045,442 | $ 2,499,827 | $ 2,683,073 | $ 2,671,716 | $ 2,990,532 |
| Transfers | $ 492,466 | $ 548,106 | $ 384,962 | $ 511,563 | $ 457,811 |
| Total | $26,337,516 | $29,342,046 | $31,011,918 | $31,268,466 | $33,605,667 |
| BUDGET PROJECTION 2ND WAY (Compounded annual % change)-- | | | | Public Works |
| Expenditure Category | % Change
2014-15 | % Change
2015-16 | % Change
2016-17 | Compounded Annual % Chg. | (using compounded
annual % change)
2018 Projection |
| Salaries and Wages | 4.2% | 3.6% | 1.8% | 3.19% | $ 8,494,874 |
| Employee Benefits | 2.3% | 3.4% | -1.1% | 1.52% | $ 2,512,523 |
| BUDGET PROJECTION 2ND WAY (3-year moving average)-- | | | | Public Works |
| Expenditure Category | | | 3-yr average for 2014-16 | 2018 Projection = 3-yr average for 2015-17 |
| Supplies | | | $ 2,480,802.33 | $ 2,646,316 |
| Services & Other | | | $ 11,576,223.33 | $ 10,391,758 |
| Community Programs | | | $ - 0 | $ - |
| Capital Outlay | | | $ 1,732,526.33 | $ 3,896,554 |
| Central Services | | | $ 2,409,447.33 | $ 2,618,205 |
| Transfers | | | $ 475,178.00 | $ 481,544 |
| ARAPAHOE COUNTY 2018 BUDGET COMPARISON COMBINING 2 WAYS-- | | | | Public Works |
| | | | | % difference btw 2018 budget and… |
| Expenditure Category | 2018 Adop-
ted Budget | 2018 Low
Projection | 2018 High
Projection | Low Projection | High Projection |
| Salaries and Wages | $ 8,570,370 | $ 8,494,874 | $ 8,529,739 | 0.89% | 0.48% |
| Employee Benefits | $ 2,589,033 | $ 2,512,523 | $ 2,542,872 | 3.05% | 1.82% |
| Supplies | $ 3,382,160 | $ 2,646,316 | $ 3,042,345 | 27.81% | 11.17% |
| Services & Other | $ 6,766,833 | $ 7,958,782 | $ 10,391,758 | -14.98% | -34.88% |
| Community Programs | $ - | $ - | $ - |
| Capital Outlay | $ 7,823,512 | $ 3,896,554 | $ 8,083,588 | 100.78% | -3.22% |
| Central Services | $ 2,744,050 | $ 2,618,205 | $ 2,990,532 | 4.81% | -8.24% |
| Transfers | $ 157,895 | $ 457,811 | $ 481,544 | -65.51% | -67.21% |
| Total | $ 32,033,853 | $ 28,585,065 | $ 36,062,377 | 12.06% | -11.17% |
Vicky-shema
ArapahoeCtyBudgetProjection--revisedSpring_19.xls
