Stillwater State Bank has requested an analysis of checking account profitability by customer...

50.1K

Verified Solution

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,0003,0002,000
Number of statements issued 450,000100,00050,000
Processing transactions 18,000,0002,000,000500,000
Number of telephone minutes 1,000,000600,000400,000
Number of ATM transactions 1,350,000200,00050,000
Number of checking accounts 38,0008,0004,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!
Become a Member

Other questions asked by students