The Asset Distribution tab contains two grids, Project Asset Distribution and Project Assets, which are described below:
Project Asset Distribution grid
The Project Asset Distribution grid tracks how project costs are distributed among asset categories. It can be used to track the total asset cost, number of asset units, asset life, and salvage value. These data may be used to establish project deterioration rates. The record that is selected in this grid controls which records are displayed in the Project Assets grid.
A sample of the grid appears below. Sort records in the grid by clicking on the headings. An up or down arrow (highlighted in orange below) indicates whether data appear in ascending or descending order.
Right-click in the grid to add a record.
Right-click on an existing record for options to View Record, Add Record, Edit Record, or Delete Record.
To create new Project Asset Distribution records, right-click in the grid and select Add Record. The following window appears:
Select an inventory asset Type from the pick list.
Enter an Asset Cost %. This value represents this asset type's portion of the entire project cost.
The Total Asset Cost is calculated by the system, using the data from the General tab.
Select the UOM (unit of measure) from the list.
Choose Count, and the system will count the number of like assets associated with this Type. The system automatically carries over data in the Cost and Value fields to the Project Assets grid.
Choose Sum, and the system will add the UOM field you indicate. The data in the Cost and Value fields is not carried over to the Project Assets grid.
If Sum is selected as the unit of measure, enter the field to be totaled in the UOM field. If Count is selected, leave UOM vacant.
For example, when creating a Project Asset record for an asset type measured in linear units (sewer or storm pipes, street segments, etc.), users may want to add the total asset length by entering the Length field here (i.e NT_LENGTH, SN_LENGTH, etc.).
Enter the number of units.
The system calculates the Unit Cost using the data in the Total Asset Cost and Units fields.
The Start Date establishes the beginning of the asset's usable life. It represents the date the asset was put into service.
Enter the Asset Life in years. This is the maximum life for this asset. This establishes the asset type's deterioration rate.
Enter the Salvage Value for the asset at the end of its life.
Indicate whether the salvage value will replace the asset's previous worth at the end of the deterioration curve.
Save and close the record.
Note: Use the functions in the grid to View, Edit, or Deletethe records.
Project Assets grid
The Project Assets grid enables users to associate individual Inventory assets with the construction project. This information can be used to track the cost of each individual asset as well as its asset life and deterioration schedule.
A sample of the grid appears below. Sort records in the grid by clicking on the headings. An up or down arrow (highlighted in orange below) indicates whether data appear in ascending or descending order.
Right-click in the grid for options to Add Record, Create Subset, Load Subset, Add Multiple Records, or add a Stretch.
Right-click on an existing record for options to View Record, Add Record, Edit Record, Delete Record, View Asset Inventory Record, View Asset in Map .
Double-click on an existing record to open it.
Add Multiple Records - Allows users to select several assets at once and attach them to the construction record.
Stretch - Allows users to select an upstream pipe and downstream pipe. These pipes and the stretch of pipes between them are all added to the work order.
View Asset Inventory Record - Opens an inventory module to the record for the currently selected asset.
View Asset in Map - Opens the map and displays the currently selected asset.
To create a new record, highlight a listing in the Project Asset Distribution grid.
Right-click in the Project Asset grid. Select Add Record. A window similar to the following will appear:
The Object Type is entered automatically by the system. This matches the highlighted Object Type in the Project Asset Distribution grid.
Note: The Object Type field cannot be edited by the user. To change the Object Type, highlight a different Asset Type listing in the Project Asset Distribution grid.
Select an individual asset from the Link 1 pick list (use F9 to access the list). The list displays assets of the same type as indicated in the Object Type field.
The Link 2 field will be populated by the system if the asset chosen from the Link 1 list has an alternate or secondary ID. For example, Sewer Pipes have two system IDs.
If you selected Count as the UOM (unit of measure) in the related Project Asset Distribution record, the system populates all other fields in this dialog with data from that record. This data can be edited as needed.
If you selected Sum as the UOM (unit of measure) in the related Project Asset Distribution record, only the Asset Life field is populated. All other data is user-entered.
The system calculates the Present Value and Remaining Life fields. The calculation for the Remaining Life field is as follows:
Remaining Life = Life of Asset - (Today's System Date - Start Date).
If the asset has reached the end of its useful life, the system marks the No Remaining Value checkbox.
Right-click in the grid and select Stretch. The following window will appear:
Enter the US Structure ID and the DS Structure ID in their respective fields.
Enter the maximum number of segments to search in the corresponding field. The system may have a default number set in the Sewer Options module.
Click Trace. A list of all manholes located between the US Structure and the DS Structure you entered is produced.
Note: If a break in the stretch exists, the user receives a message that a manhole is missing or there is nonconsecutive pipe information. Click OK and the consecutive manholes appear in the Structures list.
Click Populate to add these pipes to the Asset grid.
OR
Click Reset to clear the Stretch window and start over.
How To Add a Project Asset Distribution Record
to save the subset.
