Home » Operations Management » Cost Volume Profit Formula

Cost Volume Profit Formula

September 26, 2023
Bill Kimball

There should be some constants, such as overhead costs or variable expenses andbreak-even point,to help with the planning process. This formula makes it easy to create several different projections to work with. The total will show the number of sales you’ll need to make in order to reach your target profit goal. This strategy ignores other factors influencing the variable cost. The dollar amount of target sales can be calculated as shown below. Modifying the break-even equation, the volume of sales required to earn an amount desired or expected profit can be estimated. Here are a few advantages of using the target profit approach as compared to the arbitrary budgeting method.

However, there are two common approaches adopted by most businesses.

target profit formula

The target profit approach is a useful tool in achieving the financial objectives of the business. The target profit method can be used in a single or multiple-product environment. However, it also offers some limitations in the form of variance in results, employee demotivation, and unrealistic approaches from the management. Target profits consider both fixed and variable costs of production. Thus, the analysis offers a comprehensive evaluation of the overall operating efficiency of a business. If the profit is set to zero, the company can achieve the break-even point with the help of this equation.

Target Profit Analysis With Sales Mix

In other words, it indicates the amount of revenue necessary to earn a target profit. The key formula used to calculate the break-even or target profit point in units for a company with multiple products is as follows. Simply set the target profit to $0 for break-even calculations, or to the appropriate profit dollar amount for target profit calculations. This contribution margin can be used to pay down the theater’s fixed costs. This shows us that the theater must sell 6,000 tickets per quarter to break even. The cost volume profit equation shows us many important aspects of the business of the theater.

So we have variable costs of $2, sales price of $7, and fixed costs of $30,000. The formula used to solve for the break-even point in units for multiple-product companies is similar to the one used for a single-product company, with one change. Instead of using the contribution margin per unit in the denominator, multiple-product companies use a weighted average contribution margin per unit.

Target profit analysis results can also be presented graphically. Let’s consider the graph below using the data from the example above. This method helps management to control and improve operating efficiency. Draw the lines to represent the profits of products P2 and P3 ranked respectively according to the C/S ranking. In the final step, all figures are placed in the following formula to calculate this profit. Thus sales revenue can drop by $555,555 per year before the company begins to incur a loss. Contribution margin ratio remains constant for each product, segment, or department.

Companies use a variety of financial metrics to help them set and reach fiscal goals. One calculation many organizations use to help establish potential profits is the target profit formula. Knowing how to calculate and apply this metric is useful for any employee tasked with setting business goals for their company. The target profit formula is a calculation used by businesses to estimate how much revenue the company should produce over a set period of time. Usually, companies use this metric to help establish budgets, forecast development potential and optimize investments.

Calculated by multiplying each product’s unit contribution margin by the product’s proportion of total sales. The River model represents 60 percent of total sales volume and the Sea model accounts for 40 percent of total sales volume. As you see here, the theater must sell 8,000 tickets in order to cover its fixed costs and make a profit of $10,000 in the upcoming quarter. LWD Fashion LLC has to sell 14,000 pairs of jeans, 7,000 T-shirts, and 14,000 sweaters.

It can be difficult to execute in the multiple-product environment as it will take substantial time and effort. Draw a line that represents the profit of P1 (the highest-ranked C/S product) scaled to the graph on the y-axis. However, many businesses fail to achieve it through this approach as they cannot control budgets.

What’s The Benefit Of Calculating Target Profit?

Target profit analysis helps us to know how much in dollar sales a company will need to reach a certain profit point. Once the basic data is calculated, it can offer a great deal of insight and help in planning. It helps set accurate profit targets that can be achieved through analysis of required revenue at specific volume production. The CVP method finds the break-even sales point when the profit is set to zero. Instead of setting the profit to zero, the management can use the desired profit amount and follow the same steps to calculate the desired output quantity.

The break-even point is on the intersection of the total costs line and the sales line. In turn, target sales exceed total costs by the amount of target profit of $250,000. The equation method can be applied to compute a sales volume that allows a target profit to be earned. Aside from the determination of the break-even point, the CVP analysis can determine the level of sales required to generate a specific level of income. The target income could be expressed on a before-tax basis or after-tax basis. In all those cases, nonetheless, the CVP analysis can compute for the required sales volume.

Expected fixed costs are $700,000, the variable cost per unit is $500, and the sales price per unit is $900. The management can use the graphical method to calculate the break-even sales points as well as target profits for each product. This method uses the profit-volume relationship to calculate target profit.

Target Profit Analysis:

Next, the CVP method requires determining the fixed costs as well. To set a target level of profit, historical financial results are reviewed in addition to future forecasts.

  • The key formula used to calculate the break-even or target profit point in units for a company with multiple products is as follows.
  • Again, setting the target profit to zero will give the sales break-even point.
  • Almost every company sets profit targets and on the basis of it, they make all other decisions regarding the volume and pricing.
  • The dollar amount of target sales can be calculated as shown below.
  • As mentioned earlier, there are several methods to calculate it for a business.

For example, suppose Amy’s Accounting Service has three departments—tax, audit, and consulting—that provide services to the company’s clients. Figure 6.5 “Income Statement for Amy’s Accounting Service” shows the company’s income statement for the year. Amy, the owner, would like to know what sales are required to break even. Note that fixed costs are known in total, but Amy does not allocate fixed costs to each department. The dollar amount of target sales for a specific product can be calculated by multiplying the number of units by the sales price.

Target Profit Analysis Methods

The management can then add the desired profit that comes through excess of the break-even point sales. Since budgets come with inevitable variances, an alternative method is desired. An alternative method is to follow the cost-volume-profit or the CVP approach.

How To Calculate Target Profit Formula

For most companies, there’s no difference between target net profit and target profit. Many organizations use these two terms interchangeably to describe the amount of money they hope to make in a given time frame. But how many do they need to sell in order to make a profit of, let’s say, $10,000?

Calculate Fixed Costs

A common approach to achieving this desired profit is through the budgeting process. The management can set a target to achieve by the budgeting period end. Target profit is the desired profit that a business wants to achieve in an accounting or manufacturing period. The conventional approach is to set budgets and compare results against standards. One manager at Kayaks-For-Fun believes the break-even point should be 60 units in total, and another manager believes the break-even point should be 160 units in total. If only the River kayak is produced and sold, 60 units is the break-even point.

If only the Sea kayak is produced and sold, 160 units is the break-even point. There actually are many different break-even points, because the profit equation has two unknown variables, Qr and Qs. The second step is to determine the weighted average contribution margin. Where n is a number of units to be sold to earn a target profit. Minnesota Kayak Company needs to sell 28 kayaks in our example to break even.