Question: please show work in excell, thanks :) ! Required information [The following information applies to the questions displayed below.) Oslo Company prepared the following contribution







please show work in excell, thanks :)
! Required information [The following information applies to the questions displayed below.) 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): Sales Variable expenses Contribution margin Fixed expenses Net operating income $ 85,000 59,500 25,500 20,400 $ 5,100 Required: 1. What is the contribution margin per unit? (Round your answer to 2 decimal places.) Contribution margin per unit 2. What is the contribution margin ratio? Contribution margin ratio % 3. What is the variable expense ratio? Variable expense ratio % 4. If sales increase to 1,001 units, what would be the increase in net operating income? (Round your answer to 2 decimal places.) Increase in net operating income 5. If sales decline to 900 units, what would be the net operating income? 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? Net operating income 7. If the variable cost per unit increases by $1, spending on advertising increases by $1,750, and unit sales increase by 250 units, what would be the net operating income? Net operating income
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
