| Field | Description |
|---|
| Vendor Name
|
This column displays the name of the vendor.
|
| 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 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,
DPS 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 labor hours needed to complete the work, as of the current date.
|
| ETC Cost
|
This column displays the ETC cost amount. This is the estimate of the remaining planned cost amount needed to complete the work, as of the current date.
|
| 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 Bill
|
This column displays the 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.
DPS calculates EAC hours as follows:
JTD Hours +
ETC Hours.
|
| EAC Cost
|
This column displays the EAC) cost amount. This is the estimate of the total cost that will be expended to complete the work.
DPS calculates EAC cost as follows:
JTD Cost +
ETC Cost.
|
| EAC Bill
|
This column displays the EAC billing amount. This is the estimate of the total amount that will be billed for the completed work.
DPS calculates EAC billing amounts as follows: JTD Bill + ETC Bill.
|
| Planned - EAC Hours
|
This column displays the variance between the planned hours and the EAC hours.
|
| Planned - EAC Cost
|
This column displays the variance between the planned cost amount and the EAC cost amount.
|
| Planned - EAC Bill
|
This column displays the variance between the planned billing amount and the EAC billing amount.
|
| WBS Levels
|
For each element of the plan's WBS, the report lists the corresponding WBS levels (Project, Phase, or Task). The number of plan project and opportunity levels enabled in your WBS depends upon which modules are activated. For example:
- If both Resource Planning module and the Accounting module are activated, you can only plan projects and opportunities at the levels enabled in your WBS, up to a maximum of three levels.
- If the Resource Planning module is activated but the Accounting module is not, you can plan the 3 WBS levels (project, phase, and task) followed by columns for Plan Level 4, Plan Level 5, and so on up through Plan Level 17. If the maximum plan level selected is greater than the levels a project has, this report will display only those levels down to the project's lowest level. For example, of you choose to see 17 levels but the project only has 5, the report will list all the levels up to level 5 only for the project, not through level 17.
|
| 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 EAC Multiplier
|
This column displays the EAC multiplier for cost.
DPS calculates the multiplier as follows:
((Compensation Fee + Consultant Fee + Reimbursable Allowance) – (EAC expense cost + EAC consultant cost)) / EAC labor cost
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.
|
| Bill EAC Multiplier
|
This column displays the EAC multiplier for billing.
DPS calculates the multiplier as follows:
((Compensation Fee + Consultant Fee + Reimbursable Allowance) – (EAC expense billing + EAC consultant billing)) / EAC 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.
|
| Cost Budget Multiplier
|
This column displays the budget multiplier for cost.
DPS calculates the multiplier as follows:
Compensation Fee / EAC Cost
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.
|
| Bill Budget Multiplier
|
This column displays the budget multiplier for billing.
DPS calculates the multiplier as follows:
Compensation Fee / EAC Bill
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.
|
| Cost Planned Multiplier
|
This column displays the planned multiplier for cost.
DPS calculates the multiplier as follows:
(Compensation Fee + Consultant Fee + Reimbursable Allowance) / Planned labor cost
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.
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.
DPS calculates the multiplier as follows:
(Compensation Fee + Consultant Fee + Reimbursable Allowance) / 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.
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.
Note: In the current version of
DPS, you cannot specify target multipliers for billing, so this column will be blank if you include it on the report.
|
| 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 project's cost currency.
This amount is calculated from the entries on the Budget & Revenue tab of the Projects hub in the desktop application.
|
| 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 project's billing currency.
This amount is calculated from the fee entries on the Budget & Revenue tab of the Projects hub in the desktop application.
|
| Direct Labor Fee
|
This column displays the expected amount of compensation for direct labor, in the project's cost currency.
This fee is entered on the Budget & Revenue tab of the Projects hub in the desktop application.
|
| Bill Direct Labor Fee
|
This column displays the expected amount of compensation for direct labor, in the project's billing currency.
This fee is entered on the Budget & Revenue tab of the Projects hub in the desktop application.
|
| Direct Expense Fee
|
This column displays the expected amount of compensation for direct expense, in the project's cost currency.
This fee is entered on the Budget & Revenue tab of the Projects hub in the desktop application.
|
| Bill Direct Expense Fee
|
This column displays the expected amount of compensation for direct expense, in the project's billing currency.
This fee is entered on the Budget & Revenue tab of the Projects hub in the desktop application.
|
| Direct Consultant Fee
|
This column displays the expected amount of direct consultant fees, in the project's cost currency. This amount includes any markups on consultant professional services.
This fee is entered on the Budget & Revenue tab of the Projects hub in the desktop application.
|
| Bill Direct Consultant Fee
|
This column displays the expected amount of direct consultant fees, in the project's billing currency.
This fee is entered on the Budget & Revenue tab of the Projects hub in the desktop application.
|
| 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 project's cost currency.
This amount is calculated from the fee entries on the Budget & Revenue tab of the Projects hub in the desktop application.
|
| 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 project's billing currency.
This fee is entered on the Budget & Revenue tab of the Projects hub in the desktop application.
|
| Reimbursable Allowance Expense Fee
|
This column displays the expected amount of reimbursable non-consultant expense, in the project's cost currency.
This fee is entered on the Budget & Revenue tab of the Projects hub in the desktop application.
|
| Bill Reimbursable Allowance Expense Fee
|
This column displays the expected amount of reimbursable non-consultant expense, in the project's billing currency.
This fee is entered on the Budget & Revenue tab of the Projects hub in the desktop application.
|
| Reimbursable Allowance Consultant Fee
|
This column displays the expected amount of reimbursable consultant expense, in the project's cost currency.
This fee is entered on the Budget & Revenue tab of the Projects hub in the desktop application.
|
| Bill Reimbursable Allowance Consultant Fee
|
This column displays the expected amount of reimbursable consultant expense, in the project's billing currency.
This fee is entered on the Budget & Revenue tab of the Projects hub in the desktop application.
|
| Total Compensation Cost
|
This column displays the total compensation for the plan, in the project's cost currency:
Compensation Fee + Direct Consultant Fee + Reimbursable Allowance
This amount is calculated from the fee entries on the Budget & Revenue tab of the Projects hub in the desktop application.
|
| Total Compensation Bill
|
This column displays the total compensation for the plan, in the project's billing currency.:
Bill Compensation Fee + Bill Direct Consultant Fee + Bill Reimbursable Allowance
This amount is calculated from the fee entries on the Budget & Revenue tab of the Projects hub in the desktop application.
|
| 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
DPS 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.
|
