| 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 1 | FAS Exports 2 | | | | | | | Difference | | | | | | | | | | | 32.563 | | | | | 2007/08 | 1,263 | 1196 | | 66 | | | | | | | | | | | | | | | | | | | | | | 25.973 | | | | | 2008/09 | 1,015 | 954 | | 61 | | | | | | | | | | | | | | | | | | | | | | 21.686 | | | | | 2009/10 | 879 | 797 | | 83 | | | | | | | | | | | | | | | | | | | | | | 33.438 | | | | | 2010/11 | 1,291 | 1228 | | 63 | | | | | | | | | | | | | | | | | | | | | | 26.627 | | | | | 2011/12 | 1,051 | 978 | | 73 | | | | | | | | | | | | | | | | | | | | | | 26.348 | | | | | 2012/13 | 1,012 | 968 | | 44 | | | | | | | | | | | | | | | | | | | | | | 30.133 | | | | | 2013/14 | 1,176 | 1107 | | 69 | | | | | | | | | | | | | | | | | | | | | | 22.622 | | | | | 2014/15 | 854 | 831 | | 23 | | | | | | | | | | | | 60.39 | Average difference in Myn bushels | | | | | | |
I updated the weekly numbers.. | All Wheat | | | | | | 1998 | Total Shipments | | | | | 1999 | 25.5 | | | | | | | 2000 | 25.8 | | | | | | | 2001 | 24.1 | | | | | | | 2002 | 20.8 | | | Wheat | | | | 2003 | 29.6 | | | 17-Dec | | New | | 2004 | 26.6 | | | Booked | Crop | | 2005 | 25.3 | shipped | | | Book | | 2006 | 22.9 | | sales | | | | 2007 | 32.6 | | | | Add Ship | | 2008 | 26.0 | | | | | | | 2009 | 21.7 | 11.8 | 3.8 | 15.6 | 6.1 | 0.1 | | 2010 | 33.4 | 16.3 | 8.9 | 25.2 | 8.2 | 0.4 | | 2011 | 26.6 | 14.7 | 4.4 | 19.1 | 7.5 | 0.1 | | 2012 | 26.3 | 13.2 | 5.5 | 18.7 | 7.6 | 0.1 | | 2013 | 30.1 | 18.7 | 5.5 | 24.2 | 5.9 | 0.2 | | 2014 | 22.60 | 13.2 | 5.0 | 18.2 | 4.4 | 0.3 | | 2015 | | 10.9 | 4.4 | 15.3 | | 0.3 | | | | | | 21.9 | 6.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 | | Grain | Flour | Products | Total | | | | 1989/90 | 1,178,464 | 53,450 | 1,356 | 1,233,269 | | 54,805 | | 1990/91 | 1,025,677 | 40,464 | 1,797 | 1,067,938 | | 42,261 | | 1991/92 | 1,228,636 | 51,176 | 1,405 | 1,281,217 | | 52,581 | | 1992/93 | 1,297,022 | 54,777 | 3,162 | 1,354,961 | | 57,939 | | 1993/94 | 1,178,059 | 48,033 | 1,729 | 1,227,822 | | 49,763 | | 1994/95 | 1,124,657 | 61,807 | 1,791 | 1,188,255 | | 63,598 | | 1995/96 | 1,206,051 | 33,189 | 1,904 | 1,241,143 | | 35,092 | | 1996/97 | 974,296 | 25,472 | 1,753 | 1,001,522 | | 27,225 | | 1997/98 | 1,013,012 | 24,393 | 2,985 | 1,040,391 | | 27,378 | | 1998/99 | 1,006,591 | 35,270 | 3,516 | 1,045,377 | | 38,786 | | 1999/00 | 1,038,543 | 43,046 | 4,910 | 1,086,499 | | 47,956 | | 2000/01 | 1,024,254 | 34,199 | 3,587 | 1,062,041 | | 37,787 | | 2001/02 | 932,081 | 26,668 | 4,523 | 963,273 | | 31,191 | | 2002/03 | 821,783 | 19,774 | 7,504 | 849,061 | | 27,278 | | 2003/04 | 1,132,944 | 16,490 | 8,890 | 1,158,324 | | 25,380 | | 2004/05 | 1,046,977 | 10,854 | 8,079 | 1,065,910 | | 18,934 | | 2005/06 | 982,101 | 9,959 | 10,721 | 1,002,781 | | 20,680 | | 2006/07 | 893,969 | 11,412 | 10,340 | 915,721 | | 21,752 | | 2007/08 | 1,234,589 | 16,780 | 9,922 | 1,261,292 | | 26,703 | | 2008/09 | 993,058 | 11,542 | 10,814 | 1,015,415 | | 22,357 | | 2009/10 | 850,079 | 19,755 | 9,462 | 879,297 | | 29,217 | | 2010/11 | 1,268,035 | 15,343 | 8,068 | 1,291,446 | | 23,411 | | 2011/12 | 1,030,459 | 12,731 | 7,902 | 1,051,091 | | 20,632 | | 2012/13 | 988,805 | 15,252 | 8,008 | 1,012,066 | | 23,260 | | 2013/14 | 1,155,053 | 12,816 | 7,972 | 1,175,841 | | 20,788 | | 2014/15 | 832,070 | 14,509 | 7,692 | 854,271 | | 22,201 | | 2015/16 | 335,018 | 6,686 | 3,108 | 344,812 | | 9,793 | * Through first 5 months of Marketing Year |
Edited by JonSCKs 12/25/2015 16:24
|