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.
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
- Open claude.ai. Start a new chat.
- Click Copy prompt in the box below.
- Paste the prompt into the chat box.
- Change [QTY] to the number of pieces you need. For the sample, type 2,000.
- Paste the three quotes at the bottom, under PASTE QUOTES HERE.
- Press Enter. Wait for the table.
- Check every number against the quote. The prompt asks Claude to quote the exact words, so you can find each one fast.
- 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.
04Copy this
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.)
| Supplier | Unit price | Must buy | Setup | Freight | Lead time | Terms | Cost for my order |
|---|---|---|---|---|---|---|---|
| A (sample) | $1.42 | 2,000 (min 1,000) | None | Buyer pays, about $180 | 3 weeks | Net 30 | $2,840 + $180 = $3,020 |
| B (sample) | $1.35 | 2,500 (min 2,500) | $450 tooling | Added to invoice, amount not stated | 6 weeks after order | Net 45 | 2,500 x $1.35 = $3,375, + $450 = $3,825, + freight |
| C (sample) | $1.48 | 2,000 (min 500) | None | Included | 2 weeks | 2% 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
- Picking on unit price alone. Look at the cost for your real quantity.
- Trusting the math. AI can add wrong. Check each total.
- Pasting real prices into a personal AI account. Ask first. Use the sample to learn.
◆Ideas behind this guide
- What is structured output?: why every quote goes into one form.
- What does deterministic mean?: why a fixed format gives the same answer every time.
- How to test an AI tool: check the totals against answers you know.
07Next guide
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.