Compare corporate gift supplier quotes on the same required quantity, specification, destination and delivery promise before comparing price. Record every fee, the quote currency and conversion evidence, minimum order, sample approval, capacity and exclusions. A missing charge is unknown, not zero. The downloadable workbook separates a calculable cash estimate from a decision that still needs evidence and an authorized award. It does not invent market prices, determine taxes or select a supplier automatically.
Download and define one comparison scope
Download the English supplier quote comparison workbook. Version 1.0, October 18, 2026, contains Read Me, Inputs, Bid Lines, Scenario, Missing Evidence, Decision Log and Sources. Its examples are explicitly hypothetical. They are not supplier offers, price benchmarks or customer results. Replace the sample inputs with documented quotes before using a working copy for procurement.
Start with a written scope version. State the required usable quantity, product specification, decoration, packaging, destinations, receipt date, inspection requirement and acceptable substitutions. A supplier offering a printed notebook and another offering an unprinted notebook have not quoted the same item. Neither has a supplier offering delivery to one warehouse and another offering individual parcels to employees. Resolve these differences in the request, not in a hidden adjustment after bids arrive.
Use one working copy per consistent campaign and destination scope. For a two-country program, maintain destination-level evidence and reconcile both copies to the overall order. Do not divide a combined quote by two unless its allocation is supported. Shared tooling, consolidated freight and destination-specific taxes can make a simple split misleading. Keep any allocation method, owner and source beside the actual quote evidence.
The workbook intentionally has three example bid columns and no automatic cheapest-supplier ranking. Blue input cells hold assumptions; formulas calculate quantities, selected price tiers, cash estimates and delivery buffers. Evidence fields remain separate. Missing Evidence observes the bid calculations and confirmations. It does not authorize an order. Decision Log has editable fields for the responsible person, date, disposition and exceptions; those fields are not prefilled with invented approval.
Freeze the decision basis before asking for clarification. Procurement owns comparable scope and quote versions. Finance owns currency conversion, cash versus accounting treatment and budget acceptance. Operations owns the practical schedule and delivery path. The brand or quality owner approves the relevant sample. An authorized commercial owner makes the award. The same person may hold several roles, but the evidence should show which decision was made.
Normalize quantities and costs without hiding missing information
The International Trade Administration’s landed-cost guidance includes product price, insurance, freight, tariffs, taxes and other fees, and emphasizes that the result is estimated. This workbook uses a buyer-input cash estimate, not an automated customs valuation. Actual classification, charges, importer responsibilities and tax treatment require the relevant specialist and current shipment facts. A domestic order also needs its own tax assumptions; the example’s explicit zero is not a US exemption claim.
The following field map is the minimum practical preview. Each monetary line must use the relevant bid currency before conversion. If a fee is already included elsewhere, record that treatment rather than charging it twice.
| Input group | Required evidence | Owner and consequence |
|---|---|---|
| Scope and quantity | Specification version, required units, minimum order and actual tier | Procurement verifies equivalent deliverables |
| Price and fees | Unit price, packaging, tooling, sample, freight, clearance, tax outlay and final delivery | Finance holds incomplete estimates |
| Currency | Quote currency, reporting currency, conversion direction and dated rate evidence | Finance approves one consistent comparison basis |
| Time | Sample, production and transit days, validity and required receipt | Operations confirms the calendar and buffer |
| Execution evidence | Approved sample, customs and tax scope, capacity and quote reference | Responsible reviewers clear each open item before award |
Requested quantity and order quantity are not necessarily equal. The model orders the greater of required units and the supplier’s stated minimum. It displays surplus separately and divides cash by required units to expose the cost of buying more than the campaign needs. This is a deliberately simple minimum-order model. It does not round to carton multiples or enforce complex size or color minima. If those apply, obtain the actual permitted quantity and adapt the documented order scope rather than trusting the default formula.
The price tier follows modeled order quantity, not the buyer’s hoped-for quantity. Two price cells support one explicit tier boundary. An unused tier may be blank; the selected tier may not. Suppliers with several breaks, mixed products or separate decoration thresholds need a documented extension or separate comparable lines. Do not squeeze a complicated quote into two numbers and claim that the workbook has normalized every exception.
Fixed charges are totals for the whole bid. Packaging is per ordered unit. The model combines goods and packaging with tooling, samples, freight, clearance, tax cash outlay and final delivery, then applies the user-entered cost-increase stress. Freight has a separate stress multiplier. Both start at neutral values. This is a planning sensitivity, not a prediction or a tax engine. Do not add insurance again if a freight amount already includes it; if separately charged, include and document it within the appropriate complete freight input.
Worked case A: 500 domestic kits and a misleading unit price
Assume a hypothetical campaign needs 500 usable kits at one domestic destination within 60 calendar days. Every kit has the same approved specification and two currency units of packaging. All example bids use the same reporting currency with an explicitly documented one-to-one conversion. These amounts exist only to explain the model. No actual market price, supplier performance or permitted gift value is implied.
Supplier A quotes 18 per item, a 500-unit minimum, 1,800 tooling, 200 samples, 600 freight and 150 final delivery. Supplier B quotes 20 per item, a 300-unit minimum, 300 tooling, 100 samples, 400 freight and 250 final delivery. Clearance and tax cash inputs are explicitly zero in this hypothetical domestic comparison after an assumed finance review. They must be replaced when the real order requires charges. Neither packaging nor freight is silently included in the unit price.
For A, 500 multiplied by the sum of 18 and 2 gives 10,000 of goods and packaging: 500 × (18 + 2). Fixed charges total 2,750, producing 12,750 of modeled cash, or 25.50 per required kit. For B, goods and packaging total 11,000 and fixed charges total 1,050. Its modeled cash is 12,050, or 24.10 per required kit. B is 700 lower despite a unit price two higher. The result follows these inputs, not a general rule that high unit prices produce better deals.
Supplier C quotes 17 per item but leaves freight blank and has neither sample approval nor complete customs and tax scope confirmation. The workbook does not convert that blank into a bargain. Its cash result is unavailable and its decision state is HOLD. Asking C to complete the same scope is fairer than either assuming zero freight or excluding it permanently for an ordinary, correctable omission. Preserve the original version while requesting a revised offer.
Time changes the choice too. A’s assumed sequential schedule is five days of samples, forty of production and five of transit: fifty calendar days, leaving ten. B’s corresponding schedule is five, twenty and five: thirty days, leaving thirty. Those buffers do not prove either supplier can deliver. Operations still verifies the start trigger, artwork approval, capacity reservation, holiday calendar and receiving appointment. A production promise measured from deposit is not equivalent to one measured from approved artwork.
The defensible provisional decision is to advance B for award review if its sample, capacity and terms satisfy the frozen requirements. A remains an alternative with a different tooling and timing profile. C remains pending clarification. If the event moves earlier, rerun the receipt buffer. If required quantity falls to 250, A still requires 500 and shows 250 surplus; its cash per required unit becomes 51. That is a real consequence of the example minimum, not a spreadsheet error to suppress.
Acceptance evidence is the frozen scope, three original quotes, the two completed sample approvals, confirmed fee treatment, recalculated totals, scheduling assumptions and the named award decision. A low number alone is insufficient. Keep cancellation, defect remedy, ownership of tooling and any retained samples in the commercial record, even when those terms do not have a numeric column in the workbook.
Worked case B: 2,000 units across two countries
Now assume a hypothetical 2,000-unit program serving two countries. First separate the destination scopes and obtain a supported allocation of common costs. A supplier’s combined total may conceal who imports, who pays a destination charge or whether the second delivery is included. The purpose of the two-country review is to uncover those differences, not to create a universal cross-border rate. Do not use the domestic sample’s zero tax and clearance inputs by habit.
As a quantity-only test of the original workbook examples, changing required units from 500 to 2,000 selects the illustrative higher tier: A becomes 17 per item and B becomes 19. With all other original costs unchanged, their totals become 40,750 and 43,050. This isolates quantity sensitivity. It is not a two-country landed quote. Actual destination costs and new evidence must replace the original assumptions before making a procurement comparison.
For a separate illustrative two-country review, suppose A’s goods and packaging still total 38,000, with 1,800 tooling, 200 samples, 1,800 freight, 800 tax outlay and 450 final delivery. Clearance is missing. The answer is unavailable, not 43,050 or another guessed total. If the responsible provider later confirms 300 clearance on that exact scope, the revised estimate is 43,350. Keep the quote version, confirmation and allocation to destinations with the calculation.
Suppose B’s goods and packaging are 42,000, with 300 tooling, 100 samples, 1,200 freight, 300 clearance, 800 tax outlay and 350 final delivery. Its provisional cash estimate is 45,050. But B has not supplied an approved sample for the actual decoration. Its cost can be calculated while its award remains held. A complete price does not compensate for missing quality evidence, just as a beautiful sample does not fill a missing customs service scope.
The alternatives are to clarify A, obtain B’s correct sample, split sourcing by market, reduce the specification or postpone the gift. Splitting may improve local execution but duplicate tooling, approvals and coordination. A simpler item may reduce production steps but change the promised recipient experience. Postponement preserves the team’s ability to make an informed decision when the deadline cannot be met safely. None should be selected merely to make a spreadsheet status look complete.
Test a failure: A revises freight after its quote expires. Procurement saves the replacement, finance changes the actual freight input and review date, and operations reconfirms capacity and timing. Do not overwrite the original attachment or retain its old validity as though it covers the revision. A changed destination or decoration may invalidate a sample or tier as well. Reopen the affected evidence, not every unrelated decision.
For acceptance, reconcile destination quantities back to 2,000, reconcile shared charges once, verify no unsupported zero remains, and document the final importer, tax and delivery responsibilities outside the numeric model. Finance approves the conversion basis and cash funding. The authorized award owner records why the chosen route is acceptable and which residual exceptions have an owner and deadline. Shipment release follows that decision; it is not triggered by a calculated comparable state.
Use the workbook as an evidence-controlled working file
-
Save an unchanged master and create a campaign copy with the scope version. Read the instructions and replace the illustrative review date, quantity, reporting currency and receipt horizon.
-
Enter each quote’s version, currency, conversion rate and evidence date. The rate means reporting-currency units for one quote-currency unit. A reciprocal entry reverses the result; verify it with a small independent conversion.
-
Enter the actual minimum, price boundary, applicable unit prices, packaging and whole-bid fees. Keep unknown charges blank. Enter a confirmed zero deliberately and retain the explanation in the evidence record.
-
Add sequential sample, production and transit days. The model uses calendar days and does not incorporate a holiday service or promise parallel work. Operations must reconcile the result with the real supplier schedule.
-
Confirm sample, customs and tax scope, capacity and a unique evidence reference only when the responsible reviewer has the supporting record. Cost comparability is not proof of any of those facts.
-
Change quantity and stress inputs in the same model, recalculate, capture the decision-relevant result and restore the intended case before sharing. The Scenario sheet describes this manual process; it is not a second hidden forecast.
-
Record the actual decision owner, date, disposition and exceptions. Export or archive the reviewed working version with its quote documents so another person can reproduce the decision.
The file deliberately excludes bank details, recipient addresses and individual gift eligibility. Those do not help normalize a sample kit quote and should not be copied into an evaluation file without a separate purpose and access decision. If a service receives recipient data later, evaluate that separately from product cost and maintain the applicable privacy and security review.
The tool is also not a credit-risk model. Payment milestones, deposit exposure, refund terms, warranties and capacity reservation may decide the award even when they are not added to the cash subtotal. Record their commercial consequences and compare a documented alternative. Do not invent a risk score, a financing rate or a probability of failure to make qualitative uncertainty look objective.
For example, two offers with the same cash estimate can expose the company to different commitments. One may require a nonrefundable deposit before sample approval; another may reserve stock only after the purchase order. Ask finance and procurement to identify the maximum committed amount at each milestone and the last reversible decision. Keep that analysis beside the actual payment terms. Do not add an arbitrary percentage to the cheaper offer and call the difference a verified risk premium.
Set a handover rule for the working file. A receiving operator should be able to locate the approved specification, open the current quote, identify the rate source and reproduce one total without asking the author what a blank meant. Have that operator change one quantity, observe the tier and surplus, then restore the approved inputs. Check one incomplete bid too. If the file still looks ready after a required approval is removed, investigate the formula or the record before distributing it. This is a practical acceptance test for the local working copy, not evidence that any supplier has performed.
Resolve incomplete or changing quotes before release
Treat an incomplete quote as an action queue. Identify the exact missing field, ask the supplier the same scoped question, assign an internal reviewer and set a decision date. Keep the rest of the comparison moving. A missing freight input should not prevent another supplier’s sample review, but it must prevent the incomplete offer from being presented as a fully priced alternative.
What should happen when a blank fee is described as included?
Obtain a dated clarification identifying where it is included and which scope it covers. Then enter an explicit zero in the separate fee line only if that avoids double counting and preserves the total quoted cost. Save the clarification with the quote version. If the provider has not confirmed the interpretation, keep the fee unknown and the decision held.
Use a new quote version for substantive changes. Preserve the original currency, amount and exclusions in the source record rather than rewriting history. After a new sample or revised delivery path, recheck only the dependencies it changes: packaging cost, quantity tier, capacity, transit, taxes, cancellation and receipt buffer may all be affected. A new filename does not prove that these checks happened.
Before an order is released, require a short evidence pack: comparable specification and destinations, current quote, complete fee treatment, dated conversion basis, approved sample, capacity confirmation, feasible receipt schedule, authorized award and a final exception log. If one item remains unacceptable, hold the affected award or use a separately approved alternative. Do not route around a customer’s no-gift rule or substitute a different destination to bypass restrictions.
Conclusion: compare an executable promise
The useful result of quote comparison is an explainable purchasing decision, not the smallest displayed unit price. Normalize required and ordered quantities, keep fixed and per-unit fees distinct, expose missing information and make time and evidence visible. The domestic example shows why tooling can reverse a unit-price impression. The two-country example shows why a calculable cost and an awardable proposal are different. Refresh quote evidence for every award and review this template’s scope quarterly; no stored formula keeps a supplier’s commercial promise current.
Once the scope and decision rights are approved, Giftpack can be evaluated for sourcing, production and fulfillment coordination. Require the same line-item evidence and agreed service scope as any other route. It remains an execution option, not a substitute for procurement, finance, customs, legal or employer-policy decisions.