3-38 please show all equations to each answers so I can understand and learn from this CVP analysis. If done with excel please make sure I know what components are in equation. Show all work please. Thank you

Evaluate each of the alternatives considered by Derby Shoes. Do any of the options meet or exceed Derbys targeted increase in income of 25%? what should Derby do? 3-38 CVP analysis, shoe stores. The HighStep Shoe Company operates a chain of shoe stores that sell 10 different styles of inexpensive men's shoes with identical unit costs and selling prices. A unit is defined as a pair of shoes. Each store has a store manager who is paid a fixed salary. Individual salespeople receive a fixed salary and a sales commission. HighStep is considering opening another store that is expected to have the revenue and cost relationships shown here. Home InsertPage Layout Unit Variable Data (per pair of shoes) Annual Fixed Costs $60.00 $37.00 2 Selling price 3 Cost of shoes 4 Sales commission 5 Variable cost per unit $ 30,000 100,000 40,000 10,000 $180,000 Rent Salaries $40.00 Total fixed costs Consider each question independently 1. What is the annual breakeven point in (a) units sold and (b) revenues? 2 If 8,000 units are sold, what will be the store's operating income (loss)? 3. If sales commissions are discontinued and fixed salaries are raised by a total of $15,500, what would 4. Refer to the original data. If, in addition to his fixed salary, the store manager is paid a commission of 5. Refer to the original data. If, in addition to his fixed salary, the store manager is paid a commission of be the annual breakeven point in (a) units sold and (b) revenues? $2.00 per unit sold, what would be the annual breakeven point in (a) units sold and (b) revenues? $2.00 per unit in excess of the breakeven point, what would be the store's operating income if 12,000 units were sold