Dispensing Margins: Purchase Cost, Margin on Cost and a Fixed Fee per Item with XLOOKUP
This lesson is part of the course
In this lesson
You look up a fictional fee rule for eight stock lines, work out the margin per item and per month, and find the pooled margin per item the pharmacy earns on dispensing.
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