Supplier statistics provide the possibility to check supplier quality, bonus status, purchasing savings and orders overview. This is important for negotiating with suppliers and deciding to lock, deactivate or replace a supplier. To view supplier statistics:

In the navigation, click Purchasing and click Suppliers.
In the list select and open the supplier you want to check.
Click Statistics tab.

Supplier Quality

This section shows some basic key facts concerning the performance and usage of the supplier:

Average delivery time this year (d): the sum of delivery days for all order lines between the 1st of January this year and today, divided by the number of all order lines between the 1st of January this year and today
Average delivery time last year (d): the sum of delivery days for all order lines between the 1st of January last year and the 31st of December last year divided by the number of order lines between the 1st of January last year and the 31st of December last year
Last order: date of last purchase order that was ordered at supplier (order status was changed to ORD)
Open purchase orders: the number of purchase orders in status ORD or CON

Delivery time is based on the number of days between confirmation date (order status changed to CON) and the creation of the delivery document line for the concerning order line. For items that are ordered last year but delivered this year, delivery time is calculated for this year. Diagram in this section shows the development of the exact and trend of average delivery times over the past 12 months. If the trend goes up, it is red and it is indicating that the supplier has become slower in delivery, if it goes down it is green, in case of no change, it is black. Example: Last year and this year, the item pixi* T-Shirt was ordered at the supplier pixi* fan shop 6 times:

Confirmation date = 25.2.2012, delivered date = 1.3.2012, delivery time = 5 days
Confirmation date = 17.5.2012, delivered date = 22.5.2012, delivery time = 5 days
Confirmation date = 15.9.2012, delivered date = 18.9.2012, delivery time = 3 days
Confirmation date = 28.12.2012, delivered date = 3.1.2013, delivery time = 6 days
Confirmation date = 17.4.2013, delivered date = 22.4.2013, delivery time = 5 days
Confirmation date = 15.5.2013, delivered date = 18.5.2013, delivery time = 3 days

Calculation of average delivery time for this year and last year is:

Average delivery time this year (d): 6+5+3 / 3 = 4,7
Average delivery time last year (d): 5+5+3 / 3 = 4,3

Order Information

This section contains information on savings because of purchasing conditions and order characteristics for the orders placed at the selected supplier. You can define a time frame for which the key facts are calculated. Supplier orders are included in the calculation if their order date is within the time frame. The following values can be selected for the time frame:

Last year
Last 12 months
This year
Last quarter
Last month

Example: if today is 14.7.2013 the following time ranges are taken into the account according to the selected time frame:

Last year: from 1.1.2012 to 31.12.2012
Last 12 months 14.7.2012 to 14.7.2013 (today – 12 months)
This year 1.1.2013 to 14.7.2013 (today)
Last quarter 14.4.2013 to 14.7.2013 (today – 3 months)
Last month 14.6.2013 to 14.7.2013 (today – 1 month)

Purchasing Savings

Purchasing savings statistics show you the amount of money saved because certain purchasing conditions from the supplier were used to optimize the purchase orders. Purchasing conditions are checked for purchase orders with status ORD, CON and CLS in the defined time frame. You can see information about:

Supplier orders that reached free of freight limit (%): Number of purchase orders which reached limit for free freight costs divided by total number of purchase orders * 100
Supplier orders that reached minimum order amount (%): Number of purchase orders which reached minimum order amount divided by total number of purchase orders * 100
Total paid freight costs (€): sum of paid freight costs
Total paid surcharge (€): sum of paid surcharge

Purchase Order Characteristics

Order characteristics show you the average purchasing volume per order and frequency of purchase orders at the supplier in a defined timeframe. If you are ordering frequently with an average order volume, you can negotiate with the supplier about discounts. You can check these numbers:

Average purchasing volume per purchase order in selected period (€): sum of order lines total amounts divided by number of purchase orders
Average number of items per purchase order in selected time period: sum of order line quantities divided by number of purchase orders
Average number of days between purchase orders in selected period: order frequency in days, sum of the number of days between purchase orders (when purchase order status is changed to ORD) divided by the number of time ranges

Example: This year, the item pixi* T-Shirt was ordered at the supplier pixi* fan shop 4 times:

Purchase Order number	Ordered Date	Ordered Quantity	Order Lines Total	Status
FAN00000100	15.3.2013	2	20 €	CLS
FAN00000144	17.4.2013	3	30 €	CLS
FAN00000168	15.5.2013	2	20 €	CON
FAN00000201	16.6.2013	5	50 €	ORD

Supplier price for pixi* T-Shirt: 10,00 €
Purchasing conditions:
- Minimum order amount surcharge: 3 €
- Minimum order amount: 30 €
- Freight costs: 5,00 €
- Free of freight limit: 50,00 €
- Block price for pixi* T-Shirt: 10 % discount if ordered quantity higher 10

You want to see order information for the last quarter of this year: today is 14.7.2013, time frame is from 14.4.2013 to 14.7.2013

Supplier orders that reached free of freight limit (%): 1 / 3 * 100 = 33,3 %
Supplier orders that reached min order amount (%): 2 / 3 * 100 = 66,7 %
Total paid freight costs: 5 € + 5 € =10 €
Total paid surcharge: 3 €
Average purchasing volume per purchase order in selected period (€): 30 € +20 €+50 € / 3 = 33,33 €
Average number of items per purchase order in selected time period: 3 + 2 + 5 / 3 = 3,3
Average number of days between purchase orders in selected period: 28 + 32 (17.4.2013 – 15.5.2013 + 15.5.2013 - 16.6.2013) / 2 = 30 days

Note: Supplier order FAN00000100 is not considered in order information statistics because it does not belong to the last quarter time frame.

Bonus

The diagram shows order volume based on ordered and delivered items and reached order volume compared to the target order volume. The bonus status is based on the bonus conditions defined at the supplier object. If no bonus conditions are defined for the supplier, no diagram is displayed in this section.

Delivery Information

This section shows information on how many items were ordered at the supplier and how many were delivered. By comparing these values you can see if all items you ordered were delivered correctly. A difference here can have several reasons, e.g. items were not available or the supplier made a mistake when shipping your order. Therefore, if the difference between ordered and delivered quantity is substantial, you should research what the reason for this is.

You can also see the total amount of ordered and delivered items. This information can be used to determine if it is an important supplier for you, i.e. if you are doing a lot of business with him which should strengthen your negotiation position.

Note: Items that were delivered without a purchase order (can't be matched to any order) are not included in this calculation. And the calculation ONLY works when the purchase order is used as a template for the delivery document.

Number of items ordered: Sum of all items that were ordered at the supplier.
Amount ordered: Sum of amounts of ordered item (discount is not included).
- The calculation always takes the lowest price from purchase orders (in status ORD) which is multiplied by Number of items ordered.
Number of items delivered: Sum of all items that were delivered by the supplier. The value of this field can't be higher than Number of items ordered even if there is more items delivered than ordered.
Amount delivered: Sum of amounts of delivered items (discount not included).
- The calculation always takes the lowest price from purchase orders (in status ORD) which is multiplied by Number of items delivered
- Amount can't be higher than Amount ordered.

Note: Supplier orders and deliveries in all statuses are included in these calculations.