{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Biomass Sorghum Budget"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"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":"Biomass Sorghum Budget","index":0,"n_rows":58,"n_cols":7,"rows_kept":58,"cut":false,"hidden":false,"merged":[[1,0,1,6],[41,0,42,6],[43,0,43,6]]}
[]
["You can change the cells highlighted in yellow to match your specific operation. Columns E & F Autopopulate based on these numbers"]
[]
["Biomass Sorghum Production Budget , No-Till, Non-Irrigated"]
[]
["Yield (BDT/Acre)",7]
[]
["Establishment","Description","Unit","Quantity","Price","$/acre","$/BDT"]
["Inputs"]
["Land Rent",null,"acre",null,0,{"$f":"E10","v":0},{"$f":"E10/B6","v":0}]
["Seed1","NX4264","bag",1,225,{"$f":"E11/C55","v":25.714285714285715},{"$f":"F11/B6","v":3.6734693877551021}]
["Nitrogen2","46-0-0 Urea","lbs",180,343,{"$f":"(E12/(2000*0.46))*(D12-((D13/0.46)*0.18))","v":57.625945179584122},{"$f":"F12/B6","v":8.2322778827977316}]
["Phosphorous2","18-46-0 DAP","lbs",65,400,{"$f":"(E13/(2000*0.46))*D13","v":28.260869565217391},{"$f":"F13/B6","v":4.0372670807453419}]
["Potassium2","0-0-60 Potash","lbs",120,378,{"$f":"(E14/(2000*0.6))*D14","v":37.799999999999997},{"$f":"F14/B6","v":5.3999999999999995}]
["Lime3",null,"ton",1,30,{"$f":"(D15*E15)*0.5","v":15},{"$f":"F15/B6","v":2.1428571428571428}]
["Herbicide","Preplant","qt.",1,4.88,{"$f":"D16*E16","v":4.88},{"$f":"F16/B6","v":0.69714285714285718}]
["Herbicide-Pre-Emerge","Bicep II Magnum (qts)","qt.",2.1,12.62,26.501999999999999,{"$f":"F17/B6","v":3.786}]
["Herbicide-Pre-Emerge","Surfactant - COC",null,1,3.5,3.5,{"$f":"F18/B6","v":0.5}]
[]
["Pre Harvest Equipment Operations4"]
["Planting",null,null,1,24,{"$f":"D21*E21","v":24},{"$f":"F21/B6","v":3.4285714285714284}]
["Fertilizer Application",null,null,1,8,8,{"$f":"F22/B6","v":1.1428571428571428}]
["Herbicide Application",null,null,2,8.5,17,{"$f":"F23/B6","v":2.4285714285714284}]
[]
[null,null,null,null,"Subtotal",{"$f":"SUM(F10:F23)","v":248.28310045908722},{"$f":"SUM(G10:G23)","v":35.469014351298178}]
[]
["Harvest Equipment Operations4"]
["Swathing",null,null,null,null,22.31,{"$f":"F28/B6","v":3.1871428571428568}]
["Raking",null,null,null,null,19.45,{"$f":"F29/B6","v":2.7785714285714285}]
["Baling",null,null,null,null,108.72,{"$f":"F30/B6","v":15.531428571428572}]
["Bale Staging",null,null,null,null,44.52,{"$f":"F31/B6","v":6.36}]
[]
[null,null,null,null,"Subtotal",{"$f":"SUM(F28:F31)","v":195},{"$f":"SUM(G28:G31)","v":27.857142857142858}]
[]
[null,null,null,null,"Total Production Cost",{"$f":"SUM(F25,F33)","v":443.28310045908722},{"$f":"SUM(G25,G33)","v":63.326157208441032}]
[]
[null,"Genera Payment ($/BDT)",90,null,"Total Revenue",{"$f":"C37*B6","v":630}]
[]
[null,null,null,null,"Total Profit",{"$f":"F37-F35","v":186.71689954091278}]
["Footnotes"]
["* BDT = Bone Dry Ton"]
["1) One 50 lb. bag of seed is expected to plant roughly 8.75 acres.  Will vary slightly from year to year based on information from seed label.  Seed Rate Multiplier table can be used to ammend this variable."]
[]
["2) Enter price per ton from your supplier. For quantity, enter crop requirements. Requirements may vary by soil type."]
["3) Assumed application once every four years at 2 tons per acre.  Prorated yearly cost provided.  Application costs included."]
["4) Equipment Operation expenses are based on custom crew rates.  If doing this work yourself, rates could be different."]
[]
["Seed Rate Multiplier"]
[]
["Description","Unit","Quantity"]
["Bag of Seed","lbs",50]
["Seeds per lb",null,14000]
["Planting Density","Seeds/ Acre",80000]
[]
["Acres per Bag",null,{"$f":"(C51*C52)/C53","v":8.75}]
[]
["Copyright 2020"]
["Genera Inc.",null,null,null,null,"generainc.com/farmers"]