Results 1 to 4 of 4

Thread: help with break even "spreedsheet"

  1. #1
    Jan 2010

    help with break even "spreedsheet"

    I have some problem solving break even in spreadsheet, If anyone would be kind enough to help me I would be very thankful
    The firm’s costs are as follow:
    Overheads “a”= £800,000
    Labour cost per unit “b”= £100
    Raw material per unit “c”= £258
    Advertisement cost are “D” = £40,000 per period on advertising and are capable of producing up to 1000 units in each period.
    Total cost function is expressed by
    TC= a+bQ+cQ+D
    The demand function is
    P= j-kQ + m√D
    Where j=4000 k=3 and m = 3 D= advertisement cost

    ·What is the breakeven level of output?
    · What is the breakeven level of output If the cost increase by 10%?
    · If advertisement cost doubles what is the breakeven level of output?
    P.S I would be happy If anyone can solve it in excel or otherwise put it in words with formula “how to solve it in excel” because I also have to make diagrams. Thank you
    Follow Math Help Forum on Facebook and Google+

  2. #2
    Junior Member
    Jan 2009
    What is the price per unit that the distributer pays?

    Need to know what the revenue streams are in order to work out where breakeven is.
    Follow Math Help Forum on Facebook and Google+

  3. #3
    e^(i*pi)'s Avatar
    Feb 2009
    West Midlands, England
    I'm not sure where you're going after the total. I mean the price function is simple enough to work out but what does that mean?

    I did a simple division of total/price function which is probably wrong on many levels

    If you want it in ODS (openoffice) let me know and I'll try getting it to you that way as these forums do not like FOSS (probably from a technical standpoint)
    Follow Math Help Forum on Facebook and Google+

  4. #4
    Jan 2010
    first of all i thank you both or your time
    i have got the total cost and demand funtion but i dont know the price.. if price was given i whould have solved it myself. i did it the same way you are telling me. total cost/P = price, but i am not sure if thats write or not becuause the break even diagram looked funny. iam new to this so i cant manage to add excel file
    i cant open the tex file i whould be happy if u send me open office file plz.
    Last edited by abidabbas; Jan 6th 2010 at 06:13 PM.
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Replies: 2
    Last Post: Jun 4th 2011, 12:11 PM
  2. Replies: 2
    Last Post: Apr 24th 2011, 07:01 AM
  3. Replies: 1
    Last Post: Oct 25th 2010, 04:45 AM
  4. Replies: 1
    Last Post: Jun 4th 2010, 10:26 PM
  5. "Break out" factorization
    Posted in the Pre-Calculus Forum
    Replies: 5
    Last Post: Jan 4th 2010, 12:58 PM

Search Tags

/mathhelpforum @mathhelpforum