Budget Comparison (Cash Basis) Billing, Collection & Denials
  FY 2005 FY 2005 FY 2005 08/31/05
    Approved   11 Month Budget   11 Month Actual       Gross Billings Bad Debt Collections
Patient  Revenues             60,000,000                 55,000,000                51,100,456 Medically Indigent Program      3,860,582.00            20,421.00    1,654,581.00
Cafeteria Sales                500,000                     458,333                   349,459 Medicaid      1,693,764.00            35,373.00       279,549.00
HRSA Grant                  46,908                       42,999   Medicare      2,326,521.00            16,451.00       658,625.00
Healthy Futures             3,700,000                  3,391,667                2,841,666 Pacificare         741,752.00              1,767.00       318,017.00
Healthy Futures - Pt Education                100,000                       91,667   Staywell      1,337,434.00                 966.00    1,060,894.00
Compact Impact Funds             3,200,000                  2,933,333                5,306,785 Calvo's         245,099.00           1,749.00
Misc Revenues                  50,000                       45,833                   402,639 Net care         197,537.00       115,928.00
FEMA                                  -   Commercial         120,401.00              1,017.00  
GovGuam Subsidy             5,100,000                  4,675,000   Miscellaneous            84,527.00         74,966.00
Insurance Settlement                   730,844 Nanbo         68,909.00
Charitable Donations                100,000                       91,667                      35,137 FSM  
GTA Sale Proceeds                5,000,000 GOG            26,179.00                   46.00           9,320.00
Total Collections           72,796,908               66,730,499              65,766,986 Healthy Futures Fund       491,667.00
    Self-Pay      2,083,794.00         253,583.00       376,809.00
Salaries           30,380,099               27,848,424              27,443,610 DRT    21,841,205.00  
Specialty Pay                679,317                     622,707                   453,877 Collection Agencies  
Benefits             8,640,252                  7,920,231                7,018,419   CAOG      5,346,258.00         42,214.00
Annual Lump Sum                                  -                      57,478   GMMS      3,603,807.00         22,056.00
Other Pay             1,825,384                  1,673,269                2,804,178   SAVANT      3,881,652.00         15,611.00
Overtime             2,227,101                  2,041,509                1,767,614   UPCA         408,450.00  
Total Salaries & Benefits           43,752,153               40,106,140              39,545,176 Total        12,717,590.00    35,410,996.00    5,190,895.00
Travel & Training                204,850                     187,779                   122,327
Contractual Services             8,950,172                  8,204,324                8,119,659 Accounts Receivable (Net)
Supplies & Materials           10,933,289               10,022,182              10,499,665 Medically Indigent Program              6,511,752
Minor Equipment                312,327                     286,300                   234,123 GovGuam          1,823,072
Miscellaneous                284,513                     260,804                   181,574 Self Pay          3,233,443
Utilities             2,215,120                  2,030,527                1,645,210 Medicare          2,920,816
Capital Outlay             3,292,803                  3,018,403                   576,708 Medicaid          5,663,993
Debt Service             2,851,681                  2,614,041                   307,094 Commercial          4,661,540
Total Cash Disbursements           72,796,908               66,730,499              61,231,536 Total A/R (Net)        24,814,616
Surplus /(Deficit)                               -                                    -                  4,535,450                                 -
Accounts Payable Aging
08/31/05
    0 - 30   31 - 60   61 - 90   Over 90   Total
House Doctors                     6,123                       20,660                        7,734                             32                     34,549
Trade Payables                536,625                     355,154                   186,619                   638,519                1,716,917
Payroll Payables                                -
  - Gov Ret DBP                153,744                           616                1,046,921                1,201,281
  - Gov Ret DCP                178,094                   178,094
  - Dept of Rev                172,613                   172,613
GTA                  23,674                             32                     23,706
GPA                  45,965                     106,545                   107,471                   480,813                   740,794
GWA                  17,401                            (53)                     17,348
Unbilled P O Receipts             2,643,470                2,643,470
Total               3,777,709                       482,359                     302,472                  2,166,232                  6,728,772
                               -
Accounts Receivable Aging
08/31/05
    0 - 30   31 - 60   61 - 90   Over 90   Total
Medically Indigent Program             3,362,238                     765,945                   988,180                8,738,429              13,854,792
Self Pay             3,206,010                  1,230,049                1,114,370              27,351,905              32,902,334
Medicare             3,337,359                     902,753                   205,091                1,769,299                6,214,502
Medicaid             1,603,419                  1,327,597                1,627,225                7,492,808              12,051,049
GovGuam                  30,099                         9,062                      10,813                1,975,662                2,025,636
Commercial             3,343,651                  2,132,678                   635,016                3,806,824                9,918,169
Total             14,882,776                    6,368,084                  4,580,695                51,134,927                76,966,482
11