Project Planning Analysis Columns Tab

Use the Columns tab to select or clear columns, change column sequence, provide new column labels, set column widths, or select number and date formats.

If following columns are only available if you select Compensation Values by Row & Period on the General Tab of Planning Configuration:

  • Compensation Fee

  • Direct Labor Fee
  • Direct Expense Fee
  • Direct Consultant Fee

  • Reimbursable Allowance

  • Reimbursable Allowance Expense Fee
  • Reimbursable Allowance Consultant Fee
  • Total Comp Cost

Contents

Field Description
Vendor Name This column displays the name of the vendor.
Planned Quantity This column displays the quantity specified in the plan.
Planned Hours This column displays the labor hours specified in the plan.
Planned Cost This column displays the cost amount specified in the plan.
JTD Quantity This column displays the actual job-to-date quantity
JTD Hours This column displays the actual job-to-date hours worked.
JTD Cost

This column displays the actual job-to-date cost amount.

If you include unposted time, Vision uses billing extensions to calculate the cost of the unposted labor.

ETC Hours This column displays the estimate to complete (ETC) hours. This is the estimate of the remaining planned hours needed to complete the work, as of the current date.
ETC Cost This column displays the estimate to complete (ETC) cost amount. This is the estimate of the remaining planned cost amount needed to complete the work, as of the current date. The ETC is calculated based on the application, Vision or Navigator, in which the plan was created. See the How Planning Calculates ETC online help topic for additional information.
Planned Revenue This column displays the planned revenue amount.
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.
Planned Bill This column displays the billing amount specified in the plan.
JTD Bill This column displays the actual job-to-date billing amount.
Baseline Hours This column displays the hours 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 Bill This column displays the billing amount specified in the baseline version of the plan.
ETC Quantity

This column displays the estimate to complete (ETC) quantity.

This is the estimate of the remaining planned quantity needed to complete the work, as of the current date.

ETC Bill

This column displays the estimate to complete (ETC) billing amount.

This is the estimate of the remaining planned billing amount needed to complete the work, as of the current date.

EAC Hours

This column displays the estimate at completion (EAC) hours.

This is the estimate of the total hours that will be expended to complete the work. Vision calculates estimate-at-completion hours as follows: JTD Hours + ETC Hours.

EAC Cost

This column displays the estimate at completion (EAC) cost amount.

This is the estimate of the total cost that will be expended to complete the work. Vision calculates estimate-at-completion cost as follows: JTD Cost + ETC Cost.

EAC Bill

This column displays the estimate at completion (EAC) billing amount.

This is the estimate of the total amount that will be billed for the completed work. Vision calculates estimate-at-completion billing amounts as follows: JTD Bill + ETC Bill.

JTD Revenue This column displays the actual job-to-date revenue.
Planned – EAC Hours This column displays the variance between the planned hours and the estimate at completion hours.
Planned – EAC Cost This column displays the variance between the planned cost amount and the estimate at completion cost amount.
Planned – EAC Bill This column displays the variance between the planned billing amount and the estimate at completion billing amount.
WBS Level For each element of the plan's work breakdown structure (WBS), the report lists the corresponding WBS level (for example, Project, Phase, or Task).
Project This column displays the project number.
Phase This column displays the phase number.
Task This column displays the task number.
Labor Code For labor transactions, this column displays the labor code.
Start Date This column displays the start date for each task.
End Date This column displays the end date for each task.
Cost Eff Multiplier

This column displays the effective multiplier for cost. Vision calculates the multiplier as follows:

(Job-to-date revenue – Job-to-date expense cost – Job-to-date consultant cost) / Job-to-date labor cost

The report displays this multiplier only in the total line for each plan. It is not displayed for detail lines.

Bill Eff Multiplier

This column displays the effective multiplier for billing. Vision calculates the multiplier as follows:

(Job-to-date revenue – Job-to-date expense billing – Job-to-date consultant billing) / Job-to-date labor billing

The report displays this multiplier only in the total line for each plan. It is not displayed for detail lines.

Cost EAC Multiplier

This column displays the estimate at completion multiplier for cost. Vision calculates the multiplier as follows:

((Compensation Fee + Consultant Fee + Reimbursable Allowance) – (Estimate at completion expense cost + Estimate at completion consultant cost)) / Estimate at completion labor cost

The report displays this multiplier only in the total line for each plan. It is not displayed for detail lines.

Bill EAC Multiplier

This column displays the estimate at completion multiplier for billing. Vision calculates the multiplier as follows:

((Compensation Fee + Consultant Fee + Reimbursable Allowance) – (Estimate at completion expense billing + Estimate at completion consultant billing)) / Estimate at completion labor billing

The report displays this multiplier only in the total line for each plan. It is not displayed for detail lines.

Cost Budget Multiplier

This column displays the budget multiplier for cost. Vision calculates the multiplier as follows:

Compensation Fee / EAC Cost

The report displays this multiplier only in the total line for each plan. It is not displayed for detail lines.

Bill Budget Multiplier

This column displays the budget multiplier for billing. Vision calculates the multiplier as follows:

Compensation Fee / EAC Bill

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. Vision calculates the multiplier as follows:

(Compensation Fee + Consultant Fee + Reimbursable Allowance) / Planned labor cost

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.

Bill Planned Multiplier

This column displays the planned multiplier for billing. Vision calculates the multiplier as follows:

(Compensation Fee + Consultant Fee + Reimbursable Allowance) / Planned labor billing

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.

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.

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.

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 plan's cost currency.
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 plan's billing currency.
Direct Labor Fee This column displays the expected amount of compensation for direct labor, in the plan's cost currency.
Bill Direct Labor Fee This column displays the expected amount of compensation for direct labor, in the plan's billing currency.
Direct Expense Fee This column displays the expected amount of compensation for direct expense, in the plan's cost currency.
Bill Direct Expense Fee This column displays the expected amount of compensation for direct expense, in the plan's billing currency.
Direct Consultant Fee This column displays the expected amount of direct consultant fees, in the plan's cost currency. This amount includes any markups on consultant professional services.
Bill Direct Consultant Fee This column displays the expected amount of direct consultant fees, in the plan's billing currency.
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 plan's cost currency.
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 plan's billing currency.
Reimbursable Allowance Expense Fee This column displays the expected amount of reimbursable non-consultant expense, in the plan's cost currency.
Bill Reimbursable Allowance Expense Fee This column displays the expected amount of reimbursable non-consultant expense, in the plan's billing currency.
Reimbursable Allowance Consultant Fee This column displays the expected amount of reimbursable consultant expense, in the plan's cost currency.
Bill Reimbursable Allowance Consultant Fee This column displays the expected amount of reimbursable consultant expense, in the plan's biling currency.
Total Comp Cost

This column displays the total compensation for the plan, in the plan's cost currency:

Compensation Fee + Direct Consultant Fee + Reimbursable Allowance

Total Comp Bill

This column displays the total compensation for the plan, in the plan's billing currency.:

Bill Compensation Fee + Bill Direct Consultant Fee + Bill Reimbursable Allowance

Pct Complete Cost If you selected User-Entered Pct Complete for the percent complete calculation method for the plan, this column displays the cost amount for the percentage completed to date.
Pct Complete Bill If you selected User-Entered Pct Complete for the percent complete calculation method for the plan, this column displays the billing amount for the percentage completed to date.
Create User This column displays the Vision user ID of the employee who created the plan. The report displays the user ID only in the total line for each plan.
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.
Modify User This column displays the Vision 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.
Modify Date This column displays the date on which the plan was most recently modified. The report displays this date only in the total line for each plan.