SOLVE LISTING OUT ALL THE STEPS SO THAT I CAN LEARN

A firm manufactures and sells a widgets. The company's contribution format income statement for the most recent year is given below: Total Per Unit Percent of Sales 100% Sales (20,000 units).. $1,200,000 $0 Variable expenses Fixed expenses .. Net operating income ..60,000 900,000 45 300,000 $15 240,000 a. Compute the company's break-even point in both units and sales dollars b. Using excel, conduct some basic sensitivity analysis using a range of plus 10% minus 10% variation on sales, fixed expenses and variables. Compute how much the company's net operating income will change (in dollar value and percentage) and breakeven point (in sales and quantity) when these changes are employed? Please review these changes on operating income one a time - not altogether Refer to the original data. Assume that next year management wants the company to earn a profit of at least $90,000. How many units will have to be sold to meet this target profit? c. d. Outline the major a e. How are breakeven analysis and business risk related? Explain