Supplier KPI Dashboard for a Distribution Business

    What is a Supplier KPI Dashboard ? Supplier KPI dashboards are considered important analysis tools and are used by analysts and purchasing managers to monitor the performance of their suppliers. Some of the main functionality in this type of dashboard is that it is parameter-driven and helps the user analyze the company's suppliers from six perspectives: 1) Cost per drop, 2) Back order rate versus perfect order rate, 3) Length of transit (hours) versus production time, 4) Purchase trend, 5) Top 10 items, and 6) Top 10 suppliers. You find an example of this type of dashboard below. Purpose of Supplier KPI Dashboards Distribution businesses use Supplier KPI Dashboards for monthly performance tracking of their suppliers. When used as part of good business practices in Financial Planning & Analysis (FP&A) and Purchasing departments, a company can improve its supply chain, product quality and efficiency. It can also reduce the chances that major disruptions or cost issues occur due to avoidable supplier problems. Supplier KPI Dashboard Example Here is an example of a Supplier KPI Dashboard for a distribution business, with monthly trends and top ten item and supplier rankings. [caption id="" align="alignnone" width="2560"] Example of a Supplier KPI Dashboard for a Distribution Business Example of a Supplier KPI Dashboard for a Distribution Business[/caption] You can find hundreds of additional examples here Who Uses This Type of Dashboard ? The typical users of this type of dashboard are: COOs, purchasing/procurement managers, analysts. Other Dashboard s Often Used in Conjunction with Supplier KPI Dashboards Progressive Financial Planning & Analysis (FP&A), Purchasing and operational departments sometimes use several different Supplier KPI Dashboards, along with  inventory reports, inventory dashboards, demand and supply forecasts, sales budgets, margin reports, quality reports and other management and control tools. Where Does the Data for Analysis Originate From? The Actual (historical transactions) data typically comes from management systems or enterprise resource planning (ERP) systems like: Microsoft Dynamics 365 (D365) Finance, Microsoft Dynamics 365 Business Central (D365 BC), Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP, Microsoft Dynamics SL, Sage Intacct, Sage 100, Sage 300, Sage 500, Sage X3, SAP Business One, SAP ByDesign, Acumatica, Netsuite and others. In analyses where budgets or forecasts are used, the planning data most often originates from in-house Excel spreadsheet models or from professional corporate performance management (CPM/EPM) solutions. What Tools are Typically used for Reporting, Planning and Dashboards? Examples of business software used with the data and ERPs mentioned above are:
    • Native ERP report writers and query tools
    • Spreadsheets (for example Microsoft Excel)
    • Corporate Performance Management (CPM) tools (for example Solver)
    • Dashboards (for example Microsoft Power BI and Tableau)
    Corporate Performance Management (CPM) Cloud Solutions and More Examples
    January 30, 2021