Please help me solve all the requirements, based on the given information and blank answer slots:

Requirement 1. Compute the 2020 profitability of the Harvin, Stanback, and Grant Premier Accounts at UIB. (For amounts with a $0 balance, make sure to enter "0" in the appropriate cell. Round your answers to the nearest cent Use parentheses or a minus sign for operating losses.) Deposit/withdrawal on prearranged basis Bank checks written Foreign currency drafts Inquiries Total costs Operating income (loss) Depositors receive a 2% annual interest rate on their average deposit. UIB earns an interest rate spread of 3% (the difference between the rate at which it lends money and the rate it pays depositors) by lending money for home-loan purposes at 5%. Thus, UIB would gain $60 on the interest spread if a depositor had an average Premier Account balance of $2,000 in 2020($2,0003%=$60). The Premier Account allows depositors unlimited use of services such as deposits, withdrawals, checking accounts, and foreign currency drafts. Depositors with Premier Account balances of $1,000 or more receive unlimited free use of services. Depositors with minimum balances of less than $1,000 pay a $20-a-month service fee for their Premier Account. United International Bank (UIB) is examining the profitability of its Premier Account, a combined savings and checking account. (Click the icon to view account information.) UIB recently conducted an activity-based costing study of its services. It assessed the following costs for six individual services. The use of these services in 2020 by three customers is as follows: (Click the icon to view the costs for the services and customer information.) Assume Harvin and Grant always maintain a balance above $1,000, whereas Stanback always has a balance below $1,000. Daiances more orten tnan UID 1. Competition likely would "understand" that high-balance low-actvity type accounts are highly prottable. Utterng free services to these customers likely to retain these accounts if other banks offer higher interest rates. Competition likely will the interest rate spread UIB can earn on the high-balance low-activity accounts they are able to retain. Requirement 3. What changes would you recommend for UIB's Premier Account? Possible changes UIB could make are: a. Offer interest rates on accounts to increase UIB's competitiveness in attracting and retaining these accounts. b. In determining its pricing strategy, UIB need to consider how other competing banks are pricing their products and services. \begin{tabular}{|c|c|c|c|c|} \hline \multirow[b]{3}{*}{ Deposit/withdrawal with teller } & \multirow{2}{*}{\begin{tabular}{l} Activity-Based \\ Cost per \\ "Transaction" \end{tabular}} & \multicolumn{3}{|c|}{ Account Usage } \\ \hline & & Harvin s & Stanback & Grant \\ \hline & 2.60 & 43 & 51 & 6 \\ \hline Deposit/withdrawal with automatic teller machine (ATM) & 0.70 & 11 & 18 & 17 \\ \hline Deposit/withdrawal on prearranged monthly basis & 0.40 & 0 & 10 & 61 \\ \hline Bank checks written & 7.90 & 7 & 1 & 3 \\ \hline Foreign currency drafts & 11.90 & 5 & 2 & 8 \\ \hline Inquiries about account balance & 1.40 & 11 & 16 & 10 \\ \hline Average Premier Account balance for 2020 & & $1,125$ & 925$ & 25,200 \\ \hline \end{tabular} Requirement 2. Why might UIB worry about the profitability of individual customers if the Premier Account product offering is profitable as a whole? across individual Premier Accounts occur when profits made on some accounts are The account is highly profitable, while the account is sizably unprofitable. The It is unlikely that account shows a small profit but only because of the will keep paying these high fees and that UIB would want them to pay such high fees from a customer relationship standpoint. The facts also suggest that the customers the bank services uniformly. For example, have a lot of transactions with the teller or ATM, and also inquire about their account balances more often than UIB . Competition likely would "understand" that high-balance low-activity type accounts are highly profitable. Offering free services to these silstnmers likely tn retain these ac.nounts if nther hanks nffer hirher interest rates C.nmnetitinn likelv/ 1. Compute the 2020 profitability of the Harvin, Stanback, and Grant Premier Accounts at UIB. 2. Why might UIB worry about the profitability of individual customers if the Premier Account product offering is profitable as a whole? 3. What changes would you recommend for UIB's Premier Account