Create and Display Supplier Statistics

This document explains how you create and display supplier statistics. It also explains how you print supplier statistics.

Outcome

Detailed supplier statistics are generated.

Uses

Use the supplier statistics to do the following:

  • Summarize the totals for all the suppliers and period as well as a count of key factors for each supplier.
  • Compare different suppliers based on the performance supplier value.
  • Print and use for further analysis.

How the System Is Affected

The purchase statistics are updated in the MVENST file.

Before you start

The parameters in Define Settings for Supplier Evaluation and Statistics must be defined.

Follow These Steps

Create Supplier Statistics

  1. Start 'Supplier Statistics. Create' (PPS435).

  2. Press F13 to open the P panel. Set the opening panel as B and press Enter.

  3. On the B panel, enter the report version and click Create.

    Report versions are stored under optional IDs in a separate file that contains sets of selections and sorting parameters for created reports.

  4. On the E panel, enter the supplier and the period.

    Two different period ranges can be selected.

  5. Press Enter to return to PPS435.

  6. On the B panel, select the created record and then select option 9 = Run to display the E panel again.

  7. Enter the supplier and the period.

  8. Press Enter.

    The job is submitted.

Display Supplier Statistics

  1. Start 'Supplier Statistics. Display' (PPS440).

  2. Press F13 to open the P panel. Set the panel sequence as EFG, enter the maximum number of records, and select one of the options in 'Column display'.

    'Column display' indicates how totals in statistics columns must be calculated and presented.

    The valid alternatives are:

    0 = Not displayed

    1 = The cumulated total for all the record displayed on the screen

    2 = The average calculated for each column is displayed on the screen.

  3. Press Enter.

  4. On the B panel enter the supplier number, yearly statistics, and period (if sorting order 1 is used). Press Enter.

    The placed orders and the invoiced value for the mentioned period are displayed.

    Select the sorting order based on the way you want to display the data.

  5. Select one of the records and then select basic option 5 = 'Display' to continue to the E panel.

    • Information is displayed about placed and reported purchase order lines and invoices during a specific period.
    • Order indicates how many purchase orders were entered for this period.
    • The purchase order lines are separated into three different priority classes:

    1= Extremely urgent

    2= Urgent

    3= Normal

    These classes are connected to the priority specified on the purchase order line. The different priorities are defined in 'Purchase Order Priority. Open' (PPS230).

    A parameter on the priority code controls whether the follow-up of delivery time values in the supplier statistics should be updated. This makes it possible to delete lines from a performance evaluation when the customer has not kept to the agreed lead time.

    • The invoice field indicates the number of invoices and lines booked during the period, the total invoiced amount, and incorrect invoices. The last field refers to the invoice remark reason in 'Supplier Invoice. Update Reported' (PPS400/E) and must be updated manually.
    • Scroll backward and forward between the periods using F7 (Scroll backward) and F8 (Scroll forward), respectively.

  6. Press Enter to continue to the F panel.

    • Details about delays, inspections, and claims during a specific period are displayed.
    • In the left column, the average delay days and average early days fields display the average time for delayed and early deliveries. The ranges are defined in 'Settings - Purchase Statistics' (PPS430).
    • At the bottom of the left column the numbers of inspected batches as well as the quality inspection result are displayed.
    • The delivery time discrepancy class 1-5 fields display the delivery time discrepancy for the closed lots. They are divided into different delivery time ranges depending on when the lot was delivered. An early cost of capital amount is calculated for the early deliveries based on the interest rate entered in 'Settings - Purchase Statistics' (PPS430).
    • The value received field is calculated as: Received quantity * (Invoiced price - Discount)
    • Information about closed claim errands during the period is displayed at the bottom of the right column. The number of automatically created claims, the total claim amount, and the number of manually created claims are displayed in the fields for the number of receiving claims, value claims, and number of other claims.

  7. Press Enter.

  8. Performance values for the supplier during the period are calculated and accumulated on the G panel. These values can be used as a measurement when different suppliers are evaluated.

    • Five performance values are calculated, as follows:

    SP Performance supplier

    DP Performance delivery time

    EDC Early Delivery Cost

    DQ Delivery Quality

    IQ Invoice Quality

    • The Performance Supplier value (SP) is a summary performance value when the results of the four other values are taken into consideration. The optimal value of SP is 1 (the perfect supplier).
    • The performance value is calculated by weighing the factors as delivery time (DT), delivery quality (DQ), invoice quality (IQ), and interest cost for early deliveries (EDC).

    The formula is:

    SP = K10*DP + K11*DQ + K12*EDC + K13*IQ

    • K10-K13 are different weight factors indicating how important each aspect is to our business. If the quality aspects are very important, more important than the delivery quality, this factor will be given a higher priority. The different weights are preset in 'Parameters - Purchase Statistics' (PPS430) and are displayed on the bottom of the G panel. For more information about K-factors, See Managing Supplier Evaluation and Statistics.

  9. Press Enter to return to PPS440/B.

Print Supplier Statistics

  1. Start 'Supplier Statistics. Print' (PPS860).

  2. On the E panel, you can select different selection fields, such as supplier group, quality class, and buyer.

    • Two different period frames can be selected.
    • Sorting order can be marked, using numerical values. The lowest numerical value is given the highest priority.
    • Activate the 'Page break' check box to print totals at line breaks.
    • Activate the 'Tot' check box to print totals at line breaks.

  3. Press Enter.

    The printing job is submitted.

Related topics