Overview
A skill that automatically calculates per-product margin, end ROAS (break-even ROAS), and break-even ad spend for e-commerce sellers one-line natural language inputwith. It is self-implemented based on standard e-commerce margin·ROAS accounting formulas (deducting selling price, fees, cost, shipping, and VAT), and through AI chatbot integration you get answers immediately without uploading Excel.
One-line responsibility: Input product cost·selling price·fees → automatically calculate margin·end ROAS·break-even ad spend.
Trigger keywords
margin, margin rate, end ROAS, break-even ROAS, minimum ROAS, break-even, negative margin, fee reflected, VAT reflected, ad spend limit, break-even ad spend, margin calculation, margin calculator, ad efficiency, ROAS target
Input·Output
Input slots
| Item | Required | Example |
|---|---|---|
| Selling price | Required | 19,800원 |
| Cost | Required | 6,000원 |
| Shipping fee | Required | 3,000 KRW (seller-borne or 0 KRW) |
| Channel | Required | Smart Store / Coupang / Cafe24 / I'mweb |
| Fee rate | Automatic | Automatically applied per channel (manual input possible) |
| VAT | Automatic | 10% (applied differently for small businesses / tax-exempt businesses) |
| Coupons·Discounts | Optional | 5% / 10% / 1+1 |
| Payment fee | Optional | Toss·KakaoPay 0.5-1.5% |
Output format
{
"product": "무선이어폰 X200",
"input": {
"selling_price": 19800,
"cost": 6000,
"shipping": 3000,
"channel": "쿠팡",
"fee_rate": 0.107,
"vat_rate": 0.10,
"coupon_discount": 0
},
"breakdown": {
"vat_excluded_price": 18000,
"platform_fee": 1926,
"net_revenue": 16074,
"total_cost": 9000,
"gross_margin": 7074,
"gross_margin_rate": "35.7%"
},
"roas": {
"max_ad_budget": 7074,
"end_roas": "280%",
"end_roas_pct": 2.8,
"explanation": "광고비 7,074원으로 19,800원 매출 = 280% 본전 ROAS. 이 이상 ROAS 나와야 적자 안 남"
},
"recommendations": {
"target_roas_min": "300%",
"target_roas_recommended": "400%",
"coupon_strategy": "쿠팡 자동 쿠폰 ON (본인 부담 0원, 쿠팡 100% 부담)",
"warning": "쿠팡 화면 ROAS는 부가세 빠진 금액 — 실제 ROAS는 10% 더 낮음"
}
}
Per-channel fee guide (automatically reflected in v2.4.0)
| Channel | Fee rate (of selling price) | Notes |
|---|---|---|
| Smart Store (Naver) | 5.94% (Naver Pay + deposit fee) | Additional per payment method |
| Coupang General | 10.6% (8-13% by category) | Rocket Delivery = difference in seller cost |
| Coupang Rocket Delivery | 5-10% + inbound/outbound fee + storage fee | Based on purchase price |
| Cafe24 (D2C) | 2-3% (Cafe24 payment fee) | Own mall domain cost separate |
| I'mweb | 0-2.5% | Differs by payment method |
| 11st | 8-13% | By category |
| Gmarket·Auction | 8-13% | By category |
| Wadiz (funding) | 8.5% + payment fee | Upon successful funding |
End ROAS (break-even ROAS) formula
End ROAS is the minimum advertising return rate that does not result in a loss. This skill is the SSOT for the End ROAS formula, and the full formula, step-by-step calculation, Coupang adjustment, and per-channel fee rates are references/end-roas.mdorganized in .
엔드 ROAS = (판매가 ÷ 마진) × 100 (부가세 포함 판매가 기준)
마진 = 부가세 빠진 판매가 × (1 - 수수료율) - 원가 - 배송비 - 쿠폰
Example (Coupang wireless earbuds 19,800 KRW / cost 6,000 / shipping 3,000 / fee 10.7%): margin 7,074 KRW → End ROAS ≈ 280%. For the step-by-step solution, see references/end-roas.md .
Workflow
[Step 1] 자연어 한 줄 입력 또는 JSON 입력 슬롯 채우기
↓ 채널 자동 인식 (스마트스토어/쿠팡/카페24/아임웹/11번가/G마켓/와디즈)
[Step 2] 부가세·플랫폼 수수료·결제 수수료·쿠폰 자동 차감
↓ 실제 입금 매출 산출
[Step 3] 마진 = 실제 입금 매출 - 원가 - 배송비
↓
[Step 4] 엔드 ROAS = (판매가 ÷ 마진) × 100 산출
↓ 권장 목표 ROAS = 엔드 ROAS × 1.3~1.5
[Step 5] 권장 ROAS·쿠폰 전략·쿠팡 부가세 보정 경고 출력
↓ (선택) commerce-marketplace-coupang-ads 로 체이닝
Usage example
"무선이어폰 19,800원, 원가 6,000원, 배송 3,000원, 쿠팡으로 팔 때 엔드 ROAS 알려줘"
→ 엔드 ROAS: 280%, 마진: 7,074원, 권장 목표 ROAS: 400%
"비건 스킨케어 12,900원, 원가 4,000원, 배송 0원, 스마트스토어, 5% 쿠폰 적용"
→ 엔드 ROAS 계산 + 쿠폰 비용 반영
"카페24 자사몰 + 토스페이 결제 수수료 1%까지 정확히 마진 알려줘"
→ 결제 수수료 추가 반영 후 정확한 마진
Chaining
[입력 단계] commerce-product-naming (상품명 + 가격 후보)
↓
commerce-margin-calculator (본 스킬, 마진·엔드 ROAS 산출)
↓ 광고 운영 단계에서
commerce-marketplace-coupang-ads (목표 ROAS·캠페인 분류·자동규칙)
↓ 매출 전략 통합 시
commerce-integrated-strategy (1장 전략 + 자동화 통합)
Pair separation (responsibility boundary)
| Pair skill | Difference |
|---|---|
moai-seller:commerce-marketplace-coupang-ads |
Coupang ad campaign classification and decision-making (this skill: margin and ROAS calculation only) |
commerce-integrated-strategy |
Channel mix, pricing, and promotion integrated strategy (this skill: single-product margin) |
commerce-product-naming |
Product name verification (this skill: price verification) |
Advantages over conventional Excel margin calculators
| Item | Traditional Excel calculator | commerce-margin-calculator (this skill) |
|---|---|---|
| Input method | Excel upload | One-line natural language or JSON |
| AI integration | ❌ | ✅ Instant answers via AI chatbot |
| Payment fees | Not reflected | ✅ Toss, KakaoPay, etc. |
| Automatic channel recognition | Manual input | Automatic natural language recognition |
| Ad operations integration | Separate | moai-seller:commerce-marketplace-coupang-adsand automatic chaining |
Note: Because it follows the standard e-commerce margin accounting formula (deducting selling price, fees, cost, shipping, and VAT), the output matches that of a general margin calculator for the same input values.