Skip to main content

Vendors - insights package

This article explains how to get an overview and manage your vendors with what's included in the Insights package subscription.

Updated over a week ago

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:

  1. Top 3 vendors, ranked by highest purchase value

  2. Total stock value across all vendors

  3. Total number of received purchase order deliveries

  4. 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
(purchased qty * cost price)
โ€‹

The default is 12 months, this can be changed in settings, see later in article.


The user can click on the three dots, and choose between ranking the top vendors on [12 month purchased value] or [current stock value]
โ€‹
โ€‹

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

Did this answer your question?