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 the Compensation Values by Row & Period option is not selected on the General Tab of Planning Configuration, the following columns are not available:

• Compensation Fee

• Consultant Fee

• Reimb Allowance

• 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.
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 + Reimb 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 + Reimb 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 + Reimb 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 + Reimb 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 amount of compensation fees.
Bill Compensation Fee	This column displays the expected amount of compensation fees, calculated at billing rates.
Consultant Fee	This column displays the expected amount of reimbursable consultant fees. This amount includes any markups on consultant professional services.
Bill Consultant Fee	This column displays the expected amount of reimbursable consultant fees, calculated at billing rates.
Reimb Allowance	This column displays the expected amount of reimbursable expense billings.
Bill Reimb Allowance	This column displays the expected amount of reimbursable expense billings, calculated at billing rates.
Total Comp Cost	This column displays the total compensation for the plan, calculated at cost rates: Compensation + Consultant Fee + Reimb Allowance
Total Comp Bill	This column displays the total compensation for the plan, calculated at billing rates: Compensation + Consultant Fee + Reimb 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.