The controller for Rainbow Children's Hospital, located in Munich, Germany, estimates that the hospital uses 38...

 

Transcribed Image Text:

The controller for Rainbow Children's Hospital, located in Munich, Germany, estimates that the hospital uses 38 kilowatt-hours of electricity per patient-day, and that the electric rate will be 0.26 euro per kilowatt-hour. The hospital also pays a fixed monthly charge of 3,300 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. 1. Formula flexible budget. 2. Columnar flexible budget for 43,000, 53,000 and 63,000 patient-days of activity. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Columnar flexible budget for 43,000, 53,000 and 63,000 patient-days of activity. Variable electricity cost Fixed electricity cost Total electricity cost Patient Days 43,000 53,000 $3,000 The controller for Rainbow Children's Hospital, located in Munich, Germany, estimates that the hospital uses 38 kilowatt-hours of electricity per patient-day, and that the electric rate will be 0.26 euro per kilowatt-hour. The hospital also pays a fixed monthly charge of 3,300 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. 1. Formula flexible budget. 2. Columnar flexible budget for 43,000, 53,000 and 63,000 patient-days of activity. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Columnar flexible budget for 43,000, 53,000 and 63,000 patient-days of activity. Variable electricity cost Fixed electricity cost Total electricity cost Patient Days 43,000 53,000 $3,000