Loading...
HomeMy WebLinkAboutAll Funds - Revenue by Source 11/20/2017 11:08 |** Live Database **|P 1 ekwitmer |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts PROJECTION:20181 2018 PROPOSED BUDGET FOR PERIOD 99 RE/LBRY/HOTEL TAXES 2016 2017 2017 2017 2017 2018 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT____________________________________________________________________________________________________________________________________ GENERAL GOVT OPERATION -35,466,792.78 -35,890,100.00 -35,890,100.00 -35,391,862.56 -35,756,760.00 -36,135,600.00 _________ DEBT SERVICE -3,706,203.88 -3,752,931.00 -3,752,931.00 -3,613,856.75 -3,728,106.00 -3,750,200.00 _________ TOURIST PROMOTION HOTE -638,970.37 -615,000.00 -933,000.00 -665,395.46 -720,000.00 -1,025,000.00 _________ TOTAL RE/LBRY/HOTEL TAXES -39,811,967.03 -40,258,031.00 -40,576,031.00 -39,671,114.77 -40,204,866.00 -40,910,800.00 _________ 11/20/2017 11:08 |** Live Database **|P 2 ekwitmer |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts PROJECTION:20181 2018 PROPOSED BUDGET FOR PERIOD 99 INTEREST 2016 2017 2017 2017 2017 2018 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT____________________________________________________________________________________________________________________________________ GENERAL GOVT OPERATION -120,744.34 -50,050.00 -50,050.00 -67,682.90 -76,550.00 -77,050.00 _________ DEBT SERVICE -4,379.29 -3,500.00 -3,500.00 -2,846.40 -3,500.00 -3,500.00 _________ AGING SERVICES PSA 19 .00 .00 .00 .00 .00 .00 _________ CHILDREN & YOUTH SERVI .00 .00 .00 .32 .00 .00 _________ DOMESTIC RELATIONS -2,429.63 -2,100.00 -2,100.00 -2,392.15 -2,500.00 -2,600.00 _________ DRUG & ALCOHOL SCA SER -829.17 -800.00 -800.00 -603.98 -795.00 -800.00 _________ LIQUID FUELS TAXES -4,966.59 -5,000.00 -5,000.00 -3,959.10 -5,000.00 -5,000.00 _________ MENTAL HEALTH / EARLY -2,429.99 -3,529.00 -3,529.00 -2,077.77 -2,684.00 -2,879.00 _________ RETIREMENT -2,207,123.13 -1,700,350.00 -1,700,350.00 -1,799,537.39 -2,143,625.00 -2,171,325.00 _________ E 911 SERVICES -673.95 -750.00 -750.00 -233.92 -325.00 -270.00 _________ HAZARDOUS MATERIALS -22.19 -23.00 -23.00 -32.58 -39.00 -35.00 _________ WORKERS COMPENSATION -23,201.82 -30,000.00 -30,000.00 -25,339.72 -30,000.00 -30,000.00 _________ POST EMP HEALTH BEN CO -239,840.16 -225,000.00 -225,000.00 -187,052.61 -225,000.00 -225,000.00 _________ TOURIST PROMOTION HOTE 1,431.50 -100.00 -100.00 -77.04 -100.00 .00 _________ INTELLECTUAL DISABILIT -695.62 -825.00 -825.00 -538.27 -691.00 -500.00 _________ 11/20/2017 11:08 |** Live Database **|P 3 ekwitmer |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts PROJECTION:20181 2018 PROPOSED BUDGET FOR PERIOD 99 INTEREST 2016 2017 2017 2017 2017 2018 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT____________________________________________________________________________________________________________________________________ COMMUNITY SERVICES DEP -80.39 -80.00 -80.00 -13.93 -11.00 -15.00 _________ SPECIAL REVENUE TRUSTS -1,613.35 -440.00 -440.00 -1,906.51 -1,900.00 -1,940.00 _________ TOTAL INTEREST -2,607,598.12 -2,022,547.00 -2,022,547.00 -2,094,293.95 -2,492,720.00 -2,520,914.00 _________ 11/20/2017 11:08 |** Live Database **|P 4 ekwitmer |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts PROJECTION:20181 2018 PROPOSED BUDGET FOR PERIOD 99 I/GOVT REV - FEDERAL 2016 2017 2017 2017 2017 2018 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT____________________________________________________________________________________________________________________________________ GENERAL GOVT OPERATION -244,896.45 -719,695.00 -876,831.00 -238,403.33 -364,582.00 -452,353.00 _________ AGING SERVICES PSA 19 -908,079.00 -933,801.00 -933,801.00 -684,394.00 -940,703.00 -940,703.00 _________ CHILDREN & YOUTH SERVI -2,262,196.74 -2,521,010.00 -2,882,183.00 -1,869,759.19 -2,520,012.00 -2,408,131.00 _________ DOMESTIC RELATIONS -1,506,618.22 -1,519,346.00 -1,538,890.00 -986,733.53 -1,519,937.00 -1,519,946.00 _________ DRUG & ALCOHOL SCA SER -417,556.00 -323,160.00 -323,160.00 -322,718.00 -356,006.00 -323,160.00 _________ LIQUID FUELS TAXES -237,145.83 -415,520.00 -415,520.00 -105,440.16 -415,520.00 -100,000.00 _________ MENTAL HEALTH / EARLY -331,708.61 -307,879.00 -310,779.00 -260,464.17 -294,983.00 -297,500.00 _________ GEN ADMIN DIRECT SUPPO -53,075.16 .00 .00 .00 .00 .00 _________ COMM DEVEL BLOCK GRANT -118,717.79 -1,264,011.00 -1,264,011.00 .00 -318,215.00 -836,552.00 _________ HAZARDOUS MATERIALS -12,168.41 -11,991.00 -11,991.00 -13,692.08 -9,594.00 -9,591.00 _________ NON-CATEG HUMAN SERVIC -572,938.22 -589,187.00 -648,429.00 -519,285.91 -628,589.00 -658,388.00 _________ INTELLECTUAL DISABILIT -296,452.85 -321,088.00 -321,088.00 -307,119.41 -315,318.00 -322,138.00 _________ TOTAL I/GOVT REV - FEDERAL -6,961,553.28 -8,926,688.00 -9,526,683.00 -5,308,009.78 -7,683,459.00 -7,868,462.00 _________ 11/20/2017 11:08 |** Live Database **|P 5 ekwitmer |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts PROJECTION:20181 2018 PROPOSED BUDGET FOR PERIOD 99 I/GOVT REV - STATE 2016 2017 2017 2017 2017 2018 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT____________________________________________________________________________________________________________________________________ GENERAL GOVT OPERATION -1,514,252.94 -1,405,804.00 -1,876,122.11 -1,219,452.04 -1,599,645.00 -1,571,355.00 _________ AGING SERVICES PSA 19 -2,401,674.00 -2,539,950.00 -2,539,950.00 -2,007,489.00 -2,539,950.00 -2,578,634.00 _________ CHILDREN & YOUTH SERVI -6,178,818.27 -6,782,225.00 -6,771,295.00 -4,429,554.50 -6,782,225.00 -6,904,764.00 _________ DRUG & ALCOHOL SCA SER -771,172.00 -649,035.00 -770,688.00 -742,218.00 -747,521.00 -637,535.00 _________ LIQUID FUELS TAXES -750,462.53 -730,880.00 -730,880.00 -505,468.95 -730,880.00 -667,000.00 _________ MENTAL HEALTH / EARLY -5,711,841.37 -5,615,803.00 -5,718,318.00 -5,598,851.23 -5,481,186.00 -5,651,851.00 _________ E 911 SERVICES -3,117,033.32 .00 -3,100,000.00 -1,557,512.99 -3,115,025.00 -3,095,923.00 _________ HAZARDOUS MATERIALS -51,150.00 -38,302.00 -38,302.00 -44,887.00 -48,302.00 -25,077.00 _________ WORKERS COMPENSATION .00 -5,000.00 -5,000.00 .00 -5,000.00 -5,000.00 _________ INTELLECTUAL DISABILIT -747,596.48 -727,355.00 -687,879.00 -640,132.09 -592,622.00 -751,255.00 _________ COMMUNITY SERVICES DEP -319,228.24 -337,625.00 -316,878.00 -307,576.28 -278,162.00 -312,589.00 _________ SPECIAL REVENUE TRUSTS -120,472.97 -125,000.00 -125,000.00 -117,203.07 -132,000.00 -122,000.00 _________ TOTAL I/GOVT REV - STATE -21,683,702.12 -18,956,979.00 -22,680,312.11 -17,170,345.15 -22,052,518.00 -22,322,983.00 _________ 11/20/2017 11:08 |** Live Database **|P 6 ekwitmer |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts PROJECTION:20181 2018 PROPOSED BUDGET FOR PERIOD 99 CHARGES FOR SERVICE 2016 2017 2017 2017 2017 2018 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT____________________________________________________________________________________________________________________________________ GENERAL GOVT OPERATION -7,408,576.55 -7,318,405.00 -7,494,059.00 -6,499,686.76 -7,472,376.00 -7,229,087.00 _________ AGING SERVICES PSA 19 -280,733.39 -301,806.00 -301,806.00 -211,570.08 -319,317.00 -301,067.00 _________ CHILDREN & YOUTH SERVI -126,282.18 -145,850.00 -145,850.00 -87,227.97 -145,850.00 -95,970.00 _________ DOMESTIC RELATIONS -86,920.30 -95,000.00 -95,000.00 -77,014.80 -95,000.00 -101,000.00 _________ DRUG & ALCOHOL SCA SER 11,251.56 -210,689.00 -210,689.00 -12,623.12 -95,885.00 -302,000.00 _________ LIQUID FUELS TAXES -3,602.40 -5,000.00 -5,000.00 -2,465.92 -5,000.00 -5,000.00 _________ MENTAL HEALTH / EARLY -20,461.82 -20,398.00 -20,398.00 -15,236.88 -20,110.00 -19,685.00 _________ RETIREMENT -4,945,767.59 -4,580,000.00 -4,580,000.00 -4,232,087.67 -4,786,434.00 -4,905,000.00 _________ GEN ADMIN DIRECT SUPPO -3,521,179.64 -4,207,761.00 -4,207,761.00 -2,854,849.81 -4,207,761.00 -4,338,753.00 _________ HUMAN SERVICES BLDG OC -322,863.01 -418,597.00 -418,597.00 -252,592.17 -418,597.00 -439,034.00 _________ E 911 SERVICES .00 -3,095,923.00 .00 .00 .00 .00 _________ HAZARDOUS MATERIALS -41,708.58 -36,600.00 -36,600.00 -28,715.14 -28,716.00 -28,500.00 _________ WORKERS COMPENSATION -749,852.47 -746,023.00 -746,023.00 -716,608.93 -746,023.00 -733,596.00 _________ POST EMP HEALTH BEN CO -126,924.43 -150,000.00 -150,000.00 -118,896.27 -150,000.00 -150,000.00 _________ ADMIN ANNEX OCCUPANCY -358,607.80 -403,182.00 -403,182.00 -242,324.76 -403,182.00 -387,464.00 _________ 11/20/2017 11:08 |** Live Database **|P 7 ekwitmer |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts PROJECTION:20181 2018 PROPOSED BUDGET FOR PERIOD 99 CHARGES FOR SERVICE 2016 2017 2017 2017 2017 2018 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT____________________________________________________________________________________________________________________________________ HUMAN SERVICES ADMINIS -271,664.15 -362,793.00 -362,793.00 -198,917.14 -362,793.00 -325,246.00 _________ TOURIST PROMOTION HOTE .00 .00 .00 -15.00 .00 .00 _________ INTELLECTUAL DISABILIT -1,315.66 -1,446.00 -1,446.00 -744.79 -1,076.00 -1,075.00 _________ BH MANAGED CARE -485,483.24 -739,587.00 -739,587.00 -330,773.40 -434,418.00 -579,824.00 _________ SPECIAL REVENUE TRUSTS -126,464.00 -128,000.00 -128,000.00 -119,396.00 -142,200.00 -128,000.00 _________ TOTAL CHARGES FOR SERVICE -18,867,155.65 -22,967,060.00 -20,046,791.00 -16,001,746.61 -19,834,738.00 -20,070,301.00 _________ 11/20/2017 11:08 |** Live Database **|P 8 ekwitmer |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts PROJECTION:20181 2018 PROPOSED BUDGET FOR PERIOD 99 CONTRIBTNS / OTHER 2016 2017 2017 2017 2017 2018 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT____________________________________________________________________________________________________________________________________ GENERAL GOVT OPERATION -1,293,927.95 -961,300.00 -983,369.00 -665,651.19 -830,222.00 -951,726.00 _________ AGING SERVICES PSA 19 -22,267.76 -21,100.00 -21,100.00 -26,552.69 -40,000.00 -40,000.00 _________ CHILDREN & YOUTH SERVI -1,476.67 -2,175.00 -6,813.00 -6,757.77 -2,175.00 -3,000.00 _________ DOMESTIC RELATIONS -17.34 .00 .00 .00 .00 .00 _________ DRUG & ALCOHOL SCA SER .00 .00 -5,000.00 -5,136.85 -7,401.00 -3,626.00 _________ LIQUID FUELS TAXES -299.00 -2,500.00 -2,500.00 .00 -2,500.00 -2,500.00 _________ MENTAL HEALTH / EARLY -21,007.25 -15,015.00 -15,015.00 -27,039.27 -31,264.00 -20,739.00 _________ RETIREMENT -5,821,408.94 -5,197,500.00 -5,197,500.00 -12,149,035.66 -6,034,000.00 -6,033,000.00 _________ GEN ADMIN DIRECT SUPPO -24.00 .00 .00 -16.50 .00 .00 _________ HUMAN SERVICES BLDG OC -1,007.00 .00 -12,931.00 .00 .00 .00 _________ HAZARDOUS MATERIALS -20.00 .00 .00 .00 .00 .00 _________ WORKERS COMPENSATION 5,490.63 7,000.00 7,000.00 4,940.51 7,000.00 7,000.00 _________ POST EMP HEALTH BEN CO -665,262.83 -300,000.00 -300,000.00 -1,260,803.79 -300,000.00 -600,000.00 _________ ADMIN ANNEX OCCUPANCY -4,841.00 .00 .00 -50.00 .00 .00 _________ NON-CATEG HUMAN SERVIC -17,936.66 -18,371.00 -18,371.00 -7,007.84 -10,911.00 -9,500.00 _________ 11/20/2017 11:08 |** Live Database **|P 9 ekwitmer |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts PROJECTION:20181 2018 PROPOSED BUDGET FOR PERIOD 99 CONTRIBTNS / OTHER 2016 2017 2017 2017 2017 2018 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT____________________________________________________________________________________________________________________________________ INTELLECTUAL DISABILIT -10,108.92 -19,192.00 -19,192.00 -37,215.35 -19,753.00 -19,195.00 _________ COMMUNITY SERVICES DEP -48,274.88 -52,416.00 -52,416.00 -46,163.13 -52,501.00 -56,000.00 _________ SPECIAL REVENUE TRUSTS -60,407.46 -30,000.00 -185,900.00 -58,183.12 -208,500.00 -260,800.00 _________ TOTAL CONTRIBTNS / OTHER -7,962,797.03 -6,612,569.00 -6,813,107.00 -14,284,672.65 -7,532,227.00 -7,993,086.00 _________ 11/20/2017 11:08 |** Live Database **|P 10 ekwitmer |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts PROJECTION:20181 2018 PROPOSED BUDGET FOR PERIOD 99 TRANSFERS IN 2016 2017 2017 2017 2017 2018 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT____________________________________________________________________________________________________________________________________ GENERAL GOVT OPERATION -10,106.00 .00 -38,007.00 .00 .00 .00 _________ AGING SERVICES PSA 19 -214,965.32 -236,000.00 -236,000.00 -210,516.00 -279,552.00 -270,000.00 _________ CHILDREN & YOUTH SERVI -2,243,805.15 -2,185,182.00 -2,185,182.00 -2,190,160.53 -2,344,929.00 -2,300,000.00 _________ DOMESTIC RELATIONS -522,169.31 -671,778.00 -671,778.00 -559,815.00 -691,793.00 -608,206.00 _________ DRUG & ALCOHOL SCA SER -44,080.64 -66,330.00 -66,330.00 -40,892.41 -54,576.00 -60,000.00 _________ LIQUID FUELS TAXES .00 .00 .00 -47,574.93 .00 -16,500.00 _________ MENTAL HEALTH / EARLY -213,334.00 -200,928.00 -200,928.00 -149,015.99 -197,685.00 -194,580.00 _________ COMM DEVEL BLOCK GRANT -32,201.10 -27,559.00 -27,559.00 .00 -27,559.00 -25,815.00 _________ E 911 SERVICES -1,087,740.71 -1,111,338.00 -1,111,338.00 -398,748.21 -703,858.00 -903,692.00 _________ HAZARDOUS MATERIALS -72,991.66 -80,554.00 -80,554.00 -55,510.08 -145,398.00 -86,784.00 _________ NON-CATEG HUMAN SERVIC -14,000.00 -14,000.00 -14,000.00 -14,000.00 -14,000.00 -14,000.00 _________ INTELLECTUAL DISABILIT -46,500.00 -46,500.00 -46,500.00 -32,496.00 -44,541.00 -42,500.00 _________ COMMUNITY SERVICES DEP 6,149.71 -100,000.00 -100,000.00 .00 .00 .00 _________ GASB 34 ADJUSTMENTS 13,843.00 .00 .00 .00 .00 .00 _________ SPECIAL REVENUE TRUSTS -375,000.00 -350,000.00 -350,000.00 .00 -175,000.00 -150,000.00 _________ TOTAL TRANSFERS IN -4,856,901.18 -5,090,169.00 -5,128,176.00 -3,698,729.15 -4,678,891.00 -4,672,077.00 _________ TOTAL REVENUE -102,751,674.41 -104,834,043.00 -106,793,647.11 -98,228,912.06 -104,479,419.00 -106,358,623.00 _________ 11/20/2017 11:08 |** Live Database **|P 11 ekwitmer |NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS |bgnyrpts PROJECTION:20181 2018 PROPOSED BUDGET FOR PERIOD 99 TRANSFERS IN 2016 2017 2017 2017 2017 2018 ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION PROPOSED COMMENT____________________________________________________________________________________________________________________________________ TOTAL EXPENSE .00 .00 .00 .00 .00 .00 _________ GRAND TOTAL -102,751,674.41 -104,834,043.00 -106,793,647.11 -98,228,912.06 -104,479,419.00 -106,358,623.00 _________ ** END OF REPORT - Generated by Erin K Witmer **