Budget Comparison (Cash Basis) Billing, Collection & Denials
  FY 2006 FY 2006 FY 2006 08/31/06
    Approved   11 Month Budget   11 Month Actual       Gross Billings   Bad Debt   Collections
Patient  Revenues           52,675,260               48,285,655              52,189,271 Medically Indigent Program           2,232,741                    760  
Cafeteria Sales              600,000                  550,000                 666,551 Medicaid           2,689,506               12,250           439,442
ANA Grant                    5,713 Medicare           2,422,005               17,440           776,930
Healthy Futures   PacifiCare              702,542           615,100
Health Securities Trust Fund           3,500,000               3,208,333   Staywell                    966         1,630,455
Compact Impact Funds           3,700,000               3,391,667              4,624,690 Select Care              370,031           302,298
Bioterrorism                 646,460 Net care              424,884                  (262)           275,129
FEMA                 184,424 Commercial              478,854             64,135
GovGuam Subsidy   Miscellaneous  
Bad Debt           1,027,527                  941,900              1,027,527 Nanbo  
Charitable Donations   FSM  
Advanced Appropriations           7,800,000               7,150,000   GOG                  (621)             31,420
GRT            9,431,212               8,645,278              7,145,955 Healthy Futures Fund  
Health Securities Trust Fund              283,130                  259,536                 183,130 Health Securities Trust Fund  
Total Collections         79,017,129             72,432,369            66,673,721 Self-Pay           1,718,198              211,525           498,994
    DRT           1,604,222         24,852,307  
Salaries         34,884,362             31,977,332            31,012,948  Attorney               64,105  
Specialty Pay              830,670                  761,448              3,589,966  Collection Agency of Guam           3,058,279             26,436
Benefits           9,549,665               8,753,860              8,134,156  Guam Marianas Collection Agency            2,507,597               9,751
Annual Lump Sum                 132,846  Savant           3,602,873               4,460
Other Pay    United Pacific Collection Agency              402,588  
Overtime           2,011,306               1,843,697              2,199,340 Total             12,642,984           34,729,808           4,674,551
Total Salaries & Benefits         47,276,003             43,336,336            45,069,256                    (0)
Travel & Training              100,230                   91,878                 184,119 Accounts Receivable (Net)
Contractual Services           9,096,233               8,338,214              4,807,084 Medically Indigent Program           6,768,352 22.56%
Supplies & Materials         10,336,019               9,474,685            12,076,723 GovGuam           1,057,003 3.52%
Miscellaneous              477,101                  437,341                 776,858 Self Pay           6,688,725 22.29%
Utilities           1,987,615               1,821,980              1,729,210 Medicare           2,615,797 8.72%
Capital Outlay           2,896,928               2,655,517              2,328,205 Medicaid           7,881,724 26.27%
Debt Service           6,847,000               6,276,418                 434,830 Commercial           4,991,195 16.64%
Total Cash Disbursements         79,017,129             72,432,369            67,406,285 Total A/R (Net)      30,002,796   100.00%
Surplus /(Deficit)                          -                              -                 (732,564)                            (0)    
Accounts Payable Aging  
08/31/06
    0 - 30   31 - 60   61 - 90   Over 90   Total                        -
House Doctors                    425                        817                    9,838                532,500                543,579
Trade Payables              979,179               2,991,159              1,025,385              2,181,385              7,177,108
Payroll Payables              304,908                  172,644                  21,388                  21,579                520,518
  - Gov Ret DBP                455,529                455,529
  - Gov Ret DCP                          -
  - Dept of Rev              369,243                  395,114                 381,965              1,626,123              2,772,446
GTA                          -
GPA                          -
GWA                31,905                        817                    1,614                       197                  34,533
Unbilled P O Receipts              449,520                449,520
Total           2,135,179               3,560,551             1,440,190             4,817,314           11,953,233
Accounts Receivable Aging
08/31/06
    0 - 30   31 - 60   61 - 90   Over 90   Total
Commercial              200,427                  166,600                 456,479              7,392,635              8,216,140
GovGuam                   21,459                           -              2,180,631              2,202,090
Medicaid              944,336                  203,643                           -            15,272,279            16,420,258
Medically Indigent Program              977,646                  223,471                           -            14,181,501            15,382,618
Medicare              207,697                            -                  58,748              5,183,132              5,449,578
Self Pay           1,473,470               2,128,984              5,230,173            37,240,355            46,072,983
Total           3,803,577               2,744,157             5,745,401           81,450,532           93,743,667
11
2006