Skip to main content

Extension

Open Main MenuClose Main Menu

Agribusiness Management Series Oklahoma Canola Systems vs. Continuous Wheat Budget Comparison

The Oklahoma Canola Systems vs. Continuous Wheat Budget Comparison was developed to assist producers project returns from canola systems in comparison to continuous wheat. The program is a joint project of the Department of Agricultural Economics and the Department of Plant and Soil Sciences at Oklahoma State University. The program can be downloaded from: http://www.agecon.okstate.edu/faculty/publications.asp (Author: DeVuyst; Type: Spreadsheet).

 

The program will work best in MS Excel 2007, but will also run on MS Excel 2003, if the user has downloaded and installed conversion software from Microsoft. Some loss of functionality may be observed in MS Excel 2003. For the program to function properly, the user must allow the macro features of MS Excel. In MS Excel 2007, the user is prompted with a warning just below the button bar that macros have been disabled. Click on the warning and enable macros. In MS Excel 2003, the user must change the security level to medium or low to enable macros.

 

Table 1. Data requirements

       

Scenario name

(Yellow)

C

 

 omparison system

(Green) 

Roundup-Ready Canola-Wheat-Wheat

(Yellow)

 

Scenario name

(Yellow)

Load defaults

(Green)

Wheat defaults

(Blue)

Canola defaults

(Blue)

data requirments

 

 

 

 

 

Cells in yellow allow for user input. Cells in green or blue are either display or calculated cells. Green and blue cells are protected to prevent users from accidentally overwriting equations.

 

The top table of the program allows users to enter a description e user also specifies the canola system to be considered. Either conventional canola or Roundup-Ready of the scenario to be evaluated and the current date. These cells are optional. Thcanola systems can be analyzed.

 

The first table also allows the user to load defaults on yields, prices, and input use and prices for wheat and canola rotations. These defaults were developed by OSU canola researchers. Since these values will vary by location and producer, they should be used to guide the user in developing budgets. Location and producer specific values should be entered when available.

 

Table 2 data requirements

 

As in Table 1, user-supplied data are entered into yellow-shaded cells. The top of Table 2 requires the user to specify units of measurement for wheat (except in unusual cases, bushels) and canola (usually pounds or bushels), prices for wheat and canola, and expected yields for both crops. Note: wheat yield may vary by cropping system/rotation.

 

On left side of the middle of Table 2, inputs are listed. The cells labeled as seed, fuel, lubrication, financing and harvest costs cannot be changed. Other inputs labels can be defined by users.

 

To help organize user-entered inputs, the defaults are listed in three blocks: fertilizers, herbicides, other pesticides and crop insurance. The user must supply the purchase prices of each input. For each crop and system, the user must enter the quantity of each input entered in the left-hand column.

 

 

Interpreting results

The results on the bottom of Table 2 report “cash returns” or returns to land, labor, machinery, overhead and management. The budgets include fuel, lube, repair, harvest costs, fertilizer, herbicide, insecticide, and fungicide application. Since the same machines may be used to till and plant, unlisted machinery costs are not likely to be substantially different across systems. However, at least initially, canola will require an investment in learning how to grow the crop. This additional cost for management is not included in the canola budget. The wheat budgets are for grain-only rather than for dual-purpose wheat. To evaluate dual-purpose wheat, the budgets could be modified by adjusting the levels of wheat yield, nitrogen and seed, and including the net value of grazing.  In preliminary comparisons, a canola plus two years of dual-purpose wheat rotation generates more expected net returns than three years of continuous dual-purpose wheat.

 

Table 2.

                   
       Production System
  Revenue

Unit of mesure

Price Per unit

Continuous Wheat

           Roundup-Ready  Canola- Wheat- Wheat 

 

       

WHEAT

WHEAT

WHEAT

WHEAT

CANOLA

