Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Wiley CPAexcel Exam Review Focus Notes Auditing And Attestation 2022

Authors: Wiley

1st Edition

111984858X, 978-1119848585

More Books

Students also viewed these Accounting questions

Question

Define the goals of persuasive speaking

Answered: 1 week ago