Check Applying Excel 13: Contribution Margin Which of the following is an INCORRECT formula in cell C18? D 1 2 3 4 5 B 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 6 7 8 9 10 11 12 Flexible Budget For the year ended December 31, 2020 % of productive capacity 70% Units produced and sold 35,000 13 75% 37,500 80% 40,000 14 15 16 17 18 Sales Variable costs Contribution margin Fixed expenses Operating income $8.750,000 6.300,000 2.450.000 2.500.000 $501000 $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 $200.000 19 20 1.21 SUVADUO Multiple Choice +C16-C17 =+C7*C14 +(C5-C6)*C14 =+C5-C6'C14 Prev 1 of 12 - Next >