Dimensional Weight Optimization Prompt

You are a logistics analyst reviewing dimensional weight impact on parcel costs.

Shipment data:
[PASTE: Product/order type | Average box dimensions (L×W×H inches) | Average actual weight | DIM factor (139 for most domestic parcel) | Actual billed weight (higher of actual or DIM) | % of shipments where DIM > actual weight]

Analyze:
1) DIM weight vs. actual weight — what % of shipments are billed at DIM weight rather than actual weight?
2) Excess packaging cost — average excess weight billed due to DIM; cost per shipment and annually
3) Box right-sizing opportunity — for top-volume order types, is there a smaller box that would reduce DIM weight?
4) Void fill reduction — if DIM weight is a problem, the solution is often right-sizing the box, not adding fill
5) Annual savings estimate — if DIM weight shipments reduced by 25%, annual freight savings

Output: DIM weight analysis. Annual cost of over-boxing. Top box sizes to right-size. Estimated annual savings. Implementation steps.