Supply Chain Management Dashboard Screenshot - Key Performance Indicators & Metrics for Forecast, Inventory, Orders
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.
Was this enterprise dashboard interesting enough to share? Help spread the news about Dashboards By Example. Click on the "Share" icon above to submit this post to your social bookmark service or email the link to a fellow dashboarder or even yourself.
What do you think about this dashboard post? Please leave a comment. Your opinions are valuable to the entire business dashboarding community.
Leave a Reply
Dashboard Spy Readers: See these related Business Intelligence Dashboard posts:
- A Wholesale Business Dashboard - tracking customers, orders, fulfillment, shipping, returns ...
- Oracle JD Edwards Plant Management Dashboard ...
- Drug Supply Dashboard - Using Executive Dashboards in AIDS Treatment & Research in Rwanda ...
- Sales Pipeline Enterprise Dashboard - Opportunity Metrics Analysis ...
- Airline Ticket Processing Dashboard - Example of a Business Service Management Dashboard ...
- A corporate performance executive dashboard ...
- Banking Dashboard - Risk Concentration Screen ...
- Pick a KPI, any KPI - Using visual size and color to show trending data on dashboards ...
Latest posts of interest to the business intelligence dashboarding community - Have you read these recent enterprise dashboard posts?
- Project Gemini and Excel Dashboards
- Bling My Dashboard
- Direct Marketing Metrics Dashboard
- Pop-Up Dashboard for 2008 Election Results
- Synchronized Presidential Debates Dashboard-Style
- 2008 Political Dashboards for the Election Home Stretch
- Intranets, Portals and Dashboards, Oh My!
- Real Time Excel Dashboard Tracks Gas Prices
- CERN Collider Dashboard
- Dashboards As Navigation


