The controller for Rainbow Childrens Hospital, located in Munich, Germany, estimates that the hospital uses 26 kilowatt-hours of electricity per patient-day, and that the electric rate will be 0.14 euro per kilowatt-hour. The hospital also pays a fixed monthly charge of 2,100 euros to the electric utility to rent emergency backup electric generators.

Required:

Construct a flexible budget for the hospitals electricity costs using each of the following techniques.

1. Formula flexible budget.

2.) Columnar flexible budget for 31,000, 41,000 and 51,000 patient-days of activity.

Required 1 Required 2 Formula flexible budget. (Round per unit to 2 decimal places.) Total budgeted monthly overhead cost Budgeted variable overhead cost per activity unit Total activity units Bugeted fixed + overhead cost per month x patient days Required 1 Required 2 Columnar flexible budget for 31,000, 41,000 and 51,000 patient-days of activity. Patient Days 31,000 41,000 51,000 Variable electricity cost Fixed electricity cost Total electricity cost