questions 1-6

Profit-Planning: Multiple Products 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 18,000 4,500 22,500 Sales Mix 80% 20 100% Total Assume the following unit selling prices and unit variable costs Product Selling Price per Unit S 80 140 Variable Cost per Unit S 65 100 Contribution Margin per Unit 40 Fixed costs are $400,000 per year. Assume that the sales mix, expressed in terms of relative physical units sold, is constant as sales volume changes Required 1. Determine the breakeven point in total units and the breakdown of the total breakeven point into sales (in units) 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 (in units) 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 (CMR). (Hint: The weights for calculating the weighted-average CMR are based on relative sales dollars, not units, of the two products.) Break down the total breakeven point in sales dollars into sales dollars for product A and sales dollars for 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 fixed 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