{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Switchgrass Establishment Bdgt","Switchgrass Production Budget","Cost Analysis"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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"}

{"sheet":"Switchgrass Establishment Bdgt","index":0,"n_rows":41,"n_cols":6,"rows_kept":41,"cut":false,"hidden":false,"merged":[[32,0,33,5],[36,0,37,5]]}
[]
["You can change the cells highlighted in yellow to match your specific operation. Columns E & F Autopopulate based on these numbers"]
[]
["Switchgrass Production Budget - Establishment Year"]
[]
[]
[]
["Establishment",null,"Unit","Quantity","Price","$/acre"]
["Inputs"]
["Land Rent1",null,"acre",1,0,{"$f":"D10*E10","v":0}]
["Seed",null,"lb./PLS",6.5,12,{"$f":"D11*E11","v":78}]
["Nitrogen2","46-0-0 Urea","lbs",0,343,{"$f":"IF(D12>0,(E12/(2000*0.46))*(D12-((D13/0.46)*0.18)),0)","v":0}]
["Phosphorous2","18-46-0 DAP","lbs",40,400,{"$f":"(E13/(2000*0.46))*D13","v":17.391304347826086}]
["Potassium2","0-0-60 Potash","lbs",80,378,{"$f":"(E14/(2000*0.6))*D14","v":25.2}]
["Lime3",null,"ton",1,30,{"$f":"D15*E15","v":30}]
["Herbicide","Late Fall/Early Spring","qt.",1,4.88,4.88]
["Herbicide","Preplant","qt.",1,4.88,4.88]
[]
[null,null,null,null,"Subtotal",{"$f":"SUM(F10:F17)","v":160.3513043478261}]
["Pre Harvest Equipment Operations4"]
["Fertilizer Application",null,null,1,8,{"$f":"D21*E21","v":8}]
["Herbicide Application",null,null,2,8.5,{"$f":"D22*E22","v":17}]
["Planting",null,null,1,24,24]
["Rotary Mowing5",null,null,2,6.12,12.24]
[]
[null,null,null,null,"Subtotal",{"$f":"SUM(F21:F24)","v":61.24}]
[]
[]
[null,null,null,null,"Total Establishment Cost",{"$f":"SUM(F19,F26)","v":221.59130434782611}]
[]
["Footnotes"]
["1) Add in your land rent or property costs on a per acre basis"]
["2) Enter price per ton from your supplier. For quantity, follow recommendations from soil test and adjust accordingly. Nitrogen is not recommended in establishment year."]
[]
["3) Switchgrass is most productive in soil PH ranging from 6.0-8.0; Follow recommendations from soil test and adjust accordingly."]
["4) Equipment Operation expenses are based on custom crew rates. If doing this work yourself, rates could be different."]
["5) Used after emergence in establishment year to control broadleaf weeds.  Care must be taken to not mow lower than the height of maturing switchgrass."]
[]
[]
["Copyright 2020"]
["Genera Inc.",null,null,null,null,"generainc.com/farmers"]

