Calculate your GROSS profit margin before any ad spend. Break-Even ROAS updates instantly when you change Selling Price.
💡
This calculator shows your Gross Profit Margin — product economics BEFORE any ad spend. Tab 14 calculates Net Profit Margin (after ads).
Break-Even ROAS tells you the minimum ROAS your ads must achieve to cover product costs.
Change Selling Price to instantly see how it affects your margin and Break-Even ROAS.
Product Comparison
Product Name
Selling Price ৳
Total Cost ৳
Gross Profit / Order ৳
Markup %
Gross Margin %
Break-Even ROAS
Verdict
📐 Max CPS & Min ROAS Calculator
Find the maximum you can spend per sale and minimum ROAS needed — accounting for returns & target margin
💡CPS = Cost Per Sale — maximum ad spend allowed per conversion to still hit your profit target.
Min ROAS — your ads must achieve at least this ROAS or you are losing money.
Change any input → results update instantly.
// PER-ORDER ECONOMICS
Same cost categories as your Daily Input — Product, Operations, Marketing Tools, Telesales, Transport, Returned Loss
🎯 Selling Price ৳
What the customer pays per order
📋 Per-Order Costs (matches Daily Input columns)
💰 Product Cost ৳
Supplier (COGS)
⚙ Operations Cost ৳
Operations
🛠 Marketing Tool Cost ৳
Marketing tools
📞 Telesales Cost ৳
Team call
📦 Product Transport Cost ৳
Courier
↩ Returned Loss ৳
Manual amount per order
📈 Target Net Profit Margin %
Profit margin you want AFTER all costs including ads
📊 eCommerce Net Profit Benchmark
<5%
Danger
5–10%
Average
10–20%
Good
>20%
Excellent
MAX AD SPEND PER SALE (CPS)
৳0
MINIMUM ROAS (Net)
0.00x
Effective Revenue
৳0
After return loss
Returned Loss / Order
−৳0
Revenue lost to returns
Gross Margin (No Ads)
0%
Profit ÷ Price
Markup % (No Ads)
0%
Profit ÷ Product Cost
Target Net Profit
৳0
After ALL costs
POAS
0.00x
Net Profit ÷ Max CPS
eCommerce Benchmark
Loading...
// PROFIT BREAKDOWN PER ORDER PLACED (INCL. RETURNS)
📊 Compare with Your Live Data
Enter data on the left to see comparison with your live dashboard metrics.
☁ Google Sheets Sync
Your team enters data in Bangladesh → you see it live in South Africa
📋 STEP 1 — Create Your Google Sheet
Click below to copy the exact template your team needs. It has all the right columns pre-set.
After clicking: Go to sheets.google.com → New Sheet → paste in Row 1
Then: Select Column A → Format → Number → Date
This enables the calendar date picker for your team.
🔗 STEP 2 — Publish Your Sheet as CSV
In Google Sheets, go to: File → Share → Publish to web
Pick your sheet, then choose Comma-separated values (.csv) → click Publish. ✅ Tick "Automatically republish when changes are made" so new days sync on their own. Copy the link it gives you — it ends in output=csv — and paste it in Step 3.
🔑 STEP 3 — Paste Your Published CSV Link
Paste the published CSV link from Step 2 (ends in output=csv). A plain Sheet URL/ID also works if the sheet is shared as "Anyone with link → Viewer".
No Sheet URL saved — paste yours above
⚡ STEP 4 — Choose How to Sync
💾 Save & Sync — remembers your URL in this browser. Future page loads auto-sync your data. ⚡ Sync Once — loads data this session only. No URL is saved. Refresh → back to demo data.
📨 Share with Your Team
Send your team the Google Sheet link. They enter data daily.
📅 DATE COLUMN — How to enter:
• Column A is formatted as DATE
• Click cell → calendar popup appears
• Pick correct date — today OR any past date
• One row per date only — never duplicate
23 Columns: Date · Sales Ad Spend · Engagement Ad Spend · Reported ROAS · Website Sessions · WhatsApp Leads · Messenger Leads · Paid Ads Orders · Paid Ads Confirmed Order · Web Direct Confirmed Order · WhatsApp Confirmed Order · Messenger Confirmed Order · Abandoned Cart Recovered Order · CRM Confirmed Order · Returned · New Customers · Delivered Revenue · Delivered Product Cost · Operations Cost · Marketing Tool Cost · Telesales Cost · Delivered Courier Cost · Returned Loss ⚠ Column order must match exactly — do not change order ✅ Cancelled = Paid Ads Orders − Paid Ads Confirmed Order (auto in dashboard, NOT in sheet)
🧮 Markup & Gross Calculator
Markup % (on cost) + Gross Margin % (on price) · COD ready · ৳ BDT
TOTAL COST
—
GROSS PROFIT
—
GROSS MARGIN %
—
Profit ÷ Price
MARKUP %
—
Profit ÷ Cost
COSTS & SELLING PRICE
📦 PRODUCT COST
🏷 VAT % ON PRODUCT
🚛 TRANSPORT
➕ OTHER
💰 SELLING PRICE ৳
Markup Targets
10% → 150% · every 5%
Formula: Sell Price = Cost + Cost × Markup% | ⭐ = your target · ◀ = your current price