South Africa Breakeven Sales


Joined
Jul 5, 2019
Messages
6
Reaction score
0
Country
South Africa
I have tried to compute the Breakeven sales for a workshop, but my answer appears to be incorrect. I have used Goal Seek in Excel and get a higher breakeven sales. I have use fixed costs/the contribution margin, to compute my breakeven sales It would be appreciated if someone would kindly assist me so I can see where I have gone wrong. I have attached sample data
 

Attachments

Ad

Advertisements

kirby

VIP Member
Joined
May 12, 2011
Messages
1,888
Reaction score
258
Country
United States
The rule is NEVER open a zipfile from an unknown source, such as this.
 
Joined
Jul 5, 2019
Messages
6
Reaction score
0
Country
South Africa

kirby

VIP Member
Joined
May 12, 2011
Messages
1,888
Reaction score
258
Country
United States
Kaspersky in a May 2019 online article lists .zip, .xlsx and .pdf as included in the top 4 dangerous file attachments.
 
Joined
Apr 18, 2020
Messages
1
Reaction score
0
Country
United States
I have tried to compute the Breakeven sales for a workshop, but my answer appears to be incorrect. I have used Goal Seek in Excel and get a higher breakeven sales. I have use fixed costs/the contribution margin, to compute my breakeven sales It would be appreciated if someone would kindly assist me so I can see where I have gone wrong. I have attached sample data
The breakeven point is when the operating income is zero for a company. If you need to find your breakeven sales in terms of units, divide fixed expenses by the contribution margin per unit. If you need the breakeven sales in dollar form,divide fixed expenses by the contribution margin ratio.
 
Ad

Advertisements

Werner Reisacher

VIP Member
Joined
Jun 30, 2017
Messages
202
Reaction score
20
Country
Switzerland
Here is the formula:
Fixed Cost: $ 200000
variable cost per unit $ 20
sales price per unit $ 45
contribution margin per unit $ 25 (sales - variable cost)

The breakeven point is reached when the profits generated by the sales equals all fixed costs:
Fixed Cost $ 200000
contribution margin per unit $ 25
Breakeven point in # of units # 10000 (Fixed Cost / # contribution margin)
sales price per unit $ 45
Breakeven point in sales $ 450000


Was there any other question? I am technically too challenged to go into the file security issues.
 

kirby

VIP Member
Joined
May 12, 2011
Messages
1,888
Reaction score
258
Country
United States
The above solution is wrong.
Breakeven formula in units is indeed Fixed cost divided by Contribution Margin
so $200,000 divided by $25 = 8,000 not 10,000 per above
And that's one of the downsides in not doing your own homework and asking somebody else to figure it out.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

South Africa Calculating Breakeven Selling Hours 0
USA Multiproduct breakeven 1
Contracted out breakeven investment return ? 2
Contracted out breakeven investment return ? 1
USA Sale of Home 2
UK Sale of Business 3
USA Double Entry of sales 1
USA Sales Tax 1

Top