Spreadsheet: 101762d1299803779-multiple-lookups-book2
Sheet: Details

Cori's columns | 2 | 3 |  | 8 | 12 | 13 | 14 | 15 | 16 | 17 | 19 | 21 |  | 26
 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  | 11 | 12
Original sort | Group | Full Name | 2010 Data Annualized RVUs (net of disallowed RVUs) | 2011 Plan Year CF | (Col. 1 x Col. 2) Projected 2011 Total Comp | (col. 3 x .95) 2010 Draw (95% of Projected Total Comp) | Overhead allocation (1% for S/Holders & Associates plus $1,500 for S/Holders, $6,500 MAX) | Productivity Component (80% of col. 4 - col. 5) | Quality Component Total Points | Quality Component (paid in addition to [NAME]) (20% of col. 4 - col. 5 x col. 8/100) | Projected Annual Comp (col. 6 + col. 8) | Carmore Senior Membership x $5/pmpm |  | Projected MD Comp - Payroll Draw Calculation (col. 19 + col. 21) | 2011 Monthly Draw
1 | 1 | Physician 1 | 3117 | 41.08 | 128046.36 | 121644.042 | 2780.4636 | 95090.86272 | 100 | 23772.71568 | 118863.5784 | 1320 |  | 120183.5784 | 10015.2982
2 | 1 | Physician 2 | 10219.55 | 42.76140000000002 | 437002.2653700002 | 415152.1521015001 | 5870.022653700002 | 327425.7035582401 | 100 | 81856.42588956002 | 409282.1294478001 | N/A |  | 409282.1294478001 | 34106.84412065001
3 | 1 | Physician 3 | 7858.64 | 36.4573 | 286504.7960720001 | 272179.5562684 | 4365.04796072 | 214251.606646144 | 100 | 53562.90166153601 | 267814.50830768 | N/A |  | 267814.50830768 | 22317.87569230667
4 | 1 | Physician 4 | 12273.85 | 57.317775 | 703509.77268375 | 668334.2840495625 | 6500 | 529467.42723965 | 100 | 132366.8568099125 | 661834.2840495625 | N/A |  | 661834.2840495625 | 55152.85700413021
5 | 1 | Physician 5 | 9926.240000000002 | 60.73998640847279 | 602919.682687239 | 572773.6985528771 | 6500 | 453018.9588423017 | 100 | 113254.7397105754 | 566273.6985528771 | N/A |  | 566273.6985528771 | 47189.47487940642
6 | 1 | Physician 6 | 11971.07 | 60.73998640847279 | 727122.6290948763 | 690766.4976401326 | 6500 | 547413.1981121061 | 100 | 136853.2995280265 | 684266.4976401326 | N/A |  | 684266.4976401326 | 57022.20813667771
7 | 1 | Physician 7 | 11645.86 | 57.317775 | 667514.7831615 | 634139.0440034249 | 6500 | 502111.2352027399 | 100 | 125527.808800685 | 627639.0440034249 | N/A |  | 627639.0440034249 | 52303.25366695208
8 | 1 | Physician 8 | 10646.63 | 42.76140000000002 | 455264.8040820002 | 432501.5638779001 | 6052.648040820001 | 341159.1326696641 | 100 | 85289.78316741603 | 426448.9158370801 | N/A |  | 426448.9158370801 | 35537.40965309001
9 | 1 | Physician 9 | 5648.51 | 62.7 | 354161.577 | 336453.49815 | 5041.61577 | 265129.505904 | 100 | 66282.376476 | 331411.88238 | N/A |  | 331411.88238 | 27617.656865
10 | 1 | Physician 10 | 11581.22 | 60.73998640847279 | 703443.1453935333 | 668270.9881238566 | 6500 | 529416.7904990853 | 100 | 132354.1976247713 | 661770.9881238567 | N/A |  | 661770.9881238567 | 55147.58234365473
11 | 1 | Physician 11 | 18226.26 | 60.73998640847279 | 1107062.784677291 | 1051709.645443426 | 6500 | 836167.7163547412 | 100 | 209041.9290886853 | 1045209.645443427 | N/A |  | 1045209.645443427 | 87100.80378695221
12 | 1 | Physician 12 | 26392.8 | 57.317775 | 1512776.57202 | 1437137.743419 | 6500 | 1144510.1947352 | 100 | 286127.5486838 | 1430637.743419 | N/A |  | 1430637.743419 | 119219.8119515833
13 | 1 | Physician 13 | 7775.04 | 42.76140000000002 | 332471.5954560001 | 315848.0156832001 | 4824.715954560001 | 248818.6397829121 | 100 | 62204.65994572802 | 311023.2997286401 | N/A |  | 311023.2997286401 | 25918.60831072001
14 | 1 | Physician 14 | 8970.51 | 60.73998640847279 | 544868.6554770692 | 517625.2227032157 | 6500 | 408900.1781625726 | 100 | 102225.0445406432 | 511125.2227032158 | N/A |  | 511125.2227032158 | 42593.76855860132
15 | 1 | Physician 15 | 12891.29 | 42.76140000000002 | 551249.6082060003 | 523687.1277957003 | 6500 | 413749.7022365602 | 100 | 103437.4255591401 | 517187.1277957003 | N/A |  | 517187.1277957003 | 43098.92731630836
16 | 1 | Physician 16 | 14505.68 | 60.73998640847279 | 881074.8060456556 | 837021.0657433728 | 6500 | 664416.8525946983 | 100 | 166104.2131486746 | 830521.0657433729 | N/A |  | 830521.0657433729 | 69210.08881194775
 | 1 Total | Total Specialists | 180533.15 |  | 9866947.477426914 | 9373600.103555571 | 91154.0503798 | 7425956.842540616 | 100 | 1856489.210635154 | 9282446.053175772 | 0 |  | 9282446.053175772 | 773537.1710979808
