Asset Management – Resources
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:
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.)
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
- This file is compressed and must be extracted prior to opening.