KPIs

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

Inventory Value

The total value of on-hand inventory based on the selected filters. For example, entity, site, and warehouse. This value is retrieved from SyteLine using an approved stored procedure or approved query.

Obsolete Inventory Value

The total inventory value for items that are classified as obsolete.

Slow Moving Inventory Value

The total inventory value for items that are classified as slow moving.

This KPI is used to track inventory risks and improve working capital and service levels.

Item Below Safety Stock Count

The count of distinct items with an on-hand quantity below the safety stock level defined at the item warehouse level, based on the selected entity, site, and warehouse filters.

The items can be calculated using this formula: Count distinct (Item, Warehouse) where On Hand Qty < Safety Stock (Item Warehouse)