Breakeven/ Cost-Volume Analysis 
Breakeven/ Cost-Volume Analysis Cost-volume analysis is used in several different areas of POM and QM, especially capacity planning and location analysis. Cost-volume analysis is used to find the point of indifference between two options based on fixed and variable costs. A breakeven point is computed in terms of units or dollars. Breakeven is simply a special case of cost-volume analysis where there is one fixed cost, one variable cost and a revenue per unit.
In cost-volume analysis we compare two or more options to determine what option is least costly at any volume. The costs consist of two types - fixed costs and variable costs, but there may be several individual costs that comprise the fixed costs or the variable costs. In the example that follows we are indicating that there are five different individual costs and two options.
Cost type. Each type of cost must be identified as either a fixed cost or a variable cost. The default is that the first cost in the list is fixed and that all other costs are variable. These values can be changed by using the drop-down box in that cell.
Costs. The specific cost for each option gets listed in the two columns in the table.
Volume. If a volume analysis is desired, enter the volume at which this analysis should be performed. The volume analysis will compute the total cost (revenue) at the chosen volume. If the volume is 0, no volume analysis will be performed other than for the breakeven point. We have asked for a volume analysis at 250 units.
The solution screen is very straightforward. In the preceding screen there are five costs with some fixed and some variable. The program displays the following results.
Total fixed costs. For each of the two options the program takes the fixed costs, sums them up, and lists them below the table. In this example, the total fixed costs for option 1 are $1300 (800+500), while the total fixed costs for option 2 are $900 (700+200).
Total variable costs. The program identifies the variable costs, sums them up, and lists them. In this example, the total variable costs for option 1 are $10 per unit, while for option 2 they are $12 per unit.
Breakeven point in units. The breakeven point is the difference between the fixed costs divided by the difference between the variable costs and this is displayed in units. In the example, it is 200 units.
Breakeven point in dollars. The breakeven point can also be expressed in dollars.
A volume analysis has been performed for a volume of 250 units. The total fixed costs and total variable costs have been computed for each option and these have been summed to yield the total cost for each option.
A graph is available as shown as follows.
Example 2 - Breakeven analysis
One standard type of breakeven analysis has revenue versus cost.
Data entry for this option is slightly different in that the program creates a column for costs and a column for revenues. The fixed and variable costs get entered in the cost column and the revenue per unit is placed in the revenue column.
We have used three types of cost to set up the table. The first is for the fixed cost of $10,000, the second for the variable cost of $20 per unit, and the third for the (variable) revenue of $25 per unit. The program will compute a breakeven volume of 2000 units or $50,000 (not shown).
Example 3 - Breakeven point with more than two options
The breakeven module can perform a breakeven analysis for up to five options. Following we demonstrate the output for a three-option breakeven. The solution screen below is indicating three break even points as it makes comparisons for computers 1 vs computer 2, computer 1 vs. Computer 3 and computer 2 vs computer 3. Of course, while there are three breakeven points, only two of them are relevant.
This is seen a little more easily by looking at the breakeven graph given below. The breakeven point at 40,000 units does not matter since at 40,000 units the two computers that breakeven have higher costs than the computer 2 option.
