Budget Comparison (Cash Basis)   Billing, Collection & Denials
  FY 2006 FY 2006 FY 2006 FY 2007 09/30/06  
    Approved   12 Month Budget   12 Month Actual Approved     Gross Billings Bad Debt Collections
Patient  Revenues           52,675,260               52,675,260              56,323,089            61,097,228 Medically Indigent Program           1,163,050                    760         1,077,721
Cafeteria Sales              600,000                  600,000                 743,678                 600,000 Medicaid           1,407,039               12,250  
ANA Grant                    5,713   Medicare           2,191,486               16,402           732,258
Health Securities Trust Fund              283,130                  283,130                 466,260   PacifiCare              722,528           485,179
Health Securities Trust Fund Series B           3,500,000               3,500,000     Staywell           1,232,111                    966           699,407
Compact Impact Funds           3,700,000               3,700,000              5,081,027              6,300,000 Select Care              344,611           268,435
Bioterrorism                 646,460   Net care              308,243           286,105
FEMA                 184,424   Commercial              197,202             77,253
GovGuam Subsidy                3,639,977 Miscellaneous  
Bad Debt           1,027,527               1,027,527              1,027,527   Nanbo               8,384
Charitable Donations     FSM  
Advanced Appropriations           7,800,000               7,800,000     GOG               31,215                  (621)               3,011
GRT            9,431,212               9,431,212              8,421,521            10,062,795 Healthy Futures Fund  
Medicare Reimbursement FY03 MCR                            -              1,457,016   Health Securities Trust Fund  
Total Collections         79,017,129             79,017,129            74,356,715            81,700,000 Self-Pay           2,164,388              121,325           435,566
      DRT         24,790,667             41,993
Salaries         34,884,362             34,884,362            35,260,272            39,009,411  Attorney               64,105  
Specialty Pay              830,670                  830,670              4,211,961              1,144,703  Collection Agency of Guam           3,064,693  
Benefits           9,549,665               9,549,665              9,219,527            10,644,570  Guam Marianas Collection Agency            2,500,513             11,623
Annual Lump Sum                 132,846    Savant           3,597,194               6,883
Other Pay      United Pacific Collection Agency              402,080  
Overtime           2,011,306               2,011,306              2,547,632              1,790,025 Total               9,761,873           34,570,334           4,133,818
Total Salaries & Benefits         47,276,003             47,276,003            51,372,238            52,588,709                     0
     
Travel & Training              100,230                  100,230                 200,857                  36,900 Accounts Receivable (Net)
Contractual Services           9,096,233               9,096,233              5,240,070            11,882,372 Medically Indigent Program           6,820,295 22.28%
Supplies & Materials         10,336,019             10,336,020            14,194,092            13,268,304 GovGuam           1,259,264 4.11%
Miscellaneous              477,101                  477,099                 804,848                 688,564 Self Pay           7,723,921 25.23%
Utilities           1,987,615               1,987,615              2,016,910              2,324,865 Medicare           2,954,667 9.65%
Capital Outlay           2,896,928               2,896,928              2,328,205                 561,439 Medicaid           8,417,065 27.49%
Debt Service           6,847,000               6,847,001                 478,313   Commercial           3,442,606 11.24%
Minor Equipmant                 348,847    
Total Cash Disbursements         79,017,129             79,017,129            76,635,533            81,700,000 Total A/R (Net)      30,617,818   100.00%
Surplus /(Deficit)                          -                  (2,278,818)                              (0)    
Accounts Payable Aging  
09/30/06
    0 - 30   31 - 60   61 - 90 Over 90   Total  
House Doctors                    152                       273                 434,225                434,650  
Trade Payables              527,326               1,134,967              2,378,221              1,486,023              5,526,537  
Payroll Payables              187,588                   91,609                279,197  
  - Gov Ret DBP              157,829                 135,163                292,991  
  - Gov Ret DCP                          -  
  - Dept of Rev              395,113                  368,768                 395,114              1,084,758              2,243,753  
GTA                          -  
GPA                          -  
GWA                 1,069                   17,061                        51                  18,180  
Unbilled PO Receipts              220,003                220,003  
Total           1,489,079               1,612,405             2,773,658           3,140,169             9,015,312  
Accounts Receivable Aging
09/30/06
    0 - 30   31 - 60   61 - 90 Over 90   Total  
Commercial           3,000,512               1,102,581                 265,537              2,803,435              7,172,065  
GovGuam              424,361                   40,480                  27,009              2,131,617              2,623,467  
Medicaid           1,901,343               1,820,709              1,396,452            12,417,047            17,535,551  
Medically Indigent Program           3,458,706                   91,845                 108,199              2,496,808              6,155,558  
Medicare           3,043,490               1,110,667              1,036,392              9,320,716            14,511,265  
Self Pay           3,403,349               1,716,718              1,462,274            41,625,925            48,208,266  
Total         15,231,761               5,883,000             4,295,863         70,795,548           96,206,172  
12
2006