Case $7-53($Algo$)$ Break$-$Even Analysis; Hospital CVP Relationships $($LO $7-1,7-4)$

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 year ended June $30,20$x$1$:

$\backslash$table$[[$Costs$,$Patient Days $($variable$),$Bed Capacity $($fixed$)],[$Dietary$,$$ $1,284,000,0],[$Janitorial$,0,$$ $75,700],[$Laundry$,642,000,0],[$Laboratory$,963,000,0],[$Pharmacy$,749,000,0],[$Repairs and maintenance,,$45,200],[$General and administrative,$0,1,480,500],[$Rent$,,1,644,400],[$Billings and collections,$642,000,],[$Total$,$$ $4,280,000,$$ $3,245,800]]$

During the year ended June $30,20$x$1,$ Pediatrics charged each patient an average of $$414$ per day, had a capacity of $60$ beds, and had revenue of $$8\mathrm{.}28$ million for $365$ days. In addition, Pediatrics directly employed personnel with the following annual salary costs per employee: supervising nurses, $$26,900$; nurses, $$21,900$; and aides, $$9,380.$

Delaware Medical Center has the following minimum departmental personnel requirements, based on total annual patient days:

Supervising

EX $11-28($Algo$)$ Construct a Flexible Overhead Budget; Hospital $($LO $11-1,11-2)$

The controller for Rainbow Children's Hospital, located in Munich, Germany, estimates that the hospital uses $26$ kilowatt$-$hours of electricity per patient$-$day, and that the electric rate will be $0\mathrm{.}14$ euro per kilowatt$-$hour. The hospital$-$also pays a fixed monthly charge of $2,100$ euros to the electric utility to rent emergency backup electric generators.

Required:

Construct a flexible budget for the hospital's electricity costs using each of the following techniques.

Formula flexible budget.

Columnar flexible budget for $31,000,41,000$ and $51,000$ patient$-$days of activity.

Complete this question by entering your answers in the tabs below.

Required $2$

Columnar flexible budget for $31,000,41,000$ and $51,000$ patient$-$days of activity.

Pationt nave

EX $11-28($Algo$)$ Construct a Flexible Overhead Budget; Hospital $($LO $11-1,11-2)$

The controller for Rainbow Children's Hospital, located in Munich, Germany, estimates that the hospital uses $26$ kilowatt$-$hours of electricity per patient$-$day, and that the electric rate will be $0\mathrm{.}14$ euro per kilowatt$-$hour. The hospital also pays a fixed monthly charge of $2,100$ euros to the electric utility to rent emergency backup electric generators.

Required:

Construct a flexible budget for the hospital's electricity costs using each of the following techniques.

Formula flexible budget.

Columnar flexible budget for $31,000,41,000$ and $51,000$ patient$-$days of activity.

Complete this question by entering your answers in the tabs below.

Columnar flexible budget for $31,000,41,000$ and $51,000$ patient$-$days of activity.

Patient nave