Protectyaneck1
New Member
- Joined
- Mar 27, 2016
- Messages
- 6
Good morning everyone,
I was hoping to get some input/ideas for a project I am working on to run projections/forecasting for a bunch of medical doctors projecting billing.
So I have a bunch of data collaborated together for each medical provider; such as their calendar, number of patients, charge per patient, and most important avg amount of days it takes for them to complete their report for each visit.
So for example: Doctor A has 5 patients on 5/20. Dr. A normally bills out $500 a report and takes 20 days to bill out this report. So I would want my projection numbers for June (5/20+20 days) to be the est sum of accounts billed (5 patients*$500).
Now obv this is easy to do one by one, but I am trying to figure out how to do this on a grand scale as we have 50 providers who see patients on different, charge different amounts with time ranges anywhere from 5 days to 35 days.
I would like to be able to enter the quantity amount of patients each provider has on each day, and then be able to view the projected billings based off when we can anticipate the bill going out.
Any help or information as to how to get this going would be greatly appreciated!
Thank you!
I was hoping to get some input/ideas for a project I am working on to run projections/forecasting for a bunch of medical doctors projecting billing.
So I have a bunch of data collaborated together for each medical provider; such as their calendar, number of patients, charge per patient, and most important avg amount of days it takes for them to complete their report for each visit.
So for example: Doctor A has 5 patients on 5/20. Dr. A normally bills out $500 a report and takes 20 days to bill out this report. So I would want my projection numbers for June (5/20+20 days) to be the est sum of accounts billed (5 patients*$500).
Now obv this is easy to do one by one, but I am trying to figure out how to do this on a grand scale as we have 50 providers who see patients on different, charge different amounts with time ranges anywhere from 5 days to 35 days.
I would like to be able to enter the quantity amount of patients each provider has on each day, and then be able to view the projected billings based off when we can anticipate the bill going out.
Any help or information as to how to get this going would be greatly appreciated!
Thank you!
