|
General Ledger
<br />Budget to Actual
<br />User: hannah.lynch
<br />Printed: 4/28/2021 3:55:27 PM
<br />Period 01 - 03
<br />Fiscal Year 2021
<br />Account Number Description Budget YTD Budget End Bal One Year Prior
<br />Actual
<br />601 Water Operating
<br />Personal Services
<br />601-494-4101-000 Salaries - Water 221,373.00 55,343.25 43,455.46 44,831.94
<br />601-494-4102-000 Overtime - Water 7,000.00 1,750.00 1,418.81 1,861.56
<br />601-494-4105-000 On CallPager 4,996.00 1,249.00 -201.22 -132.69
<br />601-494-4106-000 Temporaries - Water 9,240.00 2,310.00 894.37 0.00
<br />601-494-4121-000 PERA 17,503.00 4,375.75 4,035.13 3,971.50
<br />601-494-4122-000 FICA 18,560.00 4,640.00 3,296.08 3,280.20
<br />601-494-4123-000 Def Comp Employer Contribution 294.00 73.50 0.00 132.15
<br />601-494-4131-000 Health Insurance 25,528.00 6,382.00 5,909.04 9,068.23
<br />601-494-4133-000 Life Insurance 1,027.00 256.75 206.77 195.10
<br />601-494-4134-000 Dental Insurance 1,753.00 438.25 428.07 439.92
<br />601-494-4151-000 Workers Compensation 5,463.00 1,365.75 3,436.00 3,412.00
<br />Personal Services 312,737.00 78,184.25 62,878.51 67,059.91
<br />Supplies
<br />601-494-4200-000 Office Supplies-Water 2,500.00 625.00 0.00 1,566.21
<br />601-494-4211-000 Maintenance Supplies-Water 45,000.00 11,250.00 1,499.26 5,757.78
<br />601-494-4212-000 Vehicle Fuel 10,000.00 2,500.00 0.00 0.00
<br />601-494-4215-000 Water Meters 80,000.00 20,000.00 11,163.65 32,122.18
<br />601-494-4216-000 Irrigation Controllers 20,000.00 5,000.00 0.00 0.00
<br />601-494-4222-000 Chemicals 80,000.00 20,000.00 10,980.96 10,164.16
<br />601-494-4240-000 Small ToolsEquip-Water 2,500.00 625.00 273.29 57.80
<br />Supplies 240,000.00 60,000.00 23,917.16 49,668.13
<br />Services & Charges
<br />601-494-4300-000 Professional Services-Water 125,000.00 31,250.00 13,532.89 18,613.76
<br />601-494-4304-000 Municipal Engineer 25,000.00 6,250.00 3,971.00 4,930.25
<br />601-494-4310-000 Other Consultant-Water 11,347.00 2,836.75 4,058.67 3,852.67
<br />601-494-4321-000 Telephone-Water 5,000.00 1,250.00 882.47 914.43
<br />601-494-4322-000 Postage-Water 5,500.00 1,375.00 1,379.64 899.17
<br />601-494-4330-000 TravelTuition-Water 3,000.00 750.00 614.99 0.00
<br />601-494-4340-000 Advertising-Water 3,500.00 875.00 0.00 506.08
<br />601-494-4360-000 Insurance 10,374.00 2,593.50 6,289.00 5,370.00
<br />601-494-4363-000 Auto Insurance 700.00 175.00 627.00 469.00
<br />601-494-4370-000 Uniforms-Water 760.00 190.00 320.75 158.13
<br />601-494-4381-000 Electricity-Water 90,000.00 22,500.00 11,404.43 11,343.56
<br />601-494-4382-000 Utilities 15,000.00 3,750.00 0.00 404.10
<br />601-494-4383-000 Heat-Water 5,000.00 1,250.00 621.43 904.94
<br />Services & Charges 300,181.00 75,045.25 43,702.27 48,366.09
<br />Contractual Services
<br />601-494-4410-000 Contracted Services-Water 10,000.00 2,500.00 1,765.90 2,419.35
<br />601-494-4410-129 Contr Services-Phesant Hills 0.00 0.00 -5,760.65 -10,444.13
<br />601-494-4452-000 SubscriptionsDues-Water 1,000.00 250.00 500.00 557.00
<br />601-494-4510-000 Purchased Assets Dep 605,000.00 151,250.00 0.00 0.00
<br />Contractual Services 616,000.00 154,000.00 -3,494.75 -7,467.78
<br />Capital Outlay
<br />601-494-5000-000 Capital Outlay 55,000.00 13,750.00 8,088.41 24,533.29
<br />Capital Outlay 55,000.00
<br />
<br />13,750.00
<br />
<br />8,088.41
<br />
<br />24,533.29
<br />
<br />601 Water Operating 1,523,918.00 380,979.50 135,091.60 182,159.64
<br />602 Sewer Operating
<br />Personal Services
<br />602-495-4101-000 Salaries - Sewer 221,373.00 55,343.25 43,454.92 44,831.34
<br />GL - Budget to Actual (04/28/2021 - 03:55 PM)Page 116
|