|
General Ledger
<br />Budget to Actual
<br />User: hannah.lynch F
<br />Printed: 0/2022 9:16:52 AM
<br />Period 0
<br />1 - 06
<br />Fiscal Year 2022 IN ('jF K r
<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 />138,142.50
<br />116,520.91
<br />103,110.67
<br />601-494-4102-000
<br />Overtime - Water
<br />7,000.00
<br />3,500.00
<br />3,399.84
<br />3,541.81
<br />601-494-4105-000
<br />On CallPager
<br />5,000.00
<br />2,500.00
<br />-344.35
<br />-201.22
<br />601-494-4106-000
<br />Temporaries - Water
<br />9,900.00
<br />4,950.00
<br />1,342.50
<br />1,951.37
<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 />10,810.50
<br />9,265.97
<br />8,668.59
<br />601-494-4122-000
<br />FICA
<br />22,811.00
<br />11,405.50
<br />8,840.23
<br />7,839.21
<br />601-494-4123-000
<br />Def Comp Employer Contribution
<br />428.00
<br />214.00
<br />101.49
<br />0.00
<br />601-494-4131-000
<br />Health Insurance
<br />37,844.00
<br />18,922.00
<br />12,996.25
<br />11,818.08
<br />601-494-4133-000
<br />Life Insurance
<br />871.00
<br />435.50
<br />313.91
<br />412.38
<br />601-494-4134-000
<br />Dental Insurance
<br />2,076.00
<br />1,038.00
<br />784.25
<br />856.14
<br />601-494-4151-000
<br />Workers Compensation
<br />7,311.00
<br />3,655.50
<br />3,918.00
<br />3,436.00
<br />Personal Services
<br />391,147.00
<br />195,573.50
<br />157,165.77
<br />141,433.03
<br />Supplies
<br />601-494-4200-000
<br />Office Supplies -Water
<br />2,500.00
<br />1,250.00
<br />894.75
<br />335.16
<br />601-494-4211-000
<br />Maintenance Supplies -Water
<br />45,000.00
<br />22,500.00
<br />31,972.12
<br />11,624.02
<br />601-494-4212-000
<br />Vehicle Fuel
<br />10,000.00
<br />5,000.00
<br />0.00
<br />0.00
<br />601-494-4215-000
<br />Water Meters
<br />80,000.00
<br />40,000.00
<br />51,793.26
<br />52,453.22
<br />601-494-4216-000
<br />Irrigation Controllers
<br />20,000.00
<br />10,000.00
<br />19,798.90
<br />18,999.00
<br />601-494-4222-000
<br />Chemicals
<br />125,000.00
<br />62,500.00
<br />45,397.26
<br />23,674.86
<br />601-494-4240-000
<br />Small ToolsEquip-Water
<br />2,500.00
<br />1,250.00
<br />2,669.63
<br />920.33
<br />Supplies
<br />285,000.00
<br />142,500.00
<br />152,525.92
<br />108,006.59
<br />Services & Charges
<br />601-494-4300-000
<br />Professional Services -Water
<br />100,300.00
<br />50,150.00
<br />45,897.44
<br />36,253.90
<br />601-494-4301-000
<br />Municipal Attorney
<br />0.00
<br />0.00
<br />2,604.00
<br />0.00
<br />601-494-4304-000
<br />Municipal Engineer
<br />25,000.00
<br />12,500.00
<br />8,310.08
<br />9,243.00
<br />601-494-4310-000
<br />Other Consultant -Water
<br />24,375.00
<br />12,187.50
<br />12,654.37
<br />6,245.67
<br />601-494-4321-000
<br />Telephone -Water
<br />5,000.00
<br />2,500.00
<br />1,566.30
<br />1,851.02
<br />601-494-4322-000
<br />Postage -Water
<br />5,500.00
<br />2,750.00
<br />2,128.31
<br />2,420.48
<br />601-494-4330-000
<br />TravelTuition-Water
<br />3,000.00
<br />1,500.00
<br />1,000.00
<br />1,296.99
<br />601-494-4340-000
<br />Advertising -Water
<br />10,000.00
<br />5,000.00
<br />188.07
<br />0.00
<br />601-494-4345-000
<br />Payment Processing
<br />9,262.00
<br />4,631.00
<br />4,199.51
<br />0.00
<br />601-494-4360-000
<br />Insurance
<br />11,850.00
<br />5,925.00
<br />7,646.00
<br />6,289.00
<br />601-494-4363-000
<br />Auto Insurance
<br />960.00
<br />480.00
<br />629.00
<br />627.00
<br />601-494-4370-000
<br />Uniforms -Water
<br />760.00
<br />380.00
<br />387.45
<br />320.75
<br />601-494-4381-000
<br />Electricity -Water
<br />90,000.00
<br />45,000.00
<br />40,471.50
<br />27,182.17
<br />601-494-4382-000
<br />Utilities -Water
<br />15,000.00
<br />7,500.00
<br />2,946.53
<br />1,862.20
<br />601-494-4383-000
<br />Heat -Water
<br />5,000.00
<br />2,500.00
<br />2,214.91
<br />1,368.06
<br />Services & Charges
<br />306,007.00
<br />153,003.50
<br />132,843.47
<br />94,960.24
<br />Contractual Services
<br />601-494-4410-000
<br />Contracted Services -Water
<br />9,258.00
<br />4,629.00
<br />4,337.64
<br />5,403.82
<br />601-494-4452-000
<br />SubscriptionsDues-Water
<br />1,000.00
<br />500.00
<br />637.87
<br />823.00
<br />601-494-4510-000
<br />Purchased Assets Dep
<br />783,605.00
<br />391,802.50
<br />0.00
<br />0.00
<br />Contractual Services
<br />793,863.00
<br />396,931.50
<br />4,975.51
<br />6,226.82
<br />Capital Outlay
<br />601-494-5000-000
<br />Capital Outlay
<br />1,765,015.00
<br />882,507.50
<br />39,600.65
<br />67,272.76
<br />Capital Outlay
<br />1,765,015.00
<br />882,507.50
<br />39,600.65
<br />67,272.76
<br />Operating Transfers
<br />601-494-4910-000
<br />Operating Transfers
<br />407,680.00
<br />203,840.00
<br />0.00
<br />0.00
<br />Operating Transfers
<br />407,680.00
<br />203,840.00
<br />0.00
<br />0.00
<br />GL - Budget to Actual (08/10/2022 - 09:16 AM)
<br />22
<br />Page 1
<br />
|