Supply Chain Friendshoring Risk Calculator

Introduction: Why supply-chain friendshoring matters

Supply-chain friendshoring asks whether a lower-priced source in a higher-risk country remains economical after expected interruptions, tariffs, and the cost of lost responsiveness are considered. Geopolitical tensions, trade restrictions, port closures, and other disruptions can expose dependencies that a purchase-price comparison does not show. This calculator gives operations and finance teams a way to compare that exposure with the annual cost of sourcing from an allied supplier.

Friendshoring is a risk-management choice rather than a simple preference for one geography. A disruption can create lost sales, expedited freight, emergency sourcing premiums, or delayed production even when the original supplier has the lowest quoted price. The comparison separates those expected costs from the allied option's direct cost, residual disruption exposure, lead-time benefit, and one-time move cost.

Understanding the supply-chain friendshoring inputs

For this friendshoring comparison, annual import volume is the yearly dollar value sourced from the high-risk country. Annual disruption probability is the estimated chance of a meaningful interruption in a year. Cost impact of disruption is the share of that annual volume represented by the loss or delay if an interruption occurs; it can reflect lost margin, expedited freight, emergency purchases, or other costs expressed as a percentage of volume. Projected tariff increase is applied directly to the high-risk annual volume.

The allied supplier cost is the expected annual spend after moving the supply relationship. Transition and tooling cost is added once at the start of the allied scenario. Lead-time reduction multiplied by value per day is subtracted from that scenario's annual cost, representing the annual value assigned to shorter lead times. The horizon and discount rate determine the present-value comparison. Residual disruption probability and impact recognize that an allied source can still experience disruptions; unlike the high-risk scenario, the calculator does not add a tariff-risk percentage to the allied supplier cost.

Calculating friendshoring risk-adjusted costs

This friendshoring calculator first adds the high-risk source's expected disruption cost—annual volume times disruption probability times disruption impact—and its expected tariff cost—annual volume times tariff increase—to annual volume. For the allied source, it adds expected residual disruption cost to allied annual cost and then subtracts lead-time savings. It repeats each annual cost for the selected number of years, discounts each year, and adds the one-time transition cost only to the allied scenario.

In the friendshoring NPV expression, $C_t$ is the risk-adjusted annual cost in year $t$, $d$ is the discount rate, and $C_{\mathrm{transition}}$ is the one-time transition cost. For the high-risk sourcing scenario, transition cost is zero. Comparing the two present values indicates which set of entered assumptions produces the lower discounted cost.

Worked example: electronics friendshoring decision

Consider an electronics manufacturer importing $25 million in components from a country exposed to sanctions. Its team estimates a 20 percent annual disruption probability, a disruption impact equal to 50 percent of volume, and a 12 percent tariff increase. An allied supplier would cost $27.5 million per year and require $1.2 million for transition and tooling. The move reduces lead time by 20 days, valued at $15,000 per day, and the company uses a five-year horizon with a 7 percent discount rate. Residual disruption probability is 4 percent and residual impact is 20 percent.

Under those inputs, the high-risk supplier has a $2.5 million expected annual disruption cost and a $3 million expected annual tariff cost, for a $30.5 million annual risk-adjusted cost. The allied supplier has a $220,000 expected annual disruption cost; after the $300,000 annual lead-time saving, its annual cost is $27.42 million. Discounted over five years, the high-risk scenario is approximately $125.1 million and the allied scenario is approximately $113.6 million including the $1.2 million transition cost. The result follows from the stated assumptions, not from a guarantee that every disruption will occur.

Comparison table: friendshoring disruption sensitivity

This supply-chain friendshoring sensitivity view keeps the example's other assumptions unchanged and varies only the high-risk supplier's annual disruption probability.

In this example, friendshoring remains lower even at the 10 percent disruption assumption because the allied annual cost after lead-time savings is lower than the high-risk scenario after tariffs and expected disruption costs. In a different sourcing case, the break-even point can change materially with the annual volume, tariff estimate, lead-time value, transition cost, residual risk, and discount rate. Run the friendshoring calculation with a second documented scenario before using it in a sourcing decision.

Supply-chain friendshoring governance considerations

