Amazon Profit Analyzer

Amazon Profit Analyzer 💰

Complete profit analysis and optimization framework for Amazon sellers. Uncover true profitability and maximize margins.

Installation

npx skills add nexscope-ai/Amazon-Skills --skill amazon-profit-analyzer -g

Usage Examples

Comprehensive profit analysis:

"Analyze profitability of my yoga mat: $34.99 selling price, $8 COGS, $400/month PPC spend, 15% ACoS, 5% return rate"

Portfolio profitability review:

"Review profit margins across my entire product catalog - need to identify underperformers and optimization opportunities"

Fee structure optimization:

"Break down all Amazon fees for my electronics category - where can I optimize costs and improve margins?"

Core Capabilities

1. Revenue Waterfall Analysis

• Complete revenue breakdown from gross sales to net profit
• Detailed fee structure analysis and hidden cost identification
• Margin calculation with advertising cost impact assessment
• Return and refund cost analysis with seasonal variations

2. Profitability Assessment & Benchmarking

• True profit margin calculation including all costs and fees
• Category-specific profitability benchmarking and competitive analysis
• Product-level and portfolio-level performance evaluation
• ROI analysis with investment recovery timeline assessment

3. Optimization Strategy Development

• Fee reduction opportunities and cost optimization strategies
• Pricing strategy recommendations for margin improvement
• Advertising spend optimization and ACoS target refinement
• Operational efficiency improvements and automation opportunities

How It Works

Step 1: Revenue & Cost Analysis

Comprehensive profit and loss breakdown with fee analysis

Analyze complete financial picture:

• Calculate gross revenue from sales data including seasonal variations and promotional impact
• Identify and quantify all Amazon fees including referral fees, FBA fees, storage costs, and advertising spend
• Analyze cost of goods sold (COGS), shipping costs, and operational expenses
• Assess return rates, refund costs, and customer service expenses impact on profitability

Step 2: Profitability Assessment & Benchmarking

Deep-dive margin analysis and competitive positioning

Evaluate profit performance and market positioning:

• Calculate true net profit margins after all fees, returns, and operational costs
• Compare profitability against category benchmarks and competitor performance indicators
• Analyze profit trends over time including seasonal patterns and growth trajectory
• Identify high-margin products and underperforming SKUs requiring attention

Step 3: Optimization Strategy & Implementation

Actionable recommendations for margin improvement

Develop profit optimization strategies:

• Recommend pricing adjustments and fee optimization opportunities for immediate margin improvement
• Optimize advertising spend allocation and ACoS targets based on profit contribution analysis
• Identify operational efficiency improvements and cost reduction opportunities
• Create implementation roadmap with priority actions and expected ROI timeline

Output Format

## Amazon Profit Analysis Report
**Product/Portfolio:** [Product Name/Portfolio] | **ASIN(s):** [ASIN] | **Analysis Period:** [Timeframe] | **Marketplace:** [US/UK/DE/etc]

### Revenue Waterfall Analysis

**Gross Revenue Breakdown:**
- **Gross Sales Revenue:** $[Amount] (100% baseline)
- **Promotional Discounts:** -$[Amount] ([X]% of gross)
- **Returns & Refunds:** -$[Amount] ([X]% of gross, [Y]% return rate)
- **Net Revenue:** $[Amount] ([X]% of gross)

**Amazon Fee Structure:**
| Fee Type | Amount | % of Gross Revenue | Calculation Method |
|----------|--------|-------------------|-------------------|
| Referral Fee | $[Amount] | [X]% | [Y]% of item price |
| FBA Fulfillment Fee | $[Amount] | [X]% | Based on size/weight tier |
| Monthly Storage Fee | $[Amount] | [X]% | $[X] per cubic foot |
| Long-term Storage Fee | $[Amount] | [X]% | $[Y] per cubic foot (12+ months) |
| Removal/Disposal Fee | $[Amount] | [X]% | [Z] units removed |
| **Total Amazon Fees** | **$[Amount]** | **[X]%** | **Combined impact** |

