Can you please answer 1-15 using excel and showing steps.

connect The Foundational 15 Oslo Company prepared the following contribution format income statement based on a sales volume of 1,000 units (the relevant range of production is 500 units to 1,500 units) L05-1, L05-3, L05-4, L05-5, L05-6, L05-7, Sales L05-8 Variable expenses. .. $20,000 12,000 Contribution margin Fixed expenses 8,000 6,000 Net operating income. $ 2,000 Required: (Answer each question independently and always refer to the original data unless instructed otherwise.) 1. What is the contribution margin per unit? 2. What is the contribution margin ratio? . What is the variable expense ratio? 4. If sales increase to 1,001 units, what would be the increase in net operating income? 5. If sales decline to 900 units, what would be the net operating income? 6. If the selling price increases by $2 per unit and the sales volume decreases by 100 units, what would be the net operating income? 7. If the variable cost per unit increases by $1, spending on advertising increases by $1,500, and unit sales increase by 250 units, what would be the net operating income? . What is the break-even point in unit sales? 9. What is the break-even point in dollar sales? 10. How many units must be sold to achieve a target profit of $5,000? l. What is the margin of safety in dollars? What is the margin of safety percentage? 12. What is the degree of operating leverage? 13. Using the degree of operating leverage, what is the estimated percent increase in net operat- ing income that would result from a 5% increase in unit sales?Chapter 5 14. Assume that the amounts of the company's total variable expenses and total fixed expenses were reversed. In other words, assume that the total variable expenses are $6,000 and the total fixed expenses are $12,000. Under this scenario and assuming that total sales remain the same, what is the degree of operating leverage? 15. Using the degree of operating leverage that you computed in the previous question, what is the estimated percent increase in net operating income that would result from a 5% increase in unit sales? nect EXERCISE 5-1 The Effect of Changes in Sales Volume on Net Operating Income LO5-1 below: Whirly Corporation's contribution format income statement for the most recent month is shown Total Sales (10,000 units) Per Unit Variable expenses $350.000