$3-51$ Sales mix, two products. The Stackpole Company retails two products: a standard and a deluxe version of a luggage carrier. The budgeted income statement for next period is as follows:

Units sold

Revenues at $$28$ and $$50$ per unit Variable costs at $$18$ and $$30$ per unit

Contribution margins at $$10$ and $$20$ per unit Fixed costs

Operating income Required

Standard Carrier Deluxe Carrier $187,500$

$62,500$

$$5,250,0003,375,000$ $$1,875,000$

$$3,125,0001,875,000$ $$1,250,000$

Total $250,000$

$$8,375,0005,250,0003,125,0002,250,000$ $ $875,000$

$1.$ Compute the breakeven point in units, assuming that the company achieves its planned sales mix. $2.$ Compute the breakeven point in units $($a$)$ if only standard carriers are sold and $($b$)$ if only deluxe carriers are sold.

$3.$ Suppose $250,000$ units are sold but only $50,000$ of them are deluxe. Compute the operating income. Compute the breakeven point in units. Compare your answer with the answer to requirement $1.$ What is the major lesson of this problem. Can you please answer it in excel form? I need to transfer its answer to excel. Answering it without excel wont help me$.$ Thanks a lot.