Tools / Procurement & Multi-outlet
Free tool · Procurement & Multi-outlet

Vendor Price Comparison Tool

Supplier A is cheaper on chicken, B on vegetables, C says they'll match anyone if you move the whole account. The only honest way to settle it is line by line. Paste your regular purchase list with each vendor's rate, and this tool shows the cheapest source per item, what each single-vendor basket costs, and how much a best-price mixed basket saves.

Procurement & Multi-outlet — Vendor Price Comparison Tool
In short

Compare vendors on the total cost of your actual basket, not headline rates: multiply each item's quantity by each vendor's rate, total per vendor, and compare against the mixed basket that takes the cheapest line every time.

Line cost = quantity × vendor rate. The best-price basket picks the cheapest vendor per line, its gap versus your cheapest single vendor is the most you can save by splitting the order, before weighing delivery minimums and relationship terms.
ItemQtyVendor A (₹)Vendor B (₹)Vendor C (₹)Cheapest
Vendor B
Vendor C
Vendor B
Vendor A basket
₹10,010.00
Vendor B basket
₹9,675.00
Vendor C basket
₹9,875.00
Best-price mixed basket
₹9,475.00

Cheapest single vendor: Vendor B. Splitting the order at best prices saves ₹200.00 (2.1%) versus that basket, before delivery minimums and credit terms.

How to use the Vendor Price Comparison Tool

  1. Add each item you buy regularly with its order quantity.
  2. Enter the rate quoted by each vendor (leave blank if a vendor doesn't stock it).
  3. Compare vendor basket totals and the best-price mixed basket.

Frequently asked questions

Should I always split the order across the cheapest vendors?

Not automatically. Splitting adds deliveries to receive, invoices to reconcile and minimum-order thresholds to hit. If the mixed-basket saving is under 3-4%, a single reliable vendor with one delivery and one credit line usually wins. Over 8-10%, splitting or renegotiating is worth the friction.

How do I handle vendors quoting different units or grades?

Normalise before comparing: convert everything to the same unit, and only compare like grades, a cheaper rate for a lower grade of rice or a smaller prawn count is not a saving. When grades differ, add a separate line per grade rather than pretending they are one item.

How often should I re-quote?

Monthly for volatile fresh produce, quarterly for groceries and packaging. The bigger habit is keeping this sheet from your last comparison, vendors who know you re-check rates drift upward far more slowly than vendors who know you don't.

More Procurement & Multi-outlet tools

Want this run for you? Book a free auditExplore the platform →