Hi I need assisstance in solving healthcare financial accounting problem.

Hays County IDS by Dr. Michael Nowicki, FACHE, FHFMA Your IDS It is December, 2016, and you have just accepted the CFO position at Hays County Integrated Delivery System (IDS)[hereinafter referred to as County]. You will be reporting to Mr. Salter, County's chief executive officer, a retired schoolteacher who was hired last year. Also reporting to Mr. Salter are Mr. Wannabe, County's chief operating officer, Dr. Spok, County's medical director, and Ms. Patty Care, County's director of nursing. When announcing your appointment, Mr. Salter stated that your primary objective in the coming year (2017) would be to reverse the ominous financial trend that began in 2015 with an operating loss and continued in 2016. Previous operating losses were funded with investment income (investment income was $200,000 in 2016) from unrestricted net assets; however, your board recently passed a resolution discontinuing that practice and restricting investment income to capital expenditures. County is a not-for-profit county-owned corporation and includes a 120-bed acute care hospital, a 25-bed skilled nursing facility, a 15-bed rehab facility, a home healthcare agency, and an outpatient clinic, and a 40-member medical staff that bills independently. The hospital, Hays County Hospital (HCH), is one of two hospitals in the county (population is 175,000) and the only hospital in San Marcos, Texas, with population of 50,000. St. Teresa's, a not-forprofit Catholic-owned hospital is the only other hospital in Hays County is about 25 miles from Hays County IDS. In order to acquire background information, you decide to meet with each member of the executive team first, then selected members of senior management. Meeting with Dr. Spok Dr. Spok, hospital medical director, told you: Most doctors have been on the medical staff for at least ten years. There is little loyalty to the hospital and most doctors also have admitting privileges at St. Teresa's, a newer hospital with better facilities 25 miles away. While it is a hassle for the doctors to drive from San Marcos to St. Teresa's to see patients, there are few good reasons for the doctors to admit their patients to St. Teresa's. St. Teresa's has a hospitalist and pays physicians for menial service assignments like committee work (a practice that County has refused to implement). Meeting with Mr. Salter Mr. Salter, chief executive officer, stated: I just don't understand why we are losing money. I spent a considerable amount of time recruiting new doctors while keeping the existing doctors happy. The new, younger doctors just don't seem to have a sense of loyalty to . Furthermore, I've tried to establish a \"family atmosphere\" for our employees that stresses getting along well with others in return for job security. Everyone seems happy. Everyone except Ms. Fi Nance Myway, whom you'll be replacing. She and I both started January of 2014 and she seemed increasingly frustrated with the way I do things here--she just didn't fit in. I tried to accommodate her by implementing some of her recommendations, even though they were against my better judgment--like charging visitors for parking which generated $100,000 in other operating revenue in 2015, but I have discontinued the practice in 2016 because no other organization in San Marcos, other than the University, charges for parking. And when I announced that I was bringing in more business to the hospital by entering into a two-year capitated managed care agreement with the city (it expires this month)--we get $250 per month per family for taking care of the 300 city employees and their families, whether they're sick or not, Ms. Myway threw a fit at an executive team meeting. She claimed that my decisions were driving County deeper into the red and as a result, I had to show Ms. Myway the highway for insubordination. That happened last month. Mr. Salter has asked you to do the following: 1) I would like you to make a fifteen-minute, 50 PowerPoint slide presentation during our board strategic planning retreat regarding financial challenges you see for County during the next 15 years. 2&3) Develop a statement of operations and balance sheet for 2016 (you can assume the format and numbers are correct on the 2015 balance sheet, and you can further assume that all balances on the 2015 balance sheet carry forward to the 2016 balance sheet, with the exception of accounting for the profit or loss on the 2016 statement of operations). 4) Analyze 2016's financial statements using ratio analysis and identify strengths, weaknesses and recommendations for improvement. 5) What is the best ratio for measuring accounts receivable performance? What are the best ways to improve accounts receivable performance? 6) Dr. Garcia is thinking about retiring this year and has asked us if we would like to buy her practice. She would like annual income of $250,000 for the next 30 years. If we can put the purchase price in an annuity that earns 4 percent per year compounded annually, what is the purchase price? What other factors should we consider before buying a physician practice? What is your recommendation? 7) Calculate the financial impact of buying a CT unit that would cost $3.0 million, would have a five-year useful life, would have a 10 percent salvage value, would have a profit per procedure of $400, and would generate an estimated volume of 450 procedures per year. The bank tells me the discount rate should be 10 percent. If the project loses money, let me know how many procedures in addition to the 450 projected per year we would need to generate in order to break-even. Our long-term debt represents the remaining balance on a 30 year loan taken out in 1996 at 7% with options to refinance every 10 years. If we refinance for the remaining 10 years at 3%, how much interest expense will we save over the remainder of the loan? 8) For the CT unit in #7, evaluate the various types of financing? 9) Analyze my capitated managed care agreement with the city. Using differential cost analysis for 2016 data, tell me the full cost profit/loss and the differential cost profit/loss. Should we renew the contract for next year at present rates, or should we ask for a rate increase and if so, how much rate increase do we need to cover our full cost? to cover our differential cost? 10) For 2017, develop a statistical budget; then develop a revenue budget (using a financial model, determine whether to increase rates and if so, how much) and an expense budget in statement of operations format including detailed footnotes explaining any changes in the numbers. I would like to see at least four different expense scenarios: 1) 2) 3) 4) 11) maintain expenses at 2016 levels after adjusting for volumes and mandated expenditures identified in earlier steps; maintain expenses at 2016 levels after adjusting for volumes and mandated expenditures identified in earlier steps and honoring all requests (i.e., raises, additional personnel, etc); cut expenses (from expense scenario #1) in order to break-even in 2017; cut expenses (from expense scenario #1) in order to breakeven in 2017 and recover FY 2012 losses. I would like to empower the department heads with more authority for their departments (right now they are responsible for the direct costs associated with labor and supplies). What additional authority can we delegate to the department managers and what additional training and training costs will that entail? 12&13)Please prepare a fifteen-minute, 50 slide PowerPoint presentation for our board on cost shifting at our hospital and explain how emerging reimbursement methods are making cost shifting harder. 14) Please give me your thoughts on the operational and financial implications of ACA of 2010 and MACRA of 2015 on our hospital. Meeting with Mr. Operator Mr. Operator, chief operating officer and a recent graduate from a program in health care administration, expressed the following concerns regarding the hospital: It's easy to understand how we lost money last year--Mr. Salter just won't say \"no\" to the doctors..., or the nurses, for that matter. Our revenue is down for a variety of reasons and our expenses continue to increase. I don't know why the board ever picked a school teacher to run a healthcare system. Meeting with Ms. Pincher Ms. Penny Pincher, County's controller, in answer to your question regarding last year's loss, believes the following: While acute care days are flat and SNF and rehab days and outpatient visits are up, our real financial problems involve our patient mix by financial class--commercial and self-pay continue to decline and fixed payment and capitation continue to increase, and our board won't approve more than a 2% rate increase for 2017 (which affects collections for only commercial and managed care with discount--you need to make assumptions regarding Medicare and Medicaid collections). 2016 Collections/Discharge Acute SNF Rehab Home ER Out Medicare 12,800 8,000 16,000 280 700 380 Medicaid 12,400 8,600 16,600 240 960 360 Commercial 19,200 10,400 20,000 500 1,600 400 Managed Care w/40% discount* Managed Care w/capitation** *Managed Care contracts with discounts call for an additional 1% discount for every 1% increase in rates. **Managed Care contract with capitation includes only the agreement with the city. Meeting with Ms. Care Ms. Patty Care, director of nursing, seeks your support in the following proposal: While our financial loss is serious; most of it is attributable to low rates--we need to increase our rates to reflect our quality services. Our nurses are overworked and underpaid. I've been working on two solutions that I would like your support on. First, I believe strongly in primary care nursing and as a result, 90 percent of the nursing staff is RN's. RN's can perform more tasks than LPN's and nursing assistants and therefore, are more efficient. This can be further justified by the acuity of our patients. Using the DRG scale as a severity index, our patients are sicker than the average hospital. However, I am having some difficulty getting the RN's to administer meds, empty bed pans, and feed patients. Therefore, I have developed a TQM program designed to convince the RN's that all their tasks are important. All RN's are required to attend 5 hours of TQM training each week. Even though patient days are down, I would like to hire ten more RN's to help cover the floors when the other RN's are in training. In order to recruit these RN's in light of the nursing shortage, we need to increase their average hourly rate to $50.00, which is competitive with County Hospital (see Table VI-A). This, of course, would be in addition to the cost of living raises already announced by the personnel director. I also would like for you to include a doctorally-prepared entry level nurse in our strategic plan for ten years from now. Meeting with Ms. Personal Ms. Personal, personnel director, reluctantly admits the following to you. Hospital practice in the past has been to give the employees a cost of living raise equal to the previous year's percent increase in the CPI Also, historically, we have allocated 5% of total wages to a merit pool to be awarded to meritorious employees based on their annual evaluations. Because Mr. Salter treats the employees like family, virtually everyone gets the raise. Because of shortages in nursing, I am recommending a market raise of 3%, in addition to the above raises, to keep us competitive. Here is a wage comparison to the facilities that we compete with for new hires (see Table VI-A). Mr. Salter asked us not to announce raises until your financial analysis is complete. Meeting with Mr. Materials Mr. Materials, materials manager, reports the following information to you. I am projecting a 3% increase in supply and food prices for 2017 and a 5% increase in all other prices. Table I Hays County IDS Balance Sheet as of December 31, 2015 Assets 2015 Current Assets Cash and cash equivalents Marketable securities Accounts receivable less allowances Inventories at cost Other current assets Total Current Assets $ Land and improvements Buildings Fixed equipment Moveable equipment 3,250,000 36,485,750 8,063,250 4,466,750 Property, Plant & Equipment 52,265,750 Less accumulated depreciation (18,080,750) Total Property, Plant & Equipment TOTAL ASSETS 178,750 1,100,500 11,250,000 3,368,000 992,500 16,889,750 34,185,000 $ 51,074,750 Current Liabilities Current portion of long-term debt Accounts payable & accrued expenses Estimated amounts due to third-party payors Other current liabilities Total Current Liabilities Long-term debt, net of current portion TOTAL LIABILITIES $ 2,151,000 5,400,000 1,423,750 1,500,000 10,474,750 37,000,000 47,474,750 Net Assets Unrestricted Temporarily restricted Permanently restricted 2,100,000 1,000,000 500,000 TOTAL NET ASSETS 2,500,000 TOTAL LIABILITIES AND NET ASSETS $ 51,074,750 Table II Hays County IDS Actual Expenses through December 31, 2015 Wages, Taxes, Benefits Professional Fees & Commissions Drugs Medical and Other Supplies Food Purchased Services Repairs & Maintenance Utilities Interest Depreciation TOTAL EXPENSES $ 84,000,000 6,000,000 7,000,000 6,000,000 3,000,000 3,000,000 6,000,000 4,000,000 8,019,000 11,734,120 $ 138,753,120 Table III Selected Industry Financial & Productivity Ratios 100-199 Beds Financial Ratios Optum Liquidity Ratios Current ratio Collection period ratio Days Cash-on-hand, short-term sources Days Cash-on-hand, all sources Capital Structure Ratios Net asset financing ratio Debt service coverage ratio Efficiency Ratios Total asset turnover ratio Age of plant ratio Fixed asset turnover ratio Current asset turnover ratio Inventory turnover ratio Profitability Ratios Excess margin Operating margin Return on net assets Operating Indicators Length of stay Occupancy rate Productivity Ratios Gross Price per Adjusted Discharge Net Price per Adjusted Discharge Cost per adjusted discharge 20,000 10,000 8,551 Salaries per Adjusted Discharge 3,127 Nursing service RN's as a percent of total nursing LPN's as a percent of total nursing 32.20 21.70 Full-time equivalent employees Per occupied bed Salary per FTE 4.90 57,392 Bobcat Table IV-A Hays County IDS Discharges Service(LOS) 2012 2013 2014 2015 2016 Acute(4) 8,000 7,500 7,000 7,000 7,000 SNF(13) 130 132 134 136 138 Rehab(20) 138 140 142 144 146 Home Health 30,000 25,000 20,000 15,000 15,000 Emergency 32,500 35,000 37,500 40,000 42,500 Outpatient 27,500 30,000 32,500 37,500 42,500 Table IV-B Percentage of Discharges by Payer Medicare Medicaid Commercial MC--dis MC--cap Bad Debt Charity 2012 36 14 9 35 0 3 3 2013 37 15 7 35 0 3 3 2014 38 16 5 35 0 3 3 2015 39 17 3 29 6 4 2 Table IV-C 2016 Charges per Discharge Per Discharge/Visit Acute SNF Rehab Home Health Emergency Outpatient Hays $19,200 10,400 20,000 500 1,600 400 St. Teresa $19,000 10,400 19,000 480 1,500 360 2016 40 18 2 28 6 3 3 Table V Radiology Department Procedures Procedure Tech Minutes Supply Expense Machine Minutes 2017 Volume Radiology Chest 2-view Chest 4-view Hand Arm Foot Leg Flouroscopy 14 28 05 10 05 10 30 10 20 05 10 05 10 30 10 10 05 05 05 05 15 20,000 15,000 7,000 4,000 1,000 6,000 3,000 Ultrasound Abdomen Other 15 10 10 10 10 10 5,000 5,622 Nuclear Medicine Scan 60 30 30 2,000 CT Head Head Body Body 30 60 30 60 50 75 75 100 30 45 30 45 200 300 400 500 w/o contrast w contrast w/o contrast w contrast Table VI-A Salary Survey of Area Hospitals Average Hourly Rates (without benefits), December, 2016 Position Head Nurse Staff RN Staff LPN Nursing Assistant Lab Tech Rad Tech Food Server Housekeeper Accountant Clerk Hays St. Teresa $38.00 33.50 26.00 20.70 32.00 28.00 18.40 18.40 30.00 21.00 $35.00 32.00 25.00 18.00 30.00 25.00 15.00 15.00 15.00 10.50 Table VI-B Hays County IDS Staffing as of December 31, 2016 Department Administration Medical Records Dietary Housekeeping Laundry Physical Plant Nursing** Laboratory Radiology Respiratory Therapy Physical Therapy Emergency Department Physicians KG/EEG *contract **90% RN's, 10% clerks FTE's 50 9 35 25 * 9 365 16 9 5 * * 1 Table VII San Marcos City and County Ad Valorem/Property Tax Schedule per $100 assessed value Aquifer County City ISD Special Roads Project Upper Hays River Watershed state sales tax .00981 .35510 .47000 1.23554 .06010 .02000 8.25%