Summary
 
Summary  
  Medical Associates
Productivity Jan-06 Feb-06 Mar-06 Apr-06 May-06 Jun-06 Jul-06 Aug-06 Sep-06 Oct-06 Nov-06 Dec-06 YTD Current Month YTD vs
vs Prior Month Prior YTD
                               
Charges $5,928,513 $5,542,632 $6,213,100 $6,226,033 $6,001,884 $6,432,518 $6,314,312 $5,984,080 $6,234,582 $5,626,111 $5,015,577 $64,519,343 q p
Budgeted Chrgs $5,155,000 $5,778,000 $5,790,000 $5,582,000 $5,982,000 $5,872,000 $5,565,000 $5,798,000 $5,232,000 $5,581,000 $5,514,000   $60,002,989    
Work RVU 22,984 21,930 24,985 24,349 22,079 25,839 24,141 22,618 23,476 22,515 21,527 250,443 ¾ p
MGMA Median 23,000 23,000 23,000 23,000 23,000 23,000 23,000 23,000 23,000 23,000 23,000        
Total RVU 45,098 43,098 48,544 48,533 43,531 51,372 48,964 46,354 46,251 45,684 30,687 498,117  
                               
Contr Adjusts $2,990,158 $3,108,224 $3,860,270 $3,125,213 $3,462,243 $3,733,584 $3,455,553 $3,839,432 $3,512,213 $3,641,375 $3,514,483   $38,242,749 ¾ q
Discounts $102,583 $110,348 $102,025 $42,514 $48,997 $49,613 $97,108 $131,434 $108,145 $73,390 $71,186   $937,341 ¾ q
Write Off $30,183 $25,898 $32,020 $38,764 $14,291 $17,088 $45,113 $57,003 $51,250 $34,029 $50,666 $396,305 p q
                               
Payments $2,393,704 $2,061,506 $2,640,232 $2,368,796 $2,475,375 $2,629,065 $2,360,333 $2,767,153 $2,519,709 $2,508,629 $2,469,762 $27,194,264 ¾ p
Refunds $22,137 $47,925 $25,478 $21,095 $18,373 $27,366 $32,366 $62,157 $39,309 $28,414 $31,339   $355,959 q q
                               
Visits 16,129 15,124 17,050 16,460 13,978 16,978 17,475 16,567 15,124 16,998 10,439 172,322 q p
Procedures 27,149 25,125 27,813 28,258 24,372 28,630 31,074 28,971 26,130 30,255 18,278   296,055 q p
                               
New Visits 4,088 3,509 2,911 2,729 2,746 4,994 4,489 4,611 3,761 4,649 2,436 148,932 q q
Established Visits 9,931 9,445 11,529 11,151 9,252 10,474 10,616 10,056 9,753 10,529 6,563   1,290 q q
Consultations 2,110 2,170 2,610 2,580 1,980 1,510 2,370 1,900 1,610 1,820 1,440   22,100 q q
p
q
¬
 
 
  Medical Associates
Payer Mix Charges Jan-06 Feb-06 Mar-06 Apr-06 May-06 Jun-06 Jul-06 Aug-06 Sep-06 Oct-06 Nov-06 Dec-06 YTD Current Month vs Prior Month YTD vs Prior YTD
                               
Blue Shield      
Charges $1,047,830 $782,786 $1,043,729 $1,224,595 $1,188,368 $1,236,049 $1,202,166 $1,161,667 $1,209,815 $1,142,928 $871,861 $12,111,794 q p
% of Charge 17.7% 14.1% 16.8% 19.7% 19.8% 19.2% 19.0% 19.4% 19.4% 20.3% 21.7% 18.8% ¬ p
Commercial      
Charges $2,099,062 $1,971,742 $2,180,584 $2,210,492 $2,075,291 $2,030,124 $1,996,669 $2,068,132 $1,876,418 $1,726,321 $1,134,657 $21,369,490 q p
% of Charge 35.4% 35.6% 35.1% 35.5% 34.6% 31.6% 31.6% 34.6% 30.1% 30.7% 28.3% 33.1% ¬ ¬
Medicaid      
Charges $509,648 $424,465 $445,023 $477,316 $414,397 $441,022 $540,910 $430,352 $515,836 $476,747 $304,220 $4,979,937 q p
% of Charge 8.6% 7.7% 7.2% 7.7% 6.9% 6.9% 8.6% 7.2% 8.3% 8.5% 7.6% 7.7% q q
Medicare      
Charges $1,692,953 $1,694,820 $1,766,049 $1,722,755 $1,789,321 $1,948,751 $1,890,095 $1,694,010 $1,912,863 $1,642,846 $1,041,653 $18,796,115 q p
% of Charge 28.6% 30.6% 28.4% 27.7% 29.8% 30.3% 29.9% 28.3% 30.7% 29.2% 25.9% 29.1% q ¬
Self Pay      
Charges $243,136 $219,180 $268,853 $179,772 $216,437 $266,948 $254,510 $217,546 $221,743 $198,249 $254,210 $2,540,583 p p
% of Charge 4.1% 4.0% 4.3% 2.9% 3.6% 4.1% 4.0% 3.6% 3.6% 3.5% 6.3% 3.9% p q
Managed Care/Other      
Charges $335,885 $449,639 $508,863 $411,103 $318,070 $509,624 $429,962 $412,372 $497,907 $439,021 $408,977 $4,721,423 ¬ p
% of Charge 5.7% 8.1% 8.2% 6.6% 5.3% 7.9% 6.8% 6.9% 8.0% 7.8% 10.2%   7.3% p p
     
Payer Mix Payments Jan-06 Feb-06 Mar-06 Apr-06 May-06 Jun-06 Jul-06 Aug-06 Sep-06 Oct-06 Nov-06 Dec-06 YTD Current Month vs Prior Month YTD vs Prior YTD
                               
Blue Shield    
Payments $484,855 $433,756 $528,406 $594,555 $565,699 $604,381 $601,891 $566,861 $563,242 $524,725 $321,478 $5,789,850 ¬ p
% of Payment 21.9% 20.4% 22.5% 23.6% 24.2% 26.2% 24.6% 25.0% 25.1% 27.1% 34.6% 24.5% p p
Commercial      
Payments $1,014,920 $962,229 $1,059,055 $1,138,309 $1,037,715 $924,389 $1,027,239 $975,925 $897,211 $719,756 $277,666 $10,034,412 ¬ p
% of Payment 45.8% 45.3% 45.2% 45.2% 44.5% 40.0% 42.0% 43.1% 39.9% 37.2% 29.8% 42.4% p ¬
Medicaid      
Payments $116,225 $95,346 $96,449 $104,446 $78,698 $79,067 $98,746 $75,272 $102,378 $80,539 $44,405 $971,572 ¬ ¬
% of Payment 5.2% 4.5% 4.1% 4.1% 3.4% 3.4% 4.0% 3.3% 4.6% 4.2% 4.8% 4.1% p q
Medicare      
Payments $520,824 $550,737 $582,626 $619,879 $593,696 $639,794 $659,679 $579,468 $640,226 $566,204 $267,585 $6,220,719 ¬ p
% of Payment 23.5% 25.9% 24.9% 24.6% 25.4% 27.7% 27.0% 25.6% 28.5% 29.3% 28.8% 26.3% p p
Self Pay      
Payments $55,083 $40,129 $45,550 $43,622 $32,713 $35,487 $39,191 $48,860 $21,442 $20,694 $11,063 $393,834 ¬ ¬
% of Payment 2.5% 1.9% 1.9% 1.7% 1.4% 1.5% 1.6% 2.2% 1.0% 1.1% 1.2% 1.7% p q
Managed Care/Other      
Payments $11,200 $8,938 $9,781 $8,669 $8,243 $9,558 $8,742 $6,574 $6,394 $8,747 $5,232 $92,079 ¬ p
% of Payment 0.5% 0.4% 0.4% 0.3% 0.4% 0.4% 0.4% 0.3% 0.3% 0.5% 0.6%   0.4% p q
 
 
  Medical Associates
