Concept explainers
Activity-based costing in an insurance company
Umbrella Insurance Company carries three major lines of insurance: auto, workers' compensation, and homeowners. The company has prepared the following report for 20Y2:
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-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.
b.Determine the underwriting income as a percent of premium revenue.
C.Determine the Operating income as a percent of premium revenue, rounded to one decimal place.
d.Interpret the report.
(a)
Concept Introduction:
Activity based costing is one of the costing method that identify the important activities in the organisation and accordingly identify their cost drivers. Then cost is allocated on the basis of activities used by each product.
Through administrative activities complete the product profitability report.
Answer to Problem 10.25E
The product profitability report through the administrative activities is given in table below.
Explanation of Solution
The product profitability report through the administrative activities is below:
Particulars | Auto (in $) | Worker compensation (in $) | Homeowner (in $) |
New policy processing per new policy | | | |
Cancellation processing per cancellation | | | |
Claim audit per claim audit | 13y13 | Y13y3 | |
Claim disbursement per claim disbursement | | | |
Premium collection processing per premium | | | |
Total administrative cost | | | |
Preparation of Income statement is as follows:
Particulars | Auto (in $) | Worker compensation (in $) | Homeowner (in $) |
Underwriting income before administrative expenses | | | |
Less: Administrative expenses | | | |
Underwriting net Income | | | |
(b)
Concept Introduction:
Activity based costing is one of the costing method that identify the important activities in the organisation and accordingly identify their cost drivers. Then cost is allocated on the basis of activities used by each product.
To compute:
The underwriting income as a percent of premium revenue.
Answer to Problem 10.25E
The underwriting income as a percent of premium revenue is
Explanation of Solution
Calcultion of underwriting income as a percent of premium revenue are as follows:
Underwriting income as a percent of premium revenue is:
So, the answer is
(c)
Concept Introduction:
Activity based costing is one of the costing method that identify the important activities in the organisation and accordingly identify their cost drivers. Then cost is allocated on the basis of activities used by each product.
The operating income as a percent of premium revenue.
Answer to Problem 10.25E
Operating income as a percent of premium revenue is
Explanation of Solution
Calculation of operating income as a percent of premium revenue is as follows:
Operating income as a percent of premium revenue
So, the answer is
(d)
Concept Introduction:
Activity based costing is one of the costing method that identify the important activities in the organisation and accordingly identify their cost drivers. Then cost is allocated on the basis of activities used by each product.
The interpretation of report.
Answer to Problem 10.25E
The premium revenue's significant part is used in the administrative expenses.
Explanation of Solution
Underwriting income as a percent of premium revenue after reducing administrative expenses is
So, this clearly shows that important part of premium revenue is used in administrative expenses, which helps company in profitability.
Want to see more full solutions like this?
Chapter 10 Solutions
Survey of Accounting (Accounting I)
- Interview questions are asked to determine a. what activities are being performed. b. who performs the activities. c. the relative amount of time spent on each activity by individual workers. d. possible activity drivers for assigning costs to products. e. All of these.arrow_forwardA process costing system Is most likely used by which of the following? airplane manufacturing a paper manufacturing company an accounting firm specializing in tax returns a hospitalarrow_forwardIdentifying basis for distribution of service department costs What would be the appropriate basis for distributing the costs of each of the following service departments to the user departments? Building maintenance Inspection and packing Machine repair Human resources Purchasing Shipping Raw materials storeroomarrow_forward
- Activity-Based Costing and Customer Profitability Schneider Electric manufactures power distribution equipment for commercial customers, such as hospitals and manufacturers. Activity-based costing was used to determine customer profitability. Customer service activities were assigned to individual customers, using the following assumed customer service activities, activity base, and activity rate: Customer Service Activity Activity Base Activity Rate Bid preparation Number of bid requests $400 per request Shipment Number of shipments $ 80 per shipment Support standard items Number of standard items ordered $ 25 per std. item Support nonstandard items Number of nonstandard items ordered $150 per nonstd. item Assume that the company had the following gross profit information for three representative customers: Customer 1 Customer 2 Customer 3 Revenues $120,000 $200,000 $160,000 Cost of goods sold 76,800 110,000 83,200 Gross profit…arrow_forwardActivity-Based Costing and Customer Profitability Schneider Electric manufactures power distribution equipment for commercial customers, such as hospitals and manufacturers. Activity-based costing was used to determine customer profitability. Customer service activities were assigned to individual customers, using the following assumed customer service activities, activity base, and activity rate: Customer Service Activity Activity Base Activity Rate Bid preparation Number of bid requests $400 per request Shipment Number of shipments $ 80 per shipment Support standard items Number of standard items ordered $ 25 per std. item Support nonstandard items Number of nonstandard items ordered $150 per nonstd. item Assume that the company had the following gross profit information for three representative customers: Customer 1 Customer 2 Customer 3 Revenues $120,000 $200,000 $160,000 Cost of goods sold 76,800 110,000 83,200 Gross profit…arrow_forwardCost Drivers for Support Department Allocations For each of the following support departments, select the cost driver listed that is most appropriate for allocating support department costs to responsible units. Your answer should include the number of the cost driver only. Cost drivers to choose from: Number of conference attendees Number of computers Number of employees trained Number of cell phone minutes used Number of purchase requisitions Number of sales invoices Number of payroll checks Number of travel claims Support Department Cost Driver a. Accounts Receivable b. Central Purchasing c. Computer Support d. Conferences e. Employee Travel f. Payroll Accounting g. Telecommunications h. Trainingarrow_forward
- Shipping, selling, marketing, sales order processing, return processing, and advertising activities can be related to products by using activity-based costing. Would allocating these activities to products for financial statement reporting be acceptable according to GAAP? What would happen to net income if the activities noted in Discussion Question 6 were allocated to products for financial statement reporting and the inventory increased? Under what circumstances might the activity-based costing method provide more accurate product costs than the multiple production department factory overhead rate method? When might activity-based costing be preferred over using a relative amount of product sales in allocating selling and administrative expenses to products? Under what two conditions would the multiple production department factory overhead rate method provide more accurate product costs than the single plant wide factory overhead rate method?arrow_forwardActivity-Based Costing Hakara Company has been using direct labor costs as the basis forassigning overhead to its many products. Under this allocation system, product A has been assignedoverhead of $10.80 per unit, while product B has been assigned $3.60 per unit. Management feels thatan ABC system will provide a more accurate allocation of the overhead costs and has collected thefollowing cost pool and cost driver information:Cost Pools Activity Costs Cost Drivers Activity Driver ConsumptionMachine setup $360,000 Setup hours 4,000Materials handling 100,000 Pounds of materials 20,000Electric power 40,000 Kilowatt-hours 40,000The following cost information pertains to the production of A and B, just two of Hakara’s manyproducts:A BNumber of units produced 4,000 20,000Direct materials cost $42,000 $54,000Direct labor cost $24,000 $40,000Number of setup hours 400 200Pounds of materials used 1,000 3,000Kilowatt-hours 2,000 4,000Required1. Use activity-based costing to determine a unit cost…arrow_forwardAccounting Direct labor or machine hours may not be the appropriate cost driver for overhead in all areas of manufacturing due to the complexities of many manufacturing processes. Many companies use activity-based costing (ABC) which uses multiple drivers (items that consume resources) rather than just one driver to apply overhead to their activities. With ABC, a company can use a cost driver that has a direct cause/effect relationship in its applied overhead costs. Waterways looked into ABC as a method of costing because of the variety of items it produces and the many different activities in which it is involved. The activities listed below area sample of possible cost pools for Waterways. Assembling Payroll Billing Plant supervision Digging trenches Product design Janitorial Purchasing materials Machine maintenance Selling Machine setups Testing Molding Welding Packaging Using the following information, determine the overhead rates and the actual cost assigned for each of the…arrow_forward
- Match each definition with its related term by selecting the appropriate term in the dropdown provided. Dropdown options: An accounting system that records all actual amounts after the expense has occurred. An accounting system that records all costs based on estimated amounts. An accounting system that records all direct materials and direct labor at actual amounts, while assigning manufacturing overhead costs using predetermined overhead rates. Difference between actual and planned results. Standards that are tight but are used to motivate individuals to work hard and achieve results. Standards that can be achieved only under perfect conditions. The difference between actual cost and the flexible budget for materials. The difference between actual labor hours and standard labor hours multiplied by the actual labor rate. The difference between actual labor hours and standard labor hours multiplied by the standard labor rate. The difference between actual price and standard price…arrow_forwardActivity-based costing (ABC) tions O uses a single pre-determined overhead rate. O is less complex than a traditional costing system. rces O can be used only by service companies. O provides enhanced control over overhead costsarrow_forwardWhich among the following decision can be taken with Life Cycle Costing method? a. Making choice between competing supplies of products and services b. All the options listed c. Purchase of a machinery to be used in production process d. Implementing new computerized system in the companyarrow_forward
- Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage LearningFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
- Principles of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College