Most businesses sell several products at varying prices. The products often have different unit variable costs. Thus, the total profit and the breakeven point depend on the proportions in which the products are sold. Sales mix is the relative contribution of sales among various products sold by a firm. Assume that the sales of Jordan, Inc., for a typical year are as follows:

Product Units Sold Sales Mix
A	18,000		80%
B	4,500		20%
Total =	22,500		100%
Assume the following unit selling prices and unit variable costs:
Product Selling Price Variable Cost per Unit Unit Contribution Margin
A	$80.00			$65.00			$15.00
B	$140.00			$100.00			$40.00
Fixed costs per year:
Batch-related	$60,000
Facilities-related	$340,000
	$400,000
Standard "sales basket:"
Units of Product A	4
Units of Product B	1
Increase in fixed costs =	$40,000

1.Determine the breakeven point in total units and the breakdown of the total breakeven point into sales of each of the two products, A and B. Use the weighted-average contribution margin approach.

2. Use the Goal Seek function in Excel to determine the overall breakeven point (in units) for the company.

3. Determine the breakeven point in total units and the breakdown of the total breakeven point into sales of each of the two products, A and B. Use the "sales basket" approach. (Assume that each "basket" consists of four units of A and one unit of B.)

4. Determine the overall breakeven point in terms of sales dollars based on the weighted-average contribution margin ratio. (Hint: the weights are based on relative sales dollars, not units, in the standard sales mix.) Breakdown this total into sales dollars of Product A and sales dollars of Product B.

5. Explain the following statement: "For the multiproduct firm, there is no breakeven point independent of the sales-mix assumption."

6. Assume the original facts except that now fixed costs are expected to be $40,000 higher than originally planned. How does this expected increase in cost affect the breakeven point? How does the percentage change in the breakeven point compare to the percentage increase in fixed costs? What general conclusion might you draw on the basis of these calculations?