Question

In: Accounting

Use below information for Questions 1 to 3: Company X manufactures cosmetic products that are sold...

Use below information for Questions 1 to 3:

Company X manufactures cosmetic products that are sold through a network of sales agents. The agents are paid a commission at a percent of sales basis. Partial income statement for the year ending Dec 31, 2017, is as follows:

Item

Amount (TL)

Sales

COGS

77,000,000

Variable

31,530,000

Fixed

                                   Selling and marketing expenses

8,610,000

Commissions

13,570,000

Fixed costs

10,260,000

The company is considering hiring its own sales staff to replace the network of agents. It will pay its salespeople a commission of 8.60% and incur additional fixed costs of TL7,570,000.

  1. Calculate the degree of operating leverage at sales TL77,000,000 if the company uses sales agents.
  2. Assume the company employs its own sales staff. Calculate the change in net income if sales decrease by10%.
  3. Calculate the estimated sales volume in sales TL that would generate an identical net income for the yearending December 31, 2017, regardless of whether the company uses sales agents or employs its own sales staff.

Solutions

Expert Solution

Solution:

Contribution Margin Income Statement - Sales Agents
Sales 77000000
Less: Variable Expenses
Manfacturing 31530000
Commissions to agents 13570000 45100000
Contribution Margin 31900000
Less: Fixed Expenses
Overhead 8610000
Marketing Expenses 10260000
18870000
Net Income 13030000
Degree of Operating Leverage
= Contribution Margin / Operating Income
Agents
Contribution Margin 31900000
Operating Income 13030000
DOL 2.45
Contribution Margin Income Statement - Own Sales Team
10% Decrease Current
Sales 69300000 77000000
Less: Variable Expenses
Manfacturing 28377000 31530000
Commissions to agents @ 8.60% 5959800 34336800 6622000
Contribution Margin 34963200 38848000
Less: Fixed Expenses
Overhead 8610000 8610000
Marketing Expenses 17830000 17830000
26440000 26440000
Net Income 8523200 12408000

Change in Net Income = $12408000 - $8523200 = $3884800

Agents Own Team
Contribution Margin Ratio
Sales 77000000 69300000
Contribution Margin 31900000 34963200
Contribution Margin Ratio 41.4286% 50.4519%
Total Fixed Cost 18870000 26440000
Net Profit (Sales*CM Ratio) - Fixed Costs (Sales*CM Ratio) - Fixed Costs
(Sales*41.43%)-18870000 (Sales*50.45%)-26440000
Here we want to equate both the above, as we the same profit at the same volume of sales
(Sales*41.43%)-18870000 = (Sales*50.45%)-26440000
(Sales*50.45%)-(Sales*41.43%) = 26440000-18870000
9.0234%*Sales = 7570000
Sales = 7570000/9.0234%
estimated sales volume in sales TL that would generate an identical net income =        8,38,93,175.28

Related Solutions