{"sheet":"Switchgrass Production Budget","index":1,"n_rows":45,"n_cols":7,"rows_kept":45,"cut":false,"hidden":false,"merged":[[37,0,38,6]]}
[]
["You can change the cells highlighted in yellow to match your specific operation. Columns E & F Autopopulate based on these numbers"]
[]
["Switchgrass Production Budget - After Establishment Year"]
[]
["Yield (BDT*/Acre)",6]
[]
["Production",null,"Unit","Quantity","Price","$/acre","$/BDT*"]
["Annual Maintenance"]
["Inputs"]
["Land1",null,"acre",1,0,{"$f":"D11*E11","v":0},{"$f":"F11/$B$6","v":0}]
["Nitrogen2","46-0-0 Urea","lbs",60,343,{"$f":"((E12/(2000*0.46))*D12)","v":22.369565217391305},{"$f":"F12/$B$6","v":3.7282608695652173}]
["Phosphorous2","18-46-0 DAP","lbs",40,400,{"$f":"((E13/(2000*0.46))*D13)*0.3333","v":5.7965217391304344},0.96608695652173904]
["Potassium2","0-0-60 Potash","lbs",80,378,{"$f":"((E14/(2000*0.6))*D14)*0.3333","v":8.3991600000000002},1.3998600000000001]
["Lime3",null,"ton",1,30,{"$f":"(D15*E15)*0.25","v":7.5},1.25]
["Herbicide - Broadleaf Control4","2,4 - D","pt",2,2.2200000000000002,{"$f":"D16*E16","v":4.4400000000000004},0.7400000000000001]
[]
[null,null,null,null,"Subtotal",{"$f":"SUM(F9:F16)","v":48.505246956521738},{"$f":"F18/$B$6","v":8.0842078260869563}]
[]
["Pre Harvest Equipment Operations5"]
["Fertilizer Application",null,null,1,8,{"$f":"D21*E21","v":8},{"$f":"F21/$B$6","v":1.3333333333333333}]
["Herbicide Application",null,null,1,8.5,{"$f":"D22*E22","v":8.5},{"$f":"F22/$B$6","v":1.4166666666666667}]
[]
[null,null,null,null,"Subtotal",{"$f":"SUM(F21:F22)","v":16.5},{"$f":"SUM(G21:G22)","v":2.75}]
[]
["Harvest Equipment Operations5"]
["Swathing",null,null,null,null,22.31,{"$f":"F27/$B$6","v":3.7183333333333333}]
["Baling",null,null,null,null,99.39,{"$f":"F28/$B$6","v":16.565000000000001}]
["Bale Staging",null,null,null,null,44.87,7.4783333333333326]
[]
[null,null,null,null,"Subtotal",{"$f":"SUM(F27:F29)","v":166.57},{"$f":"SUM(G27:G29)","v":27.761666666666667}]
[]
[null,null,null,null,"Total Production Cost",{"$f":"SUM(F18,F24,F31)","v":231.57524695652174},{"$f":"SUM(G18,G24,G31)","v":38.595874492753623}]
[]
["Footnotes"]
["*BDT = Bone Dry Ton"]
["1) Add in your land rent or property costs on a per acre basis"]
["2) Enter price per ton from your supplier. P & K are not typically recommended unless the soil test indicates \"Low\".  Values here represent applying N every year and P & K every third year.  Follow recommendations from soil test and adjust accordingly."]
[]
["3) Assumed application once every four years at 1 ton per acre.  Application costs included."]
["4)If needed. Do not apply before switchgrass reaches the 5 leaf stage."]
["5) Equipment Operation expenses are based on custom crew rates. If doing this work yourself, rates could be different."]
[]
["Copyright 2020"]
["Genera Inc.",null,null,null,null,null,"generainc.com/farmers"]

