Cold Chain Packout Cost: A Transparent Comparison Worksheet
A transparent cost worksheet for cold chain packout: materials, labor, monitoring, return logistics and losses, with formulas and blank cells you fill in.
The comparison question
A cheaper box can cost more per shipment once labor, refrigerant, monitoring, returns and losses are included. Compare T = H + K, where H is packout cost and K is outbound freight, both per shipment in the same currency and period. This blank worksheet contains no market prices; its examples use assumed accounting units.
Table: scroll horizontally if needed to see every column.
| Minimum input | Basis to record | Why it matters |
|---|---|---|
| Lane, protection target and period | Same scope for every option | Keeps the comparison consistent |
| Currency and shipment count N | Finance records; N must be positive | Prevents mixed units and zero division |
| Packout H | Materials, refrigerant, labor, monitoring, returns, losses | Includes costs beyond the box |
| Freight K | Carrier/service, packed size and weight, applicable charges | Adds outbound shipping separately |
| Input source/date and low/high assumptions | Quote, accounts, time study or marked estimate | Makes T and sensitivity reviewable |
Copy the tables into your working record, keeping the formulas and units. Related guides sit in the procurement section.
Common premises for a fair comparison
Fix these before you enter any cost, and apply the same ones to every option.
- Same lane set and season: compare options for the same routes and the same ambient conditions.
- Same protection target: each option must meet the same documented temperature range and time requirement, backed by evidence. Reading that evidence is covered in the guide on qualification report review. An option that misses the target is not a cheaper option.
- Same period: pick a period, such as a quarter or a year, and count shipments in that period.
- Same boundary: decide what is inside the cost: your site only, or origin to final return of reusable parts.
- Traceable data: record the source and date for each input (quote, accounts, time study or marked estimate). Use one currency; record any currency conversion and its date. For a shipment containing several packages, total its package charges before entering a per-shipment amount.
What goes into the cost per shipment
The worksheet calculates per-shipment amounts first. The period column below is a separate reconciliation: only amounts for the whole period can be summed and divided by N. Do not divide H or K by N again.
Table: scroll horizontally if needed to see every column.
| Component | Per-shipment amount (currency/shipment) | Period amount (currency for the selected period) |
|---|---|---|
| Packaging materials | B4 | N × B4 |
| Refrigerant and conditioning | C3 | N × C3 |
| Labor | D3 | N × D3 |
| Monitoring | E3 | N × E3 |
| Return logistics | F4 | N × F4 |
| Losses and excursions | G3 | G1 × G2 |
| Packout total | H = B4 + C3 + D3 + E3 + F4 + G3 | N × H |
| Outbound freight | K | N × K |
| Combined total | T = H + K | N × T |
Data sources for each component
Table: scroll horizontally if needed to see every column.
| Component | Where the data comes from | Typical traps |
|---|---|---|
| Packaging materials | Supplier quotes, purchase orders | Quotes that exclude inserts, tape or labels |
| Refrigerant and conditioning | Supplier quotes, utility bills, freezer or cold room capacity | Ignoring freezer space and the energy used to condition packs, and dry ice handling and surcharges |
| Labor | Time study at your packing station, wage plus overhead | Using a supplier’s quoted assembly time instead of your own |
| Monitoring | Logger prices, software fees, data handling time | Counting logger purchase but not reading, reporting and replacement |
| Return logistics | Carrier quotes, handling and cleaning time (reusable only) | Treating returns as free, or forgetting lost units |
| Losses and excursions | Complaint and deviation records, product value | Using a guess for loss rate with no record behind it |
If you use real-time devices, the guide on real-time vs offline monitoring explains what each approach costs in handling and data, which feeds the monitoring row.
The worksheet
Fill the blank cells. Keep one record per option and lane group. N is the shipment count in the selected period; “currency” means the single accounting currency chosen for this comparison.
Table: scroll horizontally if needed to see every column.
| Line | Item | Unit | Input or formula | Your value |
|---|---|---|---|---|
| A | Shipments in period (N) | shipments/period | Count from records | ____ |
| B1 | Reusable packaging components, per unit (for example an insulated box or panel set that comes back) | currency/reusable unit | Quote or purchase price; leave blank if nothing is reused | ____ |
| B2 | Effective uses per reusable unit, before it is retired, damaged or lost | uses/reusable unit | Usage and return records; not applicable if no reusable parts | ____ |
| B3 | Single-use materials per shipment: any outer carton that is not reused, inserts, liners, tape, labels | currency/shipment | Sum of per-shipment parts | ____ |
| B4 | Packaging materials per shipment | currency/shipment | B1 ÷ B2 + B3 | ____ |
| C1 | Refrigerant units per shipment | refrigerant units/shipment | From the packing instruction | ____ |
| C2 | Cost per refrigerant unit, including conditioning energy and storage | currency/refrigerant unit | Quote plus internal estimate | ____ |
| C3 | Refrigerant cost per shipment | currency/shipment | C1 × C2 | ____ |
| D1 | Packout time per shipment (minutes) | minutes/shipment | Time study | ____ |
| D2 | Labor rate per minute, including overhead | currency/minute | Finance figure | ____ |
| D3 | Labor per shipment | currency/shipment | D1 × D2 | ____ |
| E1 | Logger or indicator cost per shipment | currency/shipment | Unit price, divided by reuse cycles if reusable | ____ |
| E2 | Data handling cost per shipment | currency/shipment | Time to read and file × labor rate, plus any service fee | ____ |
| E3 | Monitoring per shipment | currency/shipment | E1 + E2 | ____ |
| F1 | Return transport cost per shipment returned | currency/returned unit | Carrier quote | ____ |
| F2 | Cleaning, inspection and repacking per returned unit | currency/returned unit | Time study × labor rate, plus consumables | ____ |
| F3 | Return rate (share of shipped units returned) | fraction (0–1) | Returned ÷ shipped | ____ |
| F4 | Return logistics per shipment | currency/shipment | F3 × (F1 + F2) | ____ |
| G1 | Number of failures or excursions in period | failures/period | From complaints and deviation records | ____ |
| G2 | Average cost per failure, including product, reshipment and investigation | currency/failure | Internal estimate, labeled as such | ____ |
| G3 | Losses per shipment | currency/shipment | (G1 × G2) ÷ N | ____ |
| H | Cost per shipment (excluding freight) | currency/shipment | B4 + C3 + D3 + E3 + F4 + G3 | ____ |
Only parts with evidence of reuse go in B1; if the outer carton is thrown away after each trip, it belongs in B3 even when the insulated box inside is reused. Count a reusable unit that is lost in the return loop once: either let the effective uses in B2 reflect losses, or add replacements as a separate cost, not both. If nothing is reused, B4 is simply B3; leave the reuse fields not applicable. With reused parts, B2 must be positive and based on effective-use records. If N is zero, do not calculate G3 or a per-shipment total: report “no shipments in period”. G1 and N must cover the same period.
Outbound freight is kept out of line H because it depends on the carrier, service, zone and the size of each shipper. Add it with the lines in carrier freight and surcharges below, so that the comparison shows packaging cost and shipping cost separately and together.
Illustrative example
The figures below are hypothetical and exist only to show how the formulas connect. They are not prices, benchmarks or findings. Amounts are in an assumed accounting unit per shipment.
Line B4, assumed: a reusable shipper costing 100 that lasts 10 effective uses (10 per trip), plus 2 of single-use materials per shipment, yields B4 = 12 assumed accounting units/shipment. Dividing the 2 of single-use materials by 10 as well would understate the cost.
Option X has materials per shipment of 4, refrigerant of 2, labor of 3, monitoring of 1, return logistics of 0 and losses of 1, giving a packout total H of 11 assumed accounting units/shipment. Option Y has materials of 2, refrigerant of 2, labor of 5, monitoring of 1, return logistics of 2 and losses of 2, giving H = 14 assumed accounting units/shipment. In this scenario, Option Y looks cheaper on materials and dearer overall, because labor, return handling and losses outweigh the material saving.
The example shows only the pattern. With your own data the ranking can reverse.
Carrier freight and surcharges: lines to add
“How much does cold shipping cost?” has no single answer, because the total is the packout cost above plus the freight a carrier charges for that particular box. The freight part is where options often reverse: a larger shipper with more refrigerant can lower losses but raise billable weight, and a faster service shortens the duration the box must cover but usually costs more to move. The lines below add freight to the same worksheet. All rate cells stay blank: take each figure from your carrier contract, the carrier’s current published guide or its rate calculator, and write down the date and service you used.
Use the carrier’s official documentation for each charge. UPS’s U.S. rate hub links its current service guides and separate demand, fuel, and delivery-area surcharge information. FedEx’s dry-ice shipping instructions identify a dry-ice surcharge and explain that dangerous-goods charges are treated differently. Verify applicability for the service and shipment: do not add mutually exclusive charges or copy a rate from another year.
Table: scroll horizontally if needed to see every column.
| Line | Item | Unit | Input or formula | Your value |
|---|---|---|---|---|
| J1 | Carrier, service and rate source, with date | source, service, date | For example contract, published guide or calculator | ____ |
| J2 | Packed shipper dimensions and actual weight | carrier length and mass units | Measure a fully packed box, refrigerant included | ____ |
| J3 | Dimensional weight | carrier mass unit | Length × width × height ÷ the divisor in the carrier’s current guide | ____ |
| J4 | Billable weight | carrier mass unit | Apply carrier rules to actual weight and J3, including rounding and any minimum billable weight | ____ |
| J5 | Base transportation charge per shipment | currency/shipment | Carrier rate for the service, zone and J4 | ____ |
| J6 | Dry ice charges for the shipment, if applicable | currency/shipment | Sum the applicable carrier charge for each package; otherwise zero | ____ |
| J7 | Delivery-location surcharges (for example residential or delivery area) | currency/shipment | Share of shipments affected × charge | ____ |
| J8 | Handling and size surcharges (for example additional handling or large package) | currency/shipment | Share of shipments affected × charge | ____ |
| J9 | Peak or demand surcharges | currency/shipment | Share of shipments in surcharge periods × charge | ____ |
| J10 | Other service options you buy (for example Saturday delivery or declared value) | currency/shipment | Share of shipments × charge | ____ |
| J11 | Fuel surcharge | currency/shipment | Carrier’s current percentage × the charges it applies to, as the carrier’s terms state | ____ |
| K | Freight per shipment | currency/shipment | J5 + J6 + J7 + J8 + J9 + J10 + J11 | ____ |
| T | Total cost per shipment | currency/shipment | H + K | ____ |
Three conditions change which freight lines matter.
- Overnight versus ground service: a faster service shortens the qualified duration the shipper must cover, which can mean a smaller box and less refrigerant, but the base charge per shipment is usually different. Price both services against two shipper options, each qualified for its own duration, before choosing. The qualification evidence comes first; see qualification report review.
- Dry ice: a dry ice shipment adds the carrier’s dry ice charge (line J6) and documentation and marking duties. Check the current IATA Dangerous Goods Regulations and the carrier’s own instructions, and add the labor for marking and records to line D1.
- Box size: if the shipper is large and light, dimensional weight may set the billable weight. A smaller or thinner-walled shipper that still meets the same protection target can change line J4 more than it changes lines B1 and B3.
Use carrier rate calculators to fill line J5 for a typical box per lane, not to compare packaging options on their own: a calculator answer leaves out packout labor, refrigerant, losses and returns.
Input provenance and sensitivity record
Record the following fields for each input line. “Low” and “high” are your documented alternatives, not market benchmarks; hold other inputs fixed when testing one change.
Table: scroll horizontally if needed to see every column.
| Input line | Source document or estimate | Source date | Base value and unit | Low / high assumption |
|---|---|---|---|---|
| ____ | ____ | ____ | ____ | ____ / ____ |
Table: scroll horizontally if needed to see every column.
| Scenario | Changed input / source / date | H (currency/shipment) | K (currency/shipment) | T = H + K (currency/shipment) |
|---|---|---|---|---|
| Base | ____ | ____ | ____ | ____ |
| Low | ____ | ____ | ____ | ____ |
| High | ____ | ____ | ____ | ____ |
Conditional analysis: how the answer shifts
Which component dominates depends on conditions. Use these as prompts for your own data.
- Reusable shippers: materials per shipment fall as reuse cycles rise, but return logistics, cleaning and loss of units rise. The break-even depends on return rate, so measure it before you trust any cycle count. The guide on reusable shipper operations covers the operating steps behind lines F1 to F4.
- Single-use shippers: return logistics drop to zero. Disposal fees and storage space for bulky empty boxes may belong in materials.
- High packout labor: if packers spend longer on complex assembly, labor can outweigh material savings. Time your own station.
- Long or hot lanes: extra refrigerant, a larger shipper or active systems raise cost, and a loss on a high-value shipment can exceed all other lines. Compare options with the guide on insulated shipper selection.
- Automation: test whether equipment changes D3, and account separately for capital, maintenance and downtime. Put its cost in a separate line, and use the equipment RFQ checklist to make quotes comparable.
- Regulatory add-ons: air shipments and dry ice carry documentation and handling rules, such as those in IATA’s Temperature Control Regulations and Dangerous Goods Regulations. Check current versions and add the real costs you incur.
Contract and data points to pin down
- Quote validity period and what triggers a price change.
- Minimum order quantities and storage responsibility.
- Whether quoted unit prices include inserts and printed labels.
- Who pays for retesting if the supplier changes materials.
- How returns are counted and what happens to lost units.
- What each party records, so G1 and F3 have a reliable source.
Worksheet checklist
- Lane set, season, protection target and period are the same for all options.
- Evidence that each option meets the target is on file.
- Every input has a source and date; estimates and low/high assumptions are marked.
- All amounts use the same currency and period; per-shipment amounts are separate from period totals.
- N is positive; reuse denominators are positive or not applicable.
- Reusable-unit loss, replacements and excursion costs are not counted twice.
- Packout time comes from a time study at your own station.
- Monitoring cost includes data handling as well as the device.
- Return rate for reusable shippers comes from records.
- Loss and excursion cost uses your deviation history.
- Freight lines J1 to K are filled from current carrier documents, with source, service and date, for every option.
- Results are reviewed by operations, finance and quality.
- Sensitivity is checked: change the biggest line by a plausible range and see if the ranking holds.
What this worksheet does not settle
The worksheet shows how costs add up. It cannot tell you what your costs are or rank packaging types. It leaves out capital depreciation, tax, brand and customer effects, and sustainability accounting, unless you add lines for them. A loss figure is only as good as your records, and rare events are hard to estimate from a short period. Standards and regulations are named for context only: check the current versions, and ask finance and quality teams to review the inputs before you use the result in a purchase decision.