How to Calculate Breakeven Quantity through Formula

[londoneye001]

Hi all,

I'm having difficulty calculating breakeven quantity through an Excel formula and I was wondering if one of the genius can help me figure it out.

Below are my costs:


[TABLE="width: 233"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Sales[/TD]
[TD="align: right"]9,000,000[/TD]
[/TR]
[TR]
[TD]Cogs[/TD]
[TD="align: right"]7,813,800[/TD]
[/TR]
[TR]
[TD]Direct Cost[/TD]
[TD="align: right"]896,139[/TD]
[/TR]
[TR]
[TD]Indirect Cost[/TD]
[TD="align: right"]617,916[/TD]
[/TR]
[TR]
[TD]Other Revenue[/TD]
[TD="align: right"]315,000[/TD]
[/TR]
[TR]
[TD]Net Income (Loss)[/TD]
[TD="align: right"]-12,855[/TD]
[/TR]
[TR]
[TD]Breakeven Quantity?[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Appreciate your help!

Thanks!

 

[Misca]

You'll get the break even quantity by dividing the fixed costs by the profit of a single unit (=sales price - unit cost).