Question

Lorge Corporation has collected the following information after its first year of sales. Sales were $2,500,000...

Lorge Corporation has collected the following information after its first year of sales. Sales were $2,500,000 on 100,000 units; selling expenses $250,000 (40% variable and 60% fixed); direct materials $1,351,000; direct labor $250,000; administrative expenses $270,000 (20% variable and 80% fixed); and manufacturing overhead $350,000 (70% variable and 30% fixed). Top management has asked you to do a CVP analysis so that it can make plans for the coming year. It has projected that unit sales will increase by 10% next year.

New attempt is in progress. Some of the new entries may impact the last attempt grading.Your answer is incorrect.

Compute (1) the contribution margin for the current year and the projected year, and (2) the fixed costs for the current year. (Assume that fixed costs will remain the same in the projected year.)

(1) Contribution margin for current year

$

Contribution margin for projected year

$

(2) Fixed costs for current year

$

eTextbook and Media

Incorrect answer iconYour answer is incorrect.

Compute the break-even point in units and sales dollars for the first year. (Round contribution margin ratio to 2 decimal places e.g. 0.15 and final answers to 0 decimal places, e.g. 2,510.)

Break-even point units
Break-even point

$

eTextbook and Media

Incorrect answer iconYour answer is incorrect.

The company has a target net income of $160,000. What is the required sales in dollars for the company to meet its target?

Sales dollars required for target net income

$

eTextbook and Media

Incorrect answer iconYour answer is incorrect.

If the company meets its target net income number, by what percentage could its sales fall before it is operating at a loss? That is, what is its margin of safety ratio? (Round answer to 1 decimal place, e.g. 10.5.)

Margin of safety ratio %

eTextbook and Media

Incorrect answer iconYour answer is incorrect.

The company is considering a purchase of equipment that would reduce its direct labor costs by $110,000 and would change its manufacturing overhead costs to 30% variable and 70% fixed (assume total manufacturing overhead cost is $350,000, as above). It is also considering switching to a pure commission basis for its sales staff. This would change selling expenses to 90% variable and 10% fixed (assume total selling expense is $250,000, as above). Compute (1) the contribution margin and (2) the contribution margin ratio, and recompute (3) the break-even point in sales dollars. (Round contribution margin ratio to 2 decimal places, e.g. 25.25 and all other answers to 0 decimal places, e.g. 2,520. Use the current year numbers for calculations.)

1. Contribution margin

$

2. Contribution margin ratio %
3. Break-even point

$

0 0
Add a comment Improve this question Transcribed image text
✔ Recommended Answer
Answer #1

ANSWER

Compute (1) the contribution margin for the current year and the projected year, and (2) the fixed costs for the current year. (Assume that fixed costs will remain the same in the projected year.)

Current Year
Net sales 2,500,000
Variable costs
Direct materials 1,351,000
Direct labor 250,000
Manufacturing overhead ($350,000 X .70) 245000
Selling expenses ($250,000 X .40) 100000
Administrative expenses ($270,000 X .20) 54000
Total variable costs 2,000,000
Contribution margin 500,000
Current Year Increase Projected Year
Net sales 2,500,000 1.1 2750000
Variable costs
Direct materials 1,351,000 1.1 1486100
Direct labor 250,000 1.1 275000
Manufacturing overhead ($350,000 X .70) 245000 1.1 269500
Selling expenses ($250,000 X .40) 100000 1.1 110000
Administrative expenses ($270,000 X .20) 54000 1.1 59400
Total variable costs 2,000,000 1.1 2200000
Contribution margin 500,000 1.1 550000
Current Year Projected year
Fixed Costs
Manufacturing overhead ($350,000 X .30) 105000 105000
Selling expenses ($250,000 X .60) 150000 150000
Administrative expenses ($270,000 X .80) 216000 216000
Total fixed costs 471000 471000

Compute the break-even point in units and sales dollars for the first year.

