Budget Comparison (Cash Basis) Billing, Collection & Denials
  FY 2006 FY 2006 FY 2006 04/30/06
    Approved   7 Month Budget   7 Month Actual       Gross Billings Bad Debt Collections
Patient  Revenues            52,675,260               30,727,235              33,124,859 Medically Indigent Program             941,374                 1,114         1,050,692
Cafeteria Sales              600,000                  350,000                 407,623 Medicaid          1,177,176               14,569            936,798
HRSA Grant   Medicare          2,146,478               16,994         1,088,410
Healthy Futures   Pacificare             670,557            421,513
Health Securities Trust Fund           3,500,000               2,041,667   Staywell             721,674                    966         1,111,443
Compact Impact Funds           3,700,000               2,158,333              2,626,889 Calvo's             297,588            170,637
Misc Revenues   Net care             550,552            246,210
FEMA   Commercial             160,424  
GovGuam Subsidy   Miscellaneous               72,369                    982             87,191
Bad Debt           1,027,527                  599,391                 640,897 Nanbo  
Charitable Donations   FSM  
Advanced Appropriations           7,800,000               4,550,000   GOG               28,434                     47             26,021
GRT            9,431,212               5,501,540                4,010,894 Healthy Futures Fund  
Health Securities Trust Fund              283,130                  165,159                   183,130 Health Securities Trust Fund  
Total Collections          79,017,129             46,093,325            40,994,292 Self-Pay          1,427,032              251,607            374,555
    DRT         21,530,759             64,639
Salaries          34,884,362             20,349,211            19,934,295 Collection Agencies  
Specialty Pay              830,670                  484,558              2,398,798   CAOG           3,072,374             28,661
Benefits           9,549,665               5,570,638              5,231,867   GMMS           2,546,701             10,376
Annual Lump Sum                  29,226   SAVANT           3,625,419             13,303
Other Pay     UPCA              392,467  
Overtime           2,011,306               1,173,262              1,362,382 Total              8,193,658         31,453,999         5,630,449
Total Salaries & Benefits          47,276,003             27,577,668            28,956,568
Travel & Training              100,230                   58,468                  85,013 Accounts Receivable (Net)
Contractual Services           9,096,233               5,306,136              3,220,103 Medically Indigent Program          6,112,138
Supplies & Materials          10,336,019               6,029,344              6,152,643 GovGuam          1,085,586
Minor Equipment              192,423                  112,247                  78,781 Self Pay          6,474,621
Miscellaneous              284,678                  166,062                  95,770 Medicare          2,734,290
Utilities           1,987,615               1,159,442                 983,197 Medicaid          8,149,412
Capital Outlay           2,896,928               1,689,875                 229,642 Commercial          4,298,585
Debt Service           6,847,000               3,994,083   Total A/R (Net)       28,854,632
Total Cash Disbursements          79,017,129             46,093,325            39,801,717        
Surplus /(Deficit)                          -                             -                1,192,575
 
Accounts Payable Aging
04/30/06
    0 - 30   31 - 60   61 - 90   Over 90   Total
House Doctors                36,485                   64,494                  91,733                270,673                463,385
Trade Payables              928,792               1,170,396                 651,710                839,968              3,590,866
Payroll Payables              153,001                   21,249                          -                          -                174,250
  - Gov Ret DBP              156,728                           -                          -                459,196                615,924
  - Gov Ret DCP                        -                           -                          -                          -                          -
  - Dept of Rev              349,816                  344,822                 176,716                          -                871,354
GTA                          -
GPA                        -                (307,251)                 228,982                460,419                382,150
GWA                22,421                   22,552                  22,784                     (640)                  67,117
Unbilled P O Receipts              756,352                756,352
Total           2,403,595               1,316,262              1,171,925              2,029,616              6,921,398
Accounts Receivable Aging
04/30/06
    0 - 30   31 - 60   61 - 90   Over 90   Total
Commercial           2,884,779               1,971,069                 513,150              3,359,263              8,728,261
GovGuam                72,862                   13,866                  13,654              2,070,790              2,171,172
Medicaid           2,229,225               1,790,465              1,322,120            10,957,014            16,298,824
Medically Indigent Program           3,065,432               1,053,493                 831,037            10,722,187            15,672,149
Medicare           2,826,507                  160,489                 113,136              2,368,447              5,468,579
Self Pay           3,153,514               1,561,813              1,635,009            36,813,805            43,164,141
Total          14,232,319               6,551,195              4,428,106            66,291,506            91,503,126