ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Suggestions for Updates >> Vendor Performance Report
http://www.istechforum.com/YaBB.pl?num=1057625099

Message started by Lynn_Pantic on 07/07/03 at 18:44:59

Title: Vendor Performance Report
Post by Lynn_Pantic on 07/07/03 at 18:44:59

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?

Title: Re: Vendor Performance Report
Post by melrath on 07/08/03 at 07:01:21

Lynn this sounds like a great idea! 8)

1. We operate within a 7 day on-time window. So if a vendor delivers 7 days early, or late, they're still considered on-time. Anything outside the window is considered unacceptable and counts against them.

2. Dollar value is not an issue in our calculations. We try to meet our promised delivery dates to our customers in order maintain our vendor rating. Also, we don't always know the value of our customer 's finished product.

3. We treat on-time performance (receipt date) and quality performance (buyoff date) as 2 separate issues. Of course, if it gets rejected it might affect delivery performance; but sometimes replacements are made within the delivery window. Therefore, the poor quality aspect has to be tracked separately.

Hope this helps. :)

Fred

Title: Re: Vendor Performance Report
Post by Lynn_Pantic on 07/08/03 at 11:43:56

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.....

Title: Re: Vendor Performance Report
Post by aricon on 07/08/03 at 12:33:40

Lynn,

We have already developed 75% of this in an Access application which could be brought to 100%, and maybe even more if the desire is out there, in a short time frame. And in Access it is quite easy to "tag" out of sequence vendor codes to be included in the report. Whereas in TAS it is NOT so easy.

This is available. And should there be a strong expression of interest from forum members (or from Lynn on behalf) then we would certainly endeavor to complete the additional capabilities indicated in this thread that are not there currently developed product ASAP.