Thanks:  0
Likes:  0

# Thread: is there a function to show breakeven output?

1. eg..
ball costs \$10 dollars to make
ball sells for \$15

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

2. 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

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

4. 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

5. overhead / selling price - ball cost

ie 8500/15-10 = 1700 units

6. 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?

7. 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

8. 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 ]

9. yup

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•