Budget Comparison (Cash Basis)   Billing, Collection & Denials
  FY 2007 FY 2007 FY 2007   03/31/07  
    Approved   6 Month Budget   6 Month Actual     Gross Billings Bad Debt Collections
                Medically Indigent Program           1,245,096                 7,071         1,417,163
Patient  Revenues         61,097,228             30,548,614 $34,858,802   Medicaid           1,719,125               23,898         1,117,842
Cafeteria Sales/Other Revenues              600,000                  300,000                 382,306   Medicare           2,038,181               27,239           715,240
FEMA Assistance                  43,107   TakeCare              641,715                    170           719,715
Advanced Appropriations                            -                           -   Staywell           1,195,879                 2,561         1,023,506
Bioterrorism                 355,133   Select Care           1,059,762           398,721
Compact Impact Funds           6,300,000               3,150,000                 291,348   NetCare              259,550           147,519
FMIP Reimbursement                 164,101   Commercial              379,398                    401           129,791
GovGuam Subsidy-General Fund           3,639,977               1,819,989     Miscellaneous  
GRT          10,062,795               5,031,398              4,279,921   Nanbo  
Medicare Reimbursement FY03 MCR              4,522,765   FSM  
Bad Debt     GOG              134,594                     67             20,898
Charitable Donations     Healthy Futures Fund  
Total Collections         81,700,000             40,850,001            44,897,483 Health Securities Trust Fund  
      Self-Pay           2,012,476              193,422           456,263
      DRT         50,841,801           236,296
Salaries         39,709,411             19,854,706            17,199,541   Attorney               64,368  
Specialty Pay           1,025,343                  512,672              2,221,803   Collection Agency of Guam           3,011,897             20,633
Benefits         10,644,570               5,322,285              4,777,134   Guam Marianas Collection Agency            2,500,583               7,965
Annual Lump Sum                  53,248   Savant           3,566,745  
Other Pay     United Pacific Collection Agency              401,918  
Overtime           1,909,385                  954,693              1,295,252   Total             10,685,776           60,642,140           6,411,551
Total Salaries & Benefits         53,288,709             26,644,355            25,546,978  
     
Travel & Training                40,444                   20,222                  56,246  
Contractual Services         11,200,657               5,600,329              2,990,405  
Supplies & Materials         13,252,694               6,626,348              8,948,308  
Miscellaneous              682,345                  341,171                 178,936  
Utilities           2,324,865               1,162,433              1,087,836  
Capital Outlay              534,439                  267,220                 956,312  
Debt Service                            -                 217,415  
Minor Equipment              375,847                  187,924  
Total Cash Disbursements         81,700,000             40,850,002            39,982,436  
Surplus /(Deficit)                        4,915,047  
 
Accounts Receivable Aging
03/31/07
    0 - 30   31 - 60   61 - 90 Over 90   Total  
Commercial           3,652,988               2,559,975              1,045,864              4,020,952            11,279,778  
GovGuam              377,638                   81,250                  65,210              1,940,507              2,464,605  
Medicaid           1,974,859               1,228,265              1,237,587            10,229,569            14,670,280  
Medically Indigent Program           2,604,614               1,084,657                 610,120              9,612,862            13,912,252  
Medicare           2,494,237                  415,283                 275,875              2,900,855              6,086,251  
Self Pay           2,578,119               1,584,568              1,584,069            25,899,051            31,645,807  
Total         13,682,455               6,953,998             4,818,725         54,603,796           80,058,974  
6
2007
03/31/07