Agrawal Kitchenware Distributors: A Miscellany of Inventory Problems Custom Case Solution & Analysis

1. Evidence Brief: Case Extraction

Financial Metrics

• Inventory Holding Cost: Estimated at 18-24 percent annually, including capital costs, insurance, and warehouse space.
• Working Capital: Significant portion of Agrawal Kitchenware Distributors (AKD) capital is locked in slow-moving inventory, specifically in the non-stick cookware and specialty appliance categories.
• Revenue Concentration: Approximately 70 percent of revenue is generated by 20 percent of the product portfolio, primarily pressure cookers and basic gas stoves.
• Purchase Discounts: Manufacturers offer tiered discounts of 2 to 5 percent for bulk orders exceeding 500 units per shipment.

Operational Facts

• Product Range: AKD manages over 1200 Stock Keeping Units (SKUs) across 15 different kitchenware categories.
• Lead Times: Variability ranges from 5 days for local suppliers to 21 days for major manufacturers located in South India.
• Ordering Process: Orders are currently placed weekly based on visual inspection of warehouse shelves and historical memory of the sales team.
• Geography: Central distribution hub located in Nagpur, serving a 300-kilometer radius including rural and semi-urban retail outlets.
• Storage: 15000 square feet of warehouse space currently operating at 95 percent capacity, leading to significant material handling inefficiencies.

Stakeholder Positions

• Mr. Agrawal (Owner): Prioritizes sales growth and maintaining high service levels to avoid losing retailers to competitors.
• Warehouse Manager: Concerned with physical congestion and the difficulty of locating high-demand items amidst slow-moving stock.
• Retailer Network: Demanding 24-hour fulfillment and threatening to switch distributors if stockouts on core items continue.
• Manufacturers: Pushing for larger order volumes to optimize their own production schedules and logistics costs.

Information Gaps

• Stockout Costs: The specific financial impact of lost sales due to unavailability is not quantified.
• Obsolescence Rate: The percentage of inventory that is functionally dead or requires heavy discounting to move is not explicitly stated.
• Demand Seasonality: Granular monthly data for wedding seasons versus off-peak periods is missing.

2. Strategic Analysis

Core Strategic Question

• How can AKD restructure its inventory management system to eliminate stockouts of high-velocity items while reducing the capital trapped in low-turnover SKUs?

Structural Analysis

An ABC/XYZ analysis reveals a structural mismatch in AKD operations. Category A items (high value, high frequency) suffer from frequent stockouts because they are managed with the same reorder logic as Category C items (low value, low frequency). The current system is a reactive replenishment model that ignores demand variability and lead-time fluctuations.

Strategic Options

• Option 1: Segmented Inventory Policy (Recommended). Apply Economic Order Quantity (EOQ) and safety stock levels specifically to Category A items. Establish a periodic review system for Category B and a lean, just-in-time approach for Category C.
  • Rationale: Focuses management attention where 70 percent of the cash flows.
  • Trade-offs: Requires higher initial data entry and monitoring effort.
• Option 2: SKU Rationalization. Eliminate the bottom 15 percent of non-performing SKUs to free up 2000 square feet of warehouse space and 12 percent of working capital.
  • Rationale: Reduces operational complexity and improves warehouse flow.
  • Trade-offs: Potential loss of niche customers who value a wide selection.
• Option 3: Centralized Digital Replenishment. Shift from visual inspections to a software-driven Perpetual Inventory System.
  • Rationale: Removes human error and allows for predictive ordering.
  • Trade-offs: High upfront cost and training requirements for staff.

Preliminary Recommendation

AKD must adopt Option 1 immediately. The current one-size-fits-all approach is the primary driver of the cash flow crunch. By formalizing safety stock levels for high-demand items, AKD can protect its service levels while aggressively reducing the order frequency—and thus the holding costs—of slow-moving items.

3. Implementation Roadmap

Critical Path

• Phase 1 (Days 1-30): Data Cleaning and Classification. Audit all 1200 SKUs. Categorize every item based on annual consumption value (ABC) and demand predictability (XYZ).
• Phase 2 (Days 31-60): Parameter Setting. Calculate EOQ and safety stock for the top 240 SKUs (Category A). Define fixed reorder points based on maximum lead times.
• Phase 3 (Days 61-90): Vendor Alignment. Renegotiate delivery schedules with the five largest manufacturers to align with new EOQ requirements.

Key Constraints

• Data Integrity: The transition depends entirely on the accuracy of historical sales records, which are currently fragmented.
• Staff Competency: The current warehouse team lacks experience with quantitative inventory control methods.
• Supplier Rigidity: Major brands may resist smaller, more frequent delivery requests if it disrupts their logistics.

Risk-Adjusted Implementation Strategy

To mitigate execution risk, AKD will run a pilot program for 30 days focusing exclusively on the Pressure Cooker category. This category represents the highest volume and most predictable demand. Success in this pilot will provide the proof of concept needed to overcome internal resistance. Contingency: maintain a 10 percent safety stock buffer above calculated levels during the first 90 days to account for data inaccuracies.

4. Executive Review and BLUF

Bottom Line Up Front (BLUF)

AKD is facing a self-inflicted liquidity crisis. The company has sufficient capital, but it is misallocated across 1200 SKUs without regard for velocity or value. To restore profitability, AKD must immediately transition to a segmented inventory model. This requires setting automated reorder points for the 20 percent of products that drive 70 percent of revenue and liquidating the bottom 15 percent of stagnant stock. Failure to act will lead to a permanent loss of retail market share as competitors with better fulfillment capabilities move into the Nagpur region. The priority is cash velocity, not warehouse volume.

Dangerous Assumption

The analysis assumes that manufacturer lead times are stable. In the Indian kitchenware market, production cycles are often disrupted by raw material shortages or power outages. If lead times extend beyond 21 days, the proposed safety stock levels will fail, resulting in the same stockouts the plan intends to fix.

Unaddressed Risks

• Price Volatility (High Impact, Medium Probability): Steel and aluminum price spikes can render EOQ calculations obsolete overnight, as manufacturers may change minimum order quantities.
• Channel Conflict (Medium Impact, Low Probability): Aggressive SKU rationalization might alienate specific retailers who rely on AKD for a full-line offering, potentially leading them to consolidate all purchases with a competitor.

Unconsidered Alternative

The team did not evaluate a transshipment model between other regional distributors. Instead of holding all stock in Nagpur, AKD could establish a formal inventory-sharing agreement with distributors in neighboring regions to cover unexpected demand spikes for Category A items without increasing local safety stock levels.

VERDICT: APPROVED FOR LEADERSHIP REVIEW