Expense Report

As Of: 1/1/2026 to 5/31/2026

Description Budget MTD Expense YTD Expense UnExp. Balance Encumbrance Unenc. Balance % Used
WATER PRODUCTION Totals: $847,945.85 $42,548.60 $172,095.74 $675,850.11 $258,486.27 $417,363.84 50.78%
WATER DISTRIBUTION
602-231-50000 WATER DISTRIBUTION $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 N/A
602-231-51000 PERSONNEL SERVICES - W $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 N/A
602-231-51110 WAGES - FULLTIME $253,250.00 $15,521.66 $85,924.31 $167,325.69 $0.00 $167,325.69 33.93%
602-231-51120 WAGES - FULLTIME OT $30,000.00 $1,669.59 $8,125.13 $21,874.87 $0.00 $21,874.87 27.08%
602-231-51145 MEAL ALLOWANCE $300.00 $0.00 $60.00 $240.00 $0.00 $240.00 20.00%
602-231-51190 RESERVE FOR RETIREMEN $8,550.00 $0.00 $0.00 $8,550.00 $0.00 $8,550.00 0.00%
602-231-51210 OPERS $39,655.00 $2,153.82 $11,763.41 $27,891.59 $0.00 $27,891.59 29.66%
602-231-51220 WORKERS COMPENSATIO $4,200.00 $0.00 ($85.35) $4,285.35 $0.00 $4,285.35 -2.03%
602-231-51225 HSA EMPLOYER CONTRIBU $7,895.00 $0.00 $6,629.01 $1,265.99 $0.00 $1,265.99 83.96%
602-231-51230 GROUP LIFE INSURANCE $545.00 $24.57 $218.01 $326.99 $133.70 $193.29 64.53%
602-231-51233 VISION INSURANCE $400.00 $24.68 $123.40 $276.60 $24.65 $251.95 37.01%
602-231-51235 HEALTH INSURANCE $61,500.00 $4,639.82 $22,962.65 $38,537.35 $8,380.13 $30,157.22 50.96%
602-231-51239 DENTAL INSURANCE $1,870.00 $140.59 $692.02 $1,177.98 $141.73 $1,036.25 44.59%
602-231-51270 MEDICARE/FICA $4,231.00 $240.87 $1,313.39 $2,917.61 $0.00 $2,917.61 31.04%
602-231-52000 CONTRACT SERVICES - WA $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 N/A
602-231-52127 SERVICE & CURB BOX REP $10,280.26 $0.00 $214.00 $10,066.26 $2,316.26 $7,750.00 24.61%
602-231-52220 EQUIPMENT RENTAL $500.00 $0.00 $0.00 $500.00 $0.00 $500.00 0.00%
602-231-52350 CONSULTANTS $143,139.09 $5,377.55 $18,342.55 $124,796.54 $41,796.54 $83,000.00 42.01%
602-231-52423 WATER MAIN REPAIRS $32,000.00 $1,778.36 $6,084.37 $25,915.63 $11,915.63 $14,000.00 56.25%
602-231-52540 LEGAL ADVERTISING $600.00 $0.00 $0.00 $600.00 $0.00 $600.00 0.00%
602-231-52720 EQUIPMENT MAINT & REPA $1,500.00 $0.00 $0.00 $1,500.00 $500.00 $1,000.00 33.33%
602-231-52800 MULTI-PERIL INSURANCE $670.00 $647.27 $647.27 $22.73 $0.00 $22.73 96.61%
602-231-53000 MATERIALS AND SUPPLIES $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 N/A
602-231-53122 WATER METERS & PARTS $10,000.00 $12,360.77 $25,577.39 ($15,577.39) $139.23 ($15,716.62) 257.17%
602-231-53127 VALVES, SLEEVES, MAIN P $86,545.65 $2,017.10 $9,698.20 $76,847.45 $1,847.45 $75,000.00 13.34%
602-231-53388 GENERAL EQUIPMENT/TO $13,250.00 $578.94 $805.28 $12,444.72 $4,844.72 $7,600.00 42.64%
602-231-53420 UNIFORMS $2,500.00 $0.00 $75.00 $2,425.00 $75.00 $2,350.00 6.00%
602-231-56000 MISCELLANEOUS - WATER $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 N/A
602-231-56100 MISCELLANEOUS $2,500.00 $0.00 $0.00 $2,500.00 $0.00 $2,500.00 0.00%
602-231-56227 BACKFLOW DEVICE CERTI $200.00 $0.00 $0.00 $200.00 $0.00 $200.00 0.00%
602-231-56412 RESERVE FOR DAMAGES $2,000.00 $0.00 $0.00 $2,000.00 $0.00 $2,000.00 0.00%
602-231-59000 TRANSFERS - WATER DIST $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 N/A
602-231-59603 TRANSFER TO WATER EQU $500,000.00 $175,000.00 $350,000.00 $150,000.00 $0.00 $150,000.00 70.00%
602-231-59707 TRANSFER TO SERVICE CE $40,028.00 $0.00 $12,980.00 $27,048.00 $0.00 $27,048.00 32.43%
602-231-59717 TRANSFER TO MOTOR PO $18,720.00 $0.00 $13,814.00 $4,906.00 $0.00 $4,906.00 73.79%
WATER DISTRIBUTION Totals: $1,276,829.00 $222,175.59 $575,964.04 $700,864.96 $72,115.04 $628,749.92 50.76%
602 Total: $2,351,044.64 $286,717.02 $832,291.04 $1,518,753.60 $390,207.26 $1,128,546.34 52.00%
WATER IMPROV/EQUIP REPLACEMENT
603-603-50000 WATER IMPROVE/EQUIP R $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 N/A
603-603-54000 CAPITAL OUTLAY - WATER $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 N/A
603-603-54100 CAPITAL EQUIPMENT $15,000.00 $0.00 $0.00 $15,000.00 $0.00 $15,000.00 0.00%
603-603-54110 CAPITAL IMPROVEMENTS $1,079,896.80 $0.00 $5,079.98 $1,074,816.82 $737,816.82 $337,000.00 68.79%
6/15/2026 4:01 PM Page 30 of 36 V.6.301