Exercise 14-23 Flexible Budgets; Total Operating Income Variance; Breakdown of the Total Operating-Income Variance; Spreadsheet Application [LO 14-1, 14-2, 14-3]

The following information is available for Brownstone Products Company for the month of July:

	Actual			Master Budget
Units		3,900			3,200
Sales revenue	$	55,800		$	60,000
Variable manufacturing costs		10,900			16,000
Fixed manufacturing costs		12,800			13,800
Variable selling and administrative expenses		7,400			8,000
Fixed selling and administrative expenses		8,800			10,450

Required:

1. What was the total operating income variance for July? (Note: this variance is also called the master (static) budget variance for the period.) Was this variance favorable (F) or unfavorable (U)?

2. Compute the July sales volume variance and the flexible-budget variance for the month, both in terms of contribution margin and in terms of operating income.

4. Prepare pro forma budgets for activities within its relevant range of operations. Prepare a flexible budget for each of the following two output levels:

a. 3,940 units.

b. 4,340 units.