KPI Trends

Built on the Microsoft SQL Server Reporting Services (SSRS) platform, this application directly illustrates your ERP performance against twenty-one industry standard supply chain metrics from four areas:

• Overall System Metrics work to gauge the overall operation of the system.  No system can work effectively or efficiently if these metrics do not report a high level of accuracy. 
• Outbound Performance Metrics provide fundamental data for how well we are making and keeping promises to our customers and the resulting profit for our stakeholders. 
• Internal Supply Chain Performance Metrics provide fundamental data for how well we are using the system to manage the flow of material from our suppliers, through the internal supply chain, and out to our customers. 
• Inbound Performance Metrics provide fundamental data for how well we are scheduling and coordinating with our suppliers and the resulting impact on product costs. 

Using SQL Server technologies your detailed data is collected, summarized and processed automatically (i.e., daily, weekly, monthly) so that information is ready anytime you need it.  This enables you to "see" areas that require further management attention and design proper action.

Obtaining simultaneous improvement across a group of metrics requires strong leadership and cross-functional collaboration in designing/improving business processes.  These metrics will help drive that action.

Overall System Performance

Order Date Realism*

Projected Inventory

Outbound Performance

Shipping Performance 

Quoted Lead-time 

Aged Sales Orders

Open Sales Orders Pivot Report

Sales Invoices Pivot Report

Gross Profit Trend

Internal Supply Chain Performance

ABC Analysis

Inventory Turns

Inventory Analysis

Safety Stock 

OSA Analysis

Shortage Trend*

Work in Process

Scrap Report*

Inventory Accuracy* 

Cycle Count Accuracy*

Inbound Performance

Supplier Performance

Lead Time Analysis

Purchase Price Variance Trend (based upon Work General Ledger – for integrated users)

Purchase Price Variance Trend (based upon PO Receipts – for non-integrated users)

* = New in 2020.

More information can be found in the "Downloads" section below.