Comparing supplier quotes by unit price alone can hide delivery charges, minimum order commitments, installation work and future reordering costs. This practical UK supplier cost comparison template shows how to calculate a more realistic landed cost, document assumptions and choose between quotes on a like-for-like basis.
Overview
The lowest quoted price is not always the lowest cost to your business. A supplier may charge separately for delivery, insurance, tooling, handling, installation or payment processing. Another supplier may offer a higher unit price but include delivery, provide better warranty support or accept smaller repeat orders. Comparing these offers requires a consistent total-cost method.
Use the following basic formula for each quote:
Total purchase cost = goods + delivery + insurance + tooling or setup + installation + payment charges + expected import or handling costs - applicable discounts
Then calculate the cost per usable unit:
Cost per usable unit = total purchase cost ÷ usable quantity received
For recurring purchases, extend the calculation beyond the first order. Include expected reorder quantities, storage, returns, warranty administration, replacement items and the cost of stockouts or urgent delivery where these are reasonably foreseeable. This is a practical form of total cost of ownership for supplier decisions.
The method works for homeowners comparing installation quotes, contractors buying trade materials, retailers sourcing stock and businesses purchasing industrial or commercial supplies. You can use it with a UK suppliers directory, a shortlist of verified suppliers or direct quotes from manufacturers, wholesalers and distributors.
How to estimate the real cost of a supplier quote
Start by defining the exact requirement before entering prices. Record the product specification, quantity, required delivery date, delivery location, installation scope and any compliance or warranty expectations. If two suppliers are quoting different specifications, they are not yet being compared like for like.
- Set the comparison quantity. Use the quantity you actually need, not automatically the supplier’s minimum order. Show any surplus separately because excess stock has a cash and storage cost.
- Normalise units. Convert boxes, packs, metres, kilograms or hours into a common unit. Check whether stated prices are per item, per pack or per project.
- Separate VAT treatment. Record quoted prices as either VAT-inclusive or VAT-exclusive. Apply the VAT treatment relevant to the buyer and transaction, and note whether VAT is recoverable for your business. Do not compare one quote including VAT with another excluding it.
- Add direct extras. Enter delivery, insurance, fuel or handling charges, pallet fees, setup costs, tooling, testing and installation as separate lines.
- Account for commercial terms. Record payment timing, credit-card or finance charges, deposit requirements, credit terms and discounts. A discount dependent on a large order should not be treated as a saving if the stock will not be used.
- Estimate repeat costs. Add likely reorder quantities, delivery frequency, price-review clauses, replacement parts and routine support. Use a clearly labelled assumption where the supplier has not provided a firm figure.
- Compare risk as well as arithmetic. Note lead time, returns, warranty process, stock availability, substitution rights and the consequences of late or incomplete delivery. Keep these factors visible rather than hiding them in a single score.
For quote requests, ask each supplier to confirm the same information. The UK supplier request for quote template can help structure questions about specification, delivery, payment and after-sales support. This reduces the need to guess what a headline price includes.
Editable landed-cost worksheet
Copy the following headings into a spreadsheet. Create one column for each supplier and a final column for notes or assumptions.
| Cost or decision input | What to record |
|---|---|
| Supplier and quote reference | Company name, quote date, validity period and contact |
| Required quantity | Units needed and any planned surplus |
| Unit or project price | Price basis and whether VAT is included |
| Discounts | Trade, volume, prompt-payment or promotional discount and conditions |
| Delivery | Standard, timed, urgent, pallet or split-delivery charges |
| Insurance and handling | Declared-value cover, packaging, administration or warehouse fees |
| Tooling and setup | Moulds, artwork, account setup, testing or one-off configuration |
| Installation | Labour, commissioning, access equipment, disposal and remedial work |
| Payment cost | Deposit, card surcharge, finance cost or early-payment terms |
| Import or clearance costs | Only where relevant; confirm who is responsible for each charge |
| Returns and warranty | Return freight, restocking, inspection and replacement arrangements |
| Reorder cost | Expected future price, minimum order and delivery frequency |
| Total cost | Sum of applicable costs minus valid discounts |
| Cost per usable unit | Total cost divided by usable quantity |
| Open assumptions | Anything not confirmed in writing |
Inputs and assumptions to check
A spreadsheet is only as reliable as its inputs. Mark every figure as quoted, calculated or assumed. Ask the supplier to confirm material assumptions before placing an order, particularly where a small change could alter the decision.
VAT and price presentation
Use one consistent basis throughout the comparison. If your business can reclaim VAT, you may assess net cost for internal purchasing decisions, while still recording the gross amount needed for cash-flow planning. If VAT cannot be recovered, the gross amount may be the relevant cost. Keep both figures when the position is uncertain and obtain suitable accounting advice.
Delivery and access
“Delivery included” may still require clarification. Check the delivery address, unloading responsibility, access restrictions, timed slots, failed-delivery charges and whether the quote covers one shipment or several. For bulky equipment, also check whether installation requires a lift, specialist access or site preparation.
Minimum order quantities and surplus
A lower unit price can be outweighed by stock that sits unused. Record the required quantity, supplier minimum, carton size and expected usage period. Include storage, expiry, damage and working-capital considerations where they apply. For seasonal goods, review the wholesale stock buying calendar before treating a bulk order as a saving.
Warranty, returns and support
Ask who pays return freight, how faults are assessed, whether replacement parts are available and whether installation must be completed by an approved party. These terms may not produce an immediate number, but they affect the financial risk of the purchase. Verify the supplier and its trading details using the UK supplier due-diligence checklist.
Credit terms and cash flow
Credit can reduce the immediate cash requirement, but it does not necessarily reduce the purchase cost. Record deposits, payment deadlines, late-payment consequences and any discount for early settlement. See the guide to UK trade supplier accounts when comparing account terms alongside prices.
Worked examples
One-off installation project
Suppose two suppliers quote for the same equipment and installation scope. Supplier A has the lower equipment price but lists delivery separately and excludes commissioning. Supplier B charges more for equipment but includes delivery, commissioning and a longer stated support period.
Enter equipment, delivery, commissioning, site preparation, disposal and any required accessories as separate rows. If Supplier A has not confirmed commissioning, do not enter zero; enter “not confirmed” and request a price. Compare the completed project total and then the cost per installed unit. A quote that looks cheaper before installation may not remain cheaper once the scope is complete.
Recurring trade purchases
A contractor needs regular materials. Supplier A offers a low unit price with a minimum order that exceeds the usual weekly requirement. Supplier B charges slightly more but allows smaller orders and has a lower delivery threshold.
Model a representative period, such as one quarter or one year, using the expected number of orders. Include delivery on each order, surplus stock from minimum quantities and the cost of occasional urgent replenishment. Run a second version using higher and lower demand so that the decision is not based on one optimistic forecast. A supplier management scorecard and reorder schedule can help track whether the original assumptions remain valid.
Imported stock
For imported goods, separate the supplier invoice from transport, insurance, customs or clearance charges, taxes and domestic delivery. Confirm which party is responsible for each stage and avoid assuming that a quoted delivery term covers every cost. If a charge is unknown, label it as an open assumption and use a conservative planning estimate only for internal comparison. Confirm the final position before committing funds.
When to recalculate
Recalculate the comparison whenever a pricing input or commercial assumption changes. At minimum, revisit it when a quote expires, a supplier changes its price list, delivery charges move, VAT treatment changes for the transaction, exchange rates affect imported goods, or a minimum order or payment term is renegotiated.
Also recalculate when your own buying pattern changes. A supplier that is economical for large monthly orders may be unsuitable if demand falls. Conversely, a higher unit price may become less important when consolidated deliveries reduce administration and transport. Review the model before annual budgets, contract renewals, range changes, major projects and significant reorder rounds.
- Save the original quote and worksheet with its date.
- Highlight every assumption that was not confirmed in writing.
- Request refreshed prices using the same specification and quantity.
- Update the landed-cost calculation and record the reason for each change.
- Check the result against delivery performance, defects, returns and support received.
- Keep the calculation with the purchase record so the next buyer can understand the decision.
For larger or repeated purchases, combine the calculation with a supplier review rather than relying on price alone. The supplier management scorecard provides a useful structure for recording service performance and reorder decisions. A consistent worksheet turns every new quote into a comparable evidence-based decision, whether you are sourcing from a manufacturer, wholesaler, installer or local trade supplier.