Compare supplier quotes on a consistent retail buying basis

A specialty homeware buyer in Bengaluru requests quotes for a ceramic coffee canister (SKU-CAN-450) ahead of a 60-day festive merchandising window. Supplier A quotes ₹480 per six-pack with a minimum order quantity (MOQ) of 120 six-packs (720 sellable units) and includes door delivery to the central warehouse. Supplier B quotes ₹85 per individual sellable unit with an MOQ of 300 sellable units, quoted ex-works with freight left blank as 'actuals at dispatch'. On a raw unit-price glance, Supplier A appears cheaper at ₹80.00 per sellable unit (₹480 ÷ 6) compared with Supplier B at ₹85.00. However, Supplier A requires a minimum purchase commitment of 720 units (₹57,600 net before tax) for a SKU forecast to sell 280 units over 60 days—leaving 440 units of slow-moving stock on the balance sheet—while Supplier B's quote is incomplete until ex-works freight is quantified.

The operational decision for a category buyer across specialty retail, D2C, and multistore chains is how to normalise supplier quotations onto an identical commercial basis—converting inner packs and master cartons to sellable retail units, separating verified landed charges from unquoted estimates, and comparing total MOQ cash commitment against forecast demand—before raising a purchase order (Shopify Help Center — Managing suppliers and purchase orders, Microsoft Learn — Accounts payable invoice matching in Dynamics 365 Finance). By linking this control to purchase-order partial receipt controls and open-to-buy budget discipline, category buyer teams prevent downstream inventory and accounts-payable breaks before stock or cash moves.

Why raw unit-price comparisons fail in retail buying

When category buyers compare vendor proposals in free-form spreadsheets or email threads, three structural distortions routinely corrupt the award decision:

