Start

Guides / Buyers / Guide 16

Free guide

Compare three supplier quotes

You will end with a side-by-side table that shows hidden differences in terms, lead time, and freight.

Difficulty: 1 of 5 stars, Starter+10 pts, points for this guide10-minute guide
ForBuyer
ToolClaudeExcel (optional)
  • TimeAbout 10 minutes
  • ToolsClaude, Excel (optional)
  • CostFree plan is fine to practice
Tools in this guideAll tools
  • Claude
    AI app. An AI chat app. You type or paste text, or add a file, and it writes back.
  • Excel (optional)
    Work tool. Microsoft's spreadsheet app.

01The problem

You have three quotes for the same part. One looks cheapest. But freight, minimums, and setup charges hide in the fine print. You need the real cost before you pick.

02What you need

  • Claude at claude.ai. The free plan works for practice.
  • Three quotes for the same part, as text. Copy them from the PDF or the email.
  • About 10 minutes.

Is the data safe to use? Real quotes hold prices and supplier names. Check your company rules before you paste them into any AI tool. To learn, use the sample quotes below.

Sample data / made up for this guide, not real suppliers or prices
QUOTE 1 (sample data)
From: Supplier A (sample)
Part: Steel bracket, zinc plated,
  part SAMPLE-1001
Price: $1.42 each
Minimum order: 1,000 pieces
Lead time: 3 weeks
Freight: FOB our dock. Buyer pays
  freight. Estimated $180 for
  2,000 pieces.
Terms: Net 30
Quote good for 30 days.
QUOTE 2 (sample data)
From: Supplier B (sample)
Part: Steel bracket, zinc plated,
  part SAMPLE-1001
Price: $1.35 each
Minimum order: 2,500 pieces
One-time tooling charge: $450
Lead time: 6 weeks after order
Freight: Prepaid and added to
  invoice.
Terms: Net 45
Price good for 15 days.
QUOTE 3 (sample data)
From: Supplier C (sample)
Part: Steel bracket, zinc plated,
  part SAMPLE-1001
Price: $1.48 each
Minimum order: 500 pieces
Lead time: 2 weeks
Freight: Included. FOB your dock.
Terms: 2% 10, Net 30
Price holds for 90 days.

03Steps

  1. Open claude.ai. Start a new chat.
  2. Click Copy prompt in the box below.
  3. Paste the prompt into the chat box.
  4. Change [QTY] to the number of pieces you need. For the sample, type 2,000.
  5. Paste the three quotes at the bottom, under PASTE QUOTES HERE.
  6. Press Enter. Wait for the table.
  7. Check every number against the quote. The prompt asks Claude to quote the exact words, so you can find each one fast.
  8. Want it in Excel? Type: Give me this table as CSV. Copy it. Paste it into cell A1. Then use Data, Text to Columns, Comma.
Placeholder Real screenshot of step 6 goes here With an orange circle on the table.

04Copy this

The prompt (what you type in)
You are helping a buyer compare supplier quotes for the same part.

I need [QTY] pieces.

Make one table with one row per supplier. Use these columns:
- Unit price
- Minimum order, and how many pieces I must really buy
- Setup or tooling charges
- Freight: who pays and how much
- Lead time
- Payment terms
- How long the price is good for
- Total cost for my quantity (show your math)

Rules:
1. Use only what the quotes say. If something is missing, write "not stated". Do not guess.
2. Under the table, quote the exact words from each quote for every term you used.
3. After that, list the hidden differences a buyer could miss.
4. Then list the questions I should ask each supplier.
5. Do not pick a winner. I will decide.

PASTE QUOTES HERE:

Versions of this prompt Pick one and the Copy button copies it.

◆Built something with this guide?

Add a Result note on step 7. Tell the next person what you changed and how long it took. Use sample data, not real quotes.

05What good looks like

With the sample quotes and 2,000 pieces, a good answer looks like this. (Sample data, checked by hand.)

SupplierUnit priceMust buySetupFreightLead timeTermsCost for my order
A (sample)$1.422,000 (min 1,000)NoneBuyer pays, about $1803 weeksNet 30$2,840 + $180 = $3,020
B (sample)$1.352,500 (min 2,500)$450 toolingAdded to invoice, amount not stated6 weeks after orderNet 452,500 x $1.35 = $3,375, + $450 = $3,825, + freight
C (sample)$1.482,000 (min 500)NoneIncluded2 weeks2% 10, Net 30$2,960, or $2,900.80 if paid in 10 days

Hidden differences it should find

  • B has the lowest unit price but costs the most. You must buy 500 extra pieces, and there is a $450 tooling charge.
  • B does not say how much freight is. Ask before you compare.
  • C includes freight and takes 2% off if you pay in 10 days.
  • B's price is only good for 15 days.

What to check

  • Each total matches your own math on a calculator.
  • Missing items say "not stated". Nothing is guessed.
  • No winner is picked. You pick.

06Common mistakes

  1. Picking on unit price alone. Look at the cost for your real quantity.
  2. Trusting the math. AI can add wrong. Check each total.
  3. Pasting real prices into a personal AI account. Ask first. Use the sample to learn.

◆Ideas behind this guide

07Next guide

Turn a messy ERP export into a clean report Ready now

08Safe use

Before you use real data

Do not paste confidential prices or contracts into a consumer AI tool without permission. A person owns the decision. Read the safe use notes.

Get your first win this week.

One minute. Three guides picked for your job.

Start my first win