Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 9 of 9

Thread: is there a function to show breakeven output?

  1. #1
    New Member
    Join Date
    May 2002
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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?

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    England, UK.
    Posts
    526
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #3
    New Member
    Join Date
    May 2002
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Location
    England, UK.
    Posts
    526
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #5
    MrExcel MVP
    Join Date
    Apr 2002
    Location
    Vancouver BC , Canada
    Posts
    6,259
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    overhead / selling price - ball cost

    ie 8500/15-10 = 1700 units

  6. #6
    New Member
    Join Date
    May 2002
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #7
    Board Regular
    Join Date
    Mar 2002
    Location
    England, UK.
    Posts
    526
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #8
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #9
    New Member
    Join Date
    May 2002
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    yup

    thx for advice fella )

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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