Vendor performance analysis: delivery, cost, and quality

Vendor performance analysis compares delivery, cost, and quality from purchasing records on clearly stated bases. Calculate each measure separately, reconcile it to its source rows, and use the combined evidence to decide what needs a supplier conversation.

Define the review before combining files

Start with one product family, one receiving site, and a due-date period. Record the agreed delivery date, whether partial deliveries count, the inspection policy, and the purchase-cost basis. Compare suppliers serving similar requirements; different specifications or emergency orders can explain an apparent performance gap.

The federal past-performance evaluation rules use supported facts and distinguish technical quality, schedule, and cost control where applicable. That is a useful framework for a private-company review, rather than a requirement that every commercial buyer adopt the federal process.

Do not combine financial health with operating performance. The neighboring vendor financial statement analysis guide addresses that separate question.

Build one reliable purchase-line population

Export purchase-order number and line, supplier ID, item, site, ordered quantity, agreed due date, receipts, invoice amounts, and currency. Add inspected quantity and defective quantity from the quality file. Retain the source document identifiers.

Aggregate split receipts and multiple inspection records to the chosen purchase-line level before adding invoice amounts. Otherwise, repeated purchase lines can multiply cost. Keep uninvoiced receipts and uninspected units visible as exceptions rather than assigning zero cost or zero defects.

Quality must refer to the agreed specification. The FAR quality definitions distinguish contract quality requirements and inspection. A buyer's preference is not automatically evidence of a nonconforming unit.

Work the same rows three ways

An Ohio packaging buyer reviews the following completed purchase lines. All dates are in October 2026, all receipts are full, and every received unit is inspected. Actual and benchmark costs both exclude freight and tax. Each item has a reviewed, comparable unit basis.

Enter actual date values in the worksheet. With the displayed columns in A:H, calculate the on-time flag in I2, then fill down:

=IF(OR(C2="",D2=""),"",--(D2<=C2))

Calculate the cost gap in J2 and fill down:

=G2-H2

This flag applies to completed lines with known dates. For a live due-date cohort, count an open line already past due as a delivery failure; report open lines not yet due separately. Do not quietly omit late open orders.

On-time rate = On-time due lines / Eligible due lines

Defect rate = Defective units / Inspected units

Cost gap percentage = (Actual cost − Benchmark cost) / Benchmark cost

The benchmark is the approved comparable price at the actual quantity. The detailed purchase price variance method owns that calculation; here it is one part of the supplier review.

Calculate supplier results and prove the total

Use a supplier name in L2 to select the rows. Every displayed line is eligible and fully inspected. Calculate the supplier's on-time rate with:

=SUMIFS($I$2:$I$7,$B$2:$B$7,L2)/COUNTIF($B$2:$B$7,L2)

Calculate its defect rate with:

=SUMIFS($F$2:$F$7,$B$2:$B$7,L2)/SUMIFS($E$2:$E$7,$B$2:$B$7,L2)

Calculate its cost gap percentage with:

=SUMIFS($J$2:$J$7,$B$2:$B$7,L2)/SUMIFS($H$2:$H$7,$B$2:$B$7,L2)

Keep full precision in calculations; display percentages to two decimal places.

The total cost gap is 80 − 80 + 20 = $20, also $10,020 − $10,000. Total defects are 4 + 12 + 1 = 17. Divide those defects by total inspected units; averaging supplier defect percentages would give small suppliers too much influence.

Reconcile actual cost to the selected invoice export and the unit counts to receiving and inspection records. Keep unresolved rows in a separate reconciliation category so every source amount remains accounted for.

Turn differences into an accountable review

Alder needs a delivery discussion. Beacon's below-benchmark cost accompanies the highest defect rate. Cedar has fewer units in the review, so its strong quality result has a smaller evidence base. These observations identify questions; they do not establish the root cause or justify an automatic supplier switch.

Assign procurement the commercial follow-up, receiving the delivery evidence, and quality the defect classification. The on-time-in-full guide covers delivery measurement in depth, while supplier lead-time variability addresses consistency across orders.

Where it goes wrong

• Different populations. Comparing October invoices with September receipts creates an unexplained timing difference. State each population and reconcile unmatched records.
• Inspection coverage disappears. Uninspected units are unknown quality outcomes. Report coverage instead of treating them as defect-free.
• Dates move after a miss. Preserve the agreed date used for assessment and record approved changes separately.
• Incomparable cost bases. Freight-inclusive prices and freight-exclusive benchmarks produce a misleading gap.
• Tiny counts become rankings. A short list of orders can identify exceptions without establishing lasting supplier performance.

Review your vendor file in Covirage

Bring your purchase, receipt, and inspection exports, or a Google Sheet with the same fields. Covirage maps the columns; its tools compute the measures and check the totals, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.

See Covirage for procurement teams for the purchasing context.