Break-Even & Dashboard: Contribution per Item, Break-Even Items per Day, Headroom and a Chart
This lesson is part of the course
In this lesson
You bring the pharmacy's numbers together: contribution per item, the items per day needed to break even after the shop and services, the October headroom and a chart of items per 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