KPIs

This section describes the KPIs and the formulas used to calculate the KPIs displayed in the dashboard.

Purchase Order

The total purchase orders created during the selected period.

The purchase orders can be calculated using this formula: Purchase Orders = Count of PO Numbers

Net Amt

The amount of all purchase order line items within the selected period. The value represents the total spends associated with the purchase orders.

The purchase order lines can be calculated using this formula: Net Amount = Quantity Ordered Ă— Unit Cost (for each line)

Suppliers

The total unique suppliers with one or more purchase orders during the selected period.

The suppliers can be calculated using this formula: Total Suppliers = count of unique supplier IDs

Top 10 Suppliers Spend Concentration

The percentage of ordered amount from the top ten vendors, ranked by ordered amount, compared to the total ordered amount across all vendors within the current filter context. For example, date, range, site, and buyer.

This KPI applies all active filters, including date range, site, warehouse, company, buyer, category, and currency.

The purchase orders can be calculated using this formula: (Ordered Amount of Top 10 Vendors​/ Total Ordered Amount of All Vendors) * 100