Question

In: Accounting

Part 4 – CVP Analysis Seth’s Airway Cleaning Services, operating at full capacity, sold 10,000 units...

Part 4 – CVP Analysis

Seth’s Airway Cleaning Services, operating at full capacity, sold 10,000 units at a price of $175 per unit during the year. Their income statement is as follows:
Sales ............................................... $1,750,000 Cost of goods sold ............................ 1,450,000 Gross Profit ........................................ $300,000

Expenses: Selling expenses ..................... $53,000 Administrative expenses .......... $47,000 Total Expenses ........................................................ $100,000 Income from operations ........................................... $200,000

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

Fixed Variable
Cost of goods sold 45% 55%
Selling expenses 25% 75%
Administrative expenses 50% 50%
REQUIRED: 1. Determine the total fixed costs and total variable costs for the year. 2. Determine the unit variable cost and the unit contribution margin for the year. 3. Compute the break-even sales units for the year.

The marketing manager has developed a brand extension and is wondering how the new product will affect profitability. The key figures are:

a. Projected sales increase $500,000 b. Fixed costs will go up $200,000 c. Variable costs will be unchanged in the short term.

4. Compute the break-even sales units under the proposed program.

5. Compute the amount of sales (units) that would be necessary under the proposed program to realize the $200,000 that was earned during the year.

Solutions

Expert Solution

Answer 1

Fixed Variable Total
Cost of Goods Sold          6,52,500          7,97,500          14,50,000
Selling Expense             13,250             39,750                53,000
Administrative Expense             23,500             23,500                47,000
Total          6,89,250          8,60,750          15,50,000

Answer 2

Selling Price             175.00
Variable Cost:
- Cost of Goods Sold                79.75
- Selling Expense                  3.98
- Administrative Expense                  2.35                86.08
Contribution Margin                88.93
Contribution Margin (%) 50.81%

Answer 3

Breakeven Point (Units) = Fixed Cost / Contribution Margin per unit = 689,250 / 88.93 = 7,750.91 ~ 7,751 Units

Answer 4

Revised Fixed Cost = 689,250 + 200,000 = 889,250

Revised Breakeven Point = 889,250 / 88.93 = 10,000 Units

Answer 5

Sales (units) to earn profit of $ 200,000 = (Fixed Cost + Desired Profit) / Contribution Margin Per unit = 12,249.09 ~ 12,249 Units

ekkarill92 answered 1 year ago
Next > < Previous

Related Solutions

Margin of Safety Kearney Company, operating at full capacity, sold 400,000 units at a price of...
Margin of Safety Kearney Company, operating at full capacity, sold 400,000 units at a price of $246.60 per unit during 2015. Its income statement for 2015 is as follows: Sales $ 98,640,000 Cost of goods sold (44,500,000) Gross profit $ 54,140,000 Expenses:     Selling expenses $8,000,000     Administrative expenses 3,000,000         Total expenses (11,000,000) Income from operations $ 43,140,000 The division of costs between fixed and variable is as follows: Fixed Variable Cost of good sold 28% 72% Selling expenses 25% 75% Administrative...
Darby Company, operating at full capacity, sold 159,800 units at a price of $51 per unit...
Darby Company, operating at full capacity, sold 159,800 units at a price of $51 per unit during the current year. Its income statement is as follows: Sales $8,149,800 Cost of goods sold 2,890,000 Gross profit $5,259,800 Expenses: Selling expenses $1,445,000 Administrative expenses 867,000 Total expenses 2,312,000 Income from operations $2,947,800 The division of costs between variable and fixed is as follows: Variable Fixed Cost of goods sold 60% 40% Selling expenses 50% 50% Administrative expenses 30% 70% Management is considering...
Company A is operating at full capacity, sold 45,600 units during the current year. Its income...
Company A is operating at full capacity, sold 45,600 units during the current year. Its income statement is as follows: Sales $5,654,400 Cost of goods sold 3,618,816 Gross profit $2,035,584 Expenses: Selling expenses $984,000 Administrative expenses 430,000 Total expenses 1,414,000 Income from operations $ 621,584 The division of costs between variable and fixed is as follows: (round to nearest dollar) Variable Fixed Cost of goods sold 70% 30% Selling expenses 20% 80% Administrative expenses 10% 90% Management is planning to...
Break-Even Sales Under Present and Proposed Conditions Portmann Company, operating at full capacity, sold 1,000,000 units...
Break-Even Sales Under Present and Proposed Conditions Portmann Company, operating at full capacity, sold 1,000,000 units at a price of $188 per unit during the current year. Its income statement is as follows: Sales         $188,000,000 Cost of goods sold         (98,000,000) Gross profit         $90,000,000 Expenses:            Selling expenses   $14,000,000         Administrative expenses   17,800,000         Total expenses         (31,800,000) Operating income         $58,200,000 The division of costs between variable and...
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 Portmann Company, operating at full capacity, sold 1,000,000 units...
Break-Even Sales Under Present and Proposed Conditions Portmann Company, operating at full capacity, sold 1,000,000 units at a price of $188 per unit during the current year. Its income statement is as follows: Sales $188,000,000 Cost of goods sold (100,000,000) Gross profit $88,000,000 Expenses: Selling expenses $16,000,000 Administrative expenses 12,000,000 Total expenses (28,000,000) Operating income $60,000,000 The division of costs between variable and fixed is as follows: Variable Fixed Cost of goods sold 70% 30% Selling expenses 75% 25% Administrative...
Break-Even Sales Under Present and Proposed Conditions Battonkill Company, operating at full capacity, sold 105,400 units...
Break-Even Sales Under Present and Proposed Conditions Battonkill Company, operating at full capacity, sold 105,400 units at a price of $57 per unit during 2014. Its income statement for 2014 is as follows: Sales $6,007,800 Cost of goods sold 2,128,000 Gross profit $3,879,800 Expenses: Selling expenses $1,064,000 Administrative expenses 646,000 Total expenses 1,710,000 Income from operations $2,169,800 The division of costs between fixed and variable is as follows: Fixed Variable Cost of goods sold 40% 60% Selling expenses 50% 50%...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT