Labor Subtask

Use this subtask to enter labor amounts for the project's budget.

You can create workforce budgeting for projects by using general labor categories, project labor categories, vendor labor, or employee labor. You can establish cost and bill rates; they act as default values in Costpoint Advanced Project Budgeting when a labor category is selected and can be modified for a particular row. You can build up cost rates to include burden and profit by using a composite rate for overhead and fringe costs and a multiplier for profit. T&M (bill) rates can be used for workforce budgeting and Costpoint automatically creates a cost budget for effort reporting. The T&M (bill) rate selection automatically follows the T&M (bill rates) sequencing process. You can enter a subcontractor on the same line to track subcontracted labor.

Table Window

Field Description
Organization

Enter, or click to select, the organization for this labor row.

This field is required and all organizations are available for .

Organization Name

This non-editable column displays the name of the organization entered in the Organization column.

Account

Enter, or click to select, the account for this labor row. This field is required.

Account Name

This non-editable column displays the name of the account entered in the Account column.

Reference No
Note: This column does not appear unless you select the Budget Using Ref Number and Ref Name check box on the Configure Project Budget Settings screen.

Enter, or click to select, the reference number for this row. This column is optional. If you use the reference feature, your actual cost data for this project must also be tracked with reference numbers. This ensures correct variance reporting for actual versus budgeted.

GLC

Enter, or click to select, a General Labor Category (GLC) for this labor row.

Only GLCs created in the Manage General Labor Categories screen in Costpoint Labor are available for .

If you selected the Labor Cost option on the Info tab and you select a GLC here, the average cost rate for this GLC becomes the default value in the Average Cost Rate column on this table. If no rate exists, no rate is the default.

Create and maintain GLC rates on the Manage General Labor Categories screen. Maintain GLC rates for budgeting on the Manage Average Cost GLC Rates screen.

GLC Description

This non-editable column displays the name of the selected GLC.

PLC

Enter, or click to select, a Project Labor Category (PLC) for this labor row.

Only PLCs entered on the Manage Project Labor Categories (PLCs) screen are available for . The rate that defaults in to the Average Cost Rate column depends upon the selection made on the Info tab. The options in that screen are Labor Cost or T&M Labor. The following defaults occur:

  • If you select the Labor Cost option, the average cost amount from the Manage Average Cost PLC Rates screen displays in the rate Average Cost Rate column.
  • If you select the T&M Labor option, Costpoint uses the Manage Rate Sequence Orders screen to determine which rate is used for this PLC. 

Create and maintain PLC average cost rates on the Manage Average Cost PLC Rates screen. Create and maintain Project Labor Categories in the screens in the Project Labor menu of Costpoint Project Setup. PLC T&M rates can be project specific, vendor specific, and employee specific. The T&M rate sequence table in the Projects folder defines the order in which the default rate is selected.

PLC Name

This non-editable column displays the name of the selected PLC.

Vendor

Enter, or click to select, a vendor for this labor row. This column is optional, and all existing vendors are available for . If you enter or select a vendor, you must also select a GLC or PLC category to save this row.

Vendor Name

This non-editable column displays the name of the vendor selected in the Vendor column.

Employee

Enter, or click to select, the employee for this labor row. This column is optional. If you select an Employee, you must also select a GLC or PLC.

Employee Name

This non-editable column displays the name of the employee selected in the Employee column.

Vendor Employee

Enter, or click to select, the vendor employee for this labor row. This column is optional.

Vendor Employee Name

This non-editable column displays the name of the employee selected in the Vendor Employee column.

Subcontract No

Enter the subcontract number. Use this number as a contract identification number or use a name to label a subcontract.

Fiscal Year

Use the drop-down list to select the fiscal year for this labor row. All existing fiscal years are accepted.

Note: This column does not display unless you selected the Budget by Period check box on the Info tab.
Period No

Select the period for this labor row. All existing periods are accepted.

Note: This column does not display unless you selected the Budget by Period check box on the Info tab.
Average Cost Rate/T&M

The Average Cost Rate column displays only when you have selected the Labor Cost or T&M Revenue and Cost option in the Info tab. This column is titled T&M (Time & Materials bill rate) when you select the T&M Labor option in the Info tab.

Average Cost Rate is for a labor cost budget. Use it to build a budget using average labor cost rates along with indirect or burden rates to arrive at a loaded cost rate for budgeting (for example, cost plus jobs). You can mark up the Average Cost Rate using a multiplier to arrive at an expected profit per row.

The GLC rate is entered on the Manage Average Cost GLC Rates screen. If no PLC or GLC rate was entered, the cost rate for the vendor or employee is the default value in this column. You can modify the rate in this column for this labor row, and this does NOT modify the average cost rate in the PLC or GLC rate table.

Composite Rate

This editable column displays the composite rate of the cost-based cost pools from the burden template. (Be aware that if you make a modification to the composite rate, there is a variance line on the Indirect subtask.) The composite rate is linked to the Account/Org on the Pool Base subtask of the Manage Burden Templates screen, but the burden template is linked on the Info tab.

Costpoint multiplies the cost budget amount by the composite rate to obtain a loaded labor cost, or burdened amount.

Composite Hourly Rate

