Create intermediate Works with: Any AI

Product Unit Economics Table

Table output Has example

Find which products really make money.

The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.

Build a unit economics table for my products. Product data (price, cost of goods, shipping, packaging, platform fees, payment fees, average discount, return rate, ad cost per order): [PRODUCT_DATA].

For each product calculate and show the formula:
1. Net revenue per unit = price - average discount.
2. Fulfilment cost = shipping + packaging.
3. Fees = platform fee + payment fee.
4. Expected return cost = return rate x loss per return.
5. Contribution margin per unit = net revenue - cost of goods - fulfilment - fees - expected return cost, and as a percent of net revenue.
6. Profit per order after ads = contribution margin - ad cost per order.
7. Break-even ROAS = net revenue / contribution margin before ads.

Output format: a table sorted by profit per order, with products that are negative or under a 10 percent margin marked. Then three products to scale, three to fix (name the lever: price, cost, shipping, or returns), and any product to drop, each with one line of evidence. Then a sensitivity table for the top five: profit per order with a 10 percent price rise and with a 10 percent cost rise.
Flag missing inputs as [ADD DATA], list assumptions, and explain in two sentences the difference between contribution margin and net profit. Analysis only, not accounting or tax advice.

Fill in before use

Optional: type your details and the prompt above updates. Nothing is saved or sent.

Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.

Product | Price | Discount | Net revenue | COGS | Shipping | Fees | Return cost | Contribution | Margin
Linen shirt | 60 | 4 | 56 | 22 | 5 | 3.4 | 2.8 (7% x 40) | 22.8 | 40.7%
Canvas bag | 30 | 1 | 29 | 14 | 4 | 1.8 | 0.6 | 8.6 | 29.7%
Ad cost per order 12 -> profit per order: shirt 10.8; bag -3.4 (negative).
Break-even ROAS for the bag: price 29 / contribution before ads 12.0 = 2.4.
Scale: linen shirt. Fix: canvas bag (raise price or cut shipping cost). Consider dropping: none yet.
Sensitivity: price +10% on the bag adds 2.9 contribution; cost +10% on the shirt removes 2.2.
Assumptions marked; missing inputs flagged [ADD DATA]. Contribution margin is not net profit.

• profit