Aerospace Supplier On-Time Delivery and Quality Rating Calculator
AS9100 expects you to evaluate external providers on their ability to supply conforming product on time. This calculator turns raw receiving counts into on-time delivery, lot acceptance, PPM and a single weighted rating.
Your numbers
Received on or before the promise date within your allowed window
Quality weight is the remainder
Your results
Weights and penalties are an example model. Set your own targets and rating bands in your supplier management procedure.
Composite rating vs delivery weight
Sweeps Weight on delivery from 0 to 100, holding your other inputs fixed.
Automate supplier ratings
Optional: discuss calculating these ratings directly from ERP receipts and inspections.
Optional. The tool and every export work without this. No spam.
How to use the calculator
Pull a rolling period, usually twelve months, from your receiving and purchasing data. Enter lots received, how many were on time, how many were accepted, the units received and the defective units found. Adjust the weight between delivery and quality to match your priorities and enter any open SCARs. The composite rating shows the result as a percent.
- Use the same period for all suppliers
- Count lots, not purchase order lines, consistently
- Set an on-time window and keep it fixed
- Review the chart to see sensitivity to weighting
The formulas
On-time delivery is lots on time divided by lots received. Lot acceptance is lots accepted divided by lots received. PPM is defective units divided by units received times one million. The composite is the weighted average of delivery and acceptance, less five points for each open SCAR up to a cap. If you receive nothing, the result returns zero rather than an error.
Reading the result
Compare the composite to bands in your procedure, for example preferred, conditional and probation. The example inputs give about 90 percent on time and 95 percent accepted, with a small SCAR penalty. PPM is useful when lots are large, because acceptance by lot can hide a low defect rate within accepted lots.
Common mistakes
Mixing definitions across suppliers makes comparison meaningless. Counting a late receipt that the buyer agreed to move as late hurts good suppliers, while ignoring early deliveries can hide inventory problems. Combine the rating with qualitative inputs such as responsiveness and audit results before changing a supplier's status.
Frequently Asked Questions
What is a good on-time delivery target?
Many aerospace customers expect 95 percent or better, but the right target depends on your contract and the part. Use your customer flow-downs and internal objectives.
How is PPM calculated?
Divide defective units by units received and multiply by one million. For example, 36 defective units out of 24,000 gives 1,500 PPM.
Should early deliveries count as on time?
Define it in your procedure. Many companies allow a small early window and treat anything outside it as a miss, since early receipts tie up space and cash.
Can I change the weights?
Yes. The slider sets the delivery weight and quality takes the remainder. Pick weights that match your risk, then keep them stable so trends are comparable.
If your receiving data is in the ERP, Netray can help calculate supplier ratings automatically each month and write them back to the vendor record.
Related Tools
Nadcap Special Process Supplier Approval Tracker
Editable worksheet for tracking special process suppliers, their Nadcap or customer approvals, scope and days to expiry.
Quality & InspectionAerospace Supplier Corrective Action Request Template
Issue a SCAR with defect details, required containment, root cause and effectiveness verification fields, then export to PDF or Word.
Aerospace & DefenseAerospace Supplier Scorecard
Rate a supplier across 10 criteria - OTD, quality escapes, AS9100 status, FAI performance, CAPA responsiveness, compliance flowdown, and financial health - for an instant risk rating.
Quality & InspectionAS9100 Risk and Opportunity Register Worksheet
Log risks and opportunities with severity, likelihood and detection scores, calculate a risk priority number and export to Excel.
More Quality & Inspection tools
See all- AS9100 Internal Audit Report Template
- AS9145 APQP and PPAP Checklist
- Aerospace Key Characteristic Cpk Calculator
- AS9100 Management Review Minutes Template
- Aerospace Success-Run Sample Size Calculator
- Aerospace Test Uncertainty Ratio Calculator
- Aerospace Escaped Defect Containment Cost Calculator
- Aerospace NCR Trend SQL Query Generator
- SAP QM Process Capability Cp Cpk Calculator