Share this: Google+
< | Next >
Break even point ( BEP) is the point where the revenue is equal to total cost. At BEP, the company makes neither profit nor loss. This point is important to determine the price of a product such that the company still gains net profit. In this tutorial, we will use MS Excel Goal Seek to find the price at certain BEP as well as online interactive BEP calculator . Alternatively, you may also download the spreadsheet here . Before that, let me refresh you on how to compute Break Even Point (BEP) and the terminologies.
Your company may have fixed cost, such as worker salary, building operation and maintenance, machine and equipments that you must pay every month regardless how much sales that your company can get. Aside from the fixed cost, there is also variable cost, such as materials, energy supply (oil or electricity), and worker wages that depend on the production or sales. Higher sales, you may want to produce more and eventually paid higher variable cost.
Let be variable cost/ unit and is the total sales. We can compute the variable cost as and the total cost . Your company revenue is depend on the total sales and the price of the product , or .
The break event point happens when the total cost is equal to revenue, or which is equivalent to or
Thus, the break-even point price is obtained from revenue line at
Preferable reference for this tutorial is
Teknomo, Kardi. (2010) Determination of product price based on Break Even Point.http://people.revoledu.com/kardi/tutorial/Finance/BreakEvenPoint/