Please ensure to include the excel formulas, so that I understand how to work the problem. Thank you

A large firm intends to increase the capacity of a bottleneck operation by adding a new machine. Two alternatives, A and B, have been identified, and the associated costs and revenues have been estimated. Annual fixed costs would be $44,000 for A and $33,300 for B; variable costs per unit would be $10.75 for A and $11.55 for B; and revenue per unit would be $15.75. a. Determine the break-even point in units for alternative A and alternative B. Based on your calculation state which option is best. b. What volume is needed to obtain a profit of $30,000 for each of the alternatives (two separate calculations)? c. If expected annual demand is 24,000 units, which alternative would yield the higher profit