Key Ratio - Operational dashboard

The Key Ratio - Operational dashboard contains operational metrics and KPIs that are reported on a regular basis to determine the company's performance over a period of time. Using this dashboard, executives can track business outcomes with associated budget values for improved follow up.

This dashboard can answer these business questions:
  • Are business sales, net income, and profit margin performing well against the budget?
  • How fast can the business convert cash in terms of payments, receivables, and inventory?
  • How much are distributed per account in terms of assets and liabilities?
  • What is the performance of the business sales in reference to the sales force?

Reports and KPIs in this dashboard show the values using the End This Period analysis.

Filters selected in this dashboard are passed to the CFO Dashboard, Balance Sheet, Income Statement, and Key Ratio - Strategic dashboards so you can perform continuous data analysis.

Reports and KPIs

The dashboard contains these reports:
  • Adjusted Sales vs Budget by Period
  • Net Income vs Budget by Period
  • Gross Profit Margin Pct vs Budget by Period
  • Current Assets
  • Current Liabilities
  • Cash Conversion by Period
  • Adjusted Sales per Employee ('000's) by Period

Adjusted Sales vs Budget by Period is displayed in the dashboard as Adjusted Sales by Period.

Net Income vs Budget by Period is displayed in the dashboard as Net Income by Period.

Gross Profit Margin Pct vs Budget by Period is displayed in the dashboard as Gross Profit Margin Pct by Period.

This dashboard also contains these KPIs:
  • Gross Revenue
  • Net Profit Margin Pct
  • DSO
  • DIO

When you select a period in the Fiscal Period filter, the period is shown on the dashboard. The KPIs show the corresponding metrics for that period. Each KPI displays an indicator comparing the Fiscal Period value from the selected Period Comparison filter value (Last Fiscal Period or Fiscal Period Year).

For Gross Revenue and Net Profit Margin Pct KPIs, a green arrow pointing upward indicates an increase in value and a red arrow pointing downward indicates a decrease in value. If there is no change, a yellow square indicator is displayed.

For DSO and DIO KPIs, a green arrow pointing downward indicates a decrease in value and a red arrow pointing upward indicates an increase in value. If there is no change, a yellow square indicator is displayed.

The KPIs use the Accounting Period Date as the date basis for analysis and the Sum aggregation.

Currency information is also displayed on the dashboard.

Filters

These standard filters are available:
  • Division (Config. 5)
  • Fiscal Period (Config. 2)
  • Last N Periods (Config. 1)
  • Period Comparison (Config. 2)

Division, Fiscal Period, Last N Periods, and Period Comparison are mandatory filters.

Drill across

Click <<Back to return to the CFO Dashboard.

Related topics