Skip to content

Business Excel & Job Interview Challenges · Exercise 5 of 10 · Excel for work · Advanced · 30 min · Premium

Inventory Risk Assessment

Assess stock risk from days of cover: flag items about to run out, spot overstock and dead stock, and measure the money tied up in excess inventory.

What you will practise: Turn stock and demand into days of cover, classify items into risk bands from thresholds in cells, and total the capital tied up in excess stock.

Premium

This is a Premium exercise

Premium members can open this exercise and practise it in the spreadsheet.

Open exerciseNot a member? See Premium plans