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.
|