Process activity analysis for a service company
Statewide Insurance- Company has a process for making payments on insurance claims as follows:
An activity analysts revealed that the cost of these activities was as follows:
Receiving claim | $120,000 |
Adjusting claim | 260,000 |
Paying claim | 120,000 |
Total | $ 500,000 |
This process includes only the cost of processing the claim payments, not the actual amount of the claim payments. The adjusting activity involves verifying and estimating the amount of the claim and is variable to the number of claims adjusted.
The process received, adjusted, and paid 2,000 claims during the period. All claims were treated identically in this process.
To improve the cost of this process, management has determined that claims should be segregated into two categories. Claims under $1,000 and claims greater than $1,000: claims under $1,000 would not be adjusted but would be- accepted upon the insured's evidence of claim. Claims above $1,000 would the adjusted. It is estimated that 80% of the claims are under $1,000 and would thus be paid without adjustment. It is also estimated that the additional effort to segregate claims would add 10% to the "receiving claim" activity cost.
- A. Develop a table showing the percent of individual activity cost to the total
process cost . - B. Determine the
average total process cost per claim payment, assuming 2,000 total claims. - C. Prepare a table showing the changes in the activity costs as a result of the changes proposed by management. Show columns of activity cost prior to improvement, after improvement, and savings.
- D. Estimate the average cost per claim payment, assuming that the changes proposed by management are enacted for 2,000 total claims.
Trending nowThis is a popular solution!
Chapter 26 Solutions
Financial & Managerial Accounting
- Bounce Back Insurance Company carries three major lines of insurance: auto, workers' compensation, and homeowners. The company has prepared the following report: Bounce Back Insurance CompanyProduct Profitability ReportFor the Year Ended December 31 Auto Workers' Compensation Homeowners Premium revenue $5,800,000 $6,250,000 $8,200,000 Estimated claims (4,060,000) (4,375,000) (5,740,000) Underwriting income $1,740,000 $1,875,000 $2,460,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 Activity…arrow_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_forwardThe total number of term life insurance contracts sold in Problem 13 is 199. The following pie chart shows the percentages of contracts sold by each salesperson. a. What are the problems with using a pie chart to display these data? b. What type of chart would be preferred for displaying the data in this pie chart? c. Use a different type of chart to display the percentage of contracts sold by each salesperson that conveys the data better than the pie chart. Format the chart and add data labels to improve the charts readability.arrow_forward
- The writing assignment will demonstrate writing across the curriculum by responding to the following topic in a 500-700 words in length paper. Two accounting students were discussing the timing of revenue recognition for long-term construction contracts. The discussion focused on which method was most like the typical revenue recognition method of recognizing revenue at the point of product delivery. Bill argued that recognizing revenue upon project completion was preferable because it was analogous to recognizing revenue at the point of delivery. John disagreed and supported recognizing revenue over time, stating that it was analogous to accruing revenue as a satisfied performance obligation. John also pointed out that an advantage of recognizing revenue over time is that it provides information sooner to users. Discuss the arguments made by both students. Which argument do you support? Why?arrow_forwardThe ledger of Casper Consulting at January 31, 20X5 includes the following selectedaccounts:Prepaid insuranceSuppliesBuildingLandNotes payableUnearned service revenueDebit$3,6001,800100.00060,000Credit$90,0008,000Casper's accountant is inexperienced, and he would like your help in preparing thecompany's January 31, 20X5 financial statements. He has provided you with the following information:1. A one-year insurance policy costing $3,600 was purchased on January 1, 20X5. Atthat time the full amount was debited to prepaid insurance.2. A physical inventory count on January 31,20X5 revealed $800 in supplies were still.remaining.3. Land and building were purchased on January 1, 20X5 at a cost of $160,000. Thebuilding has an expected useful life of 20 years. The purchase was financed by paying$70,000 in cash and the balance on a 2-year, 8% note payable. Interest for the monthof January was $600 and was paid on February 1, 20X5.4. Unearned service revenue related to a client retainer paid on…arrow_forwardACCRUALS & DEFERRALSAnswer and explain thoroughly EXERCISES For the following items, make a journalentry of the original transaction (ifapplicable) a. Paid $10,800 for 6-months’ insurance premiums. b. The balance in the ledger account Office Suppliesamounted to $32,000. A count of the office supplies onNov. 30 totaled $12,800. c. Received $22,800 on Nov. 1 from a customer forservices to be rendered during the months of November,December, January, and February. d. Acquired Office Equipment costing $352,800 on April 1.the equipment is expected to last 5 years. After which, itwill be worthless. e. Assume that on Nov. 30 is a Friday and that thecompany pays its employees a total of $87,500 onSaturday.arrow_forward
- VIP-MD is a health maintenance organization (HMO) located in North Carolina. Unlike the traditional fee-for-service model that determines the payment according to the actual services used or costs incurred, VIP-MD receives a fixed, prepaid amount from subscribers. The per member, per month rate (PMPM) is determined by estimating the health care cost per enrollee within a geographic location. The average health care coverage in North Carolina costs $364 per month, which is the same amount irrespective of the subscriber’s age. Because individuals are demanding quality care at reasonable rates, VIP-MD must contain its costs to remain competitive. A major competitor, National Physicians, entered the North Carolina market early in the current year with a monthly premium of $321. VIP-MD wants to maintain its current market penetration and hopes to increase its enrollees in the current year. The latest data on the number of enrollees and the associated costs follow: Age Enrollment in…arrow_forwardPlease help me by showing your solution in good accounting form. Thank you! Ayala Homes is a construction company who uses the percentage of completion method in accounting for its income. The company began constructing a building in the year 2019 for a contract price of P5,000,000. For the year ended 2019, the company billed its clients a total of 30% of the contract price. The books of the company show the following balances: Costs incurred to date P900,000; Construction income to date P300,000. How much is the company’s contract asset (liability) for the year 2019?arrow_forwardEthical Considerations. In the process of closing thecompany books, you encounter a problematic transaction. One of the company’s customers was invoicedtwice for the same project materials, resulting in a$1,000 overcharge. You immediately notify the controller, whose response is, “Let it go, it happens often.It’ll probably balance out on some future transaction.”What should you do now?arrow_forward
- Bagwis Company has the following information: Prepaid insurance – January 1 1,600,000 Prepaid insurance – December 800,000 Insurance payable decrease by 1,200,000 Insurance payments 4,000,000 How much is the insurance expense under accrual basis? Group of answer choices 3,600,000 4,800,000 3,400,000 4,000,000arrow_forwardCustomers as a Cost Object Morrisom National Bank has requested an analysis of checking account profitability by customer type. Customers are categorized according to the size of their account: low balances, medium balances, and high balances. The activities associated with the three different customer categories and their associated annual costs are as follows: Additional data concerning the usage of the activities by the various customers are also provided: Required: (Note: Round answers to two decimal places.) 1. Calculate a cost per account per year by dividing the total cost of processing and maintaining checking accounts by the total number of accounts. What is the average fee per month that the bank should charge to cover the costs incurred because of checking accounts? 2. Calculate a cost per account by customer category by using activity rates. 3. Currently, the bank offers free checking to all of its customers. The interest revenues average 90 per account; however, the interest revenues earned per account by category are 80, 100, and 165 for the low-, medium-, and high-balance accounts, respectively. Calculate the average profit per account (average revenue minus average cost from Requirement 1). Then calculate the profit per account by using the revenue per customer type and the unit cost per customer type calculated in Requirement 2. 4. CONCEPTUAL CONNECTION After the analysis in Requirement 3, a vice president recommended eliminating the free checking feature for low-balance customers. The bank president expressed reluctance to do so, arguing that the low-balance customers more than made up for the loss through cross-sales. He presented a survey that showed that 50% of the customers would switch banks if a checking fee were imposed. Explain how you could verify the presidents argument by using ABC.arrow_forwardService Revenue Softball Magazine Company received advance payments of $75,000 from customers during 2019. At December 31, 2019, $20,000 of the advance payments still had not been earned. Required: After the adjustments are recorded and posted at December 31, 2019, calculate what the balances will be in the Unearned Magazine Revenue and Magazine Revenue accounts. Use the following information for Cornerstone Exercises 5-23 and 5-24: Bolton sold a customer service contract with a price of S37 000 to Sammys Wholesale Company. Bolton offered terms of 1/10, n/30 and expects Sammy to pay within the discount period.arrow_forward
- Financial & Managerial AccountingAccountingISBN:9781285866307Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage LearningEssentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
- Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage LearningIntermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage Learning