Question

In: Accounting

Lionel Corporation manufactures pharmaceutical products sold through a network of sales agents in the United States...

Lionel Corporation manufactures pharmaceutical products sold through a network of sales agents in the United States and Canada. The agents are currently paid an 18% commission on sales; that percentage was used when Lionel prepared the following budgeted income statement for the fiscal year ending June 30, 2019:

Lionel Corporation
Budgeted Income Statement
For the Year Ending June 30, 2019
($000 omitted)
Sales $ 29,500
Cost of goods sold
Variable $ 13,275
Fixed 3,540 16,815
Gross profit $ 12,685
Selling and administrative costs
Commissions $ 5,310
Fixed advertising cost 885
Fixed administrative cost 2,360 8,555
Operating income $ 4,130
Fixed interest cost 738
Income before income taxes $ 3,392
Income taxes (30%) 1,018
Net income $ 2,374

Since the completion of the income statement, Lionel has learned that its sales agents are requiring a 5% increase in their commission rate (to 23%) for the upcoming year. As a result, Lionel’s president has decided to investigate the possibility of hiring its own sales staff in place of the network of sales agents and has asked Alan Chen, Lionel’s controller, to gather information on the costs associated with this change.

Alan estimates that Lionel must hire eight salespeople to cover the current market area, at an average annual payroll cost for each employee of $80,000, including fringe benefits expense. Travel and entertainment expenses is expected to total $700,000 for the year, and the annual cost of hiring a sales manager and sales secretary will be $200,000. In addition to their salaries, the eight salespeople will each earn commissions at the rate of 10% of sales. The president believes that Lionel also should increase its advertising budget by $600,000 if the eight salespeople are hired.

Required

1. Determine Lionel’s breakeven point (operating profit = 0) in sales dollars for the fiscal year ending June 30, 2019, if the company hires its own sales force and increases its advertising costs. Prove this by constructing a contribution income statement.

2. If Lionel continues to sell through its network of sales agents and pays the higher commission rate, determine the estimated volume in sales dollars that would be required to generate the operating profit as projected in the budgeted income statement.

Solutions

Expert Solution

A. Calculating Lionel's break even point in sales dollar for the fiscal year ended June 30 2019, If company hires its own sales force and increases its advertising costs.

1. PV Ratio = Contribution / sales x 100

Revised PV Ratio = (Sales – Variable Cost) / Sales x 100

