Need help

Solving 5-3, 5-4, and 5-5 & 5-6 please and thank you!!!

Can you do it on excel if possible!

The management of Bootleg Company wants to know the break-even point for its new line of hiking boots under each of the following independent assumptions. The selling price is $50 per Determine break-even Problem 5-3 point under varying assumptions (L.O. 3, 4) pair of boots unless otherwise stated. (Each pair of boots is one unit.) a. Fixed costs are $300,000; variable cost is $30 per unit. b. Fixed costs are $300,000; variable cost is $20 per unit. c. Fixed costs are $250,000; variable cost is $20 per unit. d. Fixed costs are $250,000; selling price is $40; and variable cost is $30 per unit. Compute the break-even point in units and sales dollars for each of the four independent cases. Required Refer to Problem 5-3. Bootleg Company's sales are S1,100,000. Determine the margin of safety in dollars for cases ( a) through (d) Problem 5-4 Determine the margin of safety (L.O. 5) Problem 5-5 Compute the level of sales dollars needed to achieve a specified level of income Using the data in Problem 5-3 (a through d), determine the level of sales dollars required to achieve a net income of $125,000. (L.O. 6) Bikes Unlimited, Inc., sells three types of bicycles. It has fixed costs of $258,000 per month. The sales and variable costs of these products for April follow: Problem 5-6 Compute multiprodut break-even point (LO. 4 Bikes Racing Mountain Touring $1,000,000 $1,500,000 $2,500,000 700,000 900,000 1,250,000 Sales Variable costs