CANOLA

   Production   Yield Revenue Yield Revenue Yield Revenue  
  Wheat bu $5.00 40 $200.00 43 $215.00 Xxx xxx
  Canola lb $0.15 xxx xxx xxx xxx 1800 $270.00
  Gross Returns  acre   $200.00  $233.33        
   Cash Costs     Quantity  Cost  Quantity  Cost  Quantity   Cost 
  Wheat Seed bu $5.00 1 $15.00 1 $15.00 xxx  xxx
  RR Canola Seed + Fees + Treatment lb $5.25 xxx xxx xxx   xxx5  $26.25
                   
  Anhydrous Ammonia (82-0-0) lb $0.20 68 $13.60 76 $15.20 0  $ –   
  Fertilizer Application acre $12.00 1 $12.00 1 $12.00 0  $ –   
  Urea (46-0--0) lb $0.19 0  $ –    0  $ –    143 $27.17
  DAP  (18-46-0) lb $0.21 50 $10.50 50 $10.50 50 $10.50
  Sulfur (0-0-0-90S) lb $0.40 0  $ –    0  $ –    5 $2.00
  Fertilizer Application acre $4.00 1 $4.00 1 $4.00 2 $8.00
  Herbicide (broadleaf) acre $5.00 1 $5.00 1 $5.00 0  $ –   
  Herbicide (grass) acre $16.00 1 $16.00 1 $16.00 0  $ –   
  Herbicide Select® oz $0.92 0  $ –    0  $ –    0  $ –  
  Herbicide Assure II® oz $1.15 0  $ –    0  $ –    0  $ –   
  Crop Oil Concentrate Acre $1.00 0  $ –    0  $ –    0  $  –   
  Roundup PowerMax  oz $0.48 0  $ –    0  $ –    36 $17.28
  Herbicide Additive (ams) lb $0.13 0  $ –    0  $ –    2 $0.25
  Herbicide Application acre $4.00 2 $8.00 2 $8.00 2 $8.00
  Prosper FX® acre $6.00 0  $ –    0  $ –    0  $ –  
  Insecticide dimethoate pint $5.38 0.75 $4.04 0.75 $4.04 0  $ –   
  Warrior® Fall (1 of 3 yrs) oz $2.45 0  $ –   0  $ –   1 $2.45
  Insecticide (e.g. Warrior®) Spring oz $2.45 0  $ –    0  $ –    3 $7.35
  Foliar Fungicide (1 of 3 years) acre $12.50 0.33 $4.13 0.33 $4.13 0  $ –   
  Aerial Pesticide Application acre $5.00 1.33 $6.65 1.33 $6.65 1.33 $6.65
  Wheat Crop Insurance acre $6.70 1 $6.70 1 $6.70 xxx  xxx 
  Canola Crop Insurance acre $12.50 xxx  xxx  xxx  xxx  1 $12.50
                   
  Fuel  gal $2.00 4.92 $9.84 4.92 $9.84 4.92 $9.84
  Lube acre $1.48 1 $1.48 1 $1.48 1 $1.48
  Repair acre $7.12 1 $7.12 1 $7.12 1 $7.12
  Operating loan interest rate % 7.00% $62.03 $4.34 $62.83 $4.40 73.42 $5.14
  Wheat Custom Harvest & Hauling              
  Base Charge acre $16.00 1 $16.00 1 $16.00 xxx xxx
  Excess for > 20 bu/a bu $0.23 20 $4.60 23 $5.29 xxx xxx
  Hauling bu $0.23 40 $9.20 43 $9.89 xxx xxx
  Canola Custom Harvest & Hauling              
  Swathing or Pushing acre $12.00 xxx xxx xxx xxx 1 $12.00
  Combining acre $16.00 xxx xxx xxx xxx 1 $16.00
  Excess for > 20 bu/a bu $0.23 xxx xxx xxx xxx 16 $3.68
  Hauling bu $0.23 xxx xxx xxx xxx 36 $8.28
  Total "Cash" Costs acre $158.19 $161.23 $191.94        
  Net Returns to Land, Machinery Fixed Costs, Labor, Overhead and Management acre   $41.81 per acre  $61.87 per acre  Roundup-Ready Canola-Wheat-Wheat

 

 

 

Eric A. DeVuyst

Associate Professor, Farm Management and Production Management

 

Francis Epplin

Professor, Agriculture Business and Commercial Agriculture

 

Thomas F. Peeper

Professor, Weed Control, Small Grains

 

Mark C. Boyles

Assistant Extension Specialist

Was this information helpful?
YESNO
Fact Sheet
Should I Buy (or Retain) Stockers to Graze Wheat Pasture?

By Roger Sahs, Amanda de Oliveira Silva and Eric DeVuyst. Learn about the factors that should be considered in deciding whether to buy or retain cattle to graze wheat pasture are discussed. Impacts on potential profit of variability in forage yield and returns to livestock are demonstrated. Means of managing risks associated with variability in forage production and utilization are outlined.

Beef CattleBudgets & RecordkeepingBusiness Planning & ManagementFarm & Ranch FinancesFinancial StatementsLivestockStocker Cattle
Fact Sheet
Consolidated Financial Statements

By Rodney Jones, Courtney Bir, and Brent Ladd. Learn about the key issues that farm and ranch businesses face financially.

Business Planning & ManagementFarm & Ranch FinancesFinancial Statements
Fact Sheet
Wildlife Food Plot Budgeting Tool User's Guide

By Eric DeVuyst and Courtney Bir. Learn how to use the OSU Food Plot budgeting tool which can help hunters and landowners estimate the cost of various food plant crops. This includes seed, fertilizer, pesticide and machine operating costs.

Budgets & RecordkeepingBusiness Planning & ManagementFarm & Ranch Finances
Fact Sheet
Information Systems for Oklahoma Farmers

By Rodney Jones, Courtney Bir and Brent Ladd. Learn about the potential applications of records in business management and different record-keeping options.

Budgets & RecordkeepingBusiness Planning & ManagementFarm & Ranch Finances
VIEW ALL
MENUCLOSE