Budget Comparison (Cash Basis) Billing, Collection & Denials
  FY 2005 FY 2005 FY 2005 06/30/05
    Approved   9 Month Budget   9 Month Actual       Gross Billings Bad Debt Collections
Patient  Revenues             60,000,000                 45,000,000                40,560,632 Medically Indigent Program      4,087,773           23,672            500,233
Cafeteria Sales                500,000                     375,000                   283,121 Medicaid      1,236,608           38,071            500,000
HRSA Grant                  46,908                       35,181   Medicare      2,198,238             2,494            858,990
Healthy Futures             3,700,000                  2,775,000                2,349,999 Pacificare         760,864             1,119            437,625
Healthy Futures - Pt Education                100,000                       75,000   Staywell      1,336,204                 966            741,343
Compact Impact Funds             3,200,000                  2,400,000                2,225,000 Calvo's         381,859            219,678
Misc Revenues                  50,000                       37,500                1,845,599 Net care         396,141            217,192
FEMA                                  -   Commercial         150,232                 869            129,265
GovGuam Subsidy             5,100,000                  3,825,000   Miscellaneous         137,038  
Charitable Donations                100,000                       75,000                      35,138 Nanbo                    -    
Total Collections           72,796,908               54,597,681              47,299,489 FSM                      -  
    GOG           15,088             5,806                    160
Salaries           30,380,099               22,785,074              22,318,318 Healthy Futures Fund            308,333
Specialty Pay                679,317                     509,488                   386,665 Self-Pay      1,359,549         239,642            369,813
Benefits             8,640,252                  6,480,189                5,708,226 DRT   21,881,905  
Annual Lump Sum                                  -                      55,913 Collection Agencies  
Other Pay             1,825,384                  1,369,038                2,250,382   CAOG      5,387,027              43,955
Overtime             2,227,101                  1,670,326                1,396,955   GMMS      3,611,704              32,611
Total Salaries & Benefits           43,752,153               32,814,115              32,116,459   SAVANT      3,909,555              17,549
Travel & Training                204,850                     153,638                   120,797   UPCA         408,468  
Contractual Services             8,950,172                  6,712,629                6,361,829 Total       12,059,594   35,511,298         4,376,747
Supplies & Materials           10,933,289                  8,199,967                8,750,227
Minor Equipment                312,327                     234,245                   240,984 Accounts Receivable (Net)
Miscellaneous                284,513                     213,385                   203,954 Medically Indigent Program      
Utilities             2,215,120                  1,661,340                   981,690 GovGuam  
Capital Outlay             3,292,803                  2,469,602                   289,688 Self Pay  
Debt Service             2,851,681                  2,138,761                   227,898 Medicare  
Total Cash Disbursements           72,796,908               54,597,681              49,293,526 Medicaid  
Surplus /(Deficit)                               -                                    -                 (1,994,037) Commercial  
Total A/R (Net)                           -
           (29,563,194)
Accounts Payable Aging
06/30/05
    0 - 30   31 - 60   61 - 90   Over 90   Total
House Doctors                                -
Trade Payables                                -
Payroll Payables                                -
  - Gov Ret DBP                                -
  - Gov Ret DCP                                -
  - Dept of Rev                                -
GTA                                -
GPA                                -
GWA                                -
Total                               -                                    -                                   -                                  -                                  -
Accounts Receivable Aging
06/30/05
    0 - 30   31 - 60   61 - 90   Over 90   Total
Medically Indigent Program             2,980,035                     781,818                1,079,250                8,158,078              12,999,181
Self Pay             2,091,379                     961,079                1,485,311              13,200,453              17,738,222
Medicare             2,538,317                     338,138                   209,237                1,632,428                4,718,120
Medicaid             1,572,877                  1,023,952                1,332,679                8,364,954              12,294,462
GovGuam                  32,591                     288,198                      11,583                1,677,652                2,010,024
Commercial             3,981,136                  1,865,319                   853,188              15,339,276              22,038,919
Total             13,196,335                    5,258,504                  4,971,248                48,372,841                71,798,928
9