Budget Comparison (Cash Basis)   Billing, Collection & Denials
  FY 2007 FY 2007 FY 2007   01/31/07  
    Approved   4 Month Budget   4 Month Actual     Gross Billings Bad Debt Collections
                Medically Indigent Program           1,432,180                 6,784         1,923,286
Patient  Revenues         61,097,228             20,365,743 $23,563,514   Medicaid           1,736,997               16,293           754,409
Cafeteria Sales/Other Revenues              600,000                  200,000                 269,054   Medicare           1,830,763               27,146           559,414
FEMA Assistance                  43,107   TakeCare           1,010,763                        -           540,673
Advanced Appropriations                            -                           -   Staywell           1,052,578                 2,561         1,085,288
Bioterrorism                  57,678   Select Care              968,185           535,110
Compact Impact Funds           6,300,000               2,100,000                  80,229   NetCare              325,688           238,297
FMIP Reimbursement                 164,101   Commercial              353,620             73,381
GovGuam Subsidy-General Fund           3,639,977               1,213,326     Miscellaneous  
GRT          10,062,795               3,354,265              2,696,213   Nanbo  
Medicare Reimbursement FY03 MCR              5,098,419   FSM  
Bad Debt     GOG               64,400                     67               4,040
Charitable Donations     Healthy Futures Fund  
Total Collections         81,700,000             27,233,334            31,972,315 Health Securities Trust Fund  
      Self-Pay               89,830              169,228           503,428
      DRT         51,168,862             34,339
Salaries         39,709,411             13,236,470            11,281,045   Attorney               63,405  
Specialty Pay           1,025,343                  341,781              1,616,386   Collection Agency of Guam           3,031,967             17,832
Benefits         10,644,570               3,548,190              3,182,837   Guam Marianas Collection Agency            2,507,813               6,880
Annual Lump Sum                  22,706   Savant           3,575,803               3,346
Other Pay     United Pacific Collection Agency              401,918  
Overtime           1,909,385                  636,462                 811,329   Total               8,865,003           60,971,845           6,279,723
Total Salaries & Benefits         53,288,709             17,762,903            16,914,303  
     
Travel & Training                40,444                   13,481                  38,008   Accounts Receivable (Net)
Contractual Services         11,200,657               3,733,552              2,495,578   Medically Indigent Program           5,540,150 22.87%
Supplies & Materials         13,252,694               4,417,566              6,895,236   GovGuam           1,137,860 4.70%
Miscellaneous              682,345                  227,446                 114,854   Self Pay           4,332,172 17.88%
Utilities           2,324,865                  774,955                 689,871   Medicare           2,794,733 11.54%
Capital Outlay              534,439                  178,146                 556,585   Medicaid           6,103,364 25.19%
Debt Service                            -                 130,449   Commercial           4,318,210 17.82%
Minor Equipmant              375,847                  125,282      
Total Cash Disbursements         81,700,000             27,108,049            27,834,884   Total A/R (Net)      24,226,489   100.00%
Surplus /(Deficit)                        4,137,431                               0    
Accounts Payable Aging  
01/31/07
    0 - 30   31 - 60   61 - 90 Over 90   Total  
House Doctors                 2,803                   16,787                  87,397                 235,895                342,882  
Trade Payables              877,255               1,258,796                 830,140              1,643,049              4,609,240  
Payroll Payables              101,993                101,993  
  - Gov Ret DBP              159,710                 148,213                307,923  
  - Gov Ret DCP              213,828                213,828  
  - Dept of Rev              396,142                396,142  
GTA                24,480                  24,480  
GPA                  124,472                124,472  
GWA                25,914                   33,404                  23,664                       979                  83,961  
Unbilled PO Receipts           1,622,606              1,622,606  
Total           3,424,731               1,433,459                 941,202           2,028,136             7,827,528  
Accounts Receivable Aging
01/31/07
    0 - 30   31 - 60   61 - 90 Over 90   Total  
Commercial           4,081,214               1,948,714                 655,898              3,595,626            10,281,451  
GovGuam              491,902                  118,935                  60,470              1,914,739              2,586,046  
Medicaid           1,750,031               1,333,261              1,519,370            10,655,747            15,258,409  
Medically Indigent Program           2,390,615               1,202,101                 924,940              9,332,719            13,850,375  
Medicare           2,944,896                  311,080                 167,223              2,787,317              6,210,517  
Self Pay           2,527,032               1,757,348              2,226,345            22,200,323            28,711,048  
Total         14,185,689               6,671,440             5,554,246         50,486,471           76,897,846  
                           -
4
2007