Compare line items, not quote totals
A quote total is almost never comparable as it stands. One supplier priced nine items out of ten, another quoted per box instead of per piece, a third included delivery and a fourth did not. Put the totals side by side and the winner is whoever left something out.
So each row in the table is a line item from your request, and each column is a supplier. Before you open any replies, lock the item list, the quantities and the base unit: piece, kilo, metre. Every quote then drops into the same grid, and gaps show up straight away.
Nine columns cover almost any purchase
For every item and every supplier, the same fields get filled in. This template is a good place to start:
| Column | What to record | How to normalise it |
|---|---|---|
| Unit price | Price from the quote and the unit it refers to | Convert to the base unit of the request |
| Currency and rate | Quote currency | Convert to AED at the rate on the comparison date, and record both |
| VAT | Included, on top or not stated | Price excluding VAT, tax in its own column, "not stated" means a question to the supplier |
| Delivery | Delivered to warehouse, ex-works, who pays freight | Add the delivery cost to the price or show it as a separate line |
| Lead time and stock | Ex-stock in the UAE or made to order | Days from order to delivery |
| Payment terms | Advance, credit terms, instalments | Advance share and credit period in days |
| Minimum order | MOQ and pack multiples | Check your quantity meets it |
| Warranty and returns | Period and conditions | One wording for all suppliers |
| Quote validity | Date the price holds until | Do not compare an expired quote without reconfirmation |
MakeBiz Technologies template. Add columns for your category: certificates, country of origin, after-sales service.
A word on currency and VAT: the standard UAE VAT rate is 5%, and if one quote includes it and another does not, that gap can easily outweigh the difference between two close offers. We covered four traps like this in our news piece on where money leaks when comparing suppliers.
Set the weights before you open the quotes
Weights invented after the fact quietly bend towards the supplier someone already likes. So write them into the purchase record up front. A hypothetical set for consumables: price 50, lead time 20, payment terms 15, track record 15. For an urgent order you raise the lead time weight, for a large batch payment terms and minimum order matter more.
Scoring is simple: the supplier with the lowest price gets 10 points on price, the others get proportionally less. Lead time works the same way. The total is the sum of scores multiplied by the weights.
Track record comes from history, not gut feeling: how often a supplier missed a date, changed the price after quoting or went silent. You only have that data if purchasing runs in a CRM rather than in personal spreadsheets. How to set up the request process itself is in our guide to procurement automation.
