Budget Comparison (Cash Basis) Billing, Collection & Denials
  FY 2005 FY 2005 FY 2005 07/31/05
    Approved   10 Month Budget   10 Month Actual       Gross Billings Bad Debt Collections
Patient  Revenues             60,000,000                 50,000,000                46,214,942 Medically Indigent Program      2,500,105           21,484            874,332
Cafeteria Sales                500,000                     416,667                   314,585 Medicaid      1,438,908           37,510            909,370
HRSA Grant                  46,908                       39,090   Medicare      1,759,388           17,826         1,149,036
Healthy Futures             3,700,000                  3,083,333                2,349,999 Pacificare         716,612             1,119            547,803
Healthy Futures - Pt Education                100,000                       83,333   Staywell      1,166,647                 966            795,716
Compact Impact Funds             3,200,000                  2,666,667                2,225,000 Calvo's         149,803            310,775
Misc Revenues                  50,000                       41,667                   393,214 Net care         171,108            196,506
FEMA                                  -   Commercial           94,521                 869  
GovGuam Subsidy             5,100,000                  4,250,000   Miscellaneous           23,448              78,442
Insurance Settlement 730844 Nanbo  
Charitable Donations                100,000                       83,333                      35,137 FSM  
Total Collections           72,796,908               60,664,090              52,263,721 GOG           18,822                 993              27,762
    Healthy Futures Fund  
Salaries           30,380,099               25,316,749              24,860,028 Self-Pay      1,329,861         225,848            348,260
Specialty Pay                679,317                     566,098                   421,512 DRT   21,875,718            327,060
Benefits             8,640,252                  7,200,210                6,365,869 Collection Agencies  
Annual Lump Sum                                  -                      55,913   CAOG      5,330,325              46,906
Other Pay             1,825,384                  1,521,153                2,577,244   GMMS      3,576,536              31,223
Overtime             2,227,101                  1,855,918                1,569,819   SAVANT      3,885,938              17,591
Total Salaries & Benefits           43,752,153               36,460,128              35,850,385   UPCA         408,450  
Travel & Training                204,850                     170,708                   122,097 Total          9,369,223   35,383,582         5,660,782
Contractual Services             8,950,172                  7,458,477                7,123,449
Supplies & Materials           10,933,289                  9,111,074                9,394,088 Accounts Receivable (Net)
Minor Equipment                312,327                     260,273                   244,579 Medically Indigent Program              6,304,942
Miscellaneous                284,513                     237,094                   178,399 GovGuam          2,019,182
Utilities             2,215,120                  1,845,933                1,373,399 Self Pay          3,882,255
Capital Outlay             3,292,803                  2,744,003                   358,433 Medicare          2,216,000
Debt Service             2,851,681                  2,376,401                   261,758 Medicaid          5,674,722
Total Cash Disbursements           72,796,908               60,664,090              54,906,587 Commercial          4,878,538
Surplus /(Deficit)                               -                                    -                 (2,642,866) Total A/R (Net)        24,975,639
                                -
Accounts Payable Aging
07/31/05
    0 - 30   31 - 60   61 - 90   Over 90   Total
House Doctors                  33,737                       64,048                      97,726                   694,207                   889,718
Trade Payables                569,453                  1,223,679                   937,338                3,203,928                5,934,398
Payroll Payables                104,123                                  -                                 -                   104,123
  - Gov Ret DBP                158,175                             616                      89,128                1,604,881                1,852,800
  - Gov Ret DCP                170,214                                  -                   577,629                   747,843
  - Dept of Rev                342,382                     142,010                   286,104                   770,496
GTA                       23,535                             84                     23,619
GPA                     107,471                   106,403                   374,410                   588,284
GWA                       22,966                             47                         (100)                     22,913
Unbilled P O Receipts                572,995                   572,995
Total               1,951,079                    1,584,325                  1,230,726                  6,741,059                11,507,189
Accounts Receivable Aging
07/31/05
    0 - 30   31 - 60   61 - 90   Over 90   Total
Medically Indigent Program             2,961,203                     922,166                   850,873                8,401,054              13,135,296
Self Pay             2,920,242                  1,096,261                1,017,001              26,295,925              31,329,429
Medicare             2,640,918                     237,458                   205,332                1,532,958                4,616,666
Medicaid             1,589,916                  1,422,403                1,148,196                7,661,822              11,822,337
GovGuam                  74,845                       16,590                   295,547                1,856,554                2,243,536
Commercial             3,147,547                  2,190,441                   883,911                3,734,301                9,956,200
Total             13,334,671                    5,885,319                  4,400,860                49,482,614                73,103,464
10
11507189
                               -