Amazon Profit Analyzer

"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