Question

In: Accounting

Question 1: CVP relation Sales volume in units 100 Revenue $7,000   Variable costs $4,000 Contribution margin...

Question 1: CVP relation

Sales volume in units 100
Revenue $7,000
  Variable costs $4,000
Contribution margin $3,000
  Fixed costs $1,800
Profit $1,200


a) Compute the following items:
    price=    
    unit VC=    
    unit CM=  

b) Write down the CVP relation.
  Profit = ___________ * volume - __________

(e.g., if Profit=4*volume-1000, enter 4 in the first box and 1000 in the second box).

c) Predict profit at sales volume of 120 units:


d) Your boss gave you a profit target of $2,100. How many units do you need to sell to meet this target?


e) Compute the breakeven point:
    breakeven volume =  
    breakeven revenue =  

f) Compute the margin of safety at current sales volume of 100 units:

(e.g., if your answer is 20%, enter 20 without the % sign)
If sales decrease by 35%, will you lose money? YES / NO
If sales decrease by 45%, will you lose money? YES / NO


g) When sales volume increases by 10 units (from any initial level in the relevant range), profit increases by:

price*10 = $700

unit VC*10 = $400

not enough informationunit

CM*10 = $300

Solutions

Expert Solution

a) How much is the price per unit, unit variable cost and unit contribution margin? price = revenue/volume = $7,000/100 = $70 per unit

unit VC = VC/volume = $4,000/100 = $40 per unit

unit CM = CM/volume =$3,000/100 = $30/unit (or use unit CM = price – unit VC)

___________________________

b) Write down the CVP relation:

profit as a function of sales volume in units.

Profit = unit CM * Volume - FC = $30*Volume - $1,800

_____________________________________________________

c)

If sales volume increases by 20% (from 100 to 120), how much is the $ change in profits?

at volume = 120, profit = $30*120 - $1,800 = $1,800 (vs original profit of $1,200 from the CM statement)

change in profit

= $1,800 - $1,200

= $600

– increase of $600 Alternatively, can compute as: change in profit

= unit CM * change in volume = $30*(120-100) = $600

_____________________________________________

d)

What is the sales volume required to achieve target profit of $2,100?

Profit = $30*Volume - $1,800 = $2,100 => volume = (2,100+1,800)/30 = 130 units

____________________________________________

e)

How much is the breakeven volume? Breakeven revenue?

Breakeven volume = FC/unit CM = $1,800/$30 = 60 units.

(or, solve for volume in:

Profit = $30*Volume - $1,800 = $0). Breakeven revenue = breakeven volume * price = 60*$50 = $3,000

___________________________________________

f)

How much is the margin of safety (at current sales volume of 100 units)?

Margin of safety = (current volume – breakeven volume) / current volume = (100-60)/100 = 40%

______________________________________________________

g)

When sales volume increases by 10 units (from any initial level in the relevant range), profit increases by:

Sales increase =70*10 = $700

unit VC increase 40*10 = $400

CM increase 3*10 = $300

Increase in FC =0

Increase in profit =300


Related Solutions

