Concept explainers
Activity-based costing for a service company
Safely First Insurance Company tarries three major lines of insurance: auto, workers’ compensation, and homeowners. The company has prepared the following report:
Safety First Insurance Company Product Profitability Report For the Year Ended December 31 |
|||
Auto | Workers’ Compensation | Homeowners | |
Premium revenue | $5,750,000 | $6,240,000 | $8,160,000 |
Estimated claims | 4,312,500 | 4,680,000 | 6,120,000 |
Underwriting income | $1,437,500 | $1,560,000 | $2,040,000 |
Underwriting income as a percent of premium revenue | 25% | 25% | 25% |
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 he 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 | Activity Rates |
New policy processing | $120 per new policy |
Cancellation processing | $175 per cancellation |
Claim audits | $320 per claim audit |
Claim disbursements processing | $104 per disbursement |
Premium collection processing | $ 24 per premium collected |
Activity-base usage data for each line of insurance were retrieved from the corporate records as follows:
Auto | Workers’ Compensation | Homeowners | |
Number of new policies | 1,320 | 1,500 | 4,080 |
Number of canceled policies | 480 | 240 | 2,160 |
Number of audited claims | 385 | 120 | 960 |
Number of claim disbursements | 480 | 216 | 840 |
Number of premiums collected | 8,400 | 1,800 | 15,000 |
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.
Want to see the full answer?
Check out a sample textbook solutionChapter 26 Solutions
Financial & Managerial Accounting
- compute the customer level operating income of this customer for abc corporation using the companys activity based costing systemarrow_forwardA company uses charging rates to allocate service department costs to the using departments. The accountant compiled the following information on one of the service departments: If Department K plans to use 1,350 hours of the service departments service in the coming year, how much of the service departments cost is allocated to Department K? a. 3,375 b. 27,300 c. 26,325 d. 23,950arrow_forwardBounce Back Insurance Company carries three major lines of insurance: auto, workers compensation, and homeowners. The company has prepared the following report: 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 as follows: a. Complete the product profitability report through the administrative activities. Determine the operating income as a percent of premium revenue, rounded to the nearest whole percent. b. Interpret the report.arrow_forward
- 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.arrow_forwardProduct costing and decision analysis for a service company Pleasant Stay Medical Inc. wishes to determine its product costs. Pleasant Stay offers a variety of medical procedures (operations) that are considered its products. The overhead has been separated into three major activities. The annual estimated activity costs and activity bases follow: Total patient days are determined by multiplying the number of patients by the average length of stay in the hospital. A weighted care unit (wcu) is a measure of nursing effort used to care for patients. There were 192,000 weighted care units estimated for the year. In addition, Pleasant Stay estimated 6,000 patients and 27,000 patient days for the year. (The average patient is expected to have a a little more than a four-day stay in the hospital.) During a portion of the year, Pleasant Stay collected patient information for three selected procedures, as follows: Private insurance reimburses the hospital for these activities at a fixed daily rate of 406 per patient day for all three procedures. Instructions Determine the activity rates. Determine the activity cost for each procedure. Determine the excess or deficiency of reimbursements to activity cost. Interpret your results.arrow_forwardActivity-based costing for a service business Sterling Hotel uses activity-based costing to determine the cost of servicing customers. There are three activity pools: guest check-in, room cleaning, and meal service. The activity rates associated with each activity pool are 8 per guest check-in, 25 per room cleaning, and 4 per served meal (not including food). Ginny Campbell visited the hotel for a three-night stay. Campbell had three meals in the hotel during her visit. Determine the total activity-based cost for Campbells visit.arrow_forward
- Product Costing and Decision Analysis for a Service Company Pleasant Stay Medical Inc. wishes to determine its product costs. Pleasant Stay offers a variety of medical procedures (operations) that are considered its “products.” The overhead has been separated into three major activities. The annual estimated activity costs and activity bases follow: Activity Budgeted Activity Cost Activity Base Scheduling and admitting $432,000 Number of patients Housekeeping 4,212,000 Number of patient days Nursing 5,376,000 Weighted care unit Total costs $10,020,000 Total “patient days” are determined by multiplying the number of patients by the average length of stay in the hospital. A weighted care unit (wcu) is a measure of nursing effort used to care for patients. There were 192,000 weighted care units estimated for the year. In addition, Pleasant Stay estimated 6,000 patients and 27,000 patient days for the year. (The…arrow_forwardDhapaarrow_forwardExercise 7-3 (Algo) Compute Activity Rates [LO7-3] Green Thumb Gardening is a small gardening service using activity-based costing to estimate costs for pricing and other purposes. The owner of the company believes costs are driven primarily by the size of customer lawns, the size of customer garden beds, the distance to travel to customers, and the number of customers. In addition, the costs of maintaining garden beds depend on whether the beds are low-maintenance beds (mainly ordinary trees and shrubs) or high-maintenance beds (mainly flowers and exotic plants). Accordingly, the company uses the five activity cost pools listed below: Activity Cost Pool Caring for lawn Caring for garden beds-low maintenance Caring for garden beds-high maintenance Travel to jobs Customer billing and service Activity Cost Pool Caring for lawn Caring for garden beds-low maintenance Caring for garden beds-high maintenance Travel to jobs Customer billing and service Square feet of lawn Square feet of…arrow_forward
- A manufacturer uses activity-based costing to assign overhead costs to products. Budgeted cost information for selected activities for next year follows. Activity Purchasing Cleaning factory Providing utilities Activity cost pool Purchasing Factory Expected Cost $127,600 31,500 63,070 Expected Costs Compute activity rates for each of the cost pools. (Round your answers to 2 decimal places.) Expected Amount of Cost Driver Cost Driver Purchase orders Square feet Square feet 4,400 4,900 Activity Overhead Rate Expected Usage of Cost Driver 4,488 purchase orders 4,900 square feet 4,900 square feet per purchase order per square footarrow_forwardMarkup on Cost, Job Pricing Privacy Window and Wall Treatments Company provides draperies, shades, and various window treatments. Privacy works with the customer to design the appropriate window treatment, places the order, and installs the finished product. Direct materials and direct labor costs are easy to trace to the jobs. Privacy's income statement for last year is as follows: Revenues $235,500 Cost of goods sold: Direct materials $120,105 Direct labor 40,035 Overhead 28,260 188,400 Gross profit $47,100 Selling and administrative expenses 26,300 Operating income $20,800 Privacy wants to find a markup on cost of goods sold that will allow them to earn about the same amount of profit on each job as was earned last year. Required: 1. What is the markup on cost of goods sold (COGS) that will maintain the same profit as last year? (Round to the nearest whole percent. Use this amount for future…arrow_forwardHaresharrow_forward
- Financial & Managerial AccountingAccountingISBN:9781337119207Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage LearningSurvey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage LearningManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
- Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning