Part 3 Happy Banking Company has ten automatic teller machines (ATM) spread throughout the city maintained...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Part 3 Happy Banking Company has ten automatic teller machines (ATM) spread throughout the city maintained by the ATM Department. You have been assigned the task of determining the cost of operating each machine. Management will use the information you develop to evaluate the desirability of continuing to operate each machine and/or changing security arrangements for a particular machine. The ATM Department consist of a total of six employees: a supervisor, a head cashier, two associate cashiers, and two maintenance personnel. The associate cashiers make between two and four daily trips to each machine to collect and replenish cash and to replenish supplies, deposit tickets and so forth. Each machine contains a small computer that automatically summarizes and reports transactions to the head cashier. The head cashier reconciles the activities of the two associate cashiers to the computerized reports. The supervisor, who does handle cash, reviews the reconciliation. When an automatic teller's computer, a customer, or a cashier reports a problem, the two maintenance employees and one cashier are dispatched immediately. The cashier removes all cash and transaction records, and the maintenance employees repair the machine. Monthly operating costs and information on percentage of time that used in activities for a recent month follows: Operating costs: Supervisor Salary Head cashier Salary Associate cashiers Salary ($1,800 each Assoc. cashier) Maintenance workers salary Cashiers' service vehicle-used for Routine trips Maintenance service vehicle-used for maintenance activities Machine lease, space rent, and utilities ($1,400 each machine) Office rent and utilities-used equally preparing for routine and maintenance activities Total operating cost for month Routine Trip Related Maintenance- Activity related activities percentage percentage $5,000 62% 38% 4,000 77% 23% 3,600 50% 50% 3,630 100% 1,682 100% 1,545 100% 1,576 50% 50% 14,000 $35,033 Related monthly activity information for this month follows: Monthly Operating cost Activity Rate $35,033.00 Routine Machine Trips Maintenance Hours 1 35 6 2 90 17 3 60 15 4 80 30 5 75 15 6 30 10 7 90 25 8 20 5 9 60 20 10 40 580 7 150 $17,516.50 $11,677.67 $8,758.25 $7,006.60 $5,838.83 $5,004.71 $4,379.13 $3,892.56 $3,503.30 Additional Information follows: 1. The office is centrally located with about equal travel time to each machine. 2. Maintenance hours include travel time. 3. The cashiers' service vehicle is used exclusively for routine visits. Required-Answer the following questions in the area below each question. I have tried to set up some structure in some of the analysis in the solution area below. You are required to use cell referencing in all your calculations in Excel to earn credit. Using cell referencing will all you to perform what-if analysis for E. Do not type in numbers but use cell references. a. Determine the monthly operating costs of a machine when cost assignments are based on the number of machines. Conceptually this is like the plantwide overhead rate per unit. Hint: Do not make this complicated, since you are given the total operating cost and know there are 10 machines. $3,503.30 b. You have determined that ABC would be a more effective costing method. You have decided to A60:J107 split the costs into 3 activities: Routine trip, maintenance, and machine lease-space rent-utilities. Develop an analysis to determine the activity rates for each of the 3 activities. Round answers to the nearest cent. Machine lease, Routine Trips space rent, and Maintenance utilities Supervisor Salary Head cashier Salary Associate cashiers Salary ($1,800 each Assoc. cashier) Maintenance workers salary $9 6.896551724 6.206896552 6.25862069 $33 26.66666667 $500 400 24 24.2 360 363 Cashiers' service vehicle-used for Routine trips 3 11.21333333 168.2 Maintenance service vehicle-used for maintenance activities 2.663793103 10 154.5 Office rent and utilities-used equally preparing for routine and maintenance activities 2.717241379 10.50666667 157.6 Machine lease, space rent, and utilities ($1,400 each machine) 24.13793103 93.33333333 1,400 Total per activity Quantity of activity Unit activity rates c. Determine the operating costs assigned to each machine when activity-based costing is used. Machine Routine Trips Maintenance Machine lease, space rent, and utilities Total 1 2 3 4 5 6 7 8 9 10 Total Part 3 Happy Banking Company has ten automatic teller machines (ATM) spread throughout the city maintained by the ATM Department. You have been assigned the task of determining the cost of operating each machine. Management will use the information you develop to evaluate the desirability of continuing to operate each machine and/or changing security arrangements for a particular machine. The ATM Department consist of a total of six employees: a supervisor, a head cashier, two associate cashiers, and two maintenance personnel. The associate cashiers make between two and four daily trips to each machine to collect and replenish cash and to replenish supplies, deposit tickets and so forth. Each machine contains a small computer that automatically summarizes and reports transactions to the head cashier. The head cashier reconciles the activities of the two associate cashiers to the computerized reports. The supervisor, who does handle cash, reviews the reconciliation. When an automatic teller's computer, a customer, or a cashier reports a problem, the two maintenance employees and one cashier are dispatched immediately. The cashier removes all cash and transaction records, and the maintenance employees repair the machine. Monthly operating costs and information on percentage of time that used in activities for a recent month follows: Operating costs: Supervisor Salary Head cashier Salary Associate cashiers Salary ($1,800 each Assoc. cashier) Maintenance workers salary Cashiers' service vehicle-used for Routine trips Maintenance service vehicle-used for maintenance activities Machine lease, space rent, and utilities ($1,400 each machine) Office rent and utilities-used equally preparing for routine and maintenance activities Total operating cost for month Routine Trip Related Maintenance- Activity related activities percentage percentage $5,000 62% 38% 4,000 77% 23% 3,600 50% 50% 3,630 100% 1,682 100% 1,545 100% 1,576 50% 50% 14,000 $35,033 Related monthly activity information for this month follows: Monthly Operating cost Activity Rate $35,033.00 Routine Machine Trips Maintenance Hours 1 35 6 2 90 17 3 60 15 4 80 30 5 75 15 6 30 10 7 90 25 8 20 5 9 60 20 10 40 580 7 150 $17,516.50 $11,677.67 $8,758.25 $7,006.60 $5,838.83 $5,004.71 $4,379.13 $3,892.56 $3,503.30 Additional Information follows: 1. The office is centrally located with about equal travel time to each machine. 2. Maintenance hours include travel time. 3. The cashiers' service vehicle is used exclusively for routine visits. Required-Answer the following questions in the area below each question. I have tried to set up some structure in some of the analysis in the solution area below. You are required to use cell referencing in all your calculations in Excel to earn credit. Using cell referencing will all you to perform what-if analysis for E. Do not type in numbers but use cell references. a. Determine the monthly operating costs of a machine when cost assignments are based on the number of machines. Conceptually this is like the plantwide overhead rate per unit. Hint: Do not make this complicated, since you are given the total operating cost and know there are 10 machines. $3,503.30 b. You have determined that ABC would be a more effective costing method. You have decided to A60:J107 split the costs into 3 activities: Routine trip, maintenance, and machine lease-space rent-utilities. Develop an analysis to determine the activity rates for each of the 3 activities. Round answers to the nearest cent. Machine lease, Routine Trips space rent, and Maintenance utilities Supervisor Salary Head cashier Salary Associate cashiers Salary ($1,800 each Assoc. cashier) Maintenance workers salary $9 6.896551724 6.206896552 6.25862069 $33 26.66666667 $500 400 24 24.2 360 363 Cashiers' service vehicle-used for Routine trips 3 11.21333333 168.2 Maintenance service vehicle-used for maintenance activities 2.663793103 10 154.5 Office rent and utilities-used equally preparing for routine and maintenance activities 2.717241379 10.50666667 157.6 Machine lease, space rent, and utilities ($1,400 each machine) 24.13793103 93.33333333 1,400 Total per activity Quantity of activity Unit activity rates c. Determine the operating costs assigned to each machine when activity-based costing is used. Machine Routine Trips Maintenance Machine lease, space rent, and utilities Total 1 2 3 4 5 6 7 8 9 10 Total
Expert Answer:
Related Book For
Auditing An International Approach
ISBN: 978-0071051415
6th edition
Authors: Wally J. Smieliauskas, Kathryn Bewley
Posted Date:
Students also viewed these accounting questions
-
Part 3 Happy Banking Company has ten automatic teller machines (ATM) spread throughout the city maintained by the ATM Department. You have been assigned the task of determining the cost of operating...
-
Image transcription text Module 5 Discussion A' Instructions: This discussion will be completed in two parts, and will give you an opportunity to reect upon this week's content and to interact with...
-
Given the definition of the radian angle: S l Where [s] = m, [4] = m What are the dimensions of angles? A. No way to know B. meters, m C. 1 (or no units/dimensions) D. seconds, S E. kilograms, kg
-
Jonathan Butler, process engineer, knows that the acceptance of a new process design will depend on its economic feasibility. The new process is designed to improve environmental performance. On the...
-
Use statistics software to make a histogram of this data set: 44, 45, 51, 40, 28, 46, 34, 19. a. Based on the histogram, predict what a box plot of the data will look like. b. Use the software to...
-
Cobra Golf Club Corp. had the following stockholders' equity at December 31, 2007: On June 30, 2008, Cobra split its common stock 2 for 1. Make the memorandum entry to record the stock split, and...
-
Based on the manager identified in Question 3, in what ways did that person exhibit or fail to exhibit each of the components of leadermember exchange (LMX)? Did you have a high or low LMX with that...
-
As stated in a class handout on the strategy of competition and cooperation that is posted in Module 9: "Economists have a simple view of cooperation and conflict: People tend to cooperate when they...
-
1. All players but the retailer should answer this question. What do you think the retailers customer demand pattern looked like? How did your customer orders vary throughout the game? 2. What...
-
See Clear Company manufactures clear plastic CD cases. It applies varlable overhead based on the number of machine hours used. Information regarding See Clear's overhead for the month of December...
-
Home has 1200 units of L and Foreign has 3600 of units of L available. Both countries can produce coffee and cloth. The unit labour requirements for coffee and cloth in Home is 4 and 2 respectively....
-
Problem 9 - 2 1 ( Algo ) Performance Report for a Nonprofit Organization [ LO 9 - 1 , LO 9 - 2 , LO 9 - 3 , LO 9 - 4 ] The Saint Lucia Blood Bank, a private charity partly supported by government...
-
After watching the video, please answer the below question. https://www.youtube.com/watch?v=RWRJLynQWnU&feature=youtu.be Are the rental scams on sites like Airbnb.com Links to an external site. or...
-
41. Sort these lists using the selection sort. a) 3, 5, 4, 1, 2 c) 1, 2, 3, 4, 5 b) 5,4, 3, 2, 1
-
This is a group based assignment with both conceptual and computational questions listed below. Please first purchase the case with the link provided; the cost of the case is $4.25 per student. Then,...
-
Wrigley Inc. had $1 billion in EBITDA in 2006. The firm is unlevered and has a market value of equity of $12 billion and a tax rate of 40%. Consider the effect on the value of the firm of the...
-
Software Solution is family-owned business that has been in operation for more than 15 year. The board of directors is comprised of mainly family members, plus a few professionals such as an...
-
What is the danger for auditors when company officials engage in undisclosed related-party transactions?
-
Case Description The case involves overpayment of wages to employees making false claims for hours worked. A temporary personnel agency assigned Nurse Jane to work at Municipal Hospital. The...
-
What are the activities in a financial performance analysis? When would the auditor design and carry out additional substantive audit procedures as a result of performance analysis?
-
A company is scheduling temporary differences for the purpose of computing deferred taxes. The company compared tax basis assets and liabilities with book basis assets and liabilities and accumulated...
-
A company is scheduling its temporary differences for the purpose of computing deferred taxes. The company compared tax basis assets and liabilities with book basis assets and liabilities and...
-
Can the number of instructions executed serve as a timer mechanism in a real-time operating system? How?
Study smarter with the SolutionInn App