Managerial Accounting: The Cornerstone of Business Decision-Making
Managerial Accounting: The Cornerstone of Business Decision-Making
7th Edition
ISBN: 9781337115773
Author: Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher: Cengage Learning
bartleby

Concept explainers

bartleby

Videos

Textbook Question
Book Icon
Chapter 5, Problem 57P

Customers 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:

Chapter 5, Problem 57P, Customers as a Cost Object Morrisom National Bank has requested an analysis of checking account , example  1

Additional data concerning the usage of the activities by the various customers are also provided:

Chapter 5, Problem 57P, Customers as a Cost Object Morrisom National Bank has requested an analysis of checking account , example  2

Required:

(Note: Round answers to two decimal places.)

  1. 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. 2. Calculate a cost per account by customer category by using activity rates.
  3. 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. 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 president’s argument by using ABC.

1.

Expert Solution
Check Mark
To determine

Compute the value of costs per account per year. Also, compute the average fee per month that should be charged by the bank to cover their costs incurred in verifying the accounts.

Explanation of Solution

Activity Based Costing (ABC):

Activity based costing is an apportionment of costs that first considers the activity drivers that helps in the allocation of costs to various activities and then allocates costs to different cost objects by using the drivers.

Use the following formula to calculate value of costs per account per year:

Costs Per Account Per Year=Total CostsNumber Of Statements Used

Substitute $6,105,000 for total costs and 75,000 for number of statements used in the above formula.

Costs Per Account Per Year=$6,105,00075,000acoounts=$81.40

Therefore, a cost per account per year is $81.40.

Use the following formula to calculate value of average fee per month:

Average Fee Per Month=Costs Per Account Per Year12Months

Substitute $81.40 for costs per account per year in the above formula.

Average Fee Per Month=$81.4012Months=$6.78

Therefore, average fee per month is $6.78.

2.

Expert Solution
Check Mark
To determine

Compute the costs per account by customer category with the help of activity rates.

Explanation of Solution

Computation of costs per account by customer category:

ActivityRate(R)Quantity (Q)

Low

(R×Q)

($)

Medium

(R×Q)

($)

High

(R×Q)

($)

(A)Opening and closing10122,500225,000  
 1014,500 45,000 
 1013,000  30,000
(B)Issuing monthly statements0.502675,000337,500  
 0.502150,000 75,000 
 0.50275,000  37,500
(C)Processing transactions0.10327,000,0002,700,000  
 0.1033,000,000 300,000 
 0.103750,000  75,000
(D)Customer inquiries0.2041,500,000300,000  
 0.204900,000 180,000 
 0.204600,000  120,000
(E)Providing ATM services0.7052,025,0001,417,500  
 0.705300,000 210,000 
 0.70575,000  67.500

Total Cost

(A+B+C+D+E)

  4,980,000810,000315,000
Number of accounts  57,00012,0006,000

Cost per account

(Total CostsNumber Of Accounts)

  87.3767.5052.50

Table (1)

Working Note:

1. Calculation of opening and closing rates:

Opening And Closing Rate=Total Opening And Closing CostsNumber of Accounts opened=$300,00030,000accounts=$10per account

2. Calculation of issuing monthly transactions rate:

Issuing Monthly Transcations Rate=Total Issuing Monthly Transactions CostsNumber of Statements issued=$450,000900,000statements=$0.5per statement

3. Calculation of processing transaction rate:

Processing Transcations Rate=Total Processing Transactions CostsNumber of Transactions=$3,075,00030,750,000transactions=$0.10per transaction

4. Calculation of rate of customer inquiries:

Customer Inquiries Rate=Total Customer Inquiries CostsNumber of Customer Inquiries=$600,0003,000,000minutes=$0.20per minute

5. Calculation of rate of providing ATM services:

Providing ATM Services Rate=Total Providing ATM Services CostsNumber of ATM Transactions=$1,680,0002,400,000transactions=$0.70per transactions

3.

Expert Solution
Check Mark
To determine

Compute the average profit per account. Also, compute the profit per account with the help of ABC approach.

Explanation of Solution

Use the following formula to calculate average profit per account:

Average Profit=Interest Revenue AverageCosts Per Account Per Year

Substitute $90.00 for interest revenue average and $81.40 for costs per account per year in the above formula.

Average Profit=$90.00$81.40=$8.60

Therefore, an average profit per account is $8.60.

Use the following formula to calculate profit per account with the help of ABC approach of low balance customers:

Profit=Interest Revenue AverageCosts Per Account 

Substitute $80.00 for interest revenue average and $87.37 for costs per account per year in the above formula.

Profit=$80.00$87.37=$7.37

Therefore, the loss per account of low balance customers is $7.37.

Use the following formula to calculate profit per account with the help of ABC approach of medium balance customers:

Profit=Interest Revenue AverageCosts Per Account 

Substitute $100.00 for interest revenue average and $67.50 for costs per account per year in the above formula.

Profit=$100.00$67.50=$32.5

Therefore, the profit per account of medium balance customers is $32.5.

Use the following formula to calculate profit per account with the help of ABC approach of high balance customers:

Profit=Interest Revenue AverageCosts Per Account 

Substitute $165.00 for interest revenue average and $52.50 for costs per account per year in the above formula.

Profit=$165.00$52.50=$112.50

Therefore, the profit per account of high balance customers is $112.50.

4.

Expert Solution
Check Mark
To determine

Discuss the steps for verifying the argument of president with the help of ABC approach.

Explanation of Solution

