Reports: Supplier Performance

The Suppliers Performance report provides admins with an overall suppliers performance comparison. The report includes the functionality to measure the On-Time, Cycle Time, and Competitiveness for each supplier as seen in the summary and with details for each part. This allows category managers to review analytics specific to how their suppliers are performing in their RFQs and provide accurate information for formulating supplier report cards.

You can access the Suppliers Performance report page from the Reports dropdown in the top navigation bar. It is also accessible from the Supplier and Supplier Intelligence pages.

In the Create A Report left sidebar you can set a date range for supplier RFQ activity, and can be based on: Month, Quarter, Year, or Custom. Next, select the RFQs and suppliers from which you want to pull the data. These can be selected individually by quote and supplier, or use the "Select All" option. Then click on Submit generate the results. 

The report results contain the following functionality:

1. A summary box displaying: a list of the chosen RFQs, suppliers selected, and the report's generated timeframe.
   
2. A report table, with a clickable Supplier Name (1st column), displaying as available:
   • RFQs - the number of RFQs assigned to the supplier within the selected date range.
   • On Time (%) - the number of items where the "Submit Date" is before the "Due Date", and then its percentage. (When there are multiple supplier submit dates, it will check for the date of the last submission.)
   • Late (%) - the number of items where "Submit Date" is after its "Due Date", and then its percentage.
   • No Response - the number of items where "Price 1" is missing and not marked as "No bid". 
   • Items - the number of items assigned to the supplier within that selected date range.
   • Bids - the number of items where the supplier entered a "Price 1".
   • Completeness - the number of items that have a "Price 1" or "No bid" selected /
     the number of all items * 100.
   • Average Response (Days) - how many days passed between the supplier being notified of the RFQ and when they Submitted items / Total items.
     
3. You can export the report table in XLXs.
   
4. Click on a desired supplier to drill down. When a supplier is clicked into, then you will see a summary box for that particular supplier's data split into two segments: RFQ Performance and BID Performance.
   • Assigned RFQs Qty - the sum of all "Qty1" items in the selected RFQs.
   • On Time, Late, No Response, Completeness, & Average Response Days - these are the same as in the previous table, but this display takes into account only the data from selected RFQs.
   • Total Assigned MPNs - the total number of MPNs in the selected RFQs.
   • Total Assigned CPNs - the total number of unique CPNs in the selected RFQs.
   • Total Bid MPN - the number of MPNs where "Price 1" exists in the selected RFQs.
   • Total Bid CPN - the number of unique CPNs that have a "Price 1" in the selected RFQs.
     
5. Below the summary, you will see the detailed supplier's performance by RFQ in the report table.
   • Due Date, Submitted Date, Notified On, Opened On, Responded On, & Accepted
     On - displayed as available within Supplyframe for the RFQs.
   • Cycle time - days between when the supplier was Notified and has Completed the RFQ.
   • Total Cost of Parts quoted by Supplier - sum of "Qty 1" * "Price 1" of RFQ items
   • MPN/CPN Assigned, Bid, & Completeness - same as within the summary, but related to the items in the corresponding RFQs.
   • MPN No Bid - number of items with an MPN marked as "No Bid".
   • CPN No Bid - number of unique CPNs marked as "No Bid".
     
6. You can export the supplier-specific report table in XLXs as well.