A cost comparison template is a spreadsheet that lines up quotes from several vendors item by item, so you compare the full cost rather than the headline price. Formulas total each bid and flag the cheapest option automatically.
In procurement, a cost comparison is a side-by-side view of what each supplier will really charge for the same scope. Each item sits in a row, each vendor in a column, and every cost the vendor adds, from setup to shipping, is counted before the totals are compared.
Buyers use it whenever more than one quote comes in: hardware orders, facilities work, services and software renewals. It works as a bid comparison template for formal tenders, a quote comparison template for everyday purchases and a vendor comparison template when price is only part of the decision.
The same layout also works as a simple price comparison template for one-off buys. The value comes from forcing every quote into the same units, so a cheap unit price can't hide expensive extras.
Name, SKU or spec and the feature list, so every vendor quotes the same thing.
Four or five suppliers side by side, one column each, with the vendor name in the header.
Unit price times quantity, plus licence fees and one-off setup charges.
Shipping, tax, maintenance, support and overhead that change the real total.
SUMPRODUCT totals each vendor, MIN finds the lowest and conditional formatting highlights it.
Ready to use in Excel and Google Sheets. Fill it in, save it, reuse it.
Write the item list, quantities and specs before asking anyone for a price.
Send the same list to every vendor, with a fixed deadline and a reply format.
Convert every quote to the same units, currency, term and scope. Add missing costs.
Let the formulas total direct and indirect costs per vendor and flag the lowest.
Weigh price against quality, delivery and support, then record why the winner won.
Start with four columns: Item, Quantity, Vendor A price, Vendor B price, and one total row using SUMPRODUCT. Add indirect costs once two quotes look close.
This example compares three quotes for 120 laptops for a growing sales team. Cedar quoted the lowest unit price, but once setup, shipping and three years of support are added, Harbour's bid is the cheapest. VAT is left out because the same rate applies to every vendor.
| Cost line | Type | Qty | Acme Office Supply | Cedar Tech Supply | Harbour Devices |
|---|---|---|---|---|---|
| 14-inch laptop | Direct | 120 | 126,000.00 | 121,200.00 | 129,600.00 |
| Imaging and setup | Direct | 120 | 3,000.00 | 4,800.00 | 0.00 |
| Device management licence, 1 year | Direct | 120 | 2,160.00 | 2,160.00 | 2,400.00 |
| Shipping | Indirect | 1 | 1,200.00 | 2,400.00 | 0.00 |
| Warranty and support, 3 years | Indirect | 120 | 10,800.00 | 13,200.00 | 9,000.00 |
| Total cost | 143,160.00 | 143,760.00 | 141,000.00 |
Illustrative quotes from fictional vendors. Unit prices: Acme 1,050, Cedar 1,010, Harbour 1,080.
Works in Excel and Google Sheets. Vendor names in D1:F1, cost lines in rows 2-6, totals from row 8.
| Col | Header | Entry or formula | What it does |
|---|---|---|---|
| A | Item description | Text | Name, SKU or spec of the cost line |
| B | Cost type | Drop-down: Direct, Indirect | Splits direct and indirect totals |
| C | Quantity | Number | Units, seats or 1 for a flat fee |
| D-F | Vendor unit prices | Currency, one vendor per column | Price per unit as quoted |
| G | Lowest unit price | =MIN(D2:F2) | Cheapest price for this line |
| H | Cheapest vendor | =INDEX($D$1:$F$1, | Who quoted that price |
| D8 | Total cost | =SUMPRODUCT($C$2:$C$6, | Quantity times price, all lines, copied to E8 and F8 |
| D9 | Direct costs | =SUMPRODUCT(($B$2:$B$6='Direct')*$C$2:$C$6*D2:D6) | Direct share of the total |
| D10 | Indirect costs | =D8-D9 | Shipping, support and other extras |
| D11 | Lines won | =COUNTIF($H$2:$H$6, | How many lines this vendor is cheapest on |
| G8 | Lowest total | =MIN(D8:F8) | The cheapest full bid |
| H8 | Lowest bidder | =INDEX(D1:F1, | Names the winner on cost |
A bid tab is stricter than a quote comparison. A bid that misses a required document, such as a bid bond or an addendum acknowledgement, is marked non-responsive and drops out of the ranking, however cheap it is. Here four contractors bid for an office refit.
| Bidder | Bid bond | Addenda | Base bid | Alternate 1 | Total | Status |
|---|---|---|---|---|---|---|
| Harbour Facilities | Yes | Yes | 412,000 | 18,500 | 430,500 | Responsive |
| Northwind Build | Yes | Yes | 398,000 | 24,000 | 422,000 | Lowest responsive |
| Cedar Interiors | Yes | No | 385,000 | 21,000 | 406,000 | Non-responsive |
| Lumen Fit-Out | No | Yes | 441,000 | 15,000 | 456,000 | Non-responsive |
Illustrative bids from fictional contractors. Estimate: 430,000. Cedar is cheapest but missed addendum 2.
Bidders in rows 2-5, total in column F, status in G and your estimate in F7.
| Item | Formula |
|---|---|
| Total bid | =D2+E2 |
| Status | =IF(AND(B2='Yes', |
| Lowest responsive bid | =MINIFS(F2:F5, |
| Rank among responsive bids | =IF(G2='Responsive', |
| Variance from estimate | =(F2-$F$7)/$F$7 |
The laptop quotes from Part 1 are within 2% of each other, so price alone can't separate them. The matrix gives cost 40% and spreads the rest across warranty, delivery time, spec fit and account support. Cost scores use the lowest total divided by each vendor's total, times 5.
| Criterion | Weight % | Acme Office Supply | Cedar Tech Supply | Harbour Devices |
|---|---|---|---|---|
| Total cost | 40 | 4.9 (1.96) | 4.9 (1.96) | 5.0 (2.00) |
| Warranty and support terms | 20 | 4 (0.80) | 3 (0.60) | 5 (1.00) |
| Delivery time | 15 | 4 (0.60) | 5 (0.75) | 3 (0.45) |
| Spec fit | 15 | 4 (0.60) | 4 (0.60) | 4 (0.60) |
| Account support | 10 | 3 (0.30) | 4 (0.40) | 4 (0.40) |
| Weighted total (out of 5) | 100 | 4.26 | 4.31 | 4.45 |
Illustrative scores. Weighted score = score x weight / 100.
| Item | Formula |
|---|---|
| Cost score (1-5) | =ROUND(MIN(Comparison!$D$8:$F$8)/Comparison!D8*5, |
| Weighted total (row 7) | =SUMPRODUCT($B$2:$B$6, |
| Best vendor | =INDEX(C1:E1, |
Three vendors quoted 200 seats of the same analytics tool. Brightline gave the deepest discount but added a 7% annual uplift, while Kestrel locked its price for three years. Before you accept any figure, check it against software pricing benchmarks.
| Line | Brightline Software | Orbit Analytics | Kestrel Data |
|---|---|---|---|
| List price per seat, per year | 300.00 | 280.00 | 260.00 |
| Discount | 20% | 10% | 5% |
| Year 1, 200 seats | 48,000.00 | 50,400.00 | 49,400.00 |
| Annual uplift | 7% | 3% | 0% |
| Year 2 | 51,360.00 | 51,912.00 | 49,400.00 |
| Year 3 | 54,955.20 | 53,469.36 | 49,400.00 |
| Implementation | 10,000.00 | 5,000.00 | 15,000.00 |
| 3-year total | 164,315.20 | 160,781.36 | 163,200.00 |
Illustrative quotes. Brightline is cheapest in year 1 and most expensive over three years.
| Item | Formula |
|---|---|
| Year 1 | =B2*(1-B3)*200 |
| Year 2 | =B4*(1+B5) |
| Year 3 | =B6*(1+B5) |
| 3-year total | =B4+B6+B7+B8 |
Most wrong decisions come from comparing quotes that describe different things. One vendor includes delivery, another bills it later, a third quotes monthly instead of yearly. Fix those gaps first, then let the formulas do the rest.
Comparing software quotes? Spendflo's pricing benchmarks show what others pay for the same tool.
See pricing benchmarksCosts tied to the item itself: unit price, licence fees and setup.
Costs around the purchase: shipping, tax, maintenance and support.
Every cost over the item's life, not just the purchase price.
A bid that meets every mandatory requirement and can be ranked.
A priced option the buyer may add to or remove from the base bid.
The yearly price increase written into a multi-year contract.
Write the item list and specs before asking for prices, and send the same list to all.
Add setup, shipping, support and tax so the totals reflect what you will pay.
Total multi-year deals over every year, with uplifts applied.
Two quotes show a difference, three show where the market sits.
Write one line on why the winner won, for audit and the next renewal.
Monthly and yearly prices in the same row give a meaningless total.
A cheap quote that excludes delivery or training is not cheap.
Typed totals go stale when a price changes. Use formulas.
When totals are close, warranty, delivery and support should decide.
One row per item, fee or service, with quantity and cost type.
One column per vendor, unit prices only, in the same currency.
Confirm SUMPRODUCT totals match each quote's bottom line before comparing.
If the top two are within a few per cent, score them in the vendor matrix.
A sales team needs 120 laptops. Cedar quotes 1,010 per unit, the lowest, but charges 40 per unit for setup, 2,400 for shipping and 110 per unit for support. Harbour quotes 1,080 with setup and shipping included, giving the lowest total at 141,000.00 against Cedar's 143,760.00. Figures are illustrative.
Every part on this page, in Excel and Google Sheets, with the examples filled in.
Part 1 as it stands. Add a lead-time row if delivery dates differ by more than a week.
Use Part 2, check every mandatory document and rank only responsive bids. Keep the sheet with the tender file.
Use Part 4 and total every year of the term. See the SaaS TCO guide for hidden costs.
Best for formulas and large bids.
Best for shared, live comparisons.
One tab for up to five vendors.
Spendflo's procurement team negotiates software deals for you, at 30% average savings.
See your savingsA good cost comparison counts every cost, puts every vendor on the same basis and shows the real lowest total. When totals are close, the weighted matrix makes the final call.
Quick answers to what people ask most about the cost comparison template.
Yes, you can download one free on this page, in Excel or Google Sheets. It includes a line-by-line bid comparison, a bid tabulation sheet, a weighted vendor matrix and a three-year software quote tab.
List the items in rows and vendors in columns, enter each vendor's unit prices, then total quantity times price plus extras like shipping and support. Compare totals, not unit prices. Download the template to skip the setup.
Put quantities in one column and each vendor's prices in their own columns, then total each vendor with =SUMPRODUCT(quantities,prices). Use =MIN() on the totals and a conditional format to highlight the lowest. The free download has these formulas built in.
Excel has no built-in tool for comparing vendor quotes; Spreadsheet Compare, included in some Office editions, compares two workbooks rather than prices. Formulas such as SUMPRODUCT, MIN and conditional formatting do the job, and the download sets them up for you.
Right here: the download includes a bid tabulation tab with bond and addenda checks, responsive status and ranking formulas. It works in Excel and Google Sheets.
Sourcing and RFx
Purchase orders
Contracts
Vendor management
Budgets and business cases
Procurement
Accounts payable
Purchasing
Software buying
Supply chain
Spendflo checks software quotes against pricing benchmarks and can negotiate the deal for you, with intake and approvals built in.
Enter your work email and we'll unlock every format.
Didn't start, or need another format? Pick one below.
Google Sheets: upload the file to Google Drive, then open it with Google Sheets.