1. Pack-hierarchy and UOM mismatches: Vendors frequently quote at the ordering unit (master case of 24, inner pack of 6, or display tray of 12), whereas retail margin and sell-through are measured at the individual barcode (each). If a buyer divides or multiplies by the wrong pack factor when entering the purchase order into the inventory system (see Shopify's supplier and purchase-order management guide), both the landed unit cost and the ordered quantity will be wrong at goods receipt.
2. Omitted freight, packaging, or handling charges: A supplier quoting ex-works (EXW) or free-on-board origin (FOB Origin) omits inbound transport, transit insurance, and unloading charges. If a comparison sheet defaults blank freight cells to ₹0.00, an incomplete ex-works quote artificially undercuts a delivered (DAP/DDP) quote and triggers price-variance holds later during accounts-payable three-way invoice matching.
3. Ignored MOQ commitment and weeks-of-supply overhang: Buying 720 units at ₹80.00/unit to save ₹5.00/unit over a 300-unit MOQ ties up ₹57,600 instead of ₹27,300 (once freight is included). If category demand is only 140 units per month, the 720-unit order creates more than five months of cover, starving open-to-buy (OTB) budget for faster-turning SKUs and forcing end-of-season markdowns that erase the initial ₹5.00 unit savings.

Use these core normalisation formulas before ranking any two retail quotes:

Sellable Unit Base Cost (₹) = Quoted Pack Price (GST-Exclusive) ÷ Sellable Units per Quoted Pack

Minimum Order Sellable Units = Quoted MOQ (in Ordering Packs) × Sellable Units per Quoted Pack

Verified Landed Unit Cost (₹) = Sellable Unit Base Cost + (Confirmed Inbound Freight & Handling ÷ Minimum Order Sellable Units)

Total Minimum Cash Commitment (₹, Net of GST) = Minimum Order Sellable Units × Verified Landed Unit Cost

When category buyers enforce these five normalisation rules in a controlled quotation comparison sheet or procurement workflow, no vendor can appear cheaper simply by quoting in a different unit of measure, omitting delivery charges, or shifting working-capital risk onto the retailer's balance sheet.

  <path d="M219 85 L248 85" stroke="#475569" stroke-width="1.8" marker-end="url(#arrow-r002)"/>

  <rect x="248" y="40" width="195" height="90" rx="8" fill="#fef9c3" stroke="#ca8a04" stroke-width="1.5"/>
  <text x="262" y="64" font-weight="700" fill="#854d0e">2. Normalise to Sellable Unit</text>
  <text x="262" y="84">A: 120 packs = 720 units @ ₹80</text>
  <text x="262" y="102">B: 300 units @ ₹85 + freight</text>
  <text x="262" y="118" font-size="11" fill="#475569">GST-exclusive net basis</text>

  <path d="M443 85 L472 85" stroke="#475569" stroke-width="1.8" marker-end="url(#arrow-r002)"/>

  <rect x="472" y="40" width="195" height="90" rx="8" fill="#ffedd5" stroke="#ea580c" stroke-width="1.5"/>
  <text x="486" y="64" font-weight="700" fill="#9a3412">3. Audit Missing Charges</text>
  <text x="486" y="84">B freight missing -> Hold</text>
  <text x="486" y="102">Resolve freight: ₹1,800 (₹6/u)</text>
  <text x="486" y="118" font-size="11" fill="#475569">B landed = ₹91.00 / unit</text>

  <path d="M667 85 L696 85" stroke="#475569" stroke-width="1.8" marker-end="url(#arrow-r002)"/>

  <rect x="696" y="40" width="200" height="90" rx="8" fill="#dcfce7" stroke="#16a34a" stroke-width="1.5"/>
  <text x="710" y="64" font-weight="700" fill="#166534">4. Compare Commitment & OTB</text>
  <text x="710" y="84">A: ₹57,600 (103 days cover)</text>
  <text x="710" y="102">B: ₹27,300 (43 days cover)</text>
  <text x="710" y="118" font-size="11" fill="#475569">Select B within ₹35k OTB cap</text>

  <rect x="24" y="166" width="872" height="164" rx="8" fill="#ffffff" stroke="#cbd5e1" stroke-width="1.2"/>
  <text x="44" y="194" font-weight="700" font-size="13" fill="#0f172a">Governance rule: Incomplete quotes cannot be recommended, and MOQ commitment must fit category OTB</text>
  <text x="44" y="220" fill="#334155">• Gate A: Pack conversion check verifies that ordering UOM (6-pack vs each) maps deterministically to the retail barcode.</text>
  <text x="44" y="246" fill="#334155">• Gate B: Unresolved charge check blocks award recommendation whenever EXW/FOB freight, tooling, or packaging is left blank.</text>
  <text x="44" y="272" fill="#334155">• Gate C: Commitment check compares total MOQ landed cost against approved category Open-to-Buy (OTB) and 60-day sell-through.</text>
  <text x="44" y="302" font-weight="600" fill="#0369a1">Outcome: Despite A's ₹80.00 unit cost vs B's ₹91.00 landed unit cost, B is selected because ₹27,300 fits the ₹35,000 OTB cap without overstock.</text>
</g>
<defs>
  <marker id="arrow-r002" viewBox="0 0 10 10" refX="8" refY="5" markerWidth="6" markerHeight="6" orient="auto-start-reverse">
    <path d="M 0 0 L 10 5 L 0 10 z" fill="#475569"/>
  </marker>
</defs>

Worked illustrative example: six-pack MOQ versus unit quote with omitted freight

Illustrative example (hypothetical scenario): Consider the Bengaluru specialty homeware buyer evaluating quotes for SKU-CAN-450 (ceramic canister, retail selling price ₹199.00 GST-exclusive, forecasted demand 4.67 units/day or 280 units over a 60-day seasonal window, with an approved category open-to-buy budget cap of ₹35,000 for this SKU).

Step 1: Establish the baseline operational and commercial parameters

• Supplier A (QUOTE-A-104, v1):
  • Quoted price: ₹480.00 per six-pack (GST-exclusive; 12% GST applicable separately)
  • Pack conversion factor: 6 sellable units per pack
  • Minimum order quantity (MOQ): 120 six-packs
  • Delivery terms: Delivered (DAP central warehouse) — inbound freight included (₹0.00 additional)
  • Promised lead time: 14 calendar days
• Supplier B (QUOTE-B-219, v1 — initial submission):
  • Quoted price: ₹85.00 per sellable unit (GST-exclusive; 12% GST applicable separately)
  • Pack conversion factor: 1 sellable unit per ordering unit (packed in master cartons of 30 units)
  • Minimum order quantity (MOQ): 300 sellable units (10 master cartons)
  • Delivery terms: Ex-works (EXW Jaipur factory) — inbound freight field left blank (Unresolved)
  • Promised lead time: 10 calendar days

Step 2: Reconcile packs, exceptions, and financial commitment

1. Convert Supplier A to sellable units and total commitment:
   • Minimum Order Sellable Units (A) = 120 packs × 6 units/pack = 720 sellable units
   • Sellable Unit Base Cost (A) = ₹480.00 ÷ 6 = ₹80.00 per unit
   • Verified Landed Unit Cost (A) = ₹80.00 + ₹0.00 = ₹80.00 per unit
   • Total Minimum Cash Commitment (A) = 720 units × ₹80.00 = ₹57,600
   • Days of Supply at 4.67 units/day = 720 ÷ 4.67 = 154.18 days (leaving 720 − 280 = 440 unsold units worth ₹35,200 at cost at the end of the 60-day season).
2. Hold Supplier B v1 and resolve omitted freight (QUOTE-B-219, v2):
   • On initial submission (v1), Supplier B's base commitment is 300 units × ₹85.00 = ₹25,500, but because delivery terms are EXW with no freight figure, the comparison sheet marks Supplier B as Incomplete — Unresolved Freight rather than assuming ₹85.00 is the landed cost.
   • The buyer obtains a binding contracted LTL carrier quote of ₹1,800 net for the 10-carton (300-unit) shipment from Jaipur to Bengaluru (₹1,800 ÷ 300 units = ₹6.00 per unit freight cost) and logs QUOTE-B-219 v2:
   • Verified Landed Unit Cost (B v2) = ₹85.00 + ₹6.00 = ₹91.00 per unit
   • Total Minimum Cash Commitment (B v2) = 300 units × ₹91.00 = ₹27,300
   • Days of Supply at 4.67 units/day = 300 ÷ 4.67 = 64.24 days (leaving only 300 − 280 = 20 residual units worth ₹1,820 at cost after the 60-day window).
3. Compare total category economics including end-of-window clearance:
   • Although Supplier A is ₹11.00 per unit cheaper (₹91.00 − ₹80.00 = ₹11.00), ordering from Supplier A breaches the ₹35,000 OTB cap by ₹22,600 (₹57,600 − ₹35,000 = ₹22,600) and leaves 440 excess units. Even if the retailer clears those 440 excess units at a 50% markdown off the ₹199.00 retail price (₹99.50 net realization vs ₹80.00 cost), ₹35,200 of working capital remains tied up after day 60. Supplier B requires ₹30,300 less upfront cash (₹57,600 − ₹27,300 = ₹30,300) and stays ₹7,700 inside the ₹35,000 OTB ceiling.

In this illustrative scenario, the category buyer awards the 300-unit order to Supplier B (QUOTE-B-219 v2) at ₹27,300 total landed commitment (or uses the normalised sheet to negotiate Supplier A's MOQ down from 120 packs to 50 packs / 300 units). The award record explicitly stores why the higher unit-cost offer was chosen: staying within the ₹35,000 OTB cap and avoiding ₹30,300 of excess inventory lock-up.

Quotation comparison workflow: roles, exception handling, and system choice

To make every supplier selection auditable and prevent post-award invoice disputes, run a four-stage comparison workflow:

1. Capture versioned vendor quotes with mandatory pack and Incoterm fields (Owner: Category Buyer). Record the supplier's quotation reference, validity date, ordering UOM, sellable units per ordering pack, MOQ in ordering packs, delivery basis (EXW, FOB, DAP, DDP), and GST rate. Never overwrite v1 when a supplier sends a revised price; log v2 as a distinct row.
2. Normalise to sellable units and quarantine missing cost elements (Owner: Buying Analyst / Worksheet Rule). Calculate Minimum Order Sellable Units and Sellable Unit Base Cost. If delivery terms are ex-works or origin-based and freight is blank, set the line status to Blocked — Unresolved Charge rather than ₹0.00.
3. Evaluate total MOQ commitment against category OTB and sell-through cover (Owner: Merchandise Planner). Compare Total Minimum Cash Commitment against the open-to-buy budget for the delivery month (see Shopify's open-to-buy planning methodology and our retail open-to-buy budget guide). Any quote whose MOQ exceeds 90 days of forecast demand requires merchandise-head sign-off before award.
4. Lock the award basis onto the purchase order and AP matching tolerance (Owner: Procurement Operations). Transfer the approved ordering UOM, pack conversion factor, unit price, and freight allowance onto the ERP purchase order so warehouse receiving (partial PO receipts) and accounts-payable invoice matching validate against the exact awarded terms.

Choosing the right tool: A locked, formula-protected comparison worksheet with mandatory dropdowns for delivery terms and pack conversion is sufficient for specialty retailers running occasional seasonal tenders. Upgrade to a structured ERP RFQ or procurement quotation workflow when multiple buyers negotiate parallel quote revisions, when landed-cost duty/freight tables must calculate automatically, or when approvers need an immutable version log.

Observable acceptance tests for your retail systems

Before relying on this workflow in production, execute three deterministic acceptance tests (ACT-R002-01 to ACT-R002-03) in your staging environment or controlled worksheet:

Putting structured quote comparison into practice

To standardise supplier quote comparisons across your buying team without slowing down seasonal purchasing:

1. Audit your last 15 competitive purchase awards and check how many compared quotes on a normalised sellable-unit landed basis versus raw quoted price, and how many incurred unbudgeted inbound freight invoices after receipt.
2. Add mandatory pack-conversion and delivery-term fields to your quotation comparison sheet so every pack quote converts automatically to sellable retail units (Each) and any EXW/FOB quote with blank freight defaults to Unresolved instead of zero.
3. Link quotation MOQ totals to category open-to-buy checks so buyers see both the per-unit landed cost difference and the total working-capital commitment (MOQ Units × Landed Unit Cost) before selecting a vendor tier.
4. Run acceptance tests ACT-R002-01 to ACT-R002-03 with your category buyers on one upcoming seasonal tender and attach the signed comparison record to the resulting purchase order.