Budget Comparison (Cash Basis)   Billing, Collection & Denials
  FY 2007 FY 2007 FY 2007   12/31/06  
    Approved   3 Month Budget   3 Month Actual     Gross Billings Bad Debt Collections
                Medically Indigent Program              775,016                 3,502           754,999
Patient  Revenues         61,097,228             15,274,307 $17,234,996   Medicaid           1,126,531               14,908         1,495,001
Cafeteria Sales/Other Revenues              600,000                  150,000                 214,234   Medicare           2,040,020               24,167           874,701
FEMA Assistance                  43,107   TakeCare              862,953                        -           477,350
Advanced Appropriations                            -                           -   Staywell           1,109,807                 2,207           513,695
Bioterrorism                  57,678   Select Care              701,506           293,565
Compact Impact Funds           6,300,000               1,575,000                  61,194   NetCare              194,015           425,325
FMIP Reimbursement                 164,101   Commercial              196,531           105,858
GovGuam Subsidy-General Fund           3,639,977                  909,994     Miscellaneous  
GRT          10,062,795               2,515,699              1,733,964   Nanbo  
Medicare Reimbursement FY03 MCR              5,093,962   FSM  
Bad Debt     GOG              108,878                     47                  558
Charitable Donations     Healthy Futures Fund  
Total Collections         81,700,000             20,425,000            24,603,236 Health Securities Trust Fund  
      Self-Pay           1,865,008              158,939           558,812
      DRT         51,258,737             32,524
Salaries         39,709,411               9,927,353              8,465,549   Attorney               63,185  
Specialty Pay           1,025,343                  256,336              1,188,064   Collection Agency of Guam           3,026,842             19,606
Benefits         10,644,570               2,661,143              2,397,577   Guam Marianas Collection Agency            2,508,222               8,288
Annual Lump Sum                  22,706   Savant           3,581,133               4,365
Other Pay     United Pacific Collection Agency              401,918  
Overtime           1,909,385                  477,346                 619,571   Total               8,980,265           61,043,806           5,564,647
Total Salaries & Benefits         53,288,709             13,322,177            12,693,467  
     
Travel & Training                40,444                   10,111                  31,353   Accounts Receivable (Net)
Contractual Services         11,200,657               2,800,164              1,940,516   Medically Indigent Program           6,138,917 25.26%
Supplies & Materials         13,252,694               3,313,175              5,213,907   GovGuam           1,258,240 5.18%
Miscellaneous              682,345                  170,584                  90,443   Self Pay           4,010,098 16.50%
Utilities           2,324,865                  581,216                 513,057   Medicare           2,621,456 10.78%
Capital Outlay              534,439                  133,610                 556,585   Medicaid           6,079,953 25.01%
Debt Service                            -                  86,966   Commercial           4,198,730 17.27%
Minor Equipmant              375,847                   93,962      
Total Cash Disbursements         81,700,000             20,331,037            21,126,294   Total A/R (Net)      24,307,394   100.00%
Surplus /(Deficit)                        3,476,942                               0    
Accounts Payable Aging  
12/31/06
    0 - 30   31 - 60   61 - 90 Over 90   Total  
House Doctors              172,067                   12,479                  28,097                 201,639                414,282  
Trade Payables              829,778               1,314,417              1,377,481              1,424,973              4,946,649  
Payroll Payables              171,574                171,574  
  - Gov Ret DBP              166,458                 148,213                314,671  
  - Gov Ret DCP                          -  
  - Dept of Rev              387,453                  222,492                 384,300                994,245  
GTA                          -  
GPA                  122,586                122,586  
GWA                33,404                   23,664                        99                  57,167  
Unbilled PO Receipts           1,231,494              1,231,494  
Total           2,992,229               1,695,639             1,789,977           1,774,825             8,252,670  
Accounts Receivable Aging
12/31/06
    0 - 30   31 - 60   61 - 90 Over 90   Total  
Commercial           3,591,977               2,315,884                 666,514              3,422,603              9,996,978  
GovGuam              521,876                   75,116                  51,122              2,147,975              2,796,088  
Medicaid           1,823,050               1,358,501              1,483,574            10,534,758            15,199,883  
Medically Indigent Program           2,985,692                  998,584              1,434,116              9,928,899            15,347,292  
Medicare           2,394,512                  457,873                 230,406              2,742,665              5,825,457  
Self Pay           2,511,268               1,967,455              1,983,718            20,143,405            26,605,846  
Total         13,828,375               7,173,414             5,849,451         48,920,305           75,771,545  
                           -
3
2006