OPTION (24) Modifications to Baseline - Moderate                               GRAPHIC EXAMPLE

(MPO-Z3-00) PURCHASE PRICE VARIANCE TRACKING/REPORTING

Baseline reports are available to report PPV from AP- RECEIPTS, by Vendor or by Part. This Modules creates a transaction in file Z_PPV_HISTORY, built at RECEIPTS File Time, for reporting.

This preserves the Authorized Cost at the time of the Receipt, reflecting the PPV at that time. In addition, the provided reports allow for numerous other sorts, and allows for reporting ranges (i.e., only unfavorable Variances over $100.)

A file is included, to detail FUTURE PPV from Scheduled Receipts in MONTHLY buckets, by Part, Vendor, Buyer, Commodity Code, etc.

Z_PPV_HISTORY builds one record per AP-RECEIPT, to detail primary PPV, between P.O. Price and Standard Material, or Outside Process Cost, for improved reports by Vendor, Buyer, Part, Commodity Code, etc. This is a tool for Materials / Purchasing to evaluate pricing on P.O.'s, vs. Standard Cost, to determine primary causes of PPV. Records are built ONLY when PPV exists.

Z_PPV uses a Monthly Bucket structure to estimate future PPV, based on Scheduled P.O. Receipts. Reports can be provided by Buyer, Vendor, Commodity Code, Part Number, etc.

Enhancements are available for existing PPV reports, to report only Unfavorable or Favorable PPV, and to limit the transaction amounts printed (i.e., print only Unfavorable PPV exceeding $100).