Costpoint Online Help

Def Rate Seq Subtask

Use this subtask to define the order in which Costpoint selects labor rates for revenue and billing and for the selection of source projects.

The Load Labor Rates screen uses this screen to determine the order in which rates are loaded into the Open Billing Detail and Labor History tables. Set up this screen at each level of the project where labor is charged for all projects that use loaded labor formulas for revenue or billing. You can sequence up to four billing rate tables starting with the least detailed (C) up to the most detailed (PVC or PEC). The order in which these rates are found is determined by this application at the project charging level and is dependent upon the sequence numbers entered here. You can set up labor rates in the following screens:

  • Manage Project Labor Categories (PLC) screen: Use this screen for company-wide PLC billing rates.
  • Link Project Labor Category Rates to Projects screen: Use this screen for project-specific PLC billing rates.
  • Link PLC Rates to Employee/Vendor screen: Use this screen for rates for vendors and vendor employees as well as employees. Employee billing rates contain billing rates that are project and employee specific (PEC). Vendor billing rates contain billing rates that are project and vendor/vendor employee specific (PVC).

Within this subtask, you must define a source project unless you are using a Rate Table of C, in which case no source project is allowed since there is only one company-wide rate table. The Link Project Labor Category Rates to Projects screen and the Link PLC Rates to Employee/Vendor screen (if used) must be established at the source level project indicated so that billing rates can be loaded.  

If you selected the Use Top Level Workforce checkbox on the Basic Info tab of the Manage Project User Flow, you can select your source project as your top-level project. This is not necessary but may save some setup time since your workforce and PLC defaults were previously established at this level.

To provide flexibility and ease of setup, the source project specified in the Rate Sequence table can be that of another project. This means the billing rate tables could be established for a generic project and, if subsequent projects or other tasks within the same project use the same billing rates, the generic project could be referenced as the source project, with no need to re-enter the same data.

Use this subtask whenever the billing and/or revenue formula you are using is a T&M formula and PLCs have been established. It must be maintained for billing rate modifications or modifications to the order in which billing rates are used by the Load Labor Rates process and must exist at each level of the project where labor is charged.

You can also use this subtask whenever you are using fixed price or CPFF formulas for revenue and billing to be able to export project workforce charges to T&E.

This subtask is also available as a standalone application: Manage Rate Sequence Orders.

Contents

Field Description
Sequence

Enter a sequence number from one to four to signify the order in which the rate tables are searched by the Load Labor Rates process. The table with a sequence number of "1" is the first table searched for by Costpoint, followed by number "2," and so on. This is a required field.

Rate Table

Enter, or click to select, a valid system-defined billing rate table name. Select one of the following rate tables:

  • PEC: Bills by project, by employee, and by labor category
  • PVC: Bills by project, by vendor, and by labor category
  • PC: Bills by project and labor category
  • C: Bills by labor category
Description

This column displays the Costpoint-defined description of each of the four billing rate tables.

Source Project

Enter, or click to select, a valid project that serves as the source for the billing rate table. The source project is required for rate tables PC, PEC, and PVC. This project is often the same as the project entered in the heading of this screen, but it can be another project that contains the correct billing rates.

Warning: Be careful when selecting a source project that is different than the project you are billing. If the source project has billing discounts on the PLCs and the project you are billing doesn't use billing discounts, the PLC billing rates are discounted when you load the labor rates. 

Or, if you select a source project that does not have billing discounts on the PLCs for a project that does use billing discounts, you get incorrect billing rates when you load the labor rates.

The Load Labor Rates program does not check the Billing Details subtask or the Revenue Details subtask to see whether you have selected a discount method. If a discount percentage is loaded in the PLC Rate tables, the load labor rates program automatically loads the original billing rate and the discounted billing rate into open billing detail and labor history. If that occurs, you get incorrect billing rates when you calculate a bill or compute revenue.