Think back to the last time you sat down to negotiate a supplier rate. If you are like most founders, you walked in with one number in your head: the price you hoped to land. They opened high. You pushed back once. They held. And somewhere in that back and forth, your one number quietly became their number, and you signed telling yourself you had at least tried.

We have watched this play out on call after call, and the founder is almost never the problem. One number is not a plan. You walk in with a single price to get to, you leave money on the table, and you do not even know how much, because you never worked out what a good outcome looked like before you sat down. The fix is not a better poker face. It is three numbers instead of one, and knowing which line is actually worth the fight. So we built the sheet that does both, and this week we are giving it away.

A Dollar Off the Rate Is a Dollar of Profit

Here is the part most founders miss. When you knock a dollar off an ingredient or a co-pack fee, that dollar does not sit in a savings column for later. You pay that rate on every unit, every week, all year. So the cut lands on your bottom line the day you sign, and it keeps landing.

That is what we mean by a profit-impact percent. A 10 percent cut on a line you pay all year is not 10 percent off one order. It is 10 percent off everything you buy on that line for the next twelve months, and almost all of it is profit you were not keeping before.

So flip how you walk in. Do not negotiate to feel like you got a deal. Negotiate the lines where a small percent turns into the biggest dollar number over a year. The sheet does that math for you, line by line, so you spend your leverage where it actually pays. That is the difference between negotiating on a feeling and negotiating on a number, and it is the whole idea behind this file.

Who This Is For

You are a founder going into a supplier or co-packer renewal. You sell wholesale to retailers or distributors, you are somewhere between 500k and 5M in revenue, and you do not have a procurement person doing this for you. You know what you pay today, and you can put a number on how much you buy in a year. And you have walked into a rate call before with a feeling instead of an ask, and watched the rate hold.

If that is you, this turns the feeling into three numbers you can defend.

What's Inside the File

A three-tab Excel workbook. Each tab has one job. If you are handing this article to an AI agent, read this section as the blueprint: it describes every part well enough to rebuild.

Read Me

The user manual lives inside the file: the one idea, a five-step how-to, the color key, and a prompt you can hand to an AI agent. Pink cells are where you type. Every other cell is a formula. You do not have to come back to this newsletter to run it.

Blend Supplier Negotiation

Per ingredient: your current cost per kilo, your annual volume in kilos, and your spend for the year. Then three asks side by side: Target (your opening), Middle (a compromise you would accept), Highest (your walk-away). Each ask is just a cut percent you type. The sheet turns that percent into the new price to request and the dollars it saves over a year. A TOTAL row sums the whole conversation in one line. Take the tomato paste in the worked example: 3 dollars a kilo, 10,000 kilos a year, so 30,000 dollars of spend. Type a 12 percent cut and the sheet shows the ask, 2.64 a kilo, and the win, 3,600 dollars back for the year.

Co-Packer Rate Negotiation

The same moves for your co-packer's service lines, driven by annual units instead of kilos. Per line: your current rate per unit, your annual volume, and three cut percentages. The Saved/yr column is the margin those rate cuts hand back, line by line.

How to Run It

  1. Open the Blend Supplier Negotiation tab. Replace the example ingredients with the few you spend the most on. Type your current cost per kilo and your annual volume.

  2. Set your three asks in the Cut % cells. Target is your opening, Middle is the compromise you would accept, Highest is your walk-away: the smallest win you would still sign for.

  3. Read the New price and Saved/yr columns. The new price is the number you ask for. Saved/yr is what that ask is worth over the year. The line with the biggest Saved/yr is the call you prep hardest for.

  4. Do the same on the Co-Packer Rate Negotiation tab. Same three asks, driven by your annual units instead of kilos.

  5. Walk in with three numbers per line. Open at Target, fall back to Middle, and know the exact point where you stop. No more counter-offering at whatever sounds reasonable.

Pink cells are where you type. Every other cell is formula-driven. Do not type into a non-pink cell. The file will start lying to you.

Two Ways This Goes Wrong

