Budget Comparison (Cash Basis)  
  FY 2007 FY 2007 FY 2007  
    Approved   10 Month Budget   10 Month Actual  
               
Patient  Revenues $61,097,228 $50,914,357 $54,072,101  
Cafeteria Sales/Other Revenues              600,000                  500,000                 600,666  
FEMA Assistance                  43,107  
Advanced Appropriations                            -              1,225,029  
Bioterrorism                 549,463  
Compact Impact Funds           6,300,000               5,250,000              3,113,641  
FMIP Reimbursement                 222,174  
GovGuam Subsidy-GRT (PL 28-68)           9,811,225               8,176,021              7,692,471  
GovGuam Subsidy-Gen Fund (PL 29-02)           3,601,660               3,001,383              3,318,980  
Medicare Reimbursement FY03 MCR              9,275,565  
Charitable Donations    
Total Collections Modified --> $81,410,113 $67,841,761 $80,113,197
  Approved --> $81,700,000    
     
Salaries $39,709,411 $33,091,176 $30,617,989  
Specialty Pay/Other Pay           1,025,343                  854,453              3,876,875  
Benefits         10,644,570               8,870,475              8,363,926  
Annual Lump Sum                 145,309  
Overtime           1,909,385               1,591,154              2,374,402  
Total Salaries & Benefits $53,288,709 $44,407,258 $45,378,501  
     
Travel & Training                40,444                   33,703                 107,123  
Contractual Services         11,200,657               9,333,881              5,904,680  
Supplies & Materials         13,252,694             11,043,913            15,458,555  
Miscellaneous              682,345                  568,619                 344,986  
Utilities           2,324,865               1,937,388              1,805,040  
Capital Outlay              534,439                  445,366              2,319,865  
Debt Service                            -              2,428,682  
Minor Equipment              375,847                  313,206  
Total Cash Disbursements $81,700,000 $68,083,334 $73,747,432  
Surplus /(Deficit)           $6,365,765  
Accounts Receivable Aging
07/31/07
    0 - 30   31 - 60   61 - 90 Over 90 days   TOTAL  
Commercial $3,470,219 $1,610,104 $641,058 $4,843,532 $10,564,912  
GovGuam              494,715                  125,263                  97,691              2,145,075              2,862,744  
MAP/Medicaid           1,746,414               1,518,672              1,858,643              8,498,461            13,622,191  
Medically Indigent Program           2,289,427                  799,059              1,121,627              8,118,282            12,328,395  
Medicare           2,686,117                  183,956                 251,624              3,233,179              6,354,876  
Self Pay           3,006,045               1,424,239              1,706,545            33,105,829            39,242,658  
Total   $13,692,937   $5,661,293   $5,677,188 $59,944,358   $84,975,777  
Accounts Payable Aging
07/31/07
    0 - 30   31 - 60   61 - 90 Over 90   Total  
House Doctors $164,160 $1,367 $22,849 $54,438 $242,814  
Trade Payables           1,141,351               1,473,404                 756,601                 902,447              4,273,803  
Payroll Payables                       2                           1                          2  
   - Gov Ret Fund DBP              164,158                164,158  
   - Gov Ret Fund DCP                          -  
   - Dept of Rev & Tax                          -  
GTA                          -  
GPA                          -  
GWA                 1,421                   25,318                    1,253                  27,992  
Unbilled PO Receipts              625,838                625,838  
Total   $2,096,929   $1,500,090   $780,703 $956,886   $5,334,608  
10
2007
07/31/07