Question

fill in blanks. thanks.

i Data Table X Manco Industries Flexible Budget Performance Report: Sales and Operating Expenses For the Month Ended September 30 Flexible budget Flexible Volume Actual variance Budget Master Budget Variance Output units 27,000 ? 30,800 Sales revenue S 253,500 S 5,100 F Less: Variable expenses 180,900 189.420 Contribution margin Less: Fixed expenses 16,500 ? 12 23,000 Operating income ? ? Print Done

Answer 1

	Manco Industries
	Flexible budget performance report : sales and operating expenses
	For the month ended September 30
		Actual Results	Flexible Budget Variance		Flexible Budget	Sales Volume Variance		Master Budget
	Output Units	27,000			27,000			30,800
	Sales Revenue	$ 2,53,500	$       5,100	F	$2,48,400	$    34,960	U	$2,83,360
Less:	Variable Expenses	$ 1,80,900	$     14,850	U	$1,66,050	$    23,370	F	$1,89,420
	Contribution margin	$     72,600	$       9,750	U	$    82,350	$    11,590	U	$    93,940
Less:	Fixed Expenses	$     16,500	$       6,500	F	$    23,000	$             -	None	$    23,000
	Operating Income	$     56,100	$       3,250	U	$    59,350	$    11,590	U	$    70,940

A. C Е F G Н Manco Industries Flexible budget performance report sales and operating expenses For the month ended September 30 2 3 Flexible Sales Volume Flexible Budget Master Budget Actual Results Budget 4 Variance Output Units 30800 5 27000 C5 6 =(F7/F5)*15 Sales Revenue 7 253500 5100 F C7-D7 17-F7 8 Less: Variable Expenses U E18/15)*F5 180900 -С8-F8 E 18 - F8 F 189420 Contribution margin C7-C8 F9-C9 9 U F7-F8 19-F9 17-18 10 Less: Fixed Expenses 16 =F10-C10 F 110-F1 B00 one Operating Income 11 -C9-C10 =F11-C11 U =F9-F10 111-F11 19-110 12 13 14 15 16 17 18 19 LO LO