RFQ Vendor Scoring & TCO Tool — Excel Workbook
Stop comparing vendor quotes in your head. Score them, weight them, and know your true landed cost — automatically.This is a 4-tab Excel workbook built from 28 years of real RFQ evaluation — not a template, a working calculator with live formulas.WHAT'S INSIDEVendor Scorecard — set your own category weights (Price, Quality, Delivery, Payment Terms, Warranty, ESG — fully editable), score up to 5 vendors 1–10, and the tool auto-calculates weighted scores, ranks every vendor, and flags your recommended supplier. No more gut-feel sourcing decisions.Should-Cost Calculator — enter raw material, labor, overhead and your allowed margin for any item. The tool calculates your target ‘should-cost’ and shows the exact variance against each vendor's quoted price — so you know precisely how much negotiation room you actually have, not just a guess.TCO Calculator — true Total Cost of Ownership per unit: quoted price + freight + duty + payment-terms impact + inventory carrying cost + quality/rejection cost. Auto-flags your lowest true-cost vendor — which is very often not the vendor with the lowest quote.Read Me tab — full instructions and a color key so you're using it correctly from the first click.WHY THIS IS DIFFERENTEvery number you see updates live. Change a weight, rescore a vendor, adjust a should-cost input — the recommendation updates instantly. Built with zero formula errors and tested before listing.WHO THIS IS FORProcurement professionals, plant buyers, sourcing managers, and small business owners who run vendor comparisons regularly but don't have access to enterprise e-sourcing software. Reusable for every RFQ cycle — just rename the vendors and rescore.ABOUT THE AUTHORBuilt by Balamurugan G, a Senior Supply Chain & Procurement Leader with 28 years of cross-industry experience managing a ₹50Cr+ annual procurement spend base and a 425+ vendor network across India, UAE, Malaysia, Singapore, and Vietnam. IIMM Full Member (F/3737/MD), ISO 9001:2015 Internal Auditor.Format: Excel (.xlsx), instant download. Works in Excel and Google Sheets. Single-user license for internal corporate or personal professional use.
Get it → balamurugan08.gumroad.com