Budget Comparison (Cash Basis)   Billing, Collection & Denials
  FY 2007 FY 2007 FY 2007   10/31/06  
    Approved   1 Month Budget   1 Month Actual     Gross Billings Bad Debt Collections
Patient  Revenues           61,097,228                 5,091,436                7,262,165   Medically Indigent Program           1,029,096                    760         1,164,537
Cafeteria Sales              600,000                   50,000                 121,847   Medicaid           1,578,441               12,250         2,912,764
ANA Grant                           -   Medicare           1,806,035               27,797           671,363
Health Securities Trust Fund                            -                           -   TakeCare              618,553           624,315
Health Securities Trust Fund Series B                            -     Staywell           1,154,038                    966           881,304
Compact Impact Funds           6,300,000                  525,000     Select Care              627,693           178,074
Bioterrorism                           -   Net care              335,195           139,403
FEMA                 164,101   Commercial              178,122             45,175
GovGuam Subsidy           3,639,977                  303,331     Miscellaneous  
Bad Debt                            -                           -   Nanbo  
Charitable Donations     FSM  
Advanced Appropriations                            -     GOG               35,286                  (621)             20,086
GRT          10,062,795                  838,566                           -   Healthy Futures Fund  
Medicare Reimbursement FY03 MCR                            -              4,921,530   Health Securities Trust Fund  
Total Collections         81,700,000               6,808,333            12,469,643   Self-Pay           2,191,473              128,398           539,896
      DRT         24,768,074             22,349
Salaries         39,709,411               3,309,118              2,733,288    Attorney               64,005  
Specialty Pay           1,025,343                   85,445                 281,769    Collection Agency of Guam           3,024,821             54,560
Benefits         10,644,570                  887,048                 824,906    Guam Marianas Collection Agency            2,523,015  
Annual Lump Sum                  16,308    Savant           3,587,720               8,340
Other Pay      United Pacific Collection Agency              401,948  
Overtime           1,909,385                  159,115                 242,775   Total               9,553,930           34,539,132           7,262,166
Total Salaries & Benefits         53,288,709               4,440,726              4,099,046           7,262,166
     
Travel & Training                40,444                     3,370                  22,578   Accounts Receivable (Net)
Contractual Services         11,200,657                  933,388              1,477,096   Medically Indigent Program           5,811,221 24.40%
Supplies & Materials         13,252,694               1,104,392              2,830,755   GovGuam           1,082,274 4.54%
Miscellaneous              682,345                   56,860                    7,033   Self Pay           5,004,870 21.02%
Utilities           2,324,865                  193,739                 246,199   Medicare           2,624,802 11.02%
Capital Outlay              534,439                   44,537                  23,886   Medicaid           6,006,625 25.22%
Debt Service                            -                  43,483   Commercial           3,285,629 13.80%
Minor Equipmant              375,847      
Total Cash Disbursements         81,700,000               6,777,012              8,750,076   Total A/R (Net)      23,815,421   100.00%
Surplus /(Deficit)                        3,719,567                              (0)    
Accounts Payable Aging  
10/31/06
    0 - 30   31 - 60   61 - 90 Over 90   Total  
House Doctors                    152                        692                    7,766                    8,610  
Trade Payables           1,172,241               1,433,549                 962,427              2,201,982              5,770,199  
Payroll Payables                          -  
  - Gov Ret DBP              160,529                160,529  
  - Gov Ret DCP                          -  
  - Dept of Rev              184,609                184,609  
GTA                          -  
GPA                  127,300                127,300  
GWA                29,365                   18,180                  47,545  
Unbilled PO Receipts              257,171                257,171  
Total           1,804,067               1,579,721                 962,427           2,209,749             6,555,963  
Accounts Receivable Aging
10/31/06
    0 - 30   31 - 60   61 - 90 Over 90   Total  
Commercial           3,142,268               1,514,406                 519,079              3,038,319              8,214,072  
GovGuam              506,096                   25,592                  31,575              2,142,423              2,705,686  
Medicaid           2,065,361               1,318,083              1,905,913              9,727,205            15,016,563  
Medically Indigent Program           2,909,126                  705,581                  75,587              2,559,235              6,249,529  
Medicare           3,349,318               1,147,800              1,136,145              8,894,789            14,528,052  
Self Pay           3,691,009               1,625,303              1,710,220            42,767,855            49,794,389  
Total         15,663,179               6,336,764             5,378,520         69,129,826           96,508,290  
1
2006