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 [Thefollowing information applies to the questions displayed below.) Oslo Company prepared thefollowing contribution format income statement based on a sales volume of 1,000units (the relevant range of production is 500 units to 1,500 units):Sales Variable expenses Contribution margin Fixed expenses Net operating income $ 85,00059,500 25,500 20,400 $ 5,100 Required: 1. What is the contribution marginper unit? (Round your answer to 2 decimal places.) Contribution margin per

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!