Comprehensive CVP analysis: Bison Industries manufactures 16GB flash drives. The current sales volume is 100,000 units per year. Price and cost data for a relevant rage extending to 200,000 units per year is as follows: $ 25 $ 8.40 8.00 Sales price per unit Variable costs per unit: Direct materials Direct labor Variable manufacturing overhead Variable SG&A Annual fixed expenses: Fixed manufacturing overhead Fixed SG&A 3.70 1.90 $ 121,800 $ 167,100 1. Using Excel, prepare a contribution margin format income statement in good form Including the current volume of 100,000 units, a per unit column and a ratio columns as appropriate. You will use the information to answer the following questions, which are posted on Bb. (See Bb CVP Assignment) You will also need to upload your Excel spreadsheet as part of the assignment. 2. What is the company's contribution margin per unit? Contribution margin ratio? Total contribution margin at the current volume? 3. What would the company's annual operating income be if it sold 130,000 units? 4. What would the company's annual operating income be if it had sales of $4,000,000? 5. What is the breakeven point in units and dollars? 6. What is the current margin of safety in units and dollars? 7. How many units would the company have to sell per year to earn a target annual profit of $260,100? Is this feasible? Why or why not. 8. BONUS: Management is currently in contract negations with the labor unlon. If the negotiations fail, direct labor costs will increase by 10% and fixed costs will increase by $23,500 per year. If these costs increase, how many units will the company have to sell each year to breakeven