The controller for Rainbow Children's Hospital, located in Munich, Germany, estimates that the hospital uses 34 kilowatt-hours of electricity per patient-day, and that the electric rate will be 0.22 euro per kilowatt-hour. The hospital also pays a fixed monthly charge of 2,900 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 39,000, 49,000 and 59,000 patient-days of activity. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Formula flexible budget. (Round per unit to 2 decimal places.) Total budgeted Budgeted variable monthly Bugeted fixed Total activity overhead cost per units overhead cost overhead cost activity unit per month x patient days The controller for Rainbow Children's Hospital, located in Munich, Germany, estimates that the hospital uses 34 kilowatt-hours of electricity per patient-day, and that the electric rate will be 0.22 euro per kilowatt-hour. The hospital also pays a fixed monthly charge of 2,900 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 39,000, 49,000 and 59,000 patient-days of activity. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Formula flexible budget. (Round per unit to 2 decimal places.) Total budgeted Budgeted variable monthly Bugeted fixed = overhead cost per Total activity units overhead cost overhead cost activity umit per month x patient days Required Required 2 > Required 1 Required 2 Columnar flexible budget for 39,000, 49,000 and 59,000 patient-days of activity. Patient Days 49,000 59,000 Variable electricity cost Fixed electricity cost Total electricity cost 39,000