| Budget Comparison (Cash Basis) | Billing, Collection & Denials | ||||||||||||||||
| FY 2006 | FY 2006 | FY 2006 | 12/31/06 | ||||||||||||||
| Approved | 3 Month Budget | 3 Month Actual | Gross Billings | Bad Debt | Collections | ||||||||||||
| Patient Revenues | 53,258,165 | 13,314,541 | 13,610,040 | Medically Indigent Program | 996,013.00 | 3,048.00 | 1,432,174.00 | ||||||||||
| Cafeteria Sales | 600,000 | 150,000 | 174,556 | Medicaid | 1,434,273.00 | 22,651.00 | 787,920.00 | ||||||||||
| HRSA Grant | Medicare | 2,190,724.00 | 16,994.00 | 691,093.00 | |||||||||||||
| Healthy Futures | 4,000,000 | 1,000,000 | Pacificare | 735,894.00 | 1,119.00 | 553,998.00 | |||||||||||
| Healthy Futures - Pt Education | Staywell | 1,284,262.00 | 893,953.00 | ||||||||||||||
| Compact Impact Funds | 3,200,000 | 800,000 | 879,078 | Calvo's | 304,561.00 | 395,641.00 | |||||||||||
| Misc Revenues | Net care | 294,536.00 | 173,691.00 | ||||||||||||||
| FEMA | Commercial | 356,717.00 | |||||||||||||||
| GovGuam Subsidy | 17,958,964 | 4,489,741 | Miscellaneous | 69,473.00 | 43,322.00 | ||||||||||||
| Insurance Settlement | Nanbo | ||||||||||||||||
| Charitable Donations | FSM | ||||||||||||||||
| GTA Sale Proceeds | GOG | 33,947.00 | 47.00 | 37,692.00 | |||||||||||||
| GRT | 1,254,528 | Healthy Futures Fund | |||||||||||||||
| Health Securities Trust Fund | 183,130 | Health Securities Trust Fund | 183,130.00 | ||||||||||||||
| Total Collections | 79,017,129 | 19,754,282 | 16,101,332 | Self-Pay | 1,577,996.00 | 377,771.00 | 321,984.00 | ||||||||||
| DRT | 21,666,246.00 | ||||||||||||||||
| Salaries | 34,884,362 | 8,721,091 | 7,948,793 | Collection Agencies | |||||||||||||
| Specialty Pay | 830,670 | 207,668 | 1,078,513 | CAOG | 3,135,225.00 | ||||||||||||
| Benefits | 9,549,665 | 2,387,416 | 2,072,390 | GMMS | 2,643,435.00 | 13,188.00 | |||||||||||
| Annual Lump Sum | 8,412 | SAVANT | 3,651,348.00 | 10,368.00 | |||||||||||||
| Other Pay | UPCA | 386,187.00 | |||||||||||||||
| Overtime | 2,011,306 | 502,827 | 543,352 | Total | 9,278,396.00 | 31,904,071.00 | 5,538,154.00 | ||||||||||
| Total Salaries & Benefits | 47,276,003 | 11,819,001 | 11,651,460 | ||||||||||||||
| Travel & Training | 100,230 | 25,058 | 43,690 | Accounts Receivable (Net) | |||||||||||||
| Contractual Services | 9,096,233 | 2,274,058 | 1,721,411 | Medically Indigent Program | 6,774,499 | ||||||||||||
| Supplies & Materials | 10,336,019 | 2,584,005 | 2,327,977 | GovGuam | 1,960,734 | ||||||||||||
| Minor Equipment | 192,423 | 48,106 | 47,024 | Self Pay | 3,644,133 | ||||||||||||
| Miscellaneous | 284,678 | 71,170 | 45,604 | Medicare | 2,637,441 | ||||||||||||
| Utilities | 1,987,615 | 496,904 | 300,427 | Medicaid | 6,633,574 | ||||||||||||
| Capital Outlay | 2,896,928 | 724,232 | 181,443 | Commercial | 5,525,020 | ||||||||||||
| Debt Service | 6,847,000 | 1,711,748 | Total A/R (Net) | 27,175,401 | |||||||||||||
| Total Cash Disbursements | 79,017,129 | 19,754,282 | 16,319,036 | - | |||||||||||||
| Surplus /(Deficit) | - | - | (217,704) | ||||||||||||||
| Accounts Payable Aging | |||||||||||||||||
| 12/31/06 | |||||||||||||||||
| 0 - 30 | 31 - 60 | 61 - 90 | Over 90 | Total | |||||||||||||
| House Doctors | 74,160 | 3,599 | 20,744 | 182,998 | 281,501 | ||||||||||||
| Trade Payables | 1,090,644 | 749,370 | 602,955 | 1,254,403 | 3,697,372 | ||||||||||||
| Payroll Payables | 118,660 | 118,660 | |||||||||||||||
| - Gov Ret DBP | (351,107) | 984,160 | 633,053 | ||||||||||||||
| - Gov Ret DCP | - | ||||||||||||||||
| - Dept of Rev | 186,213 | 186,213 | |||||||||||||||
| GTA | - | - | |||||||||||||||
| GPA | 116,804 | 118,674 | 430,600 | 666,078 | |||||||||||||
| GWA | 1,136 | 15,710 | (703) | 430 | 16,573 | ||||||||||||
| Unbilled P O Receipts | 582,414 | 582,414 | |||||||||||||||
| Total | 1,818,924 | 768,679 | 741,670 | 2,852,591 | 6,181,864 | ||||||||||||
| - | |||||||||||||||||
| Accounts Receivable Aging | |||||||||||||||||
| 12/31/06 | |||||||||||||||||
| 0 - 30 | 31 - 60 | 61 - 90 | Over 90 | Total | |||||||||||||
| Commercial | 3,730,979 | 2,100,690 | 715,312 | 4,016,429 | 10,563,410 | ||||||||||||
| GovGuam | 42,691 | 21,053 | 46,464 | 2,030,004 | 2,140,212 | ||||||||||||
| Medicaid | 1,637,424 | 1,463,596 | 1,416,853 | 9,790,959 | 14,308,832 | ||||||||||||
| Medically Indigent Program | 3,099,065 | 1,272,606 | 790,127 | 10,091,001 | 15,252,799 | ||||||||||||
| Medicare | 2,599,600 | 181,615 | 159,851 | 2,199,028 | 5,140,094 | ||||||||||||
| Self Pay | 3,796,483 | 1,326,094 | 1,522,238 | 30,330,151 | 36,974,966 | ||||||||||||
| Total | 14,906,242 | 6,365,654 | 4,650,845 | 58,457,572 | 84,380,313 | ||||||||||||
| 3 | |||||||||||||||||
| 2006 | |||||||||||||||||