Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Which of the following formulas in cell C20 yields the correct result when copied to cell E20? E 1 B 2A D Productive Capacity 50,000
Which of the following formulas in cell C20 yields the correct result when copied to cell E20? E 1 B 2A D Productive Capacity 50,000 units 2 Fixed Budget 3 For the year ended December 31, 2020 4 Total Per Unit 5 Sales $250 $9,375,000 6 Variable costs 180 6,750,000 7 Contribution margin $70 2,625,000 8 Fixed Expenses 2,500,000 9 Operating Income $125,000 10 11 Flexible Budget 12 For the year ended December 31, 2020 13 % of productive capacity 70% 75% 14 Units produced and sold 35,000 37,500 15 16 Sales $8,750,000 $9,375,000 17 Variable costs 6,300,000 6,750,000 18 Contribution margin 2,450,000 2,625,000 19 Fixed expenses 2,500,000 2,500,000 20 Operating income ($50.000) $125.000 621 80% 40,000 $10,000,000 7200,000 2,800,000 2,500,000 $300.000 Multiple Choice =+C$18-C$19 =+C18-$C$19 (0) 3+$C$18-$C$19 O =+$C$18-C19
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started