Budget Comparison (Cash Basis)   Billing, Collection & Denials
  FY 2007 FY 2007 FY 2007   11/30/06  
    Approved   2 Month Budget   2 Month Actual     Gross Billings Bad Debt Collections
                Medically Indigent Program           1,453,868                 3,502           456,606
Patient  Revenues         61,097,228             10,182,871 $11,670,349   Medicaid           1,636,396               13,924           832,638
Cafeteria Sales/Other Revenues              600,000                  100,000                 165,724   Medicare           2,085,437               24,735           868,418
ANA Grant                           -   TakeCare              590,448                    876           464,506
Advanced Appropriations                            -                           -   Staywell              912,318                    966           633,048
Bioterrorism                           -   Select Care              701,840           254,336
Compact Impact Funds           6,300,000               1,050,000     NetCare              323,621           130,607
FMIP Reimbursement                 164,101   Commercial              236,312             78,927
GovGuam Subsidy-General Fund           3,639,977                  606,663     Miscellaneous  
GRT          10,062,795               1,677,133              1,107,171   Nanbo  
Medicare Reimbursement FY03 MCR              4,921,530   FSM  
Bad Debt     GOG               18,657                  (621)             76,248
Charitable Donations     Healthy Futures Fund  
Total Collections         81,700,000             13,616,667            18,028,875 Health Securities Trust Fund  
      Self-Pay           2,258,157              121,641           426,082
      DRT         51,317,195                     -
Salaries         39,709,411               6,618,235              5,498,305   Attorney               63,310  
Specialty Pay           1,025,343                  170,891                 818,477   Collection Agency of Guam           2,992,371             37,081
Benefits         10,644,570               1,774,095              1,618,142   Guam Marianas Collection Agency            2,516,546             13,457
Annual Lump Sum                  16,308   Savant           3,585,243               6,051
Other Pay     United Pacific Collection Agency              401,948  
Overtime           1,909,385                  318,231                 423,409   Total             10,217,054           61,041,634           4,278,007
Total Salaries & Benefits         53,288,709               8,881,452              8,374,641  
     
Travel & Training                40,444                     6,741                  31,353   Accounts Receivable (Net)
Contractual Services         11,200,657               1,866,776              1,620,735   Medically Indigent Program           5,248,312 21.09%
Supplies & Materials         13,252,694               2,208,783              3,928,453   GovGuam              960,430 3.86%
Miscellaneous              682,345                  113,722                  85,471   Self Pay           7,967,152 32.01%
Utilities           2,324,865                  387,478                 466,941   Medicare           2,209,763 8.88%
Capital Outlay              534,439                   89,073                 556,585   Medicaid           5,207,350 20.92%
Debt Service                            -                  86,966   Commercial           3,295,372 13.24%
Minor Equipmant              375,847      
Total Cash Disbursements         81,700,000             13,554,025            15,151,145   Total A/R (Net)      24,888,379   100.00%
Surplus /(Deficit)                        2,877,730                              (0)    
Accounts Payable Aging  
11/30/06
    0 - 30   31 - 60   61 - 90 Over 90   Total  
House Doctors                 9,194                     1,841                    6,625                  73,636                  91,296  
Trade Payables              616,749               1,306,256              1,087,937              1,397,138              4,408,079  
Payroll Payables                66,768                  66,768  
  - Gov Ret DBP              161,140                161,140  
  - Gov Ret DCP              209,164                209,164  
  - Dept of Rev              222,492                  384,300                606,792  
GTA                          -  
GPA                  127,300                127,300  
GWA                 2,364                        880                        99                    3,343  
Unbilled PO Receipts           1,070,075              1,070,075  
Total           2,357,948               1,820,576             1,094,661           1,470,773             6,743,958  
Accounts Receivable Aging
11/30/06
    0 - 30   31 - 60   61 - 90 Over 90   Total  
Commercial           3,650,921               1,894,578                 680,791              3,189,059              9,415,349  
GovGuam              509,938                   58,508                  18,698              2,156,941              2,744,084  
Medicaid           1,957,715               1,393,823              1,404,725            10,121,880            14,878,143  
Medically Indigent Program           3,107,835               1,395,633              1,236,632              9,255,077            14,995,178  
Medicare           2,820,924                  480,435                 413,687              2,598,561              6,313,607  
Self Pay           2,639,280               1,921,606              1,677,753            18,568,744            24,807,384  
Total         14,686,614               7,144,584             5,432,285         45,890,262           73,153,746  
2
2006