2. The difference between the static budget loss of $12,000 and the actual loss of
$20,200 can first be divided into a sales-activity variance and a flexible-budget
variance:
Flexible Budget
Profit (Loss)
Static Budget Profit
(Loss)
$102 × 3,800 –
$420,000 = $(32,400)
$102 × 4,000 –
$420,000 = $(12,000)
Flexible-budget variance
(A – B) =
$(20,200) – $(32,400) =
$12,200 F
Sales activity variance
(B – C) =
$(32,400) – $(12,000) =
$20,400 U
Static budget variance (A – C)
$(20,200) – $(12,000) = $8,200 U
Therefore, the main explanation of the additional loss is the decrease in volume.
In fact, the loss of volume cost Hopkins $20,400, and cost savings of $12,200
reduces the overall shortfall to only $8,200.
The $12,200 flexible-budget variance can be further analyzed by cost category.
First, consider the physician cost. Since physician costs are fixed, we can only
compute a total physician cost variance: $240,000 – $231,000 = $9,000 F.
Nurse and technician costs are variable and have a standard rate of $30 per hour
and an actual rate of $182,700 ÷ 5,800 = $31.50. A total of 5,800 hours was used;
standard hours allowed for 3,800 patients is 1.5 hrs./patient × 3,800 patients =
Nurse & technician price variance 8,700 U
Nurse & technician quantity variance 3,000 U
Supplies variance 1,500 U
Overhead variance 16,400 F
Total flexible-budget variance $12,200 F