> Extension Economics > Farm Management

MACRO ALERT: Some of these spreadsheets contain macros to help print results for the program. You can download these spreadsheets to your computer but may still get a warning about macros. If you choose to open the spreadsheet on the Web, you may get a security message if your security settings on your computer are set at the highest level.

If you get a security warning, click okay. The program will open on the Web, but the print macros will not work.

• Analyze the Economics of Tillage Systems and Crop Mix
  This spreadsheet is designed to allow users to analyze the costs and potential benefits of conventional, minimum, and no-till cropping systems. Users can specify their intended crop mix, differences in machinery complement, if any, and operating input requirements by crop by tillage system. Summary tables are presented for each tillage system and crop mix and for the total crop mix for a particular tillage system. This spreadsheet can be used to analyze the costs adopting a particular tillage system/farming practice for the purpose of carbon sequestration and also for the purpose of energy use/savings between tillage systems. A very condensed version of this spreadsheet is available on the web at: www.montana.edu/extensionecon/software/ EnergyImpactOnAg.swf
  
  This particular version focus on the energy use differences between tillage systems and has less flexibility than the Excel spreadsheet.

• Cost of Production
  Allows a producer to calculate the cost of production for small grain crops.  He must know what his machinery costs are.  See MACHCOST, CUSTBRKE, and MACHINES to calculate machinery costs. 

• Crop Share, Cash & Flexible Lease
  Calculates lease arrangements using a contributions approach to leasing.  This program calculates Crop Share, Cash, and Flexible Cash Lease rates. This spreadsheet has been updated to include some sensitivity analysis for the costs of fuel, fertilizer and chemicals."  View/download a pdf file.

• Crop Variable Cost
  Calculates the variable cost of production for small grain crops. Useful for short run decisions. 

• Enterprise Budgeting
  Calculates the cost of production for up to 9 enterprises with full calculation of the cost of owning and operating machinery.

• Haying System Enterprise Budgeting
  This spreadsheet allows the user to estimate the operating and ownership costs of a specific type of haying systems. The user must enter machinery and equipment information for various types of systems, round bale, small square bale, large square bale, or some combination of these systems they use to put up hay. The user must specify the type of machinery and equipment used for cutting, raking, baling and hauling and stacking. The program estimates the machinery costs for each of these steps and if desired, lets the user develop enterprise budgets for the haying and stand establishment enterprises.
  
  
• 1. Spring Wheat Fertilizer Economics for Dryland Operations
  2. Winter Wheat Fertilizer Economics for Dryland Operations
  

  These programs allow the user to evaluate the optimal amount of nitrogen fertilizer to apply given the price of crop, spring wheat or winter wheat, the price of nitrogen per pound of active ingredient and protein discounts and premiums that may be available for either spring wheat or winter wheat. The yield response for S.W. and W.W. is estimated for soil N plus applied nitrogen and the yield response to total nitrogen is estimated using a model that allows the user to specific their estimated maximum yield given their historical experience.

  These programs use the Flash Player on your computer to run. If you have difficulty running this program, update your Flash Player to the current version using the link below. This is a free download and it installs easily.

  Flash Player web link: (This is a free download)
  http://www.adobe.com/shockwave/download/download.cgi?
  P1_Prod_Version=ShockwaveFlash

• Storing Grain
  Calculates the cost and breakage periods for both existing and now on farm storage, and for commercial storage.
  
  

Return to regular view	Text-only	Updated: 7/3/08