is there a function to show breakeven output?

beastwood · May 5th, 2002, 02:59 PM

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?

RET79 · May 5th, 2002, 03:15 PM

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

beastwood · May 5th, 2002, 03:19 PM

was wondering if there was a function or do i have to manually work out formula?

RET79 · May 5th, 2002, 03:55 PM

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

Nimrod · May 5th, 2002, 03:57 PM

overhead / selling price - ball cost

ie 8500/15-10 = 1700 units

beastwood · May 5th, 2002, 03:59 PM

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?

RET79 · May 5th, 2002, 04:08 PM

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

Yogi Anand · May 5th, 2002, 04:10 PM

Quote:

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 ]

beastwood · May 5th, 2002, 04:16 PM

yup

thx for advice fella )

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 5th, 2002, 02:59 PM	#1
beastwood New Member Join Date: May 2002 Posts: 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?

May 5th, 2002, 03:15 PM	#2
RET79 Board Regular Join Date: Mar 2002 Location: England, UK. Posts: 526	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

May 5th, 2002, 03:19 PM	#3
beastwood New Member Join Date: May 2002 Posts: 16	was wondering if there was a function or do i have to manually work out formula?

May 5th, 2002, 03:55 PM	#4
RET79 Board Regular Join Date: Mar 2002 Location: England, UK. Posts: 526	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

May 5th, 2002, 03:57 PM	#5
Nimrod MrExcel MVP Join Date: Apr 2002 Location: Vancouver BC , Canada Posts: 6,259	overhead / selling price - ball cost ie 8500/15-10 = 1700 units

May 5th, 2002, 03:59 PM	#6
beastwood New Member Join Date: May 2002 Posts: 16	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?

May 5th, 2002, 04:08 PM	#7
RET79 Board Regular Join Date: Mar 2002 Location: England, UK. Posts: 526	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

May 5th, 2002, 04:16 PM	#9
beastwood New Member Join Date: May 2002 Posts: 16	yup thx for advice fella )