Please show formula and show HOW TO CALCULATE FROM STEP BY STEP! I have to follow the structure and put into excel THANK YOU!

Angie has ecently opened The Sandal Shop in France, a store that specializes in fashionable sandals. Angie has just received a degree in business and she is anxious to apply the principles he has learned to his business. In time, he hopes to open a chain of sandal shops. As a first step, he has prepared the following analysis for his new store:

Sales price per pair of sandals $ 40

Variable expense per pair of sandals 16

Fixed expense per year $ 60,000

REQUIRED

1. How many pairs of sandals must be sold each year to break even? What does this represent in total sales dollars (How much at break even)? (30 marks)
2. Angie has decided that he must have net income $24,000 the first year to justify his time and effort (Assume income tax 25%). How many pairs of sandals must be sold to reach this target profit? (35 marks)
3. Angie now has two salespersons working in the store - one full time and one part time. It will cost his an additional $8,500 per year to convert the part-time position to a full-time position. Angie believes that the change would bring in an additional $25,000 in sales each year.Should he convert the position?Determine the impact of this conversion. (35 marks)

NOTE:

Break even point = (Total Fixed Cost + Earning before tax) / (Sales price per unit - Variable expense per unit)

Earning before tax = Net Income / ( 1 - Tax Rate)