Staffing per Hour: Workload Hours, Assistants Needed by Band with ROUNDUP and Items per Staff Hour
This lesson is part of the course
In this lesson
You turn the items and baskets of each hour band into workload hours, round up to the assistants needed, flag short bands and measure items per staff hour for the day.
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