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 14th Ed. W/ PAC LMS Intg CNOWv2 2S
- Process activity analysis: For a service company Statewide insurance company has a process for making payments on insurance claims as follows. An activity analysis revealed the cause of these activities was as follows. Receiving claim $78,000 Adjusting claim 338,000 Paying claim 104,000 Total. $520,000 This process includes only the cost of the process the claims payments, not the actual amount of the claim payments. The adjustment activity involves verify the estimated amount of the claim and is variable to the number of claims adjusted. The process received, adjusted, and paid 6,500 claims During the period. All claims were treated identically in this process. To improve the cost of the process, management has determined that claims should be segregated into two categories. Claims under $1,000 at claims greater than $1,000 claims under 1,000 would not be adjusted but would be acceptable to insured evidence of the claim. Claims above $1,000 would be adjusted it is estimated…arrow_forwardProcess activity analysis for service Company making payments on insurance claims as follows: Receiving claim, adjusting claim,paying claim. Receiving claim- $78,000, adjusting claim- 338,000, paying claim-104,000 ,total $ 520,000 This process includes only the Consular processing the claim payments, not ask you about when the claim payments. The adjustment activity involves verifying and estimated amount of clean and is variable to the number of claims adjust. The process receive adjusted, and paid 6,500 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 claims greater than 1,000; claims under 1,000 would not be adjusted but will be accepted upon insureds xthe evidence of claims. Play Inseparable at the housing would be adjusted. It is estimated that 75% of the claims are under a thousand and would thus be paid…arrow_forwardActivity Bases for Service Department Charges For each of the following service departments, select the activity base listed that is most appropriate for charging service expenses to responsible units. Your answer should include the number of the activity base only. Activity bases 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 Service Department Activity Base a. Accounts Receivable fill in the blank 1 b. Central Purchasing fill in the blank 2 c. Computer Support fill in the blank 3 d. Conferences fill in the blank 4 e. Employee Travel fill in the blank 5 f. Payroll Accounting fill in the blank 6 g. Telecommunications fill in the blank 7 h. Training fill in the blank 8arrow_forward
- 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_forwardplease answer within the format by providing formula the detailed workingPlease provide answer in text (Without image)Please provide answer in text (Without image)Please provide answer in text (Without image)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_forward
- 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_forwardHi there, this question uses the T-char and asks to calculate: - cost of supplies during this period - cost paid to purcahse new insurance this period - amount of interest payable that was paid during this period How do I calculate this?arrow_forwardPlease do not give image formatarrow_forward
- Please provide answer in text (Without image)arrow_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_forwardFor each of the following expenses, select the best allocation basis. A. Value of insured assets. B. Square feet of space occupied. C. Proportion of total purchase orders for each operating department. D. Number of employees in department. Maintenance department expenses of the operating departments. Payroll department expenses of all departments. Purchasing department expenses for the operating departments. Insurance expenses of all departments.arrow_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 LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
- Auditing: 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 CollegeAccounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,