Key Financial Metrics Metrics Tab

When you generate a Key Financial Metrics report, DPS creates the report using the set of metrics you select on the Metrics tab on the Options for Key Financial Metrics dialog box.

Contents

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.