Bloomington State Bank is analyzing checking account profitability by customer type (this indicates that customers are a cost object). Customers are categorized according to the size of their account: low balances, medium balances, and high balances. The activities associated with the three different categories and the associated annual costs for all bank activities are as follows: Total Bank Activities Opening & closing accounts: $ 300,000 Issuing monthly statements: $ 450,000 Processing transactions $ 3,075,000 Customer inquiries (via phone) $ 600,000 ATM services $ 1,680,000 Total cost: $ 6,105,000 # of accounts opened/closed # of statements issued Transactions processed # of telephone minutes # of ATM transactions # of checking accounts Account Balance Low Medium High 22,500 4,500 3,000 675,000 150,000 75,000 27,000,000 3,000,000 750,000 1,500,000 900,000 600,000 2,025,000 300,000 75,000 57,000 12,000 6,000 1. Calculate the activity rate for each activity below. Must use a formula/calculation in the cell for full credit. (5 points) Activity Rate #of accounts opened/closed # of statements issued Transactions processed # of telephone minutes # of ATM transactions