Operating and Cash Management

This widget displays the YTD data for four KPIs.
Note: 
  • The KPI displays the data for the selected fiscal period as well as all prior fiscal periods within the same year.
  • The Group Company and Taxonomy fields must be defined in the Filter section.

These KPIs are displayed in this widget:

Cash Cycle
The Cash Conversion Cycle (CCC) measures the number of days required to sell inventory, collect receivables, and pay bills. You can view the cash cycle days and target days in this KPI.

Formula: Cash Cycle= Days of Inventory Outstanding (DIO) + Days Sales Outstanding (DSO) - Days Payable Outstanding (DPO)

For this KPI:

  • If the actual value is positive, the value is displayed in Red colour.
  • If the actual value is negative, the value is displayed in Green colour.
Days Sales Outstanding (DSO)
Days sales outstanding (DSO) measures the average number of days a company required to collect receivables. You can view the DSO days and target days in this KPI.

Formula: DSO= Number of days * Receivables / Revenues

For this KPI:

  • If the actual value is positive, the value is displayed in Red colour.
  • If the actual value is negative, the value is displayed in Green colour.
Days Inventory Outstanding (DIO)
Days payable outstanding (DIO) measures the average number of days a company required to sell the inventory. You can view the DIO days and target days in this KPI.

Formula: DIO= Number of days * Inventories / COGS

For this KPI:

  • If the actual value is positive, the value is displayed in Red colour.
  • If the actual value is negative, the value is displayed in Green colour.
Days Payable Outstanding (DPO)

Days inventory outstanding (DIO) measures the average number of days a company required to pay suppliers. You can view the DPO days and target days in this KPI.

Formula: DPO= Number of days * Payables / COGS

For this KPI:

  • If the actual value is negative, the value is displayed in Red colour.
  • If the actual value is positive, the value is displayed in Green colour.