Question

please expain how to get the nunbers for "flexible budget" column! thank you

Problem 21-2A Preparation and analysis of a flexible budget performance report LO P1, P2, A1 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. ints awarded Scored $3,000,000 eBook PHOENIX COMPANY Fixed Budget Report For Year Ended December 31, 2017 Sales Cost of goods sold Direct materials Direet 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 Salaries Entertainment expense Income from operations $975,000 225,000 60,000 300,000 195.000 200,000 Print 1,955,000 1.045,000 References 75,000 105,000 250,000 430,000 125,000 241,000 90.000 456,000 159,000 $ Phoenix Company's actual income statement for 2017 follows. PHOENIX COMPANY Statement of Income from Operations For Year Ended December 31, 2017 Sales (18,000 units) Cost of goods sold Direct materials $1.185,000 Direct labor 278,000 Machinery repairs (variable cost) 63,000 Depreciation Plant equipment straight-line 300,000 Utilities (fixed cost is $147,500) 200, 500 Plant management salaries 210,000 2.236.500

Answer 1

If it is helpful, please rate the answer and if any doubt arises let me know

	Phoenix Company
	Fixed Budget Report
	For Year ended for December 31, 2017
		Flexible Budget		Flexible Budget for
		Variable amount per unit	Total Fixed cost	18,000 units
		(a)		[(a) X 18,000]
(i)	Sales ($3000,000/15,000)	$               200		$        36,00,000
	Variable Costs:
	Direct material ($975,000/15,000)	$                  65		$        11,70,000
	Direct labor ($225,000/15,000)	$                  15		$          2,70,000
	Machinery repairs (Variable cost) ($60,000/15,000)	$                    4		$              72,000
	Utilities ($45000/15,000)	$                    3		$              54,000
	Packaging ($75,000/15,000)	$                    5		$              90,000
	Shipping ($105,000/15,000)	$                    7		$          1,26,000
(ii)	Total Variable costs			$        17,82,000
(iii)	Contribution margin (i) - (ii)			$        18,18,000
	Fixed costs:
	Depreciation - Plant Equipment		$            3,00,000	$          3,00,000
	Utilities ($195000 - $45000)		$            1,50,000	$          1,50,000
	Plant manager salary		$            2,00,000	$          2,00,000
	Sales Salary		$            2,50,000	$          2,50,000
	Advertising Expense		$            1,25,000	$          1,25,000
	Salaries		$            2,41,000	$          2,41,000
	Entertainment Expense		$               90,000	$              90,000
(iv)	Total Fixed Costs (iii) - (iv)		$         13,56,000	$        13,56,000
	Income from Operations			$          4,62,000