Create a Materials Rate Table
Background
Create and manage rate tables with effective/expiration dates and define custom cost and billable rate columns.
Columns are configured in the company's Rate tool settings, while rows populate automatically from your project's Materials inventory.
labor and equipment rate tables
Rate tables for Labor and Equipment are created and managed in the Company level Rates tool.
Things to Consider
-
Rate tables are effective between the effective date and the expiration date.
-
When a calculated rate column is included in a table, the associated source columns from the calculated rate's formula are also added.
-
You can add and edit the rates for the source columns within a calculated rate's formula, but you cannot override the final calculated value.
Prerequisites
-
Materials must be listed in your inventory using one of the following methods:
-
On an active project, the Commitments tool was used to create a commitment change order or purchase order for materials, and includes the following information:
-
The status is Approved
-
The Schedule of Values (SOV) includes the following for each line item:
-
Description
-
Unit of Measure (UOM)
-
-
Steps
Tip
You can also copy a rate table.-
Navigate to the Project level Rates tool.
-
Click Create Material Table.
-
Enter the general information.
-
Add Columns.
-
Move the toggles
ON or
OFF to include or exclude columns.
-
-
Click Create.

