The merchant’s decision desk: 20 everyday store calculations
A supplier invoice, a second shipping label, a late payout. Pick the decision on your desk and open it to compare eight worked examples. Use the line of arithmetic to repeat it with your figures.
How many working days will a packing machine take to pay back?
Try the 48-day example. Replace the purchase price and daily costs with a supplier quote and your own estimate.
Payback · 48 working days
Use labour costs you can actually avoid. This simple payback estimate excludes interest, tax and resale value.Try the Ecommerce Profit & Pricing Workbook
Open the free workbook preview
Would a stronger box pay off?
Count actual replacements over the next 100 parcels.
Worked example · 100 × 0.3 ÷ 15 → 2 ↑
| Extra per box | Cost of one replacement | Breakages to prevent in 100 parcels |
|---|---|---|
| $0.3 | $15 | 2 |
| $0.35 | $20 | 2 |
| $0.4 | $25 | 2 |
| $0.45 | $30 | 2 |
| $0.5 | $15 | 4 |
| $0.55 | $20 | 3 |
| $0.6 | $25 | 3 |
| $0.65 | $30 | 3 |
What does each sellable item really cost?
Divide the invoice by what passed inspection.
Worked example · 300 ÷ 60 = 5
| Supplier invoice for the batch | Units fit for sale after inspection | Purchase cost per sellable unit |
|---|---|---|
| $300 | 60 | $5 |
| $432 | 72 | $6 |
| $588 | 84 | $7 |
| $768 | 96 | $8 |
| $972 | 108 | $9 |
| $1,200 | 120 | $10 |
| $1,452 | 132 | $11 |
| $1,728 | 144 | $12 |
How long until the shelf is empty?
Take out reserved stock before running the numbers.
Worked example · 72 ÷ 8 = 9
| Saleable units on the shelf | Units sold each day | Days of stock at this pace |
|---|---|---|
| 72 | 8 | 9 |
| 100 | 10 | 10 |
| 132 | 12 | 11 |
| 168 | 14 | 12 |
| 208 | 16 | 13 |
| 252 | 18 | 14 |
| 300 | 20 | 15 |
| 352 | 22 | 16 |
How many pieces repay a setup fee?
Use the contribution per piece after variable costs.
Worked example · 72 ÷ 4 = 18
| One-time setup charge | Contribution per piece before setup | Pieces needed to cover setup |
|---|---|---|
| $72 | $4 | 18 |
| $105 | $5 | 21 |
| $144 | $6 | 24 |
| $189 | $7 | 27 |
| $240 | $8 | 30 |
| $297 | $9 | 33 |
| $360 | $10 | 36 |
| $429 | $11 | 39 |
A retailer wants a case. What is left?
Use the wholesale price on the purchase order.
Worked example · (16 − 9) × 12 = 84
| Wholesale price per unit | Variable cost per unit | Contribution per case of 12 |
|---|---|---|
| $16 | $9 | $84 |
| $18 | $10 | $96 |
| $20 | $11 | $108 |
| $22 | $12 | $120 |
| $24 | $13 | $132 |
| $26 | $14 | $144 |
| $28 | $15 | $156 |
| $30 | $16 | $168 |
What do split shipments cost this week?
Count the extra labels on your carrier invoice.
Worked example · 7 × 4 = 28
| Orders needing a second parcel | Extra delivery charge per parcel | Extra delivery charges this week |
|---|---|---|
| 7 | $4 | $28 |
| 10 | $5 | $50 |
| 13 | $6 | $78 |
| 16 | $7 | $112 |
| 19 | $8 | $152 |
| 22 | $9 | $198 |
| 25 | $10 | $250 |
| 28 | $11 | $308 |
What does one picking mistake really cost?
Check both labels when a returned item is resellable.
Worked example · 4 + 6 = 10
| Return label paid by the store | New outbound label and handling | Correction cost if item is recovered |
|---|---|---|
| $4 | $6 | $10 |
| $5 | $8 | $13 |
| $6 | $10 | $16 |
| $7 | $12 | $19 |
| $8 | $14 | $22 |
| $9 | $16 | $25 |
| $10 | $18 | $28 |
| $11 | $20 | $31 |
How much should a size exchange reserve cover?
Use the actual exchange rate for this size range.
Worked example · 5 ÷ 100 × 10 = 0.5
| Exchanges per 100 orders | Extra cost of each exchange | Average reserve per original order |
|---|---|---|
| 5 | $10 | $0.5 |
| 6 | $12 | $0.72 |
| 7 | $14 | $0.98 |
| 8 | $16 | $1.28 |
| 9 | $18 | $1.62 |
| 10 | $20 | $2 |
| 11 | $22 | $2.42 |
| 12 | $24 | $2.88 |
Marketplace or direct: what fee would you pay?
Compare equal orders before adding channel-specific costs.
Worked example · 50 × (12% − 3%) = 4.5
| Order value | Marketplace fee versus direct fee | Fee difference on this order |
|---|---|---|
| $50 | 12% / 3% | $4.5 |
| $60 | 13% / 3% | $6 |
| $70 | 14% / 3% | $7.7 |
| $80 | 15% / 3% | $9.6 |
| $90 | 16% / 3% | $11.7 |
| $100 | 12% / 3% | $9 |
| $110 | 13% / 3% | $11 |
| $120 | 14% / 3% | $13.2 |
Does commission include delivery?
Read the commission base in your own agreement.
Worked example · 5 × 8% = 0.4
| Delivery charge excluded by contract | Affiliate commission rate | Overpayment if delivery is included |
|---|---|---|
| $5 | 8% | $0.4 |
| $7 | 10% | $0.7 |
| $9 | 12% | $1.08 |
| $11 | 14% | $1.54 |
| $13 | 16% | $2.08 |
| $15 | 18% | $2.7 |
| $17 | 20% | $3.4 |
| $19 | 22% | $4.18 |
Can gift wrapping fund its own labour?
Time one wrapped order from ribbon to label.
Worked example · 2 ÷ 12 × 60 = 10
| Wrap fee after materials | Labour cost per hour | Minutes of labour covered |
|---|---|---|
| $2 | $12 | 10 |
| $3 | $18 | 10 |
| $4 | $24 | 10 |
| $5 | $30 | 10 |
| $6 | $36 | 10 |
| $7 | $42 | 10 |
| $8 | $48 | 10 |
| $9 | $54 | 10 |
How many label rolls do you need?
Round up so the last orders have labels too.
Worked example · 335 ÷ 100 → 4 ↑
| Labels still needed after counting stock | Labels per unopened roll | Whole rolls to buy |
|---|---|---|
| 335 | 100 | 4 |
| 635 | 150 | 5 |
| 1,035 | 200 | 6 |
| 1,535 | 250 | 7 |
| 735 | 100 | 8 |
| 1,235 | 150 | 9 |
| 1,835 | 200 | 10 |
| 2,535 | 250 | 11 |
At what stock level should you reorder?
Compare this point with stock on hand plus stock on order, minus backorders.
Worked example · 8 × 4 + 10 = 42
| Daily unit demand × lead days | Safety stock in units | Reorder point in units |
|---|---|---|
| 8 × 4 | 10 | 42 |
| 10 × 5 | 13 | 63 |
| 12 × 6 | 16 | 88 |
| 14 × 7 | 19 | 117 |
| 16 × 4 | 22 | 86 |
| 18 × 5 | 25 | 115 |
| 20 × 6 | 28 | 148 |
| 22 × 7 | 31 | 185 |
Can an insert pay for its print run?
Count extra purchases against a comparable group without the insert.
Worked example · 120 ÷ 6 = 20
| Total printing cost | Contribution per extra repeat order | Additional repeat orders to break even |
|---|---|---|
| $120 | $6 | 20 |
| $168 | $7 | 24 |
| $224 | $8 | 28 |
| $288 | $9 | 32 |
| $360 | $10 | 36 |
| $440 | $11 | 40 |
| $528 | $12 | 44 |
| $624 | $13 | 48 |
How many subscribers stay this month?
Track new signups separately from the starting group.
Worked example · 100 × (100% − 6%) = 94
| Subscribers at start of month | Share of starting group that cancels | Starting subscribers retained |
|---|---|---|
| 100 | 6% | 94 |
| 200 | 7% | 186 |
| 300 | 8% | 276 |
| 400 | 9% | 364 |
| 500 | 10% | 450 |
| 600 | 11% | 534 |
| 700 | 12% | 616 |
| 800 | 13% | 696 |
What did the slow shelf cost this month?
Use the bins this item actually occupied.
Worked example · 6 × 8 = 48
| Bins kept all month | Monthly cost per bin | Storage cost for this item |
|---|---|---|
| 6 | $8 | $48 |
| 7 | $10 | $70 |
| 8 | $12 | $96 |
| 9 | $14 | $126 |
| 10 | $16 | $160 |
| 11 | $18 | $198 |
| 12 | $20 | $240 |
| 13 | $22 | $286 |
What does a product shoot add per sale?
Recalculate with actual sales after the launch.
Worked example · 240 ÷ 80 = 3
| One-off shoot cost | Units expected to sell | Shoot cost per expected unit |
|---|---|---|
| $240 | 80 | $3 |
| $400 | 100 | $4 |
| $600 | 120 | $5 |
| $840 | 140 | $6 |
| $1,120 | 160 | $7 |
| $1,440 | 180 | $8 |
| $1,800 | 200 | $9 |
| $2,200 | 220 | $10 |
Should you pay for express restocking?
Exclude sales that would simply wait for the normal shipment.
Worked example · 72 ÷ 7 → 11 ↑
| Extra freight for express restocking | Contribution per sale kept | Lost sales you must prevent |
|---|---|---|
| $72 | $7 | 11 |
| $90 | $8 | 12 |
| $110 | $9 | 13 |
| $132 | $10 | 14 |
| $156 | $11 | 15 |
| $182 | $12 | 16 |
| $210 | $13 | 17 |
| $240 | $14 | 18 |
How many sample kits can the budget fund?
Include packaging and outbound postage before dividing.
Worked example · 101 ÷ 4 → 25 ↓
| Available sample budget | All-in variable cost per kit | Complete kits within the budget |
|---|---|---|
| $101 | $4 | 25 |
| $136 | $5 | 27 |
| $175 | $6 | 29 |
| $218 | $7 | 31 |
| $265 | $8 | 33 |
| $316 | $9 | 35 |
| $371 | $10 | 37 |
| $430 | $11 | 39 |
How much cash is still waiting for payout?
Match the bank transfer to its settlement batch.
Worked example · 1,200 − 825 = 375
| Net receipts due for this batch | Already paid into the bank | Balance outstanding for the batch |
|---|---|---|
| $1,200 | $825 | $375 |
| $1,450 | $950 | $500 |
| $1,700 | $1,075 | $625 |
| $1,950 | $1,200 | $750 |
| $2,200 | $1,325 | $875 |
| $2,450 | $1,450 | $1,000 |
| $2,700 | $1,575 | $1,125 |
| $2,950 | $1,700 | $1,250 |
Hypothetical inputs. Only the listed costs are included.