Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
17 Water Operating
Budget Comparison Report Object Fund: 610 - WATER OPERATING Category: 4100 - PERSONAL SERVICES 4100 - SALARY -FULL TIME 4110 - OVERTIME F. T. 4120 - SAL-P.T./TEMP 4140 - PENSIONS 4141-PERA 4142 - FICA 4144- HEALTH INSURANCE 4148 - WORKERS COMP Total Category: 4100 - PERSONAL SERVICES: Category: 4200 - COMMODITIES 4200 - OFFICE SUPPLIES 4210 - OP SUPPLY -OTHER 4211- MOTOR FUELS 4212 - LUB/ADD 4216 - FERTILIZER/CHEM 4217 - CLOTHING/UNIFORM 4231- SMALL TOOLS 4270 - OP SUP-VEH/EQ 4271- OP SUP -OTHER IMP 4272 - OP SUP -BUILDINGS 4280 - CAPITAL OUTLAY <$5,000 Total Category: 4200 - COMMODITIES: Category: 4300 - CONTRACTUAL SERVICES 272.73% 117,400.00 6,700.00 Comparison 1 Comparison 1 4300 - PROF SERVICES Comparison 2 Comparison 2 25,565.25 29,700.00 110,700.00 4301- ENGINEERING SVS Parent Budget Budget to Parent % Budget to Comparison % 623.50 971.50 1,500.00 1,530.00 4305 - FEES FOR SERVICE Budget 39,451.21 16,945.98 1 Budget 53,000.00 2015 2016 2017 2017 2018 Increase / 4310 -COMMUNICATION 2019 increase/ 5,725.68 Total Activity Total Activity YTD Activity 2017 2018 (Decrease) 21,900.00 2019 fall 2017 (Decrease) 78,746.96 75,150.96 45,854.06 Through Jul 81,780.00 4340 -PRINTING 17,002.50 16,691.00 9,553.00 17,320.00 17,300.00 373,277.21 401,353.53 199,763.18 362,300.00 375,650.00 13,350.00 3.68% 387,700.00 12,050.00 3.21% 20,098.93 18,456.95 14,027.99 11,700.00 12,070.00 370.00 3.16% 12,430.00 360.00 2.98% 11,973.00 10,402.64 5,640.00 5,900.00 5,880.00 -20.00 -0.34% 5,880.00 0.00 0.00% 0.00 55,298.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 37,768.42 30,738.41 16,612.52 29,000.00 30,050.00 1,050.00 3.62% 31,010.00 960.00 3.19% 28,384.84 29,298.75 15,755.47 29,100.00 30,115.00 1,015.00 3.49% 31,060.00 945.00 3.14% 51,190.04 60,100.92 24,587.50 42,150.00 43,710.00 1,560.00 3.70% 45,730.00 2,020.00 4.62% 10,000.08 14,050.08 8,195.88 14,050.00 15,450.00 1,400.00 9.96% 15,900.00 450.00 2.91% 532,692.52 619,699.28 284,582.54 494,200.00 512,925.00 18,725.00 3.79% 529,710.00 16,785.00 3.27% 157.38 40.04 0.00 100.00 100.00 0.00 0.00% 100.00 0.00 0.00% 239,562.57 76,676.04 29,803.03 425,150.00 425,150.00 0.00 0.00% 100,150.00 -325,000.00 -76.44% 22,454.95 16,233.04 6,191.65 26,200.00 21,000.00 -5,200.00 -19.85% 21,000.00 0.00 0.00% 268.37 94.94 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 19,381.17 21,285.83 1,749.36 24,960.00 24,960.00 0.00 0.00% 25,500.00 540.00 2.16% 3,476.90 3,048.60 1,817.48 2,780.00 2,800.00 20.00 0.72% 2,860.00 60.00 2,14% 844.66 1,024.37 419.76 2,500.00 1,500.00 -1,000.00 -40.00% 1,500.00 0.00 0.00% 50.27 0.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 18,510.27 18,476.04 26,976.82 20,200.00 20,400.00 200.00 0.99% 20,810.00 410.00 2.01% 6,877.24 2,722.98 483.68 5,950.00 15,000.00 9,050.00 152.10% 6,120.00 -8,880.00 -59.20% 3,403.99 26,852.50 0.00 5,200.00 4,000.00 -1,200.00 -23.08% 4,080.00 80.00 2.00% 314,987.77 166,454.38 67,441.78 513,040.00 514,910.00 1,870.00 0.36% 182,120.00 -332,790.00 -64.63% Category: 4300 - CONTRACTUAL SERVICES 272.73% 117,400.00 6,700.00 6.05% -25,800.00 4300 - PROF SERVICES 16,626.36 11,184.36 25,565.25 29,700.00 110,700.00 4301- ENGINEERING SVS 88,891.82 113,702.12 57,829.64 97,000.00 71,200.00 4302 - LEGAL SERVICE 28.00 623.50 971.50 1,500.00 1,530.00 4305 - FEES FOR SERVICE 38,979.97 39,451.21 16,945.98 53,700.00 53,000.00 4309 - CREDIT CARD FEES 2,376.94 4,240.34 2,385.95 5,150.00 5,150.00 4310 -COMMUNICATION 4,766.28 4,994.98 5,725.68 5,140.00 5,200.00 4311 -POSTAGE 20,070.65 20,231.44 11,481.00 21,900.00 21,900.00 4321- DATA PROCESSING 78,746.96 75,150.96 45,854.06 81,775.00 81,780.00 4340 -PRINTING 17,002.50 16,691.00 9,553.00 17,320.00 17,300.00 4341-ADVER/PUBLISH 176.20 1,340.57 1,076.13 125.00 500.00 4350 - INSURANCE CHARGE 9,999.96 9,999.96 4,666.69 8,000.00 8,000.00 4360 -UTILITIES 231,545.15 244,901.48 106,946.73 233,000.00 235,000.00 4370 - MAINT-REPAIR/EQ 493.86 750.04 0.00 500.00 500.00 4371-MAINT-REPAIR/OTH 149,237.47 116,837.68 37,617.60 155,000.00 158,100.00 81,000.00 272.73% 117,400.00 6,700.00 6.05% -25,800.00 -26.60% 72,400.00 1,200.00 1.69% 30.00 2.00% 1,560.00 30.00 1.96% -700.00 -1.30% 54,060.00 1,060.00 2.00% 0.00 0.00% 5,250.00 100.00 1.94% 60.00 1.17% 5,300.00 100.00 1.92% 0.00 0.00% 22,340.00 440.00 2.01% 5.00 0.01% 83,400.00 1,620.00 1.98% -20.00 -0.12% 17,650.00 350.00 2,02% 375.00 300.00% 500.00 0.00 0.00% 0.00 0.00% 8,000.00 0,00 0.00% 2,000.00 0.86% 239,700.00 4,700.00 2.00% 0.00 0.00% 510.00 10.00 2.00% 3,100.00 2.00% 161,260.00 3,160.00 2.00% 7/25/2017 2:37:30 PM Page 6 of 14 Budget Comparison Report 7/25/2017 2:37:30 PM Page 7 of 14 Comparison 1 Comparison 1 Comparison 2 Comparison 2 Parent Budget Budget to Parent % Budget to Comparison Budget 1 Budget 2015 2016 2017 2017 2018 Increase / 2019 Increase / Total Activity Total Activity YTD Activity 2017 2018 (Decrease) 2019 fall 2017 (Decrease) Object Through Jul 4372-MAINT-REPAIR/BLD 3,138.95 973.85 7,546.64 7,000.00 7,140.00 140.00 2.00% 7,200.00 60.00 0.84% 4375 - CHARGE -FLEET MNT 37,916.75 15,397.84 10,702.22 38,700.00 20,000.00 -18,700.00 -48.32% 20,000.00 0.00 0.00% 4380 - RENTAL/LEASE 121.50 81.00 0.00 100.00 100.00 0.00 0100% 105.00 5.00 5.00% 4401- DUES & SUBS 1,861.00 1,834.00 1,911.00 2,300.00 2,300.00 0.00 0100% 2,350.00 50.00 2.17% 4403-TRAVEL/TRAIN/CON 1,289.09 1,421.96 2,543.50 3,900.00 3,900.00 0.00 0.00% 3,970.00 70.00 1.79% 4405 - CLEAN/WASTE REMV 82.00 178.34 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4438 - PRO/MISC RESALE 0.00 0.00 0.00 55,150.00 55,150.00 0.00 0.00% 56,200.00 1,050.00 1.90% 4449 - OTHER CONTRACT 0.00 187.66 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% Total Category: 4300 - CONTRACTUAL SERVICES: 703,351.41 680,174.29 349,322.57 816,960.00 858,450.00 41,490.00 5.08% 879,155.00 20,705.00 2.41% Category: 4500 - CAPITAL OUTLAY 4530 - MACH & EQUIPMENT 0.00 0.00 119,058.00 153,000.00 9,000.00 -144,000.00 -94.12% 0.00 -9,000.00 -100.00% 4540 - OTHER CAP OUTLAY 0.00 0.00 0.00 0.00 150,000.00 150,000.00 0.00% 153,000.00 3,000.00 2.00% Total Category: 4500 - CAPITAL OUTLAY: 0.00 0.00 119,058.00 153,000.00 159,000.00 6,000.00 3.92% 153,000.00 -6,000.00 -3.77% Category: 4600 - OTHER FINANCING USES 4600 -PRINCIPAL 0.00 0.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4610 -INTEREST 20,471.64 -7,974.18 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4620 - PAYING AGENT FEE 500.00 0.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4621- BOND ISSUANCE COSTS 0.00 0.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% Total Category: 4600 - OTHER FINANCING USES: 20,971.64 -7,974.18 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% Category: 4720 - DEPRECIATION 4720 -DEPRECIATION -CONTRIBUTED 498,597.12 0.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4721 -DEPRECIATION -PURCHASED 362,844.39 889,476.16 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% Total Category: 4720 - DEPRECIATION: 861,441.51 889,476.16 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% Category: 4730 - MISCELLANEOUS 4731- MISCELLANEOUS 0.00 7,569.94 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4732 - LOSS -FIXED ASSET 935.85 3,000.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% Total Category: 4730 - MISCELLANEOUS: 935.85 10,569.94 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% Category: 4999 - TRANSFERS OUT 4700 -TRANSFERS OUT 266,781.65 166,554.00 150,353.00 257,750.00 261,800.00 4,050.00 1.57% 261,800.00 0.00 0.00% Total Category: 4999 - TRANSFERS OUT: 266,781.65 166,554.00 150,353.00 257,750.00 261,800.00 4,050.00 1.57% 261,800.00 0.00 0.00% Total Fund: 610 - WATER OPERATING: 2,701,162.35 2,524,953.87 970,757.89 2,234,950.00 2,307,085.00 72,135.00 3.23% 2,005,785.00 -301,300.00 -13.06% 7/25/2017 2:37:30 PM Page 7 of 14