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
Bundle: Financial & Managerial Accounting, Loose-leaf Version, 14th + Working Papers For Warren/reeve/duchac's Corporate Financial Accounting, 14th + ... 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_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
- For 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_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_forwardpercetage of completion method (over time) using cost to cost method: 1. compute the due from to customersarrow_forward
- For each of the following expenses, select the best allocation basis. A. Value of insured assets. B. Proportion of total purchase orders for each operating department. C. Square feet of space occupied. D. Number of employees in department. Insurance expenses of all departments. Personnel department expenses of all departments. Purchasing department expenses for the operating departments. Maintenance department expenses of the operating departments.arrow_forwardJohnson Filtration. Inc., provides maintenance service for water filtration systems throughout southern Florida. Customers contact Johnson with requests for maintenance service on their water filtration systems. To estimate the service time and the service cost. Johnson’s managers want to predict the repair time necessary for each maintenance request. Hence, repair time in hours is the dependent variable. Repair time is believed to be related to three factors: the number of months since the last maintenance service, the type of repair problem (mechanical or electrical), and the repairperson who performs the repair (Donna Newton or Bob Jones). Data for a sample of 10 service calls are reported in the following table: Develop the simple linear regression equation to predict repair time given the number of months since the last maintenance service, and use the results to test the hypothesis that no relationship exists between repair time and the number of months since the last maintenance service at the 0.05 level of significance. What is the interpretation of this relationship? What does the coefficient of determination tell you about this model? Using the simple linear regression model developed in part (a), calculate the predicted repair time and residual for each of the 10 repairs in the data. Sort the data in ascending order by value of the residual. Do you see any pattern in the residuals for the two types of repair? Do you see any pattern in the residuals for the two repairpersons? Do these results suggest any potential modifications to your simple linear regression model? Now create a scatter chart with months since last service on the x-axis and repair time in hours on the y-axis for which the points representing electrical and mechanical repairs are shown in different shapes and/or colors. Create a similar scatter chart of months since last service and repair time in hours for which the points representing repairs by Bob Jones and Donna Newton are shown in different shapes and/or colors. Do these charts and the results of your residual analysis suggest the same potential modifications to your simple linear regression model? Create a new dummy variable that is equal to zero if the type of repair is mechanical and one if the type of repair is electrical. Develop the multiple regression equation to predict repair time, given the number of months since the last maintenance service and the type of repair. What are the interpretations of the estimated regression parameters? What does the coefficient of determination tell you about this model? Create a new dummy variable that is equal to zero if the repairperson is Bob Jones and one if the repairperson is Donna Newton. Develop the multiple regression equation to predict repair time, given the number of months since the last maintenance service and the repairperson. What are the interpretations of the estimated regression parameters? What does the coefficient of determination tell you about this model? Develop the multiple regression equation to predict repair time, given the number of months since the last maintenance service, the type of repair, and the repairperson. What are the interpretations of the estimated regression parameters? What does the coefficient of determination tell you about this model? Which of these models would you use? Why?arrow_forwardTopic: REVENUE FROM CONTRACTS WITH CUSTOMERS Requirments: a. Compute for the total discount granted to the customer. b. Allocate the transaction price to the performance obligations in the contract.arrow_forward
- Briefly describe the guidelines provided by GAAP for the recognition of revenue by a franchisor for an initialfranchise feearrow_forwardListed below are several costs incurred in the loan department of Suwanee Bank and Trust Company. For each cost, indicate which of the following classifications best describe the cost. More than one classification may apply to the same cost item.Cost Classificationsa. Controllable by the loan department managerb. Uncontrollable by the loan department managerc. Direct cost of the loan departmentd. Indirect cost of the loan departmente. Differential costf. Marginal costg. Opportunity costh. Sunk costi. Out-of-pocket costCost Items1. Salary of the loan department manager.2. Cost of office supplies used in the loan department.3. Cost of the department’s desktop computers purchased by the loan department manager last year.4. The portion of general advertising cost of the bank that has been allocated to the loan department.5. Revenue that the loan department would have generated for the bank if a branch loan office had been located downtown instead of in the next county.6. Difference in the…arrow_forwardAnswer the following: a. Give at least five examples of revenue from contracts to customer. b. What are the effect of unclassified accounts in the financial statements to the stakeholdersarrow_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 PubCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningSurvey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage Learning