Req 1 : | |
Contribution margin per unit = Contribution margin / Units sold = 120000 / 15000 | 8 |
Contribution margin ratio = Contribution margin / Sales = 120000 / 300000 | 40% |
Break-even point in units = Fixed expenses / Contribution margin per unit = 130000 / 8 | 16250 |
Break-even point in dollars = Fixed expenses / Contribution margin ratio = 130000 / 40% | 325000 |
Req 2 : | |
Increase in Contribution margin ( Increase in sales * Contribution margin ratio = 100000 * 40% ) | 40000 |
(-) Increase in advertising budget | 14000 |
Increase (decrease) in net operating income | 26000 |
Increase in monthly net operating income | 26000 |
Req 3 : | |
Revised selling price = Current selling price * ( 1 - % reduction ) = 20 * ( 1 - 10% ) | 18 |
Current unit variable cost = Variable expenses / Units sold = 180000 / 15000 | 12 |
Revised fixed costs = Current fixed costs + Increase in advertising expense = 130000 + 65000 | 195000 |
Revised sales units = Current sales units * 2 = 15000 * 2 | 30000 |
Sales ( 30000 * 18 ) | 540000 |
(-) Variable expenses ( 30000 * 12 ) | 360000 |
Contribution margin | 180000 |
(-) Fixed expenses | 195000 |
Net operating income (loss) | (150000 |
Req 4 : | |
Revised unit variable cost = Current unit variable cost + 0.5 = 12 + 0.5 | 12.5 |
Units sales to attain target profit = ( Target profit + Fixed expenses ) / ( Selling price - Unit variable cost ) = ( 8750 + 130000 ) / ( 20 - 12.5 ) | 18500 |
Req 5A : | |
Revised unit variable cost = 12 * 1/2 | 6 |
Revised fixed expenses = 130000 + 40800 | 170800 |
Contribution margin per unit = Selling price - Unit variable cost = 20 - 6 | 14 |
CM ratio = Contribution margin per unit / Selling price = 14 / 20 | 70% |
Break-even point in unit sales = Fixed costs / Contribution margin per unit = 170800 / 14 | 12200 |
Break even point in dollar sales = Fixed costs / CM ratio = 170800 / 70% | 244000 |
Req 5B : | ||||||
Not automated | Automated | |||||
Total | Per unit | % | Total | Per unit | % | |
Sales | 400000 | 20 | 100% | 400000 | 20 | 100% |
Variable expenses | 240000 | 12 | 60% | 120000 | 6 | 30% |
Contribution margin | 160000 | 8 | 40% | 280000 | 14 | 70% |
Fixed expenses | 130000 | 170800 | ||||
Net operating income | 30000 | 109200 |
Memofax, Inc. produces memory enhancement software for computers. Sales have been very erratic, with some months...
Memofax, Inc. produces memory enhancement software for computers. Sales have been very erratic, with some months showing a profit and some months showing a loss. The company's contribution format income statement for the most recent month is given below: Sales (18,000 units at $25 per unit) Less: Variable expenses $450,000 270,000 Contribution margin Less: Fixed expenses 180,000 188,000 Net operating loss $ (8,000) Required: 1. Compute the company's CM ratio and its break-even point in both units and dollars. Contribution...
Memofax, Inc. produces memory enhancement software for computers. Sales have been very erratic, with some months showing a profit and some months showing a loss. The company's contribution format income statement for the most recent month is given below: Sales (18,000 units at $25 per unit) Less: Variable expenses $450,000 270,000 Contribution margin Less: Fixed expenses 180,000 188,000 Net operating loss $ (8,000) Required: 1. Compute the company's CM ratio and its break-even point in both units and dollars. Contribution...
Memofax, Inc. produces memory enhancement software for computers. Sales have been very erratic, with some months showing a profit and some months showing a loss. The company's contribution format income statement for the most recent month is given below: Sales (16,500 units at $40 per unit) Less: Variable expenses $660,000 495,000 Contribution margin Less: Fixed expenses 165,000 170,000 $(5,000) Net operating loss Required: 1. Compute the company's CM ratio and its break-even point in both units and dollars. Contribution margin...
Memofax, Inc. produces memory enhancement software for computers. Sales have been very erratic, with some months showing a profit and some months showing a loss. The company's contribution format income statement for the most recent month is given below: Sales (14,500 units at $24 per unit) Less: Variable expenses $348,000 261,000 Contribution margin Less: Fixed expenses 87,000 96,000 Net operating loss $ (9,000) Required: 1. Compute the company's CM ratio and its break-even point in both units and dollars. Contribution...
Memofax, Inc. produces memory enhancement software for computers. Sales have been very erratic, with some months showing a profit and some months showing a loss. The company's contribution format income statement for the most recent month is given below: Sales (18,000 units at $25 per unit) Less: Variable expenses $450,000 270,000 Contribution margin Less: Fixed expenses 180,000 188,000 Net operating loss $ (8,000) Required: 1. Compute the company's CM ratio and its break-even point in both units and dollars. Contribution...
Memofax, Inc. produces memory enhancement software for computers. Sales have been very erratic, with some months showing a profit and some months showing a loss. The company's contribution format income statement for the most recent month is given below: Sales (22,500 units at $30 per unit) Less: Variable expenses $675,000 472,500 Contribution margin Less: Fixed expenses 202,500 211,500 Net operating loss $ (9,000) Required: 1. Compute the company's CM ratio and its break-even point in both units and dollars. Contribution...
Memofax, Inc. produces memory enhancement software for computers. Sales have been very erratic, with some months showing a profit and some months showing a loss. The company’s contribution format income statement for the most recent month is given below: Sales (14,000 units at $25 per unit) $ 350,000 Less: Variable expenses 210,000 Contribution margin 140,000 Less: Fixed expenses 148,000 Net operating loss $ (8,000) Required: 1. Compute the company’s CM ratio and its break-even point...
Memofax, Inc. produces memory enhancement software for computers. Sales have been very erratic, with some months showing a profit and some months showing a loss. The company’s contribution format income statement for the most recent month is given below: Sales (22,500 units at $30 per unit) $ 675,000 Less: Variable expenses 472,500 Contribution margin 202,500 Less: Fixed expenses 211,500 Net operating loss $ (9,000) Required: 1. Compute the company’s CM ratio and its break-even point...
Memofax, Inc. produces memory enhancement software for computers. Sales have been very erratic, with some months showing a profit and some months showing a loss. The company’s contribution format income statement for the most recent month is given below: Sales (16,000 units at $40 per unit) $ 640,000 Less: Variable expenses 448,000 Contribution margin 192,000 Less: Fixed expenses 201,000 Net operating loss $ (9,000) Required: 1. Compute the company’s CM ratio and its break-even point...
Memofax, Inc. produces memory enhancement software for computers. Sales have been very erratic, with some months showing a profit and some months showing a loss. The company’s contribution format income statement for the most recent month is given below: Sales (12,500 units at $20 per unit) $ 250,000 Less: Variable expenses 150,000 Contribution margin 100,000 Less: Fixed expenses 106,000 Net operating loss $ (6,000) Required: 1. Compute the company’s CM ratio and its break-even point...