Budget Comparison (Cash Basis) Billing, Collection & Denials
  FY 2006 FY 2006 FY 2006 01/31/06
    Approved   4 Month Budget   4 Month Actual       Gross Billings Bad Debt Collections
Patient  Revenues            53,258,165               17,752,722              17,563,884 Medically Indigent Program          1,159,757                 3,003         1,475,088
Cafeteria Sales              600,000                  200,000                 247,331 Medicaid          1,772,757               14,966            230,365
HRSA Grant   Medicare          1,691,037               16,994            202,684
Healthy Futures           4,000,000               1,333,333   Pacificare             666,569                 1,119            489,646
Healthy Futures - Pt Education   Staywell          1,341,383                    966            633,023
Compact Impact Funds           3,200,000               1,066,667                 879,078 Calvo's             196,957            102,014
Misc Revenues   Net care             913,822            181,139
FEMA   Commercial               99,829                    536  
GovGuam Subsidy          17,958,964               5,986,321   Miscellaneous             108,920             75,258
Insurance Settlement   Nanbo  
Charitable Donations   FSM  
GTA Sale Proceeds   GOG               20,762                     47                  506
GRT                 1,906,053 Healthy Futures Fund  
Health Securities Trust Fund                   183,130 Health Securities Trust Fund  
Total Collections          79,017,129             26,339,043            20,779,476 Self-Pay          1,870,175              282,081            351,988
    DRT         21,666,391  
Salaries          34,884,362             11,628,121            10,550,122 Collection Agencies  
Specialty Pay              830,670                  276,890              1,475,984   CAOG           3,093,791             73,135
Benefits           9,549,665               3,183,222              2,769,698   GMMS           2,602,074             13,570
Annual Lump Sum                  12,263   SAVANT           3,645,369               7,121
Other Pay     UPCA              385,221  
Overtime           2,011,306                  670,435                 738,413 Total              9,841,968         31,712,558         3,835,537
Total Salaries & Benefits          47,276,003             15,758,668            15,546,480                     -
Travel & Training              100,230                   33,410                  21,190 Accounts Receivable (Net)
Contractual Services           9,096,233               3,032,078              1,996,361 Medically Indigent Program          6,182,035
Supplies & Materials          10,336,019               3,445,340              3,349,013 GovGuam          1,765,078
Minor Equipment              192,423                   64,141                  67,599 Self Pay          4,307,105
Miscellaneous              284,678                   94,893                  47,336 Medicare          2,362,716
Utilities           1,987,615                  662,538                 296,469 Medicaid          5,957,078
Capital Outlay           2,896,928                  965,643                 212,540 Commercial          7,423,848
Debt Service           6,847,000               2,282,332   Total A/R (Net)       27,997,860
Total Cash Disbursements          79,017,129             26,339,043            21,536,988                             -
Surplus /(Deficit)                          -                             -                 (757,512)
Accounts Payable Aging
01/31/06
    0 - 30   31 - 60   61 - 90   Over 90   Total
House Doctors                93,729                     3,657                    6,702                197,711                301,799
Trade Payables              787,533               1,014,435                 742,822              1,516,504              4,061,294
Payroll Payables              333,649                333,649
  - Gov Ret DBP              152,901                (513,347)                984,160                623,714
  - Gov Ret DCP              187,212                187,212
  - Dept of Rev              350,274                350,274
GTA                22,649                  22,649
GPA                  116,804                549,274                666,078
GWA                16,557                     1,136                  15,007                      430                  33,130
Unbilled P O Receipts           1,104,449              1,104,449
Total           3,048,953                  622,685                 764,531              3,248,079              7,684,248
                         -
Accounts Receivable Aging
01/31/06
    0 - 30   31 - 60   61 - 90   Over 90   Total
Commercial           5,109,478               2,119,465              1,077,344              8,191,154            16,497,441
GovGuam                42,355                     6,867                  10,531              2,016,809              2,076,562
Medicaid           1,519,815               1,307,114              1,632,383              8,778,640            13,237,952
Medically Indigent Program           3,024,679                  983,875              1,154,141            10,292,392            15,455,087
Medicare           2,800,245                   66,969                 148,700              2,234,566              5,250,480
Self Pay           3,131,397               1,409,519              1,352,536            28,221,461            34,114,913
Total          15,627,969               5,893,809              5,375,635            59,735,022            86,632,435