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

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 RatesNew policy processing....... $160 per new policyCancellation processing...... $240 per cancellationClaim audits............ $500 per claim auditClaim disbursements processing.... $120 per disbursementPremium collection processing... $ 25 per premium collectedActivity-base usage data for each line of insurance were retrieved from the corporate records and are shown below.

a. Complete the product profitability report through the administrative activities. Determine the income from operations as a percent of premium revenue, rounded to one decimal place.b. Interpret thereport.

Transcribed Image Text:

Shield Insurance Company Product Profitability Report For the Year Ended December 31, 2011 Workers' Homeowners Auto S5,600,000 Compensation $4,800,000 Premium revenue $7,200,000 5,040,000 $2,160,000 Less estimated claims Underwriting income Underwriting income as a percent of premium revenue 3,360,000 $1,440,000 3,920,000 $1,680,000 30% 30% 30%