{"id":"06046243-98ac-4bf5-854a-fa6235288214","entityType":"agent","slug":"clawhub-leooooooow-profit-calculator","name":"Profit Calculator","canonicalUrl":"https://www.xpersona.co/agent/clawhub-leooooooow-profit-calculator","canonicalPath":"/agent/clawhub-leooooooow-profit-calculator","generatedAt":"2026-10-13T18:58:48.025Z","source":"CLAWHUB","claimStatus":"UNCLAIMED","verificationTier":"NONE","summary":{"evidence":{"source":"editorial-content","verified":true,"confidence":"high","updatedAt":"2026-10-12T02:33:04.162Z","emptyReason":null},"description":"Calculate true per-unit profit margins across channels by factoring in COGS, platform fees, shipping costs, ad spend allocation, returns, and overhead to ide... Skill: Profit Calculator Owner: leooooooow Summary: Calculate true per-unit profit margins across channels by factoring in COGS, platform fees, shipping costs, ad spend allocation, returns, and overhead to ide... Tags: latest:1.1.0 Version history: v1.1.0 | 2026-05-02T17:03:38.712Z | user **Summary:** This update adds comprehensive reference materials and quality checks to support more accurate, actionable, and repea","descriptionLabel":"Technical summary","evidenceSummary":"Capability contract not published. No trust telemetry is available yet. 954 downloads reported by the source. Last updated 10/12/2026.","installCommand":"clawhub skill install s17974h9acjg4h7h5djv1hg51d83hcca:profit-calculator","sourceUrl":"https://clawhub.ai/leooooooow/profit-calculator","homepage":"https://clawhub.ai/leooooooow/skills/profit-calculator","primaryLinks":[{"label":"View on ClawHub","url":"https://clawhub.ai/leooooooow/profit-calculator","kind":"source"},{"label":"Homepage","url":"https://clawhub.ai/leooooooow/skills/profit-calculator","kind":"homepage"}],"safetyScore":84,"overallRank":62,"popularityScore":60,"trustScore":null,"claimedByName":null,"isOwner":false,"seoDescription":"Calculate true per-unit profit margins across channels by factoring in COGS, platform fees, shipping costs, ad spend allocation, returns, and overhead to ide..."},"coverage":{"evidence":{"source":"public-profile","verified":false,"confidence":"medium","updatedAt":"2026-10-12T02:33:04.162Z","emptyReason":null},"protocols":[{"protocol":"OPENCLEW","label":"OpenClaw","status":"self-declared","notes":"Declared in the public agent profile."}],"capabilities":[],"verifiedCount":0,"selfDeclaredCount":1,"capabilityMatrix":{"rows":[{"key":"OPENCLEW","type":"protocol","support":"unknown","confidenceSource":"profile","notes":"Listed on profile"}],"flattenedTokens":"protocol:OPENCLEW|unknown|profile"}},"adoption":{"evidence":{"source":"CLAWHUB","verified":false,"confidence":"medium","updatedAt":"2026-10-12T02:33:04.162Z","emptyReason":null},"stars":null,"forks":null,"downloads":954,"likes":null,"task":null,"library":null,"packageName":null,"latestVersion":"1.1.0","tractionLabel":"954 downloads"},"release":{"evidence":{"source":"CLAWHUB","verified":false,"confidence":"medium","updatedAt":"2026-10-12T02:33:04.150Z","emptyReason":null},"lastUpdatedAt":"2026-10-12T02:33:04.162Z","lastCrawledAt":"2026-10-12T02:33:04.150Z","lastIndexedAt":null,"nextCrawlAt":"2026-10-13T02:33:04.150Z","lastVerifiedAt":null,"highlights":[{"version":"1.1.0","createdAt":"2026-05-02T17:03:38.712Z","changelog":"**Summary:** This update adds comprehensive reference materials and quality checks to support more accurate, actionable, and repeatable profit margin analysis. - Added quality checklist and reference guides for fee schedules, output formatting, and sensitivity analysis. - Expanded documentation with detailed \"Quick Reference\" tables to clarify strong vs. weak input and modeling approaches. - Enhanced use case explanations and detailed example workflows for gathering SKU costs and mapping channel fees. - Clarified required inputs, methods for overhead allocation, and per-channel margin analysis best practices. - Outlined common mistakes and provided actionable guidance for improving profit calculations.","fileCount":7,"zipByteSize":21161},{"version":"1.0.0","createdAt":"2026-04-21T01:10:30.558Z","changelog":"Initial release.","fileCount":2,"zipByteSize":2360}]},"execution":{"evidence":{"source":"CLAWHUB","verified":false,"confidence":"low","updatedAt":null,"emptyReason":"No published capability contract is available yet."},"installCommand":"clawhub skill install s17974h9acjg4h7h5djv1hg51d83hcca:profit-calculator","setupComplexity":"low","setupSteps":["Setup complexity is LOW. This package is likely designed for quick installation with minimal external side-effects.","Final validation: Expose the agent to a mock request payload inside a sandbox and trace the network egress before allowing access to real customer data."],"contract":{"contractStatus":"missing","authModes":[],"requires":[],"forbidden":[],"supportsMcp":false,"supportsA2a":false,"supportsStreaming":false,"inputSchemaRef":null,"outputSchemaRef":null,"dataRegion":null,"contractUpdatedAt":null,"sourceUpdatedAt":null,"freshnessSeconds":null},"invocationGuide":{"preferredApi":{"snapshotUrl":"https://www.xpersona.co/api/v1/agents/clawhub-leooooooow-profit-calculator/snapshot","contractUrl":"https://www.xpersona.co/api/v1/agents/clawhub-leooooooow-profit-calculator/contract","trustUrl":"https://www.xpersona.co/api/v1/agents/clawhub-leooooooow-profit-calculator/trust"},"curlExamples":["curl -s \"https://www.xpersona.co/api/v1/agents/clawhub-leooooooow-profit-calculator/snapshot\"","curl -s \"https://www.xpersona.co/api/v1/agents/clawhub-leooooooow-profit-calculator/contract\"","curl -s \"https://www.xpersona.co/api/v1/agents/clawhub-leooooooow-profit-calculator/trust\""],"jsonRequestTemplate":{"query":"summarize this repo","constraints":{"maxLatencyMs":2000,"protocolPreference":["OPENCLEW"]}},"jsonResponseTemplate":{"ok":true,"result":{"summary":"...","confidence":0.9},"meta":{"source":"CLAWHUB","generatedAt":"2026-10-13T18:58:48.025Z"}},"retryPolicy":{"maxAttempts":3,"backoffMs":[500,1500,3500],"retryableConditions":["HTTP_429","HTTP_503","NETWORK_TIMEOUT"]}},"endpoints":{"dossierUrl":"https://www.xpersona.co/api/v1/agents/clawhub-leooooooow-profit-calculator/dossier","snapshotUrl":"https://www.xpersona.co/api/v1/agents/clawhub-leooooooow-profit-calculator/snapshot","contractUrl":"https://www.xpersona.co/api/v1/agents/clawhub-leooooooow-profit-calculator/contract","trustUrl":"https://www.xpersona.co/api/v1/agents/clawhub-leooooooow-profit-calculator/trust"}},"reliability":{"evidence":{"source":"runtime-metrics","verified":false,"confidence":"low","updatedAt":null,"emptyReason":"No trust, reliability, or runtime telemetry is available."},"trust":{"status":"unavailable","handshakeStatus":"UNKNOWN","verificationFreshnessHours":null,"reputationScore":null,"p95LatencyMs":null,"successRate30d":null,"fallbackRate":null,"attempts30d":null,"trustUpdatedAt":null,"trustConfidence":"unknown","sourceUpdatedAt":null,"freshnessSeconds":null},"decisionGuardrails":{"doNotUseIf":["Contract metadata is missing or unavailable for deterministic execution."],"safeUseWhen":[],"riskFlags":["missing_or_unavailable_contract","trust_data_unavailable","schema_references_missing"],"operationalConfidence":"low"},"executionMetrics":{"observedLatencyMsP50":null,"observedLatencyMsP95":null,"estimatedCostUsd":null,"uptime30d":null,"rateLimitRpm":null,"rateLimitBurst":null,"lastVerifiedAt":null,"verificationSource":null},"runtimeMetrics":{"successRate":null,"avgLatencyMs":null,"avgCostUsd":null,"hallucinationRate":null,"retryRate":null,"disputeRate":null,"p50Latency":null,"p95Latency":null,"lastUpdated":null}},"benchmarks":{"evidence":{"source":"no-benchmark-data","verified":false,"confidence":"low","updatedAt":null,"emptyReason":"No benchmark suites or observed failure patterns are available."},"suites":[],"failurePatterns":[]},"artifacts":{"evidence":{"source":"CLAWHUB","verified":false,"confidence":"high","updatedAt":"2026-10-12T02:33:04.162Z","emptyReason":null},"readme":"Skill: Profit Calculator\n\nOwner: leooooooow\n\nSummary: Calculate true per-unit profit margins across channels by factoring in COGS, platform fees, shipping costs, ad spend allocation, returns, and overhead to ide...\n\nTags: latest:1.1.0\n\nVersion history:\n\nv1.1.0 | 2026-05-02T17:03:38.712Z | user\n\n**Summary:**  \nThis update adds comprehensive reference materials and quality checks to support more accurate, actionable, and repeatable profit margin analysis.\n\n- Added quality checklist and reference guides for fee schedules, output formatting, and sensitivity analysis.\n- Expanded documentation with detailed \"Quick Reference\" tables to clarify strong vs. weak input and modeling approaches.\n- Enhanced use case explanations and detailed example workflows for gathering SKU costs and mapping channel fees.\n- Clarified required inputs, methods for overhead allocation, and per-channel margin analysis best practices.\n- Outlined common mistakes and provided actionable guidance for improving profit calculations.\n\nv1.0.0 | 2026-04-21T01:10:30.558Z | user\n\nInitial release.\n\nArchive index:\n\nArchive v1.1.0: 7 files, 21161 bytes\n\nFiles: assets/quality-checklist.md (4738b), references/fee-schedule-reference.md (6709b), references/output-template.md (5865b), references/sensitivity-analysis-guide.md (7816b), skill-card.md (2538b), SKILL.md (22227b), _meta.json (136b)\n\nFile v1.1.0:SKILL.md\n\n---\nname: Profit Calculator\nversion: 1.1.0\ndescription: Calculate true per-unit profit margins across channels by factoring in COGS, platform fees, shipping costs, ad spend allocation, returns, and overhead to identify which products and channels actually make money.\nauthor: LeroyCreates\ntags: [ecommerce, profitability, unit-economics, margin-analysis, cogs, channel-profitability]\n---\n\n# Profit Calculator\n\nMany ecommerce brands think they are profitable because revenue is growing, only to discover at year-end that certain SKUs or channels have been losing money on every order. Profit Calculator walks you through a full per-unit profit waterfall for each SKU on each channel so you can see exactly which products and channels deserve more budget and which should be repriced, rebundled, or killed.\n\n## Use when\n\n> The operator says \"my TikTok Shop sales look great but the bank account isn't growing — can we figure out what's actually making money?\"\n\n> A Shopify seller asks \"if I raise the price by $2, will that offset my new 3PL rate and higher Meta CPMs, or am I still underwater?\"\n\n> An Amazon FBA brand wants to compare a single SKU's contribution margin between FBA, FBM, and their own DTC store side by side before reallocating inventory.\n\n> A founder is preparing a board update and needs a clean per-SKU contribution margin waterfall that rolls up to a blended gross margin with and without advertising.\n\n## Quick Reference\n\n| Decision | Strong | Acceptable | Weak |\n|----------|--------|------------|------|\n| COGS calculation | Landed cost including freight, duty, inspection, and packaging per unit | Factory cost plus estimated freight | Factory cost only, no landed adjustments |\n| Platform fee mapping | Every fee line itemized per channel (commission, referral, payment processing, storage, subscription amortized) | Major fees captured, minor fees estimated as percentage | Single blended \"platform fee\" percentage across channels |\n| Shipping cost model | Actual weight/zone-based rate per SKU per channel from 3PL rate card | Average shipping cost per order applied uniformly | Free shipping absorbed with no per-unit allocation |\n| Ad spend allocation | Channel-specific ROAS or blended MER applied per SKU with clear attribution window | Blended MER applied uniformly across all SKUs | Ad spend not included in unit economics |\n| Return cost modeling | Return rate per category with full loaded cost (reverse logistics + product loss + restocking labor) | Average return rate applied with estimated cost per return | Returns ignored or treated as top-line revenue reduction only |\n| Overhead allocation | Fixed overhead allocated per unit using activity-based costing or revenue-weighted method | Overhead allocated as flat percentage of revenue | Overhead excluded from unit economics entirely |\n| Contribution margin target | Channel-specific targets with minimum floor (e.g., 20% DTC, 12% Amazon, 8% TikTok) | Single blended target across all channels | No target defined, just reporting current margins |\n| Price sensitivity analysis | Scenario modeling at multiple price points showing margin impact per channel | Single price change scenario modeled | No price sensitivity analysis included |\n| SKU rationalization | Clear kill/reprice/rebundle recommendations with P&L impact quantified | Flagging negative-margin SKUs without action plan | No SKU-level recommendations |\n| Reporting cadence | Monthly P&L waterfall with automated data pull and variance tracking | Quarterly manual calculation | One-time snapshot with no refresh plan |\n\n## Solves\n\n### Revenue-profit disconnect\nThe brand is growing 40% YoY but cash flow is flat. Revenue metrics mask that 30% of SKUs lose money after platform fees and returns. The waterfall exposes per-unit contribution margin so the operator knows exactly where the margin leak is.\n\n### Channel margin blindness\nDTC looks profitable at 60% gross margin, but after Meta ad spend at 4x ROAS, shipping, and returns, contribution margin is 12%. Meanwhile Amazon FBA at 35% gross margin nets 18% contribution because ad spend is lower and returns are handled by Amazon. Without per-channel unit economics, budget allocation is backwards.\n\n### Hidden fee accumulation\nPlatform fees compound in ways that are not obvious. Amazon's referral fee + FBA fee + storage fee + payment processing can exceed 40% on low-ASP items. TikTok Shop's commission + shipping subsidy clawback + affiliate commission stack differently. Each channel's fee waterfall must be mapped individually.\n\n### Return cost underestimation\nBrands treat returns as a revenue reversal, but the true cost includes reverse logistics ($4–8 per unit), product loss (30–60% of returned apparel is unsellable at full price), restocking labor, and the original outbound shipping cost that was never recovered. A 25% return rate can eliminate all margin on a $30 product.\n\n### Ad spend misattribution\nUsing blended MER across all SKUs treats a hero product driving 80% of ad-attributed revenue the same as a tail SKU with zero ad spend. Per-SKU or per-category ROAS allocation reveals which products can afford advertising and which cannot.\n\n### Overhead allocation avoidance\nBrands exclude warehouse rent, software subscriptions, and team salaries from unit economics because they are \"fixed costs.\" But a product that shows 15% contribution margin before overhead and 2% after overhead is one supply chain disruption away from losing money.\n\n### Price optimization paralysis\nWithout a margin model, price changes are gut decisions. The waterfall lets you simulate raising price by $3 on Amazon and see exactly how contribution margin changes after the referral fee percentage adjusts and estimated conversion rate shifts.\n\n## Workflow\n\n### Step 1 — Gather SKU-Level Cost Data\n\nCollect the landed cost per unit for every SKU. Landed cost means the total cost to get one unit to your warehouse ready to sell. This includes factory cost, inbound freight (ocean/air), duty and tariffs, inspection fees, packaging materials, and any prep costs (labeling, poly-bagging).\n\n**What to ask for:**\n- Most recent purchase order with per-unit costs broken out\n- Freight invoices for the most recent shipment (divide total by units shipped)\n- Customs/duty documentation or estimated duty rate by HTS code\n- Packaging cost per unit (branded box, poly bag, inserts, labels)\n- Any prep or kitting costs (FBA prep service, bundle assembly)\n\n**Common mistakes:**\n- Using factory FOB price instead of true landed cost (can understate COGS by 15–25%)\n- Forgetting to include duty, which on many consumer goods is 5–15% of declared value\n- Not updating COGS when suppliers raise prices mid-year\n- Ignoring packaging cost differences between channels (Amazon requires specific prep that DTC does not)\n\n**Output:** A table with each SKU, its landed cost per unit, and a breakdown of what is included.\n\n### Step 2 — Map Channel Fee Structures\n\nFor each sales channel, document every fee that applies to a transaction. This must be done per channel because fee structures vary dramatically.\n\n**Amazon FBA fee components:**\n- Referral fee (category-dependent, typically 8–15%)\n- FBA fulfillment fee (size and weight tiered)\n- Monthly storage fee (standard vs. Q4 peak rates)\n- Long-term storage fee (if applicable, for inventory over 181 days)\n- Payment processing (included in referral fee for Amazon)\n- Subscription fee amortized per unit (Professional seller plan $39.99/month ÷ units sold)\n\n**Shopify DTC fee components:**\n- Shopify subscription amortized per unit\n- Payment processing (Shopify Payments: 2.4–2.9% + $0.30)\n- App fees amortized per unit (Klaviyo, reviews app, etc.)\n- Theme or development costs amortized (optional, for accuracy)\n\n**TikTok Shop fee components:**\n- Platform commission (category-dependent, typically 5–8%)\n- Payment processing fee (typically included in commission)\n- Affiliate commission (if using affiliate program, typically 10–20% of sale price)\n- Shipping subsidy participation (if enrolled, can be clawed back)\n- Sample costs for affiliate seeding (amortized per attributed sale)\n\n**Walmart Marketplace fee components:**\n- Referral fee (category-dependent, typically 6–15%)\n- WFS fulfillment fee (if using Walmart Fulfillment Services)\n- Storage fees (if using WFS)\n- Payment processing (included in referral fee)\n\n**Output:** A fee schedule table for each channel showing every line item as both percentage and estimated dollar amount per unit at current ASP.\n\n### Step 3 — Calculate Shipping and Fulfillment Costs\n\nDetermine the outbound shipping and fulfillment cost per unit per channel. This is the cost to get the product from your warehouse (or 3PL or FBA) to the customer.\n\n**For FBA:** The FBA fulfillment fee from Step 2 covers this. No additional shipping cost calculation needed for FBA orders.\n\n**For 3PL-fulfilled channels (DTC, TikTok Shop self-fulfilled, Walmart self-fulfilled):**\n- Pick-and-pack fee per order from 3PL rate card\n- Outbound shipping rate based on weight and zone mix\n- Packaging materials cost (box, dunnage, tape, label)\n- If multi-item orders are common, calculate per-unit cost as total fulfillment cost ÷ average units per order\n\n**For self-fulfilled:**\n- Labor cost per order (time to pick, pack, label ÷ hourly rate)\n- Shipping carrier rate (use average zone and weight)\n- Materials cost\n\n**Key nuance:** Free shipping is not free. If you offer free shipping on DTC, the shipping cost still hits your margin. Capture the actual cost here.\n\n**Output:** Per-unit shipping and fulfillment cost for each channel.\n\n### Step 4 — Allocate Advertising Cost Per Unit\n\nDecide how to attribute ad spend to unit economics. There are two approaches:\n\n**Approach A — Blended MER (simpler):**\nTotal monthly ad spend across all channels ÷ total revenue = ad cost as % of revenue. Apply this percentage to each unit's revenue. This is simpler but treats all SKUs equally, which is rarely accurate.\n\n**Approach B — Channel-specific ROAS (more accurate):**\nFor each channel, take the channel's ad spend ÷ channel's attributed revenue = channel ad cost percentage. Apply per channel. Within a channel, if you can break ROAS down by product category or hero SKU vs. tail, do so.\n\n**What to document:**\n- Which approach you are using and why\n- Ad spend by channel for the most recent representative month\n- Revenue by channel for the same period\n- Any known ROAS differences by product category\n- Attribution window used (1-day click, 7-day click, etc.)\n\n**Common mistake:** Excluding ad spend from unit economics entirely. This makes contribution margins look artificially high and leads to bad pricing and channel allocation decisions.\n\n**Output:** Ad cost per unit or ad cost as percentage of revenue, documented per channel.\n\n### Step 5 — Model Returns and Refund Costs\n\nReturns are one of the most underestimated margin killers. Model the full cost of a return per unit.\n\n**Return cost components:**\n- Reverse logistics (cost to ship the product back or cost of prepaid return label): typically $4–8 per unit\n- Product disposition: what percentage of returns are resellable at full price vs. discounted vs. unsellable\n  - Apparel: 30–50% full price resellable, 20–30% liquidation, 20–40% write-off\n  - Electronics: 60–70% full price after refurbishment, 20–30% liquidation\n  - Beauty/consumables: 90%+ write-off (cannot resell opened products)\n- Restocking labor: time to inspect, repackage, relabel (typically $1–3 per unit)\n- Original outbound shipping cost: already paid and not recoverable\n- Refund processing: payment processor does not always refund the transaction fee\n\n**Calculate per-unit return cost:**\n(Return rate for category) × (reverse logistics + product loss cost + restocking labor + original shipping) = return cost per unit sold\n\n**Example:** A $35 apparel item with 28% return rate, $6 reverse logistics, 40% product loss ($14), $2 restocking, $5 original shipping:\n0.28 × ($6 + $14 + $2 + $5) = $7.56 return cost per unit sold\n\n**Output:** Return cost per unit per channel, broken out by component.\n\n### Step 6 — Allocate Fixed Overhead Per Unit\n\nFixed costs do not change with volume in the short term, but they must be covered by contribution margin over time. Decide how to allocate them.\n\n**Fixed overhead categories:**\n- Warehouse or office rent\n- Full-time team salaries (non-variable)\n- Software subscriptions (Shopify, ERP, analytics tools, email platform)\n- Insurance\n- Professional services (accounting, legal)\n- Equipment depreciation\n\n**Allocation methods:**\n\n*Revenue-weighted:* Allocate total monthly overhead proportional to each SKU's share of total revenue. Simple but penalizes high-ASP items.\n\n*Unit-weighted:* Allocate total monthly overhead equally per unit sold. Simple but ignores that some SKUs consume more resources.\n\n*Activity-based:* Allocate based on actual resource consumption (e.g., SKUs requiring custom packaging get more warehouse labor allocation). Most accurate but most time-consuming.\n\n**Recommendation:** Start with revenue-weighted allocation. It is good enough for most brands under $10M in revenue. Switch to activity-based once you have SKUs with dramatically different handling requirements.\n\n**Output:** Overhead cost per unit per channel, with the allocation method documented.\n\n### Step 7 — Build the Profit Waterfall and Make Decisions\n\nAssemble all components into a per-unit profit waterfall for each SKU on each channel.\n\n**Waterfall structure:**\n1. Retail price (channel-specific)\n2. − Platform fees = Net revenue after fees\n3. − COGS (landed cost) = Gross profit\n4. − Shipping and fulfillment = Gross profit after fulfillment\n5. − Ad spend allocation = Contribution margin before returns\n6. − Return costs = Contribution margin after returns\n7. − Overhead allocation = Net contribution margin\n\n**Decision framework based on net contribution margin:**\n\n| Margin Range | Action |\n|-------------|--------|\n| > 20% | Scale — increase inventory depth, expand advertising, consider new channels |\n| 10–20% | Maintain — healthy margin, optimize where possible but no urgent action |\n| 5–10% | Optimize — look for cost reduction (negotiate COGS, reduce return rate, adjust price) |\n| 0–5% | Reprice or restructure — raise price, cut ad spend, renegotiate fees, or rebundle |\n| < 0% | Kill or dramatically restructure — exit channel, discontinue SKU, or complete repositioning |\n\n**Additional analyses to include:**\n- Sensitivity table: how does margin change if price moves ±$2, ±$5\n- Break-even volume: how many units must sell to cover fixed costs at current margin\n- Channel comparison: same SKU side-by-side across all channels\n- Top 10 and bottom 10 SKUs by contribution margin\n- Margin trend: compare current margins to 3 and 6 months ago\n\n**Output:** Complete profit waterfall table per SKU per channel, decision flags, and recommended actions.\n\n## Worked Examples\n\n### Example 1 — DTC Skincare Brand, 15 SKUs, Shopify + Amazon FBA\n\n**Context:** A skincare brand selling 15 SKUs through their Shopify DTC store and Amazon FBA. Monthly revenue is $180K ($120K DTC, $60K Amazon). The founder believes DTC is more profitable because gross margins are higher, but cash flow does not reflect this.\n\n**Step 1 — COGS:** Landed cost ranges from $4.20 (30ml serum) to $11.80 (full skincare kit). The brand sources from South Korea with 6.5% duty on cosmetics. Average landed cost is $7.40 per unit including freight at $0.85/unit by ocean and duty at $0.48/unit.\n\n**Step 2 — Fees:** DTC: Shopify Basic ($39/mo ÷ 4,000 units = $0.01) + Shopify Payments (2.9% + $0.30) = $1.17 average. Amazon: 8% referral ($2.40) + FBA fee ($3.86 average) + storage ($0.18/unit/month) = $6.44 average.\n\n**Step 3 — Shipping:** DTC: 3PL pick-pack ($2.50) + USPS Priority ($6.20 average) + materials ($0.45) = $9.15. Amazon FBA: included in FBA fee above.\n\n**Step 4 — Ad spend:** DTC runs Meta ads at 4.2x ROAS. $28,600/month ÷ $120K revenue = 23.8% of DTC revenue = $7.14 per unit at $30 ASP. Amazon runs Sponsored Products at 6.8x ROAS. $8,800/month ÷ $60K = 14.7% = $4.41 per unit at $30 ASP.\n\n**Step 5 — Returns:** DTC return rate: 8% (skincare returns are low). Cost per return: $6 reverse logistics + $12 product loss (opened, unsellable) + $1 restocking = $19. Per-unit return cost: 0.08 × $19 = $1.52. Amazon return rate: 5%. Amazon handles returns, but charges per return. Per-unit return cost: 0.05 × $15 = $0.75.\n\n**Step 6 — Overhead:** $22,000/month total overhead. Revenue-weighted: DTC gets $14,667 (66.7%), Amazon gets $7,333 (33.3%). Per unit: DTC $3.67/unit (4,000 units), Amazon $3.67/unit (2,000 units).\n\n**Step 7 — Waterfall:**\n\n| Line Item | DTC ($30 ASP) | Amazon ($30 ASP) |\n|-----------|--------------|-----------------|\n| Retail price | $30.00 | $30.00 |\n| − Platform fees | −$1.17 | −$6.44 |\n| = Net after fees | $28.83 | $23.56 |\n| − COGS | −$7.40 | −$7.40 |\n| = Gross profit | $21.43 | $16.16 |\n| − Shipping/fulfillment | −$9.15 | $0.00 |\n| = After fulfillment | $12.28 | $16.16 |\n| − Ad spend | −$7.14 | −$4.41 |\n| = Contribution pre-returns | $5.14 | $11.75 |\n| − Returns | −$1.52 | −$0.75 |\n| = Contribution post-returns | $3.62 | $11.00 |\n| − Overhead | −$3.67 | −$3.67 |\n| = Net contribution | −$0.05 | $7.33 |\n| Net margin | −0.2% | 24.4% |\n\n**Insight:** DTC is actually break-even to slightly unprofitable at the per-unit level despite higher gross margins. The combination of expensive 3PL shipping ($9.15 vs. $0 for FBA) and higher ad cost (23.8% vs. 14.7%) wipes out the fee advantage. Recommendations: negotiate 3PL rates, test higher DTC pricing ($33–35), reduce Meta ad spend on low-converting SKUs, and shift inventory allocation toward Amazon.\n\n### Example 2 — Apparel Brand, 40 SKUs, DTC + TikTok Shop + Amazon\n\n**Context:** An apparel brand doing $350K/month across Shopify DTC ($200K), TikTok Shop ($90K), and Amazon ($60K). High return rates are suspected of eroding margins but the founder has never quantified the impact.\n\n**Step 1 — COGS:** Average landed cost $12.50 per unit. Includes $8.00 factory, $1.80 freight (air for replenishment), $1.00 duty (12.5% on apparel), $1.20 packaging, $0.50 quality inspection.\n\n**Step 7 — Waterfall Summary (hero product: $45 hoodie):**\n\n| Line Item | DTC | TikTok Shop | Amazon FBA |\n|-----------|-----|-------------|------------|\n| Retail price | $45.00 | $42.00 | $45.00 |\n| − Platform fees | −$1.61 | −$5.88 | −$8.10 |\n| − COGS | −$12.50 | −$12.50 | −$12.50 |\n| − Shipping | −$8.40 | −$7.20 | $0.00 |\n| − Ad spend (channel ROAS) | −$11.25 | −$6.30 | −$5.40 |\n| − Returns (28% DTC, 18% TT, 22% AMZ) | −$7.56 | −$4.86 | −$5.94 |\n| − Overhead | −$2.80 | −$2.80 | −$2.80 |\n| = Net contribution | $0.88 | $2.46 | $10.26 |\n| Net margin | 2.0% | 5.9% | 22.8% |\n\n**Insight:** The $45 hoodie barely breaks even on DTC and TikTok Shop. Returns are the primary margin killer — at 28% return rate with $27 fully-loaded cost per return, DTC loses $7.56 per unit sold to returns alone. Recommendations: implement fit quiz to reduce returns by 5–8 points, raise DTC price to $49, audit TikTok affiliate commission structure, and prioritize Amazon inventory allocation for this SKU.\n\n## Common Mistakes\n\n1. **Using gross margin as the decision metric.** Gross margin (revenue minus COGS) ignores the majority of per-unit costs. A SKU can have 70% gross margin and negative contribution margin. Always use the full waterfall.\n\n2. **Treating shipping as a single line item.** Outbound shipping on DTC is fundamentally different from FBA fulfillment fees. One is variable by zone and weight; the other is tiered by product size. Lumping them together misses optimization opportunities.\n\n3. **Ignoring returns in unit economics.** Returns are not just a revenue reversal. They carry real costs — reverse logistics, product loss, restocking — that can add $5–20 per unit sold depending on category and return rate.\n\n4. **Applying blended ad spend across all SKUs.** Hero products and tail SKUs have dramatically different relationships with advertising. A hero driving most of the ad-attributed revenue subsidizes tail SKUs that would show negative margin if ad spend were properly allocated.\n\n5. **Forgetting platform-specific fees.** Amazon alone has 6+ distinct fee types. TikTok Shop has affiliate commissions that do not exist on other platforms. Every channel must be mapped individually.\n\n6. **Using stale COGS data.** Suppliers raise prices, freight rates fluctuate, and duty rates change. COGS should be updated at minimum quarterly or with every new PO.\n\n7. **Excluding overhead entirely.** Fixed costs feel disconnected from unit economics, but contribution margin must cover overhead. Showing the overhead line separately is better than ignoring it.\n\n8. **Not modeling the return cost per unit sold.** The correct formula is: return rate × cost per return = cost per unit SOLD (not per unit returned). This amortizes return costs across all units, including those that are never returned.\n\n9. **Confusing channel revenue with channel profit.** A channel doing $100K/month in revenue and 5% margin contributes $5K. A channel doing $40K/month at 25% margin contributes $10K. Budget and inventory allocation should follow contribution dollars, not revenue.\n\n10. **Building the model once and never updating it.** Costs change constantly. A profit waterfall is only useful if it is recalculated monthly with fresh data. Build the model to be easily refreshable.\n\n## Resources\n\n- **Output template:** See `references/output-template.md` for the full profit waterfall template with all 7 sections.\n- **Fee schedule reference:** See `references/fee-schedule-reference.md` for current platform fee structures across Amazon, Shopify, TikTok Shop, and Walmart.\n- **Sensitivity analysis guide:** See `references/sensitivity-analysis-guide.md` for price and cost scenario modeling methodology.\n- **Quality checklist:** See `assets/quality-checklist.md` for the 55-item quality checklist to validate your analysis before presenting.\n\nFile v1.1.0:_meta.json\n\n{\n  \"ownerId\": \"kn70fv0ehp50emedet9tx3fekd82pw3b\",\n  \"slug\": \"profit-calculator\",\n  \"version\": \"1.1.0\",\n  \"publishedAt\": 1777741418712\n}\n\nFile v1.1.0:references/fee-schedule-reference.md\n\n# Platform Fee Schedule Reference\n\nCurrent as of Q2 2025. Fee structures change frequently — always verify against the platform's current seller documentation before finalizing your analysis.\n\n---\n\n## Amazon\n\n### Referral Fees (Commission)\nReferral fees are a percentage of the total sale price (item price + shipping + gift wrap).\n\n| Category | Referral Fee |\n|----------|-------------|\n| Beauty & Personal Care | 8% (15% for items >$10) |\n| Clothing & Accessories | 17% |\n| Consumer Electronics | 8% |\n| Home & Kitchen | 15% |\n| Health & Household | 8% (15% for items >$10) |\n| Sports & Outdoors | 15% |\n| Toys & Games | 15% |\n| Grocery & Gourmet | 8% (15% for items >$15) |\n| Pet Supplies | 15% (22% for items ≤$10) |\n\n*Note: Amazon applies a minimum referral fee of $0.30 per unit in most categories.*\n\n### FBA Fulfillment Fees (2025 rates)\nBased on product size tier and shipping weight.\n\n| Size Tier | Weight Range | Fee |\n|-----------|-------------|-----|\n| Small standard | ≤ 6 oz | $3.06 |\n| Small standard | 6–12 oz | $3.15 |\n| Small standard | 12 oz–16 oz | $3.47 |\n| Large standard | ≤ 4 oz | $3.68 |\n| Large standard | 4–8 oz | $3.98 |\n| Large standard | 8–12 oz | $4.25 |\n| Large standard | 12 oz–1 lb | $4.55 |\n| Large standard | 1–1.5 lb | $5.14 |\n| Large standard | 1.5–2 lb | $5.40 |\n| Large standard | 2–2.5 lb | $5.69 |\n| Large standard | 2.u–3 lb | $5.97 |\n| Large standard | 3+ lb | $6.04 + $0.16/half-lb above 3 lb |\n\n### Storage Fees\n| Period | Standard-Size | Oversize |\n|--------|--------------|----------|\n| Jan–Sep | $0.78/cubic ft/month | $0.56/cubic ft/month |\n| Oct–Dec | $2.40/cubic ft/month | $1.40/cubic ft/month |\n\n### Other Amazon Fees\n- **Professional seller plan:** $39.99/month (amortize across units sold)\n- **Aged inventory surcharge:** Applies to inventory over 181 days — $0.50–$6.90/cubic ft depending on age\n- **Return processing fee:** Charged in categories with high return rates (apparel, shoes, etc.)\n- **Inbound placement service fee:** $0.21–$0.68/unit depending on number of inbound locations\n\n---\n\n## Shopify (DTC)\n\n### Subscription Plans\n| Plan | Monthly Cost | Transaction Fee (Shopify Payments) |\n|------|-------------|-----------------------------------|\n| Basic | $39/month | 2.9% + $0.30 |\n| Shopify | $105/month | 2.7% + $0.30 |\n| Advanced | $399/month | 2.5% + $0.30 |\n| Plus | $2,300/month | 2.15% + $0.30 |\n\n*Non-Shopify Payments processors add an additional 0.5–2.0% transaction fee on top.*\n\n### Common App Costs to Amortize\n| App Type | Typical Monthly Cost |\n|----------|---------------------|\n| Email/SMS (Klaviyo) | $45–$350 (based on contacts) |\n| Reviews (Judge.me, Yotpo) | $0–$299 |\n| Subscriptions (Recharge) | $99–$499 |\n| Upsell/cross-sell | $30–$150 |\n| Returns management | $50–$350 |\n| Analytics | $0–$299 |\n\n**Amortization:** Sum all monthly app costs and divide by monthly units sold to get per-unit app cost.\n\n### Shopify-Specific Considerations\n- No commission or referral fee (unlike marketplaces)\n- Payment processing is the primary platform cost\n- High-volume merchants can negotiate payment processing rates\n- Shopify Capital repayments (if used) should be tracked separately as financing cost, not COGS\n\n---\n\n## TikTok Shop\n\n### Commission Rates\n| Category | Commission |\n|----------|-----------|\n| Fashion | 8% |\n| Beauty & Personal Care | 8% |\n| Food & Beverage | 5% |\n| Health | 8% |\n| Home & Garden | 8% |\n| Sports & Outdoors | 8% |\n| Electronics | 5% |\n| Baby & Maternity | 5% |\n\n*New sellers may receive a 90-day commission reduction to 1.8%.*\n\n### Affiliate Program Costs\n| Component | Typical Rate |\n|-----------|-------------|\n| Open collaboration commission | 10–20% of sale price |\n| Targeted collaboration commission | 15–30% (negotiated with creator) |\n| Sample product cost | Full COGS per sample |\n| TikTok Shop affiliate platform fee | 1% of affiliate-driven sales |\n\n**Important:** Affiliate commissions are ON TOP of platform commission. A product with 8% platform commission and 15% affiliate commission loses 23% of the sale price before any other costs.\n\n### Shipping Considerations\n- TikTok Shop subsidized shipping programs periodically offer reduced rates\n- Shipping subsidies can be clawed back if service level targets are not met\n- Self-fulfilled orders require merchant-paid shipping\n- Fulfilled by TikTok (FBT) available in limited regions with separate fee structure\n\n---\n\n## Walmart Marketplace\n\n### Referral Fees\n| Category | Referral Fee |\n|----------|-------------|\n| Apparel & Accessories | 15% |\n| Beauty | 8% |\n| Consumer Electronics | 8% |\n| Food & Gourmet | 15% |\n| Health & Personal Care | 10% |\n| Home & Garden | 15% |\n| Sports & Outdoors | 15% |\n\n### Walmart Fulfillment Services (WFS)\n| Weight | Fulfillment Fee |\n|--------|----------------|\n| ≤ 1 lb | $3.45 |\n| 1–2 lb | $4.95 |\n| 2–3 lb | $5.45 |\n| 3+ lb | $5.45 + $0.40/lb above 3 lb |\n\n**Storage:** $0.75/cubic ft/month\n\n### Walmart-Specific Considerations\n- No monthly subscription fee (unlike Amazon Professional)\n- Payment processing included in referral fee\n- Walmart+ customers drive higher conversion but same fee structure\n- WFS items get a \"2-Day Delivery\" badge, similar to Prime\n- Lower competition than Amazon in most categories but also lower traffic volume\n\n---\n\n## Cross-Platform Fee Comparison\n\n### Quick Reference at $30 ASP (Home & Kitchen category)\n\n| Fee Component | Amazon FBA | Shopify DTC | TikTok Shop | Walmart WFS |\n|--------------|-----------|-------------|-------------|-------------|\n| Commission/referral | $4.50 (15%) | $0.00 | $2.40 (8%) | $4.50 (15%) |\n| Payment processing | Included | $1.17 (2.9%+$0.30) | Included | Included |\n| Fulfillment | $4.25 (8oz) | 3PL variable | Self/FBT | $3.45 (≤1lb) |\n| Storage | $0.18/mo est. | N/A | N/A | $0.10/mo est. |\n| Subscription amortized | $0.01–0.10 | $0.01–0.10 | $0.00 | $0.00 |\n| **Total platform cost** | **$8.94–9.03** | **$1.18–1.27** | **$2.40** | **$7.95–8.05** |\n| **As % of ASP** | **29.8–30.1%** | **3.9–4.2%** | **8.0%** | **26.5–26.8%** |\n\n*DTC has the lowest platform fees but requires merchant-paid shipping and advertising that other channels partially absorb.*\n\n---\n\n## Fee Update Checklist\n\n- [ ] Check Amazon fee announcements (typically January and June each year)\n- [ ] Verify Shopify payment processing rates match current plan\n- [ ] Review TikTok Shop commission schedule (changes frequently during growth phase)\n- [ ] Confirm Walmart referral fee rates (updated periodically)\n- [ ] Update 3PL rate card (typically renegotiated annually or at volume thresholds)\n- [ ] Recalculate amortized subscription and app costs based on current unit volume\n\nFile v1.1.0:references/output-template.md\n\n# Profit Calculator — Output Template\n\nUse this template to structure the per-unit profit waterfall analysis. Fill in each section with data gathered during the workflow steps.\n\n---\n\n## 1. SKU & COGS Summary\n\n| SKU ID | Product Name | Factory Cost | Freight/Unit | Duty/Unit | Packaging | Prep/Other | **Landed Cost** |\n|--------|-------------|-------------|-------------|-----------|-----------|------------|----------------|\n| | | $ | $ | $ | $ | $ | **$** |\n| | | $ | $ | $ | $ | $ | **$** |\n| | | $ | $ | $ | $ | $ | **$** |\n\n**COGS notes:**\n- Date of most recent PO: ___\n- Freight method: ocean / air / mixed\n- Duty rate source: HTS code ___ at ____%\n- Next expected cost change: ___\n\n---\n\n## 2. Channel Fee Schedule\n\n### Channel: _______________\n\n| Fee Type | Rate / Amount | Per-Unit Cost at Current ASP |\n|----------|--------------|------------------------------|\n| Commission / Referral | % | $ |\n| Fulfillment fee | flat / tiered | $ |\n| Payment processing | % + flat | $ |\n| Storage (monthly) | $/unit/month | $ |\n| Subscription (amortized) | $/month ÷ units | $ |\n| Other: ___ | | $ |\n| **Total channel fees** | | **$** |\n\n*(Duplicate this table for each channel)*\n\n---\n\n## 3. Shipping & Fulfillment Costs\n\n| Channel | Pick & Pack | Outbound Shipping | Materials | Multi-Item Adjustment | **Total per Unit** |\n|---------|-----------|-------------------|-----------|----------------------|-------------------|\n| DTC | $ | $ | $ | ÷ ___ units/order | **$** |\n| Amazon FBA | Included in FBA fee | — | — | — | **$0.00** |\n| TikTok Shop | $ | $ | $ | | **$** |\n| Walmart | $ | $ | $ | | **$** |\n\n**Shipping notes:**\n- 3PL provider: ___\n- Average shipping zone: ___\n- Average package weight: ___ lbs\n- Free shipping threshold: $___\n\n---\n\n## 4. Ad Spend Allocation\n\n| Channel | Monthly Ad Spend | Monthly Revenue | Ad Cost % | Attribution Model | Per-Unit Ad Cost |\n|---------|-----------------|----------------|-----------|-------------------|-----------------|\n| DTC (Meta) | $ | $ | % | ___-day click | $ |\n| DTC (Google) | $ | $ | % | | $ |\n| Amazon (SP + SB) | $ | $ | % | | $ |\n| TikTok Shop | $ | $ | % | | $ |\n| **Total** | **$** | **$** | **%** | | |\n\n**Allocation method used:** Blended MER / Channel-specific ROAS / SKU-level ROAS\n\n**Blended MER (for reference):** Total ad spend $____ ÷ Total revenue $____ = ____%\n\n---\n\n## 5. Return Cost Model\n\n| Channel | Return Rate | Reverse Logistics | Product Loss | Restocking Labor | Orig. Shipping Lost | **Cost per Return** | **Cost per Unit Sold** |\n|---------|------------|-------------------|-------------|-----------------|--------------------|--------------------|----------------------|\n| DTC | % | $ | $ | $ | $ | **$** | **$** |\n| Amazon | % | $ | $ | $ | $ | **$** | **$** |\n| TikTok | % | $ | $ | $ | $ | **$** | **$** |\n\n**Product disposition rates:**\n- Full price resellable: ___%\n- Liquidation / discount: ___%\n- Write-off / unsellable: ___%\n\n**Product loss calculation:** (Liquidation % × discount amount) + (Write-off % × full COGS) = $____ average product loss per return\n\n---\n\n## 6. Overhead Allocation\n\n| Overhead Category | Monthly Cost |\n|-------------------|-------------|\n| Warehouse / office rent | $ |\n| Team salaries (non-variable) | $ |\n| Software subscriptions | $ |\n| Insurance | $ |\n| Professional services | $ |\n| Equipment / depreciation | $ |\n| **Total monthly overhead** | **$** |\n\n**Allocation method:** Revenue-weighted / Unit-weighted / Activity-based\n\n| Channel | Revenue Share | Overhead Allocated | Units Sold | **Overhead per Unit** |\n|---------|-------------|-------------------|-----------|----------------------|\n| DTC | % | $ | | **$** |\n| Amazon | % | $ | | **$** |\n| TikTok | % | $ | | **$** |\n\n---\n\n## 7. Profit Waterfall — Per SKU Per Channel\n\n### SKU: _______________ | ASP varies by channel\n\n| Waterfall Line | DTC | Amazon | TikTok | Walmart |\n|---------------|-----|--------|--------|---------|\n| Retail price | $ | $ | $ | $ |\n| − Platform fees | −$ | −$ | −$ | −$ |\n| = Net after fees | $ | $ | $ | $ |\n| − COGS (landed) | −$ | −$ | −$ | −$ |\n| = Gross profit | $ | $ | $ | $ |\n| − Shipping/fulfillment | −$ | −$ | −$ | −$ |\n| = After fulfillment | $ | $ | $ | $ |\n| − Ad spend allocation | −$ | −$ | −$ | −$ |\n| = Contribution pre-returns | $ | $ | $ | $ |\n| − Return costs | −$ | −$ | −$ | −$ |\n| = Contribution post-returns | $ | $ | $ | $ |\n| − Overhead allocation | −$ | −$ | −$ | −$ |\n| = **Net contribution** | **$** | **$** | **$** | **$** |\n| **Net margin** | **%** | **%** | **%** | **%** |\n\n*(Duplicate this table for each SKU)*\n\n---\n\n## 8. Decision Summary\n\n### SKU Rankings by Net Contribution Margin\n\n| Rank | SKU | Best Channel | Margin | Worst Channel | Margin | Action |\n|------|-----|-------------|--------|--------------|--------|--------|\n| 1 | | | % | | % | Scale |\n| 2 | | | % | | % | Maintain |\n| ... | | | % | | % | |\n| Last | | | % | | % | Kill / Reprice |\n\n### Action Items\n\n| SKU | Channel | Current Margin | Issue | Recommended Action | Expected Impact |\n|-----|---------|---------------|-------|-------------------|----------------|\n| | | % | | | +$___ /unit |\n| | | % | | | +$___ /unit |\n\n### Sensitivity Analysis Summary\n\n| Scenario | Impact on Blended Margin |\n|----------|------------------------|\n| Price +$2 all channels | +___% |\n| Price −$2 all channels | −___% |\n| COGS +10% | −___% |\n| Return rate −5 points | +___% |\n| Ad spend −20% | +___% |\n\n### Refresh Schedule\n\n| Data Point | Refresh Frequency | Owner | Next Due |\n|-----------|-------------------|-------|----------|\n| COGS / landed cost | Per PO or quarterly | | |\n| Platform fees | Quarterly or on fee change | | |\n| Shipping rates | Quarterly or on contract renewal | | |\n| Ad spend / ROAS | Monthly | | |\n| Return rates | Monthly | | |\n| Overhead | Quarterly | | |\n\nFile v1.1.0:references/sensitivity-analysis-guide.md\n\n# Sensitivity Analysis Guide\n\nHow to model the impact of price changes, cost fluctuations, and operational improvements on per-unit profit margins.\n\n---\n\n## Why Sensitivity Analysis Matters\n\nA single profit waterfall shows current state. Sensitivity analysis answers \"what if\" questions that drive real decisions:\n- \"If I raise the price by $3, do I lose enough volume to offset the margin gain?\"\n- \"If my supplier raises COGS by 10%, which SKUs go negative?\"\n- \"If I can reduce my return rate by 5 points, how much margin do I recover?\"\n\nWithout these models, pricing and cost decisions are gut calls.\n\n---\n\n## Method 1 — Single Variable Sensitivity\n\nChange one input at a time while holding everything else constant. This isolates the impact of each variable.\n\n### Price Sensitivity Table\n\nFor each SKU on each channel, model margin at multiple price points:\n\n| Price Point | Revenue | Platform Fees | COGS | Shipping | Ad Cost | Returns | Overhead | **Net Margin** | **Change** |\n|------------|---------|--------------|------|----------|---------|---------|----------|---------------|-----------|\n| Current −$5 | $ | $ | $ | $ | $ | $ | $ | % | −___ pts |\n| Current −$2 | $ | $ | $ | $ | $ | $ | $ | % | −___ pts |\n| **Current** | **$** | **$** | **$** | **$** | **$** | **$** | **$** | **%** | **baseline** |\n| Current +$2 | $ | $ | $ | $ | $ | $ | $ | % | +___ pts |\n| Current +$5 | $ | $ | $ | $ | $ | $ | $ | % | +___ pts |\n| Current +$10 | $ | $ | $ | $ | $ | $ | $ | % | +___ pts |\n\n**Important nuances when modeling price changes:**\n- Platform fees that are percentage-based (referral fees, payment processing) change in dollar terms when price changes\n- Ad cost as a percentage of revenue stays the same, but ad cost per unit changes if you assume constant ROAS\n- Volume may decrease at higher prices — model with and without volume impact\n- Competitor pricing constrains how much you can raise on marketplaces\n\n### COGS Sensitivity Table\n\n| COGS Scenario | Landed Cost | Gross Margin | Net Margin | **Margin Change** |\n|--------------|------------|-------------|-----------|-------------------|\n| −15% (renegotiated) | $ | % | % | +___ pts |\n| −10% | $ | % | % | +___ pts |\n| **Current** | **$** | **%** | **%** | **baseline** |\n| +10% (supplier increase) | $ | % | % | −___ pts |\n| +20% (tariff impact) | $ | % | % | −___ pts |\n| +30% (supply disruption) | $ | % | % | −___ pts |\n\n### Return Rate Sensitivity\n\n| Return Rate | Cost/Unit Sold | Net Margin | **Margin Change** |\n|------------|---------------|-----------|-------------------|\n| Current −10 pts | $ | % | +___ pts |\n| Current −5 pts | $ | % | +___ pts |\n| **Current** | **$** | **%** | **baseline** |\n| Current +5 pts | $ | % | −___ pts |\n| Current +10 pts | $ | % | −___ pts |\n\n### Ad Spend Sensitivity\n\n| ROAS Scenario | Ad Cost/Unit | Net Margin | **Margin Change** |\n|--------------|-------------|-----------|-------------------|\n| ROAS improves 50% | $ | % | +___ pts |\n| ROAS improves 25% | $ | % | +___ pts |\n| **Current ROAS** | **$** | **%** | **baseline** |\n| ROAS declines 25% | $ | % | −___ pts |\n| ROAS declines 50% | $ | % | −___ pts |\n| No ad spend | $ | % | +___ pts |\n\n---\n\n## Method 2 — Multi-Variable Scenario Modeling\n\nCombine multiple changes into realistic scenarios.\n\n### Scenario Template\n\n| Scenario Name | Price Change | COGS Change | Return Rate Change | Ad Spend Change | Net Margin | vs. Current |\n|--------------|-------------|-------------|-------------------|----------------|-----------|-------------|\n| **Optimistic** | +$3 | −5% | −3 pts | ROAS +20% | % | +___ pts |\n| **Base case** | $0 | $0 | 0 pts | 0% | % | baseline |\n| **Pessimistic** | −$2 | +10% | +2 pts | ROAS −15% | % | −___ pts |\n| **Tariff impact** | $0 | +25% | 0 pts | 0% | % | −___ pts |\n| **Growth push** | −$3 | $0 | +2 pts | Spend +50% | % | −___ pts |\n\n### Common Realistic Scenarios to Model\n\n**1. Supplier price increase**\nSuppliers typically raise prices 5–15% annually. Model what happens if COGS increases and you cannot raise retail price (competitive pressure on marketplaces).\n\n**2. Peak season (Q4)**\nAmazon storage fees triple in Q4. Ad CPMs increase 30–80% across Meta and Google. Return rates spike in January. Model the Q4 margin separately from the annual average.\n\n**3. New channel launch**\nWhen launching on a new channel, initial ROAS is typically 30–50% worse than established channels. Model the expected margin during the ramp period (usually 3–6 months).\n\n**4. Free shipping threshold change**\nIf you lower or remove the free shipping threshold, average shipping cost per order changes. Model the impact on per-unit margins and the expected lift in conversion rate.\n\n**5. 3PL rate renegotiation**\n3PL contracts are typically renegotiated annually or at volume thresholds. Model the margin impact of a 10–20% reduction in fulfillment costs.\n\n---\n\n## Method 3 — Break-Even Analysis\n\nDetermine the minimum volume, price, or ROAS needed to maintain profitability.\n\n### Break-Even Volume\n\nAt current margins, how many units must you sell to cover all fixed costs?\n\n**Formula:**\nBreak-even units = Total monthly fixed costs ÷ Contribution margin per unit (before overhead)\n\n**Example:**\n- Monthly overhead: $25,000\n- Contribution margin per unit (before overhead): $8.50\n- Break-even: 25,000 ÷ 8.50 = 2,941 units/month\n\n### Break-Even Price\n\nGiven current cost structure, what is the minimum price to achieve target margin?\n\n**Formula:**\nMinimum price = (COGS + shipping + return cost/unit + overhead/unit + target profit/unit) ÷ (1 − platform fee % − ad cost %)\n\n**Example:**\n- Total costs: $7.40 + $9.15 + $1.52 + $3.67 + $1.50 target = $23.24\n- Fee drain: 3.9% platform + 23.8% ad = 27.7%\n- Minimum price: $23.24 ÷ (1 − 0.277) = $32.14\n\n### Break-Even ROAS\n\nWhat ROAS do you need to maintain positive margin?\n\n**Formula:**\nBreak-even ROAS = Revenue ÷ Maximum affordable ad spend\nMaximum affordable ad spend = Revenue − COGS − fees − shipping − returns − overhead − minimum acceptable profit\n\n---\n\n## Method 4 — Margin Tornado Chart\n\nRank variables by their impact on margin to prioritize optimization efforts.\n\n### How to Build\n\n1. For each variable, calculate margin at ±10% of current value\n2. Record the margin swing (high minus low)\n3. Rank variables by swing size\n4. Present as a tornado chart (horizontal bar chart, widest at top)\n\n### Typical Variable Ranking (ecommerce)\n\nVariables usually ranked by margin impact, highest to lowest:\n\n1. **Retail price** — highest leverage, small changes have outsized impact\n2. **Return rate** — especially in apparel, can swing margin 5–10 points\n3. **Ad spend / ROAS** — second-highest discretionary cost after COGS\n4. **COGS / landed cost** — large absolute number but harder to change quickly\n5. **Shipping cost** — significant for DTC, less for FBA\n6. **Platform fees** — mostly fixed by platform, limited optimization\n7. **Overhead allocation** — important at scale but low per-unit sensitivity\n\n---\n\n## Presenting Sensitivity Results\n\n### Do\n- Show the current baseline prominently so stakeholders have an anchor\n- Highlight the 2–3 variables with the largest margin impact\n- Include realistic scenario ranges, not just theoretical extremes\n- Tie each scenario to a decision (\"if we raise price $3, margin goes from 5% to 12%\")\n- Show break-even points for critical variables\n\n### Don't\n- Model more than 5–6 variables — it becomes noise\n- Use unrealistic ranges (e.g., \"what if COGS drops 50%\")\n- Present without action items — every scenario should map to a decision\n- Forget to note assumptions (volume held constant, fees unchanged, etc.)\n- Mix up margin percentage points and margin percentage change (a move from 10% to 15% is +5 points, not +50%)\n\nFile v1.1.0:assets/quality-checklist.md\n\n# Profit Calculator — Quality Checklist\n\nValidate every analysis against this checklist before presenting. Each item should be checked or explicitly marked N/A with reasoning.\n\n---\n\n## COGS & Landed Cost (8 items)\n\n- [ ] Landed cost includes factory cost, not just purchase price\n- [ ] Inbound freight cost calculated per unit (total freight ÷ units in shipment)\n- [ ] Duty/tariff rate verified against current HTS code schedule\n- [ ] Packaging cost per unit included (branded box, poly bag, inserts, labels)\n- [ ] Any prep or kitting costs included (FBA prep, bundle assembly)\n- [ ] Inspection or quality control fees amortized per unit\n- [ ] COGS updated to reflect most recent purchase order pricing\n- [ ] Currency conversion applied if sourcing internationally (with date of rate noted)\n\n## Platform Fees (9 items)\n\n- [ ] Every fee type mapped per channel (not a single blended percentage)\n- [ ] Referral/commission fees verified against current platform schedule\n- [ ] Payment processing fees captured (percentage + fixed per-transaction)\n- [ ] Fulfillment fees matched to correct product size tier and weight\n- [ ] Storage fees included with seasonal variation noted (Q4 vs. standard)\n- [ ] Subscription costs amortized per unit based on current monthly volume\n- [ ] App and software costs amortized per unit (for DTC channels)\n- [ ] Affiliate commissions captured separately from platform commission (TikTok Shop)\n- [ ] Fee schedule verified against platform's current published rates\n\n## Shipping & Fulfillment (7 items)\n\n- [ ] Pick-and-pack cost sourced from actual 3PL rate card or internal labor calculation\n- [ ] Outbound shipping cost based on actual weight and average zone mix\n- [ ] Packaging materials cost included (box, dunnage, tape, shipping label)\n- [ ] Multi-item order adjustment applied (total fulfillment ÷ avg units per order)\n- [ ] FBA fulfillment correctly treated as inclusive of shipping (no double-counting)\n- [ ] Free shipping cost captured as merchant expense, not ignored\n- [ ] Shipping cost differences between channels documented (DTC vs. marketplace)\n\n## Ad Spend Allocation (7 items)\n\n- [ ] Allocation method explicitly stated (blended MER vs. channel ROAS vs. SKU ROAS)\n- [ ] Ad spend and revenue figures from the same time period\n- [ ] Attribution window documented per channel\n- [ ] If using blended MER, acknowledged that it treats all SKUs equally\n- [ ] If using channel ROAS, each channel has its own ad cost calculation\n- [ ] Ad spend includes all paid media (Meta, Google, TikTok, Amazon Ads, affiliates)\n- [ ] Organic revenue separated from paid-attributed revenue if possible\n\n## Return Cost Modeling (8 items)\n\n- [ ] Return rate sourced per channel (not a single blended rate)\n- [ ] Reverse logistics cost included (return shipping label or restocking fee)\n- [ ] Product disposition rates estimated (full-price resellable, liquidation, write-off)\n- [ ] Product loss dollar amount calculated from disposition rates and COGS\n- [ ] Restocking labor cost included (inspect, repackage, relabel)\n- [ ] Original outbound shipping cost noted as unrecoverable\n- [ ] Return cost calculated per unit SOLD (rate × cost per return), not per return\n- [ ] Category-specific return rates used (apparel vs. beauty vs. electronics)\n\n## Overhead Allocation (5 items)\n\n- [ ] All fixed cost categories listed (rent, salaries, software, insurance, professional services, depreciation)\n- [ ] Allocation method stated (revenue-weighted, unit-weighted, or activity-based)\n- [ ] Overhead allocated per channel based on chosen method\n- [ ] Per-unit overhead calculated using current monthly volume\n- [ ] Overhead shown as a separate waterfall line (not mixed into other costs)\n\n## Profit Waterfall (6 items)\n\n- [ ] Waterfall follows standard 7-line structure (price → fees → COGS → shipping → ads → returns → overhead)\n- [ ] All dollar amounts are per-unit, not monthly totals\n- [ ] Each line item clearly shows subtraction (running total visible at each step)\n- [ ] Net contribution margin calculated both as dollars and as percentage of retail price\n- [ ] Waterfall built for each SKU on each channel (not just blended)\n- [ ] Decision flag assigned based on margin range (scale / maintain / optimize / reprice / kill)\n\n## Decision & Recommendations (5 items)\n\n- [ ] Top and bottom SKUs ranked by net contribution margin\n- [ ] Channel comparison for same SKU presented side-by-side\n- [ ] Sensitivity analysis included for at least price and COGS variables\n- [ ] Break-even volume or break-even price calculated\n- [ ] Specific action items listed with expected margin impact quantified\n\n---\n\n**Total: 55 items**\n\nPass threshold: all items checked or explicitly marked N/A with documented reasoning.\n\nFile v1.1.0:skill-card.md\n\n## Description:\n\nCalculate true per-unit profit margins across channels by factoring in COGS, platform fees, shipping costs, ad spend allocation, returns, and overhead to identify which products and channels actually make money.\n\nThis skill is ready for commercial/non-commercial use.\n\n## Publisher:\n\n[leooooooow](https://clawhub.ai/user/leooooooow)\n\n### License/Terms of Use:\n\nMIT-0\n\n## Use Case:\n\nExternal ecommerce operators, founders, and marketplace sellers use this skill to calculate SKU-level and channel-level unit economics. It helps compare DTC, Amazon, TikTok Shop, Walmart, and similar channels using a profit waterfall, sensitivity analysis, and decision flags.\n\n### Deployment Geography for Use:\n\nGlobal\n\n## Known Risks and Mitigations:\n\nRisk: The skill may be used with confidential ecommerce financial data.\n\nMitigation: Use only data the user is comfortable sharing in the agent session, and redact sensitive customer, supplier, and account details where possible.\n\nRisk: Marketplace fee schedules and shipping rates can become stale.\n\nMitigation: Verify current seller documentation, 3PL rate cards, and platform fee notices before finalizing recommendations.\n\nRisk: Incorrect or incomplete COGS, ad attribution, return, or overhead inputs can produce misleading margin guidance.\n\nMitigation: Validate inputs with the included quality checklist and document assumptions before acting on repricing, channel allocation, or SKU rationalization recommendations.\n\n## Reference(s):\n\n- [ClawHub skill page](https://clawhub.ai/leooooooow/skills/profit-calculator)\n- [Output template](references/output-template.md)\n- [Platform fee schedule reference](references/fee-schedule-reference.md)\n- [Sensitivity analysis guide](references/sensitivity-analysis-guide.md)\n- [Quality checklist](assets/quality-checklist.md)\n\n## Skill Output:\n\n**Output Type(s):** [text, markdown, guidance]\n\n**Output Format:** [Markdown tables and concise written analysis]\n\n**Output Parameters:** [1D]\n\n**Other Properties Related to Output:** [Produces per-SKU, per-channel profit waterfall tables, sensitivity analysis, decision flags, and recommended actions when the user provides cost and channel data.]\n\n## Skill Version(s):\n\n1.1.0 (source: frontmatter and server release evidence)\n\n## Ethical Considerations:\n\nUsers should evaluate whether this skill is appropriate for their environment, review any generated or modified files before relying on them, and apply their organization's safety, security, and compliance requirements before deployment.\n\nArchive v1.0.0: 2 files, 2360 bytes\n\nFiles: SKILL.md (4172b), _meta.json (136b)\n\nFile v1.0.0:SKILL.md\n\n---\nname: profit-calculator\ndescription: Calculate true per-unit profit margins across channels by factoring in COGS, platform fees, shipping costs, ad spend allocation, returns, and overhead to identify which SKUs and channels actually make money.\n---\n\n# Profit Calculator\n\nMany ecommerce brands think they are profitable because revenue is growing, only to discover at year-end that certain SKUs or channels have been losing money on every order. Profit Calculator walks you through a full per-unit profit teardown so you can see exactly which products and channels deserve more budget and which should be repriced, rebundled, or killed.\n\n## Use when\n\n- The operator says \"my TikTok Shop sales look great but the bank account isn't growing — can we figure out what's actually making money?\"\n- A Shopify seller asks \"if I raise the price by $2, will that offset my new 3PL rate and higher Meta CPMs, or am I still underwater?\"\n- An Amazon FBA brand wants to compare a single SKU's contribution margin between FBA, FBM, and their own DTC store side by side before reallocating inventory.\n- A founder is preparing a board update and needs a clean per-SKU contribution margin waterfall that rolls up to a blended gross margin with and without advertising.\n\n## What this skill does\n\nTakes a list of SKUs plus channel-level fee structures and produces a per-unit profit waterfall for each SKU on each channel. The calculation starts from the landed product cost (COGS including freight and duty), subtracts platform commissions and payment processing, then outbound shipping and pick-and-pack fees, then amortized ad spend using either blended MER or channel-specific ROAS, then refund and return cost reserves, and finally a per-unit allocation of fixed overhead. The output flags channels where a SKU is margin-dilutive and recommends a minimum retail price to hit a target contribution margin.\n\n## Inputs required\n\n- **SKU list with unit COGS** (required): landed cost per unit including inbound freight, duty, and any inspection fees. Example: \"SKU-001, $4.20 landed.\"\n- **Retail price per channel** (required): the current listed or promoted price on each channel including typical on-platform discount.\n- **Channel fee schedule** (required): commission %, referral fees, payment processing %, and any monthly storage or subscription costs that should be amortized per unit.\n- **Shipping and fulfillment cost per unit** (required): weight- or zone-based shipping plus 3PL pick-pack rates, or FBA fulfillment fees.\n- **Ad spend allocation** (optional): either a blended MER target (e.g., 4.0) or channel-specific ROAS so advertising can be subtracted from contribution margin.\n- **Return rate and refund cost** (optional): average return % per category and the fully loaded cost of a return (product loss + reverse logistics + restocking labor).\n- **Monthly overhead** (optional): fixed costs like software, salaries, and rent to allocate per unit at expected volume.\n\n## Output format\n\nA structured per-SKU, per-channel table showing gross revenue, all deductions line by line, contribution margin in dollars and percent, and a channel ranking for each SKU. Below the table, a prioritized action list calls out: SKUs that lose money on at least one channel, SKUs where raising price by a small amount would unlock a target margin, channels that should get more inventory, and channels where you should pause promotion. A short written summary translates the math into a one-paragraph recommendation suitable for a partner or investor update.\n\n## Scope\n\n- Designed for: ecommerce operators, DTC founders, and marketplace sellers managing multiple channels.\n- Platform context: platform-agnostic with specific fee templates for Amazon, TikTok Shop, Shopee, Lazada, and Shopify.\n- Language: English.\n\n## Limitations\n\n- Does not pull real-time fee data from platform APIs; you must provide current fee rates as inputs.\n- Does not replace bookkeeping, tax filing, or audited financial statements — it is a decision-support tool, not accounting.\n- Ad allocation assumes a steady-state MER or ROAS; it does not model attribution decay or long multi-touch customer journeys.\n\nFile v1.0.0:_meta.json\n\n{\n  \"ownerId\": \"kn70fv0ehp50emedet9tx3fekd82pw3b\",\n  \"slug\": \"profit-calculator\",\n  \"version\": \"1.0.0\",\n  \"publishedAt\": 1776733830558\n}","readmeExcerpt":"Skill: Profit Calculator Owner: leooooooow Summary: Calculate true per-unit profit margins across channels by factoring in COGS, platform fees, shipping costs, ad spend allocation, returns, and overhead to ide... Tags: latest:1.1.0 Version history: v1.1.0 | 2026-05-02T17:03:38.712Z | user **Summary:** This update adds comprehensive reference materials and quality checks to support more accurate, actionable, and repea","codeSnippets":[],"executableExamples":[],"parameters":null,"dependencies":[],"permissions":[],"extractedFiles":[{"path":"SKILL.md","content":"---\nname: Profit Calculator\nversion: 1.1.0\ndescription: Calculate true per-unit profit margins across channels by factoring in COGS, platform fees, shipping costs, ad spend allocation, returns, and overhead to identify which products and channels actually make money.\nauthor: LeroyCreates\ntags: [ecommerce, profitability, unit-economics, margin-analysis, cogs, channel-profitability]\n---\n\n# Profit Calculator\n\nMany ecommerce brands think they are profitable because revenue is growing, only to discover at year-end that certain SKUs or channels have been losing money on every order. Profit Calculator walks you through a full per-unit profit waterfall for each SKU on each channel so you can see exactly which products and channels deserve more budget and which should be repriced, rebundled, or killed.\n\n## Use when\n\n> The operator says \"my TikTok Shop sales look great but the bank account isn't growing — can we figure out what's actually making money?\"\n\n> A Shopify seller asks \"if I raise the price by $2, will that offset my new 3PL rate and higher Meta CPMs, or am I still underwater?\"\n\n> An Amazon FBA brand wants to compare a single SKU's contribution margin between FBA, FBM, and their own DTC store side by side before reallocating inventory.\n\n> A founder is preparing a board update and needs a clean per-SKU contribution margin waterfall that rolls up to a blended gross margin with and without advertising.\n\n## Quick Reference\n\n| Decision | Strong | Acceptable | Weak |\n|----------|--------|------------|------|\n| COGS calculation | Landed cost including freight, duty, inspection, and packaging per unit | Factory cost plus estimated freight | Factory cost only, no landed adjustments |\n| Platform fee mapping | Every fee line itemized per channel (commission, referral, payment processing, storage, subscription amortized) | Major fees captured, minor fees estimated as percentage | Single blended \"platform fee\" percentage across channels |\n| Shipping cost model | Actual weight/zone-based rate per SKU per channel from 3PL rate card | Average shipping cost per order applied uniformly | Free shipping absorbed with no per-unit allocation |\n| Ad spend allocation | Channel-specific ROAS or blended MER applied per SKU with clear attribution window | Blended MER applied uniformly across all SKUs | Ad spend not included in unit economics |\n| Return cost modeling | Return rate per category with full loaded cost (reverse logistics + product loss + restocking labor) | Average return rate applied with estimated cost per return | Returns ignored or treated as top-line revenue reduction only |\n| Overhead allocation | Fixed overhead allocated per unit using activity-based costing or revenue-weighted method | Overhead allocated as flat percentage of revenue | Overhead excluded from unit economics entirely |\n| Contribution margin target | Channel-specific targets with minimum floor (e.g., 20% DTC, 12% Amazon, 8% TikTok) | Single blended target across all channels | No target def"},{"path":"_meta.json","content":"{\n  \"ownerId\": \"kn70fv0ehp50emedet9tx3fekd82pw3b\",\n  \"slug\": \"profit-calculator\",\n  \"version\": \"1.1.0\",\n  \"publishedAt\": 1777741418712\n}"},{"path":"references/fee-schedule-reference.md","content":"# Platform Fee Schedule Reference\n\nCurrent as of Q2 2025. Fee structures change frequently — always verify against the platform's current seller documentation before finalizing your analysis.\n\n---\n\n## Amazon\n\n### Referral Fees (Commission)\nReferral fees are a percentage of the total sale price (item price + shipping + gift wrap).\n\n| Category | Referral Fee |\n|----------|-------------|\n| Beauty & Personal Care | 8% (15% for items >$10) |\n| Clothing & Accessories | 17% |\n| Consumer Electronics | 8% |\n| Home & Kitchen | 15% |\n| Health & Household | 8% (15% for items >$10) |\n| Sports & Outdoors | 15% |\n| Toys & Games | 15% |\n| Grocery & Gourmet | 8% (15% for items >$15) |\n| Pet Supplies | 15% (22% for items ≤$10) |\n\n*Note: Amazon applies a minimum referral fee of $0.30 per unit in most categories.*\n\n### FBA Fulfillment Fees (2025 rates)\nBased on product size tier and shipping weight.\n\n| Size Tier | Weight Range | Fee |\n|-----------|-------------|-----|\n| Small standard | ≤ 6 oz | $3.06 |\n| Small standard | 6–12 oz | $3.15 |\n| Small standard | 12 oz–16 oz | $3.47 |\n| Large standard | ≤ 4 oz | $3.68 |\n| Large standard | 4–8 oz | $3.98 |\n| Large standard | 8–12 oz | $4.25 |\n| Large standard | 12 oz–1 lb | $4.55 |\n| Large standard | 1–1.5 lb | $5.14 |\n| Large standard | 1.5–2 lb | $5.40 |\n| Large standard | 2–2.5 lb | $5.69 |\n| Large standard | 2.u–3 lb | $5.97 |\n| Large standard | 3+ lb | $6.04 + $0.16/half-lb above 3 lb |\n\n### Storage Fees\n| Period | Standard-Size | Oversize |\n|--------|--------------|----------|\n| Jan–Sep | $0.78/cubic ft/month | $0.56/cubic ft/month |\n| Oct–Dec | $2.40/cubic ft/month | $1.40/cubic ft/month |\n\n### Other Amazon Fees\n- **Professional seller plan:** $39.99/month (amortize across units sold)\n- **Aged inventory surcharge:** Applies to inventory over 181 days — $0.50–$6.90/cubic ft depending on age\n- **Return processing fee:** Charged in categories with high return rates (apparel, shoes, etc.)\n- **Inbound placement service fee:** $0.21–$0.68/unit depending on number of inbound locations\n\n---\n\n## Shopify (DTC)\n\n### Subscription Plans\n| Plan | Monthly Cost | Transaction Fee (Shopify Payments) |\n|------|-------------|-----------------------------------|\n| Basic | $39/month | 2.9% + $0.30 |\n| Shopify | $105/month | 2.7% + $0.30 |\n| Advanced | $399/month | 2.5% + $0.30 |\n| Plus | $2,300/month | 2.15% + $0.30 |\n\n*Non-Shopify Payments processors add an additional 0.5–2.0% transaction fee on top.*\n\n### Common App Costs to Amortize\n| App Type | Typical Monthly Cost |\n|----------|---------------------|\n| Email/SMS (Klaviyo) | $45–$350 (based on contacts) |\n| Reviews (Judge.me, Yotpo) | $0–$299 |\n| Subscriptions (Recharge) | $99–$499 |\n| Upsell/cross-sell | $30–$150 |\n| Returns management | $50–$350 |\n| Analytics | $0–$299 |\n\n**Amortization:** Sum all monthly app costs and divide by monthly units sold to get per-unit app cost.\n\n### Shopify-Specific Considerations\n- No commission or referral fee (unlike marketplaces)\n- Payment processi"},{"path":"references/output-template.md","content":"# Profit Calculator — Output Template\n\nUse this template to structure the per-unit profit waterfall analysis. Fill in each section with data gathered during the workflow steps.\n\n---\n\n## 1. SKU & COGS Summary\n\n| SKU ID | Product Name | Factory Cost | Freight/Unit | Duty/Unit | Packaging | Prep/Other | **Landed Cost** |\n|--------|-------------|-------------|-------------|-----------|-----------|------------|----------------|\n| | | $ | $ | $ | $ | $ | **$** |\n| | | $ | $ | $ | $ | $ | **$** |\n| | | $ | $ | $ | $ | $ | **$** |\n\n**COGS notes:**\n- Date of most recent PO: ___\n- Freight method: ocean / air / mixed\n- Duty rate source: HTS code ___ at ____%\n- Next expected cost change: ___\n\n---\n\n## 2. Channel Fee Schedule\n\n### Channel: _______________\n\n| Fee Type | Rate / Amount | Per-Unit Cost at Current ASP |\n|----------|--------------|------------------------------|\n| Commission / Referral | % | $ |\n| Fulfillment fee | flat / tiered | $ |\n| Payment processing | % + flat | $ |\n| Storage (monthly) | $/unit/month | $ |\n| Subscription (amortized) | $/month ÷ units | $ |\n| Other: ___ | | $ |\n| **Total channel fees** | | **$** |\n\n*(Duplicate this table for each channel)*\n\n---\n\n## 3. Shipping & Fulfillment Costs\n\n| Channel | Pick & Pack | Outbound Shipping | Materials | Multi-Item Adjustment | **Total per Unit** |\n|---------|-----------|-------------------|-----------|----------------------|-------------------|\n| DTC | $ | $ | $ | ÷ ___ units/order | **$** |\n| Amazon FBA | Included in FBA fee | — | — | — | **$0.00** |\n| TikTok Shop | $ | $ | $ | | **$** |\n| Walmart | $ | $ | $ | | **$** |\n\n**Shipping notes:**\n- 3PL provider: ___\n- Average shipping zone: ___\n- Average package weight: ___ lbs\n- Free shipping threshold: $___\n\n---\n\n## 4. Ad Spend Allocation\n\n| Channel | Monthly Ad Spend | Monthly Revenue | Ad Cost % | Attribution Model | Per-Unit Ad Cost |\n|---------|-----------------|----------------|-----------|-------------------|-----------------|\n| DTC (Meta) | $ | $ | % | ___-day click | $ |\n| DTC (Google) | $ | $ | % | | $ |\n| Amazon (SP + SB) | $ | $ | % | | $ |\n| TikTok Shop | $ | $ | % | | $ |\n| **Total** | **$** | **$** | **%** | | |\n\n**Allocation method used:** Blended MER / Channel-specific ROAS / SKU-level ROAS\n\n**Blended MER (for reference):** Total ad spend $____ ÷ Total revenue $____ = ____%\n\n---\n\n## 5. Return Cost Model\n\n| Channel | Return Rate | Reverse Logistics | Product Loss | Restocking Labor | Orig. Shipping Lost | **Cost per Return** | **Cost per Unit Sold** |\n|---------|------------|-------------------|-------------|-----------------|--------------------|--------------------|----------------------|\n| DTC | % | $ | $ | $ | $ | **$** | **$** |\n| Amazon | % | $ | $ | $ | $ | **$** | **$** |\n| TikTok | % | $ | $ | $ | $ | **$** | **$** |\n\n**Product disposition rates:**\n- Full price resellable: ___%\n- Liquidation / discount: ___%\n- Write-off / unsellable: ___%\n\n**Product loss calculation:** (Liquidation % × discount amount) + (Write-off % × fu"},{"path":"references/sensitivity-analysis-guide.md","content":"# Sensitivity Analysis Guide\n\nHow to model the impact of price changes, cost fluctuations, and operational improvements on per-unit profit margins.\n\n---\n\n## Why Sensitivity Analysis Matters\n\nA single profit waterfall shows current state. Sensitivity analysis answers \"what if\" questions that drive real decisions:\n- \"If I raise the price by $3, do I lose enough volume to offset the margin gain?\"\n- \"If my supplier raises COGS by 10%, which SKUs go negative?\"\n- \"If I can reduce my return rate by 5 points, how much margin do I recover?\"\n\nWithout these models, pricing and cost decisions are gut calls.\n\n---\n\n## Method 1 — Single Variable Sensitivity\n\nChange one input at a time while holding everything else constant. This isolates the impact of each variable.\n\n### Price Sensitivity Table\n\nFor each SKU on each channel, model margin at multiple price points:\n\n| Price Point | Revenue | Platform Fees | COGS | Shipping | Ad Cost | Returns | Overhead | **Net Margin** | **Change** |\n|------------|---------|--------------|------|----------|---------|---------|----------|---------------|-----------|\n| Current −$5 | $ | $ | $ | $ | $ | $ | $ | % | −___ pts |\n| Current −$2 | $ | $ | $ | $ | $ | $ | $ | % | −___ pts |\n| **Current** | **$** | **$** | **$** | **$** | **$** | **$** | **$** | **%** | **baseline** |\n| Current +$2 | $ | $ | $ | $ | $ | $ | $ | % | +___ pts |\n| Current +$5 | $ | $ | $ | $ | $ | $ | $ | % | +___ pts |\n| Current +$10 | $ | $ | $ | $ | $ | $ | $ | % | +___ pts |\n\n**Important nuances when modeling price changes:**\n- Platform fees that are percentage-based (referral fees, payment processing) change in dollar terms when price changes\n- Ad cost as a percentage of revenue stays the same, but ad cost per unit changes if you assume constant ROAS\n- Volume may decrease at higher prices — model with and without volume impact\n- Competitor pricing constrains how much you can raise on marketplaces\n\n### COGS Sensitivity Table\n\n| COGS Scenario | Landed Cost | Gross Margin | Net Margin | **Margin Change** |\n|--------------|------------|-------------|-----------|-------------------|\n| −15% (renegotiated) | $ | % | % | +___ pts |\n| −10% | $ | % | % | +___ pts |\n| **Current** | **$** | **%** | **%** | **baseline** |\n| +10% (supplier increase) | $ | % | % | −___ pts |\n| +20% (tariff impact) | $ | % | % | −___ pts |\n| +30% (supply disruption) | $ | % | % | −___ pts |\n\n### Return Rate Sensitivity\n\n| Return Rate | Cost/Unit Sold | Net Margin | **Margin Change** |\n|------------|---------------|-----------|-------------------|\n| Current −10 pts | $ | % | +___ pts |\n| Current −5 pts | $ | % | +___ pts |\n| **Current** | **$** | **%** | **baseline** |\n| Current +5 pts | $ | % | −___ pts |\n| Current +10 pts | $ | % | −___ pts |\n\n### Ad Spend Sensitivity\n\n| ROAS Scenario | Ad Cost/Unit | Net Margin | **Margin Change** |\n|--------------|-------------|-----------|-------------------|\n| ROAS improves 50% | $ | % | +___ pts |\n| ROAS improves 25% | $ | % | +___ pts |\n| **Curre"}],"languages":[],"docsSourceLabel":"CLAWHUB","editorialOverview":"Calculate true per-unit profit margins across channels by factoring in COGS, platform fees, shipping costs, ad spend allocation, returns, and overhead to ide... Skill: Profit Calculator Owner: leooooooow Summary: Calculate true per-unit profit margins across channels by factoring in COGS, platform fees, shipping costs, ad spend allocation, returns, and overhead to ide... Tags: latest:1.1.0 Version history: v1.1.0 | 2026-05-02T17:03:38.712Z | user **Summary:** This update adds comprehensive reference materials and quality checks to support more accurate, actionable, and repea","editorialQuality":{"score":100,"threshold":65,"status":"ready","wordCount":1814,"uniquenessScore":47,"reasons":[]}},"media":{"evidence":{"source":"no-media","verified":false,"confidence":"low","updatedAt":"2026-10-12T02:33:04.162Z","emptyReason":"No screenshots, media assets, or demo links are available."},"primaryImageUrl":null,"mediaAssetCount":0,"assets":[],"demoUrl":null},"ownerResources":{"evidence":{"source":"unclaimed","verified":false,"confidence":"low","updatedAt":"2026-10-12T02:33:04.162Z","emptyReason":"This page has not been claimed by the agent owner."},"hasCustomPage":false,"customPageUpdatedAt":null,"customLinks":[],"structuredLinks":{"docsUrl":null,"demoUrl":null,"supportUrl":null,"pricingUrl":null,"statusUrl":null},"customPage":null},"relatedAgents":{"evidence":{"source":"protocol-neighbors","verified":false,"confidence":"medium","updatedAt":"2026-10-13T18:58:48.025Z","emptyReason":null},"items":[{"id":"8ebccd8e-3863-4187-8355-c3f14e1f9edf","entityType":"agent","canonicalPath":"/agent/iofficeai-aionui","slug":"iofficeai-aionui","name":"AionUi","description":"Free, local, open-source 24/7 Cowork app and OpenClaw for Gemini CLI, Claude Code, Codex, OpenCode, Qwen Code, Goose CLI, Auggie, and more | 🌟 Star if you like it!","url":"https://github.com/iOfficeAI/AionUi","homepage":"https://www.aionui.com","source":"GITHUB_REPOS","protocols":["MCP","OPENCLAW"],"capabilities":[],"safetyScore":100,"overallRank":70,"updatedAt":"2026-10-09T19:11:12.944Z","createdAt":"2026-02-25T03:38:16.584Z","downloads":null},{"id":"b917f68a-ebff-438e-84f8-3f4b2494c0bc","entityType":"agent","canonicalPath":"/agent/activepieces-activepieces","slug":"activepieces-activepieces","name":"activepieces","description":"AI Agents & MCPs & AI Workflow Automation • (~400 MCP servers for AI agents) • AI Automation / AI Agent with MCPs • AI Workflows & AI Agents • MCPs for AI Agents","url":"https://github.com/activepieces/activepieces","homepage":"https://www.activepieces.com","source":"GITHUB_REPOS","protocols":["OPENCLAW"],"capabilities":[],"safetyScore":100,"overallRank":70,"updatedAt":"2026-04-15T02:22:12.426Z","createdAt":"2026-02-25T03:38:12.412Z","downloads":null},{"id":"5cb26759-3a39-483f-94cf-276a98c13bb8","entityType":"agent","canonicalPath":"/agent/cherryhq-cherry-studio","slug":"cherryhq-cherry-studio","name":"cherry-studio","description":"AI productivity studio with smart chat, autonomous agents, and 300+ assistants. Unified access to frontier LLMs","url":"https://github.com/CherryHQ/cherry-studio","homepage":"https://cherry-ai.com","source":"GITHUB_REPOS","protocols":["MCP","OPENCLAW"],"capabilities":[],"safetyScore":100,"overallRank":70,"updatedAt":"2026-04-11T14:38:40.986Z","createdAt":"2026-02-25T03:38:19.379Z","downloads":null},{"id":"6f6582d0-5d76-4f0f-b81d-86520247950b","entityType":"agent","canonicalPath":"/agent/copilotkit-copilotkit","slug":"copilotkit-copilotkit","name":"CopilotKit","description":"The Frontend for Agents & Generative UI. React + Angular","url":"https://github.com/CopilotKit/CopilotKit","homepage":"https://docs.copilotkit.ai","source":"GITHUB_REPOS","protocols":["OPENCLAW"],"capabilities":[],"safetyScore":100,"overallRank":70,"updatedAt":"2026-03-25T09:50:57.846Z","createdAt":"2026-02-25T03:39:14.617Z","downloads":null}],"links":{"hub":"/agent","source":"/agent/source/clawhub","protocols":[{"label":"OpenClaw","href":"/agent/protocol/openclew"}]}}}