Copy and paste into your AI tool
You are a senior Amazon financial analyst and ecommerce profitability specialist with expertise in multi-channel cost modeling and inventory allocation strategy.

BEFORE YOU EXECUTE:
1. Confirm the selling price for each channel is provided -- FBA, FBM, and wholesale prices are often different and the comparison is meaningless without channel-specific prices.
2. Confirm COGS (cost of goods sold per unit) is provided. This is the single most important input. If COGS includes shipping to Amazon or the seller's warehouse, note it separately.
3. Do not use placeholder fee estimates. Use the 2026 Amazon fee schedule for FBA and referral fees. If a specific product category or size tier is not provided, state your assumption and flag it for verification.
4. Hidden costs to surface for each channel: return handling, customer service time (FBM), storage (FBA vs. your own warehouse), chargebacks and deductions (wholesale), freight (all channels).
5. If wholesale margin appears higher on paper, verify the payment terms and minimum order volume -- a 30% margin with net-60 terms and a $50,000 MOQ is not the same as a 25% FBA margin with weekly payouts.

POLICY REMINDER: Referral fees are the same percentage for both FBA and FBM sellers on Amazon -- the fulfillment method does not change the referral fee rate. Referral fees have remained unchanged since January 2024 and are held flat through 2026. FBA fulfillment fees increased by an average of $0.08 per unit effective January 15, 2026. FBM sellers pay referral fees and selling plan fees but no FBA fulfillment or storage fees. Verify all current fee rates in Seller Central > Manage FBA > FBA Revenue Calculator before making channel allocation decisions.

---

TASK: Calculate true net margin per unit and per channel for the product described, then provide a channel allocation recommendation.

OUTPUT FORMAT:

**SECTION 1 -- PRODUCT AND CHANNEL SUMMARY**
| Field | FBA | FBM | Wholesale/Retail |
|---|---|---|---|
| Selling price | | | |
| Channel | Amazon FBA | Amazon FBM | [Retailer / Distributor name] |
| Monthly unit volume | | | |
| Payment terms | Net 2-3 days | Net 2-3 days | Net [X] days |

**SECTION 2 -- COST STACK (per unit)**

| Cost Category | FBA | FBM | Wholesale |
|---|---|---|---|
| COGS (product cost) | | | |
| Inbound freight to fulfillment point | | | |
| Amazon referral fee | | | |
| FBA fulfillment fee | | N/A | N/A |
| FBA storage (monthly avg) | | N/A | N/A |
| FBA inbound placement fee | | N/A | N/A |
| Self-fulfillment pick/pack/ship | N/A | | N/A |
| Outbound freight (FBM) | N/A | | N/A |
| Self-warehousing cost (FBM) | N/A | | N/A |
| Wholesale freight to buyer | N/A | N/A | |
| Retail deductions / chargebacks (est.) | N/A | N/A | |
| Returns processing cost | | | |
| Customer service cost (labor est.) | Included in FBA fee | | |
| PPC advertising allocation | | | |
| Selling plan fee (per unit allocation) | | | |
| **Total cost per unit** | | | |
| **Net margin per unit** | | | |
| **Net margin %** | | | |

**SECTION 3 -- WORKING CAPITAL AND CASH FLOW COMPARISON**
| Metric | FBA | FBM | Wholesale |
|---|---|---|---|
| Payment cycle (days to cash) | | | |
| Inventory days on hand required | | | |
| Est. working capital required at [X] units/mo | | | |
| Cash flow risk rating | | | |

**SECTION 4 -- BREAK-EVEN AND SENSITIVITY ANALYSIS**
For each channel, calculate the minimum selling price needed to break even (0% margin) given the cost stack above.

| Channel | Break-even price | Current price | Margin buffer | |
|---|---|---|---|---|

Sensitivity analysis -- impact of a 10% COGS increase on each channel:
| Channel | Current margin % | Margin % after +10% COGS | Still viable? |
|---|---|---|---|

**SECTION 5 -- HIDDEN COST FLAGS**
List any costs that are frequently underestimated or omitted for each channel, based on the inputs provided:
- FBA: [list]
- FBM: [list]
- Wholesale: [list]

**SECTION 6 -- CHANNEL ALLOCATION RECOMMENDATION**
Based on the analysis above, provide a specific recommendation:

Primary channel: [channel] | Rationale: [2-3 sentences]
Secondary channel (if applicable): [channel] | Rationale: [2-3 sentences]
Channel to avoid or deprioritize: [channel] | Rationale: [2-3 sentences]

