Budget Comparison (Cash Basis) Billing, Collection & Denials
  FY 2006 FY 2006 FY 2006 11/30/05
    Approved   2 Month Budget   2 Month Actual       Gross Billings Bad Debt Collections
Patient  Revenues            53,258,165                 8,876,361                8,262,465 Medically Indigent Program      1,341,867.00            5,553.00       335,433.00
Cafeteria Sales              600,000                  100,000                 100,304 Medicaid      1,310,662.00           29,750.00       643,117.00
HRSA Grant   Medicare      2,149,174.00           16,994.00       898,779.00
Healthy Futures           4,000,000                  666,667   Pacificare         683,147.00            1,119.00       556,197.00
Healthy Futures - Pt Education   Staywell      1,459,202.00               966.00       664,084.00
Compact Impact Funds           3,200,000                  533,333                 678,589 Calvo's         539,018.00       257,795.00
Misc Revenues   Net care         227,221.00       268,014.00
FEMA   Commercial         106,260.00               138.00         78,483.00
GovGuam Subsidy          17,958,964               2,993,161                 684,705 Miscellaneous          49,696.00  
Insurance Settlement   Nanbo  
Charitable Donations   FSM  
GTA Sale Proceeds   GOG          32,616.00                 47.00         31,162.00
Total Collections          79,017,129             13,169,522              9,726,063 Healthy Futures Fund  
    Self-Pay      1,693,330.00         293,439.00       318,002.00
Salaries          34,884,362               5,814,060              5,320,296 DRT     21,681,280.00          6,300.00
Specialty Pay              830,670                  138,445                 738,408 Collection Agencies  
Benefits           9,549,665               1,591,611              1,386,297   CAOG      3,160,082.00         34,104.00
Annual Lump Sum                    4,140   GMMS      2,681,016.00         15,317.00
Other Pay     SAVANT      3,680,675.00         12,120.00
Overtime           2,011,306                  335,218                 349,905   UPCA         385,221.00  
Total Salaries & Benefits          47,276,003               7,879,334              7,799,046 Total          9,592,193.00     31,936,280.00    4,118,907.00
Travel & Training              100,230                   16,705                  19,290
Contractual Services           9,096,233               1,516,039              1,266,609 Accounts Receivable (Net)
Supplies & Materials          10,336,019               1,722,670              1,715,379 Medically Indigent Program              6,573,266
Minor Equipment              192,423                   32,071                  38,586 GovGuam          1,902,491
Miscellaneous              284,678                   47,446                  49,260 Self Pay          3,535,886
Utilities           1,987,615                  331,269                 155,932 Medicare          2,559,097
Capital Outlay           2,896,928                  482,821                 162,427 Medicaid          6,436,527
Debt Service           6,847,000               1,141,167   Commercial          5,360,902
Total Cash Disbursements          79,017,129             13,169,522            11,206,529 Total A/R (Net)       26,368,169
Surplus /(Deficit)                          -                             -              (1,480,466)                             -
Accounts Payable Aging
11/30/05
    0 - 30   31 - 60   61 - 90   Over 90   Total
House Doctors                35,967                   61,700                  34,525                107,445                239,637
Trade Payables              562,110                  761,412                 749,374                706,179              2,779,075
Payroll Payables                          -
  - Gov Ret DBP              1,047,537              1,047,537
  - Gov Ret DCP                          -
  - Dept of Rev              191,568                191,568
GTA                21,217                  21,217
GPA                  117,469                494,347                611,816
GWA              (16,456)                   52,097                  18,864                       (53)                  54,452
Unbilled P O Receipts              692,804                692,804
Total           1,487,210                  992,678                 802,763              2,355,455              5,638,106
                         -
Accounts Receivable Aging
11/30/05
    0 - 30   31 - 60   61 - 90   Over 90   Total
Commercial           3,608,035               2,273,856              1,018,937              5,012,287            11,913,115
GovGuam                77,764                   57,063                  16,092              2,087,306              2,238,225
Medicaid           1,913,997               1,326,577              1,292,370              9,770,450            14,303,394
Medically Indigent Program           3,763,607                  752,144              1,228,643            10,688,770            16,433,164
Medicare           2,927,312                  461,735                 137,088              2,160,747              5,686,882
Self Pay           3,309,994               1,483,865              1,463,791            27,529,468            33,787,118
Total          15,600,709               6,355,240              5,156,921            57,249,028            84,361,898
2
2006