Question

In: Accounting

Product Profitability Porter Insurance Company has three lines of insurance: automobile, property, and life. The life...

Product Profitability

Porter Insurance Company has three lines of insurance: automobile, property, and life. The life insurance segment has been losing money for the past five quarters, and Leah Harper, Porter’s controller, has done an analysis of that segment. She has discovered that the commission paid to the agent for the first year the policy is in place is 55 percent of the first-year premium. The second-year commission is 20 percent, and all succeeding years a commission equal to 5 percent of premiums is paid. No salaries are paid to agents; however, Porter does advertise on television and in magazines. Last year, the advertising expense was $500,000. The loss rate (payout on claims) averages 50 percent. Administrative expenses equal $450,000 per year. Revenue last year was $10,000,000 (premiums). The percentage of policies of various lengths is as follows:

First year in force 65%
Second year 25
More than two years in force 10

Experience has shown that if a policy remains in effect for more than two years, it is rarely cancelled.

Leah is considering two alternative plans to turn this segment around. Plan 1 requires spending $250,000 on improved customer claim service in hopes that the percentage of policies in effect will take on the following distribution:

First year in force 50%
Second year 15
More than two years in force 35

Total premiums would remain constant at $10,000,000, and there are no other changes in fixed or variable cost behavior.

Plan 2 involves dropping the independent agent and commission system and having potential policyholders phone in requests for coverage. Leah estimates that revenue would drop to $7,000,000. Commissions would be zero, but administrative expenses would rise by $1,200,000, and advertising (including direct mail solicitation) would increase by $1,000,000.

Required:

1. Prepare a variable-costing income statement for last year for the life insurance segment of Porter Insurance Company. Enter operating income as a positive amount. Enter an operating loss as a negative amount.

Porter Insurance Company
Variable-Costing Income Statement
For the Last Year
Sales $
Less: Variable expenses
Contribution margin $
Less: Fixed expenses
Operating income (loss) $

2. What impact would Plan 1 have on income?
Increases segment income by  $__

3. What impact would Plan 2 have on income?
Increases segment income by  $__

Solutions

Expert Solution


Related Solutions

Comprehensive Insurance Company has two product lines: health insurance and auto insurance. The two product lines...
Comprehensive Insurance Company has two product lines: health insurance and auto insurance. The two product lines are served by three operating departments which are necessary for providing the two types of products: claims processing, administration, and sales. These three operating departments are supported by two departments: information technology and operations. The support provided by information technology and operations to the other departments is shown below. Support Departments Operating Departments Information Technology Operations Claims Processing Administration Sales Information technology — 20...
Comprehensive Insurance Company has two product lines: health insurance and auto insurance. The two product lines...
Comprehensive Insurance Company has two product lines: health insurance and auto insurance. The two product lines are served by three operating departments which are necessary for providing the two types of products: claims processing, administration, and sales. These three operating departments are supported by two departments: information technology and operations. The support provided by information technology and operations to the other departments is shown below. Support Departments Operating Departments Information Technology Operations Claims Processing Administration Sales Information technology — 20...
An insurance company has the following profitability analysis of its services: Life Insurance Auto Insurance Home...
An insurance company has the following profitability analysis of its services: Life Insurance Auto Insurance Home Insurance Revenues $5,000,000 $10,000,000 $3,000,000 Commissions (1,000,000) (2,000,000) (600,000) Payments (3,000,000) (7,300,000) (2,000,000) Fixed Costs (500,000) (500,000) (500,000) Profit $ 500,000 $ 200,000 ($ 100,000) The fixed costs are distributed equally among the services and are not avoidable if one of the services is dropped. What is the profitability of the remaining services if all services with losses are dropped?
7-41: Departmental cost allocation insurance company: Comprehensive insurance company has two product lines ; health insurance...
7-41: Departmental cost allocation insurance company: Comprehensive insurance company has two product lines ; health insurance and auto insurance. The two product lines are served by three operating departments which are necessary for providing the two types of products: claims processing, administration, and sales. These three operating departments which are necessary for providing the two types of products:claims processing, administration, and sales. These three operating departments are supported by two departments: infromation technology and operations. The support provided by information...
Comprehensive Insurance Company has two products lines: health insurance and auto insurance. The two products lines...
Comprehensive Insurance Company has two products lines: health insurance and auto insurance. The two products lines are served by three operating departments which are necessary for providing the two types of products: claims processing, administration, and sales. These three operating departments are supported by two departments: information technology and operations. The support provided by information technology and operations to the other department is shown below. Support Departments Operating Departments IT Operations Claims Processing Administration Sales IT 20% 20% 40% 20%...
The Janowski Company has three product lines of beer mugs dash—​A, ​B, and —with contribution margins...
The Janowski Company has three product lines of beer mugs dash—​A, ​B, and —with contribution margins of $5​,$ 4and $ 2respectively. The president foresees sales of 238,000 units in the coming​ period, consisting of 34,000 units of​ A, 136,000 units of​ B and 68,000 units of C. The​ company's fixed costs for the period are $525,000. Questions 1.What is the​ company's breakeven point in​ units, assuming that the given sales mix is​ maintained 2.If the sales mix is​ maintained, what...
7) Cesar Company has three product lines: A, B and C. The following annual information is...
7) Cesar Company has three product lines: A, B and C. The following annual information is available:                                                          Product A               Product B               Product C Sales                                                    $100,000                   $90,000                   $44,000 Variable costs                                           76,000                     48,000                     35,000 Contribution margin                                24,000                     42,000                      9,000 Avoidable fixed costs                                 9,000                     18,000                      3,000 Unavoidable fixed costs                             6,000                       9,000                      7,700 Operating income(loss)                             $9,000                   $15,000                  $(1,700) Assume Cesar Company drops Product C. Cesar Company then doubles the production and sales of Product B without increasing fixed costs. What will happen to operating income? A) increase by $15,000 B) increase by $24,000 C) increase by $36,000 please explain why this is the correct...
Activity-Based Costing for a Service Company Bounce Back Insurance Company carries three major lines of insurance:...
Activity-Based Costing for a Service Company Bounce Back Insurance Company carries three major lines of insurance: auto, workers' compensation, and homeowners. The company has prepared the following report: Bounce Back Insurance Company Product Profitability Report For the Year Ended December 31 Auto Workers' Compensation Homeowners Premium revenue $5,800,000 $6,250,000 $8,200,000 Estimated claims (4,060,000) (4,375,000) (5,740,000) Underwriting income $1,740,000 $1,875,000 $2,460,000 Underwriting income as a percent of premium revenue 30% 30% 30% Management is concerned that the administrative expenses may make...
Henderson Company has three product lines: baked goods, milk and fruit juice, and frozen foods. Company...
Henderson Company has three product lines: baked goods, milk and fruit juice, and frozen foods. Company has experienced net operating losses in its Milk & Fruit Juice line during the last few periods. Company management thinks that the store will improve its profitability if it discontinued the Milk & Fruit Juice line. For product line profitability analysis purposes, currently company is allocating operating expenses as a percentage of sales dollars which approximately is 30% of sales dollar. Sales Revenues                                                   $89,250          ...
Some construction company has bought a product for $200,000 with a life of three years, and...
Some construction company has bought a product for $200,000 with a life of three years, and a salvage value of $10,000. Tabulate depreciation and book value using MACRS, Double Declining Balance and straight-line methods. Which method gives the company the largest depreciation after two years?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT