Please answer question number 2, my dead line is 8pm tonight It is December, 2016, and you have just accepted the CFO position at Hays County Inte rated Delivery System (IDS)[hereinafter referred to as Coun You will be reporting to Mr. Salter, County's chief exec tive officer, a retired schoolteacher who was hired last year. Alo reporting to Mr. Salter are Mr. Wannabe, County's chief oper ting officer, Dr. Spok, County's medical director, and Ms. P tty Care, County's director of nursing. When announcing your app intment, Mr. Salter stated that your primary objective in the co ing year (2017) would be to reverse the ominous financial trend tha began in 2015 with an operating loss and continued in 2016. Previous operating losses were funded with investment income (nvestment income was $200,000 in 2016) from unrestricted net as ets; however, your board recently passed a resolution disconti uing that practice and restricting investment income to capital e penditures.

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-for profit 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 0 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, SO 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) maintain expenses at 2016 levels after adjusting for volumes and mandated expenditures identified in earlier steps;

2) 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);

3) cut expenses (from expense scenario #1) in order to break-even in 2017;

4) cut expenses (from expense scenario #1) in order to break even in 2017 and recover FY 2012 losses.

11) 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.

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.

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. PersonalMs. 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. MaterialsMr. Materials, materials manager, reports the followinginformation to you.

I am projecting a 3% increase in supply and food prices for 2017 and a 5% increase in all other prices.

Current Assets

Hays County IDS Balance Sheet as of December 31, 2015Assets

2015

Accounts receivable less	allowances	11,250,000
Inventories at cost		3,368,000
Other current assets		992,500
Total Current	Assets	16,889,750

Cash and cash equivalents Marketable securities

$ 178,750

1,100,500

Land and improvements	3,250,000
Buildings	36,485,750
Fixed equipment	8,063,250
Moveable equipment	4,466,750

Property, Plant & Equipment Less accumulated depreciation

Total Property, Plant & Equipment

TOTAL ASSETS

Current Liabilities

Current portion of long-term debt Accounts payable & accrued expenses

Estimated amounts due to third-party payers Other current liabilities

Total Current Liabilities Long-term debt, net of current portion

TOTAL LIABILITIES

Net Assets

52,265,750

(18,080,750)

34,185,000

$ 51,074,750

$ 2,151,000

5,400,000

1,423,750

1,500,000

10,474,750

37,000,000

47,474,750

Unrestricted	2,100,000
Temporarily restricted	1,000,000
Permanently restricted	500,000
TOTAL NET ASSETS	2,500,000
TOTAL LIABILITIES AND NET ASSETS	$51,074,750

Hays County IDS Actual Expenses through December 31, 2015

Wages, Taxes, Benefits	$ 84,000,000
Professional Fees & Commissions	6,000,000
Drugs	7,000,000
Medical and Other Supplies	6,000,000
Food	3,000,000
Purchased Services	3,000,000
Repairs & Maintenance		6,000,000
Utilities		4,000,000
Interest		8,019,000
Depreciation		11,734,120
TOTAL	EXPENSES	$ 138,753,120

Selected Industry Financial & Productivity Ratios 100-199 Beds

Financial Ratios Bobcat

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

Salaries per Adjusted Discharge Nursing service

RN's as a percent of total nursing

LPN's as a percent of total nursing

20,000

10,000

8,551

3,127

32.20

21.70

Full-time equivalent employees Per occupied bed

Salary per FTE

4.90

57,392

Hays County IDS Discharges

Service(LOS) 2012 2013 2014 2015 2016

Acute(4)	8,000	7,500	7,000	7,000	7,000
SNF(l3)	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

	2012	2013	2014	2015	2016
Medicare	36	37	38	39	40
Medicaid	14	15	16	17	18
Commercial	9	7	5	3	2
MC--dis	35	35	35	29	28
MC--cap	0	0	0	6	6
Bad Debt	3	3	3	4	3
Charity	3	3	3	2	3

Table IV-C

2016 Charges per Discharge

Per Discharge/Visit Hays St. Teresa

Acute	$19,200	$19,000
SNF	10,400	10,400
Rehab	20,000	19,000
Home Health	500	480
Emergency	1,600	1,500
Outpatient	400	360

Radiology Department Procedures

Tech Minutes	Supply Exeense	Machine Minutes	2017 Volume
14	10	10	20,000
28	20	10	15,000
05	05	05	7,000
10	10	05	4,000
05	05	05	1,000
10	10	05	6,000
30	30	15	3,000
15	10	10	5,000
10	10	10	5,622
60	30	30	2,000

Procedure

Radiology Chest 2-view Chest 4-view Hand

Arm Foot Leg

Flouroscopy

Ultrasound Abdomen Other

Nuclear Medicine Scan

w/o contrast	30	50	30	200
w contrast	60	75	45	300
w/o contrast	30	75	30	400
w contrast	60	100	45	500

CT

Head Head Body Body

Table VI-A

Salary Survey of Area Hospitals

Average Hourly Rates (without benefits), December, 2016

Position	Hays	St. Teresa
Head Nurse	$38.00	$35.00
Staff RN	33.50	32.00
Staff LPN	26.00	25.00
Nursing Assistant	20.70	18.00
Lab Tech	32.00	30.00
Rad Tech	28.00	25.00
Food Server	18.40	15.00
Housekeeper	18.40	15.00
Accountant	30.00	15.00
Clerk	21.00	10.50

Table VI-B

Hays County IDS Staffing

as of December 31, 2016

Department

Administration Medical Records Dietary Housekeeping Laundry Physical Plant

FTE's

50

9

35

25

*

9

Nursing** 365

Laboratory 16

Radiology 9

Respiratory Therapy 5

Physical Therapy *

Emergency Department Physicians *

KG/EEG 1

*contract

**90% RN's, 10% clerks

Table VII

San Marcos City and County Ad Valorem/Property Tax Schedule per $100 assessed value

Aquifer County City ISO

Special Roads Project

Upper Hays River Watershed

.00981

.35510

.47000

1. 23554

.06010

.02000

state sales tax 8.25%

please answer question number two, my dead line is today at 8pm