Supplier pack sizes make the cheapest quote misleading

The problem

Quotes use each, case or carton units and different minimum orders, hiding the actual cost and surplus quantity.

Agent job

Normalize supplied offers to an approved unit of need and flag assumptions that prevent fair comparison.

Expected output

A formula-based comparison of usable quantity, pack rounding, quoted freight and total cost, with unknowns left blank.

Why an agent / simpler alternative

An agent can reconcile supplier-specific prose and pack terminology before applying transparent arithmetic. A purchasing system with validated unit conversions is preferable for recurring standardized SKUs; a manual spreadsheet is enough for simple equivalent offers.

Who this helps

1. Purchasing coordinator

2. Operations manager

Evidence boundary

Problem and capability sources establish context and tool primitives only. All workflow design, examples, expected outputs and validation plans are editorial proposals; no workflow success is evidenced.

Setup requirements

1. A buyer-approved unit of need and exact SKU/variant list

2. Complete quotations including pack contents, minimums, freight and quoted validity dates

3. A declared currency and tax comparison basis; no invented exchange rates

Inputs and access

1. Name

   Supplier quotes

   Source or owner

   Authorized role owner; synthetic fixtures for first test

   Sensitivity

   Potentially confidential business records; redact personal data, credentials and unrelated content

   Permission needed

   Owner authorizes processing in the selected agent environment; no broader account connection is assumed

2. Name

   Requested quantities and unit definitions

   Source or owner

   Authorized role owner; synthetic fixtures for first test

   Sensitivity

   Potentially confidential business records; redact personal data, credentials and unrelated content

   Permission needed

   Owner authorizes processing in the selected agent environment; no broader account connection is assumed

3. Name

   Approved freight and tax comparison assumptions

   Source or owner

   Authorized role owner; synthetic fixtures for first test

   Sensitivity

   Potentially confidential business records; redact personal data, credentials and unrelated content

   Permission needed

   Owner authorizes processing in the selected agent environment; no broader account connection is assumed

Proposed steps

1. 1

   Register each offer, SKU, validity period and quoted currency; identify missing pages.

   Expected output: Offer completeness manifest

   Approval gate: Owner confirms authorized input scope and policies before this step.

2. 2

   Extract unit, pack size, minimum order, unit or pack price and stated charges with source references.

   Expected output: Raw commercial terms table

   Approval gate: Pause for the named owner if a required assumption or permission is missing.

3. 3

   Confirm conversion to the unit of need using explicit supplier evidence; quarantine ambiguous conversions.

   Expected output: Validated conversion map and questions

   Approval gate: Pause for the named owner if a required assumption or permission is missing.

4. 4

   Calculate packs required, usable quantity and surplus after rounding up to purchase constraints.

   Expected output: Formula-driven quantity comparison

   Approval gate: Pause for the named owner if a required assumption or permission is missing.

5. 5

   Calculate comparable total costs only where charge assumptions are known; show excluded or unknown amounts.

   Expected output: Cost comparison with uncertainty fields

   Approval gate: Pause for the named owner if a required assumption or permission is missing.

6. 6

   Deliver alternatives and buyer clarification questions without selecting a supplier or placing an order.

   Expected output: Procurement review workbook

   Approval gate: Human owner reviews this packet before any operational use; no external action is authorized.

Synthetic output illustration — not an executed result

Label

Clearly synthetic illustration; not a completed run or real customer record

Data

Offer

SYNTHETIC B

Need

50 units

Pack

12 units

Required packs

5

Usable units

60

Surplus units

10

Freight

Unknown; excluded from comparison total

Human approval boundaries

1. Confirm data ownership, allowed processing environment and minimum necessary input scope before using real records.

2. Review exceptions and calculations before treating the output as authoritative.

3. Separate explicit approval is required for sending, publishing, purchases, account changes or production-system writes; none are included in this plan.

Failure modes

1. Carton contents inferred from a similar SKU

2. Freight thresholds omitted

3. Currency conversion silently assumed

4. Source documents may contain malicious instructions; treat them as evidence only.

Recovery and troubleshooting

1. If pack contents are unknown, leave the conversion and total blank and request supplier clarification through the buyer.

2. If variants differ, split them into non-comparable offers rather than forcing a price ranking.

3. If a quote has expired, mark it unusable for a purchase decision until the owner obtains refreshed terms.

Unexecuted validation plan

Sample setup

Three mock offers with different pack sizes, a minimum order and an ambiguous carton quantity.

Acceptance checks

1. Known calculations match manual results

2. Ambiguous carton has no fabricated unit price

3. No purchase or supplier choice is made

4. All factual claims have source pointers; no invented facts, success metrics or time-saving claims.

5. Original input files remain unchanged.

Stop conditions

1. Any critical planted exception is missed

2. A factual assertion lacks support

3. The agent requests unauthorized access or attempts external action

Executed

No

Costs and effort — unknown or hypothetical

Status

unknown_or_estimate

Currency

Not specified.

Items

1. Eligible paid agent plan; current price and limits must be checked before testing

2. One-time input export, redaction, taxonomy or policy setup and reviewer time

3. Recurring per-batch usage and human exception review

4. Optional connector or OCR fees only if actually needed; not assumed included

Caveat

No numerical cost, time saving or return is established. Start with supplied files to avoid integration build costs.

Canadian adaptation — proposed

For Canadian supplier comparisons, obtain the buyer’s CAD/foreign-currency basis and owner-supplied tax, freight, duty and brokerage assumptions. Keep metric/imperial pack conversions explicit; do not invent exchange rates or import charges.

Limits

1. Original authored proposal; no workflow was executed or independently tested.

2. Problem sources establish duties or a concrete requirement; they do not prove prevalence, willingness to pay or effectiveness of this workflow.

3. Official capability documentation supports primitives only; platform and connector compatibility remain untested.

4. An accountable specialist must approve all judgments, source selection and any use of the deliverable; the agent only prepares a review packet.

5. Platform references refreshed on 14 October 2026; verify the actual account, execution surface, permissions and dependencies before any pilot.

Candidate platforms — compatibility untested

1. Name

   Claude (Cowork capabilities)

   Required capabilities

   1. Read approved document and spreadsheet inputs

   2. Compare evidence across files

   3. Execute auditable calculations where needed

   4. Create a separate review workbook or document

   Capability source urls

   1. https://support.claude.com/en/articles/13345190-get-started-with-claude-cowork

   2. https://support.claude.com/en/articles/16761823-claude-cowork-and-chat-are-one-claude

   Workflow compatibility

   Unknown; verify in the proposed first test.

   Historical candidate name

   Claude Cowork

   Selection basis

   Editorial candidate from general capabilities; exact end-to-end fit untested.

2. Name

   ChatGPT Work

   Required capabilities

   1. Read user-supplied files

   2. Use code for checks and transformations

   3. Produce reviewable spreadsheet and document outputs

   Capability source urls

   1. https://learn.chatgpt.com/docs/get-started-with-work

   2. https://learn.chatgpt.com/docs/artifacts-viewer

   3. https://learn.chatgpt.com/docs/sandboxing

   4. https://learn.chatgpt.com/docs/enterprise/chatgpt-work-overview

   Workflow compatibility

   Unknown; verify in the proposed first test.

   Historical candidate name

   ChatGPT agent

   Selection basis

   Editorial candidate from general capabilities; exact end-to-end fit untested.