Deep-dive guide
Online Store Profit Squeeze Simulator
Executive industry analysis
An online store looks profitable on the sales dashboard long before it is. Revenue is the loudest number, but the money a store keeps depends on a chain of smaller numbers: what each order really costs to fulfil, how many orders come back, what each new customer costs to win and how much of every sale is taken by processors and marketplaces. A store that earns a comfortable gross margin can still lose money every month once those layers are stacked together, which is why the simulator walks through them in order instead of showing one headline figure.
Advertising is usually the largest controllable cost and the one most likely to hide a problem. Return on ad spend flatters a store that sells low-margin products, because a four-to-one return on revenue can still be a loss after product cost, shipping and returns. The useful question is not how much revenue the ads generate but what one order costs to acquire compared with the margin that order leaves behind. When acquisition cost climbs past roughly a third of the unit margin, growth stops paying for itself and every extra order has to be funded from somewhere else.
Returns are the most underestimated line in the model. A refund removes the revenue, but the costs of that order rarely come back: the outbound label is gone, the payment processor keeps its fee, the return needs a label and warehouse time, some items cannot be resold and the customer usually opens a support ticket. Each of those is small on its own, yet together they can double the true cost of a returned order. Apparel and electronics stores with return rates above fifteen percent often discover that their entire profit is being spent on handling goods that never stay sold.
The scenario comparison shows why small structural changes beat bigger budgets. Spending less on ads while raising order value with bundles gives up some volume but improves almost every ratio at once: acquisition cost per order, shipping as a share of revenue and the number of support contacts per unit of profit. The twenty-four-month view adds the part a single month cannot show, which is that a leaner plan pays back its switching cost and then compounds. The breaking point tool turns all of this into one actionable number: how far an input can move before the store stops making money.
Formula and methodology blueprint
The model computes one month of operations from eight inputs. Every cost is calculated from the same order flow so that changing one input moves the rest consistently. The constants below are typical industry assumptions and are shown so you can judge them.
- Gross and net revenue
- gross = orders × AOV; net revenue = gross × (1 − return rate)
- Refunded orders remove their revenue but not all of their costs.
- Product cost
- COGS = net revenue × COGS %
- Returned goods go back to stock, so cost is charged on kept sales only.
- Fees
- fees = gross × fee %
- Processors usually keep their fee on refunded orders, which is why part of it appears as a hidden cost.
- Return handling
- orders × return rate × (1.6 × shipping + 2.5)
- A return label costs about 1.6 times an outbound label, plus 2.5 for warehouse handling.
- Unsellable returns
- orders × return rate × 15% × (AOV × COGS %)
- Fifteen percent of returned items are damaged or opened and written off at cost.
- Support
- orders × (0.60 + 4 × return rate)
- A base cost per order plus extra tickets for every return case.
- Net outcome
- net = net revenue − COGS − shipping − fees − return costs − support − ads − fixed
- Break-even is the point where this reaches zero.
Cascading elasticity
Cascading elasticity: orders move revenue, shipping, fees, support and returns together, while ad spend and fixed costs do not move with orders. That asymmetry is why a ten percent fall in orders usually cuts profit by far more than ten percent, and why the stress test often points at orders or return rate first.
Three real-world case studies
Bootstrapped starter
Bootstrapped starter
A founder ships 260 orders a month from a spare room. Margins look thin on paper, but low ad spend and almost no fixed costs keep the store comfortably positive while it learns what converts.
Scaling mid-market
Scaling mid-market brand
At 5,200 orders and a large ad budget the store makes real profit, yet every input matters more: a few points on returns or product cost moves thousands in monthly profit, so the breaking point sits much closer.
Black-swan crisis
Black-swan crisis
A supplier shock raises product cost while a bad batch triggers a wave of returns. Ad spend is already committed, so the same traffic now produces losses. Load it to see where recovery starts.
Industry benchmark matrix
| Metric | Danger zone | Industry average | Top 10% elite |
|---|---|---|---|
| Return rate | Above 15% | 8–12% | Below 6% |
| Ad cost per order vs unit margin | Above 60% | 35–50% | Below 30% |
| Contribution margin before ads | Below 20% | 25–35% | Above 40% |
| Shipping as % of revenue | Above 12% | 6–9% | Below 5% |
| Net margin after all costs | Below 0% | 5–10% | Above 15% |
Variables and levers
Orders per month
Paid orders before refunds.
Lever: Orders are the engine: fix conversion first with clearer product pages, faster checkout and abandoned-cart emails before buying more traffic.
Average order value
What the typical customer pays per order, before returns.
Lever: Raise the basket: bundles, free-shipping thresholds just above your current average, and a post-purchase add-on offer.
Product cost (COGS)
Share of revenue spent on the goods themselves.
Lever: Renegotiate supplier terms or move volume to a second supplier; a three-point cut in product cost often beats a ten percent sales increase.
Ad spend per month
All paid acquisition: search, social, marketplace ads.
Lever: Cap spend per channel at the level where the cost of one order stays below roughly a third of your unit margin, and pause the rest.
Return rate
Share of orders refunded or returned.
Lever: Return rate is the hidden killer: improve size guides, photos and descriptions, and ship only what is in stock and checked.
Shipping cost per order
What you pay the carrier, net of what customers pay you.
Lever: Re-quote carriers, use regional rates, right-size packaging, and set a free-shipping threshold so shipping scales with basket value.
Payment and marketplace fees
Percentage taken from every sale.
Lever: Review processor and marketplace pricing at your current volume; negotiated rates or a cheaper payment mix can be worth a full margin point.
Fixed costs per month
Software, staff, rent and anything that does not move with orders.
Lever: Audit subscriptions and contractors quarterly; fixed costs are the one lever that works even when sales are flat.
How to use this simulator
- 1Start with the Realistic preset or enter your own monthly figures.
- 2Watch the five connected nodes to see where the cascade turns amber or red.
- 3Press Find my breaking point to learn how far each input can move before profit hits zero.
- 4Compare Scenario A with the leaner Scenario B on the 24-month timeline.
- 5Copy the share link to send the exact scenario to a partner or accountant.
Mistakes to avoid
- Judging ad performance by return on ad spend alone. A four-to-one return can still lose money once product cost, shipping, returns and fees are paid, so compare ad cost per order with the margin each order leaves.
- Counting a refund as a simple loss of revenue. The shipping label, the payment fee, the return handling and any unsellable stock are still spent, so a returned order costs far more than the refund suggests.
- Growing orders while return rate and shipping cost per order creep up. Volume hides the problem until the breaking point is suddenly close.
- Using last quarter's product cost after a supplier change, a currency move or a price rise. Update the cost percentage before every planning exercise, because it is the input with the most leverage.
Frequently asked questions
What is the breaking point?
It is the value of a single input, with everything else unchanged, at which monthly profit reaches zero. The simulator checks 1,000 steps for every input and highlights the one that crosses closest to where you are today.
Why do returns hurt more than the refund itself?
Because the refund is only the visible part. The outbound shipping, the payment fee, the return label, warehouse handling, unsellable stock and support time are all spent even though the sale is cancelled.
Is return on ad spend a reliable measure?
Not on its own. It measures revenue per unit of advertising spend and ignores what the goods cost. Compare ad cost per order with the margin each order leaves instead.
How accurate are the numbers?
They are a planning model built on stated assumptions, not accounting. Replace the inputs with your own figures and treat the output as a way to see which lever matters most.
What do the Monte Carlo results mean?
The tool reruns your scenario 1,000 times with every input varied randomly by roughly fifteen percent and reports how often monthly profit falls to zero or below, plus the range of likely outcomes.
This is an educational planning model with stated assumptions. It is not financial, tax or legal advice. Replace the inputs with your own figures and verify important decisions with a qualified professional.