Check my work 5 The controller for Rainbow Children's Hospital, located in Munich, Germany, estimates that the hospitales 30 kilowatt-hours of electricity per patient.day, and that the electric rate will be 0.10 euro per kilowatt hour The hospital also paysafoed monthly charge of 1000 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 Pro Formula flexible budget. Total budgeted monthly overhead cost Budgeted variable overhead cost per activity unit Total activity X 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 Required