Activity-base usage data for each line of insurance were retrieved from the corporate records and are shown below. Auto Workers Comp. Homeowners Number of new policies Number of canceled policies 1,500 1,450 4,100 350 250 Number of audited claims Number of claim disbursements 320 400 2,000 700 750 100 180 Number of premiums collected 7500 1,500 12,000 a. Complete the product profitability report through the administrative activities. b. Determine the underwriting income as a percent of premium revenue. . Determine the operating income as a percent of premium revenue, rounded to one decimal place. d. Interpret the report.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Topic Video
Question
activity-based-costing-in-an-insurance-company-umbrella-insurance-company-carries-three-major-lines
Activity-base usage data for each line of insurance were retrieved from the corporate
records and are shown below.
Auto
Workers' Comp.
Homeowners
Number of new policies
Number of canceled policies
1,500
350
1,450
250
4,100
2,000
Number of audited claims
320
100
700
400
7500
Number of claim disbursements
180
750
Number of premiums collected
1,500
12,000
a Complete the product profitability report through the administrative activities.
b. Determine the underwriting income as a percent of premium revenue.
6. Determine the operating income as a percent of premium revenue, rounded to one decimal
place.
d. Interpret the report.
Transcribed Image Text:Activity-base usage data for each line of insurance were retrieved from the corporate records and are shown below. Auto Workers' Comp. Homeowners Number of new policies Number of canceled policies 1,500 350 1,450 250 4,100 2,000 Number of audited claims 320 100 700 400 7500 Number of claim disbursements 180 750 Number of premiums collected 1,500 12,000 a Complete the product profitability report through the administrative activities. b. Determine the underwriting income as a percent of premium revenue. 6. Determine the operating income as a percent of premium revenue, rounded to one decimal place. d. Interpret the report.
Umbrella Insurance Company carries three major lines of insurance: auto, workers' com-
pensation, and homeowners. The company has prepared the following report for 20Y2:
UMBRELLA INSURANCE COMPANY
Product Profitabili y Report
For the Year Ended December 31, 202
Workers
Auto
Compensation
Homeowners
Premkum revenue
$7,200,000
(5,040,000)
$2,160,000
$6500000
$9,200,000
(6,440,00
$2,760,000
Less estimated claims
4550000)
$1,950,000
Underwriting income
Management is concemed that the administrative expenses may make some of the
insurance lines unprofitable. However, the administrative expenses have not been allo-
cated to the insurance lines. The controller has suggested that the administrative expenses
could be assigned to the insurance lines using activity-based costing. The administrative
expenses are comprised of five activities. The activities and their rates are as follows:
Activity Rates
New policy processing
Cancellation procensing
Claim audits
Claim disbursements processing
Premium collection processing
$160 per new policy
$240 per cancellation
S500 per claim audit
$120 per disbursement
S 25 per premium collected
Transcribed Image Text:Umbrella Insurance Company carries three major lines of insurance: auto, workers' com- pensation, and homeowners. The company has prepared the following report for 20Y2: UMBRELLA INSURANCE COMPANY Product Profitabili y Report For the Year Ended December 31, 202 Workers Auto Compensation Homeowners Premkum revenue $7,200,000 (5,040,000) $2,160,000 $6500000 $9,200,000 (6,440,00 $2,760,000 Less estimated claims 4550000) $1,950,000 Underwriting income Management is concemed that the administrative expenses may make some of the insurance lines unprofitable. However, the administrative expenses have not been allo- cated to the insurance lines. The controller has suggested that the administrative expenses could be assigned to the insurance lines using activity-based costing. The administrative expenses are comprised of five activities. The activities and their rates are as follows: Activity Rates New policy processing Cancellation procensing Claim audits Claim disbursements processing Premium collection processing $160 per new policy $240 per cancellation S500 per claim audit $120 per disbursement S 25 per premium collected
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

Blurred answer
Knowledge Booster
Costing Systems
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education