Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions