QUESTION IS ON THE LAST SLIDE. PROVIDED PICTURES FOR DATA. I NEED HELP WITH THE FIRST QUESTION. PLEASE AND THANK YOU

1. Compute the profit (loss) per customer for the retail customer and business customer first purpose. using original cost system then using the ABC System. Use costs shown in Exhibit B for thisEXHIBIT A Consolidated Income Statement For the three years ending December 31, 20x5 20x5 20x4 20x3 ($000) ($000) ($000) Net interest income" $3,486 $3,417 Provision for credit losses $3,349 484 475 465 Net interest income after provision for credit losses 3,002 2,942 Noninterest income 2,884 1.207 1,199 1,190 Income prior to noninterest expenses and income tax 4,209 4,141 4,074 Noninterest expenses 3,805 3,539 3,362 Income before income taxes 404 602 712 Income tax expense 130 194 230 Net income $ 274 $ 408 $ 482 . Net interest income equals interest income less interest expense. The bank's primary income is from interest-bearing checking accounts. Noninterest income includes fees charged for various services, such as checking account fees charged if the account balance falls below the required minimum level. Noninterest expenses are all of the bank's operating costs, including those associated with paying checks, providing teller services, and responding to customer account inquires.EXHIBIT B Assignment of Indirect (Noninterest Expense) Costs to Activity Cost Pools" Estimated Annual Activity Cost Pool to which Total Costs Indirect Cost Indirect Cost is Assigned (in $1,000s) Salaries of check-processing personnel Paying checks $ 700 Depreciation of equipment and facilities used in check processing Paying checks 440 Teller salaries Providing teller services 1,000 Depreciation of equipment and facilities used in teller operations Providing teller services 200 Salaries of customer representatives at call Responding to customer account center inquiries 450 Toll-free phone lines plus depreciation of equipment and facilities in customer Responding to customer account call center inquiries 60 Total indirect costs $2,850 * These indirect costs are part of the $3,805 "noninterest expenses" in the bank's 20x5 Income Statement in Exhibit A. The rest of the noninterest expenses in the Income Statement shown in Exhibit A pertain to other operating costs that are excluded from the pilot ABC study, such as the CEO's salary. (The costs listed in Exhibit B are indirect with respect to the retail customers and business account customers.)EXHIBIT C Activity Cost Drivers by Customer Line Annual Number of Units Annual Number of Units of Activity-Cost Driver of Activity-Cost Driver Activity Cost Used by Retail Customers Used by Business Customers Driver (in 1,000s) (in 1,000s) Total Checks processed 570 2,280 2,850 Teller transactions 160 40 200 Account inquiry calls to customer service call center 95 100After examining the three branch banks' indirect costs (that is, the cost items making up the branch banks' noninterest operating expenses), the ABC team classied the annual costs in each activity's cost poolI (hereafter, all numbers are in thousands) as shown in Exhibit B. The team identied the following cost drivers2 for each activity cost pool: My. mom M Number or checks Providin- teller services Number of teller transactions Responding to customer account Number of account inquiry calls in-uiries to customer service call center The ABC team estimated that for the three pilot test bank branches, the retail and business customer lines experienced the annual activity levels (in thousands) as shown in Exhibit C. For example. Exhibit C reveals that retail customers had 160,000 teller transactions and made 95,000 account inquiry calls to the customer service call center. ABC Bank currently services 150,000 retail customer checking accounts and 50,000 business customer checking accounts. The bank earns net interest revenue on the balances that customers keep in their checking accounts.3 On TheABcnank The ABC Bank began operations in the mid-1980s. The bank quickly grew by providing checking account services to many small businesses. Although ABC initially offered checking account services for individual accounts (retail customers). the bank primarily focused on serving its business customers. During the economic slowdown of the early 19905 that weakened the local economy, growth in business customer accounts began to decline. In response, ABC's senior management adopted a new sn'ategy, focusing on increasing the number of retail customer accounts. By aggressively marketing individual retail accounts, ABC continued to grow. Today, the ABC Bank strives to maintain a stable base of business customers, while actively competing for an increased market share of retail customers. Recent income statements (Exhibit A) reveal a decline in the bank's prots. The bank's primary (noninterest) expense consists of salaries and employee benefits. Most full time employees' first priority is providing services to customers; these employees conduct their administrative responsibilities during slack times. The Bank schedules additional part time employees to work during peak demand times, from llAM- 2PM and Friday afternoons. Flexibility in scheduling part time employees means that the bank's staff is lean and fully utilized. ABC's CEO, Rob Garrison, believes that this stafng arrangement allows the bank to provide speedy customer service, while operating at practical capacity. (That is. the bank's staff is fully utilized in efficient operations, after allowing for bank holidays and other scheduled staff activities such as training.) to counter wrung prams, not. as uueuurs won two acuuus um year, both aimed at increasing the bank's retail customer base. First, ABC established a service call center to respond to customer inquiries about account balances, checks cleared. fees charged, and other banking concerns. Second, ABC's directors authorized year-end bonuses to branch managers who met their branch's target increase in the number of customers. However. even though 80 percent of the branch managers met the targeted increase in customer accounts, the Bank's prots continued to decline. CEO Rob Garrison does not understand why prots are declining, given that the Bank is serving more customers. ABC's southeast regional manager, Erik Larsen, has also noticed that while small retail customers ock to the bank, the number of business cusromers is barely Stable. Erik Larsen suspects that ABC's costing system may be part of the problem. ABC developed its simple costing system when the bank began operations in 1985. The bank does not trace any costs directly to individual customers. It simply treats all (noninterest expense) operating costs, except $955,000 of other operating expenses such as CEO salary, identied in the Income Statement in Exhibit A as indirect with respect to the customer line. The bank allocates these indirect costs to either the retail customer line or the business customer line, based on the total dollar value of checks processed (which is readily available because each branch must provide the dollar values of daily transactions for internal control). For the current period, ABC processed a total of $95 million in checks, of which 59.5 million was written by retail customers, and $85.5 million was written by business customers. This costing approach was fairly typical of banks and other financial institutions at the time ABC developed its cost system. In college, Erik learned about an alternative costing approach called activitybased costing (ABC). However, the examples he remembered involved manufacturing firms. He wondered whether ABC could develop an ABC system, with the business account customer line and the retail account customer line as the two primary cost objects. Erik approad'red Rob Garrison with this suggestion. Rob was skeptical, exclaiming, "Our profits are going down the tubes and you want me to spend money developing a new accounting system?" However, Erik persisted, and Rob eventually authorized a pilot ABC study using three local branches of the bank. The ABC implementation team included Erik, the managers of each of the three bank branches, a bank teller, and a representative from the customer service call center. The team began by identifying the activities ABC Bank performed. To start a simple pilot study, the team identied the three most important activities: 1. Paying checks 2. Providing teller services 3. Responding to customer account inquiries at the customer service call center If this pilot study turned out to be successful, then the team planned to rene the system by conducting a more detailed activity analysis the following year. The ABC team began by determining the costs that are associated with each of the three activities. The team quickly discovered that. as is typical in service industries like banking, labor (personnel) costs dominate. The ABC team asked each employee to fill out a short questionnaire to find out how the employee spends his or her time. The team then followed up with an in- depth personal interview with each employee. The ABC team used this combined information to estimate the percentage of time each employee spent on each of the three activities: (1) paying checks, (2) providing teller services, and (3) responding to customer account inquiries. The team then estimated the other (non-labor) resources that each of the three activities consumed. For example, they traced to the \"responding to customer account inquiry" activity: (1) the cost of toll-free telephone lines at the customer service call center, and (2) depreciation on other equipment and facilities the call center personnel use. Similarly, the ABC team estimated the percentage of time the bank's information system was used for check processing and providing teller services (vs. other uses such as compiling periodic nancial statements), to determine how much of the equipment's depreciation to assign to the activities "paying checks" and "providing teller services." To complete the pilot study in a timely fashion, the ABC team based their estimated activity costs on last year's actual data, which were already available. If the pilot study succeeded. then the ABC team planned to develop budgeted indirect cost rates for each activity the following year. The advantage of budgeted rates over actual rates based on the prior year's data is that budgeted rates (budgeted cost associated with the activity divided by the budgeted quantity of the activity's cost driver) can incorporate expected changes in costs and operations. average, the bank earns the following annual revenue (both interest and non-interest) from each type of account: Avg. annual revenue per retail customer account $10 Avg. annual revenue per business customer account $40