Loading...
HomeMy WebLinkAboutAll Funds - Revenue by Source** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/17/2022 13:17User: ekwitmerProgram ID: bgnyrpts Page 1 PROJECTION: 20231 2023 PROPOSED BUDGET FOR PERIOD 99 03 RE/LBRY/HOTEL TAXES 2021 2022 2022 2022 2022 2023 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 01 GENERAL GOVT OPERAT -38,097,172.60 -38,801,000.00 -38,801,000.00 -38,311,602.88 -38,658,420.00 -39,419,100.00 _________ 03 DEBT SERVICE -6,249,585.65 -6,285,000.00 -6,285,000.00 -6,228,150.09 -6,307,790.00 -6,441,000.00 _________ 33 TOURIST PROMOTION H -1,243,199.35 -1,300,000.00 -1,300,000.00 -1,137,920.81 -1,300,000.00 -1,300,000.00 _________ TOTAL 03 RE/LBRY/HOTEL TAXES -45,589,957.60 -46,386,000.00 -46,386,000.00 -45,677,673.78 -46,266,210.00 -47,160,100.00 _________ ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/17/2022 13:17User: ekwitmerProgram ID: bgnyrpts Page 2 PROJECTION: 20231 2023 PROPOSED BUDGET FOR PERIOD 99 04 INTEREST 2021 2022 2022 2022 2022 2023 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 01 GENERAL GOVT OPERAT -158,470.73 -215,070.00 -215,070.00 -156,004.42 -167,430.00 -418,150.00 _________ 03 DEBT SERVICE -1,778.84 -3,000.00 -3,000.00 -1,673.60 -3,000.00 -3,000.00 _________ 04 AGING SERVICES PSA .00 .00 .00 -246.52 .00 .00 _________ 05 CHILDREN & YOUTH SE -163.91 .00 .00 14.84 .00 .00 _________ 06 DOMESTIC RELATIONS -2,394.14 -8,000.00 -8,000.00 -2,248.17 -2,900.00 -8,000.00 _________ 07 DRUG & ALCOHOL SCA -402.32 -480.00 -480.00 -218.07 -335.00 -335.00 _________ 10 LIQUID FUELS TAXES -3,013.56 -8,000.00 -8,000.00 -2,788.61 -3,057.00 -3,500.00 _________ 11 MENTAL HEALTH / EAR -2,344.35 -2,500.00 -2,500.00 -2,241.39 -2,734.00 -2,750.00 _________ 12 RETIREMENT -2,587,082.30 -2,275,405.00 -2,275,405.00 -1,821,179.18 -2,208,901.00 -2,144,295.00 _________ 21 E 911 SERVICES -26.10 .00 .00 .00 .00 .00 _________ 22 HAZARDOUS MATERIALS -17.19 -50.00 -50.00 -9.70 -25.00 -25.00 _________ 24 WORKERS COMPENSATIO -45,419.14 -70,000.00 -70,000.00 -59,917.36 -70,000.00 -70,000.00 _________ 27 POST EMP HEALTH BEN -290,426.83 -350,000.00 -350,000.00 -142,133.76 -290,000.00 -300,000.00 _________ 30 SELF-FUNDED EMPLOYE -161.89 -250.00 -250.00 -218.19 -278.00 -220.00 _________ 33 TOURIST PROMOTION H -26.15 -10.00 -10.00 -21.49 -10.00 -15.00 _________ ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/17/2022 13:17User: ekwitmerProgram ID: bgnyrpts Page 3 PROJECTION: 20231 2023 PROPOSED BUDGET FOR PERIOD 99 04 INTEREST 2021 2022 2022 2022 2022 2023 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 34 INTELLECTUAL DISABI -156.84 -300.00 -300.00 -289.52 -407.00 -450.00 _________ 35 COMMUNITY SERVICES -5,760.19 -7,010.00 -7,010.00 -2,218.70 -8,177.00 -4,000.00 _________ 42 CAPITAL PROJECT COU 422,088.57 -20,000.00 -20,000.00 -9,234.82 -11,000.00 -8,500.00 _________ 80 SPECIAL REVENUE GRA -33,789.99 .00 .00 -14,035.26 -18,000.00 .00 _________ 88 SPECIAL REVENUE TRU -1,540.51 -2,200.00 -2,200.00 -3,204.90 -3,645.00 -5,200.00 _________ TOTAL 04 INTEREST -2,710,886.41 -2,962,275.00 -2,962,275.00 -2,217,868.82 -2,789,899.00 -2,968,440.00 _________ ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/17/2022 13:17User: ekwitmerProgram ID: bgnyrpts Page 4 PROJECTION: 20231 2023 PROPOSED BUDGET FOR PERIOD 99 05 I/GOVT REV - FEDERAL 2021 2022 2022 2022 2022 2023 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 01 GENERAL GOVT OPERAT -653,894.17 -939,199.00 -906,645.00 -475,656.40 -722,068.00 -877,360.00 _________ 04 AGING SERVICES PSA -775,987.00 -1,329,188.00 -1,329,188.00 -473,294.00 -602,205.00 -1,313,568.00 _________ 05 CHILDREN & YOUTH SE -2,750,833.55 -3,141,047.00 -3,141,047.00 -2,198,482.53 -2,502,750.00 -2,969,802.00 _________ 06 DOMESTIC RELATIONS -1,439,012.01 -1,481,000.00 -1,499,678.00 -796,307.53 -1,098,435.00 -1,571,000.00 _________ 07 DRUG & ALCOHOL SCA -728,934.70 -967,825.00 -967,825.00 -616,588.38 -1,295,323.00 -1,352,449.00 _________ 10 LIQUID FUELS TAXES -1,140,048.91 -249,600.00 -249,600.00 -62,399.93 -139,041.00 -1,068,000.00 _________ 11 MENTAL HEALTH / EAR -472,126.23 -458,910.00 -458,910.00 -468,501.08 -479,012.00 -577,391.00 _________ 20 COMM DEVEL BLOCK GR -338,899.38 -1,468,190.00 -1,468,190.00 -675,964.66 -716,102.00 -1,078,053.00 _________ 22 HAZARDOUS MATERIALS 3,405.56 -17,518.00 -19,366.00 -8,345.63 -19,365.00 -12,894.00 _________ 32 NON-CATEG HUMAN SER -466,796.11 -417,409.00 -559,457.00 -527,414.01 -674,320.00 -729,100.00 _________ 34 INTELLECTUAL DISABI -261,911.98 -276,061.00 -276,061.00 -308,973.72 -382,048.00 -386,319.00 _________ 35 COMMUNITY SERVICES -7,626,582.27 -8,323,000.00 -8,323,000.00 -8,740,694.01 -11,285,313.00 -3,199,030.00 _________ 80 SPECIAL REVENUE GRA -7,280,447.01 -12,000,000.00 -12,000,000.00 -6,105,488.95 -12,001,200.00 -8,000,000.00 _________ TOTAL 05 I/GOVT REV - FEDERA -23,932,067.76 -31,068,947.00 -31,198,967.00 -21,458,110.83 -31,917,182.00 -23,134,966.00 _________ ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/17/2022 13:17User: ekwitmerProgram ID: bgnyrpts Page 5 PROJECTION: 20231 2023 PROPOSED BUDGET FOR PERIOD 99 06 I/GOVT REV - STATE 2021 2022 2022 2022 2022 2023 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 01 GENERAL GOVT OPERAT -1,615,865.24 -1,772,584.00 -2,093,144.00 -1,170,341.02 -1,766,411.00 -1,691,130.00 _________ 04 AGING SERVICES PSA -2,798,115.00 -3,308,157.00 -3,308,157.00 -1,628,896.00 -2,169,682.00 -2,878,674.00 _________ 05 CHILDREN & YOUTH SE -7,762,950.39 -9,877,460.00 -9,877,460.00 -6,547,766.43 -8,104,226.00 -9,582,053.00 _________ 07 DRUG & ALCOHOL SCA -737,898.58 -716,822.00 -696,822.00 -692,924.56 -729,244.00 -732,948.00 _________ 10 LIQUID FUELS TAXES -808,312.91 -783,000.00 -783,000.00 -456,954.34 -646,651.00 -640,000.00 _________ 11 MENTAL HEALTH / EAR -5,678,666.02 -6,332,048.00 -6,218,888.00 -6,006,295.36 -6,226,525.00 -6,286,044.00 _________ 21 E 911 SERVICES -3,353,095.66 -3,318,062.00 -3,318,062.00 -2,441,052.84 -3,243,062.00 -3,250,000.00 _________ 22 HAZARDOUS MATERIALS -12,996.50 -31,949.00 -41,218.00 -28,708.23 -33,656.00 -27,704.00 _________ 34 INTELLECTUAL DISABI -809,424.28 -715,944.00 -715,944.00 -740,234.29 -771,611.00 -819,472.00 _________ 35 COMMUNITY SERVICES -382,432.28 -564,873.00 -698,033.00 -298,279.44 -349,594.00 -328,769.00 _________ 40 CAPITAL PROJECTS .00 -37,500.00 -37,500.00 -6,050.00 -6,050.00 .00 _________ 42 CAPITAL PROJECT COU -1,462,500.00 .00 .00 -37,500.00 -37,500.00 .00 _________ 80 SPECIAL REVENUE GRA -1,755,892.00 .00 .00 .00 .00 .00 _________ 88 SPECIAL REVENUE TRU -110,262.75 -150,000.00 -150,000.00 -184,637.66 -184,638.00 -195,000.00 _________ TOTAL 06 I/GOVT REV - STATE -27,288,411.61 -27,608,399.00 -27,938,228.00 -20,239,640.17 -24,268,850.00 -26,431,794.00 _________ ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/17/2022 13:17User: ekwitmerProgram ID: bgnyrpts Page 6 PROJECTION: 20231 2023 PROPOSED BUDGET FOR PERIOD 99 07 CHARGES FOR SERVICE 2021 2022 2022 2022 2022 2023 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 01 GENERAL GOVT OPERAT -7,531,399.75 -8,251,771.00 -8,251,771.00 -6,296,441.79 -8,165,040.00 -8,535,870.00 _________ 04 AGING SERVICES PSA -223,457.44 -214,942.00 -214,942.00 22,397.87 -310,149.12 -155,321.00 _________ 05 CHILDREN & YOUTH SE -154,095.55 -235,000.00 -235,000.00 -107,940.70 -132,350.00 -200,000.00 _________ 06 DOMESTIC RELATIONS -20,395.05 -31,600.00 -31,600.00 -13,202.33 -19,700.00 -21,500.00 _________ 07 DRUG & ALCOHOL SCA -45,407.46 -81,500.00 -81,500.00 -133,579.45 -147,364.00 -154,816.00 _________ 10 LIQUID FUELS TAXES -3,791.45 -5,000.00 -5,000.00 -12,195.76 -12,196.00 -5,000.00 _________ 11 MENTAL HEALTH / EAR -20,999.45 -20,885.00 -20,885.00 -14,939.43 -21,011.00 -21,075.00 _________ 12 RETIREMENT -4,621,150.36 -4,749,000.00 -4,749,000.00 -3,613,423.02 -4,625,717.00 -4,716,000.00 _________ 16 GEN ADMIN DIRECT SU -3,610,922.89 -4,606,288.00 -4,606,288.00 -3,441,035.16 -4,587,264.00 -5,755,806.00 _________ 17 HUMAN SERVICES BLDG -461,042.91 -436,916.00 -436,916.00 -324,175.96 -436,916.00 -515,270.00 _________ 22 HAZARDOUS MATERIALS -61,544.14 -53,500.00 -53,500.00 -55,461.61 -58,700.00 -59,300.00 _________ 24 WORKERS COMPENSATIO -1,164,740.68 -1,363,537.00 -1,363,537.00 -1,165,014.28 -1,365,537.00 -1,363,000.00 _________ 27 POST EMP HEALTH BEN -99,573.46 -150,000.00 -150,000.00 -80,733.40 -100,000.00 -150,000.00 _________ 28 ADMIN ANNEX OCCUPAN -496,541.40 -332,953.00 -344,280.00 -264,830.34 -332,953.00 -397,149.00 _________ 30 SELF-FUNDED EMPLOYE -5,424,054.97 -5,704,500.00 -5,704,500.00 -4,672,421.37 -5,445,700.00 -5,482,000.00 _________ ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/17/2022 13:17User: ekwitmerProgram ID: bgnyrpts Page 7 PROJECTION: 20231 2023 PROPOSED BUDGET FOR PERIOD 99 07 CHARGES FOR SERVICE 2021 2022 2022 2022 2022 2023 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 31 HUMAN SERVICES ADMI -354,448.31 -424,508.00 -424,508.00 -260,572.11 -424,508.00 -385,368.00 _________ 32 NON-CATEG HUMAN SER .00 .00 .00 -14,088.00 -18,827.00 -54,500.00 _________ 34 INTELLECTUAL DISABI -572.45 -650.00 -650.00 -746.26 -1,294.00 -1,300.00 _________ 36 BH MANAGED CARE -654,597.30 -752,838.00 -752,838.00 -523,181.93 -708,738.00 -829,242.00 _________ 88 SPECIAL REVENUE TRU -173,849.00 -177,500.00 -177,500.00 -114,556.00 -139,000.00 -139,000.00 _________ TOTAL 07 CHARGES FOR SERVICE -25,122,584.02 -27,592,888.00 -27,604,215.00 -21,086,141.03 -27,052,964.12 -28,941,517.00 _________ ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/17/2022 13:17User: ekwitmerProgram ID: bgnyrpts Page 8 PROJECTION: 20231 2023 PROPOSED BUDGET FOR PERIOD 99 08 CONTRIBTNS / OTHER 2021 2022 2022 2022 2022 2023 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 01 GENERAL GOVT OPERAT -1,520,944.81 -1,041,648.00 -1,045,034.00 387,488.60 -1,066,611.00 -851,273.00 _________ 04 AGING SERVICES PSA -38,476.21 -30,000.00 -30,000.00 -4,503.93 -5,590.00 -20,000.00 _________ 05 CHILDREN & YOUTH SE -86.21 -1,200.00 -1,200.00 -26,038.18 -1,210.00 -2,909.00 _________ 07 DRUG & ALCOHOL SCA -215.93 -115.00 -115.00 -6,979.62 -130.00 -300,130.00 _________ 10 LIQUID FUELS TAXES .00 -2,500.00 -2,500.00 .00 .00 .00 _________ 11 MENTAL HEALTH / EAR -1,901.24 -3,620.00 -3,620.00 -4,309.85 -4,328.00 -4,370.00 _________ 12 RETIREMENT -21,411,981.07 -12,401,000.00 -12,401,000.00 24,944,425.21 -2,200,700.00 -4,200,500.00 _________ 16 GEN ADMIN DIRECT SU -2,560.21 .00 -30,000.00 -2,042.10 .00 .00 _________ 21 E 911 SERVICES -2,057,259.00 .00 .00 -24.58 .00 .00 _________ 22 HAZARDOUS MATERIALS -54,687.00 .00 .00 -2,391.88 -6,077.00 .00 _________ 24 WORKERS COMPENSATIO 51,952.15 -40,750.00 -40,750.00 111,515.19 -5,000.00 -40,750.00 _________ 27 POST EMP HEALTH BEN -2,269,263.20 -2,000,000.00 -2,000,000.00 2,109,705.82 -3,000,000.00 -2,500,000.00 _________ 32 NON-CATEG HUMAN SER -3,739.41 -5,145.00 -5,145.00 -17,362.73 -13,756.00 -44,693.00 _________ 34 INTELLECTUAL DISABI -332.55 -500.00 -500.00 .00 .00 .00 _________ 35 COMMUNITY SERVICES -78,014.96 .00 .00 -76,668.27 -98,557.00 -33,900.00 _________ ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/17/2022 13:17User: ekwitmerProgram ID: bgnyrpts Page 9 PROJECTION: 20231 2023 PROPOSED BUDGET FOR PERIOD 99 08 CONTRIBTNS / OTHER 2021 2022 2022 2022 2022 2023 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 41 RESERVE FOR REPLACE -18,300.00 .00 .00 .00 .00 .00 _________ 42 CAPITAL PROJECT COU -7,240,397.95 -10,000,000.00 -10,000,000.00 .00 .00 -10,000,000.00 _________ 88 SPECIAL REVENUE TRU -290,516.42 -315,000.00 -315,000.00 -544,457.48 -549,747.00 -330,000.00 _________ TOTAL 08 CONTRIBTNS / OTHER -34,936,724.02 -25,841,478.00 -25,874,864.00 26,868,356.20 -6,951,706.00 -18,328,525.00 _________ ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/17/2022 13:17User: ekwitmerProgram ID: bgnyrpts Page 10 PROJECTION: 20231 2023 PROPOSED BUDGET FOR PERIOD 99 09 TRANSFERS IN 2021 2022 2022 2022 2022 2023 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 01 GENERAL GOVT OPERAT -4,900,702.19 -1,797,557.00 -1,797,557.00 -749,245.75 -1,500,000.00 -4,400,000.00 _________ 04 AGING SERVICES PSA -395,288.78 -475,000.00 -475,000.00 -211,010.41 -347,000.00 -370,000.00 _________ 05 CHILDREN & YOUTH SE -2,019,027.39 -2,929,081.00 -2,929,081.00 -2,128,112.33 -2,603,625.00 -2,937,358.00 _________ 06 DOMESTIC RELATIONS -743,073.14 -867,343.00 -867,343.00 -722,785.80 -867,343.00 -939,088.00 _________ 07 DRUG & ALCOHOL SCA -64,867.12 -65,000.00 -65,000.00 -45,152.51 -65,550.00 -61,000.00 _________ 10 LIQUID FUELS TAXES -22,945.44 -300,000.00 -300,000.00 .00 -15,000.00 -800,000.00 _________ 11 MENTAL HEALTH / EAR -217,305.81 -195,000.00 -195,000.00 -165,974.17 -227,000.00 -228,980.00 _________ 16 GEN ADMIN DIRECT SU .00 .00 -97,900.00 -2,511.82 .00 -85,000.00 _________ 20 COMM DEVEL BLOCK GR -57,099.99 .00 .00 .00 .00 .00 _________ 21 E 911 SERVICES -351,696.10 -587,812.00 -587,812.00 -440,856.00 -479,267.00 -642,168.00 _________ 22 HAZARDOUS MATERIALS -76,441.73 -87,908.00 -87,908.00 -71,696.41 -89,235.00 -73,513.00 _________ 30 SELF-FUNDED EMPLOYE -139,766.16 -140,000.00 -140,000.00 -91,843.09 -100,000.00 -140,000.00 _________ 32 NON-CATEG HUMAN SER -492.37 -33,158.00 -178,233.00 -54,529.19 -85,846.00 -214,639.00 _________ 34 INTELLECTUAL DISABI -44,820.00 -44,820.00 -44,820.00 -33,615.00 -45,000.00 -44,820.00 _________ 35 COMMUNITY SERVICES -15,250.00 -91,274.00 -91,274.00 .00 .00 -87,017.00 _________ ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/17/2022 13:17User: ekwitmerProgram ID: bgnyrpts Page 11 PROJECTION: 20231 2023 PROPOSED BUDGET FOR PERIOD 99 09 TRANSFERS IN 2021 2022 2022 2022 2022 2023 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 42 CAPITAL PROJECT COU -20,903.36 -44,645.00 -444,645.00 -400,000.00 -400,000.00 .00 _________ 88 SPECIAL REVENUE TRU -150,015.14 -500,000.00 -500,000.00 -750,026.15 -750,027.00 -765,000.00 _________ TOTAL 09 TRANSFERS IN -9,219,694.72 -8,158,598.00 -8,801,573.00 -5,867,358.63 -7,574,893.00 -11,788,583.00 _________ TOTAL REVENUE -168,800,326.14 -169,618,585.00 -170,766,122.00 -89,678,437.06 -146,821,704.12 -158,753,925.00 _________ TOTAL EXPENSE .00 .00 .00 .00 .00 .00 _________ GRAND TOTAL -168,800,326.14 -169,618,585.00 -170,766,122.00 -89,678,437.06 -146,821,704.12 -158,753,925.00 _________ ** END OF REPORT - Generated by Erin K Witmer **