Budget Comparison (Cash Basis) Billing, Collection & Denials
  FY 2006 FY 2006 FY 2006 02/28/06
    Approved   5 Month Budget   5 Month Actual       Gross Billings Bad Debt Collections
Patient  Revenues            53,258,165               22,190,902              22,482,957 Medically Indigent Program          1,322,933                 2,902            389,546
Cafeteria Sales              600,000                  250,000                 283,339 Medicaid          1,768,827               14,966            421,532
HRSA Grant   Medicare          2,214,595               16,994            555,746
Healthy Futures           4,000,000               1,666,667   Pacificare          1,110,887                    899            681,284
Healthy Futures - Pt Education   Staywell          1,152,896                    966         1,321,467
Compact Impact Funds           3,200,000               1,333,333                 997,875 Calvo's             509,920            165,309
Misc Revenues   Net care             271,772            621,304
FEMA   Commercial             267,140  
GovGuam Subsidy          17,958,964               7,482,902   Miscellaneous             121,391                    800            158,207
Insurance Settlement   Nanbo  
Charitable Donations   FSM  
GTA Sale Proceeds   GOG               27,655                     47             27,847
GRT                 2,673,547 Self-Pay          1,418,860              272,081            406,441
Health Securities Trust Fund                   183,130 DRT         21,619,007            110,848
Total Collections          79,017,129             32,923,804            26,620,848 Collection Agencies  
      CAOG           3,078,189             34,905
Salaries          34,884,362             14,535,151            13,246,113   GMMS           2,587,410             15,009
Specialty Pay              830,670                  346,113              1,737,637   SAVANT           3,639,020               9,627
Benefits           9,549,665               3,979,027              3,476,822   UPCA              385,221  
Annual Lump Sum                  29,226 Total             10,186,876         31,618,502         4,919,072
Other Pay                            -
Overtime           2,011,306                  838,044                 906,876
Total Salaries & Benefits          47,276,003             19,698,335            19,396,674
Travel & Training              100,230                   41,763                  61,815 Accounts Receivable (Net)
Contractual Services           9,096,233               3,790,097              2,568,796 Medically Indigent Program          6,120,008
Supplies & Materials          10,336,019               4,306,675              4,262,495 GovGuam          1,674,471
Minor Equipment              192,423                   80,176                  74,204 Self Pay          4,411,204
Miscellaneous              284,678                  118,616                  62,370 Medicare          2,328,135
Utilities           1,987,615                  828,173                 304,121 Medicaid          6,569,312
Capital Outlay           2,896,928               1,207,053                 224,145 Commercial          6,639,119
Debt Service           6,847,000               2,852,916   Total A/R (Net)       27,742,249
Total Cash Disbursements          79,017,129             32,923,804            26,954,620                             -
Surplus /(Deficit)                          -                             -                 (333,772)
Accounts Payable Aging
02/28/06
    0 - 30   31 - 60   61 - 90   Over 90   Total
House Doctors                52,680                   39,537                  11,787                274,655                378,659
Trade Payables              738,919               1,148,172              1,009,833              1,464,719              4,361,643
Payroll Payables              197,775                  171,338                       287                369,400
  - Gov Ret DBP              161,476                (524,964)                984,160                620,672
  - Gov Ret DCP              188,665                188,665
  - Dept of Rev              340,799                  349,199                689,998
GTA                23,556                  23,556
GPA              119,164                  116,804                450,018                685,986
GWA                22,654                   16,842                  16,150                      423                  56,069
Unbilled P O Receipts           1,107,659              1,107,659
Total           2,953,347               1,316,928              1,038,057              3,173,975              8,482,307
                         -
Accounts Receivable Aging
02/28/06
    0 - 30   31 - 60   61 - 90   Over 90   Total
Commercial           3,406,907               2,228,432                 851,105              3,822,710            10,309,154
GovGuam                44,573                   10,910                    6,878              2,025,252              2,087,613
Medicaid           1,743,067               1,354,299              1,354,088            10,147,018            14,598,472
Medically Indigent Program           2,905,790               1,125,068              1,036,661            10,482,501            15,550,020
Medicare           2,818,579                  224,496                  50,893              2,203,245              5,297,213
Self Pay           3,597,671               1,393,211              1,448,756            33,584,235            40,023,873
Total          14,516,587               6,336,416              4,748,381            62,264,961            87,866,345