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.

The following columns are only available if you select Compensation Values by Row & Period in Planning Settings:

• 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, Deltek 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. Deltek 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. Deltek 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. Deltek 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. Deltek 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. Deltek 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. Deltek 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. Deltek 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. Deltek 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. Deltek 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. Deltek 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. Deltek 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 billing currency.
Total Compensation Cost	This column displays the total compensation for the plan, in the plan's cost currency: Compensation Fee + Direct Consultant Fee + Reimbursable Allowance
Total Compensation 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 Deltek 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 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.