Home › Excel case studies › Inventory & Stockout Risk Analysis
Inventory & Stockout Risk Analysis
Fernwood Grocers' ops team is worried about running out of popular items across their 3 stores. The raw inventory export has inconsistent category names, duplicate rows, and a store field that's sometimes blank. Practice identifying stockout risk, cross-referencing supplier lead times, and ranking product performance. **What you'll learn:** - Threshold-based risk flagging - Multi-table lookups against a supplier reference sheet - Cross-store aggregation - Ranking product performance
Open this Excel case study
Work on a realistic business scenario for data analytics and business analytics practice. See the full details and get the assignment on Cellgrids.
View case study → Free Excel formula practiceAll Excel case studies · Excel interview prep · Excel formulas