Question

In: Operations Management

Break-Even Sales Under Present and Proposed Conditions Darby Company, operating at full capacity, sold 105,300 units...

Break-Even Sales Under Present and Proposed Conditions Darby Company, operating at full capacity, sold 105,300 units at a price of $45 per unit during the current year. Its income statement for the current year is as follows: Sales $4,738,500 Cost of goods sold 2,340,000 Gross profit $2,398,500 Expenses: Selling expenses $1,170,000 Administrative expenses 1,170,000 Total expenses 2,340,000 Income from operations $58,500 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 $360,000 in yearly sales. The expansion will increase fixed costs by $36,000, 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 $58,500 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. $ 8. Based on the data given, would you recommend accepting the proposal? In favor of the proposal because of the reduction in break-even point. In favor of the proposal because of the possibility of increasing income from operations. In favor of the proposal because of the increase in break-even point. Reject the proposal because if future sales remain at the current level, the income from operations will increase. Reject the proposal because the sales necessary to maintain the current income from operations would be below the current year sales. Choose the correct answer. b Feedback 1. Multiply the percentages for fixed and variable costs by each cost. 2. a. Divide the total variable costs by number of units. 2. b. Sales price per unit minus variable costs per unit equals contribution margin per unit. 3. Fixed costs divided by unit contribution margin equals break-even point. 4. Fixed costs under the proposed program divided by contribution margin equals new break-even point. 5. (Fixed costs + Target profit) divided by unit contribution margin equals sales units. 6. Determine the increase in units by dividing the sales increase by the price per unit. Add the additional revenue and additional fixed costs when calculating: Sales minus fixed and variable costs equals income from operations. 7. Subtract the additional fixed costs from the operating income. 8. Consider the break-even point and the sales needed for the proposed level. Learning Objective 2, Learning Objective 3.

Solutions

Expert Solution

Table:

Particulars

Amount (in $)

Variable (in $)

Fixed (in $)

Sales

4,738,500

Cost of Goods Sold

-2,340,000

-1,638,000

-702,000

Gross Profit

2,398,500

Selling Expenses

-1,170,000

-877,500

-292,500

Administrative Expenses

-1,170,000

-585,000

-585,000

Total Expenses

-2,340,000

Income

58,500

-3,100,500

-1,579,500

1.

Total Variable Cost = $ 3,100,500.

Total Fixed Cost = $ 1,579,500.

2.

(a) Unit Variable Cost = Total Variable Cost / Number of units sold = 3,100,500 / 105,300 = $ 29.44

(b) Unit contribution margin = Unit Selling price – Unit Variable Cost = 45 – 29.44 = $ 15.56

3.

Breakeven sales for the current year = Total Fixed Cost / Unit contribution margin = 1,579,500 / 15.56 = 101,510 units.

4.

As per the proposed program, increase in annual fixed = $ 36,000.

Breakeven sales for the proposed program = (1,579,500 + 36,000) / 15.56 = 103,824 units.

5.

Let amount of units sold as per the new program = x.

Plant expansion program will result in increase in fixed cost by $ 36,000.

There will be no change in variable cost.

Cost of goods sold due to the proposed program = 1,638,000 + (702,000 + 36,000) = $ 2,376,000.

Income = $ 58,500.

45 x – 2,376,000 – 2,340,000 = 58,500

45 x = 58,500 + 2,376,000 + 2,340,000 = 4,774,500

x = 4,774,500 / 45 = 106,100.

The number of units that would be needed to be sold to achieve an income of $ 58,500 = 106,100.

6.

New sales = 4,738,500 + 360,000 = $ 5,098,500.

Cost of goods sold due to the proposed program = 1,638,000 + (702,000 + 36,000) = $ 2,376,000.

Maximum income possible with the expanded plant = 5,098,500 – 2,376,000 – 2,340,000 = $ 382,500.

7.

Sales remain at the previous level.

Income as per the new proposal = 4,738,500 – 2,376,000 – 2,340,000 = $ 22,500.

8.

We may accept the new proposal as income can increase to a maximum of $ 382, 500 from the existing value of $ 58,500, which is an increase of $ 324,000.              


Related Solutions

Break-Even Sales Under Present and Proposed Conditions Darby Company, operating at full capacity, sold 163,500 units...
Break-Even Sales Under Present and Proposed Conditions Darby Company, operating at full capacity, sold 163,500 units at a price of $66 per unit during the current year. Its income statement is as follows Sales $10,791,000 Cost of goods sold 3,828,000 Gross profit $6,963,000 Expenses: Selling expenses $1,914,000 Administrative expenses 1,144,000 Total expenses 3,058,000 Income from operations $3,905,000 The division of costs between variable and fixed is as follows: Variable Fixed Cost of goods sold 60% 40% Selling expenses 50% 50%...
Break-Even Sales Under Present and Proposed Conditions Darby Company, operating at full capacity, sold 97,700 units...
Break-Even Sales Under Present and Proposed Conditions Darby Company, operating at full capacity, sold 97,700 units at a price of $93 per unit during the current year. Its income statement is as follows Sales  $9,086,100Cost of goods sold  3,224,000Gross profit  $5,862,100Expenses:   Selling expenses$1,612,000  Administrative expenses961,000  Total expenses  2,573,000Income from operations  $3,289,100 The division of costs between variable and fixed is as follows:  VariableFixedCost of goods sold60% 40% Selling expenses50% 50% Administrative expenses30% 70%  Management is considering a plant expansion program for the following year that will permit an increase of $744,000 in yearly...
Break-Even Sales Under Present and Proposed Conditions Darby Company, operating at full capacity, sold 167,200 units...
Break-Even Sales Under Present and Proposed Conditions Darby Company, operating at full capacity, sold 167,200 units at a price of $111 per unit during the current year. Its income statement is as follows: Sales $18,559,200 Cost of goods sold 6,586,000 Gross profit $11,973,200 Expenses: Selling expenses $3,293,000 Administrative expenses 1,961,000 Total expenses 5,254,000 Income from operations $6,719,200 The division of costs between variable and fixed is as follows: Variable Fixed Cost of goods sold 60% 40% Selling expenses 50% 50%...
Break-Even Sales Under Present and Proposed Conditions Darby Company, operating at full capacity, sold 139,000 units...
Break-Even Sales Under Present and Proposed Conditions Darby Company, operating at full capacity, sold 139,000 units at a price of $72 per unit during the current year. Its income statement is as follows: Sales $10,008,000 Cost of goods sold 3,552,000 Gross profit $6,456,000 Expenses: Selling expenses $1,776,000 Administrative expenses 1,056,000 Total expenses 2,832,000 Income from operations $3,624,000 The division of costs between variable and fixed is as follows: Variable Fixed Cost of goods sold 60% 40% Selling expenses 50% 50%...
Break-Even Sales Under Present and Proposed Conditions Darby Company, operating at full capacity, sold 167,200 units...
Break-Even Sales Under Present and Proposed Conditions Darby Company, operating at full capacity, sold 167,200 units at a price of $129 per unit during the current year. Its income statement is as follows: Sales $21,568,800 Cost of goods sold 7,654,000 Gross profit $13,914,800 Expenses: Selling expenses $3,827,000 Administrative expenses 2,279,000 Total expenses 6,106,000 Income from operations $7,808,800 The division of costs between variable and fixed is as follows: Variable Fixed Cost of goods sold 60% 40% Selling expenses 50% 50%...
Break-Even Sales Under Present and Proposed Conditions Darby Company, operating at full capacity, sold 120,200 units...
Break-Even Sales Under Present and Proposed Conditions Darby Company, operating at full capacity, sold 120,200 units at a price of $132 per unit during the current year. Its income statement is as follows: Sales $15,866,400 Cost of goods sold 5,632,000 Gross profit $10,234,400 Expenses: Selling expenses $2,816,000 Administrative expenses 1,672,000 Total expenses 4,488,000 Income from operations $5,746,400 The division of costs between variable and fixed is as follows: Variable Fixed Cost of goods sold 60% 40% Selling expenses 50% 50%...
Break-Even Sales Under Present and Proposed Conditions Darby Company, operating at full capacity, sold 122,850 units...
Break-Even Sales Under Present and Proposed Conditions Darby Company, operating at full capacity, sold 122,850 units at a price of $108 per unit during the current year. Its income statement for the current year is as follows: Sales $13,267,800 Cost of goods sold 6,552,000 Gross profit $6,715,800 Expenses: Selling expenses $3,276,000 Administrative expenses 3,276,000 Total expenses 6,552,000 Income from operations $163,800 The division of costs between fixed and variable is as follows: Variable Fixed Cost of goods sold 70% 30%...
Break-Even Sales Under Present and Proposed Conditions Darby Company, operating at full capacity, sold 148,400 units...
Break-Even Sales Under Present and Proposed Conditions Darby Company, operating at full capacity, sold 148,400 units at a price of $87 per unit during the current year. Its income statement is as follows Sales $12,910,800 Cost of goods sold 4,582,000 Gross profit $8,328,800 Expenses: Selling expenses $2,291,000 Administrative expenses 1,363,000 Total expenses 3,654,000 Income from operations $4,674,800 The division of costs between variable and fixed is as follows: Variable Fixed Cost of goods sold 60% 40% Selling expenses 50% 50%...
Break-Even Sales Under Present and Proposed Conditions Darby Company, operating at full capacity, sold 99,700 units...
Break-Even Sales Under Present and Proposed Conditions Darby Company, operating at full capacity, sold 99,700 units at a price of $78 per unit during the current year. Its income statement is as follows: Sales $7,776,600 Cost of goods sold 2,756,000 Gross profit $5,020,600 Expenses: Selling expenses $1,378,000 Administrative expenses 832,000 Total expenses 2,210,000 Income from operations $2,810,600 The division of costs between variable and fixed is as follows: Variable Fixed Cost of goods sold 60% 40% Selling expenses 50% 50%...
Break-Even Sales Under Present and Proposed Conditions Darby Company, operating at full capacity, sold 87,750 units...
Break-Even Sales Under Present and Proposed Conditions Darby Company, operating at full capacity, sold 87,750 units at a price of $99 per unit during the current year. Its income statement for the current year is as follows: Sales $8,687,250 Cost of goods sold 4,290,000 Gross profit $4,397,250 Expenses: Selling expenses $2,145,000 Administrative expenses 2,145,000 Total expenses 4,290,000 Income from operations $107,250 The division of costs between fixed and variable is as follows: Variable Fixed Cost of goods sold 70%   ...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT