Summary
The Vendor Scorecard is intended to be a screen where you can get some information about the performance of your suppliers.
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 order creation date, not the date of any receipt(s) that may exist for a given order.
- Orders - Shows the number of orders placed for a given vendor within the time period specified. For example, if you have filtered for a start date of 1/1/2020, this will show data for all orders placed since 1/1/2020. No data would be shown for orders placed before then.
- Order Lines - Matching order lines for the orders found for this vendor in the associated time period
- Receipts - How many receipts there have been against these order lines. Note that if you have had receipts on orders placed BEFORE your filter date, they are not shown - only receipts against matching orders/lines are displayed.
- Complete - how many of those lines were shipped complete.
- 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 current overall average planning LT for this vendor
- Line SL % - The line-level service level that this supplier is delivering to you, e.g the percent of time they deliver the line on-time and in-full as requested.
- Order SL % - The order-level service level that this supplier is delivering to you, e.g. the percent of time they deliver the entire order on-time and in-full as requested.
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.
- 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)
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.