is there a function to show breakeven output?

beastwood

New Member
Joined
May 1, 2002
Messages
16
eg..
ball costs $10 dollars to make
weekly overheads are $8500
ball sells for $15

is there a function to tell u how many balls u need to make to breakeven?
 

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand
In a week producing and selling 1700 balls would break you even for one week. You need a formula to get the answer of 1700 or are you after something else?

RET79
 
Upvote 0
There may be a formula, or you could even define your own function.

It would help if you could confirm to me that you need a formula to churn out 1700 in your example. Or is it something else you want to work out?

RET79
 
Upvote 0
aye i need to show how many balls are needed to break even..

my formula is
=SUM(E3/(E1-E2))

where
e3 = $8500 fixed costs
e1 = sale price
e2 = cost of materials for each ball

this seems to work but wondered if there is a function?
 
Upvote 0
Not sure if there is such a function, but, to be honest if I were you I would stick with the one you have as it is a simple one.... perhaps you could use named ranges such as fixcost, saleprice, cost instead of E1, E2, E3. I assume you know how to do this?

RET79
 
Upvote 0
On 2002-05-05 14:57, Nimrod wrote:
overhead / selling price - ball cost

ie 8500/15-10 = 1700 units

Hi Nirmod: Just an editorial fix:
=8500/(15-10)
This message was edited by Yogi Anand on 2002-05-05 15:11
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,208
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top