Loading...
HomeMy WebLinkAbout3F. Public Safety� Cottage City Council Action Request � Grove /(/;, \'t05perity Meetere Pride an° Meeting Date Department Agenda Category Title Staff Recommendation 7/27/2022 Public Safety Agenda Item Public Safety Budget Implication Based on Discussion Attachments HERO Center Public Safety EMS Fund 3F 7/22/2022 12:35:51 PM Page 1 of 4 Budget Comparison Report Cottage Grove Group Summary Objec… 2020 Total Activity 2021 Total Activity 2022 YTD Activity Through Jul 2022 2022 2023 2023 Parent Budget Comparison 1 Budget Comparison 1 to Parent Budget % 2024 2024 FALL 2022 Comparison 2 Budget Comparison 2 to Comparison 1 Budget % Increase / (Decrease) Increase / (Decrease) Revenue Category: 3310 - INTERGOVERNMENTAL 3359 - OTHER GOV AID -100.00%0.00%0.002,000.00 -2,000.00 0.00 0.000.000.00116,650.00 Total Category: 3310 - INTERGOVERNMENTAL:0.000.00 2,000.00 -2,000.00 -100.00%0.00 0.00 0.00%0.00116,650.00 Category: 3400 - CHARGES FOR SERVICES 3572 - VENDING SALE 0.00%0.00%6,000.006,000.00 0.00 6,000.00 0.002,680.975,155.65559.29 3581 - PRE-TRAINING 0.00%8.33%600.000.00 600.00 650.00 50.000.00200.000.00 3582 - SHOOTING RANGES 11.52%7.89%190,000.00170,380.00 19,620.00 205,000.00 15,000.00107,806.83169,443.0244,966.38 3583 - CLASSROOM(S)59.09%3.00%35,000.0022,000.00 13,000.00 36,050.00 1,050.0012,412.5030,705.008,214.25 3584 - LARGE CONFERENCE ROOM A 0.00%0.00%0.000.00 0.00 0.00 0.000.000.000.00 3586 - REALITY BASED INSIDE -37.73%3.00%20,000.0032,120.00 -12,120.00 20,600.00 600.008,200.008,600.001,480.00 3587 - REALITY BASED OUTSIDE -58.33%3.00%8,000.0019,200.00 -11,200.00 8,240.00 240.001,762.503,900.002,200.00 3588 - MEMBERSHIPS 2.69%3.00%379,250.00369,315.00 9,935.00 390,630.00 11,380.00477,577.22281,647.00170,960.00 3589 - AMMUNITION -53.13%3.00%30,000.0064,000.00 -34,000.00 30,900.00 900.009,712.7853,238.838,498.84 3591 - HOSTED COURSE REGISTRATION 60.00%12.50%40,000.0025,000.00 15,000.00 45,000.00 5,000.0040,193.3334,473.7312,829.72 3592 - SIMULATOR 0.00%3.00%5,000.005,000.00 0.00 5,150.00 150.002,400.002,080.00420.00 3593 - RTR MATS ROOM -77.78%0.00%4,000.0018,000.00 -14,000.00 4,000.00 0.000.00-200.001,290.00 3596 - RENTAL OF EYE/EAR PROTECTION 0.00%0.00%500.00500.00 0.00 500.00 0.00118.00427.77242.00 Total Category: 3400 - CHARGES FOR SERVICES:718,350.00662,864.13 731,515.00 -13,165.00 -1.80%752,720.00 34,370.00 4.78%589,671.00251,660.48 Category: 3809 - INVESTMENT INTEREST 3810 - INVEST INTEREST 0.00%0.00%0.000.00 0.00 0.00 0.00-6,065.00-697.250.00 Total Category: 3809 - INVESTMENT INTEREST:0.00-6,065.00 0.00 0.00 0.00%0.00 0.00 0.00%-697.250.00 Category: 3812 - MISCELLANEOUS 3590 - PARTNER REVENUE 0.00%3.00%100,000.000.00 100,000.00 103,000.00 3,000.000.000.000.00 3594 - SALE OF BRASS 140.00%8.33%24,000.0010,000.00 14,000.00 26,000.00 2,000.008,173.2020,511.000.00 3812 - DONATE & CONTRI 0.00%0.00%0.000.00 0.00 0.00 0.000.0029,000.000.00 3816 - REFUND & REIMBRS 0.00%0.00%0.000.00 0.00 0.00 0.0024.001,036.48278.15 3829 - MISC - OTHER 0.00%6.53%34,590.000.00 34,590.00 36,850.00 2,260.000.000.00-26.81 3830 - CASH OVER/UNDER 0.00%0.00%0.000.00 0.00 0.00 0.002.68159.55-0.26 Total Category: 3812 - MISCELLANEOUS:158,590.008,199.88 10,000.00 148,590.00 1,485.90%165,850.00 7,260.00 4.58%50,707.03251.08 HERO Center Budget Comparison Report 7/22/2022 12:35:51 PM Page 2 of 4 Objec… 2020 Total Activity 2021 Total Activity 2022 YTD Activity Through Jul 2022 2022 2023 2023 Parent Budget Comparison 1 Budget Comparison 1 to Parent Budget % 2024 2024 FALL 2022 Comparison 2 Budget Comparison 2 to Comparison 1 Budget % Increase / (Decrease) Increase / (Decrease) Category: 3999 - TRANSFERS IN 3899 - TRANSFER IN 0.00%0.00%0.000.00 0.00 0.00 0.000.000.00126,389.00 Total Category: 3999 - TRANSFERS IN:0.000.00 0.00 0.00 0.00%0.00 0.00 0.00%0.00126,389.00 Total Revenue:876,940.00664,999.01 743,515.00 133,425.00 17.95%918,570.00 41,630.00 4.75%639,680.78494,950.56 Expense Category: 4100 - PERSONAL SERVICES 4100 - SALARY-FULL TIME 56.92%3.99%265,500.00169,190.00 96,310.00 276,100.00 10,600.0087,952.17158,487.47142,222.62 4110 - OVERTIME F. T.0.00%0.00%0.000.00 0.00 0.00 0.000.000.001,048.07 4120 - SAL-P.T./TEMP -5.76%3.99%75,200.0079,800.00 -4,600.00 78,200.00 3,000.0031,740.0053,738.8027,016.90 4141 - PERA 56.82%4.02%19,900.0012,690.00 7,210.00 20,700.00 800.006,596.4111,886.5610,906.49 4142 - FICA 37.01%3.83%26,100.0019,050.00 7,050.00 27,100.00 1,000.008,765.0915,206.3812,285.85 4144 - HEALTH INSURANCE 42.34%5.00%39,500.0027,750.00 11,750.00 41,475.00 1,975.0016,187.5026,319.9619,464.96 4148 - WORKERS COMP 199.02%1.64%6,100.002,040.00 4,060.00 6,200.00 100.001,190.001,100.04800.04 Total Category: 4100 - PERSONAL SERVICES:432,300.00152,431.17 310,520.00 121,780.00 39.22%449,775.00 17,475.00 4.04%266,739.21213,744.93 Category: 4200 - COMMODITIES 4210 - OP SUPPLY-OTHER 17.65%4.17%12,000.0010,200.00 1,800.00 12,500.00 500.004,581.669,962.2525,126.36 4217 - CLOTHING/UNIFORM 0.00%0.00%1,000.001,000.00 0.00 1,000.00 0.00157.50849.001,927.00 4280 - CAPITAL OUTLAY <$5,000 12.50%0.00%45,000.0040,000.00 5,000.00 45,000.00 0.00100.0030,923.8822,994.38 Total Category: 4200 - COMMODITIES:58,000.004,839.16 51,200.00 6,800.00 13.28%58,500.00 500.00 0.86%41,735.1350,047.74 Category: 4300 - CONTRACTUAL SERVICES 4300 - PROF SERVICES 37.50%3.00%11,000.008,000.00 3,000.00 11,330.00 330.003,897.875,565.1011,754.08 4302 - LEGAL SERVICE 0.00%0.00%3,000.003,000.00 0.00 3,000.00 0.000.002,160.502,758.50 4305 - FEES FOR SERVICE -6.08%3.00%17,000.0018,100.00 -1,100.00 17,510.00 510.007,465.5113,856.6714,348.14 4309 - CREDIT CARD FEES 0.00%0.00%10,000.0010,000.00 0.00 10,000.00 0.005,132.787,296.391,381.93 4310 - COMMUNICATION 25.00%5.56%3,600.002,880.00 720.00 3,800.00 200.001,621.182,877.202,326.40 4311 - POSTAGE 0.00%3.00%200.00200.00 0.00 206.00 6.00127.01100.6248.77 4321 - DATA PROCESSING 189.33%5.99%43,400.0015,000.00 28,400.00 46,000.00 2,600.008,900.0011,759.078,525.62 4340 - PRINTING 0.00%0.00%400.00400.00 0.00 400.00 0.000.00295.29160.00 4341 - ADVER/PUBLISH 0.00%3.00%6,000.006,000.00 0.00 6,180.00 180.001,611.672,549.750.00 4350 - INSURANCE CHARGE 8.86%2.65%11,300.0010,380.00 920.00 11,600.00 300.006,055.009,999.969,000.00 4360 - UTILITIES 29.44%3.00%116,500.0090,000.00 26,500.00 119,995.00 3,495.0055,379.8296,649.6378,001.12 4372 - MAINT-REPAIR/BLD -14.81%3.00%68,150.0080,000.00 -11,850.00 70,195.00 2,045.0069,656.0380,345.6549,942.20 4375 - CHARGE-FLEET MNT 0.00%3.00%2,300.000.00 2,300.00 2,369.00 69.0015.140.000.00 4380 - RENTAL/LEASE 40.00%3.00%4,200.003,000.00 1,200.00 4,326.00 126.001,344.704,227.664,678.23 4401 - DUES & SUBS -30.60%31.82%1,100.001,585.00 -485.00 1,450.00 350.0070.00636.001,200.00 4403 - TRAVEL/TRAIN/CON 0.00%0.00%5,000.005,000.00 0.00 5,000.00 0.001,612.912,690.02638.80 4405 - CLEAN/WASTE REMV -35.94%78.67%37,500.0058,540.00 -21,040.00 67,000.00 29,500.0044,640.3435,741.4720,944.52 4434 - SPECIAL EVENTS 0.00%0.00%20,000.000.00 20,000.00 20,000.00 0.0014,921.020.000.00 Budget Comparison Report 7/22/2022 12:35:51 PM Page 3 of 4 Objec… 2020 Total Activity 2021 Total Activity 2022 YTD Activity Through Jul 2022 2022 2023 2023 Parent Budget Comparison 1 Budget Comparison 1 to Parent Budget % 2024 2024 FALL 2022 Comparison 2 Budget Comparison 2 to Comparison 1 Budget % Increase / (Decrease) Increase / (Decrease) 4438 - PRO/MISC RESALE -58.33%3.00%25,000.0060,000.00 -35,000.00 25,750.00 750.001,969.3017,713.7214,814.00 Total Category: 4300 - CONTRACTUAL SERVICES:385,650.00224,420.28 372,085.00 13,565.00 3.65%426,111.00 40,461.00 10.49%294,464.70220,522.31 Category: 4500 - CAPITAL OUTLAY 4530 - MACH & EQUIPMENT 0.00%0.00%10,000.000.00 10,000.00 10,000.00 0.000.000.0011,210.48 Total Category: 4500 - CAPITAL OUTLAY:10,000.000.00 0.00 10,000.00 0.00%10,000.00 0.00 0.00%0.0011,210.48 Category: 4999 - TRANSFERS OUT 4700 - TRANSFERS OUT 0.00%6.57%34,390.000.00 34,390.00 36,650.00 2,260.000.000.000.00 Total Category: 4999 - TRANSFERS OUT:34,390.000.00 0.00 34,390.00 0.00%36,650.00 2,260.00 6.57%0.000.00 Total Expense:920,340.00381,690.61 733,805.00 186,535.00 25.42%981,036.00 60,696.00 6.59%602,939.04495,525.46 Report Total:-546.96%43.93%-43,400.00283,308.40 9,710.00 -53,110.00 -62,466.00 -19,066.0036,741.74-574.90 Budget Comparison Report 7/22/2022 12:35:51 PM Page 4 of 4 Fund Summary Fund 2020 Total Activity 2021 Total Activity 2022 YTD Activity Through Jul 2022 2022 2023 2023 Parent Budget Comparison 1 Budget Comparison 1 to Parent Budget % 2024 2024 FALL 2022 Comparison 2 Budget Comparison 2 to Comparison 1 Budget % Increase / (Decrease) Increase / (Decrease) 290 - HERO CENTER OPERATIONS -43,400.00283,308.40 9,710.00 -53,110.00 -546.96%-62,466.00 -19,066.00 43.93%36,741.74-574.90 Report Total:-546.96%43.93%-43,400.00283,308.40 9,710.00 -53,110.00 -62,466.00 -19,066.0036,741.74-574.90 Budget Comparison Report7/20/2022 5:44:34 PMPage 14 of 29Object2020Total AcƟvity2021Total AcƟvity2022YTD AcƟvityThrough Jul2022202220232023Parent BudgetComparison 1BudgetComparison 1to Parent Budget%20242024 FALL 2022Comparison 2BudgetComparison 2to Comparison 1 Budget%Increase /(Decrease)Increase /(Decrease)Department: 21 - POLICE PROTECTIONCategory: 4100 - PERSONAL SERVICES4100 - SALARY-FULL TIME5.96% 7.67%5,241,000.004,946,170.00 294,830.00 5,643,000.00 402,000.002,544,744.984,810,028.933,411,336.674110 - OVERTIME F. T.0.00% 4.50%200,000.00200,000.00 0.00 209,000.00 9,000.0094,392.10434,388.96222,657.554115 - REGULAR-P/T REG STATUS2.09% 4.53%90,500.0088,645.00 1,855.00 94,600.00 4,100.0033,975.1171,151.5076,838.524116 - O/T -P/T REG. STATUS0.00% 0.00%0.000.00 0.00 0.00 0.000.00507.60798.544120 - SAL-P.T./TEMP3.02% 4.48%93,700.0090,950.00 2,750.00 97,900.00 4,200.0072,692.63128,651.1889,703.504121 - O.T. - P.T./TEMP0.00% 0.00%0.000.00 0.00 0.00 0.00252.62824.930.004141 - PERA-1.56% 7.02%846,100.00859,500.00 -13,400.00 905,500.00 59,400.00414,507.90850,332.76629,771.604142 - FICA6.90% 10.78%123,400.00115,430.00 7,970.00 136,700.00 13,300.0058,537.06112,413.3986,832.644144 - HEALTH INSURANCE0.52% 36.69%477,960.00475,470.00 2,490.00 653,300.00 175,340.00277,357.50454,614.46440,786.544148 - WORKERS COMP51.13% 6.07%453,400.00300,000.00 153,400.00 480,900.00 27,500.00175,000.00178,299.96178,189.96Total Category: 4100 - PERSONAL SERVICES: 7,526,060.003,671,459.90 7,076,165.00 449,895.00 6.36% 8,220,900.00 694,840.00 9.23%7,041,213.675,136,915.52Category: 4200 - COMMODITIES4200 - OFFICE SUPPLIES3.11% 2.80%4,640.004,500.00 140.00 4,770.00 130.001,368.162,834.703,138.204210 - OP SUPPLY-OTHER14.50% 2.67%75,000.0065,500.00 9,500.00 77,000.00 2,000.009,178.6652,916.7451,405.214211 - MOTOR FUELS27.00% 4.02%114,300.0090,000.00 24,300.00 118,900.00 4,600.0045,359.6991,835.9977,041.504217 - CLOTHING/UNIFORM3.00% 2.99%77,150.0074,900.00 2,250.00 79,460.00 2,310.0062,829.1845,410.5973,975.024272 - OP SUP-BUILDINGS0.00% 0.00%3,000.003,000.00 0.00 3,000.00 0.000.002,628.092,657.394280 - CAPITAL OUTLAY <$5,0003.00% 2.99%24,720.0024,000.00 720.00 25,460.00 740.0028,711.8017,629.5725,206.34Total Category: 4200 - COMMODITIES: 298,810.00147,447.49 261,900.00 36,910.00 14.09% 308,590.00 9,780.00 3.27%213,255.68233,423.66Category: 4300 - CONTRACTUAL SERVICES4300 - PROF SERVICES2.97% 3.05%18,020.0017,500.00 520.00 18,570.00 550.0016,121.624,500.0417,351.084305 - FEES FOR SERVICE2.98% 3.01%26,570.0025,800.00 770.00 27,370.00 800.0020,340.6822,560.2423,078.094310 - COMMUNICATION3.00% 3.00%73,770.0071,620.00 2,150.00 75,980.00 2,210.0038,986.6576,785.9667,127.414311 - POSTAGE105.00% 0.00%410.00200.00 210.00 410.00 0.00344.53471.502,301.894321 - DATA PROCESSING24.55% 6.01%386,100.00310,000.00 76,100.00 409,300.00 23,200.00275,605.06397,627.70309,305.404340 - PRINTING2.50% 3.25%1,230.001,200.00 30.00 1,270.00 40.002,218.91792.62721.414341 - ADVER/PUBLISH-63.33% 9.09%110.00300.00 -190.00 120.00 10.000.000.000.004350 - INSURANCE CHARGE8.97% 2.95%50,900.0046,710.00 4,190.00 52,400.00 1,500.0027,247.5045,000.0040,500.004370 - MAINT-REPAIR/EQ3.00% 3.01%28,530.0027,700.00 830.00 29,390.00 860.0018,617.679,976.7220,625.614372 - MAINT-REPAIR/BLD0.00% 0.00%7,000.000.00 7,000.00 7,000.00 0.000.000.000.004375 - CHARGE-FLEET MNT27.09% 3.00%105,500.0083,010.00 22,490.00 108,670.00 3,170.0037,405.60115,036.68113,232.704380 - RENTAL/LEASE3.03% 2.94%20,400.0019,800.00 600.00 21,000.00 600.002,848.189,906.1012,426.464401 - DUES & SUBS2.89% 3.07%3,910.003,800.00 110.00 4,030.00 120.002,715.721,789.083,109.084403 - TRAVEL/TRAIN/CON11.04% 3.00%60,630.0054,600.00 6,030.00 62,450.00 1,820.0030,469.4350,008.9143,423.334405 - CLEAN/WASTE REMV2.94% 2.86%1,750.001,700.00 50.00 1,800.00 50.00395.71504.13406.804434 - SPECIAL EVENTS47.26% -9.92%16,640.0011,300.00 5,340.00 14,990.00 -1,650.0010,025.0010,421.7810,000.00 Budget Comparison Report7/20/2022 5:44:34 PMPage 15 of 29Object2020Total AcƟvity2021Total AcƟvity2022YTD AcƟvityThrough Jul2022202220232023Parent BudgetComparison 1BudgetComparison 1to Parent Budget%20242024 FALL 2022Comparison 2BudgetComparison 2to Comparison 1 Budget%Increase /(Decrease)Increase /(Decrease)4449 - OTHER CONTRACT2.99% 3.01%8,960.008,700.00 260.00 9,230.00 270.001,413.018,593.475,472.00Total Category: 4300 - CONTRACTUAL SERVICES: 810,430.00484,755.27 683,940.00 126,490.00 18.49% 843,980.00 33,550.00 4.14%753,974.93669,081.26Category: 4500 - CAPITAL OUTLAY4530 - MACH & EQUIPMENT81.33% 3.00%408,000.00225,000.00 183,000.00 420,240.00 12,240.0046,142.17161,410.02170,628.79Total Category: 4500 - CAPITAL OUTLAY: 408,000.0046,142.17 225,000.00 183,000.00 81.33% 420,240.00 12,240.00 3.00%161,410.02170,628.79Total Department: 21 - POLICE PROTECTION: 9,043,300.004,349,804.83 8,247,005.00 796,295.00 9.66% 9,793,710.00 750,410.00 8.30%8,169,854.306,210,049.23 Budget Comparison Report7/20/2022 5:44:34 PMPage 16 of 29Object2020Total AcƟvity2021Total AcƟvity2022YTD AcƟvityThrough Jul2022202220232023Parent BudgetComparison 1BudgetComparison 1to Parent Budget%20242024 FALL 2022Comparison 2BudgetComparison 2to Comparison 1 Budget%Increase /(Decrease)Increase /(Decrease)Department: 23 - ANIMAL CONTROLCategory: 4100 - PERSONAL SERVICES4120 - SAL-P.T./TEMP0.00% 3.00%15,000.0015,000.00 0.00 15,450.00 450.000.0015,000.0015,000.004142 - FICA0.00% 3.18%1,100.001,100.00 0.00 1,135.00 35.000.001,100.001,100.004148 - WORKERS COMP10.00% 0.00%110.00100.00 10.00 110.00 0.0058.3199.96220.04Total Category: 4100 - PERSONAL SERVICES:16,210.0058.31 16,200.00 10.00 0.06% 16,695.00 485.00 2.99%16,199.9616,320.04Category: 4200 - COMMODITIES4200 - OFFICE SUPPLIES0.00% 5.00%200.00200.00 0.00 210.00 10.000.00105.0045.004210 - OP SUPPLY-OTHER3.00% 2.91%1,030.001,000.00 30.00 1,060.00 30.00333.340.001,239.134211 - MOTOR FUELS0.00% 0.00%400.000.00 400.00 400.00 0.000.000.000.004217 - CLOTHING/UNIFORM3.13% 3.03%3,300.003,200.00 100.00 3,400.00 100.001,337.751,714.57868.82Total Category: 4200 - COMMODITIES:4,930.001,671.09 4,400.00 530.00 12.05% 5,070.00 140.00 2.84%1,819.572,152.95Category: 4300 - CONTRACTUAL SERVICES4300 - PROF SERVICES3.33% 3.23%310.00300.00 10.00 320.00 10.000.000.000.004305 - FEES FOR SERVICE3.06% 2.97%6,390.006,200.00 190.00 6,580.00 190.002,696.005,866.003,762.004321 - DATA PROCESSING0.00% 0.00%0.000.00 0.00 0.00 0.000.000.002,750.044340 - PRINTING0.00% 5.00%200.00200.00 0.00 210.00 10.000.000.000.004375 - CHARGE-FLEET MNT-65.79% 3.08%1,300.003,800.00 -2,500.00 1,340.00 40.000.000.003,630.00Total Category: 4300 - CONTRACTUAL SERVICES:8,200.002,696.00 10,500.00 -2,300.00 -21.90% 8,450.00 250.00 3.05%5,866.0010,142.04Total Department: 23 - ANIMAL CONTROL:29,340.004,425.40 31,100.00 -1,760.00 -5.66% 30,215.00 875.00 2.98%23,885.5328,615.03 Budget Comparison Report7/20/2022 5:44:34 PMPage 13 of 29Object2020Total AcƟvity2021Total AcƟvity2022YTD AcƟvityThrough Jul2022202220232023Parent BudgetComparison 1BudgetComparison 1to Parent Budget%20242024 FALL 2022Comparison 2BudgetComparison 2to Comparison 1 Budget%Increase /(Decrease)Increase /(Decrease)Department: 15 - EMERGENCY PREPAREDNESSCategory: 4100 - PERSONAL SERVICES4100 - SALARY-FULL TIME11.44% 4.70%36,200.0032,485.00 3,715.00 37,900.00 1,700.0017,846.4033,623.1926,735.554110 - OVERTIME F. T.0.00% 0.00%0.000.00 0.00 0.00 0.00496.86506.7442,923.024141 - PERA0.87% 5.17%5,800.005,750.00 50.00 6,100.00 300.003,198.915,928.724,844.214142 - FICA6.38% 0.00%500.00470.00 30.00 500.00 0.00251.94469.04422.014144 - HEALTH INSURANCE4.65% 11.11%2,700.002,580.00 120.00 3,000.00 300.001,505.002,349.962,280.004148 - WORKERS COMP3.85% 7.41%2,700.002,600.00 100.00 2,900.00 200.001,516.691,800.001,830.00Total Category: 4100 - PERSONAL SERVICES:47,900.0024,815.80 43,885.00 4,015.00 9.15% 50,400.00 2,500.00 5.22%44,677.6579,034.79Category: 4200 - COMMODITIES4210 - OP SUPPLY-OTHER0.00% 10.00%100.00100.00 0.00 110.00 10.00549.50134.984,631.204211 - MOTOR FUELS580.00% 5.88%1,700.00250.00 1,450.00 1,800.00 100.000.00331.76265.014280 - CAPITAL OUTLAY <$5,0000.00% 0.00%0.000.00 0.00 0.00 0.000.000.00680.85Total Category: 4200 - COMMODITIES:1,800.00549.50 350.00 1,450.00 414.29% 1,910.00 110.00 6.11%466.745,577.06Category: 4300 - CONTRACTUAL SERVICES4300 - PROF SERVICES3.00% 2.91%1,030.001,000.00 30.00 1,060.00 30.00800.00800.001,916.504305 - FEES FOR SERVICE3.00% 2.91%4,120.004,000.00 120.00 4,240.00 120.002,718.692,718.692,842.114310 - COMMUNICATION2.86% 3.06%3,600.003,500.00 100.00 3,710.00 110.001,979.333,524.043,500.764311 - POSTAGE0.00% 0.00%0.000.00 0.00 0.00 0.00408.250.000.004360 - UTILITIES2.00% 3.92%510.00500.00 10.00 530.00 20.00323.63673.68492.074370 - MAINT-REPAIR/EQ2.98% 3.00%9,680.009,400.00 280.00 9,970.00 290.00190.001,458.74663.004375 - CHARGE-FLEET MNT-36.65% 2.86%1,400.002,210.00 -810.00 1,440.00 40.0047.460.000.004401 - DUES & SUBS0.00% 5.00%200.00200.00 0.00 210.00 10.0050.00225.00250.004403 - TRAVEL/TRAIN/CON3.08% 2.99%1,340.001,300.00 40.00 1,380.00 40.00999.06820.000.00Total Category: 4300 - CONTRACTUAL SERVICES:21,880.007,516.42 22,110.00 -230.00 -1.04% 22,540.00 660.00 3.02%10,220.159,664.44Category: 4500 - CAPITAL OUTLAY4530 - MACH & EQUIPMENT-100.00% 0.00%0.0016,600.00 -16,600.00 32,000.00 32,000.0022,894.2631,976.250.00Total Category: 4500 - CAPITAL OUTLAY:0.0022,894.26 16,600.00 -16,600.00 -100.00% 32,000.00 32,000.00 0.00%31,976.250.00Total Department: 15 - EMERGENCY PREPAREDNESS:71,580.0055,775.98 82,945.00 -11,365.00 -13.70% 106,850.00 35,270.00 49.27%87,340.7994,276.29 Budget Comparison Report7/20/2022 5:44:34 PMPage 17 of 29Object2020Total AcƟvity2021Total AcƟvity2022YTD AcƟvityThrough Jul2022202220232023Parent BudgetComparison 1BudgetComparison 1to Parent Budget%20242024 FALL 2022Comparison 2BudgetComparison 2to Comparison 1 Budget%Increase /(Decrease)Increase /(Decrease)Department: 26 - FIRE PROTECTIONCategory: 4100 - PERSONAL SERVICES4100 - SALARY-FULL TIME27.44% 22.99%546,700.00429,000.00 117,700.00 672,400.00 125,700.00207,249.55366,275.51464,273.414110 - OVERTIME F. T.0.00% 4.52%31,000.0031,000.00 0.00 32,400.00 1,400.0041,182.1559,141.2424,383.404115 - REGULAR-P/T REG STATUS-100.00% 0.00%0.0031,200.00 -31,200.00 0.00 0.000.000.000.004120 - SAL-P.T./TEMP0.00% 4.48%165,000.00165,000.00 0.00 172,400.00 7,400.0079,824.72166,498.50173,810.144121 - O.T. - P.T./TEMP0.00% 0.00%0.000.00 0.00 0.00 0.005,350.9817,123.7312,828.714141 - PERA15.81% 22.81%91,200.0078,750.00 12,450.00 112,000.00 20,800.0038,977.8973,160.9189,432.694142 - FICA-4.29% 10.76%22,300.0023,300.00 -1,000.00 24,700.00 2,400.0011,073.2821,002.2222,731.584144 - HEALTH INSURANCE25.43% 31.14%57,800.0046,080.00 11,720.00 75,800.00 18,000.0026,880.0044,255.0450,000.044147 - UNEMPLOYMENT0.00% 0.00%0.000.00 0.00 0.00 0.001,659.160.000.004148 - WORKERS COMP-4.94% 21.95%49,200.0051,755.00 -2,555.00 60,000.00 10,800.0030,190.4444,900.0444,880.00Total Category: 4100 - PERSONAL SERVICES: 963,200.00442,388.17 856,085.00 107,115.00 12.51% 1,149,700.00 186,500.00 19.36%792,357.19882,339.97Category: 4200 - COMMODITIES4200 - OFFICE SUPPLIES2.86% 3.47%1,440.001,400.00 40.00 1,490.00 50.0090.000.00360.704210 - OP SUPPLY-OTHER2.96% 3.07%10,090.009,800.00 290.00 10,400.00 310.002,828.979,807.4312,081.104211 - MOTOR FUELS11.67% 3.73%13,400.0012,000.00 1,400.00 13,900.00 500.005,317.9511,409.689,412.094217 - CLOTHING/UNIFORM3.01% 3.00%47,280.0045,900.00 1,380.00 48,700.00 1,420.005,062.8627,663.4728,350.424270 - OP SUP-VEH/EQ3.08% 2.99%5,360.005,200.00 160.00 5,520.00 160.00682.641,880.656,010.904272 - OP SUP-BUILDINGS3.06% 2.96%3,710.003,600.00 110.00 3,820.00 110.001,243.813,486.982,301.864280 - CAPITAL OUTLAY <$5,0003.00% 2,106.80%10,300.0010,000.00 300.00 227,300.00 217,000.006,026.1615,801.9525,205.58Total Category: 4200 - COMMODITIES:91,580.0021,252.39 87,900.00 3,680.00 4.19% 311,130.00 219,550.00 239.74%70,050.1683,722.65Category: 4300 - CONTRACTUAL SERVICES4300 - PROF SERVICES3.02% 2.99%18,750.0018,200.00 550.00 19,310.00 560.003,190.872,927.5014,126.004305 - FEES FOR SERVICE53.95% 3.02%24,170.0015,700.00 8,470.00 24,900.00 730.0010,904.1017,557.3544,578.064310 - COMMUNICATION3.00% 2.98%28,840.0028,000.00 840.00 29,700.00 860.0014,346.0928,583.0724,871.054311 - POSTAGE0.00% 10.00%100.00100.00 0.00 110.00 10.0071.6530.2519.214321 - DATA PROCESSING28.70% 6.08%59,200.0046,000.00 13,200.00 62,800.00 3,600.0026,833.3142,009.9640,310.044340 - PRINTING0.00% 5.00%200.00200.00 0.00 210.00 10.0034.0028.670.004350 - INSURANCE CHARGE9.29% 2.89%17,300.0015,830.00 1,470.00 17,800.00 500.009,234.1915,249.9612,999.964360 - UTILITIES3.00% 3.01%51,500.0050,000.00 1,500.00 53,050.00 1,550.0037,132.5464,884.7152,057.244370 - MAINT-REPAIR/EQ3.00% 3.00%66,330.0064,400.00 1,930.00 68,320.00 1,990.0013,589.6682,674.5931,565.784372 - MAINT-REPAIR/BLD204.02% 201.17%68,100.0022,400.00 45,700.00 205,100.00 137,000.0044,712.9770,753.9159,117.664375 - CHARGE-FLEET MNT24.00% 3.00%31,000.0025,000.00 6,000.00 31,930.00 930.0035,166.1128,494.0520,498.394380 - RENTAL/LEASE3.00% 2.91%4,120.004,000.00 120.00 4,240.00 120.00962.963,206.723,491.504401 - DUES & SUBS3.00% 2.91%1,030.001,000.00 30.00 1,060.00 30.00420.00770.00545.004403 - TRAVEL/TRAIN/CON3.02% 2.98%21,840.0021,200.00 640.00 22,490.00 650.0016,707.8330,508.5318,236.054405 - CLEAN/WASTE REMV2.97% 3.02%15,240.0014,800.00 440.00 15,700.00 460.009,126.8816,786.9914,866.954434 - SPECIAL EVENTS2.86% 2.78%720.00700.00 20.00 740.00 20.00100.00800.000.00 Budget Comparison Report7/20/2022 5:44:34 PMPage 18 of 29Object2020Total AcƟvity2021Total AcƟvity2022YTD AcƟvityThrough Jul2022202220232023Parent BudgetComparison 1BudgetComparison 1to Parent Budget%20242024 FALL 2022Comparison 2BudgetComparison 2to Comparison 1 Budget%Increase /(Decrease)Increase /(Decrease)4449 - OTHER CONTRACT3.00% 3.00%206,000.00200,000.00 6,000.00 212,180.00 6,180.0014.25233,759.46433.25Total Category: 4300 - CONTRACTUAL SERVICES: 614,440.00222,547.41 527,530.00 86,910.00 16.47% 769,640.00 155,200.00 25.26%639,025.72337,716.14Total Department: 26 - FIRE PROTECTION: 1,669,220.00686,187.97 1,471,515.00 197,705.00 13.44% 2,230,470.00 561,250.00 33.62%1,501,433.071,303,778.76 7/22/2022 12:45:12 PM Page 1 of 4 Budget Comparison Report Cottage Grove Group Summary Objec… 2020 Total Activity 2021 Total Activity 2022 YTD Activity Through Jul 2022 2022 2023 2023 Parent Budget Comparison 1 Budget Comparison 1 to Parent Budget % 2024 2024 FALL 2022 Comparison 2 Budget Comparison 2 to Comparison 1 Budget % Increase / (Decrease) Increase / (Decrease) Fund: 660 - SOUTH WASHINTON COUNTY AMBUL Revenue Category: 3310 - INTERGOVERNMENTAL 3310 - FEDERAL GRANTS 0.00%0.00%0.000.00 0.00 0.00 0.000.0058,918.6818,766.83 3349 - COUNTY AID 0.00%0.00%0.000.00 0.00 0.00 0.006,750.0054,064.2520,579.50 Total Category: 3310 - INTERGOVERNMENTAL:0.00%0.00%0.000.00 0.00 0.00 0.006,750.00112,982.9339,346.33 Category: 3400 - CHARGES FOR SERVICES 3534 - SOWASHCO SERVICE 0.00%0.00%4,860,000.004,860,000.00 0.00 4,860,000.00 0.002,829,475.305,892,265.964,315,087.36 3550 - NON-DISCRETIONARY WRITE OFFS 0.00%0.00%-2,430,000.00-2,430,000.00 0.00 -2,430,000.00 0.00-1,622,468.83-2,581,566.15-2,222,686.04 Total Category: 3400 - CHARGES FOR SERVICES:0.00%0.00%2,430,000.002,430,000.00 0.00 2,430,000.00 0.001,207,006.473,310,699.812,092,401.32 Category: 3809 - INVESTMENT INTEREST 3810 - INVEST INTEREST -100.00%0.00%0.007,500.00 -7,500.00 0.00 0.00-72.27-1,392.0210,471.55 Total Category: 3809 - INVESTMENT INTEREST:-100.00%0.00%0.007,500.00 -7,500.00 0.00 0.00-72.27-1,392.0210,471.55 Category: 3812 - MISCELLANEOUS 3812 - DONATE & CONTRI 0.00%0.00%0.000.00 0.00 0.00 0.00500.000.000.00 3813 - SALE OF GOODS 0.00%0.00%0.000.00 0.00 0.00 0.000.001,116.050.00 3816 - REFUND & REIMBRS 0.00%0.00%0.000.00 0.00 0.00 0.0068,493.2178,968.640.00 Total Category: 3812 - MISCELLANEOUS:0.00%0.00%0.000.00 0.00 0.00 0.0068,993.2180,084.690.00 Total Revenue:2,430,000.001,282,677.41 2,437,500.00 -7,500.00 -0.31%2,430,000.00 0.00 0.00%3,502,375.412,142,219.20 Expense Category: 4100 - PERSONAL SERVICES 4100 - SALARY-FULL TIME 5.35%4.50%1,011,900.00960,490.00 51,410.00 1,057,400.00 45,500.00427,114.16830,691.18763,159.31 4110 - OVERTIME F. T.0.06%4.52%81,800.0081,750.00 50.00 85,500.00 3,700.00124,557.43166,211.2948,530.93 4115 - REGULAR-P/T REG STATUS 0.00%0.00%0.000.00 0.00 0.00 0.000.00975.000.00 4120 - SAL-P.T./TEMP 0.00%4.52%270,000.00270,000.00 0.00 282,200.00 12,200.00117,172.30252,464.64271,574.21 4121 - O.T. - P.T./TEMP 0.00%0.00%0.000.00 0.00 0.00 0.005,188.4213,021.339,934.87 4140 - PENSIONS 0.00%0.00%0.000.00 0.00 0.00 0.000.00-110,975.21-43,619.46 4141 - PERA -1.53%4.58%174,600.00177,315.00 -2,715.00 182,600.00 8,000.0092,028.17170,829.83147,976.26 4142 - FICA 2.50%3.65%38,400.0037,465.00 935.00 39,800.00 1,400.0017,113.7535,801.3735,666.74 4144 - HEALTH INSURANCE -3.03%9.88%113,400.00116,940.00 -3,540.00 124,600.00 11,200.0068,215.00112,770.04109,848.04 EMS Revenue needs to be studied further by Finance. These are draft numbers-07-22-2022 Budget Comparison Report 7/22/2022 12:45:12 PM Page 2 of 4 Objec… 2020 Total Activity 2021 Total Activity 2022 YTD Activity Through Jul 2022 2022 2023 2023 Parent Budget Comparison 1 Budget Comparison 1 to Parent Budget % 2024 2024 FALL 2022 Comparison 2 Budget Comparison 2 to Comparison 1 Budget % Increase / (Decrease) Increase / (Decrease) 4148 - WORKERS COMP -6.88%5.44%71,700.0077,000.00 -5,300.00 75,600.00 3,900.0044,916.6951,699.9651,669.96 Total Category: 4100 - PERSONAL SERVICES:2.37%4.88%1,761,800.001,720,960.00 40,840.00 1,847,700.00 85,900.00896,305.921,523,489.431,394,740.86 Category: 4200 - COMMODITIES 4200 - OFFICE SUPPLIES 0.00%10.00%100.00100.00 0.00 110.00 10.000.000.0051.99 4210 - OP SUPPLY-OTHER 2.99%3.02%54,380.0052,800.00 1,580.00 56,020.00 1,640.0024,896.98107,803.3537,521.73 4211 - MOTOR FUELS 44.44%3.85%26,000.0018,000.00 8,000.00 27,000.00 1,000.0011,069.2122,203.0216,370.65 4217 - CLOTHING/UNIFORM 3.02%3.00%14,320.0013,900.00 420.00 14,750.00 430.001,837.2011,067.155,517.53 4280 - CAPITAL OUTLAY <$5,000 0.00%0.00%0.000.00 0.00 0.00 0.00500.006,327.995,279.00 Total Category: 4200 - COMMODITIES:11.79%3.25%94,800.0084,800.00 10,000.00 97,880.00 3,080.0038,303.39147,401.5164,740.90 Category: 4300 - CONTRACTUAL SERVICES 4300 - PROF SERVICES 60.46%2.08%27,920.0017,400.00 10,520.00 28,500.00 580.0016,803.0013,536.5017,992.38 4305 - FEES FOR SERVICE -13.50%3.57%52,420.0060,600.00 -8,180.00 54,290.00 1,870.0031,701.0487,644.4585,260.13 4309 - CREDIT CARD FEES 2.95%3.05%5,240.005,090.00 150.00 5,400.00 160.002,787.653,807.684,391.26 4310 - COMMUNICATION 3.02%2.99%16,380.0015,900.00 480.00 16,870.00 490.007,891.7215,918.3915,149.87 4311 - POSTAGE 0.00%0.00%0.000.00 0.00 0.00 0.0034.890.0019.21 4321 - DATA PROCESSING 140.89%6.00%108,400.0045,000.00 63,400.00 114,900.00 6,500.0026,250.0041,060.0429,829.96 4350 - INSURANCE CHARGE 8.43%3.33%9,000.008,300.00 700.00 9,300.00 300.004,841.698,000.043,000.00 4370 - MAINT-REPAIR/EQ 3.00%2.99%36,770.0035,700.00 1,070.00 37,870.00 1,100.001,212.432,981.5824,738.35 4372 - MAINT-REPAIR/BLD 0.00%-100.00%37,600.000.00 37,600.00 0.00 -37,600.000.007,166.1517,498.80 4375 - CHARGE-FLEET MNT 1.42%2.99%42,800.0042,200.00 600.00 44,080.00 1,280.0014,297.6335,402.1151,361.56 4401 - DUES & SUBS 3.00%2.91%5,150.005,000.00 150.00 5,300.00 150.002,902.003,050.912,477.00 4403 - TRAVEL/TRAIN/CON 3.02%2.98%21,840.0021,200.00 640.00 22,490.00 650.005,444.5023,223.5610,254.99 4449 - OTHER CONTRACT 0.00%0.00%0.000.00 0.00 0.00 0.000.000.00505.00 Total Category: 4300 - CONTRACTUAL SERVICES:41.78%-6.75%363,520.00256,390.00 107,130.00 339,000.00 -24,520.00114,166.55241,791.41262,478.51 Category: 4500 - CAPITAL OUTLAY 4530 - MACH & EQUIPMENT -100.00%0.00%0.0025,500.00 -25,500.00 452,300.00 452,300.0034,416.090.000.00 Total Category: 4500 - CAPITAL OUTLAY:-100.00%0.00%0.0025,500.00 -25,500.00 452,300.00 452,300.0034,416.090.000.00 Category: 4720 - DEPRECIATION 4721 - DEPRECIATION-PURCHASED 0.00%0.00%0.000.00 0.00 0.00 0.000.0079,338.6680,233.13 Total Category: 4720 - DEPRECIATION:0.00%0.00%0.000.00 0.00 0.00 0.000.0079,338.6680,233.13 Category: 4730 - MISCELLANEOUS 4732 - LOSS-FIXED ASSET 0.00%0.00%0.000.00 0.00 0.00 0.000.0055,064.390.00 4738 - BAD DEBTS 19.05%0.00%300,000.00252,000.00 48,000.00 300,000.00 0.000.00864,679.05319,696.54 Total Category: 4730 - MISCELLANEOUS:19.05%0.00%300,000.00252,000.00 48,000.00 300,000.00 0.000.00919,743.44319,696.54 Budget Comparison Report 7/22/2022 12:45:12 PM Page 3 of 4 Objec… 2020 Total Activity 2021 Total Activity 2022 YTD Activity Through Jul 2022 2022 2023 2023 Parent Budget Comparison 1 Budget Comparison 1 to Parent Budget % 2024 2024 FALL 2022 Comparison 2 Budget Comparison 2 to Comparison 1 Budget % Increase / (Decrease) Increase / (Decrease) Category: 4999 - TRANSFERS OUT 4700 - TRANSFERS OUT 3.01%2.98%100,800.0097,850.00 2,950.00 103,800.00 3,000.0057,079.1995,000.0494,500.00 Total Category: 4999 - TRANSFERS OUT:3.01%2.98%100,800.0097,850.00 2,950.00 103,800.00 3,000.0057,079.1995,000.0494,500.00 Total Expense:2,620,920.001,140,271.14 2,437,500.00 183,420.00 7.52%3,140,680.00 519,760.00 19.83%3,006,764.492,216,389.94 Total Fund: 660 - SOUTH WASHINTON COUNTY AMBUL:-190,920.00142,406.27 0.00 -190,920.00 0.00%-710,680.00 -519,760.00 272.24%495,610.92-74,170.74 Report Total:0.00%272.24%-190,920.00142,406.27 0.00 -190,920.00 -710,680.00 -519,760.00495,610.92-74,170.74 Budget Comparison Report 7/22/2022 12:45:12 PM Page 4 of 4 Fund Summary Fund 2020 Total Activity 2021 Total Activity 2022 YTD Activity Through Jul 2022 2022 2023 2023 Parent Budget Comparison 1 Budget Comparison 1 to Parent Budget % 2024 2024 FALL 2022 Comparison 2 Budget Comparison 2 to Comparison 1 Budget % Increase / (Decrease) Increase / (Decrease) 660 - SOUTH WASHINTON COUNTY AMBUL -190,920.00142,406.27 0.00 -190,920.00 0.00%-710,680.00 -519,760.00 272.24%495,610.92-74,170.74 Report Total:0.00%272.24%-190,920.00142,406.27 0.00 -190,920.00 -710,680.00 -519,760.00495,610.92-74,170.74