Open Source Asset Management Software for Small Communities

1
Open Source Asset Management Software for Small
Communities
Peter Le.Voir Doug Abbott
Maryland Center for Environmental Training (MCET)
Delaware Environmental Training Center (DelTech)
2
Pilot Program

• Partnership between EPA, MCET and DelTech.
• 4-year grant from EPA to...
• Pilot A.M. at four small- to medium-sized
  wastewater utilities in MD and DE
• Develop user friendly software
• Develop training curriculum for national
  distribution

3
Asset Management Program

• ID Stakeholders
• Mission Statement / Goals and objectives
• Asset inventory
• Criticality, Condition and Valuation
• Maintenance management
• Renewal / Replacement
• Financial plan

4
Open Source Software

• MS Office Suite v 97/2000/2003
• Data Entry using MS Access
• Export to MS Excel for Financial Analyses
• Linked Help Files in MS Word

5
Data Entry Menu
6
Report Menu
7
Advantages of this Software for Small Utilities

• Full Integration of Asset Management Principles
• Real-time valuation of all assets
• Stand-alone Maintenance Management Program
• Decision matrix for renewal / replacement
• Predictive tool for life cycle planning, capital
  improvements, OM budgeting, rate setting
• Logical scheduling and allocation of funds

8
Advantages of this Software for Small Utilities

• Cost Efficient
• LOE for Start-up Flexible
• Gets smarter with use
• Conforms with CMOM GASB requirements

9
For more information

• Attend our poster session tonight
• After conference contact MCET at 301-934-7500
  or info_at_mcet.org