MAC-PAC Homecontact ussupport login 
Documentation > MAC-PAC Technical Library > Distribution > Purchasing > Programs > Item/Vendor Analysis Inquiry - Purpose > Item/Vendor Analysis Inquiry - Calculations

Item/Vendor Analysis Inquiry - Calculations

PO940E

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.   A parameter list is set up for the fast path and help screen parameters.

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

4.   Workfields are defined and program constants are initialized.

5.   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 default company/warehouse is retrieved from the workstation assignment record (category 428).

c.   All company/warehouses to which the user is authorized are retrieved from the user company/warehouse authorization record (category 409) and loaded into an array.  If no records are found for the user, a flag is set authorizing the user to all company/warehouses.

d.   The current purchasing period calendar (category 490) is retrieved and the number of periods (12 or 13) is saved.

e.   The last purchasing period posted (category 488) is retrieved and saved.

6.   All valid company/warehouse combinations are retrieved from the Warehouse Description file (IC170M) and stored in an array.  The corresponding plant name is retrieved and stored in a separate array.  The default company/warehouse retrieved above is validated against the valid company/warehouse array; if not found, a message is displayed and the user must enter a valid company/warehouse before processing can continue.

7.   The multiple currency environment is set by checking the multiple currency flag on the system options record (category 133) on the Reference file.

8.   The location defaults data (category 132) is retrieved from the Reference file (REFERP), and the VAT (Value Added Tax) status is checked.

B.   Select

1.   The Item/Vendor Analysis Inquiry Function Select screen (PO940S01) is displayed.

2.   After the user presses the ENTER key, the user input is validated.  See the Purchasing User Manual, Inquiry Screens - Purchasing Control, for validation rules.

3.   A primary read is performed according to the entered maintenance code, and the next screen is displayed.

a.   If the Request Code = 1 (Selected Item/Vendor Relationship), the detail screen is displayed.

b.   If the Request Code = 2 (Vendors by Item), a priming read is made on the logical Item/Vendor or Vendor Master Relationship Join file (PO140JL2), keyed by part number.  If no records are found, an error message is displayed.  Otherwise, the vendor list screen is displayed.

c.   If the Request Code = 3 (Item by Vendor), a priming read is made on the logical Part Master and Item/Vendor Join file (PO140JL3), keyed by vendor number.  If no records are found, an error message is displayed.  Otherwise, the item list screen is displayed.

C.   Vendor List

1.   The vendor list screen subfile is initialized with the data from the logical Item/Vendor Relationship Join file (PO140JL2).

2.   The Item/Vendor Analysis Inquiry Vendor List screen (PO940S02) is displayed.

3.   User input is validated.  One X may be entered in the Select field.  If more than one X is entered, an error message is displayed.

4.   The next screen is displayed based on the command key the user has pressed.

Command Key

 

Next Screen

F4  - Display Detail

Detail screen (PO940S04)

F10 - Display Prompt

Function Select screen (PO940S01)

F14 - Delivery Perf.

Delivery Performance screen (PO940S05)

F16 - Price Perf.

Price Performance screen (PO940S06)

F18 - Quality Perf.

Quality Performance screen (PO940S07)

D.   Item List

1.   The item list screen subfile is initialized with data from the logical Item/Vendor Join file (PO140JL3).

2.   The Item/Vendor Analysis Inquiry Item List screen (PO940S03) is displayed.

3.   User input is validated.  One X may be entered in the Select field.  If more than one X is entered, an error message is displayed.

4.   The next screen is displayed based on the command key the user has pressed.

Command Key

 

Next Screen

F4  - Display Detail

Detail screen (PO940S04)

F10 - Display Prompt

Function Select screen (PO940S01)

F14 - Delivery Perf.

Delivery Performance screen (PO940S05)

F16 - Price Perf.

Price Performance screen (PO940S06)

F18 - Quality Perf.

Quality Performance screen (PO940S07)

E.   Detail

1.   The detail screen subfile is initialized with data from the Item/Vendor Analysis file (PO270M).

2.   The following calculations are performed:

TOTAL
RELEASES

=

ON-TIME
RELEASES

plus

EARLY
RELEASES

plus

LATE
RELEASES

 

TOTAL
QUANTITY

=

ACCEPTED
QUANTITY

plus

REJECTED QUANTITY

 

 

 

STANDARD COST
VARIANCE

=

VOLUME AT
STANDARD COST

minus

VOLUME AT
UNIT COST

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

 

ACCEPTED
PERCENT

=

ACCEPTED QUANTITY
TOTAL QUANTITY

times

100

 

REWORK
PERCENT

=

REWORK QUANTITY
TOTAL QUANTITY

times

100

 

REJECTED
PERCENT

=

REJECTED QUANTITY
TOTAL QUANTITY

times

100

 

RETURN
PERCENT

