# Supplier Total Cost of Ownership Comparison Calculator

> Source: https://netray.co/tools/supplier-total-cost-of-ownership-comparison-calculator
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Compares two suppliers on landed price plus the cost of rejects, and shows the reject rate at which the cheaper quote stops being cheaper.

## Category

supply-chain

## Audience

- Buyer
- Sourcing manager
- Supplier quality

## Tool

**Kind:** calculator

**Currency:** $

**Inputs:**

#### Annual volume

**Key:** annual_units

**Type:** number

**Default:** 50000

**Min:** 0

**Step:** 1000

**Unit:** units

#### Supplier A quoted unit price

**Key:** price_a

**Type:** number

**Default:** 12.4

**Min:** 0

**Step:** 0.05

**Unit:** $

**Help:** Incumbent or domestic quote.

#### Supplier B quoted unit price

**Key:** price_b

**Type:** number

**Default:** 10.9

**Min:** 0

**Step:** 0.05

**Unit:** $

**Help:** Challenger or offshore quote.

#### Supplier A freight, duty and fees

**Key:** adder_a

**Type:** slider

**Default:** 3

**Min:** 0

**Max:** 40

**Step:** 0.5

**Unit:** % of price

**Help:** Inbound freight, duty, brokerage and tooling amortization as a percent of price.

#### Supplier B freight, duty and fees

**Key:** adder_b

**Type:** slider

**Default:** 14

**Min:** 0

**Max:** 40

**Step:** 0.5

**Unit:** % of price

#### Supplier A expected reject rate

**Key:** reject_a

**Type:** slider

**Default:** 0.8

**Min:** 0

**Max:** 10

**Step:** 0.1

**Unit:** %

#### Supplier B expected reject rate

**Key:** reject_b

**Type:** slider

**Default:** 2.5

**Min:** 0

**Max:** 10

**Step:** 0.1

**Unit:** %

#### Full cost per rejected unit

**Key:** cost_per_reject

**Type:** number

**Default:** 22

**Min:** 0

**Step:** 1

**Unit:** $

**Help:** Material, handling, sorting, line disruption and replacement freight per reject.

**Outputs:**

#### Supplier A landed unit price

**Key:** landed_a

**Expr:** price_a * (1 + adder_a / 100)

**Format:** currency

#### Supplier B landed unit price

**Key:** landed_b

**Expr:** price_b * (1 + adder_b / 100)

**Format:** currency

#### Supplier A annual TCO

**Key:** tco_a

**Expr:** annual_units * landed_a + annual_units * reject_a / 100 * cost_per_reject

**Format:** currency

**Primary:** true

#### Supplier B annual TCO

**Key:** tco_b

**Expr:** annual_units * landed_b + annual_units * reject_b / 100 * cost_per_reject

**Format:** currency

**Primary:** true

#### Annual saving from choosing B

**Key:** saving_b

**Expr:** tco_a - tco_b

**Format:** currency

**Description:** Negative means B costs more in total.

#### Supplier A TCO per unit

**Key:** unit_tco_a

**Expr:** tco_a / annual_units

**Format:** currency

#### Supplier B TCO per unit

**Key:** unit_tco_b

**Expr:** tco_b / annual_units

**Format:** currency

#### Break-even reject rate for B

**Key:** breakeven_b

**Expr:** (tco_a - annual_units * landed_b) / (annual_units * cost_per_reject) * 100

**Format:** percent

**Description:** Above this reject rate, Supplier B costs more than A in total.

**Chart:**

#### Annual TCO vs Supplier B reject rate

**Type:** line

**X:** reject_b

**From:** 0

**To:** 10

**Steps:** 20

**Series:**

- tco_a
- tco_b

**Disclaimer:** Planning model. Add inventory carrying cost for longer lead times and currency risk separately if they are material to your decision.

## Content

**Intro:** The cheapest quote on the RFQ is rarely the cheapest part by the time it is on your shelf and through your line. This tool compares two suppliers on landed price plus the expected cost of rejects, and tells you the reject rate that flips the decision.

**Sections:**

#### How to use it

**Body:** Enter annual volume and the two unit prices. Express freight, duty, brokerage and tooling amortization as a percent of price for each supplier, using actual quotes from your forwarder or customs broker. Enter an expected reject rate for each, using history for the incumbent and a prudent assumption or first-article data for the challenger. The cost per rejected unit should include everything a reject triggers, not just the lost part.

**Bullets:**

- Use landed prices, not ex-works prices
- Use a conservative reject rate for a new supplier
- Include replacement air freight in cost per reject
- Run the chart before trusting a single point estimate

#### The formula

**Body:** Landed unit price equals quoted price times one plus the adder percentage. Annual TCO equals volume times landed price plus volume times reject rate times the full cost per reject. The break-even reject rate for Supplier B is the rate at which its TCO equals Supplier A's: A's TCO minus B's landed purchase spend, divided by volume times cost per reject. It is a quick way to see how much quality slippage a price advantage can absorb.

#### Reading the default case

**Body:** In the default example, Supplier B quotes about 12 percent lower, but duty and freight narrow the gap, and a 2.5 percent reject rate at $22 per reject takes much of what remains. The chart shows the two TCO lines crossing at the break-even reject rate. If you believe the challenger can hold a rate below that point and you can enforce it with a quality agreement, the move pays. If not, the quote is a false saving.

#### Common mistakes

**Body:** Do not ignore working capital: a longer sea freight lead time means more inventory and safety stock, which this model leaves out on purpose so the comparison stays transparent. Do not use the reject rate from a sample build for a production forecast. Finally, keep the same volume and specification for both suppliers, or the comparison is not like for like. Document the assumptions with the sourcing decision.

**Cta:** Netray can connect this comparison to your ERP purchase history and receiving data so the inputs update from real transactions rather than estimates.

**Faq:**

#### What is total cost of ownership in purchasing?

**Answer:** It is the full cost of acquiring and using a part: purchase price, freight, duty, quality failures, inventory, and support. Piece price is only one component, and often not the largest when the supplier is far away or less capable.

#### Where do I get the reject rate for a new supplier?

**Answer:** Use first-article and pilot lot results, the supplier's process capability data, and references. Then add a safety margin. A new supplier usually performs worse in the first year, so a conservative assumption is more honest.

#### Can the break-even be negative?

**Answer:** Yes. If Supplier B's landed price already exceeds Supplier A's total cost, no reject rate makes B cheaper and the result shows zero or a negative number. Treat that as a signal that A wins on cost under these inputs.

#### Does this include currency risk?

**Answer:** No. If you buy in a foreign currency, run the calculator at your expected rate and again at a stressed rate, then compare the two results. A hedging cost can also be added to the adder percentage.

## Search terms

supplier total cost of ownership calculator, tco supplier comparison, landed cost vs piece price, compare supplier quotes calculator, supplier quote comparison excel, total cost of ownership purchasing, break even reject rate supplier, sourcing decision calculator

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json