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

balliali | 14:59 Fri 15th Feb 2013 | Business
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.

1 to 3 of 3

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

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 3