Asset Management – Resources



  • Level of Service: Guidelies, Categories, and Example Goals | download
  • Level of Service: Goal Measurement | download
  • Criticality of Assets | download
  • Reference Guide for Asset Management Inventory and Risk Analysis | download
  • Introduction to Asset Management and Asset Management Resources | download
  • Asset Management: The Five Core Components | download
  • O&M Management Guide – DRAFT, Available for pilot
    (Note: This is a zip file and must be extrated prior to opening) | download

Asset Inventory

  • Inventory Database (Note: This is a zip file and must be extrated prior to opening) | download
  • Instruction for using Asset Inventory Database | download
  • Inventory Spreadsheet | download

The Inventory Spreadsheet is a standalone Excel file designed to assist small systems with developing an asset and energy inventory.  There are two tabs in the spreadsheet: Asset Inventory, and Energy Inventory.

The Asset Inventory tab has 10,000+ rows available for tracking important information about individual assets including (but not limited to): ID numbers, location, operational status, condition, probability of failure (POF), consequence of failure (COF), age, expected & remaining life, replacement cost and energy use.   Several important fields in the Asset Inventory tab contain formulas:

  • A Risk Score is automatically calculated if POF, COF and Redundancy Factors are entered; and
  • Current Age, Remaining Useful Life and Expected Replacement Year are calculated based on entered Installation Date and Expected Total Life values.

The Energy Inventory tab has 200 rows in which you can inventory the energy use of your assets, and includes fields for data including ID number, horsepower, power consumption, peak energy demand and average run time.

(Please note that the spreadsheet is password protected and locked fields containing formulas cannot be edited to prevent accidental erasure.  Be sure to enable macros when you open the file for full functionality.)

Asset Valuation Tool

This asset valuation tool was designed to provide water utilities with an estimate of what it would cost the utility to replace all of the assets today. Having an idea of the overall value of the utility can help guide decisions about how much to invest in maintenance, how much to save for the future and other financial and non-financial decisions. This tool provides the utility with an estimate that is meant to be used when looking at the big picture. It is not specific enough to use for planning replacement or construction budgets. In order to use the tool, input the estimated quantity for each asset owned and the outputs include low, high and median estimates based on the costs found from the information listed on the sources tab.Download the Asset Valuation Tool

  • Note:
  • This file is compressed and must be extracted prior to opening.


   © All Rights Reserved, Southwest Environmental Finance Center
Logo Header Menu
Social media & sharing icons powered by UltimatelySocial