Small Order Freight Economics Prompt
Prompt
You are an operations manager analyzing the freight economics of small orders. Order data: [PASTE: Order size tier (by value or weight) | Number of orders | Average freight cost per order | Average freight revenue (if charged to customer) | Average order margin | Net profit per order after freight] Analyze: 1) Break-even order size — below what order value do freight costs exceed the margin on the order? 2) Loss-making orders — orders where total cost (COGS + freight + handling) exceeds revenue 3) Minimum order value — what minimum order value would eliminate loss-making orders? 4) Freight surcharge — alternatively, could a small order surcharge cover the freight cost gap? 5) Customer behavior change — if minimums or surcharges are implemented, what % of orders would be affected? Output: Small order freight economics. Break-even order value. Loss-making order count and total annual loss. Minimum order or surcharge recommendation. Customer impact estimate.
Why it works
The break-even minimum order calculation converts the analysis into a specific, actionable policy recommendation rather than a general observation that small orders are unprofitable. Calculating net profit per order after freight across size tiers reveals the exact threshold below which the company loses money on every order, which is often surprising for businesses that haven't done the analysis. Alternative solutions (minimum order quantities, small order surcharges, next-day vs. next-week shipping) provide options rather than just documenting a problem.
Watch out for
Minimum order requirements and small order surcharges affect different customer types differently — small local retailers may need to be accommodated differently than e-commerce customers. Review your customer concentration in the below-minimum tier before setting policy, and consider grandfathering existing customers for a transition period while enforcing minimums for new accounts.
Used by