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
-
Emery Communications Company is considering the production and marketing of a communications system that will increase the efficiency of messaging for small businesses or branch offices of large...
-
Max Stamp approves study abroad documents for the university. Students must wait in line with their forms outside Maxs office. One student at a time is allowed in his office and Max takes precisely...
-
Aaron Reed, a photographer, was in a dispute with Ezelle Investment Properties, Inc., over Ezelle allegedly using one of Reeds photographs without permission. Reed sent Ezelle a cease-and-desist...
-
Kathleen Cole Inc. acquired the following assets in January of 2005. Equipment, estimated service life, 5 years; salvage value , $15,000 ........$525,000 Building, estimated service life, 30 years;...
-
Consider an object falling through air, where po is the density of the object, Pair is the density of the air, m is the mass of the object, A is the effective cross-sectional area of the object, or...
-
Presented here are summarized data from the balance sheets and income statements of Wiper Inc.: Required: a. Calculate return on investment, based on net income and average total assets, for 2023 and...
-
Choose a natural disaster that occurred in 2023 and assess its impact on a specific company's logistics, quantifying the damages or loss incurred in terms of monetary value? Select a political...
-
The primary organizational focus of managerial accounting is on the company's: Select one or more: a. whole b. There is not sufficient information to answer this question. c. Both whole and parts d....
-
Myriad Inc., a well-established and reputed multinational enterprise (MNE), is headquartered in a highly developed economy. It wants to start its operations in New Denistan, considered one of the...
-
Find the following using the given functions. (Simplify your answers completely.) f(x) = 6x3 = x + 2x + 3 and g(x) = 9x3 - 1 (a) (f+g)(x) = (b) (f+g)(2) = (c) (fg)(x) = (d) (f g)(-3) =
-
A client has indicated an interest in opening a franchise. The client has requested information related to the accounting of operating a franchise. You are to prepare a memo indicating the relevant...
-
Shaniah learned from a Cornell University website for beginning farmers that if she wants to start farming, she should consider what is demanded by society. Which of these basic economic questions...
-
The market for monkey spanners currently has 10,000 firms that have identical size and production technology. a. The market is currently in a long-run equilibrium where each firm produces...
-
Write a paper by answer the following question: Should Recycling Be Mandatory?
-
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?
-
Visit the Suzy Lamplugh Trust website at http://www.suzylamplugh.org and the Social Research Association at http://the-sra.org.uk/sra_resources/safety-code/ . Browse the guidance leaflets/web pages...
-
Andrew, a final year part-time MBA student employed by a large Maltese market research company, read in a local newspaper that Malta (a small island state situated in the centre of the Mediterranean...
-
Maria had a problem. The research proposal for her masters research project was due. But she had no idea what to research. Sustainable tourism had been her favourite module on the programme and...
Study smarter with the SolutionInn App