Worked example · entirely synthetic

A supplier comparison you can inspect.

Three fictional quotes. Different pack sizes, a minimum-order constraint, missing charges, and a specification mismatch. See what changes when the comparison uses the whole order.

All figures in USD · Original scenario: 18 October 2026

Synthetic demonstration only. All suppliers, quotes, and assumptions below are fictional. This is not client work, a real supplier recommendation, or a claim of achieved results or savings.

Open the working files

The workbook recalculates when its yellow input cells change. This page, the PDF, and the source CSV are fixed snapshots of the original example.

Start with the requirement

Purchase 980 flat-packed storage boxes with internal dimensions of 400 × 300 × 250 mm, double-wall board, and delivery within 14 calendar days. The example compares quoted dimensions and board construction; a real purchase also needs sample and specification approval.

Original fictional quote inputs. MOQ is the minimum order quantity, expressed in whole packs.
SupplierPrice / packBoxes / packMOQ, packsFreightTax rateQuoted board
Alder Carton$42.002040$85.008%Double-wall
Birch Pack$48.002540UnknownUnknownDouble-wall
Grove Carton$91.005025$0.00, included8%Single-wall

Normalize the order before comparing

Round the required quantity up to whole packs, then apply each supplier’s minimum. A lower price per box can still mean excess stock, unknown delivered cost, or an unsuitable product.

All amounts are fictional. The all-in amount includes the full order, not just the 980 boxes needed.
Order comparisonAlder CartonBirch PackGrove Carton
Quoted price per box$2.10$1.92$1.82
Whole packs to purchase494025
Boxes purchased9801,0001,250
Boxes above requirement020270
Goods amount$2,058.00$1,920.00$2,275.00
Freight$85.00Unknown$0.00, included
Tax amount$171.44Unknown$182.00
All-in order amount$2,314.44Unknown$2,457.00
Quoted specificationMatchMatchMismatch: single-wall
Lead time10 calendar days12 calendar days7 calendar days
Decision statusConditional shortlistObtain missing costsRequest compliant requote

Conditional recommendation: shortlist Alder, but do not award yet. It is the only fully priced quote that matches the stated specification and timing in the original scenario. Written confirmation of the sample, availability, delivery, and complete charges is still required. The buyer makes the final decision.

Birch is unresolved, not automatically more expensive. Grove’s lower unit price does not make its single-wall product equivalent to the requested double-wall box.

Ask specific supplier questions

  • Alder: Can you confirm the double-wall sample, stock, and a firm 10-day delivery? Does $2,314.44 include every required charge?
  • Birch: What are the freight charge, tax rate, taxable basis, and any other fees for 1,000 boxes? Is the 12-day delivery firm?
  • Grove: Please requote the required double-wall box. Does that change the pack size, MOQ, delivered cost, or lead time?

Next actions: Purchasing obtains the missing and corrected quotes. Operations confirms the sample and delivery constraints. Update the workbook’s editable inputs, compare again, and approve any purchase separately.

The method stays visible

  1. Required packs = required boxes ÷ boxes per pack, rounded up to a whole pack.
  2. Order packs = the greater of required packs and minimum packs. Order boxes = order packs × pack size. Excess = order boxes − required boxes.
  3. Goods amount = order packs × quoted pack price. Tax = (goods + freight) × tax rate, rounded to cents. The 8% rate and taxable basis here are fictional conventions, not jurisdiction-specific rules.
  4. All-in cost is unavailable until freight and tax are known. A numeric zero is used only for an explicitly confirmed zero charge.
  5. The workbook identifies the lowest fully priced quote with matching labels and acceptable lead time. It does not verify the physical product, choose an unknown-cost quote, or authorize an order.

For a simple test, enter $180 freight and 8% tax for Birch. Its total becomes $2,268.00 and the conditional candidate changes to Birch. Those test values are hypothetical, not a new quote or a savings claim. Clear them to return to the original unknown-cost case.

No value is assigned to excess stock. No external links, macros, or live supplier connections are required. Supplier questions and narrative notes refer to the original scenario and should be refreshed if the inputs change.

Help opening these files

Select the file link, then check the page that opens or your Downloads folder.

PDF: read it in your browser. DOCX: edit it in Word or a compatible document app. XLSX or CSV: open it in a spreadsheet app. TXT: open it as plain text. You can read the example on this page without downloading anything.

If a file does not open, tell us the file name and what happened. Do not send private data in your first message.

Need help using this site?

New here? You do not need to know the service name. Tell us what you have now and what a useful finished result would look like.

  1. Start a short inquiry. A few sentences are enough, and no account or files are needed.
  2. Compare services, package prices, and quote options, or see complete public-source examples before you ask.
  3. Already working with Cleargrain? Use Client Login for private requests, files, messages, and project review.

Still unsure? Describe the result you need, including technical detail if useful. Larger spreadsheets and custom work are welcome; we’ll review the task before agreeing on the work and price.

What do the file types and technical terms mean?
PDF
A document you can read in a browser or PDF reader.
XLSX
An Excel workbook. Open it in a spreadsheet app to inspect the full example.
DOCX
An editable Word document. Open it in Word or another compatible document app.
CSV
A plain spreadsheet file. Open it in a spreadsheet app to see rows and columns.
TXT
A plain-text checklist or template. Open it in a text editor or copy its text.
SOP (standard operating procedure)
A step-by-step guide for a recurring task.
CRM (customer relationship management)
A system used to organize customer or contact records.
Workflow
The steps that move a task from start to finish.
Flat file
One table of rows and columns, with one header row.
Exception list
Records that need a decision or more information, with references to the original rows.
Source-ready procedure
A procedure written from approved material you already have, rather than from a supplied walkthrough.
Preference revision
One collected round of requested adjustments within the agreed work. Correcting work that fails the written scope is separate.
White-label support
Work prepared for your agency to review and present in its own branding.

To download a file, select its download link. It may open in your browser or appear in Downloads. If the browser asks, choose where to save it. Downloading an example does not place an order.