{"text_format":"2","workbook":"xls","n_sheets":7,"sheets":["Summary","Planting","Growing","Harvesting","Capital","Energy","Other"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Summary","index":0,"n_rows":36,"n_cols":7,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8],[34,6,34,8],[35,6,35,8],[36,6,36,8],[11,0,12,0],[15,0,17,0],[34,2,34,3],[35,2,35,3],[26,1,26,2],[27,1,27,2],[28,1,28,2],[33,2,33,3]],"flags":["formulas_cached_only"]}
[" COST ANALYSIS SUMMARY"]
["Purpose: This worksheet is intended to provide an estimated production cost of the fuel using the proposed technology.  The total calculated value will be based on cost estimates provided by the applicant for growing the crop and processing the crop into fuel.  Fields in yellow need to be filled in by the applicant, while grey fields will automatically be populated based on the data provided."]
[]
[]
["Applicant:","Big Corn Inc."]
["Feedstock:","Corn "]
["Fuel Molecule:","Ethanol"]
["Energy Content (MJ/L):",21.1]
[]
["Cost Categories",null,"$/L fuel","$/GJ","% of cost"]
["Crop Feedstock","Planting",0.19798245614035084,9.383054793381556,0.3616761775886474]
["Cost to produce the biomass containing the fuel molecules","Growing",0.11123604465709727,5.271850457682335,0.20320703271374083]
[null,"Harvesting",0.06986921850079743,3.311337369706039,0.12763773301489076]
[]
["Feedstock Processing","Capital/Equipment",0.09350000000000001,4.431279620853081,0.1708066626901814]
["Costs to extract the energy-rich molecules from the biomass and refine them into the final fuel.","Energy",0.02851851851851852,1.3515885553800246,0.05209789275953245]
[null,"Other",0.04629629629629631,2.194137265227313,0.08457450123300723]
[]
[null,"TOTAL:",0.5474025341130604,25.943248062230346,1]
[]
[]
[]
[]
[]
[]
["Provide a description of the crop(s) used as feedstocks for the production of fuel and it's expected yield per hectare of the biomass component that contains the fuel."]
["Crop Yield","Description",null,"kg/ha","Reference"]
["Feedstock 1","Corn",null,10312.5,"Shapouri et al., (2002)"]
["Feedstock 2"]
[]
[]
[]
["Provide a list of the fuel molecules generated from the feedstock, including the quantity of biomass needed to produce 1 liter of the fuel.  Also include the size of the proposed biorefinery to allow an assessment of the proposed costs."]
["Feedstock products","Fuel molecule","Biorefinery scale (ML/yr)",null,"Feedstock usage (kg/L fuel)"]
["Compound 1","Ethanol",100,null,2.4342105263157894,null,"Reference"]
["Compound 2",{"$nulls":5},"Shapouri et al., (2002)"]

{"sheet":"Planting","index":1,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[[22,0,22,4],[1,0,1,4],[0,0,0,4],[4,3,12,3],[4,4,12,4],[41,0,41,3],[44,3,44,4],[45,0,48,0],[45,3,45,4],[46,3,46,4],[47,3,47,4],[48,3,48,4],[69,2,70,2],[69,3,70,3],[50,0,53,0],[50,3,50,4],[51,3,51,4],[52,3,52,4],[53,3,53,4],[55,0,59,0],[55,3,55,4],[56,3,56,4],[57,3,57,4],[58,3,58,4],[59,3,59,4],[60,3,60,4],[61,3,61,4],[62,3,62,4],[64,0,64,4],[75,0,76,0],[75,1,76,1],[75,2,76,2],[75,3,76,3],[71,0,72,0],[71,1,72,1],[71,2,72,2],[71,3,72,3],[73,0,74,0],[73,1,74,1],[73,2,74,2],[73,3,74,3],[69,0,70,0],[69,1,70,1]],"flags":["formulas_cached_only"]}
["FEEDSTOCK PRODUCTION COSTS - PLANTING"]
["Provide the estimated costs associated with the planting of proposed feedstock(s) for the large scale (>100,000 acres) production of the crop. Explain how these costs were estimated and provide citations if possible. The cost per hectare will be used to calculate the cost per liter biomass based on the yield of the feedstock grown and the yield of fuel produced from the feedstock."]
[]
["Costs","$/ha","$/L","Explanation","Reference"]
["Seed",258,0.060899521531100474,"Each of these planting costs were broken out from the  actual costs to produce 100 million gallons of EtOH.  In 1998 that required 37,202,381 bushels of corn grown on 225,469 acres at a total cost of $144 million.","Shapouri, H. , P. Gallagher, M. S. Graboski, USDA’s 1998 Ethanol Cost-of-Production Survey. U.S. Dept. of Agriculture, FAER 808. 2002"]
["Land",487.5,0.11507177033492823]
["Chisel plow",17.25,0.00407177033492823]
["Tandem disk",13.999999999999998,0.003304625199362041]
["Apply nitrogen",20.75,0.00489792663476874]
["Field cultivate",10.749999999999998,0.0025374800637958527]
["Planting",18,0.004248803827751196]
["Cultivate",7.249999999999999,0.0017113237639553426]
["Spray",5.25,0.0012392344497607654]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[]
["Total",838.75,0.19798245614035084]

{"sheet":"Growing","index":2,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":false,"merged":[[36,0,36,3],[0,0,0,4],[1,0,2,4],[5,3,13,3],[5,4,13,4],[39,3,39,4],[40,0,43,0],[40,3,40,4],[41,3,41,4],[42,3,42,4],[43,3,43,4],[64,2,65,2],[64,3,65,3],[45,0,48,0],[45,3,45,4],[46,3,46,4],[47,3,47,4],[48,3,48,4],[50,0,54,0],[50,3,50,4],[51,3,51,4],[52,3,52,4],[53,3,53,4],[54,3,54,4],[55,3,55,4],[56,3,56,4],[57,3,57,4],[59,0,59,4],[70,0,71,0],[70,1,71,1],[70,2,71,2],[70,3,71,3],[66,0,67,0],[66,1,67,1],[66,2,67,2],[66,3,67,3],[68,0,69,0],[68,1,69,1],[68,2,69,2],[68,3,69,3],[64,0,65,0],[64,1,65,1]],"flags":["formulas_cached_only"]}
["FEEDSTOCK PRODUCTION COSTS - GROWING"]
["Provide the estimated costs associated with the growing the proposed feedstock(s) for the large scale (>100,000 acres) production of the crop. Explain how these costs were estimated and provide citations if possible. The cost per hectare will be used to calculate the cost per liter biomass based on the yield of the feedstock grown and the yield of fuel produced from the feedstock."]
[]
[]
["Costs","$/ha","$/L","Explanation","Reference"]
["Nitrogen",147.5,0.03481658692185008,"Each of these growing costs were broken out from the  actual costs to produce 100 million gallons of EtOH.  In 1998 that required 37,202,381 bushels of corn grown on 225,469 acres at a total cost of $144 million.","Shapouri, H. , P. Gallagher, M. S. Graboski, USDA’s 1998 Ethanol Cost-of-Production Survey. U.S. Dept. of Agriculture, FAER 808. 2002"]
["Phosphate",60,0.01416267942583732]
["Potash",55,0.012982456140350877]
["Lime",24.249999999999996,0.0057240829346092495]
["Herbicide",62.5,0.014752791068580542]
["Insecticide",25,0.005901116427432217]
["Crop insurance",42.5,0.010031897926634769]
["Miscellaneous",22.5,0.005311004784688995]
["Interest1",32,0.007553429027113237]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[]
["Total",471.25,0.11123604465709727]
[]
["1on preharvest variable costs"]

{"sheet":"Harvesting","index":3,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[[61,3,61,4],[63,0,63,4],[74,0,75,0],[74,1,75,1],[74,2,75,2],[74,3,75,3],[70,0,71,0],[70,1,71,1],[70,2,71,2],[70,3,71,3],[72,0,73,0],[72,1,73,1],[72,2,73,2],[72,3,73,3],[68,0,69,0],[68,1,69,1],[68,2,69,2],[68,3,69,3],[49,0,52,0],[49,3,49,4],[50,3,50,4],[51,3,51,4],[52,3,52,4],[54,0,58,0],[54,3,54,4],[55,3,55,4],[56,3,56,4],[57,3,57,4],[58,3,58,4],[59,3,59,4],[60,3,60,4],[40,0,40,3],[43,3,43,4],[44,0,47,0],[44,3,44,4],[45,3,45,4],[46,3,46,4],[47,3,47,4],[25,0,25,5],[0,0,0,4],[1,0,1,4],[4,3,17,3],[4,4,17,4],[21,0,21,4]],"flags":["formulas_cached_only"]}
["FEEDSTOCK PRODUCTION COSTS - HARVESTING"]
["Provide the estimated costs associated with the harvesting of proposed feedstock(s) for the large scale (>100,000 acres) production of the crop. Explain how these costs were estimated and provide citations if possible. The cost per hectare will be used to calculate the cost per liter biomass based on the yield of the feedstock grown and the yield of fuel produced from the feedstock."]
[]
["Costs","$/ha","$/L","Explanation","Reference"]
["Combine",60.49999999999999,0.014280701754385963,"Each of these harvest costs were broken out from the  actual costs to produce 100 million gallons of EtOH.  In 1998 that required 37,202,381 bushels of corn grown on 225,469 acres at a total cost of $144 million.","Shapouri, H. , P. Gallagher, M. S. Graboski, USDA’s 1998 Ethanol Cost-of-Production Survey. U.S. Dept. of Agriculture, FAER 808. 2002"]
["Grain Cart",17,0.004012759170653907]
["Haul",32.99999999999999,0.007789473684210524]
["Drying",100.74999999999999,0.02378149920255183]
["Handling",6.25,0.0014752791068580542]
["Labor",78.49999999999999,0.018529505582137156]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[]
["Total",296,0.06986921850079743]

{"sheet":"Capital","index":4,"n_rows":22,"n_cols":4,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3],[21,0,21,3],[4,3,6,3]],"flags":["formulas_cached_only"]}
["FEEDSTOCK PROCESSING COSTS - CAPITAL/EQUIPMENT"]
["Provide the estimated capital and equipment costs involved in running a large scale biorefinery for the proposed feedstock.  Explain how these costs were estimated and provide citations if possible. The costs for each category will be used to calculate the total cost per liter of biofuel ."]
[]
["Costs","¢/L","Explanation","Reference"]
["Capital Depreciation",8.157894736842106,"See below1","Eidman, \"Ethanol Economics of Dry Mill Plants\", Chapter 3 in Corn-Based Ethanol in Illinois and the U.S., University of IL 2007."]
["Maintenance",1.1921052631578948,"Actual costs for regular equipment maintenance."]
{"$rows_empty":13}
["Total",0.09350000000000001]
[]
["1. Cost of an 100 million GPY EtOH plant is estimated at $180 million.  40% will be financed as debt over 15 years at a rate of 8.75% and the remaining equity will have an annual return of %12."]

{"sheet":"Energy","index":5,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3],[21,0,21,3],[4,2,6,2],[4,3,6,3]],"flags":["formulas_cached_only"]}
["FEEDSTOCK PROCESSING COSTS - ENERGY"]
["Provide the estimated energy costs involved in running a large scale biorefinery for the proposed feedstock.  Explain how these costs were estimated and provide citations if possible. The costs for each category will be used to calculate the total cost per liter of biofuel ."]
[]
["Costs","¢/L","Explanation","Reference"]
["Electricity",1.1481481481481481,"Energy costs were identified in the actual costs to produce 100 million gallons of EtOH in 1998 in an 100 million gallon/yr biorefinery.","Eidman, \"Ethanol Economics of Dry Mill Plants\", Chapter 3 in Corn-Based Ethanol in Illinois and the U.S., University of IL 2007."]
["Fuels",1.703703703703704]
{"$rows_empty":13}
["Total",0.02851851851851852]

{"sheet":"Other","index":6,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3],[21,0,21,3],[4,2,9,2],[4,3,9,3]],"flags":["formulas_cached_only"]}
["FEEDSTOCK PROCESSING COSTS - OTHER"]
["Provide the estimated costs involved in running a large scale biorefinery for the proposed feedstock for all inputs besides capital/equipment and energy expenses.  Explain how these costs were estimated and provide citations if possible. The costs for each category will be used to calculate the total cost per liter of biofuel ."]
[]
["Costs","¢/L","Explanation","Reference"]
["Labor",1.8783068783068784,"These costs were broken out of the actual costs to produce 100 million gallons of EtOH in 1998 in an 100 million gallon/yr biorefinery.","Eidman, \"Ethanol Economics of Dry Mill Plants\", Chapter 3 in Corn-Based Ethanol in Illinois and the U.S., University of Illinois, 2007."]
["Waste",0.18518518518518517]
["Enzymes",1.3227513227513228]
["Yeast",0.052910052910052914]
["Chemicals",0.6613756613756614]
["Denaturant",0.5291005291005292]
{"$rows_empty":9}
["Total",0.04629629629629631]