In: Accounting
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.
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 |