Tools & Calculators

Agricultural price guide

The Ag Price Guide is a web based tool to enable farmers and advisors to examine historic weekly prices for major commodities.  It has been created as part of the risk and decision making theme of Grain and Graze to assist in understanding historic prices and fluctuations in prices at various locations across Southern and Western Australia. 

Information is presented through a selection of graphs, statistical tables (mean, deciles) and correlations and can be adjusted for inflation.  Information is updated annually in September to the previous end of financial year (June).

To access the agricultural price guide click here

Risk and decision game

This Excel based tool provides a fun way to explore the concepts of risk and decision making in a cropping operation.  Users are able to make monthly decisions around time of sowing, varieties, fertiliser, herbicides etc by choosng a series of 'nil', 'low',  'medium' or 'high' cost options.  Risk is captured by historic rainfall and prices with yield calculated based on Yield Prophet.  A net profit is determined based on the decisions made.

The tool provides an opportinity to discuss with clients or a group what is behind the decisions being made (e.g. where is the information coming from to support these decisions) and how the unknown (future rainfall and prices) may affect what choices are made.  It is not designed to provide a precise calculation of net profit.  

 

Tools and Calculators

Grain and Graze Game - Activity notes..docx

Instructions on how to play the Grain and Graze decision making game.

18KB
13/01/2017
Grain and Graze game - Birchip (low rainfall)

An Excel model of the Grain and Graze risk and decision making game for a low rainfall environment (Birchip).

668KB
01/01/2017
Grain and Graze game - Lake Bolac (high rainfall)

An Excel model of the Grain and Graze risk and decision making game for a high rainfall environment (Lake Bolac).

611KB
01/01/2017