Budget Comparison (Cash Basis) Billing, Collection & Denials
  FY 2006 FY 2006 FY 2006 05/31/06
    Approved   8 Month Budget   8 Month Actual       Gross Billings   Bad Debt   Collections
Patient  Revenues            52,675,260               35,116,840              37,822,675 Medically Indigent Program           1,387,438                    952            775,394
Cafeteria Sales              600,000                  400,000                 464,222 Medicaid           2,187,872               14,330            550,000
HRSA Grant   Medicare           2,282,232               16,994            736,863
Healthy Futures   PacifiCare              836,260            437,024
Health Securities Trust Fund           3,500,000               2,333,333   Staywell           1,215,212                    966            540,397
Compact Impact Funds           3,700,000               2,466,667              2,626,889 CALVO'S              425,450            765,432
Misc Revenues   Net care              380,473            328,295
FEMA   Commercial              195,291                    866  
GovGuam Subsidy   Miscellaneous            123,592
Bad Debt           1,027,527                  685,018                 640,897 Nanbo                    753  
Charitable Donations   FSM  
Advanced Appropriations           7,800,000               5,200,000   GOG               39,269                  (621)  
GRT            9,431,212               6,287,475                4,539,433 Healthy Futures Fund  
Health Securities Trust Fund              283,130                  188,753                   183,130 Health Securities Trust Fund  
Total Collections          79,017,129             52,678,086            46,277,246 Self-Pay           1,552,610              193,310            394,686
    DRT         24,828,661  
Salaries          34,884,362             23,256,241            22,729,331 Collection Agencies  
Specialty Pay              830,670                  553,780              2,658,105  Collection Agency of Guam           3,014,650             31,378
Benefits           9,549,665               6,366,443              5,963,508  Guam Marianas Collection Agency            2,538,381               7,933
Annual Lump Sum                  85,731  Savant           3,615,877               6,822
Other Pay    United Pacific Collection Agency              402,244  
Overtime           2,011,306               1,340,871              1,551,951 Total             10,502,860           34,626,610           4,697,816
Total Salaries & Benefits          47,276,003             31,517,335            32,988,626                     -
Travel & Training              100,230                   66,820                 102,925 Accounts Receivable (Net)
Contractual Services           9,096,233               6,064,155              4,029,812 Medically Indigent Program           6,168,405 20.96%
Supplies & Materials          10,336,019               6,890,679              7,319,429 GovGuam           1,107,456 3.76%
Minor Equipment              192,423                  128,282                  97,125 Self Pay           6,605,056 22.44%
Miscellaneous              284,678                  189,785                 100,102 Medicare           2,789,374 9.48%
Utilities           1,987,615               1,325,077              1,127,509 Medicaid           8,313,587 28.24%
Capital Outlay           2,896,928               1,931,285                 222,926 Commercial           4,452,047 15.12%
Debt Service           1,764,000               1,176,000                 401,301 Total A/R (Net)       29,435,925   100.00%
Debt Service           5,083,000               3,388,668              3,219,076            
Total Cash Disbursements          79,017,129             52,678,086            49,608,831
Surplus /(Deficit)                          -                             -              (3,331,585)  
Accounts Payable Aging
05/31/06
    0 - 30   31 - 60   61 - 90   Over 90   Total
House Doctors                 2,758                   54,664                  96,920                356,767                511,109
Trade Payables              572,375               1,456,500                 995,150              1,138,164              4,162,189
Payroll Payables                94,867                   50,527                145,394
  - Gov Ret DBP              158,572                459,196                617,768
  - Gov Ret DCP                          -
  - Dept of Rev              180,643                  549,221                 344,822                176,716              1,251,402
GTA                          -
GPA                43,483               (422,811)                689,400                310,072
GWA                   23,061                       948                     (511)                  23,498
Unbilled P O Receipts           1,782,615              1,782,615
Total           2,835,313               2,133,973              1,015,029              2,819,732              8,804,047
Accounts Receivable Aging
05/31/06
    0 - 30   31 - 60   61 - 90   Over 90   Total
Commercial           2,942,895               2,010,777                 523,488              3,426,937              8,904,097
GovGuam                74,330                   14,145                  13,929              2,112,507              2,214,911
Medicaid           2,274,134               1,826,535              1,348,755            11,177,749            16,627,173
Medically Indigent Program           3,127,187               1,074,716                 847,779            10,938,192            15,987,874
Medicare           2,883,449                  163,722                 115,415              2,416,161              5,578,747
Self Pay           3,217,043               1,593,277              1,667,947            37,555,440            44,033,707
Total          14,519,038               6,683,172              4,517,313            67,626,986            93,346,509