5. What is the payback period for the new addition?

Thank You!!

R --- DATA ANALYTICS Elena Chavez is founder and CEO of Willowbank, Inc., which owns and operates several assisted-living facilities. The facilities are apartment-style buildings with 25 to 30 one-or two-bedroom apartments. While each apartment has its own complete kitchen, every building offers communal dining options and an on-site nurse who is available 24 hours a day. Residents can choose monthly meal options that include one or two meals per day in the dining room. Residents who require nursing services (e.g., blood pressure monitoring and injections) can receive those services from the nurse. However, Willowbank facilities are not nursing homes, all residents are ambulatory, and custodial care is not an option. In the five years it has been in operation, the company has expanded from one facility to five, located in southwestern cities. The income statement for last year follows. Willowbank, Inc. Income Statement for Last Year Revenue $11,520,000 Cost of services 8,064,000 Gross profit $ 3,456,000 Marketing and administrative expenses 1,550,000 Operating income $ 1,906,000 Elena originally got into the business because she had trouble finding adequate facilities for her mother. The concept worked well, and income over the past five years had grown nicely at 20 percent per year. However, Elena sensed clouds on the horizon. She knew that the pop- ulation was aging and that her current clients would be moving to more traditional forms of nursing care. As a result, Elena wanted to consider adding one or more nursing homes to Willowbank. These nursing homes would be staffed around the clock with RNs and LPNs. The residents would likely have more severe medical problems and would be confined to beds or wheelchairs. Elena knew that quality care of this type was needed. So, she contacted Peter Merrion, her marketing manager, and Bernadette Velarde, her accountant, for a brainstorm- ing session. Peter: "Elena, I really like the concept. As you know, several of our facilities have faced seeing their long-term residents move out to local nursing homes. Not only are these homes of lower quality than what we could provide, but losing a resident is heartrending for the staff, as well as for the remaining residents. I like the idea of providing a transition from less care to more." Bernadette: "I agree with you, Peter. But let's not forget the differences between assisted-living and full-time, nursing-home-type care. Our expenses will really increase." Elena: "That's why I wanted to talk with both of you. As you know, Willowbank's mission statement emphasizes the need to make a profit. We can't continue to serve our residents and provide high-quality care if we don't make enough money to pay our staff a living wage and earn enough of a profit to smooth over the rough patches and continue to improve our busi- ness. Could the two of you look into this idea, and get back to me in a week or so?" Throughout the following week, the three communicated by e-mail. By the end of the week, a number of possibilities had surfaced, and these were summarized in a message from Bernadette to the others. MESSAGE: TO: elena.chavez@willowbank.com, peter.merrion@willowbank.com FROM: bernadette.velarde@willowbank.com I've compiled the ideas from all of our e-mails into the following list. This may be a good start- ing point for our meeting tomorrow. 1. Buy an existing nursing home in one of our current locations. 2. Buy an existing nursing home in another city. 3. Build a new nursing home facility in one of our current locations. 4. Build a new nursing home facility in another city. 5. Build a wing on to one of our existing facilities. The Mesa Ridge facility has sufficient open land for an addition, The next day, Elena, Peter, and Bernadette met again in Elena's office. Elena: "I didn't realize there were so many possibilities. Are we going to have to work up numbers on each of them?" Bernadette: "No, I think we can eliminate a few of them pretty quickly. For example, build- ing a new facility would cost more than the other options, and it would involve the most risk. Peter: "I agree, and I also think we might eliminate the purchase of an existing nursing home for the same reasons. Also, existing homes would not give us the option of building a facility that is state of the art and meets our needs, and it would lock us into a preexisting patient mix." Elena: "I like that thinking. Let's restrict our attention to Option 5." Bernadette: "I thought you might like that option, so Peter and I sketched out two alternatives for an extension of the Mesa Ridge building. We call the alternatives Basic Care and Lifestyle Care." Peter: "There are different markets for each type of care. If we want to concentrate on Medi- care and Medicaid patients, the reimbursement is lower, and we would want to offer the Basic Care option. Private insurance and private-pay patients could afford more services; if we are marketing to these patients, we could offer the Lifestyle Care option. Both alternatives provide high-quality nursing care. Basic Care concentrates on the quality nursing and maintenance activities. For example, the addition would have 25 double rooms, two nursing stations, two recreation rooms, a treatment room, and an office. The Lifestyle Care option adds physical and recreational therapy with a specially equipped gym and pool. That addition would have 30 sin- gle rooms, two nursing stations, a recreation room, a swimming pool, a hydrotherapy spa and gym, a treatment room, and an office. In each case, there would be cable TV and telephone hookups in each room and a buffer area between the nursing home and the apartments." Elena: "Why the buffer area? Won't that add unnecessary cost?" Peter: "It adds cost, but it will be well worth it. Remember that the nursing home patients are different from the apartment residents. Some of the patients will have advanced demen- tia. We'll lose apartment residents in a hurry if they have to be reminded every day of what might be in store for them later on." Elena: "I see your point. Bernadette, what will these two plans cost? I'll tell you right now that I like the Lifestyle Care option better. It fits with our history of doing whatever we can to make life better for our residents." Bernadette: "I've checked into the costs of putting on a new wing and operating both alter- natives. Here's a listing." Basic Care Lifestyle Care Construction $2,800,000 Construction $4,000,000 Annual operating expenses: Annual operating expenses: Staff: RNS (3 X 550,000) $ 150,000 RNS (3 X 550,000) $ 150,000 LPNs (6 X $30,000) $ 180,000 LPNs (6 X 530,000) $ 180,000 Aides (6 X $24,000) $ 144,000 Aides (6 X $30,000) $ 144,000 Staff: alt Making the Connection Basic Carewell Lifestyle Carebberger Cooks (2 x $20,000) $ 40,000 Cooks (1.5 X $20,000) $ 30,000 Janitors (2 x $22,000) $ 44,000 Janitors (2 X $22,000) $ 44,000 Physical and recreational therapists (2 $35,000) $ 70,000 Other* (60% variable) $400,000 Other* (60% variable) $480,000 Debt service $280,000 Debt service $400,000 Depreciation (over 20 years) $140,000 Depreciation (over 20 years) $200,000 *Other includes supplies, utilities, food, and so on. bit "In both cases, total administrative costs for Willowbank would increase by $60,000 per year. This seems high, but the increased legal and insurance requirements will add signifi- cantly more paperwork and accounting." Elena: "All this sounds reasonable, but why is reimbursement such an important factor?" Peter: "Well, if you admit Medicaid patients, the state will reimburse at most $60,000 per year. Private insurance policies will pay roughly $82,000 per year. We can charge up to about $120,000 for private patients, but this type of care is so expensive that many of these patients exhaust their funds and go on Medicaid. The nice aspect of Medicaid is that we can be virtu- ally assured that we will operate at capacity." Elena: "Can we cross that bridge when we come to it?" Peter: "No, not really. Once the patient is a resident of our facility, it is hard to evict them. Also, while it is legal to force patients out before they go on Medicaid and to refuse to accept Medicaid patients, once we do accept Medicaid patients, we are prevented by law from evict- 3. Calculate the break-even number of patients (in total and for each type of ment) for each of the following scenarios (for fractional break-even amount, round up to the nearest higher whole number): a. Basic Care option, 20 percent private insurance, and 80 percent Medicaid b. Basic Care option, no Medicaid c. Lifestyle Care option, no Medicaid, 75 percent private insurance, and 25 percent private pay d. Lifestyle Care option, all insurance reimbursement What is the markup percent of cost of services charged on the assisted-living expenses? What would the price per month for a Basic Care patient be if the same markup were used? For a Lifestyle Care patient? (Assume in both cases that occupancy is at 80 percent of capacity.) 3456 47857: 42.86% 4. R --- DATA ANALYTICS Elena Chavez is founder and CEO of Willowbank, Inc., which owns and operates several assisted-living facilities. The facilities are apartment-style buildings with 25 to 30 one-or two-bedroom apartments. While each apartment has its own complete kitchen, every building offers communal dining options and an on-site nurse who is available 24 hours a day. Residents can choose monthly meal options that include one or two meals per day in the dining room. Residents who require nursing services (e.g., blood pressure monitoring and injections) can receive those services from the nurse. However, Willowbank facilities are not nursing homes, all residents are ambulatory, and custodial care is not an option. In the five years it has been in operation, the company has expanded from one facility to five, located in southwestern cities. The income statement for last year follows. Willowbank, Inc. Income Statement for Last Year Revenue $11,520,000 Cost of services 8,064,000 Gross profit $ 3,456,000 Marketing and administrative expenses 1,550,000 Operating income $ 1,906,000 Elena originally got into the business because she had trouble finding adequate facilities for her mother. The concept worked well, and income over the past five years had grown nicely at 20 percent per year. However, Elena sensed clouds on the horizon. She knew that the pop- ulation was aging and that her current clients would be moving to more traditional forms of nursing care. As a result, Elena wanted to consider adding one or more nursing homes to Willowbank. These nursing homes would be staffed around the clock with RNs and LPNs. The residents would likely have more severe medical problems and would be confined to beds or wheelchairs. Elena knew that quality care of this type was needed. So, she contacted Peter Merrion, her marketing manager, and Bernadette Velarde, her accountant, for a brainstorm- ing session. Peter: "Elena, I really like the concept. As you know, several of our facilities have faced seeing their long-term residents move out to local nursing homes. Not only are these homes of lower quality than what we could provide, but losing a resident is heartrending for the staff, as well as for the remaining residents. I like the idea of providing a transition from less care to more." Bernadette: "I agree with you, Peter. But let's not forget the differences between assisted-living and full-time, nursing-home-type care. Our expenses will really increase." Elena: "That's why I wanted to talk with both of you. As you know, Willowbank's mission statement emphasizes the need to make a profit. We can't continue to serve our residents and provide high-quality care if we don't make enough money to pay our staff a living wage and earn enough of a profit to smooth over the rough patches and continue to improve our busi- ness. Could the two of you look into this idea, and get back to me in a week or so?" Throughout the following week, the three communicated by e-mail. By the end of the week, a number of possibilities had surfaced, and these were summarized in a message from Bernadette to the others. MESSAGE: TO: elena.chavez@willowbank.com, peter.merrion@willowbank.com FROM: bernadette.velarde@willowbank.com I've compiled the ideas from all of our e-mails into the following list. This may be a good start- ing point for our meeting tomorrow. 1. Buy an existing nursing home in one of our current locations. 2. Buy an existing nursing home in another city. 3. Build a new nursing home facility in one of our current locations. 4. Build a new nursing home facility in another city. 5. Build a wing on to one of our existing facilities. The Mesa Ridge facility has sufficient open land for an addition, The next day, Elena, Peter, and Bernadette met again in Elena's office. Elena: "I didn't realize there were so many possibilities. Are we going to have to work up numbers on each of them?" Bernadette: "No, I think we can eliminate a few of them pretty quickly. For example, build- ing a new facility would cost more than the other options, and it would involve the most risk. Peter: "I agree, and I also think we might eliminate the purchase of an existing nursing home for the same reasons. Also, existing homes would not give us the option of building a facility that is state of the art and meets our needs, and it would lock us into a preexisting patient mix." Elena: "I like that thinking. Let's restrict our attention to Option 5." Bernadette: "I thought you might like that option, so Peter and I sketched out two alternatives for an extension of the Mesa Ridge building. We call the alternatives Basic Care and Lifestyle Care." Peter: "There are different markets for each type of care. If we want to concentrate on Medi- care and Medicaid patients, the reimbursement is lower, and we would want to offer the Basic Care option. Private insurance and private-pay patients could afford more services; if we are marketing to these patients, we could offer the Lifestyle Care option. Both alternatives provide high-quality nursing care. Basic Care concentrates on the quality nursing and maintenance activities. For example, the addition would have 25 double rooms, two nursing stations, two recreation rooms, a treatment room, and an office. The Lifestyle Care option adds physical and recreational therapy with a specially equipped gym and pool. That addition would have 30 sin- gle rooms, two nursing stations, a recreation room, a swimming pool, a hydrotherapy spa and gym, a treatment room, and an office. In each case, there would be cable TV and telephone hookups in each room and a buffer area between the nursing home and the apartments." Elena: "Why the buffer area? Won't that add unnecessary cost?" Peter: "It adds cost, but it will be well worth it. Remember that the nursing home patients are different from the apartment residents. Some of the patients will have advanced demen- tia. We'll lose apartment residents in a hurry if they have to be reminded every day of what might be in store for them later on." Elena: "I see your point. Bernadette, what will these two plans cost? I'll tell you right now that I like the Lifestyle Care option better. It fits with our history of doing whatever we can to make life better for our residents." Bernadette: "I've checked into the costs of putting on a new wing and operating both alter- natives. Here's a listing." Basic Care Lifestyle Care Construction $2,800,000 Construction $4,000,000 Annual operating expenses: Annual operating expenses: Staff: RNS (3 X 550,000) $ 150,000 RNS (3 X 550,000) $ 150,000 LPNs (6 X $30,000) $ 180,000 LPNs (6 X 530,000) $ 180,000 Aides (6 X $24,000) $ 144,000 Aides (6 X $30,000) $ 144,000 Staff: alt Making the Connection Basic Carewell Lifestyle Carebberger Cooks (2 x $20,000) $ 40,000 Cooks (1.5 X $20,000) $ 30,000 Janitors (2 x $22,000) $ 44,000 Janitors (2 X $22,000) $ 44,000 Physical and recreational therapists (2 $35,000) $ 70,000 Other* (60% variable) $400,000 Other* (60% variable) $480,000 Debt service $280,000 Debt service $400,000 Depreciation (over 20 years) $140,000 Depreciation (over 20 years) $200,000 *Other includes supplies, utilities, food, and so on. bit "In both cases, total administrative costs for Willowbank would increase by $60,000 per year. This seems high, but the increased legal and insurance requirements will add signifi- cantly more paperwork and accounting." Elena: "All this sounds reasonable, but why is reimbursement such an important factor?" Peter: "Well, if you admit Medicaid patients, the state will reimburse at most $60,000 per year. Private insurance policies will pay roughly $82,000 per year. We can charge up to about $120,000 for private patients, but this type of care is so expensive that many of these patients exhaust their funds and go on Medicaid. The nice aspect of Medicaid is that we can be virtu- ally assured that we will operate at capacity." Elena: "Can we cross that bridge when we come to it?" Peter: "No, not really. Once the patient is a resident of our facility, it is hard to evict them. Also, while it is legal to force patients out before they go on Medicaid and to refuse to accept Medicaid patients, once we do accept Medicaid patients, we are prevented by law from evict- 3. Calculate the break-even number of patients (in total and for each type of ment) for each of the following scenarios (for fractional break-even amount, round up to the nearest higher whole number): a. Basic Care option, 20 percent private insurance, and 80 percent Medicaid b. Basic Care option, no Medicaid c. Lifestyle Care option, no Medicaid, 75 percent private insurance, and 25 percent private pay d. Lifestyle Care option, all insurance reimbursement What is the markup percent of cost of services charged on the assisted-living expenses? What would the price per month for a Basic Care patient be if the same markup were used? For a Lifestyle Care patient? (Assume in both cases that occupancy is at 80 percent of capacity.) 3456 47857: 42.86% 4