The DNA Budgeting/Planning Model with a few changes
Published: Mon, 08/01/22
Feedback appreciated.
Lewis
| CITY OF MCKINNEY GENERAL FUND STAFFING AND SPENDING ON A PERCAPITA BASIS ADJUSTED FOR INFLATION | ||||||||||||||||||
| 1 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | GROWTH | ||
| 2 | GENERAL FUND STAFFING | |||||||||||||||||
| 3 | GENERAL GOVERNMENT | 90.50 | 104.50 | 102.50 | 91.00 | 98.50 | 101.50 | 109.80 | 121.80 | 124.00 | 131.00 | 134.00 | 135.50 | 148.00 | 151.20 | 155.74 | ||
| 4 | POLICE | 203.00 | 208.00 | 207.00 | 206.00 | 219.00 | 236.00 | 238.00 | 244.00 | 261.00 | 275.00 | 289.00 | 298.00 | 304.00 | 310.56 | 319.91 | ||
| 5 | FIRE | 167.20 | 167.20 | 166.70 | 164.50 | 167.50 | 171.50 | 174.50 | 188.00 | 191.00 | 195.00 | 221.00 | 227.00 | 229.00 | 233.94 | 240.98 | ||
| 6 | LIBRARIES | 38.70 | 37.70 | 34.80 | 32.80 | 38.60 | 38.60 | 40.00 | 41.00 | 41.00 | 41.00 | 42.90 | 44.80 | 45.80 | 46.79 | 48.20 | ||
| 7 | DEVELOPMENT | 112.60 | 105.10 | 97.00 | 81.50 | 82.50 | 92.00 | 95.00 | 96.00 | 101.50 | 109.50 | 113.50 | 116.50 | 118.00 | 120.55 | 124.17 | ||
| 8 | PARKS & RECREATION | 84.50 | 81.50 | 84.00 | 85.00 | 87.00 | 87.00 | 91.80 | 147.40 | 155.90 | 192.30 | 202.90 | 207.40 | 212.40 | 216.99 | 223.51 | ||
| 9 | PUBLIC WORKS | 60.70 | 61.70 | 61.70 | 61.70 | 61.40 | 66.90 | 71.10 | 75.80 | 74.50 | 78.50 | 83.50 | 88.00 | 91.50 | 93.48 | 96.29 | ||
| 10 | TOTAL | 757.20 | 765.70 | 753.70 | 722.50 | 754.50 | 793.50 | 820.20 | 914.00 | 948.90 | 1,022.30 | 1,086.80 | 1,117.20 | 1,148.70 | 1,173.50 | 1,208.81 | 59.64% | HEADLINE CHANGE |
| 11 | STAFF CHANGES | BASE | 8.50 | (12.00) | (31.20) | 32.00 | 39.00 | 26.70 | 93.80 | 34.90 | 73.40 | 64.50 | 30.40 | 31.50 | 24.80 | 35.31 | ||
| 12 | POPULATION | 122,083 | 131,117 | 133,619 | 136,067 | 140,826 | 148,559 | 155,142 | 161,905 | 168,358 | 179,804 | 187,802 | 195,342 | 198,507 | 202,677 | 208,775 | 71.01% | |
| 13 | POP CHANGES | BASE | 9,034 | 2,502 | 2,448 | 4,759 | 7,733 | 6,583 | 6,763 | 6,453 | 11,446 | 7,998 | 7,540 | 3,165 | 4,170 | 6,098 | SIMILAR TO GLADEWATER OR BURNET ANNUALLY | |
| 14 | STAFF PER 1,000 POP | 6.20 | 5.84 | 5.64 | 5.31 | 5.36 | 5.34 | 5.29 | 5.65 | 5.64 | 5.69 | 5.79 | 5.72 | 5.79 | 5.79 | 5.79 | -6.65% | ACTUAL CHANGE |
| 15 | GENERAL FUND STAFFING RESOURCE ALLOCATION | |||||||||||||||||
| 16 | GENERAL GOVERNMENT | 11.95% | 13.65% | 13.60% | 12.60% | 13.06% | 12.79% | 13.39% | 13.33% | 13.07% | 12.81% | 12.33% | 12.13% | 12.88% | 12.88% | 12.88% | ||
| 17 | POLICE | 26.81% | 27.16% | 27.46% | 28.51% | 29.03% | 29.74% | 29.02% | 26.70% | 27.51% | 26.90% | 26.59% | 26.67% | 26.46% | 26.46% | 26.46% | ||
| 18 | FIRE | 22.08% | 21.84% | 22.12% | 22.77% | 22.20% | 21.61% | 21.28% | 20.57% | 20.13% | 19.07% | 20.33% | 20.32% | 19.94% | 19.94% | 19.94% | ||
| 19 | LIBRARIES | 5.11% | 4.92% | 4.62% | 4.54% | 5.12% | 4.86% | 4.88% | 4.49% | 4.32% | 4.01% | 3.95% | 4.01% | 3.99% | 3.99% | 3.99% | ||
| 20 | DEVELOPMENT | 14.87% | 13.73% | 12.87% | 11.28% | 10.93% | 11.59% | 11.58% | 10.50% | 10.70% | 10.71% | 10.44% | 10.43% | 10.27% | 10.27% | 10.27% | ||
| 21 | PARKS & RECREATION | 11.16% | 10.64% | 11.15% | 11.76% | 11.53% | 10.96% | 11.19% | 16.13% | 16.43% | 18.81% | 18.67% | 18.56% | 18.49% | 18.49% | 18.49% | ||
| 22 | PUBLIC WORKS | 8.02% | 8.06% | 8.19% | 8.54% | 8.14% | 8.43% | 8.67% | 8.29% | 7.85% | 7.68% | 7.68% | 7.88% | 7.97% | 7.97% | 7.97% | ||
| 23 | TOTAL | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | ||
| 24 | GENERAL FUND SPENDING | |||||||||||||||||
| 25 | GENERAL GOVERNMENT | $19,366,493 | $22,098,360 | $20,785,693 | $19,020,719 | $19,336,330 | $30,876,833 | $22,228,405 | $23,766,504 | $28,600,730 | $29,039,706 | $33,980,586 | $42,185,516 | $46,768,322 | $47,815,161 | $50,865,683 | ||
| 26 | POLICE | $19,923,024 | $20,145,964 | $19,655,184 | $20,285,700 | $22,036,551 | $24,603,118 | $25,545,773 | $27,074,194 | $29,519,229 | $33,382,794 | $35,807,519 | $37,706,173 | $39,463,178 | $40,346,503 | $42,920,537 | ||
| 27 | FIRE | $17,894,488 | $17,959,131 | $17,930,235 | $17,302,735 | $19,409,153 | $21,004,629 | $22,848,846 | $23,588,822 | $24,934,620 | $27,961,499 | $30,805,418 | $34,353,873 | $37,275,608 | $38,109,967 | $40,541,315 | ||
| 28 | LIBRARIES | $2,638,350 | $2,909,708 | $2,781,727 | $2,775,484 | $2,826,451 | $2,868,747 | $3,279,002 | $3,379,840 | $3,382,296 | $3,533,097 | $3,624,482 | $3,530,954 | $3,835,700 | $3,921,556 | $4,171,745 | ||
| 29 | DEVELOPMENT | $9,185,580 | $9,158,668 | $8,512,495 | $8,119,293 | $8,750,307 | $9,617,376 | $10,291,439 | $10,074,158 | $10,397,360 | $11,670,785 | $11,789,924 | $11,911,476 | $12,754,482 | $13,039,972 | $13,871,899 | ||
| 30 | PARKS & RECREATION | $7,399,164 | $7,145,909 | $7,275,824 | $6,954,994 | $7,504,161 | $7,804,340 | $8,072,018 | $8,977,206 | $12,822,926 | $15,349,806 | $14,308,835 | $14,517,672 | $15,746,290 | $16,098,747 | $17,125,819 | ||
| 31 | PUBLIC WORKS | $12,275,920 | $13,386,420 | $10,610,792 | $10,882,395 | $11,097,674 | $12,150,458 | $13,857,657 | $13,007,662 | $14,329,110 | $15,961,755 | $19,608,279 | $15,719,389 | $15,274,954 | $15,616,861 | $16,613,189 | ||
| 32 | TOTAL | $88,683,019 | $92,804,160 | $87,551,950 | $85,341,320 | $90,960,627 | $108,925,501 | $106,123,140 | $109,868,386 | $123,986,271 | $136,899,442 | $149,925,043 | $159,925,053 | $171,118,534 | $174,948,768 | $186,110,187 | 109.86% | |
| 33 | ||||||||||||||||||
| 34 | COST PER CAPITA | $726.42 | $707.80 | $655.24 | $627.20 | $645.91 | $733.21 | $684.04 | $678.60 | $736.44 | $761.38 | $798.31 | $818.69 | $862.03 | $863.19 | $891.44 | 22.72% | HEADLINE CHANGE |
| 35 | GENERAL FUND RESOURCE ALLOCATION | |||||||||||||||||
| 36 | GENERAL GOVERNMENT | 21.84% | 23.81% | 23.74% | 22.29% | 21.26% | 28.35% | 20.95% | 21.63% | 23.07% | 21.21% | 22.67% | 26.38% | 27.33% | 27.33% | 27.33% | ||
| 37 | POLICE | 22.47% | 21.71% | 22.45% | 23.77% | 24.23% | 22.59% | 24.07% | 24.64% | 23.81% | 24.38% | 23.88% | 23.58% | 23.06% | 23.06% | 23.06% | ||
| 38 | FIRE | 20.18% | 19.35% | 20.48% | 20.27% | 21.34% | 19.28% | 21.53% | 21.47% | 20.11% | 20.42% | 20.55% | 21.48% | 21.78% | 21.78% | 21.78% | ||
| 39 | LIBRARIES | 2.98% | 3.14% | 3.18% | 3.25% | 3.11% | 2.63% | 3.09% | 3.08% | 2.73% | 2.58% | 2.42% | 2.21% | 2.24% | 2.24% | 2.24% | ||
| 40 | DEVELOPMENT | 10.36% | 9.87% | 9.72% | 9.51% | 9.62% | 8.83% | 9.70% | 9.17% | 8.39% | 8.53% | 7.86% | 7.45% | 7.45% | 7.45% | 7.45% | ||
| 41 | PARKS & RECREATION | 8.34% | 7.70% | 8.31% | 8.15% | 8.25% | 7.16% | 7.61% | 8.17% | 10.34% | 11.21% | 9.54% | 9.08% | 9.20% | 9.20% | 9.20% | ||
| 42 | PUBLIC WORKS | 13.84% | 14.42% | 12.12% | 12.75% | 12.20% | 11.15% | 13.06% | 11.84% | 11.56% | 11.66% | 13.08% | 9.83% | 8.93% | 8.93% | 8.93% | ||
| 43 | TOTAL | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | ||
| 44 | SPENDING ADJUSTED FOR INFLATION | |||||||||||||||||
| 45 | CPI INDEX | 214.269 | 216.449 | 219.782 | 226.502 | 230.287 | 233.326 | 236.971 | 237.017 | 239.639 | 244.140 | 249.620 | 253.905 | 257.366 | 263.127 | 279.914 | 30.64% | |
| 46 | PLACED ON 2009 BASIS | 1.000 | 1.010 | 1.026 | 1.057 | 1.075 | 1.089 | 1.106 | 1.106 | 1.118 | 1.139 | 1.165 | 1.185 | 1.201 | 1.228 | 1.306 | ||
| 47 | PLACED ON 2018 BASIS | 0.765 | 0.773 | 0.785 | 0.809 | 0.823 | 0.834 | 0.847 | 0.847 | 0.856 | 0.872 | 0.892 | 0.907 | 0.919 | 0.940 | 1.000 | ||
| 48 | ||||||||||||||||||
| 49 | 2009 BASIS | $726.42 | $700.67 | $638.80 | $593.33 | $600.98 | $673.33 | $618.51 | $613.47 | $658.48 | $668.23 | $685.26 | $690.89 | $717.68 | $702.91 | $682.38 | -6.06% | ACTUAL CHANGE |
| 50 | 2023 BASIS | $948.96 | $915.33 | $834.51 | $775.10 | $785.10 | $879.61 | $808.00 | $801.41 | $860.21 | $872.95 | $895.20 | $902.55 | $937.55 | $918.26 | $891.44 | -6.06% | ACTUAL CHANGE |