Selling Prices Decisions - New Project 5

For example, assume that Specialty Fried Chicken in the New York market estimates product demand for its large bucket of chicken for a particular period to be:

Change in Sales Price

The owner of Back Door has one of her employees conduct a survey of the other coffee shops in the area and finds that they are charging $0.75 more for espresso drinks. As a result, the owner wants to determine what would happen to operating income if she increased her price by just $0.50 and sales remained constant, so she performs the following analysis:

The only variable that has changed is the $0.50 increase in the price of their espresso drinks, but the net operating income will increase by $750. Another way to think of this increase in income is that, if the sales price increases by $0.50 per expresso drink and the estimated sales are 1,500 units, then this will result in an increase in overall contribution margin of $750. Moreover, since all of the fixed costs were met by the lower sales price, all of this $750 goes to profit. Again, this is assuming the higher sales price does not decrease the number of units sold. Since the other coffee shops will still be priced higher than Back Door, the owner believes that there will not be a decrease in sales volume.

When making this adjustment to their sales price, Back Door Café is engaging in target pricing, a process in which a company uses market analysis and production information to determine the maximum price customers are willing to pay for a good or service in addition to the markup percentage. If the good can be produced at a cost that allows both the desired profit percentage as well as deliver the good at a price acceptable to the customer, then the company should proceed with the product; otherwise, the company will not achieve its desired profit goals.

Change in Variable Cost

In March, the owner of Back Door receives a letter from her cups supplier informing her that there is a $0.05 price increase due to higher material prices. Assume that the example uses the original $3.75 per unit sales price. The owner wants to know what would happen to net operating income if she absorbs the cost increase, so she performs the following analysis:

She is surprised to see that just a $0.05 increase in variable costs (cups) will reduce her net income by $75. The owner may decide that she is fine with the lower income, but if she wants to maintain her income, she will need to find a new cup supplier, reduce other costs, or pass the price increase on to her customers. Because the increase in the cost of the cups was a variable cost, the impact on net income can be seen by taking the increase in cost per unit, $0.05, and multiplying that by the units expected to be sold, 1,500, to see the impact on the contribution margin, which in this case would be a decrease of $75. This also means a decrease in net income of $75.

Change in Fixed Cost

Back Door Café’s lease is coming up for renewal. The owner calls the landlord to indicate that she wants to renew her lease for another 5 years. The landlord is happy to hear she will continue renting from him but informs her that the rent will increase $225 per month. She is not certain that she can afford an additional $225 per month and tells him she needs to look at her numbers and will call him back. She pulls out her Cost Volume Profit spreadsheet and adjusts her monthly fixed costs upwards by $225. Assume that the example uses the original $3.75 per unit sales price. The results of her analysis of the impact of the rent increase on her annual net income are:

Because the rent increase is a change in a fixed cost, the contribution margin per unit remains the same. However, the break-even point in both units and dollars increase because more units of contribution are needed to cover the $225 monthly increase in fixed costs. If the owner of the Back Door agrees to the increase in rent for the new lease, she will likely look for ways to increase the contribution margin per unit to offset this increase in fixed costs.

Changing Multiple Variables

We have analyzed situations in which one variable changes, but often, more than one change will occur at a time. For example, a company may need to lower its selling price to compete, but they may also be able to lower certain variable costs by switching suppliers. Suppose Back Door Café has the opportunity to purchase a new espresso machine that will reduce the amount of coffee beans required for an espresso drink by putting the beans under higher pressure. The new machine will cost $15,000, but it will decrease the variable cost per cup by $0.05. The owner wants to see what the effect will be on the net operating income and break-even point if she purchases the new machine. She has arranged financing for the new machine and the monthly payment will increase her fixed costs by $400 per month.When she conducts this analysis, she gets the following results:

Looking at the “what-if” analysis, we see that the contribution margin per unit increases because of the $0.05 reduction in variable cost per unit. As a result, she has a higher total contribution margin available to cover fixed expenses. This is good, because the monthly payment on the espresso machine represents an increased fixed cost. Even though the contribution margin ratio increases, it is not enough to totally offset the increase in fixed costs, and her monthly break-even point has risen from $4,125 to $4,688. and her profits have decreased  $325. If the new break-even point in units is a realistic number (within the relevant range), then she would decide to purchase the new machine because, once it has been paid for, her break-even point will fall and her net income will rise. Performing this analysis is an effective way for managers and business owners to look into the future, so to speak, and see what impact business decisions will have on their financial position.

Let’s look at another option the owner of the Back Door Café has to consider when making the decision about this new machine. What would happen if she purchased the new machine to realize the variable cost savings and also raised her price by just $0.20? She feels confident that such a small price increase will go virtually unnoticed by her customers but may help her offset the increase in fixed costs.

The analysis shows the expected result: an increase in the per-unit contribution margin, a decrease in the break-even point, and an increase in the net operating income of 300. She has changed three variables in her costs—sales price, variable cost, and fixed cost. In fact, the small price increase almost gets her back to the net operating income she realized before the purchase of the new expresso machine.

Our analysis shows that the investment in the machine is a good decision.

Net Present Value (NPV): $2,059 with a 10% return

Internal Rate Of Return:15.24%

Since the NPV is positive we should accept this project.

Did you notice we used two tools to anaylze this option ? Decisions often use more than one tool to evaluate the decision.

In order to perform a break-even analysis for a company that sells multiple products or provides multiple services, it is important to understand the concept of a sales mix. A sales mix represents the relative proportions of the products that a company sells—in other words, the percentage of the company’s total revenue that comes from product A, product B, product C, and so forth. Sales mix is important to business owners and managers because they seek to have a mix that maximizes profit, since not all products have the same profit margin. Companies can maximize their profits if they are able to achieve a sales mix that is heavy with high-margin products, goods, or services. If a company focuses on a sales mix heavy with low-margin items, overall company profitability will often suffer. Performing a break-even analysis for these multi-product businesses is more complex because each product has a different selling price, a different variable cost, and, ultimately, a different contribution margin. We must also proceed under the assumption that the sales mix remains constant; if it does change, the CVP analysis must be revised to reflect the change in sales mix. For the sake of clarity, we will also assume that all costs are companywide costs, and each product contributes toward covering these companywide costs.

The sales mix for West Brothers is 5 ft2 of builder grade to 3 ft2 of architectural grade to 2 ft2 of restoration grade vinyl (a ratio of 5:3:2). This sales mix represents  50% Sales of Builder Grade -30% Sales of Architectural Grade -20% Sales of Restoration Grade:

West Brothers’ fixed costs are $145,000 per year, and the variable costs for one composite unit are:

We will calculate the weighted contribution margin as follows:

We now use the average  contribution margin to determine West Brothers’ break-even point:

Break-Even Point  = Total fixed costs / Average Contribution margin  = $145,000 / $3.08 = 47,154  composite units

To determine how many of each product and the sales amount of each product  West Brothers needs to sell, we apply their sales mix ratio 50%-30%-20% to the break-even quantity as follows:

Caution: Ignoring relevant range(s) in setting assumptions about cost behavior and ignoring the actual demand for the product in the company's market also distorts the information provided to management and may cause the management of the company to produce products that cannot be sold.