Task:
Gomtek Auto Performance Parts Ltd.
Domenic Cianflone, MBA, PhD, FCMA
Gomtek Auto Performance Parts Ltd. is an importer of after-market auto parts, located in Toronto. Since its inception in 2001, the company has developed a reputation for sourcing rare performance parts (mainly exhaust systems) for luxury vehicles.
The CFO of the company has engaged your services to understand the cost to serve its four largest customers. Its first customer, Hillson Auto, is a large chain of retail-based auto parts stores that uses Gomtek to supply its own private-label brand. The second customer is Mauro’s Automotive, an automotive repair shop that specialises in luxury Japanese vehicles. The third customer is Hambley Auto Parts, which specialises in luxury German vehicles. Finally, Drossel Automotive is a high-end retailer of auto parts that services automotive enthusiasts.
Gomtek’s Controller has developed the following information:
|
Activity
|
Cost Driver
|
Cost
|
Frequency
|
|
Order Processing
|
Sales orders
|
$473,546
|
524
|
|
Delivery - regular
|
Regular delivery
|
$ 89.960
|
211
|
|
Delivery - rushed
|
Rushed delivery
|
$ 37,590
|
35
|
|
Returns processing
|
Returns
|
$ 43.537
|
36
|
|
Returns Shipping '
|
Shipments
|
$ 85,622
|
45
|
|
Item
|
Hillson
|
Mauro's
|
Hamblev
|
Drossel
|
|
# of orders
|
124
|
119
|
234
|
47
|
|
Regular deliveries
|
44
|
55
|
95
|
17
|
|
Rush deliveries
|
14
|
4
|
10
|
7
|
|
# of returns
|
16
|
7
|
7
|
6
|
|
# of return shipments
|
30
|
4
|
7
|
4
|
|
Avg selling price per unit
|
$ 1,800
|
$ 2,250
|
$ 2,370
|
$2,165
|
|
Average cost per unit
|
$ 1,456
|
$ 1.238
|
$ 1.064
|
$ 871
|
|
# of units sold
|
3,872
|
454
|
561
|
487
|
|
# of units returned
|
310
|
13
|
21
|
6
|
- Refers to shipping charges incurred when shipping product back to suppliers.
The CFO is concerned about who is the most profitable to service, as there have been considerable pressures to hit higher profits. He has engaged your service to assist with this initiative.
Required:
Use activity-based costing to prepare income statements for each individual customer. Hints: calculate your cost per driver then use all information in the case to prepare the income statements.