Contribution Analysis

Breakeven Analysis for Product Tylenol Approach 1 - Same price as Tylenol Approach 2a - Cheaper than Tylenol Approach 2b - Cheaper w/lowered trade cost $ $ $ $ Unit Cost (Variable Cost) 0.60 0.60 0.60 0.60 Trade Cost (Selling Price to Retailers) $ 1.69 $ 1.69 $ 1.05 $ 0.70 Fixed Cost (Advertising) 2,000,000 6,000,000 6,000,000 6,000,000 Break-Even Quantity [Fixed Cost/(Trade Cost-Unit Cost)] 1,834,862 5,504,587 13,333,333 60,000,000 Contribution Margin (Unit) 64% 64% 43% 14%

Although the financial goal is to create profit, we need to calculate the breakeven point to get started.

5. Determine the necessary sales in unit and dollars to break-even or attain desired profit using the break-even formula.

To find the break-even point for napkins, you use the same formula. The fixed cost is still $420,000.00. The selling price of napkins is $7.00. The variable cost is $4.50. $7.00 minus $4.50 is $2.50. So then you take $420,000.00 and divide it by $2.50 to find the breaking point of $168,000.00. The company will have to sell $168,000.00 to break even in sales. The margin for safety for napkins is -$48,000.00. This is found by subtracting the actual or expected cost of $120,000.00 by the break-even point of $168,000.00. You can cut sales by $48,000.00 and not sustain a loss.

3. Market research estimates that monthly equipment production could be increased to 3,500 units which is well within production capacity limitations, if the price were cut from $1,580 to $1,400 per unit. Assuming the cost behavior patterns implied by the data in Exhibit 1 are correct, would you recommend that this action be taken? What would be the impact on monthly sales, costs, and income?

Because each product has a different contribution margin percentage, the volume required for each break-even point would be different and will not add up to the company’s overall break-even volume of 1,100,000 units; the overall break-even volume assumes that there is only one contribution margin percentage which is :

As upper-level management it is important to understand the key components of cost-volume-profit analysis. Identifying objectives including concepts related to CVP is crucial to the absorption of information.

If Marlene Herbert were to discontinue place mats, he would miss $270,000 that will go toward Mendel paper company fixed cost. The company currently has a plant overhead that is estimated at $420,000 for the quarter. In addition to the fixed plant overhead, the plant incurs fixed selling and administrative expenses per quarter of $118,000. This draws the company to a total fixed cost of $538,000. If Marlene Herbert were to discontinue the second highest contributor to the fixed cost, he would need to increase the volume of computer paper and lower material cost to help pull the contribution margin of the lowest product up to help support the lost of a whole product line.

There are some limitations of break-even as well. For example, it cannot give accurate results if the data used for it is predicted. Data such as change in direct cost

This question gives students an opportunity to exercise their ability to interpret break-even analyses. Key teaching points should include explaining the preparation of a break-even chart, the interpretation of the break-even volume (938,799 hectoliters [HL]), and the comparison of the break-even volume to the current volume (1,173,000 HL). Another key point is that the chart in case Exhibit 5 is relevant only for the current cost structure of the company—if variable costs increase or the plant expansion is approved, the break-even volume will rise. Finally, students should be aided in understanding that “break-even” refers to operating profit, not free cash flow. The typical use of the break-even chart ignores taxes, investments, and the depreciation tax shield.

Break-even point analysis is a measurement system that calculates the margin of safety by comparing the amount of revenues or units that must be sold to cover fixed and variable costs associated with making the sales. In other words, it’s a way to calculate when a project will be profitable by equating its total revenues with its total expenses. There are several different uses for the equation, but all of them deal with managerial accounting and cost management (Break-Even Point, n.d.)

Break even analysis can be used to decide whether to alter the existing product emphasis or not. For example in this case, if we refer last year’s data, we can see that the product C is not economically feasible to manufacture at $2.40 / unit. Following table gives the analysis for checking whether the company can afford to invest in additional “C” capacity.

While cost is seldom the only criterion used in a make-or-buy decision, simple break-even analysis can be an effective way to quickly surmise the

Break Even Point in Sales = (Total Fixed Costs + Target Profit) ÷ Contribution Margin Ratio

Assigning the overhead costs to the products shows how profitable the products are after deducting all cost. However, it is important to find the appropriate method of overhead cost allocation. In Sippican’s case the traditional accounting method is used, which does not reflect the real resource usage of the different product lines. The correct method in this case would be to apply the time-driven ABC approach for cost allocation. Such method apart from showing the actual profitability after all cost deductions also depicts the differences in resource usage rates between the products and, thus, allows for identification of cost drivers. A contribution margin