KPIs
Net Sales
The total invoiced sales value for the selected time period.
The actual net sales can be calculated using this formula: Sum (Net sales invoice line).
Cost
The total extended cost related with the invoiced lines for the selected time period.
The cost can be calculated using this formula: Sum (Extended cost invoice line).
On Time Delivery Percentage
The percentage of customer orders that are delivered on or before the due date.
The on time delivery percentage can be calculated using this formula: Customer Order line delivered on time / Total Customer Orders * 100.
Delivery within 5 days Percentage
The percentage of customer orders that are delivered on or before five calendar days from the order date.
The delivery within five days percentage can be calculated using this formula: Customer Order line delivered within five days of the order date / Total Customer Orders * 100.
Number of Orders
The total number of customer orders in the selected time period.
The number of orders can be calculated using this formula: Count (Customer order lines).
Net Margin
The profit expressed in percentage after deducting cost from the net sales.
The net margin can be calculated using this formula: (Net sales invoice line – Extended cost invoice line) / Net sales invoice line x 100.