Budget Comparison (Cash Basis) Billing, Collection & Denials
  FY 2005 FY 2005 FY 2005 05/31/05
    Approved   8 Month Budget   8 Month Actual       Gross Billings Bad Debt Collections
Patient  Revenues             60,000,000                 40,000,000                36,470,036 Medically Indigent Program   2,370,261           34,796         2,152,225
Cafeteria Sales                500,000                     333,333                   250,537 Medicaid   1,409,148           40,909              92,602
HRSA Grant                  46,908                       31,272   Medicare   1,920,925             2,494            671,409
Healthy Futures             3,700,000                  2,466,667                2,041,666 Pacificare       575,490             1,119            472,558
Healthy Futures - Pt Education                100,000                       66,667   Staywell       947,116                 966            349,957
Compact Impact Funds             3,200,000                  2,133,333   Calvo's       183,436                 673            101,241
Misc Revenues                  50,000                       33,333                   210,232 Net care       218,272            373,814
FEMA                                  -   Commercial       310,760             1,054  
GovGuam Subsidy             5,100,000                  3,400,000   Miscellaneous       157,592            146,747
Charitable Donations                100,000                       66,667                      35,137 Nanbo                  -    
Total Collections           72,796,908               48,531,272              39,007,608 FSM                    -  
    GOG         24,164             5,806                    560
Salaries           30,380,099               20,253,399              19,934,789 Healthy Futures Fund            150,000
Specialty Pay                679,317                     452,878                   347,263 Self-Pay   1,522,661         240,104            213,329
Benefits             8,640,252                  5,760,168                5,098,376 DRT   21,904,361            143,024
Annual Lump Sum                                  -                      55,913 Collection Agencies  
Other Pay             1,825,384                  1,216,923                1,984,431   CAOG      5,433,247              58,536
Overtime             2,227,101                  1,484,734                1,239,135   GMMS      3,677,233              33,485
Total Salaries & Benefits           43,752,153               29,168,102              28,659,907   SAVANT      3,939,456              21,507
Travel & Training                204,850                     136,567                   107,865   UPCA         407,715  
Contractual Services             8,950,172                  5,966,781                5,414,404 Total       9,639,825   35,689,932         4,980,993
Supplies & Materials           10,933,289                  7,288,859                7,465,844
Minor Equipment                312,327                     208,218                   243,441 Accounts Receivable (Net)
Miscellaneous                284,513                     189,675                   192,398 Medically Indigent Program              6,697,180
Utilities             2,215,120                  1,476,747                   922,664 GovGuam          1,897,329
Capital Outlay             3,292,803                  2,195,202                   286,001 Self Pay          3,437,493
Debt Service             2,851,681                  1,901,121                   135,968 Medicare          2,045,439
Total Cash Disbursements           72,796,908               48,531,272              43,428,492 Medicaid          6,416,224
Surplus /(Deficit)                               -                                    -                 (4,420,884) Commercial          4,395,262
Total A/R (Net)        24,888,927
                                -
Accounts Payable Aging
05/31/05
    0 - 30   31 - 60   61 - 90   Over 90   Total
House Doctors                  16,205                       59,459                      46,093                   569,120                   690,877
Trade Payables                461,269                     953,931                   936,615                3,459,806                5,811,621
Payroll Payables                             -                       65,996                                 -                                -                     65,996
  - Gov Ret DBP                194,663                     155,880                   390,615                1,654,516                2,395,673
  - Gov Ret DCP                     145,971                   286,349                   288,064                   720,383
  - Dept of Rev                     148,552                   286,104                                -                   434,656
GTA                                -
GPA                       99,257                      95,859                   373,485                   568,600
GWA                  27,262                         1,630                         (147)                     28,745
Total                  699,398                    1,630,675                  2,041,634                  6,344,843                10,716,550
Accounts Receivable Aging
05/31/05
    0 - 30   31 - 60   61 - 90   Over 90   Total
Medically Indigent Program             3,027,072                     990,723                   990,699                9,171,955              14,180,450
Self Pay             2,341,212                  1,509,774                1,163,321              23,631,465              28,645,773
Medicare             2,497,033                     560,684                   169,475                1,318,227                4,545,419
Medicaid             1,380,507                  1,243,652                1,287,017                9,740,365              13,651,541
GovGuam                309,434                       20,927                      27,235                1,740,855                2,098,452
Commercial             3,155,828                  2,125,436                   842,887                3,227,472                9,351,624
Total             12,711,087                    6,451,197                  4,480,634                48,830,340                72,473,259
                               -
8