Question

Determine the amount of sales (units) that would be necessary under Break-Even Sales Under Present and...

Determine the amount of sales (units) that would be necessary under

Break-Even Sales Under Present and Proposed Conditions

Darby Company, operating at full capacity, sold 121,500 units at a price of $108 per unit during the current year. Its income statement for the current year is as follows:

Sales $13,122,000
Cost of goods sold 6,480,000
Gross profit $6,642,000
Expenses:
Selling expenses $3,240,000
Administrative expenses 3,240,000
Total expenses 6,480,000
Income from operations $162,000

The division of costs between fixed and variable is as follows:

Variable Fixed
Cost of goods sold 70% 30%
Selling expenses 75% 25%
Administrative expenses 50% 50%

Management is considering a plant expansion program that will permit an increase of $1,188,000 in yearly sales. The expansion will increase fixed costs by $118,800, but will not affect the relationship between sales and variable costs.

Required:

1. Determine the total variable costs and the total fixed costs for the current year. Enter the final answers rounded to the nearest dollar.

Total variable costs $
Total fixed costs $

2. Determine (a) the unit variable cost and (b) the unit contribution margin for the current year. Enter the final answers rounded to two decimal places.

Unit variable cost $
Unit contribution margin $

3. Compute the break-even sales (units) for the current year. Enter the final answers rounded to the nearest whole number.
units

4. Compute the break-even sales (units) under the proposed program for the following year. Enter the final answers rounded to the nearest whole number.
units

5. Determine the amount of sales (units) that would be necessary under the proposed program to realize the $162,000 of income from operations that was earned in the current year. Enter the final answers rounded to the nearest whole number.
units

6. Determine the maximum income from operations possible with the expanded plant. Enter the final answer rounded to the nearest dollar.
$

7. If the proposal is accepted and sales remain at the current level, what will the income or loss from operations be for the following year? Enter the final answer rounded to the nearest dollar.
$ Income

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

