Budget Comparison (Cash Basis)   Billing, Collection & Bad Debts
  FY 2007 FY 2007 FY 2007   06/30/07  
    Approved   9 Month Budget   9 Month Actual     Gross Billings Bad Debt Collections
                Medically Indigent Program           1,738,721                 1,594           477,582
Patient  Revenues         61,097,228             45,822,921 $49,708,209   Medicaid 2,625,146               25,233  
Cafeteria Sales/Other Revenues              600,000                  450,000                 549,904   Medicare           2,866,254               17,800           846,454
FEMA Assistance                  43,107   TakeCare              607,928                        -           582,083
Advanced Appropriations                            -                           -   Staywell              998,617                    966           772,156
Bioterrorism                 424,124   Select Care              787,554           718,343
Compact Impact Funds           6,300,000               4,725,000              3,059,062   NetCare              162,199           172,858
FMIP Reimbursement                 222,174   Commercial              349,910           181,699
GovGuam Subsidy-GRT (PL 28-68)           9,811,225               7,358,419              6,679,152   Miscellaneous  
GovGuam Subsidy-Gen Fund (PL 29-02)           3,601,660               2,701,245              2,622,418   Nanbo  
Medicare Reimbursement FY03 MCR              9,275,565   FSM  
Bad Debt     GOG               51,593                     67  
Charitable Donations     Healthy Futures Fund  
Total Collections Modified -->         81,410,113             61,057,585            72,583,715 Health Securities Trust Fund  
  Approved -->         81,700,000     Self-Pay           1,358,477              247,967           426,454
      DRT         49,815,029           554,994
Salaries         39,709,411             29,782,058            27,674,930   Attorney               64,195  
Specialty Pay           1,025,343                  769,007              3,333,017   Collection Agency of Guam           3,005,727             25,931
Benefits         10,644,570               7,983,428              7,566,088   Guam Marianas Collection Agency            2,477,165               8,301
Annual Lump Sum                  75,989   Savant           3,558,687  
Other Pay     United Pacific Collection Agency              401,886  
Overtime           1,909,385               1,432,039              2,154,712   Total             11,546,398           59,616,317           4,766,855
Total Salaries & Benefits         53,288,709             39,966,532            40,804,736  
     
Travel & Training                40,444                   30,333                  89,608  
Contractual Services         11,200,657               8,400,493              5,592,285  
Supplies & Materials         13,252,694               9,939,522            14,108,229  
Miscellaneous              682,345                  511,757                 311,755  
Utilities           2,324,865               1,743,649              1,608,528  
Capital Outlay              534,439                  400,829              2,319,865  
Debt Service                            -              2,428,682  
Minor Equipment              375,847                  281,885  
Total Cash Disbursements         81,700,000             61,275,000            67,263,688  
Surplus /(Deficit)                        5,320,027  
Accounts Receivable Aging
06/30/07
    0 - 30   31 - 60   61 - 90 Over 90 days   TOTAL  
Commercial           3,426,191               1,873,452              1,009,679              4,560,520            10,869,842  
GovGuam              491,478                  101,212                  40,596              2,123,805              2,757,091  
MAP/Medicaid           1,972,198               1,801,981              1,406,404              8,498,174            13,678,757  
Medically Indigent Program           1,814,567               1,079,353              1,116,694              8,372,777            12,383,391  
Medicare           3,022,554                  282,397                 181,483              3,174,141              6,660,575  
Self Pay           2,832,997               1,649,998              1,969,581            31,103,685            37,556,262  
Total         13,559,984               6,788,393             5,724,438         57,833,103           83,905,917  
Accounts Payable Aging
06/30/07
    0 - 30   31 - 60   61 - 90 Over 90   Total  
House Doctors                  31,824                  45,274                  77,098  
Trade Payables              870,880               1,171,071                 649,865                 878,627              3,570,443  
Payroll Payables                       1                          1  
   - Gov Ret Fund DBP              157,663                157,663  
   - Gov Ret Fund DCP                          -  
   - Dept of Rev & Tax              223,627                  374,712                 416,107                 210,582              1,225,029  
GTA                          -  
GPA                          -  
GWA                23,745                     1,203                  24,948  
Unbilled PO Receipts              676,514                676,514  
Total           1,952,429               1,546,987             1,097,796           1,134,483             5,731,695  
9
2007
06/30/07