City Council Work Session

Budget Work Session Agenda Tuesday, January 27, 2026 at 6:00 PM Asbury City Hall, 5290 Grand Meadow Drive, Suite 1, Asbury, Iowa 52002 1. Meeting Opening A. Call to Order B. Roll Call C. Citizen Input This is the time for persons to provide comment during the meeting. a. To make a public comment please use the “Chat” function for those joining via Zoom or dial star 9 (*9) from your phone. The moderator will open the lines one at a time and announce your name or phone number. b. If attending the meeting in person, please state your name and address before making your comments. c. The Mayor may limit each speaker to three minutes. The public comment agenda item is not intended as a question and answer forum. If a person has a question(s) for the Mayor or City Council, the question(s) may be submitted prior to or after the meeting in writing, or email info@cityofasbury.com or call City Hall 563-556-7106. All questions will be answered during or after the meeting in a timely fashion. 2. Suspend with the Reading and approval of the last minutes 3. Employee Wage and Benefit Allocations 3 Wage Allocation Variance 2027.pdf Page 1 of 14  Wage allocations FY 2027.pdf 4 4. Utility Revenues. 5 Proposed Utility Rate Increase and Other Community Comparison.pdf 5. Water Utility 6-8 Water Budget 2027.pdf 6. Sewer Utility 9 - 10 Sewer Budget 2027.pdf 7. Refuse and Recycling Utility 11 Refuse Budget 2027.pdf 8. Stormwater Utility 12 Stormwater Budget 2027.pdf 9. Road Use Tax 13 - 14 RUT 2027.pdf RUT Narrative.pdf 10. Public Comment for New Items Not Previously Presented 11. Any Other Business 12. Adjournment Title Vi Statement - The City of Asbury receives federal funding and may not discriminate against anyone on the basis of race, color, or national origin, according to Title VI of the Civil Rights Act of 1964. For more information or to obtain a Title VI complaint form, call 563-556-7106. Page 2 of 14  FY 2027 Current HRLY 4.00% Proposed Wage Allocation NAME GROSS WAGES Yrs Longevity Est Hours Overtime hours Water (600) Culture (001-4XX) Public Works Snow (001-250) General (001-650) Road(110-210) Sewer (610) Solid Waste (670) Golf Course (005) Storm Water(740) $ 614,067.81 Total 1,054,610.27 271,707.99 76,196.20 52,259.99 100,529.62 151,479.90 92,120.57 238,401.77 24,276.22 19,872.67 27,765.34 1,054,610.27 FY 2026 Budget 1,012,094.19 206,404.25 79,282.74 55,876.47 82,934.11 148,789.69 117,160.16 245,314.26 28,952.79 20,162.21 27,217.50 1,012,094.18 Difference per budget (65,303.74) 3,086.54 3,616.48 (17,595.51) (2,690.21) 25,039.59 6,912.49 4,676.57 289.54 (547.84) (42,516.09) Page 3 of 14 1/23/2026 10:43 AM Employee Wage and Benefits Allocation: City employees in Public Works and City Administration perform duties that may be classified to several funds. As a result, employee wages are allocated as a percentage to the General Fund – Public Works, Culture and Recreation, General Government, Special Revenue - Road Use Tax and Business Type Activities – Water, Sewer, Solid Waste and Storm Water. Employee Wages and benefits are estimated to be allocated as follows: Special General Fund Revenue Business Type Public Works PW Parks General Golf RUT Water Sewer Refuse Storm PW Director 11% 6% 0% 1% 15% 38% 26% 0% 3% Water Manager 7% 1% 0% 0% 2% 86% 4% 0% 0% Sewer Manager 9% 2% 0% 0% 2% 4% 83% 0% 0% Certified Operator 30% 22% 0% 0% 5% 9% 34% 0% 0% Certified Operator 16% 3% 0% 0% 3% 67% 8% 0% 3% Driver/Operator 38% 13% 0% 0% 28% 8% 5% 1% 7% Driver/Operator 32% 30% 6% 8% 24% Administration City Admin 0% 0% 32% 3% 20% 15% 15% 5% 10% Dep City Clerk 0% 0% 67% 3% 0% 5% 5% 5% 10% Office Clerk 0% 0% 15% 6% 0% 35% 35% 5% 4% City Clerk 0% 17% 23% 5% 5% 20% 20% 9% 1% Adm Asst 0% 10% 25% 5% 10% 20% 20% 5% 5% Mayor and Council 100%. Police officers are allocated to the General Fund – Public Safety – Police Wages 100%. Meadows Golf Club Wages are allocated to the General Fund – Recreation 100%. When the city converted to the new financial system the Public Works crew began tracking actual hours in the department they are working in. As a result, the most significant variances occurred in the Water Fund and the Road Use Tax Fund. The Water Fund has significantly more hours whereas the Road Use Tax Fund is less. A summary of the variance by department is also attached to the agenda for your review. 9 Page 4 of 14  Utility Rate Comparison Based on 600 Cubic feet or 4,488.31 gallons Proposed Asbury PY FY27 Dubuque Asbury Variance Dubuque Variance Peosta Dyersville Water 42.28 1.61 45.66 (3.38) 35.89 44.96 Sewer 41.50 2.00 65.71 (24.21) 56.36 59.42 Refuse 17.00 0.75 19.74 (2.74) 16.97 20.49 Storm Water 9.00 1.00 12.13 (3.13) Avg Monthly Billing 109.78 5.36 143.24 (33.46) 109.22 124.87 Estimated Annual Utilities 1,317.36 64.32 1,718.88 (401.52) 1,310.64 1,498.44 FY 2027 FY 2026 FY 2026 FY2026 Property Tax FY 26 Rate per thousand 8.31321 9.9075 9.81583 10.26148 200,000 Roll Back 56.4919 FY 2024 Roll Back 46.3458 FY 2025 Roll Back 47.4316 FY 2026 Roll Back 44.5345 FY 2027 Based on $200,000 property after rollback 89,069.00 740.45 882.45 (142.00) 874.29 913.98 Total Utilities and Property Tax 2,057.81 2,601.33 2,184.93 2,412.42 Est. Annual Saving Asbury over other communities 543.52 127.12 354.61 based on 600 cu ft consumption 600 cu feet is equal to 4,488.31 US gallons Current Rate 104.50 Proposed Rate 110.00 Percent increase 5.26% Page 5 of 14  Budget Budget Budget Current Actual Actual Actual Account Title FY 2027 FY 2026 Variance YTD Actual FY 2025 FY 2024 FY 2023 Water REVENUE 600-810-4300 INTEREST (R) 120,000.00 100,000.00 20,000.00 59,181.27 130,288.10 124,512.47 89,650.99 600-810-4310 EAST WATER TOWER RENT (R) 3,000.00 3,000.00 - 8,000.00 3,000.00 3,000.00 3,000.00 Total Rent and Interest 123,000.00 103,000.00 20,000.00 67,181.27 133,288.10 127,512.47 92,650.99 600-810-4510 WATER SALES (R) 1,211,000.00 1,131,000.00 80,000.00 563,542.39 1,108,497.43 1,046,127.74 1,033,526.22 600-810-4511 COMM PROTECTION CHARGES (R) 11,000.00 9,500.00 1,500.00 5,819.50 11,064.63 9,551.17 9,455.57 600-810-4530 WATER PENALTY (R) 1,500.00 1,500.00 - 776.27 1,548.28 1,753.91 1,605.89 600-810-4550 WT SETUP & NON-COMP FEES (R) 1,000.00 - 1,000.00 2,530.93 992.41 - - 600-810-4551 WATER ACCT ESTABLISHMENT FEES (R) 6,000.00 6,000.00 - 4,150.00 6,095.00 8,100.00 6,750.00 600-810-4560 WATER SALES TAX (R) - 565.00 (565.00) - 17,690.64 538.47 530.92 600-810-4561 WATER EXCISE TAX (R) 62,000.00 62,000.00 - 33,914.42 49,742.78 62,492.22 61,840.70 Sub Total Water Sales 1,292,500.00 1,210,565.00 81,935.00 610,733.51 1,195,631.17 1,128,563.51 1,113,709.30 600-810-4705 MISC. CONTRIBUTION (R) - - - - - - - 600-810-4720 INSURANCE SETTLEMENTS (R) - - - - - - - 600-810-4750 WIRE SALES AND MISC SALES (R) 1,000.00 - 1,000.00 2,699.96 111.60 - - Sub Total Misc 1,000.00 - 1,000.00 2,699.96 111.60 - - 600-810-4830 TRANSFER FROM RESERVES (R) - - - - - - - TOTAL WATER REVENUE 1,416,500.00 1,313,565.00 102,935.00 680,614.74 1,329,030.87 1,256,075.98 1,206,360.29 Page 6 of 14  Budget Budget Budget Current Actual Actual Actual Account Title FY 2027 FY 2026 Variance YTD Actual FY 2025 FY 2024 FY 2023 WATER EXPENSES 600-810-6010 WAGES (E) 273,000.00 206,000.00 67,000.00 144,678.33 175,188.21 160,981.93 145,968.26 600-810-6011 WAGES-ADMIN (E) - - - - - - - 600-810-6110 FICA (E) 21,000.00 16,000.00 5,000.00 10,471.80 13,231.76 11,882.27 10,803.02 600-810-6130 IPERS (E) 26,000.00 19,700.00 6,300.00 13,657.63 16,538.23 15,179.20 13,779.59 600-810-6150 HEALTH INSURANCE (E) 62,000.00 42,000.00 20,000.00 26,918.09 32,125.10 29,813.36 25,113.12 600-810-6170 UNEMPLOYMENT (E) 1,200.00 1,200.00 - 172.30 336.02 550.43 919.62 600-810-6181 Clothing Allowance (E) 2,450.00 2,350.00 100.00 1,593.24 1,857.41 1,245.60 2,205.14 600-810-6210 DUES (E) 2,500.00 2,500.00 - 584.41 1,267.81 999.00 2,058.09 600-810-6230 TRAINING (E) 1,500.00 1,500.00 - 842.29 715.00 165.00 131.62 600-810-6231 SAFETY TRAINING (E) 1,500.00 1,500.00 - - - - 50.00 600-810-6240 MEETING & CONFERENCES (E) 2,500.00 2,000.00 500.00 1,199.88 - 475.00 330.00 600-810-6350 WATER MAIN REPAIRS (E) 25,000.00 25,000.00 - 3,372.05 7,680.29 13,889.04 9,267.55 600-810-6351 WATER EQUIP REPAIR (E) 30,000.00 30,000.00 - 11,856.06 67,266.35 20,995.51 - 600-810-6352 VEHICLE EXPENSE (E) 3,000.00 7,000.00 (4,000.00) 3,722.75 5,539.16 6,786.34 6,295.87 600-810-6373 PHONE EXPENSES (E) 1,000.00 2,500.00 (1,500.00) 316.55 588.18 812.61 1,985.12 600-810-6379 ELECTRICITY-N.WOOD CT (E) - - - - - - - 600-810-6380 ELECTRICITY-WEDGEWOOD (E) 23,500.00 22,200.00 1,300.00 10,781.65 19,207.40 18,423.95 19,242.00 600-810-6381 ELECTRICITY-COL.ESTATES (E) 28,000.00 26,500.00 1,500.00 11,786.44 17,634.39 18,401.48 19,034.19 600-810-6382 ELECTRICITY-WOODMOOR (E) 18,000.00 17,000.00 1,000.00 7,810.34 12,969.64 12,173.04 10,270.17 600-810-6383 ELECTRICITY-CLOIE WELL (E) 28,500.00 26,650.00 1,850.00 14,066.97 29,667.28 22,311.28 23,420.52 600-810-6388 ELECTRICITY-TOWER #2 (E) 3,800.00 3,600.00 200.00 1,666.38 3,094.45 2,281.85 2,600.39 600-810-6389 ELECTRICITY-TOWER (E) 10,800.00 10,200.00 600.00 5,062.78 9,191.05 8,085.28 7,976.88 600-810-6390 GAS-COLONIAL ESTATES WELL (E) 650.00 612.00 38.00 304.12 642.89 574.86 445.30 600-810-6401 ACCOUNTING AND AUDITING (E) 13,000.00 13,000.00 - 9,002.16 11,038.39 7,503.72 7,132.05 600-810-6404 COLLECTION EXPENSES (E) - - - - - - - 600-810-6407 ENGINEERING EXPENSES (E) 15,000.00 35,800.00 (20,800.00) 36,078.73 21,745.96 9,093.93 12,683.67 600-810-6408 INSURANCE EXPENSES (E) 33,100.00 31,175.00 1,925.00 31,295.58 27,364.59 23,523.79 21,852.86 600-810-6411 LEGAL EXPENSES (E) 1,000.00 1,000.00 - - - 214.50 594.00 600-810-6413 PERMITS (E) 1,000.00 600.00 400.00 646.11 768.54 768.91 - 600-810-6414 PRINTING & PUBLISHING EXPENSES (E) 1,000.00 1,000.00 - - 871.92 717.71 268.75 600-810-6418 SALES TAX (E) 62,000.00 63,000.00 (1,000.00) 39,320.85 67,451.42 63,223.48 62,757.88 600-810-6419 TECHNOLOGY GIS (E) 8,000.00 8,000.00 - 7,740.61 12,820.98 10,498.58 833.00 600-810-6420 SCADA (E) 7,000.00 5,000.00 2,000.00 6,824.00 1,396.50 4,419.02 - 600-810-6490 INFORMATION TECHNOLOGY (E) 20,000.00 10,000.00 10,000.00 9,918.86 8,984.00 7,901.88 5,160.82 600-810-6498 HOOKUP FEE REIMBUR. (E) - - - - - - - 600-810-6499 INSPECTIONS (E) 8,000.00 8,000.00 - 3,000.00 6,100.00 3,450.00 - 600-810-6501 CHEMICALS (E) 36,500.00 35,000.00 1,500.00 16,475.92 35,682.52 29,851.49 24,912.57 600-810-6505 EQUIPMENT (E) 40,000.00 40,000.00 - 10,248.72 3,027.22 83,254.48 55,187.48 600-810-6507 WATER TESTING (E) 6,000.00 6,000.00 - 1,811.61 2,868.09 6,959.76 8,793.37 600-810-6508 POSTAGE (E) 1,100.00 2,575.00 (1,475.00) 436.17 2,246.45 2,369.05 2,013.34 600-810-6509 LAB SUPPLIES (E) 2,000.00 1,500.00 500.00 954.95 1,598.28 1,121.67 - 600-810-6599 MISCELLANEOUS (E) 1,000.00 1,000.00 - 26.98 1,112.66 905.44 1,155.03 600-810-6710 VEHICLE (E) - 60,000.00 (60,000.00) - - - - 600-810-6725 CAPITAL OFFICE EQUIPMENT (E) - - - - 895.52 - 765.71 600-810-6726 SAFETY EQUIPMENT (E) 40,000.00 40,000.00 - - - - - 600-810-6727 WATER METERS (E) 190,000.00 185,000.00 5,000.00 190,369.35 72,612.17 82,051.80 77,968.96 600-810-6730 WATER MAIN WORK (E) - - - - - - - 600-810-6780 CAPITAL (E) 100,000.00 100,000.00 - 23,350.00 21,275.00 - - Water Operating Expenses 1,151,600.00 1,113,662.00 37,938.00 658,364.66 714,600.83 683,856.24 583,975.94 Page 7 of 14  Budget Budget Budget Current Actual Actual Actual Account Title FY 2027 FY 2026 Variance YTD Actual FY 2025 FY 2024 FY 2023 600-810-6801 PRINCIPAL (E) - - - - - - - 600-810-6803 PRINCIPAL- SRF (E) 120,000.00 118,000.00 2,000.00 - 115,000.00 113,000.00 112,000.00 600-810-6850 INTEREST (E) 6,405.00 8,470.00 (2,065.00) 4,235.00 10,482.50 12,460.00 14,420.00 600-810-6854 SERVICE FEE (E) 915.00 1,210.00 (295.00) 965.00 2,070.00 2,207.50 2,342.50 Total Water Debt Service 127,320.00 127,680.00 (360.00) 5,200.00 127,552.50 127,667.50 128,762.50 600-810-6910 TRANSFER OUT - SOLID WASTE (E) - - - - - - - 600-810-6912 TRANSFER OUT TO CAPITAL PROJ (E) - 105,000.00 (105,000.00) 111,497.23 264,910.48 - 321,087.00 600-810-6913 TRANSFER TO GENERAL FD (E) - - - - - - - 600-810-6914 TRANSFER OUT WATER RESERVE (E) 137,000.00 86,000.00 51,000.00 - 204,004.00 306,000.00 129,389.00 Total Transfer Out 137,000.00 191,000.00 (54,000.00) 111,497.23 468,914.48 306,000.00 450,476.00 Total Water Expenditures 1,415,920.00 1,432,342.00 (16,422.00) 775,061.89 1,311,067.81 1,117,523.74 1,163,214.44 Revenue over Expenditures 580.00 (118,777.00) 119,357.00 (94,447.15) 17,963.06 138,552.24 43,145.85 601-810-4301 WATER RESERVES INTEREST (R) - - - - - - - 601-810-4830 TRANSFER IN WATER OPERATING (R) - - - - - - - 601-810-4836 TRANSFER IN FROM WATER (R) 110,000.00 86,000.00 24,000.00 - 204,004.00 206,000.00 129,389.00 601-910-6910 TRANSFER TO WATER PROJ (E) 350,000.00 - 350,000.00 - - - 201,463.37 Page 8 of 14  Budget Budget Budget Current Actual Actual Actual Account Title FY 2027 FY 2026 Variance YTD Actual FY 2025 FY 2024 FY 2023 SEWER REVENUE 610-815-4300 INTEREST-SEWER UTIL-CKG ACCT (R) 100,000.00 100,000.00 - 48,435.87 116,111.81 123,786.74 90,788.35 610-815-4340 MISC (R) - - - - - - - 610-815-4510 SEWER FEES (R) 1,134,000.00 1,084,000.00 50,000.00 561,247.71 1,114,828.27 1,091,039.87 1,032,551.97 610-815-4530 SEWER PENALTY (R) 1,500.00 1,500.00 - 801.36 1,405.26 1,799.79 1,385.74 610-815-4550 SEWER HOOK UP FEES (R) 9,000.00 10,000.00 (1,000.00) 5,250.00 9,000.00 12,000.00 6,500.00 610-815-4560 SEWER SALES TAX (R) 1,200.00 1,200.00 - 757.23 1,159.31 1,492.18 1,372.08 Sewer Sales Revenue 1,145,700.00 1,096,700.00 49,000.00 568,056.30 1,126,392.84 1,106,331.84 1,041,809.79 610-815-4836 TRANSFER IN FROM SEWER REVENUE (R) - - - - - - - Page 9 of 14  Budget Budget Budget Current Actual Actual Actual Account Title FY 2027 FY 2026 Variance YTD Actual FY 2025 FY 2024 FY 2023 SEWER EXPENDITURES 610-815-6010 WAGES (E) 163,000.00 162,000.00 1,000.00 134,492.75 166,331.61 121,485.22 123,394.96 610-815-6011 WAGES - CLERK (E) 76,000.00 85,955.00 (9,955.00) - 58,160.31 72,067.03 65,484.16 610-815-6110 FICA (E) 19,000.00 19,000.00 - 9,855.63 16,642.91 14,122.17 13,954.23 610-815-6130 IPERS (E) 23,500.00 23,500.00 - 12,696.15 21,192.08 18,254.93 17,830.22 610-815-6150 HEALTH INS - CITY SHARE (E) 55,000.00 53,000.00 2,000.00 33,525.02 49,164.12 40,554.99 30,577.70 610-815-6170 UNEMPLOYMENT (E) 1,500.00 1,500.00 - 223.18 476.22 762.90 1,005.43 610-815-6181 CLOTHING ALLOWANCE (E) 2,450.00 2,350.00 100.00 1,926.82 1,225.73 1,020.93 1,044.91 610-815-6210 DUES & MEMBERSHIPS (E) 1,000.00 1,000.00 - - 1,150.55 784.00 980.52 610-815-6230 EDUCATION & TRAINING (E) 2,500.00 2,000.00 500.00 345.00 403.93 1,628.79 1,256.34 610-815-6231 SAFETY TRAINING (E) 1,000.00 1,000.00 - - - - - 610-815-6310 Collection System Repair and Maint 100,000.00 100,000.00 - 2,875.04 132,540.75 98,768.35 163,813.26 610-815-6315 PLANT MAINT & RPAIR (E) 40,000.00 40,000.00 - 28,954.67 65,710.44 34,161.06 - 610-815-6320 Lift Station Repair and Maint 50,000.00 50,000.00 - 166,211.06 99,135.26 66,465.88 - 610-815-6352 VEHICLE EXPENSE (E) 7,000.00 7,000.00 - 2,308.38 5,289.20 4,682.95 5,940.65 610-815-6371 UTILITIES - LAGOON-ELECTRIC (E) 122,000.00 116,000.00 6,000.00 53,144.69 98,460.60 94,279.74 94,593.45 610-815-6373 TELEPHONE LIFT STATION (E) 1,500.00 3,750.00 (2,250.00) 294.47 615.50 1,695.29 3,203.93 610-815-6379 TESTING & SUPPLIES (E) 12,000.00 12,000.00 - 5,165.00 8,901.00 10,788.72 9,493.87 610-815-6401 ACCOUNTING AND AUDITING (E) 14,000.00 14,000.00 - 9,002.17 11,038.39 7,503.72 7,132.05 610-815-6406 DAMGES & TORT CLAIMS (E) - - - - - - - 610-815-6407 CONSULTING FEE (E) 24,000.00 24,000.00 - 9,691.73 8,822.97 5,168.74 24,053.78 610-815-6408 INSURANCE (E) 46,730.00 44,085.00 2,645.00 42,582.09 38,284.01 32,594.70 31,717.50 610-815-6411 LEGAL SERVICES (E) - - - - - - - 610-815-6418 SALES TAX EXPENSE (E) 1,000.00 800.00 200.00 1,439.00 927.49 635.87 553.03 610-815-6419 GIS (E) 9,500.00 9,500.00 - 8,174.26 7,666.26 10,022.33 3,245.00 610-815-6420 SCADA (E) 7,000.00 7,000.00 - 8,804.19 2,810.27 3,124.13 - 610-815-6479 REF/SEW LIENS ON TAXROLL (E) - - - - - - - 610-815-6490 INFORMATION TECHNOLOGY (E) 12,000.00 8,000.00 4,000.00 6,326.23 4,588.36 2,849.36 2,065.03 610-815-6499 MOWING - SEWER (E) 8,000.00 8,000.00 - 6,500.00 10,510.00 8,520.07 - 610-815-6505 MISCELLANEOUS EXPENSE (E) 2,000.00 2,000.00 - - 1,965.39 1,012.59 1,610.61 610-815-6506 OFFICE SUPPLIES (E) 1,000.00 1,000.00 - 366.71 1,280.05 1,099.08 665.11 610-815-6508 POSTAGE (E) 1,200.00 2,500.00 (1,300.00) 709.04 2,150.06 2,082.67 1,984.84 610-815-6509 LAB SUPPLIES (E) 2,000.00 2,000.00 - 977.09 528.08 702.78 - 610-815-6725 OFFICE EQUIPMENT (E) - 10,000.00 (10,000.00) - 897.52 - - 610-815-6726 SAFETY EQUIPMENT (E) - - - - - - - 610-815-6730 LAND (E) - - - - - - - 610-815-6737 Equipment (E) 114,000.00 50,000.00 64,000.00 22,789.60 10,122.00 327,815.04 - 610-815-6750 BUILDING IMPROVEMENT (E) - 200,000.00 (200,000.00) - 11,677.30 - - 610-815-6767 CAPITAL OUTLAY-SANITARY SEWER (E) 86,000.00 8,000.00 78,000.00 - - - - Total Sewer Operating Expense 1,005,880.00 1,070,940.00 (65,060.00) 569,379.97 838,668.36 984,654.03 605,600.58 610-815-6801 PRINCIPAL (E) - - - - - - - 610-815-6851 INTEREST (E) - - - - - - - 610-815-6899 NOTE EXPENSES (E) - - - - - - - 610-910-6917 TRANSFER TO SEWER UTIL EQUIP (E) 135,000.00 115,860.00 19,140.00 - 362,500.00 - - 610-910-6918 TRANSFER TO SEWER PROJECT (E) - - - - 576,460.59 483,000.00 - 610-910-6919 TRANSFER TO CAPITAL EQUIP (E) - - - - - - - 610-910-6920 TRANSFER CAPITAL PROJ (E) - 100,000.00 (100,000.00) - - - - Total Transfer Out 135,000.00 215,860.00 (80,860.00) - 938,960.59 483,000.00 - Total Sewer Expenditures 1,140,880.00 1,286,800.00 (145,920.00) 569,379.97 1,777,628.95 1,467,654.03 605,600.58 Sewer Revenue over Expenditures 4,820.00 (190,100.00) 194,920.00 (1,323.67) (651,236.11) (361,322.19) 436,209.21 612-815-4301 SEWER UTILITY RESERVE FUND (R) - - - - 362,500.00 - - 612-910-6916 TRANSFER OUT FROM SEWER UT RES (E) - - - - 55,000.00 - 50,959.00 Page 10 of 14 612-950-4832 TRANSFER IN FROM SEWER UTILITY (R) - 115,860.00 (115,860.00) - - - -  Budget Budget Budget Current Actual Actual Actual Account Title FY 2027 FY 2026 Variance YTD Actual FY 2025 FY 2024 FY 2023 Refuse Revenue 670-840-4300 INT-SOLID WASTE-CHECKING ACCT (R) 1,500.00 6,000.00 (4,500.00) 1,532.48 4,703.34 6,518.24 6,654.39 670-840-4510 REFUSE FEES (R) 439,800.00 421,583.00 18,217.00 206,023.63 347,096.64 319,217.92 291,350.57 670-840-4530 SOLID WASTE PENALTY (R) 400.00 343.00 57.00 293.26 462.26 510.41 400.50 670-840-4550 MISC REVENUE (R) - - - - - - - 670-840-4560 SOLID WASTE SALES TAX (R) 40.00 40.00 - - 14.98 20.36 13.32 670-840-4750 MISC-YARDWASTE TAGS (R) 3,000.00 5,198.00 (2,198.00) 1,955.00 2,605.00 4,870.00 10,787.50 670-840-4751 RECYCLE BIN SALES (R) - - - - - - - 670-840-4752 PAY AS YOU THROW TAGS (R) 4,800.00 4,830.00 (30.00) 918.75 4,892.50 4,533.75 4,971.25 Refuse and Recycling Sales 448,040.00 431,994.00 16,046.00 209,190.64 355,071.38 329,152.44 307,523.14 670-840-4832 TRANSFER IN - - - - - - - Total Refuse and Recycling Revenue 449,540.00 437,994.00 11,546.00 210,723.12 359,774.72 335,670.68 314,177.53 REFUSE EXPENDITURES 670-290-6010 WAGES-YARD WASTE PICKUP (E) 2,000.00 2,360.00 (360.00) 344.43 1,734.34 1,653.58 2,093.36 670-290-6110 FICA (E) 155.00 - 155.00 25.91 31.06 - - 670-290-6130 IPERS (E) 200.00 - 200.00 32.53 163.73 156.17 197.71 670-290-6150 CITY SHARE - HEALTH INSURANCE (E) - - - (37.18) (28.44) - (32.64) 670-290-6170 UNEMPLOYMENT-S WASTE PICKUP (E) 25.00 25.00 - 1.47 4.95 7.49 21.89 670-290-6490 INFORMATION TECHNOLOGY (E) 1,500.00 - 1,500.00 - 1,371.06 - - 670-290-6599 SUPPLIES/MAINT. (E) - - - - - - - 670-840-6010 WAGES-CLERICAL (E) 24,000.00 30,100.00 (6,100.00) 14,862.63 24,557.83 20,926.84 21,985.67 670-840-6110 FICA (E) 2,000.00 2,400.00 (400.00) 1,074.71 1,996.53 1,650.18 1,750.18 670-840-6130 IPERS (E) 2,400.00 3,100.00 (700.00) 1,403.11 2,318.29 1,969.94 2,075.37 670-840-6150 HEALTH INS - CITY SHARE (E) 6,000.00 6,200.00 (200.00) 4,188.23 5,252.21 4,928.98 4,293.00 670-840-6170 UNEMPLOYMENT-CLERICAL (E) 300.00 300.00 - 25.14 54.14 85.98 190.52 670-840-6401 ACCOUNTING AND AUDITING (E) 7,000.00 7,000.00 - 3,967.56 5,388.59 3,725.02 3,519.15 670-840-6407 CONSULTANT FEES (E) 700.00 500.00 200.00 - 500.00 624.00 631.90 670-840-6408 INSURANCE (E) 3,000.00 2,000.00 1,000.00 2,394.66 1,968.84 1,837.72 1,700.26 670-840-6418 SALES TAX EXPENSE (E) 100.00 300.00 (200.00) 18.76 27.44 19.41 22.58 670-840-6490 INFORMATION TECHNOLOGY (E) 3,200.00 3,000.00 200.00 1,680.53 - - - 670-840-6499 CONTRACT - REFUSE (E) 388,000.00 371,518.00 16,482.00 181,776.18 354,607.18 342,300.18 338,227.85 670-840-6506 SUPPLIES-SOLID WASTE (E) 5,000.00 5,000.00 - - 871.92 4,786.74 5,893.83 670-840-6508 POSTAGE (E) 2,000.00 2,200.00 (200.00) 524.05 2,150.05 2,082.65 1,984.83 670-840-6599 MISCELLANEOUS EXPENSE (E) - - - - - - - 670-840-6725 OFFICE EQUIPMENT (E) 500.00 - 500.00 - - - - 670-840-6726 EQUIPMENT (E) - - - - - - - 670-841-6499 CONTRACT-RECYCLING (E) - - - - - - - 670-842-6499 CONTRACT-YARD WASTE (E) - - - - - - - Total Refuse Operations 448,080.00 436,003.00 12,077.00 212,282.72 402,969.72 386,754.88 384,555.46 670-910-6910 TRANSFER TO SOL. WASTE RES. (E) 700.00 700.00 - - 700.00 700.00 700.00 Total Refuse Expense 448,780.00 436,703.00 12,077.00 212,282.72 403,669.72 387,454.88 385,255.46 Total Revenue over Expense 760.00 1,291.00 (531.00) (1,559.60) (43,895.00) (51,784.20) (71,077.93) 671-840-4301 SOLID WASTE RESERVE FUND (R) - - - - - - - 671-910-6916 TRANSFER OUT FROM SOLID WASTE (E) - - - - - - - 671-950-4837 TRANSFER IN FROM OPERATING (R) 700.00 700.00 - - 700.00 700.00 700.00 Page 11 of 14  Budget Budget Budget Current Actual Actual Actual Account Title FY 2027 FY 2026 Variance YTD Actual FY 2025 FY 2024 FY 2023 STORM WATER REVENUE 740-865-4190 STORM WATER PERMITS (R) 4,000.00 5,000.00 (1,000.00) 2,170.00 4,020.00 4,090.00 2,850.00 740-865-4300 INTEREST (R) 5,900.00 5,900.00 - 3,872.94 8,095.62 8,520.36 4,212.38 740-865-4510 STORM WATER FEES (R) 274,780.00 226,180.00 48,600.00 114,397.44 226,784.63 222,252.48 194,496.83 740-865-4530 PENALTIES (R) 300.00 200.00 100.00 158.38 343.71 432.36 298.28 740-865-4560 STORM WATER SALES TAX (R) 300.00 200.00 100.00 339.58 289.10 376.90 290.72 Total Storm Sales Revenue 275,380.00 226,580.00 48,800.00 114,895.40 227,417.44 223,061.74 195,085.83 Total Storm Revenue 285,280.00 237,480.00 47,800.00 120,938.34 239,533.06 235,672.10 202,148.21 STORM WATER EXPENSES 740-865-6010 WAGES (E) 29,500.00 28,000.00 1,500.00 14,195.25 24,414.72 25,011.54 23,319.03 740-865-6110 FICA/MEDICARE (E) 2,300.00 2,150.00 150.00 1,048.38 1,858.73 1,833.17 1,695.92 740-865-6130 IPERS (E) 2,800.00 2,650.00 150.00 1,339.74 2,304.06 2,357.96 2,201.66 740-865-6150 CITY SHARE HEALTH INSURANCE (E) 6,700.00 6,700.00 - 2,987.89 3,909.79 2,659.64 4,246.19 740-865-6170 UNEMPLOYMENT (E) 100.00 100.00 - 27.44 64.40 100.25 104.72 740-865-6210 DUES (E) 2,500.00 3,000.00 (500.00) 2,195.00 2,130.00 2,025.00 1,945.00 740-865-6230 STORM WATER EDUCATION (E) 500.00 500.00 - - - - - 740-865-6401 ACCOUNTING AND AUDITING (E) 5,500.00 4,700.00 800.00 3,967.56 5,356.05 3,684.95 2,506.25 740-865-6407 CONSULTANT FEES (E) 3,300.00 3,300.00 - 11,655.00 1,350.00 - 2,013.25 740-865-6408 INSURANCE (E) - - - - - - - 740-865-6413 PERMIT FEES (E) 1,250.00 1,250.00 - 210.00 - 1,250.00 - 740-865-6417 STREET SWEEPING (E) 6,000.00 6,000.00 - 2,417.52 2,134.95 4,235.06 3,126.46 740-865-6418 SALES TAX (E) 600.00 300.00 300.00 532.56 471.90 361.19 270.91 740-865-6419 GIS SOFTWARE (E) 4,000.00 3,500.00 500.00 1,585.47 3,730.70 385.00 - 740-865-6490 INFORMATION TECHNOLOGY (E) 3,000.00 - 3,000.00 2,046.41 1,638.18 - - 740-865-6498 MOWING (E) 10,000.00 3,600.00 6,400.00 9,220.00 3,600.00 1,200.00 - 740-865-6499 CONTRACT (E) 43,747.00 43,747.00 - 38,605.00 40,120.00 37,135.00 35,762.00 740-865-6506 SUPPLIES (E) 700.00 700.00 - - 241.77 570.86 - 740-865-6508 POSTAGE (E) 2,200.00 2,000.00 200.00 611.91 2,150.08 2,082.67 1,984.83 740-865-6599 MISCELLANEOUS (E) 3,000.00 6,700.00 (3,700.00) 66.00 798.00 2,226.00 230.17 740-865-6765 STORM DRAINGE IMPROVEMENTS (E) 50,000.00 100,000.00 (50,000.00) 28,961.00 39,355.21 - 40,712.46 Total Storm Operating Expenses 177,697.00 218,897.00 (41,200.00) 121,672.13 135,628.54 87,118.29 120,118.85 740-910-6917 TRANSFER FROM SEWER (E) - - - - 73,792.73 112,305.70 38,983.30 740-910-6918 TRANSFER FROM SEWER RES (E) 100,000.00 109,000.00 (9,000.00) - - - - Total Storm Expenses 177,697.00 218,897.00 (41,200.00) 121,672.13 135,628.54 87,118.29 120,118.85 Storm Revenue over Expenses 7,583.00 18,583.00 89,000.00 (733.79) 103,904.52 148,553.81 82,029.36 Page 12 of 14  ROAD USE TAX Budget Budget Budget Current Actual Actual Actual Account Title FY 2027 FY 2026 Variance YTD Actual FY 2025 FY 2024 FY 2023 Revenue 110-210-4300 INTEREST (R) 40,000.00 19,000.00 21,000.00 26,790.14 46,682.72 30,816.78 14,288.90 110-210-4430 ROAD USE TAX (R) 834,900.00 834,900.00 - 495,822.15 844,020.58 839,464.16 817,823.73 Total Revenue 874,900.00 853,900.00 21,000.00 522,612.29 890,703.30 870,280.94 832,112.63 Expenditures 110-210-6010 WAGES (E) 95,000.00 116,000.00 (21,000.00) 34,652.32 72,423.71 77,136.75 63,737.63 110-210-6110 FICA (E) 7,500.00 8,921.00 (1,421.00) 2,569.78 5,369.05 5,671.81 4,708.27 110-210-6130 IPERS (E) 9,000.00 11,020.00 (2,020.00) 3,271.19 6,836.80 7,279.14 6,016.83 110-210-6150 HEALTH INS - CITY SHARE (E) 19,000.00 22,000.00 (3,000.00) 12,242.12 16,496.96 15,942.80 11,882.95 110-210-6170 UNEMPLOYMENT (E) 700.00 700.00 - 56.78 147.85 324.06 436.57 110-210-6230 EDUCATION & TRAINING (E) 300.00 300.00 - 30.00 - - 15.00 110-210-6321 TREE REMOVAL (E) 6,000.00 6,000.00 - - 685.00 - 2,675.00 110-210-6350 J.DEERE-MAINT/REPAIR (E) 500.00 500.00 - 6.29 - - 500.00 110-210-6351 EQUIPMENT (E) - - - - - - - 110-210-6352 TRUCKS-MAINT/REPAIR (E) 3,500.00 8,000.00 (4,500.00) 4,530.74 6,034.20 6,067.56 6,645.12 110-210-6353 FORD TRACTOR-MAINT/REPAIR (E) 4,500.00 1,000.00 3,500.00 - - - - 110-210-6354 MISC-MAINT/REPAIR (E) 1,000.00 900.00 100.00 590.46 806.42 - 399.10 110-210-6373 TELEPHONE (E) 3,000.00 4,500.00 (1,500.00) 1,540.27 2,392.83 2,322.45 4,007.23 110-210-6401 AUDIT (E) 6,000.00 6,000.00 - 4,532.46 5,388.58 3,725.02 4,532.05 110-210-6407 CONSULTING FEE (E) 10,000.00 20,500.00 (10,500.00) 4,815.88 7,697.82 12,304.26 13,919.48 110-210-6408 INSURANCE (E) 30,000.00 16,000.00 14,000.00 23,815.68 20,676.30 17,348.62 21,496.89 110-210-6417 STREET MAINTENANCE (E) 255,000.00 254,850.00 150.00 55,559.80 149,442.83 128,686.17 123,683.36 110-210-6419 GIS SOFTWARE (E) 8,500.00 8,500.00 - 5,745.79 3,711.75 4,481.41 770.00 110-210-6490 INFORMATION TECHNOLOGY (E) 6,500.00 6,500.00 - 3,756.95 4,075.74 - - 110-210-6499 MISC CONTRACT WORK (E) 20,000.00 20,000.00 - 8,300.00 10,685.00 21,018.80 - 110-210-6505 MISCELLANEOUS EXPENSE (E) 1,500.00 1,500.00 - 881.90 1,129.69 465.86 932.31 110-210-6507 STREET MAINT SUPPLIES (E) 1,500.00 1,500.00 - 954.80 196.16 1,175.83 380.73 110-910-6916 TRANSFER FROM ROAD FD EQUIPMEN (E) - 134,950.00 (134,950.00) - 300,819.00 - 9,869.00 110-910-6917 Transfer to Capital Road Impr (E) 450,000.00 200,000.00 250,000.00 400,000.00 129,000.00 100,000.00 420,000.00 Total Expenditures 939,000.00 850,141.00 88,859.00 567,853.21 744,015.69 403,950.54 696,607.52 Total Revenue over Expenditures (64,100.00) 3,759.00 (67,859.00) (45,240.92) 146,687.61 466,330.40 135,505.11 Page 13 of 14 Road Use Tax Fund: REVENUE: Road Use Tax Fund revenue is allocated on a per capita basis. A complete census count is important for the city to receive the maximum dollars allowed. The current population is 5,943 with the most recent census. Revenue is based on the IDOT forecast of $140.50 per capita annually to the City for a total of $834,900. There is no increase from the prior year. Road Use Tax Funds may only be used for street maintenance and improvements. EXPENDITURES: Wages and benefits decreased $27,440 due to reallocation of staffing hours. $450,000 will be transferred to fund the Street Overlay Project and no funds will be transferred to reserves. Net Expenditures and transfers over Revenue (64,100). 20 Page 14 of 14