Finally got time to dust off my export tables.. and update. Even I was surprised that we are AHEAD of where we NEED to be EVEN IN WHEAT to hit USDA's numbers.. (sorghum is the only one behind..) From the data source: http://apps.fas.usda.gov/export-sales/wkHistData.htm Edit let me explain how this works.. the Total Shipments column is what we did each year.. For Instance in 2010 we moved 39.99 mmt's of Soybeans.. by THIS DATE.. 10/28/10 we had shipped 8.5 mmt's with 20.5 mmt's on the books as sold.. thus shipped + sold to be shipped = 29 mmt's.. thus we SHIPPED an ADDITIONAL 39.99 - 29. = 10.99 mmt's throughout the REST of the YEAR.. I AVERAGE 2009's 16.3 mmt's 10's 10.99, 11's 18.2, 12's 10.4 and 2013's 11.3 to get 13.438 mmt's of EXPECTED additional Shipments to TODAY's 35.7 + 13.438 = 49.138 mmt's or 1,805 myn bushel EXPORT PACE. (clear as mud?) and do this for all the rest of the commodities listed below.. 1997 | | 24.5 | | | | | | 37.2 | | | | | | All Wheat | | | | | | | | | 1998 | | 22.9 | | | | | | 49.6 | | | | | | Total Shipments | | | | | | | | 1999 | | 27 | | | | | | 48.8 | | | | | | 25.5 | | | | | | | | | | 2000 | | 27.6 | | | | | | 47.7 | | | | | | 25.8 | | | | | | | | | | 2001 | | 29.9 | | | | | | 48 | | | | | | 24.1 | | | | | | | | | | 2002 | | 29.1 | | | Soybeans | | 39.9 | shipped | Corn | | | 20.8 | | | Wheat | | | | shipped | Sorghum | 2003 | | 24.2 | | | 30-Oct | | | 48.2 | | sales | 30-Oct | | | 29.6 | | | 30-Oct | | | 4.78 | | sales | 30-Oct | 2004 | | 29.97 | | | Booked | | 45.4 | | | Booked | Add Ship | 26.6 | | | Booked | | 4.37 | | | Booked | 2005 | | 25.5 | shipped | | | | 54.3 | | | | | | 25.3 | shipped | | | | 4.33 | | | | 2006 | | 30.3 | | sales | | | | 54 | 8.9 | 10.9 | 19.8 | 34.2 | | 22.9 | | sales | | | | 3.34 | 0.57 | 1.07 | 1.64 | 2007 | | 30.4 | | | | Add Ship | 59.97 | 9 | 18.8 | 27.8 | 32.17 | | 32.6 | | | | Add Ship | 6.19 | 1.57 | 2.73 | 4.3 | 2008 | | 33.9 | | | | | | 45.2 | 6.9 | 10.2 | 17.1 | 28.1 | | 26.0 | | | | | | 2.64 | 0.52 | 0.57 | 1.09 | 2009 | | 39.6 | 5.5 | 17.8 | 23.3 | 16.3 | | 48.3 | 7.7 | 10.1 | 17.8 | 30.5 | | 21.7 | 9.1 | 4.1 | 13.2 | 8.5 | | 3.24 | 0.43 | 0.71 | 1.14 | 2010 | | 39.99 | 8.5 | 20.5 | 29.0 | 10.99 | | 45.2 | 7.4 | 12.8 | 20.2 | 25 | | 33.4 | 12.4 | 7.6 | 20.0 | 13.4 | | 3.33 | 0.5 | 0.69 | 1.19 | 2011 | | 36.7 | 5.3 | 13.2 | 18.5 | 18.2 | | 37.9 | 5.7 | 15.4 | 21.1 | 16.8 | | 26.6 | 12.0 | 4.2 | 16.2 | 10.4 | | 0.95 | 0.26 | 0.26 | 0.52 | 2012 | | 36.2 | 8.1 | 17.7 | 25.8 | 10.4 | | 18 | 3.7 | 7.2 | 10.9 | 7.1 | | 26.3 | 10.4 | 4.3 | 14.7 | 11.6 | | 1.34 | 0.39 | 0.26 | 0.65 | 2013 | | 44.5 | 9.1 | 24.1 | 33.2 | 11.3 | | 47.4 | 4.8 | 17.1 | 21.9 | 25.5 | | 30.1 | 15.7 | 5.2 | 20.9 | 9.2 | | 4.7 | 0.54 | 1 | 1.54 | 2014 | | | 10.4 | 25.3 | 35.7 | | | | 6.9 | 12.3 | 19.2 | | | | 10.6 | 4.80 | 15.4 | | | | 1.21 | 1.92 | 3.13 | | | | | | 49.138 | 13.438 | | | | | 47.9 | 28.7 | | | | | 26.02 | 10.6 | | | | | 5.1 | | | | | | | | | | | | | | | | | | | | | | | | | | projected | | 1805.0 | | projected | | 1886.54 | | projected | | 955.80 | | | projected | | 200.72 | | pace | | | | | pace | | | | | pace | | | | | | pace | | | | | | updated WASDE | | | | | | | | | | | | | | | | | | | | USDA | | 46.83 | | | 1720 | USDA | | 44.47 | | | 1750 | USDA | | 25.2 | | | 925 | | | USDA | 5.85 | | 230 | | | | | | | | | | | | | | | | | | | | | | | | | | Difference | | 85 | myn bu | | | | | 136 | myn bu | | | | | 31 | myn bu | | | | -30 | | | | | | | | | | | | | | | | | | | | | | | | |
In soybeans we are 85 myn bu ahead of pace.. 136 myn bu ahead on Corn and 31 myn bu ahead on wheat of where we need to be to hit USDA's latest WASDE numbers updated yesterday. We're ON TRACK!! btw.. I started this last year.. http://talk.newagtalk.com/forums/thread-view.asp?tid=438765&posts=31&highlight=exports&highlightmode=1#M3535083 Those INITIAL projections of 1,746 beanies, 1,997 corn and 1,152 Wheaties were almost laughed off at the time.. USDA was at 1,475 beans, 1,450 Corn and 1,100 wheat but my model came ALOT closer to the final numbers of.. 1,647 beans 1,917 corn and 1,176 wheat.. "just say'in." My model was 99 myn bu too high on the beanies vs USDA at 172 too low. model was 80 myn bu too high on the corn vs USDA at 467 myn bu too low. and Wheaties I was 24 myn bu too LOW vs USDA at 76 myn bu too low. So Handicapping my forecast.. USDA would appear to have room (very EARLY in the season yet..) to come UP on Corn.. 50 myn and come up on the Wheaties 50 myn bu also. Since my model overestimated beanies by.. 100.. I'll stand pat for now.. but if we keep turning out 100 myn bushel SALES WEEKS as we have the past two.. then.. we'll have room to move higher..
Edited by JonSCKs 11/11/2014 11:02
|