| Product RRP | Per unit % | ||
| Enter Average Order Value (AOV) |
£
|
You can pull this figure from Shopify. If pulling from Shopify, make sure that you filter the AOV report by Sales channel = online store. This ensures that orders processed for exchanges carrying a £0 value don't skew this figure. | |
| Enter average VAT/sales tax per order |
|
This should be simple but could be more complex if you sell to multiple territories. e.g. if you're based in the U.K. and sell 80% of products to the U.K. market at 20% VAT and 20% to the US market at 5% sales tax, your average % here would be (80*0.2) + (20*0.05) = 17%. | |
| Net revenue |
|
| Per unit cost | Per unit % | If you're based in the U.K. and have included VAT above, make sure to exclude VAT from the COD figures as the majority of these should all be reclaimed. | |
| Cost of goods sold (COGS) |
£
|
Enter your average COGS figure of a typical order. | |
| Shipping and receiving (Supplier to warehouse fees, freight, import duties etc) |
£
|
Often equates to 5-10% of the COGS figure. | |
| Transaction (payment) fees |
|
The industry average is between 2-2.5%. If you use buy now pay later providers or PayPal, this may be a little more. | |
| Pick-and-pack fees |
£
|
Your warehouse/3PL will have this figure. | |
| Product packaging costs |
£
|
This is the total cost of any packaging and inserts that goes into an average order. For example, this may include a mailer bag, ziplock bag, and a "thank you for your order" flyer if you're a fashion brand. | |
| Shipping and fulfillment |
£
|
This should be the average shipping cost you pay to get it to your customer. | |
| Warehouse & storage fees |
£
|
This should be calculated by (average monthly storage fees + warehouse monthly subscription fees) / total orders per month. This will be a very small number. | |
| Return Rate (% of orders that get returned) |
|
Calculate this from your Shopify analytics by doing (total order revenue / total value of refunds) over a 6-month time period. | |
| Total COD |
|
The total cost of delivery. I.e. what it costs for you to get the product all the way from manufacturing to the customer. |
| Fuel profit | As % | ||
| Contribution margin (fuel profit) |
|
||
| Net profit target per unit |
£
|
This is how much net profit you normally make or would like to make on every unit sold. This is usually around 10% for mature ecommerce brands, and less than 10% for growing brands. |
| As £/$ | As % | ||
| Blended breakeven ROAS (MER) | |||
| Blended CPA target |
|
This is the overall cost per acquisition target, combining marketing spend from all platforms. | |
| Blended ROAS target (MER) | The target total revenue / total ad spend metric we need to hit to ensure profitability. |
| Money in | Per unit % | |
| Enter average order value |
|
|
| Enter daily revenue target |
£
|
|
| Total orders |
| Average returning customer % | ||
| Returning customer revenue |
|
|
| New customer revenue |
|
|
| New customer orders |
| VAT / sales tax per order |
|
|
| Total COGS (cost of goods) |
|
|
| Shipping and receiving (Supplier to warehouse fees, freight, import duties etc) |
|
|
| Transaction (payment) fees |
|
|
| Pick-and-pack fees |
|
|
| Product packaging costs |
|
|
| Shipping and fulfillment |
|
|
| Warehouse & storage fees |
|
|
| Return rate (% of orders that get returned) |
|
|
| Return Fulfillment Cost (cost to return) |
|
|
| Total return cost per unit |
|
|
| Total variable costs per order |
|
|
| Total variable costs per day |
|
| Payroll (per month) |
£
|
|
| Software (per month) |
£
|
|
| Agency fees (per month) |
£
|
|
| Rent (per month) |
£
|
|
| General & administrative (per month) |
£
|
|
| Total fixed cost per order |
|
|
| Total fixed costs per day |
|
| Total opex per order |
|
|
| Total opex per day |
|