Staffing Calculator

	B	C	D	E	F
1	Geographic Region:	PA
2
3	Specialty:	Family Medicine
4
5	APP Years of Experience:	6-9 Years
6
7			Advance Practice Provider	Physician	Total
8	Revenue
9	AMGA Benchmark wRVUs¹		4,735	4,908
10	Physician Production Percent increase²			10.00%
11		Or
12	New Patient Visits³			300
13	New Procedures³			-
14	Average collections per wRVU (APP based off 85% of Physician)⁴		$ 75.96	$ 89.36
15	Total Revenue		359,652	33,159	392,810
16
17			Advance Practice Provider	Physician	Total
18	Expenses
19	Salary		100,000		100,000
20	Benefits (select percentage)	0.00%	-		-
21	Bonus				-
22	CME		1,000		1,000
23	Malpractice		1,500		1,500
24	Other Expense		-		-
25	Total Expense		102,500	-	102,500
26	Contribution to Practice		257,152	33,159	290,310
27
28	ENTER YOUR OWN ASSUMPTIONS:
29			Advance Practice Provider	Physician	Total
30	Revenue
31	wRVUs¹		4,096	5,840
32	Physician Production Percent increase²			0.00%
33	Or
34	New Patient Visits³			300
35	New Procedures³
36	Average collections per wRVU		$ 90.10	$ 89.36
37	Total Revenue		369,050	33,159	402,208
38
39			Advance Practice Provider	Physician	Total
40	Expenses
41	Salary		135,000		135,000
42	Benefits (select percentage)	20.00%	27,000		27,000
43	Bonus		-		-
44	CME		1,000		1,000
45	Malpractice		-		-
46	Other Expense				-
47	Total Expense		163,000	-	163,000
48	Contribution to Practice		206,050	33,159	239,208
49
50	Footnotes:
51	1. Annual production of provider
52	2. Advance Practice Providers allow Physicians to increase production, i.e. global visits, non billable visits, etc
53	Enter percentage to increase Physician productivity
54	3. Enter new visits or procedures that hiring an Advanced Practice Provider will free Physician up to do
55	4. AMGA collection per wRVU. Advanced Practice Provider collections 85% of Physician
56

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	S	U
1				Wed	Thu	Fri	Sat	Sun	Mon	Tue	Wed	Thu	Fri	Sat	Sun	Mon	Tue
2	Name	FTE	Role	10/6	10/7	10/8	10/9	10/10	10/11	10/12	10/13	10/14	10/15	10/16	10/17	10/18	10/19
3	Sophi	1.00	Back Office
4	Gaby	0.08	Front Office
5	Ruba	0.20	Back Office
6	Sal	1.00	Front Office
7	Riya	0.20	front Office
8	Lindsay	0.58	Front Office
9
10	Total	3.06
11	Req	3.49
12
13
14
15								Front	Back			Front Office FT1		Front Office FT2			Front Office PT1	Front Office PT2	Back Office
16							M	17	8.5			9-5		9-5			9-1	1-5
17							T	17	8.5
18							W	17	8.5
19							T	17	8.5
20							F	17	8.5
21							S	8	4
22								93	46.5	139.5	3.4875
23								186

	A	B	C
1	TLG RVU CALCULATOR
2
3	PHYSICIAN ASSISTANT OR NURSE PRACTITIONER (APP) CRITERIA		Explanation:
4	A8	Geographic Region	Enter the state of your practice
5	A10	Specialty	Enter the specialty for your practice
6	A12	APP Years of Experience	Enter how many years of experience the APP has
7
8	PROJECTED PA OR NP REVENUE		Explanation:
9	A17	AMGA Benchmark wRVUs1 for APP (C17)	Based on APP criteria entered, this is the yearly RVU projection the provider will generate
10	A17	AMGA Benchmark wRVUs1 for MD (D17)	Based on the MD selected in the state and specialty, this is the projected RVU's the MD will generate
11	A18	Physician Production Percent increase2	This is what % the MD will increase their yearly RVU's with the addition of the APP (global visits)
12
13	A20	New Patient Visits3	Enter the number of new office visits that you think having an APP will allow you to do
14	A21	New Procedures3	Enter the number of new procedures that you think having an APP will allow you to do
15
16	A23	Average collections per wRVU (APP based off 85% of Physician)4	Total collections divided by wRVU - many insurances only pay the APP 85% of what a physician will receive
17	A23	cont.	Total yearly collections of APP ($$$), divided by wRVU - this then tells you what a singular wRVU is worth
18	A24	Total Revenue	Projected total revenue for APP and MD
19
20	PROVIDER EXPENSES		Explanation:
21	A27	Salary	What salary do you plan on paying the APP
22	A28	Benefits (select percentage)	How much will benefits cost to employ the PA or NP. Drop down % off of the salary (Provider Burden)
23	A29	Bonus	What production bonus, retention bonus, or sign on bonus will you provide the PA or NP provider
24	A30	CME	How much CME will you allocate for the provider
25	A31	Malpractice	Cost of Malpractice to employ new provider
26	A32	Other Expense	Any misc. expenses that employe incurs by employing provider (parking, food, lab coats, etc)
27	A33	Total Expense	Total overhead for employing the APP Provider
28
29	A37	Contribution to the Practice	Total Revenue for APP, net APP expenses

	A	B	C	D
1	Sources
2
3		Productivity Benchmarks
4			Physician	https://www.beckershospitalreview.com/compensation-issues/2015-physician-compensation-work-rvu-by-specialty.html
5			APP	http://physiciancompensation.org/PDFs/2015RSPWB/2015Survey.pdf
6
7		Collection Benchmarks
8			http://physiciancompensation.org/PDFs/2015RSPWB/2015Survey.pdf