Switch Content View

Instructions for the Worksheet

This section presents instructions for completing the System Inventory Worksheet.

Step #1: Enter the date

Circle whether you are completing or updating the worksheet and fill in the date. You should update this worksheet at least once a year. You can either make minor adjustments to the worksheet as the condition of your assets change, or start a new worksheet each year.

Step #2: Identify your assets

Write in each of your system’s assets. Be as specific as possible by providing location, manufacturer, or some other identifier for each asset. List separately assets made of different materials or installed at different times. For example, you might list a section of your distribution system as “10-inch PVC on Main St.”  You can make a copy of this worksheet if you need more room to list assets.

 Step #3: Fill in expected useful life

Use the manufacturer’s recommendation to enter the expected useful life for each asset.

Step #4: Describe assets’ condition

Briefly describe the condition of each asset. Focus especially on conditions that may influence the useful life (for example, rust or broken parts).

Step #5: Describe service history

Briefly describe the service history of each asset. Include routine maintenance activities as well as any repairs and rehabilitations. List how often you have made repairs and rehabilitations.

Step #6: Estimate the adjusted useful life for each asset

Using the Expected Useful Life (step 3) as a guide, estimate the adjusted useful life for each of your assets by considering its current condition (step 4) and its service history (step 5). If your asset is in poor condition, has not been properly maintained, or faces other challenges (poor water or soil quality, excessive use, etc.), then the adjusted useful life is likely to be less than the lower end of the expected useful life range. If your asset is in good condition, has been properly maintained, and faces average water quality, then you can use the average useful life value. However, you may want to use the lower end of the range to be more conservative and help ensure that you are prepared to replace the asset.

Step #7: Record age

For each asset, fill in how long the asset has been in use. If the asset has been previously used by another system, you should list the total age, not just the length of time your system has used it.

Step #8: Calculate the remaining useful life

For each asset, calculate the remaining useful life by subtracting its age (step 7) from its adjusted useful life (step 6).


previous home next
Worksheet Introduction   Example Worksheet