Activity based costing of customers for Sandy Sun Bank
Not what you're looking for?
Sandy Sun Bank and Trust (SSB&T) offers only checking accounts. Customers can write checks and use a network of ATM's. SSB&T earns revenue by investing the money deposited; currently it averages 5.2 percent annually on it's investments of those deposits. To compete with larger banks, the bank pays depositors .05% on all deposits. A recent study classified the banks annual operating costs into four activities.
Activity Cost Driver Cost Driver Volume
Using ATM--------------number of uses $750,000 10,000,000 uses
Visiting branch..........number of visits 2,250,000 750,000 visits
Processing transaction...number of transactions. 1,500,000 40,000,000 transactions
Managing functions........total deposits 3,000,000 $187,500,000 in deposits
TOTAL OVERHEAD $7,500,000
DATA ON TWO REPRESENTATIVE CUSTOMERS FOLLOWS:
Customer A Customer B
ATM uses......................................200 250
branch visits..................................5 20
Number of transactions................40 1,500
Average deposit..........................$200 $6,000
REQUIRED:
a. Compose SSB&T's operating profits.
b. Compute the profit from customer A and Customer B assuming that customer costs are based only on deposits. Interest costs=.05% of deposits; operating costs are 4% (=7,500,000/187,500,000) of deposits
c. Compute the profit from customer A and customer B assuming that customer costs are computed using the information in an activity based costing analysis.
d. How can SSB&T use the information from activity based costing analysis to manage it's costs?
e. What does SSB&T need to consider before implementing your suggestions from requirement d?
Purchase this Solution
Solution Summary
This solution provides a complete computation of the given accounting problem formatted in Excel.
Solution Preview
** Please see the attached file for the complete solution response **
Sandy Sun Bank and Trust (SSB&T) offers only checking accounts. Customers can write checks and use a network of ATM's. SSB&T earns revenue by investing the money deposited; currently it averages 5.2 percent annually on it's investments of those deposits. To compete with larger banks, the bank pays depositors .05% on all deposits. A recent study classified the banks annual operating costs into four activities.
Activity Cost Driver Cost Driver Volume
using atm--------------number of uses $750,000 10,000,000 uses
visiting branch..........number of visits 2,250,000 750,000 visits
processing transaction...number of transac. 1,500,000 40,000,000 trasnact
managing functions........total deposits 3,000,000 $187,500,000 in deposits
TOTAL OVERHEAD $7,500,000
DATA ON TWO ...
Purchase this Solution
Free BrainMass Quizzes
Understanding Management
This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.
Motivation
This tests some key elements of major motivation theories.
Transformational Leadership
This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.
Marketing Management Philosophies Quiz
A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.
Marketing Research and Forecasting
The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.