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. РHOENIX OСOMPANY Fixed Budget Report For Year Ended December 31, 2017 $3,300,000 Sales Cost of goods sold Direct materials $915,000 225,000 60,000 330,000 195,000 Direct labor Machinery repairs (variable cost) Depreciation-Plant equipment (straight-line) Utilities ($45,000 is variable) Plant management salaries Gross profit Selling expenses Packaging Shipping Sales salary (fixed annual amount) General and administrative expenses Advertising expense 1,935,000 1,365,000 210,000 90,000 90,000 235,000 415,000 125,000 241,000 80,000 Salaries Entertainment expense 446,000 Income from operations $ 504,000

Answer 1

Solution:

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	$220.00		$3,080,000.00	$3,520,000.00
Variable costs:
Direct materials	$61.00		$854,000.00	$976,000.00
Direct labor	$15.00		$210,000.00	$240,000.00
Machinery repairs	$4.00		$56,000.00	$64,000.00
Utilities	$3.00		$42,000.00	$48,000.00
Packaging	$6.00		$84,000.00	$96,000.00
Shipping	$6.00		$84,000.00	$96,000.00
Total Variable costs	$95.00		$1,330,000.00	$1,520,000.00
Contribution margin	$125.00		$1,750,000.00	$2,000,000.00
Fixed Costs:
Depreciation—Plant equipment		$330,000.00	$330,000.00	$330,000.00
Utilities		$150,000.00	$150,000.00	$150,000.00
Plant management salaries		$210,000.00	$210,000.00	$210,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		$80,000.00	$80,000.00	$80,000.00
Total Fixed Costs		$1,371,000.00	$1,371,000.00	$1,371,000.00
Net Operating Income			$379,000.00	$629,000.00