The Owl National Bank is analyzing its existing cost system for services so that it can...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The Owl National Bank is analyzing its existing cost system for services so that it can determine the true cost of its services for pricing purposes. The bank's controller has been researching the use of activity based costing for all operations, but specifically for the teller operations. After performing an analysis of what tellers do for customers on a recurring basis, he has identified five different activities that a teller may perform for a customer, with the related information for those activities for a normal month, provided in the table attached. Currently, the bank is using the number of teller hours as the basis for costing a service. On average, the bank records 450 hours per month for tellers. In conjunction with this, the bank is considering the creation of a brand new type of checking account for senior citizens. It has been estimated that the attached volume of activity will occur on average for these accounts. The bank wants to set a price that earns a 25% markup on its cost. e 15,000 Ne (2) REQUIRED: (1) Using the attached answer sheet, calculate the rate that the bank is currently using to estimate the costs of providing services to customers. Round your answer to four decimal places. Using the attached answer sheet, calculate the rates that the bank would use to estimate the costs of providing services to customers if it decides to use activity based costing. Round all answers to four decimal places. Using the attached answer sheet, calculate the cost of the new senior citizen account if the bank uses its existing cost system to calculate the cost. Round your answer to the nearest cent (two decimal places). What would be the price that it would charge senior citizens for this type of account using this costing method? (3) YARI LA ME (4) Using the attached answer sheet, calculate the cost of the new senior citizen account if the bank uses activity based costing to calculate the cost. Round your answer to the nearest cent (two decimal places). What would be the price that it would charge senior citizens for this type of account using activity based costing? OWL NATIONAL BANK ACTIVITIES PERFORMED BY TELLERS WITH ESTIMATED COSTS AND COST DRIVERS TIHE Acti Activity Deposit Transaction Withdrawal Transaction Answer Questions Sell Cashier's Checks, Money Orders, etc. Balance the Drawer Deposit Transactions Withdrawal Transactions Estimated Cost $ $ Activity Cost Driver 15,000 Number of Deposit Transactions 13,000 Number of Withdrawal Transactions 8,000 Number of Customer Questions 1,000 Number of Items Sold 1,200 Number of Drawers Balanced 38,200 OWL NATIONAL BANK ESTIMATED ACTIVITY VOLUME FOR VARIOUS TRANSACTIONS Average Monthly Volume 2.5 5.5 3.0 1.0 Customer Questions Number of Cashier's Checks, Money Orders, etc., Sold Estimated Cost Driver Units 40.000 30,000 40,000 1,200 1,300 Average Total Teller Time Used 5 minutes: 12 minutes 4 minutes 4 minutes (1) (2) OWL NATIONAL BANK CALCULATION OF CURRENT COST RATE FOR SERVICES TO CUSTOMERS USING EXISTING COSTING METHOD Total Estimated Cost of Services to Customers Divided By Total Estimated Teller Hours Cost of Services to Customers Under Existing Costing Method (per teller hour) OWL NATIONAL BANK CALCULATION OF COST RATES FOR SERVICES TO CUSTOMERS USING ACTIVITY BASED COSTING METHOD otal Estimated Costs of Deposit Transactions Divided By Total Cost Driver Units Estimated Cost of Deposit Transaction (per deposit) Total Estimated Costs of Withdrawal Transactions Divided By Total Cost Driver Units Estimated Cost of Withdrawal Transaction (per withdrawal) Total Estimated Costs of Answer Questions Transactions Divided By Total Cost Driver Units Estimated Cost of Answer Question Transaction (per question) Total Estimated Costs of Selling Cashier's Checks, etc. Transactions Divided By Total Cost Driver Units Estimated Cost of Selling Cashier's Checks, etc. Transaction (per item) Total Estimated Costs of Balance the Drawer Transactions Divided By Total Cost Driver Units Estimated Cost of Selling Cashier's Checks, etc. Transaction (per item) (3) (4) OWL NATIONAL BANK OF SENIOR CITIZEN ACCOUNT COST AND CHARGES USING EXISTING COST SYSTEM CALCULATION Deposit Transactions Withdrawal Transactions Customer Questions Transactions Number of Cashier's Checks, Etc. Transactions Total Cost of Senior Citizen Account Using Existing Cost System Total Cost of Senior Citizen Account Using Existing Cost System Times Markup Requirement Price Needed To Be Charged For Senior Citizen Account OWL NATIONAL BANK CALCULATION OF SENIOR CITIZEN ACCOUNT COST AND CHARGES USING ACTIVITY BASED COST SYSTEM Deposit Transactions Withdrawal Transactions Customer Questions Transactions Number of Cashier's Checks, Etc. Transactions Total Cost of Senior Citizen Account Using Activity Based Costing Total Cost of Senior Citizen Account Using Activity Based Costing Times Markup Requirement Price Needed To Be Charged For Senior Citizen Account The Owl National Bank is analyzing its existing cost system for services so that it can determine the true cost of its services for pricing purposes. The bank's controller has been researching the use of activity based costing for all operations, but specifically for the teller operations. After performing an analysis of what tellers do for customers on a recurring basis, he has identified five different activities that a teller may perform for a customer, with the related information for those activities for a normal month, provided in the table attached. Currently, the bank is using the number of teller hours as the basis for costing a service. On average, the bank records 450 hours per month for tellers. In conjunction with this, the bank is considering the creation of a brand new type of checking account for senior citizens. It has been estimated that the attached volume of activity will occur on average for these accounts. The bank wants to set a price that earns a 25% markup on its cost. e 15,000 Ne (2) REQUIRED: (1) Using the attached answer sheet, calculate the rate that the bank is currently using to estimate the costs of providing services to customers. Round your answer to four decimal places. Using the attached answer sheet, calculate the rates that the bank would use to estimate the costs of providing services to customers if it decides to use activity based costing. Round all answers to four decimal places. Using the attached answer sheet, calculate the cost of the new senior citizen account if the bank uses its existing cost system to calculate the cost. Round your answer to the nearest cent (two decimal places). What would be the price that it would charge senior citizens for this type of account using this costing method? (3) YARI LA ME (4) Using the attached answer sheet, calculate the cost of the new senior citizen account if the bank uses activity based costing to calculate the cost. Round your answer to the nearest cent (two decimal places). What would be the price that it would charge senior citizens for this type of account using activity based costing? OWL NATIONAL BANK ACTIVITIES PERFORMED BY TELLERS WITH ESTIMATED COSTS AND COST DRIVERS TIHE Acti Activity Deposit Transaction Withdrawal Transaction Answer Questions Sell Cashier's Checks, Money Orders, etc. Balance the Drawer Deposit Transactions Withdrawal Transactions Estimated Cost $ $ Activity Cost Driver 15,000 Number of Deposit Transactions 13,000 Number of Withdrawal Transactions 8,000 Number of Customer Questions 1,000 Number of Items Sold 1,200 Number of Drawers Balanced 38,200 OWL NATIONAL BANK ESTIMATED ACTIVITY VOLUME FOR VARIOUS TRANSACTIONS Average Monthly Volume 2.5 5.5 3.0 1.0 Customer Questions Number of Cashier's Checks, Money Orders, etc., Sold Estimated Cost Driver Units 40.000 30,000 40,000 1,200 1,300 Average Total Teller Time Used 5 minutes: 12 minutes 4 minutes 4 minutes (1) (2) OWL NATIONAL BANK CALCULATION OF CURRENT COST RATE FOR SERVICES TO CUSTOMERS USING EXISTING COSTING METHOD Total Estimated Cost of Services to Customers Divided By Total Estimated Teller Hours Cost of Services to Customers Under Existing Costing Method (per teller hour) OWL NATIONAL BANK CALCULATION OF COST RATES FOR SERVICES TO CUSTOMERS USING ACTIVITY BASED COSTING METHOD otal Estimated Costs of Deposit Transactions Divided By Total Cost Driver Units Estimated Cost of Deposit Transaction (per deposit) Total Estimated Costs of Withdrawal Transactions Divided By Total Cost Driver Units Estimated Cost of Withdrawal Transaction (per withdrawal) Total Estimated Costs of Answer Questions Transactions Divided By Total Cost Driver Units Estimated Cost of Answer Question Transaction (per question) Total Estimated Costs of Selling Cashier's Checks, etc. Transactions Divided By Total Cost Driver Units Estimated Cost of Selling Cashier's Checks, etc. Transaction (per item) Total Estimated Costs of Balance the Drawer Transactions Divided By Total Cost Driver Units Estimated Cost of Selling Cashier's Checks, etc. Transaction (per item) (3) (4) OWL NATIONAL BANK OF SENIOR CITIZEN ACCOUNT COST AND CHARGES USING EXISTING COST SYSTEM CALCULATION Deposit Transactions Withdrawal Transactions Customer Questions Transactions Number of Cashier's Checks, Etc. Transactions Total Cost of Senior Citizen Account Using Existing Cost System Total Cost of Senior Citizen Account Using Existing Cost System Times Markup Requirement Price Needed To Be Charged For Senior Citizen Account OWL NATIONAL BANK CALCULATION OF SENIOR CITIZEN ACCOUNT COST AND CHARGES USING ACTIVITY BASED COST SYSTEM Deposit Transactions Withdrawal Transactions Customer Questions Transactions Number of Cashier's Checks, Etc. Transactions Total Cost of Senior Citizen Account Using Activity Based Costing Total Cost of Senior Citizen Account Using Activity Based Costing Times Markup Requirement Price Needed To Be Charged For Senior Citizen Account
Expert Answer:
Answer rating: 100% (QA)
Lets calculate the requested values step by step 1 Calculate the rate the bank is currently using to estimate the costs of providing services to customers under the existing cost system Current Cost R... View the full answer
Related Book For
Practical Management Science
ISBN: 978-1305250901
5th edition
Authors: Wayne L. Winston, Christian Albright
Posted Date:
Students also viewed these accounting questions
-
Provide a detailed and in - depth analysis of specific marketing activities in relation to the full marketing strategies and tactical elements ( airline industry offering services, you need to apply...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
If an investor holds a credit-linked note and the credit event does not occur, the investor receives: A. All promised cash flows as scheduled. B. All coupon payments as scheduled but not the par...
-
Define absorption costing?
-
Suppose there are two countries. In the rich country, the representative consumer has Hr units of human capital, and total factor productivity is zr. In the poor country, the representative consumer...
-
Comment on why the proposed changes to sales processes are necessary. Also, which changes would you recommend in terms of their: (a) selling activities? (b) sales value proposition?
-
Electronics Service Co. pays salaries monthly on the last day of the month. The following information is available from Electronics for the month ended December 31, 2016: Administrative salaries...
-
How does organizational learning contribute to continuous improvement and adaptability in a rapidly changing business environment ?
-
Judy Ericsdotter, the new marketing manager for Adaptive Wear (AW), a retailer of adaptive clothing for individuals with reduced mobility, recently proposed to the board that the company create a new...
-
2. Prepare a budgeted balance sheet as of December 31, 20Y9. Current assets: Inventories: PLO Total current assets Property, plant, and equipment: Assets Total property, plant, and equipment Total...
-
Kit Inc., a manufacturer of kitchen cabinets, sells cabinets for $16,000 per set. Kit is now considering developing a new set of cabinets for a condominium project. The estimated costs are $12,000...
-
prepare T-accounts from the followings transactions and post them in a trial balance bril 2 2 3 7 11 12 17 21 24 30 Issued stock to investors in exchange for $40,000 cash. Hired an assistant at a...
-
1. Given A= [2 + m 3 1 1 2 -1 5+ ml -1 4 and B = a. (AB)TA (using Excel) b. 14A+2B (using Excel) a. 2AB- (using MATLAB) [-1-m 2 3 0+m 5+ m 6 91 3. Find the following: 1 (10 marks) (10 marks) (5...
-
The Black-Scholes pricing problem for a European binary call op- tion is given by the partial differential equation and final condition 252 V av 1 t +20 J1 S>E +rS -V-0, V(S.T) = 0 SE sav as 85 v...
-
What does the P/E ratio as of the date of the printout mean? POW $21.16 RT Day Low: 20.44 Detailed Quote UPEN: 20.82 PREV. CLOSE: 20.97 - 0.4475 CAD FX-DVNATE: 03/30/2020 HIGH: 21.18 LOW: 20.44 DIV...
-
You are a consultant to the City of Dallahassee, helping to formulate the city's solid waste policy for the next two decades. One of the critical issues the city faces is whether to build municipal...
-
Refer to Exercise 8.S.I. Construct a scatterplot of the data. Does the appearance of the scatterplot indicate that the pairing was effective? Explain. Exercise 8.S.I. A volunteer working at an animal...
-
Modify the synchronized ordering model in Example 12.5 slightly so that you can use a two-way SolverTable on the fixed costs. Specifically, enter a formula in cell B9 so that the fixed cost of...
-
Based on Boykin (1985). Thompson Chemicals produces 359 million pounds of the chemical maleic anhydride annually. A total of four reactors are available to produce maleic anhydride. Each reactor can...
-
In the last sheet of the finished version of the Fixed Cost Manufacturing file, we illustrated one way to model the Great Threads problem with IF functions, but saw that this approach doesnt work....
-
Describe which characteristics of HR metrics and workforce analytics are likely to result in greater return on investment and organizational impact.
-
Why are information security and privacy important considerations in the design, development, and maintenance of an HRIS?
-
List and discuss the major information security and privacy threats to organizations.
Study smarter with the SolutionInn App