Budget Comparison (Cash Basis)   Billing, Collection & Denials
  FY 2007 FY 2007 FY 2007   02/28/07  
    Approved   5 Month Budget   5 Month Actual     Gross Billings Bad Debt Collections
                Medically Indigent Program           1,376,995                 8,507  
Patient  Revenues         61,097,228             25,457,178 $28,453,234   Medicaid           1,397,943               26,905         1,542,024
Cafeteria Sales/Other Revenues              600,000                  250,000                 319,492   Medicare           2,227,654               32,103           119,349
FEMA Assistance                  43,107   TakeCare              785,703                    420           408,510
Advanced Appropriations                            -                           -   Staywell           1,267,757                 2,561           613,212
Bioterrorism                 197,927   Select Care              595,412           859,302
Compact Impact Funds           6,300,000               2,625,000                 291,348   NetCare              159,731             94,632
FMIP Reimbursement                 164,101   Commercial              267,220                    401           180,204
GovGuam Subsidy-General Fund           3,639,977               1,516,657     Miscellaneous               30,902  
GRT          10,062,795               4,192,831              3,572,846   Nanbo  
Medicare Reimbursement FY03 MCR              4,522,765   FSM  
Bad Debt     GOG               38,705                     67             11,652
Charitable Donations     Healthy Futures Fund  
Total Collections         81,700,000             34,041,666            37,564,820 Health Securities Trust Fund  
      Self-Pay           1,831,556              174,983           394,580
      DRT         51,124,120             51,504
Salaries         39,709,411             16,545,588            14,226,447   Attorney               64,400  
Specialty Pay           1,025,343                  427,226              1,922,069   Collection Agency of Guam           3,033,608             28,402
Benefits         10,644,570               4,435,238              3,990,378   Guam Marianas Collection Agency            2,503,267               7,632
Annual Lump Sum                  53,248   Savant           3,571,807               2,797
Other Pay     United Pacific Collection Agency              401,918  
Overtime           1,909,385                  795,577              1,075,207   Total               9,979,578           60,945,068           4,313,800
Total Salaries & Benefits         53,288,709             22,203,629            21,267,349  
     
Travel & Training                40,444                   16,852                  44,887  
Contractual Services         11,200,657               4,666,940              2,654,541  
Supplies & Materials         13,252,694               5,521,957              8,264,702  
Miscellaneous              682,345                  284,308                 139,887  
Utilities           2,324,865                  968,694                 838,922  
Capital Outlay              534,439                  222,683                 556,585  
Debt Service                            -                 173,932  
Minor Equipment              375,847                  156,603  
Total Cash Disbursements         81,700,000             34,041,666            33,940,805  
Surplus /(Deficit)                        3,624,015  
 
Accounts Receivable Aging
02/28/07
    0 - 30   31 - 60   61 - 90 Over 90   Total  
Commercial           4,018,119               2,584,818                 691,633              3,606,229            10,900,799  
GovGuam              475,585                   88,550                  38,887              1,939,590              2,542,611  
Medicaid           1,811,792               1,147,451              1,361,327              9,391,295            13,711,865  
Medically Indigent Program           2,622,425                  783,295              1,261,267              9,306,374            13,973,360  
Medicare           2,778,365                  381,712                 132,190              2,841,886              6,134,153  
Self Pay           2,646,261               1,553,488              1,910,876            24,214,268            30,324,893  
Total         14,352,547               6,539,312             5,396,180         51,299,642           77,587,681  
5
2007
02/28/07