This worksheet is provided as a basic tool to assist in basic business model development for FQHC/RHC/IHS and is based on the model of purchasing blocks of time by the hour with a specialty care or primary care provide. This tool is to help guide decisions related to contracting with a provider and how selecting a service provider will likely affect sustainability.
Complete a separate spreadsheet for each specialty and/or service provider. Insert your data into the cells with an asterisk and the remaining cells will auto populate to give a high level over view of the projected cost and revenue of providing special or primary care services.
Instructions: Insert your data into the top cells – the area below will be automatically populated based on the information entered. Please note that clinic collection revenue on this forum is based on PPS Medi-Cal patient billable visits only. Other payment sources cannot be predicted or calculated using this simple tool.
