Biodiesel_Cost_Income_Calculator_May22

Document Sample
Biodiesel_Cost_Income_Calculator_May22 Powered By Docstoc
					                 Feasibility of Biodiesel in the Treasure Valley
                                 Feedstock Evaulation Sheet

   Instructions: In column I enter your data for your plant in the grey cells. The white cells
   are locked and contain formula's. Yellow cells are to contain the total of the cells
   immediately above , either use a Sum function or enter the sum directly.


Desired Annual Capacity                                       Model               Estimate A
   a. Used Oil, gallons                                           500,000                         0
   b. Tallow, gallons                                           3,500,000                         0
   c. Virgin Oils, gallons                                               0            17,529,600
   d. Total Annual Capacity, gallons                            4,000,000             17,529,600
Selected Feedstocks
   a. Used Oil
         I.   Pounds available                                  3,750,000                         0
       ii. Cost ($/lb)                                            $0.100                 $0.100
       iii. Total Cost                                          $375,000                         $0
                                                                                                       1/
       iv. Weight per gallon                                          7.50                   7.50
       v. Gallons available                                       500,000                         0
   b. Tallow
       i. Pounds available                                     26,250,000                         0
       ii. Cost ($/lb)                                            $0.112                 $0.112
       iii. Total Cost                                        $2,940,000                         $0
                                                                                                       1/
       iv. Weight per gallon                                          7.50                   7.50
       v. Gallons available                                     3,500,000                         0
   c. Virgin Oils
       i. Acres                                                          0               166,000
       ii. Estimated average Yield. Lbs/acre                         2,200                 2,200
       iii. Total Pounds of seed                                         0          365,200,000
       iv. Cost per pound of seed ($/lb)                          $0.111                 $0.111
       v. Cleaning and handling cost ($/lb)                       $0.040                 $0.040
       vi. Total Seed Cost                                             $0          $55,145,200
       vii. Percentage oil in seed                                    40%                   40%
       vii. Estimated crushing recovery of oil (%)                    90%                   90%
                                                                                                       1/
       viii. Oil weight per gallon, lb                                 7.5                       7.5
       ix. Gallons of oil available for Biodiesel                       0            17,529,600
   d. Total Annual Production, gallons                          4,000,000            17,529,600
   e. Total Annual Cost of Feedstocks                         $3,315,000           $55,145,200
    1/
         7.5 lb/gal is a nominal weight for raw oil
Notes:




(7.5 lb/gal is a nominal weight for raw oil)




(7.5 lb/gal is a nominal weight for raw oil)




Enter the seed price on the Calculations page, cell K25




(7.5 lb/gal is a nominal weight for raw oil)
                Feasibility of Biodiesel in the Treasure Valley
                          Chemical Feedstock Evaulation Sheet

Instructions: In column J enter your data for your plant in the grey cells. The white cells are
locked and contain formula's.




                                                                   Model              Estimate A
Methanol
    a. Cost per gallon for methanol                                    $0.80                        0.8
                                                                                                          1/
    b. Gallons required per gallon of biodiesel                         0.175                     0.175
    c. Total gallons of methanol required                            700,000              3,067,680
    Total Cost                                                     $560,000             $2,454,144
Catalyst
                                                                                                          2/
    a. Cost of catalyst per gallon of biodiesel                       $0.073                 $0.073
    b. Total Cost                                                  $292,000             $1,279,661
FFA Treatment (If Used)
    a. Cost of ffa treatment per gallon of biodiesel                  $0.060                 $0.060
    b. Gallons of oil treated                                      4,000,000                         0
    c. Total Cost of FFA treatment                                 $240,000                         $0

Total Chemical Cost                                              $1,092,000             $3,733,805

   1/
        0.125 assumes 0.25 gallon required per gallon of production with a 50% recovery rate.
   2/
        ($0.073/gallon of biodiesel production)
Notes:



0.125 assumes 0.25 gallon required per gallon of production with a 50% recovery rate.




($0.073/gallon of biodiesel production)
                                                                                                  12/10/2011
                            PROJECT COST ESTIMATE
                       Treasure Valley Biodiesel Plant
                          Capacity -------------- 4,000,000 Gallons per Year


