Budget Comparison (Cash Basis) Billing, Collection & Denials
  FY 2006 FY 2006 FY 2006 10/31/05
    Approved   1 Month Budget   1 Month Actual       Gross Billings Bad Debt Collections
Patient  Revenues             53,258,165                    4,438,180                  4,149,628 Medically Indigent Program      1,108,558.00               5,593.00        695,723.98
Cafeteria Sales                600,000                       50,000                      34,696 Medicaid      1,492,235.00            30,772.00          24,818.50
HRSA Grant   Medicare      1,893,735.00            17,070.00        679,288.82
Healthy Futures             4,000,000                     333,333   Pacificare         747,433.00               1,119.00        403,857.02
Healthy Futures - Pt Education   Staywell      1,419,365.00                  966.00    1,561,896.92
Compact Impact Funds             3,200,000                     266,667   Calvo's         348,596.00        156,392.88
Misc Revenues   Net care         193,060.00        140,803.43
FEMA   Commercial            43,111.00                  947.00  
GovGuam Subsidy           17,958,964                  1,496,580   Miscellaneous            47,288.00          79,472.38
Insurance Settlement   Nanbo  
Charitable Donations   FSM  
GTA Sale Proceeds   GOG            50,431.00                    47.00          46,837.79
Total Collections           79,017,129                  6,584,761                4,184,324 Healthy Futures Fund  
    Self-Pay      1,657,132.00          284,373.00        305,401.39
Salaries           35,288,651                  2,940,721                2,722,413 DRT     21,709,826.00  
Specialty Pay             2,481,976                     206,831                   258,389 Collection Agencies  
Benefits             9,549,665                     795,805                   694,735   CAOG       3,394,859.00          48,183.29
Annual Lump Sum                                  -     GMMS       2,726,834.00  
Other Pay                                  -     SAVANT       3,739,479.00          12,614.75
Overtime                                  -                   187,596   UPCA          385,221.00  
Total Salaries & Benefits           47,320,292                  3,943,358                3,863,133 Total          9,000,944.00     32,297,106.00    4,155,291.15
Travel & Training                  97,590                         8,133                      15,958
Contractual Services             8,220,896                     685,075                1,117,242 Accounts Receivable (Net)
Supplies & Materials           11,057,169                     921,431                1,659,606 Medically Indigent Program                7,157,006
Minor Equipment                192,023                       16,002                        9,256 GovGuam            1,867,650
Miscellaneous             7,133,567                     594,464                      37,205 Self Pay            3,531,148
Utilities             1,987,615                     165,635                   220,942 Medicare            3,005,645
Capital Outlay             3,007,977                     250,665                      99,827 Medicaid            5,829,942
Debt Service                                  -   Commercial            4,669,554
Total Cash Disbursements           79,017,129                  6,584,761                7,023,169 Total A/R (Net)         26,060,945
Surplus /(Deficit)                               -                                    -                 (2,838,845)                                  -
Accounts Payable Aging
10/31/05
    0 - 30   31 - 60   61 - 90   Over 90   Total
House Doctors                  17,926                         5,002                      74,303                     50,538                   147,769
Trade Payables                394,630                  1,034,848                   518,014                   670,670                2,618,162
Payroll Payables                             -                                  -                                 -                                -                                -
  - Gov Ret DBP                1,047,537                1,047,537
  - Gov Ret DCP                                -
  - Dept of Rev                170,405                   170,405
GTA                             -                                  -                                 -                                -                                -
GPA                             -                     117,469                   588,284                   705,753
GWA                  52,097                       18,864                            (53)                     70,908
Unbilled P O Receipts                585,221                   585,221
Total               1,220,279                    1,176,183                     592,317                  2,356,976                  5,345,755
                               -
Accounts Receivable Aging
10/31/05
    0 - 30   31 - 60   61 - 90   Over 90   Total
Commercial             3,630,956                  2,671,529                   732,596                3,341,706              10,376,787
GovGuam                  75,080                       10,266                        2,776                1,987,045                2,075,167
Medicaid             1,697,807                  1,160,200                1,336,785                8,478,995              12,673,787
Medically Indigent Program             3,439,913                  1,255,999                1,188,743                9,674,053              15,558,708
Medicare             3,459,424                     752,639                   353,817                1,968,131                6,534,011
Self Pay             3,038,618                  1,435,105                1,409,908              27,685,885              33,569,516
Total             15,341,798                    7,285,738                  5,024,625                53,135,815                80,787,976
1
2006