Question
Stillwater State Bank has requested an analysis of checking account profitability by customer type. Customers are categorized according to the size of their account: low
Stillwater State 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:
Opening and closing statements | $400,000 |
Issuing monthly statements | $600,000 |
Processing transactions | $4,100,000 |
Customer inquiries | $800,000 |
Providing ATM services | $2,240,000 |
Total cost | $8,140,000 |
Additional data concerning the usage of the activities by the various customers are also provided:
Account Balance | Low | Medium | High | |||
Number of accounts opened/closed | 15,000 | 3,000 | 2,000 | |||
Number of statements issued | 450,000 | 100,000 | 50,000 | |||
Processing transactions | 18,000,000 | 2,000,000 | 500,000 | |||
Number of telephone minutes | 1,000,000 | 600,000 | 400,000 | |||
Number of ATM transactions | 1,350,000 | 200,000 | 50,000 | |||
Number of checking accounts | 38,000 | 8,000 | 4,000 |
Stillwater State Bank uses an activity-based costing system. The activity rate for opening and closing statements is based on the number of accounts opened and closed. The activity rate for issuing monthly statements is based on the number of statements issued. The activity rate for processing transactions is based on the number of transactions processed. The activity rate for customer inquiries is based on the number of telephone minutes. The rate for ATM services is based on the number of ATM transactions.
Stillwater State Bank offers free checking to all its customers. The interest revenues earned per account are $190, $230, and $360 for the low-, medium-, and high-balance accounts, respectively.
Required:
If required, round your answers to the nearest cent. When required, use rounded amounts in subsequent computations.
Complete the following:
A. The activity rate for opening and closing accounts is $fill in the blank 1 per account transaction.
B. The activity rate for issuing monthly statements is $fill in the blank 2 per statement issued.
C. The activity rate for processing transactions is $fill in the blank 3 per transaction processed.
D. The activity rate for customer inquiries is $fill in the blank 4 per inquiry.
E. The activity rate for providing ATM services is $fill in the blank 5 per ATM transaction.
F. Using the five activity rates, the cost per account for the low-balance customer category is $fill in the blank 6.
G. Using the five activity rates, the cost per account for the medium-balance customer category is $fill in the blank 7.
H. Using the five activity rates, the cost per account for the high-balance customer category is $fill in the blank 8.
Refer to parts F through H for the cost per account by customer category.
I. The activity-based profit per account for the low-balance customers is $fill in the blank 9.
J. The activity-based profit per account for the medium-balance customers is $fill in the blank 10.
K. The activity-based profit per account for the high-balance customers is $fill in the blank 11.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started