# Nearshoring Inventory and Lead Time Savings Calculator

> Source: https://netray.co/tools/nearshoring-inventory-and-lead-time-savings-calculator
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Estimate the inventory (pipeline, cycle and safety stock) and carrying cost you release by shortening lead time, and the price premium you can afford to pay.

## Category

supply-chain

## Region

Mexico

## Audience

- Supply chain director
- Procurement lead
- Finance analyst

## Tool

**Kind:** calculator

**Currency:** $

**Inputs:**

#### Annual purchase value from Asia

**Key:** annual_spend

**Type:** number

**Default:** 4000000

**Min:** 0

**Step:** 50000

**Unit:** $

**Help:** Annual spend on the parts you could move to Mexico, at current prices.

#### Mexico price premium

**Key:** premium

**Type:** slider

**Default:** 6

**Min:** 0

**Max:** 30

**Step:** 1

**Unit:** %

**Help:** How much higher the Mexican unit price is versus the current price.

#### Asia lead time (order to receipt)

**Key:** cn_days

**Type:** number

**Default:** 60

**Min:** 1

**Step:** 1

**Unit:** days

**Help:** Include production, ocean transit, port, customs and drayage.

#### Mexico lead time (order to receipt)

**Key:** mx_days

**Type:** number

**Default:** 10

**Min:** 1

**Step:** 1

**Unit:** days

#### Lead time variability (std dev as % of lead time)

**Key:** lt_sd_pct

**Type:** number

**Default:** 20

**Min:** 0

**Step:** 1

**Unit:** %

**Help:** Ocean freight often varies more than road freight; keep the same value to be conservative.

#### Demand variability (weekly std dev as % of average)

**Key:** cv

**Type:** number

**Default:** 30

**Min:** 0

**Step:** 1

**Unit:** %

#### Service level

**Key:** service

**Type:** select

**Default:** 0.95

**Options:**

##### 90%

**Value:** 0.9

##### 95%

**Value:** 0.95

##### 98%

**Value:** 0.98

##### 99%

**Value:** 0.99

#### Order interval from Asia

**Key:** interval_cn

**Type:** number

**Default:** 4

**Min:** 0

**Step:** 1

**Unit:** weeks

**Help:** Container and consolidation cadence.

#### Order interval from Mexico

**Key:** interval_mx

**Type:** number

**Default:** 1

**Min:** 0

**Step:** 1

**Unit:** weeks

#### Inventory carrying cost rate

**Key:** carry

**Type:** number

**Default:** 22

**Min:** 0

**Step:** 1

**Unit:** % per year

**Help:** Capital, storage, insurance, obsolescence and shrink.

**Outputs:**

#### Safety factor (Z)

**Key:** z

**Expr:** normsinv(service)

**Format:** decimal

**Description:** Normal distribution Z for the chosen service level.

#### Average inventory, Asia supply

**Key:** inv_cn

**Expr:** annual_spend / 365 * cn_days + annual_spend / 52 * interval_cn / 2 + z * sqrt((cn_days / 7) * pow(cv / 100 * annual_spend / 52, 2) + pow(annual_spend / 52 * cn_days / 7 * lt_sd_pct / 100, 2))

**Format:** currency

**Description:** Pipeline plus cycle plus safety stock at current prices.

#### Average inventory, Mexico supply

**Key:** inv_mx

**Expr:** annual_spend * (1 + premium / 100) / 365 * mx_days + annual_spend * (1 + premium / 100) / 52 * interval_mx / 2 + z * sqrt((mx_days / 7) * pow(cv / 100 * annual_spend * (1 + premium / 100) / 52, 2) + pow(annual_spend * (1 + premium / 100) / 52 * mx_days / 7 * lt_sd_pct / 100, 2))

**Format:** currency

**Description:** Same calculation at the higher Mexican price.

#### Working capital released

**Key:** released

**Expr:** inv_cn - inv_mx

**Format:** currency

**Primary:** true

**Description:** One-time reduction in inventory value.

#### Annual carrying cost saved

**Key:** carry_saving

**Expr:** (inv_cn - inv_mx) * carry / 100

**Format:** currency

#### Annual price premium paid

