Community Pharmacy Business Economics: Prescriptions per Day, Dispensing Margins, Front-Shop Sales, Service Fees, Staffing per Hour & Break-Even
Run the business side of a local pharmacy. You will track prescription volumes by day and hour, compute margins per item under fictional fee rules, add front-shop sales and service fees, plan pharmacist and assistant hours against demand, review stock days and find the break-even volume, all administrative and with every cell checked as you go.
One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.
About this course
This course covers the administrative and business side of a fictional community pharmacy, with no clinical content. You count prescription items by day and hour band with SUMIFS and COUNTIFS, look up an invented fee rule with XLOOKUP to get the margin per item, and measure front-shop margin %, average basket value and attach rate. You rank services by contribution per staff hour with SUMPRODUCT, plan assistants per hour band with ROUNDUP, work out days of stock and age slow movers with IFS, allocate running costs to a cost per item and finish with break-even items per day, headroom and a chart.
Lessons
- Prescription Volumes: Items per Day, Items per Form & Busy Hour Bands with SUMIFS and COUNTIFS Pro
- Dispensing Margins: Purchase Cost, Margin on Cost and a Fixed Fee per Item with XLOOKUP Pro
- Front-Shop Sales: Margin by Category, Average Basket Value and the Attach Rate Pro
- Service Fees: Revenue per Service, Contribution per Staff Hour and Service Hours with SUMPRODUCT Pro
- Staffing per Hour: Workload Hours, Assistants Needed by Band with ROUNDUP and Items per Staff Hour Pro
- Stock Days & Slow Movers: Days of Stock, Days Since Last Sale and Ageing Buckets with IFS Pro
- Running Costs: Rent, Staff, Systems & Delivery, the Cost per Item and the Staff Share Pro
- Break-Even & Dashboard: Contribution per Item, Break-Even Items per Day, Headroom and a Chart Pro