Loading...
HomeMy WebLinkAboutAll Funds - Revenue by Source 11/21/2019 10:24 |** Live Database **|P 1 ekwitmer |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts PROJECTION:20201 2020 PROPOSED BUDGET FOR PERIOD 99 03 RE/LBRY/HOTEL TAXES 2018 2019 2019 2019 2019 2020 PCT ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED CHANGE ____________________________________________________________________________________________________________________________________ 01 GENERAL GOVT OPERAT -36,465,123.65 -36,528,536.00 -36,528,536.00 -36,753,025.01 -36,925,000.00 -37,203,150.00 1.8% 03 DEBT SERVICE -3,695,398.17 -5,928,440.00 -5,928,440.00 -5,931,918.61 -5,939,750.00 -6,035,800.00 1.8% 33 TOURIST PROMOTION H -1,040,989.84 -1,210,000.00 -1,210,000.00 -867,631.59 -1,100,000.00 -1,225,000.00 1.2% TOTAL 03 RE/LBRY/HOTEL TAXES -41,201,511.66 -43,666,976.00 -43,666,976.00 -43,552,575.21 -43,964,750.00 -44,463,950.00 1.8% 11/21/2019 10:24 |** Live Database **|P 2 ekwitmer |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts PROJECTION:20201 2020 PROPOSED BUDGET FOR PERIOD 99 04 INTEREST 2018 2019 2019 2019 2019 2020 PCT ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED CHANGE ____________________________________________________________________________________________________________________________________ 01 GENERAL GOVT OPERAT -265,970.84 -180,050.00 -180,050.00 -298,689.23 -355,350.00 -366,440.00 103.5% 03 DEBT SERVICE -4,887.70 -4,500.00 -4,500.00 -3,268.49 -3,500.00 -3,500.00 -22.2% 04 AGING SERVICES PSA .00 .00 .00 .00 .00 .00 .0% 05 CHILDREN & YOUTH SE .00 .00 .00 3,506.61 .00 .00 .0% 06 DOMESTIC RELATIONS -8,970.56 -8,500.00 -8,500.00 -12,403.01 -16,667.00 -16,000.00 88.2% 07 DRUG & ALCOHOL SCA -2,470.01 -1,900.00 -1,900.00 -2,580.50 -2,718.00 -2,700.00 42.1% 10 LIQUID FUELS TAXES -7,207.60 -5,500.00 -5,500.00 -18,900.83 -22,183.00 -15,000.00 172.7% 11 MENTAL HEALTH / EAR -7,581.25 -5,468.00 -5,828.00 -11,819.34 -14,452.00 -9,452.00 62.2% 12 RETIREMENT -2,457,218.95 -2,160,650.00 -2,160,650.00 -2,012,213.88 -2,441,145.00 -2,587,010.00 19.7% 21 E 911 SERVICES -188.82 -144.00 -144.00 -565.51 -700.00 -600.00 316.7% 22 HAZARDOUS MATERIALS -31.38 -34.00 -34.00 -53.06 -60.00 -52.00 52.9% 24 WORKERS COMPENSATIO -52,147.22 -33,000.00 -33,000.00 -64,316.64 -65,000.00 -42,000.00 27.3% 27 POST EMP HEALTH BEN -300,974.28 -225,000.00 -225,000.00 -196,100.76 -225,000.00 -200,000.00 -11.1% 30 SELF-FUNDED EMPLOYE .00 .00 -50.00 -26.50 -35.00 -50.00 .0% 33 TOURIST PROMOTION H -123.33 -140.00 -140.00 -81.98 -102.00 -105.00 -25.0% 11/21/2019 10:24 |** Live Database **|P 3 ekwitmer |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts PROJECTION:20201 2020 PROPOSED BUDGET FOR PERIOD 99 04 INTEREST 2018 2019 2019 2019 2019 2020 PCT ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED CHANGE ____________________________________________________________________________________________________________________________________ 34 INTELLECTUAL DISABI -1,969.08 -1,957.00 -1,957.00 -2,141.67 -3,236.00 -3,236.00 65.4% 35 COMMUNITY SERVICES -30.02 -10.00 -10.00 -90.12 -100.00 -200.00 1900.0% 42 CAPITAL PROJECT COU -761,437.94 -800,000.00 -800,000.00 -1,103,698.44 -1,200,000.00 -1,800,000.00 125.0% 88 SPECIAL REVENUE TRU -2,887.32 -2,500.00 -2,500.00 -6,671.38 -7,676.00 -6,700.00 168.0% TOTAL 04 INTEREST -3,874,096.30 -3,429,353.00 -3,429,763.00 -3,730,114.73 -4,357,924.00 -5,053,045.00 47.3% 11/21/2019 10:24 |** Live Database **|P 4 ekwitmer |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts PROJECTION:20201 2020 PROPOSED BUDGET FOR PERIOD 99 05 I/GOVT REV - FEDERAL 2018 2019 2019 2019 2019 2020 PCT ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED CHANGE ____________________________________________________________________________________________________________________________________ 01 GENERAL GOVT OPERAT -560,611.23 -672,147.00 -781,902.00 -266,244.92 -474,020.00 -914,810.00 17.0% 04 AGING SERVICES PSA -849,473.00 -792,935.00 -804,083.00 -585,247.00 -804,083.00 -806,623.00 .3% 05 CHILDREN & YOUTH SE -2,573,274.87 -2,724,385.00 -2,724,385.00 -1,837,014.43 -2,906,246.00 -2,713,694.00 -.4% 06 DOMESTIC RELATIONS -1,453,983.75 -1,603,624.00 -1,629,860.00 -761,257.77 -1,630,324.00 -1,618,200.00 -.7% 07 DRUG & ALCOHOL SCA -499,647.54 -570,704.00 -649,003.00 -528,234.11 -623,330.00 -605,574.00 -6.7% 10 LIQUID FUELS TAXES -278,385.46 -918,000.00 -918,000.00 -113,413.22 -311,413.00 -342,400.00 -62.7% 11 MENTAL HEALTH / EAR -291,272.71 -280,017.00 -280,017.00 -318,489.79 -311,887.00 -271,929.00 -2.9% 20 COMM DEVEL BLOCK GR 53,954.00 -934,441.00 -934,441.00 60,398.00 27,279.00 -678,653.00 -27.4% 22 HAZARDOUS MATERIALS -9,592.00 -5,660.00 -5,660.00 -5,134.00 -5,337.00 -5,837.00 3.1% 32 NON-CATEG HUMAN SER -414,438.20 -950,269.00 -950,269.00 -368,508.55 58,083.00 -736,406.00 -22.5% 34 INTELLECTUAL DISABI -284,083.56 -299,695.00 -328,031.00 -326,149.65 -314,811.00 -314,811.00 -4.0% TOTAL 05 I/GOVT REV - FEDERA -7,160,808.32 -9,751,877.00 -10,005,651.00 -5,049,295.44 -7,296,089.00 -9,008,937.00 -10.0% 11/21/2019 10:24 |** Live Database **|P 5 ekwitmer |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts PROJECTION:20201 2020 PROPOSED BUDGET FOR PERIOD 99 06 I/GOVT REV - STATE 2018 2019 2019 2019 2019 2020 PCT ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED CHANGE ____________________________________________________________________________________________________________________________________ 01 GENERAL GOVT OPERAT -2,004,333.60 -1,475,017.00 -1,749,894.00 -858,767.00 -1,691,761.00 -1,839,040.00 5.1% 04 AGING SERVICES PSA -2,499,319.00 -2,594,913.00 -2,666,992.00 -1,961,915.94 -2,666,992.00 -2,856,944.00 7.1% 05 CHILDREN & YOUTH SE -7,936,926.92 -7,849,611.00 -8,191,958.00 -6,274,190.86 -7,896,195.00 -9,320,540.00 13.8% 07 DRUG & ALCOHOL SCA -901,809.89 -869,662.00 -869,662.00 -769,802.21 -893,586.00 -863,494.00 -.7% 10 LIQUID FUELS TAXES -797,083.84 -873,000.00 -873,000.00 -527,000.01 -818,816.00 -847,500.00 -2.9% 11 MENTAL HEALTH / EAR -5,504,396.67 -6,787,517.00 -7,086,696.00 -4,892,810.12 -6,924,998.00 -6,789,118.00 -4.2% 21 E 911 SERVICES -3,117,779.26 -3,175,000.00 -3,329,860.00 -2,362,928.78 -3,197,073.00 -3,295,216.00 -1.0% 22 HAZARDOUS MATERIALS -25,071.04 -23,890.00 -23,890.00 -23,889.41 -23,890.00 -25,479.00 6.7% 24 WORKERS COMPENSATIO .00 -50,000.00 -50,000.00 .00 -50,000.00 .00 -100.0% 34 INTELLECTUAL DISABI -598,194.97 -668,033.00 -757,658.00 -1,811,070.91 -696,425.00 -690,556.00 -8.9% 35 COMMUNITY SERVICES -431,834.22 -312,158.00 -344,201.00 -321,425.53 -321,883.00 -284,303.00 -17.4% 42 CAPITAL PROJECT COU .00 -1,000,000.00 -1,000,000.00 .00 .00 -1,500,000.00 50.0% 88 SPECIAL REVENUE TRU -154,372.06 -135,000.00 -135,000.00 -179,544.27 -210,740.00 -145,000.00 7.4% TOTAL 06 I/GOVT REV - STATE -23,971,121.47 -25,813,801.00 -27,078,811.00 -19,983,345.04 -25,392,359.00 -28,457,190.00 5.1% 11/21/2019 10:24 |** Live Database **|P 6 ekwitmer |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts PROJECTION:20201 2020 PROPOSED BUDGET FOR PERIOD 99 07 CHARGES FOR SERVICE 2018 2019 2019 2019 2019 2020 PCT ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED CHANGE ____________________________________________________________________________________________________________________________________ 01 GENERAL GOVT OPERAT -7,847,873.22 -7,566,680.00 -7,746,396.00 -6,488,722.38 -7,796,311.00 -8,191,671.00 5.7% 04 AGING SERVICES PSA -321,461.01 -222,307.00 -543,856.00 -332,420.18 -543,856.00 -418,100.00 -23.1% 05 CHILDREN & YOUTH SE -193,604.78 -228,000.00 -228,000.00 -136,315.12 -199,796.00 -180,000.00 -21.1% 06 DOMESTIC RELATIONS -85,528.59 -39,000.00 -39,000.00 -37,995.30 -44,000.00 -45,500.00 16.7% 07 DRUG & ALCOHOL SCA -45,777.85 -271,504.00 -271,504.00 -157,187.71 -186,363.00 -332,369.00 22.4% 10 LIQUID FUELS TAXES -4,926.28 -20,000.00 -20,000.00 .00 .00 -6,000.00 -70.0% 11 MENTAL HEALTH / EAR -20,235.48 -20,668.00 -23,168.00 -16,853.28 -20,901.00 -23,324.00 .7% 12 RETIREMENT -4,898,842.40 -5,485,000.00 -5,485,000.00 -4,660,098.70 -5,484,540.00 -6,133,695.00 11.8% 16 GEN ADMIN DIRECT SU -3,927,799.64 -4,272,885.00 -4,272,885.00 -3,446,954.51 -4,267,714.00 -4,496,095.00 5.2% 17 HUMAN SERVICES BLDG -331,110.18 -359,601.00 -359,601.00 -300,000.61 -358,699.00 -387,654.00 7.8% 22 HAZARDOUS MATERIALS -41,032.85 -38,150.00 -38,150.00 -52,513.17 -52,339.00 -42,150.00 10.5% 24 WORKERS COMPENSATIO -763,782.68 -706,418.00 -706,418.00 -654,220.67 -706,418.00 -914,028.00 29.4% 27 POST EMP HEALTH BEN -154,447.95 -150,000.00 -150,000.00 -113,823.15 -120,500.00 -150,000.00 .0% 28 ADMIN ANNEX OCCUPAN -418,895.95 -384,963.00 -384,963.00 -278,508.80 -384,963.00 -344,091.00 -10.6% 30 SELF-FUNDED EMPLOYE .00 .00 -260,300.00 -244,676.84 -272,800.00 -272,500.00 4.7% 11/21/2019 10:24 |** Live Database **|P 7 ekwitmer |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts PROJECTION:20201 2020 PROPOSED BUDGET FOR PERIOD 99 07 CHARGES FOR SERVICE 2018 2019 2019 2019 2019 2020 PCT ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED CHANGE ____________________________________________________________________________________________________________________________________ 31 HUMAN SERVICES ADMI -342,253.68 -380,871.00 -380,871.00 -291,051.95 -349,414.00 -396,608.00 4.1% 34 INTELLECTUAL DISABI -632.36 -689.00 -689.00 -641.65 -1,198.00 -1,398.00 102.9% 36 BH MANAGED CARE -533,994.23 -592,298.00 -592,298.00 -447,998.63 -599,425.00 -624,095.00 5.4% 41 RESERVE FOR REPLACE .00 -17,550.00 -54,850.00 .00 -54,850.00 .00 -100.0% 88 SPECIAL REVENUE TRU -128,393.00 -116,000.00 -116,000.00 -99,034.00 -110,100.00 -116,000.00 .0% TOTAL 07 CHARGES FOR SERVICE -20,060,592.13 -20,872,584.00 -21,673,949.00 -17,759,016.65 -21,554,187.00 -23,075,278.00 6.5% 11/21/2019 10:24 |** Live Database **|P 8 ekwitmer |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts PROJECTION:20201 2020 PROPOSED BUDGET FOR PERIOD 99 08 CONTRIBTNS / OTHER 2018 2019 2019 2019 2019 2020 PCT ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED CHANGE ____________________________________________________________________________________________________________________________________ 01 GENERAL GOVT OPERAT -785,698.51 -778,944.00 -836,896.00 -957,127.71 -1,209,435.00 -1,197,974.00 43.1% 03 DEBT SERVICE -1,982,311.32 .00 .00 .00 .00 .00 .0% 04 AGING SERVICES PSA -24,254.76 -351,549.00 -30,000.00 -1,372.97 -30,000.00 -100,484.00 234.9% 05 CHILDREN & YOUTH SE -718.87 -2,000.00 -2,000.00 -321.50 -375.00 -500.00 -75.0% 07 DRUG & ALCOHOL SCA -2,513.02 -3,500.00 -3,500.00 -2,060.15 -2,300.00 -2,400.00 -31.4% 10 LIQUID FUELS TAXES -1,354.54 -750.00 -750.00 -1,402.30 -1,402.00 -750.00 .0% 11 MENTAL HEALTH / EAR -25,735.16 -23,996.00 -23,996.00 -26,420.90 -22,332.00 -38,867.00 62.0% 12 RETIREMENT 7,948,153.81 -4,752,500.00 -4,752,500.00 -16,630,284.80 -15,827,500.00 -13,022,000.00 174.0% 16 GEN ADMIN DIRECT SU -3,433.69 .00 .00 -73.50 .00 .00 .0% 17 HUMAN SERVICES BLDG -12,930.61 .00 .00 .00 .00 .00 .0% 21 E 911 SERVICES -9,841.44 .00 .00 .00 .00 .00 .0% 24 WORKERS COMPENSATIO -96,536.61 -14,500.00 -14,500.00 -36,914.43 -38,000.00 -33,500.00 131.0% 27 POST EMP HEALTH BEN 843,634.34 -600,000.00 -600,000.00 -1,620,649.17 -1,100,000.00 -600,000.00 .0% 28 ADMIN ANNEX OCCUPAN 12,930.61 .00 .00 .00 .00 .00 .0% 32 NON-CATEG HUMAN SER -10,119.13 -12,778.00 -12,778.00 -8,543.86 -10,003.00 -12,943.00 1.3% 11/21/2019 10:24 |** Live Database **|P 9 ekwitmer |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts PROJECTION:20201 2020 PROPOSED BUDGET FOR PERIOD 99 08 CONTRIBTNS / OTHER 2018 2019 2019 2019 2019 2020 PCT ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED CHANGE ____________________________________________________________________________________________________________________________________ 34 INTELLECTUAL DISABI -19,244.26 -19,229.00 -19,229.00 -741.37 -970.00 -19,970.00 3.9% 35 COMMUNITY SERVICES -53,373.77 -56,000.00 -56,000.00 -17,009.72 -17,557.00 -69,084.00 23.4% 42 CAPITAL PROJECT COU -55,551,390.28 .00 .00 .00 .00 -10,000,000.00 .0% 88 SPECIAL REVENUE TRU -255,097.74 -294,320.00 -294,320.00 -320,856.85 -383,886.00 -411,200.00 39.7% TOTAL 08 CONTRIBTNS / OTHER -50,029,834.95 -6,910,066.00 -6,646,469.00 -19,623,779.23 -18,643,760.00 -25,509,672.00 283.8% 11/21/2019 10:24 |** Live Database **|P 10 ekwitmer |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts PROJECTION:20201 2020 PROPOSED BUDGET FOR PERIOD 99 09 TRANSFERS IN 2018 2019 2019 2019 2019 2020 PCT ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED CHANGE ____________________________________________________________________________________________________________________________________ 01 GENERAL GOVT OPERAT -124,079.45 -61,335.00 -90,930.00 -106,825.51 -145,773.00 -67,017.00 -26.3% 04 AGING SERVICES PSA -355,629.00 -340,000.00 -340,000.00 -286,547.83 -315,643.00 -318,000.00 -6.5% 05 CHILDREN & YOUTH SE -1,987,706.82 -2,450,250.00 -2,693,722.00 -2,247,702.39 -2,769,845.00 -2,831,595.00 5.1% 06 DOMESTIC RELATIONS -652,853.01 -628,297.00 -641,813.00 -523,580.80 -602,292.00 -686,896.00 7.0% 07 DRUG & ALCOHOL SCA -82,894.87 -64,797.00 -64,797.00 -56,230.70 -84,870.00 -65,000.00 .3% 10 LIQUID FUELS TAXES .00 -20,000.00 -20,000.00 .00 -3,000.00 -15,000.00 -25.0% 11 MENTAL HEALTH / EAR -222,560.15 -234,215.00 -276,676.00 -195,360.57 -255,359.00 -266,500.00 -3.7% 20 COMM DEVEL BLOCK GR -109,187.65 -18,006.00 -18,006.00 -249.37 -15,563.00 -58,871.00 227.0% 21 E 911 SERVICES .00 -1,184,875.00 -1,230,620.00 -998,832.06 -723,788.00 -953,907.00 -22.5% 22 HAZARDOUS MATERIALS -87,415.77 -102,375.00 -102,375.00 -85,417.31 -102,294.00 -81,909.00 -20.0% 32 NON-CATEG HUMAN SER -27,277.89 -26,537.00 -26,537.00 -22,479.52 -26,033.00 -28,182.00 6.2% 34 INTELLECTUAL DISABI -45,410.00 -44,820.00 -44,820.00 -34,205.00 -46,000.00 -45,000.00 .4% 35 COMMUNITY SERVICES -17,119.10 -19,000.00 -19,000.00 -4,410.90 -8,609.00 -7,025.00 -63.0% 40 CAPITAL PROJECTS -272,343.47 .00 .00 .00 .00 .00 .0% 41 RESERVE FOR REPLACE -750,000.00 .00 .00 .00 .00 .00 .0% 11/21/2019 10:24 |** Live Database **|P 11 ekwitmer |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts PROJECTION:20201 2020 PROPOSED BUDGET FOR PERIOD 99 09 TRANSFERS IN 2018 2019 2019 2019 2019 2020 PCT ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED CHANGE ____________________________________________________________________________________________________________________________________ 88 SPECIAL REVENUE TRU -377,030.27 -150,000.00 -150,000.00 -150,000.00 -150,000.00 -150,000.00 .0% TOTAL 09 TRANSFERS IN -5,111,507.45 -5,344,507.00 -5,719,296.00 -4,711,841.96 -5,249,069.00 -5,574,902.00 -2.5% TOTAL REVENUE -151,409,472.28 -115,789,164.00 -118,220,915.00 -114,409,968.26 -126,458,138.00 -141,142,974.00 19.4% TOTAL EXPENSE .00 .00 .00 .00 .00 .00 .0% GRAND TOTAL -151,409,472.28 -115,789,164.00 -118,220,915.00 -114,409,968.26 -126,458,138.00 -141,142,974.00 19.4% ** END OF REPORT - Generated by Erin K Witmer **