Question

In: Accounting

Connelly Inc., a manufacturer of quality electric ice cream makers, has experienced a steady growth in...

Connelly Inc., a manufacturer of quality electric ice cream makers, has experienced a steady growth in sales over the past few years. Because her business has grown, Jan DeJaney, the president, believes she needs an aggressive advertising campaign next year to maintain the company’s growth. To prepare for the growth, the accountant prepared the following data for the current year:

Variable costs per ice cream maker
Direct labor $ 16.00
Direct materials 19.00
Variable overhead 8.00
Total variable costs $ 43.00
Fixed costs
Manufacturing $ 130,500
Selling 46,000
Administrative 550,000
Total fixed costs $ 726,500
Selling price per unit $ 80
Expected sales (units) 57,500

Required:

1. If the costs and sales price remain the same, what is the projected operating profit for the coming year?

2. What is the breakeven point in units for the coming year?

3. Jan has set the sales target for 62,100 ice cream makers, which she thinks she can achieve by an additional fixed selling expense of $247,010 for advertising. All other costs remain as per the data in the above table. What will be the operating profit if the additional $247,010 is spent on advertising and sales rise to 62,100 units?

4-a. What will be the new breakeven point if the additional $247,010 is spent on advertising?

4-b. Prepare a contribution income statement at the new breakeven point.

4-c. What is the percentage change in both fixed costs and in the breakeven point?

5. If the additional $247,010 is spent for advertising in the next year, what is the sales level (in units) needed to equal the current year’s operating profit at 57,500 units?

ALSO:

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 and administrative costs
Commissions $ 5,436
Fixed advertising cost 906
Fixed administrative cost 2,416 8,758
Operating income $ 4,228
Fixed interest cost 755
Income before income taxes $ 3,473
Income taxes (30%) 1,042
Net income $ 2,431

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 $770,000 for the year, and the annual cost of hiring a sales manager and sales secretary will be $235,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 $670,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

ITS NOT DESIRED PROFIT , ACTUALLY IT IS UNITS TO EARN DESIRED PROFIT

SECOND SCENARIO


Related Solutions

Connelly Inc., a manufacturer of quality electric ice cream makers, has experienced a steady growth in...
Connelly Inc., a manufacturer of quality electric ice cream makers, has experienced a steady growth in sales over the past few years. Because her business has grown, Jan DeJaney, the president, believes she needs an aggressive advertising campaign next year to maintain the company’s growth. To prepare for the growth, the accountant prepared the following data for the current year: Variable costs per ice cream maker Direct labor $ 13.50 Direct materials 14.50 Variable overhead 6.00 Total variable costs $...
Connelly, Inc., a manufacturer of quality electric ice cream makers, has experienced a steady growth in...
Connelly, Inc., a manufacturer of quality electric ice cream makers, has experienced a steady growth in sales over the past few years. Since her business has grown, Jan DeJaney, the president, believes she needs an aggressive advertising campaign next year to maintain the company’s growth. To prepare for the growth, the accountant prepared the following data for the current year: Variable costs per ice cream maker      Direct labor $ 13.50      Direct materials 14.50      Variable overhead 6.00   Total variable costs $...
Connelly Inc., a manufacturer of quality electric ice cream makers, has experienced a steady growth in...
Connelly Inc., a manufacturer of quality electric ice cream makers, has experienced a steady growth in sales over the past few years. Because her business has grown, Jan DeJaney, the president, believes she needs an aggressive advertising campaign next year to maintain the company’s growth. To prepare for the growth, the accountant prepared the following data for the current year: Variable costs per ice cream maker Direct labor $ 20.00 Direct materials 24.00 Variable overhead 10.00 Total variable costs $...
Connelly Inc., a manufacturer of quality electric ice cream makers, has experienced a steady growth in...
Connelly Inc., a manufacturer of quality electric ice cream makers, has experienced a steady growth in sales over the past few years. Because her business has grown, Jan DeJaney, the president, believes she needs an aggressive advertising campaign next year to maintain the company’s growth. To prepare for the growth, the accountant prepared the following data for the current year: Variable costs per ice cream maker Direct labor $ 14.00 Direct materials 17.00 Variable overhead 7.00 Total variable costs $...
Profit Planning Connelly Inc., a manufacturer of quality electric ice cream makers, has experienced a steady...
Profit Planning Connelly Inc., a manufacturer of quality electric ice cream makers, has experienced a steady growth in sales over the past few years. Because her business has grown, Jan DeJaney, the president, believes she needs an aggressive advertising campaign next year to maintain the company’s growth. To prepare for the growth, the accountant prepared the following data for the current year: Variable costs per ice cream maker Direct labor $ 21.00 Direct materials 25.50 Variable overhead 10.50 Total variable...
onnelly Inc., a manufacturer of quality electric ice cream makers, has experienced a steady growth in...
onnelly Inc., a manufacturer of quality electric ice cream makers, has experienced a steady growth in sales over the past few years. Because her business has grown, Jan DeJaney, the president, believes she needs an aggressive advertising campaign next year to maintain the company’s growth. To prepare for the growth, the accountant prepared the following data for the current year: Variable costs per ice cream maker Direct labor $ 23.00 Direct materials 27.50 Variable overhead 11.50 Total variable costs $...
Casper Ice Cream The Casper Ice Cream Company is an ice cream manufacturer in Richmond, Utah...
Casper Ice Cream The Casper Ice Cream Company is an ice cream manufacturer in Richmond, Utah famous for making Fat Boy Ice Cream Sandwiches. The owner, Mr. Casper, the grandson of the founder, is considering replacing an existing ice cream maker and batch freezer with a new maker which has a greater output capacity and operates with less labor. His only alternative is to overhaul his ice cream maker and batch freezer which have a current net book value of...
Maus and Company maker of quality hand made pipes, has experienced a steady growth in sales...
Maus and Company maker of quality hand made pipes, has experienced a steady growth in sales for the past five years. However, increased competition has led Michael Maus, the president to believe that an aggressive advertising campaign will be necessary next year to maintain the company’ growth. To prepare for the next year’s advertising campaign, the company accountant has prepared the following data for year 1 Cost Schedule Variable Cost per pipe Direct Labor $8 Direct Material 3.25 Variable Overhead...
J.T.Pan and​ Company, a manufacturer of quality handmade walnut​ bowls, has had a steady growth in...
J.T.Pan and​ Company, a manufacturer of quality handmade walnut​ bowls, has had a steady growth in sales for the past 5 years.​ However, increased competition has led Mr.Pan​, the​ president, to believe that an aggressive marketing campaign will be necessary next year to maintain the​ company's present growth. To prepare for next​ year's marketing​ campaign, the​ company's controller has prepared and presented Mr.Pan with the following data for the current​ year, 2017​: Variable cost (per bowl) Direct materials $3.00 Direct...
Forber Inc., a manufacturer of breakfast cereals and snack bars, has experienced several years of steady...
Forber Inc., a manufacturer of breakfast cereals and snack bars, has experienced several years of steady growth in sales, profits, and dividends while maintaining a relatively low level of debt. The board of directors has adopted a long-run strategy to maximize the value of the shareholders’ investment. In order to achieve this goal, the board of directors established the following five-year financial objectives. Increase sales by 14 percent per year. Increase income before taxes by 15 percent per year. Maintain...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT