Question

In: Accounting

Atlantic City Hospital owns and operates a local hospital. It also leases unused space, including beds...

Atlantic City Hospital owns and operates a local hospital. It also leases unused space, including beds to other businesses that offer related services such as Physical Therapy and Long-Term Care. Atlantic City charges each company for common services provided such as laboratory and xray services. The hospital charged the following costs to Long Term Care for the year ended June 30,2018:

Variable Expenses Fixed Expense
Food Service $560,000.00
Xray Service 71000
Laundry $250,000.00
Lab costs $430,000.00
Pharmacy Services $310,000.00 Variable Expenses are charged
Repairs and Maintenance 33000 for patient days
General and admistrative 1300000
Rent 1540000 Fixed expenses are charged
Bill and collections $250,000.00 based on bed capacity leased
Total $1,800,000.00 2944000

During the year ended June 30, 2018, Long Term Care charged each patient an average of $500 per day, had availability of 80 beds and had revenue of $6 million for 365 days. In addition, Long Term Care directly employed personnel with the following annual salary costs per employee: supervising nurses $26625; nurses $20,200 and cna's $8500.The hospital has the following minimum departmental personnel requirements, based on total annual patient days:

Annual Patient Days Nurse aid (CNA) Nurses Supervisor Nurses
Up to 20,000 20 10 4
20,001 to 25,000 25 14 5
25,001 to 30,000 31 16 5

Long Term care always employs only the minimum number of supervising nurses and nurses but operates with 5 additional aides than the minimum required by the hospital. Salaries of supervising nurses, nurses and CNA's are fixed within ranges of annual patient days.

Long Term care operated at 100% capacity on 80 days during the year ended June 30, 2018. The hospital estimates that on the 80 days, Long Term care could have filled another 20 beds above capacity. The hospital has an additional 20 beds available for lease for the year ending June 30, 2019. The additional leased beds would increase Long Term care's fixed charges based on bed capacity. (ignore income taxes).

1. Calculate the break-even patient days for Long Term care for the year ending June 30, 2019, assuming 20 extra beds are not leased. Assume all other data and rates from June 30, 2018 remain the same.

2. Determine the net increase or decrease in Long term care's earnings for the year ending June 30, 2019 from the additional beds if Long Term care leased this extra capacity from Atlantic City Hospital. Create a schedule of Long Term care's increase in revenue and increase in costs for the year. The number of additional patient days is based on using the additional beds when at max capacity. Assume patient demand, revenue, variable and fixed rates from June 30,2018 remain the same.

3. Should Long term care lease the additional 20 beds for the year ending June 30, 2019?

4. If max capacity were to increase and the additional beds were needed for more than 80 days at what number of days would they willing to lease the additional 20 beds? Calculate the break-even (patient days) for Long Term care to lease the additional beds. Only consider the revenue and expenses calculated in question #2.

Solutions

Expert Solution

1)
Atlantic City Hospital
COMPUTATION OF BREAK-EVEN POINT
INPATIENT-DAYS: LONG TERM CARE
FOR THE YEAR ENDED JUNE 30, 2019
Total fixed costs:
Medical center charges $                          2,944,000.00
Supervising nurses ($26625 x 4) $                             106,500.00
Nurses (20,200 x 10) $                             202,000.00
Aids (8500 x 20) $                             170,000.00
Total fixed costs $                          3,422,500.00
Contribution margin per patient-day
Revenue per patient-day $500.00
Variable cost per patient-day
($6,000,000 ÷ $500 = 12,000 patient-days)
($1,800,000 ÷ 12,000 patient-days) $150.00
Contribution margin per patient-day $350.00
Break-even point inpatient-day = Fixed Cost/ Contribution Margin per Patient day 9778.57 Patient Days
2)
Atlantic City Hospital
COMPUTATION OF LOSS FROM RENTAL OF ADDITIONAL 20 BEDS: LONG TERM CARE
FOR THE YEAR ENDED JUNE 30, 2019
Increase in revenue ((20 additional beds x 90 days x $500 charge per day) $           900,000.00
Increase in expenses:
Variable charges by medical center(20 additional beds x 90 days x $150 per day) $                             270,000.00
Fixed Cost = $3,422,500/80 beds ) x 20 beds $                             855,625.00
Salaries (12,000 patient-days before additional 20 beds + 20 additional beds x 90 days = 13,800, which does not exceed 22,000 patient-days; therefore, no additional personnel are required) 0
Total increase in expenses $        1,125,625.00
Net change in earnings from lease of additional 20 beds $          (225,625.00)
4)
Contribution margin per patient-day
Revenue per patient-day $500.00
Variable cost per patient-day
($6,000,000 ÷ $500 = 12,000 patient-days)
($1,800,000 ÷ 12,000 patient-days) $150.00
Contribution margin per patient-day $350.00
Fixed cost = 855625 +  3,422,500 $                          4,278,125.00
Break-even point inpatient-day = Fixed Cost/ Contribution Margin per Patient day                                   12,223.21 Patient Days

Related Solutions

