Question

# Problem 4.33 Activity-Based Costing: Service Firm

Glencoe First National Bank operated for years under the assumption that profitability can be increased by increasing dollar volumes. Historically, First National's efforts were directed toward increasing total dollars of sales and total dollars of account balances. In recent years, however, First National's profits have been eroding. Increased competition, particularly from savings and loan institutions, was the cause of the difficulties. As key managers discussed the bank's problems, it became apparent that they had no idea what their products were costing. Upon reflection, they realized that they had often made decisions to offer a new product which promised to increase dollar balances without any consideration of what it cost to provide the service.

After some discussion, the bank decided to hire a consultant to compute the costs of three products: checking accounts, personal loans, and the gold VISA. The consultant identified the following activities, costs, and activity drivers (annual data):

 Activity Activity Cost Activity Driver ActivityCapacity Providing ATM service \$ 100,000 No. of transactions 200,000 Computer processing 1,000,000 No. of transactions 2,500,000 Issuing statements 800,000 No. of statements 500,000 Customer inquiries 360,000 Telephone minutes 600,000

The following annual information on the three products was also made available:

 Checking Accounts Personal Loans Gold VISA Units of product 30,000 5,000 10,000 ATM transactions 180,000 0 20,000 Computer transactions 2,000,000 200,000 300,000 Number of statements 300,000 50,000 150,000 Telephone minutes 350,000 90,000 160,000

In light of the new cost information, Larry Roberts, the bank president, wanted to know whether a decision made two years ago to modify the bank's checking account product was sound. At that time, the service charge was eliminated on accounts with an average annual balance greater than \$1,000. Based on increases in the total dollars in checking, Larry was pleased with the new product. The checking account product is described as follows: (1) Checking account balances greater than \$500 earn interest of 2 percent per year, and (2) A service charge of \$5 per month is charged for balances less than \$1,000. The bank earns 4 percent on checking account deposits. Fifty percent of the accounts are less than \$500 and have an average balance of \$400 per account. Ten percent of the accounts are between \$500 and \$1,000 and average \$750 per account. Twenty-five percent of the accounts are between \$1,000 and \$2,767; the average balance is \$2,000. The remaining accounts carry a balance greater than \$2,767. The average balance for these accounts is \$5,000. Research indicates that the \$2,000 category was by far the greatest contributor to the increase in dollar volume when the checking account product was modified two years ago.

Required:

1. Calculate rates for each activity. Round your answers to the nearest cent.

2. Using the rates computed in Requirement 1, calculate the cost of each product. Round your answers to the nearest cent.

3. Compute the average annual profitability per account for the four categories of accounts described in the problem. In your computations, use the activity charges computed in Requirement 2. Round your answers to the nearest cent. If an answer is a loss, use a minus (-) sign to indicate.

 Average Balance Profit Per Account \$400 \$ \$750 \$ \$2,000 \$ \$5,000 \$

Calculate the break-even point for the checking account product. Break-even analysis for the unprofitable categories may be helpful. Round interim calculations to two decimal places, and final answer to the nearest dollar.

 Break-even point \$

We need at least 6 more requests to produce the answer.

4 / 10 have requested this problem solution

The more requests, the faster the answer.

All students who have requested the answer will be notified once they are available.

#### Earn Coins

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
• ### The First Chicago Bank is reviewing its service charges and interest-paying policies on checking accounts. The...

The First Chicago Bank is reviewing its service charges and interest-paying policies on checking accounts. The daily balance of a checking account is defined to be the balance in the checking account at 2:00pm. The bank has found that for all personal checking accounts the mean of all the daily balances is \$750 and the standard deviation is \$150. In addition, the distribution of personal checking account daily balances can be approximated very well with a normal model. Question 1....

• ### 1. Activity-Based Costing for a Service Business Sterling Hotel uses activity-based costing to determine the cost...

1. Activity-Based Costing for a Service Business Sterling Hotel uses activity-based costing to determine the cost of servicing customers. There are three activity pools: guest check-in, room cleaning, and meal service. The activity rates associated with each activity pool are \$8.70 per guest check-in, \$22.00 per room cleaning, and \$2.00 per served meal (not including food). Tara Stone visited the hotel for a 5-night stay. Tara had 4 meals in the hotel during the visit. Determine the total activity-based cost...

