number 4 please

Done 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 Units Sold Sales Mix 18,000 20 Total Assume the following unit selling prices and unit variable costs Product Selling Price per UiVariable Cost per Unit Contribution Margin per Unit S15 40 140 100 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. . 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 nto 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.) Determine the overall breakeven point in terms of sales dollars based on the weighted- average contribution margin ratio (CMR). (Hint: The weights for caloulating 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 im, 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 fxed costs? What general conclusion might you draw on the basis of these calculations? questions 1-6