How to compare supplier offers on the same basis
Supplier offers are comparable once each is priced for the same yearly quantities, in the same unit and currency, with shipping added. The total per year is the sum of quantity times unit price over all items, plus shipping per order times orders per year, and it is set against what the same items cost today. An offer that leaves items out is not ranked, because it is cheaper for the wrong reason. Lead time, payment terms, validity and minimum quantities stand next to the total and are not converted into money by guesswork.
Two offers are comparable when each has been priced for the same quantities, in the same unit and currency, with the cost of delivery added. Comparing the unit prices as they arrive is not enough: the supplier with the lowest price per box may charge for every delivery, quote a larger pack, or have left out the one item that is expensive. A comparison is a calculation, and every step of it should be visible in a table.
Put every offer on the same basis
| What differs | What to do |
|---|---|
| Unit or pack size | Compare within one unit only. If a supplier quotes another pack, ask for the price in your unit instead of converting silently |
| Currency | Convert at one rate for all offers and note the rate |
| Net or gross | Compare net prices |
| Shipping | Shipping per order times orders per year |
| Minimum quantity | Note it beside the price. A price that needs a larger order than you place does not apply |
| Validity | An offer that has expired is no longer an offer. Ask for it to be renewed |
| Early-payment discount | Show it beside the total, not inside it |
| Which offer counts | The supplier's latest, not the first one in the inbox |
Price each offer for the yearly quantity
The formula is short:
Total per year = sum over all items of (quantity per year × unit price) + shipping per order × orders per year.
The quantities are the ones in the request, taken from twelve months of invoices, and they are the same for every supplier. How to set them up is described in writing a request for quotation.
An example with invented figures. Three items, twelve orders a year, and three offers. Supplier A delivers today.
| Row | Today | Supplier A | Supplier B | Supplier C |
|---|---|---|---|---|
| Gloves, 1,200 boxes | 6.00 | 5.80 | 5.50 | 5.20 |
| Paper towels, 400 packs | 15.00 | 14.50 | 15.00 | 14.00 |
| Disinfectant, 300 bottles | 8.00 | 8.00 | 7.50 | not quoted |
| Items per year | 15,600.00 | 15,160.00 | 14,850.00 | 11,840.00 |
| Shipping per order | 0.00 | 20.00 | 0.00 | |
| Shipping per year | 0.00 | 240.00 | 0.00 | |
| Total per year | 15,600.00 | 15,160.00 | 15,090.00 | incomplete |
| Below today's cost | 440.00 | 510.00 | not ranked |
Supplier B has the lowest complete total: 1,200 × 5.50 + 400 × 15.00 + 300 × 7.50 = 14,850.00, plus 12 × 20.00 = 240.00 shipping, gives 15,090.00. That is 510.00 below today's 15,600.00. Without the shipping line B would look 750.00 cheaper than today, which is not what would be paid.
Keep incomplete offers apart
Supplier C shows the smallest figure in the table and is not the cheapest. Its 11,840.00 covers two of three items. Ranking it next to A and B would reward it for leaving the disinfectant out.
Three things can be done with an incomplete offer:
- Ask the supplier to quote the missing item, and compare again.
- Compare it with today's cost of only the items it quotes. For C that is 1,200 × 6.00 + 400 × 15.00 = 13,200.00 today against 11,840.00 offered.
- Look at a split: every item from whoever quotes it lowest. Here that is gloves and towels from C and disinfectant from B: 6,240.00 + 5,600.00 + 2,250.00 = 14,090.00, plus B's shipping of 240.00, gives 14,330.00.
The split is 760.00 a year below the best single supplier. Treat it as information, not as a result: it needs two suppliers, two sets of invoices, and B has to hold its price for one item alone. It is a good argument for the next round, which is the subject of negotiation rounds with suppliers.
What the total does not show
A total per year ranks prices. It says nothing about the following, which belong in the table as rows of their own:
- Lead time. Two days and three weeks are different offers for an item you run out of.
- Payment terms. Thirty days and sixty days differ in cash, not in price.
- Validity and term. How long the offer stands and how long the prices would hold.
- Minimum quantities. Whether the price applies to the orders you actually place.
- Requirements. Whether the quoted product meets the specification of the request.
Resist turning these into money with a rule of thumb. An invented surcharge for "risk" makes the table look exact and hides a judgement. Leave the figures as computed and write the judgement next to them, with a name.
Offers that arrive as text
An offer typed into a form is already a row in the table. An offer in an email or a PDF has to be read into it, and that is where errors enter: a price per ten boxes read as a price per box, a decimal comma misread, a price range taken as a price. Check every transcribed price against the supplier's own words before it is compared with anything, and keep those words next to the figures. A range such as "between 5.00 and 5.50 depending on volume" is not a price; ask for one.
What goes wrong
- Comparing unit prices instead of totals. The largest item decides, not the number of items a supplier is cheapest on.
- Ranking incomplete offers. The lowest figure in the table is often the offer with the most gaps.
- Converting pack sizes without asking. A box of 100 and a box of 90 at the same price are not the same price.
- Adding the discount into the total. It is earned by paying early, every time.
- Comparing with a remembered price. Today's cost comes from the last invoices, per item.
How Cureman does it
Suppliers answer on a quote page that asks each of them for the same things, so most offers arrive as rows. A reply that came by email or as a PDF is read by a model into the item list as a draft, shown next to the supplier's own words, and it counts only after a person confirmed it. A different pack size is noted on the item and not converted. The comparison itself is arithmetic: each supplier's latest offer is priced for the yearly quantities plus shipping per order times orders per year, converted into the currency of the event, and set against today's cost of the items it quotes. Only offers that quote every item are ranked. The cheapest-per-item split is shown for information, an early-payment discount stands beside the total, and an expired offer is marked. For several delivery sites the comparison works site by site, as described in sourcing for multiple sites. The module is described under sourcing and negotiation.
Questions and answers
How do you compare offers from several suppliers?
- Price every offer for the same yearly quantities in the same unit and currency, add shipping per order times the number of orders per year, and set each total against what the same items cost today. Rank only the offers that quote every item. Keep lead time, payment terms, validity and minimum quantities in the table as rows of their own.
What is a price comparison table?
- A table with one row per item and one column per supplier, holding the unit prices, followed by rows for the total per year, shipping and the terms. It is also called a bid tabulation. Its value is that every figure in the total can be traced back to a quantity and a quoted price.
How should an incomplete offer be handled?
- Do not rank it against complete offers, because its total is lower only by what it leaves out. Ask the supplier to complete it, or compare it with today's cost of just the items it quotes. If its prices on some items are the lowest, that is an argument for the negotiation or for splitting the award.
Does an early-payment discount belong in the total?
- Not in the total. Show it next to it. The discount is only earned if every invoice is in fact paid within the discount period, and that depends on your own payment run, not on the supplier's offer.
Who computes the comparison in Cureman?
- Deterministic code. A model may read an offer that arrived as an email or a PDF into the item list, but that reading is a draft shown next to the supplier's own words and counts only after a person confirmed it. The totals, the ranking and the difference from today's cost are arithmetic on the confirmed prices.