17 | 2 | Physician 17 | 4554.573379329301 | 40.24 | 183276.0327842111 | 174112.2311450006 | 3332.760327842111 | 136623.5766537267 | 100 | 34155.89416343169 | 170779.4708171584 | N/A |  | 170779.4708171584 | 14231.62256809654
18 | 2 | Physician 18 | 4363.98 | 41.08 | 179272.2984 | 170308.68348 | 3292.722984 | 143417.83872 | 100 | 33403.1920992 | 176821.0308192 | 240 |  | 177061.0308192 | 14755.0859016
19 | 2 | Physician 19 | 5202.049999999999 | 41.08 | 213700.2139999999 | 203015.2032999999 | 3637.00214 | 159502.560928 | 100 | 39875.64023199999 | 199378.2011599999 | 2400 |  | 201778.2011599999 | 16814.85009666666
20 | 2 | Physician 20 | 4492 | 41.08 | 184531.36 | 175304.792 | 3345.3136 | 137567.58272 | 100 | 34391.89568 | 171959.4784 | 2460 |  | 174419.4784 | 14534.95653333334
21 | 2 | Physician 21 | 5096.860000000001 | 41.08 | 209379.0088 | 198910.05836 | 3593.790088 | 156253.0146176 | 100 | 39063.2536544 | 195316.268272 | 1380 |  | 196696.268272 | 16391.35568933333
22 | 2 | Physician 22 | 4982.33 | 40.24 | 200488.9592 | 190464.51124 | 3504.889592 | 149567.6973184 | 100 | 37391.9243296 | 186959.621648 | N/A |  | 186959.621648 | 15579.96847066667
23 | 2 | Physician 23 | 3458.23 | 40.24 | 139159.1752 | 132201.21644 | 2891.591752 | 103447.6997504 | 100 | 25861.9249376 | 129309.624688 | N/A |  | 129309.624688 | 10775.80205733333
24 | 2 | Physician 24 | 5133.63 | 41.08 | 210889.5204 | 200345.04438 | 3608.895204 | 157388.9193408 | 100 | 39347.22983520001 | 196736.149176 | 4020 |  | 200756.149176 | 16729.679098
25 | 2 | Physician 25 | 3413.59 | 40.24 | 137362.8616 | 130494.71852 | 2873.628616 | 102096.8719232 | 100 | 25524.2179808 | 127621.089904 | 2580 |  | 130201.089904 | 10850.09082533333
26 | 2 | Physician 26 | 5306.309999999999 | 40.24 | 213525.9144 | 202849.61868 | 3635.259144 | 159371.4876288 | 100 | 39842.87190719999 | 199214.359536 | N/A |  | 199214.359536 | 16601.196628
27 | 2 | Physician 27 | 5854.9 | 41.08 | 240519.292 | 228493.3274 | 3905.19292 | 179670.507584 | 100 | 44917.626896 | 224588.13448 | 1440 |  | 226028.13448 | 18835.67787333333
28 | 2 | Physician 28 | 4237.68 | 41.08 | 174083.8944 | 165379.69968 | 3240.838944 | 139267.11552 | 100 | 32427.77214720001 | 171694.8876672 | 1440 |  | 173134.8876672 | 14427.9073056
29 | 2 | Physician 29 | 3183.97 | 40.24 | 128122.9528 | 121716.80516 | 2781.229528 | 95148.46050560001 | 100 | 23787.1151264 | 118935.575632 | N/A |  | 118935.575632 | 9911.297969333335
30 | 2 | Physician 30 | 5882.34 | 40.24 | 236705.3616 | 224870.09352 | 3867.053616 | 176802.4319232 | 100 | 44200.60798080001 | 221003.039904 | N/A |  | 221003.039904 | 18416.919992
31 | 2 | Physician 31 | 5648.53 | 41.08 | 232041.6124 | 220439.53178 | 3820.416124 | 173295.2925248 | 100 | 43323.82313119999 | 216619.115656 | 2100 |  | 218719.115656 | 18226.59297133333
32 | 2 | Physician 32 | 10575.92607227539 | 41.08 | 434459.043049073 | 412736.0908966194 | 5844.59043049073 | 325513.2003729029 | 100 | 81378.30009322573 | 406891.5004661286 | 1740 |  | 408631.5004661286 | 34052.62503884405
33 | 2 | Physician 33 | 7036.91 | 40.24 | 283165.2584 | 269006.99548 | 4331.652583999999 | 211740.2743168 | 100 | 52935.06857919999 | 264675.342896 | N/A |  | 264675.342896 | 22056.27857466666
34 | 2 | Physician 34 | 5907.91 | 40.24 | 237734.2984 | 225847.58348 | 3877.342984 | 177576.1923968 | 100 | 44394.04809920001 | 221970.240496 | N/A |  | 221970.240496 | 18497.52004133334
35 | 2 | Physician 35 | 5867.734858520224 | 44.65 | 261994.361432928 | 248894.6433612816 | 4119.943614329281 | 195819.7597975619 | 100 | 48954.93994939047 | 244774.6997469524 | 3900 |  | 248674.6997469524 | 20722.89164557936
36 | 2 | Physician 36 | 4994.683445299616 | 40.24 | 200986.0618388566 | 190936.7587469138 | 3509.860618388566 | 149941.5185028201 | 100 | 37485.37962570503 | 187426.8981285252 | N/A |  | 187426.8981285252 | 15618.9081773771
37 | 2 | Physician 37 | 3669.66 | 44.65 | 163850.319 | 155657.80305 | 3138.50319 | 122015.439888 | 100 | 30503.859972 | 152519.29986 | 1320 |  | 153839.29986 | 12819.941655
38 | 2 | Physician 38 | 4198.778715228147 | 40.24 | 168958.8555007807 | 160510.9127257416 | 3189.588555007806 | 125857.0593365871 | 100 | 31464.26483414677 | 157321.3241707338 | N/A |  | 157321.3241707338 | 13110.11034756115
39 | 2 | Physician 39 | 4390.69 | 41.08 | 180369.5452 | 171351.0679399999 | 3303.695452 | 134437.8979904 | 100 | 33609.47449759999 | 168047.372488 | 1620 |  | 169667.372488 | 14138.94770733333
40 | 2 | Physician 40 | 5445.74 | 41.08 | 223710.9992 | 212525.44924 | 3737.109992 | 167030.6713984 | 100 | 41757.66784959999 | 208788.339248 | 1020 |  | 209808.339248 | 17484.02827066667
41 | 2 | Physician 41 | 3316.7 | 44.65 | 148090.655 | 140686.12225 | 2980.90655 | 110164.17256 | 100 | 27541.04314 | 137705.2157 | 1320 |  | 139025.2157 | 11585.43464166667
 | 2 Total | Total PCPs | 126215.7064706527
 |  | Grand Total Shareholders | 306748.8564706527