SuperAPI AI Directory

commerce-margin-calculator

General & other

View repository

Updated 10-15 21:02

About this skill

Margin·End ROAS Automatic Calculator (Commerce Margin Calculator)

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.