The Resourcing Decision Kit
Most resourcing business cases are wrong before anyone signs them.
They count the piece-price delta and forget the tooling, the PPAP, the safety-stock build and the air freight nobody budgeted. Then a Section 232 inclusion lands on the commodity and the whole case inverts. This kit is the model that catches all of it — should-cost, landed cost with the full 2026 duty stack, the real cost of moving, and the payback — on one page you can defend.
What you actually get
Three files. Instant download. Yours to keep and reuse on every part you touch.
Resourcing Decision Engine
A working model, not a blank template. Eight linked tabs that take one part and compare six sourcing options end to end — bottom-up should-cost, the full duty stack, statutory fees at their published FY2026 rates, the one-time cost of moving, payback, NPV and a weighted risk score. Every formula is live and visible. Nothing is locked away from you.
Supplier Transition Plan
The eight-week sequence for moving a part without stopping the line — nine phases, each with the exit gate you do not pass without. Plus the six failure modes that kill resourcing programmes, and what prevents each one.
RFQ Package Standard
Ten sections that make quotes comparable, and the reason each one moves a price by double digits. The most common sourcing mistake is not overpaying — it is comparing two quotes that priced different things.
Why the duty stack is the part everyone gets wrong
There is no such thing as a country tariff rate. Your duty is a stack — the base HTS rate, plus Section 232 if your commodity is in scope, plus Section 301, plus any antidumping or countervailing order — and it turns on your specific 10-digit classification, origin and entry date. Free calculators give you one number. This model makes you build the stack, because that is where the money is.
It moved four times in six weeks
Between July and August 2026 alone: a Section 301 forced-labour tier replaced the flat Section 122 rate, Commerce opened comment on extending 232 to more steel and aluminium derivatives, and new 232 proclamations landed on polysilicon and on drones. The Rate Library tab dates and sources every one.
A whole programme disappeared
In February 2026 the Supreme Court struck down the IEEPA tariffs, removing the country-specific reciprocal surcharges that had run from 10% to nearly 50%. Any model still carrying those numbers is overstating landed cost today.
Blank inputs pick fake winners
The option with the most missing data always looks cheapest, because a blank cell costs nothing. The Decision tab refuses to return a verdict until the inputs are actually there, and names which one is missing.
Who built it
Seventeen years in global supply chain, procurement and strategic sourcing — a Fortune 500 industrial manufacturer, Polaris, Blue Bird, Warn Automotive, BorgWarner. Directed more than $1.58 billion in managed spend and delivered over $128.5 million in savings.
Karrass-trained negotiator. Executive MBA. The eight-week transition plan in this kit is the sequence used to move a PCBA from China to Mexico in eight weeks during the chip shortage — gates included, because that is what made it hold.
The model is the one I would build for a client. The difference is that here you get the model instead of the invoice.
If you want it done for you
The Sourcing & Spend Diagnostic
Some people would rather hand over the spend file than build the model. The diagnostic does this across your portfolio rather than one part — finds where the cost and duty exposure actually sits, and hands back a prioritised plan with numbers attached.
Talk about the diagnostic →Straight answers
Are the tariff rates in it current, and will they stay current?
They were verified against USITC, CBP and Federal Register sources on 20 August 2026, and every single one carries its source and date on the Rate Library tab. They will go stale — that is the nature of 2026, not a flaw in the model. The engine is built so you update a rate in one place and the whole workbook follows. It is a calculator you own, not a feed you rent.
Is this just a spreadsheet template?
No. The formulas are built and working — open it, and the worked steel-bracket example computes through all eight tabs. Statutory fees are implemented properly, including the MPF floor and cap per entry and the fact that HMF applies to ocean arrivals but never to overland freight from Mexico. That distinction alone is one most models get wrong.
Do I need to be a customs expert?
No, but you do need your own HTS code. The model will not guess it for you, and it will not let you pretend you have it — the completeness check blocks the verdict until you enter one. Look it up free at hts.usitc.gov, or ask your broker for the code they already file under.
Excel or Google Sheets?
Built and tested as .xlsx. It opens in Excel, and imports into Google Sheets and LibreOffice Calc — the formulas are all standard functions, with nothing exotic and no macros.
What if it is not useful to me?
Fourteen days, full refund, reply to your receipt. No form and no explanation required. You keep the files either way — chasing digital downloads back is not a business I want to be in.
Checkout
Secure payment handled on this page. Card details go straight to Stripe — they never touch this site. Your three files are emailed the moment payment clears.
Trouble with the form? Open checkout in a new tab instead.