__PRESENT

The controller for Rainbow Children's 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 0.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 hospital's electricity costs using each of the following techniques. 1. Formula flexible budget. 2. 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 Total activity units + Bugeted fixed overhead cost per month x patient days + The controller for Rainbow Children's 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 0.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 hospital's electricity costs using each of the following techniques. 1. Formula flexible budget. 2. 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 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