Use this tab to compare budget amounts to actuals. Your setting in the
Budget Source field on this tab determines whether
DPS draws budget data from the
project budget worksheet in the Accounting application or from the
project plan in the
Projects hub.
Contents
For any field with a blue, underlined amount, click the amount to open the corresponding dialog box of supporting detail. On the supporting detail dialog box you can also click any blue, underlined amount to see another level of detailed data on a second drill-down dialog box.
| Field | Description |
|---|
|
Principal
|
This field displays the
employee at your enterprise who is identified as the
project's
principal. You can drill down on this
employee name to display the
employee's record. You specify the
principal assigned to the
project on the Overview tab of the
Projects hub.
|
|
Project Manager
|
This field displays the
employee at your enterprise who is serving as the
project manager for the
project. You can drill down on this
employee name to display the
employee's record in the
Employees hub. You specify the
project manager assigned to the
project on the Overview tab of the
Projects hub.
|
|
Supervisor
|
This field displays the
employee at your enterprise who is serving as the
supervisor for the
project. You can drill down on this
employee name to display the
employee's record in the
Employees hub. You specify the
supervisor assigned to the
project on the Overview tab of the
Projects hub.
|
| Budget Source
|
If your enterprise uses the Resource Planning module, you can select either of the following as the source of budgeted amounts:
- The budget worksheet in the Accounting application (Budget Worksheet option).
- Tthe
project plan in the
Projects hub.
You select the budget source on the Options dialog box. The budget source impacts the fields that display on the Cost tab. Refer to each field description for details.
|
| Currency
|
If your enterprise uses multiple currencies, this field displays the
project currency.
|
When the
Reporting at Burdened Rates option is selected in Accounting System Settings, labor and overhead are combined and the overhead is estimated using the same calculation that is used when reporting at cost and overhead allocation needs to be run.
Fee Analysis at Cost Rates
Columns
The columns in this section provide an overview of the contract/fee, planned, and profit/loss) amounts for your plan. The columns that display depend on the
project's budget source, your access rights to cost rates, and the
project's charge type: regular, overhead, or promotional).
| Field | Description |
|---|
| Contract/Fee
|
These fields display the user-entered
compensation or fee amount. When you update or change the amount, the planned and profit/loss amounts automatically recalculate.
|
| Plan/Budget
|
These fields display the planned amount at cost, which is pulled from different areas.
|
| Profit/(Loss)
|
These fields display the difference between the contract and planned amount.
|
Rows
The rows of fields display the contract amounts, planned amounts, and profit/loss for the following categories:
| Field | Description |
|---|
|
Compensation
|
This is the sum of all labor and direct expense amounts, which is added to the direct
consultant amount. Any overhead or contingency percentages that are entered are factored into these amounts.
|
| Direct
Consultants
|
This is the direct
consultant fees that your company expects to receive for the
project. This does not include reimbursable
consultant amounts.
|
| Reimbursable Allowance
|
This is the sum of reimbursable
consultant and reimbursable expense amounts.
|
| Total
|
This is the total of all
compensation, direct
consultant, and reimbursable allowance amounts.
|
These amounts are pulled from different areas.
Planning Analysis at Cost
Columns
The columns in this section provide an overview of the actual,
estimate-to-complete (ETC), and
estimate-at-completion (EAC) amounts for your plan. The columns that display depend on the
project's budget source, the use of burden rates, your access rights to cost rates, and the
project's charge type: regular, overhead, or promotional).
| Field | Description |
|---|
| Actual
|
These fields display the actual amounts, which are pulled from different areas.
|
| ETC Starting <date>
|
These fields display the
ETC amounts as of the date displayed.
ETC labor amounts are the sum of the planned amounts from the day after the displayed date forward.
ETC expense and
consultant amounts are the planned amounts less the
job-to-date (JTD) actual amounts through the displayed date.
|
| Estimate-at-Completion
|
These fields display the
EAC amounts: sum of the
JTD actual amounts and
ETC amounts as of the displayed date.
|
Rows
You can read down each row to view the amounts for the following categories:
| Field | Description |
|---|
| Compensation
|
These rows display the actual,
ETC, and
EAC amounts for labor and direct expenses.
|
| Direct
Consultants
|
This row displays the actual,
ETC, and
EAC amounts for direct
consultants. This does not include reimbursable
consultant amounts.
|
| Reimbursable Allowance
|
These rows display the actual,
ETC, and
EAC amounts for reimbursable
consultants and reimbursable expenses.
|
| Total
|
This row displays totals for the preceding rows.
|
Job-to-Date Actual
| Field | Description |
|---|
| Planned Mult
|
This field displays the planned multiplier for cost, which helps you evaluate how much revenue a plan will return per
unit of labor cost. The multiplier is calculated in this way:
Planned Total
Compensation - (Planned Direct and Reimbursable Expenses) / Planned Labor Cost
|
| Effective Mult
|
This field displays the effective multiplier for cost, calculated in this way:
Net Revenue = Revenue / (Direct Expenses + Reimbursable Expenses)
Effective Multiplier = Net Revenue / Direct Labor
|
| Earned Revenue
|
This field displays the amount of earned revenue, which is the actual
job-to-date revenue that is associated with the current period.
|
| Actual Cost
|
This field displays the actual
job-to-date amount that was spent at cost that is associated with the period. This field does not display if you do not have access to cost rates in Security.
|
| Actual Profit $
|
This field displays the actual profit amount, calculated in this way:
Earned Revenue - Actual Cost
This field does not display if the
project's charge type is overhead or promotional.
|
| Profit %
|
This field displays the profit percent, calculated in this way:
|
| Total Profit / Total Earned.
This field does not display if the
project's charge type is overhead or promotional.
|
| % Complete
|
This field displays the percentage of the
project that is complete.
|
| % Expended Hour
|
This field displays the percent expended hours, calculated in this way:
Total Actual Hours / Total Planned Hours
|
| % Expended $
|
This field displays the percent expended amount, calculated in this way:
Total Actual Hours / Total Planned Dollars
|
