The controller for Rainbow Childrens Hospital, located in Munich, Germany, estimates that the hospital uses 30 kilowatt-hours of electricity per patient-day, and that the electric rate will be .10 euro per kilowatt-hour. The hospital also pays a fixed monthly charge of 1,000 euros to the electric utility to rent emergency backup electric generators.

Required:

Construct a flexible budget for the hospitals electricity costs using each of the following techniques.

Formula flexible budget.

Columnar flexible budget for 30,000, 40,000 and 50,000 patient-days of activity.

The controller for Rainbow Childrens Hospital, located in Munich, Germany, estimates that the hospital uses 30 kilowatt-hours of electricity per patient-day, and that the electric rate will be .10 euro per kilowatt-hour. The hospital also pays a fixed monthly charge of 1,000 euros to the electric utility to rent emergency backup electric generators.

Required:

Construct a flexible budget for the hospitals electricity costs using each of the following techniques.

Formula flexible budget.

Columnar flexible budget for 30,000, 40,000 and 50,000 patient-days of activity.

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

Required 1

Required 2

Formula flexible budget.

Total budgeted monthly overhead cost	=	Budgeted variable overhead cost per activity unit	x	Total activity units	+	Bugeted fixed overhead cost per month
			x	patient days	+

Columnar flexible budget for 30,000, 40,000 and 50,000 patient-days of activity.

Patient Days
	30,000	40,000	50,000
Variable electricity cost
Fixed electricity cost
Total electricity cost