Comp model explanations
| Model | Description |
|---|---|
| Salary | A traditional hourly rate calculation (usually used for Clinical Nurse Practitioners and Physician Assistants who are referred to as Midlevel providers). FTEs are input for the provider and hourly rate pulls from payroll data. |
| Guarantee | An annual salary guarantee is placed in the ProviderList sheet of the Budget Provider Assumptions driver file (generally used in the first one to two years of hire); You can also add an incentive compensation by placing rates in the tier tables on the same line.
For example, Dr. Falk’s guarantee is $500,000 for next year and his total WRVUs=5,200. In addition to his guarantee, he will be paid:
His total compensation will be 5200 $54,720. |
| CompRate | A five-tiered model where volume drives the rate paid. (Highest tier for volume is paid at that tier rate)
For example, Dr. Champion has total WRVUs of 2,500.
His total compensation will be 2500 $112,500. |
| CompStep | A five-tiered model where an employee is paid a different rate, by tier, over the course of a contract year.
For example, Dr. Quintin has total WRVUs of 1,800.
Her total compensation will be 1800 $77,350. |
| Comp3Tier | A three-tiered model where an employee is paid one rate up to a max and another rate for any volume over the max. There is also a rate if it is below a minimum level of volume.
For example, Dr. Brush has total WRVUs of 5,000.
His total compensation will be 5000 $182,400. |
| Max | The highest value of Salary, Guarantee, CompRate, CompStep, and Comp3Tier calculations. |
| AltRate | Uses the same logic as CompRate. A five-tiered model where volume drives the rate paid. (The highest tier for volume is paid at that tier rate.) Use this model to compare an alternate CompRate table. |
| AltStep | Uses the same logic as CompStep. A five-tiered model where an employee is paid a different rate, by tier, over the year. Use this model to compare an alternate CompStep table. |
| Alt3Tier | Uses the same logic as Comp3Tier. A three-tiered model where an employee is paid one rate up to a max and another rate for any volume over the max. There is also a rate if the volume is below a minimum level. Use this model to compare an alternate CompStep table |
| Percent of Net Receivable | Calculates a percent of cash collections from the Provider sheet to use for compensation calculations. The percentage to use needs to be entered on the ProviderList sheet of the Budget Provider Assumptions driver file. For example, Dr. Champion takes cash collections and receives 25%. If his budgeted cash collections is $1,000,000, then his total compensation will be $250,000. For example, $1,000,000 * 25% = $250,000. |
| Percent of Net Revenue | Calculates a percent of net revenue by calculating Gross Charges minus Allowances from the Provider sheet to use for compensation calculations. The percentage to use needs to be entered on the ProviderList sheet of the Budget Provider Assumptions driver file. For example, the Gross Charges for Dr. Champion are $2,000,000 and Deductions are $1,500,000. He will receive 40% of Net Revenue. As a result, his total compensation will be $200,000. Example: $2,000,000-$1,500,000=$500,000 * 40%=$200,000 |
| GlobalProvider | Allows for a calculation amount that is calculated outside of the budget workbook. This amount is entered into the GlobalProvider sheet in the Budget Provider Assumptions driver file. The amount then pulls into the budget workbook in the ProviderComp sheet. |
