Spreadsheet: 0c237524-f959-4587-839c-2f8c43968d4a
Sheet: QtrTruckrates2012

Quarterly truck rates for selected Brazilian soybean export transportation routes, 2012
Route # | Origin1                                                                          (reference city) | Destination | Distance                  (miles)2 | Share (%)3 | Freight Price (US$)
 |  |  |  |  | 1st qtr | 2nd qtr | 3rd qtr | 4th qtr | Avg
 |  |  |  |  | ––– (per 100 miles)4 –––
1 | Northwest RS5 (Cruz Alta) | Rio Grande | 288 | 13.11741038792528 | 9.468337367884926 | 9.033191547751587 | 8.785335981719657 | 8.586337098680763
2 | North MT (Sorriso) | Santos | 1190 | 11.45155522938906 | 9.875597732942715 | 9.249544261743898 | 9.221176728338639 | 9.226978409221793
3 | North MT (Sorriso) | Paranaguá | 1262 | 10.79821768856813 | 9.068346803262646 | 8.346084433018712 | 8.563716014292995 | 8.548358942401988
4 | South GO (Rio Verde) | Santos | 587 | 5.660414214371654 | 9.899523244714324 | 8.998183562463698 | 9.499082375142086 | 9.09493405657011
5 | South GO (Rio Verde) | Paranaguá | 726 | 4.576670997019506 | 7.595199944785861 | 6.957104769172029 | 7.302007974153102 | 7.31497779166997
6 | North Central PR (Londrina) | Paranaguá | 268 | 4.057066183535792 | 12.98122657209568 | 12.68258917223434 | 13.32746358332339 | 12.8894394308028
7 | Western Central PR ([NAME]) | Paranaguá | 311 | 3.400580417444838 | 10.32380047554259 | 9.036843283933019 | 10.18555117622918 | 10.35539215891226
8 | Triangle MG (Uberaba) | Santos | 339 | 3.153926067347936 | 14.5148088051471 | 12.77511238884311 | 13.02456783326429 | 12.82730274753914
9 | West PR (Assis Chateaubriand) | Paranaguá | 377 | 3.555854562634733 | 9.911181430462507 | 9.794811436181552 | 10.47185391281528 | 10.54938188848835
10 | West Extreme BA (São Desidério) | Salvador | 535 | 5.530610958579285 | 11.1599206234088 | 10.76878046687887 | 10.85719734980011 | 10.58115152295557
11 | Southeast MT (Primavera do Leste) | Santos | 901 | 3.285399973494099 | 9.521200305999256 | 8.817367960970108 | 9.54347655435574 | 9.598276087736146
12 | Southeast MT (Primavera do Leste) | Paranaguá | 975 | 3.036046539608393 | 9.480076517900956 | 7.184864926994308 | 7.471117449421534 | 7.424713146081761
13 | Southwest MS (Maracaju) | Paranaguá | 612 | 3.343778347521808 | 10.16436015700887 | 8.878756320836517 | 9.64721238296818 | 9.785904282818214
14 | Southwest MS (Maracaju) | Santos | 652 | 3.138638571600225 | 10.61192046709887 | 9.95526228833728 | 10.44954186691416 | 10.59872016734062
15 | West PR (Assis Chateaubriand) | Santos | 550 | 2.437376672933262 | 10.43877597808862 | 10.26608885597494 | 9.911227237538899 | 9.610579305130038
16 | East GO (Cristalina) | Santos | 585 | 1.930551337799572 | 10.62727740424516 | 10.22901497421213 | 10.83959305780115 | 11.19705940405192
17 | North PR (Cornélio Procópio) | Paranaguá | 306 | 2.057426266259 | 9.86232552531853 | 9.71597762208751 | 9.847657772781952 | 9.591694515997409
18 | Eastern Central PR ([NAME]) | Paranaguá | 130 | 2.432731202521526 | 17.97409448150801 | 17.00098344571932 | 19.11083115763282 | 19.3637008939106
19 | South Central PR (Guarapuava) | Paranaguá | 204 | 2.489222763988785 | 14.48982903832865 | 16.5771009810929 | 16.41497363664951 | 15.99093699148518
20 | North Central MS (São Gabriel do [NAME]) | Santos | 720 | 1.952546696547347 | 9.227610620267368 | 7.778374633925136 | 8.901380052281523 | 9.313384933926637
21 | Ribeirão Preto SP (Guairá) | Santos | 314 | 0 | 12.38266020349319 | 11.75838429439229 | 11.98344617270101 | 11.23754780883413
22 | Northeast MT (Canarana) | Santos | 950 | 2.184610363248795 | 11.25969716888003 | 10.18196980690453 | 9.905835441186515 | 9.626002363189588
23 | East MS ([NAME] do Sul) | Santos | 607 | 0 | 10.20213169325812 | 9.375675475333168 | 10.20556666689858 | 11.65283110403528
24 | Northeast MT (Canarana) | Paranaguá | 1075 | 1.930585902405912 | 10.18666282331851 | 9.211896977477393 | 8.601025705237774 | 4.275947338307838
25 | Western Central RS (Tupanciretã) | Rio Grande | 273 | 2.197824333096715 | 12.46257657879362 | 11.21358971862899 | 10.83326772495415 | 10.67791919378969
26 | Southwest PR(Chopinzinho) | Paranaguá | 291 | 2.280954322158343 | 13.47900055288962 | 12.55110667483005 | 12.60806548543695 | 12.27205680860713
 | Average |  | 578 | 100 | 10.50343985091261 | 9.817628020477823 | 10.07549946446419 | 9.902360032300807
1Although each origin region comprises several cities, the main city is considered as a reference to establish the freight price; na = not available
2Distance from the main city of the considered region to the mentioned ports
3Share is measured as a percentage of total production
4US$ per metric ton (average monthly exchange rate from “Banco Central do Brasil” was used to convert Brazilian reais to the U.S. dollar)
5RS = Rio Grande do Sul, MT= [NAME], GO = Goiás, PR = Paraná, MG = [NAME],  BA = [NAME], MS = [NAME] do Sul, SP = São Paulo
Source: ESALQ/USP (University of São Paulo, Brazil) and USDA/AMS