Conditions that would change this recommendation:
1. If [X] happens, shift allocation toward [channel] because [reason]
2. If [Y] happens, shift allocation toward [channel] because [reason]

**SECTION 7 -- SCALING IMPLICATIONS**
At 2x current volume, which channel improves most and why? At 5x?
Identify the channel with the best margin improvement curve at scale and the channel that hits a structural ceiling first.

PASTE YOUR DATA BELOW. Include: product name and category, COGS per unit (and what it includes), selling price per channel (FBA / FBM / wholesale), monthly unit volume per channel (actual or projected), product dimensions and weight (for FBA fee calculation), average inventory days on hand in FBA, self-fulfillment shipping cost per unit (if FBM), wholesale buyer name and payment terms (if applicable), monthly PPC spend allocation per channel, any known retail deductions or chargeback rates. [YOUR DATA HERE]
What you'd paste after the divider
Product: Silicone Baking Mat Set (2-pack)
Category: Kitchen
COGS: $2.80/unit (includes product cost and packaging; excludes inbound freight)
Inbound freight to Amazon: $0.28/unit

FBA channel:
- Selling price: $24.99
- Monthly volume: 300 units
- Dimensions: 18 x 13 x 1.5 inches, 12 oz
- Average days inventory in FBA: 45 days
- Monthly PPC spend: $400

FBM channel:
- Selling price: $22.99 (slightly lower, competing without Prime badge)
- Monthly volume: 80 units
- Self-ship cost: $4.20/unit (USPS First Class, own warehouse)
- Warehouse overhead allocation: $0.45/unit
- Monthly PPC spend: $80

Wholesale:
- Buyer: Regional kitchen specialty retailer
- Selling price: $11.50/unit (wholesale price)
- Monthly volume: 200 units (500-unit MOQ per order)
- Payment terms: Net 45
- Known deductions: 2% prompt pay discount sometimes taken
- Freight to buyer: $0.55/unit
01

The FBM margin often looks better on a per-unit basis once you remove FBA fees -- but factor in your time cost for customer service and returns handling. If you or an employee are spending 5 hours per week on FBM customer service, that labor cost belongs in the model.

02

Wholesale economics hinge on payment terms and deductions more than the headline price. A net-60 deal at 40% margin ties up more working capital than a net-7 deal at 30% margin, and retail deductions (freight allowances, markdown money, damage claims) can easily erode 5-8 points of margin that never shows up in the purchase order.

03

Use this model as a living document -- update it each time Amazon changes its fee schedule (typically January) and each time you renegotiate COGS. The best channel today may not be the best channel at your next volume tier.

What does the Profitability by Channel Calculator prompt do?
This prompt calculates true net margin for the same product across FBA, FBM, and wholesale/retail channels by surfacing every cost layer -- including the ones most sellers miss. The output is a side-by-side channel comparison that tells you where to allocate inventory and when to switch channels as your business scales.
What data do I need to use this prompt?
An example of the exact input format is provided on this page under "Example Input." Generally you'll prepare your data in the structure shown, paste it after the prompt body, and the AI will return the analysis described above. If you're missing any inputs, the prompt will ask you what it needs.
How long does this take to set up?
Setup time for this prompt is 30-60 mins. That includes pulling your data, formatting it to match the example, and running the prompt. Once your data pipeline is set up the first time, subsequent runs take only a few minutes.
Which AI tool should I use this with?
This prompt is designed to work with any major large language model — ChatGPT (GPT-4 or newer), Claude (Sonnet 4 or newer), or Gemini. For structured analysis, math, and tabular outputs, Claude and GPT-4 class models produce the most reliable results.
Does this prompt work for Shopify or other platforms?
This prompt is built for Amazon sellers and references Amazon-specific data points such as referral fees, FBA fulfillment fees, and ASIN-level metrics. The underlying methodology can be adapted to other platforms by substituting equivalent inputs, but the prompt as written is Amazon-first.
What skill level is required to use this prompt?
This prompt is rated intermediate. Some familiarity with your platform's data exports and basic AI prompting is helpful for getting the most out of it. Most ecommerce operators can use it productively within a single session.
Is this prompt free to use?
Yes. Every prompt in the SMB Advantage Prompt Library is free for any small business operator to use. The only cost is whatever you pay for your AI tool subscription (ChatGPT Plus, Claude Pro, etc.).
Stay in the loop

Want notes when new prompts ship?

A few times a week, field notes on what's actually working when AI meets ecommerce ops. Plus first look at new prompts and tools as they go live.