=

RETURN QUANTITY
TOTAL QUANTITY

times

100

 

PRICE
INDEX

=

VOLUME AT UNIT COST
VOLUME AT STANDARD COST

times

100

 

AVERAGE
PRICE

=

VOLUME AT UNIT COST
TOTAL QUANTITY

 

 

 

                                       

3.   The Item/Vendor Analysis Inquiry Detail screen (PO940S04) is displayed.

4.   The next screen is displayed according to the command key the user has pressed:

Command Key

 

Next Screen

F8  - Return to List

Vendor List screen (PO940S02) or Item List screen (PO940S03)

F10 - Display Prompt

Function Select screen (PO940S05)

F14 - Delivery Perf.

Delivery Performance screen (PO940S05)

F16 - Price Perf.

Price Performance screen (PO940S06)

F18 - Quality Perf.

Quality Performance screen (PO940S07)

F.   Delivery Performance

1.   The graphic array, if not already loaded, is loaded with 12 or 13 periods of item/reader analysis data.

2.   The graphic display screen is loaded and the following calculations are performed:

TOTAL
RELEASES

=

EARLY SHIPPED
RELEASES

plus

ON-TIME SHIPPED
RELEASES

plus

LATE SHIPPED
RELEASES

ON-TIME
PERCENT

=

ON-TIME SHIPPED RELEASES
TOTAL RELEASES

times

100

 

EARLY
PROMPT

=

EARLY SHIPPED RELEASES
TOTAL RELEASES

times

100

 

LATE
PERCENT

=

LATE SHIPPED RELEASES
TOTAL RELEASES

times

100

 

                   

3.   The Delivery Performance screen (PO940S05) is displayed.

4.   The next screen is displayed based on the command key the user has pressed:

Command Key

 

Next Screen

F4  - Display Detail

Detail screen (PO940S04)

F7  - Previous Periods

Previous range of periods is displayed.

F8  - Next Periods

Next range of periods (if posted) is displayed.

F10 - Display Prompt

Function Select screen (PO940S01)

F16 - Price Perf.

Price Performance screen (PO940S06)

F18 - Quality Perf.

Quality Performance screen (PO940S07)

F19 - New Range

User can change the upper and lower limits of the y-axis (defaults are 100 and 0).  The user can also select any one or all three indicators (early, on-time, late) for graphic display.  If only one of the three is selected, the graph is shown with solid bars.  When all three are selected, bars representing early, on-time and late shipped releases are made up of the letters E, O and L, respectively.

G.   Price Performance

1.   The graphic array, if not already loaded, is loaded with 12 or 13 periods of item/vendor analysis data.

2.   The graphic display screen is loaded, the following calculation is performed, and the variance table is loaded.

IF VOLUME AT STD COST IS NOT = 0 THEN VARIANCE

 

 

=VOLUME AT UNIT COST - VARIANCE AT STD COST
   VOLUME AT STD COST

times

100

3.   The Price Performance screen is displayed (PO940S06).

4.   The next screen is displayed based on the command key the user selects.

Command Key

 

Next Screen

F4  - Display Detail

Detail screen (PO940S04)

F7  - Previous Periods

Previous range of periods is displayed.

F8 - Next Periods

Next range of periods (if posted) is displayed.

F10 - Display Prompt

Function Select screen (PO940S01)

F14 - Delivery Perf.

Delivery Performance screen (PO940S05)

F18 - Quality Perf.

Quality Performance screen (PO940S07)

F19 - New Range

User can specify a new range percentage for variance.  (Default is 50.)

H.   Quality Performance

1.   The graphic array, if not already loaded, is loaded with 12 or 13 periods of item/vendor analysis data.

2.   The graphic display screen is loaded and the following calculations are performed:

TOTAL
QUANTITY

=

ACCEPTED QUANTITY

plus

REJECTED QUANTITY

ACCEPTED
PERCENT

=

ACCEPTED QUANTITY
TOTAL QUANTITY

times

100

 

REJECTED
PERCENT

=

REJECTED QUANTITY
TOTAL QUANTITY

times

100

 

3.   The Quality Performance screen is displayed (PO940S07).

4.   The next screen is displayed based on the command key the user selects.

Command Key

 

Next Screen

F4  - Display Detail

Detail screen (PO940S04)

F5  - Previous Periods

Previous range of periods is displayed.

F6  - Next Periods

Next range of periods (if posted) is displayed.

F10 - Display Prompt

Function Select screen (PO940S01)

F14 - Delivery Perf.

Delivery Performance screen (PO940S05)

F16 - Price Perf.

Price Performance screen (PO940S06)

F19 - New Range

User can specify new upper and lower percentage limits (defaults are 100 and 0).  The user can also specify either Accepted, Rejected, or both quantity percentages for display.

 

PO940E Program Menu