Question

Process Activity Analysis for a Service Company Columbia Insurance Company has a process for making payments...

Process Activity Analysis for a Service Company

Columbia 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 $40,200
Adjusting claim 120,600
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 70% 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.

a. Develop a table showing the percent of individual activity cost to the total process cost. Round the percents to the nearest whole number, if required.

Columbia Insurance Company
Individual activity cost to the total process cost
Activity Cost Percent of Total Process
Receiving claim $ %
Adjusting claim %
Paying claim %
Total $ %

b. Determine the average total process cost per claim payment, assuming 6,700 total claims. Round to the nearest whole dollar.
$ per paid claim

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.

Columbia Insurance Company
Changes in the activity costs
Activity Activity Cost Prior to Improvement Activity Cost After Improvement Activity Cost Savings (Cost)
Receiving claim $ $ $
Adjusting claim
Paying claim
Total $ $ $

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.
$ per paid claim

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Process Activity Analysis for a Service Company Statewide Insurance Company has a process for making payments...
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 $30,400 Adjusting claim 212,800 Paying claim 60,800 Total $304,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...
Process Activity Analysis The Brite Beverage Company bottles soft drinks into aluminum cans. The manufacturing process...
Process Activity Analysis The Brite Beverage Company bottles soft drinks into aluminum cans. The manufacturing process consists of three activities: Mixing: water, sugar, and beverage concentrate are mixed. Filling: mixed beverage is filled into 12-oz. cans. Packaging: properly filled cans are boxed into cardboard "fridge packs". The activity costs associated with these activities for the period are as follows: Mixing $267,000 Filling 237,000 Packaging 96,000 Total $600,000 The activity costs do not include materials costs, which are ignored for this...
Process Activity Analysis The Brite Beverage Company bottles soft drinks into aluminum cans. The manufacturing process...
Process Activity Analysis The Brite Beverage Company bottles soft drinks into aluminum cans. The manufacturing process consists of three activities: Mixing: water, sugar, and beverage concentrate are mixed. Filling: mixed beverage is filled into 12-oz. cans. Packaging: properly filled cans are boxed into cardboard “fridge packs.” The activity costs associated with these activities for the period are as follows: Mixing $257,000 Filling 227,000 Packaging 66,000 Total $550,000 The activity costs do not include materials costs, which are ignored for this...
Van Frank Telecommunications has a patent on a cellular transmission process. The company has amortized the...
Van Frank Telecommunications has a patent on a cellular transmission process. The company has amortized the $27.00 million cost of the patent on a straight-line basis since it was acquired at the beginning of 2014. Due to rapid technological advances in the industry, management decided that the patent would benefit the company over a total of six years rather than the nine-year life being used to amortize its cost. The decision was made at the end of 2018 (before adjusting...
Blue Co. has a patent on a communication process. The company has amortized the patent on...
Blue Co. has a patent on a communication process. The company has amortized the patent on a straight-line basis since 2014, when it was acquired at a cost of $56 million at the beginning of that year. Due to rapid technological advances in the industry, management decided that the patent would benefit the company over a total of six years rather than the nine-year life being used to amortize its cost. The decision was made at the end of 2018...
Blue Co. has a patent on a communication process. The company has amortized the patent on...
Blue Co. has a patent on a communication process. The company has amortized the patent on a straight-line basis since 2017 when it was acquired at a cost of $55 million at the beginning of the year. Due to rapid technological advances in the industry, management decided that the patent would benefit the company over a total of six years rather than the nine-year life being used to amortize its cost. The decision was made at the end of 2021...
Magenta Company has identified seven activities as part of its manufacturing process and chosen corresponding activity...
Magenta Company has identified seven activities as part of its manufacturing process and chosen corresponding activity drivers for each activity. The chart below lists the total cost of each activity, the proportion of activity driver used for each of Magenta’s two products, and the activity cost assigned to each product. Fill in the blanks below: (Round your answers to the nearest whole number.) Proportion Used By Activity Cost Activity Driver Prod. 1 Prod. 2 Activity Cost:Prod. 1 Activity Cost:Prod. 2...
Van Frank Telecommunications has a patent on a cellular transmission process. The company has amortized the...
Van Frank Telecommunications has a patent on a cellular transmission process. The company has amortized the $27.00 million cost of the patent on a straight-line basis since it was acquired at the beginning of 2017. Due to rapid technological advances in the industry, management decided that the patent would benefit the company over a total of six years rather than the nine-year life being used to amortize its cost. The decision was made at the end of 2021 (before adjusting...
P4-33. Applications of Differential Analysis Adventure Expeditions offers guided back-country hiking/camping trips in British Columbia. Adven-...
P4-33. Applications of Differential Analysis Adventure Expeditions offers guided back-country hiking/camping trips in British Columbia. Adven- ture provides a guide and all necessary food and equipment at a fee of $50 per person per day. Adven- ture currently provides an average of 600 guide-days per month in June, July, August, and September. Based on available equipment and staff, maximum capacity is 800 guide-days per month. Monthly variable and fixed operating costs (valued in Canadian dollars) are as follows: Variable Costs...
*Waterways Continuing Problem-10 Waterways Corporation has recently acquired a small manufacturing operation in British Columbia that...
*Waterways Continuing Problem-10 Waterways Corporation has recently acquired a small manufacturing operation in British Columbia that produces one of its more popular items. This plant will provide these units for resale in retail hardware stores in British Columbia and Alberta. Because the budget prepared by the plant was incomplete, Jordan Leigh, Waterways’ CFO, was sent to B.C. to oversee the plant’s budgeting process for the second quarter of 2017. Jordan asked the various managers to collect the following information for...