Transport cost model

April 6, 2016 452

trespa

Description
Trespa International BV is a world leader in development, manufacture and supply of high quality panels for exterior cladding, decorative facades and interior surfaces.

Opportunities
Panels are transported from the factory in Weert across Europe and further. Transportation is an important cost factor. Trespa wants to make transport costs more transparant and wants to identify potential cost savings.

Solution
Groenewout developed a tool in MS Access, that was filled with historical shipment and cost information for 3 years.
The tool has two main sections:

  • Queries on historical data, for example truck fill rates, difference in costs between various modalities, number of full and broken pallets.
  • Calculating the cost impact of opportunities, for example one delivery per two weeks instead of one per week, surcharge for broken pallets, combining small ship-to’s into one big delivery, comparing transport rates from different carriers

The tool is handed over to Trespa and can be kept up-to-date with new shipment and cost data.

Benefits

  • Powerful, customized tool, developed by logistics experts
  • Easy to keep up-to-date: standard SAP downloads can be imported
  • Insight in transport costs and differences between countries / customers
  • Identification and quantification of cost saving opportunities
Twitter
Unique Selling Points
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.

Start typing and press Enter to search