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 unitxTotal 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 Days43,00053,00063,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:

  1. A formula flexible budget, in this form:
Total budgeted monthly cost=Budgeted variable cost per patient-day×Patient-days+Budgeted fixed cost per month
?=?×?+?
  1. A columnar flexible budget at 43,000, 53,000 and 63,000 patient-days:
Patient-days43,00053,00063,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.

Jake Glidden, CPA, MSA

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-days43,00053,00063,000
Variable electricity cost$688,000$848,000$1,008,000
Fixed electricity cost3,5003,5003,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

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.

Ace your accounting classes.

Textbook questions are for reference. We show a textbook's question only so you can find the problem you were assigned. We don't solve textbook questions: every solution and video on this site works through our own Accuity problem, written to teach the same method with different numbers.

Educational use. Accuity problems are original teaching material — we write our own version of each problem and solve it on video so you learn the method. Don't submit our work as your own; that violates your school's academic integrity policy. If you believe content here infringes your rights, file a DMCA notice.