Loading...
HomeMy WebLinkAboutAll Funds - Revenue by Source** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/22/2021 08:35User: ekwitmerProgram ID: bgnyrpts Page 1 PROJECTION: 20221 2022 PROPOSED BUDGET FOR PERIOD 99 03 RE/LBRY/HOTEL TAXES 2020 2021 2021 2021 2021 2022 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 01 GENERAL GOVT OPERAT -37,486,784.28 -38,248,291.00 -38,248,291.00 -37,626,585.66 -37,983,291.00 -38,801,000.00 _________ 03 DEBT SERVICE -6,329,171.92 -6,173,719.00 -6,173,719.00 -6,082,546.86 -6,151,966.00 -6,285,000.00 _________ 33 TOURIST PROMOTION H -715,556.29 -1,050,000.00 -1,050,000.00 -1,001,955.10 -1,050,000.00 -1,300,000.00 _________ TOTAL 03 RE/LBRY/HOTEL TAXES -44,531,512.49 -45,472,010.00 -45,472,010.00 -44,711,087.62 -45,185,257.00 -46,386,000.00 _________ ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/22/2021 08:35User: ekwitmerProgram ID: bgnyrpts Page 2 PROJECTION: 20221 2022 PROPOSED BUDGET FOR PERIOD 99 04 INTEREST 2020 2021 2021 2021 2021 2022 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 01 GENERAL GOVT OPERAT -262,381.31 -239,080.00 -239,080.00 -125,656.30 -161,632.00 -215,070.00 _________ 03 DEBT SERVICE -2,163.83 -3,000.00 -3,000.00 -1,483.91 -3,000.00 -3,000.00 _________ 04 AGING SERVICES PSA .00 .00 .00 -48.63 .00 .00 _________ 05 CHILDREN & YOUTH SE .00 .00 .00 -118.84 -298.00 .00 _________ 06 DOMESTIC RELATIONS -7,224.67 -10,000.00 -10,000.00 -2,021.19 -3,000.00 -8,000.00 _________ 07 DRUG & ALCOHOL SCA -696.16 -1,000.00 -1,000.00 -356.99 -481.00 -480.00 _________ 10 LIQUID FUELS TAXES -12,465.63 -18,950.00 -18,950.00 -2,561.52 -5,000.00 -8,000.00 _________ 11 MENTAL HEALTH / EAR -7,718.67 -15,229.00 -15,229.00 -1,883.88 -2,466.00 -2,500.00 _________ 12 RETIREMENT -2,820,572.17 -4,790,870.00 -4,790,870.00 -1,776,952.93 -2,273,355.00 -2,275,405.00 _________ 21 E 911 SERVICES -103.93 -100.00 -100.00 -15.43 -15.00 .00 _________ 22 HAZARDOUS MATERIALS -25.16 -50.00 -50.00 -9.25 -30.00 -50.00 _________ 24 WORKERS COMPENSATIO -57,117.25 -70,000.00 -70,000.00 -34,126.01 -54,575.00 -70,000.00 _________ 27 POST EMP HEALTH BEN -288,008.39 -200,000.00 -200,000.00 -199,021.69 -200,000.00 -350,000.00 _________ 30 SELF-FUNDED EMPLOYE -19.29 -5,050.00 -5,050.00 -130.77 -180.00 -250.00 _________ 33 TOURIST PROMOTION H -15.14 -10.00 -10.00 -22.84 -25.00 -10.00 _________ ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/22/2021 08:35User: ekwitmerProgram ID: bgnyrpts Page 3 PROJECTION: 20221 2022 PROPOSED BUDGET FOR PERIOD 99 04 INTEREST 2020 2021 2021 2021 2021 2022 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 34 INTELLECTUAL DISABI -998.89 -1,600.00 -1,600.00 -221.89 -265.00 -300.00 _________ 35 COMMUNITY SERVICES -38.96 -20.00 -6,020.00 -4,898.01 -5,407.00 -7,010.00 _________ 42 CAPITAL PROJECT COU -704,504.86 -500,000.00 -500,000.00 -1,494.77 -1,600.00 -20,000.00 _________ 80 SPECIAL REVENUE GRA -9,318.94 .00 .00 -24,854.83 .00 .00 _________ 88 SPECIAL REVENUE TRU -3,511.42 -4,200.00 -4,200.00 -1,267.26 -1,800.00 -2,200.00 _________ TOTAL 04 INTEREST -4,176,884.67 -5,859,159.00 -5,865,159.00 -2,177,146.94 -2,713,129.00 -2,962,275.00 _________ ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/22/2021 08:35User: ekwitmerProgram ID: bgnyrpts Page 4 PROJECTION: 20221 2022 PROPOSED BUDGET FOR PERIOD 99 05 I/GOVT REV - FEDERAL 2020 2021 2021 2021 2021 2022 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 01 GENERAL GOVT OPERAT -599,617.99 -878,826.00 -778,826.00 -377,603.99 -874,344.00 -939,199.00 _________ 04 AGING SERVICES PSA -836,137.00 -1,329,188.00 -1,329,188.00 -534,338.00 -1,329,188.00 -1,329,188.00 _________ 05 CHILDREN & YOUTH SE -2,590,112.62 -2,948,711.00 -2,948,711.00 -2,028,466.39 -2,757,083.00 -3,141,047.00 _________ 06 DOMESTIC RELATIONS -1,425,748.81 -1,591,000.00 -1,591,000.00 -578,078.17 -1,575,600.00 -1,481,000.00 _________ 07 DRUG & ALCOHOL SCA -779,888.00 -796,046.00 -796,046.00 -380,365.93 -591,618.00 -967,825.00 _________ 10 LIQUID FUELS TAXES -630,069.62 -1,411,062.00 -1,411,062.00 -971,026.40 -1,461,162.00 -249,600.00 _________ 11 MENTAL HEALTH / EAR -368,679.22 -388,835.00 -388,835.00 -414,827.16 -469,090.00 -458,910.00 _________ 20 COMM DEVEL BLOCK GR -415,145.49 -1,621,538.00 -1,621,538.00 -203,450.01 -203,452.00 -1,468,190.00 _________ 22 HAZARDOUS MATERIALS .00 -8,080.00 -11,902.00 -3,236.44 -3,459.00 -17,518.00 _________ 32 NON-CATEG HUMAN SER -399,145.10 -565,861.00 -565,861.00 -295,703.98 -396,868.00 -417,409.00 _________ 34 INTELLECTUAL DISABI -282,618.61 -303,061.00 -335,255.00 -210,032.83 -307,033.00 -276,061.00 _________ 35 COMMUNITY SERVICES -62,000.00 .00 -10,196,173.00 -5,782,737.40 -5,101,428.00 -8,323,000.00 _________ 80 SPECIAL REVENUE GRA -14,145,182.96 .00 -152,000.00 -60,187.50 .00 -12,000,000.00 _________ TOTAL 05 I/GOVT REV - FEDERA -22,534,345.42 -11,842,208.00 -22,126,397.00 -11,840,054.20 -15,070,325.00 -31,068,947.00 _________ ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/22/2021 08:35User: ekwitmerProgram ID: bgnyrpts Page 5 PROJECTION: 20221 2022 PROPOSED BUDGET FOR PERIOD 99 06 I/GOVT REV - STATE 2020 2021 2021 2021 2021 2022 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 01 GENERAL GOVT OPERAT -1,421,541.05 -1,811,814.00 -1,759,224.00 -884,480.08 -1,184,150.00 -1,772,584.00 _________ 04 AGING SERVICES PSA -2,713,393.00 -3,322,208.00 -3,322,208.00 -2,117,008.00 -3,322,208.00 -3,308,157.00 _________ 05 CHILDREN & YOUTH SE -7,454,507.89 -10,182,303.00 -10,182,303.00 -5,991,823.17 -7,975,508.70 -9,877,460.00 _________ 07 DRUG & ALCOHOL SCA -911,232.22 -890,208.00 -948,104.00 -674,584.80 -925,035.00 -716,822.00 _________ 10 LIQUID FUELS TAXES -796,066.93 -1,000,574.00 -1,000,574.00 -503,798.27 -1,000,574.00 -783,000.00 _________ 11 MENTAL HEALTH / EAR -6,073,321.54 -6,621,953.00 -6,400,012.00 -6,056,211.99 -5,359,917.00 -6,332,048.00 _________ 21 E 911 SERVICES -3,551,293.46 -3,415,524.00 -3,275,956.00 -2,522,867.81 -3,250,956.00 -3,318,062.00 _________ 22 HAZARDOUS MATERIALS -23,318.80 -25,285.00 -28,045.00 -17,426.46 -24,930.00 -31,949.00 _________ 24 WORKERS COMPENSATIO -52,081.73 .00 .00 .00 .00 .00 _________ 34 INTELLECTUAL DISABI -523,153.64 -661,000.00 -724,391.00 -847,116.93 -1,281,176.00 -715,944.00 _________ 35 COMMUNITY SERVICES -286,667.61 -289,399.00 -486,169.00 -426,245.25 -569,268.00 -564,873.00 _________ 40 CAPITAL PROJECTS .00 .00 .00 -462,500.00 -462,500.00 -37,500.00 _________ 41 RESERVE FOR REPLACE -420,759.00 .00 .00 .00 .00 .00 _________ 42 CAPITAL PROJECT COU .00 -1,500,000.00 -1,500,000.00 -1,000,000.00 -1,000,000.00 .00 _________ 80 SPECIAL REVENUE GRA .00 .00 -1,756,000.00 -1,755,892.00 .00 .00 _________ ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/22/2021 08:35User: ekwitmerProgram ID: bgnyrpts Page 6 PROJECTION: 20221 2022 PROPOSED BUDGET FOR PERIOD 99 06 I/GOVT REV - STATE 2020 2021 2021 2021 2021 2022 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 88 SPECIAL REVENUE TRU -143,497.69 -140,000.00 -140,000.00 -110,262.75 -110,835.00 -150,000.00 _________ TOTAL 06 I/GOVT REV - STATE -24,370,834.56 -29,860,268.00 -31,522,986.00 -23,370,217.51 -26,467,057.70 -27,608,399.00 _________ ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/22/2021 08:35User: ekwitmerProgram ID: bgnyrpts Page 7 PROJECTION: 20221 2022 PROPOSED BUDGET FOR PERIOD 99 07 CHARGES FOR SERVICE 2020 2021 2021 2021 2021 2022 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 01 GENERAL GOVT OPERAT -7,186,716.07 -7,847,348.00 -7,849,758.00 -6,433,158.33 -7,207,561.00 -8,251,771.00 _________ 04 AGING SERVICES PSA -63,448.24 -328,000.00 -328,000.00 -55,102.80 -242,000.00 -214,942.00 _________ 05 CHILDREN & YOUTH SE -193,621.93 -235,000.00 -235,000.00 -128,051.17 -146,827.00 -235,000.00 _________ 06 DOMESTIC RELATIONS -33,227.55 -39,800.00 -39,800.00 -17,795.24 -31,100.00 -31,600.00 _________ 07 DRUG & ALCOHOL SCA -72,213.35 -338,537.00 -338,537.00 -64,748.29 -59,837.00 -81,500.00 _________ 10 LIQUID FUELS TAXES -8,301.05 -5,000.00 -5,000.00 -3,791.45 -5,000.00 -5,000.00 _________ 11 MENTAL HEALTH / EAR -19,287.25 -19,885.00 -19,885.00 -13,719.40 -21,578.00 -20,885.00 _________ 12 RETIREMENT -4,805,804.87 -5,358,500.00 -5,358,500.00 -4,168,476.31 -4,597,296.00 -4,749,000.00 _________ 16 GEN ADMIN DIRECT SU -3,864,173.36 -4,456,444.00 -4,456,444.00 -3,059,393.12 -4,456,444.00 -4,606,288.00 _________ 17 HUMAN SERVICES BLDG -297,431.76 -481,704.00 -481,704.00 -349,439.28 -481,704.00 -436,916.00 _________ 22 HAZARDOUS MATERIALS -86,660.97 -61,150.00 -61,150.00 -48,728.76 -54,500.00 -53,500.00 _________ 24 WORKERS COMPENSATIO -894,239.19 -1,360,537.00 -1,360,537.00 -976,579.26 -1,305,451.00 -1,363,537.00 _________ 27 POST EMP HEALTH BEN -143,730.42 -150,000.00 -150,000.00 -89,148.47 -150,000.00 -150,000.00 _________ 28 ADMIN ANNEX OCCUPAN -289,860.44 -351,422.00 -351,422.00 -285,318.39 -351,422.00 -332,953.00 _________ 30 SELF-FUNDED EMPLOYE -269,984.83 -5,280,500.00 -5,280,500.00 -4,886,392.38 -5,658,500.00 -5,704,500.00 _________ ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/22/2021 08:35User: ekwitmerProgram ID: bgnyrpts Page 8 PROJECTION: 20221 2022 PROPOSED BUDGET FOR PERIOD 99 07 CHARGES FOR SERVICE 2020 2021 2021 2021 2021 2022 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 31 HUMAN SERVICES ADMI -414,461.23 -499,412.00 -499,412.00 -294,418.34 -376,048.00 -424,508.00 _________ 34 INTELLECTUAL DISABI -657.36 -600.00 -600.00 -364.46 -620.00 -650.00 _________ 36 BH MANAGED CARE -580,042.09 -633,113.00 -633,113.00 -479,241.92 -576,000.00 -752,838.00 _________ 88 SPECIAL REVENUE TRU -146,107.00 -129,575.00 -129,575.00 -161,811.00 -171,000.00 -177,500.00 _________ TOTAL 07 CHARGES FOR SERVICE -19,369,968.96 -27,576,527.00 -27,578,937.00 -21,515,678.37 -25,892,888.00 -27,592,888.00 _________ ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/22/2021 08:35User: ekwitmerProgram ID: bgnyrpts Page 9 PROJECTION: 20221 2022 PROPOSED BUDGET FOR PERIOD 99 08 CONTRIBTNS / OTHER 2020 2021 2021 2021 2021 2022 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 01 GENERAL GOVT OPERAT -931,532.28 -1,104,365.00 -1,242,538.00 -777,710.91 -1,116,982.00 -1,041,648.00 _________ 03 DEBT SERVICE -13,860,000.00 .00 .00 .00 -6,720,000.00 .00 _________ 04 AGING SERVICES PSA -6,625.53 -30,000.00 -30,000.00 -25,631.97 -30,000.00 -30,000.00 _________ 05 CHILDREN & YOUTH SE -1,681.58 -1,200.00 -1,200.00 -79.21 -158.00 -1,200.00 _________ 07 DRUG & ALCOHOL SCA -181.85 -500.00 -500.00 -56.82 -114.00 -115.00 _________ 10 LIQUID FUELS TAXES -16,730.00 -2,500.00 -2,500.00 .00 .00 -2,500.00 _________ 11 MENTAL HEALTH / EAR -13,188.49 -5,402.00 -5,402.00 -1,901.24 -3,417.00 -3,620.00 _________ 12 RETIREMENT -14,803,106.68 -10,401,000.00 -10,401,000.00 -19,980,326.86 -20,401,000.00 -12,401,000.00 _________ 16 GEN ADMIN DIRECT SU -348.50 .00 .00 -2,560.21 .00 .00 _________ 21 E 911 SERVICES -30.00 .00 .00 .00 .00 .00 _________ 24 WORKERS COMPENSATIO -2,748.98 -33,500.00 -33,500.00 38,963.04 -25,091.00 -40,750.00 _________ 27 POST EMP HEALTH BEN -1,332,146.56 -600,000.00 -600,000.00 -2,089,737.63 -2,200,000.00 -2,000,000.00 _________ 32 NON-CATEG HUMAN SER -5,891.44 -12,943.00 -12,943.00 -3,306.34 -5,135.00 -5,145.00 _________ 34 INTELLECTUAL DISABI -19,252.33 -19,245.00 -19,245.00 -410.19 -820.00 -500.00 _________ 35 COMMUNITY SERVICES -77,536.83 -80,188.00 -80,188.00 -51,605.05 -76,414.00 .00 _________ ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/22/2021 08:35User: ekwitmerProgram ID: bgnyrpts Page 10 PROJECTION: 20221 2022 PROPOSED BUDGET FOR PERIOD 99 08 CONTRIBTNS / OTHER 2020 2021 2021 2021 2021 2022 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 42 CAPITAL PROJECT COU .00 .00 .00 -20,000.00 -6,740,000.00 -10,000,000.00 _________ 88 SPECIAL REVENUE TRU -170,682.17 -255,600.00 -261,330.00 -248,213.65 -303,865.00 -315,000.00 _________ TOTAL 08 CONTRIBTNS / OTHER -31,241,683.22 -12,546,443.00 -12,690,346.00 -23,162,577.04 -37,622,996.00 -25,841,478.00 _________ ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/22/2021 08:35User: ekwitmerProgram ID: bgnyrpts Page 11 PROJECTION: 20221 2022 PROPOSED BUDGET FOR PERIOD 99 09 TRANSFERS IN 2020 2021 2021 2021 2021 2022 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 01 GENERAL GOVT OPERAT -98,585.02 -40,000.00 -40,000.00 -22,915.12 -40,000.00 -1,797,557.00 _________ 04 AGING SERVICES PSA -382,152.17 -368,000.00 -368,000.00 -309,747.10 -469,200.00 -475,000.00 _________ 05 CHILDREN & YOUTH SE -3,394,948.37 -3,093,734.00 -3,093,734.00 -1,415,783.41 -1,997,903.00 -2,929,081.00 _________ 06 DOMESTIC RELATIONS -639,221.06 -716,918.00 -716,918.00 -597,431.70 -716,918.00 -867,343.00 _________ 07 DRUG & ALCOHOL SCA -67,019.72 -65,745.00 -65,745.00 -36,863.59 -63,195.00 -65,000.00 _________ 10 LIQUID FUELS TAXES .00 -15,000.00 -15,000.00 .00 .00 -300,000.00 _________ 11 MENTAL HEALTH / EAR -251,811.40 -250,500.00 -250,500.00 -128,688.30 -197,032.00 -195,000.00 _________ 16 GEN ADMIN DIRECT SU -8,615.24 .00 .00 .00 .00 .00 _________ 20 COMM DEVEL BLOCK GR -111,485.35 .00 .00 .00 .00 .00 _________ 21 E 911 SERVICES -314,322.28 -954,802.00 -954,802.00 -601,702.17 -470,000.00 -587,812.00 _________ 22 HAZARDOUS MATERIALS -43,078.38 -75,204.00 -76,162.00 -60,263.14 -81,365.00 -87,908.00 _________ 30 SELF-FUNDED EMPLOYE .00 -130,000.00 -130,000.00 -105,666.67 -140,000.00 -140,000.00 _________ 32 NON-CATEG HUMAN SER -31,995.92 -32,173.00 -32,173.00 6,725.02 -12,471.00 -33,158.00 _________ 34 INTELLECTUAL DISABI -44,820.00 -44,825.00 -44,825.00 -26,145.00 -44,820.00 -44,820.00 _________ 35 COMMUNITY SERVICES 1,549.00 .00 -15,250.00 -15,250.00 -15,250.00 -91,274.00 _________ ** Live Database ** NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS Report generated: 11/22/2021 08:35User: ekwitmerProgram ID: bgnyrpts Page 12 PROJECTION: 20221 2022 PROPOSED BUDGET FOR PERIOD 99 09 TRANSFERS IN 2020 2021 2021 2021 2021 2022 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT 42 CAPITAL PROJECT COU -16,508.00 -1,250,000.00 -1,250,000.00 -48,466.36 -1,050,000.00 -44,645.00 _________ 88 SPECIAL REVENUE TRU -150,000.00 -150,000.00 -150,000.00 -150,015.14 -150,025.00 -500,000.00 _________ TOTAL 09 TRANSFERS IN -5,553,013.91 -7,186,901.00 -7,203,109.00 -3,512,212.68 -5,448,179.00 -8,158,598.00 _________ TOTAL REVENUE -151,778,243.23 -140,343,516.00 -152,458,944.00 -130,288,974.36 -158,399,831.70 -169,618,585.00 _________ TOTAL EXPENSE .00 .00 .00 .00 .00 .00 _________ GRAND TOTAL -151,778,243.23 -140,343,516.00 -152,458,944.00 -130,288,974.36 -158,399,831.70 -169,618,585.00 _________ ** END OF REPORT - Generated by Erin K Witmer **