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
- The 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_forwardA sub-capitation payment is a: a. fixed amount per month paid to a provider for only the care that an individual needs from that provider b. payment system that reimburses physicians based on the physician's work, practice expenses, and malpractice insurance expenses c. method of reimbursement whereby the health care provider is paid for individual services charged d. method of reimbursement for medical services whereby the provider accepts preestablished payments for providing care to patients for a certain period of time Which is a tax-deferred account used for qualified health care expenses in which unused funds roll over from year to year?arrow_forwardwhat are the components of the cost of goods sold (also known as cost of revenues for healthcare organizations)give a brief definition of each one of those componentsarrow_forward
- Complete this question by entering your answers in the tabs below. Req 1A Reg 1B Revenues Variable expenses Contribution margin Traceable fixed expenses: Prepare a properly formatted segmented income statement. Depreciation Liability insurance Program administrators' salaries Total traceable fixed expenses Req 2A Program segment margins General administrative overhead Net operating income (loss) Req 2B Total 0 0 0 0 0 0 0 House- keeping 0 0 0arrow_forwardwhich of the following items does accounts receivable include a. money paid for labor and received for services b. accounts receivable aging report c. state unemployment insurance d. overhead should include costs directly associated with a particular project, such a material and specific projects payrollarrow_forwardOhio Logistics manages the logistical activities for firms by matching companies that need products shipped with carriers that can provide the best rates and best service for the companies. Ohio Logistics is very concerned that its carriers deliver their customers material on time, so it carefully monitors the percentage of on-time deliveries. The following table contains a list of the carriers used by Ohio Logistics and the corresponding on-time percentages for the current and previous years. a. Sort the carriers in descending order by their current years percentage of on-time deliveries. Which carrier is providing the best service in the current year? Which carrier is providing the worst service in the current year? b. Calculate the change in percentage of on-time deliveries from the previous to the current year for each carrier. Use Excels conditional formatting to highlight the carriers whose on-time percentage decreased from the previous year to the current year. c. Use Excels conditional formatting tool to create data bars for the change in percentage of on-time deliveries from the previous year to the current year for each carrier calculated in part b. d. Which carriers should Ohio Logistics try to use in the future? Why?arrow_forward
- Please Do not Give image format and Solve All Requiredarrow_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_forwardI understand the cost classification, but not the total amount and percent of total. Thanks!arrow_forward
- If a prospect does NOT submit the initial premium with an application, the producer should A.refuse tratinghe application B.submit the application to the insurance company and advance the premium for he prospect from the agency account C.submit the applicalion to the insurance company without the premium D.give lhe applicant a conditional receipt and send the application to the insurance company wilhout the premiumarrow_forwardNeed help with the following missing data. Thank You!arrow_forwardThe adjusting entry to account for estimated customer returns and allowances involves a a. credit to Estimated Returns Inventory b. credit to Customer Refunds Payable c. debit to Customer Refunds Payable d. debit to Estimated Returns Inventorarrow_forward
- Essentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage LearningFinancial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningAuditing: A Risk Based-Approach to Conducting a Q...AccountingISBN:9781305080577Author:Karla M Johnstone, Audrey A. Gramling, Larry E. RittenbergPublisher:South-Western College PubPrinciples of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College