Columns for Project Planning Analysis

You can select the columns to display on your report.

Contents

Field	Description
Baseline Bill	This column displays the billing amount specified in the baseline version of the plan.
Baseline Cost	This column displays the cost amount specified in the baseline version of the plan.
Baseline Hours	This column displays the hours specified in the baseline version of the plan.
Bill Budget Multiplier	This column displays the budget multiplier for billing. Vantagepoint calculates the multiplier as follows: Compensation Fee / EAC Bill The compensation fee is calculated from the fee entries on the Project Review form of the Projects hub. The report displays this multiplier only in the total line for each plan. It is not displayed for detail lines.
Bill Compensation Fee	This column displays the expected total amount of compensation from direct labor and expense: Bill Direct Labor Fee + Bill Direct Expense Fee. The amount is in the project's billing currency. This amount is calculated from the fee entries on the Project Review form of the Projects hub.
Bill Direct Consultant Fee	This column displays the expected amount of direct consultant fees, in the project's billing currency. This fee is entered on the Project Review form of the Projects hub.
Bill Direct Expense Fee	This column displays the expected amount of compensation for direct expense, in the project's billing currency. This fee is entered on the Project Review form of the Projects hub.
Bill Direct Labor Fee	This column displays the expected amount of compensation for direct labor, in the project's billing currency. This fee is entered on the Project Review form of the Projects hub.
Bill Planned Multiplier	This column displays the planned multiplier for billing. Vantagepoint calculates the multiplier as follows: (Compensation Fee + Consultant Fee + Reimbursable Allowance) / Planned labor billing The fee and reimbursable allowance values come from the fee entries on the Project Review form of the Projects hub. The report displays this multiplier only in the total line for each plan. It is not displayed for detail lines. The planned multiplier helps you evaluate how much revenue a plan will return per unit of labor billing.
Bill Reimbursable Allowance	This column displays the expected total amount of reimbursable expenses, calculated at billing rates: Bill Reimbursable Allowance Expense Fee + Bill Reimbursable Allowance Consultant Fee. The amount is in the project's billing currency. This fee is entered on the Project Review form of the Projects hub.
Bill Reimbursable Allowance Consultant Fee	This column displays the expected amount of reimbursable consultant expense, in the project's billing currency. This fee is entered on the Project Review form of the Projects hub.
Bill Reimbursable Allowance Expense Fee	This column displays the expected amount of reimbursable non-consultant expense, in the project's billing currency. This fee is entered on the Project Review form of the Projects hub.
Bill Target Multiplier	This column displays the organization's target multiplier for billing. The report displays this multiplier only in the total line for each plan. It is not displayed for detail lines. In the current version of Vantagepoint, you cannot specify target multipliers for billing, so this column will be blank if you include it on the report.
Compensation Fee	This column displays the expected total amount of compensation from direct labor and expense: Direct Labor Fee + Direct Expense Fee. The amount is in the project's cost currency. This amount is calculated from the entries on the Project Review form of the Projects hub.
Cost Budget Multiplier	This column displays the budget multiplier for cost. Vantagepoint calculates the multiplier as follows: Compensation Fee / EAC Cost The compensation fee is calculated from the fee entries on the Project Review form of the Projects hub. The report displays this multiplier only in the total line for each plan. It is not displayed for detail lines.
Cost Estimate-at-Completion Multiplier	This column displays the EAC multiplier for cost. Vantagepoint calculates the multiplier as follows: ((Compensation Fee + Consultant Fee + Reimbursable Allowance) – (EAC expense cost + EAC consultant cost)) / EAC labor cost The fee and reimbursable allowance values come from the fee entries. The report displays this multiplier only in the total line for each plan. It is not displayed for detail lines.
Cost Planned Multiplier	This column displays the planned multiplier for cost. Vantagepoint calculates the multiplier as follows: (Compensation Fee + Consultant Fee + Reimbursable Allowance) / Planned labor cost The fee and reimbursable allowance values come from the fee entries on the Project Review form of the Projects hub. The report displays this multiplier only in the total line for each plan. It is not displayed for detail lines. The planned multiplier helps you evaluate how much revenue a plan will return per unit of labor cost.
Cost Target Multiplier	This column displays the organization's target multiplier for cost. The report displays this multiplier only in the total line for each plan. It is not displayed for detail lines.
Create Date	This column displays the date on which the plan was created. The report displays this date only in the total line for each plan.
Create User	This column displays the Vantagepoint user ID of the employee who created the record.
Direct Consultant Fee	This column displays the expected amount of direct consultant fees, in the project's cost currency. This amount includes any markups on consultant professional services. This fee is entered on the Project Review form of the Projects hub.
Direct Expense Fee	This column displays the expected amount of compensation for direct expense, in the project's cost currency. This fee is entered on the Project Review form of the Projects hub.
Direct Labor Fee	This column displays the expected amount of compensation for direct labor, in the project's cost currency. This fee is entered on the Project Review form of the Projects hub.
Estimate-at-Completion Bill	This column displays the EAC billing amount. This is the estimate of the total amount that will be billed for the completed work. Vantagepoint calculates EAC billing amounts as follows: JTD Bill + ETC Bill.
Estimate-at-Completion Cost	This column displays the EAC) cost amount. This is the estimate of the total cost that will be expended to complete the work. Vantagepoint calculates EAC cost as follows: JTD Cost + ETC Cost.
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.
Employee/ Account Number	For labor transactions, this column displays the employee number (also called the resource number). For expense or consultant transactions, this column displays the expense account number.
End Date	This column displays the end date for each task.
Estimate-to-Complete Bill	This column displays the ETC billing amount. This is the estimate of the remaining planned billing amount needed to complete the work, as of the current date.
ETC Cost	This column displays the ETC cost amount. This is the estimate of the remaining planned cost amount needed to complete the work, as of the current date.
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.
Job-to-Date Bill	This column displays the actual job-to-date billing amount.
JTD Cost	This column displays the actual job-to-date cost amount. If you include unposted time, Vantagepoint uses billing extensions to calculate the cost of the unposted labor.
JTD Hours	This column displays the actual job-to-date hours worked.
Labor Code	This column displays the labor code for the transaction.
Location	This column displays the location where the activity occurred or will occur.
Modify User	This column displays the user ID of the employee who most recently modified the plan. The report displays the user ID only in the total line for each plan.
Percent Complete Bill	This column displays the billing amount for the percentage completed to date.
Percent Complete Cost	This column displays the cost amount for the percentage completed to date.
Phase Number	This column displays the phase number.
Planned - EAC Bill	This column displays the variance between the planned billing amount and the EAC billing amount.
Planned - EAC Cost	This column displays the variance between the planned cost amount and the EAC cost amount.
Planned - EAC Hours	This column displays the variance between the planned hours and the EAC hours.
Planned Bill	This column displays the billing amount specified in the plan.
Planned Cost	This column displays the cost amount specified in the plan.
Planned Hours	This column displays the labor hours specified in the plan.
Project Number	This column displays the project number.
Reimbursable Allowance	This column displays the expected total amount of reimbursable expenses: Reimbursable Allowance Expense Fee + Reimbursable Allowance Consultant Fee. The amount is in the project's cost currency. This amount is calculated from the fee entries on the Project Review form of the Projects hub.
Reimbursable Allowance Consultant Fee	This column displays the expected amount of reimbursable consultant expense, in the project's cost currency. This fee is entered on the Project Review form of the Projects hub.
Reimbursable Allowance Expense Fee	This column displays the expected amount of reimbursable non-consultant expense, in the project's cost currency. This fee is entered on the Project Review form of the Projects hub.
Row Count	This column displays the total number of detail lines for each group, based on the sorting and grouping selections. If the report groups data at more than one level, this column displays row counts for all grouping levels.
Start Date	This column displays the start date for each task.
Task Number	This column displays the task number.
Total Compensation Bill	This column displays the total compensation for the plan, in the project's billing currency: Bill Compensation Fee + Bill Direct Consultant Fee + Bill Reimbursable Allowance This amount is calculated from the fee entries on the Project Review form of the Projects hub.
Total Compensation Cost	This column displays the total compensation for the plan, in the project's cost currency: Compensation Fee + Direct Consultant Fee + Reimbursable Allowance This amount is calculated from the fee entries on the Project Review form of the Projects hub.
Vendor Name	This column displays the name of the vendor associated with expenses.
WBS Level	For each element of the plan's WBS, the report lists the corresponding WBS levels (Project, Phase, or Task). The number of plan project levels enabled in your WBS depends upon which modules are activated. For example: If both the Resource Planning module and the Accounting module are activated, you can only plan projects at the levels enabled in your WBS, up to a maximum of three levels. If the Resource Planning module is activated but the Accounting module is not, you can plan the 3 WBS levels (project, phase, and task) followed by columns for Plan Level 4, Plan Level 5, and so on up through Plan Level 17. If the maximum plan level selected is greater than the levels a project has, this report displays only those levels down to the project's lowest level. For example, if you choose to see 17 levels but the project only has 5, the report lists all the levels up to level 5 only for the project, not through level 17.