ModelSheet Software now offers a financial plan for medical services businesses. It contains features that are particular to medical services businesses:
- The patient model tracks patients and the medical procedures they receive.
- The model tracks populations of new and continuing patients. You can specify an average procedure regimen for new patients for a period of time, and an average frequency of procedures for continuing patients.
- You can specify your medical procedures and procedure families.
- For each procedure, you can specify the number of hours of staff time by job type, and the amount of time that relevant medical equipment is utilized.
- The revenue model is based on fee for services: revenue = procedures x fee for each procedure.
- The model also tracks grant revenue that is not tied to procedures.
- Cost of services includes medical staff time, equipment time, and direct supplies.
- You can specify medical job types with different specialties and compensation levels.
- The model tracks medical staff headcount, available hours, applied hours, billed hours, and utilization, by job type. Includes benefits, payroll taxes, bonuses.
- You can include various types of medical equipment that are leased, and the lease cost of the equipment.
- The model computes staff and equipment cost per hour and per procedure, and utilization rates for medical staff and medical equipment.
It also contains the key features in a general financial plan for a business: financial statements and backup detail for many parts of the model. See the post on Financial Plan for a Business for more information.
This is our fourth type of financial plan for a business:
- Financial Plan for a Business (for product businesses)
blog article
overview and customizer - Financial Plan for Professional Services Businesses
overview and customizer - Financial Plan for a Small Business
overview and customizer - Financial Plan for Medical Services Businesses
case study
overview and customizer
A “customizable spreadsheet solution” is a spreadsheet model that you customize by filling in a simple web form in plain English, then download as a conventional Excel workbook. Each solution is feature-rich; you choose the features you want, and the size of the model in terms of time series and dimensions (lists of products, departments and so forth). You can see a list of our customizable spreadsheet solutions with descriptions at http://templates.modelsheetsoft.com//browser/browse.aspx . We welcome your suggestions for new features in this and other customziable spreadsheet solutions.
