Statement Showing Net Operating Income at Various Sales Level |
|||||
Sales Volume in Unit |
|||||
Per Unit |
8,600 Units |
(8,600+90) |
(8,600-90) |
7600 Units |
|
Sales |
$35.00 |
$301,000.00 |
$304,150.00 |
$297,850.00 |
$266,000.00 |
Variable Expenses |
$20.00 |
$172,000.00 |
$173,800.00 |
$170,200.00 |
$152,000.00 |
Contribution Margin (Sales - Variable Expense) |
$15.00 |
$129,000.00 |
$130,350.00 |
$127,650.00 |
$114,000.00 |
Fixed Expenses |
$55,600.00 |
$55,600.00 |
$55,600.00 |
$55,600.00 |
|
Net Operating Income (Contribution Margin - Fixed Expenses) |
$73,400.00 |
$74,750.00 |
$72,050.00 |
$58,400.00 |
This can also be calculated by another method,
1. Profit Volume(PV) Ratio = (Contribution Margin / Sales) *100
= ($15.00 / $35.00) *100 =42.86%
2. Contribution Margin = Sales * PV Ratio
Now, Operating Profit = Contribution Margin - Fixed Expenses
Requirement 1. Sales volume increased by 90 units
Units sold = 8,600 units + 90 units = 8,690 units
Sales = 8,690 units * $35.00 = $304,150.00
Contribution Margin = $304,150.00 * 42.86% = $130,358.69
So, Operating Profit = $130,358.69 - $55,600.00 = $74,758.69
Requirement 2. Sales volume decreased by 90 units
Units sold = 8,600 units - 90 units = 8,510 units
Sales = 8,510 units * $35.00 = $297,850.00
Contribution Margin = $297,850.00 * 42.86% = $127,658.51
So, Operating Profit = $127,658.51 - $55,600.00 = $72,058.51
Requirement 3. Sales volume 7,600 units
Units sold = 7,600 units
Sales = 7,600 units * $35.00 = $266,000.00
Contribution Margin = $266,000.00 * 42.86% = $114,007.60
So, Operating Profit = $114,007.60 - $55,600.00 = $58,407.60
Note: As PV Ratio is taken to two decimal places there is a little difference between the actual figures and the figures calculated by PV Ratio.
Exercise 6-1 The Effect of Changes in Activity on Net Operating Income (LO6-1] Whirly Corporation's contribution...
Exercise 6-1 The Effect of Changes In Activity on Net Operating Income [LO6-1] Whirly Corporation's contribution format Income statement for the most recent month is shown below. Total Sales (8,5ee units) Variable expenses Contribution margin Fixed expenses Net operating income $ 297,500 170,000 127,500 55,100 $ 72,480 Per Unit $ 35.00 20.00 $ 15.00 Required: (Consider each case Independently): 1. What would be the revised net operating Income per month If the sales volume Increases by 70 units? 2 What...
Exercise 6-1 The Effect of Changes in Activity on Net Operating Income (LO6-1) Whirly Corporation's contribution format income statement for the most recent month is shown below: points Skipped Sales (8,100 units) Variable expenses Contribution margin Fixed expenses Net operating income Total $ 267,300 162,000 105,300 54,800 $ 50,500 Per Unit $ 33.00 20.00 $ 13.00 eBook Required: (Consider each case independently): Print 1. What would be the revised net operating income per month if the sales volume increases by...
Exercise 6-1 The Effect of Changes in Activity on Net Operating Income (L06-1] Whirly Corporation's contribution format income statement for the most recent month is shown below: Total $ 240,000 152,000 88,000 54,100 $ 33,900 Per Unit $ 30.00 19.00 $ 11.00 Sales (8,000 units) Variable expenses Contribution margin Fixed expenses Net operating income ces Required: (Consider each case independently): 1. What would be the revised net operating income per month if the sales volume increases by 70 units? 2....
Exercise 5-1 The Effect of Changes in Activity on Net Operating Income (L05-1) Whirly Corporation's contribution format income statement for the most recent month is shown below: Sales (7,400 units) Variable expenses Contribution margin Fixed expenses Net operating income Total $ 259,000 133,200 125,800 55,700 $ 70,100 Per Unit $ 35.00 18.00 $ 17.00 Required: (Consider each case independently): 1. What would be the revised net operating income per month I the sales volume increases by 90 units? 2. What...
Exercise 5-1 The Effect of Changes in Activity on Net Operating Income (LO5-1) Whirly Corporation's contribution format income statement for the most recent month is shown below. Sales (7,eee units) Variable expenses Contribution margin Fixed expenses Net operating income Total $ 217,eee 133,eee 84, eee 54,500 $ 29,500 Per Unit $31.00 19.ee $12.00 Required: (Consider each case independently) 1. What would be the revised net operating income per month if the sales volume increases by 90 units? 2. What would...
Exercise 6-1 The Effect of Changes in Activity on Net Operating Income (L06-1] Whirly Corporation's contribution format income statement for the most recent month is shown below: Sales (7,200 units) Variable expenses Contribution margin Fixed expenses Net operating income Total $ 237,600 136,800 100,800 55,900 $ 44,900 Per Unit $ 33.00 19.00 $ 14.00 Required: (Consider each case independently): 1. What would be the revised net operating income per month if the sales volume increases by 60 units? 2. What...
Exercise 5-1 The Effect of Changes in Activity on Net Operating Income (LO5-1] Whirly Corporation's contribution format income statement for the most recent month is shown below: Sales (10,000 units) Variable expenses Contribution margin Fixed expenses Net operating income Total $ 350,000 200,000 150,000 135,000 $ 15,000 Per Unit $35.00 20.00 $15.00 Required: (Consider each case independently): 1. What would be the revised net operating income per month if the sales volume increases by 100 units? 2. What would be...
Exercise 5-1 The Effect of Changes in Activity on Net Operating Income [LO5-1] Whirly Corporation’s contribution format income statement for the most recent month is shown below: Total Per Unit Sales (8,600 units) $ 258,000 $ 30.00 Variable expenses 163,400 19.00 Contribution margin 94,600 $ 11.00 Fixed expenses 54,400 Net operating income $ 40,200 Required: (Consider each case independently): 1. What would be the revised net operating income per month if the sales volume increases by 100 units? 2. What...
Exercise 2-1 (Algo) The Effect of Changes in Activity on Net Operating Income (LO2-1] Whirly Corporation's contribution format income statement for the most recent month is shown below: Sales (7,300 units) Variable expenses Contribution margin Fixed expenses Net operating income Total $ 248,200 138,700 109,500 54,500 $ 55,000 Per Unit $ 34.00 19.00 $ 15.00 Required: (Consider each case independently): 1. What would be the revised net operating income per month if the sales volume increases by 80 units? 2....
no shown work needed Exercise 6-1 The Effect of Changes in Activity on Net Operating Income (LO6-1) Whirly Corporation's contribution format income statement for the most recent month is shown below: Sales (8,400 units) Variable expenses Contribution margin Fixed expenses Net operating income Total $ 285,600 159,600 126,000 55,300 $ 70, 700 Per Unit $ 34.00 19.00 $15.00 Required: (Consider each case independently): 1. What would be the revised net operating income per month if the sales volume increases by...