Labor ETC Subtask

Use this subtask to budget ETC amounts at the labor category (GLC/PLC) level or Employee/Vendor level.

You cannot access this subtask unless you selected the Use Labor ETC check box in the Info tab. If ETC budgeting is not completed in this subtask, you can budget at the account level on the Estimate to Complete subtask. This screen is updated based on the information from the Labor subtask.

Contents

Field Description
Budget Hours

This non-editable field displays the total budgeted labor hours from the Labor subtask.

Actual Hours

This non-editable field displays the actual, posted hours for this project. The actual hours displayed are based on the fiscal year and period used on the Update Incurred Costs subtask.

ETC Hours

This non-editable field displays the total of all ETC hours on this screen.

ETC Amount

This non-editable field displays the total of all ETC amounts on this screen.

Fiscal Year

This non-editable field displays the fiscal year selected on the Update Incurred Costs subtask.

Period

This non-editable field displays the fiscal period selected on the Update Incurred Costs subtask.

Use Rate

The setting for this non-editable check box defaults from the Use Rate check box on the Info tab. You must select this check box if you are calculating labor rates.

Table Window

Field Description
Organization

Enter, or click to select, the organization for this ETC row. This field is required.

Org 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 ETC row. This field is required.

Account Name

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

GLC

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

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

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

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

GLC Name

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 (PLC) screen are available for . The PLC rate that defaults into the ETC Amount column is based on the selections made on the Info tab. In that subtask, you can select either the Labor Cost or T&M Labor options. The rate defaults in the following manner based on these selections:

  • If you selected the Labor Cost option, the rate defaults from the Manage Average Cost PLC Rates screen. This is an editable field.
  • If you selected the T&M Labor option, the rate defaults according to setup of the Manage Rate Sequence Orders screen. If no rate exists, no rate defaults. This is an editable field.

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, or employee specific. The rate sequence table in the Projects domain defines the order in which the default rate is selected.

PLC Name

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

Vendor

This column displays if you selected the Employee/Vendor Level option on the Info tab.

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 column displays if you selected the Employee/Vendor Level option on the Info tab. This non-editable column displays the name of the vendor selected in the Vendor column.

Employee

This column displays if you selected the Employee/Vendor Level option on the Info tab.

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

Employee Name

This column displays if you selected the Employee/Vendor Level option on the Info tab. This non-editable column displays the name of the employee selected in the Employee column. This column is optional.

Vendor Employee

This column displays if you selected the Employee/Vendor Level option on the Info tab.

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

Vendor Employee Name

This column displays if you selected the Employee/Vendor Level option on the Info tab. This non-editable column displays the name of the employee selected in the Vendor Employee column. This column is optional.

Total Budget Amount

This non-editable column displays the sum of the Revised Amt, Profit Amt, and Approved CO Profit Amt columns in the Labor subtask.

Budgeted Hours

This non-editable column displays the budgeted hours for this labor row. Costpoint multiplies this amount by the Average Cost Rate or T&M (Time & Materials rate) on the Labor subtask and displays the result in the Total Budget Amt column.

Incurred Hours

This non-editable column displays the actual hours that were charged to the project. This information is filtered through Costpoint General Ledger.

Complete Rate

This rate is defined as the completion percentage for each labor category and can be modified. This rate is typically determined by the project manager using the amounts spent/incurred to date vs. the total estimated amount to complete the project. This rate also recalculates the Latest Revised Estimate at Completion (LREAC) and ETC (Incurred + ETC = LREAC).

ETC Hours

Enter the ETC hours for this labor category. Costpoint recalculates these hours by subtracting the Incurred Hours from the LREAC Hours (LREAC – Incurred = ETC).

ETC Amount

This field displays the ETC amount for this labor category and can be modified. This column, ETC Hours, the Complete Rate, and LREACHours are dynamic; if you modify these amounts, the remaining columns are recalculated. However, the ETC Hours * ETC Rate Amt = ETC Amount.

LREAC Hours

This field displays the Latest Revised Estimate at Completion (LREAC) hours for this labor category and can be modified. This column, ETC Hours, the Complete Rate, and ETC Amount are dynamic; if you modify these amounts, the remaining columns are recalculated. Costpoint also recalculates these hours by adding the Incurred Hours to the ETCHours (Incurred + ETC = LREAC).

ETC Rate Amt

This field displays the ETC rate amount for this labor category and can be modified. Costpoint multiplies this field by the ETC Hours to obtain the ETC Amount.

Previous Complete Rate

This non-editable column displays the amount that was formerly displayed in the Complete Rate column. When you click the Revise ETC button, the Complete Rate data moves to this column.

Previous LREAC Hours

This non-editable column displays the hours that were formerly displayed in the LREAC Hours column. When you click the Revise ETC button, the LREAC Hours data moves to this column.