Vantage Analytics: How Much Stock Is the Right Amount?
Vantage Analytics distributes B2B SaaS products across India. One SKU family accounts for a disproportionate share of complaints.
Demand averages 1730 units a week with a standard deviation of 709 units. Replenishment lead time is 9 weeks and has itself been slipping. Each unit costs ₹1047 to buy and carries at roughly 21% a year once warehousing, insurance and capital are counted. Gross margin is 37%.
The line currently stocks out about 15% of weeks. Sales say every stockout sends a customer to a competitor. Finance say inventory is already too high.
demand
- weekly mean units
- 1730
- weekly std dev units
- 709
- coefficient of variation
- 0.41
supply
- lead time weeks
- 9
- lead time reliability
- deteriorating
economics
- unit cost
- 1047
- gross margin pct
- 37
- annual holding cost pct
- 21
derived hints
- mean demand over lead time units
- 15570
- demand std dev over lead time units
- 2127
current performance
- service level pct
- 85
Advise the operations director. Your answer should provide:
- Analysis — the reorder point and safety stock implied by the demand and lead time, and what each service level costs.
- Risks — where the assumptions break, especially lead time variability.
- Recommendation — a target service level and stock policy, with the cash impact.
State any assumptions you make.
80 points, 60% to pass.
- recommendation20
- market analysis15
- risk assessment20
- financial analysis25
Reveal suggested structure
Reorder point = mean demand over lead time + z x std dev over lead time. Trade the holding cost of safety stock against lost margin on stockouts.