Project Planning Performance 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.

For each plan, DPS provides a summary section. The contents of those sections depend on the following:

  • Which column the data corresponds to: Planned, Baseline, or EAC.
  • Whether you select Billing or Cost in For Plans Budgeted at Cost and Billing, Use on the Options tab.

Contents

Field Description
Resource

For labor, this column displays the employee number or the generic resource identifier.

For consultants and expenses, this column displays the account name.

Vendor Name This column displays the name of the vendor associated with expenses.
Planned This column displays the planned hours or amount.
JTD This column displays the actual job-to-date (JTD) hours or amount.
ETC This column displays the estimate-to-complete (ETC) hours or amount. This is the estimate of the remaining labor hours or amount needed to complete the work, as of the current date.
EAC This column displays the estimate-at-completion (EAC) hours or amount. This is the current estimate of the total amount or the number of hours that will have been spent or worked at the completion of the plan. DPS calculates the EAC hours or amount as follows: JTD + ETC.
Baseline This column displays the hours or amount in the baseline version of the plan.
Plan - EAC This column displays the variance between the planned hours or amount and the EAC hours or amount.
Plan - JTD This column displays the variance between the planned hours or amount and the JTD hours or amount.
Baseline - JTD This column displays the variance between the hours or amount in the baseline version of the plan and the JTD hours or amount.
EAC Multiplier

This column displays the EAC multiplier for cost.

DPS calculates this multiplier for cost as follows:

(Direct labor fee / EAC labor cost

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

Note:This column will be blank for a plan if the budget type for the plan is Billing or if it is Cost and Billing and you select Billing in For Plans Budgeted at Cost and Billing, Use on the Options tab.

Budget Multiplier

This column displays the estimate at budget multiplier for cost or billing.

DPS calculates this multiplier for cost as follows:

Compensation fee / EAC cost

DPS calculates this multiplier for billing as follows:

Compensation fee / EAC billing

The compensation fee is calculated from the fee entries on the Budget & Revenue tab of the Projects hub in the desktop application.

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

Planned Multiplier

This column displays the planned multiplier for cost or billing. The planned multiplier helps you evaluate how much revenue a plan will return per unit of labor cost or billing.

DPS calculates this multiplier for cost as follows:

(Compensation fee + Consultant fee + Reimbursable allowance) - (Direct expenses + Reimbursable expenses) / Planned labor cost

DPS calculates this multiplier for billing as follows:

(Compensation fee + Consultant fee + Reimbursable allowance) - (Direct expenses + Reimbursable expenses) / Planned labor billing

The fee and reimbursable allowance values come from the fee entries on the Budget & Revenue tab of the Projects hub in the desktop application.

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

Target Multiplier

This column displays the organization's target multiplier for cost or billing.

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

Note: In the current version of DPS, you cannot specify target multipliers for billing, so this column will be blank for a plan if the budget type for the plan is Billing or if it is Cost and Billing and you select Billing in For Plans Budgeted at Cost and Billing, Use on the Options tab.