Budget Comparison (Cash Basis) Billing, Collection & Denials
  FY 2006 FY 2006 FY 2006 06/30/06
    Approved   9 Month Budget   9 Month Actual       Gross Billings   Bad Debt   Collections
Patient  Revenues            52,675,260               39,506,445              43,121,367 Medically Indigent Program           1,595,022                    952            510,058
Cafeteria Sales              600,000                  450,000                 563,499 Medicaid           1,575,947               14,330         1,337,972
HRSA Grant   Medicare           1,880,868               16,994            954,769
Healthy Futures   PacifiCare              644,864            539,257
Health Securities Trust Fund           3,500,000               2,625,000   Staywell           1,154,635                    966            950,002
Compact Impact Funds           3,700,000               2,775,000              2,626,889 Select Care              206,991            209,789
Misc Revenues   Net care              341,320            277,482
FEMA                 184,424 Commercial              273,698                    866            120,341
GovGuam Subsidy   Miscellaneous  
Bad Debt           1,027,527                  770,645                 646,460 Nanbo  
Charitable Donations   FSM  
Advanced Appropriations           7,800,000               5,850,000   GOG               38,794             10,314
GRT            9,431,212               7,073,409                5,207,661 Healthy Futures Fund  
Health Securities Trust Fund              283,130                  212,348                   183,130 Health Securities Trust Fund  
Total Collections          79,017,129             59,262,847            52,533,430 Self-Pay           1,453,156              332,536            413,322
    DRT         24,754,405             30,459
Salaries          34,884,362             26,163,272            25,606,679 Collection Agencies  
Specialty Pay              830,670                  623,003              2,998,228  Collection Agency of Guam           3,018,476  
Benefits           9,549,665               7,162,249              6,688,373  Guam Marianas Collection Agency            2,526,602               7,497
Annual Lump Sum                  85,731  Savant           3,612,137               6,933
Other Pay    United Pacific Collection Agency              402,244  
Overtime           2,011,306               1,508,480              1,747,712 Total               9,165,295           34,680,508           5,368,195
Total Salaries & Benefits          47,276,003             35,457,002            37,126,723
Travel & Training              100,230                   75,173                 173,413 Accounts Receivable (Net)
Contractual Services           9,096,233               6,822,175              4,195,817 Medically Indigent Program           6,381,674 21.79%
Supplies & Materials          10,336,019               7,752,014              9,222,332 GovGuam           1,100,892 3.76%
Minor Equipment              192,423                  144,317                  42,134 Self Pay           6,987,236 23.86%
Miscellaneous              284,678                  213,509                 596,197 Medicare           2,904,601 9.92%
Utilities           1,987,615               1,490,711              1,413,083 Medicaid           7,636,140 26.07%
Capital Outlay           2,896,928               2,172,696                 396,213 Commercial           4,277,926 14.61%
Debt Service           1,764,000               1,323,000                 347,864 Total A/R (Net)       29,288,469   100.00%
Accounts payables           5,083,000               3,812,250                               -    
Total Cash Disbursements          79,017,129             59,262,847            53,513,776
Surplus /(Deficit)                          -                             -                 (980,346)  
Accounts Payable Aging
06/30/06
    0 - 30   31 - 60   61 - 90   Over 90   Total
House Doctors                 3,612                     3,929                  88,488                463,156                559,185
Trade Payables              773,342                  983,557              1,202,185              1,790,965              4,750,049
Payroll Payables                96,384                  154,555                  31,997                282,936
  - Gov Ret DBP                459,196                459,196
  - Gov Ret DCP                          -
  - Dept of Rev              197,332                  358,032                 549,221                521,537              1,626,122
GTA                23,300                  23,300
GPA              129,635                          1                129,636
GWA                25,444                   18,999                     (541)                  43,902
Unbilled P O Receipts              387,559                387,559
Total           1,636,608               1,519,072              1,871,891              3,234,314              8,261,885
                         -
Accounts Receivable Aging
06/30/06
    0 - 30   31 - 60   61 - 90   Over 90   Total
Commercial           3,050,722               1,544,640                 461,953              3,498,539              8,555,854
GovGuam                73,027                   40,155                  23,210              2,065,391              2,201,783
Medicaid           1,970,531               1,760,646              1,614,880              9,926,222            15,272,279
Medically Indigent Program           3,047,273               1,064,410                 941,096              9,128,722            14,181,501
Medicare           3,338,495                   66,976                  96,062              2,307,669              5,809,202
Self Pay           2,882,707               1,723,425              1,589,182            36,701,145            42,896,459
Total          14,362,755               6,200,252              4,726,383            63,627,688            88,917,078