Cost of goods is the product plus everything that touched the patient
Cost of goods for one treatment is the product used plus every consumable that touched the patient, priced from the supply invoice. For neurotoxin that is units drawn, diluent, syringes and gloves. For filler it is the syringe, the cannula or needle, numbing and gauze. For an IV it is the bag, the tubing set, the catheter, the additive by the dose drawn, and disposal. The full cost list, with time and room added, is in the unit economics guide. This page is the inventory side: where the product line on that list comes from, and how to keep it honest week to week.
Vial yield is units charted, never units on the label
A vial has a number of units on the invoice. The number that matters is units charted against it before it is discarded under the window your medical director sets. Say a vial holds 100 units on the invoice and the chart shows 84 drawn before the window closed. In this illustrative example the yield is 84 percent, and 16 units were paid for and never sold. Divide the invoice price by the units charted, and the cost per unit on the margin report is the one the practice is living with. The same arithmetic runs for a filler syringe opened and not finished, if your medical director's policy discards it.
Waste has three causes, and the log names each one
- Opened for a no-show: a vial opened for a chair that canceled, and the units unused inside the window. The fix is upstream: open against a patient in the room, not a name on the calendar.
- Drawn and not charted: units drawn that never reached the chart, because the chart was written from memory after the last patient left. The fix is charting units at the chair, before the next patient.
- Expired on the shelf: product that aged out before it was opened, because the order was sized to a promotion instead of to next month's charted usage. The fix is ordering from the count.
Each cause gets its own line on the waste log: date, product, lot, units, cause, provider. Over a month the log shows which cause is costing the money, and the fix for each is different.
Lot numbers answer the recall question in one query
Every unit that goes into a patient came from a box with a lot number on it. The operational rule is that the lot is recorded against the patient and the treatment at the chair, in the chart, at the time it is used. What the chart must hold, and for how long, is your medical director's call, with counsel; requirements vary by state. The reason to do it is the recall question. If a manufacturer recalls a lot, the practice will be asked for every patient who received it, with dates, and the question is how long that list takes to produce. A practice that tracks lots in the chart has that list in minutes. A practice that tracks lots on a receiving sheet in the back room has to read every chart from the receiving date forward. What to do with the list once you have it is your medical director's decision, with counsel.
The Friday count fills five columns
| Column | Where it comes from | What it catches |
|---|---|---|
| Bought this week | Supply invoices, by product and lot | An order placed for a promotion that never ran |
| Charted this week | Units and syringes on the chart, by provider | Units drawn and never written down |
| On hand, counted | The shelf and the fridge, counted by hand, by lot | The vial that walked, and the one that expired |
| Waste, logged | The waste log, by cause | Which cause is costing the money |
| Variance | Last week on hand, plus bought, minus charted, minus waste, minus this week on hand | Anything the other four columns did not explain |
Priya and Dana do the count every Friday before the weekend order goes in. A variance that is not zero is Monday's first question. The order comes from the count: next week's charted usage plus a reserve, minus what is on hand, oldest lot used first.
The margin report the count feeds
Cost of goods per treatment on the margin report comes from this sheet. Invoice price divided by units charted gives the cost per unit, and consumables per treatment come from the cost list. The month's waste is spread across the month's treatments on its own line. By provider, the report shows whose units drawn match whose units charted, and whose waste log is longest. By treatment, it puts the product line beside the price, so the margin the practice believes it makes on tox or filler is the margin the count supports. A margin report without the count is a price list with a guess under it.
How to start the count this Friday
- Print last month's supply invoices and write the product, lot, units and price per unit on one sheet.
- Count the shelf and the fridge by lot, and write it in the on-hand column.
- Pull units charted for the month from the record system, by provider, and write the total.
- Subtract. What is left is the month's waste and variance, priced at the invoice. Start the waste log on Monday so next month's number has causes beside it.
What to do next
NorthCore's Know your numbers solution puts the count sheet and waste log beside revenue by treatment and provider, variance on its own line; the lot-per-patient lookup stays in your record system. Results in 90 days, or we keep working until you have them.
