The key figures that are described below are calculated when executing the standard analyses and are therefore not saved in any information structure.

The average purchase order price is calculated by dividing the effective purchase order value (value of the purchase order including discounts, surcharges, delivery costs, cash discounts) by the order quantity (quantity of the order materials).

This key figure is calculated when performing the vendors, material groups and material analysis.

The effective purchase order value and the purchase order quantity are updated when an order or a scheduling agreement is created and changed.

This key figure is calculated when the vendor, material and material group analysis is performed.

The average delivery time in days is calculated by dividing the total delivery time by the number of deliveries.

The total delivery time is the total number of times between order and goods receipt in days. It is updated with a goods receipt to the entry date (information structure S012).

The number of deliveries is updated with a goods receipt for an order to the entry date of the goods receipt.

The average invoice price is calculated by dividing invoice value by invoice receipt quantity. The invoice value and the invoice receipt quantity are updated with an invoice receipt to the information structure S012.

The value of goods received is calculated in two different ways:

• At data record level of information structure S012

• At aggregated level (totals line and aggregated list levels)

The goods receipt value at data record level is derived from the quantity of goods received valuated with the average order price.

The average order price is calculated by dividing the effective order value by the purchase order quantity. The effective order value is the value of the purchase order including the discounts, surcharges, delivery costs, and cancellations.

The goods receipt value at aggregated level (e.g. totals line or higher list level) is the total of the goods receipt values of the individual list lines.

The table below shows how the value of goods received is calculated for two purchase orders. In one month and for one vendor, 2 purchase orders and the corresponding goods receipts are posted for one material with different purchase order prices. The value of goods received at purchase order level is derived from the goods receipt quantity valuated with the purchase order price.

Once the purchase orders and the goods receipts have been posted, both purchase orders for 01.97 are written to information structure S012, into one data record. The value of goods received for the month 01.97 is derived by multiplying the average purchase order price by the goods receipt quantity of this one data record. In the vendor analysis, the following list is displayed in a drill-down by month.

This example shows that the value of goods received in the standard analysis does not always correspond exactly to the value of goods received according to the purchase order price in the purchase orders. When the purchase orders are updated, multiple purchase orders are aggregated in one info structure data record, so that the value of goods received in the standard analysis is calculated on the basis of an average purchase order price of the individual purchase orders.

This is the delivery time that is weighted with the goods receipt quantity.
The delivery time weighted with the quantity is calculated from the cumulated product of delivery time and goods receipt quantity divided by the cumulated goods receipt quantities:

Total of (delivery time x quantity of goods received)
------------------------------------------------------------------
Total of (quantity of goods received)

The goods receipt quantity is cumulated without taking the cancellations into account (by using the help key figure Total quantity of goods received).