1-Make a table that shows the following (use Excel):

-previous price points and the two proposed price points.

-Cost per unit for each price point

-Unit sales corresponding to each price

-Gross profit corresponding to each price

2-What other factors should Courtneys consider?

3-What is your recommendation for the price? Support your answer with clear rationale and assumptions for your calculations. A recommendation without any calculations will not receive any credit. . (you may use a combination of prices or a different price from those discussed in the case; try to show an optimistic scenario and a pessimistic scenario) -

**please show th Exel steps **