Beginner level · Module 5: Business Analytics Cases · Lesson 3 of 3
Inventory Case and Project Completion
Analyse stock-outs and overstock, then complete the level project.
In this lesson you will
- Analyse inventory performance with simple metrics
- Complete and present the level project
Key concepts
stock-outsoverstockstock daysproject presentation
The lesson
A pharmacy runs out of fast-moving medicines while slow items expire on shelves. Simple metrics — days of stock, stock-out days, expired value — show where the problem is.
Compare demand patterns with ordering patterns to find causes, such as ordering the same quantity every month regardless of sales.
Then finish your own KPI framework and performance review, and present it with a clear headline and recommendations.
Step by step
- Calculate days of stock for key items.
- Identify stock-outs and expiries.
- Recommend ordering changes.
- Complete and present the level project.
Practice activity
Complete and present the KPI Framework and Performance Review.
Expected result: A complete project presented with a clear headline and actionable recommendations.
Check your understanding
-
What does 'days of stock' measure?
Show answer
How many days current stock will last at the current rate of use.
-
What causes stock-outs and expiries at the same time?
Show answer
Ordering that does not match actual demand for each item.
Taught live by an instructor — online or in person. Free course lessons are for self-study and do not lead to a certificate — see registration options.