Question
I need the formula that is supposed to be in F6 as well. But the one that i posted and someone answered earlier last week,
I need the formula that is supposed to be in F6 as well. But the one that i posted and someone answered earlier last week, keeps coming up with a number in the millions and its only supposed to be in the hundred thousands according to the instructor.
Complete the exercise Contribution Format Income Statement (Chapter 7 DA Exercise 2) before answering this question. Open the Contribution worksheet. Change the year to 2021 in cell B1 and the value in cell F15 to 50,000. Enter the output in cell F6 in the space below. Type your response as shown on the worksheet with zero decimal places. Do NOT include any digits after the decimal place.
| Year | 2019 | ||||
| Contribution Format Income Statement | |||||
| Fiscal Year: 2019 | Target Profit Scenarios | ||||
| Sales Revenue | $ 420,245 | Sales Units | 6,363 | ||
| Variable Cost | Sales Target in Dollars | ||||
| Product | $ 159,075 | Sales Target in Units | 24,621 | ||
| SG&A | $ 150,224 | ||||
| Total Variable Cost | $ 309,299 | Variable Cost Ratio | 73.6% | ||
| Contribution Margin | $ 110,946 | Contribution Margin Ratio | 26.4% | ||
| Fixed Cost | Contribution Margin per Unit | $ 17.44 | |||
| Product | $ 219,075 | ||||
| SG&A | $ 150,224 | ||||
| Total Fixed Cost | $ 369,299 | ||||
| Net Operating Income | $ 110,932 | Target Profit | $ 60,000 | ||
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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
Principles Of Cost Accounting
Authors: Edward J. Vanderbeck
15th Edition
978-0840037039, 0840037031
