Results 1 to 4 of 4

Math Help - help with break even "spreedsheet"

  1. #1
    Newbie
    Joined
    Jan 2010
    Posts
    2

    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
    Joined
    Jan 2009
    Posts
    44
    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
    -1
    e^(i*pi)'s Avatar
    Joined
    Feb 2009
    From
    West Midlands, England
    Posts
    3,053
    Thanks
    1
    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
    Newbie
    Joined
    Jan 2010
    Posts
    2
    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; January 6th 2010 at 07:13 PM.
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Replies: 2
    Last Post: June 4th 2011, 01:11 PM
  2. Replies: 2
    Last Post: April 24th 2011, 08:01 AM
  3. Replies: 1
    Last Post: October 25th 2010, 05:45 AM
  4. Replies: 1
    Last Post: June 4th 2010, 11:26 PM
  5. "Break out" factorization
    Posted in the Pre-Calculus Forum
    Replies: 5
    Last Post: January 4th 2010, 01:58 PM

Search Tags


/mathhelpforum @mathhelpforum