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
- Download the editable comparison workbook (.xlsx) with visible inputs, formulas, and a conditional candidate.
- Download the one-page decision brief (.pdf) for the original scenario.
- Download the original synthetic quote inputs (.csv). Blank freight and tax fields mean unknown, not zero.
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.
| Supplier | Price / pack | Boxes / pack | MOQ, packs | Freight | Tax rate | Quoted board |
|---|---|---|---|---|---|---|
| Alder Carton | $42.00 | 20 | 40 | $85.00 | 8% | Double-wall |
| Birch Pack | $48.00 | 25 | 40 | Unknown | Unknown | Double-wall |
| Grove Carton | $91.00 | 50 | 25 | $0.00, included | 8% | 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.
| Order comparison | Alder Carton | Birch Pack | Grove Carton |
|---|---|---|---|
| Quoted price per box | $2.10 | $1.92 | $1.82 |
| Whole packs to purchase | 49 | 40 | 25 |
| Boxes purchased | 980 | 1,000 | 1,250 |
| Boxes above requirement | 0 | 20 | 270 |
| Goods amount | $2,058.00 | $1,920.00 | $2,275.00 |
| Freight | $85.00 | Unknown | $0.00, included |
| Tax amount | $171.44 | Unknown | $182.00 |
| All-in order amount | $2,314.44 | Unknown | $2,457.00 |
| Quoted specification | Match | Match | Mismatch: single-wall |
| Lead time | 10 calendar days | 12 calendar days | 7 calendar days |
| Decision status | Conditional shortlist | Obtain missing costs | Request 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
- Required packs = required boxes ÷ boxes per pack, rounded up to a whole pack.
- Order packs = the greater of required packs and minimum packs. Order boxes = order packs × pack size. Excess = order boxes − required boxes.
- 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.
- All-in cost is unavailable until freight and tax are known. A numeric zero is used only for an explicitly confirmed zero charge.
- 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.
Clear scope. Careful checks.