Supply Chain Dashboard: Logistics systems and processes can create quite a bit of complexity and confusion. Supply Chain Dashboards provide clarity and tracking.
Thanks goes to the Dashboard Spy who sent me these enterprise dashboard screenshots for a supply chain management system. Lots of interesting KPIs to study here. The application is divided into the following tabs: Home, Alerts, Forecast, Inventory, Reports and KPIs. The first dashboard screenshot shows the home page of the system. The left side acts as both navigation and summary by including the number of each item. For example, in the Tasks portlet, we see that there are 4 Orders to Ship. I presume that clicking on that link will bring up those orders. Likewise, the KPIs section shows the status (red/green/yellow), the KPI name (which is hyperlink to the KPI detail), and the actual value. On the right side are 2 KPI charts. The first is a graph of the Perfect Order Rate (more on how to calculate this KPI later below in this post). The second is the Back Order Rate.
Here is the orders screen:
This is the sales order drill-down:
And here is the KPI Dashboard. Forecast KPIs include: Forecast Accuracy, Supply Plan Variation, Ship to Commit Percent. Inventory KPIs include Inventory Turns, Stock Out Rate, Inventory Aging, Average Days on Hand, Inventory Dollars, Target Inventory Rate, Excess Inventory Average. The Order KPIs include: Perfect Order Rate, Delayed Shipment Rate, Open Returns, Order Fill Rate, Backorder Rate, Closed Returns and Exceptions per Item.
Homework: Do you know what is meant by “Perfect Order”? This supply chain metric calculates the error-free rate of each stage of an order. Here is an explaination from http://www.supplychainmetric.com/perfect.htm
“This measure should capture every step in the life of an order. It measures the errors per order line. An example: your warehouse picks and ships the wrong item. Once the customer receives the order and notices the error, they contact the manufacturer and notify them of the mistake. The manufacturer then enters a credit for the item not shipped and an invoice for the item shipped in its place. For almost all errors that occur, a corrective credit is issued. It is through an analysis of these credits that you derive your metric. Most systems require a “reason code” to be used when entering a credit. Tracking these reason codes and assigning them to a category allow you to group them for the Perfect Order Measure. Sample calculation:
Order Entry Accuracy: 99.95% Correct (5 errors per 1000 order lines)
Warehouse Pick Accuracy: 99.2%
Delivered on Time: 96%
Shipped without Damage: 99%
Invoiced Correctly: 99.8%
Therefore, the Perfect Order Measure is 99.95% * 99.2% * 96% * 99% * 99.8% = 94.04%”
If you want to learn more about the calculations behind supply chain management, start with these books on supply chain metrics.
So what or who is The Dashboard Spy? As his about page states, The Dashboard Spy is just a guy interested in the design of enterprise dashboards. He could not find any executive dashboard design source books (or even screenshots of real business dashboards) and so set about creating his own. Finally convinced to post his extensive collection of dashboard screenshots online, he was amazed to find how popular it has become. If you have a nice screenshot of a digital dashboard, balanced scorecard, or any business intelligence graphic to share, please send an email to info _at_ dashboardspy.com. Also check out The Dashboard Spy’s favorite books on business dashboards.