Revised PV Ratio = [Sales – (Direct Variable Cost + Commission) / Sales x 100

Revised PV Ratio = {29500 – [13275 + (29500 x 10%)]} / 29500 x 100

Revised PV Ratio = [29500 – (13275 + 2950)] / 29500 x 100

Revised PV Ratio = (29500 – 16225) / 29500 x 100

Revised PV Ratio = 13275 / 29500 x 100

Revised PV Ratio = 45%

2. Revised Fixed Cost Structure

Particulars Calculations Amount $(000)
Fixed cost of goods sold 3,540
Fixed advertising cost (885 + 600) 1485
Fixed administrative cost 2,360
Fixed Salary Cost [(80 x 8) + 200] 840
Total Fixed Cost $8,225

3. Break Even Point (Sales) = Total Fixed Cost / PV Ratio

Break Even Point (Sales) = 8225 / 45%

Break Even Point (Sales) = $18277.78

4. Proof:- Revised Income Statement for June 30, 2019

Lionel Corporation
Revised Budgeted Income Statement
For the Year Ending June 30, 2019
($000 omitted)
Sales 18277.78
Cost of goods sold
Variable (45% sales) 8225.00
Fixed 3540.00 11765.00
Gross profit 6512.78
Selling and administrative costs
Commissions (10% sales) 1827.78
Fixed advertising cost 1485.00
Fixed administrative cost 2360.00
Fixed Salary Cost 840.00 6512.78
Operating income 0.00
Fixed interest cost 738.00
Income before income taxes -738.00
Income taxes (30%) 221.40
Net income -516.60

B. Calculating estimated sales revenue to generate same operating Profit, If Lionel continues to sell through its network of sales agents and pays the higher commission rate.

1. PV Ratio = Contribution / sales x 100

Revised PV Ratio = (Sales – Variable Cost) / Sales x 100

Revised PV Ratio = [Sales – (Direct Variable Cost + Commission) / Sales x 100

Revised PV Ratio = {29500 – [13275 + (29500 x 23%)]} / 29500 x 100

Revised PV Ratio = [29500 – (13275 + 6785)] / 29500 x 100

Revised PV Ratio = (29500 – 20060) / 29500 x 100

Revised PV Ratio = 9440 / 29500 x 100

Revised PV Ratio = 32%

2. Fixed Cost Structure

Particulars Amount $(000)
Fixed cost of goods sold 3,540
Fixed advertising cost 885
Fixed administrative cost 2,360
Fixed Salary Cost 0
Total Fixed Cost $6,785

3. Calculating Required Contribution to achieve desired sales

Required Contribution = Fixed Cost + Desired Operating Profit

Required Contribution = (3540 + 885 + 2360) +4130

Required Contribution = 6785 + 4130

Required Contribution = $10915

4. Calculating Desired level of sales to earn same profit

Desired level of sales = Required Contribution / PV Ratio

Desired level of sales = 10915 / 32%

Desired level of sales = $34109.38


Related Solutions

Lionel Corporation manufactures pharmaceutical products sold through a network of sales agents in the United States...
Lionel Corporation manufactures pharmaceutical products sold through a network of sales agents in the United States and Canada. The agents are currently paid an 18% commission on sales; that percentage was used when Lionel prepared the following budgeted income statement for the fiscal year ending June 30, 2019: Lionel Corporation Budgeted Income Statement For the Year Ending June 30, 2019 ($000 omitted) Sales $ 28,500 Cost of goods sold Variable $ 12,825 Fixed 3,500 16,325 Gross profit $ 12,175 Selling...
Lionel Corporation manufactures pharmaceutical products sold through a network of sales agents in the United States...
Lionel Corporation manufactures pharmaceutical products sold through a network of sales agents in the United States and Canada. The agents are currently paid an 18% commission on sales; that percentage was used when Lionel prepared the following budgeted income statement for the fiscal year ending June 30, 2019: Lionel Corporation Budgeted Income Statement For the Year Ending June 30, 2019 ($000 omitted) Sales $ 30,100 Cost of goods sold Variable $ 13,545 Fixed 3,612 17,157 Gross profit $ 12,943 Selling...
Lionel Corporation manufactures pharmaceutical products sold through a network of sales agents in the United States...
Lionel Corporation manufactures pharmaceutical products sold through a network of sales agents in the United States and Canada. The agents are currently paid an 18% commission on sales; that percentage was used when Lionel prepared the following budgeted income statement for the fiscal year ending June 30, 2019: Lionel Corporation Budgeted Income Statement For the Year Ending June 30, 2019 ($000 omitted) Sales $ 30,200 Cost of goods sold Variable $ 13,590 Fixed 3,624 17,214 Gross profit $ 12,986 Selling...
Lionel Corporation manufactures pharmaceutical products sold through a network of sales agents in the United States...
Lionel Corporation manufactures pharmaceutical products sold through a network of sales agents in the United States and Canada. The agents are currently paid an 18% commission on sales; that percentage was used when Lionel prepared the following budgeted income statement for the fiscal year ending June 30, 2019: Lionel Corporation Budgeted Income Statement For the Year Ending June 30, 2019 ($000 omitted) Sales $ 30,200 Cost of goods sold Variable $ 13,590 Fixed 3,624 17,214 Gross profit $ 12,986 Selling...
Lionel Corporation manufactures pharmaceutical products sold through a network of sales agents in the United States...
Lionel Corporation manufactures pharmaceutical products sold through a network of sales agents in the United States and Canada. The agents are currently paid an 18% commission on sales; that percentage was used when Lionel prepared the following budgeted income statement for the fiscal year ending June 30, 2019 Lionel Corporation Budgeted Income Statement For the Year Ending June 30, 2019 ($000 omitted) Sales $ 29,000 Cost of goods sold Variable $ 13,050 Fixed 3,480 16,530 Gross profit $ 12,470 Selling...
Lionel Corporation manufactures pharmaceutical products sold through a network of sales agents in the United States...
Lionel Corporation manufactures pharmaceutical products sold through a network of sales agents in the United States and Canada. The agents are currently paid an 18% commission on sales; that percentage was used when Lionel prepared the following budgeted income statement for the fiscal year ending June 30, 2019: Lionel Corporation Budgeted Income Statement For the Year Ending June 30, 2019 ($000 omitted) Sales $ 30,200 Cost of goods sold Variable $ 13,590 Fixed 3,624 17,214 Gross profit $ 12,986 Selling...
Klyne Corporation manufactures pharmaceutical products that are sold through a network of sales agents. The agents...
Klyne Corporation manufactures pharmaceutical products that are sold through a network of sales agents. The agents are paid a commission of 24% of sales. The income statement for the year ending December 31, 2017, is as follows: KLYNE CORPORATION Income Statement For the Year Ending December 31, 2017   Sales $ 29,000,000   Cost of goods sold      Variable $ 14,790,000         Fixed 2,876,000    17,666,000   Gross margin 11,334,000   Selling and marketing expenses      Commissions 6,960,000         Fixed costs 3,270,000    10,230,000   Operating income...
Klyne Corporation manufactures pharmaceutical products that are sold through a network of sales agents. The agents...
Klyne Corporation manufactures pharmaceutical products that are sold through a network of sales agents. The agents are paid a commission of 24% of sales. The income statement for the year ending December 31, 2017, is as follows: KLYNE CORPORATION Income Statement For the Year Ending December 31, 2017   Sales $ 29,000,000   Cost of goods sold      Variable $ 14,790,000         Fixed 2,876,000    17,666,000   Gross margin 11,334,000   Selling and marketing expenses      Commissions 6,960,000         Fixed costs 3,270,000    10,230,000   Operating income...
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT