Question

1.

A E 1 2 3 4 B с D Productive Capacity 50,000 units Fixed Budget For the year ended December 31, 2020 Per Unit Total Sales $250 $9,375,000 Variable costs 180 6,750,000 Contribution margin $70 2,625,000 Fixed Expenses 2,500,000 Operating Income $125,000 5 6 7 8 9 10 11 12 13 Flexible Budget For the year ended December 31, 2020 % of productive capacity 70% Units produced and sold 35,000 75% 37,500 80% 40,000 14 15 16 17 18 19 20 21 Sales Variable costs Contribution margin Fixed expenses Operating income $8,750,000 6,300,000 2,450,000 2,500,000 ($50.000) $9,375,000 6,750,000 2,625,000 2,500,000 $125.000 $10,000,000 7,200,000 2,800,000 2,500,000 $300.000
2.

3.

Answer 1

1.)	=C1*D13*$C$6 does not yield the correct answer is cell E17.
	Correct answer is option 4.
2.)	=D7/((C4-C5)/C4) is the correct formula to calculate the amount of breakeven sals dollars in Cell D11.
	Correct answer is option 4.
3.)	=+C4/AVERAGE(C14:D14) is the correct formula to calculate accounts receivable turnover for 2022.
	Correct answer is option 2.