Question

Phoenix Company’s 2017 master budget included the following fixed budget report. It is based on an expected production and sales volume of 15,000 units.

PHOENIX COMPANY Fixed Budget Report For Year Ended December 31, 2017
Sales				$	3,150,000
Cost of goods sold
Direct materials	$	930,000
Direct labor		225,000
Machinery repairs (variable cost)		45,000
Depreciation—Plant equipment (straight-line)		300,000
Utilities ($45,000 is variable)		195,000
Plant management salaries		180,000			1,875,000
Gross profit					1,275,000
Selling expenses
Packaging		75,000
Shipping		90,000
Sales salary (fixed annual amount)		235,000			400,000
General and administrative expenses
Advertising expense		125,000
Salaries		241,000
Entertainment expense		90,000			456,000
Income from operations				$	419,000

3. The company’s business conditions are improving. One possible result is a sales volume of 18,000 units. The company president is confident that this volume is within the relevant range of existing capacity. How much would operating income increase over the 2017 budgeted amount of $419,000 if this level is reached without increasing capacity?

Answer 1

Solution 3:

Phoenix Company
Flexible Budget for 2017
Particulars	Flexible Budget		Flexible Budget For
	Variable amount per unit	Total Fixed Cost	Volume - 14000 units	Volume - 16000 units
Sales	$210.00		$2,940,000.00	$3,360,000.00
Variable costs:
Direct materials	$62.00		$868,000.00	$992,000.00
Direct labor	$15.00		$210,000.00	$240,000.00
Machinery repairs	$3.00		$42,000.00	$48,000.00
Utilities	$3.00		$42,000.00	$48,000.00
Packaging	$5.00		$70,000.00	$80,000.00
Shipping	$6.00		$84,000.00	$96,000.00
Total Variable costs	$94.00		$1,316,000.00	$1,504,000.00
Contribution margin	$116.00		$1,624,000.00	$1,856,000.00
Fixed Costs:
Depreciation—Plant equipment		$300,000.00	$300,000.00	$300,000.00
Utilities		$150,000.00	$150,000.00	$150,000.00
Plant management salaries		$180,000.00	$180,000.00	$180,000.00
Sales Salaries		$235,000.00	$235,000.00	$235,000.00
Advertising expense		$125,000.00	$125,000.00	$125,000.00
Salaries		$241,000.00	$241,000.00	$241,000.00
Entertainment expense		$90,000.00	$90,000.00	$90,000.00
Total Fixed Costs		$1,321,000.00	$1,321,000.00	$1,321,000.00
Net Operating Income			$303,000.00	$535,000.00

Phoenix Company
Forecasted contribution margin income statement
For the year ended December 31, 2017
Sales (In units)	15000	18000
Contribution margin per unit	$116.00	$116.00
Contribution margin	$1,740,000.00	$2,088,000.00
Fixed costs	$1,321,000.00	$1,321,000.00
Operating income (Loss)	$419,000.00	$767,000.00	$348,000.00	Increase in income