Budget allocator template for Healthcare

The budget allocator with three columns a provider needs: which service line a share is for, how much capacity stands behind it, and how much of that service's demand is meant to come from referral rather than direct advertising.

Everything else is the general allocator, unchanged. One row per destination, a basis for every share, a floor and a ceiling, and a reallocation rule written before it is needed.

Use it whenever more than one service is competing for the same marketing budget, which in a multi-service practice is always. Without a capacity column the split will keep funding whichever service is easiest to advertise, and that is frequently the one with the longest wait.

Use it again whenever a practitioner joins, leaves or changes their hours, because capacity is the ceiling on every row it touches.

Every allocator has a ceiling column. In a practice, the ceiling is not a property of the audience or the inventory; it is a property of the appointment book, and it moves every week.

That single fact reorganises the document. A service with a six-week wait cannot usefully absorb more money however well its advertising performs, and a service with empty slots can absorb more than its recent cost per appointment would suggest. The share that is right this month may be wrong in three weeks for reasons that have nothing to do with marketing at all.

So capacity goes in the row, with the day it was read, and it is re-read on the allocator's cadence rather than at the start of a period. The split is then argued against what the practice can actually deliver, which is the only version of the argument worth having.

The service line column exists because services differ in every way that matters to an allocation.

They differ in capacity, as above. They differ in what an appointment is worth, because a long consultation and a short review are not the same revenue. They differ in claim review, which changes how quickly new creative can be put in market. And they differ in how their demand arrives — some services are found by people searching for them, others arrive almost entirely through referral.

An allocator that treats them as interchangeable destinations will fund whichever is cheapest to advertise. That is frequently the service with the longest wait, because its demand is already strong, and the money goes into making a queue longer.

The referral mix column is the one most practices have never written down, and it changes the shape of a share.

A service whose work arrives mostly through referring practitioners needs spend aimed at a small, expensive, professional audience, judged on referrals received rather than on enquiries. A service whose work arrives directly needs spend aimed at a large patient audience with a much lower cost per action. Put both in the same allocator without the column, and the referrer row will look like the worst performer in the practice on every metric the reporting produces.

Naming the mix lets each row be judged on its own terms, and it makes an obvious question askable: for this service, is the cheaper route to more appointments a patient campaign or ten conversations with referrers.

Floors are where a multi-service practice usually needs the most discipline.

The instinct is fair: every service wants some visibility, so the budget is divided across all of them. The result is nine rows, each too small to reach anybody more than once, producing a handful of enquiries each and no readable information about any of them.

A floor is the least a row may hold and still produce enough attended appointments to tell whether it worked. Written into the allocator, it forces the honest version of the choice: three services funded properly this quarter, and the others next quarter, rather than nine funded in a way that helps none of them.

The reallocation rule in a practice should be built around capacity rather than around performance, because capacity is the thing that changes fastest.

A workable rule reads like this: if the book for this service is full for the next three weeks, move up to a fifth of the row to a service with availability, checked every Monday. It needs no analysis and no meeting, and it prevents the specific failure this category produces most reliably.

The performance version of the rule still belongs there too, on a slower condition — two consecutive periods above target — because appointment volumes in a small practice are noisy enough that a single bad fortnight means very little.

One more thing belongs in the notes on rows that are being increased: how quickly new creative for that service can be cleared.

A share can be raised faster than a service's wording can be reviewed. Where a service's claims take two weeks to clear, a large increase this week will run on existing assets at a higher frequency, which is not the same purchase as an increase with fresh creative behind it.

Writing the review lead time into the notes means the allocator's decisions and the practice's actual capacity to act on them stay in step.

The evidence column should name an attended appointment rate read from the practice management system over a stated window. Not enquiries, and not a figure from anywhere else.

Enquiry-to-attendance rates vary by service, by catchment and by how quickly reception replies, which means no external figure can stand in for yours. Where a service is new and there is no history, name the row as a bet, write the assumption down, and give it a floor big enough to produce an answer within the period.

Every row names a service line and the capacity behind it, with the day it was read, and no row is funded beyond what that service can see. Shares sum to one whole per currency. Every row has a floor set from the appointments needed to read a result. The referral mix is stated for every service, even where the answer is none. Every row carries a reallocation rule that can be applied on a Monday without a meeting. And every assumption is labelled as one, in words.