A method for reporting supplier on time performance comprising:
- storing in a database summarized purchase order data from a plurality of buyers, the summarized purchase order data comprising a plurality of records, each record in the plurality of records including a supplier, a buyer, a one of a plurality of start point/end point pairs for measuring on time delivery, a number of orders placed, and a number of orders delivered on time, wherein the start point is representative of a plurality of events triggering a start of a time period used to measure delivery time, the end point is representative of a plurality of events triggering an end of a time period used to measure delivery time, and each of the plurality of start point/end point pairs can be different from each other for at least one buyer, and wherein the start point corresponds to a first point along an order fulfillment process and the end point corresponds to a second point along the order fulfillment process;
- for a first subset of the plurality of records, each record in the first subset including a first of the plurality of start point/end point pairs and a first supplier, summing together the number of orders placed included in each record of the first subset to obtain a first total number of orders placed with the first supplier for which the first start point/end point pair is used to measure on time delivery;
- for the first subset of the plurality of records, summing together the number of orders delivered on time to obtain a number of the first total number of orders that were delivered on time;
- for a second subset of the plurality of records, each record of the second subset including a second of the plurality of start point/end point pairs and the first supplier, summing together the number of orders placed included in each record of the second subset to obtain a second total number of orders placed with the first supplier for which the second start point/end point pair is used to measure on time deliver;
- for the second subset of the plurality of records, summing together the number of orders delivered on time to obtain a number of the second total number of orders that were delivered on time;
- for a third subset of the plurality of records, each record in the third subset including a third of the plurality of start point/end point pairs and a second supplier, summing together the number of orders placed included in each record of the third subset to obtain a third total number of orders, the third total number of orders placed with the second supplier for which the first start point/end point pair is used to measure on time delivery;
- for the third subset of the plurality of records, summing together the number of orders delivered on time included in each record of the third subset to obtain a number of the third total number of orders that were delivered on time;
- and
- reporting the plurality of buyers and the plurality of suppliers the first total number of orders, the number of the first total number of orders that were delivered on time, the second total number of orders, the number of the second total number of orders that were delivered on time, the third total number of orders and the number of the third total number of orders that were delivered on time.