I need help with this break-even analysis question in the attached file.
Susquehanna Medical Center operates a general hospital in northern Pennsylvania. The medical center also rents space and beds separately owned entities rendering specialized services, such as Pediatrics and Psychiatric Care. Susquehanna 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. Susquehanna Medical Center charged the following costs to Pediatrics for the year ended June 30, 20x5.
Patient Days (Variable) Bed Capacity (fixed)
Dietary $720,000 ------
Janitorial ------ $84,000
Laundry 360,000 --------
Laboratory 540,000 --------
Pharmacy 420,000 --------
Repairs and maintenance ------ 36,000
General and administrative ------ 1,560,000
Rent ------ 1,800,000
Billings and collections 360,000 --------
Total $2,400,000 $3,480,000
During the year ended June 30, 20x5, Pediatrics charged each patient an average of $360 per day, had a capacity of 60 beds, and had revenue of $7.2 million for 365 days. In addition, Pediatrics directly employed personnel with the following annual salary costs per employee: supervising nurses, $30,000; nurses, $24,000; and aides, $10,800.
Susquehanna Medical Center has the following minimum departmental personnel requirements based on total annual budgeted patient days:
Annual Patient Days Supervising Nurses Nurses Aides
Up to 22,000 4 10 20
22,001 to 26,000 5 14 25
26,001 to 29,200 5 16 31
Pediatrics always employs only the minimum number of required personnel. Salaries of supervising nurses, nurses, and aides are therefore fixed within ranges of annual patient days.
Pediatrics operated at 100 percent capacity on 90 days during the year ended June 30, 20x5. Administrators estimate that on these 90 days, Pediatrics could have filled another 20 beds above capacity. Susquehanna Medical Center has an additional 20 beds for rent for the year ending June 30, 20x6. Such additional rental would increase Pediatrics' fixed charges based on bed capacity. ( In the following requirements, ignore income taxes.)
1. Calculate the minimum number of patient days required for Pediatrics to break even for the year ending June 30, 20x6, if additional 20 beds are not rented. Patient demand is unknown, but assume that revenue per patient day, cost per patient day, cost per bed, and salary rates will remain the same as for the year ended June 30, 20x5.
2. Assume that patient demand, revenue per patient day, cost per patient day, cost per bed, and salary rates for the year ending June 30, 20x6 remain the same as for the year ended June 30, 20x5. Prepare a schedule of Pediatrics' increase in revenues and increase in costs for the year ending June 30, 20x6. Determine the net increase or decrease in Pediatrics' earnings from the additional 20 beds if Pediatrics rents this extra capacity from Susquehanna Medical Center.
The solution has the breakeven analysis for a hospital.