I have had several requests for a Vendor Delivery Performance Report and am looking for feedback regarding how to quantify it.  It is easy enough to define due date versus actual receipt date and therefore number of days early or late.  Items to discuss include:
 
1.  Should an early receipt offset a late one when calculating vendor ratings/averages?
2.  How does a 1 day late receipt of 2 pieces of a $2 item compare to a 30 day late receipt of 1000 units at $100 each?  Is the dollar value or quantity of greater importance?  Or should the report offer multiple options to determine an aggregate vendor rating?  Obviously a late $0.10 item can potentially hold up a $100,000 shipment so maybe dollar value doesn't count.  Comments, please.
3.  PO Receipt (in DBA) doesn't truly happen until QC Buyoff if you receive to QC.  But I presume if the parts are good, the vendor delivery performance shouldn't suffer because your QC people are lazy.  
4.  Any other ideas/comments?

OK, how does this sound as a flexible approach (same logic could be used for On-Time rating of shipments to customers)
 
1.  Prompt for Date Range of receipts to be included in the calculation
2.  Define whether to base on Actual Receipt Date or Estimated Receipt Date within that range
3.  Define "On-Time Window" in terms of allowable days early and allowable days late.
4.  Enter range of Vendors to be rated based on From/Through Vendor Code and Vendor Class
5.  Select On-Time Rating method to be used as one or more of the following:
a.  Percent of receipts on-time based on number of PO Lines received on time regardless of quantity of items or dollar value of each received line divided by total number of lines received from the vendor.
b.  Percent of Items on-time based on total quantity of items received on time divided by total quantity of items received.
c.  Percent of value on-time based on total dollar value of items received on-time divided by total value of all items received from the vendor.
6.  Print out a report listing each vendor and the on-time rating percentage based on the method(s) selected.
 
 
Comments please.....