Loading...
HomeMy WebLinkAbout3C. General Government� Cottage � Grove /(/;, \'t05perity Meetere Pride an° Meeting Date 7/27/2022 Department Administration Agenda Category Agenda Item City Council Action Request 3C Title General Government Staff Recommendation Budget Implication Based on Discussion Attachments General Government Comparison Report Budget Comparison Report7/20/2022 5:44:34 PMPage 2 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: 01 - MAYOR-COUNCILCategory: 4100 - PERSONAL SERVICES4120 - SAL-P.T./TEMP0.00% 0.00%43,600.0043,600.00 0.00 43,600.00 0.0025,396.0043,195.5043,536.004141 - PERA0.00% 0.00%1,500.001,500.00 0.00 1,500.00 0.00793.101,291.501,359.604142 - FICA0.00% 0.00%1,830.001,830.00 0.00 1,830.00 0.00959.211,702.761,644.364148 - WORKERS COMP6.67% 0.00%160.00150.00 10.00 160.00 0.0087.06140.04140.04Total Category: 4100 - PERSONAL SERVICES:47,090.0027,235.37 47,080.00 10.00 0.02% 47,090.00 0.00 0.00%46,329.8046,680.00Category: 4200 - COMMODITIES4200 - OFFICE SUPPLIES0.00% 0.00%0.000.00 0.00 0.00 0.0044.000.000.004210 - OP SUPPLY-OTHER204.00% 0.00%1,520.00500.00 1,020.00 1,520.00 0.00129.00141.0065.66Total Category: 4200 - COMMODITIES:1,520.00173.00 500.00 1,020.00 204.00% 1,520.00 0.00 0.00%141.0065.66Category: 4300 - CONTRACTUAL SERVICES4300 - PROF SERVICES29.52% 3.97%6,800.005,250.00 1,550.00 7,070.00 270.006,500.005,250.00453.574305 - FEES FOR SERVICE4.00% 2.56%780.00750.00 30.00 800.00 20.000.000.000.004340 - PRINTING0.00% 0.00%100.00100.00 0.00 100.00 0.0055.000.000.004350 - INSURANCE CHARGE5.96% 0.00%1,600.001,510.00 90.00 1,600.00 0.00880.531,449.965,450.044401 - DUES & SUBS5.71% 3.93%40,700.0038,500.00 2,200.00 42,300.00 1,600.0010,488.0037,148.0035,798.004403 - TRAVEL/TRAIN/CON400.00% 0.00%5,000.001,000.00 4,000.00 5,000.00 0.001,895.57275.00953.374434 - SPECIAL EVENTS200.00% 0.00%3,000.001,000.00 2,000.00 3,000.00 0.00814.82903.27100.00Total Category: 4300 - CONTRACTUAL SERVICES:57,980.0020,633.92 48,110.00 9,870.00 20.52% 59,870.00 1,890.00 3.26%45,026.2342,754.98Total Department: 01 - MAYOR-COUNCIL: 106,590.0048,042.29 95,690.00 10,900.00 11.39% 108,480.00 1,890.00 1.77%91,497.0389,500.64 Budget Comparison Report7/20/2022 5:44:34 PMPage 3 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: 02 - ADMINISTRATIONCategory: 4100 - PERSONAL SERVICES4100 - SALARY-FULL TIME12.85% 4.52%677,300.00600,185.00 77,115.00 707,900.00 30,600.00325,819.46502,661.35515,955.904120 - SAL-P.T./TEMP-100.00% 0.00%0.007,680.00 -7,680.00 0.00 0.000.000.000.004141 - PERA12.85% 4.72%50,800.0045,015.00 5,785.00 53,200.00 2,400.0022,868.9635,992.5838,821.134142 - FICA18.85% 4.64%51,700.0043,500.00 8,200.00 54,100.00 2,400.0023,297.4435,577.9938,051.424144 - HEALTH INSURANCE-1.37% 10.15%72,900.0073,915.00 -1,015.00 80,300.00 7,400.0043,116.9847,940.0047,000.044148 - WORKERS COMP-19.68% 2.50%4,000.004,980.00 -980.00 4,100.00 100.002,905.003,339.963,240.00Total Category: 4100 - PERSONAL SERVICES: 856,700.00418,007.84 775,275.00 81,425.00 10.50% 899,600.00 42,900.00 5.01%625,511.88643,068.49Category: 4200 - COMMODITIES4200 - OFFICE SUPPLIES0.00% 0.00%0.000.00 0.00 0.00 0.00218.56503.67420.664210 - OP SUPPLY-OTHER0.00% 20.00%500.00500.00 0.00 600.00 100.001,342.96243.33217.44Total Category: 4200 - COMMODITIES:500.001,561.52 500.00 0.00 0.00% 600.00 100.00 20.00%747.00638.10Category: 4300 - CONTRACTUAL SERVICES4300 - PROF SERVICES2.94% 431.43%10,500.0010,200.00 300.00 55,800.00 45,300.002,427.003,124.5014,308.524302 - LEGAL SERVICE0.00% 0.00%0.000.00 0.00 0.00 0.001,139.00300.00105.004305 - FEES FOR SERVICE2.94% 4.76%2,100.002,040.00 60.00 2,200.00 100.002,059.56500.002,486.004310 - COMMUNICATION4.25% 3.70%2,700.002,590.00 110.00 2,800.00 100.001,650.062,544.392,328.864321 - DATA PROCESSING107.32% 6.12%42,500.0020,500.00 22,000.00 45,100.00 2,600.0011,958.3116,415.0418,935.044340 - PRINTING6.67% 0.00%800.00750.00 50.00 800.00 0.0055.00140.34295.004341 - ADVER/PUBLISH4.55% 4.35%2,300.002,200.00 100.00 2,400.00 100.0079.90956.21430.804350 - INSURANCE CHARGE8.85% 3.25%12,300.0011,300.00 1,000.00 12,700.00 400.006,591.6910,890.000.004370 - MAINT-REPAIR/EQ0.00% 0.00%0.000.00 0.00 0.00 0.000.000.000.004401 - DUES & SUBS3.23% 3.13%3,200.003,100.00 100.00 3,300.00 100.003,846.483,287.332,445.494403 - TRAVEL/TRAIN/CON2.78% 3.38%14,800.0014,400.00 400.00 15,300.00 500.004,108.027,599.832,787.844434 - SPECIAL EVENTS5.00% 4.76%2,100.002,000.00 100.00 2,200.00 100.006,736.781,621.58866.86Total Category: 4300 - CONTRACTUAL SERVICES:93,300.0040,651.80 69,080.00 24,220.00 35.06% 142,600.00 49,300.00 52.84%47,379.2244,989.41Total Department: 02 - ADMINISTRATION: 950,500.00460,221.16 844,855.00 105,645.00 12.50% 1,042,800.00 92,300.00 9.71%673,638.10688,696.00 Budget Comparison Report7/20/2022 5:44:34 PMPage 4 of 292020Total AcƟvity2021Total AcƟvity2022YTD AcƟvityThrough Jul2022202220232023Parent BudgetComparison 1BudgetComparison 1to Parent Budget%20242024 FALL 2022Comparison 2BudgetComparison 2to Comparison 1 Budget%Increase /(Decrease)Increase /(Decrease)ObjectDepartment: 03 - LEGAL AND ASSESSINGCategory: 4300 - CONTRACTUAL SERVICES4300 - PROF SERVICES3.02%3.02%221,800.00215,300.006,500.00228,500.00 6,700.00232,799.38203,106.11191,389.874301 - ENGINEERING SVS0.00%0.00%0.000.000.000.000.000.000.00144.504302 - LEGAL SERVICE3.04%2.95%237,000.00230,000.007,000.00244,000.00 7,000.00111,349.50234,737.76226,809.66458,800.00344,148.88 445,300.0013,500.00 3.03% 472,500.00 13,700.00 2.99%437,843.87418,344.03Total Category: 4300 - CONTRACTUAL SERVICES:Total Department: 03 - LEGAL AND ASSESSING:458,800.00344,148.88 445,300.0013,500.00 3.03% 472,500.00 13,700.00 2.99%437,843.87418,344.03 Budget Comparison Report7/20/2022 5:44:34 PMPage 5 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: 04 - CITY CLERK/ELECTIONSCategory: 4100 - PERSONAL SERVICES4100 - SALARY-FULL TIME0.00% 0.00%0.000.00 0.00 0.00 0.0015,416.00-200.000.004120 - SAL-P.T./TEMP-100.00% 0.00%0.0050,000.00 -50,000.00 0.00 0.000.0042,671.2560,223.434141 - PERA0.00% 0.00%0.000.00 0.00 0.00 0.001,156.20186.0043.214142 - FICA-100.00% 0.00%0.003,825.00 -3,825.00 0.00 0.001,024.552,260.271,469.14Total Category: 4100 - PERSONAL SERVICES:0.0017,596.75 53,825.00 -53,825.00 -100.00% 0.00 0.00 0.00%44,917.5261,735.78Category: 4200 - COMMODITIES4200 - OFFICE SUPPLIES0.00% 0.00%0.000.00 0.00 0.00 0.000.0065.00650.884210 - OP SUPPLY-OTHER0.00% 20.00%500.00500.00 0.00 600.00 100.000.0031.32502.77Total Category: 4200 - COMMODITIES:500.000.00 500.00 0.00 0.00% 600.00 100.00 20.00%96.321,153.65Category: 4300 - CONTRACTUAL SERVICES4300 - PROF SERVICES165.63% 16.81%59,500.0022,400.00 37,100.00 69,500.00 10,000.001,942.323,541.362,406.644302 - LEGAL SERVICE2.93% 3.11%38,600.0037,500.00 1,100.00 39,800.00 1,200.0056,856.0025,157.500.004305 - FEES FOR SERVICE0.00% 0.00%0.000.00 0.00 0.00 0.000.0020.000.004340 - PRINTING0.00% 0.00%0.000.00 0.00 0.00 0.000.002,598.250.004341 - ADVER/PUBLISH0.00% 20.00%500.00500.00 0.00 600.00 100.000.00998.85368.154370 - MAINT-REPAIR/EQ12.75% 3.00%11,500.0010,200.00 1,300.00 11,845.00 345.0010,110.009,810.005,810.004401 - DUES & SUBS0.00% 0.00%0.000.00 0.00 0.00 0.000.0045.000.00Total Category: 4300 - CONTRACTUAL SERVICES: 110,100.0068,908.32 70,600.00 39,500.00 55.95% 121,745.00 11,645.00 10.58%42,170.968,584.79Total Department: 04 - CITY CLERK/ELECTIONS: 110,600.0086,505.07 124,925.00 -14,325.00 -11.47% 122,345.00 11,745.00 10.62%87,184.8071,474.22 Budget Comparison Report7/20/2022 5:44:34 PMPage 6 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: 05 - FINANCECategory: 4100 - PERSONAL SERVICES4100 - SALARY-FULL TIME2.21% 4.50%430,900.00421,595.00 9,305.00 450,300.00 19,400.00243,409.99463,043.82441,470.914110 - OVERTIME F. T.0.00% 0.00%0.000.00 0.00 0.00 0.00211.070.00160.444115 - REGULAR-P/T REG STATUS45.05% 4.55%26,400.0018,200.00 8,200.00 27,600.00 1,200.000.000.000.004120 - SAL-P.T./TEMP0.00% 0.00%0.000.00 0.00 0.00 0.0010,171.207,975.800.004141 - PERA3.99% 6.41%34,300.0032,985.00 1,315.00 36,500.00 2,200.0015,975.6134,966.8633,752.404142 - FICA3.73% 2.29%34,900.0033,645.00 1,255.00 35,700.00 800.0018,441.4033,436.7231,782.854144 - HEALTH INSURANCE21.09% 10.24%45,900.0037,905.00 7,995.00 50,600.00 4,700.0022,111.2548,000.0046,775.044148 - WORKERS COMP-24.48% 0.00%2,700.003,575.00 -875.00 2,700.00 0.002,085.442,880.002,880.00Total Category: 4100 - PERSONAL SERVICES: 575,100.00312,405.96 547,905.00 27,195.00 4.96% 603,400.00 28,300.00 4.92%590,303.20556,821.64Category: 4200 - COMMODITIES4200 - OFFICE SUPPLIES0.00% 0.00%0.000.00 0.00 0.00 0.000.00318.000.004210 - OP SUPPLY-OTHER50.00% 0.00%900.00600.00 300.00 900.00 0.00250.00123.76750.884280 - CAPITAL OUTLAY <$5,0000.00% 0.00%0.000.00 0.00 0.00 0.000.000.000.00Total Category: 4200 - COMMODITIES:900.00250.00 600.00 300.00 50.00% 900.00 0.00 0.00%441.76750.88Category: 4300 - CONTRACTUAL SERVICES4300 - PROF SERVICES13.61% 4.14%29,000.0025,525.00 3,475.00 30,200.00 1,200.0015,951.1427,252.3224,635.694305 - FEES FOR SERVICE0.00% 0.00%0.000.00 0.00 0.00 0.0010.56163.800.004309 - CREDIT CARD FEES0.00% 0.00%0.000.00 0.00 0.00 0.000.0013,870.6749,017.264310 - COMMUNICATION114.29% 0.00%1,800.00840.00 960.00 1,800.00 0.00585.001,867.501,595.004311 - POSTAGE0.00% 0.00%0.000.00 0.00 0.00 0.0026.950.000.004321 - DATA PROCESSING67.80% 6.10%34,400.0020,500.00 13,900.00 36,500.00 2,100.0011,958.3115,069.9613,359.964340 - PRINTING33.33% 0.00%1,000.00750.00 250.00 1,000.00 0.000.001,883.54707.884341 - ADVER/PUBLISH0.00% 25.00%200.00200.00 0.00 250.00 50.000.000.000.004401 - DUES & SUBS3.28% 3.17%630.00610.00 20.00 650.00 20.00460.00460.00610.004403 - TRAVEL/TRAIN/CON3.00% 3.33%6,000.005,825.00 175.00 6,200.00 200.00302.702,658.112,350.18Total Category: 4300 - CONTRACTUAL SERVICES:73,030.0029,294.66 54,250.00 18,780.00 34.62% 76,600.00 3,570.00 4.89%63,225.9092,275.97Total Department: 05 - FINANCE: 649,030.00341,950.62 602,755.00 46,275.00 7.68% 680,900.00 31,870.00 4.91%653,970.86649,848.49 Budget Comparison Report7/20/2022 5:44:34 PMPage 7 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: 08 - COMMUNITY & EMPLOYEE PROGCategory: 4100 - PERSONAL SERVICES4100 - SALARY-FULL TIME300.00% 0.00%10,000.002,500.00 7,500.00 10,000.00 0.001,075.006,080.990.004120 - SAL-P.T./TEMP0.00% 0.00%0.000.00 0.00 0.00 0.00275.00670.000.004141 - PERA0.00% 0.00%0.000.00 0.00 0.00 0.000.00341.700.004142 - FICA0.00% 0.00%0.000.00 0.00 0.00 0.000.00348.530.00Total Category: 4100 - PERSONAL SERVICES:10,000.001,350.00 2,500.00 7,500.00 300.00% 10,000.00 0.00 0.00%7,441.220.00Category: 4200 - COMMODITIES4210 - OP SUPPLY-OTHER300.00% -50.00%2,000.00500.00 1,500.00 1,000.00 -1,000.0030.180.00152.10Total Category: 4200 - COMMODITIES:2,000.0030.18 500.00 1,500.00 300.00% 1,000.00 -1,000.00 -50.00%0.00152.10Category: 4300 - CONTRACTUAL SERVICES4300 - PROF SERVICES-0.79% 5.73%38,890.0039,200.00 -310.00 41,120.00 2,230.0014,000.000.0036,500.004311 - POSTAGE0.00% 0.00%35,000.000.00 35,000.00 35,000.00 0.00265.00265.002,216.954340 - PRINTING-43.54% 5.46%42,460.0075,200.00 -32,740.00 44,780.00 2,320.0041,798.3573,552.7739,007.064375 - CHARGE-FLEET MNT18.34% 3.00%1,000.00845.00 155.00 1,030.00 30.000.000.001,809.804403 - TRAVEL/TRAIN/CON3.00% 3.01%10,300.0010,000.00 300.00 10,610.00 310.0014.362,573.179,670.504434 - SPECIAL EVENTS3.00% 3.03%25,750.0025,000.00 750.00 26,530.00 780.0028,444.2331,455.5915,280.20Total Category: 4300 - CONTRACTUAL SERVICES: 153,400.0084,521.94 150,245.00 3,155.00 2.10% 159,070.00 5,670.00 3.70%107,846.53104,484.51Total Department: 08 - COMMUNITY & EMPLOYEE PROG: 165,400.0085,902.12 153,245.00 12,155.00 7.93% 170,070.00 4,670.00 2.82%115,287.75104,636.61 Budget Comparison Report7/20/2022 5:44:34 PMPage 8 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: 09 - CITY HALL BUILDINGSCategory: 4100 - PERSONAL SERVICES4100 - SALARY-FULL TIME0.00% 0.00%0.000.00 0.00 0.00 0.000.000.0014,426.174110 - OVERTIME F. T.0.00% 0.00%0.000.00 0.00 0.00 0.000.00277.111,587.144120 - SAL-P.T./TEMP0.00% 0.00%0.000.00 0.00 0.00 0.000.000.005,955.004141 - PERA0.00% 0.00%0.000.00 0.00 0.00 0.000.0020.771,060.244142 - FICA0.00% 0.00%0.000.00 0.00 0.00 0.000.0017.301,584.934144 - HEALTH INSURANCE0.00% 0.00%0.000.00 0.00 0.00 0.000.000.001,605.004148 - WORKERS COMP0.00% 0.00%0.000.00 0.00 0.00 0.000.000.00190.00Total Category: 4100 - PERSONAL SERVICES:0.000.00 0.00 0.00 0.00% 0.00 0.00 0.00%315.1826,408.48Category: 4200 - COMMODITIES4200 - OFFICE SUPPLIES0.00% 0.00%8,900.008,900.00 0.00 8,900.00 0.002,218.386,712.286,773.024210 - OP SUPPLY-OTHER-52.05% 5.71%3,500.007,300.00 -3,800.00 3,700.00 200.001,466.983,091.964,149.074211 - MOTOR FUELS0.00% 0.00%1,500.000.00 1,500.00 1,500.00 0.000.003,966.890.004217 - CLOTHING/UNIFORM0.00% 0.00%0.000.00 0.00 0.00 0.000.000.000.004231 - SMALL TOOLS0.00% 0.00%0.000.00 0.00 0.00 0.000.0089.95532.034270 - OP SUP-VEH/EQ0.00% 10.00%1,000.000.00 1,000.00 1,100.00 100.00669.381,332.28615.884272 - OP SUP-BUILDINGS44.00% 1.39%7,200.005,000.00 2,200.00 7,300.00 100.003,908.057,201.954,690.874280 - CAPITAL OUTLAY <$5,0000.00% 0.00%0.000.00 0.00 0.00 0.000.000.0011,804.00Total Category: 4200 - COMMODITIES:22,100.008,262.79 21,200.00 900.00 4.25% 22,500.00 400.00 1.81%22,395.3128,564.87Category: 4300 - CONTRACTUAL SERVICES4300 - PROF SERVICES-37.50% 10.00%500.00800.00 -300.00 550.00 50.000.00445.00731.194305 - FEES FOR SERVICE24.00% 0.00%31,000.0025,000.00 6,000.00 31,000.00 0.0013,205.0531,875.0953,641.354311 - POSTAGE-35.83% 8.33%12,000.0018,700.00 -6,700.00 13,000.00 1,000.0010,000.0010,435.9611,891.924321 - DATA PROCESSING68.67% 5.93%25,300.0015,000.00 10,300.00 26,800.00 1,500.008,750.0013,989.968,019.964340 - PRINTING-33.33% 10.00%1,000.001,500.00 -500.00 1,100.00 100.000.00831.002,561.004350 - INSURANCE CHARGE9.10% 3.09%45,300.0041,520.00 3,780.00 46,700.00 1,400.0024,220.0039,999.9651,500.044360 - UTILITIES16.67% 1.90%105,000.0090,000.00 15,000.00 107,000.00 2,000.0066,916.73104,730.0486,946.464370 - MAINT-REPAIR/EQ-56.31% 2.22%9,000.0020,600.00 -11,600.00 9,200.00 200.002,916.014,367.4013,782.524371 - MAINT-REPAIR/OTH0.00% 0.00%0.000.00 0.00 0.00 0.0040.780.000.004372 - MAINT-REPAIR/BLD31.39% 70.51%146,500.00111,500.00 35,000.00 249,800.00 103,300.00104,046.56119,833.3877,416.304375 - CHARGE-FLEET MNT0.00% 2.50%400.000.00 400.00 410.00 10.000.000.0068.514380 - RENTAL/LEASE5.26% 0.83%12,000.0011,400.00 600.00 12,100.00 100.005,298.8711,511.8010,607.734401 - DUES & SUBS0.00% 0.00%0.000.00 0.00 0.00 0.000.00120.000.004403 - TRAVEL/TRAIN/CON0.00% 0.00%0.000.00 0.00 0.00 0.000.000.00-225.004405 - CLEAN/WASTE REMV3.28% 2.70%63,000.0061,000.00 2,000.00 64,700.00 1,700.0033,982.3763,676.3158,978.98 Budget Comparison Report7/20/2022 5:44:34 PMPage 9 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 CONTRACT0.00% 0.00%0.000.00 0.00 0.00 0.000.000.0031.77Total Category: 4300 - CONTRACTUAL SERVICES: 451,000.00269,376.37 397,020.00 53,980.00 13.60% 562,360.00 111,360.00 24.69%401,815.90375,952.73Total Department: 09 - CITY HALL BUILDINGS: 473,100.00277,639.16 418,220.00 54,880.00 13.12% 584,860.00 111,760.00 23.62%424,526.39430,926.08