Universal Indane: Managing Inventory Flows and Beyond Custom Case Solution & Analysis

1. Evidence Brief: Case Extraction

Financial Metrics

• Gross Margin: Fixed commission per cylinder set by the Oil Marketing Company (OMC). Domestic refill commission is approximately 61.84 Indian Rupees (INR) per cylinder.
• Security Deposits: Significant liability held for customer cylinders and regulators, totaling millions of INR across the 12,000+ customer base.
• Working Capital: High turnover requirement; inventory must be paid for at the time of loading at the bottling plant.
• Operational Costs: Delivery vehicle maintenance, fuel, and labor represent 70% of total operating expenses.

Operational Facts

• Customer Base: 12,500 domestic households and 450 commercial entities (restaurants, small industries).
• Delivery Lead Time: Current average is 48 to 72 hours from booking to delivery.
• Fleet Size: 12 delivery vehicles (three-wheelers and small trucks) operating within a 15-kilometer radius.
• Storage Capacity: Strictly regulated by the Petroleum and Explosives Safety Organization (PESO). Maximum on-site storage is capped at 500 filled cylinders.
• Supply Source: Indian Oil Corporation Limited (IOCL) bottling plant located 45 kilometers from the distribution point.

Stakeholder Positions

• Sanjay Gupta (Owner): Focused on maintaining the 48-hour delivery promise while minimizing the cost of idle delivery staff.
• IOCL (Supplier): Operates on a push-pull system; demands strict adherence to safety protocols and digital booking records.
• Domestic Customers: High sensitivity to stockouts; prone to panic-booking during winter months or subsidy policy changes.
• Delivery Staff: Paid on a per-delivery basis; high turnover rate due to the physical nature of the work.

Information Gaps

• Demand Variance: Precise daily standard deviation of refill bookings is not provided.
• Competitor Benchmarking: Delivery times and service levels of Bharat Gas or HP Gas distributors in the same territory are absent.
• Customer Retention: Data on the rate of customers switching to piped natural gas (PNG) alternatives.

2. Strategic Analysis

Core Strategic Question

• How can Universal Indane optimize its inventory replenishment cycle to eliminate the 15% peak-period stockout rate while remaining within PESO storage constraints?
• How can the firm transition from reactive booking-based delivery to a predictive replenishment model?

Structural Analysis

Inventory Management Framework: The bottleneck is not capital but physical space. The PESO limit of 500 cylinders creates a hard ceiling. With a daily demand of 350-400 cylinders during peak periods, the safety stock is effectively less than half a day of operations. This necessitates a high-frequency, low-volume replenishment strategy from the bottling plant.

Value Chain Analysis: The primary value driver is the last-mile delivery. Inbound logistics (bottling plant to godown) is currently inefficient due to poor synchronization between booking spikes and truck dispatch. Outbound logistics suffers from route overlaps and empty-trip returns.

Strategic Options

Preliminary Recommendation

Implement Predictive Refill Scheduling combined with a milk-run replenishment model. By analyzing the average 45-day cycle of domestic users, Universal Indane can flatten the demand curve. This reduces the pressure on the 500-cylinder storage limit and allows for consistent, pre-planned inbound logistics from the IOCL plant.

3. Operations and Implementation Planner

Critical Path

• Week 1-4: Data Cleaning. Segment the 12,500 customers by consumption frequency (30-day, 45-day, and 60-day cycles).
• Week 5-8: Pilot Predictive Booking. Contact the top 1,000 frequent users 48 hours before their predicted empty date to secure bookings.
• Week 9-12: Replenishment Synchronization. Contract a dedicated transport carrier for two daily trips from the bottling plant, regardless of load size, to maintain a constant flow.

Key Constraints

• PESO Storage Compliance: Any attempt to buffer against supply shocks is limited by the 500-unit legal cap. Overstocking invites heavy fines or license cancellation.
• Labor Availability: The per-delivery payment model fails during low-demand periods, leading to staff attrition. A hybrid fixed-plus-variable pay structure is required to stabilize the workforce.

Risk-Adjusted Implementation Strategy

The strategy assumes a 90% accuracy rate in predictive modeling. To mitigate the 10% error margin, a rolling buffer of 50 cylinders must be reserved exclusively for emergency domestic bookings. Implementation will follow a phased geographic rollout, starting with the highest-density neighborhoods to maximize delivery density per kilometer.

4. Executive Review and BLUF

BLUF

Universal Indane must shift from reactive fulfillment to a predictive replenishment model. The current 48-hour delivery promise is unsustainable during peak demand due to the 500-cylinder PESO storage ceiling. By utilizing consumption analytics to prompt customer bookings, the firm can smooth demand spikes, optimize vehicle utilization, and maintain service levels without physical expansion. This transition is the only path to protecting margins in a price-controlled environment.

Dangerous Assumption

The analysis assumes that the IOCL bottling plant can provide perfectly elastic supply. If the bottling plant faces its own production bottlenecks or transport strikes, the predictive booking system will create a backlog of frustrated customers who were promised delivery based on an algorithm rather than physical inventory.

Unaddressed Risks

• Regulatory Risk: Sudden changes in the Direct Benefit Transfer for LPG (DBTL) subsidy levels can trigger massive, unpredictable booking surges that override predictive models (High Probability, High Consequence).
• Substitution Risk: Expansion of Piped Natural Gas (PNG) infrastructure in the 15-kilometer radius could cannibalize the high-volume domestic segment (Medium Probability, High Consequence).

Unconsidered Alternative

The team did not evaluate a Joint Venture or inventory-sharing agreement with a neighboring Indane distributor. A mutual-aid pact for inventory borrowing during local stockouts could provide a safety valve for the 500-unit storage constraint without requiring capital expenditure or regulatory filings.

VERDICT: APPROVED FOR LEADERSHIP REVIEW