DATA INPUT
Master Budget Actual Variance
Units sold 5,000 4,800 200 U
Revenue 1,800,000$ 1,728,000$ 72,000$ U
Variable cost 1,140,000 1,170,000 (30,000) U
Contribution margin 660,000$ 558,000$ 102,000$ U
Fixed overhead 270,000 270,000 –
Fixed general and adminstrative cost 180,000 172,500 7,500 F
Operating income 210,000$ 115,500$ 94,500$ U
Unit costs:
Direct material 90$
Direct labor 66$
Variable overhead 54$
Variable selling costs 18$
Total variable costs: 1,170,000$
Direct material 480,000$
Direct labor 288,000$
Variable overhead 264,000$
Variable selling expenes 138,000$
SOLUTION
1. Flexible budget for the month of June, based on 4,800 units, showing separate variable cost budget is as follows:
Revenue 4,800 x 1,800,000$ / 5,000 = 1,728,000$
Deduct: Variable costs:
Contribution margin 633,600$
Deduct: Fixed costs:
2. Flexible-budget variances are as follows:
Flexible Flexible-Budget
Actual Budget Variance
Units 4,800 4,800 –
Variable overhead 264,000 259,200 4,800 U
Variable selling 138,000 86,400 51,600 U