Commodity Supplier Management Dashboard | Purchasing Dashboard

Use the Commodity Supplier Management Dashboard/reports to judge suppliers’ performance:

• See how much a supplier’s prices have increased or decreased in a commodity, across all items for that supplier.
• Use return rates and reasons to measure a supplier’s quality and performance in a commodity. See which suppliers and commodities have the highest return amount or number of return transactions, and determine the most common return reasons.
• Measure how suppliers for a particular commodity are performing based on rejections during inspection.
• View the amount or number of transactions received early, within tolerance, or late for specific suppliers and commodities, based on your receiving options setup in Oracle Purchasing. See which suppliers and commodities have the highest receipt date exception amount or number of receipt date exception transactions

 

Image

Price Change Amount: Sum of [Quantity * (Price – Supplier Benchmark Price)]. Use this KPI to measure how much you are saving in a commodity because of better prices. The savings are measured by comparing today’s prices with a supplier benchmark price, which is the average unit price for the items in the previous enterprise year for a supplier in a commodity, across all operating units. A negative number indicates a price decrease.

• Return Amount: Sum of (Price * Return Quantity).
Price is the price on the purchase order. Return Quantity is the quantity on the return.

Use this KPI to see how much has been returned to suppliers, including the change in that amount between the current and previous periods.

• Return Transactions: Number of return transactions performed in Oracle Purchasing or Oracle iProcurement for the selected parameters. There can be multiple return transactions for each receipt.

Image

Receipt Date Exception Amount Rate:(Sum of Exception Amount / Sum of Receipt Amount) * 100.
The Exception Amount is the price on the purchase order, multiplied by the receipt quantity, for all receipts whose receipt dates fall outside the days early or days late. The Receipt Amount is the price on
the purchase order, multiplied by the receipt quantity, for all receipts.

Use this KPI to monitor the supplier’s performance by evaluating receipt exceptions, both early and late. A lower rate is desirable.

• Receipt Date Exception Transactions Rate:(Sum of Exception Transactions / Sum of Receipt Transactions) * 100.
Number of receipt date exception transactions as a percentage of all receipt transactions that occurred for the selected parameters and time period.

Image

PO Price Change KPI

How much more am I purchasing for each commodity because of changes in purchase order price?
• Which suppliers have the highest purchase order price increases in each commodity or across all commodities?
• How much is my company spending, based on the PO Purchases Amount, on a commodity, category, or item? With which suppliers or supplier sites is that amount being spent?

The PO Price Change reports measure purchase order price increases or decreases in a commodity, for specific suppliers, by comparing today’s prices with a supplier benchmark price. The supplier benchmark price is the average unit price for the items in the previous enterprise year for that supplier, across all operating units.

The PO Price Change reports measure how well a supplier is performing on price relative to the supplier’s past performance. Ideally, suppliers should be reducing their prices as they become more efficient or as the volume of purchases increases. The Price Change by PO Number report displays the purchasing documents that are responsible for the price change.