Unfortunately, I can only trend data for about two years from a system standpoint. The system pivot can only handle two years of data at that level. Excel has its limits.
I am able to trend data back to FY06 for all clinics. Our fiscal year is Oct-Sept. I obviously pulled the FY11 data as it is an incomplete year. I supposed I could annualize it but I am not that ambitious and it wouldn’t be the most accurate based on only three months (we haven’t closed Jan yet).
The following categories make up expenses.
Labor – 30%
Supplies – 13% (pharm making up $58% of supplies)
Services – 49% (73% of services are physician fees which are also 36% of total expenses)
Other – 8%
Measuring capital is going to be difficult as large projects or acquisitions can skew numbers significantly. I can tell you this, all available funds for threshold projects has been suspended for FY12. The economy is often a driving factor in capital money for hospitals because it is driven by bond ratings and the hospital’s ability to borrow. If credit dries up, there is less money to borrow. Another factor in the suspension is the uncertainty of Obamacare. As we all know, uncertainty bring the private sector to a stand still.
I could really dive into the numbers by line item but I don’t have the time.
