Project Overview

Developed a portfolio performance and inventory strategy analysis framework for Cinagro under Evenflow Brands to evaluate product-level profitability, inventory efficiency, replenishment planning, and growth opportunities using Amazon operational data.

The project focused on identifying operational inefficiencies across the product portfolio while improving inventory allocation, replenishment logic, and working capital utilization.

The analysis combined:

• Marketplace portfolio analytics
• Inventory health evaluation
• Revenue concentration analysis
• Product rationalization frameworks
• Purchase order planning
• Growth opportunity assessment

The final solution was structured as a strategic business analysis presentation designed for portfolio optimization and operational decision-making.

Problem Statement

Marketplace-driven consumer brands often struggle with inefficient inventory allocation, slow-moving SKUs, working capital lock-in, and unclear portfolio prioritization.

Cinagro's product portfolio required structured analysis to:

• Evaluate product-level profitability and commission economics
• Identify inventory inefficiencies and stock-out risks
• Improve replenishment and purchase order planning
• Reduce capital lock-in in low-performing SKUs
• Identify portfolio rationalization opportunities
• Recommend scalable growth opportunities within existing product categories

The challenge was to build a data-driven portfolio optimization framework capable of improving operational efficiency while supporting future marketplace growth.

Goal

The objective of this project was to:

• Analyze portfolio-level business performance using Amazon operational data
• Evaluate retailer commission structures and pricing consistency
• Identify high-performing and underperforming ASINs
• Optimize inventory replenishment logic and PO planning
• Improve working capital efficiency through SKU rationalization
• Recommend scalable product expansion opportunities
• Deliver strategic recommendations using structured marketplace analytics

Tools & Technologies Used

• Microsoft Excel
• Microsoft PowerPoint
• Amazon Marketplace Data Analysis
• Inventory Planning Frameworks
• Business Portfolio Analysis
• Working Capital Optimization
• SKU Performance Evaluation
• Demand Forecasting Logic
• Strategic Business Analysis

What I Did

Conducted Portfolio Commission Analysis

Analyzed portfolio-wide retailer commission economics using Amazon operational data.

Built a revenue-weighted commission framework by:

• Normalizing ASP values
• Calculating commission percentages across ASINs
• Comparing commission consistency across the portfolio
• Identifying economically meaningful deviations

The analysis revealed a tightly standardized commission structure across high-revenue SKUs, indicating stable pricing governance.

Performed ASIN-Level Performance Evaluation

Built structured ASIN analysis frameworks to identify:

High-Performance Products

• High Daily Run Rate (DRR) products
• Fast-moving inventory
• Revenue-driving SKUs
• Predictable demand patterns

Operational Risk Products

• Zero or low DRR inventory
• Excess inventory cover
• Capital lock-in risk
• Obsolescence exposure

This analysis highlighted how a small number of fast-moving SKUs drove the majority of portfolio performance.

Designed Inventory Replenishment Logic

Created inventory planning and purchase order frameworks using:

• DRR-based demand forecasting
• Inventory cover calculations
• Product movement segmentation
• Working capital prioritization

Defined replenishment logic such as:

• 30-day inventory targets for fast-moving SKUs
• 60-day inventory targets for slow-moving SKUs
• Zero replenishment for dead inventory

Calculated representative purchase order quantities using demand-driven inventory planning models.

Built Portfolio Rationalization Framework

Developed SKU discontinuation and rationalization criteria based on:

• Near-zero demand
• High inventory cover
• Low strategic importance
• Working capital inefficiency

Recommended:

• Replenishment freezes for dead SKUs
• Inventory liquidation strategies
• Capital reallocation toward fast-moving products

The framework focused on improving cash flow efficiency without negatively impacting overall revenue.

Conducted Competitive & Market Analysis

Researched and analyzed:

Indian Brand Aggregators

• Mensa Brands
• GlobalBees
• UpScalio
• GOAT Brand Labs
• 10Club

Global Marketplace Aggregators

• Thrasio
• Razor Group
• SellerX
• Perch

Positioned the analysis around competitive operational scale and marketplace portfolio management.

Proposed Product Expansion Opportunities

Recommended new product opportunities aligned with:

• Existing successful product categories
• Cross-selling potential
• Marketplace demand patterns
• Portfolio depth expansion
• Average order value growth

Focused on low-risk expansion opportunities that leveraged existing marketplace positioning and operational capabilities.

Key Areas Analyzed

Challenges & Learnings

Challenges

• Balancing inventory availability with working capital efficiency
• Identifying economically meaningful performance deviations across SKUs
• Designing replenishment systems using operational marketplace data
• Distinguishing strategic inventory from dead inventory
• Structuring concise strategic recommendations from large operational datasets

Learnings

• Developed stronger understanding of marketplace portfolio management and inventory strategy
• Learned how a small number of SKUs often drive disproportionate business performance
• Improved skills in inventory planning and demand-driven replenishment logic
• Gained practical exposure to working capital optimization in e-commerce businesses
• Understood how inventory inefficiency directly impacts cash flow and operational scalability
• Strengthened analytical thinking around portfolio rationalization and category expansion strategy

Result / Outcome

Successfully developed a structured marketplace portfolio and inventory optimization framework capable of:

• Identifying high-value and low-performing SKUs
• Improving replenishment planning logic
• Reducing working capital inefficiencies
• Supporting inventory rationalization decisions
• Improving portfolio-level operational visibility
• Recommending scalable product expansion opportunities

The final solution combined:

• Marketplace analytics
• Inventory strategy
• Operational reasoning
• Working capital management
• Strategic business analysis

The project strengthened expertise in:

• E-commerce Operations
• Inventory Strategy
• Marketplace Analytics
• Portfolio Management
• Working Capital Optimization
• Demand Planning
• SKU Rationalization
• Business Strategy
• Operational Analysis

Skills Demonstrated

• Inventory Planning
• Marketplace Analytics
• Portfolio Optimization
• Demand Forecasting
• Working Capital Analysis
• Business Strategy
• E-commerce Operations
• Data Interpretation
• Operational Decision Making
• Excel-Based Analysis
• Strategic Problem Solving
• Executive Presentation Design