Budget Comparison (Cash Basis) Billing, Collection & Denials
  FY 2005 FY 2005 FY 2005 09/30/05
    Approved     Month Budget     Month Actual       Gross Billings Bad Debt Collections
Patient  Revenues             60,000,000                 60,000,000                56,359,028 Medically Indigent Program      2,363,580.00               8,244.00        809,524.00
Cafeteria Sales                500,000                     500,000                   382,444 Medicaid      2,244,168.00            31,321.00        767,015.00
HRSA Grant                  46,908                       46,908   Medicare      2,248,484.00            23,982.00        831,454.00
Healthy Futures             3,700,000                  3,700,000                4,791,666 Pacificare         656,605.00               1,084.00        783,260.00
Healthy Futures - Pt Education                100,000                     100,000   Staywell      1,590,616.00                  966.00    1,148,209.00
Compact Impact Funds             3,200,000                  3,200,000                5,457,575 Calvo's         540,718.00        168,716.00
Misc Revenues                  50,000                       50,000                   419,799 Net care         324,840.00        176,896.00
FEMA                                  -   Commercial         141,953.00  
GovGuam Subsidy             5,100,000                  5,100,000   Miscellaneous         120,335.00               1,017.00          82,822.00
Insurance Settlement                   730,844 Nanbo  
Charitable Donations                100,000                     100,000                      35,137 FSM  
GTA Sale Proceeds                5,000,000 GOG            34,480.00                    46.52            5,152.00
Total Collections           72,796,908               72,796,908              73,176,493 Healthy Futures Fund    1,950,000.00
    Self-Pay      2,150,062.00          320,593.00        360,835.00
Salaries           30,380,099               30,380,099              30,550,228 DRT     21,702,247.00          54,156.00
Specialty Pay                679,317                     679,317                   503,397 Collection Agencies  
Benefits             8,640,252                  8,640,252                7,963,266   CAOG       4,123,267.00          37,071.00
Annual Lump Sum                                  -                      57,478   GMMS       2,745,687.00          20,806.00
Other Pay             1,825,384                  1,825,384                3,284,319   SAVANT       3,759,475.00          12,406.00
Overtime             2,227,101                  2,227,101                2,013,794   UPCA          402,143.00  
Total Salaries & Benefits           43,752,153               43,752,153              44,372,482 Total        12,415,841.00     33,120,072.52    7,208,322.00
Travel & Training                204,850                     204,850                   121,565
Contractual Services             8,950,172                  8,950,172                9,772,251 Accounts Receivable (Net)
Supplies & Materials           10,933,289               10,933,289              11,782,119 Medically Indigent Program              6,860,553
Minor Equipment                312,327                     312,327                   235,386 GovGuam          1,830,651
Miscellaneous                284,513                     284,513                   186,274 Self Pay          2,841,787
Utilities             2,215,120                  2,215,120                1,980,484 Medicare          2,499,878
Capital Outlay             3,292,803                  3,292,803                   593,234 Medicaid          5,182,323
Debt Service             2,851,681                  2,851,681                   249,777 Commercial          6,171,660
Total Cash Disbursements           72,796,908               72,796,908              69,293,572 Total A/R (Net)        25,386,852
Surplus /(Deficit)                               -                                    -                  3,882,921          
Accounts Payable Aging
09/30/05
    0 - 30   31 - 60   61 - 90   Over 90   Total
House Doctors                     1,670                       80,081                      35,026                     25,452                   142,229
Trade Payables                583,547                     601,760                   204,039                   496,263                1,885,609
Payroll Payables                                -
  - Gov Ret DBP                153,039                1,047,537                1,200,576
  - Gov Ret DCP                                -
  - Dept of Rev                                -
GTA                                -
GPA                     119,756                                1                   588,284                   708,041
GWA                  18,864                            (53)                     18,811
Unbilled P O Receipts                                -
Total                  757,120                       801,597                     239,066                  2,157,483                  3,955,266
   
Accounts Receivable Aging
09/30/05
    0 - 30   31 - 60   61 - 90   Over 90   Total
Medically Indigent Program             3,564,629                  1,119,782                   838,774                9,391,060              14,914,245
Self Pay             3,195,852                  1,391,249                1,240,549              23,189,942              29,017,592
Medicare             2,808,051                     545,842                   274,428                1,806,197                5,434,518
Medicaid             1,525,712                  1,256,178                1,468,188                7,015,842              11,265,920
GovGuam                  40,253                         3,958                        7,232                1,982,614                2,034,057
Commercial             3,864,966                  1,751,763                   649,259                7,448,811              13,714,799
Total             14,999,463                    6,068,772                  4,478,430                50,834,466                76,381,131