|
General Ledger
<br />Budget to Actual
<br />User: hannah.lynch F
<br />Printed: 022 1:55:48 PM
<br />Period 0
<br />1 - 03 03
<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 />69,071.25
<br />43,423.92
<br />43,455.46
<br />601-494-4102-000
<br />Overtime - Water
<br />7,000.00
<br />1,750.00
<br />2,147.24
<br />1,418.81
<br />601-494-4105-000
<br />On CallPager
<br />5,000.00
<br />1,250.00
<br />-344.35
<br />-201.22
<br />601-494-4106-000
<br />Temporaries - Water
<br />9,900.00
<br />2,475.00
<br />802.50
<br />894.37
<br />601-494-4121-000
<br />PERA
<br />21,621.00
<br />5,405.25
<br />4,000.06
<br />4,035.13
<br />601-494-4122-000
<br />FICA
<br />22,811.00
<br />5,702.75
<br />3,395.40
<br />3,296.08
<br />601-494-4123-000
<br />Def Comp Employer Contribution
<br />428.00
<br />107.00
<br />101.49
<br />0.00
<br />601-494-4131-000
<br />Health Insurance
<br />37,844.00
<br />9,461.00
<br />7,706.67
<br />5,909.04
<br />601-494-4133-000
<br />Life Insurance
<br />871.00
<br />217.75
<br />193.50
<br />206.77
<br />601-494-4134-000
<br />Dental Insurance
<br />2,076.00
<br />519.00
<br />530.33
<br />428.07
<br />601-494-4151-000
<br />Workers Compensation
<br />7,311.00
<br />1,827.75
<br />3,918.00
<br />3,436.00
<br />Personal Services
<br />391,147.00
<br />97,786.75
<br />65,874.76
<br />62,878.51
<br />Supplies
<br />601-494-4200-000
<br />Office Supplies -Water
<br />2,500.00
<br />625.00
<br />177.08
<br />0.00
<br />601-494-4211-000
<br />Maintenance Supplies -Water
<br />45,000.00
<br />11,250.00
<br />6,700.64
<br />1,499.26
<br />601-494-4212-000
<br />Vehicle Fuel
<br />10,000.00
<br />2,500.00
<br />0.00
<br />0.00
<br />601-494-4215-000
<br />Water Meters
<br />80,000.00
<br />20,000.00
<br />10,605.80
<br />11,163.65
<br />601-494-4216-000
<br />Irrigation Controllers
<br />20,000.00
<br />5,000.00
<br />19,798.90
<br />0.00
<br />601-494-4222-000
<br />Chemicals
<br />125,000.00
<br />31,250.00
<br />11,751.94
<br />10,980.96
<br />601-494-4240-000
<br />Small ToolsEquip-Water
<br />2,500.00
<br />625.00
<br />214.70
<br />273.29
<br />Supplies
<br />285,000.00
<br />71,250.00
<br />49,249.06
<br />23,917.16
<br />Services & Charges
<br />601-494-4300-000
<br />Professional Services -Water
<br />100,300.00
<br />25,075.00
<br />10,873.83
<br />13,532.89
<br />601-494-4304-000
<br />Municipal Engineer
<br />25,000.00
<br />6,250.00
<br />1,559.09
<br />3,971.00
<br />601-494-4310-000
<br />Other Consultant -Water
<br />24,375.00
<br />6,093.75
<br />7,309.81
<br />4,058.67
<br />601-494-4321-000
<br />Telephone -Water
<br />5,000.00
<br />1,250.00
<br />573.67
<br />882.47
<br />601-494-4322-000
<br />Postage -Water
<br />5,500.00
<br />1,375.00
<br />596.60
<br />1,379.64
<br />601-494-4330-000
<br />TravelTuition-Water
<br />3,000.00
<br />750.00
<br />0.00
<br />614.99
<br />601-494-4340-000
<br />Advertising -Water
<br />10,000.00
<br />2,500.00
<br />188.07
<br />0.00
<br />601-494-4345-000
<br />Payment Processing
<br />9,262.00
<br />2,315.50
<br />1,293.02
<br />0.00
<br />601-494-4360-000
<br />Insurance
<br />11,850.00
<br />2,962.50
<br />7,646.00
<br />6,289.00
<br />601-494-4363-000
<br />Auto Insurance
<br />960.00
<br />240.00
<br />629.00
<br />627.00
<br />601-494-4370-000
<br />Uniforms -Water
<br />760.00
<br />190.00
<br />334.95
<br />320.75
<br />601-494-4381-000
<br />Electricity -Water
<br />90,000.00
<br />22,500.00
<br />15,703.67
<br />11,404.43
<br />601-494-4382-000
<br />Utilities -Water
<br />15,000.00
<br />3,750.00
<br />1,265.73
<br />0.00
<br />601-494-4383-000
<br />Heat -Water
<br />5,000.00
<br />1,250.00
<br />967.76
<br />621.43
<br />Services & Charges
<br />306,007.00
<br />76,501.75
<br />48,941.20
<br />43,702.27
<br />Contractual Services
<br />601-494-4410-000
<br />Contracted Services -Water
<br />9,258.00
<br />2,314.50
<br />773.99
<br />1,765.90
<br />601-494-4452-000
<br />SubscriptionsDues-Water
<br />1,000.00
<br />250.00
<br />637.87
<br />500.00
<br />601-494-4510-000
<br />Purchased Assets Dep
<br />783,605.00
<br />195,901.25
<br />0.00
<br />0.00
<br />Contractual Services
<br />793,863.00
<br />198,465.75
<br />1,411.86
<br />2,265.90
<br />Capital Outlay
<br />601-494-5000-000
<br />Capital Outlay
<br />1,765,015.00
<br />441,253.75
<br />36,831.65
<br />8,088.41
<br />Capital Outlay
<br />1,765,015.00
<br />441,253.75
<br />36,831.65
<br />8,088.41
<br />Operating Transfers
<br />601-494-4910-000
<br />Operating Transfers
<br />407,680.00
<br />101,920.00
<br />0.00
<br />0.00
<br />Operating Transfers
<br />407,680.00
<br />101,920.00
<br />0.00
<br />0.00
<br />601
<br />Water Operating
<br />3,948,712.00
<br />987,178.00
<br />202,308.53
<br />140,852.25
<br />GL - Budget to Actual (05/16/2022 - 01:55 PM)
<br />20
<br />Page 1
<br />
|