Procedure Code * Rate - How are you Budgeting for this type of Revenue?

Hello!
I’m wondering how other Prophix Users budget for revenue related to procedure codes, rates and utilization discounting.

Examples would be hospitals, nursing homes, group homes, adult day programs and the like. Do you budget at the client level specifically in cases where you know who the client will be (think nursing homes)? Do you budget by procedure code? Do you budget by funder? I would love to chat with you!

Thanks,
Emily

Interesting Scenario.

I have not come across a Prophix installation / setup for Hospital / Nursing Home etc, however I was involved in Hospitality Project(Hotel/Restaurant).

Hotels Budget on Average Rate & Per night basis for each Room Type.

Restaurants Budget on Expected Person’s visit(PAX) and Average Check.

Bars usually Budget on PAX and Category of Liquor.

I think for each segment/type of Business you might need to create different drivers to budget more efficiently.

Regards,

Ali Arsalan

1 Like

We don’t have anything like that for our budgets in Prophix.

I would use DPM to setup your revenue forecasting. I have worked in a dermatology office and if I were to use Prophix for that business, I would have budgeted by product & service, not by patient. I would possibly further budget by provider.
For a nursing home, could you budget by bed? I am not sure what the various sources of revenue are for a nursing home.

1 Like

We have a separate cube set up with information from Power BI that records our tasks/sales/costs to be able to create reports by task type etc.
We have also used our costs exported into a template that we can use to uplift revenue on a % basis and then import into Prophix to create the budget and forecasts.

Hi Emily! We budget by fund source instead of by client.

We budget by margin in our budget.

We do not budget like this.

We are not in this industry, but would like to prepare budgets that more closely match to reporting we receive on revenue. Ours would include providers and types of services. Some of these services are discounted at different levels depending on the agreement with the provider. I am considering using DPM for this.

We make our budget differently per business unit. Some of our business units do a price times quantity on customer level, others just price times quantity on a high level. This is still partly an Excel excercise, but we are working on bringing all this into Prophix the coming year to make the process easier.

1 Like

We do not have this on our industry

We don’t have anything like that for our budgets in Prophix.

Sorry, we aren’t currently doing anything like that.

We budget by Funder and then by discipline

my prior institution used raisers edge to budget then fold into the GL

For our Nursing Homes, we budget by anticipated census and the optimal mix of payor sources (Medicare/Managed Care/etc) that will contribute to our margin goals.

We do Monthly forecasting in Prophix to help with budget but we have other external items that we evaluate on timing Revenue based on historical data.

We budget by product type but we are in a different industry.

We don’t get that granular on the revenue for the nursing home. We essentially take rates multiple by days for revenue on the nursing home. We are in multiple states, but use this method for all.

We have separate models outside of Prophix because of complex partnership funding and distributions; so not relevant to what you’re asking. However, I would agree with some of the other comments that it sounds like it’s worthwhile for you to consider if DPM is right for your scenario.