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
EBK FINANCIAL & MANAGERIAL ACCOUNTING
- A 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_forwardActivity-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_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: 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_forwardCost of quality and value-added/non-value-added reports for a service company A. Using the information in Exercise 17, identify the cost of quality classification for each activity and whether the activity is value-added or non-value-added. B. Prepare a cost of quality report. Assume that sales are 3,000,000. (Round percentages to one decimal place.) C. Prepare a value-added/non-value-added analysis. D. Interpret the information in (B) and (C).arrow_forwardCost of Goods Manufactured and Income Statement with Predetermined Overhead and Labor Cost Classification Assume information pertaining to Bauer Hockey for April of the current year follows. Sales Purchases ● Raw materials Manufacturing supplies Office supplies Salaries (including fringe benefits) Administrative Production supervisors Sales Depreciation Plant and machinery Office and office equipment Utilities Plant Office Inventories $670,950 Finished goods Additional information follows: 202,500 10,800 1,980 92,340 22,050 94,500 21,600 7,200 13,500 5,400 April 1 April 30 $45,315 $47,250 Raw materials Manufacturing supplies 5,580 6,660 Office supplies 1,620 1,350 Work-in-process 34,650 36,180 81,000 79,200 000 panions •Manufacturing overhead is applied to products at 125% of direct labor dollars. Employee base wages are $15 per hour. Employee fringe benefits amount to 20% of the base wage rate. They are classified as manufacturing overhead. During April, production employees worked…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_forward1.Item Fixed/VarType Dir/IndLeather used for the bicycle seatsProduction manager’s salaryLife insurance for the company presidentElectricity used in the production facilitiesSales commissionsInternet advertisingEmployee benefits for the production workersProperty taxes on the production facilitiesShipping costsSalary of the chief financial officer*Type = S= Selling, M= Manufacturing, A= Administrative2. Unit costs for variable manufacturing expenses based on Nov (October) amounts:Leather used in seats: ________________________ = $____/bikeElectricity: ___________________________________= $___/bikeEmployee benefits____________________________ = $____/bikeDecember manufacturing costs:ItemPer unitAmount Activity CostLeather in seatsElectricity - variableEmployee benefitsProduction manager’s salary n/aElectricity - fixed n/aProperty taxes n Solve question 2arrow_forwardAllocating Selling and Administrative Expenses using Activity-Based CostingShrute Inc. manufactures office copiers, which are sold to retailers. The price and cost of goods sold for each copier are as follows: Price$1,110per unitCost of goods sold682 Gross profit$428per unit In addition, the company incurs selling and administrative expenses of $414,030. The company wishes to assign these costs to its three major retail customers, The Warehouse, Kosmo Co., and Supply Universe. These expenses are related to its three major nonmanufacturing activities: customer service, sales order processing, and advertising support. The advertising support is in the form of advertisements that are placed by Shrute Inc. to support the retailer's sale of Shrute copiers to consumers. The budgeted activity costs and activity bases associated with these activities are: ActivityBudgeted Activity Cost Activity BaseCustomer service$76,860Number of service requestsSales order processing25,920Number of sales…arrow_forward
- Assume a company’s activity-based costing system includes three activities with the following activity rates: Activity Cost Pool Activity Rate Travel $ 2 per mile driven Deliveries $ 50 per delivery Customer service $ 22 per phone call Two of the company’s many customers include Customer A and Customer B. These two customers consumed the company’s activities as follows: Total Expected Activity Customer A Customer B Travel (number of miles driven) 340 250 Deliveries (number of deliveries) 15 5 Customer service (number of phone calls) 20 12 How much cost would be assigned from the Travel activity to Customer A?arrow_forwardCurrent Attempt in Progress Presented below are Crane Company's monthly manufacturing cost data related to its personal computer products. a. b. C d. a Enter each cost item in the following table, placing an X under the appropriate headings. b. C. Hard drives and memory sticks Wages to assemble equipment Insurance on manufacturing building Wages for factory supervisors d. Direct Materials $27.600 $59,800 $37,720 $58,880 Save for Later Product Costs Direct Labor Manufacturing Overhead Attempts: 0 of 1 used. Submit Answerarrow_forwardStep-Down Method The Ferre Publishing Company has three service departments and two operating departments. Selected data from a recent period on the five departments follow The company allocates service department costs by the step-down method in the following order: Administration (number of employees). Janitorial (space occupied), and Maintenance (hours of press time). Required: Using the step-down method, allocate the service department costs to the operating departments.:arrow_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
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning