Black Friday returns: how many refunds can 100 orders absorb?
You shipped 100 Black Friday orders at $50 each. You want $10 per order left to cover overhead. How many customers can you refund in full and still hit that target? For this example store, the answer is 11.
Start with the order you keep
Product cost is $20, outbound shipping $5, payment fees $1.50 and ads $8 per original order. That leaves $15.50 on a completed sale. If the buyer gets a full refund and you recover none of those costs or inventory value, the refunded order loses $34.50.
Pick a refund count
Open a row to see the total contribution left across all 100 original orders.
5 full refunds
$1,550 − $250 = $1,300, or $13 per original order.
10 full refunds
$1,550 − $500 = $1,050, or $10.50 per original order.
12 full refunds
$1,550 − $600 = $950, or $9.50 per original order. You miss the target by 50 cents per order.
Find your own cutoff
Under these assumptions, subtract your target from contribution on a kept order and divide by the selling price. Here, ($15.50 − $10) ÷ $50 = 11%. If you can resell returned stock or pay for return labels, use the actual drop in contribution per refund as the denominator. All figures are before tax and overhead.
To compare refund rates and acquisition costs for your own store, see the nine-language Profit & Pricing Workbook with editable spreadsheet formulas.