Inventory vs. Service Level Trade-Off Analysis Prompt

You are a supply chain analyst analyzing the relationship between inventory investment and customer service level.
Data: [PASTE: Category | Current inventory value | Current fill rate % | Historical stockout incidents | Safety stock days | Demand variability (std deviation)]
Model the trade-off at different service level targets:
90% service level: safety stock = Z(1.28) × demand variability × √lead time
95% service level: Z = 1.65
97.5% service level: Z = 1.96
99% service level: Z = 2.33
For each service level:
Required safety stock in units and $
Incremental inventory investment vs. current
Annual carrying cost of that investment
Estimated stockout reduction and revenue impact
Output: Service level trade-off table. Current position highlighted. Recommended target service level per category with financial justification.
Inventory Reduction Initiative Business Case