Columns for Labor Summary Report

You can select the columns to display on your report.

Contents

Field	Description
Balance Amount	This column displays the monetary amount remaining to be spent to complete the work, calculated as follows: Budgeted Amount - Job-to-date spent amount.
Balance Hours	This column displays the labor hours remaining to complete the work, calculated as follows: Budgeted Hours - Job-to-date hours
Balance Hours at Budget Rate	This column displays the labor hours remaining to complete the work if they are expended at the budgeted rate. The balance hours are calculated as follows: Balance Amount / Budgeted Rate
Balance Hours at Eff. Rate	This column displays the labor hours remaining to complete the work if they are expended at the current effective rate. The balance hours are calculated as follows: Balance Amount / Effective Rate
Billing Currency Code	This column displays the three-character code for the billing currency.
Budget Amount	This column displays the budgeted amount. If you use Planning, your selection in Budget Source on the Options tab determines whether budget information comes from the project budget worksheet, the associated plan's budget, or the associated plan's baseline.
Budget Hours	This column displays the budgeted hours. If you use Planning, your selection in Budget Source on the Options tab determines whether budget information comes from the project budget worksheet, the associated plan's budget, or the associated plan's baseline.
Budget Rate	This column displays the hourly rate used to calculate budgeted labor amounts.
Current Amount	This column displays the amount of account activity during the current accounting period.
Current Hours	This column displays the total labor hours for the current period. This total includes regular hours, standard overtime hours, and secondary overtime hours.
EAC Amount	This column displays the estimate at completion (EAC) amount for the labor code or expense account for the project, phase, or task. This is the estimate of the total monetary amount that will have been charged to the labor code or expense account at the completion of the project.
EAC Hours	This column displays the estimate at completion (EAC) hours for the labor code for the project, phase, or task. This is the estimate of the total number of hours that will have been charged to the labor code at the completion of the project.
Effective Rate	This column displays the current effective hourly rate, calculated as follows: Job-to-date labor amount at cost rates or at billing rates / Job-to-date labor hours
ETC Amount	This column displays the estimate to complete (ETC) amount. This is the estimate of the total additional monetary amount, beyond that already charged, that will be charged to the labor code or expense account during the completion of the project.
ETC Hours	This column displays the estimate-to-complete (ETC) hours. This is the estimate of the remaining labor hours needed to complete the work, as of the current date.
Functional Currency Code	This column displays the three-character code for the functional currency.
JTD Amount	This column displays the job-to-date labor, overhead, or expense amount spent.
JTD Hours	This column displays the actual job-to-date hours worked.
Pct Budget Expended (Hours)	This column displays the percent of the budget hours expended as of the current date, calculated as follows: JTD Hours / Budget Hours
Pct Complete Reported (Hours)	This column displays the overall percent complete for labor for the task, phase, or project. The percentage is based on cost or billing hours, depending on your selection in Report At. Vantagepoint calculates this percentage based on your selection of budget source on the Budget tab and, if you select one of the planning budget sources, the percent complete formula specified for each of the project plans. Overhead is not included in these calculations.
Pct EAC Expended	This column displays the percent estimate at completion expended for the expense account. The percent estimate at completion expended is the percentage of the estimate at completion amount for the account that has been expended for the task, phase, or project as of the current date. This percentage is calculated as follows: Expenses spent / EAC Amount
Pct ETC Expended	This column displays the percent estimate to complete expended for the expense account. The percent estimate to complete expended is the percentage of the estimate to complete for the account that has been expended on the task, phase, or project as of the current date. This percentage is calculated as follows: Expenses spent / Expenses spent + ETC Amount.
Percent Budget Expended	This column displays the percentage of the budget expended as of the current date, calculated as follows: Job-to-date Spent Amount / Budgeted Amount
Percent Complete Reported	This column displays the overall percent complete. The percentage is based on cost or billing amounts, depending on your selection in Report At. Vantagepoint calculates this percentage based on your selection of budget source on the Budget tab of the Options dialog box and, if you select one of the planning budget sources, the percent complete formula specified for each of the project plans.
Phase	This column displays the phase number.
Project	This column displays the project number.
Project Currency Code	This column displays the three-character code for the project currency.
Row Count	This column displays the row number of a line item.
Task	This column displays the task number.
Traffic Live Project Name	If the project is linked to a job in TrafficLIVE, this column displays the name of the TrafficLIVE project to which the job belongs.
YTD Amount	This column displays the year-to-date labor amount spent.
YTD Hours	This column displays the total labor hours for the current year to date. This total includes regular hours, standard overtime hours, and secondary overtime hours.