The steps for verifying the argument of president with the help of ABC approach are explained below:

  • • Compute the value of profits from various loans provided by the organization to their customers such as credit card with the help of ABC approach.
  • • Compare the 50% of the profit of cross sales of the low balance customers with the total loss of low balance customers in verifying the accounts.
  • • At the end, if the amount of profit of cross sales are more than the loss of cross sales, argue of president is valid.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
Kindly give a step by step details explaination of each answers especially question 5 and 6. Please, don't just give answers without explaining how we arrived at the answer. Thanks! The following are the questions:      1. What is the general journal entries the transactions described for Hogan Company. All sales are on account. Use the date of December 31 to make the entry to summarize sales for the year in the old territory and new territory.      2. Make the journal entries to record the write-off of accounts in the new territory.      3. Make the journal entry to record the write-off of accounts in the old territory.      4. Make the entry on December 31 to record uncollectible accounts expense for 20X1 for both territories. Make the calculation using the percentages developed by Hogan.      5. Let’s say the Allowance for Doubtful Accounts had a credit balance of $24,800 on September 30 before any of the above entries were made. Calculate the balance in the allowance account after…
Financial accounting
General Accounting

Chapter 5 Solutions

Managerial Accounting: The Cornerstone of Business Decision-Making

Ch. 5 - Prob. 11DQCh. 5 - What are value-added activities? Value-added...Ch. 5 - What are nonvalue-added activities? Nonvalue-added...Ch. 5 - Identify and define four different ways to manage...Ch. 5 - Prob. 15DQCh. 5 - A batch-level driver is consumed by a product each...Ch. 5 - Which of the following is a nonunit-level driver?...Ch. 5 - Prob. 3MCQCh. 5 - Use the following information for Multiple-Choice...Ch. 5 - The first stage of ABC entails the assignment of...Ch. 5 - The second stage of ABC entails the assignment of...Ch. 5 - Interview questions are asked to determine a. what...Ch. 5 - Prob. 8MCQCh. 5 - Assume that the moving activity has an expected...Ch. 5 - Which of the following is a true statement about...Ch. 5 - Prob. 11MCQCh. 5 - This year, Lambert Company will ship 1,500,000...Ch. 5 - Prob. 13MCQCh. 5 - A forklift and its driver used for moving...Ch. 5 - Which of the following are nonvalue-added...Ch. 5 - Suppose that a company is spending 60,000 per year...Ch. 5 - Prob. 17MCQCh. 5 - Thom Company produces 60 units in 10 hours. The...Ch. 5 - Thom Company produces 60 units in 10 hours. The...Ch. 5 - Striving to produce the same activity output with...Ch. 5 - Use the following information for Brief Exercises...Ch. 5 - Use the following information for Brief Exercises...Ch. 5 - Calculating ABC Unit Costs Perkins National Bank...Ch. 5 - Assigning Costs to Activities McCourt Company...Ch. 5 - Activity-Based Customer Costing Sleepeze Company...Ch. 5 - Activity-Based Supplier Costing Clearsound uses...Ch. 5 - Prob. 27BEACh. 5 - Velocity and Cycle Time Kolby Company takes 36,000...Ch. 5 - Use the following information for Brief Exercises...Ch. 5 - Use the following information for Brief Exercises...Ch. 5 - Prob. 31BEBCh. 5 - Assigning Costs to Activities Craig Company...Ch. 5 - Activity-Based Customer Costing Limpio Company...Ch. 5 - Activity-Based Supplier Costing Blackburn Inc....Ch. 5 - Nonvalue-Added Costs Evans Inc. has the following...Ch. 5 - Velocity and Cycle Time Tara Company takes 8,000...Ch. 5 - Consumption Ratios; Activity Rates Saludable...Ch. 5 - Activity Rates Patten Company uses activity-based...Ch. 5 - Comparing ABC and Plantwide Overhead Cost...Ch. 5 - Activity-Based Product Costing Suppose that a...Ch. 5 - Assigning Costs to Activities, Resource Drivers...Ch. 5 - Activity-Based Customer-Driven Costs Suppose that...Ch. 5 - Activity-Based Supplier Costing Bowman Company...Ch. 5 - Use the following information for Exercises 5-44...Ch. 5 - Use the following information for Exercises 5-44...Ch. 5 - Use the following information for Exercises 5-44...Ch. 5 - Cycle Time and Velocity In the first quarter of...Ch. 5 - Product-Costing Accuracy, Consumption Ratios Plata...Ch. 5 - Product-Costing Accuracy, Consumption Ratios,...Ch. 5 - Formation of an Activity Dictionary A hospital is...Ch. 5 - Activity Rates and Activity-Based Product Costing...Ch. 5 - Value- and Nonvalue-Added Costs Waterfun...Ch. 5 - Functional-Based versus Activity-Based Costing For...Ch. 5 - Plantwide versus Departmental Rates,...Ch. 5 - Production-Based Costing versus Activity-Based...Ch. 5 - Prob. 56PCh. 5 - Customers as a Cost Object Morrisom National Bank...Ch. 5 - Grundvig Manufacturing produces several types of...Ch. 5 - Activity-Based Supplier Costing Levy Inc....Ch. 5 - Danna Martin, president of Mays Electronics, was...Ch. 5 - John Thomas, vice president of Mallett Company (a...Ch. 5 - Cycle Time, Velocity, Product Costing Goldman...Ch. 5 - Prob. 63CCh. 5 - Consider the following conversation between...
Knowledge Booster
Background pattern image
Accounting
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.
Recommended textbooks for you
Text book image
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Text book image
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Text book image
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Text book image
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
Text book image
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
Text book image
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Cost Accounting - Definition, Purpose, Types, How it Works?; Author: WallStreetMojo;https://www.youtube.com/watch?v=AwrwUf8vYEY;License: Standard YouTube License, CC-BY