Tariff Rollout
See the exposure before it becomes a cash problem.
Figures above are the workbook's own illustrative test scenario ("Example Industrial Co."), included to show how the model behaves — not a live calculation.
The Problem
Tariff costs often sit between purchasing, logistics, accounting, and customer billing. Most companies can calculate a tariff percentage — the harder problem is connecting that percentage to the actual operational flow: which shipment it came from, which items it's attached to, whether it can be recovered from a customer, and when the cash is actually required. Without one operational view, exposure stays invisible until the cash is already due.
What the Tool Maps
Tariff Rollout is a shipment-first model: one record for the physical shipment or customs entry, with each part number listed as its own shipment line. Supplier POs are tracked as an optional reference, not a required key — a shipment doesn't need to map cleanly to one PO or one customer order.
What You Can See
The Dashboard rolls everything up into total duty and tariff, customer vs. stock exposure, and expected recovery — alongside control signals (unbalanced lines, unallocated units, uncovered customer tariff) and cash signals (peak planned import cash, lowest projected reserve, months below minimum, open critical/high actions). Duty and tariff are also broken out by month and by destination, so you can see when the exposure lands and where it's headed.
Designed for Real Shipment Flows
A single shipment can carry multiple part numbers, mixed customer orders and stocking inventory, and lines still in transit. Allocations split each shipment line between customer orders and stock; the model's key control is simply that allocated quantity must equal shipment-line quantity — so the Checks sheet can confirm everything reconciles before you trust the numbers above it.
What You Receive
A twelve-sheet Excel workbook: Start Here, Setup, Tariff Rates, Shipments, Shipment Lines, Allocations, Recovery, Inventory Impact, Cash Calendar, Actions, Dashboard, and Checks. Setup holds your planning assumptions (planning horizon, available import reserve, contingency cushion on estimated costs); Actions is a working register for classification, customer, and cash tasks with an owner, due date, priority, and status. The workbook ships pre-loaded with a fictional test scenario so you can see the model working before you clear it out and enter your own shipments.
How It Is Used
Capture the shipment → list its contents on Shipment Lines → allocate each line between customer orders and stock → plan customer recovery on the recoverable portion → let Inventory Impact and the Cash Calendar carry the rest → review exposure, timing, and exceptions on the Dashboard. A default contingency cushion covers the uncertainty in estimated costs; override it only when a specific shipment needs a different assumption. This is a planning aid for projected costs — actual transactions still belong in your accounting system once they occur, and HTS classification, origin, customs value, and entry timing should be confirmed with a qualified customs, legal, or accounting professional.