ChatterBank3 mins ago
How To Create Breakeven Chart In Excel 2007 When I Only Know The Fixed Costs, Variable Costs And Sales Revenue?
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.
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.
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.