Returns Analysis by Reason Code Prompt

You are an inventory manager analyzing product returns.
Returns data: [PASTE: Return date | SKU | Customer | Qty returned | Reason code |
Condition on return (resalable/damaged/defective/wrong item/expired) | Original sale date | Original sale value]
Analyze:
Return rate % by category and channel — total returns ÷ total units sold
Top return reasons — ranked by frequency and by value
Condition analysis — what % of returns are resalable vs. require action?
Return age — how long after original sale are items being returned? (late returns = more difficult to resell)
Root cause by reason: product quality issue (quality team action) / wrong item shipped (fulfillment issue) / customer changed mind (commercial policy issue) / damaged in transit (carrier/packing issue)
Output: Returns analysis report. Top 3 root causes with specific recommended actions. Total return cost (lost revenue + processing cost + write-down).
Return Disposition Decision Framework