Compare HVAC supplier quotes by pack size and required quantity

Extract the commercial units before comparing prices

Collect the approved material requirement and dated supplier quotes. Keep the requested item identifier, specification reference, required quantity, supplier item code, units per pack, pack price, quote validity, freight and tax treatment in separate fields. AI can prepare an extraction table, but the estimator must verify those fields against the source. A quoted box is not automatically one required unit.

Keep substitutions outside this exercise. Similar descriptions do not establish that two filters, controls or accessories are interchangeable. Where the specification or pack count is missing, return an open question rather than a calculated recommendation. Preserve the original supplier wording next to the normalized value.

Test the table with a fictional order

Suppose a reviewed requirement calls for 18 identical approved items. Supplier A quotes packs of four at $36; Supplier B quotes individual items at $10.50. A has an implied unit cost of $9, but whole-pack purchasing requires five packs: 20 items for $180, leaving two surplus. B supplies exactly 18 for $189. These are illustrative numbers before freight, tax and other excluded costs.

Calculate packs with rounding up, not ordinary nearest-number rounding. Show the requirement, purchased quantity and surplus separately. If freight is unknown for A, the $9 difference cannot establish which delivered order costs less. Do not let the assistant silently allocate surplus to another job or assume an existing stock balance.

Give the estimator a comparison they can approve

Use a calculator or spreadsheet to verify every extension independently of the model’s explanation. Have the purchasing or estimating owner confirm specification equivalence, supplier validity and whether surplus is useful under existing inventory rules. An accepted comparison authorizes only what that person actually approves; it does not place an order.

Retain a short decision note explaining the selected basis, excluded costs and unresolved questions. Refresh the table when the quote expires or the required quantity changes. A pilot should track incorrect pack conversions, missing-cost flags and reviewer corrections. Do not claim buying savings from a lower displayed unit price unless actual comparable purchasing records support that conclusion.

Release checklist

• Verify item specification and units per pack.
• Round required packs up and show surplus.
• Keep unknown delivered costs visible.
• Independently check arithmetic before purchasing approval.

Source context and limits

Jobber documents a product/service catalog and unit-cost/price fields. The whole-pack comparison and fictional arithmetic are our proposed review method, not an automated supplier-selection feature or evidence that two products are technically equivalent.