EX 11-28 (Algo) Construct a Flexible Overhead Budget; Hospital (LO 11-1, 11-2)
Managerial AccountingBudgeting & Variances
What the textbook asks
The controller for Rainbow Children's Hospital, located in Munich, Germany, estimates that the hospital uses 38 kilowatt-hours of electricity per patient-day, and that the electric rate will be 0.26 euro per kilowatt-hour. The hospital also pays a fixed monthly charge of 3,300 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 43,000, 53,000 and 63,000 patient-days of activity.
Required 1: Formula flexible budget. Note: Round per unit to 2 decimal places.
| Total budgeted monthly overhead cost | = | Budgeted variable overhead cost per activity unit | x | Total activity units (patient days) | + | Budgeted fixed overhead cost per month |
|---|
Required 2: Columnar flexible budget for 43,000, 53,000 and 63,000 patient-days of activity.
| Patient Days | 43,000 | 53,000 | 63,000 |
|---|---|---|---|
| Variable electricity cost | |||
| Fixed electricity cost | |||
| Total electricity cost |
Below is the Accuity problem: the same method with different numbers. We solve ours, so work through it and you'll know how to solve yours.
The Accuity problem
Accuity Medical Center, a hospital in Orlando, Florida, is building next year's utility budget. Its controller expects each patient-day of care to use 40 kilowatt-hours of electricity, billed at $0.40 per kilowatt-hour. On top of the usage charge, the hospital pays the power company a flat $3,500 a month to rent standby emergency generators.
Build a flexible budget for the hospital's monthly electricity cost in two forms:
- A formula flexible budget, in this form:
| Total budgeted monthly cost | = | Budgeted variable cost per patient-day | × | Patient-days | + | Budgeted fixed cost per month |
|---|---|---|---|---|---|---|
| ? | = | ? | × | ? | + | ? |
- A columnar flexible budget at 43,000, 53,000 and 63,000 patient-days:
| Patient-days | 43,000 | 53,000 | 63,000 |
|---|---|---|---|
| Variable electricity cost | ? | ? | ? |
| Fixed electricity cost | ? | ? | ? |
| Total electricity cost | ? | ? | ? |
An Accuity original. We write our own version of each problem and solve it from scratch, so you learn the method rather than copying an answer.
Video solution
Covers the full step-by-step solution below, start to finish.

Solved by
Jake Glidden, CPA, MSA
Founder of Accuity
Jake started Accuity while studying accounting at UCF and has worked with hundreds of students in introductory and upper-level accounting classes. Accuity solutions are checked against the textbook before they're published.
Certified Public Accountant (CPA) · B.S.B.A. in Accounting, UCF · M.S. in Accounting, UCF
More about Accuity →Step-by-step solution
The same steps the video works through, written out.
This problem tests how to build a flexible budget: a budget that shows what costs should be at any level of activity, not just one. The cost driver here is patient-days, and electricity has a variable part (usage) and a fixed part (generator rental).
A flexible budget can be written two ways. The formula version gives one equation that works at any activity level. The columnar version applies that equation to a few chosen levels.
Step 1 — Variable cost per patient-day
Each patient-day uses 40 kWh, and each kWh costs $0.40:
40 kWh × $0.40 = $16.00 per patient-day
The $3,500 generator rental is fixed. It is the same every month no matter how many patients the hospital treats.
Requirement 1 — Formula flexible budget
| Total budgeted monthly cost | = | Variable cost per patient-day | × | Patient-days | + | Fixed cost per month |
|---|---|---|---|---|---|---|
| Total cost | = | $16.00 | × | Patient-days | + | $3,500 |
Written as an equation: Total monthly electricity cost = $16.00 × Patient-days + $3,500
Requirement 2 — Columnar flexible budget
Multiply $16 by each activity level for the variable line. The fixed line stays at $3,500 in every column.
| Patient-days | 43,000 | 53,000 | 63,000 |
|---|---|---|---|
| Variable electricity cost | $688,000 | $848,000 | $1,008,000 |
| Fixed electricity cost | 3,500 | 3,500 | 3,500 |
| Total electricity cost | $691,500 | $851,500 | $1,011,500 |
Work for the variable line:
43,000 × $16 = $688,000
53,000 × $16 = $848,000
63,000 × $16 = $1,008,000
Check: each step of 10,000 patient-days adds 10,000 × $16 = $160,000 to total cost, and that is exactly the gap between the columns ($851,500 − $691,500 = $160,000).
Where students go wrong
- Using $0.40 as the variable rate. That is per kilowatt-hour. The activity unit is the patient-day, so multiply by 40 kWh first.
- Scaling the fixed charge. The $3,500 is per month, not per patient-day, so it never changes across the columns.
- Rounding. Show the per-unit amount to two decimals: $16.00.
More Budgeting & Variances problems
- Crystal Glassware Company standards and flexible-budget dataThis problem tests computation of four overhead variances using standard formulas: variable spending and efficiency variances, and fixed budget and volume variances. Solutions require comparing actual overhead costs and labor hours against flexible-budget standards.
- New Jersey Valve Company manufactured 9,000 units during JanuaryThis problem tests your ability to calculate standard production costs and analyze material and labor variances. You'll compute price, quantity, rate, and efficiency variances to understand production performance against standards.
- The director of cost management for Odessa Company uses a control chartThis problem tests understanding of when variances warrant investigation using a percentage-of-standard-cost rule. Students calculate the investigation cutoff and identify which months exceed it.
- GreenThumb Organic Fertilizer Company plans to sell 250,000 units in JulyThis problem tests your ability to forecast production needs based on sales growth and ending inventory targets, then calculate raw-material purchase costs. You'll work through multi-month production budgets and inventory management policies to determine both required units and purchase expenses.
- Bodin Company budgets on an annual basis: production and raw materialTests production budgeting and raw material purchase calculations using inventory flow equations. Solutions require computing units to manufacture from sales and ending inventory targets, then determining material purchases from production needs and inventory levels.
Got a different wording of this problem?
Assignments vary by school and semester. Share the version you were given and we'll add it so other students can find this solution.
Studying Budgeting & Variances for a class?
Accuity courses map to your actual syllabus — video lessons, exam-style practice, and walkthroughs for the problems you're assigned.