# Le Bistro, like most other resturants, makes more than one product and would like to know its breakeven point in dollars.Example of the Multiproduct Break-even Point

### Problem Data

It is required to find the multiproduct break-even point with the following data:

Fixed Costs (F)

\$36000

Product 1

Selling Price per Unit (P): 5

Variable Cost per Unit (V): 3

Sales: 9000 units

Product 2

Selling Price per Unit (P): 1.5

Variable Cost per Unit (V): 0.5

Sales: 9000 units

Product 3

Selling Price per Unit (P): 2

Variable Cost per Unit (V): 1

Sales: 7000 units

Description
Le Bistro, like most other resturants, makes more than one product and would like to know its breakeven point in dollars.Le Bistro, like most other resturants, makes more than one product and would like to know its breakeven point in dollars. Information for Le Bistro follows. Fixed costs are \$36,000 per year. Data: Sandwich, ANNUAL FORECASTED SALES UNITS=9000, PRICE=\$5, COST=\$3. Drinks, ANNUAL FORECASTED SALES UNITS=9000, PRICE=\$1.5, COST=\$0.5. Baked potato, ANNUAL FORECASTED SALES UNITS=7000, PRICE=\$2, COST=\$1. Calculate the multiproduct break-even point.

## Solution

The following are the detailed calculations to obtain the multiproduct break-even point according to the data provided. The calculation methods and formulas are based on the book Principles of Operations Management by Jay Heizer and Barry Render:

### Break-even Point in Sales Revenue (\$)

a) Break-even Point Formula in Sales Revenue (\$):

To calculate the break-even point in sales revenue (\$), we will use the following formula

Where:

• BEP\$: Break-even point in sales revenue (\$)
• F: Fixed Cost
• Pi: Unit selling price of product i.
• Vi: Variable unit cost of product i.
• Wi: Percent each product is of total dollar sales.

Note: The entire expression in the denominator of the formula is known as the weighted contribution.

Likewise, to obtain the value of Wi, we will apply the following expression:

Where Salesi indicates the sales revenue generated by product i.

b) Table to determine the weighted contribution:

Below is a table in which we will apply the formulas indicated:

123456789
Product 1350.60.49000450000.6210.248
Product 20.51.50.3330.6679000135000.1860.124
Product 3120.50.57000140000.1930.097
Total7250010.469

c) Calculations Explained:

The results shown in the table are explained below:

• Columns 2 and 3 are data entered to solve the problem.
• Column 4 is obtained by dividing the values in column 2 and 3.
• Column 5 is obtained by subtracting the value obtained in column 4 from 1.
• Column 6 shows the sales data in units that were entered in the problem. Since it is necessary to know the sales in monetary value (\$), column 7 is calculated by multiplying column 3 by column 6.
• In column 8, the contribution to sales of each product was calculated by dividing each value in column 7 by the sum of the sales of all products: \$72500. It is essential to mention that the sum of all values in column 8 must be 1.
• Finally, in column 9, multiplying the values of column 5 and column 8. The sum of all the values in column 9 gives us a result of 0.469. This value will be used to replace the formula.

Once we have obtained the value of the denominator of our formula, we will replace its value to calculate the break-even point:

For the company to break-even, it must have revenues of \$76759.062

Based on current sales, the company has a loss of \$4259.062

d) Sales level by product for the Break-even point:

To calculate the level of sales per product to cover the break-even point, multiply the sales contribution of each product by the calculated break-even point:

ProductsSales level for BEP\$
Product 10.621x76759.062 = \$47667.378
Product 20.186x76759.062 = \$14277.186
Product 30.193x76759.062 = \$14814.499

### Break-even point in units for each product

To calculate the number of units that must be sold for each product to break even, divide the level of sales per product by its selling price:

ProductsUnits to be sold to cover BEP\$
Product 147667.378/5 = 9533.476
Product 214277.186/1.5 = 9518.124
Product 314814.499/2 = 7407.249

## Learn with step-by-step explanations

At PM Calculators we strive to help you overcome those tricky subjects in an easier way.

### Membership

#### What calculators are included?

• Critical Path PERT and CPM

• Linear Programming Methods

• Normal Distribution

• Break-even and more