{"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":56,"n_cols":7,"rows_kept":56,"cut":false,"hidden":false,"merged":[[1,0,1,6],[39,0,40,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",null,"Unit","Quantity","Price","$/acre","$/BDT"]
["Inputs"]
["Land Rent",null,"acre",1,75,{"$f":"D10*E10","v":75},{"$f":"F10/B6","v":10.714285714285714}]
["Seed1","NX4264","bag",1,225,{"$f":"E11/C53","v":25.714285714285715},{"$f":"F11/B6","v":3.6734693877551021}]
["Nitrogen",null,"lbs",120,0.44,{"$f":"D12*E12","v":52.8},{"$f":"F12/B6","v":7.5428571428571427}]
["Phosphorous2",null,"lbs",65,0.4,26,{"$f":"F13/B6","v":3.7142857142857144}]
["Potassium2",null,"lbs",120,0.32,38.4,{"$f":"F14/B6","v":5.4857142857142858}]
["Lime3 (lbs)",null,"ton",1,30,{"$f":"(D15*E15)*0.5","v":15},{"$f":"F15/B6","v":2.1428571428571428}]
["Herbicide","Preplant","qt.",1,4.88,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,2,1.5,3,{"$f":"F18/B6","v":0.42857142857142855}]
[]
["Equipment Operations"]
["Planting",null,null,1,8.1199999999999992,{"$f":"D21*E21","v":8.1199999999999992},{"$f":"F21/B6","v":1.1599999999999999}]
["Fertilizer Application",null,null,1,5,5,{"$f":"F22/B6","v":0.7142857142857143}]
["Herbicide Application",null,null,2,5,10,{"$f":"F23/B6","v":1.4285714285714286}]
[]
[null,null,null,null,"Subtotal",{"$f":"SUM(F10:F23)","v":290.41628571428572},{"$f":"SUM(G10:G23)","v":41.488040816326539}]
[]
["Harvesting"]
["Equipment Operations"]
["Swathing",null,null,null,null,22.31,{"$f":"Table23[[#This Row],[Column5]]/B6","v":3.1871428571428568}]
["Raking",null,null,null,null,19.45,{"$f":"Table23[[#This Row],[Column5]]/B6","v":2.7785714285714285}]
["Baling",null,null,null,null,108.72,{"$f":"Table23[[#This Row],[Column5]]/B6","v":15.531428571428572}]
["Bale Staging",null,null,null,null,44.52,{"$f":"Table23[[#This Row],[Column5]]/B6","v":6.36}]
["Bale Loading4",null,null,null,null,22.13,{"$f":"Table23[[#This Row],[Column5]]/B6","v":3.1614285714285715}]
[]
[null,null,null,null,"Subtotal",{"$f":"SUM(F29:F33)","v":217.13},{"$f":"SUM(G29:G33)","v":31.01857142857143}]
[]
[null,null,null,null,"Total Production Cost",{"$f":"SUM(F25,F35)","v":507.54628571428572},{"$f":"SUM(G25,G35)","v":72.506612244897966}]
[]
["Footnotes"]
["1) One 50 lb. bag of seed is expected to plant roughly 8.75 acres.  Will vary from year to year based on information from seed label.  Seed Rate Multiplier table can be used to ammend this variable."]
[]
["2) If soil test indicates \"High\"  for Phosphorous or Potassium these rates can be decreased by 50%."]
["3) Assumed application once every four years at 2 tons per acre.  Prorated yearly cost provided.  Application costs included."]
["4) Can be removed if Genera is hauling bales."]
[]
["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":"(C49*C50)/C51","v":8.75}]
[]
["Copyright 2020"]
["Genera Inc."]