Supplier Price Comparison Spreadsheet, Vendor Quote and Inventory Tracker for Small Business, Excel and Google Sheets, Digital Download

Excel and Google Sheets tool. Not a printable, not party decor.

Five quotes, five different Incoterms, five different MOQs. This sheet puts them on one screen and ranks them by what each one actually costs you.

WHAT IT SOLVES

The cheapest quote is almost never the cheapest supplier. One is FOB, one is EXW, one includes samples, one has a defect rate that eats 4% of the shipment before you sell a single unit. Comparing the unit prices tells you nothing.

This ranks suppliers on true landed cost per sellable unit, and scores them on the things a price alone hides.

WHAT IT SCORES

•⁠ ⁠True landed cost per good unit, after expected defect rate

•⁠ ⁠Lead time

•⁠ ⁠Quality, communication, payment terms and certification, weighted the way you decide

•⁠ ⁠MOQ feasibility: any supplier whose minimum is above your order quantity is marked MOQ NOT MET and taken out of the cost ranking

•⁠ ⁠One combined Best Value score, so you are not left staring at six columns

THE WEIGHTS ARE YOURS

Cost is not always 100% of the decision. A supplier two dollars cheaper with a nine week lead time may be the wrong answer for your cash flow. Set the six weights on the WEIGHTS tab and the ranking follows your priorities, not mine.

BUILT TO WORK PARTLY FILLED

Comparing three suppliers instead of five gives correct scores. Empty rows are ignored by every score, every average and every ranking. Most comparison sheets quietly break when you use fewer rows than they shipped with.

WHAT YOU GET

•⁠ ⁠1 Excel file (.xlsx)

•⁠ ⁠Works in Excel on Windows and Mac, and in Google Sheets

•⁠ ⁠No add-ins, no macros, no subscription

•⁠ ⁠Sample data included. Clear it and enter your own.

HOW IT IS SET UP

Blue text on yellow cells are yours to edit. Formula cells are locked so you cannot break them by accident, with no password if you want to change the structure.

DELIVERY AND REFUNDS

Digital download only. No physical item will be shipped. Your file is available immediately after payment. Because files are delivered instantly, all sales are final.

If something does not work the way you expected, message me. I will fix it and send you the updated file.

---

Built with AI assistance, then tested and corrected by me. Every formula in this file was recalculated and stress-tested before it shipped, including blank-sheet and partial-data scenarios.