EX $11-28($Algo$)$ Construct a Flexible Overhead Budget; Hospital $($LO $11-1,11-2)$

The controller for Rainbow Children's Hospital, located in Munich, Germany, estimates that the hospital uses $32$ kilowatt$-$hours of electricity per patient$-$day, and that the electric rate will be $0\mathrm{.}20$ euro per kilowatt$-$hour. The hospital also pays a fixed monthly charge of $2,700$ 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.

Formula flexible budget.

Columnar flexible budget for $37,000,47,000$ and $57,000$ patient$-$days of activity.

Complete this question by entering your answers in the tabs below.

Formula flexible budget.

Note: Round per unit to $2$ decimal places.

$\backslash$table$[[\backslash$table$[[$Total budgeted$],[$monthly$],[$overhead cost$]],\{$fde$2$d$9510-$bc$40-4325-$ad$3$b$-99$df$15590$f$61\}$

$\backslash$table$[[$Budgeted variable$],[$overhead cost per$],[$activity unit$]],\{$f$60$c$392$da$-963$c$-4$be$2-9227-$d$71994$b$38476\}$

$\backslash$table$[[$Total activity$],[$units$]],+$

$\backslash$table$[[$Bugeted fixed$],[$overhead cost$],[$per month$]],],[,,,$patient days,$+]]$