from harvest to sale: managing grain inventories using fast

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