Documentation >
MAC-PAC Technical Library >
Distribution >
Purchasing >
Programs >
Item/Buyer Analysis by Buyer Report - Purpose >
Item/Buyer Analysis by Buyer Report - Calculations
Item/Buyer Analysis by Buyer Report - Calculations
PO760E
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/Buyer Analysis Report Request file (PO310KP) is read.
2. If the Item/Buyer Analysis By Buyer 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/buyer analysis records.
c. The multiple currency flag is checked, and the appropriate report headings are printed.
d. The first item/buyer analysis record meeting the selection criteria is retrieved.
e. 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, buyer, and item/buyer if level break flags = Y.
h. Calculations are performed for each record read meeting the selection criteria.
(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. Totals are incremented at the company/warehouse, buyer, and item/buyer levels.
j. Level breaks occur if the company/warehouse, buyer, or item/buyer changes. Sub-total lines are calculated and printed and level break flags are set to Y.