Loading...
HomeMy WebLinkAboutAll Funds - Expense by Function** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/17/2022 13:19User: ekwitmerProgram ID: bgnyrpts Page 1 PROJECTION: 20231 2023 PROPOSED BUDGET FOR PERIOD 99 1 GEN ADMIN AND JUDICIAL 2021 2022 2022 2022 2022 2023 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 01 GENERAL GOVT OPERAT 23,713,695.21 24,916,607.00 25,759,723.93 21,149,068.76 25,019,156.88 26,999,308.00 _________ 06 DOMESTIC RELATIONS 1,969,984.33 2,107,943.00 2,107,943.00 1,620,053.70 2,117,632.00 2,269,588.00 _________ 16 GEN ADMIN DIRECT SU 3,766,553.73 4,606,288.00 4,606,288.00 4,011,070.80 5,050,236.00 5,840,806.00 _________ 17 HUMAN SERVICES BLDG 403,316.69 435,316.00 435,316.00 345,225.18 463,269.00 515,270.00 _________ 28 ADMIN ANNEX OCCUPAN 345,856.22 330,153.00 341,480.00 283,063.87 366,577.00 397,149.00 _________ 40 CAPITAL PROJECTS 153,032.75 .00 .00 .00 .00 .00 _________ 41 RESERVE FOR REPLACE .00 .00 182,410.00 91,446.41 49,952.46 .00 _________ 42 CAPITAL PROJECT COU 16,187,710.58 13,550,000.00 13,501,232.03 1,612,352.68 1,639,716.00 10,000,000.00 _________ 80 SPECIAL REVENUE GRA 4,854,980.78 1,500,000.00 1,500,000.00 167,681.47 1,521,926.00 .00 _________ 88 SPECIAL REVENUE TRU 55,558.66 64,700.00 64,700.00 48,695.07 53,092.00 61,250.00 _________ TOTAL 1 GEN ADMIN AND JUDICI 51,450,688.95 47,511,007.00 48,499,092.96 29,328,657.94 36,281,557.34 46,083,371.00 _________ ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/17/2022 13:19User: ekwitmerProgram ID: bgnyrpts Page 2 PROJECTION: 20231 2023 PROPOSED BUDGET FOR PERIOD 99 2 PUBLIC SAFETY 2021 2022 2022 2022 2022 2023 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 01 GENERAL GOVT OPERAT 22,076,017.06 22,709,687.00 23,186,748.00 19,362,343.21 22,739,703.00 24,572,658.00 _________ 21 E 911 SERVICES 5,762,076.86 3,905,874.00 3,905,874.00 3,012,802.65 3,712,329.00 3,892,168.00 _________ 22 HAZARDOUS MATERIALS 202,281.00 190,925.00 200,194.00 170,104.68 207,058.00 173,436.00 _________ 41 RESERVE FOR REPLACE 34,075.00 .00 50,162.00 86,211.40 86,212.00 .00 _________ 80 SPECIAL REVENUE GRA 72,233.42 .00 .00 .00 .00 .00 _________ TOTAL 2 PUBLIC SAFETY 28,146,683.34 26,806,486.00 27,342,978.00 22,631,461.94 26,745,302.00 28,638,262.00 _________ ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/17/2022 13:19User: ekwitmerProgram ID: bgnyrpts Page 3 PROJECTION: 20231 2023 PROPOSED BUDGET FOR PERIOD 99 3 PUBLIC WORKS 2021 2022 2022 2022 2022 2023 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 01 GENERAL GOVT OPERAT 1,160.70 51,110.00 51,110.00 707.20 700.00 7,110.00 _________ 10 LIQUID FUELS TAXES 1,909,609.57 2,130,400.00 2,130,400.00 356,381.90 535,330.00 2,861,687.00 _________ 20 COMM DEVEL BLOCK GR 395,999.37 1,479,279.00 1,479,279.00 663,871.86 760,350.00 916,875.00 _________ TOTAL 3 PUBLIC WORKS 2,306,769.64 3,660,789.00 3,660,789.00 1,020,960.96 1,296,380.00 3,785,672.00 _________ ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/17/2022 13:19User: ekwitmerProgram ID: bgnyrpts Page 4 PROJECTION: 20231 2023 PROPOSED BUDGET FOR PERIOD 99 4 HUMAN SERVICES 2021 2022 2022 2022 2022 2023 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 04 AGING SERVICES PSA 4,231,324.43 5,357,287.00 5,357,287.00 3,352,586.06 3,945,650.17 4,737,563.00 _________ 05 CHILDREN & YOUTH SE 12,687,157.00 16,183,788.00 16,183,788.00 11,600,416.77 14,427,980.00 15,692,122.00 _________ 07 DRUG & ALCOHOL SCA 1,577,726.42 1,831,742.00 1,811,742.00 1,471,994.24 1,950,113.00 2,601,678.00 _________ 11 MENTAL HEALTH / EAR 6,393,343.10 7,012,963.00 6,899,803.00 5,572,091.91 7,276,564.00 7,120,610.00 _________ 31 HUMAN SERVICES ADMI 362,359.16 424,508.00 424,508.00 269,123.24 397,088.00 385,368.00 _________ 32 NON-CATEG HUMAN SER 471,027.89 455,712.00 742,835.00 780,315.60 849,185.00 1,042,932.00 _________ 34 INTELLECTUAL DISABI 1,117,218.09 1,038,275.00 1,038,275.00 857,490.23 1,174,109.00 1,252,361.00 _________ 35 COMMUNITY SERVICES 8,108,039.50 8,986,157.00 9,119,317.00 9,083,318.81 11,820,691.00 3,652,716.00 _________ 36 BH MANAGED CARE 654,597.30 752,838.00 752,838.00 600,919.93 708,738.00 829,242.00 _________ TOTAL 4 HUMAN SERVICES 35,602,792.89 42,043,270.00 42,330,393.00 33,588,256.79 42,550,118.17 37,314,592.00 _________ ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/17/2022 13:19User: ekwitmerProgram ID: bgnyrpts Page 5 PROJECTION: 20231 2023 PROPOSED BUDGET FOR PERIOD 99 5 CULTURE & RECREATION 2021 2022 2022 2022 2022 2023 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 01 GENERAL GOVT OPERAT 59,220.89 59,478.00 61,978.00 58,652.42 68,376.00 71,297.00 _________ 88 SPECIAL REVENUE TRU 262,988.30 274,535.00 274,535.00 266,763.51 275,997.00 682,000.00 _________ TOTAL 5 CULTURE & RECREATION 322,209.19 334,013.00 336,513.00 325,415.93 344,373.00 753,297.00 _________ ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/17/2022 13:19User: ekwitmerProgram ID: bgnyrpts Page 6 PROJECTION: 20231 2023 PROPOSED BUDGET FOR PERIOD 99 6 COMMUNITY & ECON DEVELOP 2021 2022 2022 2022 2022 2023 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 01 GENERAL GOVT OPERAT 346,972.09 483,392.00 545,102.00 336,789.05 406,364.00 500,498.00 _________ 33 TOURIST PROMOTION H 1,244,068.19 1,300,010.00 1,300,010.00 1,090,820.03 1,300,010.00 1,300,015.00 _________ 80 SPECIAL REVENUE GRA 1,878,386.36 10,500,000.00 10,500,000.00 .00 10,500,000.00 10,000,000.00 _________ 88 SPECIAL REVENUE TRU 77,341.40 231,500.00 231,500.00 58,575.65 79,000.00 269,000.00 _________ TOTAL 6 COMMUNITY & ECON DEV 3,546,768.04 12,514,902.00 12,576,612.00 1,486,184.73 12,285,374.00 12,069,513.00 _________ ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/17/2022 13:19User: ekwitmerProgram ID: bgnyrpts Page 7 PROJECTION: 20231 2023 PROPOSED BUDGET FOR PERIOD 99 7 DEBT SERVICE 2021 2022 2022 2022 2022 2023 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 03 DEBT SERVICE 5,581,213.44 6,570,677.00 6,570,677.00 5,293,691.32 6,499,177.00 6,864,500.00 _________ 17 HUMAN SERVICES BLDG 4,092.21 1,600.00 1,600.00 1,126.31 1,600.00 .00 _________ 28 ADMIN ANNEX OCCUPAN 6,931.34 2,800.00 2,800.00 1,907.73 2,800.00 .00 _________ TOTAL 7 DEBT SERVICE 5,592,236.99 6,575,077.00 6,575,077.00 5,296,725.36 6,503,577.00 6,864,500.00 _________ ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/17/2022 13:19User: ekwitmerProgram ID: bgnyrpts Page 8 PROJECTION: 20231 2023 PROPOSED BUDGET FOR PERIOD 99 8 MISCELLANEOUS 2021 2022 2022 2022 2022 2023 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 01 GENERAL GOVT OPERAT 283,580.13 2,087,370.00 1,231,082.00 216,637.91 271,000.00 1,038,515.00 _________ 12 RETIREMENT 9,121,064.66 9,387,715.00 9,387,715.00 8,068,869.78 9,351,152.25 9,982,798.00 _________ 24 WORKERS COMPENSATIO 667,926.51 1,427,823.00 1,427,823.00 483,037.75 885,251.60 1,126,123.00 _________ 27 POST EMP HEALTH BEN 734,547.41 859,000.00 859,000.00 647,086.25 745,980.00 809,000.00 _________ 30 SELF-FUNDED EMPLOYE 5,464,720.35 5,142,500.00 5,142,500.00 3,568,404.75 5,273,500.00 5,538,500.00 _________ 40 CAPITAL PROJECTS 750.00 231,644.00 231,644.00 12,406.33 12,406.00 100,000.00 _________ 41 RESERVE FOR REPLACE .00 184,249.00 -48,323.00 .00 .00 304,100.00 _________ 80 SPECIAL REVENUE GRA .00 .00 .00 .00 .00 3,971,672.00 _________ TOTAL 8 MISCELLANEOUS 16,272,589.06 19,320,301.00 18,231,441.00 12,996,442.77 16,539,289.85 22,870,708.00 _________ ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/17/2022 13:19User: ekwitmerProgram ID: bgnyrpts Page 9 PROJECTION: 20231 2023 PROPOSED BUDGET FOR PERIOD 99 9 OTHER FINANCING SOURCES 2021 2022 2022 2022 2022 2023 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 01 GENERAL GOVT OPERAT 4,158,307.90 6,100,122.00 6,536,861.00 5,005,019.39 5,424,742.00 7,079,566.00 _________ 40 CAPITAL PROJECTS .00 1,250,000.00 1,250,000.00 .00 .00 .00 _________ 42 CAPITAL PROJECT COU 141,965.98 100,000.00 100,000.00 .00 .00 105,000.00 _________ 80 SPECIAL REVENUE GRA .00 .00 .00 600,000.00 600,000.00 4,400,000.00 _________ TOTAL 9 OTHER FINANCING SOUR 4,300,273.88 7,450,122.00 7,886,861.00 5,605,019.39 6,024,742.00 11,584,566.00 _________ TOTAL REVENUE .00 .00 .00 .00 .00 .00 _________ TOTAL EXPENSE 147,541,011.98 166,215,967.00 167,439,756.96 112,279,125.81 148,570,713.36 169,964,481.00 _________ GRAND TOTAL 147,541,011.98 166,215,967.00 167,439,756.96 112,279,125.81 148,570,713.36 169,964,481.00 _________ ** END OF REPORT - Generated by Erin K Witmer **