Just need help with question 4 part a (Net operating income (loss)) 2. Change al

Question

Just need help with question 4 part a (Net operating income (loss))

2. Change all of the numbers in the data area of your worksheet so that it looks like this: 1 Chapter 5: Applying Excel 2 3 Data 4 Unit sales 5 Selling price per unit 6 Variable expenses per unit 30,000 units $10 per unit 7 Fixed expenses 90,000 If your formulas are correct, you should get the correct answers to the following questions. (a) What is the break-even in dollar sales? Break-even in dollar sales $ 150,000 (b) What is the margin of safety percentage? Margin of safety 501% ercentage

Explanation / Answer

Particulars Amount Sales (36000*10) $360,000 Less: variable expenses (36000*4) 144000 Contribution Margin $216,000 Less: Fixed cost $90,000 Net operating income $126,000

Related Questions

Navigate

• Browse (All)
• Browse J
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.