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 | $20,100 | |
Adjusting claim | 140,700 | |
Paying claim | 40,200 | |
Total | $201,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 6,700 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 adjusted. It is estimated that 60% 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 5% to the "receiving claim" activity cost.
c. Prepare a table showing the changes in the activity costs as a result of the changes proposed by management. If an amount is zero, leave the entry box blank. Use the minus sign to indicate an additional cost in the last column.
Statewide Insurance Company | |||
Changes in the activity costs | |||
Activities | Activity Cost Prior to Improvement |
Activity Cost After Improvement |
Activity Cost Saving |
Receiving claim | $fill in the blank 1ff336fe1048010_1 | $fill in the blank 1ff336fe1048010_2 | $fill in the blank 1ff336fe1048010_3 |
Adjusting claim | fill in the blank 1ff336fe1048010_4 | fill in the blank 1ff336fe1048010_5 | fill in the blank 1ff336fe1048010_6 |
Paying claim | fill in the blank 1ff336fe1048010_7 | fill in the blank 1ff336fe1048010_8 | fill in the blank 1ff336fe1048010_9 |
Totals | $fill in the blank 1ff336fe1048010_10 | $fill in the blank 1ff336fe1048010_11 | $fill in the blank 1ff336fe1048010_12 |
d. Estimate the average cost per claim payment, assuming that the changes proposed by management are enacted for 6,700 total claims. Round to the nearest cent.
$fill in the blank 4d35bf07306df9b_1 per paid claim
Trending nowThis is a popular solution!
Step by stepSolved in 4 steps
- Woodstock Binding has two service departments, IT (Information Technology) and HR (Human Resources), and two operating departments, Publishing and Binding. Management has decided to allocate IT costs on the basis of IT Tickets (issued with each IT request) in each department and HR costs on the basis of employees in each department. The following data appear in the company records for the current period: IT HR IT tickets 0 Employees 18 1,555 0 Publishing 2,488 27 Binding 2,177 45 Department direct costs $ 154,400 $ 248,490 $ 432,200 $ 395,500 Required: Allocate the service department costs using the reciprocal method. (Matrix algebra is not required because there are only two service departments.) Note: Amounts to be deducted should be indicated by a minus sign. Do not round intermediate calculations. From: Service department costs IT HR Total Cost Allocation To: IT HR Publishing Bindingarrow_forwardes Comprehensive Insurance Company has two product lines: health insurance and auto insurance. The two product lines are served by three operating departments, which are necessary for providing the two types of products: claims processing, administration, and sales. These three operating departments are supported by two departments: information technology and operations. The support provided by information technology and operations to the other departments is shown below. Operating Departments Information technology Operations The total costs incurred in the five departments are: Information technology Operations Claims processing Administration Sales C. Total costs a. Direct Method b. Support Departments Information Technology Operations 20% Step Method (Info Tech First) Step Method (Operations First) Reciprocal Method 10% $ 577,000 1,530,000 350,000 627,000 550,000 $ 3,634,000 Required: Determine the total costs in each of the three operating departments, after departmental…arrow_forwardSubject: Accountingarrow_forward
- Describe the staffing competencies needed for hiring team members in the back-end revenue cycle of a healthcare organizationarrow_forwardLily Accounting performs two types of services, Audit and Tax. Lily's estimated overhead costs consist of computer support, $312000; and legal support, $153000. Information on the two services and their estimated use of cost drivers is as follows: Direct labor cost CPU minutes Legal hours used Audit Tax $50000 $100000 O $3744 O $5097 O $5544 O $3897 40000 200 10000 800 Lily Accounting performs tax services for Cathy Lane. Direct labor cost is $1200, 600 CPU minutes were used; and 1 legal hour was used. What is the total cost of the Lane job using ABC?arrow_forwardComprehensive Insurance Company has three operating departments: claims processing, administration, and sales. These three operating departments are supported by two service departments: information technology and accounting. The support provided by information technology and accounting to the other departments is shown below. Information technology Accounting The total costs incurred in the five departments are: Information technology Accounting Claims processing Administration Sales Total costs a. Direct Method b. Step Method (Info Tech First) Step Method (Accounting First) c. Reciprocal Method Service Departments Information Technology $ 560,000 1,730,000 250,000 599,000 650.000 $ 3,789,000 10% Required: Determine the total costs in each of the three operating departments, after departmental allocations, using (a) the direct method, (b) the step method (first for information technology going first in the allocation and then for accounting going first), and (c) the reciprocal method.…arrow_forward
- The following represents the aging of contributions receivable for McKenzie Health Foundation for the historical years ended June 30, 2020, 2019, 2018, 2017, 2016, and 2015. Contributions receivable vary significantly by year; however, contribution revenue has been fairly stable over the five-year period. Fiscal Year-End 6/30/2020 6/30/2019 6/30/2018 6/30/2017 6/30/2016 6/30/2015 Total contributions receivable $1,003,900 $1,225,650 $913,550 $1,907,700 $625,800 $483,750 Allowance for uncollectible contributions 31,689 40,100 29,327 68,870 21,903 19,530 Total contribution revenue 20,066,850 20,960,895 19,094,525 21,011,340 20,879,860 20,571,300 Aging of contributions receivable 0–30 days $546,000 $394,800 $457,800 $1,547,700 $625,800 $456,750 31–60 days 23,400 383,400 261,000 360,000 0 27,000 61–90 days 389,500 447,450 194,750 0 0 0 >90 days 45,000 0 0 0 0 0 $1,003,900 $1,225,650 $913,550 $1,907,700 $625,800 $483,750 a) Prepare a report…arrow_forwardPlease assist with Req C (Reciprocal Method) Please be as detailed as possible when showing work.arrow_forwardHelping tags: Accounting, Intermediate Accounting . . . WILL UPVOTE, just pls help me answer it and show complete solutions. Thank you!arrow_forward
- Regling Company provides its employees vacation benefits and a defined benefit pension plan. Employees earned vacation pay of $20,000 for the period. The pension formula determined a pension cost of $232,000. Only $13,920 was contributed to the pension plan administrator. Question Content Area a. Journalize the entry to record the vacation pay. If an amount box does not require an entry, leave it blank. blank Account Debit Credit blank Feedback Area Feedback Question Content Area b. Journalize the entry to record the pension benefit. If an amount box does not require an entry, leave it blank. blank Account Debit Credit blankarrow_forwardWhich of the following is true about plan assets? Any excess return on plan assets are earned to the benefit of the company Includes qualifying insurance policies None of the statements are correct These are assets held for short-term purpose in the event of employee retirement during the yeararrow_forward4 In accounting for construction contracts using the percentage of completion method, the gross profit recognized during the year would be the estimated gross profit multiplied by the percentage of the costs incurred to date to the : Group of answer choices Total estimated cost Total contract price Total cost incurred to date Unbilled portion of the contract pricearrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education