Why ASIN-Level Profitability Matters
Your overall profit and loss statement shows $50,000 profit. But which products are generating that profit? You might have 5 SKUs losing money while 2 SKUs carry the entire business. Without ASIN-level profitability analysis, you're flying blind.
Amazon sellers often discover that 20% of products generate 80% of profit—and the other 80% are mediocre or losing money. ASIN profitability modeling reveals which products to scale, which to discontinue, and which to reprice.
The Complete ASIN Profit Formula
Gross Revenue per ASIN
Less: Product COGS
Less: Amazon Referral Fee (8-45% depending on category)
Less: FBA Fulfillment Fee
Less: Payment Processing Fee
Less: Advertising Spend (if applicable)
Less: Allocated Overhead (portion of fixed costs)
= Net Profit Per Unit × Units Sold = Total ASIN Profit
Step 1: Calculate Product COGS
What's Included in COGS
- Product Cost: Unit price from supplier
- Freight Cost: Ocean/air shipping per unit (landed cost)
- Customs & Tariffs: Import duties allocated per unit
- Packaging: Poly mailers, boxes, labels for shipping
- Labeling: UPC codes, serial numbers, QC inspection
- Prep & Repack: If repackaging for FBA
Real Example: Wireless Earbuds ASIN
| Cost Component | Unit Cost | Calculation |
|---|---|---|
| Product Cost | $12.50 | Direct from supplier |
| Ocean Freight | $1.20 | $30,000 freight ÷ 25,000 units |
| Customs & Duties | $0.80 | 15% tariff on $12.50 |
| Packaging | $0.75 | Box, manual, label |
| QC & Labeling | $0.45 | Testing, FNSKU labeling |
| Total COGS | $15.70 | Landed cost per unit |
Note: Many sellers only count supplier invoice ($12.50) as COGS, missing $3.20/unit in hidden costs. This underestimates true product cost by 26%.
Step 2: Calculate Amazon FBA Fees
Referral Fee (Fixed by Category)
- Electronics: 8%
- Home & Kitchen: 15%
- Sports & Outdoors: 10%
- Apparel & Shoes: 17%
- Beauty: 10%
- Check Amazon's complete fee schedule for your category
FBA Fulfillment Fee (Size/Weight Based)
Standard Size (less common):
- Up to 12oz: $2.41/unit
- Over 12oz: $0.87/lb
Oversize Category:
- Over 20 lbs: $125-315/unit (price varies by size tier)
FBA Fee Example: Earbuds (128g / 4.5oz)
| Fee Type | Per Unit | Calculation |
|---|---|---|
| Referral Fee (8%) | $1.60 | 8% of $20 selling price |
| FBA Fulfillment | $0.41 | Small/light: 4.5oz = $0.41 |
| Payment Processing | $0.60 | 3% of $20 revenue |
| Total Fees | $2.61 | 13% of selling price |
Step 3: Account for Advertising Spend
If you're running Sponsored Products, Sponsored Brands, or Sponsored Display ads, allocate spend by ASIN:
Monthly Ad Spend: $500
Product A: $200 (generated by this ASIN's ads)
Product B: $150
Product C: $150
Divide ad spend by monthly units sold of each product to get cost per unit
Advertising Cost Per Unit
- Example: Product A spent $200, sold 1,000 units = $0.20 ACoS (Advertising Cost of Sale)
- Many sellers target 15-25% ACoS on average (so $3-5 ad spend on a $20 item)
- Unprofitable ACoS: When ad spend exceeds profit margin
Step 4: Overhead Allocation
Overhead Costs to Allocate
- Software Subscriptions: QB/Xero, Inventory Lab, Helium 10
- Accounting & Tax: Bookkeeper, tax prep allocated to product
- Packaging & Supplies: Labels, tape, boxes (if not in COGS)
- Shipping Supplies: Poly mailers, void fill
- Returns & Replacements: Defect rate provision
Allocation Methods
Method 1: By Revenue %
- Total monthly overhead: $2,000
- Product A revenue: $30,000 (30% of $100,000 total)
- Allocated overhead: $2,000 × 30% = $600
- If 1,000 units sold: $0.60 overhead per unit
Method 2: By Unit Count
- Total overhead: $2,000
- Total units sold across all products: 5,000
- Overhead per unit: $2,000 ÷ 5,000 = $0.40/unit
- Each ASIN bears $0.40 regardless of price
Recommendation: Use Method 1 (revenue %) as it's fairer to high-volume, lower-margin products.
Complete ASIN Profitability Model Example
| Component | Unit Amount | Annual (1,000 units) |
|---|---|---|
| Revenue | $20.00 | $20,000 |
| Product COGS | -$15.70 | -$15,700 |
| Referral Fee (8%) | -$1.60 | -$1,600 |
| FBA Fee | -$0.41 | -$410 |
| Payment Processing (3%) | -$0.60 | -$600 |
| Ad Spend (20% ACoS) | -$4.00 | -$4,000 |
| Allocated Overhead | -$0.60 | -$600 |
| Net Profit Per Unit | -$3.91 | -$3,910 |
| Profit Margin % | -19.6% | LOSS |
⚠️ Alert: This ASIN is losing $3.91 per unit! Even though gross revenue is $20, after all costs it's unprofitable. This is common for new sellers who underprice or overspend on ads.
How to Optimize Unprofitable ASINs
1. Raise Selling Price
Increase from $20 to $24 (+20%). If volume drops 10%, total profit improves:
- 900 units × new profit per unit = improved margin
- Elasticity varies by category (some handle price increases, some don't)
- Test with small price increments ($1-2 first)
2. Reduce COGS
- Negotiate lower supplier price (buy in larger volumes)
- Find alternative supplier
- Reduce freight costs (combine shipments, negotiate LCL rates)
- Even $0.50/unit savings on 1,000 units = $500 additional profit
3. Cut Advertising Spend
- Currently spending 20% of revenue on ads
- If organic rank improves, reduce ad budget to 10-15%
- Focus budget on profitable search terms only
- Reduce ACoS from 20% to 15% = +$1/unit profit
4. Discontinue the ASIN
- If unprofitable after optimization attempts, kill the product
- Redeploy inventory budget to profitable ASINs
- Free up warehouse space and management overhead
Building Your ASIN Profitability Dashboard
Tools to Track ASIN Profit
- Stitch Labs: $99-299/month (best for FBA sellers)
- Sellalytic: $99/month (good ASIN breakdown)
- Inventory Lab: $29-89/month (basic profitability)
- Helium 10: $99-299/month (includes profit analysis)
- Excel/Google Sheets: Free (manual but works with export)
Manual Tracking Method (Excel)
Create columns for each ASIN with:
- Units sold per month
- Selling price
- COGS (landed cost)
- Amazon fees (referral + FBA)
- Ad spend
- Allocated overhead
- Net profit calculation
- Profit margin %
Pareto Analysis: 80/20 Rule for ASINs
Typical ASIN Distribution (100 products):
20 ASINs generate 80% of profit (stars to scale)
30 ASINs generate 15% of profit (mediocre, optimize or kill)
50 ASINs generate 5% or are unprofitable (discontinue)
Action Plan Based on Profitability Tier
- Top 20% (Highly Profitable): Increase ad spend, order more inventory, optimize listings
- Middle 30% (Mediocre): Price increase test, reduce ad spend, or discontinue
- Bottom 50% (Low/No Profit): Discontinue immediately to free capital
Common ASIN Profitability Mistakes
- Not including landed cost: Only counting supplier invoice ignores freight, tariffs, packaging
- Ignoring Amazon fee changes: Fees increase quarterly for some categories
- Not allocating overhead: Makes unprofitable products look breakeven
- Over-advertising unprofitable products: Throwing good money after bad
- Mixing profitable and unprofitable: Unprofitable ASINs drag down overall business metrics
- Not tracking by ASIN: Business looks profitable overall but products individually lose money
- Ignoring inventory holding cost: Slow-moving ASINs pay Amazon storage fees ($0.87/unit/month oversize)
Summary: ASIN Profitability Modeling
1. Calculate true landed cost for each ASIN (supplier price + all freight, tariffs, packaging)
2. Account for all Amazon fees (referral, FBA, payment processing)
3. Allocate advertising spend and overhead by ASIN
4. Model net profit per unit and total ASIN profit
5. Identify your 80/20 products and focus scaling efforts
6. Discontinue bottom 50% of unprofitable ASINs