Loading...
HomeMy WebLinkAbout01 Information TechnologyBudget Comparison Report 8/1/2017 10:33:53 AM Page 6 of 8 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 Aug Fund: 720 - INFORMATION TECHNOLOGY Category: 4100 - PERSONAL SERVICES 4100 -SALARY -FULL TIME 38,242.15 69,925.42 38,158.20 120,700.00 138,465.00 17,765.00 14.72% 146,150.00 7,685.00 5.55% 4115 - REGULAR-P/T REG STATUS 83,314.44 53,635.43 31,794.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4140- PENSIONS 0.00 6,512.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4141- PERA 12,326.45 8,990.00 5,449.59 9,350.00 10,730.00 1,380.00 14.76% 11,330.00 600.00 5.59% 4142 -FICA 8,820.12 8,707.40 5,257.19 9,230.00 10,600.00 1,370.00 14.84% 11,180.00 580.00 5.47% 4144 -HEALTH INSURANCE 20,244.04 21,858.00 10,386.64 15,580.00 17,140.00 1,560.00 10.01% 17,140.00 0.00 0.00% 4148 - WORKERS COMP 800.04 900.00 600.00 900.00 1,000.00 100.00 11.11% 1,040.00 40.00 4.00% Total Category: 4100 - PERSONAL SERVICES: 163,747.24 170,528.25 91,645.62 155,760.00 177,935.00 22,175.00 14.24% 186,840.00 8,905.00 5.00% Category: 4200 - COMMODITIES 4200 - OFFICE SUPPLIES 0.00 26.31 77.68 100.00 100.00 0.00 0.00% 100.00 0.00 0.00% 4210 - OP SUPPLY -OTHER 699.69 1,364.10 113.50 3,530.00 5,060.00 1,530.00 43.34% 5,160.00 100.00 1.98% 4211- MOTOR FUELS 0.00 131.47 24.33 500.00 150.00 -350.00 -70.00% 150.00 0.00 0.00% 4280 - CAPITAL OUTLAY <$5,000 70,456.37 44,023.94 23,986.96 56,500.00 131,000.00 74,500.00 131.86% 75,000.00 -56,000.00 -42.75% Total Category: 4200 - COMMODITIES: 71,156.06 45,545.82 24,202.47 60,630.00 136,310.00 75,680.00 124.82% 80,410.00 -55,900.00 -41.01% Category: 4300 - CONTRACTUAL SERVICES 4300 - PROF SERVICES 11,934.50 20,808.67 0.00 12,000.00 24,000.00 12,000.00 100.00% 24,000.00 0.00 0.00% 4305 - FEES FOR SERVICE 1,909.43 230.69 0.00 1,960.00 200.00 -1,760.00 -89.80% 200.00 0.00 0.00% 4310 -COMMUNICATION 27,684.08 34,881.74 35,393.67 32,360.00 58,060.00 25,700.00 79.42% 79,060.00 21,000.00 36.17% 4311 -POSTAGE 81.15 0.00 0.00 50.00 50.00 0.00 0.00% 0.00 -50.00 -100.00% 4321- DATA PROCESSING 59,664.80 87,816.15 97,716.21 115,270.00 59,020.00 -56,250.00 -48.80% 108,800.00 49,780.00 84,34% 4340- PRINTING 29.00 0.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4350 - INSURANCE CHARGE 1,599.96 1,599.96 1,066.64 1,600.00 1,600.00 0.00 0.00% 1,600.00 0.00 0.00% 4370 - MAINT-REPAIR/EQ 23,637.84 31,551.28 6,595.64 17,530.00 10,100.00 -7,430.00 -42.38% 10,100.00 0.00 0,00% 4371-MAINT-REPAIR/OTH 10,234.67 27,324.00 27,601.85 26,500.00 106,900.00 80,400.00 303.40% 112,000.00 5,100.00 4.77% 4375 - CHARGE -FLEET MNT 0.00 559.83 245.89 0.00 1,000.00 1,000.00 0.00% 1,000.00 0.00 0.00% 4380 - RENTAL/LEASE 335.95 1,725.18 150.12 840.00 840.00 0.00 0.00% 0.00 -840.00 -100.00% 4401- DUES & SUBS 132.00 165.00 0.00 500.00 500.00 0.00 0.00% 0.00 -500.00 -100,00% 4403-TRAVEL/TRAIN/CON 440.23 6,190.75 39.17 18,000.00 14,000.00 -4,000.00 -22.22% 14,000.00 0.00 0.00% 4449 - OTHER CONTRACT 0.00 67.61 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% Total Category: 4300 - CONTRACTUAL SERVICES: 137,683.61 212,920.86 168,809.19 226,610.00 276,270.00 49,660.00 21.91% 350,760.00 74,490.00 26.96% Category: 4500 - CAPITAL OUTLAY 4520 - FURN & OFF EQUIP 0.00 19,116.88 14,615.00 91,000.00 20,000.00 -71,000.00 -78.02% 20,000.00 0.00 0.00% Total Category: 4500 - CAPITAL OUTLAY: 0.00 19,116.88 14,615.00 91,000.00 20,000.00 -71,000.00 -78.02% 20,000.00 0.00 0.00% Category: 4720 - DEPRECIATION 4720 - DEPRECIATION -CONTRIBUTED 0.00 0.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4721 -DEPRECIATION -PURCHASED 21,606.42 29,058.80 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 8/1/2017 10:33:53 AM Page 6 of 8 Budget Comparison Report Object Comparison 1 Comparison 1 Comparison 2 Comparison 2 Parent Budget Budget to Parent % Budget to Comparison % 477,170.61 Budget 534,000.00 1 Budget 2015 2016 2017 2017 2018 Increase / 2019 Increase / Total Activity Total Activity YTD Activity 2017 2018 (Decrease) 2019 fall 2017 (Decrease) Through Aug Total Category: 4720 - DEPRECIATION: 21,606.42 29,058.80 0.00 0.00 0.00 Total Fund: 720 - INFORMATION TECHNOLOGY: 394,193.33 477,170.61 299,272.28 534,000.00 610,515.00 Report Total: 2,678,810.29 2,840,901.54 1,602,925.54 3,113,630.00 3,002,835.00 0.00 0.00% 0.00 0.00 0.00% 76,515.00 14.33% 638,010.00 27,495.00 4.50% 110,795.00 -3.56% 2,522,318.00 -480,517.00 -16.00% 8/1/2017 10:33:53 AM Page 7 of 8 (= Cottage Grove Budget Comparison Report Group Summary 8/1/2017 10:32:08 AM Page 1 of 5 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 Jun Fund: 215 - RECYCLING Category: 3310 - INTERGOVERNMENTAL 3349 - COUNTY AID 82,494.00 77,495.00 0.00 57,140.00 57,140.00 0.00 0.00% 57,000.00 -140.00 -0.25% Total Category: 3310 - INTERGOVERNMENTAL: 82,494.00 77,495.00 0.00 57,140.00 57,140.00 0.00 0.00% 57,000.00 -140.00 -0.25% Category: 3809 - INVESTMENT INTEREST 3810 - INVEST INTEREST 336.21 339.99 300.11 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% Total Category: 3809 - INVESTMENT INTEREST: 336.21 339.99 300.11 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% Category: 3812 - MISCELLANEOUS 3816 - REFUND & REIMBRS 3,500.00 3,500.00 0.00 20,350.00 0.00 -20,350.00 -100.00% 0.00 0.00 0.00% Total Category: 3812 - MISCELLANEOUS: 3,500.00 3,500.00 0.00 20,350.00 0.00 -20,350.00 -100.00% 0.00 0.00 0.00% Total Fund: 215 - RECYCLING: 86,330.21 81,334.99 300.11 77,490.00 57,140.00 -20,350.00 -26.26% 57,000.00 -140.00 -0.25% 8/1/2017 10:32:08 AM Page 1 of 5