Question: 1 . Calculate the Unit and Package Contribution Margin. Prepare in Excel with proper headings, titles and formulas. Sabrina: All this sounds reasonable, but why

1. Calculate the Unit and Package Contribution Margin. Prepare in Excel with proper headings, titles and formulas. Sabrina: "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 $30,000 per
year. Private insurance policies will pay roughly $46,000 per year. We can charge up
to about $65,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 virtually assured that we will operate at capacity."
Sabrina: "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 him
or her. 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 evicting them-no matter how high our costs go."
Sabrina: "OK, it looks as if we have some hard work ahead of us to decide whether or
not to get into this line of business."
2. What is the mark-up 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 mark-up were used? For a Lifestyle Care patient? (Assume in both cases that occupancy is at 80 percent of capacity.
3. What is the payback period for the new addition?
Sabrina: "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 alternatives. Here's a listing."
\table[[Basic Care,Lifestyle Care],[Construction,$1,500,000,Construction,$2,000,000],[Annual operating expenses:,,Annual operating expenses:,],[Staff:,,Staff:,],[RNs (3\times $30,000),90,000,RNs (3\times $30,000),90,000],[LPNs (6\times $22,000),132,000,LPNs (6\times $22,000),132,000],[Aides (6\times $20,000),120,000,Aides (6\times $20,000),120,000],[Cooks (2\times $15,000),30,000,\table[[Physical and recreational],[therapists (2\times $25,000)]],50,000],[Janitors (2\times $18,000),36,000,Cooks (1.5\times $15,000),22,500],[Other*(60% variable),300,000,Janitors (2\times $18,000),36,000],[Debt service,150,000,Other (60% variable),360,000],[Depreciation (over 20 years),75,000,Debt service,200,000],[,,Depreciation (over 20 years),100,000]]
*Other includes supplies, utilities, food, and so on.
"In both cases, total administrative costs for Golden Care would increase by $30,000 per year. This seems high, but the increased legal and insurance requirements will add signif
 1. Calculate the Unit and Package Contribution Margin. Prepare in Excel

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!