Budget Comparison (Cash Basis) Billing, Collection & Denials
  FY 2006 FY 2006 FY 2006 07/31/06
    Approved   10 Month Budget   10 Month Actual       Gross Billings   Bad Debt   Collections
Patient  Revenues            52,675,260               43,896,050              48,542,247 Medically Indigent Program           1,070,396                    952         1,471,841
Cafeteria Sales              600,000                  500,000                 605,761 Medicaid           1,240,586               12,250            221,153
ANA Grant                    5,713 Medicare           1,920,493               17,440         1,047,986
Healthy Futures   PacifiCare              878,436            492,846
Health Securities Trust Fund           3,500,000               2,916,667   Staywell           1,155,190                    966         1,082,747
Compact Impact Funds           3,700,000               3,083,333              2,753,447 Select Care              376,139            150,341
Misc Revenues   Net care              305,763            274,272
FEMA                 184,424 Commercial              303,203             95,882
GovGuam Subsidy   Miscellaneous  
Bad Debt           1,027,527                  856,273                 646,460 Nanbo  
Charitable Donations   FSM  
Advanced Appropriations           7,800,000               6,500,000   GOG               22,931             12,884
GRT            9,431,212               7,859,343              5,924,014 Healthy Futures Fund  
Health Securities Trust Fund              283,130                  235,942                 183,130 Health Securities Trust Fund  
Total Collections          79,017,129             65,847,608            58,845,196 Self-Pay           1,458,112              205,217            365,314
    DRT         24,786,940             31,463
Salaries          34,884,362             29,070,302            27,929,666 Collection Agencies  
Specialty Pay              830,670                  692,225              3,412,524  Collection Agency of Guam           3,034,264             49,155
Benefits           9,549,665               7,958,054              7,413,068  Guam Marianas Collection Agency            2,514,026  
Annual Lump Sum                 122,416  Savant           3,607,368               6,689
Other Pay    United Pacific Collection Agency              402,588  
Overtime           2,011,306               1,676,088              1,950,717 Total               8,731,249           34,582,011           5,302,573
Total Salaries & Benefits          47,276,003             39,396,669            40,828,391                     -
Travel & Training              100,230                   83,525                 174,611 Accounts Receivable (Net)
Contractual Services           9,096,233               7,580,194              4,587,139 Medically Indigent Program           6,482,237 22.23%
Supplies & Materials          10,336,019               8,613,349            11,073,747 GovGuam           1,073,687 3.68%
Miscellaneous              477,101                  397,584                 761,664 Self Pay           7,216,572 24.75%
Utilities           1,987,615               1,656,346              1,581,009 Medicare           2,620,940 8.99%
Capital Outlay           2,896,928               2,414,107                 456,962 Medicaid           7,737,961 26.54%
Debt Service           6,847,000               5,705,834                 391,347 Commercial           4,022,591 13.80%
Total Cash Disbursements          79,017,129             65,847,608            59,854,870 Total A/R (Net)       29,153,988   100.00%
Surplus /(Deficit)                          -                             -              (1,009,674)                             -    
Accounts Payable Aging  
07/31/06
    0 - 30   31 - 60   61 - 90   Over 90   Total
House Doctors                    152                     4,040                  62,022                545,542                611,756
Trade Payables           2,492,656               1,215,717                 832,071              1,471,124              6,011,568
Payroll Payables              263,983                  156,048                  88,006                  31,997                540,034
  - Gov Ret DBP                459,196                459,196
  - Gov Ret DCP                          -
  - Dept of Rev              394,105                  386,349                 358,032              1,070,759              2,209,245
GTA                22,962                  22,962
GPA              123,473                123,473
GWA                25,389                   25,444                  18,999                     (541)                  69,291
Unbilled P O Receipts                36,880                  36,880
Total           3,359,600               1,787,598              1,359,130              3,578,077            10,084,405
Accounts Receivable Aging
07/31/06
    0 - 30   31 - 60   61 - 90   Over 90   Total
Commercial           3,540,910               1,057,629                 291,740              3,154,903              8,045,182
GovGuam                80,891                   13,382                  12,211              2,040,889              2,147,373
Medicaid           1,890,360               1,334,998              1,816,642            10,433,922            15,475,922
Medically Indigent Program           3,094,367               1,010,588              1,115,927              9,184,090            14,404,972
Medicare           2,527,343                  225,246                  73,673              2,415,618              5,241,880
Self Pay           3,523,507               1,306,386              1,803,679            38,354,987            44,988,559
Total          14,657,378               4,948,229              5,113,872            65,584,409            90,303,888
10
2006