Managerial Accounting
15th Edition
ISBN: 9781337912020
Author: Carl Warren, Ph.d. Cma William B. Tayler
Publisher: South-Western College Pub
expand_more
expand_more
format_list_bulleted
Question
Chapter 13, Problem 20E
a)
To determine
Develop a table showing percentage of individual activity cost to total
b)
To determine
Calculate the
c)
To determine
Prepare a table showing changes in the activity cost due to the proposed improvements which also shows the changes before improvement of activity cost.
d)
To determine
Determine the average total process cost per claim.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
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 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 be…
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…
Process 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…
Chapter 13 Solutions
Managerial Accounting
Ch. 13 - What is the benefit of the lean philosophy?Ch. 13 - Prob. 2DQCh. 13 - Prob. 3DQCh. 13 - Prob. 4DQCh. 13 - Prob. 5DQCh. 13 - Why would a lean manufacturer strive to produce...Ch. 13 - Prob. 7DQCh. 13 - Prob. 8DQCh. 13 - Prob. 9DQCh. 13 - Prob. 10DQ
Ch. 13 - Prob. 11DQCh. 13 - Prob. 12DQCh. 13 - Prob. 13DQCh. 13 - Prob. 1BECh. 13 - Prob. 2BECh. 13 - Prob. 3BECh. 13 - Prob. 4BECh. 13 - Prob. 5BECh. 13 - Prob. 1ECh. 13 - Prob. 2ECh. 13 - Lean principles Rag Swag Inc. manufactures various...Ch. 13 - Prob. 4ECh. 13 - Reduce setup time Vernon Inc. has analyzed the...Ch. 13 - Compute lead time Jackson Fabricators Inc....Ch. 13 - Calculate lead time Williams Optical Inc. is...Ch. 13 - Prob. 8ECh. 13 - Prob. 9ECh. 13 - Prob. 10ECh. 13 - Prob. 11ECh. 13 - Prob. 12ECh. 13 - Lean accounting Modern Lighting Inc. manufactures...Ch. 13 - Prob. 14ECh. 13 - Prob. 15ECh. 13 - Prob. 16ECh. 13 - Prob. 17ECh. 13 - Prob. 18ECh. 13 - Process activity analysis The Brite Beverage...Ch. 13 - Prob. 20ECh. 13 - Prob. 21ECh. 13 - Lean principles Bright Night, Inc., manufactures...Ch. 13 - Prob. 2PACh. 13 - Lean accounting Dashboard Inc. manufactures and...Ch. 13 - Pareto chart and cost of quality report for a...Ch. 13 - Prob. 1PBCh. 13 - Lead time Master Chef Appliance Company...Ch. 13 - Lean accounting Com-Tel Inc. manufactures and...Ch. 13 - Pareto chart and cost of quality report for a...Ch. 13 - Prob. 1MADCh. 13 - Prob. 2MADCh. 13 - Prob. 3MADCh. 13 - Prob. 4MADCh. 13 - Ethics in Action In August, Lannister Company...Ch. 13 - Prob. 3TIFCh. 13 - Prob. 1CMACh. 13 - Prob. 2CMACh. 13 - In measuring the cost of quality, which one of the...Ch. 13 - Prob. 4CMA
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- 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_forwardThe 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_forwardBounce 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_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_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_forwardJewel-Osco evaluated three different pay-by-touch systems that identify a customer by a finger scan and automatically deduct the amount of the bill directly from their checking account. The revenue alternatives were ranked according to increasing initial investment and identified as alternatives A, B, and C. Comparison i*, % Δi*, % A to DN 23.4 B to DN 8.1 C to DN 16.6 B vs. A −5.1 C vs. A 12.0 C vs. B 83.9 Based on the alternative ROR values (i*), the incremental ROR values (Δi*), and the company’s MARR of 16% per year, the alternative to select is: (a) A (b) B (c) C (d) DNarrow_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_forwardSemona Bank would like to determine the price to charge for customer services and which classes of customers should be emphasized or de-emphasized. It has provided details of the activities and the cost drivers relating to those expenses that can be attributed to customers as follows: Activity Activity costs (R) Activity driver Activity volume Providing ATM services 400 000 Number of transactions 200 000 Computer processing 1 300 000 Number of transactions 2 500 000 Issuing Statements 1 100 000 Number of statements 500 000 Collections 160 000 Number of transactions 100 000 Customer inquiries 660 000 Telephone minutes 600 000 The following are annual information on the four types of customers: Personal Loans Cheque accounts Platinum accounts Savings accounts Number of product 7 000 28 000 12 000 2 000 ATM transactions 0 160 000 18 000 20 000 Computer transactions 210 000…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_forward
- Johnson 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_forwardABC Bank would like to determine the price to charge for customer services and which classes of customers should be emphasized or de-emphasized. It has provided details of the activities and the cost drivers relating to those expenses that can be attributed to customers as follows: Activity Activity costs (R) Activity driver Activity volume Providing ATM services 400 000 Number of transactions 200 000 Computer processing 1 300 000 Number of transactions 2 500 000 Issuing Statements 1 100 000 Number of statements 500 000 Collections 160 000 Number of transactions 100 000 Customer inquiries 660 000 Telephone minutes 600 000 The following are annual information on the four types of customers: Personal Loans Cheque accounts Platinum accounts Savings accounts Number of product 7 000 28 000 12 000 2 000 ATM transactions 0 160 000 18 000 20 000 Computer transactions 210 000…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_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubFinancial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher: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 Learning
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningFinancial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning
Essentials of Business Analytics (MindTap Course ...
Statistics
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning
alue Chain Analysis EXPLAINED | B2U | Business To You; Author: Business To You;https://www.youtube.com/watch?v=SI5lYaZaUlg;License: Standard Youtube License