Summary
The Vendor Scorecard is intended to be a screen where you can get some information about the performance of your suppliers. The scorecard can score every supplier type: Vendors, Manufacturers and intersite Warehouses. Only Vendors are included by default; use Supplier Types in Display Options to add the others.
Click Get Insights from Edison beside the page title for an Edison summary across all the suppliers on screen. Edison can draw on every tab of the scorecard.
Display Options
- Supplier Types – Which supplier types to score. Only Vendors are included by default. Add Warehouse to include intersite transfers, or Manufacturer for make items.
- Chart Measure – Which lead time early/late performance is measured against. The default is Planning.
- Time Interval – Group the charts by month (the default) or another interval.
- Date Filter – Filter by Order Creation Date (the default) or Receipt Date.
Column Description
At the top of the screen is the Supplier Performance Overview grid, showing a set of facts about this supplier for the time period in question. StockIQ can load up to 3 years worth of receipt history for your vendor, typically the last year is all that is used for calculating lead times.
NOTE: Date filtering is based on the option selected in Display Options.
- Order Lines - Matching order lines for the orders found for this vendor in the associated time period
- Perfect Lines-the number of lines delivered on time and in full.
- Orders -The number of orders for this supplier in your time period that have at least one receipt. Orders with no receipts yet aren't counted.
- Perfect Orders- the number of orders delivered on time and in full.
- Receipts - How many receipts there have been against these order lines. When filtering by Order Creation Date, receipts on orders placed before your filter date aren't included.
- Expedited- the number of the supplier's receipts flagged as expedited.
- Complete - How many receipts were for the full quantity ordered (note this is not lines)
- Under - how many of those receipts were shipped under the requested order quantity
- Over - how many of those receipts were shipped for more than the requested order quantity
- Early - How many of those receipts were recorded as being before your "Days Early" threshold set in the On Time Tolerance Settings
- On-Time - How many were within your on-time range
- Late - How many receipts were recorded past the "Days Late" threshold in your On Time Tolerance Settings.
- Planning LT - The average measured planning lead time across this supplier's receipts in your time period. This is not the lead time currently used for planning.
- Line SL % - Perfect Lines as a percentage of Order Lines.
- Order SL % - Perfect Orders as a percentage of Orders.
- Excluded (hidden by default)- the number of receipts you've excluded.
NOTE: Receipts you've excluded on the Receipts tab, and receipts your ERP flags as expedited (emergency) shipments, are left out of every figure in this grid except the Expedited and Excluded counts. Expedited receipts are counted separately, because how often a supplier needs expediting is worth knowing on its own.
Detail Tabs
The different tabs of the Vendor Scorecard show details about the vendor you currently have selected in the performance overview grid. All of these values are filtered according to your input filters, so you can view the data for only your requested time period.
Overview Tab
- Timeliness - Shows the numbers and percentages for early/OT/Late for your selected time period and filters. Unknown receipts can't be rated, typically because a date is missing.
- Counts - Shows raw counts of orders, lines, and receipts for your selected time period.
- Lead Time - shows the calculated average LT's based on order and receipt history for orders in your selected period.
-
Delays - Indicates the usual days of delay vs expected from the vendor. Negative numbers mean they beat expectation, positive numbers means they were later than expectation.
- Release - Delay between the expected release day vs actual release of the order
- Ship - Delay between when the order was expected to ship vs when it was actually shipped, based on current expected ship date.
- Delivery - Delay between Expected dock date and actual dock date.
- Ship Vs Orig - Delay between when the order actually shipped vs the ORIGINAL Expected Ship Date
- Delivery vs Orig - Delay between when the order was actually delivered vs the ORIGINAL Expected Dock Date
- Service Level - Shows the order and line service level the vendor has given you.
Timing Tab
This shows a chart of how the supplier's performance is changing over time in terms of # of lines early, late, and on-time. This helps provide a visual to see if performance is improving or worsening with time.
Completeness Tab
Shows a chart of the relative number of orders that are showing Complete / Over / Under over time, again, to see if performance is improving or worsening with time.
Histogram Tab
This tab shows a breakdown of receipts by how many days early and late they are. With enough data, this will usually start to converge on a bit of a bell curve, to show the approximate mean and standard deviation of the vendor's performance. This is based on their delivery to your dock, not the end-to-end putaway time (as they are not responsible for your own putaway delays, if any).
NOTE: This tab is always filtered by receipt date regardless of Display Options
Average Lead Time Tab
Shows the portions of average lead times for each of admin, vendor, shipping, and putaway time, over time, to see if any particular aspect is getting better or worse.
Receipts Tab
This tab shows every single receipt used for measuring the vendor during the time period you've filtered. MANY columns of information are available, see the Receipts Detail Grid topic. You can add/remove/change/group columns in this grid as much as you like and also export it to Excel for additional analysis.
Supplier Review
The Supplier Review is a one-supplier report you can take into a meeting with that supplier. To create one, select a supplier in the Supplier Performance Overview grid, then click Supplier Review on the Overview tab. Edison writes a short review that follows the scorecard tabs in order: Overview, Timing, Completeness, Lead Time, Histogram and Receipts, then expedites and spend. It covers on-time delivery, completeness, lead-time drift and late, short or early receipts, citing specific POs. Each on-time figure states the tolerance band and promised-date basis it uses.
Subscribe: You can also subscribe to get the full Supplier Review by email, on demand or on a schedule. The emailed report includes:
- The supplier's scorecard row, plus its rank and share of spend among the suppliers you can see
- Key figures: the terms used for scoring, payment terms, buying-since date and active item-sites
- Timing, completeness, lead time and spend by month. Lead time is shown next to today's planning lead time, with any drift called out.
- A days early/late spread
- The worst items
- Late or short receipts and early receipts, by PO
- A comparison with earlier reviews: what changed, and whether the worst items are the same ones
- External-safe: Check External-safe before you generate or subscribe to leave out rank, share of spend and exclusion counts. Use this version when you want to share the review with the supplier. The left-out data is never sent to Edison either.
NOTE: Late receipts in the Supplier Review are always measured against the planned receipt date, the same as the Receipt column on the Receipts tab.