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 Activity Capacity 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.   Activity Rates Providing ATM service $ per transaction Computer processing $ per transaction Issuing statements $ per statement Customer inquiries $ per minute   2. Using the rates computed in Requirement 1, calculate the cost of each product. Round your answers to the nearest cent.   Unit Cost Checking Accounts $ Personal Loans $ Gold VISA $   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 $

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

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 Activity
Capacity
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.

  Activity Rates
Providing ATM service $ per transaction
Computer processing $ per transaction
Issuing statements $ per statement
Customer inquiries $ per minute

 

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

  Unit Cost
Checking Accounts $
Personal Loans $
Gold VISA $

 

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 $
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 4 images

Blurred answer
Knowledge Booster
Domestic transfer pricing
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education