Service Fees: Revenue per Service, Contribution per Staff Hour and Service Hours with SUMPRODUCT
This lesson is part of the course
In this lesson
You price five fictional service types by month and by staff hour, add up the staff hours they use and find the pooled contribution per hour.
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