Development of Activity Based Costing Model

April 6, 2016 1714

akzonobel_logo_svg

Description
AkzoNobel Car Refinishes is a world leader in coatings for car repair and commercial vehicles.
The International Distribution Center (IDC) of AkzoNobel Car Refinishes is located on the site in Sassenheim.

Opportunities
The IDC is serving the global market. The volume split between EMEA (=Europe, Middle East and Africa) and the rest of the world is 75/25. Cost is allocated to the customers via an allocation process which uses an Activity Based Cost model to:

  • To determine the expected cost allocation based on the forecasted cost and volumes which determines the mark-up.
  • To allocate costs based on actual volumes.

The ABC model initially used assigned different costs to activities based on percentages.
The model was considered complex and there was a lack of trust in the accuracy of the model. Groenewout was requested to support the setup of a new ABC model.

Solution
A multi disciplinary team from Finance, Operations and a customer representative of EMEA was formed. The team analyzed and classified costs into direct and indirect. Both cost categories are being allocated to individual customers, by means of two different methods. Indirect cost are allocated yearly, based on the kilograms of the product mix each customer is expected to order.
Direct costs, firstly were linked to relevant activities and cost drivers. Secondly, a tariff per activity was calculated, based on forecasted volumes. To add flexibility in direct cost allocation, ranges of tariff validity were determined. Finally, extensive model validation proved that the model indeed generated reliable allocation results, as presented in standardized monthly reporting.

Benefits

  • There is a better underpinned view and discussion concerning the actual influence able costs which the supplier (cost center) allocates to their customers.
  • The level of acceptance of the ABC model is very high due to the transparency (one set of data!) and the joined approach during the design of the model.
  • The final result is a management tool which can be used for much more the allocation of cost, like:
    • Providing internal and external transparency on actual cost and efficiency of the IDC process
    • Optimization of the Supply Chain in terms of expected unit cost
    • Internal process and efficiency improvement of the warehouse
    • What-if analysis as starting point of a business case
Twitter
  • Rob Besten en Tim van Lohuizen supply chain adviseurs bij Groenewout https://t.co/C8vaaWiEov via  @Consultancy_nl  4 months ago
  • Welkom nieuwe collega's: Tim van Lohuizen en Rob Besten. Specialisaties: modelleren, operations research en logisti… https://t.co/y3nzTaydQB 5 months ago
  • Per 1 april '19 neemt Alain de rol van Managing Director over van Mari van Kuijk, die sinds 2007 deze rol vervulde.… https://t.co/eAbdd6fAMq 5 months ago
50 years of experience

Consulting firm with over 50 years of experience.


European database

Availability of a European logistics database with benchmark figures on transportation and warehouse costs.


Network design

Full scope expertise on network design, as well as warehouse design (conceptual layout, logistics - and storage equipment) and logistics building design (engineering and investment calculations).


Implementation support

Ability to support implementation of new logistics concepts (70% of Groenewout revenue is with existing customers in follow-up/implementation projects.


Extensive knowledge

Extensive operational knowledge, hands-on, pragmatic and bottom-up approach.


Contact Us

We're not around right now. But you can send us an email and we'll get back to you, asap.

Not readable? Change text. captcha txt

Start typing and press Enter to search