[mfw_user_group] Re: MFW User Group Enquiry: Vendor Performance Report

  • From: "Phillips, Carol" <Carol.Phillips@xxxxxxxxxxxxxxxxxxx>
  • To: mfw_user_group@xxxxxxxxxxxxx
  • Date: Tue, 15 Jan 2002 13:11:02 -0000

Michael,  

I have not as yet done any work on this but would be extremely interested in
what you have done. 
  

Carol

        -----Original Message-----
        From:   Michael Elder [SMTP:melder@xxxxxxxxxxxx]
        Sent:   Tuesday, January 15, 2002 12:53 PM
        To:     'mfw_user_group@xxxxxxxxxxxxx'
        Subject:        [mfw_user_group] MFW User Group Enquiry: Vendor
Performance Report


        Hi

        I have previously designed a vendor performance crystal report for
use with 
        MFW.

        The report basically gives each supplier a rating out of 100, as to
how 
        many units they delivered on time over a set period.

        The report classifies deliveries as early, on time, late and out of
limit. 
        As a customer we are only concerned about how many units were
delivered on 
        time.

        i.e. if an order was placed for 2000 units, and 2 deliveries were
made to 
        complete the order, 1600 on time and 400 late, then the performance
index 
        would be :

        (1600/2000)*100 = 80%

        I believe this is called Lpi by many organisations.

        Overall I have found some errors in my designed  report, and I am
very 
        interested to see if there is anyone who has worked on a similar
project.

        Basically, if anyone has experience with rating vendor performance,
and 
        uses a similar report, or knows if there are any third party
products 
        available which do a similar function, then I would be very
interested to 
        hear from you.

        I am using MFW version 3.5 with Crystal Reports Version 6.

        Thanks

        Michael Elder
        Magnetic Technologies Europe
        Rochester, UK

Other related posts: