Budget Comparison (Cash Basis) Billing, Collection & Denials
  FY 2006 FY 2006 FY 2006 03/31/06
    Approved   6 Month Budget   6 Month Actual       Gross Billings Bad Debt Collections
Patient  Revenues            53,258,165               26,629,083     Medically Indigent Program          1,584,940                 2,377            365,341
Cafeteria Sales              600,000                  300,000   Medicaid          2,277,279               14,875            940,093
HRSA Grant   Medicare          2,141,551               16,994            734,903
Healthy Futures           4,000,000               2,000,000   Pacificare             685,728            746,056
Healthy Futures - Pt Education   Staywell          1,112,324                    966         1,109,823
Compact Impact Funds           3,200,000               1,600,000   Calvo's             459,607            322,207
Misc Revenues   Net care             373,601            265,661
FEMA   Commercial             235,196  
GovGuam Subsidy          17,958,964               8,979,482   Miscellaneous               83,918                    982             83,458
Insurance Settlement   Nanbo  
Charitable Donations   FSM                     47  
GTA Sale Proceeds   GOG               18,904  
GRT    Healthy Futures Fund  
Health Securities Trust Fund   Health Securities Trust Fund  
Total Collections          79,017,129             39,508,565                          - Self-Pay          1,445,444              273,220            475,968
    DRT         21,606,460  
Salaries          34,884,362             17,442,181   Collection Agencies  
Specialty Pay              830,670                  415,335     CAOG           3,116,302  
Benefits           9,549,665               4,774,833     GMMS           2,550,578               9,987
Annual Lump Sum     SAVANT           3,633,192               6,761
Other Pay     UPCA              385,483  
Overtime           2,011,306               1,005,653   Total             10,418,492         31,601,476         5,060,258
Total Salaries & Benefits          47,276,003             23,638,002                       -
Travel & Training              100,230                   50,115   Accounts Receivable (Net)
Contractual Services           9,096,233               4,548,117   Medically Indigent Program          6,497,755
Supplies & Materials          10,336,019               5,168,010   GovGuam          1,784,387
Minor Equipment              192,423                   96,212   Self Pay          4,352,307
Miscellaneous              284,678                  142,339   Medicare          2,442,620
Utilities           1,987,615                  993,808   Medicaid          7,376,829
Capital Outlay           2,896,928               1,448,464   Commercial          5,080,286
Debt Service           6,847,000               3,423,498   Total A/R (Net)       27,534,184
Total Cash Disbursements          79,017,129             39,508,565                          -                             -
Surplus /(Deficit)                          -                             -                            -
Accounts Payable Aging
03/31/06
    0 - 30   31 - 60   61 - 90   Over 90   Total
House Doctors                58,398                   47,924                  16,190                324,495                447,007
Trade Payables              839,397               1,002,596                 631,074              1,201,015              3,674,082
Payroll Payables              155,769                155,769
  - Gov Ret DBP              161,637                459,196                620,833
  - Gov Ret DCP                          -
  - Dept of Rev              344,822                  176,716                521,538
GTA                23,084                  23,084
GPA                  119,164                 116,804                343,614                579,582
GWA                21,603                   22,784                     (416)                     (224)                  43,747
Unbilled P O Receipts              712,483                712,483
Total           2,317,193               1,369,184                 763,652              2,328,096              6,778,125
                         -
Accounts Receivable Aging
03/31/06
    0 - 30   31 - 60   61 - 90   Over 90   Total
Commercial           3,571,381               1,645,788                 806,075              3,189,440              9,212,684
GovGuam                48,856                     7,547                  11,145              2,031,731              2,099,279
Medicaid           2,264,802               1,222,056              1,477,513            11,428,583            16,392,954
Medically Indigent Program           3,155,910                  764,862              1,091,771            11,231,845            16,244,388
Medicare           3,010,485                  113,160                 133,147              2,171,252              5,428,044
Self Pay           3,130,194               1,505,304              1,351,006            35,464,036            41,450,540
Total          15,181,628               5,258,717              4,870,657            65,516,887            90,827,889