**Advertising & Marketing Costs:**
- **PPC Advertising Spend:** $[Amount] ([X]% ACoS, [Y]% of revenue)
- **Sponsored Brand/Display:** $[Amount] ([X]% of total ad spend)
- **External Marketing:** $[Amount] (social media, influencers, etc.)
- **Total Marketing Investment:** $[Amount] ([X]% of revenue)

**Cost of Goods & Operations:**
- **COGS (Cost of Goods Sold):** $[Amount] ([X]% of revenue)
- **Inbound Shipping:** $[Amount] ([X]% of revenue)
- **Packaging & Prep:** $[Amount] (per unit cost: $[X])
- **Inventory Financing Cost:** $[Amount] ([X]% carrying cost)
- **Total Direct Costs:** $[Amount] ([X]% of revenue)

### True Profitability Assessment

**Net Profit Calculation:**

Gross Revenue: $[Amount]

• Amazon Fees: $[Amount]
• Advertising Costs: $[Amount]
• Direct Costs (COGS): $[Amount]
• Operating Expenses: $[Amount]

= NET PROFIT: $[Amount] ([X]% margin)

**Profitability Metrics:**
- **Net Profit Margin:** [X]% (Industry benchmark: [Y]%)
- **ROI (Return on Investment):** [X]% (Target: >20%)
- **ROAS (Return on Ad Spend):** [X]:1 (Break-even: [Y]:1)
- **Contribution Margin:** $[Amount] per unit after variable costs
- **Break-even Point:** [X] units per month to cover fixed costs

**Category Benchmarking:**
| Metric | Your Performance | Category Average | Top 25% Performers |
|--------|------------------|------------------|-------------------|
| Net Margin | [X]% | [Y]% | [Z]% |
| ACoS | [X]% | [Y]% | [Z]% |
| Return Rate | [X]% | [Y]% | [Z]% |
| Inventory Turnover | [X]x/year | [Y]x/year | [Z]x/year |

### Profit Optimization Opportunities

**Immediate Improvements (0-30 days):**

**1. Fee Optimization - Potential savings: $[X]/month**
- **FBA Fee Reduction:** Optimize packaging dimensions to reduce size tier
  - Current: [Size tier] → Target: [Lower tier] = $[X] savings per unit
- **Storage Cost Management:** Reduce excess inventory aging
  - Current: [X] months supply → Target: [Y] months = $[Z] monthly savings
- **Return Rate Reduction:** Improve product quality/descriptions
  - Current: [X]% → Target: [Y]% = $[Z] monthly savings

**2. Pricing Strategy Optimization - Revenue impact: $[X]/month**
- **Price Point Analysis:** Test optimal pricing for margin maximization
  - Current: $[Price] → Recommended: $[New Price] 
  - Expected volume impact: [X]% change in units
  - Net margin improvement: $[Amount] per unit

**Medium-term Improvements (1-3 months):**

**3. Advertising Optimization - Profit impact: $[X]/month**
- **ACoS Target Refinement:** Optimize ad spend for profit contribution
  - Current ACoS: [X]% → Target ACoS: [Y]% 
  - Maintain profitability while scaling: Target ROAS [X]:1
- **Campaign Structure:** Reallocate budget to high-performing campaigns
  - Reduce spend on keywords with ACoS >[X]%
  - Increase spend on profitable keywords with room to scale

**4. Operational Efficiency - Cost reduction: $[X]/month**
- **COGS Optimization:** Negotiate better supplier terms or find alternatives
  - Current: $[Amount] → Target: $[Amount] = $[Savings] per unit
- **Shipping Optimization:** Consolidate shipments and optimize logistics
  - Potential savings: [X]% of inbound shipping costs

### Advanced Profit Analysis

**Seasonal Profitability Patterns:**
| Month | Revenue | Net Margin | Key Factors |
|-------|---------|------------|-------------|
| Q1 | $[Amount] | [X]% | [Post-holiday returns, lower demand] |
| Q2 | $[Amount] | [X]% | [Spring category trends] |
| Q3 | $[Amount] | [X]% | [Summer demand, inventory prep] |
| Q4 | $[Amount] | [X]% | [Holiday season, higher ad costs] |

**Product Lifecycle Profitability:**
- **Launch Phase (0-3 months):** -[X]% margin (investment phase)
- **Growth Phase (3-12 months):** [X]% margin (scaling efficiency)