The rotation modeling spreadsheet assists producers in comparing, at the field level, certain relevant economic differences between rotations and farming methods of conventional and certified organic production. However, the rotation modeling spreadsheet does not account for economic information such as fixed costs, nor does it reflect the overall economic picture of a farm.
The department developed a second spreadsheet to model the economics for an entire farm and provide an example of how information from the rotation modeling spreadsheet can be used to plan and evaluate transitioning an entire farm. This "whole-farm" spreadsheet is not intended as a template and is only provided as an example. The whole-farm spreadsheet does not have some of the error-protection and user-friendly features that are built into the rotation modeling worksheet.
The whole-farm model compares the economics of a dryland farm transitioning to organic production to the economics of continued conventional production over a twenty-year period.
Initially: 2,540 acres under conventional management
Complete transition accomplished over a 10-year period:
Net income is for an incorporated farm
The spreadsheet contains several worksheets, which show up as tabs at the bottom of the spreadsheet. The first worksheet, titled "Comparison Summary," provides a consolidated comparison. Different sets of worksheets are used for the scenario in which the farm transitions to organic production and the scenarios in which the farm continues conventional management.
As in the rotation models, two examples are provided below to model different economic conditions: the first using mid-2007 commodity prices and input costs from 2007-2008; and the second using 2006 crop prices and costs.
Agricultural Development Division
Montana Department of Agriculture
302 N Roberts
Helena, MT 59601
Phone: (406) 444-2402
Fax: (406) 444-9442
Published: Mon Nov 21 15:14:00 MST 2011.
Last Modified: Tue Jun 14 08:44:09 MDT 2016