Unit selling price = $2,500,000 ÷ 100,000 = $25
Unit variable cost = $2000000 ÷ 100,000 = $20
Unit contribution margin = $25-20 = $5
Contribution margin ratio = $5 ÷ $25 = .20
Break-even point in units
Break-even point in units=Fixed costs/Unit contribution margin 471000/4 119000
Break-even point in dollars
Break-even point in dollars =Break-even point in units/Contribution margin ratio 471000/.20 2355000

The company has a target net income of $160,000. What is the required sales in dollars for the company to meet its target?
If the company meets its target net income number, by what percentage could its sales fall before it is operating at a loss? That is, what is its margin of safety ratio?

Sales dollars
required for target net income
(Fixed costs + Target net income)/Contribution margin ratio (471000+160000)/.20 3155000
Margin of safety
ratio
= (Expected sales – Break-even sales) ÷ Expected sales (3155000-2355000)/3155000 25.4%

The company is considering a purchase of equipment that would reduce its direct labor costs by $110,000 and would change its manufacturing overhead costs to 30% variable and 70% fixed (assume total manufacturing overhead cost is $350,000, as above). It is also considering switching to a pure commission basis for its sales staff. This would change selling expenses to 90% variable and 10% fixed (assume total selling expense is $250,000, as above). Compute (1) the contribution margin and (2) the contribution margin ratio, and recompute (3) the break-even point in sales

Projected Year
Net sales 2,500,000
Variable costs
Direct materials 1,351,000
Direct labor ($250000 – $111000) 140000
Manufacturing overhead ($350,000 X .30) 105000
Selling expenses ($250,000 X .90) 225000
Administrative expenses ($270,000 X .20) 54000
Total variable costs 1,875,000
Contribution margin 625,000
Contribution margin ratio = $625000/2500000 = 25%
Break-even point in dollars = $486000 ÷ .25= $1,515,152 =1944000
Fixed cost
Manufacturing overhead ($350,000 X .70) 245000
Selling expenses ($250,000 X .10) 25000
Administrative expenses ($270,000 X .80) 216000
Total fixed costs 486000

_____________________________________________

If you have any query or any Explanation please ask me in the comment box, i am here to helps you.please give me positive rating.

*****************THANK YOU**************

