The Prevented Planting decision aid is an excel base tool that will help producers in determining which prevented planting decision is best for their circumstances. The tools allows producers to enter in their farm specified variables such as planting costs, average production history (APH), insurance coverage level, and insurance premium cost. The producer can also enter current commodity market prices. The decision aid was developed to display estimated profitability for the four different prevented planting options using the farmer’s information. We have set up two decision aids: 1) when corn is the originally insured crop with potential to switch to soybeans; and 2) when cotton is the originally insured crop with the potential to switch to soybeans. We recognize there are other possible secondary crops a producers could switch to, but we do not have data to include this in the decision aid.

Note Regarding Security Settings: The decision-aid file contains macros (examples: buttons for printing and moving from the intro page to the calculator) which are required for the calculator to function properly. Security settings for Microsoft Office or Excel may give you warnings when you open the file regarding the safety of enabling the macros. This will especially be true if your security settings are set to high or very high. The macros in the file must be enabled for the calculator to function properly.