LABOR ETC

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

You cannot access this subtask unless you have selected the Use Labor ETC check box in the Project Budget Information subtask (access this subtask with the INFO button on the main screen). If ETC budgeting is not completed in this subtask, you can budget at the account level in the ETC subtask. This screen is updated based on the information from the Labor subtask.

Project

This non-editable field displays the project from the main screen.

Name

This non-editable field displays the project name from the main screen.

Budget Type

This non-editable field displays the budget type, either Baseline or Workplan, selected from the Budget Type group box in the main screen.

Bud Hours

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

Act 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 in the Update Incurred Costs for ETC Subtask.

ETC Amt

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

Revision

This non-editable field displays the revision from the main screen for your workplan budget.

Table Window

Organization

Enter, or use 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 use 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 use to select, a General Labor Category (GLC) for this labor row.

Only GLCs created in the General Labor Categories screen (People » Labor » Labor Controls) are available in .

If you selected the Labor Cost option in the Project Budget Information subtask, 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 will be the default.

Create and maintain GLC rates in the General Labor Categories screen (People » Labor » Labor Controls). Maintain GLC rates for budgeting in the Maintain Average Cost GLC Rates screen (Projects » Advanced Project Budgeting » Controls).

GLC Name

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

PLC

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

Only PLCs entered on the Set Up Project Labor Categories (PLC) screen (Projects » Project Setup » Project Labor) are available for . The PLC rate that will default into the ETC Amount column is based on the selections made in the Project Budget Information subtask.  In that subtask, you can select either the Labor Cost or T&M Labor options.  The rate will default in the following manner based on these selections:

  1. If you selected the Labor Cost option, the rate will default from the Maintain Average Cost PLC Rates screen (Projects » Advanced Project Budgeting » Controls). This is an editable field.

  2. If you selected the T&M Labor option , the rate will default according to setup of the Define Rate Sequence screen (Projects » Project Setup » Revenue Setup). If no rate exists, no rate will default. This is an editable field.

Create and maintain PLC average cost rates in the Maintain Average Cost PLC Rates screen (Projects » Advanced Project Budgeting » Controls). 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 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

This column will display if you selected the Employee/Vendor Level option in the Project Budget Information subtask.

Enter, or use to select, a vendor for this labor row. This column is optional, and all existing vendors will be 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 will display if you selected the Employee/Vendor Level option in the Project Budget Information Subtask. This non-editable column displays the name of the vendor selected in the Vendor column.

Employee

This column will display if you selected the Employee/Vendor Level option in the Project Budget Information subtask.

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

Employee Name

This column will display if you selected the Employee/Vendor Level option in the Project Budget Information subtask. This non-editable column displays the name of the employee selected in the Employee column. This column is optional.

Vendor Employee

This column will display if you selected the Employee/Vendor Level option in the Project Budget Information subtask.

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

Vendor Employee Name

This column will display if you selected the Employee/Vendor Level option in the Project Budget Information subtask. This non-editable column displays the name of the employee selected in the Vendor Employee column. This column is optional.

Total Budget Amt

This column will display if you selected the Employee/Vendor Level option in the Project Budget Information subtask. 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. The system multiplies this amount by the Average Cost Rate or T&M (Time & Materials rate) in the Labor subtask and displays the result in the Total Budget Amt column.

Incurred Hours

This non-editable column displays the actual hours that have been 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 changed. 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.  The system 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 changed.  This column, ETC Hours, the Complete Rate, and LREAC Hours are dynamic; if you change 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 changed.  This column, ETC Hours, the Complete Rate, and ETC Amount are dynamic; if you change these amounts, the remaining columns are recalculated. The system also recalculates these hours by adding the Incurred Hours to the ETC Hours (Incurred + ETC = LREAC).

ETC Rate Amt

This field displays the ETC rate amount for this labor category and can be changed. The system 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.

F.Y.

This non-editable field displays the fiscal year selected in the Update Incurred Costs for ETC subtask.

Pd.

This non-editable field displays the fiscal period selected in the Update Incurred Costs for ETC subtask.

Use Rate

The setting for this non-editable check box defaults from the Use Rate check box in the Project Budget Information subtask. You must select this check box if you are calculating labor rates.