To build a vendor price comparison sheet, list your top 20 to 30 purchased items in rows, put each supplier's price per identical unit in columns, add your weekly usage, and let a formula flag the lowest price and the dollars you would save. Compare the same pack size and grade, check delivery fees and minimums, and repeat the exercise every quarter. Most owners find at least a few items where a second vendor beats the primary by 5% to 15%.
Why a comparison sheet beats gut feel
Rep relationships are valuable, but prices drift. A distributor who was competitive in January may be 8% high on chicken by October, and you will not notice if you only see invoices one at a time. A single sheet puts every price side by side so the decision becomes arithmetic. It also gives you hard numbers for negotiating better prices with your vendors.
Step 1: Pick the items that matter
You do not need to compare every can of tomatoes. Pull your last three months of invoices and rank items by total dollars spent. The top 20 to 30 usually cover 70% to 80% of purchasing. Proteins, dairy, produce, oil and paper goods are the usual suspects.
Step 2: Standardize the unit
This is where most comparisons go wrong. One vendor quotes a 40 lb case, another a 10 lb bag. Convert everything to a price per pound, per each or per ounce before comparing. The method is in calculating cost per ounce and per serving. Also match the grade: "choice" and "select" beef are different products.
Step 3: Get real quotes
Ask two or three vendors for written quotes on your list, using the same unit and delivery schedule. Tell them it is a competitive bid; you do not have to be coy about it. Record the date, since prices move weekly on commodities.
| Item | Vendor A | Vendor B | Vendor C | Weekly use | Weekly savings (best vs A) |
|---|---|---|---|---|---|
| Chicken thigh (lb) | $2.85 | $2.70 | $2.95 | 120 | $18.00 |
| Ground beef (lb) | $4.60 | $4.75 | $4.50 | 90 | $9.00 |
| Yellow onions (lb) | $0.62 | $0.58 | $0.66 | 60 | $2.40 |
| Fry oil (35 lb jug) | $38.00 | $36.50 | $39.00 | 4 | $6.00 |
Those four lines alone save about $35 a week, or roughly $1,800 a year, before you look at the rest of the list.
Step 4: Count the hidden costs
The lowest sticker price is not always the lowest cost. Add:
- Delivery fees and fuel surcharges
- Order minimums that push you to over-buy
- Payment terms (net 30 beats cash on delivery for cash flow)
- Short ships, substitutions and credit hassles
- Delivery windows that disrupt your prep
A vendor that is 3% cheaper but short-ships twice a week can cost more once you pay a staffer to run to the store.
Step 5: Split your purchasing wisely
You rarely need to switch everything. Many owners keep a primary distributor for convenience and volume rebates, then buy a handful of high-spend items from a cheaper specialist, such as a local produce or protein supplier. Keep enough volume with your primary to protect your relationship and your pricing tier. See how to choose and manage food suppliers for vetting tips.
Step 6: Re-run it every quarter
Set a calendar reminder. When commodity prices swing, as with egg price spikes or high beef prices, run it monthly. Update your recipe costs afterward so your menu pricing reflects reality.
Common mistakes
- Comparing different pack sizes or grades.
- Ignoring delivery fees and minimums.
- Switching vendors for a tiny saving and losing priority on shorted weeks.
- Never telling your current rep you are getting quotes.
A vendor comparison sheet turns a gut-feel purchasing habit into a quarterly savings check. Compare unit prices on your top 25 items, count the hidden costs, and keep one primary vendor for leverage.
Use your POS data to set usage
Weekly usage is the number that makes savings real. Your sales mix tells you how much of each ingredient you really use. Cobblestone POS is a free, all-in-one POS for independent restaurants with item-level reporting and no monthly fee, so you can size your orders from actual sales instead of guesses, without the $470-plus a month some competitors charge. Download the worksheet below, plug in your numbers and see what a second quote is worth.
Free Vendor Price Comparison Worksheet (Excel).