Loading...
HomeMy WebLinkAboutAll Funds - Revenue by Source** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/17/2023 14:36User: ekwitmerProgram ID: bgnyrpts Page 1 PROJECTION: 20241 2024 BUDGET FOR PERIOD 99 03 RE/LBRY/HOTEL TAXES 2022 2023 2023 2023 2023 2024 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 01 GENERAL GOVT OPERAT -38,822,874.78 -39,419,100.00 -39,419,100.00 -39,208,559.71 -39,564,100.00 -40,317,250.00 _________ 03 DEBT SERVICE -6,373,630.99 -6,441,000.00 -6,441,000.00 -6,363,448.92 -6,406,000.00 -6,562,840.00 _________ 33 TOURIST PROMOTION H -1,420,297.41 -1,300,000.00 -1,300,000.00 -1,215,254.45 -1,500,000.00 -1,500,000.00 _________ TOTAL 03 RE/LBRY/HOTEL TAXES -46,616,803.18 -47,160,100.00 -47,160,100.00 -46,787,263.08 -47,470,100.00 -48,380,090.00 _________ ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/17/2023 14:36User: ekwitmerProgram ID: bgnyrpts Page 2 PROJECTION: 20241 2024 BUDGET FOR PERIOD 99 04 INTEREST 2022 2023 2023 2023 2023 2024 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 01 GENERAL GOVT OPERAT -354,059.09 -418,150.00 -418,150.00 -1,230,282.60 -1,489,456.00 -1,234,914.00 _________ 03 DEBT SERVICE -12,380.46 -3,000.00 -3,000.00 -61,945.91 -60,000.00 -60,000.00 _________ 04 AGING SERVICES PSA .00 .00 .00 -25,795.69 -63,651.00 -66,000.00 _________ 05 CHILDREN & YOUTH SE 14.84 .00 .00 .00 .00 .00 _________ 06 DOMESTIC RELATIONS -931.41 -8,000.00 -8,000.00 -82,885.61 -110,000.00 -110,000.00 _________ 07 DRUG & ALCOHOL SCA -1,212.34 -335.00 -335.00 -14,109.50 -335.00 -20,000.00 _________ 10 LIQUID FUELS TAXES -16,103.92 -3,500.00 -3,500.00 -176,490.12 -228,000.00 -100,000.00 _________ 11 MENTAL HEALTH / EAR -18,861.79 -2,750.00 -2,750.00 -143,845.05 -173,757.00 -135,000.00 _________ 12 RETIREMENT -2,773,564.10 -2,144,295.00 -2,144,295.00 -1,346,602.00 -1,528,417.28 -1,591,108.00 _________ 22 HAZARDOUS MATERIALS -11.34 -25.00 -25.00 -1,087.56 -1,200.00 -800.00 _________ 24 WORKERS COMPENSATIO -77,998.46 -70,000.00 -70,000.00 -188,506.59 -70,000.00 -70,000.00 _________ 27 POST EMP HEALTH BEN -300,662.79 -300,000.00 -300,000.00 -259,993.02 -340,000.00 -350,000.00 _________ 30 SELF-FUNDED EMPLOYE -271.52 -220.00 -220.00 -29,161.77 -25,055.00 -20,055.00 _________ 33 TOURIST PROMOTION H -29.05 -15.00 -15.00 -2,807.24 -3,000.00 -3,000.00 _________ 34 INTELLECTUAL DISABI -2,305.86 -450.00 -450.00 -13,306.06 -18,310.00 -14,000.00 _________ ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/17/2023 14:36User: ekwitmerProgram ID: bgnyrpts Page 3 PROJECTION: 20241 2024 BUDGET FOR PERIOD 99 04 INTEREST 2022 2023 2023 2023 2023 2024 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 35 COMMUNITY SERVICES -9,119.00 -4,000.00 -4,000.00 -11,704.21 -3,963.00 -4,000.00 _________ 36 BH MANAGED CARE -3,585.34 .00 .00 .00 .00 .00 _________ 42 CAPITAL PROJECT COU -13,071.82 -8,500.00 -8,500.00 -56,060.92 -8,500.00 -10,000.00 _________ 80 SPECIAL REVENUE GRA .00 .00 .00 -123,224.05 .00 .00 _________ 88 SPECIAL REVENUE TRU -7,158.31 -5,200.00 -5,200.00 -97,664.52 -105,000.00 -70,000.00 _________ TOTAL 04 INTEREST -3,591,311.76 -2,968,440.00 -2,968,440.00 -3,865,472.42 -4,228,644.28 -3,858,877.00 _________ ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/17/2023 14:36User: ekwitmerProgram ID: bgnyrpts Page 4 PROJECTION: 20241 2024 BUDGET FOR PERIOD 99 05 I/GOVT REV - FEDERAL 2022 2023 2023 2023 2023 2024 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 01 GENERAL GOVT OPERAT -667,298.42 -877,360.00 -1,052,562.00 -586,804.20 -883,340.00 -1,052,250.00 _________ 04 AGING SERVICES PSA -813,822.00 -1,313,568.00 -1,313,568.00 -931,289.10 -889,423.00 -1,219,893.00 _________ 05 CHILDREN & YOUTH SE -2,650,251.55 -2,969,802.00 -2,969,802.00 -2,223,850.94 -2,869,344.00 -2,712,002.00 _________ 06 DOMESTIC RELATIONS -1,495,670.61 -1,571,000.00 -1,571,000.00 -861,046.44 -1,571,000.00 -1,540,500.00 _________ 07 DRUG & ALCOHOL SCA -813,053.57 -1,352,449.00 -1,352,449.00 -1,003,304.52 -1,352,449.00 -1,006,373.00 _________ 10 LIQUID FUELS TAXES -91,185.53 -1,068,000.00 -1,068,000.00 -40,040.74 -241,000.00 -953,000.00 _________ 11 MENTAL HEALTH / EAR -540,860.28 -577,391.00 -577,391.00 -529,811.25 -541,985.00 -806,169.00 _________ 20 COMM DEVEL BLOCK GR -716,039.39 -1,078,053.00 -1,078,053.00 -102,657.23 -105,250.00 -980,823.00 _________ 22 HAZARDOUS MATERIALS -19,385.63 -12,894.00 -12,894.00 -6,390.42 -6,906.00 -8,690.00 _________ 32 NON-CATEG HUMAN SER -760,484.41 -729,100.00 -726,100.00 -420,261.99 -729,100.00 -592,249.00 _________ 34 INTELLECTUAL DISABI -341,353.57 -386,319.00 -386,319.00 -296,323.91 -322,905.00 -328,661.00 _________ 35 COMMUNITY SERVICES -10,891,314.99 -3,199,030.00 -3,199,030.00 -2,193,394.36 -1,986,789.00 -1,346,000.00 _________ 41 RESERVE FOR REPLACE -47,665.25 .00 .00 .00 .00 .00 _________ 80 SPECIAL REVENUE GRA -7,987,017.24 -8,000,000.00 -14,900,000.00 -14,436,069.14 -14,900,000.00 -1,600,000.00 _________ TOTAL 05 I/GOVT REV - FEDERA -27,835,402.44 -23,134,966.00 -30,207,168.00 -23,631,244.24 -26,399,491.00 -14,146,610.00 _________ ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/17/2023 14:36User: ekwitmerProgram ID: bgnyrpts Page 5 PROJECTION: 20241 2024 BUDGET FOR PERIOD 99 06 I/GOVT REV - STATE 2022 2023 2023 2023 2023 2024 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 01 GENERAL GOVT OPERAT -2,000,083.57 -1,691,130.00 -1,909,500.11 -1,245,250.21 -2,060,863.00 -2,081,028.00 _________ 04 AGING SERVICES PSA -2,672,299.00 -2,878,674.00 -2,878,674.00 -2,448,292.88 -2,893,845.00 -3,045,663.00 _________ 05 CHILDREN & YOUTH SE -8,508,332.02 -9,582,053.00 -9,582,053.00 -7,386,563.15 -9,879,800.00 -10,225,260.00 _________ 07 DRUG & ALCOHOL SCA -798,099.56 -732,948.00 -732,948.00 -584,298.72 -732,948.00 -724,566.00 _________ 10 LIQUID FUELS TAXES -758,257.41 -730,000.00 -730,000.00 -516,953.37 -794,077.00 -757,000.00 _________ 11 MENTAL HEALTH / EAR -6,132,095.03 -6,286,044.00 -6,268,044.00 -5,940,490.91 -5,982,908.00 -6,261,565.00 _________ 21 E 911 SERVICES -3,257,871.54 -3,250,000.00 -3,250,000.00 -2,503,560.54 -3,787,761.00 -3,808,504.00 _________ 22 HAZARDOUS MATERIALS -34,941.73 -27,704.00 -27,704.00 -17,900.32 -19,484.00 -25,418.00 _________ 34 INTELLECTUAL DISABI -661,106.63 -819,472.00 -804,472.00 -762,772.64 -866,698.00 -815,000.00 _________ 35 COMMUNITY SERVICES -277,494.94 -328,769.00 -361,769.00 -346,826.32 -280,139.00 -344,048.00 _________ 40 CAPITAL PROJECTS -6,050.00 .00 .00 .00 .00 .00 _________ 42 CAPITAL PROJECT COU -37,500.00 .00 .00 .00 .00 -500,000.00 _________ 80 SPECIAL REVENUE GRA .00 .00 -85,675.00 .00 -85,675.00 -675,000.00 _________ 88 SPECIAL REVENUE TRU -184,637.66 -195,000.00 -195,000.00 -186,563.98 -186,564.00 -220,000.00 _________ TOTAL 06 I/GOVT REV - STATE -25,328,769.09 -26,521,794.00 -26,825,839.11 -21,939,473.04 -27,570,762.00 -29,483,052.00 _________ ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/17/2023 14:36User: ekwitmerProgram ID: bgnyrpts Page 6 PROJECTION: 20241 2024 BUDGET FOR PERIOD 99 07 CHARGES FOR SERVICE 2022 2023 2023 2023 2023 2024 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 01 GENERAL GOVT OPERAT -7,546,149.35 -8,535,870.00 -8,405,870.00 -6,345,830.68 -7,566,904.25 -8,051,654.00 _________ 04 AGING SERVICES PSA -114,918.13 -155,321.00 -155,321.00 -38,610.16 -165,321.00 -206,407.00 _________ 05 CHILDREN & YOUTH SE -117,469.08 -200,000.00 -200,000.00 -112,542.00 -141,010.00 -140,000.00 _________ 06 DOMESTIC RELATIONS -14,402.17 -21,500.00 -21,500.00 -11,677.66 -13,200.00 -14,000.00 _________ 07 DRUG & ALCOHOL SCA -126,287.94 -154,816.00 -154,816.00 -153,877.53 -154,816.00 -177,141.00 _________ 10 LIQUID FUELS TAXES -12,195.76 -5,000.00 -5,000.00 -8,002.69 -8,003.00 -15,000.00 _________ 11 MENTAL HEALTH / EAR -20,734.92 -21,075.00 -21,075.00 -16,922.00 -22,465.00 -22,500.00 _________ 12 RETIREMENT -4,361,701.40 -4,716,000.00 -4,716,000.00 -5,187,544.31 -5,617,153.40 -5,808,200.00 _________ 16 GEN ADMIN DIRECT SU -4,454,904.86 -5,755,806.00 -5,755,806.00 -4,785,198.09 -5,737,927.00 -6,501,525.00 _________ 17 HUMAN SERVICES BLDG -207,783.96 -515,270.00 -515,270.00 -355,302.83 -515,270.00 -425,979.00 _________ 22 HAZARDOUS MATERIALS -71,083.32 -59,300.00 -59,300.00 -43,797.05 -44,600.00 -51,500.00 _________ 24 WORKERS COMPENSATIO -1,405,550.74 -1,363,000.00 -1,363,000.00 -1,211,422.37 -1,363,000.00 -1,303,000.00 _________ 27 POST EMP HEALTH BEN -89,889.50 -150,000.00 -150,000.00 -78,977.60 -87,000.00 -150,000.00 _________ 28 ADMIN ANNEX OCCUPAN -267,747.57 -397,149.00 -397,149.00 -284,545.81 -397,149.00 -296,511.00 _________ 30 SELF-FUNDED EMPLOYE -5,098,608.17 -5,482,000.00 -5,482,000.00 -4,475,148.32 -5,277,400.00 -5,283,000.00 _________ ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/17/2023 14:36User: ekwitmerProgram ID: bgnyrpts Page 7 PROJECTION: 20241 2024 BUDGET FOR PERIOD 99 07 CHARGES FOR SERVICE 2022 2023 2023 2023 2023 2024 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 31 HUMAN SERVICES ADMI -305,281.33 -385,368.00 -385,368.00 -240,354.75 -304,495.00 -334,272.00 _________ 32 NON-CATEG HUMAN SER -25,049.11 -54,500.00 -54,500.00 -51,098.37 -54,500.00 -60,029.00 _________ 34 INTELLECTUAL DISABI -680.06 -1,300.00 -1,300.00 -274.78 -1,300.00 -800.00 _________ 36 BH MANAGED CARE -701,423.51 -829,242.00 -829,242.00 -544,053.61 -740,000.00 -697,382.00 _________ 88 SPECIAL REVENUE TRU -133,406.00 -139,000.00 -139,000.00 -90,311.00 -106,000.00 -113,000.00 _________ TOTAL 07 CHARGES FOR SERVICE -25,075,266.88 -28,941,517.00 -28,811,517.00 -24,035,491.61 -28,317,513.65 -29,651,900.00 _________ ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/17/2023 14:36User: ekwitmerProgram ID: bgnyrpts Page 8 PROJECTION: 20241 2024 BUDGET FOR PERIOD 99 08 CONTRIBTNS / OTHER 2022 2023 2023 2023 2023 2024 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 01 GENERAL GOVT OPERAT 203,024.62 -851,273.00 -863,167.00 -828,850.47 -884,645.00 -905,409.00 _________ 04 AGING SERVICES PSA -356,290.18 -20,000.00 -41,000.00 -50,516.88 -30,906.00 -25,000.00 _________ 05 CHILDREN & YOUTH SE -35,224.18 -2,909.00 -2,909.00 -13,352.05 -26,596.00 -3,000.00 _________ 06 DOMESTIC RELATIONS -12,845.00 .00 .00 .00 .00 .00 _________ 07 DRUG & ALCOHOL SCA -30,058.62 -300,130.00 -300,130.00 19,447.46 -300,130.00 -26,059.00 _________ 10 LIQUID FUELS TAXES .00 .00 .00 -5,250.00 -10,500.00 .00 _________ 11 MENTAL HEALTH / EAR -6,217.81 -4,370.00 -4,370.00 -12,814.04 -12,611.00 -4,500.00 _________ 12 RETIREMENT 22,351,755.57 -4,200,500.00 -4,200,500.00 -12,994,184.44 -15,525,342.42 -16,140,000.00 _________ 16 GEN ADMIN DIRECT SU -19,506.10 .00 .00 -74,897.09 -74,900.00 -32,010.00 _________ 21 E 911 SERVICES -1,643,384.58 .00 .00 -28.04 -28.00 .00 _________ 22 HAZARDOUS MATERIALS -2,760.50 .00 .00 -793.18 -800.00 .00 _________ 24 WORKERS COMPENSATIO 102,255.79 -40,750.00 -40,750.00 -4,496.54 -40,750.00 -40,750.00 _________ 27 POST EMP HEALTH BEN 2,215,785.64 -2,500,000.00 -2,500,000.00 30,821.27 -2,500,000.00 -2,500,000.00 _________ 32 NON-CATEG HUMAN SER -17,270.68 -44,693.00 -47,693.00 700.09 -44,693.00 .00 _________ 34 INTELLECTUAL DISABI -795.00 .00 .00 .00 .00 .00 _________ ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/17/2023 14:36User: ekwitmerProgram ID: bgnyrpts Page 9 PROJECTION: 20241 2024 BUDGET FOR PERIOD 99 08 CONTRIBTNS / OTHER 2022 2023 2023 2023 2023 2024 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 35 COMMUNITY SERVICES -22,360.43 -33,900.00 -33,900.00 -70,959.67 -58,394.00 -40,500.00 _________ 36 BH MANAGED CARE -33,226.82 .00 .00 -36,076.99 .00 -41,813.00 _________ 42 CAPITAL PROJECT COU .00 -10,000,000.00 -10,000,000.00 -9,997,595.65 -10,000,000.00 -5,000,000.00 _________ 80 SPECIAL REVENUE GRA .00 .00 .00 -51,949.61 -149,436.00 -288,000.00 _________ 88 SPECIAL REVENUE TRU -936,604.25 -330,000.00 -330,000.00 -258,362.51 -753,950.00 -570,000.00 _________ TOTAL 08 CONTRIBTNS / OTHER 21,756,277.47 -18,328,525.00 -18,364,419.00 -24,349,158.34 -30,413,681.42 -25,617,041.00 _________ ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/17/2023 14:36User: ekwitmerProgram ID: bgnyrpts Page 10 PROJECTION: 20241 2024 BUDGET FOR PERIOD 99 09 TRANSFERS IN 2022 2023 2023 2023 2023 2024 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 01 GENERAL GOVT OPERAT -2,793,356.44 -4,400,000.00 -3,819,183.15 -1,369,183.15 -1,370,000.00 -1,736,026.00 _________ 04 AGING SERVICES PSA -389,681.53 -370,000.00 -370,000.00 -172,492.92 -227,050.00 -230,000.00 _________ 05 CHILDREN & YOUTH SE -2,746,459.01 -2,937,358.00 -2,937,358.00 -2,299,068.03 -3,123,535.00 -3,607,560.00 _________ 06 DOMESTIC RELATIONS -623,787.37 -939,088.00 -939,088.00 -782,573.30 -939,088.00 -764,851.00 _________ 07 DRUG & ALCOHOL SCA -58,112.92 -61,000.00 -61,000.00 -43,311.36 -58,500.00 -835,646.00 _________ 10 LIQUID FUELS TAXES .00 -800,000.00 .00 .00 .00 -800,000.00 _________ 11 MENTAL HEALTH / EAR -233,681.65 -228,980.00 -228,980.00 -164,916.28 -223,000.00 -230,000.00 _________ 16 GEN ADMIN DIRECT SU -2,511.82 -85,000.00 -85,000.00 .00 .00 .00 _________ 20 COMM DEVEL BLOCK GR 2,946.95 .00 .00 .00 .00 .00 _________ 21 E 911 SERVICES -335,277.10 -642,168.00 -642,168.00 -453,112.00 -441,008.00 -687,148.00 _________ 22 HAZARDOUS MATERIALS -62,100.80 -73,513.00 -73,513.00 -60,177.60 -77,285.00 -77,267.00 _________ 30 SELF-FUNDED EMPLOYE -116,985.82 -140,000.00 -140,000.00 -84,072.50 -85,000.00 -85,000.00 _________ 32 NON-CATEG HUMAN SER -129,020.59 -214,639.00 -214,639.00 -108,791.53 -214,639.00 -466,607.00 _________ 34 INTELLECTUAL DISABI -27,229.58 -44,820.00 -44,820.00 -30,360.42 -35,000.00 -41,000.00 _________ 35 COMMUNITY SERVICES -76,606.52 -87,017.00 -87,017.00 -15,831.13 -76,789.00 -96,007.00 _________ ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/17/2023 14:36User: ekwitmerProgram ID: bgnyrpts Page 11 PROJECTION: 20241 2024 BUDGET FOR PERIOD 99 09 TRANSFERS IN 2022 2023 2023 2023 2023 2024 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 40 CAPITAL PROJECTS .00 .00 .00 .00 .00 -1,000,000.00 _________ 41 RESERVE FOR REPLACE .00 .00 .00 -72,051.00 .00 -2,400,000.00 _________ 42 CAPITAL PROJECT COU -400,000.00 .00 .00 .00 .00 .00 _________ 88 SPECIAL REVENUE TRU -750,055.20 -765,000.00 -765,000.00 -765,000.00 -765,000.00 -150,000.00 _________ TOTAL 09 TRANSFERS IN -8,741,919.40 -11,788,583.00 -10,407,766.15 -6,420,941.22 -7,635,894.00 -13,207,112.00 _________ TOTAL REVENUE -115,433,195.28 -158,843,925.00 -164,745,249.26 -151,029,043.95 -172,036,086.35 -164,344,682.00 _________ TOTAL EXPENSE .00 .00 .00 .00 .00 .00 _________ GRAND TOTAL -115,433,195.28 -158,843,925.00 -164,745,249.26 -151,029,043.95 -172,036,086.35 -164,344,682.00 _________ ** END OF REPORT - Generated by Erin K Witmer ** ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/17/2023 14:36User: ekwitmerProgram ID: bgnyrpts Page 12 PROJECTION: 20241 2024 BUDGET FOR PERIOD 99 09 TRANSFERS IN 2022 2023 2023 2023 2023 2024 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT Field # Total Page Break Sequence 1 10 Y Y Sequence 2 1 Y N Sequence 3 0 N N Sequence 4 0 N N Report title: 11/17/2023 14:36 |** 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 Revenue Account status