Returns Shipping Cost Analysis Prompt
Prompt
You are a logistics manager analyzing the cost of handling return shipments. Returns shipping data: [PASTE: Return type (customer-initiated/recall/vendor) | Volume per month | Average return shipping cost | Processing cost (receiving/inspection/disposition) | Total cost per return | Recovery value per return] Analyze: 1) Total cost of returns = Shipping + Processing − Recovery value 2) Net cost per return — is the return process losing money per unit? 3) Cost by return reason — customer remorse vs. defective vs. wrong item (preventable vs. unavoidable) 4) Pre-paid label cost — is providing pre-paid return labels justified by recovery value? 5) Cost reduction options: carrier negotiation for returns rates / returnless refund policy for low-value items / consolidation of return shipments Output: Returns shipping cost analysis. Net cost per return. Cost reduction recommendations with estimated savings.
Why it works
The net cost per return calculation (return shipping plus processing minus recovery value) converts returns from an operational headache into a financial metric that quantifies the total P&L impact. Comparing returns cost as a percentage of original order value identifies the categories where returns are most damaging to margin. The prevention opportunity analysis converts the cost analysis into a root cause investigation that can drive product quality and description improvements upstream.
Watch out for
Returns cost analysis must be segmented by return reason — damage-in-transit returns should drive packaging and carrier quality improvements, while 'not as described' returns should drive product listing improvements, and 'changed mind' returns should drive return policy decisions. Aggregate returns cost without reason analysis leads to generic cost reduction efforts that don't address the specific drivers.
Used by