Loading...
HomeMy WebLinkAboutAll Funds - Expense by Function** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/22/2021 08:40User: ekwitmerProgram ID: bgnyrpts Page 1 PROJECTION: 20221 2022 PROPOSED BUDGET FOR PERIOD 99 1 GEN ADMIN AND JUDICIAL 2020 2021 2021 2021 2021 2022 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 01 GENERAL GOVT OPERAT 21,999,407.52 24,499,417.00 24,667,580.00 20,201,096.52 24,183,257.57 24,939,143.00 _________ 06 DOMESTIC RELATIONS 1,850,991.28 2,080,799.00 2,080,799.00 1,658,268.63 2,020,230.00 2,107,943.00 _________ 16 GEN ADMIN DIRECT SU 3,764,492.87 4,456,444.00 4,456,444.00 3,317,888.57 4,118,188.00 4,606,288.00 _________ 17 HUMAN SERVICES BLDG 329,610.07 473,704.00 473,704.00 356,263.55 695,129.00 435,316.00 _________ 28 ADMIN ANNEX OCCUPAN 289,790.70 339,422.00 339,422.00 288,205.53 326,702.00 330,153.00 _________ 41 RESERVE FOR REPLACE 106,907.36 .00 35,990.00 35,989.46 36,500.00 .00 _________ 42 CAPITAL PROJECT COU 34,994,433.19 20,508,000.00 20,508,000.00 15,990,671.82 20,046,850.00 13,550,000.00 _________ 80 SPECIAL REVENUE GRA 301,034.61 .00 -2,500.48 12,620.78 7,790.64 1,500,000.00 _________ 88 SPECIAL REVENUE TRU 31,101.85 59,700.00 65,430.00 53,340.45 72,039.00 64,700.00 _________ TOTAL 1 GEN ADMIN AND JUDICI 63,667,769.45 52,417,486.00 52,624,868.52 41,914,345.31 51,506,686.21 47,533,543.00 _________ ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/22/2021 08:40User: ekwitmerProgram ID: bgnyrpts Page 2 PROJECTION: 20221 2022 PROPOSED BUDGET FOR PERIOD 99 2 PUBLIC SAFETY 2020 2021 2021 2021 2021 2022 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 01 GENERAL GOVT OPERAT 21,202,625.32 23,076,954.00 22,972,021.00 19,091,241.04 22,659,495.53 22,709,687.00 _________ 21 E 911 SERVICES 3,865,749.67 4,370,426.00 4,230,858.00 3,330,218.12 3,831,651.61 3,905,874.00 _________ 22 HAZARDOUS MATERIALS 152,698.50 169,769.00 181,309.00 139,124.77 161,717.75 190,925.00 _________ 41 RESERVE FOR REPLACE .00 .00 34,075.00 70,125.00 34,075.00 .00 _________ 80 SPECIAL REVENUE GRA 506,879.54 .00 134,854.14 58,241.24 27,556.94 .00 _________ TOTAL 2 PUBLIC SAFETY 25,727,953.03 27,617,149.00 27,553,117.14 22,688,950.17 26,714,496.83 26,806,486.00 _________ ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/22/2021 08:40User: ekwitmerProgram ID: bgnyrpts Page 3 PROJECTION: 20221 2022 PROPOSED BUDGET FOR PERIOD 99 3 PUBLIC WORKS 2020 2021 2021 2021 2021 2022 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 01 GENERAL GOVT OPERAT 358.80 92,400.00 92,400.00 1,067.66 1,080.00 51,110.00 _________ 10 LIQUID FUELS TAXES 1,033,886.59 3,946,898.00 3,946,898.00 1,517,717.33 2,520,327.00 2,130,400.00 _________ 20 COMM DEVEL BLOCK GR 526,630.84 1,621,963.00 1,621,963.00 202,788.96 214,052.00 1,479,279.00 _________ TOTAL 3 PUBLIC WORKS 1,560,876.23 5,661,261.00 5,661,261.00 1,721,573.95 2,735,459.00 3,660,789.00 _________ ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/22/2021 08:40User: ekwitmerProgram ID: bgnyrpts Page 4 PROJECTION: 20221 2022 PROPOSED BUDGET FOR PERIOD 99 4 HUMAN SERVICES 2020 2021 2021 2021 2021 2022 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 04 AGING SERVICES PSA 4,001,755.94 5,377,396.00 5,377,396.00 3,641,670.83 5,346,657.00 5,357,287.00 _________ 05 CHILDREN & YOUTH SE 13,634,872.39 16,460,948.00 16,460,948.00 10,668,521.94 14,458,857.00 16,183,788.00 _________ 07 DRUG & ALCOHOL SCA 1,831,231.30 2,092,036.00 2,149,932.00 1,236,288.11 1,749,266.00 1,831,742.00 _________ 11 MENTAL HEALTH / EAR 6,734,006.57 7,301,804.00 7,079,863.00 4,882,552.31 6,481,410.00 7,012,963.00 _________ 31 HUMAN SERVICES ADMI 402,598.23 499,412.00 499,412.00 326,006.19 426,721.00 424,508.00 _________ 32 NON-CATEG HUMAN SER 437,032.46 610,977.00 610,977.00 390,509.84 426,580.00 455,712.00 _________ 34 INTELLECTUAL DISABI 871,500.83 1,030,331.00 1,125,916.00 947,898.79 1,221,896.00 1,038,275.00 _________ 35 COMMUNITY SERVICES 424,694.40 369,607.00 10,783,800.00 4,374,067.93 5,750,498.00 8,986,157.00 _________ 36 BH MANAGED CARE 580,042.09 633,113.00 633,113.00 553,288.84 657,694.00 752,838.00 _________ TOTAL 4 HUMAN SERVICES 28,917,734.21 34,375,624.00 44,721,357.00 27,020,804.78 36,519,579.00 42,043,270.00 _________ ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/22/2021 08:40User: ekwitmerProgram ID: bgnyrpts Page 5 PROJECTION: 20221 2022 PROPOSED BUDGET FOR PERIOD 99 5 CULTURE & RECREATION 2020 2021 2021 2021 2021 2022 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 01 GENERAL GOVT OPERAT 62,636.28 71,078.00 71,078.00 52,473.02 66,024.00 59,478.00 _________ 88 SPECIAL REVENUE TRU 343,551.85 688,011.00 688,011.00 208,713.24 645,896.00 274,535.00 _________ TOTAL 5 CULTURE & RECREATION 406,188.13 759,089.00 759,089.00 261,186.26 711,920.00 334,013.00 _________ ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/22/2021 08:40User: ekwitmerProgram ID: bgnyrpts Page 6 PROJECTION: 20221 2022 PROPOSED BUDGET FOR PERIOD 99 6 COMMUNITY & ECON DEVELOP 2020 2021 2021 2021 2021 2022 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 01 GENERAL GOVT OPERAT 347,098.94 424,561.00 419,761.00 269,017.72 398,877.00 455,556.00 _________ 33 TOURIST PROMOTION H 714,702.49 1,050,000.00 1,050,000.00 925,689.52 1,050,016.00 1,300,010.00 _________ 80 SPECIAL REVENUE GRA 8,379,584.53 .00 1,756,000.00 2,028,353.52 149,967.16 10,500,000.00 _________ 88 SPECIAL REVENUE TRU 86,486.37 223,575.00 223,575.00 21,193.05 36,000.00 231,500.00 _________ TOTAL 6 COMMUNITY & ECON DEV 9,527,872.33 1,698,136.00 3,449,336.00 3,244,253.81 1,634,860.16 12,487,066.00 _________ ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/22/2021 08:40User: ekwitmerProgram ID: bgnyrpts Page 7 PROJECTION: 20221 2022 PROPOSED BUDGET FOR PERIOD 99 7 DEBT SERVICE 2020 2021 2021 2021 2021 2022 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 03 DEBT SERVICE 19,742,904.25 5,587,000.00 5,587,000.00 4,475,253.44 5,652,000.00 6,570,677.00 _________ 17 HUMAN SERVICES BLDG 5,987.30 8,000.00 8,000.00 3,591.63 8,000.00 1,600.00 _________ 28 ADMIN ANNEX OCCUPAN 10,141.26 12,000.00 12,000.00 6,083.46 12,000.00 2,800.00 _________ TOTAL 7 DEBT SERVICE 19,759,032.81 5,607,000.00 5,607,000.00 4,484,928.53 5,672,000.00 6,575,077.00 _________ ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/22/2021 08:40User: ekwitmerProgram ID: bgnyrpts Page 8 PROJECTION: 20221 2022 PROPOSED BUDGET FOR PERIOD 99 8 MISCELLANEOUS 2020 2021 2021 2021 2021 2022 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 01 GENERAL GOVT OPERAT 1,835,305.91 957,008.00 1,031,499.00 234,928.04 283,500.00 2,087,370.00 _________ 12 RETIREMENT 8,365,371.06 8,910,312.00 8,910,312.00 7,569,127.79 9,025,829.00 9,387,715.00 _________ 24 WORKERS COMPENSATIO 659,560.97 1,736,288.00 1,736,288.00 617,911.94 750,604.00 1,427,823.00 _________ 27 POST EMP HEALTH BEN 788,023.20 835,000.00 835,000.00 634,307.84 754,300.00 859,000.00 _________ 30 SELF-FUNDED EMPLOYE 216,838.49 5,097,500.00 5,097,500.00 4,111,946.86 5,099,500.00 5,142,500.00 _________ 40 CAPITAL PROJECTS .00 930,500.00 930,500.00 153,782.75 153,783.00 231,644.00 _________ 41 RESERVE FOR REPLACE .00 500,564.00 430,499.00 .00 .00 184,249.00 _________ TOTAL 8 MISCELLANEOUS 11,865,099.63 18,967,172.00 18,971,598.00 13,322,005.22 16,067,516.00 19,320,301.00 _________ ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/22/2021 08:40User: ekwitmerProgram ID: bgnyrpts Page 9 PROJECTION: 20221 2022 PROPOSED BUDGET FOR PERIOD 99 9 OTHER FINANCING SOURCES 2020 2021 2021 2021 2021 2022 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 01 GENERAL GOVT OPERAT 5,358,362.64 5,730,982.00 5,730,982.00 3,335,149.41 4,176,236.00 6,100,122.00 _________ 40 CAPITAL PROJECTS .00 1,250,000.00 1,250,000.00 .00 1,250,000.00 1,250,000.00 _________ 41 RESERVE FOR REPLACE 16,508.00 .00 .00 .00 .00 .00 _________ 42 CAPITAL PROJECT COU .00 .00 .00 .00 70,000.00 100,000.00 _________ TOTAL 9 OTHER FINANCING SOUR 5,374,870.64 6,980,982.00 6,980,982.00 3,335,149.41 5,496,236.00 7,450,122.00 _________ TOTAL REVENUE .00 .00 .00 .00 .00 .00 _________ TOTAL EXPENSE 166,807,396.46 154,083,899.00 166,328,608.66 117,993,197.44 147,058,753.20 166,210,667.00 _________ GRAND TOTAL 166,807,396.46 154,083,899.00 166,328,608.66 117,993,197.44 147,058,753.20 166,210,667.00 _________ ** END OF REPORT - Generated by Erin K Witmer **