• ### Activity-Based Costing for a Service Company Crosswinds Hospital plans to use activity-based costing to assign hospital...

Activity-Based Costing for a Service Company Crosswinds Hospital plans to use activity-based costing to assign hospital indirect costs to the care of patients. The hospital has identified the following activities and activity rates for the hospital indirect costs: Activity Activity Rate Room and meals \$281 per day Radiology \$396 per image Pharmacy \$49 per physician order Chemistry lab \$71 per test Operating room \$960 per operating room hour The activity usage information associated with the two patients is as follows:...

• ### Activity-Based Costing for a Service Business Sterling Hotel uses activity-based costing to determine the cost of...

Activity-Based Costing for a Service Business Sterling Hotel uses activity-based costing to determine the cost of servicing customers. There are three activity pools: guest check-in, room cleaning, and meal service. The activity rates associated with each activity pool are \$8.50 per guest check-in, \$22.00 per room cleaning, and \$4.00 per served meal (not including food). Tara Washington visited the hotel for a 3-night stay. Tara had 4 meals in the hotel during the visit. Determine the total activity-based cost for...

• ### Activity-Based Costing for a Service Business Sterling Hotel uses activity-based costing to determine the cost of...

Activity-Based Costing for a Service Business Sterling Hotel uses activity-based costing to determine the cost of servicing customers. There are three activity pools: guest check-in, room cleaning, and meal service. The activity rates associated with each activity pool are \$8.60 per guest check-in, \$16.00 per room cleaning, and \$2.00 per served meal (not including food). Tara Campbell visited the hotel for a 6-night stay. Tara had 6 meals in the hotel during the visit. Determine the total activity-based cost for...

please help Activity-Based Costing for a Service Business Sterling Hotel uses activity-based costing to determine the cost of servicing customers. There are three activity pools: guest check-in, room cleaning, and meal service. The activity rates associated with each activity pool are \$8.10 per guest check-in, \$22.00 per room cleaning, and \$5.00 per served meal (not including food). Brian Campbell visited the hotel for a 4-night stay. Brian had 7 meals in the hotel during the visit. Determine the total activity-based...

• ### 17. The Barminster Bank is reviewing its service charges and interest paying policies on current accounts....

17. The Barminster Bank is reviewing its service charges and interest paying policies on current accounts. The bank has found that the average daily balance is normally distributed with a mean of £580 and a standard deviation of £140. a. What percentage of current account customers carry average balances in excess of £800? b. What percentage of current account customers carry average daily balances between £300 and £700? c. The bank is considering paying interest to customers carrying average daily...

• ### ctivity-Based Costing, Activity Identification, Activity Dictionary Golding Bank is in the process of implementing an activity-based...

ctivity-Based Costing, Activity Identification, Activity Dictionary Golding Bank is in the process of implementing an activity-based costing system. A copy of an interview with the manager of Golding's Credit Card Department follows. QUESTION 1: How many employees are in your department? RESPONSE: There are eight employees, including me. QUESTION 2: What do they do (please describe)? RESPONSE: There are four major activities: supervising employees, processing credit card transactions, issuing customer statements, and answering customer questions. QUESTION 3: Do customers outside...

• ### Simplifying the ABC System: TDABC Golding Bank provided the following data about its resources and activities...

Simplifying the ABC System: TDABC Golding Bank provided the following data about its resources and activities for its checking account process: Resources Activities Time per Unit Activity Driver Supervision Phone and supplies \$70,000 90,000 Processing accounts Issuing statements 0.20 hr. No. of accounts 0.10 hr No. of statements Salaries 275,000 Processing transactions 0.05 hr. No. of transactions Computer 25,000 Answering customer inquiries 0.15 hr. No. of inquiries Total \$460,000 Total check processing hours 25,000 (practical capacity) Required: 1. Calculate the...

• ### Activity-Based Costing Zeus Industries manufactures two types of electrical power units, custom and standard, which involve...

Activity-Based Costing Zeus Industries manufactures two types of electrical power units, custom and standard, which involve four factory overhead activities-production setup, procurement, quality control, and materials management. An activity analysis of the overhead revealed the following estimated activity costs and activity bases for these activities: Activity Activity Cost Production setup Procurement \$ 58,500 136,500 182,000 200,000 Activity Base Number of setups Number of purchase orders (PO) Number of inspections Number of components Quality control Materials management Total \$577,000 The activity-base...