Add a comment
Know the answer?
Add Answer to:
Lorge Corporation has collected the following information after its first year of sales. Sales were $2,500,000...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
  • Lorge Corporation has collected the following information after its first year of sales. Sales were $2,500,000...

    Lorge Corporation has collected the following information after its first year of sales. Sales were $2,500,000 on 100,000 units; selling expenses $250,000 (40% variable and 60% fixed); direct materials $1,370,600; direct labor $250,000; administrative expenses $270,000 (20% variable and 80% fixed); and manufacturing overhead $322,000 (70% variable and 30% fixed). Top management has asked you to do a CVP analysis so that it can make plans for the coming year. It has projected that unit sales will increase by 10%...

  • Lorge Corporation has collected the following information after its first year of sales. Sales were $1,600,000...

    Lorge Corporation has collected the following information after its first year of sales. Sales were $1,600,000 on 80,000 units; selling expenses $250,000 (40% variable and 60% fixed); direct materials $620,800; direct labor $270,000; administrative expenses $270,000 (20% variable and 80% fixed); and manufacturing overhead $336,000 (70% variable and 30% fixed). Top management has asked you to do a CVP analysis so that it can make plans for the coming year. It has projected that unit sales will increase by 10%...

  • Lorge Corporation has collected the following information after its first year of sales. Sales were $2,400,000...

    Lorge Corporation has collected the following information after its first year of sales. Sales were $2,400,000 on 120,000 units; selling expenses $250,000 (40% variable and 60% fixed); direct materials $1,206,700; direct labor $280,000; administrative expenses $270,000 (20% variable and 80% fixed); and manufacturing overhead $399,000 (70% variable and 30% fixed). Top management has asked you to do a CVP analysis so that it can make plans for the coming year. It has projected that unit sales will increase by 10%...

  • Lorge Corporation has collected the following information after its first year of sales. Sales were $1,200,000...

    Lorge Corporation has collected the following information after its first year of sales. Sales were $1,200,000 on 120,000 units; selling expenses $250,000 (40% variable and 60% fixed); direct materials $291,400; direct labor $250,000; administrative expenses $270,000 (20% variable and 80% fixed); and manufacturing overhead $378,000 (70% variable and 30% fixed). Top management has asked you to do a CVP analysis so that it can make plans for the coming year. It has projected that unit sales will increase by 10%...

  • Lorge Corporation has collected the following information after its first year of sales. Sales were $2,500,000...

    Lorge Corporation has collected the following information after its first year of sales. Sales were $2,500,000 on 100,000 units; selling expenses $250,000 (40% variable and 60% fixed); direct materials $1,360,600; direct labor $260,000; administrative expenses $270,000 (20% variable and 80% fixed); and manufacturing overhead $322,000 (70% variable and 30% fixed). Top management has asked you to do a CVP analysis so that it can make plans for the coming year. It has projected that unit sales will increase by 10%...

  • Problem 6-2A (Video) Lorge Corporation has collected the following information after its first year of sales....

    Problem 6-2A (Video) Lorge Corporation has collected the following information after its first year of sales. Sales wore $2,100,000 on 105 000 units; seling expenses s 250000 40% variable and 6 fixed); direct materials $1,045,700; direct labor $250,000; administrative expenses $270,000 (20% variable and 80% fixed), and manufacturing overhead oo pow variable and 30% fixed). Top management has asked you to do a CVP analysis so that it can make plans for the coming year it has projected that unt...

  • Blue Spruce Corporation has collected the following information after its first year of sales. Sales were $1...

    Blue Spruce Corporation has collected the following information after its first year of sales. Sales were $1,600,000 on 100,000 units, selling expenses $240,000 (40% variable and 60% fixed), direct materials $514,000, direct labor $270,800, administrative expenses $280,000 (20% variable and 80% fixed), and manufacturing overhead $376,000 (70% variable and 30% fixed). Top management has asked you to do a CVP analysis so that it can make plans for the coming year. It has projected that unit sales will increase by...

  • Problem 18-06A Wildhorse Corporation has collected the following information after its first year of sales. Sales...

    Problem 18-06A Wildhorse Corporation has collected the following information after its first year of sales. Sales were $1,250,000 on 125,000 units, selling expenses $250,000 (40% variable and 60% fixed), direct materials $496,000, direct labor $34,900, administrative expenses $280,000 (20% variable and 80% fixed), and manufacturing overhead $358,000 (70% variable and 30% fixed). Top management has asked you to do a CVP analysis so that it can make plans for the coming year. It has projected that unit sales will increase...

  • Johnson Company has collected the following information after its first year of sales. Sales were $1,700,000...

    Johnson Company has collected the following information after its first year of sales. Sales were $1,700,000 on 85,000 units; selling expenses $250,000 (40% variable and 60% fixed); direct materials $720,800; direct labor $250,000; administrative expenses $270,000 (20% variable and 80% fixed); and manufacturing overhead $336,000 (70% variable and 30% fixed). Top management has asked you to do a CVP analysis so that it can make plans for the coming year. It has projected that unit sales will increase by 10%...

  • Problem 18-06A Oriole Corporation has collected the following information after its first year of sales. Sales...

    Problem 18-06A Oriole Corporation has collected the following information after its first year of sales. Sales were $1,600,000 on 100,000 units, selling expenses $250,000 (40% variable and 60% fixed), direct materials $510,000, direct labor $288,200, administrative expenses $284,000 (20% variable and 80% fixed), and manufacturing overhead $350,000 (70% variable and 30% fixed). Top management h xed). Top management has asked you to do a CVP analysis so that it can make plans for the coming year. It has projected that...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT