Question

Hanno had the following static budget for March, when it expected to sell 4,000 sandwiches:

Sales revenue	$ 48,000
Variable costs	$ 32,000
Fixed costs	$ 5,000
Net income	$11,000

Hanno actually sold 5,000 sandwiches during March at $12 each. Variable costs were $38,000 and fixed costs were $4,800.

A. Prepare a flexible budget at for March that will help Hanno separate the volume variance from the flexible budget variance. Make your income statement match my format and compute net income.

B. What is the volume variance for variable costs?

C. What is the flexible budget variance for variable costs?

Answer 1

Solution A:

Flexible Budget Performance Report
For the month ended March
Particulars	Actual results	Revenue and spending variances		Flexible Budget	Volume Variances		Planning Budget
Nos of units	5000			5000			4000
Sales	$60,000.00	$0.00	None	$60,000.00	$12,000.00	F	$48,000.00
Variable cost	$38,000.00	$2,000.00	F	$40,000.00	$8,000.00	U	$32,000.00
Contribution margin	$22,000.00	$2,000.00	F	$20,000.00	$4,000.00	F	$16,000.00
Fixed Costs	$4,800.00	$200.00	F	$5,000.00	$0.00	None	$5,000.00
Net Income	$17,200.00	$2,200.00	F	$15,000.00	$4,000.00	F	$11,000.00

Solution B:

Refer Flexible budget performance report:

Volume variance for variable costs = $8,000 U

Solution C:

Refer Flexible budget performance report:

flexible budget variance for variable costs = $2,000 F