SIGN UP

How To Create Breakeven Chart In Excel 2007 When I Only Know The Fixed Costs, Variable Costs And Sales Revenue?

Avatar Image
balliali | 14:59 Fri 15th Feb 2013 | Business
3 Answers
Help appreciated.... I need to create a Breakeven in Sales chart in Excel 2007 where the sales are not measured in units e.g. charity shop trading monthly. I can project the monthly income (units/items are all variably priced), I know the monthly fixed costs and the monthly variable costs. I want to demonstrate when I would reach breakeven i.e. the amount of sales which covers the costs and there is neither loss nor profit. Is this enough information to create a chart? Links to Youtube demos much appreciated too, please and thank you all.

Answers

1 to 3 of 3rss feed

Best Answer

No best answer has yet been selected by balliali. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
It seems to me you have all the information you need.
Total costs = fixed costs + (variable costs x units)
Revenue = you say you know this. Is it simply sales price x units (or the sum of this for each item if you sell several products)
Question Author
Thank you for that. I wanted to create a graph in excel to display that. I have projected figures for 3 years so I know the gross profit and net profit. Manually I can work out that my breakeven in sales value occurs in month 10 in year 2 and 3, but I found it difficult to show that on X and Y axis for either year. Biz makes a loss in Year 1.
Do you want to specifically show the breakeven point on a chart? If so an XY line chart would be clearest...just allocate your x and y axis to the correct list of figures and the wonder programme will do the work for you. Good luck!!

1 to 3 of 3rss feed

Do you know the answer?

How To Create Breakeven Chart In Excel 2007 When I Only Know The Fixed Costs, Variable Costs And Sales Revenue?

Answer Question >>

Related Questions

Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.