SCM Overview Analytics

You can understand about SCM Overview Analytics

Supply Chain Management Overview helps analyze and understand the inventory levels, Purchase Orders, and Vendors.

 

SCM Overview Analytics helps you to focus on key aspects of Supply Chain management i.e, Purchasing (sourcing), Planning (scheduling) and Logistics (delivery/returns).

 

One of the most prominent goals of supply chain management is to contribute to the organization’s financial performance. Historically, cost-cutting strategies have focused on streamlining stock levels to reduce inventory carrying costs,

 

SCM Overview Analytics is designed to present below KPIs and Insights

KPI

Insights

Total Inventory Items

 

This Metric lets you know how many Total inventory items are in your store.

 

Total Purchase Order Value

 

 

 

This Metric lets you know how much the Total purchased cost for the selected range and base period.

 

Estimated Reordering Cost for scheduled services

 

Metrics to understand Estimated Reordered Cost To complete Scheduled Services.

 

 

Purchase Order by Status

 

 

 

 

 

It will help to know the status of the purchase order. like how many orders are accepted, how many orders are pending, and how many are billed.

Inv. Stock Availability

 

 

 

To understand your warehouse by Items that are `In stock` vs `Out of Stock` vs Items to `Reorder`

 

Purchase Order Value on Inventory over time

 

 

Metric to understand the money spent on the inventory for the selected date period. Total cost by Month based on the selected date range and base period.

 

Material Procurement vs Utilization vs Availability [Top 5]

 

 

 

Top 5 items that are more stocked and less used

Listed with informative fields like ItemName, Total Stocked, Total Used, Available Qty.

 

Available stock per Material

[Top 5]

 

 

 

Provides you with a list of items that are `In Stock.

Items to Reorder for Services that are Scheduled

 

 

 

Provides you with a list of items that need to be Reordered to complete Services that are Scheduled.

Listed with informative fields like ItemName, Available Qty, Required Qty, and Reorder Cost.

 

Top 10 Purchase Orders created

 

 

 

Detailed metrics Report helps you to understand your purchase orders.

 

Calculation

 

Available Qty = Total Stocked - Total Usage (completed Services)

 

Qty to be Reordered = The minimum amount of inventory before more inventory needs to be ordered to complete Scheduled and Pending Services

 

Estimated Reordering Cost For Scheduled and Pending = Reordering Qty For Scheduled and Pending * Unit Price

 

ReorderCost = (QtyToReorderForServices * UnitCost)

 

Out Of Stock = (AvailableQty = 0)

 

In Stock = (AvailableQty >= QtyRequiredForServices )

 

To Reorder = (QtyRequiredForServices > AvailableQty)

 

Here are the business constraints that are applied.

  1. Only active Items are considered.

  2. Non Inventory items are not considered.

 

Importance of Supply Chain Management Overview Analytics & Benefits

  • This dashboard helps strike the right inventory balance to keep costs as low as possible without stock-outs.

  • Excess inventory leads to higher-than-necessary inventory carrying costs while running out of items means lost sales.

  • Stock costs money until it sells. Carrying costs include storage handling and transportation fees. Inventory is also at risk of theft, loss from natural disasters, or obsolescence.