Spreadsheet: 0950960b-495f-4f17-ad56-463d2b074d2e
Sheet: TLC-Shanghai

Cost of transporting  soybeans from Brazil to Shanghai, China
 | 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 | 38.93723442858654 | 25.82870543714659
Ocean | 57.31 | 82.83 | 70.3770303177845 | 58.78333333333333 | 55.84249999999999 | 50.5025 | 49.7025 |  | 55.81 | 81.56 | 72.0770303177845 | 59.4175 | 58.21250000000001 | 51.095 | 49.685
Total transportation | 136.77 | 180.51 | 186.1174769188574 | 155.7786844939801 | 172.6180341956574 | 173.8085300559558 | 161.4830589684349 |  | 71.97 | 103.37 | 94.36849978172982 | 83.92227478710078 | 86.39248057926267 | 90.03223442858655 | 75.5137054371466
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 | 301.65 | 414.33 | 545.1124057360888 | 480.1235164404948 | 490.7681894316609 | 565.9079203827444 | 644.7956658717326 |  | 282.31 | 370.43 | 489.0289941773765 | 443.4298647324755 | 431.2945445394014 | 505.8975166433614 | 558.7292372056497
Transport % of landed cost | 45.4 | 43.9 | 34.1342336158058 | 32.62969909875894 | 38.6481318206919 | 30.64497745028939 | 28.38383854968176 |  | 25.2 | 28.1 | 19.36948514716915 | 18.99525941070982 | 20.14652565776714 | 17.81783692897812 | 13.68673973408875
 | North Central 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 | 55.33398832406679 | 50.83404948072974 | 64.7128191365784 | 63.91675865353095 | 55.0191038530714
Ocean | 56.31 | 80.81 | 71.66164837334006 | 59.00125 | 58.92 | 57.32000000000001 | 55.19750000000001 |  | 57.31 | 82.83 | 70.3770303177845 | 58.78333333333333 | 55.84249999999999 | 50.5025 | 49.7025
Total transportation | 77.62 | 113.18 | 105.2570488138855 | 86.3663603571033 | 93.43119048011096 | 96.85953840911995 | 89.95758156816565 |  | 100.87 | 133.3 | 125.7110186418513 | 109.6173828140631 | 120.5553191365784 | 114.419258653531 | 104.7216038530714
Farm price3 | 213.81 | 281.14 | 399.3050080156343 | 372.4622707926709 | 350.4357336466817 | 431.6612212678666 | 513.8056226816159 |  | 189.63 | 268.65 | 373.1267843094359 | 338.3134324339076 | 324.2695215738101 | 412.8924884393784 | 479.8017538519686
Landed cost | 291.43 | 394.32 | 504.5620568295199 | 458.8286311497742 | 443.8669241267926 | 528.5207596769865 | 603.7632042497816 |  | 290.5 | 401.95 | 498.8378029512872 | 447.9308152479707 | 444.8248407103885 | 527.3117470929094 | 584.5233577050399
Transport % of landed cost | 26.5 | 28.9 | 21.02872470155646 | 18.91483746163184 | 21.22967813503373 | 18.36050499047511 | 15.06156275001183 |  | 34.6 | 33.5 | 25.36984861306989 | 24.57561670096687 | 27.37381307061096 | 21.71616649439781 | 18.14977602035689
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