From a Veteran's Gut Feel to a 3D Loading Plan — Building a Container Loading Simulator
Executive Summary
A known rooftop tent manufacturer and exporter relied on the experience of its logistics staff to decide what — and how much — went into each shipping container. When a load didn't fit, items were pulled, and the shipping request and invoice were rewritten.
A TecAce Forward Deployed Engineer (FDE) saw the process first-hand on the warehouse floor, splitting boxes and helping load containers. The FDE then built a browser-based tool that turns a shipping request (PI) spreadsheet into a 3D loading plan — pallet configuration, loading sequence, and remaining space. It runs entirely on the user's PC, with no installation and no server. The first trial load went largely to plan, and the calculation rules are being fine-tuned with feedback from the floor.
The Challenge
The tents are larger than a standard pallet and ship on dedicated ones; the accessories that go with them are small and number in the thousands. Accessories go in cartons, and anything that doesn't fill a full carton is left as loose units or soft poly mailers. It's Tetris with blocks of every shape and weight, and a loaded container is hard to redo.
Key Pain Points:
The rules lived in people's heads: Check box dimensions → convert quantities to cartons → compare against container volume → adjust for margin. Most of this happened within the staff's own experience, so no one else could see the reasoning.
A plan you could only test by loading: When sales asked whether a quantity would fit, there was no reliable answer until the container was actually loaded. If it didn't fit, items came out and the shipping request and invoice were redone.
Negotiation took longer than loading: At times, sales and logistics spent more time agreeing on a load than actually loading it.
Gaps that crossed the ocean: When quantities changed right before shipping, the change wasn't recorded right away, so the overseas office could only confirm actual quantities after the container arrived.
Carrying boxes alongside the team, the FDE felt how physically demanding the work was — and concluded that sales and logistics needed one shared screen showing the same numbers.
The Solution
The tool was built on one principle: the tool does the math; people make the call.
Phase 1: Start from the paperwork the team already uses
The logistics team drags in the same shipping request (PI) Excel or CSV file they receive every time, and the tool finds the item code and quantity headers — whichever sheet or row they're on. Multiple requests bound for the same container are combined, and dimensions and weights come from the master price list the company already maintains.
Phase 2: Turn a veteran's instincts into calculations
Splitting cartons: For example, 400 units at 36 per carton becomes 11 cartons plus 4 loose units. Leftovers ship loose or get grouped into a mixed box.
Building pallets: Single-item pallets come first; remaining boxes are mixed in, largest and heaviest first, while respecting support ratios. The tool runs several loading sequences and picks the one with the fewest pallets.
Filling the container: Choose 20FT, 40FT, or 40FT HC, and the layout accounts for door height and ceiling clearance. If one container isn't enough, it shows how to split the load across several.
Adding more: An "Additional Load" tab shows which items — and how many — still fit in the remaining space, so a "Can you send a few more?" request gets an immediate answer.
Phase 3: Flag what needs checking in orange
The dimensions in a spreadsheet don't always match the real box. Items with missing dimensions, mixed boxes calculated from assumed values, and cargo that couldn't be loaded are all highlighted in orange. The flag clears only after someone enters a measured value or clicks "Confirmed," so unchecked numbers never slip silently into the plan.
Phase 4: Put field judgment back in
When the result doesn't match on-the-ground judgment, staff switch on "Edit Layout" and move pallets and boxes directly in the 3D view. Every change carries through to the Excel export and the printout shared with sales.
Security note: All calculations run inside the browser on the user's PC. Shipping requests are never sent anywhere, and there's no server or installation involved.
The Results
A tool the team actually uses
The logistics team sits side by side at their PCs to simulate each load. Hit print, and a list shows what goes on each numbered pallet and how many — the team takes that list out to the container and loads from it.
The first trial load went largely to plan. Loose units and poly mailers that don't fit a carton count still need their dimensions entered by hand, so presets for common packaging sizes are next on the improvement list.
A different kind of conversation
Before → After
Debating whether a load will fit → Reviewing a layout
Load, overflow, rewrite the shipping request and invoice → Calculate before loading, including how much more fits
Individual experience → A 3D view, Excel file, and printout that sales and logistics share
Container loading ties directly to freight cost. With this tool, sales and logistics can now talk from the same numbers — the human judgment stays, and the reasoning behind it is visible to everyone.
Next Steps
Mixed-box presets: Save common small and medium packaging sizes for one-click reuse
Connecting to overseas receiving: Link the shipping list to shipment records so the overseas office knows what's coming and can check it against actual receipts
English version: Let the overseas team review loads on the same screen
Moving to production use: Once dimension data is complete, roll out to the sales and logistics teams for everyday use
At this client, prototypes like this one came out of six departments in October alone: finance, materials and logistics, sales and marketing, production operations, customer service, and purchasing and merchandising.
Where are your veteran's instincts locked away? Start the conversation with TecAce today.
Comments