Loading...
HomeMy WebLinkAboutAll Funds - Expense by Function** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/17/2023 14:44User: ekwitmerProgram ID: bgnyrpts Page 1 PROJECTION: 20241 2024 BUDGET FOR PERIOD 99 1 GEN ADMIN AND JUDICIAL 2022 2023 2023 2023 2023 2024 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 01 GENERAL GOVT OPERAT 24,595,680.64 26,998,602.00 27,627,404.44 22,699,732.26 26,026,827.83 27,182,524.00 _________ 06 DOMESTIC RELATIONS 1,882,808.08 2,269,588.00 2,269,588.00 1,788,490.16 2,297,440.00 2,189,351.00 _________ 16 GEN ADMIN DIRECT SU 4,751,210.84 5,840,806.00 5,790,795.28 5,343,604.29 5,502,232.33 6,533,535.00 _________ 17 HUMAN SERVICES BLDG 425,414.33 515,270.00 515,270.00 352,921.79 -7,795.00 425,979.00 _________ 28 ADMIN ANNEX OCCUPAN 346,731.16 397,149.00 394,360.06 273,979.38 387,312.00 288,511.00 _________ 40 CAPITAL PROJECTS 8,187.50 .00 .00 43,724.92 .00 .00 _________ 41 RESERVE FOR REPLACE 49,951.76 .00 109,306.00 256,824.61 188,174.07 .00 _________ 42 CAPITAL PROJECT COU 1,741,656.81 10,000,000.00 9,935,642.08 5,841,103.95 10,064,357.92 11,000,000.00 _________ 80 SPECIAL REVENUE GRA 582,540.64 .00 .00 98,807.00 .00 1,275,000.00 _________ 88 SPECIAL REVENUE TRU 38,634.75 61,250.00 61,250.00 54,237.86 60,867.00 73,400.00 _________ TOTAL 1 GEN ADMIN AND JUDICI 34,422,816.51 46,082,665.00 46,703,615.86 36,753,426.22 44,519,416.15 48,968,300.00 _________ ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/17/2023 14:44User: ekwitmerProgram ID: bgnyrpts Page 2 PROJECTION: 20241 2024 BUDGET FOR PERIOD 99 2 PUBLIC SAFETY 2022 2023 2023 2023 2023 2024 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 01 GENERAL GOVT OPERAT 22,163,188.13 24,572,658.00 23,834,713.23 20,084,682.41 24,175,578.35 22,632,038.00 _________ 21 E 911 SERVICES 3,426,020.12 3,892,168.00 3,892,168.00 2,976,520.00 3,701,147.00 4,495,652.00 _________ 22 HAZARDOUS MATERIALS 189,838.55 173,436.00 173,436.00 132,359.76 145,429.00 163,675.00 _________ 41 RESERVE FOR REPLACE 68,700.00 .00 48,092.00 65,603.40 65,603.00 .00 _________ 80 SPECIAL REVENUE GRA .00 .00 529,900.00 527,873.44 .00 .00 _________ TOTAL 2 PUBLIC SAFETY 25,847,746.80 28,638,262.00 28,478,309.23 23,787,039.01 28,087,757.35 27,291,365.00 _________ ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/17/2023 14:44User: ekwitmerProgram ID: bgnyrpts Page 3 PROJECTION: 20241 2024 BUDGET FOR PERIOD 99 3 PUBLIC WORKS 2022 2023 2023 2023 2023 2024 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 01 GENERAL GOVT OPERAT 710.08 7,110.00 7,110.00 713.20 720.00 1,020.00 _________ 10 LIQUID FUELS TAXES 466,322.45 2,861,687.00 2,861,687.00 492,885.52 848,889.00 4,702,817.00 _________ 20 COMM DEVEL BLOCK GR 713,092.44 916,875.00 907,395.00 61,645.85 88,693.00 980,823.00 _________ TOTAL 3 PUBLIC WORKS 1,180,124.97 3,785,672.00 3,776,192.00 555,244.57 938,302.00 5,684,660.00 _________ ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/17/2023 14:44User: ekwitmerProgram ID: bgnyrpts Page 4 PROJECTION: 20241 2024 BUDGET FOR PERIOD 99 4 HUMAN SERVICES 2022 2023 2023 2023 2023 2024 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 04 AGING SERVICES PSA 3,856,543.25 4,737,563.00 4,754,563.00 4,081,263.33 4,933,972.00 4,792,963.00 _________ 05 CHILDREN & YOUTH SE 14,045,313.65 15,692,122.00 15,692,110.66 12,876,722.28 16,670,787.22 16,687,822.00 _________ 07 DRUG & ALCOHOL SCA 1,824,122.66 2,601,678.00 2,601,678.00 1,790,693.97 2,185,355.00 2,789,785.00 _________ 11 MENTAL HEALTH / EAR 6,950,506.24 7,120,610.00 7,102,610.00 5,567,220.57 6,941,033.00 7,459,734.00 _________ 31 HUMAN SERVICES ADMI 307,279.13 385,368.00 385,368.00 274,663.43 359,994.00 334,272.00 _________ 32 NON-CATEG HUMAN SER 931,824.79 1,042,932.00 1,042,932.00 734,871.68 1,077,672.63 1,118,885.00 _________ 34 INTELLECTUAL DISABI 1,032,103.19 1,252,361.00 1,236,288.74 946,093.07 1,237,331.00 1,199,461.00 _________ 35 COMMUNITY SERVICES 11,276,895.64 3,652,716.00 3,685,716.00 1,425,148.35 2,535,018.00 1,830,555.00 _________ 36 BH MANAGED CARE 738,235.67 829,242.00 829,242.00 646,099.40 821,910.00 798,433.00 _________ 88 SPECIAL REVENUE TRU .00 .00 .00 .00 .00 780,370.00 _________ TOTAL 4 HUMAN SERVICES 40,962,824.22 37,314,592.00 37,330,508.40 28,342,776.08 36,763,072.85 37,792,280.00 _________ ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/17/2023 14:44User: ekwitmerProgram ID: bgnyrpts Page 5 PROJECTION: 20241 2024 BUDGET FOR PERIOD 99 5 CULTURE & RECREATION 2022 2023 2023 2023 2023 2024 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 01 GENERAL GOVT OPERAT 68,368.20 71,297.00 71,297.00 65,284.36 74,621.00 75,865.00 _________ 80 SPECIAL REVENUE GRA .00 .00 .00 .00 .00 1,015,600.00 _________ 88 SPECIAL REVENUE TRU 277,873.51 682,000.00 682,000.00 88,045.43 90,843.00 1,137,778.00 _________ TOTAL 5 CULTURE & RECREATION 346,241.71 753,297.00 753,297.00 153,329.79 165,464.00 2,229,243.00 _________ ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/17/2023 14:44User: ekwitmerProgram ID: bgnyrpts Page 6 PROJECTION: 20241 2024 BUDGET FOR PERIOD 99 6 COMMUNITY & ECON DEVELOP 2022 2023 2023 2023 2023 2024 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 01 GENERAL GOVT OPERAT 383,205.05 500,498.00 509,672.00 339,917.19 428,096.00 430,930.00 _________ 33 TOURIST PROMOTION H 1,420,352.59 1,300,015.00 1,300,015.00 1,157,168.97 1,503,000.00 1,503,000.00 _________ 80 SPECIAL REVENUE GRA 50,497.50 10,000,000.00 8,085,675.00 9,946,641.03 10,000,000.00 4,777,291.00 _________ 88 SPECIAL REVENUE TRU 155,873.39 269,000.00 269,000.00 128,293.56 184,018.00 317,000.00 _________ TOTAL 6 COMMUNITY & ECON DEV 2,009,928.53 12,069,513.00 10,164,362.00 11,572,020.75 12,115,114.00 7,028,221.00 _________ ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/17/2023 14:44User: ekwitmerProgram ID: bgnyrpts Page 7 PROJECTION: 20241 2024 BUDGET FOR PERIOD 99 7 DEBT SERVICE 2022 2023 2023 2023 2023 2024 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 03 DEBT SERVICE 6,493,951.32 6,864,500.00 6,864,500.00 5,606,638.18 6,864,500.00 7,321,400.00 _________ 04 AGING SERVICES PSA 490,467.59 .00 .00 .00 .00 .00 _________ 05 CHILDREN & YOUTH SE 12,407.35 .00 .00 .00 .00 .00 _________ 06 DOMESTIC RELATIONS 20,935.87 .00 .00 .00 .00 .00 _________ 07 DRUG & ALCOHOL SCA 2,701.99 .00 .00 .00 .00 .00 _________ 11 MENTAL HEALTH / EAR 1,945.24 .00 .00 .00 .00 .00 _________ 16 GEN ADMIN DIRECT SU 124.61 .00 .00 .00 .00 .00 _________ 17 HUMAN SERVICES BLDG 1,122.10 .00 .00 .00 .00 .00 _________ 21 E 911 SERVICES 1,810,513.10 .00 .00 .00 .00 .00 _________ 22 HAZARDOUS MATERIALS 444.77 .00 .00 .00 .00 .00 _________ 28 ADMIN ANNEX OCCUPAN 1,909.93 .00 .00 .00 .00 .00 _________ 31 HUMAN SERVICES ADMI 34.35 .00 .00 .00 .00 .00 _________ 34 INTELLECTUAL DISABI 1,367.52 .00 .00 .00 .00 .00 _________ TOTAL 7 DEBT SERVICE 8,837,925.74 6,864,500.00 6,864,500.00 5,606,638.18 6,864,500.00 7,321,400.00 _________ ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/17/2023 14:44User: ekwitmerProgram ID: bgnyrpts Page 8 PROJECTION: 20241 2024 BUDGET FOR PERIOD 99 8 MISCELLANEOUS 2022 2023 2023 2023 2023 2024 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 01 GENERAL GOVT OPERAT 265,804.58 1,038,515.00 372,595.89 214,683.33 481,083.00 1,344,970.00 _________ 12 RETIREMENT 9,623,514.54 9,982,798.00 9,982,798.00 8,950,044.48 10,088,109.85 10,761,563.00 _________ 24 WORKERS COMPENSATIO 840,483.58 1,126,123.00 1,099,406.45 816,921.22 1,219,295.65 3,023,517.00 _________ 27 POST EMP HEALTH BEN 733,072.67 809,000.00 809,000.00 692,809.50 809,000.00 815,000.00 _________ 30 SELF-FUNDED EMPLOYE 4,553,369.70 5,538,500.00 5,538,500.00 3,821,486.68 4,963,500.00 5,445,000.00 _________ 40 CAPITAL PROJECTS 12,406.33 100,000.00 100,000.00 3,500.00 100,000.00 1,500,000.00 _________ 41 RESERVE FOR REPLACE .00 304,100.00 129,190.60 .00 31,360.00 3,095,029.00 _________ 80 SPECIAL REVENUE GRA .00 3,971,672.00 1,441,772.00 .00 3,971,672.00 .00 _________ TOTAL 8 MISCELLANEOUS 16,028,651.40 22,870,708.00 19,473,262.94 14,499,445.21 21,664,020.50 25,985,079.00 _________ ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/17/2023 14:44User: ekwitmerProgram ID: bgnyrpts Page 9 PROJECTION: 20241 2024 BUDGET FOR PERIOD 99 9 OTHER FINANCING SOURCES 2022 2023 2023 2023 2023 2024 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 01 GENERAL GOVT OPERAT 5,733,691.18 7,079,566.00 6,279,566.00 4,861,980.50 5,965,016.00 6,370,860.00 _________ 28 ADMIN ANNEX OCCUPAN .00 .00 .00 .00 .00 8,000.00 _________ 42 CAPITAL PROJECT COU .00 105,000.00 105,000.00 209,124.06 105,000.00 175,000.00 _________ 80 SPECIAL REVENUE GRA 2,200,000.00 4,400,000.00 3,800,000.00 1,422,051.00 4,400,000.00 2,300,000.00 _________ TOTAL 9 OTHER FINANCING SOUR 7,933,691.18 11,584,566.00 10,184,566.00 6,493,155.56 10,470,016.00 8,853,860.00 _________ TOTAL REVENUE .00 .00 .00 .00 .00 .00 _________ TOTAL EXPENSE 137,569,951.06 169,963,775.00 163,728,613.43 127,763,075.37 161,587,662.85 171,154,408.00 _________ GRAND TOTAL 137,569,951.06 169,963,775.00 163,728,613.43 127,763,075.37 161,587,662.85 171,154,408.00 _________ ** END OF REPORT - Generated by Erin K Witmer ** ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/17/2023 14:44User: ekwitmerProgram ID: bgnyrpts Page 10 PROJECTION: 20241 2024 BUDGET FOR PERIOD 99 9 OTHER FINANCING SOURCES 2022 2023 2023 2023 2023 2024 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT Field # Total Page Break Sequence 1 3 Y Y Sequence 2 1 Y N Sequence 3 0 N N Sequence 4 0 N N Report title: 11/17/2023 14:44 |** Live Database ** |P ekwitmer |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrp PROJECTION: 20241 2024 BUDGET FOR PERIOD 99 Report type: 1 Budget level: 4 Percentage change calculation method: 4 Print first or second year of budget requests: F Print revenue as credit: Y Include cfwd in rev bud: N Include cfwd in actuals: N Print totals only: Y Include segment code: Y Include report grand totals by account type: Y Print full GL account: N Double space: N Suppress zero bdgt accts: Y Print as worksheet: N Print percent change or comment: C Print text: N Amounts/totals exceed 999 million dollars: Y Print five budget levels: N Report view: D Find Criteria Field Name Field Value Org Object Project Account type Expense Account status