AgTalk Home
AgTalk Home
Search Forums | Classifieds (58) | Skins | Language
You are logged in as a guest. ( logon | register )

Census vs FAS Wheat exports.
View previous thread :: View next thread
   Forums List -> Market TalkMessage format
 
JonSCKs
Posted 12/25/2015 15:51 (#4986427)
Subject: Census vs FAS Wheat exports.


Argh.. letting the Christmas pudding settle while updating the export numbers.  I've often wondered why the trade does not make more of the difference between the Census Wheat export numbers and the Foreign Ag Service numbers which are the ones reported weekly.  ( http://apps.fas.usda.gov/export-sales/wkHistData.htm )

It's the Census numbers that are used in the WASDE.. and they differ than the FAS.. by.. quite a bit.  I looked them up this afternoon and found the difference.

( http://www.ers.usda.gov/data-products/wheat-data.aspx#25171 )

       
 1 Source:  U.S. Department of Commerce, U.S. Census Bureau
     Includes flour and selected other products expressed in grain equivalent bushels
       
 2 Source:  USDA, Foreign Agricultural Service, U.S. Export Sales.
       
  Census 1FAS Exports 2 
     Difference
       
   32.563   
 2007/081,2631196 66 
      
      
      
  25.973   
 2008/091,015954 61 
      
      
      
  21.686   
 2009/10879797 83 
      
      
      
  33.438   
 2010/111,2911228 63 
      
      
      
  26.627   
 2011/121,051978 73 
      
      
      
  26.348   
 2012/131,012968 44 
      
      
      
  30.133   
 2013/141,1761107 69 
      
      
      
  22.622   
 2014/15854831 23 
      
    60.39Average difference in Myn bushels
      

 

I updated the weekly numbers..

 All Wheat     
1998Total Shipments    
199925.5      
200025.8      
200124.1      
200220.8  Wheat   
200329.6  17-Dec New 
200426.6    BookedCrop 
200525.3shipped  Book 
200622.9 sales   
200732.6   Add Ship 
200826.0      
200921.711.83.815.66.10.1 
201033.416.38.925.28.20.4 
201126.614.74.419.17.50.1 
201226.313.25.518.77.60.1 
201330.118.75.524.25.90.2 
201422.6013.25.018.24.40.3 
2015 10.94.415.3 0.3 
    21.96.6  
      0.2 
     6.5  
projected  805.07   
pace       
        
 21.8  800   
        
    5 myn bu difference
        

Anywho the projected pace.. at 805 myn bushels plus the average difference between the Census and the FAS.. of 60.4 would put the expected WASDE exports to come in around 865.4 vs the 800 currently in the WASDE.. fwiw. 

Cheers.

Edit add:  I pulled out the Flour and Product exports from the Census data for review.  Note the Census Grain Exports are different than the FAS Grain exports.. so it's not correct to simply add only the Flour and Product exports as the Census also seems to gain on Grain exports.. (containers..??)  Anywho it's this TOTAL column that is used in the WASDE below... and how it gets there.. Note for the Current year the Census data is only updated through October.

( http://www.ers.usda.gov/data-products/wheat-data.aspx#25171 )

In 1,000 bushels.. Grain equivalent.

 Census data     
      Flour + Products
 GrainFlourProductsTotal   
1989/90     1,178,46453,4501,3561,233,269 54,805 
1990/911,025,67740,4641,7971,067,938 42,261 
1991/921,228,63651,1761,4051,281,217 52,581 
1992/931,297,02254,7773,1621,354,961 57,939 
1993/941,178,05948,0331,7291,227,822 49,763 
1994/951,124,65761,8071,7911,188,255 63,598 
1995/961,206,05133,1891,9041,241,143 35,092 
1996/97974,29625,4721,7531,001,522 27,225 
1997/981,013,01224,3932,9851,040,391 27,378 
1998/991,006,59135,2703,5161,045,377 38,786 
1999/001,038,54343,0464,9101,086,499 47,956 
2000/011,024,25434,1993,5871,062,041 37,787 
2001/02932,08126,6684,523963,273 31,191 
2002/03821,78319,7747,504849,061 27,278 
2003/041,132,94416,4908,8901,158,324 25,380 
2004/051,046,97710,8548,0791,065,910 18,934 
2005/06982,1019,95910,7211,002,781 20,680 
2006/07893,96911,41210,340915,721 21,752 
2007/081,234,58916,7809,9221,261,292 26,703 
2008/09993,05811,54210,8141,015,415 22,357 
2009/10850,07919,7559,462879,297 29,217 
2010/111,268,03515,3438,0681,291,446 23,411 
2011/121,030,45912,7317,9021,051,091 20,632 
2012/13988,80515,2528,0081,012,066 23,260 
2013/141,155,05312,8167,9721,175,841 20,788 
2014/15832,07014,5097,692854,271 22,201 
2015/16335,0186,6863,108344,812 9,793* Through first 5 months of Marketing Year


Edited by JonSCKs 12/25/2015 16:24
Top of the page Bottom of the page


Jump to forum :
Search this forum
Printer friendly version
E-mail a link to this thread

(Delete cookies)