Physician-Productivity-Worksheet
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
How many patient slots will you have in an 8-hr day?What percent of these slots will be filled per day?How many 8-hr days a week will you work?How many weeks a year will you work?Total encounters per year
3
4
2095%445=3420
5
6
7
Average 99213Average 99214% 99214+ visits (of sick)Average ancillary rev/sick
Average revenue/commercial sick visit
8
$ 72.00 $ 105.00 30% $ 5.00 = $ 80.73
9
10
11
% well visits (of all)Average well visit rev (except imms)Average revenue/commercial visit (no imms)Predicted panel size
12
35% $ 158.00 = $ 107.77 882
13
14
15
% Medicaid payment % Medicaid (of encounters)Total nonvaccine revenue
Average revenue/visit (nonvaccine)
16
70%25%= $ 340,941.69 $99.69
17
18
19
Immunizations per year
Non-Medicaid imm admin revenue (per imm)Average imm purchase cost per product (non VFC)Average markup per imm dose (non VFC)
Total imms revenue per year
20
1600$20.00$54.0025%=$110,600.00
21
22
Total revenue per year
Average revenue/visit (w vaccines)
23
=$451,541.69$132.03
24
25
Practice overhead %Collection %BenefitsAvailable for salarySalary / hr
26
66%100% $ 15,000 = $ 138,524.18 $ 96.20
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...