Do this job with AI
Compare three supplier quotes without being fooled by the headline price
Written by AI Tools AcademyLast checked on 27 September 2026
Helpful first: Hallucination and trust · What can I put into ChatGPT at work?
Practice files for this page
Three supplier quotes, full text (fictional) (Markdown, 2 pages)
Fictional practice data. No real people or organisations.
Three supplier quotes, key figures (fictional) (CSV, 3 rows)
Fictional practice data. No real people or organisations.
This scenario gives you three fictional quotes with traps built in. Download them, run the steps in your own AI tool and compare your table with the finished version.
Three supplier quotes, full text (Markdown, 2 pages)
Includes the terms and conditions extracts, which is where most of the traps are.
Fictional practice data. No real people or organisations.
Three supplier quotes, key figures (CSV, 3 rows)
The same quotes as a spreadsheet, with the small print in the last column.
Fictional practice data. No real people or organisations.
What Fernway asked for: a cloud phone system for 40 users across head office and the Midlands depot, 12 desk handsets, number porting, go-live in early December 2026.
Quote A: Brackenmoor Telecom Ltd (36 months)
| Item | Price |
|---|---|
| Service, 40 users | £12.00 per user per month |
| Implementation and number porting | £600.00 one-off |
| Desk handsets | Up to 15 included |
| Support | UK helpdesk, 8am to 6pm weekdays, included |
All prices include VAT at 20%. Terms 6.2: after the first 12 months, Brackenmoor may apply an annual price increase with 30 days' notice. Terms 11.3: leaving early costs 50% of the remaining monthly charges.
Quote B: Pellow Hart Communications (24 months)
| Item | Price |
|---|---|
| Service, 40 users | £10.50 per user per month |
| Implementation and number porting | £750.00 one-off |
| Desk handsets | £80.00 each |
| Support | Standard support included |
Terms 2.1: all prices in this quotation exclude VAT. Terms 9.4: customers with more than 25 users must take Premium Support at £45.00 per month for the duration of the agreement. Terms 14.2: renews automatically for 12 months unless 60 days' notice is given.
Quote C: Quillfield Voice (36 months)
| Item | Price |
|---|---|
| Service, 40 users | £13.20 per user per month |
| Installation | Included for standard sites |
| Desk handsets | £95.00 each |
| Support | 24/7 phone and email, included |
Prices include VAT. Calls: UK calls included, fair use applies. Terms 8.2: after month 12, 90 days' notice with no penalty. The quote doesn't define "standard site" or "fair use".
Step 1: Understand the task
Dan asked which quote is cheapest. Before answering, work out what "cheapest" can mean here. Lowest price per user? Lowest monthly bill? Lowest total you're committed to? These give different answers when one contract is 24 months and the others are 36.
So the real task is a fair comparison: every quote on the same VAT basis, every compulsory charge included, costs shown both per month and over the contract, and the gaps turned into questions. Which supplier to choose is Dan and Priya's decision. Your job is to make sure they're comparing the right numbers.
Step 2: Decide whether AI is appropriate
Partly. AI is good at pulling figures and conditions out of several documents into one table, and at spotting clauses you might skim past. It's unreliable at arithmetic done in its head, and it has no idea which differences matter to Fernway.
Use it to extract and lay out. Do or check every sum yourself.
Step 3: Assess the data
Real supplier quotes are commercially sensitive. Some are marked confidential, and pricing shared with you in a tender isn't something the supplier expects to end up in a tool outside your organisation's control. There's usually little personal data, maybe a sales contact's name and email.
Use a tool your organisation has approved for work documents, signed in with your work account. If the quote is marked confidential and your organisation hasn't approved any AI tool for that kind of material, do the comparison by hand. You can remove the contact names without losing anything useful.
The fictional practice files are safe to use anywhere. Your organisation's policy and approved tools still take priority.
Step 4: Prepare the input
Give the AI the whole quote, including the terms, never just the summary page. In this set, the VAT basis for quote B and its compulsory support fee are both in the small print.
Tell it what Fernway actually needs (40 users, 12 handsets, two sites). Without that, it can't work out handset costs or spot that "standard sites" might not cover the depot.
If the quotes are PDFs, check the text came through: tables in PDFs sometimes paste as a jumble. The CSV version of this exercise avoids that. Its first line is a label saying the data is fictional; if you open it in a spreadsheet, delete that line so the column headings are read as headings.
Step 5: Choose an approach or tool
Any of the general assistants can build the table from pasted or uploaded quotes. The difference that matters is how the sums get done.
In Microsoft 365 Copilot in Excel
If Copilot is available in your Excel (depending on your licence and your organisation's settings), it can suggest formula columns for the totals. It may need the file saved as an Excel workbook in OneDrive or SharePoint, with the data formatted as a table. The advantage is that formulas are visible: you can click a cell and see exactly what was added up.
In ChatGPT, Claude or Gemini
With an uploaded file, these tools may run the calculation as code (depending on the tool and your plan) or may work it out in the text of the reply, and it isn't always obvious which happened. Either way, ask for the working line by line, so you can check each step with a calculator.
Step 6: Write the instruction
Weak
Which of these three quotes is cheapest?
Better
Using only these three quotes, build a comparison table. Convert every price to include VAT at 20%. Include every compulsory charge from the terms. Show monthly cost, total over each contract and average per month, with your working. List anything unclear as questions for the supplier. Don't recommend a supplier.
Why it works: It fixes the basis of comparison, points the AI at the small print, makes the sums checkable and keeps the decision with the people who own it.
Notice what the better version leaves out: no role-play, no long preamble. Every sentence closes off a specific way the comparison could go wrong.
I need to compare the three supplier quotes below for [what you're buying]. Our requirement: [e.g. 40 users, 12 desk handsets, two sites]. Using only the text of the quotes, including the terms, build a table with one column per supplier showing: contract length, monthly charges, any compulsory extra charges from the terms, one-off charges for our requirement, total cost over the contract and average cost per month. State each quote's VAT basis and convert everything to include VAT at 20%. Show your working for every total. Where a quote is unclear or silent on something we need, don't assume: list it as a question to ask that supplier. Don't recommend a supplier. [paste quotes]
Why this works: Each line blocks a trap: VAT basis, buried fees, different contract lengths, vague wording.
Step 7: Inspect the answer
This is the kind of answer the weak instruction can produce. It reads well, and its conclusion is wrong.
| Supplier | Monthly cost | Contract | Total cost |
|---|---|---|---|
| Brackenmoor Telecom | £480 | 36 months | £17,880 |
| Pellow Hart | £420 | 24 months | £10,830 |
| Quillfield Voice | £528 | 36 months | £19,008 |
Recommendation: Pellow Hart offers the best value, with the lowest monthly cost and a total saving of over £7,000 compared with Brackenmoor. Its shorter contract also gives more flexibility.
Before you check any number, look at what's missing: no handsets, no support fee, no mention of VAT, and a recommendation you didn't ask for.
Step 8: Identify likely errors
Other things to check:
- Brackenmoor's £17,880 is correct (£480 × 36 = £17,280, plus £600). Check it anyway: a right answer you haven't checked is luck.
- "More flexibility" ignores that Pellow Hart renews automatically for 12 months unless you give 60 days' notice.
- Quillfield's "included for standard sites" has been read as "free". The Midlands depot may not be a standard site.
Step 9: Correct the result
Send one follow-up that names the specific problems, then check the arithmetic yourself.
Please redo the table. Pellow Hart's terms 2.1 say its prices exclude VAT, and terms 9.4 add compulsory Premium Support at £45 a month for more than 25 users. Include 12 desk handsets for each supplier. Show every total as a line of working. Add a row showing what Pellow Hart would cost over 36 months if it renewed for 12 months at the same monthly charges, and label that row as an assumption. Remove the recommendation.
Why this works: Pointing at the exact clauses is faster than asking it to 'check again'.
Then check each line with a calculator. Every figure below has been worked through by hand; if your AI's numbers differ, trust the calculator and find where it slipped.
- Quote A: £12.00 × 40 = £480.00 a month. £480.00 × 36 = £17,280.00, plus £600.00 = £17,880.00. Divided by 36 = £496.67 a month.
- Quote B: service £10.50 × 40 = £420.00, plus 20% VAT = £504.00. Support £45.00 plus VAT = £54.00. Monthly total £558.00. £558.00 × 24 = £13,392.00. One-offs: implementation £750.00 plus VAT = £900.00; handsets 12 × £80.00 = £960.00 plus VAT = £1,152.00. Total £15,444.00. Divided by 24 = £643.50 a month.
- Quote C: £13.20 × 40 = £528.00 a month. £528.00 × 36 = £19,008.00, plus handsets 12 × £95.00 = £1,140.00. Total £20,148.00. Divided by 36 = £559.67 a month.
Step 10: Produce the finished work
Show the finished version
Office phone system: comparison of three quotes (prepared for Dan Okafor and Priya Shah)
All figures include VAT at 20%. Quote B was quoted excluding VAT and has been converted. Figures assume 40 users and 12 desk handsets.
| A: Brackenmoor | B: Pellow Hart | C: Quillfield | |
|---|---|---|---|
| Contract length | 36 months | 24 months | 36 months |
| Service, 40 users, per month | £480.00 | £504.00 | £528.00 |
| Compulsory support fee, per month | Included | £54.00 | Included |
| Implementation, one-off | £600.00 | £900.00 | £0 if "standard site" |
| 12 desk handsets, one-off | Included | £1,152.00 | £1,140.00 |
| Total over the contract | £17,880.00 | £15,444.00 | £20,148.00 |
| Average per month | £496.67 | £643.50 | £559.67 |
How to read this. A has the lowest average monthly cost. B has the lowest contract total only because its contract is 12 months shorter. If B renewed for a further 12 months at the same charges (an assumption; its renewal price isn't stated), it would cost £22,140.00 over 36 months, the highest of the three. Excluding VAT, the totals are £14,900.00, £12,870.00 and £16,790.00: the order doesn't change. Finance may prefer the ex-VAT figures; Dan to decide which basis to use.
Other differences
- Support: A is weekday office hours; B is phone support 8am to 8pm Monday to Saturday (Premium); C is 24/7.
- Leaving early: A charges 50% of remaining monthly charges; B renews automatically unless 60 days' notice is given; C allows 90 days' notice with no charge after month 12.
- Price rises: A may increase prices each year after month 12 (size not stated). B and C don't mention increases.
Questions for suppliers before deciding
- Brackenmoor: is there a cap on the annual price increase after year 1?
- Pellow Hart: please confirm Premium Support applies to us at 40 users, and what the monthly charges would be on renewal.
- Quillfield: are both head office and the Midlands depot "standard sites"? If not, what does installation cost?
- Quillfield: what does "fair use" mean for UK calls? What happens if we leave before month 12?
- All three: confirm number porting is included for all our existing numbers.
Step 11: Reflect: did AI actually save time?
Partly. The AI was quick at the part people find tedious: reading three sets of terms and pulling out the clauses that matter. The follow-up surfaced the notice periods and price-increase clause in seconds.
It saved nothing on the arithmetic. You had to check every sum, and the first version was so wrong that a quick glance would have sent Dan the wrong answer. If you'd trusted it, AI would have cost Fernway money.
Common mistakes
- Trusting the AI's sums because the table looks neat. Formatting says nothing about accuracy. Check every total, especially when one quote comes out far cheaper than the rest.
- Feeding it the summary page only. Compulsory fees, VAT basis and auto-renewal usually live in the terms. If the AI never saw them, it can't include them.
- Comparing totals across different contract lengths. A 24-month total will almost always look smaller than a 36-month one. Show the average per month next to the total.
- Reading vague wording as a promise. "Included for standard sites" means included only if you're a standard site. Turn every vague phrase into a question.
- Letting the AI recommend. The purchasing decision depends on things the AI doesn't know: how much the business values 24/7 support, how it feels about auto-renewal, the relationship with a supplier. Leave the recommendation to the people who own the decision, or write it yourself.
- Mixing VAT bases. One quote excluding VAT among two that include it is a common trap. Pick one basis and say which at the top of the table.