|
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 />2,961,534.00
<br />1,791,815.78
<br />700,918.68
<br />602
<br />Sewer Operating
<br />Personal Services
<br />602-495-4101-000
<br />Salaries - Sewer
<br />276,285.00
<br />207,213.75
<br />171,346.56
<br />154,309.46
<br />602-495-4102-000
<br />Overtime - Sewer
<br />7,000.00
<br />5,250.00
<br />5,105.59
<br />4,905.15
<br />602-495-4105-000
<br />On CallPager
<br />5,000.00
<br />3,750.00
<br />-344.35
<br />-201.22
<br />602-495-4106-000
<br />Temporaries - Sewer
<br />9,900.00
<br />7,425.00
<br />3,610.50
<br />5,988.62
<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 />16,215.75
<br />13,477.73
<br />12,610.80
<br />602-495-4122-000
<br />FICA
<br />22,811.00
<br />17,108.25
<br />13,142.02
<br />11,954.74
<br />602-495-4123-000
<br />Def Comp Employer Contribution
<br />428.00
<br />321.00
<br />101.49
<br />0.00
<br />602-495-4131-000
<br />Health Insurance
<br />37,844.00
<br />28,383.00
<br />18,271.99
<br />17,743.28
<br />602-495-4133-000
<br />Life Insurance
<br />871.00
<br />653.25
<br />444.91
<br />618.80
<br />602-495-4134-000
<br />Dental Insurance
<br />2,076.00
<br />1,557.00
<br />1,274.12
<br />1,284.21
<br />602-495-4151-000
<br />Workers Compensation
<br />16,536.00
<br />12,402.00
<br />15,676.00
<br />12,179.00
<br />Personal Services
<br />400,372.00
<br />300,279.00
<br />242,133.33
<br />221,392.84
<br />Supplies
<br />602-495-4200-000
<br />Office Supplies -Sewer
<br />2,500.00
<br />1,875.00
<br />1,234.85
<br />1,457.68
<br />602-495-4211-000
<br />Maintenance Supplies -Sewer
<br />45,000.00
<br />33,750.00
<br />47,326.38
<br />5,132.09
<br />602-495-4212-000
<br />Vehicle Fuel
<br />10,000.00
<br />7,500.00
<br />0.00
<br />0.00
<br />602-495-4240-000
<br />Small ToolsEquip-Sewer
<br />2,500.00
<br />1,875.00
<br />3,221.87
<br />829.00
<br />Supplies
<br />60,000.00
<br />45,000.00
<br />51,783.10
<br />7,418.77
<br />Services & Charges
<br />602-495-4300-000
<br />Professional Services -Sewer
<br />165,300.00
<br />123,975.00
<br />53,463.06
<br />58,068.90
<br />602-495-4304-000
<br />Municipal Engineer
<br />25,000.00
<br />18,750.00
<br />11,818.06
<br />14,556.25
<br />602-495-4304-146
<br />Municipal Engineer
<br />0.00
<br />0.00
<br />33,858.00
<br />0.00
<br />602-495-4310-000
<br />Other Consultant -Sewer
<br />24,375.00
<br />18,281.25
<br />19,030.69
<br />9,415.30
<br />602-495-4321-000
<br />Telephone -Sewer
<br />1,500.00
<br />1,125.00
<br />1,254.56
<br />775.97
<br />602-495-4322-000
<br />Postage -Sewer
<br />5,000.00
<br />3,750.00
<br />2,934.52
<br />3,879.89
<br />602-495-4330-000
<br />TravelTuition-Sewer
<br />3,000.00
<br />2,250.00
<br />1,680.00
<br />1,000.00
<br />602-495-4340-000
<br />Advertising -Sewer
<br />500.00
<br />375.00
<br />0.00
<br />381.41
<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 />6,946.50
<br />6,967.62
<br />0.00
<br />602-495-4360-000
<br />Insurance
<br />17,540.00
<br />13,155.00
<br />18,454.00
<br />17,627.00
<br />602-495-4363-000
<br />Auto Insurance
<br />960.00
<br />720.00
<br />951.00
<br />941.00
<br />602-495-4370-000
<br />Uniforms -Sewer
<br />760.00
<br />570.00
<br />535.97
<br />510.72
<br />602-495-4381-000
<br />Electricity -Sewer
<br />32,000.00
<br />24,000.00
<br />23,875.48
<br />21,538.07
<br />602-495-4382-000
<br />Utilities -Sewer
<br />15,000.00
<br />11,250.00
<br />8,686.68
<br />7,173.27
<br />602-495-4383-000
<br />Heat -Sewer
<br />1,800.00
<br />1,350.00
<br />1,256.25
<br />966.34
<br />Services & Charges
<br />301,997.00
<br />226,497.75
<br />185,244.82
<br />136,834.12
<br />Contractual Services
<br />602-495-4405-000
<br />MCES Sewer Charges
<br />1,087,743.00
<br />815,807.25
<br />906,449.10
<br />741,366.18
<br />602-495-4410-000
<br />Contracted Services -Sewer
<br />5,758.00
<br />4,318.50
<br />3,629.78
<br />8,202.54
<br />602-495-4452-000
<br />SubscriptionsDues-Sewer
<br />1,000.00
<br />750.00
<br />243.09
<br />124.37
<br />602-495-4510-000
<br />Purchased Assets Dep
<br />574,323.00
<br />430,742.25
<br />0.00
<br />0.00
<br />Contractual Services
<br />1,668,824.00
<br />1,251,618.00
<br />910,321.97
<br />749,693.09
<br />Capital Outlay
<br />602-495-5000-000
<br />Capital Outlay
<br />115,015.00
<br />86,261.25
<br />44,139.90
<br />57,430.12
<br />602-495-5000-146
<br />Capital Outlay - 2022 ESLD
<br />0.00
<br />0.00
<br />158,735.51
<br />0.00
<br />Capital Outlay
<br />115,015.00
<br />86,261.25
<br />202,875.41
<br />57,430.12
<br />602
<br />Sewer Operating
<br />2,546,208.00
<br />1,909,656.00
<br />1,592,358.63
<br />1,172,768.94
<br />603
<br />Storm Water Operating
<br />Personal Services
<br />603-496-4101-000
<br />Salaries - Storm
<br />136,793.00
<br />102,594.75
<br />66,608.17
<br />0.00
<br />603-496-4102-000
<br />Overtime - Storm
<br />0.00
<br />0.00
<br />1,400.63
<br />0.00
<br />603-496-4121-000
<br />PERA
<br />10,259.00
<br />7,694.25
<br />5,100.89
<br />0.00
<br />603-496-4122-000
<br />FICA
<br />10,465.00
<br />7,848.75
<br />5,088.04
<br />0.00
<br />603-496-4123-000
<br />Def Comp Employer Contribution
<br />285.00
<br />213.75
<br />101.49
<br />0.00
<br />603-496-4131-000
<br />Health Insurance
<br />20,516.00
<br />15,387.00
<br />2,551.77
<br />0.00
<br />603-496-4133-000
<br />Life Insurance
<br />417.00
<br />312.75
<br />166.38
<br />0.00
<br />603-496-4134-000
<br />Dental Insurance
<br />944.00
<br />708.00
<br />269.72
<br />0.00
<br />603-496-4151-000
<br />Workers Compensation
<br />8,364.00
<br />6,273.00
<br />3,869.00
<br />0.00
<br />GL - Budget to Actual (11/09/2022 - 01:53 PM) 23 Page 2
<br />
|