B11 Sales Cost of goods sold Gross profit Expenses: Selling expenses Administrative expenses Total expenses Income from operations $13,122,000 $6,480,000 6,642,000 3,240,000 3,240,000 6,480,000 $ 162,000 total S 6,480,000 4,536,000 $ 3,240,000 2,430,000 810,000 variable fixed 1,944,000 12 13 14 Cost of goods sold Selling expenses Administrative expenses total 3,240,000 1,620,000 1,620,000 $12,960,000 8,586,000 4,374,000 16 17 18 total variable costs total fixed costs 8,586,000 4,374,000 2 $ 20 21 lunit variable cost unit sales price unit contribution 70.67 108 37.33 $ 23B25 23 3 break even point (units 117,161 units 26 27 28 29 30 31 32 current roposed S108.00 108.00 70.67 70.67 37.33 37.33 $

for formulas and calculations, refer to the images below -

B11 A B Sales Cost of goods sold Gross profit Expenses: Selling expenses Administrative expenses Total expenses Income from operations 13122000 6642000 3240000 3240000 162000 total variable D12*0.7 D13 0.75 D14 0.5 SUM(E12:E14) fixed 12 13 14 15 16 17 18 Cost of goods sold Selling expenses Administrative expenses total D12*0.3 D13 0.25 D14*0.5 D7 SUM(D12:D14) -SUM(F12:F14 total variable costs total fixed costs E15 F15 D17/121500 108 2 lunit variable cost 20 21 unit sales price unit contribution D21-D20 23B25 23 3 Ibreak even point (units D18/D22 units 26 27 28 29 30 31 32 proposed 108 4 current sales per unit 108 variable cost per unit contribution per unit D20 D28-D29 D20 E28-E29 D31+1188000/108) E30 E31 D33+118800 E32-E33 sales units total contribution 121500 D30 D31 D18 D32-D33 fixed cost 34 - income from operations break even point (units E33/E30 units 37 5 necessary sales (units E33+162000)/E30 units 39 40 41 42 43 6 | maximum possible income from operations 1-E34 E30 D31 D42 D43 E33 D44-D45 7 contribution per unit sales units total contribution 45 fixed cost net income (loss) from operations) 47 net income from operations D46 49

Add a comment
Know the answer?
Add Answer to:
Determine the amount of sales (units) that would be necessary under Break-Even Sales Under Present and...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Determine the amount of sales (units) that would be necessary under Break-Even Sales Under Present and...

    Determine the amount of sales (units) that would be necessary under Break-Even Sales Under Present and Proposed Conditions Darby Company, operating at full capacity, sold 79,650 units at a price of $60 per unit during the current year. Its income statement for the current year is as follows: Sales $4,779,000 Cost of goods sold 2,360,000 Gross profit $2,419,000 Expenses: Selling expenses $1,180,000 1,180,000 Administrative expenses Total expenses 2,360,000 Income from operations $59,000 The division of costs between fixed and variable...

  • Determine the amount of sales (units) that would be necessary under Break-Even Sales Under Present and...

    Determine the amount of sales (units) that would be necessary under Break-Even Sales Under Present and Proposed Conditions Darby Company, operating at full capacity, sold 99,900 units at a price of $93 per unit during the current year. Its income statement for the current year is as follows: $9,290,700 4,588,000 Sales Cost of goods sold Gross profit Expenses: $4,702,700 Selling expenses $2,294,000 Administrative expenses 2,294,000 Total expenses 4,588,000 Income from operations $114,700 The division of costs between fixed and variable...

  • Determine the amount of sales (units) that would be necessary under Break-Even Sales Under Present and...

    Determine the amount of sales (units) that would be necessary under Break-Even Sales Under Present and Proposed Conditions Darby Company, operating at full capacity, sold 99,900 units at a price of $93 per unit during the current year. Its income statement for the current year is as follows: $9,290,700 4,588,000 Sales Cost of goods sold Gross profit Expenses: $4,702,700 Selling expenses $2,294,000 Administrative expenses 2,294,000 Total expenses 4,588,000 Income from operations $114,700 The division of costs between fixed and variable...

  • Determine the amount of sales (units) that would be necessary under Break-Even Sales Under Present and...

    Determine the amount of sales (units) that would be necessary under Break-Even Sales Under Present and Proposed Conditions Darby Company, operating at full capacity, sold 117,450 units at a price of $120 per unit during the current year. Its income statement for the current year is as follows: Sales $14,094,000 Cost of goods sold 6,960,000 Gross profit $7,134,000 Expenses: Selling expenses $3,480,000 Administrative expenses 3,480,000 Total expenses 6,960,000 Income from operations $174,000 The division of costs between fixed and variable...

  • Determine the amount of sales (units) that would be necessary under Break-Even Sales Under Present and...

    Determine the amount of sales (units) that would be necessary under Break-Even Sales Under Present and Proposed Conditions Darby Company, operating at full capacity, sold 75,600 units at a price of $135 per unit during the current year. Its income statement for the current year is as follows Sales Cost of goods sold Gross profit Expenses $10,206,000 5,040,000 $5,166,000 Selling expenses $2,520,000 Administrative expenses 2,520,000 Total expenses 5,040,000 Income from operations $126,000 The division of costs between fixed and variable...

  • Determine the amount of sales (units) that would be necessary under Break-Even Sales Under Present and...

    Determine the amount of sales (units) that would be necessary under Break-Even Sales Under Present and Proposed Conditions Darby Company, operating at full capacity, sold 78,300 units at a price of $51 per unit during the current year. Its income statement for the current year is as follows: Sales $3,993,300 Cost of goods sold 1,972,000 Gross profit $2,021,300 Expenses: Selling expenses $986,000 Administrative expenses 986,000 Total expenses 1,972,000 Income from operations $49,300 The division of costs between fixed and variable...

  • Determine the amount of sales (units) that would be necessary under Break-Even Sales Under Present and...

    Determine the amount of sales (units) that would be necessary under Break-Even Sales Under Present and Proposed Conditions Darby Company, operating at full capacity, sold 74,250 units at a price of $51 per unit during the current year. Its income statement for the current year is as follows: Sales $3,786,750 Cost of goods sold 1,870,000 Gross profit $1,916,750 Expenses: Selling expenses $935,000 Administrative expenses 935,000 Total expenses 1,870,000 Income from operations $46,750 The division of costs between fixed and variable...

  • Determine the amount of sales (units) that would be necessary under Break-Even Sales Under Present and...

    Determine the amount of sales (units) that would be necessary under Break-Even Sales Under Present and Proposed Conditions Darby Company, operating at full capacity, sold 70,200 units at a price of $81 per unit during the current year. Its income statement for the current year is as follows: Sales $5,686,200 Cost of goods sold 2,808,000 Gross profit $2,878,200 Expenses: Selling expenses $1,404,000 Administrative expenses 1,404,000 Total expenses 2,808,000 Income from operations $70,200 The division of costs between fixed and variable...

  • Determine the amount of sales (units) that would be necessary under Break-Even Sales Under Present and...

    Determine the amount of sales (units) that would be necessary under Break-Even Sales Under Present and Proposed Conditions Darby Company, operating at full capacity, sold 82,350 units at a price of $63 per unit during the current year. Its income statement for the current year is as follows: Sales Cost of goods sold Gross profit Expenses: $5,188,050 2,562,000 $2,626,050 $1,281,000 Selling expenses Administrative expenses 1,281,000 2,562,000 Total expenses $64,050 Income from operations The division of costs between fixed and variable...

  • Determine the amount of sales (units) that would be necessary under Break-Even Sales Under Present and...

    Determine the amount of sales (units) that would be necessary under Break-Even Sales Under Present and Proposed Conditions Darby Company, operating at full capacity, sold 112,050 units at a price of $129 per unit during the current year. Its income statement for the current year is as follows: Sales $14,454,450 Cost of goods sold 7,138,000 Gross profit $7,316,450 Expenses: Selling expenses $3,569,000 Administrative expenses 3,569,000 Total expenses 7,138,000 Income from operations $178,450 The division of costs between fixed and variable...

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