7 Exercise 11-28 Construct a Flexible Overhead Budget; Hospital (LO 11-1, 11-2) 0.75/1.2 points awarded The controller for Rainbow Children's Hospital, located in Munich, Germany, estimates that the hospital uses 27 kilowatt-hours of electricity per patient-day, and that the electric rate will be 0.15 euro per kilowatt-hour. The hospital also pays a fixed monthly charge of 2,200 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 32,000, 42,000 and 52,000 patient-days of activity. Scored Complete this question by entering your answers in the tabs below. Required 1 Required 2 Columnar flexible budget for 32,000, 42,000 and 52,000 patient-days of activity. Patient Days 32,000 4.800 2.200 7.000 42,000 5,300 XE 52,000 7.800 X Variable electricity cost Fixed electricity cost Total electricity cost 2,200 2.200 8,500 10.000