Change in Payer Mix Model.xlsx (26.3 KB)
I created this change in payer mix model (if you want to use it fill in the grey fields with your actual data and then put whatever scenario you want to model in the yellow highlighted column; and NO, these are not our practice’s actual numbers, don’t want to get anyone in trouble). For our practice a 10% decrease in Blue Cross and a 10% increase in Medicaid would negatively impact our revenue by about 8%. That scenario is too simplistic. Has anyone given thought to how our payer mix might change due to mass unemployment?