Total Bank Activities
Opening & closing accounts:	$ 300,000
Processing transactions	$ 3,075,000
ATM services	$ 1,680,000
Total cost:	$ 5,055,000
	Account Balance
	Low	Medium	High
# of accounts opened/closed	22,500	4,500	3,000
Transactions processed	27,000,000	3,000,000	750,000
# of ATM transactions	2,025,000	300,000	75,000
# of checking accounts	57,000	12,000	6,000
1. Create a table and calculate the activity rate for each activity: opening & closing accounts, processing transactions, and ATM services. (1.5 points)
Activity rates
	Total Activity	Total Cost	Activity Rate
Number of accounts openened/closed	$ 300,000	$ 300,000	1
Processing transactions	$ 3,075,000	$ 900,000.00	3.42
Number of ATM transactions	$ 2,400,000.00	$ 1,680,000	1.43
2. Now using the activity rates above, assign the costs to each of the customer categories for each activity and find the total cost per customer category. (6 points)
	Low Balance	Medium Balance	High Balance
Opening & closing accounts:	$ 22,500	$ 4,500	$ 3,000
Processing transactions	$ 92,250,000.00	$ 10,250,000.00	$ 2,562,500.00
ATM services	$ 2,892,857.14	$ 428,571.43	$ 107,142.86
Total Cost Per Category	$ 95,165,357	$ 10,683,071	$ 2,672,643
3. For each customer category, find the cost per account based on the total cost per account category and the # of checking accounts in that category. (1.5 points)
	Cost per Account
Low Balance
Medium Balance
High Balance
4. Based on your analysis above, what customer group should the bank work harder to make happy? Provide support/reasoning for your response. (2 points)