**Key:** premium_cost

**Expr:** annual_spend * premium / 100

**Format:** currency

#### Net annual effect (saving minus premium)

**Key:** net_annual

**Expr:** (inv_cn - inv_mx) * carry / 100 - annual_spend * premium / 100

**Format:** currency

**Primary:** true

**Description:** Positive means inventory savings alone cover the premium. Freight, duty and quality effects are not included.

#### Break-even price premium (approx.)

**Key:** breakeven

**Expr:** (inv_cn - inv_mx) * carry / annual_spend

**Format:** percent

**Description:** Premium at which carrying savings equal the extra price, ignoring second-order changes.

**Chart:**

#### Annual effect vs Mexico price premium

**Type:** line

**X:** premium

**From:** 0

**To:** 30

**Steps:** 30

**Series:**

- carry_saving
- premium_cost
- net_annual

**Disclaimer:** Inventory models are simplified. This tool covers pipeline, cycle and safety stock only. Add freight, duties, tariffs, exchange rates, quality cost, tooling and the cost of the transition using your own data and a landed cost comparison.

## Content

**Intro:** Moving supply from Asia to Mexico shortens the pipeline, reduces safety stock and lets you order in smaller lots. This calculator puts a dollar value on that inventory release and shows how much of a price premium it can pay for.

**Sections:**

#### How to use the calculator

**Body:** Enter the annual spend for the parts you would move, the lead times of both options and your demand variability. The model estimates average inventory in three components for each source, then multiplies the difference by your carrying cost rate. Change the Mexico price premium to see the net effect and read the break-even premium from the results. The chart sweeps the premium from zero to thirty percent.

#### The method behind it

**Body:** Pipeline inventory is spend per day times lead time, relevant when you own goods in transit. Cycle stock is half the order quantity, estimated as average weekly spend times the order interval divided by two. Safety stock is Z times the standard deviation of demand over lead time, combining demand variability and lead time variability: Z times the square root of lead time in weeks times the weekly demand variance, plus the squared weekly demand times the squared lead time deviation in weeks.

**Bullets:**

- Pipeline: daily spend times lead time
- Cycle: weekly spend times interval divided by two
- Safety: Z times demand-over-lead-time deviation
- Carrying saving: inventory difference times carrying rate

#### Reading the result

**Body:** A positive net annual effect means that inventory savings cover the price premium on their own. Even when the net is negative, the released working capital is a one-time cash benefit and the lower safety stock reduces stockout and obsolescence risk. Compare the net effect with the freight, duty and tariff difference in a landed cost model. Under USMCA, qualifying goods can enter the US duty-free, but you must hold origin documentation.

#### Common mistakes

**Body:** People often count the pipeline inventory even when the supplier owns goods until delivery under their terms, which overstates savings. Check your Incoterms. Others use the same order interval for both sources or ignore that a faster supplier needs a smaller interval to realize the benefit. Finally, remember that the Mexico lead time depends on whether the supplier holds materials locally or imports them from Asia itself.

**Cta:** If you want these numbers from your actual ERP data, such as real lead time distributions and demand variability by part, we can build a read-only analysis over your history.

**Faq:**

#### Does the model include freight and duty?

**Answer:** No. It isolates the inventory effect. Use a landed cost calculator for freight, duties and tariffs, then combine the two to compare total cost between sources.

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

**Answer:** Use your finance team's number. Typical ranges include cost of capital plus storage, insurance, shrink and obsolescence, often in the high teens to high twenties percent per year depending on the business.

#### Why does lead time variability matter?

**Answer:** Safety stock must cover both demand variation and the uncertainty of when parts arrive. Ocean freight can vary by weeks, which is a large driver of safety stock for Asian supply.

#### Is the break-even premium exact?

**Answer:** It is an approximation. The Mexican inventory itself costs more at a higher price, so the exact break-even is slightly lower. Use the chart for the precise crossing point.

## Search terms

nearshoring inventory savings, nearshoring lead time calculator, mexico vs china inventory cost, nearshoring working capital, safety stock lead time calculator, nearshoring break even price premium, inventory carrying cost nearshoring, reshoring total cost inventory

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