PRE-DESIGN DEVELOPMENT
   Business Plan        $25,000          +         $10    /1000 Gal.                                $65,000
   Licensing Permiting $35,000           +         $10    /1000 Gal.                                $75,000
   Agreements           $25,000          +         $10    /1000 Gal.                                $65,000
   Site Acquistion     $165,000          +          0.5   Acre/5 MGal./Yr                          $165,000
                              1.0 Acre                    Pre-Design Development Total             $370,000
SITE WORK, FOUNDATION, STRUCTURE & BUILDING EXTERIOR
              5,000 /sqFt +          3,000 sqFt/5 MGal./Yr @ $50.00 /sqFt                           250,000
                          5,000 sqFt                         Building Total                        $250,000
EQUIPMENT
   Tankage                     14   Day Capacity
       Feedstock          153,425   Gallon @    $0.55 /Gal.                                          $84,384
       Methanol           117,664   Gallon @    $1.10 /Gal. +               $16,000         6       $145,431
       Biodiesel          153,425   Gallon @    $0.55 /Gal.                                          $84,384
       Glycerol            15,342   Gallon @    $0.55 /Gal.                                           $8,438
       Reactors             5,479   Gallon @    $1.00 /Gal.                                           $5,479
   Seperators                        $20,000      +         $10             /1000 Gal.               $60,000
   Heaters, Dryers & Other           $10,000      +          $5             /1000 Gal.               $30,000
   Piping                            $20,000      +          $5             /1000 Gal.               $40,000
   Pumps                             $20,000      +         $15             /1000 Gal.      18       $60,000
   Laboratory                        $50,000      +          $5             /1000 Gal.               $70,000
   Controls                          $20,000      +         $30             /1000 Gal.              $140,000
   Fire Supression                   $20,000      +          $5             /1000 Gal.               $40,000
   Misc.                               5.0%    of Equipment Cost                                     $38,406
   Miscellaneous                                                                                    $500,000
   Installation                        15.0% of Equipment Cost                                      $120,978
                                                                             Equipment Total      $1,427,500

                                               TOTAL DIRECT COST                                   2,047,500
                                               CONTINGENCY                           10 %            204,750
                                                                TOTAL                              2,252,250

CONSTRUCTION MANAGEMENT                              3 % Project Cost                                67,567
ENGINEERING & DESIGN                                10 % Project Cost                               225,225
OPERATION & PLANT START-UP                           5 % Project Cost                               112,612
                                                    TOTAL CONSTRUCTION COST                      $2,657,655
                                      Plant Cost Per Gallon of Annual Production                     $0.664
Size Factor

    -1        Set for Column B only




Assumes starting a batch every other day.
                Feasibility of Biodiesel in the Treasure Valley
                                                Other Expenses
      Instructions: In column J enter your data for your plant in the grey cells. The white cells are locked and contain
     formula's. Yellow cells are to contain the total of the cells immediately above , either use a Sum function or enter
                                                        the sum directly.

                                                                                        Model             Estimate A

Miscellaneous Freight Charges Not included Elsewhere                    $0.050           $200,000             $876,480
Enter estimate per gallon in F13

In-plant Meal handling
    a. Cost/ ton                                                                            $0.000               $0.010
    b. Tons handled                                                                                0
    c. Total Meal Handling charge                                                                $0                   $0

In-plant Glycerol handling and purification
    a. Cost/gallon                                                                          $0.000               $0.000
    b. Gallons handled                                                                     100,000              100,000
    c. Total Glycerol handling                                                                   $0                   $0

Crushing Charge
   a. Tons crushed                                                                                 0            182,600
   b. Estimated cost per ton                                                                $50.00               $50.00
   c. Total Crushing charge                                                                      $0         $9,130,000

Cost of Plant Operation
   a. Energy                                                                                                     $0.030
   b. Labor                                                                                                      $0.034
          Plant Cost $/gal of annual production                          $0.664
   c. Capital Recovery                                                                                           $0.090
   d. Maintenance
   e. Administration, sales                                                                                      $0.065
   f. Analytical Services                                                                                        $0.001
   g. Miscellaneous Costs
   h. Total Plant Operation Cost/gallon                                                     $0.217               $0.219
   i. Total Plant Operation Cost                                                         $866,103           $3,837,346

Total Cost
    a. Total Cost                                                                      $5,473,103         $72,722,831
    b. Cost/gallon of biodiesel                                                              $1.37                $4.15
    c. Ratio of Feedstock cost to total cost                                                    61%                 76%
           Notes:




           Estimate of Plant Operation Cost:
                            Cost/gal gallons per year
                                   0.3    500000
                                0.219 17,529,600
                                    0.2 21,500,000 21,000,000
                                    0.1                  3970400




           ($50.00/ton)




           See computation on Calculation sheet
           CR is computed based on 7% interest, 10% salvage, and 10 year life


For Estimate A only
           Enter 1 in cell J35 if COST Page is used
        0 Enter 0 in J35 and your estimate of
   $0.219 Plant Operation Cost Per "Gallon in J36
       0.2 if the Cost Page is not used

           Use this in lieu of estimating a-h or estimate a-h and sum them to obtain I or j
            depending on whether they are input as total plant costs or costs/gallon..
            Feasibility of Biodiesel in the Treasure Valley
                                Income

Biodiesel Production Plant Income              Model          Estimate A
1. Biodiesel Sales
      a. Selling Price per gallon                   $2.20            $2.20
          (FOB Plant Gate)
      b. Gallons Sold                           4,000,000       17,529,600
      c. Total Biodiesel Income                $8,800,000      $38,565,120
2. Meal Sales
      a. Price per ton                                 125             125
           (FOB Plant Gate)
      b. Tons sold                                       0         116,864
      c. Total Meal Income                              $0     $14,608,000
3. Glycerol Sales
      a. Price per pound                               0.05           0.05
          (FOB Plant Gate)
      b. Pounds sold                              400,000        1,752,960
      c. Total Glycerol Income                   $20,000          $87,648
4. Local State and Federal Incentives
      a. Local Incentives ($/gal)                   $0.00                  0
      b. State Incentives ($/gal)                   $0.00                  0
      c. Federal Incentives ($/gal)                 $0.00                  0
      Total Incentive Income                            $0             $0
5. Other Income
6. Total Income
      a. Total Income                          $8,820,000      $53,260,768
      b. Income per gallon of plant capacity        $2.21            $3.04



Plant Profit or Loss                                $0.84           ($1.11)
Computation of Capital Recovery, CRF

Principal amount               P                0.6644137                    I/q                  0.07
Payment                        R                                             (1+I/q)              1.07
Salvage as a percent of P                              0.1                   n*q                    10
Salvage Value                  S                0.0664414                    p-s             0.597972
                               q
Number of compounding periods per year                   1                   si/q            0.004651
Interest Rate/period           I                      0.07
Life of investment, years      n                        10                   num             0.137701
                                                                             den             0.967151

                                                                             CRF                 0.090 This value is currently refe

Enter Seed Price in K25                              0.111                   To use the sensitivity analysis cells H31 and I31 on the feedsto
                                                                             page must reference E17 on this page:
                                              11 Million     21 Million      (=Calculations!E17)
                                                                             Highlight the table (A30:F38E32) and use Data | Ta
Cost Per Gallon                                     $1.37           $4.15
Gross Profit or Loss                                $0.84          ($1.11)
% Feedstock Cost                                      61%             76%

Sensitivity Analysis
Cost Per Gallon and Profit or Loss Versus Seed Price

                       11 Million Gallon Plant 2.5 Million Gallon Plant
Seed Price, cents/lb      Cost         Profit      Cost          Profit
                               1.37      0.84          4.15         (1.11)
              $0.06            1.37      0.84          3.09         (0.05)
              $0.08            1.37      0.84          3.50         (0.46)
              $0.10            1.37      0.84          3.92         (0.88)
              $0.12            1.37      0.84          4.34         (1.30)
              $0.14            1.37      0.84          4.75         (1.71)
              $0.16            1.37      0.84          5.17         (2.13)
              $0.18            1.37      0.84          5.59         (2.55)
              $0.20            1.37      0.84          6.00         (2.96)


 This table will automatically update, if the only changes to the spreadsheet are inputs
 in the grey areas (on any page), and if cells H31 and I30 on the feedstock page remain
                                   referenced to E17.
  This value is currently referenced by cells by cells I31 on the Expense Page

ysis cells H31 and I31 on the feedstock
on this page:


30:F38E32) and use Data | Table and set the column cell to E17.

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:2
posted:12/11/2011
language:
pages:11