This column displays the composite hourly rate for this Account/Org, if hours-based cost pools exist. Costpoint multiplies this rate by the Budgeted Hours to obtain the Hourly Burden Amount.

Change Composite Rate

If you select this check box, use the composite rate or use the burden template to insert a default composite rate. If you select this check box, any time the burden template is updated with new accounts, or with a new rate, or if the template is modified, the new composite rate displays in the Composite Rate field. If do not select this check box, modifications to the composite rate for the burden template selected on the Info tab do not affect this row.

Warning: If you modify the composite rate, a variance line is created on the Indirect subtask (if you enabled the Indirect subtask in the Info tab).
Multiplier

The Target Multiplier entered on the Info tab is the default in this field and can be modified. To select a different multiplier amount default, edit the Info tab.

Budgeted Hours

Enter the budgeted hours for this labor row. Costpoint multiplies this amount by the Average Cost Rate or T&M (Time & Materials rate) and displays the result in the Cost Budget Amount column.

Approved CO Hours

This non-editable column displays the number of approved change order hours. Change orders are entered on the Manage Change Orders screen. Enter the number of labor hours and the labor rate to arrive at the change order amount. The labor amount entered on all approved change orders for this project is included for this budget.

Total Hours

This column displays the sum of Budgeted Hours and Approved CO Hours and can be modified. If you modify this column, the Budgeted Hours column amount automatically recalculates.

Cost Budget Amount/Revenue Budget Amount

This column displays the product of either T&M (Time & Materials) or Average Cost Rate multiplied by the Budgeted Hours amount. The Cost Budget Amount column displays if you have selected the Labor Cost option in the Info tab for labor. This column is titled Revenue Budget Amount if you selected the T&M Labor option. If you modify this column, the Budgeted Hours column amount automatically recalculates.

Hourly Burden Amount

This column displays the hourly burdened amount. Costpoint calculates this value by multiplying the Composite Hourly Rate by the Budgeted Hours.

Total Burden Amount

This column displays the product of the Cost Budget Amount and the Composite Rate columns plus the Hourly Burden Amount and can be modified. This column appears if you select the Labor Cost option on the Info tab for labor. If you modify the Total Burden Amount, the Composite Rate column amount automatically recalculates.

Burdened Budget Amt

This non-editable column displays the sum of the Cost Budget Amount and the Total Burden Amount columns.

Approved CO Amount

This non-editable column displays the approved change order amount for this labor row. This figure is the total monetary labor equivalent of the Approved CO Hours for this organization and account or organization and reference. Change orders are entered on the Manage Change Orders screen. Enter the number of labor hours and the labor rate to arrive at the change order amount. The labor amount entered on all approved change orders for this project is included for this budget.

Revised Amount

This non-editable column displays the revised budget amount. This number is the sum of the either the Burdened Budget Amt and the Approved CO Amount or Revenue Budget Amount and the Approved CO Amount. The Revenue Budget Amount is used in this calculation only when you select the T&M Labor option on the Info tab.

Profit Amount

This column displays the profit amount for this row, and can be modified. This column is calculated by several different formulas, depending on the selection you make in the Subtask Multiplier Info group box on the Info tab. If you modify this column, the Multiplier recalculates.

  • If you selected Use Multiplier on Budget Amt in the Subtask Multiplier Info group box, Costpoint multiplies this row's Multiplier by the Cost Budget Amount column, then subtracts the Budget Amount, and the result displays in this column ((Multiplier for this row * Budget Amount) - Cost Budget Amount). If the Budget Amount is 100,000 and the Multiplier is 1.2, the resulting Profit Amt is 20,000.
  • If you selected Use Multiplier on Burdened Bud Amt in the Subtask Multiplier Info group box, Costpoint multiplies this row's Multiplier by the Burdened Budget Amt column, then subtracts the Burdened Budget Amt, and the result displays in this column ((Multiplier for this row * Burdened Budget Amt) – Burdened Budget Amt). If the Burdened Budget Amt is 100,000 and the Multiplier is 2, the resulting Profit Amt is 100,000.
  • If you selected Use Multiplier on Rvsd Budget Amt in the Subtask Multiplier Info group box, Costpoint multiplies this row's Multiplier by the Revised Amt column, then subtracts the Revised Amt, and the result displays in this column. Use this method only if the Multiplier must be applied to the Approved CO Amt ((Multiplier for this row * Revised Amt) – Revised Amt). If the Revised Amt is 100,000 and the Multiplier is 2.5, the resulting Profit Amt is 150,000.
  • If this row has no Multiplier, no profit amount is calculated for this row.
Approved CO Profit Amount

This non-editable column displays the calculated profit portion of the approved change order for this row. If you enter a change order with separate cost and profit amounts, the profit amount is displayed. Enter change orders on the Manage Change Orders screen.

Total Budget Amount

This non-editable column displays the sum of the Revised Amount, Profit Amount, and Approved CO Profit Amount columns.

Unallocated Amt
Note: This column is available only if you selected the Budget by Period check box on the Info tab.

This non-editable column displays the total of all amounts unallocated to a fiscal period. This column is not visible if budgets are not spread or not maintained by period. The amount in this column is the Total Budget Amt for this labor row, less the amounts allocated over periods, usually done with the Spread function.