| Field | Description |
|---|
| Revenue - YTD
|
This metric is the year-to-date revenue.
|
| Expenses - YTD
|
This metric is the year-to-date expenses (direct, indirect, and other charges).
|
| Profit (incl. OH) - YTD
|
This metric is the year-to-date profit: Revenue - Expenses.
|
| Profit Percentage (incl. OH)-YTD
|
This metric is the year-to-date profit percentage: Profit / Revenue.
|
| Total Outstanding AR
|
This metric is the total amount that has been billed but not yet received.
|
| Outstanding AR (61-90)
|
This metric is the total outstanding amount for billed invoices that are 61-90 days old.
|
| Outstanding AR (91-120)
|
This metric is the total outstanding amount for billed invoices that are 91-120 days old.
|
| Outstanding AR (Over 120)
|
This metric is the total outstanding amount for billed invoices that are over 120 days old.
|
| Average Age of AR
|
This metric is the average age of all accounts receivable.
|
| Cash Balance
|
This metric is the cash balance of the bank accounts for the bank codes.
|
| Utilization - YTD [Target]
|
This metric is the year-to-date target ratio (ratio C). This ratio is the percentage of an employee's time that you expect will be charged to revenue-producing projects. This metric includes terminated employees.
|
| Number of Full-Time Employees
|
This metric is the number of full-time employees at your firm. This number can be the number of hourly employees, salary employees, or both, depending on the option you select under
Number of Full-Time Employees Options on the Employees tab in the Options dialog box. You can also include or exclude inactive employees. (This number never includes terminated employees.)
|
| Unbilled - Total
|
This metric is the total amount of revenue that is not yet billed: Revenue - Billed.
|
| Effective Multiplier - JTD
|
This metric is the job-to-date effective multiplier. The effective multiplier is a productivity measure. It represents the amount of net revenue earned for each labor dollar spent.
DPS calculates net revenue as follows:
Earned Revenue - (Direct and reimbursable expenses)
DPS then calculates the effective multiplier as follows:
Net revenue / Direct labor at cost rates
|
| Opportunity Hit Rate
|
This metric is the percentage of opportunities won out of all opportunities opened.
|
| Actual Overhead Rate -YTD
|
This metric is the year-to-date actual overhead rate.
For the most accurate value, run the Overhead Allocation process before you generate the Key Financial Metrics report:
- If you set the overhead allocation scope to
Firm-wide,
Actual Overhead Rate on this report should match the overhead rate in the header section of the Overhead Allocation report.
- If you set the overhead allocation scope to
by Organization, this report uses the
Effective Rate for the selected organization as listed on the Overhead Allocation report.
- If you include more than one organization in this report,
DPS displays an average of effective rates for all the included organizations.
|
| Indirect Expenses - Current
|
This metric is the indirect expenses for the current accounting period.
|
| Indirect Expenses - YTD
|
This metric is the year-to-date indirect expenses.
|
| Indirect Expenses - Range
|
This metric is the indirect expenses for the period range you specify on the General Ledger tab of the Options dialog box.
|
| Revenue - Current
|
This metric is the revenue for the current accounting period.
|
| Expenses - Current
|
This metric is the total expenses (direct, indirect, and other charges) for the current accounting period.
|
| Profit - Current
|
This metric is the profit amount for the current accounting period:
Revenue - Expenses
|
| Profit Percentage - Current
|
This metric is the profit percentage for the current accounting period:
Profit / Revenue
|
| Revenue - Period Range
|
This metric is the revenue for the period range you specify on the General Ledger tab of the Options dialog box.
|
| Expenses - Period Range
|
This metric is the total expenses for the period range you specify on the General Ledger tab of the Options dialog box.
|
| Profit - Period Range
|
This metric is the profit for the period range you specify on the General Ledger tab.
DPS calculates profit as follows:
Revenue - Expenses
|
| Profit Percentage - Period Range
|
This metric is the profit percentage for the period range you specify on the General Ledger tab.
DPS calculates the profit percentage as follows:
Profit / Revenue
|
| Outstanding AR (Current)
|
This metric is the total outstanding amount for billed invoices that are 0-30 days old.
|
| Outstanding AR (31-60)
|
This metric is the total outstanding amount for billed invoices that are 31-60 days old.
|
| Cash Change - YTD
|
This metric is the difference between the cash balance of the bank account now and the cash balance at the start of the current fiscal year.
|
| Cash Change - Current
|
This metric is the difference between the cash balance of the bank account now and the cash balance at the start of the current accounting period.
|
| Cash Change - Period Range
|
This metric is the difference between the cash balance of the bank account at the beginning of the range of periods and the cash balance at the end of the range of periods.
|
| Utilization - MTD [Direct/Total]
|
This metric is the month-to-date gross chargeable ratio (ratio A):
Direct hours / Total hours
This metric includes terminated employees.
|
| Utilization - YTD [Direct/Total]
|
This metric is the year-to-date gross chargeable ratio (ratio A):
Direct hours / Total hours
This metric includes terminated employees.
|
| Utilization - MTD [Direct/ (Total-Benefit)]
|
This metric is the month-to-date net chargeable ratio (ratio B): Direct hours / (Total hours - Benefit hours)
This metric includes terminated employees.
|
| Utilization - YTD [(Direct/ Total-Benefit)]
|
This metric is the year-to-date net chargeable ratio (ratio B): Direct hours / (Total hours - Benefit hours)
This metric includes terminated employees.
|
| Utilization - MTD [Target]
|
This metric is the month-to-date target ratio (ratio C). This ratio is the percentage of an employee's time that you expect will be charged to revenue-producing projects.
This metric includes terminated employees.
|
| Utilization - MTD [Direct/Std]
|
This metric is the month-to-date ratio D: Direct hours / Standard hours.
This metric includes terminated employees.
|
| Utilization - YTD [Direct/Std]
|
This metric is the year-to-date ratio D: Direct hours / Standard hours
This metric includes terminated employees.
|
| Utilization - MTD [Direct/(Std-Benefit)]
|
This metric is the month-to-date ratio E: Direct hours / (Standard hours - Benefit hours)
This metric includes terminated employees.
|
| Utilization - YTD [(Direct/Std-Benefit)]
|
This metric is the year-to-date ratio E: Direct hours / (Standard hours - Benefit hours)
This metric includes terminated employees.
|
| Billed - Current
|
This metric is the amount billed amount for the current accounting period.
|
| Billed - YTD
|
This metric is the amount billed for the fiscal year to date.
|
| Billed - Total
|
This metric is the total amount billed.
|
| Unbilled - Current
|
This metric is the amount of revenue that is not yet billed for the current accounting period: Revenue - Billed
|
| Unbilled - YTD
|
This metric is the amount of revenue that is not yet billed for the fiscal year to date: Revenue - Billed
|
| Labor Direct Cost - Current
|
This metric is the labor direct cost for the current accounting period.
|
| Labor Direct Cost - YTD
|
This metric is the labor direct cost for the fiscal year to date.
|
| Labor Direct Cost - Total
|
This metric is the total labor direct cost.
|
| Labor Direct Billing - Current
|
This metric is the for the current accounting period.
|
| Labor Direct Billing - YTD
|
This metric is direct labor billing amount for the fiscal year to date.
|
| Labor Direct Billing - Total
|
This metric is total direct labor billing amount.
|
| Labor Indirect Cost - Current
|
This metric is the labor indirect cost for the current accounting period.
|
| Labor Indirect Cost - YTD
|
This metric is the labor indirect cost for the fiscal year to date.
|
| Effective Multiplier - Current
|
This metric is the effective multiplier for the current accounting period. The effective multiplier is a productivity measure. It represents the amount of net revenue earned for each labor dollar spent.
DPS calculates net revenue as follows:
Earned Revenue - (Direct and reimbursable expenses)
DPS then calculates the effective multiplier as follows:
Net revenue / Direct labor at cost rates
|
| Effective Multiplier - YTD
|
This metric is the year-to-date effective multiplier. The effective multiplier is a productivity measure. It represents the amount of net revenue earned for each labor dollar spent.
DPS calculates net revenue as follows:
Earned Revenue - (Direct and reimbursable expenses)
DPS then calculates the effective multiplier as follows:
Net revenue / Direct labor at cost rates
|
| Realization Ratio - Current
|
This metric is the realization ratio for the current accounting period.
The realization ratio compares net revenue earned to labor at billing rates:
Net revenue / Direct labor at billing rates.
|
| Realization Ratio - YTD
|
This metric is the year-to-date realization ratio.
The realization ratio compares net revenue earned to labor at billing rates:
Net revenue / Direct labor at billing rates
|
| Realization Ratio - JTD
|
This metric is the job-to-date realization ratio.
The realization ratio compares net revenue earned to labor at billing rates:
Net revenue / Direct labor at billing rates.
|
| Backlog or Backlog-Project Currency
|
This metric is the monetary value of work that is under contract but that has not yet been earned. Backlog is an indicator of business volume.
DPS calculates backlog as follows:
Total Compensation - Job-to-date revenue. (Total compensation = Compensation + Consultant fee + Reimbursable allowance)
If you use multiple currencies, the column name is
Backlog-Project Currency. For this backlog column,
DPS converts project currency amounts to presentation currency amounts.
|
| Backlog-Billing Currency
|
This column is only available if you are using multiple currencies. It displays the monetary value of work that is under contract but that has not yet been earned. Backlog is an indicator of a firm's business volume.
DPS calculates backlog as follows:
Total Compensation - Job-to-date revenue. (Total compensation = Compensation + Consultant fee + Reimbursable allowance)
For this backlog column,
DPS converts billing currency amounts to presentation currency amounts.
|
| Actual Overhead Rate - Current
|
This metric is the actual overhead rate for the current accounting period. For the most accurate value, run the Overhead Allocation process before you generate the Key Financial Metrics report:
- If you set the overhead allocation scope to
Firm-wide,
Actual Overhead Rate on this report should match the overhead rate in the header section of the Overhead Allocation report.
- If you set the overhead allocation scope to
by Organization, this report uses the
Effective Rate for the selected organization as listed on the Overhead Allocation report.
- If you include more than one organization in this report,
DPS displays an average of effective rates for all the included organizations.
|
