Loading...
HomeMy WebLinkAbout04 Community DevelopmentBudget Comparison Report Object Department: 10 - PLANNING & ZONING Category: 4100 - PERSONAL SERVICES 4100 - SALARY -FULL TIME 4110 -OVERTIME F. T. 4120 - SAL-PT./TEMP 4121- O.T. - 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 4217 - CLOTHING/UNIFORM 4280 - CAPITAL OUTLAY <$5,000 Total Category: 4200 - COMMODITIES: Category: 4300 - CONTRACTUAL SERVICES 4300 - PROF SERVICES 4301- ENGINEERING SVS 4305 - FEES FOR SERVICE 4311 -POSTAGE 4321- DATA PROCESSING 4340 - PRINTING 4341- ADVER/PUBLISH 4350 -INSURANCE CHARGE 4370 - MAINT-REPAIR/EQ 4401- DUES & SUBS 4403 - TRAVEL/TRAIN/CON 4434 -SPECIAL EVENTS Total Category: 4300 - CONTRACTUAL SERVICES: Total Department: 10 - PLANNING & ZONING: Comparison 1 Comparison 1 Comparison 2 Comparison 2 Parent Budget Budget to Parent % Budget to Comparison % 7,285.00 Budget 2,059.96 1 Budget 2016 2017 2018 2018 2019 Increase / 2020 Increase / Total Activity Total Activity YTD Activity 2018 2019 (Decrease) 2020 FALL 2018 (Decrease) Through Jun 0.00 4,144.00 12,000.00 233,150.22 234,284.38 114,258.96 235,170.00 242,215.00 7,045.00 3.00% 249,500.00 7,285.00 3.01% 2,059.96 630.01 547.56 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 2,990.01 0.00 4,144.00 12,000.00 12,000.00 0.00 0.00% 12,000.00 0.00 0.00% 189.00 0.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 2,818.00 0.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 17,191.76 17,820.50 8,900.55 18,600.00 18,775.00 175.00 0.94% 19,335,00 560.00 2.98% 16,307.57 18,929.09 8,609.75 18,910.00 19,450.00 540.00 2.86% 19,450.00 0.00 0.00% 30,399.96 44,940.00 22,414.98 44,830.00 45,945.00 1,115.00 2,49% 48,730.00 2,785.00 6.06% 1,700.04 1,764.96 877.50 1,755.00 1,830.00 75.00 4.27% 1,830.00 0.00 0.00% 306,806.52 318,368.94 159,753.30 331,265.00 340,215.00 8,950.00 2.70% 350,845.00 10,630.00 3.12% 1,743.87 1,733.34 1,005.10 1,500.00 1,600.00 100.00 6.67% 1,650.00 50.00 3,13% 555.76 30.82 56.39 200.00 100.00 -100.00 -50.00% 110.00 10.00 10,00% 0.00 181.00 0.00 250.00 250.00 0.00 0.00% 260.00 10.00 4.00% 0.00 779.44 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 2,299.63 2,724.60 1,061.49 1,950.00 1,950.00 0.00 0.00% 2,020.00 70.00 3.59% 992.50 150.00 160.90 10,300.00 10,500.00 200.00 1.94% 10,610.00 110.00 1.05% 18,180.44 13,361.45 81,587.93 10,000.00 23,500.00 13,500.00 135.00% 14,110.00 -9,390.00 -39.96% 2,014.85 1,715.30 1,108.10 2,550.00 2,600.00 50.00 1.96% 2,680.00 80.00 3.08% 372.30 0.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 10,625.04 13,068.00 5,850.00 11,700.00 12,285.00 585.00 5.00% 12,900.00 615.00 5.01% 0.00 28.66 55.00 4,500.00 0.00 -4,500.00 -100.00% 0.00 0.00 0.00% 6,237.09 2,587.30 2,120.10 5,000.00 5,100,00 100.00 2.00% 5,250.00 150.00 2.94% 999.96 999.96 499.98 1,000.00 1,000.00 0.00 0.00% 1,050.00 50.00 5.00% 49.99 0.00 0.00 1,100.00 1,120.00 20.00 1.82% 1,155.00 35.00 3.13% 1,000.00 1,215.61 1,078.00 1,300.00 1,330.00 30.00 2.31% 1,370.00 40.00 3.01% 1,696.12 1,926.15 60.00 2,500.00 2,500.00 0.00 0.00% 2,500.00 0.00 0.00% 0.00 134.50 264.57 500.00 500.00 0.00 0.00% 525.00 25.00 5.00% 42,168.29 35,186.93 92,784.58 50,450.00 60,435.00 9,985.00 19.79% 52,150.00 -8,285.00 -13.71% 351,274.44 356,280.47 253,599.37 383,665.00 402,600.00 18,935.00 4.94% 405,015.00 2,415.00 0.60% 7/19/2018 9:55:27 AM Page 11 of 32 Budget Comparison Report Object Department: 14 - ENGINEERING Category: 4100 - PERSONAL SERVICES 4100 - SALARY -FULL TIME 4120 - SAL-P.T./TEMP 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 4217 - CLOTHING/UNIFORM Total Category: 4200 - COMMODITIES: Category: 4300 - CONTRACTUAL SERVICES 4300 - PROF SERVICES 4301- ENGINEERING SVS 4310 - COMMUNICATION 4311 -POSTAGE 4321- DATA PROCESSING 4340 - PRINTING 4341- ADVER/PUBLISH 4370 - MAINT-REPAIR/EQ 4375 - CHARGE -FLEET MNT 4401- DUES & SUBS 4403 - TRAVEL/TRAIN/CON 4449 - OTHER CONTRACT Total Category: 4300 - CONTRACTUAL SERVICES: Total Department: 14 - ENGINEERING: 296.11 109.99 0.00 0.00 Comparison 1 Comparison 1 0.00% Comparison 2 Comparison 2 0.00% 21,961.75 33,873.69 58,614.99 Parent Budget Budget to Parent % Budget to Comparison % 875.00 1,085.00 630.00 1,260.00 1,260.00 Budget 0.00% 1,300.00 1 Budget 3.17% 2016 2017 2018 2018 2019 Increase / 0.00% 2020 Increase / 0.00% Total Activity Total Activity YTD Activity 2018 2019 (Decrease) 5.00% 2020 FALL 2018 (Decrease) 5.03% 36.00 34.00 Through Jun 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 132,787.74 205,137.39 121,154.03 223,300.00 232,165.00 8,865.00 3.97% 239,130.00 6,965.00 3.00% 6,870.00 615.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 9,718.36 14,929.16 9,331.31 16,750.00 17,995.00 1,245.00 7.43% 18,530.00 535.00 2.97% 9,792.71 14,289.86 8,764.23 17,100.00 17,760.00 660.00 3.86% 18,290.00 530.00 2.98% 13,299.96 38,700.00 23,527.50 47,055.00 48,265.00 1,210.00 2.57% 51,235.00 2,970.00 6.15% 800.04 1,599.96 799.98 1,600.00 1,670.00 70.00 4.38% 1,720.00 50.00 2.99% 173,268.81 275,271.37 163,577.05 305,805.00 317,855.00 12,050.00 3.94% 328,905.00 11,050.00 3.48% 386.63 637.54 96.54 400.00 410.00 10.00 2.50% 420.00 10.00 2.44% 175.65 229.64 24.97 400.00 410.00 10.00 2.50% 420.00 10.00 2.44% 1,406.86 756.37 860.82 1,400.00 1,400.00 0.00 0.00% 1,750.00 350.00 25.00% 17.14 174.86 0.00 180.00 400.00 220.00 122.22% 200.00 -200.00 -50.00% 1,986.28 1,798.41 982.33 2,380.00 2,620.00 240.00 10.08% 2,790.00 170.00 6.49% 296.11 109.99 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 21,961.75 33,873.69 58,614.99 34,500.00 35,170.00 670.00 1.94% 35,690.00 520.00 1.48% 875.00 1,085.00 630.00 1,260.00 1,260.00 0.00 0.00% 1,300.00 40.00 3.17% 0.00 0.00 0.00 100.00 100.00 0.00 0.00% 100.00 0.00 0.00% 6,375.00 7,840.77 3,499.98 7,000.00 7,350.00 350.00 5.00% 7,720.00 370.00 5.03% 36.00 34.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 0.00 331.78 175.20 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 0.00 0.00 0.00 600.00 600.00 0.00 0.00% 620.00 20.00 3.33% 265.68 467.91 0.00 500.00 500.00 0.00 0.00% 500.00 0.00 0.00% 1,280.75 1,170.50 382.50 1,440.00 1,390.00 -50.00 -3.47% 1,750.00 360.00 25.90% 2,548.84 2,598.72 279.46 7,410.00 3,500.00 -3,910.00 -52.77% 3,590.00 90.00 2.57% 41.61 0.00 32.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 33,680.74 47,512.36 63,614.13 52,810.00 49,870.00 -2,940.00 -5.57% 51,270.00 1,400.00 2.81% 208,935.83 324,582.14 228,173.51 360,995.00 370,345.00 9,350.00 2.59% 382,965.00 12,620.00 3.41% 7/19/2018 9:55:27 AM Page 14 of 32 Budget Comparison Report Comparison 1 Comparison 1 Comparison 2 Comparison 2 Parent Budget Budget to Parent % Budget to Comparison Budget 1 Budget 2016 2017 2018 2018 2019 Increase / 2020 Increase / Total Activity Total Activity YTD Activity 2018 2019 (Decrease) 2020 FALL 2018 (Decrease) Object Through Jun Department: 09 - CITY HALL BUILDINGS Category: 4100 - PERSONAL SERVICES 4100 -SALARY -FULL TIME 99,766.26 108,414.29 52,539.10 106,930.00 112,985.00 6,055.00 5.66% 116,375.00 3,390.00 3.00% 4110- OVERTIME F. T. 607.11 1,351,85 494.92 0,00 0.00 0.00 0.00% 0.00 0.00 0.00% 4120 - SAL-P.T./TEMP 0.00 0.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4141- PERA 7,916.97 8,234.99 4,223.33 8,290.00 8,475.00 185.00 2.23% 8,725.00 250.00 2.95% 4142 -FICA 7,028.35 7,391.07 3,792.89 8,180.00 8,645.00 465.00 5.68% 8,900.00 255.00 2.95% 4144 -HEALTH INSURANCE 20,400.00 28,700.04 11,355.00 22,710.00 23,260.00 550.00 2.42% 24,630.00 1,370.00 5.89% 4148- WORKERS COMP 2,000.04 2,400.00 379.98 760.00 810.00 50.00 6.58% 835.00 25.00 3,09% Total Category: 4100 - PERSONAL SERVICES: 137,718.73 156,492.24 72,785.22 146,870.00 154,175.00 7,305.00 4.97% 159,465.00 5,290.00 3.43% Category: 4200 - COMMODITIES 4200- OFFICE SUPPLIES 2,729.72 2,892.93 1,189.07 3,500.00 3,570.00 70.00 2.00% 3,700.00 130.00 3.64% 4210 - OP SUPPLY -OTHER 2,619.75 9,169.10 4,371.77 6,900.00 7,000.00 100.00 1.45% 7,200.00 200.00 2.86% 4211- MOTOR FUELS 682.08 637.40 426.78 600.00 600.00 0.00 0.00% 600.00 0.00 0.00% 4217-CLOTHING/UNIFORM 693.74 319.77 380.23 630.00 600.00 -30.00 -4.76% 600.00 0.00 0.00% 4231 -SMALL TOOLS 1,064.83 1,917.63 565.07 350.00 800.00 450.00 128.57% 800.00 0.00 0.00% 4271 -OP SUP -OTHER IMP 2,037.67 0.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4272 - OP SUP -BUILDINGS 11,112.85 2,336.82 1,420.86 5,500.00 5,500.00 0.00 0.00% 5,600.00 100.00 1.82% 4280 - CAPITAL OUTLAY <$5,000 7,722.82 2,584.00 4,800.00 4,000.00 6,500.00 2,500.00 62.50% 6,500.00 0.00 0.00% Total Category: 4200 - COMMODITIES: 28,663.46 19,857.65 13,153.78 21,480.00 24,570.00 3,090.00 14.39% 25,000.00 430.00 1.75% Category: 4300 - CONTRACTUAL SERVICES 4300 - PROF SERVICES 20.00 30.00 5,075.00 500.00 520.00 20.00 4.00% 530.00 10.00 1.92% 4305 - FEES FOR SERVICE 16,866.91 21,957.85 12,692.24 18,000.00 24,250.00 6,250.00 34,72% 24,500.00 250.00 1.03% 4310 -COMMUNICATION 840.20 840.12 420.06 1,000.00 800.00 -200.00 -20.00% 820.00 20.00 2.50% 4311 -POSTAGE 15,331.66 16,532.15 5,225.00 18,000.00 18,000.00 0.00 0.00% 18,250.00 250.00 1.39% 4321- DATA PROCESSING 6,375.00 7,840.77 3,499.98 7,000.00 8,000.00 1,000.00 14.29% 8,240.00 240.00 3.00% 4340 -PRINTING 1,578.00 2,602.00 495.00 3,000.00 1,000.00 -2,000.00 -66.67% 1,100.00 100.00 10.00% 4350- INSURANCE CHARGE 51,500.04 51,500.04 25,750.02 51,500.00 51,500.00 0.00 0.00% 54,100.00 2,600.00 5.05% 4360 - UTILITIES 95,539.41 90,416.62 36,161.01 110,000.00 113,000.00 3,000.00 2.73% 116,000.00 3,000.00 2.65% 4370 - MAINT-REPAIR/EQ 16,537.23 21,904.70 4,362.65 10,000.00 10,000.00 0.00 0.00% 10,300.00 300.00 3.00% 4371-MAINT-REPAIR/OTH 692.05 0.00 1,538.00 0.00 1,600.00 1,600.00 0.00% 1,700.00 100.00 6.25% 4372-MAINT-REPAIR/BLD 20,316.88 23,000.99 8,337.34 18,000.00 14,000.00 -4,000.00 -22.22% 15,000.00 1,000.00 7.14% 4375 - CHARGE -FLEET MNT 601.39 2,796.53 657.87 3,000.00 1,700.00 -1,300.00 -43.33% 1,700.00 0.00 0.00% 4380-RENTAL/LEASE 14,224.01 11,778.76 3,905.97 11,000.00 11,000.00 0.00 0.00% 11,330.00 330.00 3,00% 4401- DUES & SUBS 590.00 704.32 -49.00 150.00 250.00 100.00 66.67% 260.00 10.00 4.00% 4403-TRAVEL/TRAIN/CON 0.00 20.52 305.00 2,000.00 500.00 -1,500.00 -75.00% 550.00 50.00 10.00% 4405 - CLEAN/WASTE REMV 41,083.50 38,779.80 21,525.18 37,000.00 45,000.00 8,000.00 21.62% 45,000.00 0.00 0.00% 7/19/2018 9:55:27 AM Page 9 of 32 Budget Comparison Report Object 4449 - OTHER CONTRACT Total Category: 4300 - CONTRACTUAL SERVICES: Total Department: 09 - CITY HALL BUILDINGS: 7/19/2018 9:55:27 AM Comparison 1 Comparison 1 Comparison 2 Comparison 2 Parent Budget Budget to Parent % Budget to Comparison Budget 1 Budget 2016 2017 2018 2018 2019 Increase / 2020 Increase / Total Activity Total Activity YTD Activity 2018 2019 (Decrease) 2020 FALL 2018 (Decrease) Through Jun 0.00 0.00 16.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 282,096.28 290,705.17 129,917.32 290,150.00 301,120.00 10,970.00 3.78% 309,380.00 8,260.00 2.74% 448,478.47 467,055.06 215,856.32 458,500.00 479,865.00 21,365.00 4.66% 493,845.00 13,980.00 2.91% Page 10 of 32 Budget Comparison Report //19/2018 9:55:27 AM Page 13 of 32 Comparison 1 Comparison 1 Comparison 2 Comparison 2 Parent Budget Budget to Parent % Budget to Comparison Budget 1 Budget 2016 2017 2018 2018 2019 Increase / 2020 Increase / Total Activity Total Activity YTD Activity 2018 2019 (Decrease) 2020 FALL 2018 (Decrease) Object Through Jun Department: 13 - PROTECTIVE INSPECTION Category: 4100 - PERSONAL SERVICES 4100 -SALARY -FULL TIME 336,128.57 353,902.76 202,433.60 420,200.00 437,780.00 17,580.00 4.18% 450,900.00 13,120.00 3.00% 4110 -OVERTIME F. T. 2,438.13 1,171.18 542.71 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4120-SAL-P.T./TEMP 0.00 36,801.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4141- PERA 24,928.37 26,474.21 15,796.53 32,510.00 33,930.00 1,420.00 4.37% 34,945.00 1,015.00 2.99% 4142 - FICA 23,951.14 25,610.46 15,360.19 32,150.00 33,490.00 1,340.00 4.17% 34,495.00 1,005.00 3.00% 4144 -HEALTH INSURANCE 51,699.96 52,100.04 29,875.02 59,750.00 61,250.00 1,500.00 2,51% 64,910.00 3,660.00 5.98% 4148- WORKERS COMP 2,499.96 2,700.00 1,495.02 2,990.00 3,150.00 160.00 5.35% 3,245.00 95.00 3.02% Total Category: 4100 - PERSONAL SERVICES: 441,646.13 498,759.65 265,503.07 547,600.00 569,600.00 22,000.00 4.02% 588,495.00 18,895.00 3.32% Category: 4200 - COMMODITIES 4200 - OFFICE SUPPLIES 1,704.97 1,259.84 1,142.58 1,400.00 1,450.00 50.00 3.57% 1,450.00 0.00 0.00% 4210 -OP SUPPLY -OTHER 709.08 0.00 0.00 100.00 100.00 0.00 0.00% 500.00 400.00 400.00% 4211- MOTOR FUELS 4,347.61 4,708.06 2,641.17 6,300.00 7,000.00 700.00 11.11% 9,000.00 2,000.00 28.57% 4217-CLOTHING/UNIFORM 226.00 417.50 0.00 500.00 500.00 0.00 0.00% 500.00 0.00 0.00% 4231- SMALL TOOLS 0.00 278.03 0.00 100.00 0.00 -100.00 -100.00% 0.00 0.00 0.00% Total Category: 4200 - COMMODITIES: 6,987.66 6,663.43 3,783.75 8,400.00 9,050.00 650.00 7.74% 11,450.00 2,400.00 26.52% Category: 4300 - CONTRACTUAL SERVICES 4300- PROF SERVICES 66,918.05 81,786.10 46,734.48 66,000.00 70,000.00 4,000.00 6.06% 71,300.00 1,300.00 1.86% 4301- ENGINEERING SVS 17,730.08 3,466.75 4,256.75 9,000.00 3,000.00 -6,000.00 -66.67% 3,300.00 300.00 10.00% 4305 - FEES FOR SERVICE 37.49 2,570.02 1,645.63 3,000.00 2,250.00 -750.00 -25.00% 2,750.00 500.00 22.22% 4310 -COMMUNICATION 3,313.15 4,040.67 2,082.80 3,300.00 3,200.00 -100.00 -3.03% 3,200.00 0.00 0.00% 4321- DATA PROCESSING 10,625.04 13,068.00 5,835.00 11,670.00 25,000.00 13,330.00 114.22% 25,000.00 0.00 0.00% 4340 -PRINTING 292.73 108.66 24.00 500.00 500.00 0.00 0.00% 500.00 0.00 0.00% 4341-ADVER/PUBLISH 240.90 365.00 0.00 700.00 500.00 -200.00 -28.57% 500.00 0.00 0.00% 4350- INSURANCE CHARGE 800.04 699.96 349.98 700.00 700.00 0.00 0.00% 700.00 0.00 0.00% 4370 - MAINT-REPAIR/EQ 0.00 420.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0,00% 4375 - CHARGE -FLEET MNT 4,737.14 5,253.83 3,516.97 6,500.00 6,500.00 0.00 0.00% 6,700.00 200.00 3.08% 4401- DUES & SUBS 1,173.43 1,424.74 875.00 1,300.00 1,000.00 -300.00 -23.08% 1,000.00 0.00 0.00% 4403 - TRAVEL/TRAIN/CON 2,984.29 3,287.34 685.74 4,500.00 5,000.00 500.00 11,11% 5,500.00 500.00 10.00% 4449 - OTHER CONTRACT 64.00 0.00 80.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% Total Category: 4300 - CONTRACTUAL SERVICES: 108,916.34 116,491.07 66,086.35 107,170.00 117,650.00 10,480.00 9.78% 120,450.00 2,800.00 2.38% Total Department: 13 - PROTECTIVE INSPECTION: 557,550.13 621,914.15 335,373.17 663,170.00 696,300.00 33,130.00 5.00% 720,395.00 24,095.00 3.46% //19/2018 9:55:27 AM Page 13 of 32