Farm Progress is part of the Informa Markets Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them. Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

Serving: IL
Spreadsheet Can Help Make Planting-Change Decisions

Spreadsheet Can Help Make Planting-Change Decisions

Gary Schnitkey says the new tool can help farmers predict profits based on crop and planting date.

It's decision-making time again for farmers, and the recent wet weather only complicates these issues. Should I delay planting corn? If I do, how will that decision affect the yield later? Should I consider switching from corn to soybeans?

A new spreadsheet entitled Planting Decision Model has been developed on the University of Illinois farmdoc website to provide some answers for farmers, according to agricultural economist and farm management specialist Gary Schnitkey.

"The spreadsheet compares corn and soybean returns by planting date," Schnitkey says. "We've built in agronomic functions developed in the U of I Department of Crop Sciences that give an average or a projected yield for different planting dates.  We combine that with the price of corn and soybeans and determine which crop has a higher return on any given planting date."

Visitors to the U of I farmdoc website can download the spreadsheet at Key factors impacting returns estimates are yield by planting date, harvest-time prices, and non-land costs.

"We're going to add a couple of other modules as we go through the season. One module will deal with with late planting and crop insurance, but right now the returns by planting date are available," Schnitkey notes.

Can farmers switch crops and make money? Schnitkey says probably not.

"Right now those yield functions and very high corn and soybean prices suggest that we wouldn't want to switch in northern and central Illinois until at least the end of May and early June. In southern Illinois, those decisions to switch from corn to soybeans occur in the last week of May, using yield functions that are defaulted within the model," he adds.

Schnitkey recommends farmers utilize the Returns Estimated by Planting Date sheet in the Planting Decision Model to evaluate whether to switch from corn to soybeans.   Switching dates are sensitive to corn and soybean prices.

"Using current commodity prices and costs, switching to more soybeans seems several weeks away," Schnitkey says. "For northern and central Illinois, corn is projected to be more profitable than soybeans throughout May.  In southern Illinois, corn is projected to be more profitable than soybeans through the last part of May.  Commodity prices play a key role in return differentials.  Current commodity prices favor corn compared to what one would expect with more typical prices."

Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.