Supplier defect comparison calculator

Calculate supplier table [ID,defect %,lower fraction,upper fraction,defect cost] and weighted combined defect rate with your own figures.

Your numbers

Use the units shown. Results update as you change valid inputs.

Choose the currency for these amounts. Changing it keeps your numbers and does not convert exchange rates.

Use supplier table [ID,defect %,lower fraction,upper fraction,defect cost] and weighted combined defect rate to compare changes to your inputs. The method and limits below explain the scope.

Examples

Examples

Try the starting example

Suppliers JSON [ID,received units,defective units,cost per defective currency] (USD)
[["A",100,5,10],["B",200,8,15]]
User-supplied normal critical z for rate intervals
1.959963984540054
Supplier table [ID,defect %,lower fraction,upper fraction,defect cost] (USD)
[["A",5,0.0215436791544,0.111750469232,50],["B",4,0.0204056320662,0.0769320682009,120]]
Weighted combined defect rate (%)
4.333333
Total supplied defect cost (USD)
$170.00

Try another scenario

Suppliers JSON [ID,received units,defective units,cost per defective currency] (USD)
[["A",100,2,10],["B",200,8,15]]
User-supplied normal critical z for rate intervals
1.959963984540054
Supplier table [ID,defect %,lower fraction,upper fraction,defect cost] (USD)
[["A",2,0.00550196755016,0.0700117907285,20],["B",4,0.0204056320662,0.0769320682009,120]]
Weighted combined defect rate (%)
3.333333
Total supplied defect cost (USD)
$140.00
Calculation method

Calculation method

Supplier table [ID,defect %,lower fraction,upper fraction,defect cost] (USD)

Compute d/n, supplied-z Wilson score interval, and d*cost for each supplier.

Weighted combined defect rate (%)

100*sum(defects)/sum(received).

Total supplied defect cost (USD)

sum(defects*costPerDefective).

Symbols and units
a
Suppliers JSON [ID,received units,defective units,cost per defective currency] (USD)
b
User-supplied normal critical z for rate intervals

Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.

Calculation steps and notation

sum(list) adds all entries in the list.

Assumptions & limits

Assumptions & limits

  • Independent binomial descriptive rate comparison and Wilson intervals; no causal ranking or supplier-quality certification. Costs are explicit estimates; intervals are not adjusted for multiplicity. Supported limits: unique supplier IDs; n integer>0; 0<=d<=n integer; cost>=0; z>0; <=100 suppliers.
Are these inputs private?

These calculations run in your browser. A shared link contains the values you choose to share. Only questions submitted to the separate AI finder are sent to OpenAI.

Further reading

Method reference ↗

Background reading; this does not imply endorsement or independent review of SumFizz.

Share this page
Share this calculator

Leave unchecked to share the page without your entered values.