LOAD LABOR RATES

Use this screen to populate the Open Billing Detail and/or the Labor History table with appropriate billing rate information. There are many ways to link a billing rate to a project in Costpoint. Multiple tables accommodate this. You can set up and maintain Project Labor Categories (PLCs) and their associated billing rates in Costpoint Project Setup. The Load Labor Rates process uses the Define T&M rate Sequence table to determine which billing rate table to use for a project. The process evaluates the effective date in Labor History and Open Billing Detail and compares it to the start and end dates in the rate tables to determine the proper billing rates. After the proper rates have been found, the billing rates are copied into the Labor History table and/or the Open Billing Detail table.

If the Use Goal Multipliers for Billable Value Calculations check box is selected on the Configure Project Settings screen, this program performs additional steps. Currently, this program uses the Manage Rate Sequence Orders screen to assign billing rates to Labor History and Open Billing Detail for hourly base projects. Hourly based projects are those projects billed out using loaded labor rates. For these projects, Costpoint loads the billing rate into the REV_RT_AMT column of LAB_HS (Labor History), and the BILL_RT_AMT column of OPEN_BILLING_DETL.

If you want to compute and report Billing Value, a value is required in the REV_RT_AMT column of the LAB_HS (Labor History) table for all labor hours incurred. For hourly based projects, this field is computed as previously outlined. For all other projects (CPFF, CPFH, Units based, Cost Time Multiplier), the actual hourly rate is loaded into the REV_RT_AMT column of LAB_HS (Labor History). The allowable hours column (ALLOW_REV_HRS) is set equal to the actual hours worked. The rate type column (S_BILL_RT_TYPE_CD) of  LAB_HS (Labor History) is set to the appropriate rate type (A (Actual), B (Billing), C (Ceiling)). These types of projects bill labor hours at the hourly payroll rate, rather than a loaded billing rate.

The Revenue and Billing calculation programs use the billing rate stored in Labor History and Open Billing Detail, respectively, as the basis for revenue and billing amounts on projects with T&M or Loaded Labor formulas. Therefore, you must run this program before computing revenue or billings. You should also initialize PLC billing rates by project before running this program. In addition to using revenue and billing programs, the Billing Value report also uses the billing rate stored in Labor History as the basis for deriving the billing value of costs incurred.

Only those records that have a fiscal year, period and subperiod equal to the Fiscal Year, Period, and Subperiod entered in this screen are evaluated. Therefore, if you posted labor adjustments to more than one period, you should run this program for each period affected by the modifications.

The billing rate that is selected from the billing rate table is based on the effective date in Labor History and/or Open Billing Detail. The effective date is compared to the start and end dates in the billing rate tables to determine the proper rate.

Location

Identification

Use the fields in this block to create a new parameter ID or to retrieve a previously saved parameter ID. A parameter ID represents a set of screen selection parameters. After you have saved a parameter ID and its related parameters, you can retrieve them using Query.

You can use the retrieved parameters to produce reports and run processes more efficiently and with greater consistency. The saved parameters are also useful and necessary when you want to run the process as part of a batch job. Many users save a unique set of parameters for each different way they run a report or process. When you select a previously saved parameter ID or parameter description, the associated saved screen selection parameters automatically display as selection defaults. The page setup and print options are also included in the saved parameter ID if there are any. You can change any of the associated selection defaults as necessary.

Parameter ID

Enter, or click to select, a parameter ID of up to 15 alphanumeric characters. Choose characters for your parameter ID that help identify the type of selections you made in the screen, such as PERIOD or QUARTERLY.

When you save your record, all the selections made in the screen are stored with the parameter ID. Later, you can retrieve the parameter using Query.

You can use the parameter to run the process more efficiently because you can select the parameter ID with its previously defined screen selections. After the default selections display in the screen, you can override the defaults.

Description

Enter, or click to select, a parameter description of up to 30 alphanumeric characters.

Selection Ranges

Subperiods

Use the options in this group box to select the subperiods with which you want to update labor rates. If more than one period requires updating, the program must be run individually for each period being updated.

Options

Use this drop-down list to select the range of values to be included. Valid options are:

The default for this field is All.

Start Fiscal Year

Enter, or click to select, the starting fiscal year for the range you want to include.

Start Period

Enter, or click to select, the starting period for the range you want to include.

Start Subpd

Enter, or click to select, the starting subperiod for the range you want to include.

Ending Date

If the Subperiod field is active and you have made your selections, this field displays the ending date for the selected subperiod.

End Subpd

Enter, or click to select, the ending subperiod for the range you want to include.

Ending Date

This field displays the ending date for the selected subperiod.

Projects

Option

Use this drop-down list to select the range of projects to be included. Valid options are:

The default for this field is All.

Start

Enter, or click to select, the starting project for the range you want to include. If you select All or From Beginning in the Option field, this field is inactive. 

End

Enter, or click to select, the ending project for the range you want to include. If you select All, One, or To End in the Option field, this field is inactive.

Exchange Rate Date

Enter, or click to select, the exchange rate date that you wish to use for the labor rates. The Calculate Standard Bills screen uses this date when converting the billing rates. The default is the system date.

Options

Select Process

Use this group box to select the tables that are updated with the billing rate.

Labor History

Select this option to update the billing rate in the Labor History table. This is the REV_RT_AMT column of the LAB_HS table. Select this option if you want the billing rates updated only for the revenue computation.

Open Billing Detail

Select this option to update the billing rate in the Open Billing Detail table. This is the BILL_RT_AMT column of the OPEN_BILLING_DETL table. Select this option if you want the billing rates updated only for the billing computation.

Both

Select this option to update the billing rate in both the Labor History and Open Billing Detail tables. Select this option if you want the billing rates updated for both revenue and billing computations. This option is selected by default.

Load Rates

When you have finished making your selections, click to start loading updated billing rates into the Labor History table and/or the Open Billing Detail table.