Complete the product profitability report

Assignment Help Accounting Basics
Reference no: EM132690684

Problem - Activity-based costing in an insurance company

Safeguard Insurance Company carries three major lines of insurance: auto, workers' compensation, and homeowners. The company has prepared the following report for 2013:

Safeguard Insurance Company Product Profitability Report For the Year Ended December 31, 2013


Auto

Workers' Compensation

Homeowners

Premium revenue

$4,800,000

$5,200,000

$6,800,000

Less estimated claims

3,360,000

3,640,000

4,760,000

Underwriting income

$1,440,000

$1,560,000

$2,040,000

Underwriting income as a percent of premium revenue

30%

30%

30%

Management is concerned that the administrative expenses may make some of the insurance lines unprofitable. However, the administrative expenses have not been allocated 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

$150 per new policy

Cancellation processing 

$220 per cancellation

Claim audits 

$400 per claim audit

Claim disbursements processing 

$130 per disbursement

Premium collection processing 

$30 per premium collected

Activity-base usage data for each line of insurance was retrieved from the corporate records and is shown below.

 

Auto

Workers' Comp.

Homeowners

Number of new policies

1,100

1,250

3,400

Number of canceled policies  

400

200

1,800

Number of audited claims

320

100

800

Number of claim disbursements

400

180

700

Number of premiums collected

7,000

1,500

13,000

Required -

a. Complete the product profitability report through the administrative activities. Determine the income from operations as a percent of premium revenue, rounded to the nearest whole percent.

b. Interpret the report.

Reference no: EM132690684

Questions Cloud

Explain how you integrated the therapeutic approaches : Explain how you integrated the therapeutic approaches from this course in your clinical practice. Include how this helped you achieve the goals and objectives.
Determine the activity cost associated with each patient : Valley Hospital plans to use activity-based costing to assign hospital indirect costs to the care of patients. Determine the activity cost
Develop diagnoses for clients receiving psychotherapy : Develop diagnoses for clients receiving psychotherapy. Analyze legal and ethical implications of counseling clients with psychiatric disorders.
How the core determinants of health are impacting the health : Create a PowerPoint presentation to illustrate and explain how the core determinants of health are impacting the health of your target population utilizing the.
Complete the product profitability report : Complete the product profitability report through the administrative activities. Determine the income from operations as a percent of premium revenue
How your company will increase diversity at all levels : Create a PowerPoint presentation to explain why and how your company (The Widget Company) will increase diversity at all levels. You may create an assessment.
How the world we live in is shaped by what we sense : The internet can be used to do your own research about how the world we live in is shaped by what we sense and what we perceive. Go to the link The Human Senses
Determine the per-unit factory overhead : Determine the per-unit factory overhead allocated to the gasoline and diesel engines under the single plantwide factory overhead rate method
What is value chain : What is value chain? Who are the channel members?

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd