Vendors
In the top navigation bar, Vendors will take you to a dedicated page that gives an overview of active vendors and their performance, enabling you to measure and manage your supply base.
Vendor Workflow
The first half of the article will focus on the user workflow, while the details will be found towards the end.
Vendor Overview
When the user clicks on Vendors in the navigation bar, an overview of all vendors is shown
The user is greeted with four KPI's on top:
Top 3 vendors, ranked by highest purchase value
Total stock value across all vendors
Total number of received purchase order deliveries
On time - Delivery performance measurement
Below is a list of active vendors with insightful information such as: the lead time days, delivery performance, measured lead time, number of deliveries, purchased value, stock holding cost and many more.
By clicking on a vendor name, a new vendor page will open with vendor specific details
Vendor specific details
In this page, the user is looking at one vendor, and starts in the "overview" tab. to navigate to the Lead time analysis, the user must click on the "Lead time analysis or the purple ->] icon.
There are two information blocks at the top:
General
lead time analysis
showing vendor specific settings and measurements, enabling the user to f.ex override the system lead time (pencil icon) with the Avg lead time from the Lead time analysis info.
The bottom half displays a list of items that are marked in the ERP with this vendor as the primary vendor.
The user can view the stock and sales on the sku level ( stock keeping unit, [item + location] level) by expanding the > item no.
It can give insights to sort the items by highest stock value or sale value.
For further detail, the user can click the [open in items] button, mid screen to the right.
Lead time analysis
By clicking on the lead time analysis a new page opens, see Lead time analysis article
Vendors KPI details, settings & columns
Below is a section that explains the details of the Vendors KPI's, system settings and information columns.
Vendors KPIโs - details
The KPI's are intended to highlight interesting data points depending on where customer is in the system.
Vendor Overview KPI's | Description |
Top vendors
| This KPI Displays the top 3 vendors by purchase value in last 12 months The default is 12 months, this can be changed in settings, see later in article.
|
Total Stock value | The total stock value shows the sum of stock value across all active suppliers: (stock units * item's cost price)
Current cost price from the ERP's item card |
Total number of deliveries
| This KPI shows the total number of deliveries in the last 12 months (default setting) from all active vendors.
Each delivery is counted as [Purchase order number + order date + delivery date]
(to allow for multiple deliveries per order) |
On time delivery performance
| Measurement of on time deliveries across all active suppliers.
Measured on Purchase order level, as by settings: first delivery, last delivery date. users can exclude single PO's from the measurements in the lead time analysis |
Vendors Lead time analysis settings
Navigate to the cogwheel icon > settings
General > Lead time analysis (scroll down to the bottom)
These are global settings, controlling calculations in the vendor overview and the Lead time Analysis.
Lead time & vendor settings | Description |
On time buffer days | An option to add buffer to the on time measurement: system lead time vs actual lead time. Often used for estimating internal inbound receiving time, days after arrival before it has physically arrived in the receiving site. |
Lead time calculation method | The lead time analysis is measured on the Purchase order as a whole, the user can choose to measure against the first delivery, last delivery or to ignore orders with multiple delivery dates. |
Number of months for calculations | Time horizon to include for lead time analysis, impacts KPI's for Purchased value, number of deliveries, On time delivery performance, Avg lead time, min & max lead time |
Number of purchase orders | A sub rule after the Number of months for calculations. In case it helps to minimize the number of purchase orders displayed in the list below the lead time analysis. |
Stock holding percentage | Calculates the column: stock holding cost. % cost of the current stock value.
By default the value is set to 0, prompting the user to insert their average stock holding cost percentage for the company.
Stock holding cost should cover: cost of capital, insurance, housing, forklifts, electricity, warehouse staff (servicing), risk and admin for example.
Many companies know this value as rough estimate, often around 25-20% per year |
Vendor information columns - Insights package
In the vendor overview, the vendor detail page there is a list of available columns that are described in detail here below
Vendors Insights - Column Name | Description |
Vendor | Name and number |
Item count | YES |
Lead time days | The registered lead time in the vendor card in the ERP system, or overwritten on vendor level in AGR |
Add. Lead time days | if registered on vendor level in AGR |
Min order value |
|
No of deliveries | Number of purchase order deliveries ordered in the time horizon included in the Lead time analysis settings page |
Stock value | [stock units * cost price] on hand stock, item card cost price |
Stock holding cost | Stock value * stock holding percentage (settings) |
Total purchase cost | Purchased quantity from arrived purchase orders. Ordered over the [months included in calculations] * cost price [item card] |
On time delivery buffer | days added or subtracted from the actual lead time as buffer for resulting in an on time delivery. |
Avg. lead time | The average measured lead time, during the months included in the calculation settings. [order date - arrived physical date] |
Max lead time | Longest measured lead time, days between order date and arrived physical date. During the months included in the calculation settings. |
Min lead time | Shortest measured lead time, days between order date and arrived physical date. During the months included in the calculation settings. |
Deliveries % | Percentage of on time deliveries, on the purchase order header level. Settings: Months included in the calculation (default 12 months). Settings: first order date, last or ignore with multiple |
Item no | Item number (from the ERP system) |
Item name | Item name from the ERP system |
Original item no | Supplier's item number (from ERP system) |
Item group level 1 | tem group name, level 1 from the ERP system |
sale value last 12 months | [sale quantity (last 360days) * sale price] from the ERP's item card |