# Supplier Total Cost of Ownership Comparison Worksheet

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

## Short answer

Compare suppliers on landed, quality and inventory carrying cost per unit to find the lowest total cost, not just the lowest price.

## Category

supply-chain

## Audience

- Buyer
- Sourcing manager
- Procurement analyst

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Supplier

**Key:** supplier

**Type:** text

#### Unit price

**Key:** unit_price

**Type:** number

**Format:** currency

#### Freight per unit

**Key:** freight

**Type:** number

**Format:** currency

#### Duty %

**Key:** duty_pct

**Type:** number

#### Reject rate %

**Key:** reject_pct

**Type:** number

#### Cost per reject

**Key:** rework_cost

**Type:** number

**Format:** currency

**Help:** Handling, rework, scrap, line disruption

#### Lead time (days)

**Key:** lead_days

**Type:** number

#### Carrying cost % per year

**Key:** carry_pct

**Type:** number

#### Tooling per unit

**Key:** tooling

**Type:** number

**Format:** currency

#### Annual quantity

**Key:** annual_qty

**Type:** number

#### TCO per unit

**Key:** tco_unit

**Type:** number

**Expr:** unit_price + freight + unit_price * duty_pct / 100 + reject_pct / 100 * rework_cost + unit_price * carry_pct / 100 * lead_days / 365 + tooling

**Format:** currency

#### TCO per year

**Key:** tco_annual

**Type:** number

**Expr:** tco_unit * annual_qty

**Format:** currency

**Rows:**

**Supplier:** Domestic Machining Co

**Unit price:** 14.8

**Freight:** 0.35

**Duty pct:** 0

**Reject pct:** 0.8

**Rework cost:** 45

**Lead days:** 21

**Carry pct:** 20

**Tooling:** 0.1

**Annual qty:** 12000

**Tco unit:** 0

**Tco annual:** 0

**Supplier:** Offshore Supplier A

**Unit price:** 10.9

**Freight:** 1.1

**Duty pct:** 5

**Reject pct:** 4

**Rework cost:** 45

**Lead days:** 70

**Carry pct:** 20

**Tooling:** 0.25

**Annual qty:** 12000

**Tco unit:** 0

**Tco annual:** 0

**Supplier:** Nearshore Supplier B

**Unit price:** 12.6

**Freight:** 0.6

**Duty pct:** 0

**Reject pct:** 1.5

**Rework cost:** 45

**Lead days:** 35

**Carry pct:** 20

**Tooling:** 0.15

**Annual qty:** 12000

**Tco unit:** 0

**Tco annual:** 0

**Totals:**

#### Lowest TCO per unit

**Key:** tco_unit

**Agg:** min

**Format:** currency

#### Highest TCO per unit

**Key:** tco_unit

**Agg:** max

**Format:** currency

**Summary:**

#### Spread between best and worst TCO

**Key:** spread

**Expr:** (max_tco_unit - min_tco_unit) / min_tco_unit * 100

**Format:** percent

**Primary:** true

**Description:** How much more the most expensive supplier costs than the cheapest on a total cost basis.

**Notes:** Carrying cost is applied to unit price over the lead time as a simple proxy for pipeline and safety inventory. Add rows for each supplier and edit the example numbers. Add quality, delivery or risk adjustments in Excel if your policy uses them.

## Content

**Intro:** The cheapest unit price is rarely the cheapest supplier. This worksheet puts price, freight, duty, quality losses, inventory carrying cost and tooling on one line per supplier, so you can compare total cost per unit and per year, then export the table to Excel.

**Sections:**

#### How to use the TCO worksheet

**Body:** Add one row for each supplier you are comparing. Enter the quoted unit price, freight per unit, import duty percent, expected reject rate, the cost each reject causes, the lead time in days, your annual inventory carrying cost percentage, tooling cost spread per unit, and annual volume. The worksheet calculates total cost per unit and per year for every row and shows the spread between the best and worst. Use the same volume and the same assumptions for every supplier so only real differences move the result.

#### The cost elements and why they matter

**Body:** Price is the visible part. Freight and duty move the landed cost. Quality loss is the reject rate times the full cost of dealing with a reject, which is usually many times the part price once you count handling, rework, line stoppage and expediting. Lead time drives inventory: a longer pipeline ties up cash and needs more safety stock. Tooling and development are one-time costs that are easy to ignore if you only look at piece price. Together these explain why a supplier that is 25 percent cheaper on paper can cost more in practice.

**Bullets:**

- Landed cost: price plus freight plus duty
- Quality cost: reject rate x cost per reject
- Inventory cost: price x carrying % x lead time / 365
- Tooling: one-time cost spread per unit

#### Reading the result

**Body:** Look first at the ranking by TCO per unit, then at the spread. If the spread is small, other factors such as capacity, risk, financial health and relationship should decide. If the cheapest unit price becomes the most expensive TCO, the worksheet has done its job. Test sensitivity by changing the reject rate and lead time, because those are usually the least certain inputs. If the winner changes when a reasonable input moves, treat the decision as close and look for more evidence, such as a trial order.

#### Common mistakes

**Body:** The biggest mistake is leaving out the cost of a quality failure, which makes offshore sources look better than they are. The next is using different volumes or different Incoterms across suppliers. Do not mix delivered and ex works prices without adding freight. Do not assume a past reject rate for a new supplier; use a conservative estimate until you have data. Finally, do not ignore currency risk, payment terms and supplier concentration. This worksheet covers cost; risk and capacity need a separate review.

**Cta:** If supplier quality, receipts and prices sit in your ERP, Netray can help you build a live TCO view that uses real reject and lead time history.

**Faq:**

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

**Answer:** Total cost of ownership is the full cost of buying and using a part or service, including price, freight, duty, quality losses, inventory carrying cost, tooling, and administrative effort. It shows the real cost of a supplier relationship, not only the quoted unit price.

#### How do I estimate cost per reject?

**Answer:** Add the part cost, inspection and sorting time, rework or scrap labor, line disruption, expediting and replacement freight. For parts that stop an assembly line, the cost per reject can be many times the unit price. Use finance and quality data where you can.

#### What carrying cost percentage should I use?

**Answer:** Many manufacturers use 15 to 30 percent per year, covering cost of capital, storage, insurance, handling and obsolescence. Ask your finance team for the figure they use for inventory decisions and apply it consistently across suppliers.

#### Should TCO be the only criterion for choosing a supplier?

**Answer:** No. TCO covers cost, but capacity, technical capability, financial stability, delivery performance, compliance and risk also matter. Use TCO alongside a weighted scorecard so that price does not outweigh factors that could stop your production.

## Search terms

total cost of ownership supplier comparison, supplier tco worksheet, supplier comparison excel template, total cost of ownership procurement, tco calculation purchasing, supplier cost comparison template, landed cost comparison suppliers, lowest total cost supplier

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