Executive Summary
In this scenario, a seller generates ₹30,00,000 monthly revenue with a 40% gross margin. Unit modeling reveals one product line bleeding ₹2,10,000 monthly from return logistics and ad spend.
Situation: Who This Looks Like
Typical Brand Profile
Growing seller with 20+ active SKUs across home, apparel, or electronics
The business owner monitors accounting statements showing ₹30,00,000 in monthly sales, assuming every product line contributes reasonably to profit. However, settlement statements bundle commissions, weight surcharges, return fees, and ad costs into a single net payout. Without SKU-level modeling, marketing budgets continue funding products that lose money on every unit delivered.
Common Diagnostic Triggers
- Aggregate sales hit record highs, but monthly bank deposits remain disappointing
- Categories carry 4% to 22% returns, but marketing applies identical ROAS targets
- Weight handling fees creep up when packaging crosses volumetric boundaries
- Replenishment is guided by sales velocity rather than net contribution cash
What the Data Usually Shows: Diagnostic Signals
When inspecting accounts in this situation, our strategists review settlement files, ad consoles, and search term logs. These four signals consistently identify where margin and conversion are leaking.
Hidden Volumetric Weight Surcharges
Logistics Fee ReconciliationObservation: Certain SKUs are billed at 1.5kg volumetric weight instead of their 450g physical weight due to oversized packaging boxes.
Implication: The seller pays ₹65 extra in fulfillment fees per shipment, erasing 12% of product margin on every unit.
Disguised Return Cost Bleed
Customer Return & Reverse Shipping Fee AuditObservation: A popular SKU line experiences a 22% return rate. Each return incurs reverse shipping and repackaging write-offs.
Implication: The SKU requires 4 profitable sales just to break even on a single returned and damaged unit.
Misallocated Advertising Budgets
Ad Spend to Margin RatioObservation: Campaign managers allocate 40% of monthly ad spend to SKU Gamma because of strong click volume.
Implication: Ad spend actively accelerates losses on a product that has negative unit contribution economics.
Commission Category Misclassification
Marketplace Referral Fee VerificationObservation: Items listed under a secondary category pay a 17% referral fee instead of the appropriate 12% rate.
Implication: A 5 percentage point fee overcharge is silently deducted on every order.
Our Approach Step by Step
Growth requires disciplined sequence. We avoid making ad bid changes before catalog indexing is sound, and we never scale ad spend on unverified unit economics. Here is our sequential execution roadmap:
Ingest and Reconcile Settlement Reports
We extract settlement reports from marketplace portals, isolating commissions, closing fees, shipping surcharges, and taxes down to individual Order IDs.
Key Deliverables:
- Granular fee reconciliation mapping all marketplace deduction lines
- Volumetric dimension audit comparing physical measurements to billed weight
- Referral fee rate verification against official category schedules
Build the SKU-Level Contribution P&L Engine
We combine COGS, packaging costs, marketplace fees, return write-offs, and ad spend to establish the exact net contribution profit for every SKU.
Key Deliverables:
- SKU contribution scorecard classifying items into Profit, Breakeven, and Bleed
- Reverse logistics and return cost allocation by SKU
- Break-even ROAS threshold calculated for every individual product
Pause Bleeding SKUs & Recalibrate Packaging
We pause ad spend on negative-margin SKUs, adjust packaging dimensions to drop volumetric weight tiers, and dispute fee overcharges.
Key Deliverables:
- Immediate pausing of ad campaigns on negative-margin products
- Packaging redesign specifications reducing volumetric shipping tiers
- Documentation recovering historical volumetric weight overcharges
Reallocate Ad Budgets to High-Contribution Champions
We redirect marketing focus toward high-margin hero SKUs, ensuring spend compounds bottom-line cash rather than vanity top-line volume.
Key Deliverables:
- Restructured advertising allocation focusing capital on top contributors
- Automated monthly SKU contribution margin tracking model
- Inventory reorder framework prioritized by net cash contribution
Worked Numeric Example: Operational Economics
Illustrative Scenario: Uncovering a Loss-Making SKU Line on ₹30L Revenue
This hypothetical scenario illustrates how three product lines (Alpha, Beta, Gamma) generating ₹30,00,000 monthly revenue performed after establishing true SKU-level contribution margin clarity.
| Operational Metric | Baseline Model | Post-Intervention | Operational Note |
|---|---|---|---|
| SKU Alpha Revenue (50% share) | ₹15,00,000 | ₹16,00,000 | Solid 29.67% net margin hero |
| SKU Beta Revenue (33.3% share) | ₹10,00,000 | ₹10,00,000 | Stable 18.00% net margin contributor |
| SKU Gamma Revenue (16.7% share) | ₹5,00,000 | ₹0 ad-driven sales | Negative -42.00% margin bleeder! |
| Total Company Revenue | ₹30,00,000 | ₹26,00,000 | Selective trimming of unprofitable volume |
| Total Company Ad Spend | ₹6,00,000 | ₹4,00,000 | Eliminated ₹2.5L spend on Gamma, reallocated ₹50K to Alpha |
| SKU Gamma Net Contribution | -₹2,10,000 (Loss) | ₹0 (Ad spend stopped) | Eliminated ₹2.1L monthly cash drain |
| Total Company Net Contribution | ₹4,15,000 (13.83%) | ₹6,55,000 (25.19%) | +₹2,40,000 net monthly profit increase (+57.8%) |
Specific Modeling Interventions Applied:
- Calculated SKU-level P&L including COGS, fees, returns, and direct ad spend.
- Found SKU Gamma lost ₹2,10,000 monthly due to 22% returns and ₹2.5L ad spend.
- Paused ad spend on SKU Gamma and reallocated ₹50,000 to SKU Alpha.
- Redesigned SKU Alpha packaging, cutting volumetric weight from 1.0kg to 500g.
Mathematical Reconciliation & Logic:
Baseline: Revenue was ₹30L. Alpha produced ₹15L (+₹4.45L profit). Beta produced ₹10L (+₹1.8L profit). Gamma produced ₹5L with 22% returns, generating a -₹2.1L loss.
Company Baseline: Aggregate net profit was ₹4,15,000 (13.83% margin). Gamma was actively erasing over half of Beta's earnings.
Outcome: Pausing Gamma ads eliminated the loss. Reallocating ₹50K to Alpha lifted net profit to ₹6,55,000 (+₹2.4L lift, 25.19% margin) on ₹26L revenue.
* Illustrative scenario for educational modeling only. All numbers reflect internal unit-economic formulas, not guaranteed or historical client results.
What We Would Measure & How Often
Sustainable marketplace management requires clear metrics reviewed on defined cadences with pre-agreed action thresholds:
| Metric & Area | Cadence | Target Operating Range | Pre-Set Decision Rule |
|---|---|---|---|
| Weekly SKU Net Contribution Margin | Weekly | Promoted SKU net CM >= 15% | Flag and pause advertising on any SKU showing negative 7-day contribution. |
| Return Rate by SKU | Weekly | Return rate <= 8.0% | Inspect product quality and listing attributes if returns exceed 10%. |
| Marketplace Fee Audit | Monthly | Target: verify fee accuracy against official rate cards | File marketplace dispute tickets when volumetric weight billing errors occur. |
| Inventory Capital Prioritization | Monthly | 80% of reorder capital allocated to Tier-1 SKUs | Deprioritize manufacturing purchase orders for low-contribution SKUs. |
What We Need From You (Prerequisites & Files)
To perform a diagnostic assessment or manage a similar engagement, we operate through read-only secondary permissions and standard business files. We never ask for master login credentials:
Cost Data
- Unit-level landed bill of materials / manufacturing cost for active SKUs
- Inbound freight and packaging cost per unit
Marketplace Reports
- Historical 90-day settlement transaction files (.csv or .tsv)
- Return reports and customer feedback disposition files
Catalog Specifications
- Product packaging dimension measurements (L x W x H) and deadweight
Related Services & Solutions
Explore the specific service programs and solutions referenced in this worked scenario:
Facing this bottleneck in your marketplace store?
Connect with our team for an initial, no-obligation discovery call. We review your catalog metrics, identify fee and advertising leaks, and deliver a clear diagnostic roadmap.
Scope and proposal are shared after the first call · We treat your business data as confidential