Concept explainers
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:
Additional data concerning the usage of the activities by the various customers are also provided:
Required:
(Note: Round answers to two decimal places.)
- 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. Calculate a cost per account by customer category by using activity rates.
- 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. 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.
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:
Substitute $6,105,000 for total costs and 75,000 for number of statements used in the above formula.
Therefore, a cost per account per year is $81.40.
Use the following formula to calculate value of average fee per month:
Substitute $81.40 for costs per account per year in the above formula.
Therefore, average fee per month is $6.78.
2.
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:
Activity | Rate(R) | Quantity (Q) |
Low ($) |
Medium ($) |
High ($) |
(A)Opening and closing | 101 | 22,500 | 225,000 | ||
101 | 4,500 | 45,000 | |||
101 | 3,000 | 30,000 | |||
(B)Issuing monthly statements | 0.502 | 675,000 | 337,500 | ||
0.502 | 150,000 | 75,000 | |||
0.502 | 75,000 | 37,500 | |||
(C)Processing transactions | 0.103 | 27,000,000 | 2,700,000 | ||
0.103 | 3,000,000 | 300,000 | |||
0.103 | 750,000 | 75,000 | |||
(D)Customer inquiries | 0.204 | 1,500,000 | 300,000 | ||
0.204 | 900,000 | 180,000 | |||
0.204 | 600,000 | 120,000 | |||
(E)Providing ATM services | 0.705 | 2,025,000 | 1,417,500 | ||
0.705 | 300,000 | 210,000 | |||
0.705 | 75,000 | 67.500 | |||
Total Cost | 4,980,000 | 810,000 | 315,000 | ||
Number of accounts | 57,000 | 12,000 | 6,000 | ||
Cost per account | 87.37 | 67.50 | 52.50 |
Table (1)
Working Note:
1. Calculation of opening and closing rates:
2. Calculation of issuing monthly transactions rate:
3. Calculation of processing transaction rate:
4. Calculation of rate of customer inquiries:
5. Calculation of rate of providing ATM services:
3.
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:
Substitute $90.00 for interest revenue average and $81.40 for costs per account per year in the above formula.
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:
Substitute $80.00 for interest revenue average and $87.37 for costs per account per year in the above formula.
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:
Substitute $100.00 for interest revenue average and $67.50 for costs per account per year in the above formula.
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:
Substitute $165.00 for interest revenue average and $52.50 for costs per account per year in the above formula.
Therefore, the profit per account of high balance customers is $112.50.
4.
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?
Chapter 5 Solutions
Managerial Accounting: The Cornerstone of Business Decision-Making
- Thayne Company has 30 clerks that work in its Accounts Payable Department. A study revealed the following activities and the relative time demanded by each activity: Required: Classify the four activities as value-added or non-value-added, and calculate the clerical cost of each activity. For non-value-added activities, indicate why they are non-value-added.arrow_forwardUse the following information to answer the questions that follow. A. Calculate the operating income percentage for each of the stores. Comment on how your analysis has changed for each store. B. Perform a vertical analysis for each store. Based on your analysis, what accounts would you want to investigate further? How might management utilize this information? C. Which method of analysis (using a dollar value or percentage) is most relevant and/or useful? Explain.arrow_forwardActivity Bases for Service Department Charges For each of the following service departments, select the activity base listed that is most appropriate for charging service expenses to responsible units. Your answer should include the number of the activity base only. Activity bases to choose from: Number of conference attendees Number of computers Number of employees trained Number of cell phone minutes used Number of purchase requisitions Number of sales invoices Number of payroll checks Number of travel claims Service Department Activity Base a. Accounts Receivable fill in the blank 1 b. Central Purchasing fill in the blank 2 c. Computer Support fill in the blank 3 d. Conferences fill in the blank 4 e. Employee Travel fill in the blank 5 f. Payroll Accounting fill in the blank 6 g. Telecommunications fill in the blank 7 h. Training fill in the blank 8arrow_forward
- Tote bags are sold through agents who are paid a commission on each bag sold. For financial accountingpurposes, these commissions are classified as a(n) _____________________. In terms of costbehavior, commissions are classified as a(n)__________________ .arrow_forwardNational SavingsBank (NSB) is examining the profitability of its PremierAccount, a combined savings and checking account.NSB recently conducted an activity-based costing study of its services. It assessed the following costs for six individual services. The use of these services in2017 by three customers is as follows:Assume Lindenand Gonzalez always maintain a balance above $1,000, whereas Whitner always has a balance below $1,000. Depositors receive a 2% annual interest rate on their average deposit. NSB earns an interest rate spread of 3% (the difference between the rate at which it lends money and the rate it pays depositors) by lending money for home-loan purposes at 5%. Thus, NSB would gain $60 on the interest spread if a depositor had an average Premier Account balance of $2,000 in 2017 ($2,000 x 3% = $60). The Premier Account allows depositors unlimited use of services such as deposits, withdrawals, checking accounts, and foreign currency drafts.…arrow_forwardSuperior Company provided the following data for the year ended December 31 (all raw materials are used in production as direct materials): Selling expenses Purchases of raw materials $ 213,000 $ 260,000 Direct labor Administrative expenses Manufacturing overhead applied to work in process Actual manufacturing overhead cost $ 158,000 $ 370,000 $ 354,000 Inventory balances at the beginning and end of the year were as follows: Beginning $ 59,000 Ending $ 31,000 $ 25,000 Raw materials Work in process Finished goods ? $ 37,000 The total manufacturing costs added to production for the year were $670,000; the cost of goods available for sale totaled $720,000 the unadjusted cost of goods sold totaled $661,000; and the net operating income was $37,000. The company's underapplied or overapplied overhead is closed to Cost of Goods Sold. Required: Prepare schedules of cost of goods manufactured and cost of goods sold and an income statement. (Hint: Prepare the income statement and schedule of…arrow_forward
- Please help me with all answers thankuarrow_forwardcan you show work and show how to do it in excel?arrow_forwardRecord the cost of goods sold. (Round intermediary calculations to two decimal places. Round your final answer to the nearest whole dollar.) DEBIT/CREDIT AMOUNTS Accounts Moving-Weighted-Average Record the payment of operating expenses. Accounts DEBIT/CREDIT AMOUNTS Moving-Weighted-Average FIFO FIFOarrow_forward
- The Westfield branch of Security Home Bank submitted the following cost data for last year: Teller wages Assistant branch manager salary Branch manager salary Total Virtually all other costs of the branch-rent, depreciation, utilities, and so on-are organization-sustaining costs that cannot be meaningfully assigned to individual customer transactions such as depositing checks. In addition to the cost data above, the employees of the Westfield branch were interviewed concerning how their time was distributed last year across the activities included in the activity-based costing study. The results of those interviews appear below: Teller wages Assistant branch manager salary Branch manager salary $ 144,000 74,000 90,000 $ 308,000 Activity Opening accounts Processing deposits and withdrawals Processing other customer transactions Distribution of Resource Consumption Across Activities Processing Deposits and Withdrawals 75% 15% 0% Opening Accounts 4% 15% 4% Activity Cost Pool Opening…arrow_forwardDirections: Read the given sentences carefully. Select the best answer from the choices given below. Write your answer on the space provided before each item. Gains Purchases Sales Income Gross Profit Sales Discount Selling expenses Professional Fee Net Income Operating expenses Sales return Cost of Goods Sold Service Income 1. An example of service revenue. 2. The revenue generated from the sale of products. 3. It is computed by deducting the cost of sales from net sales. 4. It is used to describe revenue derived from the rendering of services. 5. A type of income derived from the other activities of the business. 6. The account used to report the acquisitions of merchandise for sale. 7. It represents the actual cost of inventories that the company was able to sell. 8. These are expenses that are directly related to the main purpose of a merchandising business 9. A contra-sales account that is used to report the amount of discount given to or taken by the customers. 10. It refers…arrow_forwardDirections: Read the given sentences carefully. Select the best answer from the choices given below. Write your answer on the space provided before each item. (1 point each) Gains Gross Profit Sales Discount Selling expenses Net Income Sales return Service Income Professional Fee Purchases Sales Income Operating expenses Cost of Goods Sold 1. An example of service revenue. 2. The revenue generated from the sale of products. 3. It is computed by deducting the cost of sales from net sales. 4. It is used to describe revenue derived from the rendering of services. 5. A type of income derived from the other activities of the business. 6. The account used to report the acquisitions of merchandise for sale.bnuo1o 7. It represents the actual cost of inventories that the company was able to sell. 8. These are expenses that are directly related to the main purpose of a merchandising business. boinag 9. A contra-sales account that is used to report the amount of discount given to or taken by the…arrow_forward
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningEssentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage Learning
- Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegePrinciples of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College