Stock Days & Slow Movers: Days of Stock, Days Since Last Sale and Ageing Buckets with IFS
This lesson is part of the course
In this lesson
You measure how many days of sales the stock covers per group, age ten slow-moving stock lines by their last sale, sort them into buckets and total the value tied up for over 90 days.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Prescription Volumes: Items per Day, Items per Form & Busy Hour Bands with SUMIFS and COUNTIFS Locked
- Dispensing Margins: Purchase Cost, Margin on Cost and a Fixed Fee per Item with XLOOKUP Locked
- Front-Shop Sales: Margin by Category, Average Basket Value and the Attach Rate Locked
- Service Fees: Revenue per Service, Contribution per Staff Hour and Service Hours with SUMPRODUCT Locked
- Staffing per Hour: Workload Hours, Assistants Needed by Band with ROUNDUP and Items per Staff Hour Locked
- Stock Days & Slow Movers: Days of Stock, Days Since Last Sale and Ageing Buckets with IFS Locked
- Running Costs: Rent, Staff, Systems & Delivery, the Cost per Item and the Staff Share Locked
- Break-Even & Dashboard: Contribution per Item, Break-Even Items per Day, Headroom and a Chart Locked