|
General Ledger
<br />Budget to Actual
<br />User: hannah.lynch F
<br />Printed: 11/9/2022 1:53:11 PM
<br />Period 01 - 09
<br />Fiscal Year 2022 JIN('jlj Kr_�)
<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 />276,285.00
<br />207,213.75
<br />171,346.12
<br />154,309.89
<br />601-494-4102-000
<br />Overtime - Water
<br />7,000.00
<br />5,250.00
<br />5,105.72
<br />4,905.31
<br />601-494-4105-000
<br />On CallPager
<br />5,000.00
<br />3,750.00
<br />-344.35
<br />-201.22
<br />601-494-4106-000
<br />Temporaries - Water
<br />9,900.00
<br />7,425.00
<br />3,610.50
<br />5,988.62
<br />601-494-4108-000
<br />Wellness Program -Water
<br />0.00
<br />0.00
<br />26.77
<br />0.00
<br />601-494-4121-000
<br />PERA
<br />21,621.00
<br />16,215.75
<br />13,477.53
<br />12,610.76
<br />601-494-4122-000
<br />FICA
<br />22,811.00
<br />17,108.25
<br />13,141.54
<br />11,954.45
<br />601-494-4123-000
<br />Def Comp Employer Contribution
<br />428.00
<br />321.00
<br />101.49
<br />0.00
<br />601-494-4131-000
<br />Health Insurance
<br />37,844.00
<br />28,383.00
<br />18,272.33
<br />17,742.74
<br />601-494-4133-000
<br />Life Insurance
<br />871.00
<br />653.25
<br />445.62
<br />618.32
<br />601-494-4134-000
<br />Dental Insurance
<br />2,076.00
<br />1,557.00
<br />1,274.12
<br />1,284.21
<br />601-494-4151-000
<br />Workers Compensation
<br />7,311.00
<br />5,483.25
<br />7,404.00
<br />5,395.00
<br />Personal Services
<br />391,147.00
<br />293,360.25
<br />233,861.39
<br />214,608.08
<br />Supplies
<br />601-494-4200-000
<br />Office Supplies -Water
<br />2,500.00
<br />1,875.00
<br />1,234.84
<br />1,484.98
<br />601-494-4211-000
<br />Maintenance Supplies -Water
<br />45,000.00
<br />33,750.00
<br />38,769.55
<br />29,082.34
<br />601-494-4212-000
<br />Vehicle Fuel
<br />10,000.00
<br />7,500.00
<br />0.00
<br />0.00
<br />601-494-4215-000
<br />Water Meters
<br />80,000.00
<br />60,000.00
<br />76,912.99
<br />64,691.60
<br />601-494-4216-000
<br />Irrigation Controllers
<br />20,000.00
<br />15,000.00
<br />19,798.90
<br />18,999.00
<br />601-494-4222-000
<br />Chemicals
<br />125,000.00
<br />93,750.00
<br />110,767.54
<br />105,473.00
<br />601-494-4240-000
<br />Small ToolsEquip-Water
<br />2,500.00
<br />1,875.00
<br />3,435.12
<br />1,901.84
<br />Supplies
<br />285,000.00
<br />213,750.00
<br />250,918.94
<br />221,632.76
<br />Services & Charges
<br />601-494-4300-000
<br />Professional Services -Water
<br />100,300.00
<br />75,225.00
<br />94,657.09
<br />49,045.49
<br />601-494-4301-000
<br />Municipal Attorney
<br />0.00
<br />0.00
<br />4,137.00
<br />1,100.00
<br />601-494-4304-000
<br />Municipal Engineer
<br />25,000.00
<br />18,750.00
<br />14,170.82
<br />13,540.75
<br />601-494-4310-000
<br />Other Consultant -Water
<br />24,375.00
<br />18,281.25
<br />19,030.69
<br />9,415.30
<br />601-494-4321-000
<br />Telephone -Water
<br />5,000.00
<br />3,750.00
<br />2,564.39
<br />2,607.34
<br />601-494-4322-000
<br />Postage -Water
<br />5,500.00
<br />4,125.00
<br />2,934.53
<br />4,142.42
<br />601-494-4330-000
<br />TravelTuition-Water
<br />3,000.00
<br />2,250.00
<br />1,000.00
<br />1,614.99
<br />601-494-4340-000
<br />Advertising -Water
<br />10,000.00
<br />7,500.00
<br />3,238.07
<br />4,045.42
<br />601-494-4345-000
<br />Payment Processing
<br />9,262.00
<br />6,946.50
<br />6,967.61
<br />0.00
<br />601-494-4360-000
<br />Insurance
<br />11,850.00
<br />8,887.50
<br />16,303.00
<br />10,111.00
<br />601-494-4363-000
<br />Auto Insurance
<br />960.00
<br />720.00
<br />951.00
<br />941.00
<br />601-494-4370-000
<br />Uniforms -Water
<br />760.00
<br />570.00
<br />535.97
<br />510.75
<br />601-494-4381-000
<br />Electricity -Water
<br />90,000.00
<br />67,500.00
<br />76,501.90
<br />64,468.04
<br />601-494-4382-000
<br />Utilities -Water
<br />15,000.00
<br />11,250.00
<br />4,727.07
<br />3,377.57
<br />601-494-4383-000
<br />Heat -Water
<br />5,000.00
<br />3,750.00
<br />2,468.66
<br />1,530.57
<br />Services & Charges
<br />306,007.00
<br />229,505.25
<br />250,187.80
<br />166,450.64
<br />Contractual Services
<br />601-494-4410-000
<br />Contracted Services -Water
<br />9,258.00
<br />6,943.50
<br />6,368.87
<br />9,811.88
<br />601-494-4452-000
<br />SubscriptionsDues-Water
<br />1,000.00
<br />750.00
<br />637.87
<br />1,487.00
<br />601-494-4510-000
<br />Purchased Assets Dep
<br />783,605.00
<br />587,703.75
<br />0.00
<br />0.00
<br />Contractual Services
<br />793,863.00
<br />595,397.25
<br />7,006.74
<br />11,298.88
<br />Capital Outlay
<br />601-494-5000-000
<br />Capital Outlay
<br />1,765,015.00
<br />1,323,761.25
<br />1,049,840.91
<br />86,928.32
<br />Capital Outlay
<br />1,765,015.00
<br />1,323,761.25
<br />1,049,840.91
<br />86,928.32
<br />Operating Transfers
<br />601-494-4910-000
<br />Operating Transfers
<br />407,680.00
<br />305,760.00
<br />0.00
<br />0.00
<br />Operating Transfers
<br />407,680.00
<br />305,760.00
<br />0.00
<br />0.00
<br />GL - Budget to Actual (11/09/2022 - 01:53 PM)
<br />22
<br />Page 1
<br />
|