{"sheet":"Cost Analysis","index":2,"n_rows":44,"n_cols":11,"rows_kept":44,"cut":false,"hidden":false,"merged":[[1,0,6,10],[22,0,22,10]]}
[]
["The tables below summarize a 10-year production cycle for both switchgrass and non-irrigated, no-till soybeans in Southeastern Tennessee counties. This comparison of annual and cumulative profits is not meant to be a competitive comparison between the two crops. We’re simply showing a comparison to soybeans since many growers in the region are familiar with that crop, especially the costs of production, the risks involved, and the yields. The primary purpose of this comparison is to show that switchgrass, on the right land, can produce significant profit to the grower, just like soybeans on the right land can as well. In fact, switchgrass production returns are more consistent and have less annual volatility due to its drought resistance and the set pricing a grower receives from Genera. You can change the values in the yellow cells to reflect your operation’s details for a personalized analysis."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Switchgrass Production Cost Analysis per Acre by Year"]
["Year",1,2,3,4,5,6,7,8,9,10]
["Yield (BDT)1",2,4,6,6,6,6,6,6,6,6]
[]
["Switchgrass Production, ($65/BDT)"]
["Expenses2",{"$f":"-'Switchgrass Establishment Bdgt'!F29-'Switchgrass Production Budget'!F27-((SUM('Switchgrass Production Budget'!F28:F29)*(B14/6)))","v":-291.98797101449276},{"$f":"-'Switchgrass Production Budget'!F18-'Switchgrass Production Budget'!F24-'Switchgrass Production Budget'!F27-((SUM('Switchgrass Production Budget'!F28:F29)*(C14/6)))","v":-183.48858028985507},{"$f":"-'Switchgrass Production Budget'!$F$33","v":-231.57524695652174},{"$f":"-'Switchgrass Production Budget'!$F$33","v":-231.57524695652174},{"$f":"-'Switchgrass Production Budget'!$F$33","v":-231.57524695652174},{"$f":"-'Switchgrass Production Budget'!$F$33","v":-231.57524695652174},{"$f":"-'Switchgrass Production Budget'!$F$33","v":-231.57524695652174},{"$f":"-'Switchgrass Production Budget'!$F$33","v":-231.57524695652174},{"$f":"-'Switchgrass Production Budget'!$F$33","v":-231.57524695652174},{"$f":"-'Switchgrass Production Budget'!$F$33","v":-231.57524695652174}]
[]
["Revenue - Yearly",{"$f":"B14*65","v":130},260,390,390,390,390,390,390,390,390]
["Profit - Yearly",{"$f":"B19+B17","v":-161.98797101449276},76.511419710144935,158.42475304347826,158.42475304347826,158.42475304347826,158.42475304347826,158.42475304347826,158.42475304347826,158.42475304347826,158.42475304347826]
["Profit - Acumulating",{"$f":"B19+B17","v":-161.98797101449276},{"$f":"C19+C17+B21","v":-85.476551304347822},72.94820173913044,231.3729547826087,389.79770782608693,548.22246086956523,706.64721391304352,865.07196695652181,1023.4967200000001,1181.9214730434783]
[]
["1) Expected yield for lowland varieties of switchgrass in Southeastern Tennessee."]
["2) Expenses are generated from values entered on the previous two tabs."]
[]
["How does Switchgrass Production Compare to Other on Farm Enterprises?"]
[]
["Soybeans, No-Till, Non-Irrigated"]
[]
["Year",2010,2011,2012,2013,2014,2015,2016,2017,2018,2019]
["Yield (bushels)3",31.5,29.2,45.6,45.6,53.5,52.5,32.9,44.4,52,47]
["Price Received (per bushel)3",11.1,12.2,14.6,13,10.6,9.2899999999999991,9.7799999999999994,9.6999999999999993,8.75,8.85]
[]
["Expenses4",-325.52,-306.39999999999998,-331.07,-389.2,-410.1,-434.04,-404.98,-388,-365.42,-388.86]
[]
["Revenue - Yearly",{"$f":"B31*B32","v":349.65},{"$f":"C31*C32","v":356.23999999999995},665.76,592.80000000000007,567.1,487.72499999999997,321.76199999999994,430.67999999999995,455,415.95]
["Profit - Yearly",{"$f":"B36+B34","v":24.129999999999995},{"$f":"C36+C34","v":49.839999999999975},334.69,203.60000000000008,157,53.684999999999945,-83.218000000000075,42.67999999999995,89.579999999999984,27.089999999999975]
["Profit - Acumulating",{"$f":"B36+B34","v":24.129999999999995},{"$f":"C36+C34+B38","v":73.96999999999997},{"$f":"D36+D34+C38","v":408.65999999999997},612.26,769.26,822.94499999999994,739.72699999999986,782.40699999999981,871.98699999999985,899.07699999999977]
[]
["3) Soybean yield and price received numbers were derived from the National Agricultural Statistics Service (NASS)."]
["4) Expenses come from the University of Tennessee Field Crop Budgets for each respective year.  These expenses have been adjusted to reflect a land cash rent price of $75."]
[]
["Copyright 2020"]
["Genera Inc.",null,null,null,null,null,null,null,null,null,"generainc.com/farmers"]