Kardi Teknomo
Kardi Teknomo Kardi Teknomo Kardi Teknomo
   
 
  Research
  Publications
  Tutorials
  Resume
  Personal
  Contact

 

Visit Tutorials below:
Adaptive Learning from Histogram
Adjacency matrix
Analytic Hierarchy Process (AHP)
ArcGIS tutorial
Arithmetic Mean
Bayes Theorem
Bootstrap Sampling
Bray Curtis Distance
Break Even Point
Chebyshev Distance
City Block Distance
Conditional Probability
Continued Fraction
Data Analysis from Questionnaire
Data Revival from Statistics
Decimal to Rational
Decision tree
Difference equations
Digital Root
Discriminant analysis
Divisibility
Eigen Value using Excel
Euclidean Distance
Euler Integration
Euler Number
Excel Iteration
Excel Macro
Excel Tutorial
Feasibility Study
Financial Analysis
Generalized Inverse
Generalized Mean
Geometric Mean
Ginger Bread Man and Chaos
Graph Theory
Growth Model
Hamming Distance
Harmonic Mean
Hierarchical Clustering
Independent Events
Incident matrix
Jaccard Coefficient
Kernel basis function
Kernel Regression
k-Means clustering
K Nearest Neighbor
LAN Connections Switch
Learning from data
Lehmer Mean
Linear Algebra
Logarithm Rules
Mahalanobis Distance
Market Basket Analysis
Mean Absolute Deviation
Mean and Average
Mean, median, mode
Minkowski Distance
Minkowski Mean
Monte Carlo Simulation
Multi Agent System
Multicriteria decision making
Mutivariate Distance
Newton Raphson
Non-Linear Transformation
Normalization Index
Normalized Rank
Ordinary Differential Equation
Page Rank
Palindrome
PI
Power rules
Prime Factor
Prime Number
Q Learning
Quadratic Function
Queueing Theory
Rank Reversal
Recursive Statistics
Regression Model
Reinforcement Learning
Root of Polynomial
Runge-Kutta
Scenario Analysis
Sierpinski gasket
Sieve of Erastosthenes
Similarity and Distance
Solving System Equation
Standard deviation
String Distance
Summation Tricks
Support Vector Machines
System dynamic
Time Average
Tower of Hanoi
Variance
Vedic Square
Visual Basic (VB) tutorial
What If Analysis

Determination of product price based on

Break Even Point

by Kardi Teknomo

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

(Equation 1)

Thus, the break-even point price is obtained from revenue line at

(Equation 2)

In the next section, I will explain how to compute BEP using MS Excel. For interactive online break event analysis calculator, click here
< | Next > Google+

See also: Goal Seek Tutorial, MS Excel Tutorial index, Kardi Teknomo's Tutorial




These tutorial is copyrighted.

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/

 

 
© 2007 Kardi Teknomo. All Rights Reserved.
Designed by CNV Media