Question

In: Accounting

CVP Analysis Data Unit sales     20,000 units Selling price per unit $60 per unit Variable...

CVP Analysis
Data
Unit sales     20,000 units
Selling price per unit $60 per unit
Variable expenses per unit $45 per unit
Fixed expenses $240,000
Enter a formula into each of the cells marked with a ? below
Review Problem: CVP Relationships
Compute the CM ratio and variable expense ratio
Selling price per unit ? per unit
Variable expenses per unit ? per unit
Contribution margin per unit ? per unit
CM ratio ?
Variable expense ratio ?
Compute the break-even
Break-even in unit sales ? units
Break-even in dollar sales ?
Compute the margin of safety
Margin of safety in dollars ?
Margin of safety percentage ?
Compute the degree of operating leverage
Sales ?
Variable expenses ?
Contribution margin ?
Fixed expenses ?
Net operating income ?
Degree of operating leverage ?

Solutions

Expert Solution

Particulars Amount
Unit sales 20000
Selling price(PU) 60
Variable cost per unit 45
Fixed cost 240000
Particulars Amount Remarks
Selling price per unit(SP) 60
Variable cost per unit(VC) 45
Contribution margin per unit(CM) 15
Contribution margin ratio(CM/SP*100)(P/V ratio) 0.25
Variable cost ratio(VC/SP) 0.75
Break Even sales( units) 16000
Break Even sales( $) 960000
Margin of safety(units)(Sales-BES) 4000 (20000-16000)
Margin of safety($)(Sales-BES) 240000 (20000*60-960000)
Computation of Operating Leverage
Particulars Units Amount per unit Amount
a Sales 20000 60 1200000
b Variable expenses 20000 45 900000
c Contribution margin 15 300000
d Fixed Expenses 240000
e Net operating income 60000
f Operating Leverage(c/e) 5 Times
Break even sales( in units) = Fixed cost/Contribution per unit
Break even sales( in $) = Fixed cost/P/V ratio
Margin of safety=Sales- Break even sales
Operating Leverage=Contribution/Net operating income(EBIT)
Variable cost ratio=Variable cost/sales
Contribution margin ratio=Contribution per unit/Sale value per unit

Related Solutions

Data 4 Unit sales 30,000 units 5 Selling price per unit $60 per unit 6 Variable...
Data 4 Unit sales 30,000 units 5 Selling price per unit $60 per unit 6 Variable expenses per unit $30 per unit 7 Fixed expenses $810,000 What is the break-even in dollar sales?        (b) What is the margin of safety percentage?        (c) What is the degree of operating leverage? (Round your answer to 2 decimal places.)        3. Using the degree of operating leverage and without changing anything in your worksheet, calculate the percentage change in net operating...
Sales per period 1,000 units Selling price $40 per unit Variable manufacturing cost $12 per unit...
Sales per period 1,000 units Selling price $40 per unit Variable manufacturing cost $12 per unit Selling expenses $5,100 plus 5% of selling price Administrative expenses $3,000 plus 20% of selling price note Note that some costs have variable components such as commissions on sales and shipping costs. The contribution margin ratio would be: A) 70%. B) 45%. C) 75%. D) 55%.
In CVP analysis, contribution represents the unit selling price less the unit variable cost. How does...
In CVP analysis, contribution represents the unit selling price less the unit variable cost. How does it relate to the concept of operating gearing
    Per Unit .       % of sales Selling price . $75 . 100% Variable Expenses ....
    Per Unit .       % of sales Selling price . $75 . 100% Variable Expenses . $45 . 60% Contribution Margin . $30 40% Fixed expenses are $75,000 per month and the company is selling 3,000 units per month. 2. Refer to the original data . Management is considering using higher quality components that would increase variable cost by $3 per unit. The manager believes that the higher quality product would increase sales by 15% per month. Should the higher...
The budgeted selling price per unit is $60. Budgeted unit sales for June, July, August, and...
The budgeted selling price per unit is $60. Budgeted unit sales for June, July, August, and September are 8,900, 20,000, 22,000, and 23,000 units, respectively. All sales are on credit. Forty percent of credit sales are collected in the month of the sale and 60% in the following month. The ending finished goods inventory equals 20% of the following month’s unit sales. The ending raw materials inventory equals 10% of the following month’s raw materials production needs. Each unit of...
1.A company has provided the following data:   Sales 12,000 units   Sales price $100 per unit   Variable...
1.A company has provided the following data:   Sales 12,000 units   Sales price $100 per unit   Variable cost $50 per unit   Fixed cost $300,000             If the dollar contribution margin per unit is increased by 10%, total fixed cost is decreased by 20%, and all other factors remain the same, by how much will net income increase? 2.   Hamada Company sells a single product. The product has a selling price of $100 per unit and variable expenses of 80% of sales. If the...
Sales price per unit: (current monthly sales volume is 120,000 units). . . . $25.00 Variable...
Sales price per unit: (current monthly sales volume is 120,000 units). . . . $25.00 Variable costs per unit: Direct materials. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $6.60 Direct labor. . . . . . . . . . . . . . . ....
Sales (in units) 60,000 Selling price per unit $25 Manufacturing costs per unit:   Materials 5   Direct...
Sales (in units) 60,000 Selling price per unit $25 Manufacturing costs per unit:   Materials 5   Direct labor 4   Overhead         Variable 4          Fixed 6     Total $19 Gross margin 6 Selling and admin. Expenses per unit 2 Operating income $4 A company in a foreign market offer to buy and the offer specifies the following data units to be sold 10,000 price per unit $12 The incremental profit should be
Selling price is $15 per unit Sales by month: April 25,000 units May 50,000 units June...
Selling price is $15 per unit Sales by month: April 25,000 units May 50,000 units June 40,000 units July 30,000 units August 20,000 units Cash Collections 60% collected in month of sale 40% collected in the month after sale Accounts receivable at the end of March is $25,000 and it will be collected in April Production Budget Ending inventory is 25% of next month’s budgeted sales On March 31st there were 5,000 units on hand Direct Materials Budget 5 pounds...
Problem 2 Total Per Unit Percent of Sales Sales (40,000 units) 2,400,000 60 100% Variable expenses...
Problem 2 Total Per Unit Percent of Sales Sales (40,000 units) 2,400,000 60 100% Variable expenses 1,600,000 40 ? % Contribution margin 800,000 ? % Fixed expenses 500,000 Net operating income 300,000 Calculate variable expense ratio. Calculate contribution margin ratio. Calculate break even sales in units (show your work). Calculate break even sales in Dollars. How many units must be sold to make a profit of SAR 200,000. Management is considering increasing quality of its units by spending SAR 3...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT