My Spreadsheet Died in the Pacific Ocean

In 2018, Trump's tariffs hit while the cargo was mid-ocean. I built the supply chain myself, and never saw it coming. Here's what I'd do completely differently today.

My spreadsheet died in the middle of the Pacific Ocean.

Not metaphorically.

The numbers literally stopped working while the cargo was mid-ocean.

And the worst part? I built the whole thing myself. From scratch. And I never saw it coming.

I Built It. That's What Made It Hurt.

In 2017, I joined a hotel construction company as COO. By late 2017, I had built a direct import supply chain from the ground up.

We were building 1 to 3 hotels a year. Good revenue. Solid reputation. The kind of company that operators are proud to run.

But I kept watching the same thing happen on every project.

We'd build the whole building, concrete, steel, structure, and then hand massive margin to outside vendors for everything that went inside it. Furniture. Lighting. Granite countertops. Shower doors. Lobby millwork. Artwork. Fixtures.

Every single thing a guest would actually touch.

The contractors trusted us to build the structure. The brands, Marriott, IHG, Wyndham, Choice, trusted us to deliver to their standards. But we were writing enormous checks to middlemen for the interior product.

So I asked a simple question: If customers trust us to build the hotel, why aren't we supplying everything inside it?

Nobody had a good answer.

The 9 PM to 3 AM Build

For six months, I worked full days on job sites, then came home and worked 9 PM to 3 AM with manufacturers in China.

Building relationships across time zones takes time. Building trust takes longer.

I learned how to spec products to brand standards. Marriott's finish requirements. IHG's FF&E specs. How to private label so the product met brand approval. How to navigate factory minimums, lead times, and QC processes from 10,000 miles away.

I built it. All of it. Relationships. Systems. Pricing models. The whole supply chain infrastructure from scratch.

It worked.

Revenue doubled. We scaled from 1 to 3 hotels a year to 5 to 7. We started capturing margin we had been giving away for years.

I was proud of what I built.

That pride is also what made me blind to what I didn't build.

The Day Everything Turned Red

In 2018, Trump's Section 301 tariffs landed, a 35% hit on the exact categories we were importing from China.

Ships already loaded. Contracts already signed. Projects already priced. Customers already committed.

I opened the spreadsheet and watched every single job turn red in real time.

And here's what I have to own: I never had a backup plan.

I had built a world-class supply chain for one scenario, stability. I had designed for efficiency, margin, and scale. What I had not designed for was disruption. I had no alternative sourcing mapped. No contingency pricing model. No early warning system watching for trade policy shifts that could blow up my unit economics overnight.

I was so focused on building the thing that I never stress-tested the assumption the whole thing was sitting on:

That the geopolitical environment would stay the same.

It didn't. And I had no system to tell me it was changing until it already had.

The Pivot (What Resourcefulness Actually Looks Like)

I had two choices:

→ Call it a lesson and rebuild slowly

→ Find a different ocean

So we went to work.

Calls at midnight. Emails before dawn. Research during lunch. Within weeks, we had identified alternative sourcing paths:

• Granite and quartz → Estonia
• Other categories → Vietnam and Southeast Asian markets

The business survived. Not because we had a plan. Because we moved fast once we had no other choice.

But here's what I've thought about ever since: survival mode is an expensive way to operate. The energy, the margin erosion, the relationship strain, the sleep, that's a tax you pay for not having systems that see it coming.

What I Would Do Completely Differently Today

This is the part most people don't talk about. Not just "what I learned", but what specifically I would have built to prevent it.

The answer isn't smarter instincts. It's better systems.

Here's what I'd have running today if I were building that supply chain from scratch:

1. Automated trade policy monitoring

An AI agent watching USTR filings, Federal Register updates, and Congressional trade committee activity, specifically filtered to the HS codes covering my product categories. When tariff language hits a threshold, I get an alert before it's news. Not after the ship is loaded.

2. Geopolitical risk scoring by country

A live dashboard scoring each sourcing country on key risk indicators: trade relationship stability, currency volatility, political risk indices, and past tariff history with the U.S. Not a perfect crystal ball, but a system that tells me when a country's risk profile is drifting before I have contracts signed.

3. Scenario pricing built into the model

Every job quoted with a 15%, 25%, and 35% tariff scenario pre-calculated. Not buried in a backup tab. Front and center. The moment I sign a contract, I already know what that contract looks like if the world changes. I'm not doing that math at 11 PM when the tariff hits.

4. Supplier diversification as a metric, not an afterthought

A simple rule: no single country accounts for more than 60% of a product category. Tracked. Enforced. Flagged automatically when a category drifts above threshold. Diversification isn't just a strategy, it's a KPI.

5. Weekly AI-synthesized briefings on sourcing risk

Every Monday morning, a briefing lands in my inbox: material shifts in trade policy, supplier country news, freight cost changes, and any new tariff proposals in my categories. Synthesized from multiple sources. Readable in 5 minutes. Actionable before the week starts.

None of this is futuristic. Every single one of these systems is buildable today. Most of them could be running in a week with the right tools.

I didn't have them. I had a spreadsheet and a work ethic.

The work ethic saved us. The spreadsheet died.

What This Has to Do With Your Business

The tariff conversation is loud right now.

I've been through it: not as an analyst, not as a consultant watching from the outside, but as the operator whose spreadsheet actually died mid-ocean with real contracts and real consequences on the other end.

And what I can tell you is this: most businesses are stress-testing the wrong things.

They're worried about interest rates, competitor pricing, and hiring. They're not asking the question that actually matters:

What's the assumption buried in your unit economics that you've never tested against a 35% external shock?

That assumption exists. In your pricing. In your supplier relationships. In your tech stack. In your operational infrastructure.

The businesses that survive disruption aren't always the smartest or the best-funded. They're the ones whose decision-makers are closest to the operational reality and moving before survival mode kicks in.

That's what AI gives you now. Not magic. Not a replacement for operator instinct. An early warning system so the first time you hear about the problem isn't the day your spreadsheet turns red.

The Question I'll Leave You With

What's the assumption buried in your business that hasn't been stress-tested yet?

Not the one you know about. The one you've been ignoring because things are working.

That's the one that matters. And now there are tools to find it before it finds you.