| 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 | ||||||||||||