Mr. Byrd wants to see how different scenarios impact the net income. In addition to the current scenario, he wants to investigate two additional scenarios. In the first scenario he wants to increase the number of units sold to 150, decrease revenue per unit to $950, and decrease variable costs per unit to $700. In the second scenario, he wants to decrease the number of units sold to100, increase revenue to $1,050 per unit and increase labor by $50. Using scenario manager prepare the three scenarios and generate a scenario summary report.

P.S: if you can solve this issues problem by excel or any program. Would you mind to explain to me step by step and what formula did you use to solve it? I don't only want the answer but also learn how to do it.