|
Account Number
<br />Description
<br />Budget
<br />YTD Budget
<br />End Bal
<br />One Year Prior
<br />Actual
<br />601
<br />Water Operating
<br />3,948,712.00
<br />1,974,356.00
<br />487,111.32
<br />417,899.44
<br />602
<br />Sewer Operating
<br />Personal Services
<br />602-495-4101-000
<br />Salaries - Sewer
<br />276,285.00
<br />138,142.50
<br />116,521.28
<br />103,110.38
<br />602-495-4102-000
<br />Overtime - Sewer
<br />7,000.00
<br />3,500.00
<br />3,399.76
<br />3,541.69
<br />602-495-4105-000
<br />On CallPager
<br />5,000.00
<br />2,500.00
<br />-344.35
<br />-201.22
<br />602-495-4106-000
<br />Temporaries - Sewer
<br />9,900.00
<br />4,950.00
<br />1,342.50
<br />1,951.37
<br />602-495-4108-000
<br />Wellness Program -Sewer
<br />0.00
<br />0.00
<br />26.77
<br />0.00
<br />602-495-4121-000
<br />PERA
<br />21,621.00
<br />10,810.50
<br />9,265.99
<br />8,668.54
<br />602-495-4122-000
<br />FICA
<br />22,811.00
<br />11,405.50
<br />8,840.24
<br />7,839.52
<br />602-495-4123-000
<br />Def Comp Employer Contribution
<br />428.00
<br />214.00
<br />101.49
<br />0.00
<br />602-495-4131-000
<br />Health Insurance
<br />37,844.00
<br />18,922.00
<br />12,996.05
<br />11,818.44
<br />602-495-4133-000
<br />Life Insurance
<br />871.00
<br />435.50
<br />313.43
<br />412.70
<br />602-495-4134-000
<br />Dental Insurance
<br />2,076.00
<br />1,038.00
<br />784.25
<br />856.14
<br />602-495-4151-000
<br />Workers Compensation
<br />16,536.00
<br />8,268.00
<br />8,846.00
<br />7,757.00
<br />Personal Services
<br />400,372.00
<br />200,186.00
<br />162,093.41
<br />145,754.56
<br />Supplies
<br />602-495-4200-000
<br />Office Supplies -Sewer
<br />2,500.00
<br />1,250.00
<br />894.76
<br />335.16
<br />602-495-4211-000
<br />Maintenance Supplies -Sewer
<br />45,000.00
<br />22,500.00
<br />16,492.06
<br />499.78
<br />602-495-4212-000
<br />Vehicle Fuel
<br />10,000.00
<br />5,000.00
<br />0.00
<br />0.00
<br />602-495-4240-000
<br />Small ToolsEquip-Sewer
<br />2,500.00
<br />1,250.00
<br />2,456.37
<br />784.18
<br />Supplies
<br />60,000.00
<br />30,000.00
<br />19,843.19
<br />1,619.12
<br />Services & Charges
<br />602-495-4300-000
<br />Professional Services -Sewer
<br />165,300.00
<br />82,650.00
<br />28,585.11
<br />39,525.78
<br />602-495-4304-000
<br />Municipal Engineer
<br />25,000.00
<br />12,500.00
<br />5,249.82
<br />10,439.75
<br />602-495-4304-146
<br />Municipal Engineer
<br />0.00
<br />0.00
<br />27,914.00
<br />0.00
<br />602-495-4310-000
<br />Other Consultant -Sewer
<br />24,375.00
<br />12,187.50
<br />12,654.37
<br />6,245.67
<br />602-495-4321-000
<br />Telephone -Sewer
<br />1,500.00
<br />750.00
<br />607.55
<br />512.06
<br />602-495-4322-000
<br />Postage -Sewer
<br />5,000.00
<br />2,500.00
<br />2,128.30
<br />2,157.92
<br />602-495-4330-000
<br />TravelTuition-Sewer
<br />3,000.00
<br />1,500.00
<br />1,000.00
<br />682.00
<br />602-495-4340-000
<br />Advertising -Sewer
<br />500.00
<br />250.00
<br />0.00
<br />0.00
<br />602-495-4340-146
<br />Advertising
<br />0.00
<br />0.00
<br />478.93
<br />0.00
<br />602-495-4345-000
<br />Payment Processing
<br />9,262.00
<br />4,631.00
<br />4,199.54
<br />0.00
<br />602-495-4360-000
<br />Insurance
<br />17,540.00
<br />8,770.00
<br />11,314.00
<br />11,971.00
<br />602-495-4363-000
<br />Auto Insurance
<br />960.00
<br />480.00
<br />629.00
<br />627.00
<br />602-495-4370-000
<br />Uniforms -Sewer
<br />760.00
<br />380.00
<br />387.45
<br />320.72
<br />602-495-4381-000
<br />Electricity -Sewer
<br />32,000.00
<br />16,000.00
<br />15,353.30
<br />13,598.15
<br />602-495-4382-000
<br />Utilities -Sewer
<br />15,000.00
<br />7,500.00
<br />5,389.68
<br />3,675.36
<br />602-495-4383-000
<br />Heat -Sewer
<br />1,800.00
<br />900.00
<br />739.31
<br />598.94
<br />Services & Charges
<br />301,997.00
<br />150,998.50
<br />116,630.36
<br />90,354.35
<br />Contractual Services
<br />602-495-4405-000
<br />MCES Sewer Charges
<br />1,087,743.00
<br />543,871.50
<br />634,514.37
<br />576,618.14
<br />602-495-4410-000
<br />Contracted Services -Sewer
<br />5,758.00
<br />2,879.00
<br />2,332.53
<br />4,684.49
<br />602-495-4452-000
<br />SubscriptionsDues-Sewer
<br />1,000.00
<br />500.00
<br />243.09
<br />79.37
<br />602-495-4510-000
<br />Purchased Assets Dep
<br />574,323.00
<br />287,161.50
<br />0.00
<br />0.00
<br />Contractual Services
<br />1,668,824.00
<br />834,412.00
<br />637,089.99
<br />581,382.00
<br />Capital Outlay
<br />602-495-5000-000
<br />Capital Outlay
<br />115,015.00
<br />57,507.50
<br />33,168.90
<br />47,430.12
<br />Capital Outlay
<br />115,015.00
<br />57,507.50
<br />33,168.90
<br />47,430.12
<br />602
<br />Sewer Operating
<br />2,546,208.00
<br />1,273,104.00
<br />968,825.85
<br />866,540.15
<br />603
<br />Storm Water Operating
<br />Personal Services
<br />603-496-4101-000
<br />Salaries - Storm
<br />136,793.00
<br />68,396.50
<br />34,616.37
<br />0.00
<br />603-496-4102-000
<br />Overtime - Storm
<br />0.00
<br />0.00
<br />1,259.91
<br />0.00
<br />603-496-4121-000
<br />PERA
<br />10,259.00
<br />5,129.50
<br />2,690.88
<br />0.00
<br />603-496-4122-000
<br />FICA
<br />10,465.00
<br />5,232.50
<br />2,685.50
<br />0.00
<br />603-496-4123-000
<br />Def Comp Employer Contribution
<br />285.00
<br />142.50
<br />101.49
<br />0.00
<br />603-496-4131-000
<br />Health Insurance
<br />20,516.00
<br />10,258.00
<br />1,183.56
<br />0.00
<br />603-496-4133-000
<br />Life Insurance
<br />417.00
<br />208.50
<br />91.79
<br />0.00
<br />603-496-4134-000
<br />Dental Insurance
<br />944.00
<br />472.00
<br />80.94
<br />0.00
<br />603-496-4151-000
<br />Workers Compensation
<br />8,364.00
<br />4,182.00
<br />0.00
<br />0.00
<br />Personal Services
<br />188,043.00
<br />94,021.50
<br />42,710.44
<br />0.00
<br />GL - Budget to Actual (08/10/2022 - 09:16 AM) 23 Page 2
<br />
|