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:
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.
|
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. |