Top Ten Procedures Units Unit Rank Charges Total RVU Charges Per Total RVU
Procedure Current Month Prior Month Current Month Prior Month Current Month Prior Month Current Month Prior Month Current Month Prior Month
99213 Out Patient Visit, Return 2,764 4,897 1 1 $217,683 $370,140 3,811 6,783 $57.12 $54.57
99214 Outpatient Visit,  Return 1,343 2,045 2 2 $193,119 $286,796 2,875 4,405 $67.16 $65.11
99212 Outpatient  Visit, Return 556 1,048 3 3 $38,550 $68,058 513 1,011 $75.10 $67.34
99232 Daily Hospital Care;Moderate Complexity 546 940 4 4 $69,198 $111,131 803 1,382 $86.22 $80.42
99233 Daily Hospital Care;High Complexity 467 537 5 6 $88,038 $100,188 975 1,122 $90.30 $89.27
93307 Echocardiography Complete W Image Documentation 2D 378 436 6 7 $121,044 $141,612 708 908 $170.95 $156.02
90471 Immunization Admin, One Vaccine; Single Or Combo Vaccine 293 912 7 5 $2,356 $7,296 64 201 $36.55 $36.36
93320 Doppler Echocardography 277 335 8 10 $49,484 $61,054 162 216 $304.59 $282.84
90780 Infusion Therapy First Hour 206 303 9 12 $33,166 $48,671 492 724 $67.36 $67.21
99244 Outpt Consult, Moderate Complexity 206 281 9 14 $49,978 $68,302 914 1,247 $54.67 $54.78
Top Ten Procedures 7,036 11,734     $862,616 $1,263,248 11,317 17,999 $101.00 $95.39
% of Total 23.4% 24.1%     21.5% 22.4% 36.9% 39.4%    
All Procedures 30,060 48,711     $4,016,898 $5,627,795 30,698 45,699 $130.85 $123.15
Top Ten Diagnosis Units Unit Rank Charges Total RVU Charges Per Total RVU
Diagnosis  Current Month Prior Month Current Month Prior Month Current Month Prior Month Current Month Prior Month Current Month Prior Month
174.9 Breast (Female) Cancer, Nos 4,970 8,250 1 1 $345,176 $548,530 1,355 1,915 $254.83 $286.50
203.00 Multiple Myeloma Wo Remission 1,765 2,228 2 2 $71,067 $151,931 212 530 $334.94 $286.41
285.9 Anemia 1,312 2,161 3 3 $40,653 $59,610 105 135 $386.22 $440.38
202.80 Lymphoma Nec Unspec Site 1,005 1,220 4 6 $77,269 $128,876 432 559 $178.93 $230.54
154.0 Mal Neo Rectosigmoid Jct 905 677 5 12 $49,211 $40,377 124 166 $395.36 $243.73
555.9 Crohn'S Disease Nos. 721 868 6 9 $81,335 $91,717 235 281 $346.33 $326.63
V58.1 Maintenance Chemotherapy 597 1,084 7 7 $65,981 $88,797 133 167 $496.14 $531.88
250.00 Diabetes Mellitus, Type Ii Or Unspec 543 1,041 8 8 $43,093 $75,438 604 1,013 $71.39 $74.46
186.9 Malig Neo Testis Nec 535 787 10 10 $36,469 $57,770 214 387 $170.30 $149.39
185 Malign Neopl Prostate 464 237 10 41 $55,041 $87,758 96 199 $572.57 $441.35
Top Ten Diagnosis 12,817 18,553     $865,295 $1,330,804 3,510 5,352 $320.70 $301.13
% of Total 42.6% 38.1%     21.5% 23.6% 11.4% 11.7%    
All Diagnoses 30,060 48,711     $4,016,898 $5,627,795 30,698 45,699 $130.85 $123.15