Spreadsheet: 132fcee1-6a05-4f61-ba67-c65d4993791a
Sheet: TLC-Hamburg

Cost of transporting  soybeans from Brazil to Hamburg, Germany
 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | % Change 11-12 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | % Change 11-12
 | [NAME]                                                                                                                                   --US$/mt-- |  |  |  |  |  |  |  | Northwest RS1 - Rio Grande2                                                                                                                                          --US$/mt--
Truck | 79.46 | 97.67 | 115.7404466010729 | 96.99535116064675 | 116.7755341956574 | 123.3060300559558 | 111.7805589684349 |  | 16.16 | 21.82 | 22.29146946394532 | 24.50477478710078 | 28.17998057926268 | 37.53587379653438 | 25.82870543714659
Ocean | 46.76 | 73.01 | 52.35916290676066 | 32.48333333333333 | 33.6275 | 34.6525 | 31.75 |  | 45.03 | 71.73 | 54.30410515254744 | 33.79166666666666 | 36.03 | 36.115 | 33.145
Total transportation | 126.22 | 170.68 | 168.0996095078335 | 129.4786844939801 | 150.4030341956574 | 157.9585300559558 | 143.5305589684349 |  | 61.18 | 93.55 | 76.59557461649277 | 58.29644145376744 | 64.20998057926268 | 73.65087379653438 | 58.97370543714659
Farm price3 | 164.88 | 233.82 | 358.9949288172314 | 324.3448319465148 | 318.1501552360035 | 392.0993903267885 | 483.3126069032977 |  | 210.34 | 267.06 | 394.6604943956467 | 359.5075899453747 | 344.9020639601387 | 415.8652822147749 | 483.2155317685031
Landed cost | 291.11 | 404.5 | 527.094538325065 | 453.8235164404949 | 468.5531894316609 | 550.0579203827443 | 626.8431658717326 |  | 271.53 | 360.61 | 471.2560690121394 | 417.8040313991422 | 409.1120445394014 | 489.5161560113092 | 542.1892372056498
Transport % of landed cost | 43.4 | 42.5 | 31.64662453076261 | 28.6662033405016 | 32.58767037185398 | 28.73538477618437 | 23.28427564261485 |  | 22.3 | 26.1 | 16.05161146692964 | 13.98078862681296 | 15.81792809845068 | 15.0402828433757 | 11.03497691050298
 | North Center PR1 - Paranagua2                                                                                                                                                                               --US$/mt-- |  |  |  |  |  |  |  | South GO1 - Santos2                                                                                                                                                                          --US$/mt--
Truck | 21.31 | 32.36 | 33.59540044054545 | 27.36511035710329 | 34.51119048011095 | 39.53953840911993 | 34.76008156816566 |  | 43.56 | 50.47 | 80.61126128421581 | 50.83404948072974 | 64.7128191365784 | 63.91675865353095 | 55.0191038530714
Ocean | 45.76 | 71.05 | 53.81410515254743 | 33.34333333333333 | 35.0825 | 34.945 | 33.795 |  | 46.76 | 73.01 | 52.35916290676066 | 32.48333333333333 | 33.6275 | 34.6525 | 31.75
Total transportation | 67.07 | 103.42 | 87.40950559309289 | 60.70844369043662 | 69.59369048011095 | 74.48453840911993 | 68.55508156816566 |  | 90.32 | 123.48 | 132.9704241909765 | 83.31738281406308 | 98.34031913657842 | 98.56925865353095 | 86.7691038530714
Farm price3 | 213.81 | 281.14 | 399.3045502096033 | 372.4622707926709 | 350.4357336466817 | 431.6612212678666 | 513.8056226816159 |  | 189.63 | 268.65 | 358.9949288172314 | 338.3134324339076 | 324.2695215738101 | 412.8924884393784 | 479.8017538519686
Landed cost | 280.88 | 384.56 | 486.7140558026961 | 433.1707144831075 | 420.0294241267926 | 506.1457596769866 | 582.3607042497815 |  | 279.96 | 392.12 | 491.9653530082078 | 421.6308152479707 | 422.6098407103884 | 511.4617470929094 | 566.5708577050399
Transport % of landed cost | 23.8 | 27 | 17.85640309063568 | 14.08469635159475 | 16.76991510149488 | 14.73911284757487 | 11.90438924524287 |  | 32.2 | 31.8 | 26.94103453676431 | 19.81749548848881 | 23.56151939927826 | 19.27625104288985 | 15.55629622705577
1Producing regions: RS = Rio Grande Do Sul, MT= [NAME], GO = Goiás, PR = Paraná
2Export ports
3Source: Companhia Nacional de Abastecimento (CONAB) www.conab.gov.br
Source: ESALQ/ USP (University of São Paulo, Brazil) and USDA/AMS