amazon-profit-analyzer

# Amazon Profit Analyzer 💰

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

## Installation

```bash
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 t