Spreadsheet: 020f2036-a9eb-4fb9-b315-bedfb0224248
Sheet: QtrTLC-Shanghai-2012

Quarterly costs of transporting Brazilian soybeans to Shanghai, China
 | ––––––––––––––––––––––––– 2012 –––––––––––––––––––––––––
 | 1st qtr | 2nd qtr | 3rd qtr | 4th qtr | Avg | 1st qtr | 2nd qtr | 3rd qtr | 4th qtr | Avg
 | [NAME]                                                                 --US$/mt-- |  |  |  |  | [NAME]                                                           --US$/mt--
Truck | 117.5196130220183 | 110.0695767147524 | 109.7320030672298 | 109.8010430697393 | 111.7805589684349 | 114.4425366571746 | 105.3275855446961 | 108.0740961003776 | 107.8802898531131 | 108.9311270388403
Ocean | 46.62 | 51.35 | 50.42 | 50.42 | 49.7025 | 52.32 | 57.63 | 55.42 | 55.42 | 55.19750000000001
Total transportation | 164.1396130220183 | 161.4195767147524 | 160.1520030672298 | 160.2210430697393 | 161.4830589684349 | 166.7625366571746 | 162.9575855446961 | 163.4940961003776 | 163.3002898531131 | 164.1286270388404
Farm price3 | 377.7037988997299 | 448.2892315798179 | 570.6588273992194 | 536.5985697344234 | 483.3126069032977 | 377.7037988997299 | 448.2892315798179 | 570.6588273992194 | 536.5985697344234 | 483.3126069032977
Landed cost | 541.8434119217482 | 609.7088082945702 | 730.8108304664491 | 696.8196128041627 | 644.7956658717326 | 544.4663355569045 | 611.246817124514 | 734.1529234995969 | 699.8988595875365 | 647.441233942138
Transport % of landed cost | 30.29281327604717 | 26.47486382331635 | 21.91428977113144 | 22.99318792491688 | 28.38383854968176 | 30.62862215101002 | 26.65986651861794 | 22.26976027297225 | 23.33198398827925 | 25.72255823271987
 | [NAME]                                                        --US$/mt-- |  |  |  |  | North Central PR1 - Paranagua2                                             --US$/mt--
Truck | 85.78601475705331 | 79.44448532834068 | 85.98672375474521 | 86.48046755050267 | 84.42442284766047 | 34.78968721321642 | 33.98933898158802 | 35.71760240330668 | 34.54369767455151 | 34.76008156816566
Ocean | 46.62 | 51.35 | 50.42 | 50.42 | 49.7025 | 52.32 | 57.63 | 55.42 | 55.42 | 55.19750000000001
Total transportation | 132.4060147570533 | 130.7944853283407 | 136.4067237547452 | 136.9004675505027 | 134.1269228476605 | 87.10968721321643 | 91.61933898158802 | 91.13760240330669 | 89.96369767455151 | 89.95758156816565
Farm price3 | 377.7037988997299 | 448.2892315798179 | 570.6588273992194 | 536.5985697344234 | 483.3126069032977 | 428.7959740184131 | 475.6889657418677 | 593.1956291814504 | 557.5419217847324 | 513.8056226816159
Landed cost | 510.1098136567832 | 579.0837169081585 | 707.0655511539646 | 673.4990372849261 | 617.4395297509582 | 515.9056612316296 | 567.3083047234556 | 684.3332315847571 | 647.5056194592839 | 603.7632042497816
Transport % of landed cost | 25.95637472799924 | 22.58645537931511 | 19.29194874960644 | 20.32675029535142 | 22.04038228806806 | 16.88480932836793 | 16.14983214924898 | 13.31772274046273 | 13.8938867819677 | 15.06156275001183
 | South GO1 - Santos2                                                                   --US$/mt-- |  |  |  |  | Northwest RS1 - Rio Grande2                                                   --US$/mt--
Truck | 58.11020144647308 | 52.81933751166191 | 55.75961354208405 | 53.38726291206655 | 55.0191038530714 | 27.26881161950859 | 26.01559165752457 | 25.30176762735261 | 24.7286508442006 | 25.82870543714659
Ocean | 46.62 | 51.35 | 50.42 | 50.42 | 49.7025 | 47.92 | 52.78 | 49.02 | 49.02 | 49.685
Total transportation | 104.7302014464731 | 104.1693375116619 | 106.179613542084 | 103.8072629120666 | 104.7216038530714 | 75.18881161950858 | 78.79559165752457 | 74.32176762735261 | 73.7486508442006 | 75.5137054371466
Farm price3 | 401.5793742001446 | 428.3952149125616 | 566.9069718010784 | 522.3254544940896 | 479.8017538519686 | 405.0666632754551 | 448.4684184422827 | 557.8985209306617 | 521.4285244256129 | 483.2155317685031
Landed cost | 506.3095756466177 | 532.5645524242235 | 673.0865853431624 | 626.1327174061562 | 584.5233577050399 | 480.2554748949636 | 527.2640100998073 | 632.2202885580143 | 595.1771752698135 | 558.7292372056497
Transport % of landed cost | 20.68501298098503 | 19.55994574507168 | 15.77503041275887 | 16.57911494261199 | 18.14977602035689 | 15.65600301296993 | 14.94423858791522 | 11.75567582572647 | 12.39104150974336 | 13.68673973408875
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