Amazon Profit Analyzer

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

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

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

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

## 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:**

**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)
- **Maturity Phase (12+ months):** [X]% margin (optimized operations)
- **Decline Phase:** [X]% margin (harvest strategy needed)

**Portfolio Performance Matrix:**
| Product | Revenue | Margin | Volume | Strategic Action |
|---------|---------|--------|--------|------------------|
| [Product A] | $[Amount] | [X]% | High | Scale and optimize |
| [Product B] | $[Amount] | [X]% | Medium | Improve margins |
| [Product C] | $[Amount] | [X]% | Low | Consider discontinuation |

### Action Plan & Implementation

**Priority 1: Immediate Actions (This Week)**
- [ ] Optimize FBA packaging to reduce fulfillment fees
- [ ] Adjust PPC bids on unprofitable keywords (ACoS >[X]%)
- [ ] Review and remove aged inventory to avoid long-term storage fees
- [ ] Test pricing adjustment on low-margin products

**Priority 2: Short-term Initiatives (Next 30 days)**
- [ ] Implement enhanced product descriptions to reduce returns
- [ ] Launch negative keyword campaigns to improve ad efficiency  
- [ ] Negotiate better COGS terms with top suppliers
- [ ] Set up automated repricing rules for margin protection

**Priority 3: Medium-term Strategy (Next 90 days)**
- [ ] Develop higher-margin product variations or bundles
- [ ] Optimize inventory management to reduce carrying costs
- [ ] Implement advanced advertising strategies (DSP, video ads)
- [ ] Establish performance monitoring dashboard for ongoing optimization

### ROI Projections

**Expected Improvements (90-day projection):**
- **Fee Optimization:** $[Amount] monthly savings
- **Pricing Strategy:** $[Amount] additional monthly profit  
- **Advertising Efficiency:** $[Amount] monthly improvement
- **Operational Costs:** $[Amount] monthly reduction
- **Total Monthly Impact:** $[Amount] ([X]% profit increase)

**Investment Required vs Return:**
- **Implementation Cost:** $[Amount] (time + tools + potential testing losses)
- **Monthly Profit Improvement:** $[Amount] 
- **Payback Period:** [X] months
- **12-month ROI:** [X]% return on optimization investment

### Monitoring & Tracking Framework

**Weekly KPIs to Monitor:**
- Net profit margin (target: >[X]%)
- ACoS performance (target: <[X]%)  
- Return rate (target: <[X]%)
- Inventory turnover rate
- Break-even unit sales volume

**Monthly Deep-dive Analysis:**
- Complete P&L breakdown with trend analysis
- Fee structure changes and impact assessment
- Competitive pricing and margin analysis
- New optimization opportunities identification

**Quarterly Strategic Review:**
- Portfolio profitability rebalancing
- Market expansion opportunities assessment
- Long-term pricing strategy evaluation
- Investment priorities and resource allocation

### Next Actions
- [ ] Implement immediate fee optimization opportunities identified
- [ ] Test recommended pricing adjustments with A/B testing approach
- [ ] Optimize advertising campaigns based on profit contribution analysis
- [ ] Establish ongoing profit monitoring and reporting system
- [ ] Review supplier agreements and negotiate improved terms where possible