Thesis/Capstone
Publication Date
Authored by
Niklas Blomberg, Ramon Gras Alomà
Abstract

Airfreight forwarding companies must develop accurate forecasting tools to analyze the suitability and attractiveness of each incoming bidding process, to decide whether to participate in a tender and how to define the optimal commercial strategy. The “1:6” weight/volume ratio establishes that whenever the cargo ratio is different from 1:6 (1m3:167 kg) forwarders must pay the higher rate: either volume or weight. Given the main constraints in terms of volumetric capacity and maximum weight per volumetric unit, the most profitable business opportunities consist of combining in the same load compatible products with different densities. The main target is to come close as possible to the desired 1:6 ratio, to minimize the average price per load. To remain competitive, airfreight forwarding firms must improve their consolidation techniques, to combine in the same load cargo with compatible densities. The availability of robust analytical resources will allow airfreight industry companies to improve their rate of success, in terms of enhancing both efficiency (by increasing air volumes and densities) and profitability (by minimizing the Net Achieved Rate). This thesis develops an analytical model based on meaningful metrics to provide airfreight forwarders with an accurate and solid forecasting tool to select the bids under consideration that best match with their current portfolio in terms of air volume usage for a given origin-destination lane. It also predicts breakeven rates to increase profitability by minimizing the Net Achieved Rate. Furthermore, the model provides a series of metrics and visualization tools to help air freight forwarding companies to improve their understanding of their current portfolio for a given origin-destination lane and define their commercial strategy with respect to air freight cargo tenders.

Authors: Niklas Blomberg and Ramon Gras Alomà
Advisor: Dr. Jarrod Goentzel