Company X manufactures cosmetic products that are sold through a network of sales agents. The agents...
Company X manufactures cosmetic products that are sold through a network of sales agents. The agents are paid a commission at a percent of sales basis. Partial income statement for the year ending Dec 31, 2017, is as follows: Item Amount (TL) Sales 78,000,000 COGS Variable 31,510,000 Fixed 8,610,000 Selling and marketing expenses Commissions 13,550,000 Fixed costs 10,270,000 The company is considering hiring its own sales staff to replace the network of agents. It will pay its salespeople a commission...
Use below information for Questions 1 to 3: For June 30th of 2017, Company X reported...
Use below information for Questions 1 to 3: For June 30th of 2017, Company X reported raw materials balance of TL20,500 and WIP balance of TL25,000 in its balance sheet. During July; • Direct labor of TL250,000 was used. • TL360,000 worth of raw materials was purchased. • Manufacturing overhead used (exclusive of indirect materials) was equal to 67% of direct labor costs. At the end of July, ending work in process inventory was worth TL59,500. Totol cost of work...
Use below information for Questions 1 to 4: The smelting department of Company X has following...
Use below information for Questions 1 to 4: The smelting department of Company X has following production and cost data for September: Production: Beginning work in process 200 units that are 100% complete as to materials and 85% complete as to conversion costs; units started into production 1,000 units; units transferred out to next department 980 units; ending work in process are 100% complete as to materials and 41% complete as to conversion costs. Manufacturing costs: Beginning work in process...
Required information [The following information applies to the questions displayed below.] Cane Company manufactures two products...
Required information [The following information applies to the questions displayed below.] Cane Company manufactures two products called Alpha and Beta that sell for $130 and $90, respectively. Each product uses only one type of raw material that costs $5 per pound. The company has the capacity to annually produce 102,000 units of each product. Its average cost per unit for each product at this level of activity are given below: Alpha Beta Direct materials $ 25 $ 10 Direct labor...
Required information [The following information applies to the questions displayed below.] Cane Company manufactures two products...
Required information [The following information applies to the questions displayed below.] Cane Company manufactures two products called Alpha and Beta that sell for $130 and $90, respectively. Each product uses only one type of raw material that costs $5 per pound. The company has the capacity to annually produce 102,000 units of each product. Its average cost per unit for each product at this level of activity are given below: Alpha Beta Direct materials $ 25 $ 10 Direct labor...
Required information [The following information applies to the questions displayed below.] Cane Company manufactures two products...
Required information [The following information applies to the questions displayed below.] Cane Company manufactures two products called Alpha and Beta that sell for $130 and $90, respectively. Each product uses only one type of raw material that costs $5 per pound. The company has the capacity to annually produce 102,000 units of each product. Its average cost per unit for each product at this level of activity are given below: Alpha Beta Direct materials $ 25 $ 10 Direct labor...
Bonita Beauty Corporation manufactures cosmetic products that are sold through a network of sales agents. The...
Bonita Beauty Corporation manufactures cosmetic products that are sold through a network of sales agents. The agents are paid a commission of  19% of sales. The income statement for the year ending December 31, 2020, is as follows. BONITA BEAUTY CORPORATION Income Statement For the Year Ended December 31, 2020 Sales $ 78,400,000 Cost of goods sold     Variable $ 32,144,000     Fixed 9,000,000 41,144,000     Gross margin $ 37,256,000 Selling and marketing expenses     Commissions $ 14,896,000     Fixed costs 10,528,000 25,424,000     Operating income $...
Marigold Beauty Corporation manufactures cosmetic products that are sold through a network of sales agents. The...
Marigold Beauty Corporation manufactures cosmetic products that are sold through a network of sales agents. The agents are paid a commission of 22% of sales. The income statement for the year ending December 31, 2020, is as follows. MARIGOLD BEAUTY CORPORATION Income Statement For the Year Ended December 31, 2020 Sales $75,100,000 Cost of goods sold     Variable $32,293,000     Fixed 8,870,000 41,163,000     Gross margin $33,937,000 Selling and marketing expenses     Commissions $16,522,000     Fixed costs 10,380,000 26,902,000     Operating income $7,035,000 The company is...
Bonita Beauty Corporation manufactures cosmetic products that are sold through a network of sales agents. The...
Bonita Beauty Corporation manufactures cosmetic products that are sold through a network of sales agents. The agents are paid a commission of 21% of sales. The income statement for the year ending December 31, 2020, is as follows. BONITA BEAUTY CORPORATION Income Statement For the Year Ended December 31, 2020 Sales $78,800,000 Cost of goods sold     Variable $31,520,000     Fixed 8,650,000 40,170,000     Gross margin $38,630,000 Selling and marketing expenses     Commissions $16,548,000     Fixed costs 10,970,900 27,518,900     Operating income $11,111,100 The company is...
Olin Beauty Corporation manufactures cosmetic products that are sold through a network of sales agents. The...
Olin Beauty Corporation manufactures cosmetic products that are sold through a network of sales agents. The agents are paid a commission of 18% of sales. The forecast income statement for the year ending December 31, 2020, is as follows: OLIN BEAUTY CORPORATION Income Statement Year Ending December 31, 2020 Sales $78,335,000 Cost of goods sold Variable $36,034,100 Fixed 7,880,000 43,914,100 Gross margin 34,420,900 Selling and marketing expenses Commissions $14,100,300 Fixed costs 10,084,000 24,184,300 Operating income $10,236,600 The company is considering...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT