vt oilseed profit cost calculator release 1 1a by 3H6tcET

VIEWS: 0 PAGES: 36

									BACKGROUND
As part of the VSJF's ongoing Vermont Biofuels Initiative and UVM Extension's research this tool is intended to help farmers determine their total cost of production for oilseeds and oilseed
products (e.g. meal, oil, biodiesel.) The tool also allows the user to determine potential profit based on assumed market pricing for these products. Summary results are provided on the          print a copy of user's
same page as the user entered information, but a much more detailed calculation report is available for review and printing. Typical values for all user entered information are provided as              interface
reference and are based on either compiled Vermont oilseed grower data or other published data from other parts of the USA. Whenever possible, the user should carefully review their
own specific data to arrive at the entered information.
                                                                                                                                                                                                   print these instructions
INSTRUCTIONS
The first step is to gather all the data you have related to land, field operations, seed cost, harvesting costs, drying and cleaning costs, pressing costs, and biodiesel production costs. You
may want to print a copy of the User Interface (see button at right) to have as a checklist. Ideally, you should be able to enter specific information for your farm in each of the white boxes
on this sheet. You may also want to a copy of these instructions (see button at right).

NOTE: The calculator will use the "Typical" valueswhenever the white box next to it
has an "NA" in it. If a particular cost is really zero, you will need to enter "0" to
prevent the typical value from being used.

1. TITLE - Enter a title for the calculation. This will appear on the detailed report
to help keep various calculations sorted.

2. CROP - Select the oilseed crop for the calculation from the drop down menu,
and then enter your acreage information. Include fallow acreage in "Total Cropland."
Enter your land cost. This may be rent or may be your tax burden.

3. YIELD - Enter your yield for this crop, the oil content and test weight.

4. COST OF PRODUCTION - Enter your per acre costs of oilseed production
including labor, fuel and materials (e.g. seed, manure, chemical, etc.)
ghg
NOTE: You can either enter a total cost of production or enter the specific costs for
each part of production that you practice. If a total cost is entered, it will override
any specific actitivity information.

Also enter your equipment costs here, including purchase cost and life (or annual
maintenance cost and 1 year if fully depreciated.)

5. COST OF CLEANING AND DRYING - Enter seed moisture info, and cleaning / drying costs including cost of electricity and labor. Also enter the purchase cost and life of your cleaner
and drier (or maintenance cost and 1 year if fully depreciated).                                                                             Click image to proceed to calculator
6. COST OF PRESSING - Enter the cost of your press and expected life. Also enter the press capacity, oil extraction efficiency, power rating and labor costs for operation.

7. COST OF BIODIESEL PRODUCTION - Enter the cost of your biodiesel processing equipment and expected life. Also enter your heating cost (note: $30/mill BTU is equivalent to
$0.13/kWhr electricity, $4.14/gal fuel oil and $2.76/gal propane.) Alcohol and lye costs should be entered here as well. Also be sure to include labor costs associated with making the fuel.

8. MARKET VALUE OF PRODUCTS - The typical values for this section are from recent hisorical pricing data for the relevant commodities. You will want to be sure to find out your local
and/or regional market pricing and enter them here. This will greatly impact the project profit or loss in the results section.

Summary results are provided on the right hand side of the User Interface sheet. But more detailed results are available for printing and review by clicking on the "Print Detailed Report"
button. If you make a mistake and want to start over, click "Clear My Inputs" button. You can save individual scenarios as separate Excel files. For example, if you wanted to keep a
Sunflower calculation and a Soybean calculation you can do so by entering the information separately and saving as separate files (File, Save As).
                                                                                                                                                                                      Brought to you by a joint effort between UVM Extension and the Vermont
Vermont Oilseed Crop Production Cost and Profit Calculator                                                                                                                                                     Sustainable Jobs Fund.


USER INPUTS                                                                                                                                                                                                                                         RESULTS
    1    Title                                                                  GENERAL INSTRUCTIONS: Enter any specific information you have regarding your farm's                                            Projected Costs                                 Typical          My Farm

    2    Crop Sunflower                                                         operation into the white boxes below. If you do not enter a value in the white box, the                                            Incremental (cost for each step)
                                                                                "typical" value to the left of it will be used. If you enter "0" instead of "NA" a value of zero                                   Cost of Production               $              200      $        200     /acre
                 Total Cropland                 100      acres                                                                                                                                                                                      $              364      $        364     /ton seed
                                                                                will be used.           "Typical" values are based on research and collection of data from
                 Acres in Oilseeds               50      acres                                                                                                                                                     Cost of Cleaning/Drying          $                28     $          28    /acre
                 Acres in this Crop              25      acres                  participating farmers and other published resources and are provided for guidance only.                                                                             $                51     $          51    /ton seed
                                                                                Summary results are displayed on the right of the screen, and you can print a more                                                 Cost of Pressing                 $                 8     $           8    /acre
                                  Typical My Farm                                                                                                                                                                                                   $                 9     $           9    /ton meal
                                                                                detailed report by clicking "Print Detailed Report".
         Land Cost                 $ 37     NA    /acre/yr                                                                                                                                                                                          $                25     $          25    / '000 gal oil
                                                                                                                                                                                                                   Cost of Biodiesel Production     $                39     $          39    /acre
     3   Yield                                                Typical      My Farm                                                                                                                                                                  $              0.60     $        0.60    /gal
                 Yield (Seed)                                     1100           NA lbs/acre            6   Cost of Pressing                             Typical          My Farm
                 Oil Content                                       44%           NA                              Press Cost                            $   4,000                NA                                 Cumulative (total cost for each product)
                 Test Weight                                        32           NA lbs/bu (dry)                 Press Life                                    20                NA   years                        Cost to Produce Seed             $      228              $        228     /acre
                                                                                                                 Press Capacity                               1.0                NA   ton/day                                                       $      415              $        415     /ton
    4    Cost of Production                                   Typical      My Farm                               Press Oil Efficiency                         90%                NA                                Cost to Produce Meal             $      236              $        236     /acre
         (Labor, fuel and materials should be included in each item. Equipment cost is carried below)            Press Power Rating                              7               NA    hP
                                                                                                                                                                                      hP                                                            $      423              $        423     /ton
                  Field Prep (plow & disk)                $     34.00           NA      /acre                    Labor Cost (per ton)                  $    0.75                NA    /ton                         Cost to Produce Oil              $      236              $        236     /acre
                  Fertilizer (applied)                    $     47.00           NA      /acre               OR Overall Cost of Hired Pressing          $ 15.32                  NA    /ton seed                                                     $     0.71              $        0.71    /gal
                  Seed                                    $     25.00           NA      /acre               OR Cost of Purchased Oil                   $    0.68                NA    /gal                         Cost to Produce Biodiesel        $      275              $        275     /acre
                  Planting                                $      6.00           NA      /acre                    Amount of Purchased Oil                                        NA    gal/yr                                                        $     1.31              $        1.31    /gal
                  Cultivating                             $      8.00           NA      /acre
                  Spraying                                $     20.00           NA      /acre           7 Cost of Biodiesel Production                   Typical          My Farm                              Projected Profit / (Loss)                       Typical          My Farm
                  Harvesting                              $     12.00           NA      /acre                  Plant & Equip Cost                      $ 10,000                 NA                               Seed Only (Clean and Dry)                         ($29)             ($29)   /acre
                  Hauling                                 $      1.00           NA      /acre                  Plant & Equip Life                              30                NA   years                      Meal Only                                        ($194)           ($194)    /acre
            OR Total Cost of Production                   $    153.00           NA      /acre                  Heating Cost                            $    1.84                NA    /gal propane               Oil Only                                          $125             $125     /acre
               Total Being used in Calculator                             $ 153.00      /acre                  Alcohol Cost                            $    1.07                NA    /gal alc                   Meal & 100% Oil                                   $167             $167     /acre
                                                                                                               Alcohol Used                                   20%                NA   gal / gal oil              Meal and 100% Biodiesel                           ($88)             ($88)   /acre
                 Prod. Equip. Cost                        $    20,000             NA                           Lye Cost                                $    0.80                NA    /lb lye                    Biodiesel Only                                   ($130)           ($130)    /acre
                 Prod. Equip. Life                                 20             NA years                     Lye Used                                    0.083                 NA   lb / gal oil               Meal and Oil/Biodiesel split                      ($88)             ($88)   /acre
                                                                                                               Labor Cost (per gal)                    $    0.10                NA    /gal
            OR Cost of Raw Seed                           $    363.64             NA /ton                 OR Cost of Hired Production                  $     -                  NA    /gal B100                    Seed Only (Clean and Dry)                      ($723)           ($723)    total
                                                                                                                                                                                                                   Meal Only                                    ($4,843)         ($4,843)    total
     5   Costs of Cleaning and Drying                       Typical        My Farm                      8 Market Value of Products                        Typical         My Farm                                  Oil Only                                      $3,114           $3,114     total
               Harvest Moisture                                  14%             NA     % weight              Market Price for Seed                     $     362               NA    /ton                         Meal & 100% Oil                               $4,183           $4,183     total
               Storage Moisture                                   8%             NA     % weight              Market Price for Meal                     $     139               NA    /ton                         Meal and 100% Biodiesel                      ($2,192)         ($2,192)    total
               Cleaning Cost Factor                               1.5            NA     kWhr/ton              Market Price for Oil                      $    5.59               NA    /gal                         Biodiesel Only                               ($3,261)         ($3,261)    total
               Electricity Cost                           $     0.13             NA     /kWhr                 Market Price for Off-Road Diesel          $    2.24               NA    /gal                         Meal and Oil/Biodiesel split                 ($2,192)         ($2,192)    total
               Labor Cost (Dry/Clean per ton)             $   15.00              NA     /ton                                                            $
                                                                                                              Net Market Value of Other Potential Bi-product -                  NA    /acre

                                                                                                                                                                                                                       Print Detailed Report                             Clear My Inputs
                 Cleaner Cost                             $      4,000            NA                                                                       Typical        My Farm
                 Cleaner Life                                       30            NA years                      Value of Seed                          $       199    $         199   /acre
                                                                                                                Value of Meal                          $        43    $          43   /acre
                                                                                                                                                                                                                           See Instructions                              Print Instructions
                 Drier Cost                               $    12,000             NA                            Value of Oil                           $       361    $         361   /acre
                 Drier Life                                        20             NA years                      Value of Biodiesel                     $       145    $         145   /acre

            OR Cost of Clean / Dry Seed                   $    414.62             NA /ton                       Marketing split (oil vs. biodiesel)        Typical        My Farm
                                                                                                                      Sell                                       0%              NA raw oil
                                                                                                                      Convert remaining                       100%               NA to biodiesel
                                                                                                                                                                                                                                Release 1.1 - 2010 September 13 (Working Draft)




/gal oil
/gal propane
/kWhr electric
/cord wood
                                     Vermont Oilseed Crop Production Cost and Profit Calculator
                                                                              Detailed Report




CROP                                     Sunflower
Acres in Production                        100        acres
Acres in Oilseeds                           50        acres
                                           50%
Acres in Sunflower                          25        acres
                                           25%


                                                                                             My Farm Info Entered                             Inputs Actually Used &
                                                 Typical Values                          (Overrides the Typical Values)                         Calculation Results
CROP YIELDS
Yield                                         1,100   lb/acre                                     NA lb/acre                         1,100    lb/acre
                                              13.75   tons seed total                                                                   14    tons seed total
                                                859   bushels                                                                          859    bushels
                                                0.6   ton/acre seed                                                                    0.6    ton/acre seed

Oil Content                                    44%    oil (weight %), gross                       NA oil (weight %)                   44%     oil (weight %)
                                                7.5   lbs oil / gal                                                                    7.5    lbs oil / gal
                                              1,613   gal oil (ideal)                                                                1,613    gal oil (ideal)
                                                 65   gal/acre oil (gross)                                                              65    gal/acre oil
                                                 65   gal/acre oil (net)                                                                65    gal/acre oil (net)
                                               44%    oil (weight %), net                                                             44%     oil (weight %), net

Meal Content                                   56%    meal (weight %)                             NA meal (weight %)                  56%     meal (weight %)
                                                  8   ton meal                                                                           8    ton meal
                                                0.3   ton meal / acre                                                                  0.3    ton meal / acre
                                               56%    meal (weight %), net                                                            56%     meal (weight %), net

Test Weight                                     32 lb/bu                                          NA lb/bu                              32 lb/bu

CROP PRODUCTION COSTS
Land Cost                            $        37.00   /acre/yr                                   NA    /acre/yr                $     37.00    /acre/yr
Cost of Production                   $       153.00   /acre                                      NA    /acre                   $    153.00    /acre
   Field Prep Cost                   $        34.00   /acre                                      NA    /acre                   $     34.00    /acre
   Fertilizer                        $        47.00   /acre                                      NA    /acre                   $     47.00    /acre
   Seed Cost                         $        25.00   /acre                                      NA    /acre                   $     25.00    /acre
   Planting Cost                     $         6.00   /acre                                      NA    /acre                   $      6.00    /acre
   Cultivation Cost                  $         8.00   /acre                                      NA    /acre                   $      8.00    /acre
   Spraying Cost                     $        20.00   /acre                                      NA    /acre                   $     20.00    /acre
   Harvesting Cost                   $        12.00   /acre                                      NA    /acre                   $     12.00    /acre
   Hauling Cost                      $         1.00   /acre                                      NA    /acre                   $      1.00    /acre
Production Equipment Cost            $       20,000                                              NA                            $    20,000
Production Equipment Life                        20   years                                      NA    years                             20   years
Production Equipment Dep             $        1,000   /year                                                                    $     1,000    /year
                                      $      10.00    /acre                                                                    $     10.00    /acre
Crop Production Cost - Total          $     200.00    /acre                                                                    $    200.00    /acre
Cost of Raw Seed                      $     363.64    /ton seed                                  NA /ton                       $    363.64    /ton seed
                                      $     203.64    /ton meal (net)                                                          $    203.64    /ton meal (net)
                                      $     160.00    /ton oil (net)                                                           $    160.00    /ton oil (net)

CLEANING AND DRYING COSTS

Cleaning Cost Factor                            1.5   kWhr/ton                                    NA kWhr/ton                           1.5   kWhr/ton
Cleaning Cost - Electricity          $         0.11   /acre                                                                    $      0.11    /acre
Cleaner Cost                         $        4,000                                              NA                            $     4,000
Cleaner Life                                     30   years                                      NA years                                30   years
Cleaning Cost - Fixed                $          133   /year                                                                     $      133    /year
                                     $         2.67   /acre                                                                     $     2.67    /acre
Cleaning Cost - Total                $         2.77   /acre                                                                     $     2.77    /acre
                                     $         5.04   /ton seed                                                                 $     5.04    /ton seed
                                     $         2.82   /ton meal (net)                                                          $       2.82   /ton meal (net)
                                     $         2.22   /ton oil (net)                                                           $       2.22   /ton oil (net)

Harvest Moisture                              14%     weight                                      NA weight                            14%    weight
Storage Moisture                               8%     weight                                      NA weight                             8%    weight
Drying Cost Factor                           0.076    kWhr/lb water                                                                   0.076   kWhr/lb water
Electricity Cost                     $        0.13    /kWhr                                      NA /kWhr                      $      0.13    /kWhr
Drying Cost - Recurring              $        5.02    /acre                                                                    $      5.02    /acre
Drier Cost                           $      12,000                                               NA                            $    12,000
Drier Life                                      20    years                                      NA years                                20   years
Drying Cost - Fixed                  $         600    /year                                                                     $      600    /year
                                     $       12.00    /acre                                                                     $    12.00    /acre
Drying Cost - Total                  $       17.02    /acre                                                                     $    17.02    /acre
                                     $       30.94    /ton seed                                                                 $    30.94    /ton seed
                                     $       17.33    /ton meal (net)                                                          $      17.33   /ton meal (net)
                                     $       13.61    /ton oil (net)                                                           $      13.61   /ton oil (net)

Drying and Cleaning Labor
Cleaning/Drying Labor Rate           $        15.00   /ton                                       NA /ton                        $    15.00    /ton
Cleaning/Drying Cost - Labor         $         8.25   /acre                                                                     $     8.25    /acre
                                     $        15.00   /ton seed                                                                $      15.00   /ton seed
                                     $         8.40   /ton meal (net)                                                          $       8.40   /ton meal (net)
                                     $         6.60   /ton oil (net)                                                           $       6.60   /ton oil (net)

Drying and Cleaning Costs - Total    $        28.04   /acre                                                                    $     28.04    /acre
                                     $        50.98   /ton seed                                                                $     50.98    /ton seed
                                     $        28.55   /ton meal (net)                                                          $     28.55    /ton meal (net)
                                     $        22.43   /ton oil (net)                                                           $     22.43    /ton oil (net)

Cumulative Cost of Clean, Dry Seed   $      414.62 /ton seed                                     NA /ton seed                  $    414.62 /ton seed




Release 1.1                                             Calculator Provided by UVM Extension (http://www.uvm.edu/extension/)                                           8/31/2012 - 10:49 AM
(Sept. 13, 2010)                                                and the Vermont Sustainable Jobs Fund (www.vsjf.org)                                                           Page 3 of 36
                              Vermont Oilseed Crop Production Cost and Profit Calculator
                                                                     Detailed Report




CROP                              Sunflower
Acres in Production                 100       acres
Acres in Oilseeds                    50       acres
                                    50%
Acres in Sunflower                   25       acres
                                    25%


                                                                                     My Farm Info Entered                             Inputs Actually Used &
                                          Typical Values                         (Overrides the Typical Values)                         Calculation Results

PRESSING COSTS
Press Cost                    $       4,000                                              NA                            $     4,000
Press Life                               20   years                                      NA    years                             20   years
Press Capacity                          1.0   ton/day (24 hr)                            NA    ton/day (24 hr)                  1.0   ton/day (24 hr)
Press Power Rating                        5   kW                                         NA    hP                                 5   kW
Pressing Labor Cost           $        0.75   /ton                                       NA    /ton                    $       0.75   /ton
Pressing Cost                 $      200.00   /year depreciation                                                        $   200.00    /year depreciation
                              $       14.55   /ton seed depreciation                                                    $    14.55    /ton seed depreciation
                              $        0.78   $/ton seed operation                                                      $     0.78    $/ton seed operation
                              $        0.68   cum cost / gal oil                                                       $       0.68   cum cost / gal oil
                              $       25.28   $/ '000 gal total pressing                                                $    25.28    $/ '000 gal total pressing
                                         65   net gal oil/ acre                                                                  65   net gal oil/ acre
                              $        8.43   $/acre pressing total                                                    $      8.43    $/acre pressing total
                              $       15.32   $/ton seed pressing total                  NA /ton seed                  $     15.32    $/ton seed pressing total
                              $        8.58   $/ton meal pressing total                                                $      8.58    $/ton meal pressing total
                              $        6.74   $/ton oil pressing total                                                 $      6.74    $/ton oil pressing total



BIODIESEL CONVERSION COSTS
Plant & Equip Cost            $      10,000                                              NA                            $    10,000
Plant & Equip Life                       30   years                                      NA    years                             30   years
Heating Cost                  $          20   /mill BTU                                  NA    /gal propane            $        20    /mill BTU (converted from fuel cost)
Alcohol Cost                  $        1.07   /gal alc                                   NA    /gal alcohol            $      1.07    /gal alcohol
Alcohol Used                           20%    gal alc / gal oil                          NA    gal alc / gal oil               20%    gal alc / gal oil
Lye Cost                      $        0.80   /lb lye                                    NA    /lb lye                 $      0.80    /lb lye
Lye Used                              0.083   lb lye / lb oil & lye mix                  NA    lb lye / gal oil               0.083   lb lye / gal oil
Conversion Labor              $        0.10   /gal                                       NA    /gal                     $     0.10    /gal
Conversion Cost - Recurring   $        0.39   /gal                                                                      $     0.39    /gal
Conversion Cost - Fixed       $        0.21   /gal                                                                      $     0.21    /gal
Conversion Cost - Total       $        0.60   /gal                                                                      $     0.60    /gal
                              $       38.51   /acre                                                                    $      38.51   /acre
Conversion rate                        64.5   gal/acre                                                                         64.5   gal/acre




Release 1.1                                     Calculator Provided by UVM Extension (http://www.uvm.edu/extension/)                                                    8/31/2012 - 10:49 AM
(Sept. 13, 2010)                                        and the Vermont Sustainable Jobs Fund (www.vsjf.org)                                                                    Page 4 of 36
                                          Vermont Oilseed Crop Production Cost and Profit Calculator
                                                                                  Detailed Report




CROP                                          Sunflower
Acres in Production                             100        acres
Acres in Oilseeds                                50        acres
                                                50%
Acres in Sunflower                               25        acres
                                                25%


                                                                                                  My Farm Info Entered                              Inputs Actually Used &
                                                      Typical Values                          (Overrides the Typical Values)                          Calculation Results

TOTAL COSTS
Cost of Crop Production                   $      200.00    /acre                                                                     $   200.00     /acre
Cost of Cleaning & Drying                 $       28.04    /acre                                                                     $    28.04     /acre
Cost of Pressing                          $        8.43    /acre                                                                     $     8.43     /acre
   Meal Portion                           $        4.72    /acre                                                                    $       4.72    /acre
   Oil Portion                            $        3.71    /acre                                                                    $       3.71    /acre
Cost of Biodiesel Conversion              $       38.51    /acre                                                                     $    38.51     /acre
                                          $      274.98    /acre                                                                     $   274.98     /acre

COST BREAKDOWNS

Seed
Crop Production                           $      363.64 /ton                                                                        $     363.64 /ton
Cleaning / Drying                         $       50.98 /ton                                                                        $      50.98 /ton
Total                                     $      414.62 /ton                                                                        $     414.62 /ton

Meal
Crop Production                           $      203.64    /ton                                                                     $     203.64    /ton
Cleaning Drying                           $       28.55    /ton                                                                     $      28.55    /ton
Pressing                                  $        8.58    /ton                                                                     $       8.58    /ton
Total                                     $      240.77    /ton                                                                     $     240.77    /ton

Oil
Crop Production                           $      160.00    /ton                                                                     $     160.00    /ton
Cleaning Drying                           $       22.43    /ton                                                                     $      22.43    /ton
Pressing                                  $        6.74    /ton                                                                     $       6.74    /ton
Total                                     $      189.17    /ton                                                                      $   189.17     /ton

Crop Production                           $         0.60   /gal                                                                     $       0.60    /gal
Cleaning Drying                           $         0.08   /gal                                                                     $       0.08    /gal
Pressing                                  $        25.28   / '000 gal                                                               $      25.28    / '000 gal
Total                                     $         0.71   /gal                                       NA /gal                        $     0.71     /gal

Amount of Oil Purchased                                                                               NA gal/yr                              -      gal/yr

Biodiesel
Crop Production                           $         0.60   /gal                                                                     $       0.60    /gal
Cleaning/Drying                           $         0.08   /gal                                                                     $       0.08    /gal
Pressing                                  $        25.28   / '000 gal                                                               $      25.28    / '000 gal
Biodiesel Conversion                      $         0.60   /gal                                                                     $       0.60    /gal
Total                                     $         1.31   /gal                                                                     $       1.31    /gal

VALUE OF PRODUCTS
Value of Seed                             $          362   per ton                                    NA    per ton                 $        362    per ton
Value of Meal                             $          139   per ton                                    NA    per ton                 $        139    per ton
Value of Oil                              $         5.59   per gallon                                 NA    per gallon              $       5.59    per gallon
Value of Biodiesel                        $         2.24   per gallon                                 NA    per gallon              $       2.24    per gallon

Value of Seed                             $      199.10    /acre                                                                    $    199.10     /acre
Value of Meal                             $       42.76    /acre                                                                    $     42.76     /acre
Value of Oil                              $      361.02    /acre                                                                    $    361.02     /acre
Value of Biodiesel                        $      144.54    /acre                                                                    $    144.54     /acre
Net Value of Other Potential Bi-Product    $       -       /acre                                      NA /acre                      $       -       /acre

POTENTIAL PROFIT (LOSS)
Seed Only (Clean and Dry)                  $     (28.94)   /acre                                                                    $     (28.94)   /acre
Meal Only                                  $    (193.70)   /acre                                                                    $    (193.70)   /acre
Oil Only                                  $       124.55   /acre                                                                    $     124.55    /acre
Meal & 100% Oil                           $       167.31   /acre                                                                    $     167.31    /acre
Meal and 100% Biodiesel                    $     (87.67)   /acre                                                                    $     (87.67)   /acre
Biodiesel Only                             $    (130.43)   /acre                                                                    $    (130.43)   /acre
Meal and Oil/Biodiesel split               $     (87.67)   /acre                                                                    $     (87.67)   /acre
    Sell                                             0%    raw oil                                     NA                                     0%    raw oil
    Convert                                        100%    raw oil to biodiesel                                                             100%    raw oil to biodiesel

Seed Only (Clean and Dry)                  $       (723)   total                                                                    $       (723)   total
Meal Only                                  $     (4,843)   total                                                                    $     (4,843)   total
Oil Only                                  $        3,114   total                                                                    $      3,114    total
Meal & 100% Oil                           $        4,183   total                                                                    $      4,183    total
Meal and 100% Biodiesel                    $     (2,192)   total                                                                    $     (2,192)   total
Biodiesel Only                             $     (3,261)   total                                                                    $     (3,261)   total
Meal and Oil/Biodiesel split               $     (2,192)   total                                                                    $     (2,192)   total




Release 1.1                                                  Calculator Provided by UVM Extension (http://www.uvm.edu/extension/)                                            8/31/2012 - 10:49 AM
(Sept. 13, 2010)                                                     and the Vermont Sustainable Jobs Fund (www.vsjf.org)                                                            Page 5 of 36
                                                       Vermont Oilseed Crop Production Cost and Profit Calculator
                                                                                              Detailed Report




CROP                                                     Sunflower
Acres in Production                                        100         acres
Acres in Oilseeds                                           50         acres
                                                           50%
Acres in Sunflower                                          25         acres
                                                           25%


                                                                                                              My Farm Info Entered                            Inputs Actually Used &
                                                                  Typical Values                          (Overrides the Typical Values)                        Calculation Results
PROFIT / (LOSS) STATEMENTS

Grow, Clean, Dry and Sell Seed Only
Total Revenue                                           $    4,978                                                                              $    4,978
Total Expenses                                          $    5,701                                                                              $    5,701
Total Profit / (Loss)                                   $     (723)                                                                             $     (723)

Grow Seed, Press, Sell Meal Only
Total Revenue                                           $     1,069                                                                             $    1,069
Total Expenses                                          $     5,912                                                                             $    5,912
Total Profit / (Loss)                                   $    (4,843)                                                                            $   (4,843)

Grow Seed, Press, Sell Oil Only
Total Revenue                                           $    9,025                                                                              $    9,025
Total Expenses                                          $    5,912                                                                              $    5,912
Total Profit / (Loss)                                   $    3,114                                                                              $    3,114

Grow Seed, Press, Sell Meal and Oil
Total Revenue                                           $   10,094                                                                              $   10,094
Total Expenses                                          $    5,912                                                                              $    5,912
Total Profit / (Loss)                                   $    4,183                                                                              $    4,183

Grow Seed, Press, Sell Meal, Convert Oil to Biodiesel, and Sell Biodiesel OR Buy Oil and Convert and Sell Biodiesel
Total Revenue                                            $    4,683                                                                             $    4,683
Total Expenses                                           $    6,874                                                                             $    6,874
Total Profit / (Loss)                                    $   (2,192)                                                                            $   (2,192)

Grow Seed, Sell Biodiesel
Total Revenue                                           $     3,614                                                                             $    3,614
Total Expenses                                          $     7,085                                                                             $    7,085
Total Profit / (Loss)                                   $    (3,472)                                                                            $   (3,472)

Grow Seed, Sell 0% oil and 100% biodiesel                                                                #VALUE!
Total Revenue                                           $     3,614                                                                             $    3,614
Total Expenses                                          $     6,874                                                                             $    6,874
Total Profit / (Loss)                                   $    (3,261)                                                                            $   (3,261)




Release 1.1                                                              Calculator Provided by UVM Extension (http://www.uvm.edu/extension/)                                          8/31/2012 - 10:49 AM
(Sept. 13, 2010)                                                                 and the Vermont Sustainable Jobs Fund (www.vsjf.org)                                                          Page 6 of 36
Crops
                 1         2            3              4            5         6                7            8
                                    Yield/Ac       Oil Yield    Meal Yield Test Wt           Cost of   Field Prep
                                                                                              Prod


                                     (lbs.)         % Oil        % Meal      lb/bu - dry     $/acre      $/acre
         5   Camelina           5    1500           37%           63%            50          153.00      34.00
         2   Canola             2     800           40%           60%            52          153.00      34.00
         6   Flax               6    1200           35%           65%            60          153.00      34.00
         7   Mustard            7     600           35%           65%            60          153.00      34.00
        10   Other             10    1000           40%           60%            30          153.00      34.00
         8   Poppies            8    1200           35%           65%            46          153.00      34.00
         4   Rapeseed           4     800           40%           60%            60          153.00      34.00
         9   Safflower          9     800           38%           62%            38          153.00      34.00
         3   Soybeans           3    2200           15%           85%            60           96.00      18.00
         1   Sunflower          1    1100           44%           56%            32          153.00      34.00

Average Cleaning Cost Factor                                1.5 kWhr/ton

Average Drying Cost Factor                              0.076 kWhr/lbH2O

Average Electricity Cost                                  0.13 $/kWhr

Land Cost                                      $            37 /acre/yr

Production Equip Cost                          $      20,000
Production Equip Life                                     20 years

Cleaner Cost                                   $       4,000
Cleaner Life                                              30 years

Drier Cost                                     $      12,000 per 2400 bu
Drier Life                                                20 years

Cleaning / Drying Labor Cost                   $       15.00 /ton

Press Cost                                     $       4,000
Press Life                                                20    years
Press Capacity                                              1   ton/day
Press Oil Efficiency                                     90%
Press Power Rating                                          5   kW                          convert kW to hP by multiplying by
Press Labor                                    $        0.75    /ton

Plant & Equip Cost                             $      10,000
Plant & Equip Life                                         30   years
Heating Cost                                   $          20    /mill BTU                        2.76 /gal oil
Alcohol Cost                                           $1.07    /gal alc
Alcohol Used                                             20%    gal alc / gal oil
Lye Cost                                       $        0.80    /lb lye
Lye Used                                                1.10    lb lye / lb oil & lye mix
                                                       0.083    lb lye / gal oil
Conversion Labor                             $   0.10 /gal

Average Seed Value                           $    362   per ton
Average Meal Value                           $    139   per ton
Average Oil Value                            $   5.59   per gallon
Average Biodiesel Value                      $   2.24   per gallon
Default Value of Other Potential BiProduct         $0   per acre

 Sell                                              0% raw oil
 Convert                                         100% raw oil to biodiesel
                  9           10          11          12            13       14          15         16          17
              Fertilizer     Seed      Planting    Cultivate       Spray   Harvest      Haul      Harvest    Storage
                                                                                                  Moisture   Moisture


                  $/acre    $/acre        $/acre     $/acre     $/acre      $/acre      $/acre    % weight % weight
                  47.00     25.00          6.00       8.00      20.00       12.00        1.00         12%       7%
                  47.00     25.00          6.00       8.00      20.00       12.00        1.00         12%       7%
                  47.00     25.00          6.00       8.00      20.00       12.00        1.00         10%       7%
                  47.00     25.00          6.00       8.00      20.00       12.00        1.00         12%       7%
                  47.00     25.00          6.00       8.00      20.00       12.00        1.00         12%       7%
                  47.00     25.00          6.00       8.00      20.00       12.00        1.00         12%       7%
                  47.00     25.00          6.00       8.00      20.00       12.00        1.00         12%       7%
                  47.00     25.00          6.00       8.00      20.00       12.00        1.00         12%       7%
                   0.00     50.00          5.00       0.00      17.00        5.00        1.00         13%      13%
                  47.00     25.00          6.00       8.00      20.00       12.00        1.00         14%       8%




W to hP by multiplying by      1.341               convert hP to kW by multiplying by    0.7457                     7




              $      1.84 /gal propane$                       $
                                             0.07 /kWhr electric      400 /cord wood
   18          19         20
 Seed         Meal    Oil Market
 Market      Market   Value - 2
Value - 2   Value - 2 year avg
year avg    year avg
  $/ton       $/ton      $/gal

      302        212       3.98




        0           0      0.00

      276        271       3.11
      362        139       5.59




hP
  Date      Prior Release   Rolled in New   Change       By
                              Release       Number

3/22/2010     Beta 0.2        Beta 0.2.1      1      C. Callahan
                                              2      C. Callahan
                                              3      C. Callahan
                                              4      C. Callahan
                                              5      C. Callahan
                                              6      C. Callahan

3/25/2010    Beta 0.2.1       Beta 0.2.2       1     C. Callahan
3/30/2010    Beta 0.2.2       Beta 0.2.3       1     C. Callahan
                                               2     C. Callahan
                                               3     C. Callahan
                                               4     C. Callahan
                                               5     C. Callahan
                                               6     C. Callahan
                                               7     C. Callahan
                                               8     C. Callahan
                                               9     C. Callahan
                                              10     C. Callahan
                                              11     C. Callahan
                                              12     C. Callahan
                                              13     C. Callahan
                                              14     C. Callahan
4/7/2010     Beta 0.2.3       Beta 0.2.4       1     C. Callahan
                                               2     C. Callahan
                                               3     C. Callahan

                                              4      C. Callahan


6/7/2010     Beta 0.2.4      Release 1.0      1      C. Callahan
                                              2      C. Callahan

                                              3      C. Callahan

                                              4      C. Callahan

                                              5      C. Callahan


                                              6      C. Callahan
9/16/2010    Release 1.0     Release 1.1      1      C. Callahan


                                              2      C. Callahan


                                              3      C. Callahan
                                              4      C. Callahan
5   C. Callahan

6   C. Callahan


7   C. Callahan
Description



Corrected formula for "Meal and Oil/Biodiesel Split" to include revenue from meal. Previously not included.
Corrected formula for $/ton meal and $/gal oil pressing costs
Adjusted format of "Value of…" section to be consistent with the rest of the user interface
Corrected a formula problem (cell reference) in the Cost of Production summary area.
Changed default "my Farm" entry from "0" to "NA", allowing users to enter zero values for certain items.
Added different historical (10 year avg) seed, oil, and meal prices from USDA ERS data (Oilseed Crops
Yearbook). These now change based on the user's crop selection on "User Interface"
Added cumulative profit / (loss) statements as p.3 of calculation report.
Added option for user to enter a title for Calculation Report
Improved format based on input from S. Sawyer (VSJF)
Added typical production costs for Soybeans from Rainbow Valley 2009 input
Corrected error in Hx Soy Oil $/gal calculation.
Added Hx Pricing for Methanol (unable to find source for Hx Lye pricing at this time.)
Referenced typical value for fuel to 5 yr annual avg Hx pricing for Off-road diesel
Corrected formula error for calculation of $/ton meal for pressing and $/gal oil for pressing (unit error)
Added labor for pressing
Removed Drier Cost / acre from User Interface. This is a calculated value, not user entered.
Reformated User input vs. Results sections to clarify what is entered and what is a result.
Added additional units in Results section (e.g. cost of oil per gal in addition to per acre.)
Added general instructions.
Added labor for cleaning/drying, pressing
Added cost of land (based on 2009 avg cropland rental for VT from NASS)
Added net gal oil / acre calculation in Detailed Calc Report (to account for pressing efficiency)
Added cost breakdown for each product (seed $/ton, meal $/ton, oil $/gal, BD $/gal) in Calc Report
Standardized meal vs. oil cost allocation on net terms (including pressing efficiency, not only theoretical oil
content of seed)
Corrected error in cumulative cost calculation for per gallon cost of BD. Had not split costs of crop production,
cleaning, and drying among the meal and oil. They were double kept. Now split among the two. This reduces
the cumulative cost of oil (and cumulative cost of meal).
Corrected error in cost estimation of lye (was using % wt, but calculating as lb/gal oil.)
Changed typical value for market prices to be based on 2 year averages instead of 10 year averages. Growers
indicated that the 10 year averages were quite low compared to what they are seeing now.
Removed redundant cleaning cost per acre. This is calculated from the cost per ton (electricity) plus labor and
ammortized fixed costs.
Added instructions for user and protected worksheet to prevent inadvertant errors or corruption of the calculator.

Revised calculations to more accurately spread equipment cost across all farm operations (when appropriate,
e.g. field operations), across all oilseed operations (when appropriate, e.g. cleaning & drying). This requires the
user to enter total cropland, acreage in oilseeds and acreage in this specific crop.
Protected all sheets from revision by user (other than intended user entry cells.)
Removed Drying energy factor since it is a matter of physics, not operation. This is simply the energy required to
evaporate 1 lb of water and won't change depending on a farmer's operational decisions. It is now hidden within
the calculations.
Changed the method of drop-down crop selection from simple combo box to a custom combo box which is
triggered by a data validation rule and an associated VB sub-routine on cell D9. This allows for control of font
size of the drop down list which was a complaint of beta users.
Changed press capacity units from tons/hr to tons/day (24 hr)
Corrected calculation error in the P&L section dealing with selling oil only (was using per acre profit/loss to
calculate revenue instead of using the per acre value of the product.
Made input of energy costs easier by employing a drop down menu with various fuel choices. Conversions
between the options are automatic.
Included a section for users to enter "Net Value of Other Potential Bi Product" such as straw from the oilseed
plant, etc. This is automatically added to the revenue side of the profit and loss calculation when a non-zero
value is entered.
Provided an option for users to enter purchased feedstocks (i.e. not grown), and also contracted services (such
as drying, pressing, & biodiesel production).
Appendix table 3--Soybeans: Supply, disappearance, and price, U.S., 1980/81-2008/09
 Year                           Supply                                                   Disappearance                                                                    Price
beginning       Beginning                                                                             Seed, feed                                      Ending            Average
September 1       stocks      Production      Total 1/              Crush           Exports                and                       Total            stocks            received
                                                                                                        residual                                                       by farmers
                                                   -------------------- Million bushels --------------------                                                              $/bu.
1980                    358              1,798            2,156               1,020               724                 99             1,843               313              7.57
1981                    313              1,989            2,302               1,030               929                 89             2,048               255              6.07
1982                    255              2,190            2,445               1,108               905                 87             2,100               345              5.71
1983                    345              1,636            1,980                 983               743                 79             1,805               176              7.83
1984                    176              1,861            2,037               1,030               598                 93             1,721               316              5.84
1985                    316              2,099            2,415               1,053               741                 85             1,879               536              5.05
1986                    536              1,943            2,479               1,179               757                106             2,042               436              4.78
1987                    436              1,938            2,375               1,174               804                 95             2,073               302              5.88
1988                    302              1,549            1,855               1,058               527                 88             1,673               182              7.42
1989                    182              1,924            2,108               1,146               622                101             1,869               239              5.69
1990                    239              1,926            2,169               1,187               557                 96             1,840               329              5.74
1991                    329              1,987            2,319               1,254               684                103             2,041               278              5.58
1992                    278              2,190            2,471               1,279               771                129             2,179               292              5.56
1993                    292              1,870            2,168               1,276               588                 95             1,959               209              6.40
1994                    209              2,515            2,729               1,405               840                150             2,395               335              5.48
1995                    335              2,174            2,514               1,370               849                111             2,330               183              6.72
1996                    183              2,380            2,573               1,436               886                119             2,441               132              7.35
1997                    132              2,689            2,826               1,597               874                155             2,626               200              6.47
1998                    200              2,741            2,944               1,590               805                201             2,596               348              4.93
1999                    348              2,654            3,006               1,578               973                165             2,716               290              4.63
2000                    290              2,758            3,052               1,640               996                168             2,804               248              4.54
2001                    248              2,891            3,141               1,700             1,064                169             2,933               208              4.38
2002                    208              2,756            2,969               1,615             1,044                131             2,791               178              5.53
2003                    178              2,454            2,638               1,530               887                109             2,525               112              7.34
2004                    112              3,124            3,242               1,696             1,097                193             2,986               256              5.74
2005                    256              3,068            3,327               1,739               940                199             2,878               449              5.66
2006                    449              3,197            3,655               1,808             1,116                157             3,081               574              6.43
2007                    574              2,677            3,261               1,801             1,161                 93             3,056               205             10.10
2008 2/                 205              2,959            3,173               1,640             1,185                163             2,988               185           8.85-9.85
1/ Total supply includes imports. 2/ Forecast.
                                                                                                                                                                          5 year
Sources: Crop Production , Grain Stocks and Agricultural Prices , National Agricultural Statistics Service, USDA and U.S. Trade Internet System, Foreign Agricultural Service, USDA.
                                                                                                                                                                       10 year
                                                                                                                                                                       15 year

                                                                                                                                                                    2 year




                                                                                 30
                                                              Oil Crops Yearbook/OCS-2009/March 2009
                                                                  Economic Research Service, USDA
$/ton
        252
        202
        190
        261
        195
        168
        159
        196
        247
        190
        191
        186
        185
        213
        183
        224
        245
        216
        164
        154
        151
        146
        184
        245
        191
        189
        214
        337



        235
        198
        203

        276




                                 31
              Oil Crops Yearbook/OCS-2009/March 2009
                  Economic Research Service, USDA
Appendix table 4--Soybean meal: Supply, disappearance, and price, U.S., 1980/81-2008/09
 Year                                       Supply                                                                         Disappearance
beginning        Beginning                                                                                                                                  Ending
October 1         stocks 1/     Production 1/       Imports             Total           Domestic                                  Exports       Total      stocks 1/

                                                                      ------------------- 1,000 short tons --------------------
1980                      226               24,312                  0               24,538                 17,591                  6,784       24,375            163
1981                      163               24,634                  0               24,797                 17,714                  6,908       24,622            175
1982                      175               26,714                  0               26,889                 19,306                  7,109       26,415            474
1983                      474               22,756                  0               23,230                 17,615                  5,360       22,975            255
1984                      255               24,529                  0               24,784                 19,518                  4,879       24,397            387
1985                      387               24,951                  0               25,338                 19,090                  6,036       25,126            212
1986                      212               27,758                  0               27,970                 20,435                  7,295       27,730            240
1987                      240               28,060                  0               28,300                 21,323                  6,824       28,147            153
1988                      153               24,943                 17               25,113                 19,497                  5,443       24,940            173
1989                      173               27,719                 37               27,928                 22,194                  5,416       27,610            318
1990                      318               28,325                 50               28,693                 22,775                  5,633       28,408            285
1991                      285               29,831                 69               30,185                 22,854                  7,101       29,955            230
1992                      230               30,364                 95               30,689                 24,086                  6,398       30,484            204
1993                      204               30,514                 75               30,793                 25,163                  5,481       30,644            150
1994                      150               33,269                 71               33,490                 26,427                  6,839       33,266            223
1995                      223               32,527                100               32,850                 26,549                  6,089       32,638            212
1996                      212               34,211                119               34,543                 27,222                  7,111       34,333            210
1997                      210               38,176                 66               38,452                 28,619                  9,615       38,234            218
1998                      218               37,797                112               38,126                 30,103                  7,693       37,796            330
1999                      330               37,591                 71               37,993                 30,080                  7,619       37,700            293
2000                      293               39,385                 55               39,733                 31,264                  8,085       39,350            383
2001                      383               40,292                148               40,823                 32,567                  8,015       40,583            240
2002                      240               38,194                173               38,607                 32,074                  6,314       38,388            220
2003                      220               36,324                285               36,830                 31,449                  5,169       36,619            211
2004                      211               40,715                147               41,073                 33,561                  7,340       40,902            172
2005                      172               41,244                141               41,557                 33,195                  8,048       41,243            314
2006                      314               43,054                156               43,524                 34,374                  8,804       43,178            346
2007                      346               42,242                141               42,729                 33,155                  9,280       42,435            294
2008 2/                   294               38,841                165               39,300                 30,600                  8,400       39,000            300
1/ Includes millfeed (hull meal). 2/ Forecast.
Sources: National Monthly Feedstuff Prices , Agricultural Marketing Service, USDA and U.S. Trade Internet System, Foreign Agricultural Service, USDA.      5 year
                                                                                                                                                           10 year
                                                                                                                                                           15 year

                                                                                                                                                        2 year




                                                                                31
                                                             Oil Crops Yearbook/OCS-2009/March 2009
                                                                 Economic Research Service, USDA
    Price
48% protein,
  Decatur
  (solvent)
    $/ton
   235.13
   196.62
   200.94
   203.21
   136.40
   166.20
   177.31
   239.35
   252.40
   186.48
   181.38
   189.21
   193.75
   192.86
   162.60
   235.90
   270.90
   185.30
   138.55
   167.70
   173.61
   167.72
   181.58
   256.05
   182.90
   174.17
   205.44
   335.94
  265-305


         231
         198
         202

   270.69




                                  32
               Oil Crops Yearbook/OCS-2009/March 2009
                   Economic Research Service, USDA
Appendix table 5--Soybean oil: Supply, disappearance, and price, U.S., 1980/81-2008/09
 Year                                         Supply                                                               Disappearance
beginning        Beginning                                                                                                                               Ending
October 1          stocks         Production         Imports                 Total             Domestic               Exports                   Total    stocks
                                                              ------------------- Million pounds --------------------
1980                   1,210              11,270                    0              12,480                9,113               1,631              10,744    1,736
1981                   1,736              10,979                    0              12,716                9,536               2,077              11,613    1,103
1982                   1,103              12,040                    0              13,143                9,857               2,025              11,882    1,261
1983                   1,261              10,863                    0              12,124                9,579               1,824              11,403      721
1984                     721              11,468                   20              12,209                9,916               1,660              11,576      632
1985                     632              11,617                    8              12,257               10,054               1,257              11,311      947
1986                     947              12,783                   15              13,745               10,833               1,187              12,020    1,725
1987                   1,725              12,975                  194              14,893               10,927               1,874              12,801    2,092
1988                   2,092              11,737                  138              13,967               10,591               1,661              12,252    1,715
1989                   1,715              13,004                   22              14,741               12,082               1,353              13,435    1,305
1990                   1,305              13,408                   17              14,730               12,136                 808              12,944    1,786
1991                   1,786              14,345                    1              16,132               12,248               1,644              13,892    2,239
1992                   2,239              13,778                   10              16,028               13,012               1,461              14,473    1,555
1993                   1,555              13,951                   68              15,574               12,940               1,531              14,471    1,103
1994                   1,103              15,613                   17              16,733               12,914               2,683              15,597    1,137
1995                   1,137              15,240                   95              16,472               13,465                 992              14,457    2,015
1996                   2,015              15,752                   53              17,821               14,267               2,033              16,300    1,520
1997                   1,520              18,143                   60              19,723               15,262               3,079              18,341    1,382
1998                   1,382              18,078                   83              19,543               15,652               2,372              18,024    1,520
1999                   1,520              17,825                   83              19,427               16,059               1,375              17,434    1,993
2000                   1,993              18,420                   73              20,486               16,318               1,401              17,719    2,767
2001                   2,767              18,898                   46              21,711               16,833               2,519              19,352    2,359
2002                   2,359              18,430                   46              20,835               17,081               2,263              19,344    1,491
2003                   1,491              17,080                  306              18,877               16,866                 936              17,802    1,076
2004                   1,076              19,360                   26              20,462               17,439               1,324              18,763    1,699
2005                   1,699              20,387                   35              22,122               17,959               1,153              19,112    3,010
2006                   3,010              20,489                   37              23,536               18,574               1,877              20,451    3,085
2007                   3,085              20,568                   65              23,718               18,328               2,907              21,235    2,483
2008 1/                2,483              18,645                   50              21,178               16,900               1,500              18,400    2,778
1/ Forecast.
Sources: National Monthly Feedstuff Prices , Agricultural Marketing Service, USDA and U.S. Trade Internet System, Foreign Agricultural Service, USDA.




                                                                                 32
                                                              Oil Crops Yearbook/OCS-2009/March 2009
                                                                  Economic Research Service, USDA
     Price
     Crude,
    Decatur
    Cents/lb.   $/gal
      22.73        1.70
      18.95        1.42
      20.62        1.55
      30.55        2.29
      29.52        2.21
      18.02        1.35
      15.36        1.15
      22.67        1.70
      21.09        1.58
      22.28        1.67
      20.98        1.57
      19.13        1.43
      21.24        1.59
      26.96        2.02
      27.51        2.06
      24.70        1.85
      22.51        1.69
      25.83        1.94
      19.80        1.49
      15.59        1.17
      14.09        1.06
      16.46        1.23
      22.04        1.65
      29.97        2.25
      23.01        1.73
      23.41        1.76
      31.02        2.33
      52.03        3.90
   28.5-31.5


    5 year        2.39
   10 year        1.86
   15 year        1.80

2 year             3.11




                                             33
                          Oil Crops Yearbook/OCS-2009/March 2009
                              Economic Research Service, USDA
Appendix table 21--Sunflowerseed: Supply, disappearance, and price, U.S., 1980/81-2008/09
Year                                   Supply                                                   Disappearance                         Ending
beginning       Beginning     Production      Imports      Total             Crush        Non-oil       Exports            Total      stocks
Sep. 1            stocks                                                                   use +
                                                                                            seed
                                                            ---------- Million pounds ----------
1980/81              1,975             3,742             62            5,779            1,720           340        3,318   5,377       401
1981/82                401             4,487             71            4,959              825           391        3,428   4,644       315
1982/83                315             5,333             88            5,736            1,689           421        2,972   5,081       655
1983/84                655             3,199             68            3,922            1,301           247        2,303   3,851        71
1984/85                 71             3,745             57            3,873            1,250           283        2,184   3,717       156
1985/86                156             3,153             57            3,366            1,486           608          804   2,898       468
1986/87                468             2,676             19            3,162            1,400           534          670   2,604       558
1987/88                558             2,608             22            3,189            1,984           176          594   2,755       434
1988/89                434             1,792             55            2,281            1,267           651          186   2,105       176
1989/90                176             1,760             44            1,981            1,204           507          211   1,922        58
1990/91                 58             2,274             88            2,421            1,307           647          271   2,226       195
1991/92                195             3,613            166            3,974            2,099           980          317   3,396       578
1992/93                578             2,565            104            3,247            2,036           800          260   3,096       151
1993/94                151             2,572             54            2,777            1,457           946          218   2,621       156
1994/95                156             4,836             93            5,084            2,894         1,331          632   4,857       227
1995/96                227             4,009             46            4,283            2,018         1,318          494   3,830       453
1996/97                453             3,559             40            4,052            1,861         1,429          329   3,619       433
1997/98                433             3,677             65            4,175            2,338         1,217          418   3,973       202
1998/99                202             5,273             75            5,551            2,596         1,874          573   5,043       508
1999/00                508             4,342             91            4,942            2,511         1,469          451   4,431       510
2000/01                510             3,544            145            4,199            2,036         1,376          443   3,854       345
2001/02                345             3,419            169            3,932            1,676         1,499          517   3,693       239
2002/03                239             2,451            216            2,907              703         1,398          366   2,467       440
2003/04                440             2,665            197            3,302            1,383         1,186          374   2,943       359
2004/05                359             2,050             98            2,507              609         1,391          308   2,307       199
2005/06                199             4,017             87            4,303            1,248         1,879          392   3,519       784
2006/07                784             2,144            247            3,174            1,452         1,020          400   2,872       302
2007/08                302             2,869            192            3,363            1,505         1,155          439   3,098       265
2008/09 1/             265             3,423            175            3,863            1,505         1,385          420   3,310       553
 1/ Forecast.
Sources: Crop Production, Grain Stocks, and Agricultural Prices , National Agricultural Statistics Service, USDA                     5 year
and U.S. Trade Internet System, Foreign Agricultural Service, USDA.                                                                 10 year
                                                                                                                                    15 year

                                                                                                                                   2 year




                                                                        49
                                                     Oil Crops Yearbook/OCS-2009/March 2009
                                                         Economic Research Service, USDA
   Price
 Average
 received
by farmers
   $/cwt      $/ton
 10.90                218
 10.80                216
   9.03               181
 13.00                260
 11.30                226
   7.93               159
   6.90               138
   8.34               167
 12.10                242
 10.60                212
 10.80                216
   8.69               174
   9.74               195
 12.90                258
 10.70                214
 11.50                230
 11.70                234
 11.60                232
 10.60                212
   7.53               151
   6.89               138
   9.62               192
 12.10                242
 12.10                242
 13.70                274
 12.10                242
 14.50                290
 21.70                434
20.10-21.70

    14.82         296
    12.08         242
    11.56         231

                      362




                                               50
                            Oil Crops Yearbook/OCS-2009/March 2009
                                Economic Research Service, USDA
Appendix table 22--Sunflowerseed meal: Supply, disappearance, and price, U.S., 1980/81-2008/09
 Year                                        Supply                                                                    Disappearance               Ending
beginning         Beginning       Production         Imports          Total 1/          Domestic                          Exports      Total       stocks
October 1           stocks

                                                                              ---------- 1,000 short tons ----------

1980/81                   4                 484                   4                 492                   489                0          489             3
1981/82                   3                 222                   3                 228                   220                0          220             8
1982/83                   8                 478                   4                 491                   485                0          485             6
1983/84                   6                 292                   6                 303                   270               28          298             6
1984/85                   6                 354                   6                 365                   344               15          359             6
1985/86                   6                 394                   6                 405                   351               49          399             6
1986/87                   6                 336                   6                 347                   295               47          342             6
1987/88                   6                 470                   0                 475                   419               51          471             4
1988/89                   4                 321                  14                 339                   329                7          336             3
1989/90                   3                 291                  14                 308                   299                3          303             5
1990/91                   5                 323                  20                 348                   337                6          343             5
1991/92                   5                 549                   8                 562                   496               59          555             7
1992/93                   7                 485                   5                 497                   442               53          495             2
1993/94                   2                 360                   5                 366                   321               41          361             5
1994/95                   5                 720                   0                 725                   623               98          720             5
1995/96                   5                 505                   0                 510                   478               27          505             5
1996/97                   5                 485                   0                 490                   462               23          485             5
1997/98                   5                 545                   0                 550                   531               14          545             5
1998/99                   5                 623                   0                 628                   578               45          623             5
1999/00                   5                 603                   0                 608                   580               23          603             5
2000/01                   5                 489                   0                 494                   480                9          489             5
2001/02                   5                 402                  28                 435                   402               28          430             5
2002/03                   5                 169                  69                 243                   235                3          238             5
2003/04                   5                 332                  22                 359                   341               13          354             5
2004/05                   5                 146                   0                 151                   143                3          146             5
2005/06                   5                 300                   5                 310                   299                7          305             5
2006/07                   5                 348                  22                 375                   355               15          370             5
2007/08                   5                 361                   0                 366                   343               18          361             5
2008/09 2/                5                 360                   0                 365                   350               10          360             5
 N.A. = Not available. 1/ Total supply includes imports. 2/ Forecast.
Sources: Economic Research Service estimates and National Monthly Feedstuff Prices , Agricultural Marketing Service, USDA                         5 year
and U.S. Trade Internet System, Foreign Agricultural Service, USDA.                                                                               10 year
                                                                                                                                                  15 year

                                                                                                                                               2 year




                                                                                50
                                                             Oil Crops Yearbook/OCS-2009/March 2009
                                                                 Economic Research Service, USDA
   Price
 Average,
28 percent
  protein
$/short ton

   111
   106
   100
   111
     52
     68
     76
   103
   120
     97
     88
     77
     90
     95
     63
   124
   111
     84
     64
     75
     91
     87
   105
   111
     86
     77
   105
   173
 135-175

    110.36
     97.39
     96.08

    139




                                 51
              Oil Crops Yearbook/OCS-2009/March 2009
                  Economic Research Service, USDA
Appendix table 23--Sunflowerseed oil: Supply, disappearance, and price, U.S., 1980/81-2008/09
 Year                                         Supply                                                                  Disappearance                             Ending
beginning         Beginning        Production         Imports            Total           Domestic                        Exports              Total             stocks
October 1           stocks

                                                                               ---------- Million pounds ----------

1980/81                  161                657                   0                818                     64               664                728                  90
1981/82                   90                302                   0                392                    139               227                366                  26
1982/83                   26                668                   0                694                     95               505                600                  95
1983/84                   95                450                   0                545                    117               414                531                  13
1984/85                   13                483                   0                496                    143               287                430                  66
1985/86                   66                584                   0                650                    143               452                595                  55
1986/87                   55                587                   0                642                    187               343                530                 112
1987/88                  112                831                   0                943                     84               703                787                 156
1988/89                  156                518                   1                675                    126               468                594                  81
1989/90                   81                475                   5                560                    173               350                522                  38
1990/91                   38                536                  33                607                    201               359                560                  47
1991/92                   47                911                   9                967                    340               527                867                 100
1992/93                  100                730                   0                830                    188               586                774                  56
1993/94                   56                580                   7                643                    129               450                579                  65
1994/95                   65              1,165                   1              1,231                    171               978              1,149                  82
1995/96                   82                860                   2                943                    168               628                796                 147
1996/97                  147                840                  22              1,009                    207               709                916                  93
1997/98                   93                959                   8              1,060                    186               815              1,000                  60
1998/99                   60              1,090                   5              1,155                    233               800              1,033                 121
1999/00                  121              1,055                   4              1,181                    394               630              1,024                 157
2000/01                  157                855                   8              1,020                    339               545                883                 136
2001/02                  136                704                  36                876                    401               453                854                  23
2002/03                   23                295                  61                379                    238               113                352                  27
2003/04                   27                581                  25                633                    357               237                593                  40
2004/05                   40                256                  75                371                    224               125                349                  22
2005/06                   22                524                  56                603                    339               210                549                  54
2006/07                   54                610                 156                820                    590               170                760                  60
2007/08                   60                632                 104                796                    600               169                769                  26
2008/09 1/                26                632                  75                733                    523               160                683                  50
 1/ Forecast.
Sources: Economic Research Service estimates, Consumption, Production, and Stocks , Bureau of Census, National Monthly Feedstuff Prices , Agricultural Marketing Service, USDA
and U.S. Trade Internet System, Foreign Agricultural Service, USDA.




                                                                                51
                                                             Oil Crops Yearbook/OCS-2009/March 2009
                                                                 Economic Research Service, USDA
     Price
   Average,
     crude
  Minneapolis
   Cents/lb.    $/gal

     26.95              2.02
     24.89              1.87
     21.38              1.60
     32.33              2.43
     30.01              2.25
     19.10              1.43
     15.99              1.20
     23.49              1.76
     22.66              1.70
     24.37              1.83
     23.67              1.78
     21.63              1.62
     25.37              1.90
     31.08              2.33
     28.10              2.11
     25.40              1.91
     22.64              1.70
     27.00              2.03
     20.10              1.51
     16.68              1.25
     15.89              1.19
     23.25              1.74
     33.11              2.48
     33.41              2.51
     43.78              3.28
     37.72              2.83
     58.03              4.35
     91.15              6.84
   42.5-45.5

   5 year               3.96
   10 year              2.80
   15 year              2.34

2 year                  5.59




                                                  52
                               Oil Crops Yearbook/OCS-2009/March 2009
                                   Economic Research Service, USDA
Appendix table 24--Canola seed: Acreage planted, harvested, yield, supply and disappearance, U.S., 1991/92-2008/09
Year               Planted      Harvested        Yield                              Supply                                                                   Disappearance                       Price
beginning                                                     Beginning Production       Imports       Total       Crush                                  Exports    Total 1/      Ending      Average     Value
June 1                                                          stocks                                                                                                             stocks      received
                                                                                                                                                                                              by farmers
                    --------1,000 acres----------       Lbs/acre                                                   ---------- Million pounds ----------                                          $/cwt     $1,000    $/ton

1991/92                 155               147            1,300               32           191              2            225              109                97         212          13           9.72       18,582           194
1992/93                 140               112            1,286               13           144             27            184               63               104         174          10           9.90       14,262           198
1993/94                 199               187            1,350               10           252            773          1,036              850                78         940          95          10.90       27,476           218
1994/95                 354               340            1,316               95           447            630          1,173              899               227       1,138          34          11.10       49,802           222
1995/96                 446               429            1,278               34           548            558          1,141              899               138       1,053          88          11.10       60,837           222
1996/97                 367               347            1,384               88           480            570          1,138              868               173       1,059          80          12.90       62,048           258
1997/98                 671               631            1,237               80           781            782          1,642            1,298               277       1,600          42          11.30       88,235           226
1998/99               1,115             1,076            1,448               42         1,558            684          2,284            1,533               543       2,115         169          10.30      160,112           206
1999/00               1,076             1,044            1,306              169         1,364            534          2,066            1,587               299       1,957         109           7.82      106,685           156
2000/01               1,555             1,498            1,334              109         1,998            479          2,587            1,699               486       2,503          84           6.71      120,933           134
2001/02               1,494             1,455            1,374               84         1,999            276          2,358            1,665               480       2,209         149           8.77      175,351           175
2002/03               1,460             1,281            1,197              149         1,533            434          2,116            1,267               633       1,961         155          10.60      162,719           212
2003/04               1,082             1,068            1,416              155         1,512            537          2,205            1,385               671       2,116          88          10.60      159,849           212
2004/05                 865               828            1,618               88         1,340          1,030          2,458            1,976               308       2,327         130          10.70      143,853           214
2005/06               1,159             1,114            1,419              130         1,581          1,143          2,854            2,269               346       2,663         191           9.62      152,033           192
2006/07               1,044             1,021            1,366              191         1,394          1,427          3,012            2,123               542       2,717         295          11.90      165,491           238
2007/08               1,183             1,156            1,238              295         1,431          1,926          3,651            2,287               959       3,306         345          18.30      260,339           366
2008/09 2/            1,183               989            1,461              345         1,445          1,984          3,774            2,658               507       3,227         547       18.35-19.95   276,730
 1/ Includes planting seed and residual. 2/ Forecast.
Sources: Crop Production, Grain Stocks, and Crop Values , National Agricultural Statistics Service and U.S. Trade Internet System, Foreign Agricultural Service, USDA.                    5 year 12.22     199689            244
                                                                                                                                                                                         10 year 10.53     172398            211

                                                                                                                                                                                2 year          15.10      212915     302.00




                                                                                                            52
                                                                                         Oil Crops Yearbook/OCS-2009/March 2009
                                                                                             Economic Research Service, USDA
Appendix table 26--Canola meal: Supply and disappearance, U.S., 1991/92-2008/09
Year                                      Supply                                                                        Disappearance                                   Price
beginning        Beginning      Production       Imports          Total              Domestic                         Exports      Total                Ending        Pacific NW
Oct. 1             stocks                                                                                                                               stocks
                                                                    1,000 short tons                                                                                 $/short ton

1991/92                   6                19                621                 646                   640                0             640                  6           145
1992/93                   6                39                603                 648                   642                0             642                  6           138
1993/94                   6               322                780               1,108                 1,102                0           1,102                  6           129
1994/95                   6               236                815               1,057                 1,047                4           1,051                  6           128
1995/96                   6               281              1,013               1,300                 1,292                2           1,294                  6           177
1996/97                   6               270                954               1,230                 1,214               10           1,224                  6           192
1997/98                   6               356              1,372               1,734                 1,710               18           1,728                  6           131
1998/99                   6               432              1,194               1,632                 1,619                7           1,626                  6           112
1999/00                   6               487              1,260               1,753                 1,735               12           1,747                  6           117
2000/01                   6               506              1,178               1,690                 1,673               11           1,684                  6           139
2001/02                   6               460                921               1,387                 1,373                8           1,381                  6           143
2002/03                   6               392              1,013               1,411                 1,371               34           1,405                  6           144
2003/04                   6               475              1,638               2,119                 2,073               39           2,113                  6           188
2004/05                   6               622              1,482               2,110                 2,070               34           2,104                  6           140
2005/06                   6               666              1,611               2,283                 2,223               54           2,277                  6           141
2006/07                   6               653              1,651               2,310                 2,237               66           2,304                  6           173
2007/08                   6               723              2,000               2,729                 2,614              109           2,723                  6           251
2008/09 1/                6               850              2,105               2,961                 2,842              113           2,955                  6         210-250
 1/ Forecast.
Sources: Economic Research Service estimates, National Monthly Feedstuff Prices , Agricultural Marketing Service and U.S. Trade Internet System, Foreign5 year            178.59
                                                                                                                                                         Agricultural Service, USDA.
                                                                                                                                                       10 year           154.80

                                                                                                                                                    2 year                    212




                                                                                54
                                                             Oil Crops Yearbook/OCS-2009/March 2009
                                                                 Economic Research Service, USDA
Appendix table 25--Canola oil: Supply and disappearance, U.S., 1991/92-2008/09
Year                                      Supply                                                               Disappearance
beginning       Beginning       Production         Imports          Total                  Domestic          Exports      Total               Ending
Oct. 1            stocks                                                                                                                      stocks
                                                                             Million pounds
1991/92               41                25                 815               881                795             15               810             71
1992/93               71                49                 861               981                898             16               914             67
1993/94               67               406                 902             1,375              1,162             76             1,238            137
1994/95              137               299                 938             1,374              1,167            153             1,320             54
1995/96               54               356               1,086             1,496              1,272            147             1,419             77
1996/97               77               342               1,075             1,494              1,134            295             1,429             65
1997/98               65               451               1,088             1,604              1,143            349             1,492            112
1998/99              112               548               1,060             1,720              1,279            272             1,551            169
1999/00              169               617               1,139             1,925              1,435            284             1,719            206
2000/01              206               641               1,193             2,040              1,743            187             1,930            110
2001/02              110               582               1,108             1,800              1,493            255             1,748             52
2002/03               52               496                 981             1,529              1,284            161             1,445             84
2003/04               84               601               1,223             1,908              1,539            278             1,817             91
2004/05               91               798               1,133             2,023              1,626            269             1,894            128
2005/06              128               838               1,598             2,564              1,829            471             2,301            264
2006/07              264               828               1,568             2,659              1,880            630             2,510            149
2007/08              149               964               2,241             3,354              2,873            349             3,221            133
2008/09 1/           133             1,105               2,563             3,801              3,393            287             3,680            121
 1/ Forecast.
Sources: Economic Research Service estimates, Production, Consumption and Stocks , Bureau of Census, and U.S. Trade Internet System, Foreign Agricultural Service, USDA
and Milling & Baking News.




                                                                     53
                                                  Oil Crops Yearbook/OCS-2009/March 2009
                                                      Economic Research Service, USDA
  Price
 Midwest

 Cents/lb.   $/gal
   23.65             1.77
   21.98             1.65
   23.97             1.80
   28.55             2.14
   29.03             2.18
   25.68             1.93
   28.83             2.16
   22.48             1.69
   17.11             1.28
   17.56             1.32
   23.45             1.76
   29.75             2.23
   33.76             2.53
   30.78             2.31
   31.00             2.33
   40.57             3.04
   65.64             4.92
36.5-39.5


  5 year             3.03
 10 year             2.34

2 year               3.98




                                               54
                            Oil Crops Yearbook/OCS-2009/March 2009
                                Economic Research Service, USDA
Historical Methanol Prices
Source: http://www.methanex.com/products/documents/MxAvgPrice_Feb252010.pdf

12 MO AVERAGE                              $0.87
2 YR AVERAGE                               $1.07
5 YR AVERAGE                               $1.21


           Methanex Non-Discounted
           Reference Price




Date       $/gal
 Jan 2001             n/a
 Feb 2001             n/a
 Mar 2001             n/a
 Apr 2001             n/a
May 2001             $0.77
 Jun 2001            $0.67
  Jul 2001           $0.57
 Aug 2001            $0.51
 Sep 2001            $0.42
 Oct 2001            $0.37
 Nov 2001            $0.40
 Dec 2001            $0.40
 Jan 2002            $0.38
 Feb 2002            $0.36
 Mar 2002            $0.38
 Apr 2002            $0.42
May 2002             $0.50
 Jun 2002            $0.56
  Jul 2002           $0.62
 Aug 2002            $0.62
 Sep 2002            $0.62
 Oct 2002            $0.62
 Nov 2002            $0.62
 Dec 2002            $0.62
 Jan 2003            $0.69
 Feb 2003            $0.79
 Mar 2003            $0.82
 Apr 2003            $0.82
May 2003             $0.82
 Jun 2003            $0.82
  Jul 2003           $0.78
 Aug 2003            $0.72
 Sep 2003            $0.70
 Oct 2003            $0.68
 Nov 2003            $0.68
 Dec 2003            $0.68
 Jan 2004            $0.75
Feb 2004    $0.75
Mar 2004    $0.75
Apr 2004    $0.75
May 2004    $0.75
Jun 2004    $0.81
 Jul 2004   $0.84
Aug 2004    $0.84
Sep 2004    $0.84
Oct 2004    $0.84
Nov 2004    $0.90
Dec 2004    $0.95
Jan 2005    $0.95
Feb 2005    $0.95
Mar 2005    $0.95
Apr 2005    $0.95
May 2005    $0.95
Jun 2005    $0.95
 Jul 2005   $0.90
Aug 2005    $0.90
Sep 2005    $0.90
Oct 2005    $0.96
Nov 2005    $0.96
Dec 2005    $1.02
Jan 2006    $1.02
Feb 2006    $1.07
Mar 2006    $1.07
Apr 2006    $1.07
May 2006    $1.03
Jun 2006    $1.03
 Jul 2006   $1.00
Aug 2006    $1.03
Sep 2006    $1.33
Oct 2006    $1.80
Nov 2006    $1.80
Dec 2006    $1.80
Jan 2007    $1.80
Feb 2007    $1.65
Mar 2007    $1.55
Apr 2007    $1.01
May 2007    $1.01
Jun 2007    $1.01
 Jul 2007   $0.93
Aug 2007    $0.93
Sep 2007    $0.96
Oct 2007    $1.70
Nov 2007    $2.00
Dec 2007    $2.50
Jan 2008    $2.50
Feb 2008    $2.10
Mar 2008    $1.90
Apr 2008    $1.60
May 2008    $1.50
Jun 2008    $1.58
 Jul 2008   $1.58
Aug 2008    $1.58
Sep 2008    $1.58
Oct 2008    $1.50
Nov 2008    $1.40
Dec 2008    $1.00
Jan 2009    $0.70
Feb 2009    $0.70
Mar 2009    $0.65
Apr 2009    $0.60
May 2009    $0.60
Jun 2009    $0.60
 Jul 2009   $0.68
Aug 2009    $0.72
Sep 2009    $0.84
Oct 2009    $0.95
Nov 2009    $1.00
Dec 2009    $1.10
Jan 2010    $1.10
Feb 2010    $1.10
Mar 2010    $1.10
Back to Contents    Data 1: U.S. No 2 Diesel Commercial Price by All Sellers (Cents per Gallon) - Exclud
   Sourcekey             D220200002
                       U.S. No 2 Diesel
                    Commercial Price by
                    All Sellers (Cents per
      Date                  Gallon)          $/gal
             1994                     57.7    $    0.58
             1995                     58.8    $    0.59
             1996                     71.1    $    0.71
             1997                     66.6    $    0.67
             1998                     51.6    $    0.52
             1999                     60.5    $    0.61
             2000                     95.8    $    0.96
             2001                     85.7    $    0.86
             2002                     78.9    $    0.79
             2003                     96.1    $    0.96
             2004                    126.8    $    1.27
             2005                    181.7    $    1.82
             2006                    209.2    $    2.09
             2007                    228.4    $    2.28
             2008                    314.3    $    3.14
             2009                    186.3    $    1.86

2 year                                       $    2.50
5 year                                       $    2.24
10 year                                      $    1.60

Source USDOE EIA
http://tonto.eia.doe.gov/dnav/pet/hist/LeafHandler.ashx?n=pet&s=d220200002&f=a
ts per Gallon) - Excludes taxes

								
To top