Stillwater State Bank has requested an analysis of checking account profitability by customer type. Customers...
50.1K
Verified Solution
Link Copied!
Question
Accounting
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.
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!