Delaware Medical Center operates a general hospital. The medical center also rents space and beds to...
Delaware Medical Center operates a general hospital. The medical center also rents space and beds to separately owned entities rendering specialized services, such as Pediatrics and Psychiatric Care. Delaware charges each separate entity for common services, such as patients’ meals and laundry, and for administrative services, such as billings and collections. Space and bed rentals are fixed charges for the year, based on bed capacity rented to each entity. Delaware Medical Center charged the following costs to Pediatrics for the...
James Polk Hospital has currently unused space in its lobby. In three years, the space will be required for a planned expansion, but the hospital is considering uses of the space until then.
  James Polk Hospital has currently unused space in its lobby. In three years, the space will be required for a planned expansion, but the hospital is considering uses of the space until then. The hospital has decided that it wants to purchase at least one and maybe two fast food franchises, to take advantage of the high volume of patients and visitors that walk through the lobby all day long. The hospital plans to purchase the franchise(s), operate them...
Helmert Hospital operates a general hospital but rents space to separately owned entities rendering specialized services...
Helmert Hospital operates a general hospital but rents space to separately owned entities rendering specialized services such as pediatrics and psychiatry.   Helmert Hospital charges each separate entity for patients’ services (Meals and laundry) and for administrative services (billings and collections). Space and bed rentals are fixed charges for the year, based on bed capacity rented to each entity.   Helmert Hospital charged the following costs to Pediatrics for the year ended June 30, 2018.   Patient Services Bed Capacity (Variable cost) (Fixed...
Toy City (TC) is a toy store that operates in leased space in a shopping center....
Toy City (TC) is a toy store that operates in leased space in a shopping center. The contents of TC are insured for $200,000 under a building and personal property coverage form (BPP) with a value reporting form attached. A monthly reporting requirement applies. What dollar amount will be paid in each of the following situations? Treat each situation separately. Show your calculations and disregard any deductibles that might apply a. Three weeks after the first report was due, but...
The City of Ashville operates an internal service fund to provide garage space and repairs for...
The City of Ashville operates an internal service fund to provide garage space and repairs for all city-owned-and-operated vehicles. The Central Garage Fund was established by a contribution of $300,000 from the General Fund on July 1, 2015, at which time the land and building were acquired. The post-closing trial balance at June 30, 2016, was as follows: Debits Credits Cash $ 110,000 Due from Other Funds 9,000 Inventory of Supplies 90,000 Land 50,000 Building 250,000 Allowance for Depreciation—Building $...
The City of Ashville operates an internal service fund to provide garage space and repairs for...
The City of Ashville operates an internal service fund to provide garage space and repairs for all city-owned-and-operated vehicles. The Central Garage Fund’s preclosing trial balance for the current fiscal year is as follows: Debits Credits Cash $ 110,000 Due from Other Funds 9,000 Inventory of Supplies 90,000 Land 50,000 Building 250,000 Allowance for Depreciation—Building $ 20,000 Machinery and Equipment 65,000 Allowance for Depreciation—Machinery and Equipment 12,000 Vouchers Payable 31,000 Net Position—Net Investment in Capital Assets 333,000 Net Position—Unrestricted 178,000...
The City of Ashville operates an internal service fund to provide garage space and repairs for...
The City of Ashville operates an internal service fund to provide garage space and repairs for all city-owned-and-operated vehicles. The Central Garage Fund’s preclosing trial balance for the current fiscal year is as follows: Debits Credits Cash $ 121,100 Due from Other Funds 10,200 Inventory of Supplies 99,000 Land 54,500 Building 275,500 Allowance for Depreciation—Building $ 22,100 Machinery and Equipment 71,900 Allowance for Depreciation—Machinery and Equipment 13,200 Vouchers Payable 34,000 Net Position—Net Investment in Capital Assets 366,600 Net Position—Unrestricted 196,300...
Jonathan owns and operates a deli restaurant in New York City. It is a family business...
Jonathan owns and operates a deli restaurant in New York City. It is a family business and all of the employees are family members. Jonathan wants to establish a retirement plan so he can save for retirement and the retirement of his employees on a tax deferred basis. Jonathan only wants to contribute to the plan when the business makes a profit. He is happy to contribute on behalf of his employees if the business is doing well. He wants...
ll system owns and operates a hospital and employees primary care physicians, general surgeons, and oncologist....
ll system owns and operates a hospital and employees primary care physicians, general surgeons, and oncologist. The hospital purchased a surgical practice in 2012. Part of the purchase of the Proctors included the purchase of the electronic medical record system that was a certified EHR. In January 2014, the hospital transition the primary care physicians, surgeons, and the radiologist in the hospital to a new certified electronic health record, the implementation of which was completed 10 months later in October...
Pacific Healthcare is an investor-owned hospital chain that owns and operates nine hospitals in Washington, Oregon,...
Pacific Healthcare is an investor-owned hospital chain that owns and operates nine hospitals in Washington, Oregon, and Northern California. You are a recent graduate of a prominent healthcare administration program and have just been hired by Washington Medical Center, Pacific’s largest hospital. Like all new management personnel, you must undergo three months of intensive training at the system level before joining the hospital. You begin by examining Pacific’s annual report to get some basic financial data. You search Yahoo! Finance,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT