Parts 1 & 2

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