Loading...
HomeMy WebLinkAbout21 Street LightsBudget Comparison Report 7/25/2017 2:37:30 PM Page 10 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 Fund: 630 - STREET LIGHTS Category: 4100 - PERSONAL SERVICES 4100-SALARY-FULLTIME 55,880.47 58,121.38 42,360.74 59,300.00 61,100.00 1,800.00 3.04% 62,890.00 1,790.00 2.93% 4110 - OVERTIME F. T. 8,475.98 5,560.03 4,215.69 500.00 530.00 30.00 6.00% 5,880.00 5,350.00 1,009,43% 4120 - SAL-P.T./TEMP 0.00 0.00 0.00 5,880.00 0.00 -5,880.00 -100.00% 0.00 0.00 0.00% 4140 -PENSIONS 0.00 1,125.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4141- PERA 6,567.26 4,687.50 3,598.75 4,600.00 4,780.00 180.00 3.91% 4,916.00 136.00 2.85% 4142 - FICA 4,540.69 4,371.71 3,284.94 5,000.00 5,160.00 160.00 3.20% 4,850.00 -310.00 -6.01% 4144 -HEALTH INSURANCE 10,042.96 10,851.00 4,812.50 8,250.00 8,570.00 320.00 3.88% 8,570.00 0.00 0.00% 4148 - WORKERS COMP 3,699.96 5,100.00 3,325.00 5,700.00 6,050.00 350.00 6.14% 5,690.00 -360.00 -5.95% Total Category: 4100 - PERSONAL SERVICES: 89,207.32 89,816.62 61,597.62 89,230.00 86,190.00 -3,040.00 -3.41% 92,796.00 6,606.00 7.66% Category: 4200 - COMMODITIES 4210 -OP SUPPLY -OTHER 2,304.94 2,821.56 839.10 4,110.00 4,110.00 0.00 0.00% 4,190.00 80.00 1.95% 4211- MOTOR FUELS 5,378.89 4,260.96 1,957.03 5,800.00 5,200.00 -600.00 -10.34% 5,200.00 0.00 0.00% 4217-CLOTHING/UNIFORM 506.70 503.50 524.96 600.00 600.00 0.00 0.00% 610.00 10.00 1.67% 4231- SMALL TOOLS 1,563.36 259.49 282.20 800.00 800.00 0.00 0.00% 810.00 10.00 1.25% 4270 - OP SUP-VEH/EQ 0.00 0.00 0.00 200.00 200.00 0.00 0.00% 205.00 5.00 2.50% 4271 -OP SUP -OTHER IMP 37,952.59 38,834.97 26,286.92 46,200.00 46,200.00 0.00 0.00% 47,100.00 900.00 1.95% 4280 - CAPITAL OUTLAY <$5,000 6,544.50 3,436.10 0.00 3,600.00 3,600.00 0.00 0.00% 3,670.00 70.00 1.94% Total Category: 4200 - COMMODITIES: 54,250.98 50,116.58 29,890.21 61,310.00 60,710.00 -600.00 -0.98% 61,785.00 1,075.00 1.77% Category: 4300 - CONTRACTUAL SERVICES 4300 - PROF SERVICES 1,667.15 828.82 474.18 1,500.00 1,500.00 0.00 0.00% 1,530.00 30.00 2.00% 4301- ENGINEERING SVS 26,268.50 135.00 0.00 5,000.00 5,000.00 0.00 0.00% 5,100.00 100.00 2.00% 4305 - FEES FOR SERVICE 15,970.41 9,746.55 10,907.95 16,880.00 17,000.00 120.00 0.71% 17,340.00 340.00 2.00% 4309 - CREDIT CARD FEES 2,376.89 4,240.27 2,385.91 2,500.00 3,500.00 1,000.00 40.00% 3,500.00 0.00 0.00% 4310 -COMMUNICATION 830.20 840.28 757.62 895.00 900.00 5.00 0.56% 920.00 20.00 2.22% 4311 -POSTAGE 4,988.00 5,210.72 3,170.00 5,050.00 5,100.00 50.00 0.99% 5,200.00 100.00 1.96% 4321- DATA PROCESSING 9,594.80 8,695.07 11,363.52 19,400.00 19,000.00 -400.00 -2.06% 19,800.00 800.00 4.21% 4340 -PRINTING 4,141.00 4,472.80 2,391.00 4,250.00 4,250.00 0.00 0.00% 4,300.00 50.00 1.18% 4350 - INSURANCE CHARGE 8,000.04 8,000.04 4,666.69 8,000.00 8,000.00 0.00 0.00% 8,000.00 0.00 0.00% 4360 -UTILITIES 142,579.83 143,294.38 62,991.92 183,500.00 178,500.00 -5,000.00 -2.72% 178,500.00 0.00 0.00% 4361- NSP STREET LIGHT 71,339.59 74,818.14 37,417.73 92,905.00 92,905.00 0.00 0.00% 94,770.00 1,865.00 2.01% 4370 - MAINT-REPAIR/EQ 0.00 0.00 0.00 300.00 300.00 0.00 0.00% 305.00 5.00 1.67% 4371-MAINT-REPAIR/OTH 143,353.63 120,397.99 125,337.03 157,000.00 157,000.00 0.00 0.00% 160,140.00 3,140.00 2.00% 4375 - CHARGE -FLEET MNT 6,699.92 6,933.94 1,567.20 8,600.00 8,600.00 0.00 0.00% 8,600.00 0.00 0.00% 4401- DUES & SUBS 25.25 0.00 10.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4403-TRAVEL/TRAIN/CON 614.20 202.64 346.67 900.00 900.00 0.00 0.00% 920.00 20.00 2.22% 4438 - PRO/MISC RESALE 0.00 54,969.89 21,760.00 207,500.00 150,000.00 -57,500.00 -27.71% 150,000.00 0.00 0.00% 7/25/2017 2:37:30 PM Page 10 of 14 Budget Comparison Report 7/25/2017 2:37:30 PM Page 11 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 4449 - OTHER CONTRACT 0.00 32.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% Total Category, 4300 - CONTRACTUAL SERVICES: 438,449.41 442,818.53 285,547.42 714,180.00 652,455.00 -61,725.00 -8.64% 658,925.00 6,470.00 0.99% Category: 4500 - CAPITAL OUTLAY 4530 - MACH & EQUIPMENT 0100 0.00 26,070.00 54,000.00 9,000.00 -45,000.00 -83.33% 0.00 -9,000.00 -100.00% 4540 - OTHER CAP OUTLAY 0.00 0.00 0.00 458,500.00 467,670.00 9,170.00 2.00% 0.00 -467,670.00 -100.00% Total Category: 4500 - CAPITAL OUTLAY: 0.00 0.00 26,070.00 512,500.00 476,670.00 -35,830.00 -6.99% 0.00 -476,670.00 -100.00% Category: 4720 - DEPRECIATION 4720 -DEPRECIATION -CONTRIBUTED 123,591.84 0.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4721 -DEPRECIATION -PURCHASED 40,732.44 162,533.10 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% Total Category: 4720 - DEPRECIATION: 164,324.28 162,533.10 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% Category: 4999 - TRANSFERS OUT 4700 -TRANSFERS OUT 45,849.96 45,846.00 27,545.00 47,220.00 47,220.00 0.00 0.00% 0.00 -47,220.00 -100.00% Total Category: 4999 - TRANSFERS OUT: 45,849.96 45,846.00 27,545.00 47,220.00 47,220.00 0.00 0.00% 0.00 -47,220.00 -100.00% Total Fund: 630 - STREET LIGHTS: 792,081.95 791,130.83 430,650.25 1,424,440.00 1,323,245.00 -101,195.00 -7.10% 813,506.00 -509,739.00 -38.52% 7/25/2017 2:37:30 PM Page 11 of 14