The URL can be used to link to this page

2019-01-02 CC MINUTESCalhoun County Commissioners' Court—January 02, 2019 REGULAR 2018 TERM § JANUARY 02, 2019 BE IT REMEMBERED THAT ON JANUARY 02, 2019, THERE WAS BEGUN AND HOLDEN A REGULAR TERM OF COMMISSIONERS' COURT. 1. CALL TO ORDER 2. ROLL CALL THE FOLLOWING MEMBERS WERE PRESENT: Richard Meyer David Hall Vern Lyssy Clyde Syma Gary Reese Anna Goodman Catherine Sullivan County Judge Commissioner, Precinct #1 Commissioner, Precinct #2 Commissioner, Precinct #3 Commissioner, Precinct #4 County Clerk Deputy County Clerk 3. INVOCATION & PLEDGE OF ALLEGIANCE (AGENDA ITEM NO. 2 & 3) Invocation — Commissioner David Hall Pledge to US Flag & Texas Flag — Commissioner Gary Reese/Vern Lyssy 4. HEAR REPORT FROM MEMORIAL MEDICAL CENTER. (AGENDA ITEM NO. 4) Jason Anglin and Diane Moore presented report. Page 1 of 6 Calhoun County Commissioners' Court — January 02, 2019 5. PUBLIC HEARING (AGENDA ITEM NO. 5) Concerning petition to vacate lots 3 and 4, Block 1 of Outlot 1, Outblock 15 and Outlot 2, Outblock 16, Port O'Connor Townsite Outlots, Resubdivision No 1. (KF) Began: 10:09 A.M. Ended: 10:11 A.M. Terry Ruddick spoke on this matter. 6. CONSIDER AND TAKE NECESSARY ACTION (AGENDA ITEM NO. 6) On request by Seadrift Volunteer Fire Department to apply for credit with 911 Rapid Response. (KF) RESULT: APPROVED [UNANIMOUS] MOVER: Vern Lyssy, Commissioner Pet 2 SECONDER: Gary Reese, Commissioner Pet 4 AYES: Judge Meyer, Commissioner Hall, Lyssy, Syma, Reese 7. Pass order Placing Officials on Salary Basis. (AGENDA ITEM NO. 7) RESULT: APPROVED [UNANIMOUS] MOVER: Vern Lyssy, Commissioner Pet 2 SECONDER: David Hall, Commissioner Pet 1 AYES: Judge Meyer, Commissioner Hall, Lyssy, Syma, Reese 8. Appoint Judge Pro -Tem. (AGENDA ITEM NO. 8) Clyde Syma, Commissioner Pct 3 was appointed. RESULT: APPROVED [UNANIMOUS] MOVER: Vern Lyssy, Commissioner Pet 2 SECONDER: David Hall, Commissioner Pet 1 AYES: Judge Meyer, Commissioner Hall, Lyssy, Syma, Reese Page 2 of 6 Calhoun County Commissioners' Court — January 02, 2019 9. Appoint member to E911 Board. (AGENDA ITEM NO. 9) David Hall was appointed. RESULT: APPROVED [UNANIMOUS] MOVER: Vern Lyssy, Commissioner Pet 2 SECONDER: Gary Reese, Commissioner Pet 4 AYES: Judge Meyer, Commissioner Hall, Lyssy, Syma, Reese 10. Appoint member to the Foreign Trade Zone. (AGENDA ITEM NO. 10) Gary Reese was appointed. RESULT: APPROVED [UNANIMOUS] MOVER: Vern Lyssy, Commissioner Pet 2 SECONDER: David Hall, Commissioner Pet 1 AYES: Judge Meyer, Commissioner Hall, Lyssy, Syma, Reese 11. CONSIDER AND TAKE NECESSARY ACTION (AGENDA ITEM NO. 11) To establish pay for grand jurors and petit jurors for County, District, and Justice of the Peace Courts. (MP) RESULT: APPROVED [UNANIMOUS] MOVER: David Hall, Commissioner Pet 1 SECONDER: Vern Lyssy, Commissioner Pet 2 AYES: Judge Meyer, Commissioner Hall, Lyssy, Syma, Reese 12. CONSIDER AND TAKE NECESSARY ACTION (AGENDA ITEM NO. 12) To change the date of the third meeting in February from February 20, 2019 to February 18, 2019 due to a schedule conflict. (MP) RESULT: APPROVED [UNANIMOUS] MOVER: Gary Reese, Commissioner Pet 4 SECONDER: Vern Lyssy, Commissioner Pet 2 AYES: Judge Meyer, Commissioner Hall, Lyssy, Syma, Reese Page 3 of 6 Calhoun County Commissioners' Court—January 02, 2019 13. ACCEPT REPORTS OF THE FOLLOWING COUNTY OFFICES: (AGENDA ITEM NO. 13) i. Calhoun Tax Assessor/Collector ii. County Treasurer iii. County Sheriff iv. District Clerk — Nov 2018 v. County Clerk vi. Justices of Peace vii. County Auditor viii. Floodplain Administration ix. Extension Service x. Adult Detention Center SHP Medical RESULT: APPROVED [UNANIMOUS] MOVER: Vern Lyssy, Commissioner Pet 2 SECONDER: David Hall, Commissioner Pet 1 AYES: Judge Meyer, Commissioner Hall, Lyssy, Syma, Reese 14. CONSIDER AND TAKE NECESSARY ACTION (AGENDA ITEM NO. 14) To declare certain items of County property in the District Clerk's office as surplus/salvage and remove from inventory. (see list) (MP) RESULT: APPROVED [UNANIMOUS] MOVER: Clyde Syma, Commissioner Pet 3 SECONDER: Gary Reese, Commissioner Pet 4 AYES: Judge Meyer, Commissioner Hall, Lyssy, Syma, Reese 15. CONSIDER AND TAKE NECESSARY ACTION (AGENDA ITEM NO. 15) To transfer certain items of County property in the District Clerk's office to other County offices. (see list) (MP) RESULT: APPROVED [UNANIMOUS] MOVER: Vern Lyssy, Commissioner Pet 2 SECONDER: David Hall, Commissioner Pet 1 AYES: Judge Meyer, Commissioner Hall, Lyssy, Syma, Reese Page 4 of 6 Calhoun County Commissioners' Court—January 02, 2019 16. CONSIDER AND TAKE NECESSARY ACTION (AGENDA ITEM NO. 16) On any necessary budget adjustments. N/A 17. Approval of bills and payroll. MMC Bills RESULT: APPROVED [UNANIMOUS] MOVER: David Hall, Commissioner Pet 1 SECONDER: Vern Lyssy, Commissioner Pet 2 AYES: Judge Meyer, Commissioner Hall, Lyssy, Syma, Reese County Bills RESULT: APPROVED [UNANIMOUS] MOVER: David Hall, Commissioner Pet 1 SECONDER: Vern Lyssy, Commissioner Pet 2 AYES: Judge Meyer, Commissioner Hall, Lyssy, Syma, Reese Page 5 of 6 Calhoun County Commissioners' Court—January 02, 2019 18. PUBLIC DISCUSSION OF COUNTY MATTERS. COURT ADJOURNED: 10:23 AM Page 6 of 6 Calhoun County Corn miss loners' Court—January 02, 2019 REGULAR 2018 TERM 0 JANUARY 02, 2019 BE IT REMEMBERED THAT ON JANUARY 02, 2019, THERE WAS BEGUN AND HOLDEN A REGULAR TERM OF COMMISSIONERS' COURT. 1. CALL TO ORDER 2. ROLL CALL THE FOLLOWING MEMBERS WERE PRESENT: Richard Meyer David Hall Vern Lyssy Clyde Syma Gary Reese Anna Goodman Catherine Sullivan County Judge Commissioner, Precinct #1 Commissioner, Precinct #2 Commissioner, Precinct #3 Commissioner, Precinct #4 County Clerk Deputy County Clerk 3. INVOCATION & PLEDGE OF ALLEGIANCE (AGENDA ITEM NO. 2 & 3) Invocation — Commissioner David Hall Pledge to US Flag & Texas Flag — Commissioner Gary Reese/Vern Lyssy Page 1 of 16 Calhoun County Commissioners' Court—January 02, 2019 4. HEAR REPORT FROM MEMORIAL MEDICAL CENTER. (AGENDA ITEM NO. 4) Jason Anglin and Diane Moore presented report. Page 2 of 16 I/ Memorial Medical Center - Port Lavaca, Texas CEO Report December 12, 2018 Financial Results: rrte�' In Dehad a Net Income of $57,605 decreasing the loss for the year to $758,224. FEMA Diane continues to work with FEMA on potential reimbursements. QIPP Program We toured a facility in Rockport owned by HMG Healthcare. We have on the agenda for approval to add them to our QIPP program. Physician Recruitment Continuing recruitment efforts focusing on Pain Medicine Physician. Specialty Clinic Dr. Kurtis Krueger, Cardiologist from Victoria will started coming to our specialty clinic. Texas Community Development Block Grant Continuing to work on the grant. Two representatives from the State toured our facility. Information on Board Items: Financial Items: 1. Waiver Update on Measure Bundles- Danette & Diane will do a presentation on our Waiver Program with the Measure Bundles. 2. Healthcare Professional & General Liability Insurance— Recommend renewal with same carrier. Renewal cost $28,496 compared to current year of $28,053 an increase of $443. 3. Regulatory/Billing E&O/Cyber Liability Insurance— Recommend renewal with same carrier. Renewal cost $18,589 compared to current year of $18,601 an decrease of $12. 4. Directors & Officers Liability Insurance- Recommend renewal with same carrier. Renewal cost $15,111 is same as current year. 5. Worker's Compensation Insurance- recommend renewal with same carrier. Renewal cost 49,379 compared to current year premium of $44,453, and increase of $4,926. 6. Employee Health / Dental / Ancillary Plans(Basic Life/AD&D, Long Term Disability, Employee Assistance Insurance —As you know for our employee medical and dental insurance MMC has had a self-funded plan with reinsurance. Each year we have looked for both self-funded and fully insured options. In the past fully insured have either declined to quote or were cost prohibited. Surprisingly, this year we received a very good fully insured proposal from Blue Cross. Our recommendation is to change to the fully insured Blue Cross Option for Medical and Dental. To continue encouraging the use of MMC and keep similar benefit level, with this recommendation we recommend waiving the co-insurance and deductibles at MMC and waiving part of the ER and Clinic Copay at Memorial Medical Clinic to enable to match current copays levels of $50 in the ER and $20 at Memorial Medical Clinic. For Ancillary Plans we recommend staying with current carriers. 7. MRI Upgrade -We would like to discuss upgrades to our current MRI machine. We have had this scanner since 2009 and are currently on software version 3.0. This will upgrade us to the current software version and platform to bring MMC up to the newest magnet that Hitachi sells currently. Cost for upgrade is $75,000. 8. GE Fluoroscopic Room -In our Imaging Department we have two X-ray Machines. Our older machine also has fluoroscopic capability. We have been notified that by the vender that as of March 2019 the x-ray/fluoroscopic equipment is deemed at end of life and they will no longer service the equipment. We would like to discuss replacing the equipment at this time. Please see attached proposal for $303,000. 9. Coding Service Agreement — We would like to contract with a coding company for them to do our E&M coding at our clinic. 10. Financial Assistance Policy -In working with our accounting firm on cost report items, BKD recommended additional modifications to our Financial Assistance Policy. 11. Filing of change of ownership paperwork for operations of nursing facility— We have met with executives from HMG Healthcare, LLC regarding a nursing home facility in Rockport in terms of working with them on the QIPP program. We believe they would be a good addition to our QIPP program participation. Non -Financial Items: 1, Update on Eide Baily Chart review— Diane will provide an update regarding the chart review. Closed Session: We have closed sessions posted for (1) Quality and (2) Legal. Respectfully, Jason Anglin, CEO Memorial Medical Center Memorial Medical Center Financial Report For the Month of: November 2018 Overview: In October, we had a Net Profit of $57,605, decreasing the YTD (year to date) 2018 loss to $758,224. Memorial Medical Clinic had a EBITDA in November, a loss of $99,363 and a total EBITDA profit YTD of $299,659. The DSRIP waiver project reporting was completed in October 2018. The data posted was the benchmarks for a total of 12 different objectives for C1 Primary Care Prevention (9) and C2 Primary Care Prevention (3) for 2018, based on the 2017 activity. Based on comparing our actual achievements for the first 9 months of 2018 and the 2018 full year objectives, there are a few DSRIP objectives that will not be achieved at 100%. (Please see the summary for the details.) We had accrued the potential monies at less than the total available, so based on the accrual Memorial Medical Center does not have a financial reduction in our accrual or a reduction in our net revenue in our financial statements. Inpatient volume decreased 17.1%, the overall revenue deductions decreased from the previous month. Statistics: November Highlights on Volumes: Key volumes in November as compared to October include: Average daily census 6.47 a decrease from October's 7.80 ER Visits down .2% from 683 to 671 visits. Clinic Visits down 5% from 2,653 to 2,521 visits. Surgery up 6% from 80 to 85 cases. Imaging up 1%. Lab up 7%. Rehab up 14%. Program Hope stayed flat Private Pay utilization decreased from 20.2% to 17.1% of Revenue. Hospital—October's Self Pay was $1,078,833 compared to November's $906,014 a decrease of $172,819. November of 2017 Self Pay revenue was $759,083 — an increase of $146,831. Balance Sheet Highlights: ASSETS Bank Accounts Cash and Investment balances ended the month at $3,797,833, of which $747,171, is Nursing Home monies. This leaves the hospital with $3,050,294 which is an increase of $320,573 from October. However, we decreased our Private Waiver account by $704,615. At the end of October, we had 42.14 days of cash expenses on hand in hospital funds, which is an increase of 14.16 days from October. Accounts Receivable Patient Accounts Receivable balances were $11,898,546 for the hospital and $760,805 for the clinic. Net AR combined is $1,805,054. The AR increased $106,990 in November. Accounts Receivable — Other The balance in Other A/R increased by $795,096. The increase was due to the reconciliation of the DSRIP waiver and the IGT for the QIPP Nursing Home. The balance at the end of November is $3,287,285. Accounts Receivable Nursing Home The nursing homes ended October with $7,689,693 in receivables. Accounts Receivable Est. 31a Party Paver Settlements Our books reflect a net due from third party payers of $607,500. This consist of $382,212 which is an estimated amount due from Medicare for 2017, estimated due from Medicare $225,388 for 2018. We received a partial payment for the Medicare 2017. LIABILITIES Accounts Payable The balance in payments due to vendors and accruals at the end of the month was $1,054,646 up by $190,204 from $864,442 in October. Accounts payable invoices received are at $1,674,552 vs $764,380 at the end of October. Due to Nursing Homes The balance due to Nursing Homes decreased to $9,173,274. Accrued Expenses We carried accrued payroll and benefits payable to hospital employees totaling $1,178,524 which is down from $1,357,816 in October. Accrued Intergovernmental Transfers IGT liability is $895,246 at the end of November. Leases Payable The hospital has $1,007,522 in capital leases total both long term and short term. Long-term portion also included below. Long Term Debt, Net of Current: The total is $3,659,230. This consists of $2,730,075 in Pension liability and $929,155 the long term portion of leases. Current Ratio The ratio between our current assets and current liabilities is 1.45 at the end of November. This is lower than our benchmark of 2.3 Income Statement: Gross patient revenue for hospital and clinic was $5,689,530 which is a decrease of $91,066 from October. Revenue Deductions were at 59.8% compared to 66.3% in October. Total Operating Revenue November 2018 as compared to YTD from November 2017, we are up by $234,730. This is due to the following: • Overall Patient Revenue is up $2,011,630 o Self -pay revenue YTD is up $2,042,290 • Overall Deductions are up $2,101,225 o Contractual expense down $230,195 o Charity is up $5,611,320 o Bad Debt is down $3,310,867 • Net Charity and Bad Debt is up $2,300,452 o Indigent is down $498,394 o DSH/UC/DSRIP is down $529,361 • Other Operating Revenue is up $493,525 o Reimbursement for Harvey— Insurance claims $131,870 o 340b is up $158,787 Total November expenses (excluding nursing home) were up from October by $166,813. This was driven by: • Salary expense down $7,187. (One less working day in November) • Benefits and PR Taxes cost up by $100,724 (Medical Insurance costs were up) • Professional Fees were up by $35,383 (Addition of full month of provider and true up with ESS for ER visits) • Purchased Services were up by $58,623 (Edie Bailey $24,100, Studer $9,469, FCC $6,711) • Supplies were down by $7,839 • Insurance was down $2,253 • Utilities were down $9,115 (Due to difference with telephone bill in October) • Other Expenses were down $1,864 • Depreciation was down by $835 Current Period Actual This Budget This Month Month Last Year 863,073 1,323,508 768,726 3,269,161 3,957,990 3,139,198 1,557,296 1,835,766 1,737,579 4,418,968 3,595,089 3,423,563 10,108,498 10,712,353 9,069,066 2,900,263 4,224,624 2,502,817 256,358 131,913 49,968 6,176 41,217 67,361 (493,933) (179,067) (286,271) 733,637 534,285 1,018,687 3,402,500 4,752,971 3,352,562 6,705,997 5,959,382 5,716,504 172,908 61,255 69,375 Memorial Medical Center Income Statement - Combined For the Month Ended November 30, 2018 Revenue Inpatient Revenues Outpatient Revenues ER Revenues Resident Revenues Total Patient Revenue Revenue Deductions Contractuals Charity Indigent Care DSH/UCC/DSRIP Bad Debt Total Revenue Deductions Net Patient Revenue Other Operating Revenue 6,878,906 6,020,636 5,785,879 Total Operating Revenue Operating Expenses Year to Date Actual YTD Budget YTD Last Year YTD 10,907,244 14,558,586 11,602,464 32,814,382 43,537,890 30,765,985 18,124,238 20,193,431 17,465,785 46,814,432 39,545,979 37,014,225 108,660,297 117,835,885 96,848,459 31,135,405 46,470,861 31,365,600 7,105,911 1,451,042 1,494,591 236,531 453,383 734,925 (2,262,713) (1,969,732) (2,792,074) 3,347,754 5,877,130 6,658,622 39,562,888 52,282,685 37,461,663 69,097,408 65,553,200 59,386,796 1,407,604 673,800 914,079 70,505,013 66,227,000 60,300,876 Non Operating Income / (Exp) 1,284 Current Period 81 Investment Income 13,859 Year to Date 8,608 Actual This Budget This (1,904) Interest Expense (39,977) (13,644) (22,149) Month Month Last Year Contributions and Grants Actual YTD Budget YTD Last Year YTD 893,352 936,360 859,655 Salaries & Wages 9,427,600 10,299,956 9,025,694 342,170 290,193 293,790 Employee Benefits & PR Taxes 3,344,974 3,192,128 2,553,686 420,293 329,900 418,348 Professional Fees 4,048,501 3,628,904 4,243,974 370,854 379,870 303,557 Purchased Services 3,478,681 4,178,565 3,201,878 257,979 297,325 227,981 Supplies 2,502,197 3,270,573 2,585,981 1,101 5,716 2,851 Insurance 38,017 62,879 43,108 51,486 46,105 49,223 Utilities 617,383 507,159 526,319 75,652 96,076 86,363. Other Expenses 738,336 1,056,837 1,084,559 4,516,327 3,595,089 3,423,563 Nursing Home Fee 47,521,041 39,545,979 37,142,030 6,929,214 5,976,635 5,665,331 Total Operating Expenses 71,716,731 65,742,980 60,407,229 85,217 80,693 79,154 Depreciation 990,177 887,625 894,283 7,014,432 6,057,328 5,744,485 Total Expenses 72,706,908 66,630,604 61,301,512 (135,526) (36,691) 41,394 Net Operating income/(Loss) (2,201,895) (403,604) (1,000,637) Non Operating Income / (Exp) 1,284 449 81 Investment Income 13,859 4,939 8,608 (2,871) (1,240) (1,904) Interest Expense (39,977) (13,644) (22,149) - 2,691 - Contributions and Grants (2,495) 29,604 - - - - IGT Expense - - - - - - Service Contribution by SOSET - - 455,741 194,717 113,021 - Nursing Home Program 1,472,284 1,243,231 255,610 193,131 114,921 (1,823) Total Non -Operating Revenue 1,443,671 1,264,130 697,809 57,605 78,230 39,571 Total Net Income/ (LOSS) (758,224) 860,526 (302,828) I� Memorial Medical Center Income Statement by Operating Unit For the Month Ended November 30, 2018 Revenue Hospital Current Period Combined 686,123 207,229 Year to Date 893,352 287,772 54,398 Nursing 342,170 215,944 204,349 - Nursing 334,046 Hospital Clinics Homes Combined 42,044 Hospital Clinics Homes Combined 863,073 - - 863,073 Inpatient Revenues 10,907,244 - - 10,907,244 2,811,478 457,683 - 3,269,161 Outpatient Revenues 27,014,943 5,799,439 - 32,814,382 1,557,296 - - 1,557,296 Eft Revenues 18,124,238 - - 18,124,238 - - 4,418,968 4,418,968 Resident Revenues - - 46,814,432 46,814,432 5,231,847 457,683 4,418,968 10,108,498 Total Patient Revenue 56,046,425 5,799,439 46,814,432 108,660,297 Revenue Deductions 2,860,050 40,213 - 2,900,263 Contractuals 29,642,499 1,492,906 - 31,135,405 205,508 50,850 - 256,358 Charity 7,011,255 94,656 - 7,105,911 6,176 - - 6,176 Indigent Care 223,215 13,316 - 236,531 (493,933) - - (493,933) DSH/UCC (2,262,713) - - (2,262,713) 731,838 1,799 - 733,637 Bad Debt 3,315,554 32,200 - 3,347,754 3,309,639 92,862 - 3,402,500 Total Revenue Deductions 37,929,810 1,633,078 - 39,562,888 1,922,209 364,821 4,418,968 6,705,997 Net Patient Revenue 18,116,615 4,166,361 46,814,432 69,097,408 73,707 99,201 - 172,908 Other Operating Revenue 663,067 744,538 - 1,407,604 6,878,906 Total Operating Revenue 18,779,682 4,910,899 46,814,432 70,505,013 1,995,916 464,022 4,418,968 Hospital Current Period Nursing Clinics Homes Combined 686,123 207,229 - 893,352 287,772 54,398 - 342,170 215,944 204,349 - 420,293 334,046 36,808 - 370,854 215,935 42,044 - 257,979 1,101 - - 1,101 51,486 - - 51,486 70,838 4,814 - 75,652 - 4,516,327 4,516,327 1,863,247 549,641 4,516,327 6,929,214 69,217 16,000 - 85,217 1,932,464 565,641 4,516,327 7,014,432 63,451 (101,619) (97,359) (135,526) 1,284 - - 1,284 (2,871) - - (2,871) Operating Expenses Salaries & Wages Employee Benefits & PR Taxes Professional Fees Purchased Services Supplies Insurance Utilities Other Expenses Nursing Home Fee Total Operating Expenses Depreciation Year to Date Nursing Hospital Clinics Homes Combined 7,844,248 1,583,352 - 9,427,600 2,877,523 467,452 - 3,344,974 2,216,210 1,832,292 - 4,048,501 3,186,358 292,323 - 3,478,681 2,292,482 209,715 - 2,502,197 38,017 - - 38,017 617,383 - - 617,383 687,599 50,737 - 738,336 - 47,521,041 47,521,041 19,759,820 4,435,870 47,521,041 71,716,731 814,177 176,000 - 990,177 Total Expenses 20,573,997 4,611,870 47,521,041 72,706,908 Net Operating Income / (Loss) Non Operating Income / (Exp) Investment Income Interest Expense Contributions and Grants IGT Expense Service Contribution by SOSET (1,794,315) 299,028 (706,608) (2,201,895) 13,859 - - 13,859 (39,977) - - (39,977) (2,495) - - (2,495) - 194,717 194,717 Nursing Home Program - 1,472,284 1,472,284 (1,587) - 194,717 193,131 Total Non -Operating Revenue (28,612) - 1,472,284 1,443,671 61,865 (101,619) 97,359 57,605 Total Net income /(Loss) (1,822,927) 299,028 765,675 (758,224) -2- e\ m O t0 o 0 0\\ e 2: o N M n O RI vm I� W O a !rtl M N � � L L m p O O N Vl rl N N 1I1 N N l0 Ill O N •- d L Y V N VI N a VI `I T m `-1 M d' V O l0 a N t( m U O N N a ti VI U O M w V C O w M a � . LL M OMI M ci — N W Ol Ol O t0 Ill Ol a s Ilt Ol a n Ol r OI N m 1t) O lD t0 N M Vl m T Ip r V vl r '-I O I+1 � N OI m t0 OI O O m m 'i M vl W m O a r m Ol V M tt N M VI Ol W a O N N N a N Vl a M IO r O m m a m VI a O V1 O Op O C N W N vl n Ill VI N t0 IYI m O N cl' a m N V ti Vl N N N W m16 M14 O C N N l0 S E N ei lD m' r OI N O OI O O O c a N OI 10 O 1t) OI ifl N N l9 n 1l1 r O O lel `. clV1 � N C1 VI' ll O O m Yl r OI N n O m M LLV4W V!+/� VF VnV?NVT V� VINN t LLah v/Y +/Y Vl Vt Vn Vn Vl V�Li a? N v}v/Y VYh VI L M rl N m Olei V lO M N 0i F N C tll al i� Mm p M h W V O M 1� O O ti a V M M O M 1� O VI T m T O m m V N m N V M A N T W 0 O M N m m O a r (O IO O l0 M O l0 O rl M F 10 a' m MN N V n a N r1 V � O M a m N a M M O M O mM N m m V M N IPn W V m m M V' m r IyO m m V O m n m C 0 c Q� ry ¢m c M M > N M M m `" 2 N a v (9 S M V M (9 19 (9 i9 di N N a y v> c e9 H bi VY Hi VN! 0 1- K a Yo s o O n o Ql � l0 r a M N YI m Ol O l0 O a N � N � V N VI Ol M N n N a a A cl rl N O ci m N r C N ~ m t0 N vl Vl \ ec0 N M N N (>j1 r l0 � ~ E C o u E � o ac u o w LL on m o Fo a rlr va InM o n lomrvmv.=lam.-I min vl .� wln vl ry n ry m m M M N m w to m N m m o m n o m m w ry M M m m N a m n o p ry a m m m a m N M n N m a o In v o N m a m rI m M m m N m M v o m N N O N ri N h cm N ✓� pj ti O rl' WO N 11;ml N Ill LD ml N. ri IO vl tO O Ol Ot r M Ol V m Ol N N ul vl ei ei M OI C E loo It) rl w o M r1 Ol " N c10 O M OI O Nma mm U O N N V N M N U O N a Ill Vl a O N VI a N M� a-1 01 N p V l0 V m N m OI OI Ol M N N M OI � � t0 M m M O OI N r N t0 n n M IO I(1 OI O w l0 ry M O l0 F M m n n M OI O } IO l0 OI M ll m M 1i rl N ll M w N Ill M V OI N VI n N 1f1 C Ill V V N W N m N V l0 v1O1 m M 'i m M l0 V VI IF Ol N M N ryl N l0 m A O lO n t0 M a M l0 OI M OI N IO n rl m M a n r ID V M OI N N Ill V O m a N m l0 OI vl v o Ill N N M m O N m N n W rt M YIO O h Ol fl Y 'i M N VI cl rl m M N lV N N O N w N N M N O VI rl o N IO m a m M Ol n N m Yl a Ol y V Ol VI « ❑ W m O a m m m M N O N « m N O n n M m O N N O M V O OI O 1� VI M } V M M O M n �-I Ip N m O �-1 OI VI M m e'1 M O l0 w p � N W W O N r r w Ol lO 1pO� m n p W 1 m Ol O' rI M Ol h N m P M N w o r m I� l0 l m m ry n n w o M m m M M' o lfl N N r m v y m m V1 YI m rl N r M Vl n M a a a OI M N O l0 b « y N N w rl N M O rl M O V M •' 'O Q W ON rl N 1lI N' l0 L 9 O tYl IVI V ttl rl l6 r y 3 rl G N r a IO N y rl N N > m } m V N a' VI rl H M a m� l0 a O O a rl rl m r m m O n n r Ol h Yl N OI �N (mom w O rl M rl vl M O n O m OI IO n r m M lO 1l1 p� r O m rl M M OI r t0 m 1l1 lO rl O m m l0 rl m m N V) r OI rl OJ OI a l0 M m >' N m a N n N 10 N O W r w W N w r 1A O Vl Yl ll Ol N W M n ti O V Il) N a Ill Ill IO n m O m l0 l0 M p N V V r O M rl m m OI M Ol r1 M N (V M m rl M r1 rl N N M m N V Y a m O V VI tO n rl OI rl a Ill n M •ti N T (I'i V ttl N N N � rl � t�O M " Imv1 N w a m O t0 V a M r r Vl N M n O O M O O ul m IP M rl M p � � L L O 01 1A m n N m m N l0 N O N c OI Vl N N v •- d L Y l0 Ol O r N rl O r M N M m M n rl O a VI OI M l0 N M d' V O l0 a N t( m N N a ti VI n M w V C O OMI N lnll N a m m M a � . G pa0 O M OMI M ci — pap � D a K O m U u m �.0 p � c O� m m m N O M a OI t0 N M n 1l1 M V N y n 10 Ol m IO Ill r m m ll m N O m Yl r OI N n O m M m rl O lO m n N M t O N N M N m N IO M Oj O M L M rl N m Olei V lO M N 0i F N C tll al i� Mm O to l0 l+l M O OI M N p Ill r N m n m T F' C rtl N O O n rl gVi a N r M VI r W N rl vi W M mV m ei N M q O N VlIROI N V n a N r1 V � O M a m N a 0¢ O v1 N m w N N c Q� ¢m c c > - O ¢ 2 « v M o LL O F y v> c o z _ « 0 1- K a Yo s o O n o O o m o ~ O ~ ~ C U a m O t0 V a M r r Vl N M n O O M O O ul m IP M rl M p � � L L O 01 1A m n N m m N l0 N O N n OI OI Vl N N V M •- d L Y l0 Ol O r N rl O r M N M m M n rl O a VI OI M l0 N M d' V O l0 a N t( m N N a ti VI n M w V C O OMI N lnll N a m m M a � . G pa0 O M OMI M ci — pap � O m U u m m rl lO O M m l0 ", r O� m m m N O M a OI t0 N M n 1l1 M V N y n 10 Ol m IO Ill r m m ll m N O m Yl r OI N n O m M m rl O lO m n N M t O N N M N m N IO M Oj O M L M rl N m Olei V lO M N 0i F N C tll al i� Mm O to l0 l+l M O OI M N p Ill r N m n m T F' C rtl N O O n rl gVi a N r M VI r W N rl vi W M mV m ei N M q O N VlIROI N V n a N r1 V � O M a m N a tlt N v1 N m N N N N Q� Q2 -3- m n n m ry m o n m m o m rc wo mmm o,ymo a.+m u m N N W N N W M n O N O P till ln0 m w 91 c Y m N P1 tO lO v1 N N N N OI m UI 1f1 N O m IP m ry m m � I O T N a 0 Q o n o m 0 O z Z o 0 z z Z 0 o z z z z o -4- Y F W L N E z mm NN mm�m�ppm n nwo.y W O o n M v1 o m M n m in m m E W O W N H M D] W O Vl b lD IO c'1 m _m Q l0 1 O n m c1 O d' 10 T C N � J Q O v a T N N N N D N � ti N rl N h O E S v � v = IN mvNim mw om N ry vl m N N N ci 'i N N T w m w w o m m ry w ti uMi V N N N N ti M till ln0 m w 91 c Y m N P1 tO lO v1 N N N N OI m UI 1f1 N O m IP m ry m m � I O T N a 0 Q o n o m 0 O z Z o 0 z z Z 0 o z z z z o -4- Ol 't m n l0 M m V m Ill W a} ul n VI N N of n vl H n ul MID m N t0 N n Om N N N O N I N tO Ol V O n a E v 0 V VI m N lO N O N O m0 M M n n d Oml N V n VI Ol N n tOI n o ON ti l0 l0 rl (n rtl V I� l0 rtl ci M n CA n Z O m OI m Ol FYI m O N a -I m N tO 'i [( N ei 01 N Ol N N IO n lO tO y0 V 1p N m N N 'i N n N N m N v m n N n W N n n n V N w m d ln0 n m IMYI VI OI OI , N Om Ol Ol M v m IO V N N N M 6 to n OI M T V ON M ci N W Ill lr a Ol IIOO n m n M Ol N m I m m N m N N N N n Q N t0 n Ol O m O m N N l0 m IO Ol O m n m W m N ul m m o Iu O W m m V N N 'i M t0 m O O N V n vl d' O IO v n ry a m m o In M n m .-a � r Io v to m m� � vi to ro a a In lomm.y m N. -I N.i w m m m M M Io Io to a m m cr�p v1 m .6 O 'i 6 m O M IO j I tm Ri O V l0 O ti � n m m m N N 2 V o 0 O N .0 ' U Q Uv'=i w [[ In p v` E a s a o 6 o 0 n O O Z Z O Z O Z Z U 0 F I -5- w In O t/i N n vl n C N M Ol N Vl V 10 N m m Oi (n a v m H m m ul 1� O1 l0 N vl l0 m a rti [t1 � 3 m n m N N N V1 N N m cl v 'O C a U � m Ol O Ol m to N n mm t0 tO Ot N M O1 V O vl m m Ol Cl. m N m (fN� � m N t — u 0 o vo o "M m a 2' Nm rmro.n-I-Ion Ili -i mM Io n% a m o m Ol W' W m tO V m t0 rl N m n N M V rl m O.-1 nmo.-lm.-i ul m o ry vi m N t -i m N m o m y m ._0l6 C 1? .6 lo'o30 010 to .ti am tO n m N N H e-1 m N 'i N t0 n Ol O m O m N N l0 m IO Ol O m n m W m N ul m m o Iu O W m m V N N 'i M t0 m O O N V n vl d' O IO v n ry a m m o In M n m .-a � r Io v to m m� � vi to ro a a In lomm.y m N. -I N.i w m m m M M Io Io to a m m cr�p v1 m .6 O 'i 6 m O M IO j I tm Ri O V l0 O ti � n m m m N N 2 V o 0 O N .0 ' U Q Uv'=i w [[ In p v` E a s a o 6 o 0 n O O Z Z O Z O Z Z U 0 F I -5- w In O t/i N n m d' X11 N n O W n W C N m m n m M W N N r m N cY N W m M lO O m m n tD M O rr N n '� tOvf d0' VI m m m l0 m M m O Oml C O U � v E c E v O m V G0 0 0 0 0 0 0 0 0 0 0 o O O O o O O O O O O O O O O O O O O O O O ;N 0 0 0 0 0 0 0 0 0 0 0' 'UW .ti .� N N .� .� N N� � � a v 0 0o m� �n N ti n .1 m n m W m o rn m o W h0 W n W 'd' N m n m W '�-� �-I N m y ci Ifl n N ci O m N d' N W M LO O m n t0 M O N � b0 O l0 l0' Lr Ul Ol N a N O' V� Vl 41 m m '/1 m � N In m N t11 M V�� N N N W � m ci W N Z v cni dn• Q O v� W M m W IfI ifl n N m I(1 d' n ei N ci m �/1 W t0 N N w l0 M W u vpi rr t tm � v]' Ql m m N cr N vi v v W n n W In m m N " 1p O M d' M N N d' W If1 M � d a m m m M M M M d' � W Y }+ N 41 O M OO Ut ci n 1p m m m N O .-1 N 1p W O O d' .-i .-i W w m n 0 0 0 M J ++ m N W 1 '7 C31 '(1 W m 1I1 O1 N lIl N N O �/1 uu �'S W c m m m w m m V� m m 'ri a" d' o m' m d N �t a n N W W m ^ m m m o O > G N K C-9_ U v } o N r+ M N l0 M W O m rl N O ci O ci N E E C m ci O m tD N W m m M N N W W V N cp O W E O' O' m tD N lO N V� C l0 N N' d� m r N d' W M N m N M H N N W lD m m lD V .ti E °- > m m m N �F d' a m m M M N m m n a N N N V M d' z c:5 ao n N m m N m d' O W N O 'A M W N W .--I N W n O n 0 0 0 m W n p c _p v H o - - .-i .-i m vi L6 . m d (0 p l0 n W m M Ol n m Q m N I(1 rl m m n m N M a N n N N n n ,p p N tD M W N n m W M a p � u E E N m N m d' IV W N W n W m 1� r W � N N N n W n N Ifl lD m N OM m m n M cp m m m W m .� W m o m M r n lD N N m n lD It M ' dt O W l0 N N 7 N G o' m F N Lr' N df Lr' m m r m m W h' o T m W a -i m M n 'd' N O m m N to m n n m W H m m > 'n M io �t �o �n io <t <t 'n a n m <t n o n M vi Li u U -u U U U � � 6 New Patient Clinic Visits 477 367 378 328 344 301 345 399 441 477 522 4,379 438 Existing Patient Clinic Visits 2,022 1,763 1,898 2,006 1,921 1,563 1,702 2,103 1,780 2,176 1,999 20,933 2,093 All Other Visits - - - - - - - - - - - - - Tead RHC &Surgery Clinic Visits 2,499 2,130 2,276 2,334 2,265 1,864 2,041 2,502 2,221 2,653 2,521 25,312 2,531 Specialty Clinic Visits 352 344 506 494 493 562 473 434 169 200 244 4,271 427 Hospital OR Procedures 40 49 51 57 61 62 53 65 44 52 60 594 59 Total Visits & Procedures 2,891 2,523 2,833 2,885 2,819 2,488 2,573 3,001 2,434 2,905 2,825 30,177 3,018 No Shows 167 149 148 156 178 185 169 183 159 165 173 1,833 183 No Show is, 6% 7% 6% 6% 7% 9% 8% 7% 7% 6% 6% 7% 158,335 Professional Fees Specialty Clinic Revenue Pattent Revenee Estimated Medicare Settlement 13,565 187 138,984 Meaningful Use 7,999 7,699 7,975 7,892 8,164 7,859 7,857 6,302 8,707 9,402 9,024 - - Hart Revenue 650 2,117 920 1,125 967 917 829 1,147 1,099 817 930 11,516 1,152 340B Revenue 14,556 41,683 2,781 47,820 8,944 74 601 174,058 22,739 62,477 185.093 98,271 733,022 73,302 Total Miscellaneous Revenue 15,205 43,800 3,700 48,945 9,911 75,517 174,885 23,886 63,575 185,909 99,201 744,538 74,454 Total Net Revenue 361,699 426,512 334,506 269.738 503,878 502.441 610,748 340,882 385.905 710,567 464,022 4910,899 491,090 Salaries -Regular 100,681 113,952 124,604 120,924 125,732 117,476 119,598 121,085 130,559 145,056 174,459 1,394,125 139,413 Salaries - Overtime 2,200 5,389 1,959 2,578 2,285 2,768 2,371 4,630 2,910 4,722 3,449 35,261 3,526 Salaries - PTO 11,973 12,257 14,274 13,397 12,155 12,443 11,209 14,536 11,007 11,393 29,321 153,985 15,397 Total Seems 114,854 131,598 140,836 136,899 140,172 132,688 133,179 140,251 144,476 161,172 207,229 1,583,352 158,335 Benefits - FICA 7,999 7,699 7,975 7,892 8,164 7,859 7,857 6,302 8,707 9,402 9,024 90,869 9,087 Benefits -State Unemployment - - - - - - - - - - - - - Benefits- Fedeal Unemployment 769 225 245 100 39 4 1 21 74 69 67 1,614 161 Benefits - Retirement 9,625 9,122 9,468 8,191 10,898 9,320 9,419 9,169 10,263 11,065 10,629 107,169 10,717 Insurance - Hospitalization 23,392 12,074 20,599 3%190 19.631 23,976 23,638 14,088 16,512 25,368 30,777 240,225 24,022 Insurance - Other 1,166 381 2,098 2,700 1,704 1,845 1,124 2,047 1,545 533 2,801 17,944 1,794 Total Wages and Benefits 158,395 161,353 182,420 187,170 181.701 176.866 176.230 173,296 182,782 208.874 261,626 2,050,803 205,080 Supplies - General 13,053 7,704 6,919 19,438 9,312 8,930 7,559 25,666 20,343 41,197 41,377 201,499 20,150 Supplies - Office 879 257 507 724 405 69 260 56 1,623 746 499 6,026 603 Supplies - Forms 160 320 - - - - - - - - - 480 48 Freight 159 143 221 187 139 62 165 15 307 146 168 1,710 171 Total Supplies 14,250 8,423 7,648 20,350 9,856 9,062 7,984 25,737 22,273 42,089 42,044 209,715 20,971 Pro Fees -Physicians 189,550 169,574 156,051 157,134 242,859 152,119 85,301 139,989 167,892 167,672 204,349 1,832,292 183,229 Purchased Services - Nan- h sician 28,188 27,565 22,955 11,919 13,240 49,549 41,735 19,033 28.445 12885 36,808 292,323 29,232 Total Purchased Services 217,736 197,139 179,006 169,053 255,899 201,668 127,039 159,022 196,337 180,557 241,157 2,124,615 212,461 Repairs - Instmments - - - - - - CallectianCoals - - - 3,301 - - 7,784 774 459 535 530 13,383 t,t t5 Subscriptions 862 1,802 521 636 521 2,204 3,903 2,473 2,623 2,479 2,479 20,502 2,050 Leases & Rental (9,058) 995 995 995 1,990 995 995 995 995 995 995 1,886 189 Equilfinerit leasing - other#t Total Rent and Leases (9,058) 995 995 995 1,990 995 995 995 995 995 995 1,885 189 Total Expenses 382,188 370,335 370,590 384,883 454.658 391,250 326.271 363,114 406793 436,250 549,641 4,435,870 443,587 Net Opf i (20488) 56.176 (38084) (115145) 49,322 111.191 284,477 (22231) (20888) 274.317 (85619) 475.028 47,503 Depreciation (16,000) (16,a00) (16,000) (16,000) (16,000) (16,000) (16,000) (16,000) (16,000) (16,000) (16,000) (176,060) (17,600) IGT Expense - - - - - - - - - - - Communi Benefits Cornball Net N n -op ti g lnc.M- Contribute. Margin (36488) 40176 (52084) (131145) 33322 95191 288477 (38231) (36888) 258317 (101619) 299020 29903 7 New Patient Clinic Visits 471 367 378 328 344 301 345 399 441 477 522 4,31. 406 Existing Patient Clinic Visits 2,022 1,763 1,898 2,000 1,921 1,563 1,702 2,103 1,700 2,176 1,909 20,933 2,093 All OIhaVisits - - - - - - 248565 4]8]90 415.339 636.893 3D7880 - " Total Curls Visits 2,499 2,130 2,276 2,334 2,265 1,864 2,047 2,502 2,221 2,653 2,521 25,312 2,531 Hospital OR Procedures 40 49 51 57 61 62 53 65 44 52 60 594 59 Total Vlsi150 Procedures 2.539 2179 2,327 2,391 2326 1928 2100 255] 2265 2]05 2581 25.908 2591 No Shows/Mesad Appolatmenis 167 149 148 156 178 186 169 183 159 165 173 1,833 103 No She, IS 6% 7% 6% 6% 8% 9% 6% 7% 7% 6% 6% ]% 7% 30100044 Setlleme rt 340B Revenue 14.556 41,683 2,781 47,920 8,944 74801 174,08 22739 624]] 185.093 98,271 733022 73,302 Total Miscellafeous Revenue 14,556 41,883 2,781 41,820 0,944 74,601 174,058 22,}39 62,4]] 165,093 98,2]1 ]33,022 ]3,302 Total Net Revenue 316221 394.199 3D0524 248565 4]8]90 415.339 636.893 3D7880 353,903 ]0021] 430,452 4481982 440,190_ Salaries - Regular 40000041 ]],684 86,561 98,979 95,449 98,850 91,995 95,580 99,060 105,479 117,966 100,527 1.074,331 107,433 Salaries - Ovedime 40005041 814 3,928 1,078 1.061 1,614 1,708 1,481 2,073 1,048 3,367 1,623 22.291 2,229 Salanse - PTO 40010041 9,195 10,331 11,660 10,955 9,595 10,301 8,773 11,324 0,903 9,102 12,059 111,598 11,160 Total Cli0lral Salaries 87,893 100.020 109,117 108,280 110,058 104.002 195,034 113.256 118,33D 130.435 122,209 1200.220 120,822 Salaries - Regular 40000042 17,650 22,045 21,876 20,740 21,379 19,932 18,057 16,530 10,654 21,762 60,910 261,336 26,134 Bahama -Ovedim0 40005042 1,039 1,127 716 739 417 791 003 1,650 920 1,018 1,645 10,973 1,097 Salaries- PTO 40010042 3,050 1,409 2,718 1,950 2,151 1,828 1,]91 2.508 1,664 1,845 16,}30 3].728 3,]73 Total Clinic PFS Salaries 21,]4] 24,502 25,308 23.430 23,948 22,549 21,550 20,]]5 22,239 24,825 79,284 310,034 31,003 Benefits Clinical- FICA 40015041 6,013 5,770 6,910 5,927 6,134 5,869 5,980 6,350 6,814 7,330 6,326 68,431 6,043 Benefits Clinical- Federal unemployment Benefits Clinical-Re@ement 40025041 40040041 578 7,190 07 6,770 138 6,983 69 6,119 33 8,148 5 6,924 1 7,104 21 6,930 61 7,965 44 8,560 42 7,401 Luese 80,101 109 B4OID Benefis Cilnic PFS- FICA 40015042 1,621 1,594 head 1,634 1,640 1.625 1,533 1,587 1,547 1.709 2,363 18,534 1,053 Benefits Citrus, PFS- Federal unemployment 40025042 158 116 113 31 6 (2) - - 13 24 26 483 48 Ba.afeCilnic PFS - Hollowa a 40040042 1,981 1,910 2,021 1,695 2,236 1,949 1,909 1,943 1,052 2,055 2,810 22,366 2,237 Group Health Clinical Other Insurance Clinical Allocated 18,019 071 6,307 201 15,733 1,631 22,675 2,076 15,000 1,272 10,301 1,608 17,077 760 IM15 1,700 12,257 1.292 22,282 424 13,304 2,165 172,871 14,009 1],26] 1,401 Workers' Camp Clinical Group Health Clinic PFS Other Insurance Clinic PFS Allaotsel 451 4.458 215 195 5,380 180 929 3,941 371 947 8,425 524 930 2,945 360 921 4,595 142 804 4,782 323 (453) 3,388 244 970 3,632 188 1,024 2,042 88 1,051 16,849 534 7,777 58,447 3,158 778 5,845 316 Workers' Camp Clinic PFS 112 40 215 205 204 200 164 (83) 105 193 - 1,443 144 Total Benefits 41,664 28,563 39,666 40,326 39,716 42,137 41,245 31,]66 36,]]7 45,711 52,8]0 448,507 44,851 Total Color.. Wages, and Benefts 151,303 153955 174090 180.022 173720 168.689 168,630 165797 175346 200837 254.263 1968762 196676 Supplies- General Supplies -Otfce Fraeght 40220041 40225041 40215041 12,580 6]] 159 7,350 218 143 6,777 471 221 19,125 454 187 8,856 363 139 0,925 69 62 7,411 260 165 25,802 56 15 20,221 1.622 307 40,843 708 146 41,178 498 168 198,087 5,595 1,710 1%887 559 171 Total Supplies 13,]]5 8,031 7,468 19,]6] 9,358 9,056 7,036 25,873 22,149 41.807 41,842 206,852 20,665 Pro Fees -Physicians Pumhasetl Services Non -h siGan 40530041 40510041 189,550 8,]13 199,574 1]365 158,051 11.743 157,134 8619 242,659 8240 152,119 6349 65,304 5405 139,909 7808 167,892 17595 16],8]2 15.855 204,349 24.800 1,832,292 130,410 183,229 13,041 Total Purchased Services 198,203 18Q939 167,]94 183,753 250,898 158,468 90,789 147,597 105,407 183,55] 229,15} 1,96$(02 196,270 Callvatf.0 Costs Subscriptions Education 40446"1 40605041 4061 41 -3,301 862 - 1,802 475 521 - 636 2 8 521 (420) 2,204 4 7,784 3.903 355 774 2,473 108 459 2,623 4l8 535 2,479 - 530 2,479 - 13,383 20,502 3742 1,338 2,050 374 Total Other Practice Expenses 862 2,428 521 7.315 4,660 2,660 14,023 4.084 4,40] 3,735 3,019 48,493 4,849 Leases Rental Total Rent and Leases 40500041 (9,246) (9,246) 633 633 633 533 633 833 1,268 1266 633 633 633 633 833 633 633 633 633 633 633 633 12205) (2,285) (228) (220) Total Evensess 354,95] 351993 350506 371490 439903 339505 281,911 343763 388,021 430,459 529,814 4182,323 418,232 Net Of 1 (30]36) 4 !49903) (124 2 ) 8 8 }6834 254.981 (35803) (34118) 269758 (99363) 299,659 29.988 Depreciation (1000) (16,000) (16,000) (16,000) (16,00) (16,000) (16,000) (16.000) (16,000) (16,OD) (16,000) (176,000) (47.800) IGT Expense G.Racrunily Benefits Contribution Net Nan -o emltn income - - - - - - - _ ContributionM i (54,738) 26206 (65.98D (140925) Mars 60.834 238,981 (51883) (50110) 253758 (115363) 123,659 12,366 Net RevenueMeit Breakeven Visits who Community Honest Breakeven Visits w/ Community Beach[ 126.54 2,005 2,805 185.07 1,902 1,902 132.04 2,655 2,655 105.64 3,517 3,517 211.39 2,081 2,081 223.38 1,520 1,520 262.28 1.075 1,075 123.05 2,794 2,794 159.34 2,435 2,435 253.93 1,831 1,631 1]0.]5 3,103 3,103 177.07 23,629 23,820 i Rent 650 2.117 920 1,125 967 917 829 1,147 1,099 017 930 11,516 1,152 Totes Miscellaneous Revenue 550 2,117 920 1,125 967 917 B29 1,147 1,099 817 930 11,516 1,152 To[.[ Net Rovonue 45470 32,313 33,982 23.173 25,089 86.102 73855 33,002 32.001 10,350 33.571 428,916 42,892 Selena -Repels, 5,147 5,345 5,749 4,735 5,503 5,549 5,160 5,495 5,426 5,320 5,022 58,459 5,046 Salaries-OveNme 347 334 165 (23) 254 272 (12) 100 42 337 181 1,997 200 Sala nes-PTO (279) 517 497 491 410 316 645 626 440 447 532 4.642 464 Total Salenes 5,214 6.196 6,412 5.203 61168 6,130 5.794 6.220 5,908 5.111 5,738 65.097 6,510 Benefits -FICA Benefits - State Unemployment Benefits- Federal Unemployment Benefits -ReSrement Group Health OtherlasuMace WorkeR'Co., Tatel Benefits 366 335 304 332 380 366 335 384 346 383 334 3,904 390 35 12 (5) - - - - - - - - 42 4 454 434 464 378 515 447 406 291 445 451 418 4,703 470 915 388 924 1,080 685 1,060 079 555 an 1,044 624 9,107 911 80 12 96 100 71 95 42 94 66 20 192 777 78 27 12 55 45 53 54 44 (25) 49 48 49 411 41 1,877 1,193 1,918 1,945 1,904 2,041 1,806 1,280 1,529 1,925 1,527 18,944 1,894 Total Salades,W es and Benefits 7.092 7388 8.330 7,148 8071 8,177 7600 7500 7436 8,037 7.253 84,042 8,404 SupPltes-General 474 353 142 313 457 6 148 64 122 354 200 2,633 263 Suppries-Office 2 39 37 270 42 - - - 1 38 3 431 43 Bupplles-Forms - - - - - - - - - - " FmlOh[ Total Supplies 476 392 179 583 490 6 148 64 124 392 202 3,063 306 Pro Fees - Phsicien - - - - - - - - - - " P M1 dS yN - h fy 194]5 1 11213 5300 5000 43200 38250 11425 10850 (3000) 12000 161,913 18191 Total Purchased SeMces 19,475 10,200 11,213 5,300 5,000 43,200 38,250 11,425 10,850 (3,000) 12,000 161.913 18,191 Leas65& Rental 108 362 362 352 724 362 362 362 362 362 362 4,170 417 Egelprosent lesonn-oNee IR - _ Total Rent and Losses 188 362 362 362 724 362 362 352 362 352 362 4,170 417 Total saneness 27231 13342 20084 13393 14653 51745 44.360 11,350 18]]2 5] 91 19827 253547 25355 H.tc,rathr,1 18248 13,970 13,899 9780 10,436 34357 29,496 13652 13,230 4.559 13744 175370 1]53] IGTExPens, - - - - _ Community SN ConMelfore- - - - NtN ratl - Continuation Me 1. 18,248 13970 13899-9 780 10.436 34357 29,496 13652 13.230 4659 13744 1]5.3]0 17.537 Memorial Medical Center Ado Ayo 598,765 848,478 860,287 (249,713) -29% (261,522) Physician Revenue Trend -Hospital Only 000548 Haresh Kumar - - - 18,891 YTD for 2019,2017,&2016 001381 Dakshesh Parikh 22,327 837 59,422 21,490 012100 Amount 791,426 Amount 856,268 (179,627) -18% (64,842) -8% Comparision %Comparision Comparision Comparision 369,637 2018 YTD 2017 YTD 2016 YTD 2018 to 2017 2018 to 2017 2018 to 2016 2018 to 2016 Memorial Medical Center Clinic - 6,340 #DIV/0! 6,340 9DIV/01 059000 Krueger Kurtis 000966 Truong Thao 1,559,968 1,264,155 1,255,977 295,813 23% 303,990 24% 002099 Shefcik Traci 491,882 424,806 371,473 67,075 16% 120,409 32% 002927 Gaines Michael 222,409 3,978 - 218,431 5491% 222,409 #DIV/0! 005966 Carol Andrus - 74,891 507,500 (74,891) -100% (507,500) -100% 009293 Serino Danielson 1,314 492,285 1,747,648 (490,971) -100% (1,746,334) -100% 009294 John Durst - 206,323 225,563 (206,323) -100% (225,563) -100% 011005 Crowley William 4,938,383 5,932,666 4,862,534 (994,283) -17% 75,848 2% 019000 Arroyo Diaz Ric 3,539,204 3,281,953 3,956,894 257,251 85, (417,690) -11% 022000 Rojas Peter 1,189,985 1,270,621 1,950,898 (80,636) -6% (760,914) -39% 041574 Hinds Frank 1,827,341 798,538 - 1,028,804 129% 1,827,341 #DIV/01 041596 Schultz Mercele 1,250,333 345,522 - 904,810 262% 1,250,333 #DIV/01 041743 Angela Dobbins - - 651,155 0 #DIV/0! (651,155) -100% 042320 Pfeil Michael 436,845 129,935 - 306,910 236% 436,845 #DIV/01 058001 Thurlkill Court 452,991 292,231 244,323 160,760 55% 208,668 85% 100118 Joseph Jenkins 120,242 - - 120,242 #DIV/01 120,242 41DIV/0! 320001 Sharma Odonneli 163,085 - - 163,085 #DIV/01 163,085 #DIV/01 102218 Cook Marshall 1 119,231 - 119,231 #DIV/01 119,231 #DIV/01 15,910,654 14,517,905 15,773,966 1,392,749 10% 136,688 15/ 28% 265' 25% Hospitalist 015020 Hospitalist 8,738,609 7,050,967 7,495,999 1,687,642 24% 1,242,609 17% 8,738,609 7,050,967 7,495,999 1,687,642 245. 1,242,609 17% 15% 13% 12% Port Lavaca Clinic 000983 Michael Caughron 94,021 - 33,768 94,021 #DIV/01 60,253 178% 001500 Lincoln Jewel 31,411 1,825,943 2,485,238 (1,794,532) -98% (2,453,827) -99% 008800 Amu N Kwi 1,829,710 1,609,785 2,053,289 219,926 14% (223,579) -11% 012000 Griffin Jeannine 250,008 219,834 241,676 30,173 14% 8,332 3% 013001 Falcon Leigh A 2,073,574 1,906,874 2,471,061 166,700 9% (397,487) -16% 050001 Wright John 3,014,248 3,599,572 4,100,523 (585,324) -16% (1,086,276) -26% 101201 Ibrom Destiny 10,963 - - 10,963 #DIV/01 10,963 #DIV/01 101202 Salinas Henry I 3,323 - - 3,323 #DIV/0! 3,323 #DIV/01 320001 O'Donnell Sharma 272,899 367,704 424,907 (94,805) -26% (152,007) -36% 7,580,157 9,529,711 11,810,462 (1,949,554) -2D% (4,230,305) -36% 13% 17% 18% Specialty Clinic 000404 Ado Ayo 598,765 848,478 860,287 (249,713) -29% (261,522) -305/ 000548 Haresh Kumar 18,891 - - 18,891 001381 Dakshesh Parikh 22,327 837 59,422 21,490 012100 Breech Donald 791,426 971,053 856,268 (179,627) -18% (64,842) -8% 013000 Bunnell Dan Pau 809,893 678,988 369,637 130,905 19% 440,256 119% 1057004 Harsh Chandra 1 6,340 - - 6,340 #DIV/0! 6,340 9DIV/01 059000 Krueger Kurtis 1,995 - - 1,995 #DIV/0! 1,995 #DIV/01 070002 Richard Steinberg - 92,633 210,548 (92,633) -100% (210,548) -100% 525225 Malik Azhar MD 79,388 58,693 73,059 20,695 35% 6,329 9% 2,329,025 2,650,682 2,429,220 (321,657) -12% (100,196) -0% 4% 5% 4% -10- Physician Revenue Trend - Hospital Only Memorial Medical Center YTD for 2018,2017,&2016 Coastal Medical Clinic 000806 William McFarland 000809 Delgado Ana 011000 McFarland, Tim R Independent 006000 Lin Mau Shong 310001 Cummins Michelle 330000 Le Nhi MD Other Medical Staff 1807077 Wash Patel 989112 Powaser Peter 065002 George Boozalis Total E/R Physicians 29% 0% 1% Amount Amount 4,450,485 4,562,444 (181,673) 333,021 Comparision %Comparision Comparision Comparision 2018 YTD 2017 YTD 2016 YTD 2018 to 20172018 to 2017 2018 to 20162018 to 2016 -18% (275,573) -45% 1% (7,416,430) 42% 24,276 32,551 31,291 - 96,869 272,669 (96,869) -100% (272,669) -100% 6,161 - - 6,161 #DIV/0! 6,161 #DIV/01 65,624 508,833 880,322 (443,209) -87% (814,698) -93% 71,785 605,702 1,152,991 (533,917) -88% (1,081,206) -94% 29% 0% 1% 2% Other Ordering Physicians 4,268,811 4,450,485 4,562,444 (181,673) 333,021 262,317 1,634,597 70,703 27% (1,301,577) -80'% 8% 343,010 415,892 618,584 (72,882) -18% (275,573) -45% 1% (7,416,430) 42% 24,276 32,551 31,291 (8,275) -25% (7,015) -22% 700,307 710,760 2,284,472 (10,454) -1% (1,584,165) -69% 1% 1% 4% 1 $ 431,786 $ 110,225 $ 621,923 321,561 292% (190,137) -31% $ 132,941 $ - $ - 132,941 #DIV/0! 132,941 #DIV/01 $ 191,634 $ 293,261 $ 251,051 (101627) -35% (59,417) -24% 756,361 403,486 872,974 352,875 87% (116,613) -13% 1% 1% 1% 16,092,617 15,969,947 17,482,225 122,670 1% (1,389,609) -8% 16,092,617 15,969,947 17,482,225 122,670 1% (1,389,609) -8% 29% 29% 27% Other Ordering Physicians 4,268,811 4,450,485 4,562,444 (181,673) -4% (293,633) -6% 4268811 4,450,485 4,562,444 (181,673) -4% (293,633) -6% 8% 8% 7% Totals 56,448,325 55,889,644 63,864,754 558,681 1% (7,416,430) 42% -11- Memorial Medical Center Inpatient Volume Indicators Admissions by Unit 2016 Yr0 2017 WD 2018 WD 1,000R WMedical/Surgical/ICU NObstetrics DSwing Bed 991 17 goo_F761 _. _.. - -._ ____ '. _ __... 600 to a 799 743 200 0.]5� _it 633 � 0.77 - - - 8.00 6.00 4.00 10.058.68 Patient Days by Unit 200 2016 Yr0 2017 WD 2018 WD WMedical/Surgical/ICU NObstetrics DSwing Bed Average Daily Census _. _.. - -._ ____ '. _ __... 14.00 1.70 1.57 12.00 0.]5� _it 10.00 � 0.77 - - - 8.00 6.00 4.00 10.058.68 - 200 Ma 2016 WD 2017 YTD 2018 WD f Medlca1/5urglcal/IN ®Obstetrics MW,Bed Average Length of Stay B.OD 11.27 7.647.21... zoo 6.00 5.00 3'82 4.01 4.00 3.56 3.00 2.30 12.17 '2.03 2.00 _ 1.00 0.00 2016Yro 2017 no 2018 WD B Medical/Surgical/ICU YOb,Wrics NSwing Bed -7 2- 2,500 - 1,986 2,000 1,500 --- 1.000 Soo ------ Memorial Medical Center Operating Statistics 13 -Month Trends Outpatient Statistical Trends 2,130 2,100 2,031 .807 ---1,695 - 11-778 1.869 1,897 1,823__-1,883 � 4 _- _ _ ro�♦415 1415 N.,17 Dec 17 Jan -18 Feb 18 Mar -SS Apr -18 May -18 Jun 18 Jul -IS Aug -18 Sep 18 Oct -18 Nov 18 �Sa Outpatient Visits -Emergency Room Viits .. -Spenalty Clinic Visits I Surgery & Endoscopy 200 -- ,'. 0 ...109___-98 76_ _ 82 _.88. _.__ 101 _-110_ _ 108._ _-'91.-._ 102. --69 -80 -85 Nov -17 Dec -17 lap -IS Feb -18 M., -IS Apr -I8 May -18 Jun -18 Jul -I8 Aug -18 Sep -18 Oct 18 Nov -18 Radiology Procedures 2,000 _ - 1,000 1 332 1,230 1,404 1,349 1,358 15361,056 1,297 1,392 1,452 1,281 1,452 0 Nov -17 Dec -17 Jan -18 Feb -18 Mar -I8 Apr -18 May -I8 Jun -18 1u1-18 Au3-18 5 p-18 00-18 N v-18 f.____ Laboratory test 35,000 30,000 - .___ ___ __ .32.252-_. -. _.__.___ -_ _ _ _.,- --32;718- , 31,655 3o,906 31,171 31,034 31,259 30,212 30,912 31,127 30,663 30,612 25,000 --. __2],993 __-_- Nav-17 Dec -17 Jan -I8 Fe638 Mar -18 Aprd8 May -18 Jun -18 Jul -18 Aug -18 Sap -18 Oct -18 Nov -18 Rehab Services Procedures j 4,000 2,090 0 1,756 _..1,408 1,591___. 2043 _ 1,497-- 1,510-- 1,839 1)348---1;458 1,445 1,340 1,272-- 1,449 - j Nov -17 Dec -17 Jap -IS Feb -18 Mar -18 Apr -18 May -18 Jun -18 Jul -18 Aug -18 Sep -18 Oct -IS Nov -18 -13- 0 N b r N NO m 'O y� N b m o N N b N W O N n a lO N a N M N W N N m n MN N O V Mm m lO o m n ei N m y y m M Vl M a m m„ M I 'yid O 'i m m m M N ei h ul m O m R V ✓1 N n N M M N Mo W N b vl O n n N ti N N O m 10 m n N q a n V b ci N a s N M n N OJ N N n `I M N r n a N N LQ m N N b O N 01 (YI N O b ry N n N ei N N V N j N N N m N 'I W KI O Z b N m O 00 m N u1 a vl O p 0 0� N N O 'i N om„ ry a 11 N� m VVI N M N O N „ m N M W iD N u1 v1 a-1 OI 10 O M VI N m eri a N N N V l00 N W N ti N r Ol IYI b N N ti m N ei ro T O m n v ry vmi .n+m om Imo e.ni n n n �� rvb n m.� Mo m� o mN .+a r o ti m«�o ".-� .+ M .-� N N a m m m n a m a w ei a rl N a rt1 N a r t0 M „1 In to m IQ m a Lq eo ry ri ti m ri .i ro v Nm n n noa mm. -1 nm c omnm nm .+aln r°�m a a o tinNo m M n `� a m b r N 1`i Ir a m 'i ri o v l0 M N N Vl OJ M ei `10-1 b N m N a N b rtl ti b m � 'i ri N m IT ri of m m .i M m n n m m m ry m o m O n o m o m n n m m o m n M b N N N o N o m m n y m M a M 10 m o m ry m m m .-1 .i N r r m m p'I N 16 O N m M N N r a ti N „i r. N a Ill N n OJ 'i a m N� N N m m N .i Oi rcl O m r `a n Mm n I. Irr morn n Mm a a 10 a.+m.-� ow 10 .+m e�-1 �-11n 10 o ry o c a m m m a 10 10 n m _ y w a ri .ti ti m ri m m V F O Q y _ Z v �v NMm mMra n � e W M.-1 om „ alo lnro �-+n Noa o n 6vl Il) 0' OO b m N W n O1 „1 l0 'I N M N M V N a 14 M ttl O N C E c W n val O n ti N O N M l0 m O 1 M1�� N a yy N l0 a N W M 10 m O O m n a O b m Vl O [F m ~ ml n n M W m b m N M N O lD IpYI r N m O N 0q DI a Ol OO ei N'1 a CI N Ol m N N Ol N Y O LL ryl W O b O ti n N N n N N ti Oml 1b0 N eMi n N lNO N N tn0 n N lb0 lNO O m a tmVl O N N Owl O� n W O N b a OO O N� M a m V N IQ 19 O N W 1v1 lON N �-I W W b (b(1 m Oml Ol m N O N m m ri N Vl N N o" n a m M O N n i m N N M N ti ati W T W O �} r 11�� n Hyl n a N M 1O o m m N m ryry011 {0 N Y N1 O n rynryll N a m O l0 1pp t0 a m M 10 Ill N � n o0 mm ry � a m ri .7 ov 0 z w e v v o o c u v w S¢49 s o E E' 'u' In o ?' y Q m v✓ m or a w `w ; U a `v `w 'u ip `a o o� v O� � ;o - '`a' t'%J � v _ a t m E w a t=wH ¢�o1nFh ooz �o'wwlai lui3 ��mz'>>G��a ¢Yn x�wwv�i rc cmuao -14- Memorial Medical Center YTD YTD YTD 11/31/18 26.6% Statistical Comparison 11/30/16 11/30/17 11/31/18 OVER (UNDER) % OF Newborns - Births (11 months) (11 months) (11 months) 11/30/2017 CHANGE Total Admissions 969 779 924 145 18.6% ER Admissions 615 484 529 45 9.3% Total Patient Days 3,800 3,236 3,349 113 3.5% AVERAGE DAILY CENSUS 5,181 4,572 4,332 (240) -5.2% Medical/Surgical/ICU 10.05 8.34 8.68 0.34 4.1% Obstetrics 0.75 0.54 0.77 0.22 41.2% Swing Bed 1.70 1.76 1.57 (0.19) -11.0% Total AVG Daily Census 12.50 10.64 11.02 0.37 3.5% Total AVG LOS - Acute Care 3.66 3.81 3.35 (0.46) -12.1% Observation - Patients 476 395 Soo 105 26.6% Observation -Patients from ER 355 241 415 174 72.2% Newborns - Births 90 74 108 34 45.9% MMC Clinic Visits 18,562 19,870 25,142 5,272 26.5% Outpatient Visits 20,590 19,162 20,036 874 4.6% Emergency Room Visits 7,403 7,421 8,193 772 10.4% Specialty Clinic Visits 5,181 4,572 4,332 (240) -5.2% Surgery & Endoscopy 1,075 855 992 137 16.0% Laboratory test 310,256 312,755 342,866 30,111 9.6% Radiology Procedures 7,109 6,632 7,052 420 6.3% RadiologyOP- Clinic 1,243 1,279 1,378 99 7.7`0 Bone Density 136 153 270 117 76.5% Nuclear Medicine 191 118 112 (6) -5.1% Ultrasound 1,951 1,568 1,797 229 14.6% Ultrasound -Clinic 450 435 526 91 20.9% CT Scans 21570 2,217 2,394 177 8.0% MRI 1,138 886 1,014 128 14.4% Mammograms 829 449 906 457 101.8% Total Radiology Procedures 15,617 13,737 15,449 1,712 12.5% Respiratory Therapy Procedures 7,755 6,885 6,445 (440) -6.4% Stress Test 70 35 32 (3) -8.6% Holter Monitor 34 34 EKG Exams 3,144 2,404 2,552 148 6.2% Sleep Studies 141 113 82 (31) -27.4% Total Respiratory 11,110 9,441 9,148 (293) -3.1% Physical Therapy Services Procedures 17,190 19,089 16,792 (2,297) -12.0% Occupational Therapy Total 2,187 1,174 239 (935) -79.6% Speech Therapy Total 573 774 562 (212) -27.4% Behavioral Health Patient Encounters 3,400 1,638 1,282 (356) -21.7% Cardiac Rehab units 61 515 1,199 684 132.8% Pharmacy Total 119,953 102,691 103,337 646 0.6% Dietary Total 47,075 n.a. 41,385 -15- n £ p m a N£ n m v R F B n o x a m:�� xarmn m .°Jorma a. -1m nnrnio 0 NH � S o�am ax o ,.�^ry gNg xx oonm m a' m mpm cm n"�eYJ� �a n c 0 E AS P•��r'^ 'a a.�'m^em'�A eo crtihm E o ,. o�m,y ma mr m oad W m o n a m .i dem v p '"aor"i m� wq N � .varr�mGman�aryn�o m� mom„ iom W"m m ary n n o m m Re .�.neaaN<"orvm nti�� r m^ m e aao a 6Nmm"mrvv a a" � ami ti v � m C N N V M rl N m ' M 17 d m O m V N m I m W N O m m m io O r m d' O m m m o m o m r N N rl `-I o n M r ul M N m d a O vi N ul t0 N M r ri m vi � Ol vi W � .o fl � N .+ M n' V � a m a m m io M o m 0 m m N m m m a m m N m o n r m n m m N �o �o m m ttl' m m wio ON� m lD .1 rt1 n N m m N V m 'i m m Vl C M O m Ifl M ' V O a O r q O OJ On tO m m 1p m m m l0 m N m OJ r N m r N O c-1 m l0 V N I N t0 n r W N Yl Vl Ol t0 m v .ti ri rri ry ro ro ri o o m of m ri ro ri � ri � o n m m m neo n v mromm m m m mo .y m O N M V N r N C M n m n m n tO m n t0 d' t0 h ll Ol O1 ul M 'O N y ttI d� N V lO r W O m m O n m m a m m t0 t0 N a m .y ci m m N M m m C m m m w N .-� O v N m m m N M N N N' V O N N h m N n m N o N O N ei N M N r rl M t0 t0 O ci m O N r m m O N loom '� m mom ry m m n n N m.yN m od o io mva m m n r moo ro ri n �o r .-+ .ti � of O n n M m �y m VI t0 m m m lO o M m H v v m N N N N OJ VI rl O M r "1 N M O rl N n m N n m o N N N t0 m O N M m m m o N 04o o mmm ion v m n.-��o m v a m le 0 of o'o ci m M m N ci oo ni .6v `o' l o v.6 o m rci l a' m n m vi m a oor ry a m m v�o n m mN.-1 m o m o m o m m o m .i m m w m M n c o V ry N N r rl m V M N m ry o m m or m o n r m m y M n O m o 0 m I n7 o vi ni -? ro g m of6 m ri L of n ri vi lO rl m 1D VI V �O M t0 N lO M N r V N N rl N t0 N ti N O al' N nl O VI Ol N V ri ttl O m NO Vt ' O m m iz .� n o m m m M m n a m m N ry o ry m ry r a m ai m O N O n vl N n O O N tO N d' tO W t0 n O ri N hOi t0 cr Ol W lD Oi N V N H N W N m m m m m M N a m lO M m O ei W n C O M rl vl VI Q lO V m m tO N V d' O m M V r tO r N N N o N V N n M O ti m m m v� mo �o m m o mo m M o o nm mm lo.im a M m m .y m o m m ry m o nM VN nO n O W .614 NmN lmm0 NiVo Om Nn OO mm O N N V] O m m " m tO ID ry O m n O o m O r mvml vl rtl t0 N n M N m m o m �o c r io m O m m io n o N M r m n m ro ri v a 'o ri ri vi ui ni ri m .-i ri ri .616 v ri a ti m o m m r V m m io m m m mo ri ri v 0 o m n a m .-i m y ry 16 m o 'o ti m m m m N r r " mi ry m m o m m o m n r N 'o m M m m m m v m m n r o o m m o a m 0 ry m Io m io r r h rl vl d' cr l0 N ttl v.+ -i mi io W V1 N n N �a m m rt1 C. mMm h Z io 0 \ ei mo LO m O V N z [1' r1 M m Vl M M rl N 'i O m M n m N tO vl N d' n m m m n d' N V r l00 M N ci ttl O' Oi N N 16 c m m m r m N N m o 0 0 o a ti n �o ry m o m mnV mryN vn mO NN vOo mm H tt.-0i 0 O W O m Wri m CO mimO N 1O V m Oo t0 O M In ma d' Moo m N m M 0 M m O N tO vl t0 O m tD m r tD O N 14lh O Oi d e-1 16 at0 O I m 0 m m N r O O m V r rO m O r m N O C m m t0 m m r N r O M N r m Nr V m m O m l0 N r O m m lO V m m m m m eri "1 of o ri f vi ory m � ri � vi o au m ry If mm m m,-� m MN mom m �o m o m ro n mN m .y n m m m r m N N E v M C } O v V `w 0 v Y¢ 14 G c c N = v c E o v a o w U N c o_ c c U 2 2 Q 1 a 0 = Yi O U U N a h m '^ m 3v a w U¢ 1O c t m .' v v m w C a h o v N o +. u¢ o w z U c L N E y U .. '�' `a% V 4'Z w°c° E F a a c a m w m u '° v O 0 F '" u `o "~ Q v ❑ o 0 m t0 a ami ti v � m C N N a m m m n v N N m N ry m v1 Ol N W � N tip m N Mn m l0 H W lD o m !d n vi ro m N M n o m m m m N C vl o a m io n m mm O) rl a n�{i of to m m m m uni c} V ci m N m N N Di n i � m m m m M a M al V N ry m o tp N 'i vl � rtml N N Q n N N ' 1 n O N n tO h m ,D Dl N to m ry m m V .ti N ' N O1 N V N c1 tO m m rl N Omi N W 1011 m n m ry v`1i o N m N O [m''1 w m tll Omi n a ri N � pEj N C N �0 t7 O G _~ u G � � E n .a +' u o E ` 13 o a U m n a' - v ¢ m y z w "' �. v m z v � = N D v W � 6 [11 2 ✓1 � � .Q .� N � N Y � N v m v v> a a a a a`t°- Mn tO V N n O •i vi vi m a n�{i of n vmi N uni c} V to Di n i � maJ w v m a M al V N m O tp N O N vl � O N � pEj N C N �0 t7 O G _~ u G � � E n .a +' u o E ` 13 o a U m n a' - v ¢ m y z w "' �. v m z v � = N D v W � 6 [11 2 ✓1 � � .Q .� N � N Y � N v m v v> a a a a a`t°- Memorial Medical Center Capital Acquisitions For the Month Ended November 30, 2018 Month Description Land Building Equipment Total 1/31/18 Panda IRES Warmer w/Instrument5helf 22,530 22,530 1/31/18 Computers -January 2017 - 5,558 5,558 1/31/18 CPSI Software needed for EMR requirements 118,790 118,790 Sub Total January 2/1/2018 Land - 701 N Virginia, Port Lavaca, TX 2/1/2018 Bldg - 701 N Virginia, Port Lavaca, TX 2/12/2018 Trilogy 202 Ventilator 2/28/2018 Computers Sub Total February 3/31/2018 Computers Sub Total March 4/30/2018 Hand Held Ultrasound Unit Sub Total April 5/31/2018 Mammography 5/31/2018 Fiber Optic Link, New Clinic 5/31/2018 Gas Line Sub Total May 6/30/2018 ER Signs Sub Total June 7/31/2018 Computers Sub Total July 8/23/2018 Computers Sub Total August 9/30/2018 CT Room Remodel 9/30/2018 Computers 9/30/2018 Firewall - Cisco 9/30/2018 Occupational Marketing -Audiometer 9/30/2018 Petroleum Solutions - Tank Monitoring Sub Total September None for October Sub Total October 15 -Nov Surical supplies for Ortho Sub Total November Sub Total December Total -19- - 146,878 146,878 141,200 141,200 276,889 276,889 11,338 11,338 14,554 14,554 141,200 276,889 25,891 443,980 10,976 10,976 10,976 10,976 9,675 9,675 9,675 9,675 392,744 392,744 17,905 17,905 5,192 5,192 - - 415,841 415,841 5,028 5,028 8,079 8,079 8,079 8,079 3,176 3,176 9,063 9,063 9,297 9,297 5,530 5,530 3,176 29,045 32,220 39,875 39,875 - - 39,875 39,875 $ 141,200 $ 280,064 693,696 1,114,960 � 7(22!§7§\ 2222§i§ Memorial Medical Center Payer Mix Memorial Medical Center As of November 30, 2018 so 45 40 35 I 30 25 20 10 s N N N ti N SII LL m a � > z Q -3. Q N Z l Seriesl Series2 2—Series3 .:�=Series4 Series6 Series6 -21- Memorial Medical Clinic Payer Mix Memorial Medical Clinic As of November 30, 2018 6 Month Trend 40.0 35.0 30.0 25.0 15.0 10.0 5.0 0.0 -' w c a E n m G o Y o a 0 o w z Medicare Medicaid —e�81ue Cross =yrs^- tiinii ficial Private HMO/PPO & Workers Comp —22— r 6OMMMMMMM eraO2 m Std n a � sr N ' 8r� 0 nmummommmm m sr n- 8rl m 9 amar mammummommmmmmmmmmm gta i �b X m 9r,1 0 �m N ry p 4 mommomommm 8 a„ al 'O 8l � m 8t+ U I i 1 pb N v O m sloo 8 T m ph N' ara sr I 0 `ra sra x' r I I ltv ap ;e 0 o S S o oo�o o�a I p I o. I °2 Y. eraO2 dr n � sr III! II e e dY n- 8rl m 9 m i eri i Kral m 0 e 8 a„ al 'O 8l I ar�p f x EE er9� G m ara 81,9 I 0 `ra m sra I I n b a 0 o S S o oo�o o�a I �o I o. I °2 0 0 0 0 0 0 0 0 0 0 0 o.mmm am N.+ -23- L � ® eraO2 n sr III! II e �s dY n- 8rl 0 m i eri I i I Kral m e 8 n ar�p f x EE er9� e ara 9� x 0 `ra ap m 4� n b a 0 o S S o oo�o o�a 0 0 0 0 0 0 x 0 0 0 0 m i eri I i I r �1 Q I f EE er9� (iII I �P x m 4� 0 0 0 0 0 0 x 0 0 0 Memorial Medical Center Accounts Receivable Agings Aging 0-30 31-60 61-90 91-120 121-150 151-180 181-365 Total Gross % Over % Over % Under % Under Jan -17 2,386,450 285,860 149,700 1 119,244 38,280 120 Days 90 Days 1 60 Days 90 Days Total Jan -17 4,561,199 1,469,951 1,100,920 982,629 476,477 353,442 1,059,659 10,004,278 18.9% 28.7% 60.3% 71.3% Feb -17 3,997,759 1,723,287 1,056,568 781,203 566,018 282,925 1,168,505 9,576,264 21.1% 29.2% 59.7% 70.8% Mar -17 3,773,839 1,907,190 1,179,335 704,554 297,877 283,398 973,224 9,119,417 17.0% 24.8% 62.3% 75.2% Apr -17 3,596,810 1,887,117 1,343,950 698,284 391,335 182,383 958,124 9,058,003 16.9% 24.6% 60.5% 75.4% May -17 3,664,157 1,711,890 1,085,916 791,862 432,566 229,471 1,151,230 9,067,092 20.0% 28.7% 59.3% 71.3% Jun -17 3,969,048 1,754,014 1,170,853 743,100 444,307 267,135 1,008,115 9,356,572 18.4% 26.3% 61.2% 73.7% Jul -17 4,046,347 1,934,970 1,108,644 650,999 470,901 273,275 1,048,009 9,533,146 18.8% 25.6% 62.7% 74.4% Aug -17 3,439,090 2,250,858 1,350,173 824,841 477,805 299,293 1,123,377 9,765,436 19.5% 27.9% 58.3% 72.1% Sep -17 3,476,932 1,831,638 1,338,123 1,019,649 658,678 261,460 1,158,721 9,745,201 21.3% 31.8% 54.5% 68.2% Oct -17 3,950,901 1,447,764 1,309,557 1,078,059 726,276 449,970 1,138,219 10,100,747 22.9% 33.6% 53.4% 66.4% Nov -17 4,031,951 1,942,996 963,012 820,502 674,549 479,208 1,092,091 10,004,309 22.4% 30.7% 59.7% 69.3% Dec -17 3,369,155 1,776,876 1,329,611 957,231 668,287 422,688 1,322,641 9,846,490 24.5% 34.2% 52.3% 65.8% Jan -18 4,037,071 1,509,038 1,276,575 1,102,392 622,605 469,173 1,322,009 10,338,864 23.3% 34.0% 53.6% 66.0% Feb -18 4,404,787 1,771,312 966,966 949,627 805,456 354,935 1,385,778 10,638,860 23.9% 32.9% 58.1% 67.1% Mar -18 3,644,319 2,142,989 1,295,861 817,250 739,113 637,321 1,431,215 10,708,068 26.2% 33.9% 54.0% 66.1% Apr -18 3,973,283 1,797,168 1,488,925 1,103,355 696,484 545,343 1,487,965 11,092,525 24.6% 34.6% 52.0% 65.4% May -18 4,085,271 1,913,588 1,142,851 1,059,675 921,907 384,597 1,521,370 11,029,259 25.6% 35.2% 54.4% 64.8% Jun -18 3,849,206 1,703,638 1,279,846 920,439 782,238 337,403 1,454,395 10,327,165 24.9% 33.8% 53.8% 66.2% Jul -18 3,900,269 1,640,242 1,264,165 973,541 859,006 743,071 1,807,759 11,188,053 30.5% 39.2% 49.5% 60.8% Aug -18 3,763,400 1,733,095 1,104,875 1,052,621 898,089 774,197 1,938,160 11,264,437 32.1% 41.4% 48.8% 58.6% Sep -18 3,905,377 1,782,035 1,042,315 787,688 872,556 776,132 2,182,860 11,348,962 33.8% 40.7% 50.1% 59.3% Oct -18 3,874,629 1,471,773 1,037,378 890,885 688,179 648,286 1,870,134 10,481,265 30.6% 39.1% 51.0% 60.9% Nov -18 4,089,598 1,907,316 1,093,596 896,339 863,349 650,705 2,284,916 11,785,820 32.2% 39.8% 50.9% 60.2% -24- J:\2018\NOVEMBER 2018\AR Monthly Analysis Board Packet - Nov 2018.x1sx Medicare Jan -17 2,386,450 285,860 149,700 155,427 119,244 38,280 52,875 3,187,836 6.6% 11.5% 83.8% 88.5% Feb -17 1,862,872 374,963 116,022 71,331 89,561 13,984 46,738 2,575,471 5.8% 8.6% 86.9% 91.4% Mar -17 2,107,406 436,774 230,248 69,511 20,078 25,536 60,966 2,950,519 3.6% 6.0% 86.2% 94.0% Apr -17 1,976,211 471,695 228,098 143,924 66,892 11,845 48,197 2,946,861 4.3% 9.2% 83.1% 90.8% May -17 1,872,077 421,809 148,604 66,904 34,477 27,215 24,922 2,596,009 3.3% 5.9% 88.4% 94.1% Jun -17 1,901,474 375,067 131,562 51,709 9,333 15,186 51,010 2,535,341 3.0% 5.0% 89.8% 95.0% Jul -17 1,959,529 418,370 115,772 52,310 34,540 7,949 54,922 2,643,393 3.7% 5.7% 90.0% 94.3% Aug -17 1,565,207 548,410 143,762 55,787 29,744 17,895 40,975 2,401,780 3.7% 6.0% 88.0% 94.0% Sep -17 1,655,132 426,033 182,349 35,908 5,783 19,655 53,433 2,378,292 3.3% 4.8% 87.5% 95.2% Oct -17 1,546,696 326,618 168,326 97,667 24,188 5,783 44,675 2,213,954 3.4% 7.8% 84.6% 92.2% Nov -17 1,503,313 314,582 71,861 46,533 60,375 24,632 51,412 2,072,709 6.6% 8.8% 87.7% 91.2% Dec -17 1,538,394 289,336 83,733 70,541 43,439 37,498 59,975 2,122,916 6.6% 10.0% 86.1% 90.0% Jan -18 1,844,700 451,558 77,713 52,902 16,665 43,694 88,177 2,575,409 5.8% 7.8% 89.2% 92.2% Feb -18 2,088,267 361,587 125,854 40,101 35,914 3,745 71,835 2,727,305 4.1% 5.6% 89.8% 94.4% Mar -18 1,581,974 370,210 138,814 105,521 28,386 29,320 52,846 2,307,071 4.8% 9.4% 84.6% 90.6% Apr -18 1,734,620 410,877 227,646 91,038 71,717 23,247 78,523 2,637,667 6.6% 10.0% 81.3% 90.0% May -18 1,825,583 408,277 154,170 124,556 69,720 70,213 59,169 2,711,689 7.3% 11.991 82.491 88.1% Jun -18 1,764,878 198,191 162,714 57,769 48,527 24,513 72,939 2,329,531 6.3% 8.7% 84.3% 91.3% Jul -18 1,759,349 244,537 82,156 34,860 49,928 30,310 47,287 2,248,427 5.7% 7.2% 89.1% 92.8% Aug -18 1,546,920 284,669 71,695 38,259 24,094 38,439 77,846 2,081,922 6.7% 8.6% 88.0% 91.4% Sep -18 1,805,215 330,690 53,618 21,457 35,582 3,572 74,026 2,324,159 4.9% 5.8% 91.9% 94.2% Oct -18 1,679,366 254,111 77,659 34,946 26,921 31,218 103,583 2,207,803 7.3% 8.9% 87.6% 91.1% Nov -18 2,034,186 315,548 117,728 37,089 33,817 27,774 125,583 2,691,725 7.0% 8.3% 87.3% 91.7% -24- J:\2018\NOVEMBER 2018\AR Monthly Analysis Board Packet - Nov 2018.x1sx Memorial Medical Center Accounts Receivable Agings Aging 0-30 31-60 61-90 91-120 121-150 151-180 181-365 Total Gross %Over %Over % Under 'A Under Jan -17 1 1 1 109,745 32,115 240 120 Days 90 Days 60 Days 90 Days -25- 1:\2018\NOVEMBER 2018\AR Monthly Analysis Board Packet -Nov 2018.xfsx Medicaid Jan -17 477,073 109,557 83,221 109,745 32,115 240 49,129 861,079 9.5% 22.2% 68.1% 77.8% Feb -17 499,028 262,788 75,947 70,739 45,052 11,423 23,859 988,836 8.1% 15.3% 77.0% 84.7% Mar -17 366,982 152,054 132,383 55,197 32,554 31,887 31,866 802,924 12.0% 18.9% 64.6% 81.1% Apr -17 446,305 129,854 103,367 44,736 17,612 16,982 38,509 797,364 9.2% 14.8% 72.3% 85.2% May -17 379,502 80,220 47,861 17,661 7,005 4,153 19,719 556,121 5.6% 8.7% 82.7% 91.3% Jun -17 436,594 108,262 21,015 13,369 51,724 4,769 1,162 636,896 9.1% 11.2% 85.5% 88.8% Jul -17 419,361 168,247 44,566 10,362 5,081 1,669 2,140 651,426 1.4% 3.0% 90.2% 97.0% Aug -17 460,814 355,303 115,759 32,474 7,570 2,527 2,963 977,411 1.3% 4.7% 83.5% 95.3% Sep -17 426,389 157,688 95,749 55,878 18,320 5,034 2,324 761,381 3.4% 10.7% 76.7% 89.3% Oct -17 591,739 127,347 107,194 88,329 53,254 15,528 5,416 988,807 7.5% 16.4% 72.7% 83.6% Nov -17 759,598 252,849 58,949 112,208 64,507 29,619 15,371 1,293,102 8.5% 17.1% 78.3% 82.9% Dec -17 431,144 299,722 97,482 58,356 48,616 44,765 14,753 994,838 10.9% 16.7% 73.5% 83.3% Jan -18 422,060 148,528 225,853 86,639 48,806 46,157 49,814 1,027,857 14.1% 22.5% 55.5% 77.5% Feb -18 433,253 154,279 53,562 42,735 66,332 38,398 92,970 881,531 22.4% 27.3% 66.6% 72.7% Mar -18 437,939 133,832 80,035 28,497 19,079 1,863 31,876 733,121 7.2% 11.1% 78.0% 88.9% Apr -18 683,844 151,138 96,296 69,986 13,085 4,637 27,487 1,046,473 4.3% 11.0% 79.8% 89.0% May -18 549,198 266,269 57,422 78,441 35,940 4,968 10,969 1,003,207 5.2% 13.0% 81.3% 87.0% Jun -18 530,391 260,169 168,617 43,823 54,626 19,590 16,051 1,093,267 8.3% 12.3% 72.3% 87.7% Jul -18 423,204 191,192 158,059 71,199 31,984 18,255 44,083 937,976 10.1% 17.6% 65.5% 82.4% Aug -18 406,778 124,853 113,057 74,726 20,198 23,360 29,471 792,443 9.2% 18.6% 67.1% 81.4% Sep -18 335,414 161,756 87,984 47,466 33,959 23,860 33,938 724,378 12.7% 19.2% 68.6% 80.8% Oct -18 448,030 122,525 87,883 29,213 24,348 7,532 13,344 732,875 6.2% 10.2% 77.9% 89.8% Nov -18 336,075 156,777 53,327 28,582 21,941 1,925 7,186 605,811 5.1% 9.8% 81.4% 90.2% BCB5 Jan -17 320,493 84,311 20,250 14,367 5,700 2,621 15,461 463,205 5.1% 8.2% 87.491 91.8% Feb -17 269,307 46,555 27,028 9,863 15,810 5,545 9,349 383,456 8.0% 10.6% 82.4% 89.4% Mar -17 247,112 75,199 12,097 22,972 1,057 8,981 23,522 390,939 8.6% 14.5% 82.4% 85.5% Apr -17 194,701 66,632 11,211 6,873 2,935 1,057 28,239 311,648 10.3% 12.5% 83.9% 87.5% May -17 242,780 26,109 17,740 10,674 1,381 2,735 32,665 334,083 11.0% 14.2% 80.5% 85.8% Jun -17 248,545 88,197 20,152 7,449 1,480 1,545 19,779 387,147 5.9% 7.8% 87.0% 92.2% Jul -17 208,352 47,463 6,757 5,350 3,303 383 21,144 292,752 8.5% 10.3% 87.4% 89.7% Aug -17 164,226 16,122 25,208 5,446 1,896 3,303 19,975 236,175 10.7% 13.0% 76.4% 87.0% Sep47 223,860 51,453 10,158 4,197 2,583 3,249 30,060 325,560 11.0% 12.3% 84.6% 87.7% Oct -17 407,975 17,747 10,268 3,174 3,375 236 37,470 480,246 8.6% 9.2% 88.6% 90.8% Nov -17 290,129 118,230 9,065 8,522 369 1,488 18,526 446,330 4.6% 6.5% 91.5% 93.5% Dec -17 373,181 37,769 104,059 3,292 9,976 369 23,522 552,169 6.1% 6.7% 74.4% 93.3% Jan -18 314,301 41,036 15,097 99,861 3,229 3,315 21,609 498,447 5.6% 25.7% 71.3% 74.3% Feb -18 298,344 49,545 15,003 6,092 15,309 1,956 9,740 395,989 6.8% 8.4% 87.9% 91.6% Mar -18 295,992 108,847 36,620 7,521 2,126 18,355 1,912 471,374 4.8% 6.3% 85.9% 93.7% Apr -18 264,955 59,799 22,052 24,249 3,036 290 3,381 377,761 1.8% 8.2% 86.0% 91.8% May -18 333,429 85,657 28,772 13,701 11,066 853 1,266 474,745 2.8% 5.7% 88.3% 94.3% Jun -18 243,731 39,136 15,863 19,935 5,982 - 339 324,987 1.9% 8.1% 87.0% 91.9% Jul -18 293,552 25,273 21,415 4,663 4,641 1,022 1,147 351,714 1.9% 3.3% 90.6% 96.7% Aug -18 246,685 76,065 10,129 15,588 2,965 1,388 365 353,185 1.3% 5.7% 91.4% 94.3% Sep -18 259,451 36,355 31,903 8,890 14,802 2,895 2,167 356,462 5.6% 8.1% 83.0% 91.9% Oct -18 278,210 10,535 8,081 9,175 7,660 3,928 5,197 322,787 5.2% 8.0% 89.5% 92.0% Nov -18 473,881 65,622 13,374 5,239 2,984 7,660 5,218 573,977 2.8% 3.7% 94.0% 96.3% -25- 1:\2018\NOVEMBER 2018\AR Monthly Analysis Board Packet -Nov 2018.xfsx Memorial Medical Center Accounts Receivable Agings Aging 0-30 31-60 61-90 1 91-120 1 121-150 151-180 1 181-365 1 Total Gross %Over 120Days %Over 90Days %Under 60Days %Under 90Days Commercial Jan -17 998,533 274,367 175,439 123,255 28,246 44,188 92,977 1,737,006 9.5% 16.6% 73.3% 83.4% Feb -17 1,153,728 303,202 157,302 62,901 45,604 24,581 95,421 1,842,739 9.0% 12.4% 79.1% 87.6% Mar -17 844,910 425,021 153,692 91,705 30,928 32,904 123,070 1,702,229 11.0% 16.4% 74.6% 83.6% Apr -17 745,420 490,323 268,383 97,507 74,921 21,913 130,255 1,828,722 12.4% 17.7% 67.6% 82.3% May -17 763,519 358,044 178,198 138,315 67,083 20,153 126,604 1,651,916 12.9% 21.3% 67.9% 78.7% Jun -17 800,121 347,650 176,569 77,169 97,604 39,049 68,539 1,606,701 12.8% 17.6% 71.49' 82.4% Jul -17 774,569 388,804 158,306 62,600 48,270 79,143 74,750 1,586,443 12.7% 16.7% 73.3% 83.3% Aug -17 674,104 448,688 191,443 154,611 47,357 29,752 113,532 1,659,488 11.5% 20.8% 67.7% 79.2% Sep -17 721,865 339,070 195,300 131,925 103,031 30,556 125,411 1,647,158 15.7% 23.7% 64.4% 76.3% Oct -17 835,246 343,682 208,722 150,765 84,940 58,123 140,570 1,822,048 15.6% 23.8% 64.7% 76.2% Nov -17 955,745 435,321 193,894 169,830 88,573 65,646 178,639 2,087,649 15.9% 24.1% 66.6% 75.9% Dec -17 682,636 339,518 224,738 181,524 156,065 41,013 158,761 1,784,255 19.9% 30.1% 57.3% 69.9% Jan -18 824,258 285,290 217,186 165,843 123,015 129,879 187,441 1,932,911 22.8% 31.491 57.4% 68.6% Feb -18 918,183 364,431 202,273 130,000 93,883 63,325 228,521 2,000,617 19.3% 25.8% 64.1% 74.2% Mar -18 850,442 605,732 226,262 153,925 101,948 81,211 256,603 2,276,123 19.3% 26.1% 64.0% 73.9% Apr -18 728,218 431,123 357,405 141,985 128,892 92,298 262,489 2,142,410 22.6% 29.2% 54.1% 70.8% May -18 800,862 278,160 230,641 173,663 65,732 85,795 274,780 1,909,633 22.3% 31.4% 56.5% 68.6% Jun -18 829,499 388,496 142,866 150,542 83,399 24,000 284,230 1,903,032 20.6% 28.5% 64.0% 71.5% Jul -18 825,768 467,637 202,262 79,734 107,817 62,825 248,128 1,994,172 21.0% 25.0% 64.9% 75.0% Aug -18 744,010 433,200 186,860 115,254 57,004 97,936 223,446 1,857,709 20.4% 26.6% 63.451. 73.4% Sep -18 955,278 421,905 184,118 119,636 73,755 32,360 289,966 2,077,017 19.1% 24.8% 66.3% 75.2% Oct -18 751,981 423,249 148,746 104,819 91,486 49,131 256,596 1,826,009 21.8% 27.5% 64.4% 72.5% Nov -18 754,369 434,004 280,506 122,980 92,969 87,543 310,882 2,083,255 23.6% 29.5% 57.0% 70.5% Private Pay Jan -17 378,651 715,855 672,310 579,835 291,172 268,113 849,216 3,755,152 37.5% 52.9% 29.1% 47.1% Feb -17 212,825 735,778 680,269 566,369 369,992 227,392 993,137 3,785,762 42.0% 57.0% 25.1% 43.0% Mar -17 207,429 818,142 650,915 465,170 213,260 184,089 733,800 3,272,806 34.6% 48.8% 31.3% 51.2% Apr -17 234,173 728,613 732,890 405,244 228,976 130,587 712,924 3,173,408 33.8% 46.6% 30.3% 53.4% May -17 406,278 825,708 693,512 558,308 322,621 175,216 947,319 3,928,962 36.8% 51.0% 31.4% 49.0% Jun -17 582,314 834,839 821,554 593,404 284,165 206,586 867,625 4,190,487 32.4% 46.6% 33.8% 53.4% Jul -17 684,536 912,087 783,243 520,376 379,707 184,131 895,053 4,359,133 33.5% 45.4% 36.6% 54.6% Aug -17 574,739 882,335 874,001 576,522 391,238 245,816 945,931 4,490,582 35.3% 48.1% 32.4% 51.9% Sep -17 449,686 857,394 854,568 791,741 528,961 202,966 947,493 4,632,810 36.3% 53.3% 28.2% 46.7% Oct -17 569,246 632,369 815,047 738,124 560,519 370,300 910,087 4,595,692 40.1% 56.1% 26.1% 43.9% Nov -17 523,165 822,013 629,242 483,409 460,724 357,822 828,143 4,104,520 40.1% 51.9% 32.8% 48.1% Dec -17 343,800 810,531 819,598 643,518 410,192 299,042 1,065,630 4,392,313 40.4% 55.1% 26.3% 44.9% Jan -18 631,752 582,628 740,726 697,147 430,891 246,128 974,968 4,304,240 38.4% 54.6% 28.2% 45.4% Feb -18 666,740 841,468 570,272 730,699 594,017 247,510 982,712 4,633,419 39.4% 55.1% 32.6% 44.9% Mar -18 477,973 924,367 814,130 521,786 587,573 506,572 1,087,977 4,920,379 44.3% 55.0% 28.5% 45.0% Apr -18 561,647 744,232 785,526 776,098 479,755 424,871 1,116,085 4,888,213 41.3% 57.2% 26.7% 42.8% May -18 576,199 875,225 671,847 669,314 739,448 222,767 1,175,185 4,929,986 43.4% 56.9% 29.4% 43.1% Jun -18 480,707 817,645 789,785 648,370 589,705 269,300 1,080,836 4,676,348 41.5% 55.3% 27.8% 44.7% Jul -18 598,396 711,603 800,272 783,085 664,636 630,659 1,467,114 5,655,765 48.8% 62.7% 23.2% 37.3% Aug -18 819,007 814,307 723,135 808,794 793,828 613,075 1,607,033 6,179,179 48.8% 61.9% 26.4% 38.1% Sep -18 550,018 831,329 684,693 590,239 714,458 713,445 1,782,763 5,866,945 54.7% 64.8% 23.5% 35.2% Oct -18 717,042 661,353 715,009 712,732 537,764 556,476 1,491,414 5,391,791 48.0% 61.2% 25.6% 38.8% Nov -18 491,088 935,365 628,661 702,449 711,638 525,804 1,836,047 5,831,052 52.7% 64.8% 24.5% 35.2% -26- J:\2018\NOVEMBER 2018\AR Monthly Analysis Board Packet - Nov 2018.xlsx Memorial Medical Center Accounts Receivable Agings Aging 0 -3031 -GO 61-90 91-120 121-150 151-180 I81-365 Total Gross %o e, Or %ve %urUa0 %Uader Jan -17 4,182,549 754,096 428,610 402,794 185,305 85,329 210,443 120 Days 90 Days 1 60 Days 90 Days J:\2018\NOVEMBER 2018\AR Monthly Analysis Board Packet -Nov 2018.x1s7-27 All Insured Jan -17 4,182,549 754,096 428,610 402,794 185,305 85,329 210,443 6,249,126 7.7% 14.1% 79.0% 85.9% Feb -17 3,784,935 987,509 376,299 214,834 196,026 55,533 175,367 5,790,503 7.4% 11.1% 82.4% 88.9% Mar -17 3,566,410 1,089,047 528,420 239,384 84,617 99,309 239,424 5,846,611 7.2% 11.3% 79.6% 88.7% Apr -17 3,362,637 1,158,504 611,060 293,040 162,359 51,796 245,200 5,884,595 7.8% 12.8% 76.8% 87.2% May -17 3,257,878 886,181 392,404 233,555 109,945 54,255 203,911 5,138,130 7.2% 11.7% 80.7% 88.3% Jun -17 3,386,734 919,175 349,298 149,696 160,141 60,549 140,490 5,166,084 7.0% 9.9% 83.3% 90.1% Jul -17 3,361,811 1,022,884 325,400 130,623 91,194 89,145 152,956 5,174,014 6.4% 9.0% 84.7% 91.0% Aug -17 2,864,351 1,368,523 476,171 248,319 86,567 53,477 177,446 5,274,853 6.0% 10.7% 80.2% 89.3% Sep -17 3,027,246 974,244 483,555 227,908 129,716 58,494 211,228 5,112,391 7.8% 12.3% 78.3% 87.7% Oct -17 3,381,655 815,395 494,510 339,935 165,757 79,670 228,132 5,505,055 8.6% 14.8% 76.2% 85.2% Nov -17 3,508,786 1,120,983 333,770 337,093 213,825 121,386 263,948 5,899,789 10.2% 15.9% 78.5% 84.1% Dec -17 3,025,355 966,345 510,013 313,713 258,095 123,645 257,011 5,454,177 11.7% 17.5% 73.2% 82.5% Jan -18 3,405,319 926,411 535,849 405,246 191,715 223,045 347,040 6,034,625 12.6% 19.3% 71.8% 80.7% Feb -18 3,738,047 929,843 396,693 218,928 211,439 107,424 403,066 6,005,442 12.0% 15.7% 77.7% 84.3% Mar -18 3,166,346 1,218,622 481,731 295,463 151,540 130,749 343,238 5,787,689 10.8% 15.9% 75.8% 84.1% Apr -18 3,411,636 1,052,937 703,399 327,258 216,729 120,472 371,881 6,204,312 11.4% 16.7% 72.0% 83.3% May -18 3,509,072 1,038,363 471,005 390,362 182,458 161,829 346,184 6,099,274 11.3% 17.7% 74.6% 82.3% Jun -18 3,368,499 885,993 490,060 272,069 192,533 68,104 373,559 5,650,817 11.2% 16.0% 75.3% 84.0% Jul -18 3,301,873 928,639 463,893 190,456 194,371 112,412 340,645 5,532,288 11.7% 15.1% 76.5% 84.9% Aug -18 2,944,393 918,788 381,740 243,826 104,260 161,122 331,128 5,085,258 11.7% 16.5% 76.0% 83.5% Sep -18 3,355,359 950,706 357,622 197,449 158,098 62,687 400,096 5,482,017 11.3% 14.9% 78.5% 85.1% Oct -18 3,157,587 810,420 322,370 178,153 150,415 91,809 378,720 5,089,474 12.2% 15.7% 78.0% 84.3% Nov -18 3,598,510 971,952 464,935 193,890 151,711 124,902 448,869 5,954,768 12.2% 15.4% 76.8% 84.6% J:\2018\NOVEMBER 2018\AR Monthly Analysis Board Packet -Nov 2018.x1s7-27 Q u U z ar ry a I y QO2 `'I 6 r al a 8r � j i I aar MOPE=o ' 8�a m b a1- 8l. m 4b 81.49 l T sr @ m NNIMMEM !I Bl oliklilli ' gr9y db n V ArP i FI eta gl9ay P� N ry e�4 N tl 'by _ I Pl tr o y �0000 0000" .. wnoNervrv.+ ' I ',� i 0000" o000 0� .i rvnoNem«.. @ "O v b °2 0 0 0 0 o � Bl ry �I4 o r o LTJ �1. R m a a ry ar ry a I y MEMO=I `'I 6 r al a 8r � j i I aar MOPE=o ' sr m b a1- 8l. m 81.49 l W sr NNIMMEM !I Bl oliklilli ' gr9y db n Al ' ArP i FI gl9ay e�4 N tl 'by _ I Pl tr o y �0000 0000" .. wnoNervrv.+ ' I ',� i 0000" o000 0� .i rvnoNem«.. -28- "O Q>i °2 0 0 0 0 o � ry I y MEMO=I `'I r a 8r � j i dr MOPE=o ' sr m NNIMMEM !I oliklilli ' gr9y � � I I � 8l9"1 Al ' i FI N tl 'by _ tr o y �0000 0000" .. wnoNervrv.+ ' I ',� i 0000" o000 0� .i rvnoNem«.. -28- Memorial Medical Clinics Accounts Receivable Agings 1:\2018\NOVEMBER 2018\AR Monthly Analysis Board Packet - Nov 2018.xlsx-2 9- 0-30 31-60 61-90 91-120121-150 151-180 181-365 Total Gross % Over %Over % Under % Under Aging 177,845 45,939 1 1 21,902 27,580 314,021 690,468 120 Days 90 Days 60 Days 90 Days 1:\2018\NOVEMBER 2018\AR Monthly Analysis Board Packet - Nov 2018.xlsx-2 9- Total Jan -17 177,845 45,939 57,264 45,917 21,902 27,580 314,021 690,468 52.6% 59.3% 32.491 40.7% Feb -17 269,462 85,013 35,008 53,331 19,610 21,687 292,038 776,148 42.9% 49.8% 45.7% 50.2% Mar -17 175,914 125,935 47,390 31,997 37,612 18,716 273,709 711,273 46.4% 50.9% 42.4% 49.1% Apr -17 145,546 93,733 96,893 37,133 28,917 26,811 267,720 696,755 46.4% 51.8% 34.3% 48.2% May -17 175,689 51,363 53,860 69,077 10,774 12,250 319,039 692,052 49.4% 59.4% 32.8% 40.6% Jun -17 204,495 59,325 28,792 31,725 50,647 17,575 268,259 660,818 50.9% 55.7% 39.9% 44.3% Jul -17 188,913 77,816 36,857 18,734 8,625 29,129 142,000 502,074 35.8% 39.5% 53.1% 60.5% Aug -17 243,288 83,211 44,944 29,131 14,703 8,905 162,924 587,105 31.8% 36.7% 55.6% 63.3% Sep -17 271,781 60,841 37,973 28,154 15,045 13,523 126,132 553,448 28.0% 33.0% 60.1% 67.0% Oct -17 330,823 88,758 32,676 25,290 20,469 12,114 43,176 553,306 13.7% 18.3% 75.8% 81.7% Nov -17 437,677 45,544 17,584 20,989 18,453 11,121 43,214 594,582 12.2% 15.8% 81.3% 84.2% Dec -17 508,569 32,492 10,313 12,134 4,096 (512) (2,879) 564,212 0.1% 2.3% 95.9% 97.7% Jan -18 489,483 12,415 9,784 10,329 1,798 1,725 (7,453) 518,080 -0.8% 1.2% 96.9% 98.8% Feb -18 662,437 8,542 9,431 10,058 1,294 1,988 (4,032) 689,718 -0.1% 1.3% 97.3% 98.7% Mar -18 339,013 88,982 60,831 26,105 32,849 57,084 38,388 643,253 19.9% 24.0% 66.5% 76.0% Apr -18 222,485 52,817 36,604 15,031 11,116 16,556 254,242 608,851 46.3% 48.8% 45.2% 51.2% May -18 335,753 113,813 52,167 36,240 43,889 6,351 61,873 650,086 17.2% 22.8% 69.2% 77.2% Jun -18 294,657 107,410 73,653 33,359 29,030 39,443 50,232 627,784 18.991 24.2% 64.0% 75.8% Jul -18 260,163 99,274 70,500 57,360 31,081 26,238 71,943 616,559 21.0% 30.3% 58.3% 69.7% Aug -18 280,996 77,067 69,401 61,815 55,394 27,360 86,595 658,628 25.7% 35.1% 54.491 64.9% Sep -18 248,325 86,054 65,173 69,908 57,434 52,914 112,080 692,889 32.1% 42.2% 48.3% 57.8% Oct -18 291,839 80,198 43,070 54,574 56,767 54,791 151,394 732,633 35.9% 43.3% 50.8% 56.7% Nov -18 283,334 119,440 56,831 40,017 40,601 43,012 177,569 760,805 34.3% 39.6% 52.9% 60.4% 1:\2018\NOVEMBER 2018\AR Monthly Analysis Board Packet - Nov 2018.xlsx-2 9- Medicare Jan -17 17,840 1,017 1,820 599 324 (365) (3,056) 18,179 -17.0% -13.7% 103.7% 113.79' Feb -17 42,441 1,388 1,009 1,100 309 374 (3,794) 42,828 -7.3% -4.7% 102.3% 104.7% Mar -17 23,433 1,151 - 225 433 30 (528) 24,744 -0.3% 0.6% 99.4% 99.4% Apr -17 16,507 6,599 720 65 488 105 5,592 30,076 20.6% 20.8% 76.8% 79.2% May -17 56,671 9,259 12,170 5,862 2,646 (377) 31,594 117,824 28.7% 33.7% 56.0% 66.3% Jun -17 17,406 4,659 582 (74) 515 30 (171) 22,948 1.6% 1.3% 96.2% 98.7% Jul -17 30,481 6,143 6,327 299 (530) 9,116 322 52,157 17.1% 17.7% 70.2% 82.35' Aug -17 42,603 (3,362) 4,250 3,536 - (520) 9,747 56,255 16.4% 22.7% 69.8% 77.3% Sep -17 78,674 2,048 6,124 3,316 436 - 796 91,393 1.3% 5.0% 88.3% 95.0% Oct -17 87,459 6,941 1,143 333 3,264 522 556 100,216 4.3% 4.7% 94.2% 95.3% Nov -17 67,989 3,233 1,108 - 1,840 86 - 74,256 2.6% 2.6% 95.9% 97.4% Dec -17 67,807 2,700 240 - 774 - - 71,521 1.1% 1.1% 98.6% 98.9% Jan -18 84,984 1,657 291 - - 161 (463) 86,630 -0.3% -0.3% 100.0% 100.3% Feb -18 37,789 246 90 16 - 161 (730) 37,573 -1.591 -1.5% 101.2% 101.5% Mar -18 46,304 1,787 828 5 8,097 120 1,009 58,151 15.9% 15.9% 82.7% 84.1% Apr -18 40,887 3,659 1,592 507 5 7,751 23,694 78,096 40.3% 40.9% 57.0% 59.1% May -18 39,279 6,412 656 1,119 362 (75) 8,674 56,426 15.9% 17.9% 81.0% 82.1% Jun -18 59,720 9,066 9,481 408 1,335 80 (783) 79,307 0.8% 1.3% 86.7% 98.7% Jul -18 68,106 6,286 6,798 4,141 70 819 (970) 85,251 -0.1% 4.8% 87.3% 95.2% Aug -18 44,236 8,677 3,402 7,413 3,187 190 (43) 67,062 5.0% 16.0% 78.9% 84.0% Sep -18 58,061 3,515 8,218 3,402 7,413 1,532 200 82,341 11.1% 15.2% 74.8% 84.8% Oct -18 46,870 13,775 989 4,803 3,402 2,383 1,732 73,954 10.2% 16.7% 82.0% 83.3% Nov -18 42,211 9,728 10,660 365 1,833 3,402 3,747 71,947 12.5% 13.0% 72.2% 87.0% 1:\2018\NOVEMBER 2018\AR Monthly Analysis Board Packet - Nov 2018.xlsx-2 9- Memorial Medical Clinics Accounts Receivable Agings Aging 0-30 31-60 61-90 97=-18 151-180 181-365 Total Gross % Over % Ovcr % Under % Under Jan -17 16,626 7,325 20,563 I 3,625 7,674 6,218 66,121 120 Days 90 Days 60 Days 90 Days J:\2018\NOVEMBER 2018\AR Monthly Analysis Board Packet - Nov 2018.xisx -30- Medicaid Jan -17 16,626 7,325 20,563 4,089 3,625 7,674 6,218 66,121 26.5% 32.7% 36.2% 67.3% Feb -17 33,792 16,271 7,698 17,132 3,292 2,726 9,970 90,881 17.6% 36.4% 55.1% 63.6% Mar -17 15,543 24,656 14,061 7,046 13,156 1,628 7,185 83,275 26.4% 34.8% 48.3% 65.29' Apr -17 15,411 7,112 15,772 2,064 7,585 10,130 6,631 64,706 37.6% 40.8% 34.8% 59.2% May -17 29,694 4,108 7,185 15,492 (341) (1,957) 50,166 104,346 45.9% 60.7% 32.4% 39.3% Jun -17 32,250 14,432 2,459 3,319 7,103 1,228 8,261 69,052 24.0% 28.8% 67.63' 71.2% Jul -17 16,967 16,640 1,653 1,540 321 1,232 6,658 45,010 18.2% 21.7% 74.7% 78.3% Aug -17 14,853 13,914 7,701 1,638 1,068 276 7,512 46,962 18.9% 22.3% 61.3% 77.7% Sep -17 13,962 3,929 3,406 3,958 1,262 528 7,584 34,630 27.1% 38.5% 51.7% 61.5% Oct -17 12,610 12,669 3,790 3,515 2,313 443 3,044 38,384 15.1% 24.3% 65.9% 75.7% Nov -17 19,742 11,275 1,347 3,384 2,069 443 2,968 41,228 13.3% 21.5% 75.2% 78.5% Dec -17 33,129 10,491 1,094 3,023 2,069 443 21657 52,906 9.8% 15.5% 82.4% 84.5% !an -18 52,500 1,795 1,074 1,817 674 443 (84) 58,218 1.8% 4.9% 93.3% 95.1% Feb -18 180,174 2,576 2,454 2,616 108 268 (603) 187,593 -0.1% 1.3% 97.4% 98.7% Mar -18 41,100 22,475 11,937 3,830 3,377 4,997 8,406 96,123 17.5% 21.4% 66.1% 78.6% Apr -18 52,892 18,629 21,433 7,968 1,786 3,337 19,807 125,852 19.8% 26.1% 56.8% 73.9% May -18 62,491 36,104 12,462 18,326 5,192 1,231 10,369 146,176 11.5% 24.0% 67.4% 76.0% Jun -18 49,771 38,609 16,595 8,765 16,308 3,990 2,867 136,906 16.9% 23.3% 64.6% 76.7% Jul -18 37,712 27,135 28,797 15,558 8,267 14,650 5,291 137,408 20.5% 31.9% 47.2% 68.1% Aug -18 46,844 27,268 25,800 24,544 15,418 8,187 16,598 164,658 24.4% 39.3% 45.0% 60.7% Sep -18 50,254 17,527 26,074 24,043 22,082 14,486 23,673 178,138 33.8% 47.3% 38.0% 52.7% Oct -18 74,987 17,600 19,624 28,277 24,543 21,921 37,302 224,253 37.4% 50.0% 41.3% 50.0% Nov -18 36,903 54,776 13,278 17,977 19,628 15,621 51,516 209,698 41.491 49.9% 43.7% 50.1% BCBS Jan -17 15,036 526 1,947 90 (181) 6,476 (11,195) 12,699 -38.6% -37.9% 122.5% 137.9% Feb -17 6,660 15,105 (326) 2,308 - (394) (5,372) 17,981 -32.1% -19.2% 121.0% 119.2% Mar -17 2,789 4,112 12,515 (733) 2,488 120 (1,286) 20,006 6.6% 2.9% 34.5% 97.1% Apr -17 2,554 199 3,859 13,683 2,549 647 6,340 29,831 32.0% 77.8% 9.2% 22.2% May -17 5,405 2,973 2,279 8,019 8,845 8,153 54,823 90,498 79.4% 88.2% 9.3% 11.8% Jun -17. 20,029 (4,508) 1,641 (268) (24) 9,755 (1,972) 24,653 31.5% 30.4% 63.0% 69.6% Jul -17 11,144 986 512 828 (268) 3,465 (1,756) 14,911 9.7% 15.2% 81.3% 84.8% Aug -17 20,935 660 121 438 882 - (1,639) 21,396 -3.5% -1.5% 100.9% 101.5% Sep -17 37,143 934 - (751) - 984 - 38,310 2.6% 0.6% 99.4% 99.4% Oct -17 32,005 2,293 112 - 161 - - 34,570 0.5% 0.5% 99.2% 99.5% Nov -17 57,757 622 88 - - - - 58,467 0.0% 0.0% 99.8% 100.0% Dec -17 58,955 582 48 (24) - - (1,826) 57,735 -3.2% -3.2% 103.1% 200.0% Jan -18 50,641 - 48 (24) - - (1,856) 48,808 -3.8% -3.9% 103.8% 103.9% Feb -18 85,189 - - (24) - 235 (1,856) 83,544 -1.9% -2.0% 102.0% 102.0% Mar -18 43,110 1,026 1,940 1,161 15,789 3,190 (11710) 64,507 26.8% 28.6% 68.4% 71.4% Apr -18 20,032 1,918 883 759 1,077 3,434 33,269 61,372 61.6% 62.8% 35.8% 37.2% May -18 46,176 2,168 1,308 129 51 1,280 1,140 52,251 4.7% 5.09' 92.5% 95.0% Jun -18 35,387 5,243 145 802 129 (55) 1,140 42,791 2.8% 4.7% 95.0% 95.3% Jul -18 23,376 10,826 761 183 24 - 990 36,159 2.8% 3.3% 94.6% 96.7% Aug -18 33,724 3,099 6,214 879 53 24 1,494 45,487 3.5% 5.4% 81.0% 94.6% Sep -18 16,832 3,834 3,058 5,481 (40) 53 1,702 30,921 5.5% 23.3% 66.8% 76.7% Oct -18 40,167 7,467 2,059 329 675 (40) (2,235) 48,422 -3.3% -2.6% 98.4% 102.6% Nov -18 38,892 11,973 7,427 2,099 329 675 (1,999) 59,397 -1.7% 1.9% 85.6% 98.1% J:\2018\NOVEMBER 2018\AR Monthly Analysis Board Packet - Nov 2018.xisx -30- Memorial Medical Clinics Accounts Receivable Agings Aging 0-30 31-60 61-90 91-120 121-150 151-180 i!701-1 Gross %Over % Over %Under %Under Jan -17 45,282 6,706 13,671 1 1 1 1 102,734 120 Days I 90 Days I 60 Days 90 Days J:\2018\NOVEMBER 2018\AR Monthly Analysis Board Packet- Nov 2018.xlsx-31 - Commercial Jan -17 45,282 6,706 13,671 3,579 5,265 9,645 18,586 102,734 32.6% 36.1% 50.6% 63.9% Feb -17 53,630 13,122 4,215 16,080 3,342 8,519 13,977 112,884 22.9% 37.1% 59.1% 62.9% Mar -17 61,118 42,365 4,785 2,228 5,522 3,111 1,749 120,878 8.6% 10.4% 85.6% 89.6% Apr -17 26,405 37,256 25,653 5,173 (2,768) 3,190 (13,490) 81,418 -16.1% -9.7% 78.2% 109.7% May -17 5,066 2,181 12,858 16,131 (7,987) (2,879) (21,296) 4,074 -789.5% -393.5% 177.9% 493.5% Jun -17 111,604 31,936 11,222 12,838 16,527 353 (555) 183,925 8.9% 15.9% 78.0% 84.1% Jul -17 104,116 29,081 6,553 4,327 224 3,687 (457) 147,532 2.3% 5.3% 90.3% 94.7% Aug -17 126,645 39,727 8,364 6,807 1,778 126 (1,269) 182,177 0.3% 4.1% 91.3% 95.9% Sep -17 124,179 39,183 12,093 2,047 1,173 932 2,381 181,989 2.5% 3.6% 89.8% 96.4% Oct -17 168,711 48,813 13,956 9,875 677 910 2,813 245,755 1.8% 5.8% 88.5% 94.2% Nov -17 236,703 15,336 5,680 8,157 324 450 2,438 269,088 1.2% 4.29' 93.7% 95.8% Dec -17 266,196 9,379 2,670 2,715 196 (242) (4,489) 276,424 -1.6% -0.7% 99.7% 100.7% Jan -18 235,748 2,981 1,877 2,438 92 1,736 (3,990) 240,882 -0.9% 0.1% 99.1% 99.9% Feb -18 206,928 (201) 397 1,458 - 1,836 (3,675) 206,743 -0.9% -0.2% 100.0% 100.2% Mar -18 129,401 43,274 4,835 23,519 8,778 29,821 8,404 248,033 19.0% 28.4% 69.6% 71.6% Apr -18 20,869 (7,062) 6,843 (25,374) 8,806 5,402 142,580 152,063 103.1% 86.49' 9.1% 13.6% May -18 120,047 41,619 14,041 8,497 3,521 4,324 5,315 197,364 6.7% 11.0% 81.9% 89.0% Jun -18 107,317 33,964 16,185 11,405 6,213 3,117 6,947 185,149 8.8% 15.0% 76.3% 85.0% Jul -18 96,918 36,921 18,582 15,670 10,230 6,428 6,741 191,490 12.2% 20.4% 69.9% 79.6% Aug -18 120,715 19,719 19,916 16,106 14,816 7,363 7,198 205,834 14.3% 22.1% 68.2% 77.9% Sep -18 79,477 35,827 14,332 18,938 15,622 14,313 13,691 192,201 22.7% 32.6% 60.0% 67.4% Oct -18 92,127 22,537 7,538 6,564 16,964 13,668 23,937 183,334 29.8% 33.39' 62.5% 66.7% Nov -18 115,695 26,818 11,718 4,087 5,716 8,555 44,665 217,254 27.1% 29.0% 65.6% 71.0% Private Pay Jan -17 83,062 30,364 19,264 37,560 12,870 4,148 303,467 490,736 65.3% 73.0% 23.1% 27.0% Feb -17 132,939 39,126 22,413 16,711 12,667 10,462 277,256 511,573 58.7% 62.0% 33.6% 38.0% Mar -17 73,030 53,651 16,030 23,231 16,012 13,827 266,590 462,371 64.1% 69.1% 27.4% 30.9% Apr -17 84,668 42,568 50,889 16,150 21,063 12,740 262,647 490,725 60.4% 63.7% 25.9% 36.3% May -17 78,853 32,843 19,367 23,572 7,613 9,310 203,753 375,311 58.8% 65.1% 29.8% 34.9% Jun -17 23,206 12,806 12,888 15,911 26,526 6,209 262,695 360,240 82.0% 86.4% 10.0% 13.6% Jul -17 26,206 24,966 21,813 11,740 8,878 11,629 137,233 242,465 65.1% 69.9% 21.1% 30.1% Aug -17 38,252 32,271 24,509 16,712 10,975 9,022 148,573 280,314 60.1% 66.1% 25.2% 33.9% Sep -17 17,824 14,747 16,351 19,582 12,173 11,078 115,372 207,126 66.9% 76.4% 15.7% 23.6% Oct -17 30,039 18,043 13,676 11,567 14,054 10,239 36,763 134,381 45.491 54.0% 35.8% 46.0% Nov -17 55,486 15,077 9,361 9,448 14,220 10,143 37,808 151,543 41.0% 47.3% 46.6% 52.7% Dec -17 82,482 9,340 6,261 6,420 1,057 (712) 779 105,626 1.1% 7.1% 86.9% 92.9% Jan -18 65,611 5,982 6,493 6,098 1,032 (615) (11060) 83,541 -0.8% 6.5% 85.7% 93.5% Feb -18 152,357 5,922 6,490 5,992 1,186 (513) 2,832 174,264 2.0% 5.4% 90.8% 94.6% Mar -18 79,096 20,420 41,290 (2,410) (3,192) 18,956 22,278 176,437 21.6% 20.2% 56.4% 79.8% Apr -18 87,804 35,673 5,853 31,171 (557) (3,368) 34,890 191,467 16.2% 32.5% 64.5% 67.5% May -18 67,759 27,510 23,701 8,169 34,763 (409) 36,375 197,868 35.7% 39.9% 48.1% 60.1% Jun -18 42,461 20,528 31,246 11,979 5,045 32,310 40,062 183,631 42.2% 48.7% 34.3% 51.3% Jul -18 34,052 18,106 15,562 21,808 12,490 4,341 59,892 166,251 46.1% 59.3% 31.49' 40.7% Aug -18 35,477 18,304 14,070 12,874 21,920 11,595 61,348 175,588 54.0% 61.4% 30.6% 38.6% Sep -18 43,701 25,352 14,491 18,044 12,357 22,530 72,814 209,289 51.5% 60.1% 33.0% 39.9% Oct -18 37,688 18,818 12,860 14,601 11,183 16,860 90,659 202,670 58.6% 65.8% 27.9% 34.2% Nov -18 49,633 16,146 13,747 15,490 13,094 14,760 79,640 202,509 53.1% 60.7% 32.5% 39.3% J:\2018\NOVEMBER 2018\AR Monthly Analysis Board Packet- Nov 2018.xlsx-31 - Memorial Medical Clinics Accounts Receivable Agings ging 0-30 31-60 61-90 91-120 121-150 151-180 181-365 Total Grass %Over[Y.20 r:-L::_ 94,783 15,574 38,000 8,357 9,032 23,432 10,554 199,732 Days 25.7% 55.3% 74.3% J:\2018\NOVEMBER 2018\AR Monthly Analysis Board Packet- Nov 2018.xlsx-3 2- All Insured Jan -17 94,783 15,574 38,000 8,357 9,032 23,432 10,554 199,732 21.5% 25.7% 55.3% 74.3% Feb -17 136,523 45,887 12,595 36,620 6,943 11,224 14,783 264,575 12.5% 26.3% 68.9% 73.7% Mar -17 102,884 72,284 31,360 8,765 21,600 4,889 7,119 248,902 13.5% 17.0% 70.4% 83.0% Apr -17 60,878 51,165 46,004 20,984 7,854 14,072 5,073 206,030 13.1% 23.3% 54.4% 76.7% May -17 96,836 18,520 34,492 45,505 3,162 2,940 115,286 316,741 38.3% 52.7% 36.4% 47.3% Jun -17 181,289 46,519 15,904 15,814 24,121 11,366 5,564 300,577 13.7% 18.9% 75.8% 81.1% Jul -17 162,707 52,850 15,044 6,994 (253) 17,500 4,767 259,609 8.5% 11.2% 83.0% 88.8% Aug -17 205,036 50,940 20,435 12,419 3,727 (117) 14,351 306,791 5.9% 9.9% 83.4% 90.1% Sep -17 253,958 46,094 21,623 8,571 2,872 2,445 10,760 346,322 4.6% 7.1% 86.6% 92.9% Oct -17 300,784 70,716 19,001 13,723 6,414 1,875 6,412 418,925 3.5% 6.8% 88.7% 93.2% Nov -17 382,191 30,466 8,223 11,542 4,233 978 5,406 443,039 2.4% 5.0% 93.1% 95.0% Dec -17 426,087 23,152 4,052 5,714 3,039 200 (3,658) 458,586 -0.1% 1.2% 98.0% 98.8% Jan -18 423,872 6,433 3,291 4,231 766 2,340 (6,394) 434,538 -0.8% 0.2% 99.0% 99.8% Feb -18 510,080 2,621 2,941 4,066 108 2,501 (6,864) 515,453 -0.8% 0.0% 99.59' 100.0% Mar -18 259,916 68,562 19,540 28,515 36,042 38,128 16,110 466,813 19.3% 25.4% 70.4% 74.6% Apr -18 134,680 17,144 30,751 (16,140) 11,673 19,924 219,351 417,382 60.1% 56.3% 36.4% 43.7% May -18 267,993 86,303 28,467 28,071 9,126 6,760 25,498 452,217 9.2% 15.4% 78.3% 84.6% Jun -18 252,196 86,883 42,406 21,381 23,985 7,132 10,171 444,153 9.3% 14.1% 76.3% 85.9% Jul -18 226,111 81,168 54,938 35,551 18,591 21,897 12,051 450,308 11.7% 19.6% 68.2% 80.4% Aug -18 245,519 58,764 55,331 48,941 33,474 15,765 25,247 483,041 15.491 25.6% 63.0% 74.491 Sep -18 204,625 60,702 51,683 51,864 45,076 30,384 39,267 483,600 23.7% 34.4% 54.9% 65.6% Oct -18 254,150 61,380 30,210 39,973 45,583 37,932 60,735 529,963 27.2% 34.8% 59.5% 65.2% Nov -18 233,701 103,294 43,083 24,528 27,507 28,252 97,929 558,296 27.5% 31.9% 60.4% 68.1% J:\2018\NOVEMBER 2018\AR Monthly Analysis Board Packet- Nov 2018.xlsx-3 2- MEMORIAL MEDICAL CENTER CHECK REGISTER: NOVEMBER 01, 2018 - NOVEMBER 30, 2018 BANK CODE CHECKNUMBERDATE AMOUNT PAYEE A/P 1001 11/16/2018 $8,085.05 AMERISOURCEBERGEN A/P 1003 11/30/2018 $3,436.40 AMERISOURCEBERGEN A/P 1006 11/06/2018 $10,420.76 MCKESSON A/P 1007 11/14/2018 $2,809.30 MCKESSON A/P 1008 11/20/2018 $2,407.47 MCKESSON A/P 1009 11/27/2018 $1,183.39 MCKESSON A/P 172403 11/20/2018 $0.00 MMC OPERATING PROSPERITY ACC A/P 172404 11/20/2018 $65,000.00 MMC OPERATING PROSPERITY ACC A/P 176420 11/20/2018 ($1,842.50) WALLER,LANSDEN, DORTCH & DAVIS A/P 177939 11/27/2018 $0.00 JOHNSTONE SUPPLY A/P 178037 11/27/2018 ($49.99) JOHNSTONE SUPPLY A/P 178184 11/07/2018 $15.98 ACE HARDWARE 15521 A/P 178185 11/07/2018 $2,438.62 AIRGAS USA,LLC- CENTRAL DIV A/P 178186 11/07/2018 $1,547.70 ALCON LABORATORIES, INC. A/P 178187 11/07/2018 $12,619.00 AMERICAN PROFICIENCY INSTITUTE A/P 178188 11/07/2018 $38.83 AUTO PARTS & MACHINE CO. A/P 178189 11/07/2018 $769.45 BAXTER HEALTHCARE A/P 178190 11/07/2018 $10,422.93 BECKMAN COULTER INC A/P 178191 11/07/2018 $814.95 BEEKLEY MEDICAL A/P 178192 11/07/2018 $214.70 DAWN MCCLELLAND A/P 178193 11/07/2018 $182.33 DEWITT POTH & SON A/P 178194 11/07/2018 $136,807.28 DISCOVERY MEDICAL NETWORK INC A/P 178195 11/07/2018 $552.40 DSHS CENTRAL LAB MC2004 A/P 178196 11/07/2018 $62.63 DYNATRONICS CORPORATION A/P 178197 11/07/2018 $40,062.50 EMERGENCY STAFFING SOLUTIONS A/P 178198 11/07/2018 $178.86 ERIN CLEVENGER A/P 178199 11/07/2018 $1,982.50 FIRE DOOR SOLUTIONS A/P 178200 11/07/2018 $75.00 FIRST CLEARING A/P 178201 11/07/2018 $11,175.79 FISHER HEALTHCARE A/P 178202 11/07/2018 $308.77 FLDR DESIGNS LLC A/P 178203 11/07/2018 $949.00 FORT BEND SERVICES, INC A/P 178204 11/07/2018 $122.44 GETINGE USA A/P 178205 11/07/2018 $354.40 GULF COAST PAPER COMPANY A/P 178206 11/07/2018 $26.49 HAYES ELECTRIC SERVICE A/P 178207 11/07/2018 $0.00 VOIDED A/P 178208 11/07/2018 $771.05 HER CREDIT RECEIVABLES DEPT308 A/P 178209 11/07/2018 $517.12 HOLOGIC INC A/P 178210 11/07/2018 $11.25 ICU MEDICAL, INC A/P 178211 11/07/2018 $209.70 KATHYJIMENEZ A/P 178212 11/07/2018 $173.62 KELLYSCHOTT A/P 178213 11/07/2018 $3,741.87 LABCORP OF AMERICA HOLDINGS A/P 178214 11/07/2018 $24,327.92 LUBY'S FUDDRUCKERS RESTAURANTS A/P 178215 11/07/2018 $1,045.00 M G TRUST A/P 178216 11/07/2018 $423.55 MCKESSON MEDICAL SURGICAL INC A/P 178217 11/07/2018 $263.69 MEDIVATORS A/P 178218 11/07/2018 $3,367.17 MEDLINE INDUSTRIES INC A/P 178219 11/07/2018 $0.00 MEMORIAL MEDICAL CENTER A/P 178220 11/07/2018 $150.00 MEMORIAL MEDICAL CLINIC -33- BANKCODE CHECK NUMBER DATE AMOUNT PAYEE A/P 178221 11/07/2018 $75.63 MERCEDES MEDICAL A/P 178222 11/07/2018 $1,603.52 MERRY X-RAY/SOURCEONE HEALTHCA A/P 178223 11/07/2018 $806.72 MICRO SURGICAL TECHNOLOGY INC A/P 178224 11/07/2018 $121.79 MID -COAST ELECTRIC SUPPLY, INC A/P 178225 11/07/2018 $160.80 MMC AUXILIARY GIFT SHOP A/P 178226 11/07/2018 $19,892.81 MMC EMPLOYEE BENEFIT PLAN A/P 178227 11/07/2018 $0.00 VOIDED A/P 178228 11/07/2018 $11,721.76 MORRIS & DICKSON CO, LLC A/P 178229 11/07/2018 $2,935.51 OCCU PRO LLC A/P 178230 11/07/2018 $749.93 ORTHO CLINICAL DIAGNOSTICS A/P 178231 11/07/2018 $738.06 OWENS & MINOR A/P 178232 11/07/2018 $2,490.00 PABLO GARZA A/P 178233 11/07/2018 $1,496.93 PRINCIPAL LIFE A/P 178234 11/07/2018 $1,625.00 RADSOURCE A/P 178235 11/07/2018 $738.31 SAM'S CLUB DIRECT A/P 178236 11/07/2018 $113.59 SERVICE SUPPLY OF VICTORIA INC A/P 178237 11/07/2018 $771.36 SERVPRO OF VICTORIA A/P 178238 11/07/2018 $272.36 SHIRLEY KARNEI A/P 178239 11/07/2018 $232.00 SOUTH TEXAS BLOOD & TISSUE CEN A/P 178240 11/07/2018 $385.00 STANFORD VACUUM SERVICE A/P 178241 11/07/2018 $2,465.00 STERIS INSTRUMENT MANAGEMENT A/P 178242 11/07/2018 $361.31 STRYKER SALES CORP A/P 178243 11/07/2018 $3,690.52 TEXAS ADVANTAGE COMMUNITY BANK A/P 178244 11/07/2018 $7,679.89 THE US CONSULTING GROUP A/P 178245 11/07/2018 $1,728.00 THYSSENKRUPP ELEVATOR CORP A/P 178246 11/07/2018 $295.41 TRI-ANIM HEALTH SERVICES INC A/P 178247 11/07/2018 $3,356.30 UNIFIRST HOLDINGS INC A/P 178248 11/07/2018 $50.00 VICTORIA COMMUNICATION SVCS A/P 178249 11/07/2018 $2,699.58 WAGEWORKS A/P 178250 11/07/2018 $1,571.67 WERFEN USA LLC A/P 178251 11/07/2018 $848.00 ZIMMER BIOMET A/P 178252 11/20/2018 $46.75 ACE HARDWARE 15521 A/P 178253 11/20/2018 $49.30 ACOG DISTRIBUTION CENTER A/P 178254 11/20/2018 $31.61 ADRIANNA GALVAN A/P 178255 11/20/2018 $45.92 AIRGAS USA, LLC -CENTRAL DIV A/P 178256 11/20/2018 $109.06 ALIMED INC. A/P 178257 11/20/2018 $2,776.93 ALLIED BENEFIT SYSTEMS A/P 178258 11/20/2018 $14,787.24 ASHFORD GARDENS A/P 178259 11/20/2018 $2,464.00 AYA HEALTHCARE INC A/P 178260 11/20/2018 $344.62 BARD PERIPHERAL VASCULAR A/P 178261 11/20/2018 $530.77 BAXTER HEALTHCARE A/P 178262 11/20/2018 $1,245.00 BAYER HEALTHCARE A/P 178263 11/20/2018 $212.95 BEEKLEY MEDICAL A/P 178264 11/20/2018 $123.75 BHB MACHINE & PUMP REPAIR, LLC A/P 178265 11/20/2018 $220.38 BRIGGS HEALTHCARE A/P 178266 11/20/2018 $17,421.22 BROADMOOR AT CREEKSIDE PARK A/P 178267 11/20/2018 $925.00 C -D ELECTRIC A/P 178268 11/20/2018 $135.19 CALHOUN COUNTY A/P 178269 11/20/2018 $180.00 CALHOUN COUNTY INDIGENT ACCOUN A/P 178270 11/20/2018 $200.00 CALHOUN COUNTY SHERIFFS OFFICE A/P 178271 11/20/2018 $630.90 CARDINAL HEALTH 414,LLC A/P 178272 11/20/2018 $4,353.14 CAREFUSION 211, INC. -34- BANKCODE CHECK NUMBER DATE AMOUNT PAYEE A/P 178273 11/20/2018 $40.60 CENTERPOINT ENERGY A/P 178274 11/20/2018 $65.71 COASTAL OFFICE SOLUTONS A/P 178275 11/20/2018 $1,630.10 COMBINED INSURANCE A/P 178276 11/20/2018 $125.52 CON MED CORPORATION A/P 178277 11/20/2018 $1,249.13 COVIDIEN A/P 178278 11/20/2018 $707.17 CUSTOM MEDICAL SPECIALTIES A/P 178279 11/20/2018 $400.00 CYGNUS MEDICAL LLC A/P 178280 11/20/2018 $324.81 CYRACOM LLC A/P 178281 11/20/2018 $0.00 VOIDED A/P 178282 11/20/2018 $1,586.95 DEWITT POTH & SON A/P 178283 11/20/2018 $81.28 DYNATRONICS CORPORATION A/P 178284 11/20/2018 $155.24 ERBE USA INC SURGICAL SYSTEMS A/P 178285 11/20/2018 $23.33 FEDERAL EXPRESS CORP. A/P 178286 11/20/2018 $0.00 VOIDED A/P 178287 11/20/2018 $11,723.40 FISHER HEALTHCARE A/P 178288 11/20/2018 $730.66 FRONTIER A/P 178289 11/20/2018 $5,168.73 GARDNER & WHITE, INC. A/P 178290 11/20/2018 $122.46 GENESIS DIAGNOSTICS A/P 178291 11/20/2018 $183.88 GETINGE USA SALES LLC A/P 178292 11/20/2018 $81,645.39 GOLDENCREEK HEALTHCARE A/P 178293 11/20/2018 $912.93 GRAINGER A/P 178294 11/20/2018 $100.00 GULF COAST DELIVERY A/P 178295 11/20/2018 $604.15 GULF COAST PAPER COMPANY A/P 178296 11/20/2018 $0.00 HAYES ELECTRIC SERVICE A/P 178297 11/20/2018 $1,241.56 HOLOGIC INC A/P 178298 11/20/2018 $10,419.46 J & 1 HEALTH CARE SYSTEMS, INC A/P 178299 11/20/2018 $352.06 JASON ANGLIN A/P 178300 11/20/2018 $30.63 JESUSITAS.HERNANDEZ A/P 178301 11/20/2018 $1,049.00 MASA A/P 178302 11/20/2018 $430.83 MCKESSON MEDICAL SURGICAL INC A/P 178303 11/20/2018 $427.22 MEDIVATORS A/P 178304 11/20/2018 $0.00 VOIDED A/P 178305 11/20/2018 $0.00 VOIDED A/P 178306 11/20/2018 $0.00 VOIDED A/P 178307 11/20/2018 $10,224.62 MEDLINE INDUSTRIES INC A/P 178308 11/20/2018 $293.06 MICROTEK MEDICAL INC A/P 178309 11/20/2018 $153.73 MMCAUXILIARY GIFT SHOP A/P 178310 11/20/2018 $112.86 MMC VOLUNTEERS A/P 178311 11/20/2018 $0.00 VOIDED A/P 178312 11/20/2018 $1,007.90 MORRIS & DICKSON CO, LLC A/P 178313 11/20/2018 $218.96 NURSES CHOICE CORPORATION A/P 178314 11/20/2018 $65.54 OFFICE DEPOT A/P 178315 11/20/2018 $46.54 ORIENTAL TRADING CO INC A/P 178316 11/20/2018 $440.39 OWENS & MINOR A/P 178317 11/20/2018 $10,634.77 PAETEC(WIN DSTREAM) A/P 178318 11/20/2018 $273.60 PENNY GOULDEN A/P 178319 11/20/2018 $240.00 PHILIPS HEALTHCARE A/P 178320 11/20/2018 $96.00 PORT LAVACA CLINICASSOC A/P 178321 11/20/2018 $4,500.00 PREMIER SLEEP DISORDERS CENTER A/P 178322 11/20/2018 $75.00 RACHEL PADRON A/P 178323 11/20/2018 $9,172.23 RICOH USA, INC. A/P 178324 11/20/2018 $1,994.72 SANOFI PASTEUR INC -35- BANK CODE CHECK NUMBER DATE AMOUNT PAYEE A/P 178325 11/20/2018 $1,333.33 SIEMENS FINANCIAL SERVICES A/P 178326 11/20/2018 $1,338.04 SMITH & NEPHEW A/P 178327 11/20/2018 $331.94 SMITHS MEDICAL ASD INC A/P 178328 11/20/2018 $375.01 SOLERA WEST HOUSTON A/P 178329 11/20/2018 $2,295.25 STERIS CORPORATION A/P 178330 11/20/2018 $1,156.00 STERIS INSTRUMENT MANAGEMENT A/P 178331 11/20/2018 $7,875.00 THE CRESCENT A/P 178332 11/20/2018 $673.31 THE US CONSULTING GROUP A/P 178333 11/20/2018 $1,229.40 THYSSENKRUPP ELEVATOR CORP A/P 178334 11/20/2018 $3,100.00 TRINITY PHYSICS CONSULTING LLC A/P 178335 11/20/2018 $2,378.63 UNIFIRST HOLDINGS INC A/P 178336 11/20/2018 $221.86 UNIFORM ADVANTAGE A/P 178337 11/20/2018 $33,793.51 VICTORIA ANESTHESIOLOGY A/P 178338 11/20/2018 $670.00 VICTORIA RADIOWORKS, LTD A/P 178339 11/20/2018 $26,623.40 WAGEWORKS A/P 178340 11/20/2018 $2,436.35 WERFEN USA LLC A/P 178341 11/20/2018 $66.00 WEST COAST MEDICAL RESOURCES A/P 178342 11/20/2018 $488.00 WEST INTERACTIVE SERVICES CORP A/P 178343 11/20/2018 $682.00 WISCONSIN STATE LABORATORY A/P 178344 11/14/2018 $56.80 ACCENT A/P 178345 11/14/2018 $511.69 ACCENT A/P 178346 11/14/2018 $1,280.61 AETNA A/P 178347 11/14/2018 $981.07 OSCAR INSURANCE CORP. A/P 178348 11/14/2018 $1,329.91 SOUTHERN OPERATORS HEAL A/P 178349 11/14/2018 $2,163.16 UHC MEDICARE SOLUTIONS A/P 178350 11/14/2018 $886.20 UNITED HEALTHCARE A/P 178351 11/14/2018 $728.01 UNITED HEALTHCARE A/P 178352 11/14/2018 $3,777.24 UNITED HEALTHCARE COMMU A/P 178353 11/14/2018 $60.00 UNITED HEALTHCARE MEDIC A/P 178354 11/14/2018 $1,596.49 UNITED HEALTHCARE MEDIC A/P 178355 11/14/2018 $75.50 ■ A/P 178356 11/14/2018 $359.71 A/P 178357 11/20/2018 $300.09 41MPRINT, INC. A/P 178358 11/20/2018 $54.90 ACE HARDWARE 15521 A/P 178359 11/20/2018 $1,888.00 ACOSTA ELECTRIC A/P 178360 11/20/2018 $57.95 AQUA BEVERAGE COMPANY A/P 178361 11/20/2018 $2,863.75 AYA HEALTHCARE INC A/P 178362 11/20/2018 $19.22 BAXTER HEALTHCARE A/P 178363 11/20/2018 $572.32 BAYER HEALTHCARE A/P 178364 11/20/2018 $1,191.90 BECKMAN COULTER INC A/P 178365 11/20/2018 $1,358.63 BECTON, DICKINSON & CO (BD) A/P 178366 11/20/2018 $2,496.99 BELFOR USA GROUP, INC A/P 178367 11/20/2018 $140.00 BHB MACHINE & PUMP REPAIR, LLC A/P 178368 11/20/2018 $4,160.00 BKD, LLP A/P 178369 11/20/2018 $12,215.00 BROADMOOR AT CREEKSIDE PARK A/P 178370 11/20/2018 $2.08 CALHOUN COUNTY APPRAISAL DIST A/P 178371 11/20/2018 $1,371.74 CHANNING L BETE CO INC A/P 178372 11/20/2018 $80.00 CHRIS KOVAREK A/P 178373 11/20/2018 $2,418.90 CHRISTINA ZAPATA-ARROYO A/P 178374 11/20/2018 $159.66 COASTAL OFFICE SOLUTONS A/P 178375 11/20/2018 $240.00 COOPER SURGICAL INC A/P 178376 11/20/2018 $176.00 COVER ONE -36- BANK CODE CHECK NUMBER DATE AMOUNT PAYEE A/P 178377 11/20/2018 $2,965.64 CSI LEASING INC A/P 178378 11/20/2018 $1,029.24 DEWITT POTH & SON A/P 178379 11/20/2018 $50,311.25 DIAMOND HEALTHCARE CORP A/P 178380 11/20/2018 $448.00 E -MDS, INC A/P 178381 11/20/2018 $280.00 EAGLE FIRE & SAFETY INC A/P 178382 11/20/2018 $40,062.50 EMERGENCY STAFFING SOLUTIONS A/P 178383 11/20/2018 $1,888.50 EVOQUA WATER TECHNOLOGIES LLC A/P 178384 11/20/2018 $5,279.49 FISHER HEALTHCARE A/P 178385 11/20/2018 $648.42 GLAXOSMITHKLINE PHARMACUETICAL A/P 178386 11/20/2018 $342.50 GOLDENCREEK HEALTHCARE A/P 178387 11/20/2018 $18.08 GULF COAST PAPER COMPANY A/P 178388 11/20/2018 $652.58 HILL -ROM COMPANY, INC A/P 178389 11/20/2018 $8,333.33 HITACHI MEDICAL SYSTEMS A/P 178390 11/20/2018 $14,828.18 HUNTER PHARMACY SERVICES A/P 178391 11/20/2018 $437.31 IRON MOUNTAIN A/P 178392 11/20/2018 $726.32 1 & 1 HEALTH CARE SYSTEMS, INC A/P 178393 11/20/2018 $400.00 LAMAR COMPANIES A/P 178394 11/20/2018 $4,712.50 LAURELTREE ACCOUNTING A/P 178395 11/20/2018 $6.37 LOWE'S HOME CENTERS INC A/P 178396 11/20/2018 $4,748.89 MEDICAL DATA SYSTEMS, INC. A/P 178397 11/20/2018 $0.00 VOIDED A/P 178398 11/20/2018 $5,048.06 MEDLINE INDUSTRIES INC A/P 178399 11/20/2018 $2,609.64 MERCK SHARP & DOHME CORP A/P 178400 11/20/2018 $379.68 MERRYX-RAY/SOURCEONE HEALTHCA A/P 178401 11/20/2018 $212.40 MMC AUXILIARY GIFT SHOP A/P 178402 11/20/2018 $116,173.79 MMC EMPLOYEE BENEFIT PLAN A/P 178403 11/20/2018 $0.00 VOIDED A/P 178404 11/20/2018 $12,304.03 MORRIS & DICKSON CO, LLC A/P 178405 11/20/2018 $138.36 OWENS & MINOR A/P 178406 11/20/2018 $2,385.00 PABLO GARZA A/P 178407 11/20/2018 $77.86 PRECISION DYNAMICS CORP (PDC) A/P 178408 11/20/2018 $55.00 A/P 178409 11/20/2018 $45.47 RED HAWK FIRE AND SECURITY A/P 178410 11/20/2018 $2,124.00 REVCYCLE+,INC. A/P 178411 11/20/2018 $80.50 RITA DAVIS A/P 178412 11/20/2018 $2,172.50 ROBERTS, ODEFEY, WITTE & WALL A/P 178413 11/20/2018 $235.00 RX WASTE SYSTEMS LLC A/P 178414 11/20/2018 $889.47 SANOFI PASTEUR INC A/P 178415 11/20/2018 $231.29 SARA RUBIO A/P 178416 11/20/2018 $351.78 SHIRLEY KARNEI A/P 178417 11/20/2018 $3,015.00 SOLERA WEST HOUSTON A/P 178418 11/20/2018 $80.00 A/P 178419 11/20/2018 $351.13 STRYKER SUSTAINABILITY A/P 178420 11/20/2018 $730.36 THE US CONSULTING GROUP A/P 178421 11/20/2018 $1,562.77 UNIFIRST HOLDINGS INC A/P 178422 11/20/2018 $236.86 UNIFORM ADVANTAGE A/P 178423 11/20/2018 $605.89 UPS A/P 178424 11/20/2018 $2,200.00 US POSTAL SERVICE A/P 178425 11/20/2018 $4,855.61 WERFEN USA LLC A/P 178426 11/20/2018 $7,500.00 WILLIAM CROWLEY III, DO A/P 178427 11/20/2018 $2,428.92 FRONTIER A/P 178428 11/20/2018 $1,842.50 WALLER,LANSDEN, DORTCH & DAVIS -37- BANK CODE CHECK NUMBER DATE AMOUNT PAYEE A/P 178430 11/28/2018 $558.00 ABILITY NETWORK(SHIFTHOUND) A/P 178431 11/28/2018 $253.34 ACE HARDWARE 15521 A/P 178432 11/28/2018 $1,400.00 ACUTE CARE INC A/P 178433 11/28/2018 $2,174.41 AIRESPRING INC A/P 178434 11/28/2018 $3,386.58 AIRGAS USA, LLC- CENTRAL DIV A/P 178435 11/28/2018 $2,501.70 ALCON LABORATORIES, INC. A/P 178436 11/28/2018 $137.75 AMERICAN ACADEMY OF PEDIATRICS A/P 178437 11/28/2018 $13,535.04 ARTHREX, INC A/P 178438 11/28/2018 $90.86 AUTO PARTS & MACHINE CO. A/P 178439 11/28/2018 $2,962.25 AYA HEALTHCARE INC A/P 178440 11/28/2018 $3,876.78 BAXTER HEALTHCARE A/P 178441 11/28/2018 $572.32 BAYER HEALTHCARE A/P 178442 11/28/2018 $26,108.96 BECKMAN COULTER INC A/P 178443 11/28/2018 $1,812.61 BECTON, DICKINSON & CO (BD) A/P 178444 11/28/2018 $56.80 BOSART LOCK & KEY INC A/P 178445 11/28/2018 $1,146.19 CARDINAL HEALTH 414,LLC A/P 178446 11/28/2018 $108.22 CAROLINA LIQUID CHEMISTRIES A/P 178447 11/28/2018 $4,424.08 CDW GOVERNMENT, INC. A/P 178448 11/28/2018 $14,089.75 CLINICAL PATHOLOGY A/P 178449 11/28/2018 $249.00 COLA RESOURCES, INC. A/P 178450 11/28/2018 $83.65 CUSTOM MEDICAL SPECIALTIES A/P 178451 11/28/2018 $0.00 VOIDED A/P 178452 11/28/2018 $1,471.57 DEWITT POTH & SON A/P 178453 11/28/2018 $220.72 DIANE MOORE A/P 178454 11/28/2018 $143,025.85 DISCOVERY MEDICAL NETWORK INC A/P 178455 11/28/2018 $321.50 DRIESSEN WATER INC. (CULLIGAN) A/P 178456 11/28/2018 $552.40 DSHS CENTRAL LAB MC2004 A/P 178457 11/28/2018 $17,125.00 EMERGENCY STAFFING SOLUTIONS A/P 178458 11/28/2018 $155.20 ERBE USA INC SURGICAL SYSTEMS A/P 178459 11/28/2018 $16,485.00 EVIDENT A/P 178460 11/28/2018 $495.00 FASTHEALTH CORPORATION A/P 178461 11/28/2018 $19.65 FEDERAL EXPRESS CORP. A/P 178462 11/28/2018 $75.00 FIRST CLEARING A/P 178463 11/28/2018 $0.00 VOIDED A/P 178464 11/28/2018 $9,575.07 FISHER HEALTHCARE A/P 178465 11/28/2018 $530.00 FORT BEND SERVICES, INC A/P 178466 11/28/2018 $10,980.14 GE HEALTHCARE A/P 178467 11/28/2018 $7,763.62 GLAXOSMITHKLINE PHARMACUETICAL A/P 178468 11/28/2018 $445.13 GULF COAST PAPER COMPANY A/P 178469 11/28/2018 $255.00 HEALTHCARE CODING & CONSULTING A/P 178470 11/28/2018 $21,073.58 HEALTHCARE EQUIPMENT FINANCE A/P 178471 11/28/2018 $8,333.33 HITACHI MEDICAL SYSTEMS A/P 178472 11/28/2018 $23,568.90 ITA RESOURCES INC A/P 178473 11/28/2018 $43.00 KEY SURGICAL INC A/P 178474 11/28/2018 $917.50 LABCORP OF AMERICA HOLDINGS A/P 178475 11/28/2018 $247.04 LAERDAL MEDICAL CORPORATION A/P 178476 11/28/2018 $2,432.16 LUMINANT ENERGY COMPANY LLC A/P 178477 11/28/2018 $1,295.00 M G TRUST A/P 178478 11/28/2018 $45.44 MARKS PLUMBING PARTS A/P 178479 11/28/2018 $663.27 MARLIN BUSINESS BANK A/P 178480 11/28/2018 $64.10 MARTIN PRINTING CO A/P 178481 11/28/2018 $1,218.33 MARVELOUS GARDENS, INC Im BANKCODE CHECKNUMBER DATE AMOUNT PAYEE A/P 178482 11/28/2018 $1,432.03 MCKESSON MEDICAL SURGICAL INC A/P 178483 11/28/2018 $371.50 MEDIVATORS A/P 178484 11/28/2018 $0.00 VOIDED A/P 178485 11/28/2018 $0.00 VOIDED A/P 178486 11/28/2018 $0.00 VOIDED A/P 178487 11/28/2018 $0.00 VOIDED A/P 178488 11/28/2018 $11,221.68 MEDLINE INDUSTRIES INC A/P 178489 11/28/2018 $25.00 MEMORIAL MEDICAL CLINIC A/P 178490 11/28/2018 $183.75 MMC AUXILIARY GIFT SHOP A/P 178491 11/28/2018 $442.11 MOMENTUM RENTAL & SALES A/P 178492 11/28/2018 $0.00 VOIDED A/P 178493 11/28/2018 $0.00 VOIDED A/P 178494 11/28/2018 $13,659.05 MORRIS & DICKSON CO, LLC A/P 178495 11/28/2018 $1,255.88 OLYMPUS AMERICA INC A/P 178496 11/28/2018 $548.93 ORTHO CLINICAL DIAGNOSTICS A/P 178497 11/28/2018 $6.34 OWENS&MINOR A/P 178498 11/28/2018 $250.00 PALACIOS BEACON A/P 178499 11/28/2018 $2,627.00 PHILIPS HEALTHCARE A/P 178500 11/28/2018 $1,950.00 PRESS GANEY ASSOCIATES, INC. A/P 178501 11/28/2018 $138.00 PSYCHEMEDICS CORPORATION A/P 178502 11/28/2018 $224.00 RAPID PRINTING LLC A/P 178503 11/28/2018 $2,817.50 REALITY MEDICAL IMAGING OF TX A/P 178504 11/28/2018 $401.50 REED, CLAYMON, MEEKER & HARGET A/P 178505 11/28/2018 $12,005.71 SANOFI PASTEUR INC A/P 178506 11/28/2018 $751.58 SIEMENS MEDICAL SOLUTIONS INC A/P 178507 11/28/2018 $147.80 SMILE MAKERS A/P 178508 11/28/2018 $2,426.00 SOUTH TEXAS BLOOD & TISSUE CEN A/P 178509 11/28/2018 $385.00 STANFORD VACUUM SERVICE A/P 178510 11/28/2018 $2,023.97 STERICYCLE, INC A/P 178511 11/28/2018 $236.00 STERIS INSTRUMENT MANAGEMENT A/P 178512 11/28/2018 $9,286.39 STRYKER ENDOSCOPY A/P 178513 11/28/2018 $18,938.23 STUDER GROUP, LLC A/P 178514 11/28/2018 $5,699.00 T -SYSTEM, INC A/P 178515 11/28/2018 $3,853.00 TEXAS MUTUAL INSURANCE CO A/P 178516 11/28/2018 $201.76 THE STAYWELL COMPANY, LLC A/P 178517 11/28/2018 $960.00 THYSSENKRUPP ELEVATOR CORP A/P 178518 11/28/2018 $106.10 TRI -TECH FORENSICS, INC. A/P 178519 11/28/2018 $1,111.00 TRIZETTO PROVIDER SOLUTIONS A/P 178520 11/28/2018 $2,899.88 UNIFIRST HOLDINGS INC A/P 178521 11/28/2018 $46.88 UNIFORM ADVANTAGE A/P 178522 11/28/2018 $2,329.33 WAGEWORKS A/P 178523 11/28/2018 $34.87 WATERMARK GRAPHICS INC A/P 178524 11/28/2018 $2,487.28 WERFEN USA LLC A/P 178525 11/28/2018 $686.00 WISCONSIN STATE LABORATORY A/P 178526 11/27/2018 $300.00 ALISON KING A/P 178527 11/27/2018 $121.81 AMANDA KEY A/P 178528 11/27/2018 $25.00 FRANCES FRANCO A/P 178529 11/27/2018 $50.00 RAUSHANAH MONDAY A/P 178530 11/27/2018 $1,389.27 VANESSA GUARDIOLA A/P 178531 11/28/2018 $25.00 MEMORIAL MEDICAL CENTER ACCOUNTS PAYABLE TOTAL: $1,524,456.42 -39- BANK CODE CHECK NUMBER DATE AMOUNT PAYEE NHG 22 ICP 12171 11/08/2018 $4,166.67 MEMORIAL MEDICAL CENTER ICP 12172 11/08/2018 $266.54 ADU SPORTS MEDICINE CLINIC ICP 12173 11/08/2018 $63.88 CLINICAL PATHOLOGY LABS ICP 12174 11/08/2018 $54.41 ESS OF PORT LAVACA LLC ICP 12175 11/08/2018 $4,779.14 MEMORIAL MEDICAL CENTER ICP 12176 11/08/2018 $311.38 MEMORIAL MEDICAL CENTER ICP 12177 11/08/2018 $495.81 MEMORIAL MEDICAL CLINIC ICP 12178 11/08/2018 $121.95 REGIONAL EMPLOYEE ASSISTANCE ICP 12179 11/08/2018 $100.24 SINGLETON ASSOCIATES PA ICP 12180 11/08/2018 $80.00 VICTORIA KIDNEY DIALYSIS ICP TOTAL: $10,440.02 NHB 8 11/20/2018 $5,860.17 MMC OPERATING NHG 22 11/07/2018 $47,465.33 MMCOPERATING NHG 23 11/20/2018 $54,427.36 MMC OPERATING NHF 31 11/07/2018 $13,775.58 MMC OPERATING NHF 32 11/20/2018 $46,450.49 MMC OPERATING NHC 33 11/07/2018 $18,029.01 MMC OPERATING NHC 34 11/20/2018 $8,874.78 MMC OPERATING NHC 35 11/28/2018 $3,959.30 MMC OPERATING NHA 36- 11/07/2018 $19,860.36 MMCOPERATING NHA 37 11/20/2018 $81,592.88 MMC OPERATING NHA 38 11/28/2018 $20,448.62 MMCOPERATING NURSING FACILITY TOTAL: PR- 62170 11/02/2018 PR- 62171 11/02/2018 PR- 62172 11/02/2018 PR- 62173 11/16/2018 PR- 62174 11/16/2018 PR- 62175 11/16/2018 PR- 62176 11/16/2018 PR- 62177 11/16/2018 PR- 62178 11/16/2018 PR- 62179 11/16/2018 PR- 62180 11/30/2018 PR- 62181 11/30/2018 PR- 62182 11/30/2018 PR- 62183 11/30/2018 PR- 62184 11/30/2018 PR- 62185 11/30/2018 PR- 999999 11/02/2018 PAYROLLTOTAL: $320,743.88 $528.38 $1,210.25 $815.01 $238.34 $84.49 $0.00 $1,935.86 $527.41 $815.98 $1,222.05 $1,289.76 $275.19 $475.82 $718.24 $340.61 $420.08 $827,448.30 $838,345.77 COMBINED TOTAL: $2,693,986.09 PAY -P.10/12/18 10/25/18 PAY -P.10/12/18 10/25/18 PAY -P.10/12/18 10/25/18 PAY -P.10/26/18 11/08/18 PAY -P.10/26/18 11/08/18 PAY -P.10/26/18 11/08/18 PAY -P.10/26/18 11/08/18 PAY -P.10/26/18 11/08/18 PAY -P.10/26/18 11/08/18 PAY -P.10/26/18.11/08/18 PAY -P.11/09/18 11/22/18 PAY -P.11/09/18 11/22/18 PAY -P.11/09/18 11/22/18 PAY -P.11/09/18 11/22/18 PAY -P.11/09/18 11/22/18 PAY -P.11/09/18 11/22/18 MEMORIAL MEDICAL CENTER GROSS PAYROLL REPORT NOVEMBER 2018 PRTitle PRDeptName PRTotGross A -P / PAYROLL CLERK ACCOUNTING 3,760.52 STAFF ACCOUNTANT ACCOUNTING 4,140.15 CONTROLLER ACCOUNTING 7,500.00 ADM INIST ASSISTANT ADMINISTRATION 5,244.20 C.F.O. ADMINISTRATION 19,063.48 ASSIST ADMINISTRATOR ADMINISTRATION 13,708.00 C.E.O. ADMINISTRATION 27,360.38 CLINICAL IT SPCLST ADMINISTRATION -CLINICAL SERVIC 7,172.14 TRAUMA COORDINATOR ADMINISTRATION -CLINICAL SERVIC 6,451.83 ADMIN ASST TO AA-CNO ADMINISTRATION -CLINICAL SERVIC 3,602.46 BEHAV. HEALTH THERA BEHAVIORAL HEALTH 6,346.20 SPECIAL PROJECTS MGR BUSINESS DEVELOPMENT 4,530.64 ASST PURCHASE BUYER CENTRAL SUPPLY 3,205.87 PURCHASING SUPERVISR CENTRAL SUPPLY 6,487.20 COURIER -SUPPLY TECH CENTRAL SUPPLY 3,070.50 PRACT ADMINISTRATOR CLINIC FS 10,985.80 RECEPTIONIST CLINIC FS 2,747.30 OPERATOR CLINIC FS 2,614.49 RECEPTIONIST CLINIC FS 3,904.78 RECEPTIONIST CLINIC FS 2,384.59 INSURANCE CLERK CLINIC FS 3,491.50 OPERATOR CLINIC FS 3,459.49 RECEPTIONIST CLINIC FS 3,063.33 INSURANCE CLERK CLINIC FS 3,427.07 OPERATOR CLINIC FS 2,545.59 OFFICE MANAGER CLINIC FS 3,525.85 RECEPTIONIST CLINIC FS 3,425.57 RADIOLOGICAL TECH DIAGNOSTIC IMAGING 8,210.85 RADIOLOGICAL TECH DIAGNOSTIC IMAGING 768.00 RADIOLOGICAL TECH DIAGNOSTIC IMAGING 7,582.02 RECEPT/SECRETARY DIAGNOSTIC IMAGING 3,000.95 RADIOLOGY SUPERVISOR DIAGNOSTIC IMAGING 9,502.76 RADIOLOGY TECH DIAGNOSTIC IMAGING 1,698.30 RADIOLOGICAL TECH DIAGNOSTIC IMAGING 7,726.50 RADIOLOGICAL TECH DIAGNOSTIC IMAGING 6,467.66 NUCLEAR MED TECH DIAGNOSTIC IMAGING 9,580.00 RADIOLOGICAL TECH DIAGNOSTIC IMAGING 5,529.72 RADIOLOGYTECH DIAGNOSTIC IMAGING 206.50 RADIOLOGIC TECH DIAGNOSTIC IMAGING 2,374.22 RAD TECHNOLOGIST DIAGNOSTIC IMAGING 289.00 RADIOLOGICAL TECH DIAGNOSTIC IMAGING 1,952.50 RADIOLOGICAL TECH DIAGNOSTIC IMAGING 5,477.54 DIRECTOR DIAGNOSTIC IMAGING 8,071.95 DIRECTOR OF DIETARY DIETARY 6,371.14 FOOD SERVICE STAFF DIETARY 2,366.25 FOOD SERVICE STAFF DIETARY 2,221.50 FOOD SERVICE STAFF DIETARY 2,463.75 FOOD SERVICE STAFF DIETARY 2,047.26 FOOD SERVICE STAFF DIETARY 2,521.53 -41- FOOD SERVICE STAFF DIETARY 2,334.30 FOOD SERVICE STAFF DIETARY 3,027.00 FOOD SERVICE STAFF DIETARY 2,371.59 REGISTERED NURSE EMERGENCY ROOM 8,190.70 REGISTERED NURSE EMERGENCY ROOM 3,007.52 REGISTERED NURSE EMERGENCY ROOM 6,228.19 REGISTERED NURSE EMERGENCY ROOM 8,659.40 REGISTERED NURSE EMERGENCY ROOM 827.70 REGISTERED NURSE EMERGENCY ROOM 3,368.95 REGISTERED NURSE EMERGENCY ROOM 10,574.70 DIRECTOR EMERGENCY ROOM 9,976.16 REGISTERED NURSE EMERGENCY ROOM 5,896.06 REGISTERED NURSE EMERGENCY ROOM 7,734.75 REGISTERED NURSE EMERGENCY ROOM 82.50 REGISTERED NURSE EMERGENCY ROOM 6,810.95 REGISTERED NURSE EMERGENCY ROOM 5,895.91 REGISTERED NURSE EMERGENCY ROOM 1,052.91 REGISTERED NURSE EMERGENCY ROOM 4,059.84 REGISTERED NURSE EMERGENCY ROOM 5,814.78 REGISTERED NURSE EMERGENCY ROOM 921.19 REGISTERED NURSE EMERGENCY ROOM 7,800.52 REGISTERED NURSE EMERGENCY ROOM 51.38 REGISTERED NURSE EMERGENCY ROOM 4,417.96 ES AIDE ENVIRONMENTAL SERVICES 3,059.06 EVS AIDE/ FLOOR TECH ENVIRONMENTAL SERVICES 2,863.49 ESAIDE ENVIRONMENTAL SERVICES 2,831.65 EVS AIDE ENVIRONMENTAL SERVICES 2,926.67 ES AIDE ENVIRONMENTAL SERVICES 2,200.80 E.S. TEAM LEADER ENVIRONMENTAL SERVICES 3,792.79 EVS AIDE ENVIRONMENTAL SERVICES 2,394.85 ES AIDE ENVIRONMENTAL SERVICES 3,019.05 EVS AIDE ENVIRONMENTAL SERVICES 1,347.31 ES AIDE ENVIRONMENTAL SERVICES 2,938.01 FLOOR TECHNICIAN ENVIRONMENTAL SERVICES 2,867.09 ES AIDE ENVIRONMENTAL SERVICES 2,491.53 EVS AIDE ENVIRONMENTAL SERVICES 2,321.43 BIRTH REG/TRANSCRIP HEALTH INFORMATION MANAGEMENT 3,203.64 DISCHARGE ANALYST HEALTH INFORMATION MANAGEMENT 2,720.75 HIM SPECIALIST HEALTH INFORMATION MANAGEMENT 465.46 CODING SPECIALIST HEALTH INFORMATION MANAGEMENT 4,606.21 HIM SPECIALIST HEALTH INFORMATION MANAGEMENT 2,478.13 DIRECTOR OF HIM HEALTH INFORMATION MANAGEMENT 5,765.00 HR MANAGER HUMAN RESOURCES 3,861.81 REGISTERED NURSE ICU 7,036.75 REGISTERED NURSE ICU 6,824.48 REGISTERED NURSE ICU 5,485.74 REGISTERED NURSE ICU 5,731.72 REGISTERED NURSE ICU 7,147.04 REGISTERED NURSE ICU 5,252.03 REGISTERED NURSE ICU 829.94 REGISTERED NURSE ICU 6,126.05 REGISTERED NURSE ICU 9,258.78 REGISTERED NURSE ICU 395.75 REGISTERED NURSE ICU 6,145.00 -42- PT FIN COUN/CIHC COO INDIGENT CARE PROGRAM 3,832.00 FINANCIAL COUNSELOR INDIGENT CARE PROGRAM 3,495.05 IP/EH/RM NURSE INFECTION PREVENTION 8,675.34 I.T. DIRECTOR INFORMATION TECHNOLOGY 8,320.64 IT SYSTEM ANALYST INFORMATION TECHNOLOGY 5,943.77 IT SYSTEM ANALYST INFORMATION TECHNOLOGY 573.00 MLT LABORATORY 4,921.07 MEDICAL LAB TECH LABORATORY 6,756.26 LABASSISTANT LABORATORY 4,557.35 MEDICAL LAB TECH LABORATORY 6,142.00 MEDICAL TECHNOLOGIST LABORATORY 7,451.77 TECHNICAL SUPERVISOR LABORATORY 2,652.00 LAB DIRECTOR LABORATORY 7,826.80 LAB ASSISTANT LABORATORY 1,130.50 LAB ASSISTANT LABORATORY 1,037.44 MEDICAL TECHNICIAN LABORATORY 3,983.39 MEDICAL LAB TECH LABORATORY 5,033.98 GENERAL SUPERVISOR LABORATORY 6,133.62 LAB ASSISTANT LABORATORY 1,371.50 LAB ASSISTANT LABORATORY 3,078.60 LABORATORY ASSISTANT LABORATORY 558.25 LAB ASSISTANT LABORATORY 3,357.25 MEDICAL TECHNOLOGIST LABORATORY 581.25 MEDICAL LAB TECH LABORATORY 5,804.59 DEPARTMENTAL ASSIST MAINTENANCE 4,993.95 DIRECTOR MAINTENANCE 8,333.80 PLANT OPS SPECIALIST MAINTENANCE 4,357.75 PLANT OPS SPECIALIST MAINTENANCE 6,169.01 REGISTERED NURSE MED/SURG 1,201.50 REGISTERED NURSE MED/SURG 10,313.37 LICENSED VOCATIONAL MED/SURG 4,684.41 REGISTERED NURSE MED/SURG 7,785.76 DIRECTOR OF INPT SVC MED/SURG 11,837.82 LICENSED VOCATIONAL MED/SURG 3,837.78 CNA MED/SURG 3,549.55 REGISTERED NURSE MED/SURG 676.88 REGISTERED NURSE MED/SURG 5,920.16 LICENSED VOCATIONAL MED/SURG 566.00 REGISTERED NURSE MED/SURG 895.50 REGISTERED NURSE MED/SURG 1,380.25 REGISTERED NURSE MED/SURG 7,221.56 REGISTERED NURSE MED/SURG 8,225.39 CERTIFIED NURSE AIDE MED/SURG 2,446.03 REGISTERED NURSE MED/SURG 809.00 REGISTERED NURSE MED/SURG 3,374.13 CERTIFIED NURSE AIDE MED/SURG 2,318.26 REGISTERED NURSE MED/SURG 775.00 REGISTERED NURSE MED/SURG 6,674.18 CERTIFIED NURSE AIDE MED/SURG 2,705.40 LICENSED VOCATIONAL MED/SURG 49.00 REGISTERED NURSE MED/SURG 5,234.44 REGISTERED NURSE MED/SURG 6,197.81 LICENSED VOCATIONAL MED/SURG 3,964.12 CERTIFIED NURSE AIDE MED/SURG 4,433.83 -43- RN -OR SCRUB NURSE MED/SURG 538.00 REGISTERED NURSE MED/SURG 1,856.13 REGISTERED NURSE MED/SURG 5,568.52 REGISTERED NURSE MED/SURG 7,868.59 REGISTERED NURSE MED/SURG 914.25 REGISTERED NURSE MED/SURG 48.00 REGISTERED NURSE MED/SURG 4,373.54 REGISTERED NURSE MED/SURG 7,443.25 CERTIFIED NURSES AID MED/SURG 443.00 CNA MED/SURG 195.25 CERTIFIED NURSES AID MED/SURG 1,686.53 LICENSED VOCAT NURSE MED/SURG 3,238.25 LICENSED VOCATIONAL MEMORIAL MEDICAL CLINIC 3,565.30 REGISTERED NURSE MEMORIAL MEDICAL CLINIC 8,795.43 NURSE PRACTIONER MEMORIAL MEDICAL CLINIC 11,307.60 NURSE PRACTITIONER MEMORIAL MEDICAL CLINIC 11,307.62 LICENSED VOCATIONAL MEMORIAL MEDICAL CLINIC 769.25 NURSE SUPERVISOR MEMORIAL MEDICAL CLINIC 4,600.44 NURSE PRACTIONER MEMORIAL MEDICAL CLINIC 11,307.60 MEDICAL ASSISTANT MEMORIAL MEDICAL CLINIC 2,685.23 MEDICAL ASSISTANT MEMORIAL MEDICAL CLINIC 3,323.44 MEDICAL ASSISTANT MEMORIAL MEDICAL CLINIC 1,878.67 LICENSED VOCATIONAL MEMORIAL MEDICAL CLINIC 4,363.30 REFERRAL SPCLST / MA MEMORIAL MEDICAL CLINIC 2,602.78 LICENSED VOCATIONAL MEMORIAL MEDICAL CLINIC 1,079.50 MEDICAL ASSISTANT MEMORIAL MEDICAL CLINIC 3,656.68 OPERATOR MEMORIAL MEDICAL CLINIC 3,055.61 LICENSED VOCATIONAL MEMORIAL MEDICAL CLINIC 3,112.80 MEDICAL ASSISTANT MEMORIAL MEDICAL CLINIC 3,871.67 REFERRAL SPCLST / MA MEMORIAL MEDICAL CLINIC 3,920.18 MEDICAL ASSISTANT MEMORIAL MEDICAL CLINIC 2,347.01 MEDICAL ASSISTANT MEMORIAL MEDICAL CLINIC 3,270.78 LVN MEMORIAL MEDICAL CLINIC 5,232.79 NURSE PRACTITIONER MEMORIAL MEDICAL CLINIC 11,307.60 MEDICAL ASSISTANT MEMORIAL MEDICAL CLINIC 2,655.22 NURSE PRACTITIONER MEMORIAL MEDICAL CLINIC 12,269.22 MEDICAL ASSISTANT MEMORIAL MEDICAL CLINIC 3,461.73 RADIOLOGY TECH MMC CLINIC - DIAGNOSTIC IMAGIN 8,875.00 MEDICAL LAB TECH MMC CLINIC - LABORATORY 4,910.87 LICENSED VOCATIONAL OBSTETRICS 4,928.64 REGISTERED NURSE OBSTETRICS 4,613.94 REGISTERED NURSE OBSTETRICS 10,444.53 REGISTERED NURSE OBSTETRICS 7,237.36 REGISTERED NURSE OBSTETRICS 6,400.69 REGISTERED NURSE OBSTETRICS 718.72 REGISTERED NURSE OBSTETRICS 5,836.71 REGISTERED NURSE OBSTETRICS 6,229.42 REGISTERED NURSE OBSTETRICS 7,968.10 REGISTERED NURSE OBSTETRICS 8,687.38 REGISTERED NURSE OBSTETRICS 946.37 REGISTERED NURSE OBSTETRICS 5,492.90 REGISTERED NURSE OBSTETRICS 8,536.26 REGISTRATION CLERK PATIENT FINANCIAL SERVICES 2,340.18 SELF PAY CLERK PATIENT FINANCIAL SERVICES 2,849.17 BILLING CLERK REGISTRATION CLERK CASHIER -SWITCHBOARD INSUR COORDINATOR MEDICARE COORDINATOR REGISTRATION CLERK TEAM LEADER PFS DIRECTOR MEDICAID CLERK REGISTRATION CLERK REGISTRATION CLERK REGISTRATION CLERK REGISTRATION CLERK REGISTRATION CLERK REGISTRATION CLERK REGISTRATION CLERK REGISTRATION CLERK REG PHARM TECH SUPER LVN-CHG-CHART AUDITR REGIST PHARMACY TECH REG PHARMACY TECH OFFICE COORDINATOR PT ASSISTANT PT ASSISTANT DIRECTOR REHAB SERVC PHYSICAL THERAPIST PHYSICIAL THERAPIST TEAM LEAD PTA RECEPTIONIST CNO SECURITY SUPERVISOR SECURITY OFFICER SECURITY OFFICER SECURITY OFFICER OP/QA NURSE REGISTERED NURSE SURGERY MANAGER PRE -ADMISSION NURSE LICENSED VOCATIONAL RN -OR SCRUB NURSE 0 R TECH REGISTERED NURSE RN -PERIOPERATIVE CERTIFIED STERIL TEC ORAIDE REGISTERED NURSE PERIOPERATIVE RN PERIOPERATIVE RN CASE MANAGER/UR/DP PATIENT FINANCIAL SERVICES PATIENT FINANCIAL SERVICES PATIENT FINANCIAL SERVICES PATIENT FINANCIAL SERVICES PATIENT FINANCIAL SERVICES PATIENT FINANCIAL SERVICES PATIENT FINANCIAL SERVICES PATIENT FINANCIAL SERVICES PATIENT FINANCIAL SERVICES PATIENT FINANCIAL SERVICES PFS - REGISTRATION PFS - REGISTRATION PFS - REGISTRATION PFS - REGISTRATION PFS - REGISTRATION PFS - REGISTRATION PFS - REGISTRATION PHARMACY PHARMACY PHARMACY PHARMACY PHYSICAL THERAPY PHYSICAL THERAPY PHYSICAL THERAPY PHYSICAL THERAPY PHYSICAL THERAPY PHYSICAL THERAPY PHYSICAL THERAPY PHYSICAL THERAPY QUALITY ASSURANCE SECURITY SECURITY SECURITY SECURITY SPECIALTY CLINIC SURGERY SURGERY SURGERY SURGERY SURGERY SURGERY SURGERY SURGERY SURGERY SURGERY SURGERY SURGERY SURGERY REVIEW -45- 2,774.26 2,924.48 2,541.60 2,696.55 2,996.82 2,459.49 4,028.89 5,429.80 3,636.90 2,486.92 2,891.34 1,950.14 1,172.39 599.52 2,867.72 936.41 2,998.63 4,309.25 4,264.13 4,373.93 4,289.09 2,615.84 6,337.59 7,284.69 12,843.40 10,063.10 10,039.70 7,625.63 3,205.10 10,677.80 3,406.18 2,808.04 1,750.00 2,724.08 7,322.48 488.07 9,657.80 5,411.30 5,991.10 5,963.22 3,939.40 8,652.25 8,148.04 2,934.29 2,544.96 7,508.70 10,766.00 364.47 oIHS Issued 12/05/18 Source Description 01 Physician Services 02 Prescription Drugs O8 Rural Health Clinics 14 Mmc - Hospital Outpation 15 Mmc - Er Bills Source Totals Report Calhoun Indigent Health Care Batch Dates 12/01/2018 through 12/01/2018 For Source Group Indigent Health Care For Vendor: All Vendors Amount Billed 6,066.28 290.04 1,352.00 t 568.00 1,317.00 Expenditures 9,645.43 Reimb/Adjustments -52.11 Grand Total IM 9,593.32 COPAYS TOTAL Amount Paid 1,175.44 290.04 1,098.73 269.01 421.44 3,306.77 -52.11 3,254.66 4,166.67 7,421.33 <160.00> 7261.33 olHs Source Totals Report Issued 12/06/18 Calhoun Indigent Health Care Batch Dates 01/31/2018 through 12/01/2018 For Source Group Indigent Health Care For Vendor: All Vendors Source Description Amount Billed Amount Paid 01 Physician Services 62,743.62 9,463.97 01-2 Physician Services -Anesthesia 4,056.00 1,066.16 02 Prescription Drugs 2,929.53 2,644.39 05 Lab/X-Ray 331.00 79.39 08 Rural Health Clinics 15,067.60 13,321.82 11 Reimbursements 0.00 -2,792.98 13 Mmc - Inpatient Hospital 88,713.64 48,875.92 14 Mmc - Hospital Outpatient 188,477.24 61,200.41 15 Mmc - Er Bills 45,870.86 14,668.68 Expenditures 408,699.44 151,830.69 Reimb/Adjustments -509.95 -3,302.93 Grand Total 408,189.49 148,527.76 EXPENSES 45,833.37 194,361.13 COPAYS <2170.00> YEAR TO DATE TOTAL 192,191.13 —47— Calhoun County Indigent Care Patient Caseload 2018 Monthly Avg December 2017 Active 3 1 Approved Denied Removed Active Pending January 4 2 3 20 6 February 3 4 2 18 6 March 2 2 3 17 4 April 5 3 1 21 2 May 0 2 3 18 1 June 0 0 2 16 1 July 1 0 0 17 3 August 2 1 6 13 2 September 3 0 3 13 0 October 5 0 1 17 3 November 3 0 0 20 4 December YTD Monthly Avg December 2017 Active 3 1 2 17 3 18 Active Value Calhoun County Pharmacy Assistance Patient Caseload 2018 December YTD PATIENT SAVINGS $244,879.01 Monthly Avg 5 9 56 $22,261.73 0 December 2017 Active 32 Approved Refills Removed Active Value January 0 5 0 32 $5,006.00 February 5 9 0 37 $26,999.00 March 5 9 0 42 $18,184.00 April 0 6 0 42 $16,769.61 May 10 7 0 52 $16,330.00 June 3 6 0 55 $39,699.96 July 2 3 0 57 $14,029.00 August 8 6 0 63 $19,964.75 September 7 12 0 70 $18,233.94 October 8 13 0 78 $30,486.80 November 6 20 0 84 $39,175.95 December YTD PATIENT SAVINGS $244,879.01 Monthly Avg 5 9 56 $22,261.73 0 December 2017 Active 32 Calhoun County Commissioners' Court—January 02, 2019 S. PUBLIC HEARING (AGENDA ITEM NO. 5) Concerning petition to vacate lots 3 and 4, Block 1 of Outiot 1, Outblock 15 and Outlot 2, Outblock 16, Port O'Connor Townsite Outlots, Resubdivision No 1. (KF) Began: 10:09 A.M. Ended: 10:11 A.M. Terry Ruddick spoke on this matter. Page 3 of 16 December 27, 2018 Honorable Michael Pfeifer Calhoun County Judge 211 S. Ann Port Lavaca, TX 77979 RE: AGENDA ITEM Dear Judge Pfeifer: Kenneth W. Finster County Commissioner County of Calhoun Precinct 4 Please place the following item on the Commissioners' Court Agenda for January 2, 2019. • Public Hearing concerning petition to vacate Lots 3 and 4, Block 1 of Outlet 1, Outblock 15 and outlot 2, Outblock 16, Port O'Connor Townsite Outlots, Resubdivision No. 1. Sincerely, W. Kenneth W. Finster KWF/at P.O. Box 177 — Seadrift, Texas 77983 — email: kfinster@calhouncotx.org — (361) 785-3141 — Fax (361) 785-5602 December 20, 2018 Kenneth Finster Calhoun County Commissioner Precinct 4 P.O. Box 177 Seadrift, TX 77983 RE: Proposed re -subdivision on Harrison Street, Port O'Connor, TX (our job S22891) Dear Commissioner Finster, Please consider this letter as my request to have the following item placed on the January 2, 2019 Commissioner's Court agenda: Public Hearing concerning petition to vacate Lots 3 and 4, Block 1 of Outlot 1, Outblock 15 and Outlot 2, Outblock 16, Port O'Connor Townslte Outlots, Resubdivision No. 1. If I can provide additional information please do not hesitate to contact me. Sinc ely, Ter y T. dick, C.E. . 4 j R.P.L.S. 12661 Silicon Drive San Antonio, Texas 78249 TBPLS Firm No. 10193843 Phone: (210) 267-8654 Fax: (210) 267-8704 IN lip[ HII I m 3p ,�� $k ' Rqi Nil [6F - PIN jjia�lose 1� 10 1 N g Id el al I Be ffih �3�"se9s, @ 9 s �I 8 I3s3`$E Y I ' e k � (pour 3 m xt �arWh 3.CO,K9L 5 L `e a qE§&§w ,e- BE eg q w' tNN E..m 52`�Yk" `�N ��i�9��ORL_ e, r#J s V$ 8 a p yY Fm 3[ ayy a tlHE6Z9N6 e a ss o s �eE3agg i k" un un A� Uwxa�m s�maa ul� 3 Z Na � e Ya$E $� mn uruasm �xxn sxzwa ^^ k$o �jyy �� Anel ssnsn o+v�n ss Ia.E?:�oa��' 3 &3 SgSg�`E 9'S �osE6CV94' 3 g YL Ali 8" `z4afl ill � b !!S 4 i�yfr Z ' I I I Calhoun County Commissioners' Court—January 02, 2019 6. CONSIDER AND TAKE NECESSARY ACTION (AGENDA ITEM NO. 6) On request by Seadrift Volunteer Fire Department to apply for credit with 911 Rapid Response. (KF) RESULT: APPROVED [UNANIMOUS] MOVER: Vein Lyssy, Commissioner Pct 2 SECONDER: Gary Reese, Commissioner Pct 4 AYES: Judge Meyer, Commissioner Hall, Lyssy, Syma, Reese Page 4 of 16 December 27, 2018 Honorable Michael Pfeifer Calhoun County Judge 211 S. Ann Port Lavaca, TX 77979 RE: AGENDA ITEM Dear Judge Pfeifer: F Kenneth W. Finster C County Commissioner County of Calhoun Precinct 4 Please place the following item on the Commissioners' Court Agenda for January 2, 2019. • Consider and take necessary action to authorize Seadrift Volunteer Fire Department to apply for credit with 911 Rapid Response. Sincerely, 4UZf W J4;4� Kenneth W. Finster KWF/at P.O. Box 177 — Seadrift, Texas 77983 — email: kfmster@calhouncotx.org calhouncotx.org — (361) 785-3141 — Fax (361) 785-5602 a 11 Rapid Response CREDIT . ACCOUNT FORM Business Name Legal Name Address City State F Zip Country I Phone P.O. Req. d I)♦ Ship To Address Address City & State Zip Code +4 F-" INDIVIDUAL/ BUSINESS F- MUNICIPAL COMl?ANY1 EI�AR MENTAPPROVEGNRCHAS�ERS Name ITitle ( Phone I Name Title Phone Name I Title I Phone Name Title Phone Name I Title Phone Name Title I Phone ACCpUN7'S RAYABL,E CONTACT Name Phone Email F I- EMERGENCYSVCS F- WHOLESALE Name of Bank I---- Contact r Account Type I� Phone I Email (— - ' --- - Fax F CREDITREFERENCES'(Established credit equal #o'or greater than reguL'sted credit)Name of Firm F ContactF Credit Limit F-1Phone Email FaxName of Firm F ContactF Credit Limit Phone I Email I Fax OF INFORMATION ACCURACY AND RELEASE OF AUTHORITY TO VERIFY 1 herebycertifythat the Information In this credit application is correct. The Information induded in this credit"plkation is for use by 911 Rapid Response, Inc, in determining the amount and conditions of credit to be extended. I understand that 911 Rapid Response, Inc may also utilheothersourcesof credit which R wndders necessary in making this determination. Further, i herebyauthodrethe bank asduade references lined in this aednapplkation to releasebrionnation necessarytomist 911 Rapid Response, Inc in establishing a line of credit. Document Signature Field Title Date I — TERMS: Terms of 30 days are DUE UPON RECEIPT of Invoice. TERMS AND CONDITIONS: The Customer hereby agrees that all services, and payment therefor, are subject to the following terms and conditions: 1. Customer agrees that all services that may be provided by the Company to the Customer shall be governed by and subject to the Company's Service Conditions set forth by the company. Further, Customer agrees that, if any term or condition set forth in the Service Conditions conflicts with any term or condition set forth in any formal document issues by a company officer (including, but not limited to, any bill of lading, waybill, manifest or tariff; whether in physical or electronic format), then the term or condition set forth in the Service Conditions shall Prevail and govern. 2. Customer agrees that all amounts due for services provided by the Company are payable at 700 W. Main St. Annville, PA 17003 3. Customer agrees that all amounts due are not payable in installments, but are payable Net 30 days from date of invoice. Company reserves the right to demand payment of all outstanding and past due freight charges as a precondition for releasing any shipment(s) at destination. This right includes the right to demand payment upon delivery of any shipment(s) at any time. If any amount due is not paid within said period a delinquency charge of 5% per month or minimum of $15 per month of the delinquent balance shall be added to the amount due. 4. If customers invoice was time, date, stamped showing invoice was received, the above fees will apply at day 31. If invoice was not sent, invoice will be time, date, stamped at 31 days, and customer will have 30 days to make payment from that date. 5. In the event the account becomes delinquent and is tamed over for collection, Customer agrees to pay all costs of collection including reasonable attorney fees, accrued labor, and court costs. 6. Customer agrees to notify the Company by certified mail of any changes in ownership of Customer and further agrees to be liable for all losses incurred as a result of failure to comply with said notifications. 7. Customer outhorlm the Company and/or its credit agent(s) to investigate all credit history, bank references and any other Information required to process this application and as it deems necessary in the future. 8. Please specify how invoices should be delivered to the accounts payable contact _ Email _ Mail — Pace B Date: Title: Applicant Signature:. Type or Print Name: Please return completed form and documents to accountiog@91lrapidresponse.com or by fax at (717)473-7060 Calhoun County Commissioners' Court —January 02, 2019 7. Pass order Placing Officials on Salary Basis. (AGENDA ITEM NO. 7) RESULT: APPROVED [UNANIMOUS] MOVER: Vern Lyssy, Commissioner Pet 2 SECONDER: David Hall, Commissioner Pet 1 AYES: Judge Meyer, Commissioner Hall, Lyssy, Syma, Reese Page 5 of 16 CALHOUN COUNTY ORDER PLACING OFFICIALS ON SALARY BASIS On Motion by Commissioner Lyssy, seconded by Commissioner Hall, and carried, that the following order be entered: At a regular term of the Commissioners' Court in and for Calhoun County, Texas, held in the regular meeting of said Court in the County Courthouse in Port Lavaca, Texas, on the 2nd day of January 2019, with County Judge Richard Meyer presiding and Commissioners David Hall, Vern Lyssy, Clyde Syma and Gary Reese present and with Catherine Sullivan, Deputy County Clerk, in attendance, there having come on for hearing the matter of determining whether county and precinct officers shall be compensated on a salary basis for the calendar (fiscal) year 2019, it was ordered that all county and precinct officers and their deputies, clerks and assistants be compensated on a salary basis for the calendar (fiscal) year 2019, and the County Clerk is hereby ordered and directed to file a certified copy of this order with the State Comptroller of Public Accounts in Austin, Texas, on or before January 31, 2019. IT IS SO ORDERED this 2nd day of January 2019. ATTEST: Anna Goodman / . C j By: Catherine Sullivan, Deputy COMMISSIONERS' COURT OF CALHOUN COUNTY, TEXAS By: Richard Meyer, Calhoun Co fi udge Calhoun County Cornmissioners' Court—January 02, 2019 8. Appoint Judge Pro -Tem. (AGENDA ITEM NO. 8) Clyde Syma, Commissioner Pet 3 was appointed. RESULT: APPROVED [UNANIMOUS] MOVER: Vern Lyssy, Commissioner Pet 2 SECONDER: David Hall, Commissioner Pet 1 AYES: Judge Meyer, Commissioner Hall, Lyssy, Syma, Reese Page 6 of 16 JUDGE PRO -TEM 2005 Commissioner Galvan 2006 Commissioner Balajka 2007 Commissioner Finster 2008 Commissioner Fritsch 2009 Commissioner Lyssy 2010 Commissioner Galvan 2011 Commissioner Finster 2012 Commissioner Fritsch 2013 Commissioner Lyssy 2014 Commissioner Galvan 2015 Commissioner Finster 2016 Commissioner Fritsch 2016 Commissioner Lyssy (05-26-2016) 2017 Commissioner Finster 2018 Commissioner Hall 2019 Commissioner Syma Calhoun County Commissioners" Court— January 02, 2019 9. Appoint member to E911 Board. (AGENDA ITEM NO. 9) David Hall was appointed. RESULT: APPROVED [UNANIMOUS] MOVER: Vern Lyssy, Commissioner Pet 2 SECONDER: Gary Reese, Commissioner Pet 4 AYES: Judge Meyer, Commissioner Hall, Lyssy, Syma, Reese Page 7 of 16 ct E911 BOARD Dustin Jenkins Appointment expires January 2020 Vern Lyssy Appointment expires January 2019 Each January one appointment to E911 Board E911 BOARD Dustin Jenkins Appointment expires January 2020 David Hall Appointment expires January 2021 Each January one appointment to E911 Board Calhoun County Commissioners' Court—January 02, 2019 10. Appoint member to the Foreign Trade Zone. (AGENDA ITEM NO. 10) Gary Reese was appointed. RESULT: APPROVED [UNANIMOUS] MOVER: Vern Lyssy, Commissioner Pet 2 SECONDER: David Hall, Commissioner Pet 1 AYES: Judge Meyer, Commissioner Hall, Lyssy, Syma, Reese Page 8 of 16 CaIhOUn County Commissioners' Court—January 02, 2019 11. CONSIDER AND TAKE NECESSARY ACTION (AGENDA ITEM NO. 11) To establish pay for grand jurors and petit jurors for County, District, and Justice of the Peace Courts. (MP) RESULT: APPROVED [UNANIMOUS] MOVER: David Hall, Commissioner Pet 1 SECONDER: Vern Lyssy, Commissioner Pct 2 AYES: Judge Meyer, Commissioner Hall, Lyssy, Syma, Reese Page 9 of 16 Calhoun County Commissioners' Court — 7anuaxy 11, 2018 21, CONSIDER AND TAKE NECESSARY ACTION (AGENDA ITEM N0. 21) To establish pay For grand jurors and petit jurors for County, District and justice of the Peace Courts. (MP) R, SULT: APPROVED, [U7NANiMOUS1 MOVER: V. Lyssy, Commissioner.P.9t 2, SECONDER. Clyde Syma, Commissioner Pot 3 AYES: Judge Pfeif", Commissioner Hall, Lyssy, Syma, Finster Page 19 of 32 Susan Rlin From: Rhonda Knkana <rhondn,kokana(�cafhaunaolx orp> Ssntr Friday, January00, 2017 S:40AM To: $seen Rasy SubJootl JUROR PAY Importance: High Prospective Jurors / $5,00 chosen Jurors / First Day $72.00 & every day thereafter is $40 state reimburses the County $52.00 for every dyy wo payout $40 RNONPA S. KOKi~NA CoV"N Trea3a�rer Caldnotu� C&wA4V AKw4vIt 20z S. AwwSf; 5W;fvA Pari' Lavaca,, T¢hcas, 77979 ($ln2)553-Q6�.9 offiro. I Calhoun County Commissioners' Court—January 02, 2019 12. CONSIDER AND TAKE NECESSARY ACTION (AGENDA ITEM NO. 12) To change the date of the third meeting in February from February 20, 2019 to February 18, 2019 due to a schedule conflict. (MP) RESULT: APPROVED [UNANIMOUS] MOVER: Gary Reese, Commissioner Pet 4 SECONDER: Vern Lyssy, Commissioner Pet 2 AYES: Judge Meyer, Commissioner Hall, Lyssy, Syma, Reese Page 10 of 16 (31 00 0 N F- F F- F- F- D Z) 0 0 0 u u O 0 0 0 N F- F F- D Z) 0 0 0 u u Calhoun County Commissioners' Court—January 02, 2019 13. ACCEPT REPORTS OF THE FOLLOWING COUNTY OFFICES: (AGENDA ITEM NO. 13) i. Calhoun Tax Assessor/ Collector ii. County Treasurer iii. County Sheriff iv. District Clerk — Nov 2018 v. County Clerk vi. Justices of Peace vii. County Auditor viii. Floodplain Administration ix. Extension Service x. Adult Detention Center SHP Medical RESULT: APPROVED [UNANIMOUS] MOVER: Vern Lyssy, Commissioner Pet 2 SECONDER: David Hall, Commissioner Pet 1 AYES: Judge Meyer, Commissioner Hall, Lyssy, Syma, Reese Page 11 of 16 SECOND AMENDED NOVEMBER 2018 MONTHLY REPORT the amount torney General. *Treasurer Receipt Numbers F2018NOV010, 015,038 MONTHLY REPORT OF COLLECTIONS AND DISTRIBUTIONS 12/21/2018 COURT NAME: DISTRICT CLERK MONTH OF REPORT: NOVEMBER YEAR OF REPORT: 2018 ACCOUNT NUMBER ACCOUNT NAME DEBIT CREDIT 1000-001-44190 SHERIFF'S SERVICE FEES $1,210.85 1000-001-44140 JURY FEES $40.00 1000-001-44045 RESTITUTION FEE $0.00 1000-001-44020 DISTRICT ATTORNEY FEES $0.00 1000-001-49010 REBATES -PREVIOUS EXPENSE $4.61 1000-001-49030 REBATES -ATTORNEY'S FEES $306.81 1000-001-44058 DISTRICT CLERK ELECTRONIC FILING FEES $244.28 1000-001-43049 STATE REIMB- TITLE IV -D COURT COSTS $0.00 DISTRICT CLERK FEES CERTIFIED COPIES $598.00 CRIMINAL COURT $11.70 CIVIL COURT $1,629.72 STENOGRAPHER $205.09 CIV FEES DIFF $0.00 1000-001-44050 DISTRICT CLERK FEES $2,444.51 1000-999-10010 CASH - AVAILABLE $4,251.06 2706-001-44055 FAMILY PROTECTION FEE $15.00 2706-999-10010 CASH - AVAILABLE $15.00 2740-001-45055 FINES - DISTRICT COURT $28.40 2740-999-10010 CASH - AVAILABLE $28.40 2620-001-44055 APPELLATE JUDICIAL SYSTEM $68.37 2620-999-10010 CASH -AVAILABLE $68.37 2670-001-44055 COURTHOUSE SECURITY $84.78 2670-999-10010 CASH -AVAILABLE $84.78 2673-001-44055 CRT RECS PRESERVATION FUND- CO $166.73 2673-999-10010 CASH -AVAILABLE $166.73 2739-001-44055 RECORD MGMT/PRSV FUND - COUNTY $40.20 2739-999-10010 CASH - AVAILABLE $40.20 2737-001-44055 RECORD MGMT/PRSV FUND -DIST CLRK $174.12 2737-999-10010 CASH -AVAILABLE $174.12 2731-001-44055 LAW LIBRARY $478.53 2731-999-10010 CASH - AVAILABLE $478.53 2663-001-44050 CO & DIST CRT TECHNOLOGY FUND $1.02 2663-999-10010 CASH - AVAILABL $1.02 7040-999-20740 BREATH ALCOHOL TESTING - STATE $0.00 7040-999-10010 CASH -AVAILABLE $0.00 2667-001-44055 CO CHILD ABUSE PREVENTION FUND $1.37 2667-999-10010 CASH -AVAILABLE $1.37 7502-999-20740 JUDICIAL & COURT PERSONNEL TRAINING FUND -STATE $95.00 7502-999-10010 CASH-AVAILABE $95.00 7383-999-20610 DNA TESTING FEE -County $0.31 7383-999-20740 DNA TESTING FEE -STATE $2.82 7383-999-10010 CASH - AVAILABLE $3.13 7405-999-20610 EMS TRAUMA FUND - COUNTY $2.44 7405-999-20740 EMS TRAUMA FUND - STATE $21.96 7405-999-10010 CASH - AVAILABLE $24.40 7070-999-20610 CONSOL, COURT COSTS - COUNTY $25.34 7070-999-20740 CONSOL. COURT COSTS - STATE $228.04 7070-999-10010 CASH - AVAILABLE $253.38 2698-001-44030-010 DRUG CRT PROG FEE - COUNTY (PROGRAM) $8.58 2698-999-10010-010 CASH - AVAILABLE $8.58 7390-999-20610-999 DRUG COURT FROG FEE - COUNTY (SVC FEE) $1.72 7390-999-20740-999 DRUG COURT PROG FEE - STATE $6.85 7390-999-10010-999 CASH -AVAILABLE $8.57 7865-999-20610-999 CRIM - SUPP OF IND LEGAL SVCS - COUNTY $0.35 7865-999-20740-999 CRIM - SUPP OF IND LEGAL SVCS - STATE $3.18 7865-999-10010-999 CASH - AVAILABLE $3.53 7950-999-20610 TIME PAYMENT - COUNTY $12.93 7950-999-20740 TIME PAYMENT - STATE $12.92 7950-999-10010 CASH -AVAILABLE $25.85 7505-999-20610 JUDICIAL SUPPORT-CRIM - COUNTY $1.63 7505-999-20740 JUDICIAL SUPPORT-CRIM - STATE $9.22 7505-999-10010 CASH -AVAILABLE $10.85 7505-999-20740-010 JUDICIAL SALARIES -CIVIL- STATE(42) $700.23 7505-999-10010-010 CASH AVAILABLE $700.23 2740-001-45050 BOND FORFEITURES $0.00 2740-999-10010 CASH - AVAILABLE $0.00 2729-001-44034 PRE-TRIAL DIVERSION FUND $0.00 2729-999-10010 CASH -AVAILABLE $0.00 7857-999-20610 JURY REIMBURSEMENT FUND- COUNTY $0.74 7857-999-20740 JURY REIMBURSEMENT FUND- STATE $6.61 7857-999-10010 CASH -AVAILABLE $7.35 7403-999-22888 DIST CRT - ELECTRONIC FILING FEE - CIVIL $620.14 7403-999-22991 DIST CRT - ELECTRONIC FILING FEE - CRIMINAL $0.33 CASH - AVAILABLE $620.47 7855-999-20784-010 DIST CRT - DIVORCE & FAMILY LAW - STATE $111.83 7855-999-20657-010 DIST CRT - DIVORCE & FAMILY LAW - COUNTY $3.50 7855-999-20792-010 DIST CRT -OTHER THAN DIVORCE/FAMILY LAW - STATE $48.50 7855-999-20658-010 DIST CRT -OTHER THAN DIVORCE/FAMILY LAW - COUNTY $1.50 7855-999-20740-010 DIST CRT - OTHER CIVIL PROCEEDINGS - STATE $760.00 7855-999-20610-010 DIST CRT - OTHER CIVIL PROCEEDINGS - COUNTY $40.00 7855-999-10010-010 CASH -AVAILABLE $965.33 TOTAL (Distrib Req to Oper Acct) $8,036.25 $8,036.25 DUE TO OTHERS (Distrib Req(s) attached) ATTORNEY GENERAL (RESTITUTION) 0.00 OUT -OF -COUNTY SERVICE FEES 340.00 REFUND OF OVERPAYMENTS 0.00 DUE TO OTHERS 0.00 TOTAL DUE TO OTHERS $340.00 REPORT TOTAL - ALL FUNDS 8,376.25 PLUS AMT OF RETURNED CKS 0.00 LESS: TOTAL TREASURER'S RECEIPTS (8,376.25) Revised 03/18/14 OVER / (SHORT) $0.00 DISTRICT COURT STATE COURT COSTS REPORT SECTION I: REPORT FOR OFFENSES COMMITTED 01/01/04 - FORWARD 09/01/01 -12131/03 09/01/99 - 08/31/01 09/01/97 - 08/31/99 09/01/95 - 08/31/97 09/01/91 - 08/31/95 BAIL BONDS FEES DNA TESTING FEES EMS TRAUMA FUND JUV. PROB. DIVERSION FEES JURY REIMBURSEMENT FEE STATE TRAFFIC FEES DRUG CRT PROG FEE SECTION II: AS APPLICABLE STATE POLICE OFFICER FEES FAILURE TO APPEAR/PAY FEES JUD. FUND -CONST. CO. CRT. JUD. FUND -STATUTORY CO. CRT. MOTOR CARRIER WEIGHT VIOLATIONS TIME PAYMENT FEE DRIVING RECORD FEE JUDICIAL SUPPORT FEES ELECTRONIC FILING FEE - CR TOTAL STATE COURT COSTS CIVIL FEES REPORT BIRTH CERTIFICATE FEES MARRIAGE LICENSE FEES DECL. OF INFORMAL MARRIAGE ELECTRONIC FILING FEE - CV NONDISCLOSURE FEES JUROR DONATIONS JUSTICE CRT. INDIG FILLING FEES STAT PROB CRT INDIG FILING FEES STAT PROB CRT JUDIC FILING FEES STAT CNTY CRT INDIG FILING FEES STAT CNTY CRT JUDIC FILING FEES STAT CNTY CRT -JUDICIAL SUPPORT CONST CNTY CRT INDIG FILING FEES CNST CNTY CRT JUDIC FILING FEES DIST CRT DIV & FAMILY LAW Y_, : 14 DIST CRT OTHER THAN DIV/FAM LAW 3 DIST CRT OTHER CIVIL FILINGS --_-- 41' FAMILY PROTECTION FEE JUDICIAL SUPPORT FEE L_=8 JUDICIAL & COURT PERSONNEL TRANING FEE 38.' TOTAL CIVIL FEES REPORT NOVEMBER 2018 NOVEMBER COLLECTED COUNTY STATE 0.02 0.18 1.15 10.37 3.13 12.92 3.13 24.40 2.44 21.96 $7.35 0.74 6.61 $17.15 $10.30 6.85 $25.85 12.93 12.92 $10.85 1.63 9.22 $0.33 $0.33 $342.44 $ 53.38 $ 289.06 NOVEMBER COLLECTED COUNTY STATE $620.14 $620.14 $115.33 3.50 111.83 $50.00 1.50 48.50 $800.00 40.00 760.00 $700.23 $700.23 $95.00 - $95.00 $ 2,380.70 $ 45.00 $ 2,335.70 TOTAL BOTH REPORTS $ 2,723.14 $ 98.38 $ 2,624.76 MONTHLYREPORT COURT NAME: DISTRICT CLERK MONTH OF REPORT: NOVEMBER YEAR OF REPORT: 2018 CIVIL FEES District Clerk's Fees: Certified Copies 598.00 Civil Court 1,629.72 Stenographer 205.09 2,432.81 Courthouse Security Fund: 83.36 Civil Filings: 965.33 Sheriffs Fees: Civil Court 1,179.70 Civil Jury 0.00 1,179.70 Jury Fees: 40.00 Law Library Fees: 478.53 Appellate Judicial System Fund (AJSF): 68.37 Judicial Salaries Fund (JSF): 700.23 Family Protection Fund (FPA): 15.00 Court Records Preservation Fund 166.73 Judicial & Court Personeel Training Fee (JCPT) 95.00 Records Management Fees: District Clerk 173.36 County 33.36 206.72 Bond Forfeitures 0.00 Adoption/Bureau of Vital Statistics Fee 0.00 State Electronic Filing Fee - CV 620.14 County Electronic Filing Fee - CV 24428 Civil Fees: 7,296.20 CRIMINAL FEES Consolidated Court Costs: Criminal Justice Planning (CJPF) 0.00 Crime Victims Camp (CVCF) 1.53 JCPT 0.06 CJPT 0.00 Crime Stoppers (CS) 0.11 Fugitive Apprehension (FA) 0.17 Consol Crt Costs (CCC) 251.48 Juv Crime Prevention (JCD) 0.01 CMI 0.02 253.38 Clerk's Fees: 11.70 Records Management: 7.60 Restitution Fee: 0.00 Bond Forfeitures: 0.00 Pretrial Diversion Fund 0.00 Law Enforcement Edo Fund (LEOS): 0.00 Breath Alcohol Testing (BAT): 0.00 Child Abuse Prevention Fund 1.37 Drug Court Program Fee 17.15 DNA Testing 3.13 EMS Trauma Fund 24.40 Time Payment Fee: 25.85 State Electronic Filing Fee - CR: 0.33 County Electronic Filing Fee - CR: 0.00 Reimurse Crt Appt Atty Fees: 306.81 Jury Reimbursement Fee (JRF): 7.35 Judicial Support Fund (JSF): 10.85 Fines: 28.40 Courthouse Security: 1.42 Sheriffs Fees: 31.15 District Attorney Fees: 0.00 Criminal Fees: $730.89 Due to Others: $340.00 TOTAL COLLECTED: $8,367.09 Less Returned checks 1100 CALHOUN DISTRIBUTION COUNTY REQUEST 201 West Austin DR# 420 A 43456 PAYEE Name: Calhoun County Oper. Acct. Address: City: State: Zip: Phone: PAYOR Official: Anna Kabela Title: District Clerk ACCOUNT NUMBER':-'' - GEStRIPTI{!N ,..' AMOUNT 7340-999-20759-999 District Clerk Monthly Collections - Distribution $8,036.25 NOVEMBER 2018 V# 967 Signature of Official Date TOTAL 8,036.25 CALHOUN DISTRIBUTION COUNTY REQUEST 201 West Austin DR# 420 A 43456 PAYEE Name: Calhoun County Oper. Acct. Address: City: State: Zip: Phone: PAYOR Official: Anna Kabela Title: District Clerk MOWT FNIMBER - ; ^^"DESCR1t3130N AMOUNT ; 7340-999-20759-999 District Clerk Monthly Collections - Distribution $8,036.25 NOVEMBER 2018 V# 967 Signature of Official Date TOTAL 8,036.25 Calhoun County Commissioners' Court --January 02, 2019 14. CONSIDER AND TAKE NECESSARY ACTION (AGENDA ITEM NO. 14) To declare certain items of County property in the District Clerk's office as surplus/salvage and remove from inventory. (see list) (MP) RESULT: APPROVED [UNANIMOUS] MOVER: Clyde Syma, Commissioner Pet 3 SECONDER: Gary Reese, Commissioner Pet 4 AYES: Judge Meyer, Commissioner Hall, Lyssy, Syma, Reese Page 12 of 16 /L Calhoun County, Texas SURPLUSISALVAGE DECLARATION REQUEST FORM (2018) Department Name: District clerk's Office Requested By: Inventory Number Descrintion Anna Kabela Reason for Surplus/Salvage Serial No. Declaration tri -pod with screen no longer needed oscillating floor fan no longer needed metal easel with tablet no longer needed Epson Workforce WF -364C printer no longer needed 6' table with folding legs no longer needed plastic folding table no longer needed dry -erase board no longer needed Acer computer monitor no J-Qnger needed space heater no longer needed 3 -unit plast c storage bin no longer needed 2 metal computer sta ds no longer needed 3 metal wall dividers no longer needed metal podium no longer needed Calhoun County Commissioners' Court — January 02, 2019 15. CONSIDER AND TAKE NECESSARY ACTION (AGENDA ITEM NO. 15) To transfer certain items of County property in the District Clerk's office to other County offices. (see list) (MP) RESULT: APPROVED [UNANIMOUS] MOVER: Vein Lyssy, Commissioner Pet 2 SECONDER: David Hall, Commissioner Pet 1 AYES: Judge Meyer, Commissioner Hall, Lyssy, Syma, Reese Page 13 of 16 Calhoun County, Texas DEPARTMENTAL INVENTORY TRANSFER REQUEST FORM (2018) Inventory Number Description Requested By: Anna Kabela, Calhoun County District Clerk Serial No. Transfer From/To Department 2 3 -tier metal rolling cits from District Clerk to Elections 3 -tier ste ladder from District Clerk to Elections 4 sections of metal shelvi from District Clerk to Elections 2 sections of metal shelvi from District Clerk to Jail oscillatingfloor fan from District clerk to Auditor Calhoun County Commissioners' Court—January 02, 2019 16. CONSIDER AND TAKE NECESSARY ACTION (AGENDA ITEM NO. 16) On any necessary budget adjustments. N/A Page 14 of 16 Calhoun County Commissioners' Court—January 02, 2019 17. Approval of bills and payroll. MMC Bills RESULT: APPROVED [UNANIMOUS] MOVER: David Hall, Commissioner Pet 1 SECONDER: Vein Lyssy, Commissioner Pet 2 AYES: Judge Meyer, Commissioner Hall, Lyssy, Syma, Reese County Bills RESULT: APPROVED [UNANIMOUS] MOVER: David Hall, Commissioner Pet 1 SECONDER: Vern Lyssy, Commissioner Pet 2 AYES: Judge Meyer, Commissioner Hall, Lyssy, Syma, Reese Payroll RESULT: APPROVED [UNANIMOUS] MOVER: David Hall, Commissioner Pet 1 SECONDER: Vern Lyssy, Commissioner Pet 2 AYES: Judge Meyer, Commissioner Hall, Lyssy, Syma, Reese Page 15 of 16 MEMORIAL MEDICAL CENTER COMMISSIONERS COURT APPROVAL LIST FOR -- January 02, 2019 TOTALS TO BE APPROVED - TRANSFERRED FROM ATTACHED PAGES TOTAL PAYABLES, PAYROLL AND ELECTRONIC BANK PAYMENTS $ 104,242.40 TOTAL TRANSFERSBETWEEN FUNDS $ TOTAL NURSING HOME UPLIEXPENSES $ 1,554,174.74 TOTAL INTER -GOVERNMENT TRANSFERS $ MEMORIAL MEDICAL CENTER COMMISSIONERS COURT APPROVAL LIST FOR ---January 02, 2019 PAYABLES AND PAYROLL 12/28/2018 McKesson -3406 Prescription Expense 12/28/2018 MMC Employee Benefit Plan -Insurance 12/28/2018 Emergency Staffing Solutions -ER Staffing 12/28/2018 Amerisource Bergen -34013 Prescription Expense 12/28/2018 Pablo Garza -Contract Employee 12/28/2018 Texas Mutal Insurance Co -Insurance 12/28/2018 Shirley Karnei-Contract Employee 12/28/2018 MMC Auxiliary Gift Shop 12/31/2018 Payroll Liabilities (Payroll Taxes) 12/31/2018 Supplemental Payroll Electronic Bank Payments Prosperity Electronics Payments 12/26/2018 Harland Clarke -Checks for Nursing Home Facilities 12/21-12/27/18 Pay Plus -Patient Claims Processing Fee 2,078.72 24,562.90 40,062.50 4,438.90 2,100.00 5,688.00 278.96 466.78 2,188.68 22,201.60 137.10 38.26 TOTAL TRANSFERS BETWEEN FUNDS $ NURSING HOME UPL EXPENSES 12/28/2018 Nursing Home UPI 12/28/2018 Nursinq Home UPI 1,408,267.89 145,906.85 TOTAL INTER -GOVERNMENT TRANSFERS $ GRAND TOTAL DISBURSEMENTS APPROVED January 02, 2019 $ 1,658,417.14' V E 110 a,c 2, 1€l, MEMORIAL MEDICAL CENTER 0 15:08 AP Open Invoice List ap_ p P o en_invoice.tem late cmjjou�-1 COUNTY, TP, XjW Page 1 of 1 No -Pay Net 0.00 24,562.90 No -Pay Net 0.00 24,562,90 Net' i 24,562 90 �I i i file:///C:/Usersleclevengerlepsi/memmed.cpsinet.com/u82227/data_5/tmp_cw5report29... 12/27/2018 Dates Through: Vendor# Vendor Name Class Pay Code / 10810 MMC EMPLOYEE BENEFIT PLAN V/ Invoice# Comment Tran Dt Inv Dt Due Dt Check DPay Gross Discount 122118 12/27/2012/21/2012/21/20 24,562.90 0.00 INSURANCE Vendor Total: Number Name Gross Discount 10810 MMC EMPLOYEE BENEFIT PLAN 24,562.90 0.00 Report Summary Grand Totals: Gross Discount No -Pay 24,562.90 0.00 0.00 cmjjou�-1 COUNTY, TP, XjW Page 1 of 1 No -Pay Net 0.00 24,562.90 No -Pay Net 0.00 24,562,90 Net' i 24,562 90 �I i i file:///C:/Usersleclevengerlepsi/memmed.cpsinet.com/u82227/data_5/tmp_cw5report29... 12/27/2018 ATI 11,:10V3� o; a1�,7 2 8 2018 2:ate7i47'�2,§:1u�F't'a55t. 6UA1,4.1ODN k'<Dtiltd'9"Cy'k�t+„kr 1 Page 1 of 1 0 ap_open_invoice.te mplate Discount 0.00 No -Pay 0.00 Net 40,062.50 MEMORIAL MEDICAL CENTER /251 - No -Pay Net AP Open Invoice List 15:09 40,062.50 rz1r y' a 3€1x�`,r F}1$.'tz>a- Dates Through: Vendor# Vendor Name Class Pay Code 11284 EMERGENCY STAFFING SOLUTIONS 40,062.50sry Invoice#Comment Tran Dt Inv Dt Due Dt Check DPay Gross / 37296 ✓ 12/27/20 12/31/20 12/31/20 40,062.50 ER STAFFING Vendor Total; Number Name Gross 11284 EMERGENCY STAFFING SOLUTIONS 40,062.50 Report Summary Grand Totals: Gross Discount 40,062.50 0.00 ATI 11,:10V3� o; a1�,7 2 8 2018 2:ate7i47'�2,§:1u�F't'a55t. 6UA1,4.1ODN k'<Dtiltd'9"Cy'k�t+„kr 1 Page 1 of 1 0 ap_open_invoice.te mplate Discount 0.00 No -Pay 0.00 Net 40,062.50 Discount No -Pay Net 0.00 0.00 40,062.50 No -Pay Net: 0.00 ( 40,062.50sry file:///C:/Users/celevenger/cpsihnemmed.cpsinet.com/u82227/data_5/tmp_cw5report27... 12/27/2018 Report Summary Grand Totals: Gross Discount 2,100.00 0.00 d)t'1 S A18 4:ebaJPF'f'i ,!?:S)l.;af.'f'd3L°. 4�AJ.1i:'!T�)P'd C,{➢d1 MAY,'!?•�1'tSi.# Page 1 of 1 0 ap_open_invoice.template Discount No -Pay 12%g`%p18 F MEMORIAL MEDICAL CENTER 0.00 AP Open Invoice List a II12i,fjr a 11 q' Dates Through: Vendor# Vendor Name Class Pay Code 11069 PABLO GARZA y% 2,100.00 Invoice# Comment Tran Dt Inv Dt Due Dt Check D* Pay Gross 122418 12/27/2012/24/2012/24120 2,100.00 CONTRACT EMPLOYEE Vendor Totals Number Name Gross 11069 PABLO GARZA 2,100.00 Report Summary Grand Totals: Gross Discount 2,100.00 0.00 d)t'1 S A18 4:ebaJPF'f'i ,!?:S)l.;af.'f'd3L°. 4�AJ.1i:'!T�)P'd C,{➢d1 MAY,'!?•�1'tSi.# Page 1 of 1 0 ap_open_invoice.template Discount No -Pay Net 0.00 0.00 2,100.00 y/ Discount No -Pay Net 0.00 0.00 2,100.00 No -Pay NOS 0.00 2,10060 r � file:///C:/Users/eclevenger/cpsi/memmed.cpsinet.com/u82227/data_5/tmp_cw5report5 l ... 12/27/2018 O COYAN a u [ W)t,j,1)V AA�t0UN 6 OUN F?:,'it,xA2 Page 1 of I 0 ap_open_i nvo Ice.template Discount No -Pay Net / 0.00 7, � >,10 MEMORIAL MEDICAL CENTER 12i2�118 AP Open Invoice List Net Dates Through: Vendor# Vendor Name // Class Pay Code T2204 TEXAS MUTUAL INSURANCE CO e/ W Invoice# Co/tnment Tran Dt Inv Dt Due Dt Check DPay Gross 1000641042 a/ 12127/2012/16/2001/07/20 5,688.00 INSURANCE Vendor Total: Number Name Gross T2204 TEXAS MUTUAL INSURANCE CO 5,688.00 Repoli Summary Grand Totals: Gross Discount 5,688.00 0.00 O COYAN a u [ W)t,j,1)V AA�t0UN 6 OUN F?:,'it,xA2 Page 1 of I 0 ap_open_i nvo Ice.template Discount No -Pay Net / 0.00 0.00 5,688.00 y/ Discount No -Pay Net 0.00 0.00 5,688.00 No -Pay Net 0.00 d' 5,688.00;�t'A.. ✓t1 -°L { 9 Gf file:///C:/Users/cclevenger/cpsi/memmed.cpsinet.com/u82227/data_5/tmp_cw5report59... 12/27/2018 a' No -Pay Net MEMORIAL MEDICAL CENTER 12/27/2018 , e d;d 9 #s`:`: AP Open Invoice List Discount Dates Through: Vendor# Vendor Name Class Pay Code K0536 SHIRLEY KARNEI 0.00 Invoice# Comment Tran Dt Inv Dt Due Dt Check DPay Gross 122518 12/27/2012/25/2012/25/20 278.96 CONTRACT EMPLOYEE Vendor Total: Number Name Gross K0536 SHIRLEY KARNEI 278.96 Report Summary Grand Totals: Gross Discount 278.96 0.00 A,-,Q'1tfJV A,U W14 0E."..a232018 t A1,YAW3N C(38 NTY,',PEXA..`-) Page 1 of 1 0 ap_open_i nvoice.template Discount No -Pay Net 0.00 0.00 278.96 Discount No -Pay Net 0.00 0.00 278.96 No -Pay Net 0.00 � 278.96 file:///C:/Users/eclevenger/cpsi/memmed.cpsinet.com/u82227/data_5/tmp_cw5report84... 12/27/2018 pg (?'r'tcW CS SS Gt-)u,C,4TY AW)-fTO c Page 1 of 1 0 ap_open_invoice.template Discount No -Pay Net '1 1 01ES MEMORIAL MEDICAL CENTER 350.17 ✓/ AP Open Invoice List 15:1 Dates Through: 116.61 ✓ Vendor# Vendor Name Class Pay Code M2621 MMC AUXILIARY GIFT SHOP w Invoice# Comment Tran Dt Inv Dt Due Dt Check DPay Gross 122018 12/27/20 12/20/20 12/20/20 350.17 PAYROLL DED 122718 12/27/20 12/27/20 12/27/20 116.61 PAYROLL DED 0.00 Vendor Total: Number Name Gross M2621 MMC AUXILIARY GIFT SHOP 466.78 Report Summary Grand Totals: Gross Discount 466.78 0.00 pg (?'r'tcW CS SS Gt-)u,C,4TY AW)-fTO c Page 1 of 1 0 ap_open_invoice.template Discount No -Pay Net 0.00 0.00 350.17 ✓/ 0.00 0.00 116.61 ✓ Discount No -Pay Net J 0.00 0.00 1 466.78 No -Pay .Nota,...... 0.00 ( 466.78 file:///C:/Users/celevenger/cpsi/niemmed. cpsinet. com/u82227/data_5/tmp_cw5report59... 12/27/2018 N N NO 0. T Z ) ON T 4J a pvl ' dr.i 4 i ma a r) l� 0 r ¢o W m cm ILr ME M 8E wz o g m kc O a m a9a o'- �o NN as a u J N N m o d U j �« F-« j ❑ U � arQn � J N au. a 0 a E° Q, o Q ai r M � o N `, C N r W m N E o O 0w E N c o .m.. — n � V � 0 � N N = o Q m xt LU Q o Nm� m o ,v_F vW = ®m F- A 1 1 s• • k o rj c U 5 a m U W U) r m ¢ Zm u. a ya p o o rn K§ v o c m 3 N O � U ¢ B s o0 v G ' u$7 IL N E �QW4. < mo a LL a '� o N N ON a pvl ' dr.i 4 i 1 r) l� N N � N m p N o � r m N N m V N N N N r E � p ° o m OE a�tW ZU J qJqQ w a UA. U wE ao wz U r ci � o � c 0 �E � N m p N o � r m N N m V N N N N r E � p ° o C$®®1 �/ 4f, VIII N M o N m r rn rn m m o o r r r M O O o N O O m N N N b W W N r O O N N N m M1 O O N m m m m rn rn m 0 0 0 0 0 0 0 r r r r r r 1- U1 a A g m r {:r rn y C$®®1 �/ a�tW ZU J qJqQ UA. gic 4f, VIII N M o N m r rn rn m m o o r r r M O O o N O O m N N N b W W N r O O N N N m M1 O O N m m m m rn rn m 0 0 0 0 0 0 0 r r r r r r 1- m co Mm mo O M 6> M N O o v mmm rn v. - W N Ol m m O �- a O >OO O O OO d_ C U Y M O O 10 m O h q O O .R r m m m rn r 4 q 8 � LL �n �M000 uri rn W m N r O O N O N N Y1 r O O N m m m m rn m m E 0 0 0 0 0 0 0 — Q � a 3 a m m m m m m m N II a o a o 0 0 0 0 M N N N N N N N 4 ymj N h 10 in � h m N N N N N N N N ° ` c E �a Z m m m m m m W c m o 0 0 0 0 0 o E o a a � ul 0 ¢ Q 3 M N a Z d O U :3 0 O O o O o r 0 0 0 N UJB{{ `7 0 0 {:r w a N m co Mm mo O M 6> M N O o v mmm rn v. - W N Ol m m O �- a O >OO O O OO d_ C U Y M O O 10 m O h q O O .R r m m m rn r 4 q 8 � LL �n �M000 uri rn W m N r O O N O N N Y1 r O O N m m m m rn m m E 0 0 0 0 0 0 0 — Q � a 3 a m m m m m m m N II a o a o 0 0 0 0 M N N N N N N N 4 ymj N h 10 in � h m N N N N N N N N ° ` c E �a Z m m m m m m W c m o 0 0 0 0 0 o E o a a � ul 0 ¢ Q 3 M N a Z d O U :3 0 O O o O o r 0 0 0 N UJB{{ `7 {:r i I UA. r ci m 0 so M Q> 00 p r > o N N � L• g _ N 'oma aE N .- lU 2• N N x x g i d x �g Q D w z ..dam Qo �rn ®� M ao��Z—U, U Wq F F � 2i p R 2 > w a O c03 � � N °E N F N ; m 0 F- ° M N 00 p > o N N � L• g _ N N w N .- lU 2• N N I ffi Q y x �g xx� U N F ®� M ao��Z—U, U ', a O o LU AN O U❑ _ 0 zy ON a 0° m cmN ma F- ° Z U c • - . W Q D Q c > o eA I L O c L• g _ T o w (� ° E cn r� I ffi Q y x �g xx� U N F ®� M ao��Z—U, U Wq mLao>-zg ul � 2i p E U 2 > w a ', a O o LU AN O U❑ _ 0 zy ON a 0° m cmN ma o O 0 o r o O o 0 s W O O N O N N N . O r� I N N Q y o O 0 o r o O o 0 s a i 1H r� c': Number: 57513074 Date: 12-21-2018 1 of 1 WALGREENS #124943406 Due AmerisourceBergen STATEMENT AMERISOURCEBERGEN DRUG CORP Amount 12727 WEST AIRPORT BLVD TX 77979-2509 SUGAR LAND TX 77478-6101 866-451-9655 AMERISOURCEBERGEN DRUG CORP 0.00 PO Box 905223 4,438.90 CHARLOTTE NC. 28290-5223 Number: 57513074 Date: 12-21-2018 1 of 1 WALGREENS #124943406 Due MEMORIAL MEDICAL CENTER Purchase Order 1302 N VIRGINIA ST Amount PORTLAVACA TX 77979-2509 ACCOUNT: 1001352841037028186 Number Type Not Yet Due: 0.00 Current: 4,438.90 Past Due: 0.00 Total Due: 4,438.90 Account Balance: 4,438.90 Activity Due Reference Purchase Order Activity Amount Date Date Number Number Type 12-17-2018 12-28-2018 3017276717 140894 Invoice 493.861/ 12-17-2018 12.28-2018 3017276718 140895 Invoice 38.33 12-17-2018 12-28-2018 3017276719 140896 Invoice 0.40 12-17-2018 12-28-2018 3017276870 140897 Invoice 3.51V/ 12-17-2018 12-28-2018 3017276871 140898 Invoice 0.31. / 12-17-2018 12-28-2018 3017276872 140899 Invoice 11.514/,/ 12-17-2018 12-28-2018 3017276873 140900 Invoice 132.51+! 12-17-2018 12-28-2018 3017276874 140937 Invoice 87.831/ 12-17-2018 12-28-2018 3017276875 140938 Invoice 0.24 12-17-2018 12.28.2018 3017276876 140939 Invoice 280.44 V/ 12-17-2018 12-28-2018 3017276877 140940 Invoice 2.62/ 12.17-2018 12-28-2018 3017276878 140941 invoice 2.02E/ 12-17-2018 12-28-2018 3017321476 140990 Invoice 267.04 `✓ 12-17.2018 12-28-2018 3017321477 140991 Invoice 132.51/ 12-17-2018 12-28-2018 3017321478 140992 Invoice 0.16v' 12-17-2018 12-28-2018 3017321479 140993 Invoice 134.05 12-17-2018 12-28-2018 $017321700 140994 Invoice 355.88✓ 12-17-2018 12-28-2018 3017321701 140995 Invoice 1.551 12-18-2018 12-28-2018 3017441542 141003 Invoice 598.21% 12-18-2018 12-28-2018 3017441543 141004 Invoice 132.51 12.18-2018 12-28-2018 3017441544 141005 Invoice 259.70✓ 12-18-2018 12-28-2018 3017441545 141006 Invoice 1.551/ 12-19-2018 12-28-2018 3017603172 141064 Invoice 833.421/ 12-19-2018 12-28-2018 3017603173 141066 Invoice 0.76..,/ 12-20-2018 12-28-2018 3017706662 141078 Invoice 667.98V Thank You for Your Payment Reminders Date Payment Number Amount Due Date Amount 12.21-2018 (2,133.62) 12-28-2018 4 0 Total Due: 4,438.90 Terms — -- RAnnriav - Pririav rhnA in 7 nave _. t thecY,,,lOU-1 r -7L Ncc, .*i- (C0 b00Q v�..�n. xMa.. ammewcmm �<*vc. c,.«,c„mxan m,e,mnun ;ogNTYAlffl 'AOR ^A:4,t;(WN (;0IJKCY,'1 NYA 3 C O a I H N � m o m o a O � m m h m z n Enkzjon�"' a o d' C V0 Y dam' V a in a m� x m h �ry .-+ eo H H of ai of m U0U��UUm U UO g U U 0 U N N h m m " m o v m O mm m O J J N Z J � �: LL3dwg,d� N O H .1 m E E E E y E T d? T T T T ?, m m m m m m m i d d d d d d a U rG U V V U V U a V a a a a Q a m m w m m ca co m H H R H H H H H 0 0 0 0 0 0 0 0 h 1p l� to tp V H r( O N N N N N N N N E a t .; ,- „ -r- v m .rn Jy 00 o ill •.- - N �n 2 m .. J) rn ,- cv r w U� m ;n C C *} O� O 00 � 00 O ry 0 0 0 0 0 N O m`u m`mtt.�m`m` m a v 1 p p H N � m o m o a O � m m h m z n Enkzjon�"' a o d' C V0 Y dam' V a in a m� x m h �ry z z z a z z m U0U��UUm U UO g U U 0 U a W a Z a a 0 v m O mm m O J J N Z J � �: LL3dwg,d� v E E E E E T d? T T T T ?, m m m m m m m i d d d d d d a U rG U V V U V U a V a a a a Q a m m w m m ca co m H H R H H H H H 0 0 0 0 0 0 0 0 h 1p l� to tp V H r( N N N N N N N N .-1 N N N cNi N N H c U 41 a J u J tJ i� CD Y � s N Memorial Medical Center Nursing Home UPI, Weekly Cantex Transfer Prosperity Accounts 12/28/2018 Previous Assume Beginning ACH Number Balance Transferout Traron'l. 53,169.66 , 52,964.40 235,980.90 Eoutfi lnfarmatlan for Ashford Ga*,, Ashford Health Co. Center Ltd Ca JP Margon Chose Bank ABA Atte Today's Amsenito Be Beginning Transferred to - 236,186.16 ✓ / Bank Balance 236,186.16 Variance - leavetnBalance 100.00 MMCPmU*.QIPP1 - MMC Portion 01PP1 - MMCPorom,01PP2 - MMcPoll"AQIPP3 - October Bank mtermi 54.63 / November Bank Interest 50.63 Y December Bank interest - Adjust 0alance/rranSferAmt 235,980.98 flouflna 0formadon fvrhes¢8t/Salem at WestHvmtvn/tort BendlB od e- CvntexHeol(fi Care centers 11116 JPMagon ehaseeank ABA Note: Only bvfanv ofover$5,000 vdg be transferred to the nursino home. Nat,2 Earn aoaunthasabme bvlvnce a)$I00 MotMMcdep4sttedto open account. 235,966° :U 596e659,3U 364,501-'/1 120,002,'%5 91,045^23 g:\NHWe NyII nsrem\NH UPLTmnsferSummary\20tH\December2018\NH UPLTmnsfer$ummary L2-28-18 Leave In Balance 180.00 MMC Portion CUPPI - MMCPartIonQIPP1 - MMCPortion QIPP2 - MMC Portion CUPP3 October Bank interest 21.68 ✓- NovemberBankinterest 19.56 ✓� + December Bank Interest Adjust Balance/TrensferAret 91,843.23 ✓ V + , TOTALTRANSfE85 1.908267.89 Approved: Diane Moore, CFO 12/2$/2018 COO1V1117 .A:CJW`Pdti , %:lti ffi'Pa 114 i;R➢flsd`t�+, IM 4;'.rzft Prods. Tad.Y's Amount to ee A..e.t Beginning AGI Pending Ck to Beglan, Transferred to Nursing Hem. Number Balance Transfeh0ut Tmnskr-In MMCfor QIPP Pending DeposBs cant"Person- Federal Match Balance Nursing Home SRiSYEY�i N9110}1'n� -1 50,529.70 50,298.45 596,659.30 - 596,89o.55 596,65930 Bank Balance 596,890.55 Whose - Leave in Balance 100.00 MMCParom QIPPI - MNICPortion QIPP2 - MMcPoNanQIPP3 October Baniinterest - / 65.42/ November Bank interest 65.83 December Bank Interest / Adjust Balmoot arafer Amt 596,659.30,/ _.�u�� cCC4 t^� ;�;,?y 6,845.40 0� 6660.001/364,501.71 - - 364,688.11/364,501.71 Bank Balance 364,688.11 l/ Variance Leave in Balance 100.00 MMC Pardon QIPP1 - MMCPortionQiPP2 - MMC Portion QIPP3 October Bank interest 40.81✓ November Bank Interest 45S7 ✓ December Bank Interest Adjust BoWcefrmnsfer And 364,So3A1 ✓ ♦ , a -y �} 296,764.61t/ 296,559,79 f 120,062.75 - - 120,28757 120,082.75 Bank Balance 120,287.57 Variance leavein Balance 100.00 MMCPertion OIPPS - NUAC Period QIPP 2 MMc Potion0dPP3 October Bank Interest / 64.15 ✓ November Bank Interest 40.67✓ December Bank Interest 0 / Adjust ealance/Tmnsfer Amt 320,082.75 ✓ ,` Rirv�i(�s'�; .,J 5,90.45/ 5,807.21 / 91,043.23 - v - 91,184.47 91,043,23 Bank Balance 91,18447 Variance - flouflna 0formadon fvrhes¢8t/Salem at WestHvmtvn/tort BendlB od e- CvntexHeol(fi Care centers 11116 JPMagon ehaseeank ABA Note: Only bvfanv ofover$5,000 vdg be transferred to the nursino home. Nat,2 Earn aoaunthasabme bvlvnce a)$I00 MotMMcdep4sttedto open account. 235,966° :U 596e659,3U 364,501-'/1 120,002,'%5 91,045^23 g:\NHWe NyII nsrem\NH UPLTmnsferSummary\20tH\December2018\NH UPLTmnsfer$ummary L2-28-18 Leave In Balance 180.00 MMC Portion CUPPI - MMCPartIonQIPP1 - MMCPortion QIPP2 - MMC Portion CUPP3 October Bank interest 21.68 ✓- NovemberBankinterest 19.56 ✓� + December Bank Interest Adjust Balance/TrensferAret 91,843.23 ✓ V + , TOTALTRANSfE85 1.908267.89 Approved: Diane Moore, CFO 12/2$/2018 COO1V1117 .A:CJW`Pdti , %:lti ffi'Pa 114 i;R➢flsd`t�+, IM 4;'.rzft K:\NH Weekly Transfers\Cantex Bank Dowioad\2018\DECEMBER 2018\Cantex Prosperity Download 1221-18 Thru 12-27-18 Ash#41Pdfar--dens 12/27/2018 ACH Deposit Amerigroup TXSC HCCLAIMPMT 3389049370111000 12/27/2018 ACH Deposit UHC COMMUNITY PL HCCLAIMPMT 746003411910000 12/27/2018 ACE Deposit NOVITAS SOLUTION HCCLAIM PMT 675423420000318 12/26/2018 CM Wire Domestic WI RE OUT ASHFORD HEALTH CARE CENTER LTD 12/26/2018 ACH Deposit Amerigroup TX5C HCCLAIMPIAT 3388939552111000 12/26/2018 ACH Deposit UHC COMMUNITY PL HCCLAIMPMT 746003411910000 12/24/2018 ACH Deposit Amerigroup TXSC HCCLAIMPMT 3388863234111000 12/24/2018 ACH Deposit UHC COMMUNITY PL HCCLAIMPMT 74600341191000D 12/24/2018 ACH Deposit NOVITAS SOLUTION HCCLAIMPMT 675423 420000193 12/21/2018 ACH Deposit HEALTH HUMAN SVC HCCLAIMPMT 17460034113005 2 12/27/2018 ACH Deposit UHC COMMUNITY PL HCCLAIMPMT 7460 03431 91000 0 12/27/2018 ACH Deposit UNC Community PI HCCLAIMPMT746003431910000 12/27/2018 ACH Deposit NOVITAS SOLUTION HCCIAIMPMT 676357420000118 12/26/2018 CM Wire Domestic WIRE OUT CANTER HEALTH CARE CENTERS III 12/26/2018 ACH Deposit UHC COMMUNITY PL HCCLAIMPMT 746003411910000 12/26/2018 ACH Deposit HUMANA INS CO EFPAYMENT 3908618300005608121 12/24/2018 -ACH Deposit HHP EFPAYMENT 39086191000012215703 DISDATA 12/24/2018 ACH Deposit UNITEDHEALTHCARE HCCLAIMPMT 74603411124384 12/24/2018 ACH Deposit HUMANA INS CO EFPAYMENT 3908618300005290747 12/24/2018 ACH Deposit HUMANA INS CO EFPAYMENT 3908618300005286682 12/24/2018 ACH Deposit HEALTH HUMAN SVC HCCLAIMPMT 1746034113004 2 12/21/2018 Deposit 12/21/2018 ACH Deposit UHC Community PI HCCLAIMPMT746003411910000 12/21/2018 ACH Deposit NOVITAS SOLUTION HCCLAIMPMT 67635742000116 12/21/2018 ACH Deposit HUMANA INS CO EFPAYMENT 39DS6193005013554 x 12/27/2018 ACH Deposit UHC COMMUNITY PC HCCLAIMPMT7460034119100 12/27/2018 ACH Deposit UHC Community PI HCCLAIMPMT 74603411910000 12/27/2018 ACH Deposit NOVITAS SOLUTION HCCLAI MPMT 67632342000118 12/26/2018 CM Wire Domestic WIRE DUE CANTEX HEALTH CARE CENTERS III 12/26/2018 ACH Deposit UHC COMMUNITY PL HCCLAIMPMT 7460034119100 12/26/2018 ACH Deposit UHC Community PI HCCLAIMPMT746003411910000 12/26/2018 ACH Deposit HUMANA INS CO EFPAYMENT39086483000OS608121 12/24/2018 ACH Deposft UHC COMMUNITY PL HCCLAIMPMT 74600341191000 12/24/2018 ACH Deposit UHC Community PI HCCLAIMPMT 746OD3411910000 12/2212018 ACH Deposit UHC COMMUNITY PL HCCLAIMPMT 746003411910000 12/21/2018 ACH Deposit NOVITAS SOLUTION HCCLAIMPMT 676323 42000116 A' 12/27/2018 ACH Deposit UHC COMMUNITY PL HCCLAI MPMT 746003411910000 12/27/2018 ACH Deposit UHC Community PI HCOAIMPMT 746003411910000 12/27/2018 ACH Deposit NOVITAS SOLUTION HCCUJMPMT 675663 42000088 12/27/2018 ACH Deposit HUMANA INS CO EFPAYMENT 390863830005923189 12/26/2018 CM Wire Domestic WIRE OUT CANTER HEALTH CARE CENTERS III 12/26/2018 ACH Deposit HUMANA INS CO EFPAYMENT 390863 8300005612177 12/24/2018 ACH Deposit UHC Community PI HCCIAIMPMT 746003411910000 12/24/2018 ACH Deposit NOVITAS SOLUTION HCCLAIMPMT 6 75 663 42000192 12/24/2018 ACH Deposit HUMANA INS CO EFPAYMENT, 390863 8300005286682 12/24/2018 ACH Deposit HEALTH HUMAN SVC HCCLAIMPMT 174600341130062 12/21/2018 ACH Deposit UnitedHealthcare HCCLAIMPMT 74 60 03 411 124 3 8 4 12/21/2018 ACH Deposit HUMANA INS CO EFPAYMENT 390863830005013554 MMC PORTION Transfer -Out T"mfer-In QIPP/Comp3 QIPP/Comp2 QIPPJComp3 QIPPTI 2,025.12 2,708.01 137,217.09 - 52,964AD 1,422.90 29,383.27 - 26,105.19 29,984.49 - 3,287.40 3,947.43 page 1 NH PORTION 2,025.12 2,708.01 137,217.09 1,422.90 29,303.27 26,105.19 29,984.49 3,287.40 3,947.43 52,964.40 235,980.90 235,980.90 MMC PORTION Transfer -Out Transfer -in QIPP/Comp3 QIPP/Comp2 QIPP/Comp3 QIPPTI NH PORTION 18,384.80 - 18,384.80 9,330.00 9,330.00 35,614.84 - 35,614.84 296,559.79 4,448.64 - 4,448.64 7,205.44 - 7,205.44 154.12 - 154.12 7,938.00 - 7,938.00 2,756.76 - 2,756.76 8,166.33 - 8,166.33 2,216.73 2,216.73 109.23 109.23 6,482.50 6,482.50 16,219.28 - 16,213.28 1,062.08 - 1,062.08 296.50.79 1120,082.75 MMC PORTION Transfer -Out Transfer -in I QIPP/Comp3 0jPP/Comp2 QIPP/Comp3 QIPP 71 NH PORTION 1,653.60 - 1,653.60 1,480.00 1,480.00 24,257.45 - 24,257.45 6,660.00 _ _ 14,169.94 - 14,169.94 5,327.50 - 5,327.50 9,152.39 9,152.39 10,865.76 - 10,865.76 3,330.0 3,330.00 5,922.46 5,922.46 288,342.61 - 28&342.61 6,660.00 364,501.71 364,501.71 MMC PORTION Transfer -Out Transfer -In I QIPP/Comp3 QIPP/Comp2 QIPP/Comp3 QIPPTI NH PORTION 11,759.20 - 11,759.20 6,263.00 6,263.00 8,630.64 - 8,630.64 1,941.90 - 1,941.90 5,807.21 7,252.74 - 7,252.74 1,473.50 1,473.50 40,427.83 - 40,427.83 642.54 - 642.54 2,575.00 - 2,575.00 2,268.00 - 2,268.00 7,808.88 - 7,806.68 5,80731 91,043.23 1 91,043.23 R:\NH Weekly Transfers\Cantex Bank Dowload\2018\DECEMBER 2018\Cantex Prosperity Download 12-21-18Thru 12-27-18 SalaC+l ali,4Vast Houston 12/27/2018 ACH Deposit Amerigroup T%5C HCCLAIMPMT 3389049371111000 12/27/2018 ACH Deposit UnitedHealthcare HCCLAIMPMT746003411124334 12/27/2018 ACH Deposit NOVITAS SOLUTION HCCLAIMPMT676310420000118 12/26/2018 CM Wire Domestic WIRE OUT CANTER HEALTHCARE CENTERS III 12/26/2018 ACH Deposit HHP HCCIAIMPMT390862 91000012224276 DISDATA 12/26/2018 ACH Deposit Amerigroup TXSC HCCLAIMPMT 3388939553111000 12/26/2018 ACH Deposit UnitedHealthcare HCCIAIMPMT 746003411124384 12/26/2018 ACH Deposit UHC COMMUNITY PL HCCLAIMPMT 74 60 03 411 910000 12/26/2018 ACH Deposit HUMANA INS CO EFPAYMENT 3908628300005612177 12/24/2018 ACH Deposit UnitedHealthcare HCCLAIMPMT 746003411124384 12/24/2018 ACH Deposit NOVITAS SOLUTION HCCLAIMPMT 676310420000192 12/24/2018 ACH Deposit HEALTH HUMAN SVC HCCLAIMPMT 17460034113007 2 12/21/2018 Deposit 12/21/2018 ACH Deposit UHC Community PI HCCLAIMPMT 746003411910000 12/21/2018 ACH Deposit UHC COMMUNITY PL HCCLAIMPMT 746003411910000 12/21/2018 ACH Deposit NOVITAS SOLUTION HCCLAIMPMT 676 310 420 000116 TOTALS Page 2 MMC PORTION Transfer -Out TmnsfeMn QIPP/Comps QIPP/Comp2 QIPP)[omp3 QIPP TI NH PORTION 14,615.89 - 14,615.89 400.00 - 400.00 36,551.28 - 36,551.28 50,298,45 728.20 72820 14,912.68 14,912.68 40.00 - 40.00 9,820.28 9,820.28 35,081.65 35,081.65 6,560.00 - 6,560.00 436,802.61 - 436,802.61 3,015.00 - 3,015.00 3,600.00 - 3,600.00 10,457.50 - 107457.50 16,326.63 16,326,63 7,747.58 7,747.58 50,298.45 596,659.30 596,659.30 412,289.85 1,408,267.89 1,408,267.89 12128/2018 Rollie ALL ACCOUNTS FAVORITES * Digital Banking Checking Available son By: Account Number 1 Previous Day WRIN1 QMWAMM MEMORIAL MEDICAL CENTER / $320,650.41 $236,186.16 NH ASHFORD •43a1 * MEMORIAL MEDICAL CENTER / $178,118.73 $120,287.57 NH BROADMOOR'44aa * MEMORIAL MEDICAL CENTER / $386,029.99 $354,688.11 NH CRESCENT x'4411 * MEMORIAL MEDICAL CENTER / $674,971.27 $596,890.55 SOLERA AT WEST HOUSTON '4438* MEMORIAL MEDICAL CENTER / $126,285.42 891,184.47 NH FORT BEND -4446* affmanoWwwas _.. - TOTAL $4,123,431.76 $3,997,312.96 https://pbsltx.secum.fundsxpress.com/fxweb/app/#ihome 1/1 /) ! ■! ) `)§ ; {� �\ / \\ 2r §§ §)!E+ #+ ® 6 > MMC PORTION Golden Creek Transfer -Out Transfer-[ IOIPP/Comp] OIPP/COmp2 QIPP/COMP3 OIPP TI CNH POSITION 12/27/2010 AM Deposit NOVITASSOLUTION HOCIAIMPMT6]609)4200(30110 32,979.34 - 4079.34 12/24/2018 ACH Deposit NOVITAS SOLVNON HOUAIMPM(676097420000192 21,809.68 21,009.68 12/21/2018 Deposit 76,533.24 - 76,533.24 12/21/2018 AM Deposlf NOWASSOLI)TION HMLAIMPW S76097420000116 14,684.59 14,604.59 145,906.85 145$06,85 12/28/2018 Home ALLACCOUNTS Checking FAVORITES * MEMORIAL MEDICAL / NH GOLDEN CREEK HEALTHCARE -4454* Digital Banking Available Previous Day $179,158.77 $146,072.15 TOTAL $4,123,431.76 $3,997,312.96 sort By: Eccco..t Number https:llpbsItK.secure.fundsxpress.comlixweb/appl#/home 111 Run Date: 12/29/18 Time: 09:54 Final Summary *-- Pay Code Summary I PayCd Description 1 REGULAR PAY -SI C CALL PAY B EXTRA WAGES MEMORIAL MEDICAL CENTER Page 78 Payroll Register I Bi-4leekly j P2REG Pay Period 12/07/16 - 12/20/18 Runk 3 ---------------------*-- D e d u c t i o n s S u m m a r y ----- - -------* Bra IOTISHIFIBIHOICBI Gross I Cade Amount 3.00 N N N N 150.64 141.00 N N N N 282.00 N N N N 1560.00 AIR A/R2 ADVANC AWARDS CAFE H CAFH-1 CAFH-3 -1000.22 CAFE -4 CAFH-C CAFE -D CAFH-H CAFE -I CAFE -P -1224.78 CANCER CLINIC C014BIN DD ADV DENTAL DIS -LF -921.88 EAT FEDTAX FICA -N1 FIRSTC FLUX S FORT D FUCA GRANT GRP -IN HOSP-I ID TFT LEGAL NASA MISC MISC/ OTHER PHI PR FIN -2091.30 RELAY SAMS SCRUBS ST -TX STONDF STONE2 STUDEN TSA -2 TSA -C TSA -R TUTION NWIHGS 3, +-------------------- Grand Totals: 144.00 ------- (Gross; 2000.69 Deductions: -19886.81 Net; 21887, )B0— �- Checks Count:- FT 141 PT 1 Other Female 127 Male 14 Credit overAmt 1 ZeroNet Term To a : 1941 ( e� A/R3 BOOTS -4967.42 CAFE -2 -3798.83 -1370.57 VAFR-5 -671.22 CAFE -F CAFE -L CHILD -3320.87 CREDUN DEP-LF EATCSH 249.68 FICA -0 999.10 FLX FE GIFT S GTL LEAP -1768.50 MEALS MMCSHR PHI*** REPAY SIGNON STONE TSA -1 TSA -P UNIFOR Run Date: 12/28/18 MEMORIAL MEDICAL CENTER Page 5 Time: 10:44 Payroll Register ( B1 -Weekly ) P2REG Pay Period 12/07/18 - 12/20/18 Rua# 2 Final Summary *-- Pay Code Summary PayCd Description *------------ _------------------- --------------------------------- ---*-- D e d u c t i o n s S u m m a r Era IOTISHINBIHOICBI Gross I Code Amount ------------------------------------ *---------------- .----------- . --------------------- A/R --___--_-__-__-__._ A/R A/R2 ADVANC AWARDS CAFE H CAFH-1 CAFR-3 CAFE -4 CAFE -C CAFE -D CAFE -H CAFH-I CAFE -P CANCER CLINIC CORBIN DD ADV DENTAL DIS -LF BAT FEDTAX FICA -M FIRSTC FLEX S FORT D FUTA GRANT GRP -IN HOSP-I ID TFT LEGAL NASA DISC RISC/ OTHER PHI PR FIN RELAY SAME SCRUBS ST -TX STONDF STONE2 STUDIED TSA -2 TSA -C TSA -R TUTION UIV/HOS A/R3 BOOTS CAFE -2 CAFE -5 CAFE -F CAFE -L CHILD CREDUN DEP-LF BAKER .05 FICA -0 FIX FE GIFT S GTL LEAF MRALS MKCSHR PHI*** REPAY SIGNON STONE TSA -1 TSA -P UNIFOR *-------------------- Grand Totals: ------- ( Gross: Deductions: 3.23 Checks Count:- FT PT Other Female Male Credit 2 OverAmt ZeroNet Term t--------------------------------------- _--------------------------------------------- _______________________. 3.18 Net: -3.23 ) Q T t_1 I / Run Date: 12/31/18 MEMORIAL MEDICAL CENTER Page 5 Time: 08:32 Payroll Register ( Bi -Weekly ) P2REG Pay Period 12/07/16 - 12/20/18 Rung 4 Final Summary +-- Pay Code Summary Payed Description -------------------------------- E -------------------- Grand Totals: Checks Count:- FT PT Other '------------------------ _------------- ---------------------------- _____-'-- D e d u c t i o n s S u m m a r y ----------_..' Hrs IOTISHIWEIHOICEI Gross I Code Amount N N N N -1560.00 A/R A/R2 A/R3 ADVANC AWARDS BOOTS CAFE H CAFE -1 -65.45 CAPS -2 CAPH-3 CAFH-4 CAFH-5 CAFE -C CARE -D CAFH-F CAFH-H CAPE -I CAFE -L CAFB-P CANCER CHILD CLINIC COMBIN CREDUN OF ADV DENTAL DEP-LF DIS -LF RAT BATCSH FBDTAX FICA -M -45.24 FICA -0 -193.44 FIRSTC FLEX S FLX FH FORT D FUTA GIFT S GRANT GRP -IN GTL HOSP-I ID TFT LEAF LEGAL MASA 9.75 MEALS MISC MISC/ MMCSHR OTHER PHI PHPtt PR FIN RELAY REPAY SAMS SCRUBS EIDSON ST -TX STONDF STONE STON92 STUDEN TSA -1 TSA -2 TSA -C TSA -P TSA -R TUTION UNIFOR UW/HOS ------- ( Gross: -1560.00 Deductions: -294.30 Net:( -1265.62 ( r�1� Female Male Credit 2 OverAmt ZereNet Term Total:—I �- V, L ------------------`------` Cr -0 1) -$t-1$ Run Bate: 12/31/18 Time: 09:15 Final Summary *-- Pay Code Summary Payed Description *------------ --------------- C C MEMORIAL MEDICAL CENTER Payroll Register I Bi -Weekly ) Pay Period 12/07/18 - 12/20/18 Rung 5 Page 5 P2RHG ------------------------- ----------- *-- D e d u c t 10 n s S u m m a r y -------------* Mrs JOTISBIWEIMOICB] Gross I Code Amount -128.00 N N N N -256.00 A/R A/R2 A/R3 ADVANC AWARDS BOOTS CAFE H CAFE -1 160,05 CAFE -2 CAFE -3 45.23 CAPE -4 34.42 CAFE -5 CAFE -C CAFE -D CAFH-F CAFR-H CAPB-I CAFE -L CAFE -P CANCER CHILD CLINIC CORBIN 288.65 CERIUM DD ADV DENTAL DEP-LF DIS -LF 289.65 EAT EATCSH PRETAX FICA -M -16.55 RICA -0 FIRSTC FLEX 8 FIX FE FORT D FUTA GIFT 8 GRANT GRP -IN GTL HOSP-I ID TFT LEAF LEGAL MASA 9.75 NFALS MISC NISC/ MMCSHR OTHER PHI PHI*** PR FIN RELAY REPAY SA148 SCRUBS SIGNOR ST -TX STONDF STONE STONE2 STUDEN TSA -1 TSA -2 TSA -C TSA -P TSA -R TUTION UNIFOR UW/HOS 89,39 -71.49 *------------------- Grand Totals: -128.00 ------- ( Gross: -256.00 Deductions; 829.90 Net: -1085.90 1\ Checks Count:- FT PT Other Female Male Credit 2 OveTAmt 2eroNet Term �ta� -1-� --- ------------------------------------------ ------ --- Cho t23t-(� Run Date: 12/31/18 MEMORIAL MEDICAL CANTER Page 7 Time: 09:37 Payroll Register 1 Bi -Weekly ) P2REG Pay Period 12/07118 - 12/20/18 Rung 6 Final Summary x-- P a y C o d e S u m m a r y -------------------------- PayCd Description Hrs IOTISHIWEIHOICBI x ----------------------------------------------------------- C 128.00 N N N N x-------------------- Grand Totals: 128.00 ------- ) Gross: Checks Count:- FT 3 IT Other Female 3 Male --------x-- D e d u c t i o n s S u m m a r y ---- ---------' Gross Code Amauat __- -----x---------------------------------------------------x 256,00 A/R A/R2 A/R3 ADVANC AWARDS BOOTS CAFE H CAFH-1 -268.10 CAFE -2 -09.39 CAFR-3 -45,23 CAPS -4 -34,42 CAFE -5 CAFE -C CAFE -D CAFE -F CAPE -II -1560.00 CAFE -I CAFH-L CAFE -P CANCER CHILD CLINIC CONNIN -288,65 CREDUN DD ADV DENTAL DBP -LF DIS -LF -289.65 BAT RATCSH FEDTAX FICA -M 32.68 PICA -0 139,69 FIRSTC FLEX S FIX PE FORT D FUTA GIFT E GRANT GRP -IN GTL HOSP-I ID TFT LEAF LEGAL NASA -9,75 MEALS MISC MISC/ MMCSHR OTHER PHI PHP*' PR FIN RELAY REPAY SAMS SCRUBS SIGNOR ST -TX STONDF STONE STON92 STUDEN TSA -1 TSA -2 TSA -C TSA -P TSA -R TUTION UNIFOR UN/HOS 256.00 Deductions: -2412,90 Net: ( 2668.90 Credit OverAmt EeroNet Term Total: -------------------------------------------------------------' Q�)-b TOLL FEE PHONE NUMBER: 1-800-555-3453 (EFTPS TUTORIAL SYSTEM: 1-800-572-8683) "ENTER 9-DIGITTAXPAYER IDENTIFICATION NUMBER" "ENTER YOUR 4 -DIGIT PIN" D"MAKE A PAYMENT, PRESS 1" "ENTER THE TAX TYPE NUMBER FOLLOWED BY THE # SIGN" E"IF FEDERAL TAX DEPOSIT ENTER 1" D"ENTER 2 -DIGIT TAX FILING YEAR" "ENTER 2 -DIGIT TAX FILING ENDING MONTH" 1ST QTR - 03 (MARCH) - Jan, Feb, Mar 2ND QTR - 06 (JUNE) - Apr, May, June 3RD QTR - 09 (SEPTEMBER) -July, Aug, Sept 4TH QTR - 12 (DECEMBER) - Oct, Nov, Dec "ENTER AMOUNT OF TAX DEPOSIT - FOLLOWED BY # SIGN" "1 TO CONFIRM" "ENTER W/CENTS AMOUNT OF SOCIAL SECURITY" "ENTER W/CENTS AMOUNT OF MEDICARE" "ENTER W/CENTS AMOUNT OF FEDERAL WITHHOLDING" 0 11 6 -DIGIT SETTLEMENT DATE" "1 TO CONFIRM" ACKNOWLEDGEMENT NUMBER #### ENTER: ### 24-6003411 6016 941 # n 11, $ 2,186.65 1 $ 1,747.70 $ 440.98 CHECK $ 1 CALLED IN BY: CALLED IN DATE: CALLED IN TIME: d K:1Finance Share\AP-Payroll Files\Payroll Taxes\20181#26 MMC TAX DEPOSIT WORKSHEET 12.20.18 R2 -R6 12/31/2018 941 RECJTAX DEPOSIT FOR MMC PAYROLL "This report Includes the voided check number 062175 and the necessary adjutments REVISED 3118/2014 1NAL CK 111 TOTALS $ 440.64 (5,140.20) (3,788.83) (1,000.22) (1,370.67) (671.22) (1,660.00) (1,224.78) (3,320.87) (921.68) 220.62 877.04 (1,758,75) (2,091.30) $ (21,760.96) $ 22,201.60 S26 MMC TAX DEPOSIT WORKSHEET 12.20.18 R2 -R6; TAX DEPOSIT WORKSHEETI2/31@018 -CALCULATED" •-EMFRVON PAY PERIOD; BEGIN Differen 12/97/(81 VOIDED CP PAY PERIOD: END 12I20J18 PAY DATE: 1.46% 72!29118 $ GROSS PAY: $ 440.64 azo% DEDUCTIONS: AJR 6x0% $ 873.85 $ ADVANC $ - BOOTS $ CAFE -1 $ (6,140.20) $ CAFE -2 $ (3,798.83) zee% CAFE -3 $ (1,000.22) CAFE -4 $ (1,370.67) CAFE` -6 $ (671.22) CAFE -D CAFE -H $ (1,660.00) CAFE -I $ CAFE -L CAFE -P $ (1,224.78) CANCER CHILD $ CLINIC $ COMBIN $ (3,320.87) CREDUN DENTAL DEP-LF DIS -LF $ (921.88) EAT $ FED TAX FICA -M $ 220.62 FICA -0 $ 877.04 FIRST C FLEX S FLX-FE GIFT S GRP -IN GTL HOSP-1 LEGAL $ (1,758.75) OTHER PHI PR FIN $ (2,091.30) RELAY REPAY STONEDF $ STONE STONE2 STUDEN TSA -R $ UWIHOS TOTAL DEDUCTIONS: $ (21,760.96) $ _ '3kU141i1>FFgPRE` �..JL'2T61[I4i NET PAY: $ 22,201.60 1 $ TOTAL CAFE 125 PLAN: $ (94,766.82) L9Ss'F%e "This report Includes the voided check number 062175 and the necessary adjutments REVISED 3118/2014 1NAL CK 111 TOTALS $ 440.64 (5,140.20) (3,788.83) (1,000.22) (1,370.67) (671.22) (1,660.00) (1,224.78) (3,320.87) (921.68) 220.62 877.04 (1,758,75) (2,091.30) $ (21,760.96) $ 22,201.60 S26 MMC TAX DEPOSIT WORKSHEET 12.20.18 R2 -R6; TAX DEPOSIT WORKSHEETI2/31@018 -CALCULATED" From MMC RBRmi Differen FICA-MED(ER) 4.46% $ 220.49 FICA - MED (EE) 1.46% $ 220.49 $ 220.62 $ FICA - SOC SEC (ER) azo% $ 873.86 FICA - SOC SEC (EE) 6x0% $ 873.85 $ 877.04 $ FED WITHHOLDING $ $ TAX DEPOSIT: $ 2,188.68 $ 2,195.32 $ FICA -MEDICARE zee% $ 440.98 FICA -SOCIAL SECURITY ,z.4o% $ 1,747.70 FED WITHHOLDING $ - TOTALTAX: $ 2,188.68 "This report Includes the voided check number 062175 and the necessary adjutments REVISED 3118/2014 1NAL CK 111 TOTALS $ 440.64 (5,140.20) (3,788.83) (1,000.22) (1,370.67) (671.22) (1,660.00) (1,224.78) (3,320.87) (921.68) 220.62 877.04 (1,758,75) (2,091.30) $ (21,760.96) $ 22,201.60 S26 MMC TAX DEPOSIT WORKSHEET 12.20.18 R2 -R6; TAX DEPOSIT WORKSHEETI2/31@018 Calhoun County Cornrnissioners' Court — January 02, 2019 17. Approval of bills and payroll. MMC Bills RESULT: APPROVED [UNANIMOUS] MOVER: David Hall, Commissioner Pct 1 SECONDER: Vern Lyssy, Commissioner Pet 2 AYES: Judge Meyer, Commissioner Hall, Lyssy, Syma, Reese County Bills RESULT: APPROVED [UNANIMOUS] MOVER: David Hall, Commissioner Pet 1 SECONDER: Vern Lyssy, Commissioner Pet 2 AYES: Judge Meyer, Commissioner Hall, Lyssy, Syma, Reese Page 15 of 16 January 2, 2019 2018 APPROVAL LIST- 2018 BUDGET COMMISSIONERS COURT MEETING OF 01/02/19 BALANCE BROUGHT FORWARD FROM APPROVAL LIST REPORT PAGE 7 J ✓ $43,829.57 FICA P/R $ 48,632.22 MEDICARE P/R $ 11,611.72 FWH P/R $ 33,563.43 NATIONWIDE RETIREMENT SOLUTIONS P/R $ 3,503.48 OFFICE OF THE ATTORNEY GENERAL - CHILD SUPPORT P/R $ 2,662.93 CABLE ONE A/P $ 137.44 FRONTIER COMMUNICATIONS A/P $ 228.52 MCI COMM SERVICE A/P $ 54.97 WHITE TRASH SERVICES A/P $ 70.26 TOTAL VENDOR DISBURSEMENTS: $ 144,294.54 TOTAL AMOUNT FOR APPROVAL: $ 144,294.54 s 3 y o 0 0 0 00 00 O O O w n ° ui mo m ro ro Z �v ro O O O O O O O O O O W O 99 mo s 0� zz 0 0 0 �m 9 a °z °z zo O W A VtAi Vii Y e b O O N Ei j H Oo b a0 yam O c)O oa o0oO a a as mff gn Ba o � 'oYo trirCY' PN m NC m�x No n 2i. o wRo m �"' ti� a �U' R to O J O. M N W lI� H W Wb W UWi W Op. Op. N to J Vi Vi O W W IA a W tAn V A A O O O W W O O n 9 �� 2 x 2y m m � w r `v DWI O w s w a VNi b U O H O N O O O O r `v DWI O n h H n w w in N L+ O N O n 0 O w s w a VNi b U O H O O n h H n w w in N L+ O N O n 0 �! 0§ M p kz k2 S2 a a v e n O O O U U m o r M y O n r C. CpO, O n y Y in Z O y O e^i R ° (p N O O T O O O N N p p RG QQ� �i ns nS z o 0 o a t H 8p g° y I o z S o 0 NvOi vOi u N N N O O I r n CCC Q O O gg b boL4 a Cu n Vln NQ V A q qQ u pC u O 103 �C b CC � V J 1 A NA WN V W W W b P r n 0 0 0 0 0 $ o S $ g o Wrro b77d trl ,ro p]7� b7 Sd� O z z Sy > �y' y �5z O R O C�.0 O 1�y't VNi C b 9 Q � ^'t N � '9 i• r� 'tL'. w K� V H m r O O O N N N N N W N if' o ��c� Q� e y y a �,� o N 3W2 N o OA J � T CO o W J ij `Ob V O u N QMO �� dA z r f3 ro� � yy CT ;v m c� oym h'1 FA n AH "y' H FN �� Ag �. H^ ECpW m Ow ,dz e rop Aon �W `�� a• w w N O W W � J tW0 A A J J N N O a 0 0 0 0 0 0 0 0 y H qq A pp A W O G O J N N (] O O O ° r� 1S roE 6 0 0 o y o o n Y r $ b N A W Oo O W ON0 M A J � O b leg Ci O O 111 ° iM 1 c m v Y[ D GTl u �1 R A gfi g m Nb -P r 0 x p A b � N �. _ � �74 boy .Np H � p n m N N T N N y N N N cTc�� N .W�pp yyA C O po O ^ S S O o o' I n I PO a 3 I PO Calhoun County Commissioners' Court—January 02, 2019 18. PUBLIC DISCUSSION OF COUNTY MATTERS. COURT ADJOURNED: 10:23 AM Page 16 of 16