Accurate delivery cost calculation starts with precise tracking. Follow this guide to ensure every repack, consolidation, and weight change is logged correctly in your OrientDig spreadsheet.
Why Detailed Tracking is Essential
Every modification to your original shipment's packaging or weight directly impacts volumetric calculations and final freight costs. By meticulously recording these changes, you gain complete visibility into your logistics spend and prevent billing discrepancies.
Step-by-Step Recording Guide
1. Logging a Repack Request
When an item is moved into a new, single box:
- Column A (Request ID):RPK-2023-001.
- Column B (Date):
- Column C (Type):Repack" from the dropdown.
- Column D (Original Ref):
- Column E-F (New Dimensions):Length, Width, Height (cm).
- Column G (New Weight):
- Column H (Notes):
2. Recording a Consolidation
When multiple items are combined into one package:
- Column C (Type):Consolidation".
- Column D (Original Ref):PKG-100, PKG-101).
- Column E-F (New Dimensions):new consolidated
- Column G (New Weight):combined weight
- Column H (Notes):
- Column G (New Weight):combined weight
3. Updating a Weight Change
When only the weight is corrected (e.g., after re-weighing):
- Column C (Type):Weight Change".
- Column D (Original Ref):
- Column E-F (New Dimensions):
- Column G (New Weight):corrected, verified weight.
- Column H (Notes):
- Column E-F (New Dimensions):
Best Practices for Accuracy
- Immediate Entry:
- Mandatory Fields:Type, Original Ref, and New Weight
- Note Details:
- Regular Review:
- Mandatory Fields:Type, Original Ref, and New Weight
Streamline Your Logistics Costs
Treating your OrientDig spreadsheet as the single source of truth for packaging changes transforms cost calculation from an estimate into an exact science. Consistent recording directly translates to transparent billing, optimized shipping decisions, and ultimately, greater control over your supply chain expenses.
Start tracking meticulously today for more accurate costs tomorrow.