4 Chippewa River Banking Company has ten automatic teller machines (ATMs) spread throughout the city maintained by the ATM Department. You have the task of determining the cost of operating each machine. Management will use the information you develop, along with other information pertaining to the volume and type of transactions at each machine, to evaluate the desirability of continuing to operate each machine and/or changing security arrangements for a particular machine. a. Determine the monthly operating costs of machines 7 and 8 when overhead costs are distributed cvenly between the ATM machines. Parts b- e will step through calculating the monthly operating costs of machines 7 and 8 when using activity based costing. b. Identify which of the costs in the table above are overhead costs, and which are direct (can be The ATM Department consists of six employees: a supervisor, a head cashier, two associate cashiers, and two maintenance personnel. The ATM department is responsible for two main activities: daily trips to restock the machines, and maintenance of the machines. The associate cashiers make between two and four daily trips to each machine to collect and replenish cash and to replenish supplies. Costs associated with these daily trips are driven by the number of trips made. When a problem is reported, 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. Costs associated with maintenance activities are driven by maintenance hours. Maintenance employees spend all of their time on maintenance-related activities. The associate cashiers spend approximately 50 percent of their time on percent on daily trips. The head cashier\'s time is divided, with 75 percent directly related to daily trips to each machine and 25 percent related to supervising cashiers on maintenance calls. The supervisor devotes 20 percent of the time to daily trips to each machine and 80 percent to the equal supervision of each emplayee. One third of the office space (and associated utilities) is used for maintenance activities, the remainder of the office space is accommodates the routine daily trips. In a normal month, the ATM department makes 720 routine daily trips, and logs 160 maintenance hours. Cost information for a recent month follows: traced easly to each ATM). Assign the overhead costs to the two identified activities (routine daily trips and maintenance). Hint: some of the overhead costs in the table above are split between the two activities. For those costs, use the time and other information given above to assign costs between activities. Determine the activity cost overhead rates for the activities. Round answers to the nearest cent c. d. e. Determine the operating costs assigned to machines 7 and 8 using activity-based costing. f. How can ABC cost information be used by Red River Banking Company to improve the overall management of monthly operating costs? Salaries Head cashier Associate cashiers ($1,800 each) Maintenance personnel ($1,800 each) 4,200 3,000 3,600 3,600 Lease and Maintenance service vehicle Office rent and utilities Machine lease and utilities ($1,500 per ATM) 1,500 1,400 2,500 15,000 34,800 Total Related actual activity information for this month follows: Machine number 120
a. Monthly Cost of Operating Machines
Total Operating Costs
34800
Total ATM Machines
10
Overheads are evenly distributed
= 34800 / 10
Machine 7
3480
Machine 8
3480
b. Categorizing the expenses
Direct Expenses
Overhead Costs
Salaries
Salaries
Associate Cashier
Supervisor
Maintenance Personnel
Head Cashier
Lease and Operating Costs
Cashier\'s Service Vehicle
Office Rent and utilities
Maintenance Service Vehicle
Machine lease and utilities
c. Assigning Overhead Costs
Routine Daily Trips
Maintenance
Salaries
Associate Cashier
50%
50%
Maintenance Personnel
100%
Supervisor
20%
80%
Head Cashier
75%
25%
Lease and Operating Costs
Cashier\'s Service Vehicle
50%
50%
Maintenance Service Vehicle
100%
Machine lease and utilities
Office Rent and utilities
67.67%
33.33%
d. Activity Cost Overhead Rate for activities
Routine Daily Trips
Maintenance
Salaries
Associate Cashier
$ 1,800
$ 1,800
Maintenance Personnel
$ -
$ 3,600
Supervisor
$ 840
$ 3,360
Head Cashier
$ 2,250
$ 750
Lease and Operating Costs
Cashier\'s Service Vehicle
$ 750
$ 750
Maintenance Service Vehicle
$ 1,400
Machine lease and utilities
Office Rent and utilities
$ 1,692
$ 833
| a. Monthly Cost of Operating Machines |
| Total Operating Costs | 34800 |
| Total ATM Machines | 10 |
| Overheads are evenly distributed | = 34800 / 10 |
| Machine 7 | 3480 |
| Machine 8 | 3480 |
Homework Sourse
