MAC-PAC Homecontact ussupport login 
Documentation > MAC-PAC Technical Library > Distribution > Purchasing > Programs > Item/Vendor Statistics by Vendor Report - Purpose > Item/Vendor Statistics by Vendor Report - Calculations

Item/Vendor Statistics by Vendor Report - Calculations

PO720E

A.   Housekeeping

1.   See Common Processing Routines - Housekeeping of this manual for a general discussion of the Housekeeping routine.  Processing specific to this program is described below.

2.   Key lists are defined for each file retrieved by the program.

3.   Workfields are defined and program constants are initialized.

4.   The following records are retrieved from the Reference file (REFERP):

a.   The date format record (category 049) is retrieved.  If this record is not found, the date format defaults to MMDDYY.

b.   The Purchasing System Defaults - 2 record (category 492) is retrieved to determine if statistical quantities or amounts should be printed on the report.

c.   The system options record (category 133) is retrieved to determine if the user is in a multi-currency environment.

B.   Mainline

1.   The first record on the Item/Vendor Statistics Report Request file (PO310HP) is read.  The Request Type (RRTYP2) is checked to determine if the Item/Vendor Statistics By Vendor report was requested.

2.   If the Item/Vendor Statistics By Item report was requested, the following processing is performed:

a.   The Request Type (RRTYP3) is checked to determine if a summary or detail report format was requested.

b.   The request selection criteria are checked to determine which logical file should be used to retrieve the item/vendor statistics records.

c.   The multiple currency flag is checked, and the proper report headings are printed.

d.   The first item/vendor statistics record meeting the selection criteria is retrieved.

e.   Calculations are performed based on whether current period, Year-to-Date, or last year statistics were requested.

The on-time delivery percentage, price index, and quality percentage are calculated as follows:

ON-TIME DELIVERY
PERCENTAGE

=

ON-TIME RELEASES
TOTAL RELEASES

times

100

PRICE
INDEX

=

VOLUME AT UNIT COST
VOLUME AT STANDARD COST

times

100

QUALITY
PERCENTAGE

=

ACCEPTED QUANTITY
sum of ACCEPTED plus
REJECTED QUANTITIES

times

100

f.    The calculated performance percentages are compared to the performance percentage selection criteria entered in the report request program.  If the record is within the range of performance  percentages entered in the selection criteria, it is eligible for printing.

g.   Level break totals are cleared for the company/warehouse, purchasing group, and purchasing sub-group if level break flags = Y.  Item/vendor totals are cleared each time.

h.   Calculations are performed based on whether current period, Year-to-Date, or last year statistics were requested.

(1)  The on-time, early, and late release percentages are calculated as follows:

ON-TIME RELEASE
PERCENTAGE

=

ON-TIME RELEASES
TOTAL RELEASES

times

100

EARLY RELEASE
PERCENTAGE

=

EARLY RELEASES
TOTAL RELEASES

times

100

LATE RELEASE
PERCENTAGE

=

LATE RELEASES
TOTAL RELEASES

times

100

(2)  The volume at unit cost and volume at standard cost are added to the appropriate accumulators.

(3)  The accepted, rework, rejected, and return percentages are calculated as follows:

ACCEPTED
PERCENT

=

ACCEPTED QUANTITY
sum of ACCEPTED plus
REJECTED QUANTITIES

times

100

REWORK
PERCENT

=

REWORK QUANTITY
sum of ACCEPTED plus
REJECTED QUANTITIES

times

100

REJECTED
PERCENT

=

REJECTED QUANTITY
sum of ACCEPTED plus
REJECTED QUANTITIES

times

100

RETURN
PERCENT

=

RETURN QUANTITY
sum of ACCEPTED plus
REJECTED QUANTITIES

times

100

(4)  The accepted, rework, rejected, and return amounts at standard cost are calculated.

First, a standard cost workfield is calculated:

STANDARD COST
(workfield)

=

VOLUME AT STANDARD COST
sum of ACCEPTED  plus
REJECTED QUANTITIES

Then the amounts at standard cost are calculated as follows:

ACCEPTED AMOUNT
AT STANDARD COST

=

ACCEPTED
QUANTITY

times

STANDARD COST
(workfield)

REWORK AMOUNT
AT STANDARD COST

=

REWORK
QUANTITY

times

STANDARD COST
(workfield)

REJECTED AMOUNT
AT STANDARD COST

=

REJECTED
QUANTITY

times

STANDARD COST
(workfield)

RETURN AMOUNT
AT STANDARD COST

=

RETURN
QUANTITY

times

STANDARD COST
(workfield)

(5)  The price index is calculated as follows:

PRICE
INDEX

=

VOLUME AT UNIT COST
VOLUME AT STANDARD COST

times

100

i.    If a summary report format is requested, the overall performance is calculated.

(1)  The purchasing group is used as the key to retrieve the performance weight from the Reference File (category 472).  If the performance weight is not on the Reference file, the four performance indicators are weighted equally.

(2)  The quality perfection and price percentages are calculated as follows:

QUALITY
PERFECTION

=

ACCEPTED minus REWORK QUANTITIES
sum of ACCEPTED plus REJECTED QUANTITIES

times

100

PRICE
PERCENTAGE

=

VOLUME AT STANDARD COST
VOLUME AT UNIT COST

times

100

(3)  Weighted percentages are calculated as follows:

QUALITY PERFECTION
PERCENTAGE (weighted)

=

ACCEPTED QUANTITY
PERCENT

times

QUALITY ACCEPTANCE
WEIGHT

REWORK AMOUNT
AT STANDARD COST

=

REWORK
QUANTITY

times

STANDARD COST
(workfield)

PRICE
PERCENTAGE (weighted)

=

PRICE PERCENTAGE

times

PRICE WEIGHT

ON-TIME DELIVERY
PERCENTAGE (weighted)

=

ON-TIME DELIVERY
PRICE PERCENTAGE

times

DELIVERY WEIGHT

(4)  Finally, the overall performance is calculated as follows:

OVERALL
PERFORMANCE

=

QUALITY
PERFECTION
(weighted)

plus

QUALITY
ACCEPTANCE
(weighted)

plus

PRICE
PERCENTAGE
(weighted)

plus

ON-TIME
DELIVERY
(weighted)

j.    Totals are incremented at the company/warehouse, vendor group, and vendor levels.

k.   Level breaks occur if the company/warehouse, vendor group, or vendor changes.  Sub-total lines are calculated and printed and level break flags are set to Y.

PO730E Program Menu