Question

In: Accounting

Activity-Based Costing in a Service Organization Banctronics Inc. has ten automatic teller machines (ATMs) spread throughout...

Activity-Based Costing in a Service Organization

Banctronics Inc. has ten automatic teller machines (ATMs) 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, along with other information pertaining to the vol-

ume 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.

The ATM Department consists of a total of six employees: a supervisor, a head cashier, two as-

sociate 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 transac-

tions to the head cashier. The head cashier reconciles the activities of the two associate cashiers to the

computerized reports. The supervisor, who does not 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.

Maintenance employees spend all of their time on maintenance-related activities. The associate

cashiers spend approximately 50 percent of their time on maintenance-related activities and 50 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

employee. Cost information for a recent month follows:

Salaries

Supervisor......................................................... $ 5,500

Head cashier....................................................... 4,000

Other ($2,100 each) ................................................. 8,400

Lease and operating costs

Cashiers’ service vehicle ............................................. 1,600

Maintenance service vehicle........................................... 1,500

Office rent and utilities ................................................. 4,000

Machine lease, space rent, and utilities ($1,700 each)......................... 17,000

Total ............................................................... $42,000

Related monthly activity information for this month follows:

Machine

Routine

Trips

Maintenance

Hours

1 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20 5

2 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 60 17

3 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 40 15

4 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 40 30

5 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 80 15

6 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20 10

7 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 70 25

8 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 100 5

9 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30 20

10 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 40

18

Total ................................................. 500 160

Additional information follows:

• The of?ce is centrally located with about equal travel time to each machine.

• Maintenance hours include travel time.

• The cashiers’ service vehicle is used exclusively for routine visits.

• The of?ce space is divided equally between the supervisor and the head cashier.

Required

a. Determine the monthly operating costs of machines 7 and 8 when cost assignments are based on the

number of machines.

b. Determine the activity cost of a routine trip and a maintenance hour for the month given. Round

answers to the nearest cent.

c. Determine the operating costs assigned and reassigned to machines 7 and 8 when activity-based

costing is used.

d. How can ABC cost information be used by Banctronics Inc. to improve the overall management of

monthly operating costs?

Solutions

Expert Solution


Related Solutions

Commercial Bank and Trust Company is studying the use of its automatic teller machines (ATMs). Of...
Commercial Bank and Trust Company is studying the use of its automatic teller machines (ATMs). Of particular interest is whether young adults (under 25 years) use the machines more than senior citizens. To investigate further, samples of customers under 25 years of age and customers over 60 years of age were selected. The number of ATM transactions last month was determined for each selected individual, and the results are shown below. Under 25 10 10 11 15 7 11 10...
The National Bank, like most other large banks, found that using automatic teller machines (ATMs) reduces...
The National Bank, like most other large banks, found that using automatic teller machines (ATMs) reduces the cost of routine bank transactions. National installed an ATM in the corporate offices of the Fun Toy Company. The ATM is for the exclusive use of Fun's 595 employees. After several months of operation, a sample of 100 employees revealed the following use of the ATM machine by Fun employees in a month: Number of Times ATM Used Frequency 0 15 1 20...
Activity-Based Costing for a Service Company Crosswinds Hospital plans to use activity-based costing to assign hospital...
Activity-Based Costing for a Service Company Crosswinds Hospital plans to use activity-based costing to assign hospital indirect costs to the care of patients. The hospital has identified the following activities and activity rates for the hospital indirect costs: Activity Activity Rate Room and meals $210 per day Radiology $296 per image Pharmacy $45 per physician order Chemistry lab $77 per test Operating room $740 per operating room hour The activity usage information associated with the two patients is as follows:...
Activity-Based Costing for a Service Company Crosswinds Hospital plans to use activity-based costing to assign hospital...
Activity-Based Costing for a Service Company Crosswinds Hospital plans to use activity-based costing to assign hospital indirect costs to the care of patients. The hospital has identified the following activities and activity rates for the hospital indirect costs: Activity Activity Rate Room and meals $252 per day Radiology $355 per image Pharmacy $56 per physician order Chemistry lab $100 per test Operating room $680 per operating room hour The activity usage information associated with the two patients is as follows:...
Activity-based costing for a service company Crosswinds Hospital plans to use activity-based costing to assign hospital...
Activity-based costing for a service company Crosswinds Hospital plans to use activity-based costing to assign hospital indirect costs to the care of patients. The hospital has identified the following activities and activity rates for the hospital indirect costs: Activity Activity Rate Room and meals $260 per day Radiology $210 per image Pharmacy $30 per physician order Chemistry lab $110 per test Operating room $940 per operating room hour The activity usage information associated with the two patients is as follows:...
Activity-Based Costing for a Service Company Crosswinds Hospital plans to use activity-based costing to assign hospital...
Activity-Based Costing for a Service Company Crosswinds Hospital plans to use activity-based costing to assign hospital indirect costs to the care of patients. The hospital has identified the following activities and activity rates for the hospital indirect costs: Activity Activity Rate Room and meals $237 per day Radiology $334 per image Pharmacy $53 per physician order Chemistry lab $90 per test Operating room $740 per operating room hour The activity usage information associated with the two patients is as follows:...
Activity-Based Costing for a Service Company Crosswinds Hospital plans to use activity-based costing to assign hospital...
Activity-Based Costing for a Service Company Crosswinds Hospital plans to use activity-based costing to assign hospital indirect costs to the care of patients. The hospital has identified the following activities and activity rates for the hospital indirect costs: Activity Activity Rate Room and meals $240 per day Radiology $215 per image Pharmacy $50 per physician order Chemistry lab $80 per test Operating room $1,000 per operating room hour The activity usage information associated with the two patients is as follows:...
Activity-Based Costing and Product Cost Distortion Handbrain Inc. is considering a change to activity-based product costing....
Activity-Based Costing and Product Cost Distortion Handbrain Inc. is considering a change to activity-based product costing. The company produces two products, cell phones and tablet PCs, in a single production department. The production department is estimated to require 4,000 direct labor hours. The total indirect labor is budgeted to be $462,400. Time records from indirect labor employees revealed that they spent 40% of their time setting up production runs and 60% of their time supporting actual production. The following information...
Activity-Based Costing and Product Cost Distortion Handbrain Inc. is considering a change to activity-based product costing....
Activity-Based Costing and Product Cost Distortion Handbrain Inc. is considering a change to activity-based product costing. The company produces two products, cell phones and tablet PCs, in a single production department. The production department is estimated to require 4,000 direct labor hours. The total indirect labor is budgeted to be $462,400. Time records from indirect labor employees revealed that they spent 40% of their time setting up production runs and 60% of their time supporting actual production. The following information...
Dodo Inc., uses activity-based costing to determine product margins. In the first stage, the activity-based costing...
Dodo Inc., uses activity-based costing to determine product margins. In the first stage, the activity-based costing system allocates two overhead accounts--equipment depreciation and supervisory expense--to three activity cost pools--Machining, Order Filling, and Other--based on resource consumption. Data pertinnent to perform these allocations appears below: Overhead costs: Equipment depreciation $ 107,000 Supervisory expense $ 9,900 Distribution of Resource Consumption Across Activity Cost Pools: Activity Cost Pools Machining Order Filling Other Equipment depreciation 0.60 0.30 0.10 Supervisory expense 0.60 0.20 0.20 In...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT