+ Reply to Thread
Results 1 to 6 of 6

Determining break even value

  1. #1
    Registered User
    Join Date
    05-08-2014
    MS-Off Ver
    GSheets
    Posts
    5

    Determining break even value

    Hi,

    I am currently calculating the required consumption in % in order to determine my breakeven value. For that I just manually try different consumption % values until I reach 0 . It feel a bit stupid and was hoping that the required consumption % can be automatically calculated by using a formula. In order to show you what I mean, I came up with some example data. The only function existing is the one you see in the screenshot:
    Screenshot 2019-11-29 at 10.06.57.png
    Attached Images Attached Images

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    2007 Enterprise
    Posts
    4,868

    Re: Determining break even value

    .
    Here is an excellent discussion on determining Break Even Point : https://squareup.com/us/en/townsquar...point-analysis

    But you are saying "Consumption". Are you selling a product ? What are you attempting to measure ?

  3. #3
    Forum Moderator Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    8,606

    Re: Determining break even value

    @k1282
    Your profile states you are using XL2003. Is this still the case? If not perhaps update your profile as answers are tailored to your XL version?
    Thanks
    You really don't have to give me rep points for moderating. It's part of the job. Keep rep points for those who find solutions

  4. #4
    Registered User
    Join Date
    05-08-2014
    MS-Off Ver
    GSheets
    Posts
    5

    Re: Determining break even value

    - I updated my Excel Version in my profile.
    - I do not see how the link helps me to create the function i am looking for

    so I take it, it is not possible and that I should look for an alternative way to calculate my break even?

  5. #5
    Forum Moderator Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    8,606

    Re: Determining break even value

    Thanks
    I will move your thread to the correct forum.
    In the future please start your threads in the correct forum so that members will not loose time .
    Thanks

  6. #6
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    11,448

    Re: Determining break even value

    If that is really the only formula present, then it feels like a very simple algebra problem more than a programming problem -- 0=C3*C5-D3. It's not clear to me exactly which value is "x", but, if it C5, for example:
    C3*x-D3=0 --> add D3 to both sides
    C3*x=D3 --> divide both sides by C3
    x=D3/C3

    and there's your formula for the break even point based on the percentage in C5.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1