www.farmdoc.uiuc.edu
From Harvest to Sale:Managing Grain Inventories Using FAST
Travis FarleyUniversity of Illinois
www.farmdoc.uiuc.edu
Tools for Better Farm Decisions
FAST - Farm Analysis Solution Tools
− Financial Analysis
− Investment Analysis
− Loan Analysis
− Farm Management
− Grain Marketing and Management
− Risk Management
− Yield Database Utilities
www.farmdoc.uiuc.edu
Access FAST Tools
• FAST Tools and Resources CD– Subscription service
• University of Illinois farmdoc– Download tools free of charge
www.farmdoc.uiuc.edu
Extension Program
• Provide hands-on training through extension workshops
• Utilize a mobile computer lab
• Demonstrate application of tools through case studies
www.farmdoc.uiuc.edu
Women in Agriculture
• Play a significant role in recordkeeping
• Asked to organize a large amount of grain information during harvest
• Often document harvest information on paper or in homemade spreadsheets
www.farmdoc.uiuc.edu
Questions to Answer
• What is my average yield?
• How much grain have I taken a LDP on?
• What is my average LDP?
• What is my average sales price?
• How much grain have I forward contracted?
• How much grain have I feed to livestock?
• How much grain am I storing for each of my landlords?
www.farmdoc.uiuc.edu
Grain Inventory Management
• Manages and tracks grain inventories by:– Grain owner– Storage site
• The program records the following grain transactions:
– Sales– Production– Transfers– Purchases– Fed to livestock
– Loan Deficiency Payments– Forward pricing– Other price contracts– CCC loan transactions
www.farmdoc.uiuc.edu
Grain Transactions
Stores grain transactions in a searchable database that allows you to:
Search for a specific grain transaction
Sort transactions by various fields and on many levels
www.farmdoc.uiuc.edu
Query the Database
• On what date did a transaction occur?
• What sales prices have I received?
• What LDP prices have I received?
• How many bushels were harvested from a certain field?
Grain Transactions Database
www.farmdoc.uiuc.edu
Grain Reports
• Program reports: – Grain Owner Inventory– Storage Location Inventory– Production Records
• The tool designs reports for the farm operator and landlords documenting crop yields, inventory, and storage sites.
www.farmdoc.uiuc.edu
Grain Owner Report
www.farmdoc.uiuc.edu
Storage Location Report
www.farmdoc.uiuc.edu
Production Report
www.farmdoc.uiuc.edu
Program Navigation
The Main Menu guides the user through the input screens of the tool.
www.farmdoc.uiuc.edu
Closing Comments
• Increasing demand for FAST Tools education
• Program descriptions available on farmdoc and FAST CD
• Grain Inventory Management tool apart of Annie’s Project