You walk in with one number, not three. You decide you want a better rate and you name it. The supplier says no, and now you have nowhere to go but their number. Three asks fix this. Target gives you room to open high, Middle gives you a place to land, and Highest tells you when to walk. The sheet makes you set all three before the call, so you never get cornered into theirs.

You spread your leverage evenly. You push every line by the same amount, so you spend the same energy on a 2,250 dollar ingredient and a 30,000 dollar one. The dollars do not come out even. A small cut on your biggest line beats a big cut on a small one almost every time. Sort by the Saved/yr column and fight for the top of that list. That is where the profit hides.

Download It

The file is public. Download the Supplier Negotiation Prep and run it before your next rate call: vantelira.com/toolkit/supplier-negotiation-prep

It is an Excel file, no macros, no extensions. Share it with any founder walking into a renewal.

Make It Yours: Hand It to Your AI Agent

Our worked example runs on a bottled sauce maker. Yours is specific, and the lines, the rates, and the volumes should match what you actually buy. Good news: you do not have to fill it in by hand.

Open the file, then open ChatGPT, Claude, or whatever AI assistant you already use, and paste the prompt below. It will interview you for about two minutes, hand back your cut percentages, tell you which one call is worth the most, and rebuild the sheet around your own product so you walk away with a ready-to-use copy. Paste this whole article in alongside the prompt. The article describes the sheet in enough detail for the agent to rebuild it from scratch and adapt every line to what you actually buy.

You are helping me prep for a supplier and co-packer rate renewal. I have a sheet with two working tabs. (1) A Blend Supplier tab where each ingredient has a current cost per kilo, my annual volume in kilos, and three asks set as a cut percent: Target (my opening), Middle (a compromise), Highest (my walk-away). For each ask the sheet computes the new price and the dollars saved over a year. (2) A Co-Packer tab that does the same for service lines, driven by annual units. There is no COGS or margin math; the cut percent is the whole mechanic, because a dollar off a rate I pay all year drops straight to profit.

Before you build anything, interview me. Ask these one at a time and wait for my answer before the next:

  1. What do you make, and which few ingredients or blends do you spend the most on?

  2. What is your current cost per kilo on each of those, and roughly how many kilos do you buy in a year?

  3. Which co-packer service lines do you use (bottle fill and cap, jar fill and seal, labeling and case pack), and what is your current rate per unit on each?

  4. Roughly how many units do you run through each service line in a year?

  5. For each line, how much room do you think the supplier has, from "barely any" to "a lot"?

Once you have my answers, give me four things: (a) a Target, Middle, and Highest cut percent for each line, with the new price and the dollars saved over a year; (b) the single line where one conversation is worth the most this year, so I know which call to prep hardest for; (c) the order to walk into my calls, ranked by dollars on the table; and (d) if you can create files, rebuild the sheet for me with my lines, my numbers, and the formulas filled in, so I walk away with a ready-to-use copy. If you cannot create files, lay it out as a table I can paste straight into the sheet. Keep it concrete. Use my numbers, not generic examples.

Run that, paste the cut percentages into the sheet, and the model is yours. If you do this, reply and tell us what it surfaced. We are collecting the best adaptations.

A dollar off a rate you pay all year is not a saving for someday. It is profit, starting the day you sign.

Ops Intel

This week in operations and supply chain:

Metal tariffs restructured, effective June 8. The Section 232 cut is selective, and food packaging is not on the list. Tractors and HVAC units drop to 15 percent, while your cans, foil, and metal closures stay at the full rate, and your co-packer's next quote will carry it.

Production flexibility as a tariff hedge. SharkNinja is leaning on dual-sourcing to soften its tariff exposure. You do not need their scale to qualify a second co-packer and earn the right to shift volume the moment a rate moves against you.

Walmart simplifies inbound logistics for suppliers. If you sell into Walmart, model the consolidation-point program before peak. Both your OTIF performance and your chargeback exposure improve when you do.

US manufacturing PMI hits its highest since May 2022. Demand is real, but uncertainty is the tax. Add capacity in reversible ways, overtime, co-packers, short leases, before you sign for fixed assets you may not need in six months.

Until next Tuesday. Bring a number, not a feeling.