|
General Ledger
<br />Budget to Actual
<br />User: tracy.thoma
<br />Printed: 7/23/2024 10:57:38 AM
<br />Period 01 - 06
<br />Fiscal Year 2024
<br />- --S.
<br />_ � F
<br />C I I '(JA _ �,t Y` O F
<br />��l�1
<br />11-NO11, KE
<br />Account Number
<br />Description
<br />Budget
<br />YTD Budget
<br />End Bal
<br />One Year Prior
<br />Actual
<br />601
<br />Water Operating
<br />Personal Services
<br />601-494-4101-000
<br />Salaries - Water
<br />298,975.00
<br />149,487.50
<br />121,923.76
<br />113,757.77
<br />601-494-4102-000
<br />Overtime - Water
<br />7,000.00
<br />3,500.00
<br />1,869.90
<br />3,805.98
<br />601-494-4105-000
<br />On CallStandby
<br />6,000.00
<br />3,000.00
<br />0.00
<br />0.00
<br />601-494-4106-000
<br />Temporaries - Water
<br />9,880.00
<br />4,940.00
<br />3,087.00
<br />2,799.00
<br />601-494-4108-000
<br />Wellness Program -Water
<br />72.00
<br />36.00
<br />0.00
<br />0.00
<br />601-494-4121-000
<br />PERA
<br />23,398.00
<br />11,699.00
<br />10,025.88
<br />9,551.14
<br />601-494-4122-000
<br />FICA Water
<br />24,622.00
<br />12,311.00
<br />9,350.20
<br />8,856.25
<br />601-494-4123-000
<br />Def Comp Employer Contribution
<br />0.00
<br />0.00
<br />100.40
<br />0.00
<br />601-494-4131-000
<br />Health Insurance
<br />31,506.00
<br />15,753.00
<br />13,561.56
<br />12,294.59
<br />601-494-4133-000
<br />Life Insurance
<br />941.00
<br />470.50
<br />329.59
<br />319.79
<br />601-494-4134-000
<br />Dental Insurance
<br />2,481.00
<br />1,240.50
<br />1,205.82
<br />1,001.66
<br />601-494-4141-000
<br />Reemployment Insurance
<br />0.00
<br />0.00
<br />4,685.73
<br />0.00
<br />601-494-4151-000
<br />Workers Compensation
<br />10,503.00
<br />5,251.50
<br />6,708.00
<br />6,972.00
<br />Personal Services
<br />415,378.00
<br />207,689.00
<br />172,847.84
<br />159,358.18
<br />Supplies
<br />601-494-4200-000
<br />Office Supplies -Water
<br />2,500.00
<br />1,250.00
<br />2,904.38
<br />2,314.56
<br />601-494-4211-000
<br />Maintenance Supplies -Water
<br />45,000.00
<br />22,500.00
<br />8,622.73
<br />5,367.65
<br />601-494-4212-000
<br />Vehicle Fuel
<br />12,000.00
<br />6,000.00
<br />0.00
<br />0.00
<br />601-494-4215-000
<br />Water Meters
<br />150,000.00
<br />75,000.00
<br />144,866.63
<br />45,127.34
<br />601-494-4216-000
<br />Irrigation Controllers
<br />20,000.00
<br />10,000.00
<br />0.00
<br />29,878.17
<br />601-494-4222-000
<br />Chemicals
<br />155,000.00
<br />77,500.00
<br />34,257.70
<br />48,998.03
<br />601-494-4240-000
<br />Small ToolsEquip-Water
<br />2,500.00
<br />1,250.00
<br />522.53
<br />401.46
<br />Supplies
<br />387,000.00
<br />193,500.00
<br />191,173.97
<br />132,087.21
<br />Services & Charges
<br />601-494-4300-000
<br />Professional Services -Water
<br />103,300.00
<br />51,650.00
<br />26,784.65
<br />39,249.78
<br />601-494-4301-000
<br />Municipal Attorney
<br />5,000.00
<br />2,500.00
<br />17,909.50
<br />4,402.80
<br />601-494-4304-000
<br />Municipal Engineer
<br />25,000.00
<br />12,500.00
<br />5,716.33
<br />16,324.50
<br />601-494-4308-000
<br />Auditor
<br />7,000.00
<br />3,500.00
<br />7,361.34
<br />1,500.00
<br />601-494-4310-000
<br />Other Consultant -Water
<br />19,286.00
<br />9,643.00
<br />10,157.49
<br />8,753.51
<br />601-494-4321-000
<br />Telephone -Water
<br />5,000.00
<br />2,500.00
<br />2,646.45
<br />1,636.60
<br />601-494-4322-000
<br />Postage -Water
<br />6,000.00
<br />3,000.00
<br />3,686.43
<br />2,614.75
<br />601-494-4330-000
<br />TravelTuition-Water
<br />4,500.00
<br />2,250.00
<br />2,365.86
<br />1,847.50
<br />601-494-4340-000
<br />Advertising -Water
<br />5,000.00
<br />2,500.00
<br />1,671.00
<br />2,260.12
<br />601-494-4345-000
<br />Payment Processing
<br />13,000.00
<br />6,500.00
<br />5,445.35
<br />4,869.03
<br />601-494-4360-000
<br />Insurance
<br />27,078.00
<br />13,539.00
<br />17,584.00
<br />17,316.00
<br />601-494-4363-000
<br />Auto Insurance
<br />953.00
<br />476.50
<br />619.00
<br />645.00
<br />601-494-4370-000
<br />Uniforms -Water
<br />1,140.00
<br />570.00
<br />350.44
<br />307.06
<br />601-494-4381-000
<br />Electricity -Water
<br />120,000.00
<br />60,000.00
<br />34,208.79
<br />38,515.48
<br />601-494-4382-000
<br />Utilities -Water
<br />9,000.00
<br />4,500.00
<br />4,911.20
<br />2,988.54
<br />601-494-4383-000
<br />Heat -Water
<br />5,000.00
<br />2,500.00
<br />2,053.35
<br />2,031.62
<br />Services & Charges
<br />356,257.00
<br />178,128.50
<br />143,471.18
<br />145,262.29
<br />Contractual Services
<br />601-494-4410-000
<br />Contracted Services -Water
<br />11,995.00
<br />5,997.50
<br />6,878.41
<br />3,896.15
<br />601-494-4415-000
<br />Rental Equipment
<br />0.00
<br />0.00
<br />113.95
<br />0.00
<br />601-494-4452-000
<br />SubscriptionsDues-Water
<br />1,000.00
<br />500.00
<br />1,168.00
<br />698.12
<br />Contractual Services
<br />12,995.00
<br />6,497.50
<br />8,160.36
<br />4,594.27
<br />Capital Outlay
<br />601-494-5000-000
<br />Capital Outlay
<br />157,500.00
<br />78,750.00
<br />32,608.28
<br />9,867.50
<br />Capital Outlay
<br />157,500.00
<br />78,750.00
<br />32,608.28
<br />9,867.50
<br />Operating Transfers
<br />601-494-4910-000
<br />Operating Transfers
<br />731,760.00
<br />365,880.00
<br />0.00
<br />0.00
<br />GL - Budget to Actual (07/23/2024 - 10:57 AM) 21 Page 1
<br />
|