|
General Ledger
<br />Budget to Actual
<br />User: hannah.lynch
<br />Printed: 8/9/2021 12:27:03 PM
<br />Period 01 - 06
<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 110,686.50 103,110.67 101,451.98
<br />601-494-4102-000 Overtime - Water 7,000.00 3,500.00 3,541.81 3,822.16
<br />601-494-4105-000 On CallPager 4,996.00 2,498.00 -201.22 -132.69
<br />601-494-4106-000 Temporaries - Water 9,240.00 4,620.00 1,951.37 1,022.25
<br />601-494-4121-000 PERA 17,503.00 8,751.50 8,668.59 7,892.55
<br />601-494-4122-000 FICA 18,560.00 9,280.00 7,839.21 7,595.64
<br />601-494-4123-000 Def Comp Employer Contribution 294.00 147.00 0.00 132.15
<br />601-494-4131-000 Health Insurance 25,528.00 12,764.00 11,818.08 13,196.68
<br />601-494-4133-000 Life Insurance 1,027.00 513.50 412.38 370.51
<br />601-494-4134-000 Dental Insurance 1,753.00 876.50 856.14 822.52
<br />601-494-4151-000 Workers Compensation 5,463.00 2,731.50 3,436.00 3,412.00
<br />Personal Services 312,737.00 156,368.50 141,433.03 139,585.75
<br />Supplies
<br />601-494-4200-000 Office Supplies-Water 2,500.00 1,250.00 335.16 2,645.59
<br />601-494-4211-000 Maintenance Supplies-Water 45,000.00 22,500.00 11,624.02 14,301.01
<br />601-494-4212-000 Vehicle Fuel 10,000.00 5,000.00 0.00 0.00
<br />601-494-4215-000 Water Meters 80,000.00 40,000.00 52,453.22 34,472.18
<br />601-494-4216-000 Irrigation Controllers 20,000.00 10,000.00 18,999.00 0.00
<br />601-494-4222-000 Chemicals 80,000.00 40,000.00 23,674.86 32,320.38
<br />601-494-4240-000 Small ToolsEquip-Water 2,500.00 1,250.00 920.33 765.32
<br />Supplies 240,000.00 120,000.00 108,006.59 84,504.48
<br />Services & Charges
<br />601-494-4300-000 Professional Services-Water 125,000.00 62,500.00 36,253.90 39,793.33
<br />601-494-4304-000 Municipal Engineer 25,000.00 12,500.00 9,243.00 22,506.00
<br />601-494-4310-000 Other Consultant-Water 11,347.00 5,673.50 6,245.67 5,922.67
<br />601-494-4321-000 Telephone-Water 5,000.00 2,500.00 1,851.02 1,836.57
<br />601-494-4322-000 Postage-Water 5,500.00 2,750.00 2,420.48 2,274.85
<br />601-494-4330-000 TravelTuition-Water 3,000.00 1,500.00 1,296.99 0.00
<br />601-494-4340-000 Advertising-Water 3,500.00 1,750.00 0.00 506.08
<br />601-494-4360-000 Insurance 10,374.00 5,187.00 6,289.00 5,370.00
<br />601-494-4363-000 Auto Insurance 700.00 350.00 627.00 469.00
<br />601-494-4370-000 Uniforms-Water 760.00 380.00 320.75 158.13
<br />601-494-4381-000 Electricity-Water 90,000.00 45,000.00 27,182.17 26,480.08
<br />601-494-4382-000 Utilities 15,000.00 7,500.00 1,862.20 1,519.60
<br />601-494-4383-000 Heat-Water 5,000.00 2,500.00 1,368.06 1,824.47
<br />Services & Charges 300,181.00 150,090.50 94,960.24 108,660.78
<br />Contractual Services
<br />601-494-4410-000 Contracted Services-Water 10,000.00 5,000.00 5,403.82 5,374.73
<br />601-494-4410-129 Contr Services-Phesant Hills 0.00 0.00 0.00 -10,444.13
<br />601-494-4452-000 SubscriptionsDues-Water 1,000.00 500.00 823.00 580.00
<br />601-494-4510-000 Purchased Assets Dep 605,000.00 302,500.00 0.00 0.00
<br />Contractual Services 616,000.00 308,000.00 6,226.82 -4,489.40
<br />Capital Outlay
<br />601-494-5000-000 Capital Outlay 55,000.00 27,500.00 67,272.76 135,966.14
<br />Capital Outlay 55,000.00 27,500.00 67,272.76 135,966.14
<br />601 Water Operating 1,523,918.00 761,959.00 417,899.44 464,227.75
<br />602 Sewer Operating
<br />Personal Services
<br />602-495-4101-000 Salaries - Sewer 221,373.00 110,686.50 103,110.38 101,450.99
<br />GL - Budget to Actual (08/09/2021 - 12:27 PM)Page 116
|