Loading...
HomeMy WebLinkAbout01 Public SafetyBudget Comparison Report Object Department: 21- POLICE PROTECTION Category: 4100 - PERSONAL SERVICES 4100 - SALARY -FULL TIME 4110- OVERTIME F. T. 4115 - REGULAR-P/T REG STATUS 4116 - O/T -P/T REG. STATUS 4120 - SAL-P.T./TEMP 4121- O.T. - P.T./TEMP 4140 - PENSIONS 4141- PERA 4142 - FICA 4144- HEALTH INSURANCE 4147- UNEMPLOYMENT 4148 - WORKERS COMP Total Category: 4100 - PERSONAL SERVICES: Category: 4200 - COMMODITIES 4200 - OFFICE SUPPLIES 4210 -OP SUPPLY -OTHER 4211- MOTOR FUELS 4217 - CLOTHING/UNIFORM 4272 - OP SUP -BUILDINGS 4280 - CAPITAL OUTLAY <$5,000 Total Category: 4200 - COMMODITIES: Category: 4300 - CONTRACTUAL SERVICES 7,090.00 154.47% 12,380.00 Comparison 1 Comparison 1 11,692.36 Comparison 2 Comparison 2 4,590.00 4303 - INSTRUCTORS 0.00 60.00 Parent Budget Budget to Parent % Budget to Comparison % 4310 -COMMUNICATION 66,082.04 65,013.02 32,835.04 62,160.00 Budget 213.56 311.45 1 Budget 200.00 2016 2017 2018 2018 2019 Increase / 941.16 2020 Increase / 2,040.00 Total Activity Total Activity YTD Activity 2018 2019 (Decrease) 35,000.04 2020 FALL 2018 (Decrease) 40,500.00 4370 - MAINT-REPAIR/EQ 19,150.82 Through Jun 2,951.75 26,060.00 4371-MAINT-REPAIR/OTH 0.00 799.67 0.00 0.00 3,730,818.87 3,860,815.57 2,000,339.38 3,993,330.00 4,143,600.00 150,270.00 3.76% 4,259,385.00 115,785.00 2.79% 179,204.37 142,120.51 75,666.00 160,300.00 180,000.00 19,700.00 12.29% 200,000.00 20,000.00 11.11% 56,457.13 61,720.58 31,905.91 58,000.00 67,930.00 9,930.00 17.12% 69,975.00 2,045.00 3.01% 437.76 975.02 290.81 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 49,562.75 50,528.67 31,851.88 54,535.00 75,510.00 20,975.00 38.46% 75,510.00 0.00 0.00% 300.00 0.00 0.00 800.00 800.00 0.00 0.00% 800.00 0.00 0.00% 2,223.00 35,084.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 607,778.13 612,913.43 328,267.27 641,250.00 698,735.00 57,485.00 8.96% 752,330.00 53,595.00 7.67% 82,827.01 84,642.09 46,112.57 92,900.00 98,415.00 5,515.00 5,94% 101,415.00 3,000.00 3.05% 412,500.00 467,000.04 233,500.02 467,000.00 478,700.00 11,700.00 2.51% 507,065.00 28,365.00 5.93% 2,335.68 764.18 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 124,500.00 161,400.00 71,419.98 142,840.00 172,460.00 29,620.00 20.74% 178,300.00 5,840.00 3.39% 5,248,944.70 5,477,964.09 2,819,353.82 5,610,955.00 5,916,150.00 305,195.00 5.44% 6,144,780.00 228,630.00 3.86% 3,467.72 4,325.99 1,499.93 6,120.00 6,245.00 125.00 2.04% 6,430.00 185.00 2.96% 55,113.48 59,816.21 30,245.51 59,200.00 60,385.00 1,185.00 2.00% 61,000.00 615.00 1.02% 83,468.46 88,249.35 46,878.50 105,000.00 110,000.00 5,000.00 4.76% 125,000.00 15,000.00 13.64% 77,382.80 69,744.80 23,233.93 60,000.00 70,000.00 10,000.00 16.67% 72,100.00 2,100.00 3.00% 0.00 0.00 0.00 0.00 3,000.00 3,000.00 0.00% 3,000.00 0.00 0.00% 60,580.77 15,029.68 13,760.50 22,650.00 73,105.00 50,455.00 222,76% 23,800.00 -49,305.00 -67.44% 280,013.23 237,166.03 115,618.37 252,970.00 322,735.00 69,765.00 27.58% 291,330.00 -31,405.00 -9.73% Category: 4300 - CONTRACTUAL SERVICES 7,090.00 154.47% 12,380.00 700.00 4300- PROF SERVICES 11,692.36 8,923.56 8,355.76 4,590.00 4303 - INSTRUCTORS 0.00 60.00 0.00 0.00 4305 - FEES FOR SERVICE 13,438.70 8,205.70 5,158.28 20,400.00 4310 -COMMUNICATION 66,082.04 65,013.02 32,835.04 62,160.00 43 11 - POSTAGE 213.56 311.45 65.40 200.00 4321- DATA PROCESSING 151,120.37 181,673.70 101,362.38 159,400.00 4340 -PRINTING 941.16 1,695.66 398.28 2,040.00 4341- ADVER/PUBLISH 0.00 0.00 176.94 510.00 4350 - INSURANCE CHARGE 35,000.04 40,500.00 20,250.00 40,500.00 4370 - MAINT-REPAIR/EQ 19,150.82 18,313.68 2,951.75 26,060.00 4371-MAINT-REPAIR/OTH 0.00 799.67 0.00 0.00 4372-MAINT-REPAIR/BLD 220.34 0.00 0.00 0.00 4375 - CHARGE -FLEET MNT 72,002.77 76,343.60 18,501.24 77,000.00 4380 - RENTAL/LEASE 21,353.99 18,156.99 10,350.33 18,700.00 4401- DUES & SUBS 2,530.00 2,234.00 1,640.00 3,550.00 11,680.00 7,090.00 154.47% 12,380.00 700.00 5.99% 0.00 0.00 0.00% 0.00 0.00 0.00% 15,000.00 -5,400.00 -26.47% 15,450.00 450.00 3.00% 63,405.00 1,245.00 2.00% 65,300.00 1,895.00 2.99% 205.00 5.00 2.50% 210.00 5.00 2.44% 204,590.00 45,190.00 28.35% 215,000.00 10,410.00 5.09% 1,200.00 -840.00 -41.18% 1,200.00 0.00 0.00% 520.00 10.00 1.96% 530.00 10.00 1.92% 40,500.00 0.00 0.00% 42,600.00 2,100.00 5.19% 26,580.00 520.00 2.00% 27,380.00 800.00 3.01% 0.00 0.00 0.00% 0.00 0.00 0.00% 0.00 0.00 0.00% 0.00 0.00 0.00% 80,000.00 3,000.00 3.90% 80,000.00 0.00 0.00% 19,075.00 375.00 2.01% 19,650.00 575.00 3.01% 3,620.00 70.00 1.97% 3,730.00 110.00 3.04% 7/19/2018 9:55:27 AM Page 16 of 32 Budget Comparison Report Category: 4500 - CAPITAL OUTLAY 4530- MACH & EQUIPMENT 184,782.24 181,518.21 142,744.34 126,150.00 159,000.00 32,850.00 26.04% 204,700.00 45,700.00 28.74% Total Category: 4500 - CAPITAL OUTLAY: 184,782.24 181,518.21 142,744.34 126,150.00 159,000.00 32,850.00 26.04% 204,700.00 45,700.00 28.74% Total Department: 21- POLICE PROTECTION: 6,176,266.94 6,376,419.92 3,310,240.18 6,465,595.00 6,937,220.00 471,625.00 7.29% 7,199,090.00 261,870.00 3.77% 7/19/2018 9:55:27 AM Page 17 of 32 Comparison 1 Comparison 1 Comparison 2 Comparison 2 Parent Budget Budget to Parent % Budget to Comparison a/ 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 4403-TRAVEL/TRAIN/CON 54,619.79 43,725.05 19,661.25 43,000.00 53,000.00 10,000.00 23.26% 54,590.00 1,590.00 3.00% 4405 - CLEAN/WASTE REMV 0.00 652.06 421.63 1,600.00 1,635.00 35.00 2.19% 1,680.00 45.00 2.75% 4434 -SPECIAL EVENTS 7,753.52 7,921.56 7,250.00 7,650.00 10,000.00 2,350.00 30.72% 10,000.00 0.00 0.00% 4449 -OTHER CONTRACT 6,407.31 5,241.89 3,145.37 8,160.00 8,325.00 165.00 2.02% 8,580.00 255.00 3.06% Total Category: 4300 - CONTRACTUAL SERVICES: 462,526.77 479,771.59 232,523.65 475,520.00 539,335.00 63,815.00 13.42% 558,280.00 18,945.00 3.51% Category: 4500 - CAPITAL OUTLAY 4530- MACH & EQUIPMENT 184,782.24 181,518.21 142,744.34 126,150.00 159,000.00 32,850.00 26.04% 204,700.00 45,700.00 28.74% Total Category: 4500 - CAPITAL OUTLAY: 184,782.24 181,518.21 142,744.34 126,150.00 159,000.00 32,850.00 26.04% 204,700.00 45,700.00 28.74% Total Department: 21- POLICE PROTECTION: 6,176,266.94 6,376,419.92 3,310,240.18 6,465,595.00 6,937,220.00 471,625.00 7.29% 7,199,090.00 261,870.00 3.77% 7/19/2018 9:55:27 AM Page 17 of 32 Budget Comparison Report 7/19/2018 9:55:27 AM Page 18 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: 23 - ANIMAL CONTROL Category: 4100 - PERSONAL SERVICES 4120-SAL-P.T./TEMP 13,500.00 13,500.00 0.00 13,850.00 15,000.00 1,150.00 8.30% 15,000.00 0.00 0.00% 4142 -FICA 1,033.00 1,033.00 0.00 1,100.00 1,145.00 45.00 4,09% 1,145.00 0.00 0.00% 4148 - WORKERS COMP 99.96 99.96 55.02 110.00 110.00 0.00 0.00% 110.00 0.00 0.00% Total Category: 4100 - PERSONAL SERVICES: 14,632.96 14,632.96 55.02 15,060.00 16,255.00 1,195.00 7.93% 16,255.00 0.00 0.00% Category: 4200 - COMMODITIES 4200 -OFFICE SUPPLIES 0.00 0.00 0.00 200.00 205.00 5.00 2.50% 210.00 5.00 2.44% 4210 -OP SUPPLY -OTHER 870.62 385.95 0.00 1,400.00 1,000.00 -400.00 -28.57% 1,030.00 30.00 3.00% 4211- MOTOR FUELS 301.34 278.75 209.81 1,400.00 1,000.00 -400.00 -28.57% 1,000.00 0.00 0.00% 4217-CLOTHING/UNIFORM 1,998.94 1,916.09 892.20 3,000.00 3,060.00 60.00 2.00% 3,150.00 90.00 2.94% Total Category: 4200 - COMMODITIES: 3,170.90 2,580.79 1,102.01 6,000.00 5,265.00 -735.00 -12.25% 5,390.00 125.00 2.37% Category: 4300 - CONTRACTUAL SERVICES 4300 - PROF SERVICES 0.00 0.00 0.00 300.00 300.00 0.00 0.00% 310.00 10.00 3.33% 4305 - FEES FOR SERVICE 6,726.00 4,934.00 658.00 7,500.00 6,000.00 -1,500.00 -20.00% 6,180.00 180.00 3.00% 4321- DATA PROCESSING 2,373.00 876.75 1,200.00 2,400.00 2,450.00 50.00 2.08% 2,450.00 0.00 0.00% 4340 - PRINTING 99.00 150.00 0.00 400.00 200.00 -200.00 -50.00% 210.00 10.00 5.00% 4375 - CHARGE -FLEET MNT 0.00 0.00 0.00 3,600.00 3,600.00 0.00 0.00% 3,710.00 110.00 3.06% 4403-TRAVEL/TRAIN/CON 0.00 0.00 0.00 500.00 0.00 -500.00 -100.00% 0.00 0.00 0.00% Total Category: 4300 - CONTRACTUAL SERVICES: 9,198.00 5,960.75 1,858.00 14,700.00 12,550.00 -2,150.00 -14.63% 12,860.00 310.00 2.47% Total Department: 23 - ANIMAL CONTROL: 27,001.86 23,174.50 3,015.03 35,760.00 34,070.00 -1,690.00 -4.73% 34,505.00 435.00 1.28% 7/19/2018 9:55:27 AM Page 18 of 32 Budget Comparison Report Cottage Grove Group Summary 7/23/2018 11:58:02 AM Page 1 of 2 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 Fund: 240 - FORFEITURE & SEIZURE Category: 3310 - INTERGOVERNMENTAL 3349 - COUNTY AID 0.00 4,210.00 0.00 8,000.00 8,000.00 0,00 0.00% 0.00 -8,000.00 -100.00% Total Category: 3310 - INTERGOVERNMENTAL: 0.00 4,210.00 0.00 8,000.00 8,000.00 0.00 0.00% 0.00 -8,000.00 -100.00% Category: 3400 - CHARGES FOR SERVICES 3538 - FORFEIT/SEIZ REV 4,303,77 4,190.58 44,039.25 5,000.00 5,200.00 200.00 4.00% 7,500.00 2,300.00 44.23% 3540- DUI FORFEITURE REVENUE 25,162.00 4,994.23 10,516.00 10,000.00 10,000.00 0.00 0.00% 7,500,00 -2,500.00 -25.00% 3541 -CRIMINAL STIPULATION 10,434.23 4,763.19 3,250.01 6,000.00 6,000.00 0.00 0.00% 15,060.00 9,060.00 151.00% Total Category: 3400 - CHARGES FOR SERVICES: 39,900.00 13,948.00 57,805.26 21,000.00 21,200.00 200.00 0.95% 30,060.00 8,860.00 41.79% Category: 3809 - INVESTMENT INTEREST 3810 - INVEST INTEREST 185.46 190.43 170.74 200.00 200.00 0.00 0.00% 200.00 0.00 0,00% Total Category: 3809 - INVESTMENT INTEREST: 185.46 190.43 170.74 200.00 200.00 0.00 0.00% 200.00 0.00 0.00% Total Fund: 240 - FORFEITURE & SEIZURE: 40,085.46 18,348.43 57,976.00 29,200.00 29,400.00 200.00 0.68% 30,260.00 860.00 2.93% Report Total: 40,085.46 18,348.43 57,976.00 29,200.00 29,400.00 200.00 0.68% 30,260.00 860.00 2.93% 7/23/2018 11:58:02 AM Page 1 of 2 Budget Comparison Report Cottage Grove Group Summary Comparison 1 Comparison 1 Comparison 2 Comparison 2 Parent Budget Budget to Parent % Budget to Comparison 30,060.00 Budget 2.95% 1 Budget 2016 2017 2018 2018 2019 Increase / 2020 Increase / Total Activity Total Activity YTD Activity 2018 2019 (Decrease) 2020 FALL 2018 (Decrease) Object 55,942.91 16,933.67 Through Jun 28,620.00 29,200.00 580.00 2.03% 30,060.00 860.00 2.95% Fund: 240 - FORFEITURE & SEIZURE 55,942.91 16,933.67 5,375.61 28,620.00 29,200.00 580.00 2.03% 30,060.00 860.00 2.95% Department: 21- POLICE PROTECTION 55,942.91 16,933.67 5,375.61 28,620.00 29,200.00 580.00 2.03% 30,060.00 860.00 2.95% Category: 4200 - COMMODITIES 4280 - CAPITAL OUTLAY <$5,000 6,613.00 6,639.90 158.90 4,500.00 4,600.00 100.00 2.22% 4,740.00 140.00 3.04% Total Category: 4200 - COMMODITIES: 6,613.00 6,639.90 158.90 4,500.00 4,600.00 100.00 2.22% 4,740.00 140.00 3.04% Category: 4300 - CONTRACTUAL SERVICES 4302 - LEGAL SERVICE 8,244.00 7,434.00 3,123.00 8,000.00 8,160.00 160.00 2.00% 8,400.00 240.00 2.94% 4305 - FEES FOR SERVICE 0.00 0.00 0.00 100.00 100.00 0.00 0.00% 100.00 0.00 0.00% 4310 -COMMUNICATION 0.00 0.00 0.00 420.00 430.00 10.00 2.38% 440.00 10.00 2.33% 4341-ADVER/PUBLISH 722.70 788.40 766.50 300.00 305.00 5.00 1.67% 310.00 5.00 1.64% 4390-VICTIM/WITNESS 402.94 401.59 281.21 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4391 -COUNTY DEFENDENT 1,038.90 803.17 763.25 4,000.00 4,080.00 80.00 2.00% 4,200.00 120.00 2.94% 4403-TRAVEL/TRAIN/CON 0.00 453.36 0.00 1,000.00 1,020.00 20.00 2.00% 1,050.00 30.00 2.94% 4449 - OTHER CONTRACT 11,415.57 413.25 282.75 300.00 305.00 5.00 1.67% 310.00 5.00 1.64% Total Category: 4300 - CONTRACTUAL SERVICES: 21,824.11 10,293.77 5,216.71 14,120.00 14,400.00 280.00 1.98% 14,810.00 410.00 2.85% Category: 4500 - CAPITAL OUTLAY 4520 - FURN & OFF EQUIP 17,505.80 0.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4540 - OTHER CAP OUTLAY 10,000.00 0.00 0.00 10,000.00 10,200.00 200.00 2.00% 10,510.00 310.00 3.04% Total Category: 4500 - CAPITAL OUTLAY: 27,505.80 0.00 0.00 10,000.00 10,200.00 200.00 2.00% 10,510.00 310.00 3.04% Total Department: 21- POLICE PROTECTION: 55,942.91 16,933.67 5,375.61 28,620.00 29,200.00 580.00 2.03% 30,060.00 860.00 2.95% Total Fund: 240 - FORFEITURE & SEIZURE: 55,942.91 16,933.67 5,375.61 28,620.00 29,200.00 580.00 2.03% 30,060.00 860.00 2.95% Report Total: 55,942.91 16,933.67 5,375.61 28,620.00 29,200.00 580.00 2.03% 30,060.00 860.00 2.95% 7/23/2018 11:59:53 AM Page 1 of 2 Budget Comparison Report Object Department: 15 - EMERGENCY PREPAREDNESS 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 Comparison 1 Comparison 1 Comparison 2 Comparison 2 4200 - OFFICE SUPPLIES 0.00 Parent Budget Budget to Parent 9 Budget to Comparison 9 0.00 0.00% 4210 - OP SUPPLY -OTHER 0.00 134.98 Budget 50.00 100.00 1 Budget 100.00% 2016 2017 2018 2018 2019 Increase / 0.00 2020 Increase / 0.00 Total Activity Total Activity YTD Activity 2018 2019 (Decrease) 134.98 2020 FALL 2018 (Decrease) 100.00 0.00 0.00% Through Jun 0.00 0.00% Category: 4300 - CONTRACTUAL SERVICES 11,054.59 21,521.03 12,975.88 24,190.00 24,910.00 720.00 2.98% 25,120.00 210.00 0.84% 244.58 0.00 0.00 2,000.00 0.00 -2,000.00 -100.00% 0.00 0.00 0.00% 1,718.42 3,405.02 1,919.42 3,920.00 4,225.00 305.00 7.78% 4,450.00 225.00 5,33% 79.56 202.85 148.78 350.00 360.00 10.00 2.86% 365.00 5.00 1.39% 2,000.04 2,199.96 1,159.98 2,320.00 1,960.00 -360.00 -15.52% 2,030.00 70.00 3.57% 1,200.00 1,800.00 850.02 1,700.00 1,940.00 240.00 14.12% 1,955.00 15.00 0.77% 16,297.19 29,128.86 17,054.08 34,480.00 33,395.00 -1,085.00 -3.15% 33,920.00 525.00 1.57% Category: 4200 - COMMODITIES 4200 - OFFICE SUPPLIES 0.00 0.00 0.00 50.00 0.00 -50.00 -100.00% 0.00 0.00 0.00% 4210 - OP SUPPLY -OTHER 0.00 134.98 4.29 50.00 100.00 50.00 100.00% 100.00 0.00 0.00% 4280 - CAPITAL OUTLAY <$5,000 4,176.00 0.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% Total Category: 4200 - COMMODITIES: 4,176.00 134.98 4.29 100.00 100.00 0.00 0.00% 100.00 0.00 0.00% Category: 4300 - CONTRACTUAL SERVICES 4300 - PROF SERVICES 2,718.69 3,518.69 800.00 1,000.00 1,000.00 0.00 0.00% 1,000.00 0.00 0.00% 4305 - FEES FOR SERVICE 2,640.00 0.00 2,718.69 3,800.00 3,875.00 75.00 1,97% 4,000.00 125.00 3.23% 4310 -COMMUNICATION 3,766.35 3,704.86 1,819.88 4,000.00 4,000.00 0.00 0,00% 4,120.00 120.00 3.00% 4311- POSTAGE 0.00 784.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4340 - PRINTING 0.00 0.00 0.00 50.00 0.00 -50.00 -100.00% 0.00 0.00 0.00% 4360 -UTILITIES 481.56 477.92 197.74 450.00 460.00 10.00 2.22% 470.00 10.00 2.17% 4370 - MAINT-REPAIR/EQ 20,124.51 4,037.70 193.90 10,750.00 10,965.00 215.00 2.00% 11,300.00 335.00 3.06% 4375 - CHARGE -FLEET MNT 168.75 0.00 0.00 700.00 500.00 -200.00 -28.57% 500.00 0.00 0.00% 4380 - RENTAL/LEASE 0.00 190.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4401- DUES & SUBS 0.00 0.00 0.00 200.00 205.00 5.00 2.50% 210.00 5.00 2.44% 4403-TRAVEL/TRAIN/CON 0.00 271.54 350.00 1,200.00 1,225.00 25.00 2.08% 1,260.00 35.00 2.86% Total Category: 4300 - CONTRACTUAL SERVICES: 29,899.86 12,984.71 6,080.21 22,150.00 22,230.00 80.00 0.36% 22,860.00 630.00 2.83% Category: 4500 - CAPITAL OUTLAY 4530- MACH & EQUIPMENT 0.00 0.00 0.00 0.00 14,000.00 14,000.00 0.00% 28,550.00 14,550.00 103.93% Total Category: 4500 - CAPITAL OUTLAY: 0.00 0.00 0.00 0.00 14,000.00 14,000.00 0.00% 28,550.00 14,550.00 103.93% Total Department: 15 - EMERGENCY PREPAREDNESS: 50,373.05 42,248.55 23,138.58 56,730.00 69,725.00 12,995.00 22.91% 85,430.00 15,705.00 22.529 7/19/2018 9:55:27 AM Page 15 of 32 Budget Comparison Report 7/23/2018 1:50:34 PM Page 19 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: 26 - FIRE PROTECTION Category: 4100 - PERSONAL SERVICES 4100 -SALARY -FULL TIME 340,865.03 434,784.50 222,656,74 426,100.00 438,930.00 12,830.00 3,01% 449,015.00 10,085.00 2.30% 4110 - OVERTIME F. T. 33,407,50 28,469.11 9,217.33 4,000.00 31,000.00 27,000.00 675.00% 31,000.00 0.00 0.00% 4120-SAL-P.T./TEMP 191,465,82 160,504.37 76,043,07 200,300.00 175,000.00 -25,300.00 -12,63% 175,000.00 0.00 0.00% 4121- O.T. - P.T./TEMP 7,850.44 4,300.67 1,754.36 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4141- PERA 64,452.40 72,444.38 37,525.89 67,650.00 76,685.00 9,035.00 13.36% 78,080.00 1,395.00 1.82% 4142 - FICA 20,880.70 19,047.14 9,312.57 21,560.00 20,300.00 -1,260.00 -5.84% 19,970.00 -330.00 -1.63% 4144 -HEALTH INSURANCE 41,049.96 49,500.00 23,590.02 47,180.00 48,140.00 960.00 2.03% 49,535.00 1,395.00 2.90% 4148 - WORKERS COMP 39,324.96 46,299.96 21,454.98 42,910.00 49,080.00 6,170.00 14.38% 47,320.00 -1,760.00 -3.59% Total Category: 4100 - PERSONAL SERVICES: 739,296.81 815,350.13 401,554.96 809,700.00 839,135.00 29,435.00 3.64% 849,920.00 10,785.00 1,29% Category: 4200 - COMMODITIES 4200 - OFFICE SUPPLIES 709.87 921.22 163.25 1,350.00 1,380.00 30.00 2.22% 1,420.00 40.00 2.90% 4209 -OP SUPPLIES-CLEN 56.51 0.00 0.00 100.00 0.00 -100.00 -100.00% 0.00 0.00 0.00% 4210 -OP SUPPLY -OTHER 12,881.84 10,244.07 4,351.40 16,500.00 14,840.00 -1,660.00 -10.06% 15,280.00 440.00 2.96% 4211- MOTOR FUELS 6,707.91 7,821.53 4,955.21 10,000.00 10,200,00 200.00 2.00% 12,000.00 1,800.00 17.65% 4216-FERTILIZER/CHEM 490.15 0.00 0.00 500.00 0.00 -500.00 -100,00% 0.00 0.00 0,00% 4217-CLOTHING/UNIFORM 31,109.78 30,230.83 13,255.73 41,000.00 44,100.00 3,100.00 7.56% 45,430.00 1,330.00 3.02% 4231 -SMALL TOOLS 37.61 614.92 869.22 0.00 0.00 0,00 0.00% 0.00 0.00 0.00% 4270 -OP SUP-VEH/EQ 2,159.16 440.00 0.00 7,140.00 5,000.00 -2,140.00 -29.97% 5,150.00 150.00 3.00% 4272 - OP SUP -BUILDINGS 675.18 688.42 922.81 500.00 3,500.00 3,000.00 600.00% 3,600.00 100.00 2.86% 4280 - CAPITAL OUTLAY <$5,000 0.00 3,981.74 2,780.00 500,00 9,600.00 9,100.00 1,820.00% 9,100.00 -500.00 -5.21% Total Category: 4200 - COMMODITIES: 54,828,01 54,942.73 27,297.62 77,590.00 88,620.00 11,030.00 14.22% 91,980.00 3,360.00 3.79% Category: 4300 - CONTRACTUAL SERVICES 4300 - PROF SERVICES 14,879.25 18,455.00 5,443,00 17,160.00 17,500.00 340.00 1.98% 18,020.00 520.00 2.97% 4303 - INSTRUCTORS 0.00 30.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4305 - FEES FOR SERVICE 8,257.13 10,460.18 10,263.07 7,530.00 11,680.00 4,150.00 55.11% 11,680.00 0.00 0.00% 4310 -COMMUNICATION 29,409.20 28,886.08 14,958.65 22,800.00 29,375.00 6,575.00 28.84% 30,260.00 885.00 3.01% 4311- POSTAGE 58.36 0.00 0.00 100.00 100,00 0.00 0.00% 100.00 0.00 0.00% 4321- DATA PROCESSING 26,940.00 31,363.09 17,599.98 35,200.00 36,960.00 1,760.00 5.00% 38,800.00 1,840.00 4.98% 4340 -PRINTING 26.34 26.00 0.00 200.00 205.00 5.00 2.50% 210.00 5.00 2.44% 4341-ADVER/PUBLISH 821,90 0.00 0.00 150.00 155.00 5.00 3.33% 160,00 5.00 3.23% 4350 - INSURANCE CHARGE 12,000.00 8,499.96 6,499.98 13,000.00 13,000.00 0.00 0.00% 13,700.00 700.00 5.38% 4360 -UTILITIES 33,279.78 41,017.65 25,927.64 35,000.00 38,000.00 3,000.00 8.57% 39,140.00 1,140.00 3.00% 4370 - MAINT-REPAIR/EQ 41,733.53 42,073.10 29,389.69 42,000.00 43,000.00 1,000.00 2.38% 44,290.00 1,290.00 3.00% 4371-MAINT-REPAIR/OTH 3,941,29 6,763,58 0.00 200.00 0.00 -200.00 -100.00% 0.00 0.00 0.00% 4372-MAINT-REPAIR/BLD 12,726.42 18,509.60 3,427.07 20,000.00 21,000.00 1,000.00 5.00% 21,630.00 630.00 3.00% 4375 - CHARGE -FLEET MNT 15,150.87 18,879.54 9,448.77 25,900.00 25,000,00 -900.00 -3.47% 25,000.00 0.00 0.00% 4380 - RENTAL/LEASE 1,226.17 3,884.16 1,671.21 1,800.00 1,835.00 35.00 1.94% 1,890.00 55.00 3.00% 7/23/2018 1:50:34 PM Page 19 of 32 Budget Comparison Report 7/23/2018 1:50:34 PM Page 20 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 4401- DUES & SUBS 657.00 1,382.00 477.00 1,955.00 1,995.00 40.00 2.05% 2,050.00 55.00 2.76% 4403-TRAVEL/TRAIN/CON 32,733.93 21,372.36 21,153.03 20,000.00 20,400.00 400.00 2.00% 21,010.00 610.00 2.99% 4405 - CLEAN/WASTE REMV 9,220.28 10,220.01 5,645.07 10,000.00 10,200.00 200.00 2.00% 10,500.00 300.00 2.94% 4434 -SPECIAL EVENTS 0.00 112.29 0.00 500.00 705.00 205.00 41.00% 720.00 15.00 2.13% 4449 - OTHER CONTRACT 195,002.01 4,405.12 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% Total Category, 4300 - CONTRACTUAL SERVICES: 438,063.46 266,339.72 151,904.16 253,495.00 271,110.00 17,615.00 6.95% 279,160.00 8,050.00 2.97% Total Department: 26 - FIRE PROTECTION: 1,232,188.28 1,136,632.58 580,756.74 1,140,785.00 1,198,865.00 58,080.00 5.09% 1,221,060.00 22,195.00 1.85% 7/23/2018 1:50:34 PM Page 20 of 32 Budget Comparison Report 7/19/2018 10:18:58 AM Page 2 of 4 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: 24 - SOWASHCO AMBULANCE Category: 4100 - PERSONAL SERVICES 4100 -SALARY -FULL TIME 599,629.28 614,383.80 297,953.15 663,650.00 684,755.00 21,105.00 3,18% 697,320.00 12,565.00 1.83% 4110 -OVERTIME F. T. 27,056.81 36,438.69 19,660,60 28,460.00 29,650.00 1,190.00 4.18% 25,000.00 -4,650.00 -15.68% 4115 - REGULAR-P/T REG STATUS 57,822.10 5,827.08 0.00 0.00 265,000.00 265,000.00 0.00% 265,000.00 0.00 0.00% 4116 - O/T -P/T REG. STATUS 1,357.89 282.24 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4120 - SAL-P.T./TEMP 235,090.90 255,443.13 127,877.70 250,000.00 0.00 -250,000,00 -100.00% 0.00 0.00 0.00% 4121- O.T. - P.T./TEMP 12,469.80 12,616,50 5,198.59 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4140 - PENSIONS 194,751.00 37,971.00 0.00 0.00 0.00 0.00 0.00% 0,00 0.00 0.00% 4141- PERA 85,321.01 98,912.76 51,175.39 105,500,00 114,050.00 8,550.00 8.10% 120,310.00 6,260.00 5.49% 4142 - FICA 32,199,93 31,313.17 15,607.65 30,580,00 32,030.00 1,450.00 4.74% 32,200.00 170.00 0,53% 4144 -HEALTH INSURANCE 71,924.96 94,978.00 47,335.02 94,670.00 99,450.00 4,780.00 5.05% 102,400.00 2,950.00 2.97% 4148 - WORKERS COMP 50,574.96 54,950.04 25,075.02 50,150.00 54,490.00 4,340.00 8.65% 54,900.00 410.00 0.75% Total Category: 4100 - PERSONAL SERVICES: 1,368,198.64 1,243,116.41 589,883.12 1,223,010.00 1,279,425.00 56,415.00 4.61% 1,297,130.00 17,705.00 1.38% Category: 4200 - COMMODITIES 4200 -OFFICE SUPPLIES 0.00 0.00 0.00 100.00 100.00 0.00 0.00% 100,00 0.00 0.00% 4210 -OP SUPPLY -OTHER 57,257.53 43,274.60 25,972.71 44,880,00 50,780,00 5,900.00 13.15% 52,300.00 1,520.00 2.99% 4211- MOTOR FUELS 16,783.07 17,710.42 8,525.45 20,500.00 25,000.00 4,500.00 21.95% 27,500.00 2,500.00 10.00% 4217-CLOTHING/UNIFORM 5,239.41 7,940.65 4,582.54 8,160.00 13,325.00 5,165.00 63.30% 13,720.00 395.00 2,96% 4280 - CAPITAL OUTLAY <$5,000 0.00 0.00 0.00 3,060.00 0.00 -3,060.00 -100.00% 0.00 0.00 0.00% Total Category: 4200 - COMMODITIES: 79,280.01 68,925.67 39,080.70 76,700.00 89,205.00 12,505.00 16.30% 93,620.00 4,415.00 4.95% Category: 4300 - CONTRACTUAL SERVICES 4300 - PROF SERVICES 11,064.25 11,184.00 10,530.00 12,240.00 12,485.00 245.00 2.00% 12,860,00 375.00 3.00% 4305 - FEES FOR SERVICE 65,430.77 83,258.25 36,579.22 58,400.00 59,570,00 1,170.00 2.00% 61,360.00 1,790.00 3.00% 4310 -COMMUNICATION 11,602,04 11,422.55 6,740.64 11,300.00 11,525,00 225,00 1.99% 11,870.00 345.00 2.99% 4311- POSTAGE 0.00 0,00 20.87 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% 4321- DATA PROCESSING 24,639.96 27,388.36 12,500.04 25,000.00 26,250.00 1,250.00 5.00% 27,560.00 1,310.00 4.99% 4350 - INSURANCE CHARGE 2,499.96 3,000.00 1,500,00 3,000.00 3,000.00 0.00 0,00% 3,150.00 150.00 5.00% 4370 - MAINT-REPAIR/EQ 3,349.83 7,987.07 199.00 22,600.00 23,050.00 450.00 1.99% 23,740.00 690,00 2.99% 4375 - CHARGE -FLEET MNT 27,371.09 28,609.92 14,926.85 30,000.00 30,000.00 0.00 0.00% 30,000.00 0.00 0.00% 4380 - RENTAL/LEASE 4,554.95 302.27 0.00 4,900.00 0.00 -4,900.00 -100.00% 0.00 0.00 0.00% 4401- DUES & SUBS 3,217.67 5,373.00 2,300.50 4,730.00 4,825,00 95.00 2.01% 4,970.00 145.00 3.01% 4403-TRAVEL/TRAIN/CON 15,882.60 11,045.84 2,908.63 20,000.00 20,400.00 400.00 2.00% 21,010.00 610.00 2.99% 4449 - OTH ER CONTRACT 0.00 175.00 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% Total Category: 4300 - CONTRACTUAL SERVICES: 169,613.12 189,746.26 88,205.75 192,170.00 191,105.00 -1,065.00 -0.55% 196,520.00 5,415.00 2.83% Category: 4500 - CAPITAL OUTLAY 4530 - MACH & EQUIPMENT 0.00 0.00 0.00 185,600.00 0.00 -185,600.00 -100.00% 0.00 0.00 0.00% Total Category: 4500 - CAPITAL OUTLAY: 0.00 0.00 0.00 185,600.00 0.00 -185,600.00 -100.00% 0.00 0.00 0.00% 7/19/2018 10:18:58 AM Page 2 of 4 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 Category, 4720 - DEPRECIATION 4721- DEPRECIATION -PURCHASED 65,312.82 72,054.02 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% Total Category: 4720 - DEPRECIATION: 65,312.82 72,054.02 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00% Category: 4730 - MISCELLANEOUS 4738 - BAD DEBTS 191,060.59 255,139.44 0.00 252,000.00 252,000.00 0.00 0.00% 252,000.00 0.00 0.00% Total Category: 4730 - MISCELLANEOUS: 191,060.59 255,139.44 0.00 252,000.00 252,000.00 0.00 0.00% 252,000.00 0.00 0.00% Total Department: 24 - SOWASHCO AMBULANCE: 1,873,465.18 1,828,981.80 717,169.57 1,929,480.00 1,811,735.00 -117,745.00 -6.10% 1,839,270.00 27,535.00 1.52% Total Fund: 660 - SOUTH WASHINTON COUNTY AMBUL: 1,965,148.18 1,923,411.80 764,384.59 2,023,910.00 1,906,235.00 -117,675.00 -5.81% 1,933,770.00 27,535.00 1.44% Report Total: 1,965,148.18 1,923,411.80 764,384.59 2,023,910.00 1,906,235.00 -117,675.00 -5.81% 1,933,770.00 27,535.00 1.44% 7/19/2018 10:18:58 AM Page 3 of 4