Friendshoring assumptions deserve the same review as supplier quotations. Procurement can validate capacity, finance can test the discount rate and transition budget, and risk or security teams can document the evidence behind disruption and tariff assumptions. Long-term contracts, capacity reservations, and a diversified raw-material base may change the inputs, but they are not automatically reflected unless their cost or risk effect is entered in the model.

For a friendshoring review, retain the source and date for each assumption, including supplier pricing, tariff outlook, lead-time estimate, and disruption assessment. Revisit the analysis when supplier performance, trade policy, or operating conditions change. The page can export the entered assumptions and calculated values to CSV after a result is generated, which can support an internal review record.

Integrating friendshoring scenario planning

Friendshoring scenario planning is useful because disruption probabilities and tariff expectations are uncertain. Run separate cases for the assumptions your team considers plausible, such as a lower, central, and higher disruption probability, rather than treating one output as a forecast. The result shows how the NPV difference responds to the values entered for each case.

When presenting a friendshoring comparison, distinguish modeled costs from qualitative consequences. Customer retention, reputation, intellectual-property exposure, and strategic access to materials may influence a sourcing decision but are not separate fields in this calculator. If a team can defensibly express a disruption-related financial consequence as a share of annual volume, it may be considered when setting the disruption-impact assumption; otherwise, document it alongside the numeric result rather than implying the calculator has measured it.

Financing a supply-chain friendshoring transition

A supply-chain friendshoring move can require upfront cash for tooling, qualification, audits, inventory overlap, or deposits. Enter the applicable one-time amount as transition and tooling cost so it is included at the start of the allied scenario. Lead-time benefits are modeled separately as lead-time reduction times value per day, reducing the annual allied cost in every year of the selected horizon.

Negotiated pricing, incentives, shared capacity investments, and changes in safety-stock requirements can alter the economics, but their treatment should match the fields available. Update the allied supplier annual cost when negotiations change recurring spend, update transition cost when a one-time amount changes, and use the lead-time fields only for an annual value that can reasonably be tied to the specified day reduction.

Operational discipline after supply-chain friendshoring

After a supply-chain friendshoring decision, monitor whether the realized costs and service conditions still resemble the assumptions used in the comparison. Allied suppliers can face capacity constraints, logistics failures, quality issues, and regional concentration risk, which is why the calculator includes residual disruption probability and impact rather than assuming zero risk.

Periodic recalculation can reveal whether changes in supplier cost, lead time, tariffs, or disruption exposure affect the relative NPV. This calculator compares two aggregated sourcing scenarios; it does not allocate volume among several suppliers. Teams evaluating a multi-source network should prepare separate, clearly defined scenarios and avoid treating a single output as a complete network design.

Friendshoring calculator limitations and ongoing refinement

This friendshoring calculator reduces a complex sourcing decision to annual dollar amounts, probability and impact percentages, a lead-time value, and discounted cash flows. It assumes the annual risk-adjusted cost stays constant through the selected horizon and applies the transition cost once. It does not model changing annual volumes, exchange rates, contract penalties, tax treatment, component-level dependencies, or a phased migration unless those effects are reflected in the entered assumptions.

Use the result as a transparent comparison of the stated assumptions, then supplement it with supplier due diligence, legal review, capacity analysis, and operational feasibility work. A careful friendshoring decision should make both the modeled cost tradeoff and the unmodeled strategic considerations visible to the people responsible for procurement, finance, and continuity of supply.

How to use this friendshoring risk calculator

1. Enter Annual Import Volume from High-Risk Country ($) as the annual dollar value currently sourced from the higher-risk location.
2. Enter Annual Probability of Disruption (%) as your estimated yearly likelihood of a material supply interruption.
3. Enter Cost Impact of Disruption (% of volume) as the portion of annual volume represented by disruption-related cost if that event occurs.
4. Complete the supplier, tariff, transition, lead-time, horizon, discount-rate, and residual-risk fields, then evaluate the friendshoring result against another documented set of sourcing assumptions.

Formula: how the friendshoring estimate is built

The high-risk annual cost equals annual import volume plus annual volume multiplied by disruption probability and disruption impact, plus annual volume multiplied by projected tariff increase. The allied annual cost equals allied supplier cost plus allied supplier cost multiplied by residual disruption probability and residual disruption impact, minus lead-time reduction multiplied by value per day of lead time. Enter dollar fields as dollars, percentage fields as percentages, lead-time reduction as days, and the analysis horizon as years.