Make-Buy, Outsourcing & Network Design calculator
Insourcing Payback Calculator
Insourcing payback period tells you how many years it takes for the savings from making a part in-house to repay the capital you spent on machines, tooling, and setup. Operations managers and plant controllers run it when deciding whether to pull a job back from a contract shop. It cuts through gut-feel reshoring arguments by netting recurring support costs against gross savings before dividing into the up-front investment. A short payback (under two years) usually clears the bar for a make-vs-buy switch; a long one signals the volume or margin isn't there yet.
What this calculator does
- Estimate insourcing payback for make-buy, outsourcing and network design using production-ready inputs so teams can screen a capital project before a detailed business case.
- Use it when insourcing payback in make-buy, outsourcing and network design is being put in front of a capital committee and the savings story needs to hold up.
- It divides the up-front insourcing investment by the net annual savings (gross savings minus added in-house support cost) to return a payback period in years.
Formula used
- Net annual insourcing payback savings = annual insourcing payback savings - annual insourcing payback support cost
- Insourcing payback payback period = insourcing payback investment ÷ net annual savings
- Five-year ROI = five-year net value ÷ investment × 100
Inputs explained
- Equipment and setup investment to bring work in-house:
- Annual savings vs. current outsourced spend:
- Annual added in-house support and labor cost:
How to use the result
- Use it when evaluating whether to reshore or in-source a part currently bought from a contract manufacturer, before committing capital to equipment and qualification.
- It assumes savings and support costs stay flat every year and ignores the time value of money, ramp-up scrap, and demand changes, use NPV or IRR for capital decisions above a few hundred thousand dollars.
Current U.S. benchmarks
- USITC reported an average effective tariff statistic — a calculated-duty rate of 12.4% of covered customs value in 2025 across the 57 manufacturing import families MFG Calcs tracks, up from 3.3% the year before. This is a statistical aggregate, not verified cash paid or an entry-specific legal rate. Statutory and effective rates by family are at mfgcalcs.com/tariffs.
- Sourcing currencies as of 2026-10-02 (Federal Reserve H.10): 6.7038 CNY and 18.192 MXN per USD. Landed-cost comparisons move with these daily rates.
- U.S. iron and steel import customs value ran $2.2B in Aug 2026 (Census International Trade). The U.S. ran a trade deficit of $0.6B in the category that month. This dollar total mixes price, quantity, product mix, origin, and timing; it does not measure physical import volume or prove a tariff or reshoring effect.
Common questions
- How do you calculate insourcing payback period? Subtract the added annual in-house support cost from the gross annual savings to get net annual savings, then divide the investment by that figure. With a $25,000 investment, $18,000 savings, and $2,500 support cost, net savings are $15,500/yr and payback is 25000 / 15500 = 1.61 years.
- What is a good insourcing payback period? Most plants want under 2 years for discretionary insourcing and under 3 years for strategic capacity moves. The 1.61-year result in the worked example is firmly in attractive territory.
- Why subtract support cost from savings? Bringing work in-house adds recurring cost, operators, maintenance, utilities, indirect labor. Only the net of gross savings minus those added costs actually pays back the investment, so using gross savings alone overstates the case.
- What is the five-year value of insourcing? Multiply net annual savings by five and subtract the investment. Here that is $15,500 x 5 - $25,000 = $52,500 of net value over five years, assuming volumes hold.
- Insourcing payback vs. NPV, which should I use? Payback is a fast screen that ignores discounting; NPV accounts for the time value of money and the full asset life. Use payback to triage candidates, then run NPV on the survivors before signing a capital request.
- What happens to payback if volume drops? Savings scale with volume, so a 20% volume drop cuts gross savings roughly 20% while support cost stays sticky, net savings fall faster than that and payback lengthens. Always stress-test the result against your low-demand scenario.
Last reviewed 2026-08-12.