Contribution Margin Analysis: We calculate contribution margin by taking our sales revenue less our variable costs....
Contribution Margin Analysis: We calculate contribution margin by taking our sales revenue less our variable costs. This basically tells us the portion of our sales that are available to cover the fixed cost of the business. Contribution margin per unit is especially useful. We compute this by taking our sales revenues per unit less our variable cost per unit. With this, we can easily compute our break-even point. Dog Day Care Pricing at $18 per dog per day, you can...
Contribution Margin Format Example: Volume XX Sales XX Variable Costs (Listed) XX Variable Costs (Total) XX...
Contribution Margin Format Example: Volume XX Sales XX Variable Costs (Listed) XX Variable Costs (Total) XX Contribution Margin XX Fixed Costs (Listed) XX Fixed Costed (Total) XX Operating Income XX Vroom-Vroom manufactures ride-on cars for toddlers and young children. They have a fiscal year of January through December. When they were preparing their budget, they couldn’t decide if a static or flexible budget would be best for their company – so they did both. It is now March, and their...
Sales (4,000 units) $200,000 Variable expenses 110,000 Contribution margin 90,000 Fixed expenses 48,000 Net operating income...
Sales (4,000 units) $200,000 Variable expenses 110,000 Contribution margin 90,000 Fixed expenses 48,000 Net operating income $42,000 A)What is the contribution margin per unit? B)What is the contribution margin ratio? C)What is the variable expense ratio? D) If sales increase to 6,050 units, what would be the estimated net operating income? E) If the selling price decreases by $4 per unit and the sales volume increases by 200 units, what would be the estimated net operating income? F) If the...
Contribution margin is:       A.    the excess of sales revenue over variable cost       B.    another...
Contribution margin is:       A.    the excess of sales revenue over variable cost       B.    another term for volume in the "cost-volume-profit" analysis       C.    profit       D.    the same as sales revenue Salim’s fixed costs are RM41, 500, the variable cost is RM12 per unit. If Salim sells the product for RM22 per unit, the breakeven point is:       A.    4,150 units       B.    8,300 units       C.    2,075 units       D.    6,225 units The fixed costs of Juara...
Contribution Income Statement Sales (16,000 units) ……………………….. 128,000 Variable expenses ……………………… 80,000 Contribution Margin ………………… 48,000...
Contribution Income Statement Sales (16,000 units) ……………………….. 128,000 Variable expenses ……………………… 80,000 Contribution Margin ………………… 48,000 Fixed expenses ………………………… 12,000 Net Operating Income ………………. 36,000 Jackpot company sells a single product, has provided its contribution format income statement for June. Required: Prepare Contribution Income Statement assuming that the business expects an increase in its total sales (as revenue) by 10% and decrease in variable cost per unit by $3. (2.5 marks) Refer to the original data, how much is the...
Question 1: Cost allocation Product A Product B Total sales volume (units) 180 100 280 Revenue...
Question 1: Cost allocation Product A Product B Total sales volume (units) 180 100 280 Revenue $3,000 $18,000 $21,000 Variable costs:   direct materials $600 $1,200 $1,800   direct labor $1,200 $3,000 $4,200 Contribution margin $1,200 $13,800 $15,000   Fixed costs $12,600 Profit $2,400 a) Allocate the fixed costs between products A and B. Use direct labor dollars as the cost driver. allocation rate=$  per DL$ allocated costs for A=$ allocated costs for B=$ b) Compute the profit margins for products A and B:...
1). Contribution Margin is: a). Sales - Total Variable expenses b). Sales - Total variable expenses...
1). Contribution Margin is: a). Sales - Total Variable expenses b). Sales - Total variable expenses - Total fixed expenses c). Sales revenue per unit x Sales quantity d). Variable expense per unit x Sales quantity 2). When preparing segmented income statements fixed expense are separated into the following categories: a). Traceable and common b).Fixed and Variable c).Direct and indirect d).Product and period 3).A Co. reported: Sales $125000; Contribution margin $62000; Total fixed expenses $42000; Common fixed expenses $15000. How...
Break-Even in Sales Revenue, Variable-Costing Ratio, Contribution Margin Ratio, Margin of Safety Hammond Company runs a...
Break-Even in Sales Revenue, Variable-Costing Ratio, Contribution Margin Ratio, Margin of Safety Hammond Company runs a driving range and golf shop. The budgeted income statement for the coming year is as follows. Sales $1,240,000 Less: Variable expenses 706,800    Contribution margin $533,200 Less: Fixed expenses 425,000    Income before taxes $108,200 Less: Income taxes 43,280    Net income $64,920 Required: 1. What is Hammond’s variable cost ratio? Enter your answer as a decimal value rounded to two decimal places. What is the contribution...
The contribution margin income statement of Krazy Kustard Donuts for August 2016 Sales Revenue: $125,000 Variable...
The contribution margin income statement of Krazy Kustard Donuts for August 2016 Sales Revenue: $125,000 Variable Costs: COGS: $32,100, Selling Costs: $17,100, Administrative Costs: $800 Contribution Margin: $75,000 Fixed Costs: Selling Costs: $32,400, Administrative Costs: $10,800 Operating Income: $31,800 Krazy Kustard sells 4 dozen plain donuts for every dozen custard-filled donuts. A dozen plain donuts sells for $4.00, with total variable cost of $1.60 per dozen. A dozen custard-filled donuts sells for $8.00, with total variable cost of $ $3.20...
Sales (10,000units) $ 70,000 Less variable costs (35,000) Contribution margin $ 35,000 Less fixed costs (32,500)...
Sales (10,000units) $ 70,000 Less variable costs (35,000) Contribution margin $ 35,000 Less fixed costs (32,500) Net income $ 2,500 Requirements: 1. Compute Break-even point in units and explain what the number that you calculated means. 2. Compute break-even point in sales volume (in dollar) and explain what the number that you calculated means. 3. How much sales should be in order to earn a before tax profit of $15000.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT