{"text_format":"1","workbook":"xlsx","n_sheets":20,"sheets":["Menu","AlfalfaDrylandEstablish","AlfalfaHayDryland","AlfalfaIrrigatedEstablish","AlfalfaHayIrrigated","CottonDryland2X1","CottonDrylandSolid","CottonIrrigated","Peanuts","SorghumDryland","WheatDryland","SmallGrain","CanolaDryland","CowCalf","StockersMar1","StockersGrazeOut","Livestock Budget","Crop Budget","Comparative Returns - Cash Rent","Your Returns - Cash Rent"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":666,"comments":17,"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":"Menu","index":0,"n_rows":55,"n_cols":26,"rows_kept":55,"cut":false,"hidden":false,"merged":[[5,0,5,5]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[]
["     Rolling Plains Extension District - 3     "]
[]
[null,null,null,"Budgets"]
[]
[]
[null,null,null,"Forage Crops"]
[]
[null,null,null,{"$f":"+AlfalfaDrylandEstablish!A3","v":"Dryland Alfalfa Establishment"}]
[null,null,null,{"$f":"AlfalfaHayDryland!A3","v":"Dryland Alfalfa Hay"}]
[null,null,null,{"$f":"AlfalfaIrrigatedEstablish!A3","v":"Irrigated Alfalfa Establishment"}]
[null,null,null,{"$f":"AlfalfaHayIrrigated!A3","v":"Irrigated Alfalfa Hay"}]
[null,null,null,{"$f":"SmallGrain!A3","v":"Small Grain Grazing"}]
[null,"Comparative Returns"]
[null,null,null,"Field Crops"]
[]
[null,null,null,{"$f":"CanolaDryland!A3","v":"Dryland Canola"}]
[null,null,null,{"$f":"CottonDryland2X1!A3","v":"Dryland Cotton (2X1 Planting Pattern)"}]
[null,null,null,{"$f":"CottonDrylandSolid!A3","v":"Dryland Cotton (Solid 40\" Rows)"}]
[null,null,null,{"$f":"CottonIrrigated!A3","v":"Sprinkler Irrigated Cotton"}]
[null,null,null,{"$f":"Peanuts!A3","v":"Sprinkler Irrigated Peanuts"}]
[null,null,null,{"$f":"SorghumDryland!A3","v":"Dryland Sorghum"}]
[null,null,null,{"$f":"WheatDryland!A3","v":"Dryland Wheat"}]
[]
[null,null,null,"Livestock"]
[]
[null,null,null,{"$f":"+CowCalf!A3","v":"Rolling Plains Cow-Calf Production"}]
[null,null,null,{"$f":"+StockersMar1!A3","v":"Stocker Calf Budget - Pull off Wheat March 1"}]
[null,null,null,{"$f":"+StockersGrazeOut!A3","v":"Stocker Calf Budget - Grazeout"}]
[]
[null,null,null,"Other Budgets"]
[]
[null,null,null,{"$f":"'Livestock Budget'!A3","v":"Livestock Enterprise"}]
[null,null,null,{"$f":"'Crop Budget'!A3","v":"Crop Enterprise"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["  Developed by Extension Economists, Texas A&M AgriLife Extension Service, budgets@tamu.edu.  "]

{"sheet":"AlfalfaDrylandEstablish","index":1,"n_rows":100,"n_cols":18,"rows_kept":100,"cut":false,"hidden":false,"merged":[[77,3,77,8],[87,3,87,8],[99,0,99,11],[0,0,0,11],[1,0,1,11],[2,0,2,11],[3,0,3,11]]}
["Projections for Planning Purposes Only -- Not to be Used without Updating"]
["2018 Estimated Costs and Returns per Acre"]
["Dryland Alfalfa Establishment"]
["Enter your name for this budget in the cell above."]
["Enter  Your Values in the cells highlighed in MAROON."]
[null,null,null,null,"Your Acres",null,null,null,null,null,null,null,null,null,null,null,null,"Your"]
[null,null,"Crop Acres",100,null,null,null,null,null,null,null,"Your",null,null,null,null,"Enterprise","Enterprise"]
[null,null,null,null,"Your",null,null,"Your","Cash","Your","Landlord","Landlord",null,"Your",null,"Your","Total","Total"]
["REVENUE",null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Share","Share","Landlord","Landlord","Tenant","Tenant","(100 acres)",{"$f":"\"(\" & E7 & \" acres)\"","v":"( acres)"}]
[null,0,null,0,null,"",0,null,0,{"$f":"E10*H10","v":0},0,null,0,{"$f":"J10*L10","v":0},0,{"$f":"+J10-N10","v":0},0,{"$f":"+J10*E$7","v":0}]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
["Total Revenue",null,null,null,null,null,null,null,0,{"$f":"SUM(J10:J12)","v":0},null,null,0,{"$f":"SUM(N10:N12)","v":0},0,{"$f":"SUM(P10:P12)","v":0},0,{"$f":"SUM(R10:R12)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enterprise","Enterprise"]
["VARIABLE COSTS",null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Share","Share","Landlord","Landlord","Tenant","Tenant","Total","Total"]
["Production Costs"]
[null,"Fertilizer"]
[null,"","Fertilizer (N)",40,null,"Pound",0.41,null,16.399999999999999,{"$f":"E18*H18","v":0},0,null,0,{"$f":"J18*L18","v":0},16.399999999999999,{"$f":"+J18-N18","v":0},1639.9999999999998,{"$f":"+J18*E$7","v":0}]
[null,"","Fertilizer (P)",80,null,"Pound",0.34,null,27.200000000000003,0,0,null,0,0,27.200000000000003,0,2720.0000000000005,0]
[null,"","Potash (K)",40,null,"Pound",0.3,null,12,0,0,null,0,0,12,0,1200,0]
[null,"","Sulfur",12,null,"Pound",0.25,null,3,0,0,null,0,0,3,0,300,0]
[null,"Herbicide"]
[null,"","Roundup",2,null,"Pint",2.1875,null,4.375,0,0,null,0,0,4.375,0,437.5,0]
[null,"","Herbicide Application",1,null,"Acre",5.5,null,5.5,0,0,null,0,0,5.5,0,550,0]
[null,"Seed"]
[null,"","Alfalfa Seed",20,null,"Acre",5.75,null,115,0,0,null,0,0,115,0,11500,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,0,null,null,0,null,0,{"$f":"E29*H29","v":0},0,null,0,{"$f":"J29*L29","v":0},0,{"$f":"+J29-N29","v":0},0,{"$f":"+J29*E$7","v":0}]
[null,"Machinery Labor"]
[null,null,"Tractors/Self-Propelled",0.62,null,"Hour",10,null,6.2,{"$f":"E31*H31","v":0},0,null,0,{"$f":"J31*L31","v":0},6.2,{"$f":"+J31-N31","v":0},620,{"$f":"+J31*E$7","v":0}]
[null,null,"Other Labor",0.68,null,"Hour",10,null,6.8000000000000007,{"$f":"E32*H32","v":0},0,null,0,{"$f":"J32*L32","v":0},6.8000000000000007,{"$f":"+J32-N32","v":0},680.00000000000011,{"$f":"+J32*E$7","v":0}]
[]
[null,"Diesel Fuel"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0,null,0,{"$f":"E35*H35","v":0},0,null,0,{"$f":"J35*L35","v":0},0,{"$f":"+J35-N35","v":0},0,{"$f":"+J35*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",4.25,null,"Gallon",2.1,null,8.9250000000000007,{"$f":"E36*H36","v":0},0,null,0,{"$f":"J36*L36","v":0},8.9250000000000007,{"$f":"+J36-N36","v":0},892.50000000000011,{"$f":"+J36*E$7","v":0}]
[]
[null,"Gasoline"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",9,null,9,{"$f":"E39*H39","v":0},0,null,0,{"$f":"J39*L39","v":0},9,{"$f":"+J39-N39","v":0},900,{"$f":"+J39*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",0,null,"Gallon",2.25,null,0,{"$f":"E40*H40","v":0},0,null,0,{"$f":"J40*L40","v":0},0,{"$f":"+J40-N40","v":0},0,{"$f":"+J40*E$7","v":0}]
[]
[null,"Repairs & Maintenance"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",2.415,null,2.415,{"$f":"E43*H43","v":0},0,null,0,{"$f":"J43*L43","v":0},2.415,{"$f":"+J43-N43","v":0},241.5,{"$f":"+J43*E$7","v":0}]
[null,null,"Irrigation Equipment",1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,"Tractors/Self-Propelled",1,null,"Acre",8.2961571855272762,null,8.2961571855272762,0,0,null,0,0,8.2961571855272762,0,829.61571855272757,0]
[null,null,"Implements",1,null,"Acre",11.232010033295461,null,11.232010033295461,0,0,null,0,0,11.232010033295461,0,1123.2010033295462,0]
[null,null,null,null,null,null,null,null,0,0,0,null,0,0,0,0,0,{"$f":"+J47*E$7","v":0}]
[null,null,null,null,null,null,null,null,0,0,0,null,0,0,0,0,0,0]
[null,"Interest on Credit Line",null,null,null,null,5.7500000000000002E-2,null,2.0695381470104728,{"$f":"+SUM(J17:J48)/2*H49","v":0},null,null,0,{"$f":"+SUM(N17:N48)/2*L49","v":0},2.0695381470104728,{"$f":"+SUM(P17:P48)/2*L49","v":0},206.95381470104729,{"$f":"+J49*E$7","v":0}]
["Total Variable Costs",null,null,null,null,null,null,null,238.4127053658332,{"$f":"SUM(J18:J49)","v":0},null,null,0,{"$f":"SUM(N18:N49)","v":0},238.4127053658332,{"$f":"SUM(P18:P49)","v":0},23841.270536583317,{"$f":"SUM(R18:R49)","v":0}]
["Planned Returns Above Variable Costs:",null,null,null,null,null,null,null,-238.4127053658332,{"$f":"+J13-J50","v":0},null,null,0,{"$f":"+N13-N50","v":0},-238.4127053658332,{"$f":"+P13-P50","v":0},-23841.270536583317,{"$f":"+R13-R50","v":0}]
[null,"Breakeven Price to Cover Variable Costs",null,null,null,null,"n/a",{"$f":"IF(E10=0,\"n/a\",(YVarExp-(YTotExp+YTotRet-J10))/E10)","v":"n/a"},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enterprise","Enterprise"]
["FIXED COSTS",null,null,"Quantity","Quantity","Units","$/Unit","$/Unit",null,"Total","Share","Share","Landlord","Landlord","Tenant","Tenant","Total","Total"]
[null,"Machinery Depreciation"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",3.3528250000000002,null,3.3528250000000002,{"$f":"E56*H56","v":0},0,null,0,{"$f":"J56*L56","v":0},3.3528250000000002,{"$f":"+J56-N56","v":0},335.28250000000003,{"$f":"+J56*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",1,null,"Acre",8.5726957583781864,null,8.5726957583781864,0,0,null,0,{"$f":"J57*L57","v":0},8.5726957583781864,0,857.26957583781859,0]
[null,null,"Implements",1,null,"Acre",13.560896281875507,null,13.560896281875507,0,0,null,0,{"$f":"J58*L58","v":0},13.560896281875507,0,1356.0896281875507,0]
[null,"Equipment Investment"]
[null,null,"Pickup/General Use Equipment",23.485875,null,"Dollars",5.5E-2,null,1.2917231250000001,{"$f":"E60*H60","v":0},0,null,0,{"$f":"J60*L60","v":0},1.2917231250000001,{"$f":"+J60-N60","v":0},129.1723125,{"$f":"+J60*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",66.784065343494561,null,"Dollars",5.5E-2,null,3.6731235938922007,0,0,null,0,{"$f":"J61*L61","v":0},3.6731235938922007,0,367.31235938922009,0]
[null,null,"Implements",58.01050076135634,null,"Dollars",5.5E-2,null,3.1905775418745987,0,0,null,0,{"$f":"J62*L62","v":0},3.1905775418745987,0,319.05775418745986,0]
[null,"Salaried Labor",null,1,null,"Acre",0,null,0,0,0,null,0,{"$f":"J63*L63","v":0},0,{"$f":"+J63-N63","v":0},0,{"$f":"+J63*E$7","v":0}]
[null,"Management Fee, Owner/Operator Labor",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,"Allocated Establishment Cost",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,"Cash Rent - Dryland Alfalfa",null,1,null,"Acre",32,null,32,0,0,null,0,0,32,0,3200,0]
[null,"Property Taxes",null,1,null,"Acre",0,null,0,{"$f":"E67*H67","v":0},0,null,0,0,0,0,0,{"$f":"+J67*E$7","v":0}]
[null,"Whole Farm Insurance",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,1,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,1,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
["Total Fixed Costs",null,null,null,null,null,null,null,65.641841301020492,{"$f":"+SUM(J56:J70)","v":0},null,null,0,{"$f":"+SUM(N56:N70)","v":0},65.641841301020492,{"$f":"+SUM(P56:P70)","v":0},6564.1841301020486,{"$f":"+SUM(R56:R70)","v":0}]
["Total Specified Costs",null,null,null,null,null,null,null,304.0545466668537,{"$f":"+J50+J71","v":0},null,null,0,{"$f":"+N50+N71","v":0},304.0545466668537,{"$f":"+P50+P71","v":0},30405.454666685364,{"$f":"+R50+R71","v":0}]
[]
["Returns Above Specified Costs",null,null,null,null,null,null,null,-304.0545466668537,{"$f":"+J13-J72","v":0},null,null,0,{"$f":"+N13-N72","v":0},-304.0545466668537,{"$f":"+P13-P72","v":0},-30405.454666685364,{"$f":"+R13-R72","v":0}]
[]
["    Breakeven Price to Cover Total Costs",null,null,null,null,null,"n/a",{"$f":"IF(E10=0,\"n/a\",(YTotExp-(YTotExp+YTotRet-J10))/E10)","v":"n/a"},""]
[]
[null,null,null,"Example Breakeven Prices"]
[null,"Example","Example","To Cover",null,null,"To Cover"]
[null,"Yield","Yield","Variable",null,null,"Total"]
[null,"Percent","","Costs",null,null,"Costs"]
[null,0.75,0,0,null,null,0]
[null,0.9,0,0,null,null,0]
[null,1,0,0,null,null,0]
[null,1.1000000000000001,0,0,null,null,0]
[null,1.25,0,0,null,null,0]
[]
[null,null,null,"Your Breakeven Prices"]
[null,"Your","Your",null,"To Cover",null,null,"To Cover"]
[null,"Yield","Yield",null,"Variable",null,null,"Total"]
[null,"Percent","",null,"Costs",null,null,"Costs"]
[null,0.75,{"$f":"E10*YPER1","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER1))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER1))","v":0}]
[null,0.9,{"$f":"E10*YPER2","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER2))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER2))","v":0}]
[null,1,{"$f":"+E10","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER3))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER3))","v":0}]
[null,1.1000000000000001,{"$f":"E10*YPER4","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER4))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER4))","v":0}]
[null,1.25,{"$f":"E10*YPER5","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER5))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER5))","v":0}]
[]
["  Developed by Extension Economists, Texas A&M AgriLife Extension Service, budgets@tamu.edu.  "]
[]
["Information presented is prepared solely as a general guide and not intended to recognize or predict the costs and returns from any one operation.  Brand names are mentioned only as examples and imply no endorsement."]

{"sheet":"AlfalfaHayDryland","index":2,"n_rows":101,"n_cols":18,"rows_kept":101,"cut":false,"hidden":false,"merged":[[78,3,78,8],[88,3,88,8],[100,0,100,11],[0,0,0,11],[1,0,1,11],[2,0,2,11],[3,0,3,11]]}
["Projections for Planning Purposes Only -- Not to be Used without Updating"]
["2018 Estimated Costs and Returns per Acre"]
["Dryland Alfalfa Hay"]
["Enter your name for this budget in the cell above."]
["Enter  Your Values in the cells highlighed in MAROON."]
[null,null,null,null,"Your Acres",null,null,null,null,null,null,null,null,null,null,null,null,"Your"]
[null,null,"Crop Acres",100,null,null,null,null,null,null,null,"Your",null,null,null,null,"Enterprise","Enterprise"]
[null,null,null,null,"Your",null,null,"Your","Cash","Your","Landlord","Landlord",null,"Your",null,"Your","Total","Total"]
["REVENUE",null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Share","Share","Landlord","Landlord","Tenant","Tenant","(100 acres)",{"$f":"\"(\" & E7 & \" acres)\"","v":"( acres)"}]
[null,"Alfalfa Hay",null,3.25,null,"Ton",200,null,650,{"$f":"E10*H10","v":0},0,null,0,{"$f":"J10*L10","v":0},650,{"$f":"+J10-N10","v":0},65000,{"$f":"+J10*E$7","v":0}]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,{"$f":"+J11-N11","v":0},0,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
["Total Revenue",null,null,null,null,null,null,null,650,{"$f":"SUM(J10:J12)","v":0},null,null,0,{"$f":"SUM(N10:N12)","v":0},650,{"$f":"SUM(P10:P12)","v":0},65000,{"$f":"SUM(R10:R12)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enterprise","Enterprise"]
["VARIABLE COSTS",null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Share","Share","Landlord","Landlord","Tenant","Tenant","Total","Total"]
["Production Costs"]
[null,"Custom"]
[null,"","Fertilizer Application",1,null,"Acre",5.5,null,5.5,{"$f":"E18*H18","v":0},0,null,0,{"$f":"J18*L18","v":0},5.5,{"$f":"+J18-N18","v":0},550,{"$f":"+J18*E$7","v":0}]
[null,"","Herbicide Application",2,null,"Acre",5.5,null,11,0,0,null,0,0,11,0,1100,0]
[null,"","Insecticide Application",2,null,"Acre",5.5,null,11,0,0,null,0,0,11,0,1100,0]
[null,"","Custom Baling - Alfalfa",3.25,null,"Ton",25,null,81.25,0,0,null,0,0,81.25,0,8125,0]
[null,"Fertilizer"]
[null,"","Sulfur",12,null,"Pound",0.25,null,3,0,0,null,0,0,3,0,300,0]
[null,"","Fertilizer (N)",20,null,"Pound",0.41,null,8.1999999999999993,0,0,null,0,0,8.1999999999999993,0,819.99999999999989,0]
[null,"","Fertilizer (P)",50,null,"Pound",0.34,null,17,0,0,null,0,0,17,0,1700,0]
[null,"Herbicide"]
[null,"","Valpar",2,null,"Pint",11.875,null,23.75,0,0,null,0,0,23.75,0,2375,0]
[null,"","Butyrac",2,null,"Pint",3.75,null,7.5,0,0,null,0,0,7.5,0,750,0]
[null,"Insecticide"]
[null,"","Insecticide - Alfalfa 1",2,null,"Pint",4.12,null,8.24,0,0,null,0,0,8.24,0,824,0]
[null,"","Insecticide - Alfalfa 2 Baythroid",3,null,"Fluid Ounce",1.0546875,null,3.1640625,0,0,null,0,0,3.1640625,0,316.40625,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,0,null,null,0,null,0,{"$f":"E34*H34","v":0},0,null,0,{"$f":"J34*L34","v":0},0,{"$f":"+J34-N34","v":0},0,{"$f":"+J34*E$7","v":0}]
[null,"Machinery Labor"]
[null,null,"Tractors/Self-Propelled",0,null,"Hour",10,null,0,{"$f":"E36*H36","v":0},0,null,0,{"$f":"J36*L36","v":0},0,{"$f":"+J36-N36","v":0},0,{"$f":"+J36*E$7","v":0}]
[null,null,"Other Labor",0,null,"Hour",10,null,0,{"$f":"E37*H37","v":0},0,null,0,{"$f":"J37*L37","v":0},0,{"$f":"+J37-N37","v":0},0,{"$f":"+J37*E$7","v":0}]
[]
[null,"Diesel Fuel"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0,null,0,{"$f":"E40*H40","v":0},0,null,0,{"$f":"J40*L40","v":0},0,{"$f":"+J40-N40","v":0},0,{"$f":"+J40*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",0,null,"Gallon",2.1,null,0,{"$f":"E41*H41","v":0},0,null,0,{"$f":"J41*L41","v":0},0,{"$f":"+J41-N41","v":0},0,{"$f":"+J41*E$7","v":0}]
[]
[null,"Gasoline"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",4.5,null,4.5,{"$f":"E44*H44","v":0},0,null,0,{"$f":"J44*L44","v":0},4.5,{"$f":"+J44-N44","v":0},450,{"$f":"+J44*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",0,null,"Gallon",2.25,null,0,{"$f":"E45*H45","v":0},0,null,0,{"$f":"J45*L45","v":0},0,{"$f":"+J45-N45","v":0},0,{"$f":"+J45*E$7","v":0}]
[]
[null,"Repairs & Maintenance"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",1.2075,null,1.2075,{"$f":"E48*H48","v":0},0,null,0,{"$f":"J48*L48","v":0},1.2075,{"$f":"+J48-N48","v":0},120.75,{"$f":"+J48*E$7","v":0}]
[null,null,"Irrigation Equipment",1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,"Tractors/Self-Propelled",1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,"Implements",1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0,null,0,0,0,0,0,0]
[null,"Interest on Credit Line",null,null,null,null,5.7500000000000002E-2,null,3.872720751284247,{"$f":"+SUM(J17:J53)/2*H54","v":0},null,null,0,{"$f":"+SUM(N17:N53)/2*L54","v":0},3.872720751284247,{"$f":"+SUM(P17:P53)/2*L54","v":0},387.27207512842472,{"$f":"+J54*E$7","v":0}]
["Total Variable Costs",null,null,null,null,null,null,null,189.18428325128426,{"$f":"SUM(J18:J54)","v":0},null,null,0,{"$f":"SUM(N18:N54)","v":0},189.18428325128426,{"$f":"SUM(P18:P54)","v":0},18918.428325128425,{"$f":"SUM(R18:R54)","v":0}]
["Planned Returns Above Variable Costs:",null,null,null,null,null,null,null,460.81571674871577,{"$f":"+J13-J55","v":0},null,null,0,{"$f":"+N13-N55","v":0},460.81571674871577,{"$f":"+P13-P55","v":0},46081.571674871579,{"$f":"+R13-R55","v":0}]
[null,"Breakeven Price to Cover Variable Costs",null,null,null,null,58.210548692702851,{"$f":"IF(E10=0,\"n/a\",(YVarExp-(YTotExp+YTotRet-J10))/E10)","v":"n/a"},"Ton"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enterprise","Enterprise"]
["FIXED COSTS",null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Share","Share","Landlord","Landlord","Tenant","Tenant","Total","Total"]
[null,"Machinery Depreciation"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",1.6764125000000001,null,1.6764125000000001,{"$f":"E61*H61","v":0},0,null,0,{"$f":"J61*L61","v":0},1.6764125000000001,{"$f":"+J61-N61","v":0},167.64125000000001,{"$f":"+J61*E$7","v":0}]
[null,"Equipment Investment"]
[null,null,"Pickup/General Use Equipment",11.7429375,null,"Dollars",5.5E-2,null,0.64586156250000004,{"$f":"E63*H63","v":0},0,null,0,{"$f":"J63*L63","v":0},0.64586156250000004,{"$f":"+J63-N63","v":0},64.586156250000002,{"$f":"+J63*E$7","v":0}]
[null,"Salaried Labor",null,1,null,"Acre",0,null,0,0,0,null,0,{"$f":"J64*L64","v":0},0,{"$f":"+J64-N64","v":0},0,{"$f":"+J64*E$7","v":0}]
[null,"Management Fee, Owner/Operator Labor",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,"Allocated Establishment Cost",null,1,null,"Acre",61,null,61,0,0,null,0,0,61,0,6100,0]
[null,"Cash Rent - Dryland Alfalfa",null,1,null,"Acre",32,null,32,0,0,null,0,0,32,0,3200,0]
[null,"Property Taxes",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,"Whole Farm Insurance",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,1,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,1,null,null,0,null,0,{"$f":"E71*H71","v":0},0,null,0,0,0,0,0,0]
["Total Fixed Costs",null,null,null,null,null,null,null,95.3222740625,{"$f":"+SUM(J61:J71)","v":0},null,null,0,{"$f":"+SUM(N61:N71)","v":0},95.3222740625,{"$f":"+SUM(P61:P71)","v":0},9532.2274062500001,{"$f":"+SUM(R61:R71)","v":0}]
["Total Specified Costs",null,null,null,null,null,null,null,284.50655731378424,{"$f":"+J55+J72","v":0},null,null,0,{"$f":"+N55+N72","v":0},284.50655731378424,{"$f":"+P55+P72","v":0},28450.655731378425,{"$f":"+R55+R72","v":0}]
[]
["Returns Above Specified Costs",null,null,null,null,null,null,null,365.49344268621576,{"$f":"+J13-J73","v":0},null,null,0,{"$f":"+N13-N73","v":0},365.49344268621576,{"$f":"+P13-P73","v":0},36549.344268621571,{"$f":"+R13-R73","v":0}]
[]
["    Breakeven Price to Cover Total Costs",null,null,null,null,null,87.540479173472079,{"$f":"IF(E10=0,\"n/a\",(YTotExp-(YTotExp+YTotRet-J10))/E10)","v":"n/a"},"Ton"]
[]
[null,null,null,"Example Breakeven Prices"]
[null,"Example","Example","To Cover",null,null,"To Cover"]
[null,"Yield","Yield","Variable",null,null,"Total"]
[null,"Percent","Ton","Costs",null,null,"Costs"]
[null,0.75,2.4375,77.614064923603792,null,null,116.72063889796277]
[null,0.9,2.9250000000000003,64.678387436336493,null,null,97.267199081635624]
[null,1,3.25,58.210548692702851,null,null,87.540479173472079]
[null,1.1000000000000001,3.5750000000000002,52.918680629729856,null,null,79.582253794065522]
[null,1.25,4.0625,46.568438954162275,null,null,70.032383338777663]
[]
[null,null,null,"Your Breakeven Prices"]
[null,"Your","Your",null,"To Cover",null,null,"To Cover"]
[null,"Yield","Yield",null,"Variable",null,null,"Total"]
[null,"Percent","Ton",null,"Costs",null,null,"Costs"]
[null,0.75,{"$f":"E10*YPER1","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER1))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER1))","v":0}]
[null,0.9,{"$f":"E10*YPER2","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER2))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER2))","v":0}]
[null,1,{"$f":"+E10","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER3))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER3))","v":0}]
[null,1.1000000000000001,{"$f":"E10*YPER4","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER4))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER4))","v":0}]
[null,1.25,{"$f":"E10*YPER5","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER5))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER5))","v":0}]
[]
["  Developed by Extension Economists, Texas A&M AgriLife Extension Service, budgets@tamu.edu.  "]
[]
["Information presented is prepared solely as a general guide and not intended to recognize or predict the costs and returns from any one operation.  Brand names are mentioned only as examples and imply no endorsement."]

{"sheet":"AlfalfaIrrigatedEstablish","index":3,"n_rows":105,"n_cols":18,"rows_kept":105,"cut":false,"hidden":false,"merged":[[82,3,82,8],[92,3,92,8],[104,0,104,11],[0,0,0,11],[1,0,1,11],[2,0,2,11],[3,0,3,11]]}
["Projections for Planning Purposes Only -- Not to be Used without Updating"]
["2018 Estimated Costs and Returns per Acre"]
["Irrigated Alfalfa Establishment"]
["Enter your name for this budget in the cell above."]
["Enter  Your Values in the cells highlighed in MAROON."]
[null,null,null,null,"Your Acres",null,null,null,null,null,null,null,null,null,null,null,null,"Your"]
[null,null,"Crop Acres",100,null,null,null,null,null,null,null,"Your",null,null,null,null,"Enterprise","Enterprise"]
[null,null,null,null,"Your",null,null,"Your","Cash","Your","Landlord","Landlord",null,"Your",null,"Your","Total","Total"]
["REVENUE",null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Share","Share","Landlord","Landlord","Tenant","Tenant","(100 acres)",{"$f":"\"(\" & E7 & \" acres)\"","v":"( acres)"}]
[null,0,null,0,null,"",0,null,0,{"$f":"E10*H10","v":0},0,null,0,{"$f":"J10*L10","v":0},0,{"$f":"+J10-N10","v":0},0,{"$f":"+J10*E$7","v":0}]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,{"$f":"+J11-N11","v":0},0,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
["Total Revenue",null,null,null,null,null,null,null,0,{"$f":"SUM(J10:J12)","v":0},null,null,0,{"$f":"SUM(N10:N12)","v":0},0,{"$f":"SUM(P10:P12)","v":0},0,{"$f":"SUM(R10:R12)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enterprise","Enterprise"]
["VARIABLE COSTS",null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Share","Share","Landlord","Landlord","Tenant","Tenant","Total","Total"]
["Production Costs"]
[null,"Fertilizer"]
[null,"","Fertilizer (N)",40,null,"Pound",0.41,null,16.399999999999999,{"$f":"E18*H18","v":0},0,null,0,{"$f":"J18*L18","v":0},16.399999999999999,{"$f":"+J18-N18","v":0},1639.9999999999998,{"$f":"+J18*E$7","v":0}]
[null,"","Fertilizer (P)",80,null,"Pound",0.34,null,27.200000000000003,0,0,null,0,0,27.200000000000003,0,2720.0000000000005,0]
[null,"","Potash (K)",40,null,"Pound",0.3,null,12,0,0,null,0,0,12,0,1200,0]
[null,"","Sulfur",12,null,"Pound",0.25,null,3,0,0,null,0,0,3,0,300,0]
[null,"Herbicide"]
[null,"","Roundup",2,null,"Pint",2.1875,null,4.375,0,0,null,0,0,4.375,0,437.5,0]
[null,"","Herbicide Application",1,null,"Acre",5.5,null,5.5,0,0,null,0,0,5.5,0,550,0]
[null,"Seed"]
[null,"","Alfalfa Seed",20,null,"Acre",5.75,null,115,0,0,null,0,0,115,0,11500,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,0,null,null,0,null,0,{"$f":"E29*H29","v":0},0,null,0,{"$f":"J29*L29","v":0},0,{"$f":"+J29-N29","v":0},0,{"$f":"+J29*E$7","v":0}]
[null,"Irrigation"]
[null,null,"Energy Cost",6,null,"AcreInch",1.2000367064824382,null,7.2002202388946293,{"$f":"E31*H31","v":0},0,null,0,{"$f":"J31*L31","v":0},7.2002202388946293,{"$f":"+J31-N31","v":0},720.02202388946296,{"$f":"+J31*E$7","v":0}]
[null,null,"Irrigation Labor",0.51200000000000001,null,"Hour",10,null,5.12,0,0,null,0,0,5.12,0,512,0]
[null,"Machinery Labor"]
[null,null,"Tractors/Self-Propelled",0.62,null,"Hour",10,null,6.2,{"$f":"E34*H34","v":0},0,null,0,{"$f":"J34*L34","v":0},6.2,{"$f":"+J34-N34","v":0},620,{"$f":"+J34*E$7","v":0}]
[null,null,"Other Labor",0.68,null,"Hour",10,null,6.8000000000000007,{"$f":"E35*H35","v":0},0,null,0,{"$f":"J35*L35","v":0},6.8000000000000007,{"$f":"+J35-N35","v":0},680.00000000000011,{"$f":"+J35*E$7","v":0}]
[]
[null,"Diesel Fuel"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0,null,0,{"$f":"E38*H38","v":0},0,null,0,{"$f":"J38*L38","v":0},0,{"$f":"+J38-N38","v":0},0,{"$f":"+J38*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",4.25,null,"Gallon",2.1,null,8.9250000000000007,{"$f":"E39*H39","v":0},0,null,0,{"$f":"J39*L39","v":0},8.9250000000000007,{"$f":"+J39-N39","v":0},892.50000000000011,{"$f":"+J39*E$7","v":0}]
[]
[null,"Gasoline"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",9,null,9,{"$f":"E42*H42","v":0},0,null,0,{"$f":"J42*L42","v":0},9,{"$f":"+J42-N42","v":0},900,{"$f":"+J42*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",0,null,"Gallon",2.25,null,0,{"$f":"E43*H43","v":0},0,null,0,{"$f":"J43*L43","v":0},0,{"$f":"+J43-N43","v":0},0,{"$f":"+J43*E$7","v":0}]
[]
[null,"Repairs & Maintenance"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",2.415,null,2.415,{"$f":"E46*H46","v":0},0,null,0,{"$f":"J46*L46","v":0},2.415,{"$f":"+J46-N46","v":0},241.5,{"$f":"+J46*E$7","v":0}]
[null,null,"Irrigation Equipment",1,null,"Acre",10.0002,null,10.0002,0,0,null,0,0,10.0002,0,1000.02,0]
[null,null,"Tractors/Self-Propelled",1,null,"Acre",8.2961571855272762,null,8.2961571855272762,0,0,null,0,0,8.2961571855272762,0,829.61571855272757,0]
[null,null,"Implements",1,null,"Acre",11.232010033295461,null,11.232010033295461,0,0,null,0,0,11.232010033295461,0,1123.2010033295462,0]
[null,null,null,null,null,null,null,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0,null,0,0,0,0,0,0]
[null,"Interest on Credit Line",null,null,null,null,5.7500000000000002E-2,null,2.6580240722126236,{"$f":"+SUM(J17:J51)/2*H52","v":0},null,null,0,{"$f":"+SUM(N17:N51)/2*L52","v":0},2.6580240722126236,{"$f":"+SUM(P17:P51)/2*L52","v":0},265.80240722126234,{"$f":"+J52*E$7","v":0}]
["Total Variable Costs",null,null,null,null,null,null,null,261.32161152993001,{"$f":"SUM(J18:J52)","v":0},null,null,0,{"$f":"SUM(N18:N52)","v":0},261.32161152993001,{"$f":"SUM(P18:P52)","v":0},26132.161152992994,{"$f":"SUM(R18:R52)","v":0}]
["Planned Returns Above Variable Costs:",null,null,null,null,null,null,null,-261.32161152993001,{"$f":"+J13-J53","v":0},null,null,0,{"$f":"+N13-N53","v":0},-261.32161152993001,{"$f":"+P13-P53","v":0},-26132.161152992994,{"$f":"+R13-R53","v":0}]
[null,"Breakeven Price to Cover Variable Costs",null,null,null,null,"n/a",{"$f":"IF(E10=0,\"n/a\",(YVarExp-(YTotExp+YTotRet-J10))/E10)","v":"n/a"},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enterprise","Enterprise"]
["FIXED COSTS",null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Share","Share","Landlord","Landlord","Tenant","Tenant","Total","Total"]
[null,"Machinery Depreciation"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",3.3528250000000002,null,3.3528250000000002,{"$f":"E59*H59","v":0},0,null,0,{"$f":"J59*L59","v":0},3.3528250000000002,{"$f":"+J59-N59","v":0},335.28250000000003,{"$f":"+J59*E$7","v":0}]
[null,null,"Irrigation Equipment",1,null,"Acre",6,null,6,0,0,null,0,{"$f":"J60*L60","v":0},6,0,600,0]
[null,null,"Tractors/Self-Propelled",1,null,"Acre",8.5726957583781864,null,8.5726957583781864,0,0,null,0,{"$f":"J61*L61","v":0},8.5726957583781864,0,857.26957583781859,0]
[null,null,"Implements",1,null,"Acre",13.560896281875507,null,13.560896281875507,0,0,null,0,{"$f":"J62*L62","v":0},13.560896281875507,0,1356.0896281875507,0]
[null,"Equipment Investment"]
[null,null,"Pickup/General Use Equipment",23.485875,null,"Dollars",5.5E-2,null,1.2917231250000001,{"$f":"E64*H64","v":0},0,null,0,{"$f":"J64*L64","v":0},1.2917231250000001,{"$f":"+J64-N64","v":0},129.1723125,{"$f":"+J64*E$7","v":0}]
[null,null,"Irrigation Equipment",175,null,"Dollars",5.5E-2,null,9.625,0,0,null,0,{"$f":"J65*L65","v":0},9.625,0,962.5,0]
[null,null,"Tractors/Self-Propelled",66.784065343494561,null,"Dollars",5.5E-2,null,3.6731235938922007,0,0,null,0,{"$f":"J66*L66","v":0},3.6731235938922007,0,367.31235938922009,0]
[null,null,"Implements",58.01050076135634,null,"Dollars",5.5E-2,null,3.1905775418745987,0,0,null,0,{"$f":"J67*L67","v":0},3.1905775418745987,0,319.05775418745986,0]
[null,"Salaried Labor",null,1,null,"Acre",0,null,0,0,0,null,0,{"$f":"J68*L68","v":0},0,{"$f":"+J68-N68","v":0},0,{"$f":"+J68*E$7","v":0}]
[null,"Management Fee, Owner/Operator Labor",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,"Allocated Establishment Cost",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,"Cash Rent - Irrigated Alfalfa",null,1,null,"Acre",75,null,75,0,0,null,0,0,75,0,7500,0]
[null,"Property Taxes",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,"Whole Farm Insurance",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,1,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,1,null,null,0,null,0,{"$f":"E75*H75","v":0},0,null,0,0,0,0,0,0]
["Total Fixed Costs",null,null,null,null,null,null,null,124.26684130102049,{"$f":"+SUM(J59:J75)","v":0},null,null,0,{"$f":"+SUM(N59:N75)","v":0},124.26684130102049,{"$f":"+SUM(P59:P75)","v":0},12426.68413010205,{"$f":"+SUM(R59:R75)","v":0}]
["Total Specified Costs",null,null,null,null,null,null,null,385.58845283095047,{"$f":"+J53+J76","v":0},null,null,0,{"$f":"+N53+N76","v":0},385.58845283095047,{"$f":"+P53+P76","v":0},38558.845283095041,{"$f":"+R53+R76","v":0}]
[]
["Returns Above Specified Costs",null,null,null,null,null,null,null,-385.58845283095047,{"$f":"+J13-J77","v":0},null,null,0,{"$f":"+N13-N77","v":0},-385.58845283095047,{"$f":"+P13-P77","v":0},-38558.845283095041,{"$f":"+R13-R77","v":0}]
[]
["    Breakeven Price to Cover Total Costs",null,null,null,null,null,"n/a",{"$f":"IF(E10=0,\"n/a\",(YTotExp-(YTotExp+YTotRet-J10))/E10)","v":"n/a"},""]
[]
[null,null,null,"Example Breakeven Prices"]
[null,"Example","Example","To Cover",null,null,"To Cover"]
[null,"Yield","Yield","Variable",null,null,"Total"]
[null,"Percent","","Costs",null,null,"Costs"]
[null,0.75,0,0,null,null,0]
[null,0.9,0,0,null,null,0]
[null,1,0,0,null,null,0]
[null,1.1000000000000001,0,0,null,null,0]
[null,1.25,0,0,null,null,0]
[]
[null,null,null,"Your Breakeven Prices"]
[null,"Your","Your",null,"To Cover",null,null,"To Cover"]
[null,"Yield","Yield",null,"Variable",null,null,"Total"]
[null,"Percent","",null,"Costs",null,null,"Costs"]
[null,0.75,{"$f":"E10*YPER1","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER1))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER1))","v":0}]
[null,0.9,{"$f":"E10*YPER2","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER2))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER2))","v":0}]
[null,1,{"$f":"+E10","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER3))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER3))","v":0}]
[null,1.1000000000000001,{"$f":"E10*YPER4","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER4))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER4))","v":0}]
[null,1.25,{"$f":"E10*YPER5","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER5))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER5))","v":0}]
[]
["  Developed by Extension Economists, Texas A&M AgriLife Extension Service, budgets@tamu.edu.  "]
[]
["Information presented is prepared solely as a general guide and not intended to recognize or predict the costs and returns from any one operation.  Brand names are mentioned only as examples and imply no endorsement."]

{"sheet":"AlfalfaHayIrrigated","index":4,"n_rows":106,"n_cols":18,"rows_kept":106,"cut":false,"hidden":false,"merged":[[83,3,83,8],[93,3,93,8],[105,0,105,11],[0,0,0,11],[1,0,1,11],[2,0,2,11],[3,0,3,11]]}
["Projections for Planning Purposes Only -- Not to be Used without Updating"]
["2018 Estimated Costs and Returns per Acre"]
["Irrigated Alfalfa Hay"]
["Enter your name for this budget in the cell above."]
["Enter  Your Values in the cells highlighed in MAROON."]
[null,null,null,null,"Your Acres",null,null,null,null,null,null,null,null,null,null,null,null,"Your"]
[null,null,"Crop Acres",100,null,null,null,null,null,null,null,"Your",null,null,null,null,"Enterprise","Enterprise"]
[null,null,null,null,"Your",null,null,"Your","Cash","Your","Landlord","Landlord",null,"Your",null,"Your","Total","Total"]
["REVENUE",null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Share","Share","Landlord","Landlord","Tenant","Tenant","(100 acres)",{"$f":"\"(\" & E7 & \" acres)\"","v":"( acres)"}]
[null,"Alfalfa Hay",null,6.5,null,"Ton",200,null,1300,{"$f":"E10*H10","v":0},0,null,0,{"$f":"J10*L10","v":0},1300,{"$f":"+J10-N10","v":0},130000,{"$f":"+J10*E$7","v":0}]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,{"$f":"+J11-N11","v":0},0,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
["Total Revenue",null,null,null,null,null,null,null,1300,{"$f":"SUM(J10:J12)","v":0},null,null,0,{"$f":"SUM(N10:N12)","v":0},1300,{"$f":"SUM(P10:P12)","v":0},130000,{"$f":"SUM(R10:R12)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enterprise","Enterprise"]
["VARIABLE COSTS",null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Share","Share","Landlord","Landlord","Tenant","Tenant","Total","Total"]
["Production Costs"]
[null,"Custom"]
[null,"","Herbicide Application",2,null,"Acre",5.5,null,11,{"$f":"E18*H18","v":0},0,null,0,{"$f":"J18*L18","v":0},11,{"$f":"+J18-N18","v":0},1100,{"$f":"+J18*E$7","v":0}]
[null,"","Insecticide Application",3,null,"Acre",5.5,null,16.5,0,0,null,0,0,16.5,0,1650,0]
[null,"","Fertilizer Application",1,null,"Acre",5.5,null,5.5,0,0,null,0,0,5.5,0,550,0]
[null,"","Custom Baling - Alfalfa",6.5,null,"Ton",25,null,162.5,0,0,null,0,0,162.5,0,16250,0]
[null,"Fertilizer"]
[null,"","Fertilizer (N)",30,null,"Pound",0.41,null,12.299999999999999,0,0,null,0,0,12.299999999999999,0,1230,0]
[null,"","Fertilizer (P)",50,null,"Pound",0.34,null,17,0,0,null,0,0,17,0,1700,0]
[null,"","Sulfur",12,null,"Pound",0.25,null,3,0,0,null,0,0,3,0,300,0]
[null,"Herbicide"]
[null,"","Valpar",2,null,"Pint",11.875,null,23.75,0,0,null,0,0,23.75,0,2375,0]
[null,"","Butyrac",2,null,"Pint",3.75,null,7.5,0,0,null,0,0,7.5,0,750,0]
[null,"Insecticide"]
[null,"","Insecticide - Alfalfa 1",2,null,"Pint",4.12,null,8.24,0,0,null,0,0,8.24,0,824,0]
[null,"","Insecticide - Alfalfa 2 Baythroid",3,null,"Fluid Ounce",1.0546875,null,3.1640625,0,0,null,0,0,3.1640625,0,316.40625,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,0,null,null,0,null,0,{"$f":"E34*H34","v":0},0,null,0,{"$f":"J34*L34","v":0},0,{"$f":"+J34-N34","v":0},0,{"$f":"+J34*E$7","v":0}]
[null,"Irrigation"]
[null,null,"Energy Cost",10,null,"AcreInch",1.2000367064824382,null,12.000367064824381,{"$f":"E36*H36","v":0},0,null,0,{"$f":"J36*L36","v":0},12.000367064824381,{"$f":"+J36-N36","v":0},1200.0367064824381,{"$f":"+J36*E$7","v":0}]
[null,null,"Irrigation Labor",0.96,null,"Hour",10,null,9.6,0,0,null,0,0,9.6,0,960,0]
[null,"Machinery Labor"]
[null,null,"Tractors/Self-Propelled",0,null,"Hour",10,null,0,{"$f":"E39*H39","v":0},0,null,0,{"$f":"J39*L39","v":0},0,{"$f":"+J39-N39","v":0},0,{"$f":"+J39*E$7","v":0}]
[null,null,"Other Labor",0,null,"Hour",10,null,0,{"$f":"E40*H40","v":0},0,null,0,{"$f":"J40*L40","v":0},0,{"$f":"+J40-N40","v":0},0,{"$f":"+J40*E$7","v":0}]
[]
[null,"Diesel Fuel"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0,null,0,{"$f":"E43*H43","v":0},0,null,0,{"$f":"J43*L43","v":0},0,{"$f":"+J43-N43","v":0},0,{"$f":"+J43*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",0,null,"Gallon",2.1,null,0,{"$f":"E44*H44","v":0},0,null,0,{"$f":"J44*L44","v":0},0,{"$f":"+J44-N44","v":0},0,{"$f":"+J44*E$7","v":0}]
[]
[null,"Gasoline"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",6.75,null,6.75,{"$f":"E47*H47","v":0},0,null,0,{"$f":"J47*L47","v":0},6.75,{"$f":"+J47-N47","v":0},675,{"$f":"+J47*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",0,null,"Gallon",2.25,null,0,{"$f":"E48*H48","v":0},0,null,0,{"$f":"J48*L48","v":0},0,{"$f":"+J48-N48","v":0},0,{"$f":"+J48*E$7","v":0}]
[]
[null,"Repairs & Maintenance"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",1.81125,null,1.81125,{"$f":"E51*H51","v":0},0,null,0,{"$f":"J51*L51","v":0},1.81125,{"$f":"+J51-N51","v":0},181.125,{"$f":"+J51*E$7","v":0}]
[null,null,"Irrigation Equipment",1,null,"Acre",20,null,20,0,0,null,0,0,20,0,2000,0]
[null,null,"Tractors/Self-Propelled",1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,"Implements",1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0,null,0,0,0,0,0,0]
[null,"Interest on Credit Line",null,null,null,null,5.7500000000000002E-2,null,5.3475841033051932,{"$f":"+SUM(J17:J56)/2*H57","v":0},null,null,0,{"$f":"+SUM(N17:N56)/2*L57","v":0},5.3475841033051932,{"$f":"+SUM(P17:P56)/2*L57","v":0},534.75841033051927,{"$f":"+J57*E$7","v":0}]
["Total Variable Costs",null,null,null,null,null,null,null,325.96326366812957,{"$f":"SUM(J18:J57)","v":0},null,null,0,{"$f":"SUM(N18:N57)","v":0},325.96326366812957,{"$f":"SUM(P18:P57)","v":0},32596.326366812958,{"$f":"SUM(R18:R57)","v":0}]
["Planned Returns Above Variable Costs:",null,null,null,null,null,null,null,974.03673633187043,{"$f":"+J13-J58","v":0},null,null,0,{"$f":"+N13-N58","v":0},974.03673633187043,{"$f":"+P13-P58","v":0},97403.673633187049,{"$f":"+R13-R58","v":0}]
[null,"Breakeven Price to Cover Variable Costs",null,null,null,null,50.148194410481473,{"$f":"IF(E10=0,\"n/a\",(YVarExp-(YTotExp+YTotRet-J10))/E10)","v":"n/a"},"Ton"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enterprise","Enterprise"]
["FIXED COSTS",null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Share","Share","Landlord","Landlord","Tenant","Tenant","Total","Total"]
[null,"Machinery Depreciation"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",2.5146187499999995,null,2.5146187499999995,{"$f":"E64*H64","v":0},0,null,0,{"$f":"J64*L64","v":0},2.5146187499999995,{"$f":"+J64-N64","v":0},251.46187499999994,{"$f":"+J64*E$7","v":0}]
[null,null,"Irrigation Equipment",1,null,"Acre",12,null,12,0,0,null,0,{"$f":"J65*L65","v":0},12,0,1200,0]
[null,"Equipment Investment"]
[null,null,"Pickup/General Use Equipment",17.614406249999998,null,"Dollars",5.5E-2,null,0.9687923437499999,{"$f":"E67*H67","v":0},0,null,0,{"$f":"J67*L67","v":0},0.9687923437499999,{"$f":"+J67-N67","v":0},96.879234374999996,{"$f":"+J67*E$7","v":0}]
[null,null,"Irrigation Equipment",350,null,"Dollars",5.5E-2,null,19.25,0,0,null,0,{"$f":"J68*L68","v":0},19.25,0,1925,0]
[null,"Salaried Labor",null,1,null,"Acre",0,null,0,0,0,null,0,{"$f":"J69*L69","v":0},0,{"$f":"+J69-N69","v":0},0,{"$f":"+J69*E$7","v":0}]
[null,"Management Fee, Owner/Operator Labor",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,"Allocated Establishment Cost",null,1,null,"Acre",78,null,78,0,0,null,0,0,78,0,7800,0]
[null,"Cash Rent - Irrigated Alfalfa",null,1,null,"Acre",75,null,75,0,0,null,0,0,75,0,7500,0]
[null,"Property Taxes",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,"Whole Farm Insurance",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,1,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,1,null,null,0,null,0,{"$f":"E76*H76","v":0},0,null,0,0,0,0,0,0]
["Total Fixed Costs",null,null,null,null,null,null,null,187.73341109374999,{"$f":"+SUM(J64:J76)","v":0},null,null,0,{"$f":"+SUM(N64:N76)","v":0},187.73341109374999,{"$f":"+SUM(P64:P76)","v":0},18773.341109375,{"$f":"+SUM(R64:R76)","v":0}]
["Total Specified Costs",null,null,null,null,null,null,null,513.69667476187954,{"$f":"+J58+J77","v":0},null,null,0,{"$f":"+N58+N77","v":0},513.69667476187954,{"$f":"+P58+P77","v":0},51369.667476187955,{"$f":"+R58+R77","v":0}]
[]
["Returns Above Specified Costs",null,null,null,null,null,null,null,786.30332523812046,{"$f":"+J13-J78","v":0},null,null,0,{"$f":"+N13-N78","v":0},786.30332523812046,{"$f":"+P13-P78","v":0},78630.332523812045,{"$f":"+R13-R78","v":0}]
[]
["    Breakeven Price to Cover Total Costs",null,null,null,null,null,79.030257655673779,{"$f":"IF(E10=0,\"n/a\",(YTotExp-(YTotExp+YTotRet-J10))/E10)","v":"n/a"},"Ton"]
[]
[null,null,null,"Example Breakeven Prices"]
[null,"Example","Example","To Cover",null,null,"To Cover"]
[null,"Yield","Yield","Variable",null,null,"Total"]
[null,"Percent","Ton","Costs",null,null,"Costs"]
[null,0.75,4.875,66.864259213975302,null,null,105.37367687423171]
[null,0.9,5.8500000000000005,55.720216011646073,null,null,87.811397395193069]
[null,1,6.5,50.148194410481473,null,null,79.030257655673779]
[null,1.1000000000000001,7.15,45.589267645892242,null,null,71.845688777885243]
[null,1.25,8.125,40.11855552838518,null,null,63.224206124539023]
[]
[null,null,null,"Your Breakeven Prices"]
[null,"Your","Your",null,"To Cover",null,null,"To Cover"]
[null,"Yield","Yield",null,"Variable",null,null,"Total"]
[null,"Percent","Ton",null,"Costs",null,null,"Costs"]
[null,0.75,{"$f":"E10*YPER1","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER1))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER1))","v":0}]
[null,0.9,{"$f":"E10*YPER2","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER2))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER2))","v":0}]
[null,1,{"$f":"+E10","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER3))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER3))","v":0}]
[null,1.1000000000000001,{"$f":"E10*YPER4","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER4))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER4))","v":0}]
[null,1.25,{"$f":"E10*YPER5","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER5))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER5))","v":0}]
[]
["  Developed by Extension Economists, Texas A&M AgriLife Extension Service, budgets@tamu.edu.  "]
[]
["Information presented is prepared solely as a general guide and not intended to recognize or predict the costs and returns from any one operation.  Brand names are mentioned only as examples and imply no endorsement."]

{"sheet":"CottonDryland2X1","index":5,"n_rows":106,"n_cols":18,"rows_kept":106,"cut":false,"hidden":false,"merged":[[83,3,83,8],[93,3,93,8],[105,0,105,11],[0,0,0,11],[1,0,1,11],[2,0,2,11],[3,0,3,11]]}
["Projections for Planning Purposes Only -- Not to be Used without Updating"]
["2018 Estimated Costs and Returns per Acre"]
["Dryland Cotton (2X1 Planting Pattern)"]
["Enter your name for this budget in the cell above."]
["Enter  Your Values in the cells highlighed in MAROON."]
[null,null,null,null,"Your Acres",null,null,null,null,null,null,null,null,null,null,null,null,"Your"]
[null,null,"Crop Acres",640,null,null,null,null,null,null,null,"Your",null,null,null,null,"Enterprise","Enterprise"]
[null,null,null,null,"Your",null,null,"Your","Cash","Your","Landlord","Landlord",null,"Your",null,"Your","Total","Total"]
["REVENUE",null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Share","Share","Landlord","Landlord","Tenant","Tenant","(640 acres)",{"$f":"\"(\" & E7 & \" acres)\"","v":"( acres)"}]
[null,"Cotton Lint",null,320,null,"Pound",0.56000000000000005,null,179.20000000000002,{"$f":"E10*H10","v":0},0,null,0,{"$f":"J10*L10","v":0},179.20000000000002,{"$f":"+J10-N10","v":0},114688.00000000001,{"$f":"+J10*E$7","v":0}]
[null,"Cottonseed",null,0.26400000000000001,null,"Ton",200,null,52.800000000000004,0,0,null,0,0,52.800000000000004,{"$f":"+J11-N11","v":0},33792,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
["Total Revenue",null,null,null,null,null,null,null,232.00000000000003,{"$f":"SUM(J10:J13)","v":0},null,null,0,{"$f":"SUM(N10:N13)","v":0},232.00000000000003,{"$f":"SUM(P10:P13)","v":0},148480,{"$f":"SUM(R10:R13)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enterprise","Enterprise"]
["VARIABLE COSTS",null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Share","Share","Landlord","Landlord","Tenant","Tenant","Total","Total"]
["Production Costs"]
[null,"Custom"]
[null,"","Insecticide Application",1,null,"Acre",5.5,null,5.5,{"$f":"E19*H19","v":0},0,null,0,{"$f":"J19*L19","v":0},5.5,{"$f":"+J19-N19","v":0},3520,{"$f":"+J19*E$7","v":0}]
[null,"","Gin, Bag, Ties",320,null,"Pound",0.12,null,38.4,0,0,null,0,0,38.4,0,24576,0]
[null,"","Custom Stripping",320,null,"Pound",0.1,null,32,0,0,null,0,0,32,0,20480,0]
[null,"Fertilizer"]
[null,"","Fertilizer (N)",57,null,"Pound",0.41,null,23.369999999999997,0,0,null,0,0,23.369999999999997,0,14956.8,0]
[null,"Herbicide"]
[null,"","Roundup",2,null,"Pint",2.1875,null,4.375,0,0,null,0,0,4.375,0,2800,0]
[null,"Insecticide"]
[null,"","Insecticide - Cotton",0.5,null,"Pound",7.2,null,3.6,0,0,null,0,0,3.6,0,2304,0]
[null,"","Bollweevil Eradication",1,null,"Acre",2.5,null,2.5,0,0,null,0,0,2.5,0,1600,0]
[null,"Miscellaneous"]
[null,"","Insurance - Dryland Cotton",1,null,"Acre",15,null,15,0,0,null,0,0,15,0,9600,0]
[null,"Seed"]
[null,"","Cotton Seed",5,null,"Pound",7.7,null,38.5,0,0,null,0,0,38.5,0,24640,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,0,null,null,0,null,0,{"$f":"E35*H35","v":0},0,null,0,{"$f":"J35*L35","v":0},0,{"$f":"+J35-N35","v":0},0,{"$f":"+J35*E$7","v":0}]
[null,"Machinery Labor"]
[null,null,"Tractors/Self-Propelled",1.07,null,"Hour",10,null,10.700000000000001,{"$f":"E37*H37","v":0},0,null,0,{"$f":"J37*L37","v":0},10.700000000000001,{"$f":"+J37-N37","v":0},6848.0000000000009,{"$f":"+J37*E$7","v":0}]
[null,null,"Other Labor",1.28,null,"Hour",10,null,12.8,{"$f":"E38*H38","v":0},0,null,0,{"$f":"J38*L38","v":0},12.8,{"$f":"+J38-N38","v":0},8192,{"$f":"+J38*E$7","v":0}]
[]
[null,"Diesel Fuel"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0,null,0,{"$f":"E41*H41","v":0},0,null,0,{"$f":"J41*L41","v":0},0,{"$f":"+J41-N41","v":0},0,{"$f":"+J41*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",7.29,null,"Gallon",2.1,null,15.309000000000001,{"$f":"E42*H42","v":0},0,null,0,{"$f":"J42*L42","v":0},15.309000000000001,{"$f":"+J42-N42","v":0},9797.76,{"$f":"+J42*E$7","v":0}]
[]
[null,"Gasoline"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",1.0546875,null,1.0546875,{"$f":"E45*H45","v":0},0,null,0,{"$f":"J45*L45","v":0},1.0546875,{"$f":"+J45-N45","v":0},675,{"$f":"+J45*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",0,null,"Gallon",2.25,null,0,{"$f":"E46*H46","v":0},0,null,0,{"$f":"J46*L46","v":0},0,{"$f":"+J46-N46","v":0},0,{"$f":"+J46*E$7","v":0}]
[]
[null,"Repairs & Maintenance"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0.28300781250000001,null,0.28300781250000001,{"$f":"E49*H49","v":0},0,null,0,{"$f":"J49*L49","v":0},0.28300781250000001,{"$f":"+J49-N49","v":0},181.125,{"$f":"+J49*E$7","v":0}]
[null,null,"Irrigation Equipment",1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,"Tractors/Self-Propelled",1,null,"Acre",14.228834686093387,null,14.228834686093387,0,0,null,0,0,14.228834686093387,0,9106.4541990997677,0]
[null,null,"Implements",1,null,"Acre",17.459703421994021,null,17.459703421994021,0,0,null,0,0,17.459703421994021,0,11174.210190076174,0]
[null,null,null,null,null,null,null,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0,null,0,0,0,0,0,0]
[null,"Interest on Credit Line",null,null,null,null,5.7500000000000002E-2,null,5.0854030278785274,{"$f":"+SUM(J18:J54)/2*H55","v":0},null,null,0,{"$f":"+SUM(N18:N54)/2*L55","v":0},5.0854030278785274,{"$f":"+SUM(P18:P54)/2*L55","v":0},3254.6579378422575,{"$f":"+J55*E$7","v":0}]
["Total Variable Costs",null,null,null,null,null,null,null,240.16563644846593,{"$f":"SUM(J19:J55)","v":0},null,null,0,{"$f":"SUM(N19:N55)","v":0},240.16563644846593,{"$f":"SUM(P19:P55)","v":0},153706.00732701819,{"$f":"SUM(R19:R55)","v":0}]
["Planned Returns Above Variable Costs:",null,null,null,null,null,null,null,-8.1656364484659036,{"$f":"+J14-J56","v":0},null,null,0,{"$f":"+N14-N56","v":0},-8.1656364484659036,{"$f":"+P14-P56","v":0},-5226.0073270181892,{"$f":"+R14-R56","v":0}]
[null,"Breakeven Price to Cover Variable Costs",null,null,null,null,0.58551761390145596,{"$f":"IF(E10=0,\"n/a\",(YVarExp-(YTotExp+YTotRet-J10))/E10)","v":"n/a"},"Pound"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enterprise","Enterprise"]
["FIXED COSTS",null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Share","Share","Landlord","Landlord","Tenant","Tenant","Total","Total"]
[null,"Machinery Depreciation"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0.39290917968749994,null,0.39290917968749994,{"$f":"E62*H62","v":0},0,null,0,{"$f":"J62*L62","v":0},0.39290917968749994,{"$f":"+J62-N62","v":0},251.46187499999996,{"$f":"+J62*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",1,null,"Acre",14.703129175629835,null,14.703129175629835,0,0,null,0,{"$f":"J63*L63","v":0},14.703129175629835,0,9410.002672403094,0]
[null,null,"Implements",1,null,"Acre",21.715982404262917,null,21.715982404262917,0,0,null,0,{"$f":"J64*L64","v":0},21.715982404262917,0,13898.228738728267,0]
[null,"Equipment Investment"]
[null,null,"Pickup/General Use Equipment",2.7522509765624998,null,"Dollars",5.5E-2,null,0.1513738037109375,{"$f":"E66*H66","v":0},0,null,0,{"$f":"J66*L66","v":0},0.1513738037109375,{"$f":"+J66-N66","v":0},96.87923437500001,{"$f":"+J66*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",114.54211922305176,null,"Dollars",5.5E-2,null,6.2998165572678468,0,0,null,0,{"$f":"J67*L67","v":0},6.2998165572678468,0,4031.8825966514219,0]
[null,null,"Implements",92.896146951569165,null,"Dollars",5.5E-2,null,5.1092880823363043,0,0,null,0,{"$f":"J68*L68","v":0},5.1092880823363043,0,3269.944372695235,0]
[null,"Salaried Labor",null,1,null,"Acre",0,null,0,0,0,null,0,{"$f":"J69*L69","v":0},0,{"$f":"+J69-N69","v":0},0,{"$f":"+J69*E$7","v":0}]
[null,"Management Fee, Owner/Operator Labor",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,"Allocated Establishment Cost",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,"Cash Rent - Dryland Cotton",null,1,null,"Acre",32,null,32,0,0,null,0,0,32,0,20480,0]
[null,"Property Taxes",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,"Whole Farm Insurance",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,1,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,1,null,null,0,null,0,{"$f":"E76*H76","v":0},0,null,0,0,0,0,0,0]
["Total Fixed Costs",null,null,null,null,null,null,null,80.372499202895341,{"$f":"+SUM(J62:J76)","v":0},null,null,0,{"$f":"+SUM(N62:N76)","v":0},80.372499202895341,{"$f":"+SUM(P62:P76)","v":0},51438.399489853022,{"$f":"+SUM(R62:R76)","v":0}]
["Total Specified Costs",null,null,null,null,null,null,null,320.53813565136124,{"$f":"+J56+J77","v":0},null,null,0,{"$f":"+N56+N77","v":0},320.53813565136124,{"$f":"+P56+P77","v":0},205144.4068168712,{"$f":"+R56+R77","v":0}]
[]
["Returns Above Specified Costs",null,null,null,null,null,null,null,-88.538135651361216,{"$f":"+J14-J78","v":0},null,null,0,{"$f":"+N14-N78","v":0},-88.538135651361216,{"$f":"+P14-P78","v":0},-56664.406816871196,{"$f":"+R14-R78","v":0}]
[]
["    Breakeven Price to Cover Total Costs",null,null,null,null,null,0.83668167391050385,{"$f":"IF(E10=0,\"n/a\",(YTotExp-(YTotExp+YTotRet-J10))/E10)","v":"n/a"},"Pound"]
[]
[null,null,null,"Example Breakeven Prices"]
[null,"Example","Example","To Cover",null,null,"To Cover"]
[null,"Yield","Yield","Variable",null,null,"Total"]
[null,"Percent","Pound","Costs",null,null,"Costs"]
[null,0.75,240,0.78069015186860802,null,null,1.1155755652140051]
[null,0.9,288,0.65057512655717331,null,null,0.92964630434500428]
[null,1,320,0.58551761390145596,null,null,0.83668167391050385]
[null,1.1000000000000001,352,0.53228873991041459,null,null,0.76061970355500352]
[null,1.25,400,0.46841409112116478,null,null,0.66934533912840311]
[]
[null,null,null,"Your Breakeven Prices"]
[null,"Your","Your",null,"To Cover",null,null,"To Cover"]
[null,"Yield","Yield",null,"Variable",null,null,"Total"]
[null,"Percent","Pound",null,"Costs",null,null,"Costs"]
[null,0.75,{"$f":"E10*YPER1","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER1))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER1))","v":0}]
[null,0.9,{"$f":"E10*YPER2","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER2))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER2))","v":0}]
[null,1,{"$f":"+E10","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER3))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER3))","v":0}]
[null,1.1000000000000001,{"$f":"E10*YPER4","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER4))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER4))","v":0}]
[null,1.25,{"$f":"E10*YPER5","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER5))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER5))","v":0}]
[]
["  Developed by Extension Economists, Texas A&M AgriLife Extension Service, budgets@tamu.edu.  "]
[]
["Information presented is prepared solely as a general guide and not intended to recognize or predict the costs and returns from any one operation.  Brand names are mentioned only as examples and imply no endorsement."]

{"sheet":"CottonDrylandSolid","index":6,"n_rows":107,"n_cols":18,"rows_kept":107,"cut":false,"hidden":false,"merged":[[84,3,84,8],[94,3,94,8],[106,0,106,11],[0,0,0,11],[1,0,1,11],[2,0,2,11],[3,0,3,11]]}
["Projections for Planning Purposes Only -- Not to be Used without Updating"]
["2018 Estimated Costs and Returns per Acre"]
["Dryland Cotton (Solid 40\" Rows)"]
["Enter your name for this budget in the cell above."]
["Enter  Your Values in the cells highlighed in MAROON."]
[null,null,null,null,"Your Acres",null,null,null,null,null,null,null,null,null,null,null,null,"Your"]
[null,null,"Crop Acres",640,null,null,null,null,null,null,null,"Your",null,null,null,null,"Enterprise","Enterprise"]
[null,null,null,null,"Your",null,null,"Your","Cash","Your","Landlord","Landlord",null,"Your",null,"Your","Total","Total"]
["REVENUE",null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Share","Share","Landlord","Landlord","Tenant","Tenant","(640 acres)",{"$f":"\"(\" & E7 & \" acres)\"","v":"( acres)"}]
[null,"Cotton Lint",null,480,null,"Pound",0.56000000000000005,null,268.8,{"$f":"E10*H10","v":0},0,null,0,{"$f":"J10*L10","v":0},268.8,{"$f":"+J10-N10","v":0},172032,{"$f":"+J10*E$7","v":0}]
[null,"Cottonseed",null,0.39600000000000002,null,"Ton",200,null,79.2,0,0,null,0,0,79.2,{"$f":"+J11-N11","v":0},50688,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
["Total Revenue",null,null,null,null,null,null,null,348,{"$f":"SUM(J10:J13)","v":0},null,null,0,{"$f":"SUM(N10:N13)","v":0},348,{"$f":"SUM(P10:P13)","v":0},222720,{"$f":"SUM(R10:R13)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enterprise","Enterprise"]
["VARIABLE COSTS",null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Share","Share","Landlord","Landlord","Tenant","Tenant","Total","Total"]
["Production Costs"]
[null,"Custom"]
[null,"","Fertilizer Application",1,null,"Acre",5.5,null,5.5,{"$f":"E19*H19","v":0},0,null,0,{"$f":"J19*L19","v":0},5.5,{"$f":"+J19-N19","v":0},3520,{"$f":"+J19*E$7","v":0}]
[null,"","Insecticide Application",1,null,"Acre",5.5,null,5.5,0,0,null,0,0,5.5,0,3520,0]
[null,"","Gin, Bag, Ties",480,null,"Pound",0.12,null,57.599999999999994,0,0,null,0,0,57.599999999999994,0,36864,0]
[null,"","Custom Stripping",480,null,"Pound",0.1,null,48,0,0,null,0,0,48,0,30720,0]
[null,"Fertilizer"]
[null,"","Fertilizer (N)",57,null,"Pound",0.41,null,23.369999999999997,0,0,null,0,0,23.369999999999997,0,14956.8,0]
[null,"Herbicide"]
[null,"","Roundup",2,null,"Pint",2.1875,null,4.375,0,0,null,0,0,4.375,0,2800,0]
[null,"Insecticide"]
[null,"","Insecticide - Cotton",0.5,null,"Pound",7.2,null,3.6,0,0,null,0,0,3.6,0,2304,0]
[null,"","Bollweevil Eradication",1,null,"Acre",2.5,null,2.5,0,0,null,0,0,2.5,0,1600,0]
[null,"Miscellaneous"]
[null,"","Insurance - Dryland Cotton",1,null,"Acre",15,null,15,0,0,null,0,0,15,0,9600,0]
[null,"Seed"]
[null,"","Cotton Seed",5,null,"Pound",7.7,null,38.5,0,0,null,0,0,38.5,0,24640,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,0,null,null,0,null,0,{"$f":"E36*H36","v":0},0,null,0,{"$f":"J36*L36","v":0},0,{"$f":"+J36-N36","v":0},0,{"$f":"+J36*E$7","v":0}]
[null,"Machinery Labor"]
[null,null,"Tractors/Self-Propelled",1.01,null,"Hour",10,null,10.1,{"$f":"E38*H38","v":0},0,null,0,{"$f":"J38*L38","v":0},10.1,{"$f":"+J38-N38","v":0},6464,{"$f":"+J38*E$7","v":0}]
[null,null,"Other Labor",1.21,null,"Hour",10,null,12.1,{"$f":"E39*H39","v":0},0,null,0,{"$f":"J39*L39","v":0},12.1,{"$f":"+J39-N39","v":0},7744,{"$f":"+J39*E$7","v":0}]
[]
[null,"Diesel Fuel"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0,null,0,{"$f":"E42*H42","v":0},0,null,0,{"$f":"J42*L42","v":0},0,{"$f":"+J42-N42","v":0},0,{"$f":"+J42*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",6.88,null,"Gallon",2.1,null,14.448,{"$f":"E43*H43","v":0},0,null,0,{"$f":"J43*L43","v":0},14.448,{"$f":"+J43-N43","v":0},9246.7200000000012,{"$f":"+J43*E$7","v":0}]
[]
[null,"Gasoline"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",1.0546875,null,1.0546875,{"$f":"E46*H46","v":0},0,null,0,{"$f":"J46*L46","v":0},1.0546875,{"$f":"+J46-N46","v":0},675,{"$f":"+J46*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",0,null,"Gallon",2.25,null,0,{"$f":"E47*H47","v":0},0,null,0,{"$f":"J47*L47","v":0},0,{"$f":"+J47-N47","v":0},0,{"$f":"+J47*E$7","v":0}]
[]
[null,"Repairs & Maintenance"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0.28300781250000001,null,0.28300781250000001,{"$f":"E50*H50","v":0},0,null,0,{"$f":"J50*L50","v":0},0.28300781250000001,{"$f":"+J50-N50","v":0},181.125,{"$f":"+J50*E$7","v":0}]
[null,null,"Irrigation Equipment",1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,"Tractors/Self-Propelled",1,null,"Acre",13.429678373536111,null,13.429678373536111,0,0,null,0,0,13.429678373536111,0,8594.9941590631115,0]
[null,null,"Implements",1,null,"Acre",15.283402874287223,null,15.283402874287223,0,0,null,0,0,15.283402874287223,0,9781.3778395438221,0]
[null,null,null,null,null,null,null,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0,null,0,0,0,0,0,0]
[null,"Interest on Credit Line",null,null,null,null,5.7500000000000002E-2,null,4.9653548897301887,{"$f":"+SUM(J18:J55)/2*H56","v":0},null,null,0,{"$f":"+SUM(N18:N55)/2*L56","v":0},4.9653548897301887,{"$f":"+SUM(P18:P55)/2*L56","v":0},3177.8271294273209,{"$f":"+J56*E$7","v":0}]
["Total Variable Costs",null,null,null,null,null,null,null,275.6091314500535,{"$f":"SUM(J19:J56)","v":0},null,null,0,{"$f":"SUM(N19:N56)","v":0},275.6091314500535,{"$f":"SUM(P19:P56)","v":0},176389.84412803425,{"$f":"SUM(R19:R56)","v":0}]
["Planned Returns Above Variable Costs:",null,null,null,null,null,null,null,72.390868549946504,{"$f":"+J14-J57","v":0},null,null,0,{"$f":"+N14-N57","v":0},72.390868549946504,{"$f":"+P14-P57","v":0},46330.155871965748,{"$f":"+R14-R57","v":0}]
[null,"Breakeven Price to Cover Variable Costs",null,null,null,null,0.40918569052094483,{"$f":"IF(E10=0,\"n/a\",(YVarExp-(YTotExp+YTotRet-J10))/E10)","v":"n/a"},"Pound"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enterprise","Enterprise"]
["FIXED COSTS",null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Share","Share","Landlord","Landlord","Tenant","Tenant","Total","Total"]
[null,"Machinery Depreciation"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0.39290917968749994,null,0.39290917968749994,{"$f":"E63*H63","v":0},0,null,0,{"$f":"J63*L63","v":0},0.39290917968749994,{"$f":"+J63-N63","v":0},251.46187499999996,{"$f":"+J63*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",1,null,"Acre",13.877334319320649,null,13.877334319320649,0,0,null,0,{"$f":"J64*L64","v":0},13.877334319320649,0,8881.493964365216,0]
[null,null,"Implements",1,null,"Acre",19.037479776759248,null,19.037479776759248,0,0,null,0,{"$f":"J65*L65","v":0},19.037479776759248,0,12183.98705712592,0]
[null,"Equipment Investment"]
[null,null,"Pickup/General Use Equipment",2.7522509765624998,null,"Dollars",5.5E-2,null,0.1513738037109375,{"$f":"E67*H67","v":0},0,null,0,{"$f":"J67*L67","v":0},0.1513738037109375,{"$f":"+J67-N67","v":0},96.87923437500001,{"$f":"+J67*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",108.10891090696569,null,"Dollars",5.5E-2,null,5.9459900998831126,0,0,null,0,{"$f":"J68*L68","v":0},5.9459900998831126,0,3805.4336639251919,0]
[null,null,"Implements",81.438107933914551,null,"Dollars",5.5E-2,null,4.4790959363653,0,0,null,0,{"$f":"J69*L69","v":0},4.4790959363653,0,2866.6213992737921,0]
[null,"Salaried Labor",null,1,null,"Acre",0,null,0,0,0,null,0,{"$f":"J70*L70","v":0},0,{"$f":"+J70-N70","v":0},0,{"$f":"+J70*E$7","v":0}]
[null,"Management Fee, Owner/Operator Labor",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,"Allocated Establishment Cost",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,"Cash Rent - Dryland Cotton",null,1,null,"Acre",32,null,32,0,0,null,0,0,32,0,20480,0]
[null,"Property Taxes",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,"Whole Farm Insurance",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,1,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,1,null,null,0,null,0,{"$f":"E77*H77","v":0},0,null,0,0,0,0,0,0]
["Total Fixed Costs",null,null,null,null,null,null,null,75.884183115726756,{"$f":"+SUM(J63:J77)","v":0},null,null,0,{"$f":"+SUM(N63:N77)","v":0},75.884183115726756,{"$f":"+SUM(P63:P77)","v":0},48565.87719406512,{"$f":"+SUM(R63:R77)","v":0}]
["Total Specified Costs",null,null,null,null,null,null,null,351.49331456578022,{"$f":"+J57+J78","v":0},null,null,0,{"$f":"+N57+N78","v":0},351.49331456578022,{"$f":"+P57+P78","v":0},224955.72132209939,{"$f":"+R57+R78","v":0}]
[]
["Returns Above Specified Costs",null,null,null,null,null,null,null,-3.4933145657802243,{"$f":"+J14-J79","v":0},null,null,0,{"$f":"+N14-N79","v":0},-3.4933145657802243,{"$f":"+P14-P79","v":0},-2235.7213220993872,{"$f":"+R14-R79","v":0}]
[]
["    Breakeven Price to Cover Total Costs",null,null,null,null,null,0.56727773867870879,{"$f":"IF(E10=0,\"n/a\",(YTotExp-(YTotExp+YTotRet-J10))/E10)","v":"n/a"},"Pound"]
[]
[null,null,null,"Example Breakeven Prices"]
[null,"Example","Example","To Cover",null,null,"To Cover"]
[null,"Yield","Yield","Variable",null,null,"Total"]
[null,"Percent","Pound","Costs",null,null,"Costs"]
[null,0.75,360,0.54558092069459307,null,null,0.75637031823827838]
[null,0.9,432,0.45465076724549425,null,null,0.63030859853189869]
[null,1,480,0.40918569052094483,null,null,0.56727773867870879]
[null,1.1000000000000001,528,0.3719869913826771,null,null,0.51570703516246252]
[null,1.25,600,0.32734855241675587,null,null,0.45382219094296705]
[]
[null,null,null,"Your Breakeven Prices"]
[null,"Your","Your",null,"To Cover",null,null,"To Cover"]
[null,"Yield","Yield",null,"Variable",null,null,"Total"]
[null,"Percent","Pound",null,"Costs",null,null,"Costs"]
[null,0.75,{"$f":"E10*YPER1","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER1))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER1))","v":0}]
[null,0.9,{"$f":"E10*YPER2","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER2))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER2))","v":0}]
[null,1,{"$f":"+E10","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER3))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER3))","v":0}]
[null,1.1000000000000001,{"$f":"E10*YPER4","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER4))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER4))","v":0}]
[null,1.25,{"$f":"E10*YPER5","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER5))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER5))","v":0}]
[]
["  Developed by Extension Economists, Texas A&M AgriLife Extension Service, budgets@tamu.edu.  "]
[]
["Information presented is prepared solely as a general guide and not intended to recognize or predict the costs and returns from any one operation.  Brand names are mentioned only as examples and imply no endorsement."]

{"sheet":"CottonIrrigated","index":7,"n_rows":118,"n_cols":18,"rows_kept":118,"cut":false,"hidden":false,"merged":[[95,3,95,8],[105,3,105,8],[117,0,117,11],[0,0,0,11],[1,0,1,11],[2,0,2,11],[3,0,3,11]]}
["Projections for Planning Purposes Only -- Not to be Used without Updating"]
["2018 Estimated Costs and Returns per Acre"]
["Sprinkler Irrigated Cotton"]
["Enter your name for this budget in the cell above."]
["Enter  Your Values in the cells highlighed in MAROON."]
[null,null,null,null,"Your Acres",null,null,null,null,null,null,null,null,null,null,null,null,"Your"]
[null,null,"Crop Acres",120,null,null,null,null,null,null,null,"Your",null,null,null,null,"Enterprise","Enterprise"]
[null,null,null,null,"Your",null,null,"Your","Cash","Your","Landlord","Landlord",null,"Your",null,"Your","Total","Total"]
["REVENUE",null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Share","Share","Landlord","Landlord","Tenant","Tenant","(120 acres)",{"$f":"\"(\" & E7 & \" acres)\"","v":"( acres)"}]
[null,"Cotton Lint",null,800,null,"Pound",0.56000000000000005,null,448.00000000000006,{"$f":"E10*H10","v":0},0,null,0,{"$f":"J10*L10","v":0},448.00000000000006,{"$f":"+J10-N10","v":0},53760.000000000007,{"$f":"+J10*E$7","v":0}]
[null,"Cottonseed",null,0.6,null,"Ton",200,null,120,0,0,null,0,0,120,{"$f":"+J11-N11","v":0},14400,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
["Total Revenue",null,null,null,null,null,null,null,568,{"$f":"SUM(J10:J13)","v":0},null,null,0,{"$f":"SUM(N10:N13)","v":0},568,{"$f":"SUM(P10:P13)","v":0},68160,{"$f":"SUM(R10:R13)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enterprise","Enterprise"]
["VARIABLE COSTS",null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Share","Share","Landlord","Landlord","Tenant","Tenant","Total","Total"]
["Production Costs"]
[null,"Custom"]
[null,"","Fertilizer Application",1,null,"Acre",5.5,null,5.5,{"$f":"E19*H19","v":0},0,null,0,{"$f":"J19*L19","v":0},5.5,{"$f":"+J19-N19","v":0},660,{"$f":"+J19*E$7","v":0}]
[null,"","Insecticide Application",1,null,"Acre",5.5,null,5.5,0,0,null,0,0,5.5,0,660,0]
[null,"","Harvest Aid Application",1,null,"Acre",5.5,null,5.5,0,0,null,0,0,5.5,0,660,0]
[null,"","Gin, Bag, Ties",800,null,"Pound",0.12,null,96,0,0,null,0,0,96,0,11520,0]
[null,"","Custom Picking",800,null,"Pound",0.13,null,104,0,0,null,0,0,104,0,12480,0]
[null,"Fertilizer"]
[null,"","Fertilizer (N)",75,null,"Pound",0.41,null,30.749999999999996,0,0,null,0,0,30.749999999999996,0,3689.9999999999995,0]
[null,"","Fertilizer (P)",60,null,"Pound",0.34,null,20.400000000000002,0,0,null,0,0,20.400000000000002,0,2448.0000000000005,0]
[null,"","Potash (K)",40,null,"Pound",0.3,null,12,0,0,null,0,0,12,0,1440,0]
[null,"","Sulfur",12,null,"Pound",0.25,null,3,0,0,null,0,0,3,0,360,0]
[null,"Herbicide"]
[null,"","Roundup",2,null,"Pint",2.1875,null,4.375,0,0,null,0,0,4.375,0,525,0]
[null,"","Harvest Aid - Prep",3,null,"Pint",2.375,null,7.125,0,0,null,0,0,7.125,0,855,0]
[null,"","Harvest Aid -Def",8,null,"Ounce",0.546875,null,4.375,0,0,null,0,0,4.375,0,525,0]
[null,"Seed"]
[null,"","Cotton Seed",11.5,null,"Pound",7.7,null,88.55,0,0,null,0,0,88.55,0,10626,0]
[null,"Insecticide"]
[null,"","Insecticide - Cotton",0.5,null,"Pound",7.2,null,3.6,0,0,null,0,0,3.6,0,432,0]
[null,"","Bollweevil Eradication",1,null,"Acre",2.5,null,2.5,0,0,null,0,0,2.5,0,300,0]
[null,"Miscellaneous"]
[null,"","Insurance - Irrigated Cotton",1,null,"Acre",17,null,17,0,0,null,0,0,17,0,2040,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,0,null,null,0,null,0,{"$f":"E42*H42","v":0},0,null,0,{"$f":"J42*L42","v":0},0,{"$f":"+J42-N42","v":0},0,{"$f":"+J42*E$7","v":0}]
[null,"Irrigation"]
[null,null,"Energy Cost",15,null,"AcreInch",1.2000367064824382,null,18.000550597236572,{"$f":"E44*H44","v":0},0,null,0,{"$f":"J44*L44","v":0},18.000550597236572,{"$f":"+J44-N44","v":0},2160.0660716683888,{"$f":"+J44*E$7","v":0}]
[null,null,"Irrigation Labor",0.96,null,"Hour",10,null,9.6,0,0,null,0,0,9.6,0,1152,0]
[null,"Machinery Labor"]
[null,null,"Tractors/Self-Propelled",0.87,null,"Hour",10,null,8.6999999999999993,{"$f":"E47*H47","v":0},0,null,0,{"$f":"J47*L47","v":0},8.6999999999999993,{"$f":"+J47-N47","v":0},1044,{"$f":"+J47*E$7","v":0}]
[null,null,"Other Labor",1.04,null,"Hour",10,null,10.4,{"$f":"E48*H48","v":0},0,null,0,{"$f":"J48*L48","v":0},10.4,{"$f":"+J48-N48","v":0},1248,{"$f":"+J48*E$7","v":0}]
[]
[null,"Diesel Fuel"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0,null,0,{"$f":"E51*H51","v":0},0,null,0,{"$f":"J51*L51","v":0},0,{"$f":"+J51-N51","v":0},0,{"$f":"+J51*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",5.92,null,"Gallon",2.1,null,12.432,{"$f":"E52*H52","v":0},0,null,0,{"$f":"J52*L52","v":0},12.432,{"$f":"+J52-N52","v":0},1491.8400000000001,{"$f":"+J52*E$7","v":0}]
[]
[null,"Gasoline"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",9,null,9,{"$f":"E55*H55","v":0},0,null,0,{"$f":"J55*L55","v":0},9,{"$f":"+J55-N55","v":0},1080,{"$f":"+J55*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",0,null,"Gallon",2.25,null,0,{"$f":"E56*H56","v":0},0,null,0,{"$f":"J56*L56","v":0},0,{"$f":"+J56-N56","v":0},0,{"$f":"+J56*E$7","v":0}]
[]
[null,"Repairs & Maintenance"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",2.415,null,2.415,{"$f":"E59*H59","v":0},0,null,0,{"$f":"J59*L59","v":0},2.415,{"$f":"+J59-N59","v":0},289.8,{"$f":"+J59*E$7","v":0}]
[null,null,"Irrigation Equipment",1,null,"Acre",16.669499999999999,null,16.669499999999999,0,0,null,0,0,16.669499999999999,0,2000.34,0]
[null,null,"Tractors/Self-Propelled",1,null,"Acre",11.546081667256079,null,11.546081667256079,0,0,null,0,0,11.546081667256079,0,1385.5298000707294,0]
[null,null,"Implements",1,null,"Acre",13.530715556940979,null,13.530715556940979,0,0,null,0,0,13.530715556940979,0,1623.6858668329176,0]
[null,null,null,null,null,null,null,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0,null,0,0,0,0,0,0]
[null,"Interest on Credit Line",null,null,null,null,5.7500000000000002E-2,null,10.271029197661106,{"$f":"+SUM(J18:J64)/2*H65","v":0},null,null,0,{"$f":"+SUM(N18:N64)/2*L65","v":0},10.271029197661106,{"$f":"+SUM(P18:P64)/2*L65","v":0},1232.5235037193327,{"$f":"+J65*E$7","v":0}]
["Total Variable Costs",null,null,null,null,null,null,null,532.73987701909471,{"$f":"SUM(J19:J65)","v":0},null,null,0,{"$f":"SUM(N19:N65)","v":0},532.73987701909471,{"$f":"SUM(P19:P65)","v":0},63928.785242291364,{"$f":"SUM(R19:R65)","v":0}]
["Planned Returns Above Variable Costs:",null,null,null,null,null,null,null,35.260122980905294,{"$f":"+J14-J66","v":0},null,null,0,{"$f":"+N14-N66","v":0},35.260122980905294,{"$f":"+P14-P66","v":0},4231.2147577086362,{"$f":"+R14-R66","v":0}]
[null,"Breakeven Price to Cover Variable Costs",null,null,null,null,0.51592484627386836,{"$f":"IF(E10=0,\"n/a\",(YVarExp-(YTotExp+YTotRet-J10))/E10)","v":"n/a"},"Pound"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enterprise","Enterprise"]
["FIXED COSTS",null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Share","Share","Landlord","Landlord","Tenant","Tenant","Total","Total"]
[null,"Machinery Depreciation"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",3.3528249999999997,null,3.3528249999999997,{"$f":"E72*H72","v":0},0,null,0,{"$f":"J72*L72","v":0},3.3528249999999997,{"$f":"+J72-N72","v":0},402.33899999999994,{"$f":"+J72*E$7","v":0}]
[null,null,"Irrigation Equipment",1,null,"Acre",10,null,10,0,0,null,0,{"$f":"J73*L73","v":0},10,0,1200,0]
[null,null,"Tractors/Self-Propelled",1,null,"Acre",11.930951056164616,null,11.930951056164616,0,0,null,0,{"$f":"J74*L74","v":0},11.930951056164616,0,1431.714126739754,0]
[null,null,"Implements",1,null,"Acre",17.288940021600474,null,17.288940021600474,0,0,null,0,{"$f":"J75*L75","v":0},17.288940021600474,0,2074.672802592057,0]
[null,"Equipment Investment"]
[null,null,"Pickup/General Use Equipment",23.485875000000004,null,"Dollars",5.5E-2,null,1.2917231250000003,{"$f":"E77*H77","v":0},0,null,0,{"$f":"J77*L77","v":0},1.2917231250000003,{"$f":"+J77-N77","v":0},155.00677500000003,{"$f":"+J77*E$7","v":0}]
[null,null,"Irrigation Equipment",291.66666666666669,null,"Dollars",5.5E-2,null,16.041666666666668,0,0,null,0,{"$f":"J78*L78","v":0},16.041666666666668,0,1925.0000000000002,0]
[null,null,"Tractors/Self-Propelled",92.945957421411421,null,"Dollars",5.5E-2,null,5.1120276581776283,0,0,null,0,{"$f":"J79*L79","v":0},5.1120276581776283,0,613.44331898131543,0]
[null,null,"Implements",73.958243425735361,null,"Dollars",5.5E-2,null,4.0677033884154445,0,0,null,0,{"$f":"J80*L80","v":0},4.0677033884154445,0,488.12440660985334,0]
[null,"Salaried Labor",null,1,null,"Acre",0,null,0,0,0,null,0,{"$f":"J81*L81","v":0},0,{"$f":"+J81-N81","v":0},0,{"$f":"+J81*E$7","v":0}]
[null,"Management Fee, Owner/Operator Labor",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,"Allocated Establishment Cost",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,"Cash Rent - Irrigated Cotton",null,1,null,"Acre",75,null,75,0,0,null,0,0,75,0,9000,0]
[null,"Property Taxes",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,"Whole Farm Insurance",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,1,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,1,null,null,0,null,0,{"$f":"E88*H88","v":0},0,null,0,0,0,0,0,0]
["Total Fixed Costs",null,null,null,null,null,null,null,144.08583691602482,{"$f":"+SUM(J72:J88)","v":0},null,null,0,{"$f":"+SUM(N72:N88)","v":0},144.08583691602482,{"$f":"+SUM(P72:P88)","v":0},17290.30042992298,{"$f":"+SUM(R72:R88)","v":0}]
["Total Specified Costs",null,null,null,null,null,null,null,676.82571393511955,{"$f":"+J66+J89","v":0},null,null,0,{"$f":"+N66+N89","v":0},676.82571393511955,{"$f":"+P66+P89","v":0},81219.085672214336,{"$f":"+R66+R89","v":0}]
[]
["Returns Above Specified Costs",null,null,null,null,null,null,null,-108.82571393511955,{"$f":"+J14-J90","v":0},null,null,0,{"$f":"+N14-N90","v":0},-108.82571393511955,{"$f":"+P14-P90","v":0},-13059.085672214336,{"$f":"+R14-R90","v":0}]
[]
["    Breakeven Price to Cover Total Costs",null,null,null,null,null,0.69603214241889944,{"$f":"IF(E10=0,\"n/a\",(YTotExp-(YTotExp+YTotRet-J10))/E10)","v":"n/a"},"Pound"]
[]
[null,null,null,"Example Breakeven Prices"]
[null,"Example","Example","To Cover",null,null,"To Cover"]
[null,"Yield","Yield","Variable",null,null,"Total"]
[null,"Percent","Pound","Costs",null,null,"Costs"]
[null,0.75,600,0.68789979503182452,null,null,0.92804285655853258]
[null,0.9,720,0.57324982919318712,null,null,0.77336904713211052]
[null,1,800,0.51592484627386836,null,null,0.69603214241889944]
[null,1.1000000000000001,880.00000000000011,0.46902258752169845,null,null,0.63275649310809035]
[null,1.25,1000,0.4127398770190947,null,null,0.55682571393511959]
[]
[null,null,null,"Your Breakeven Prices"]
[null,"Your","Your",null,"To Cover",null,null,"To Cover"]
[null,"Yield","Yield",null,"Variable",null,null,"Total"]
[null,"Percent","Pound",null,"Costs",null,null,"Costs"]
[null,0.75,{"$f":"E10*YPER1","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER1))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER1))","v":0}]
[null,0.9,{"$f":"E10*YPER2","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER2))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER2))","v":0}]
[null,1,{"$f":"+E10","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER3))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER3))","v":0}]
[null,1.1000000000000001,{"$f":"E10*YPER4","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER4))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER4))","v":0}]
[null,1.25,{"$f":"E10*YPER5","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER5))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER5))","v":0}]
[]
["  Developed by Extension Economists, Texas A&M AgriLife Extension Service, budgets@tamu.edu.  "]
[]
["Information presented is prepared solely as a general guide and not intended to recognize or predict the costs and returns from any one operation.  Brand names are mentioned only as examples and imply no endorsement."]

{"sheet":"Peanuts","index":8,"n_rows":110,"n_cols":18,"rows_kept":110,"cut":false,"hidden":false,"merged":[[87,3,87,8],[97,3,97,8],[109,0,109,11],[0,0,0,11],[1,0,1,11],[2,0,2,11],[3,0,3,11]]}
["Projections for Planning Purposes Only -- Not to be Used without Updating"]
["2018 Estimated Costs and Returns per Acre"]
["Sprinkler Irrigated Peanuts"]
["Enter your name for this budget in the cell above."]
["Enter  Your Values in the cells highlighed in MAROON."]
[null,null,null,null,"Your Acres",null,null,null,null,null,null,null,null,null,null,null,null,"Your"]
[null,null,"Crop Acres",120,null,null,null,null,null,null,null,"Your",null,null,null,null,"Enterprise","Enterprise"]
[null,null,null,null,"Your",null,null,"Your","Cash","Your","Landlord","Landlord",null,"Your",null,"Your","Total","Total"]
["REVENUE",null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Share","Share","Landlord","Landlord","Tenant","Tenant","(120 acres)",{"$f":"\"(\" & E7 & \" acres)\"","v":"( acres)"}]
[null,"Runner Peanuts",null,2,null,"Ton",390,null,780,{"$f":"E10*H10","v":0},0,null,0,{"$f":"J10*L10","v":0},780,{"$f":"+J10-N10","v":0},93600,{"$f":"+J10*E$7","v":0}]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,{"$f":"+J11-N11","v":0},0,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
["Total Revenue",null,null,null,null,null,null,null,780,{"$f":"SUM(J10:J12)","v":0},null,null,0,{"$f":"SUM(N10:N12)","v":0},780,{"$f":"SUM(P10:P12)","v":0},93600,{"$f":"SUM(R10:R12)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enterprise","Enterprise"]
["VARIABLE COSTS",null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Share","Share","Landlord","Landlord","Tenant","Tenant","Total","Total"]
["Production Costs"]
[null,"Custom"]
[null,"","Fungicide Application",2,null,"Acre",5.5,null,11,{"$f":"E18*H18","v":0},0,null,0,{"$f":"J18*L18","v":0},11,{"$f":"+J18-N18","v":0},1320,{"$f":"+J18*E$7","v":0}]
[null,"","Drying - Peanut",2,null,"Ton",20,null,40,0,0,null,0,0,40,0,4800,0]
[null,"Fertilizer"]
[null,"","Fertilizer (N)",40,null,"Pound",0.41,null,16.399999999999999,0,0,null,0,0,16.399999999999999,0,1967.9999999999998,0]
[null,"","Fertilizer (P)",40,null,"Pound",0.34,null,13.600000000000001,0,0,null,0,0,13.600000000000001,0,1632.0000000000002,0]
[null,"Herbicide"]
[null,"","Prowl",1.5,null,"Pint",3.4375,null,5.15625,0,0,null,0,0,5.15625,0,618.75,0]
[null,"","Valor SX",2,null,"Ounce",4.75,null,9.5,0,0,null,0,0,9.5,0,1140,0]
[null,"","Cobra",12.5,null,"Ounce",1.484375,null,18.5546875,0,0,null,0,0,18.5546875,0,2226.5625,0]
[null,"Seed"]
[null,"","Peanut Seed",90,null,"Pound",0.85,null,76.5,0,0,null,0,0,76.5,0,9180,0]
[null,"Fungicides"]
[null,"","Folicular Fungicide-Abound",24.5,null,"Ounce",1.4058593749999999,null,34.443554687499997,0,0,null,0,0,34.443554687499997,0,4133.2265625,0]
[null,"","Fungicide - Bravo",1.5,null,"Pint",3.5625,null,5.34375,0,0,null,0,0,5.34375,0,641.25,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,0,null,null,0,null,0,{"$f":"E34*H34","v":0},0,null,0,{"$f":"J34*L34","v":0},0,{"$f":"+J34-N34","v":0},0,{"$f":"+J34*E$7","v":0}]
[null,"Irrigation"]
[null,null,"Energy Cost",18.949999999999996,null,"AcreInch",1.2000367064824382,null,22.7406955878422,{"$f":"E36*H36","v":0},0,null,0,{"$f":"J36*L36","v":0},22.7406955878422,{"$f":"+J36-N36","v":0},2728.8834705410641,{"$f":"+J36*E$7","v":0}]
[null,null,"Irrigation Labor",1.2080000000000002,null,"Hour",10,null,12.080000000000002,0,0,null,0,0,12.080000000000002,0,1449.6000000000001,0]
[null,"Machinery Labor"]
[null,null,"Tractors/Self-Propelled",1.96,null,"Hour",10,null,19.600000000000001,{"$f":"E39*H39","v":0},0,null,0,{"$f":"J39*L39","v":0},19.600000000000001,{"$f":"+J39-N39","v":0},2352,{"$f":"+J39*E$7","v":0}]
[null,null,"Other Labor",2.35,null,"Hour",10,null,23.5,{"$f":"E40*H40","v":0},0,null,0,{"$f":"J40*L40","v":0},23.5,{"$f":"+J40-N40","v":0},2820,{"$f":"+J40*E$7","v":0}]
[]
[null,"Diesel Fuel"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0,null,0,{"$f":"E43*H43","v":0},0,null,0,{"$f":"J43*L43","v":0},0,{"$f":"+J43-N43","v":0},0,{"$f":"+J43*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",13.37,null,"Gallon",2.1,null,28.076999999999998,{"$f":"E44*H44","v":0},0,null,0,{"$f":"J44*L44","v":0},28.076999999999998,{"$f":"+J44-N44","v":0},3369.24,{"$f":"+J44*E$7","v":0}]
[]
[null,"Gasoline"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",6.375,null,6.375,{"$f":"E47*H47","v":0},0,null,0,{"$f":"J47*L47","v":0},6.375,{"$f":"+J47-N47","v":0},765,{"$f":"+J47*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",0,null,"Gallon",2.25,null,0,{"$f":"E48*H48","v":0},0,null,0,{"$f":"J48*L48","v":0},0,{"$f":"+J48-N48","v":0},0,{"$f":"+J48*E$7","v":0}]
[]
[null,"Repairs & Maintenance"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",1.7106250000000001,null,1.7106250000000001,{"$f":"E51*H51","v":0},0,null,0,{"$f":"J51*L51","v":0},1.7106250000000001,{"$f":"+J51-N51","v":0},205.27500000000001,{"$f":"+J51*E$7","v":0}]
[null,null,"Irrigation Equipment",1,null,"Acre",16.670315000000002,null,16.670315000000002,0,0,null,0,0,16.670315000000002,0,2000.4378000000002,0]
[null,null,"Tractors/Self-Propelled",1,null,"Acre",26.087604086391877,null,26.087604086391877,0,0,null,0,0,26.087604086391877,0,3130.5124903670253,0]
[null,null,"Implements",1,null,"Acre",22.245182304437954,null,22.245182304437954,0,0,null,0,0,22.245182304437954,0,2669.4218765325545,0]
[null,null,null,null,null,null,null,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0,null,0,0,0,0,0,0]
[null,"Interest on Credit Line",null,null,null,null,5.7500000000000002E-2,null,10.036503593363365,{"$f":"+SUM(J17:J56)/2*H57","v":0},null,null,0,{"$f":"+SUM(N17:N56)/2*L57","v":0},10.036503593363365,{"$f":"+SUM(P17:P56)/2*L57","v":0},1204.3804312036038,{"$f":"+J57*E$7","v":0}]
["Total Variable Costs",null,null,null,null,null,null,null,419.62116775953541,{"$f":"SUM(J18:J57)","v":0},null,null,0,{"$f":"SUM(N18:N57)","v":0},419.62116775953541,{"$f":"SUM(P18:P57)","v":0},50354.54013114424,{"$f":"SUM(R18:R57)","v":0}]
["Planned Returns Above Variable Costs:",null,null,null,null,null,null,null,360.37883224046459,{"$f":"+J13-J58","v":0},null,null,0,{"$f":"+N13-N58","v":0},360.37883224046459,{"$f":"+P13-P58","v":0},43245.45986885576,{"$f":"+R13-R58","v":0}]
[null,"Breakeven Price to Cover Variable Costs",null,null,null,null,209.81058387976771,{"$f":"IF(E10=0,\"n/a\",(YVarExp-(YTotExp+YTotRet-J10))/E10)","v":"n/a"},"Ton"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enterprise","Enterprise"]
["FIXED COSTS",null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Share","Share","Landlord","Landlord","Tenant","Tenant","Total","Total"]
[null,"Machinery Depreciation"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",2.3749177083333333,null,2.3749177083333333,{"$f":"E64*H64","v":0},0,null,0,{"$f":"J64*L64","v":0},2.3749177083333333,{"$f":"+J64-N64","v":0},284.99012499999998,{"$f":"+J64*E$7","v":0}]
[null,null,"Irrigation Equipment",1,null,"Acre",10,null,10,0,0,null,0,{"$f":"J65*L65","v":0},10,0,1200,0]
[null,null,"Tractors/Self-Propelled",1,null,"Acre",26.957190889271612,null,26.957190889271612,0,0,null,0,{"$f":"J66*L66","v":0},26.957190889271612,0,3234.8629067125935,0]
[null,null,"Implements",1,null,"Acre",28.320853257625767,null,28.320853257625767,0,0,null,0,{"$f":"J67*L67","v":0},28.320853257625767,0,3398.5023909150923,0]
[null,"Equipment Investment"]
[null,null,"Pickup/General Use Equipment",16.635828125000003,null,"Dollars",5.5E-2,null,0.91497054687500023,{"$f":"E69*H69","v":0},0,null,0,{"$f":"J69*L69","v":0},0.91497054687500023,{"$f":"+J69-N69","v":0},109.79646562500002,{"$f":"+J69*E$7","v":0}]
[null,null,"Irrigation Equipment",291.66666666666669,null,"Dollars",5.5E-2,null,16.041666666666668,0,0,null,0,{"$f":"J70*L70","v":0},16.041666666666668,0,1925.0000000000002,0]
[null,null,"Tractors/Self-Propelled",210.0052128954546,null,"Dollars",5.5E-2,null,11.550286709250003,0,0,null,0,{"$f":"J71*L71","v":0},11.550286709250003,0,1386.0344051100003,0]
[null,null,"Implements",332.99978069958047,null,"Dollars",5.5E-2,null,18.314987938476925,0,0,null,0,{"$f":"J72*L72","v":0},18.314987938476925,0,2197.7985526172311,0]
[null,"Salaried Labor",null,1,null,"Acre",0,null,0,0,0,null,0,{"$f":"J73*L73","v":0},0,{"$f":"+J73-N73","v":0},0,{"$f":"+J73*E$7","v":0}]
[null,"Management Fee, Owner/Operator Labor",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,"Allocated Establishment Cost",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,"Cash Rent - Peanuts",null,1,null,"Acre",75,null,75,0,0,null,0,0,75,0,9000,0]
[null,"Property Taxes",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,"Whole Farm Insurance",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,1,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,1,null,null,0,null,0,{"$f":"E80*H80","v":0},0,null,0,0,0,0,0,0]
["Total Fixed Costs",null,null,null,null,null,null,null,189.4748737164993,{"$f":"+SUM(J64:J80)","v":0},null,null,0,{"$f":"+SUM(N64:N80)","v":0},189.4748737164993,{"$f":"+SUM(P64:P80)","v":0},22736.984845979918,{"$f":"+SUM(R64:R80)","v":0}]
["Total Specified Costs",null,null,null,null,null,null,null,609.09604147603477,{"$f":"+J58+J81","v":0},null,null,0,{"$f":"+N58+N81","v":0},609.09604147603477,{"$f":"+P58+P81","v":0},73091.524977124151,{"$f":"+R58+R81","v":0}]
[]
["Returns Above Specified Costs",null,null,null,null,null,null,null,170.90395852396523,{"$f":"+J13-J82","v":0},null,null,0,{"$f":"+N13-N82","v":0},170.90395852396523,{"$f":"+P13-P82","v":0},20508.475022875849,{"$f":"+R13-R82","v":0}]
[]
["    Breakeven Price to Cover Total Costs",null,null,null,null,null,304.54802073801739,{"$f":"IF(E10=0,\"n/a\",(YTotExp-(YTotExp+YTotRet-J10))/E10)","v":"n/a"},"Ton"]
[]
[null,null,null,"Example Breakeven Prices"]
[null,"Example","Example","To Cover",null,null,"To Cover"]
[null,"Yield","Yield","Variable",null,null,"Total"]
[null,"Percent","Ton","Costs",null,null,"Costs"]
[null,0.75,1.5,279.74744517302361,null,null,406.06402765068987]
[null,0.9,1.8,233.12287097751965,null,null,338.38668970890819]
[null,1,2,209.81058387976771,null,null,304.54802073801739]
[null,1.1000000000000001,2.2000000000000002,190.73689443615245,null,null,276.86183703456123]
[null,1.25,2.5,167.84846710381416,null,null,243.6384165904139]
[]
[null,null,null,"Your Breakeven Prices"]
[null,"Your","Your",null,"To Cover",null,null,"To Cover"]
[null,"Yield","Yield",null,"Variable",null,null,"Total"]
[null,"Percent","Ton",null,"Costs",null,null,"Costs"]
[null,0.75,{"$f":"E10*YPER1","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER1))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER1))","v":0}]
[null,0.9,{"$f":"E10*YPER2","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER2))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER2))","v":0}]
[null,1,{"$f":"+E10","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER3))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER3))","v":0}]
[null,1.1000000000000001,{"$f":"E10*YPER4","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER4))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER4))","v":0}]
[null,1.25,{"$f":"E10*YPER5","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER5))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER5))","v":0}]
[]
["  Developed by Extension Economists, Texas A&M AgriLife Extension Service, budgets@tamu.edu.  "]
[]
["Information presented is prepared solely as a general guide and not intended to recognize or predict the costs and returns from any one operation.  Brand names are mentioned only as examples and imply no endorsement."]

{"sheet":"SorghumDryland","index":9,"n_rows":99,"n_cols":18,"rows_kept":99,"cut":false,"hidden":false,"merged":[[76,3,76,8],[86,3,86,8],[98,0,98,11],[0,0,0,11],[1,0,1,11],[2,0,2,11],[3,0,3,11]]}
["Projections for Planning Purposes Only -- Not to be Used without Updating"]
["2018 Estimated Costs and Returns per Acre"]
["Dryland Sorghum"]
["Enter your name for this budget in the cell above."]
["Enter  Your Values in the cells highlighed in MAROON."]
[null,null,null,null,"Your Acres",null,null,null,null,null,null,null,null,null,null,null,null,"Your"]
[null,null,"Crop Acres",640,null,null,null,null,null,null,null,"Your",null,null,null,null,"Enterprise","Enterprise"]
[null,null,null,null,"Your",null,null,"Your","Cash","Your","Landlord","Landlord",null,"Your",null,"Your","Total","Total"]
["REVENUE",null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Share","Share","Landlord","Landlord","Tenant","Tenant","(640 acres)",{"$f":"\"(\" & E7 & \" acres)\"","v":"( acres)"}]
[null,"Grain Sorghum",null,22,null,"CWT",5.77,null,126.94,{"$f":"E10*H10","v":0},0,null,0,{"$f":"J10*L10","v":0},126.94,{"$f":"+J10-N10","v":0},81241.600000000006,{"$f":"+J10*E$7","v":0}]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,{"$f":"+J11-N11","v":0},0,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
["Total Revenue",null,null,null,null,null,null,null,126.94,{"$f":"SUM(J10:J12)","v":0},null,null,0,{"$f":"SUM(N10:N12)","v":0},126.94,{"$f":"SUM(P10:P12)","v":0},81241.600000000006,{"$f":"SUM(R10:R12)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enterprise","Enterprise"]
["VARIABLE COSTS",null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Share","Share","Landlord","Landlord","Tenant","Tenant","Total","Total"]
["Production Costs"]
[null,"Herbicide"]
[null,"","Atrazine",1,null,"Quart",4.125,null,4.125,{"$f":"E18*H18","v":0},0,null,0,{"$f":"J18*L18","v":0},4.125,{"$f":"+J18-N18","v":0},2640,{"$f":"+J18*E$7","v":0}]
[null,"Seed"]
[null,"","Grain Sorghum Seed",3,null,"Pound",2.5,null,7.5,0,0,null,0,0,7.5,0,4800,0]
[null,"Custom"]
[null,"","Custom Harvest Sorghum",1,null,"Acre",24,null,24,0,0,null,0,0,24,0,15360,0]
[null,"","Custom Haul Sorghum",22,null,"CWT",0.24,null,5.2799999999999994,0,0,null,0,0,5.2799999999999994,0,3379.2,0]
[null,"Miscellaneous"]
[null,"","Insurance - Grain Sorghum",1,null,"Acre",8,null,8,0,0,null,0,0,8,0,5120,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,0,null,null,0,null,0,{"$f":"E28*H28","v":0},0,null,0,{"$f":"J28*L28","v":0},0,{"$f":"+J28-N28","v":0},0,{"$f":"+J28*E$7","v":0}]
[null,"Machinery Labor"]
[null,null,"Tractors/Self-Propelled",0.82,null,"Hour",10,null,8.1999999999999993,{"$f":"E30*H30","v":0},0,null,0,{"$f":"J30*L30","v":0},8.1999999999999993,{"$f":"+J30-N30","v":0},5248,{"$f":"+J30*E$7","v":0}]
[null,null,"Other Labor",0.98,null,"Hour",10,null,9.8000000000000007,{"$f":"E31*H31","v":0},0,null,0,{"$f":"J31*L31","v":0},9.8000000000000007,{"$f":"+J31-N31","v":0},6272,{"$f":"+J31*E$7","v":0}]
[]
[null,"Diesel Fuel"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0,null,0,{"$f":"E34*H34","v":0},0,null,0,{"$f":"J34*L34","v":0},0,{"$f":"+J34-N34","v":0},0,{"$f":"+J34*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",5.59,null,"Gallon",2.1,null,11.739000000000001,{"$f":"E35*H35","v":0},0,null,0,{"$f":"J35*L35","v":0},11.739000000000001,{"$f":"+J35-N35","v":0},7512.9600000000009,{"$f":"+J35*E$7","v":0}]
[]
[null,"Gasoline"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",2.109375,null,2.109375,{"$f":"E38*H38","v":0},0,null,0,{"$f":"J38*L38","v":0},2.109375,{"$f":"+J38-N38","v":0},1350,{"$f":"+J38*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",0,null,"Gallon",2.25,null,0,{"$f":"E39*H39","v":0},0,null,0,{"$f":"J39*L39","v":0},0,{"$f":"+J39-N39","v":0},0,{"$f":"+J39*E$7","v":0}]
[]
[null,"Repairs & Maintenance"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0.56601562500000002,null,0.56601562500000002,{"$f":"E42*H42","v":0},0,null,0,{"$f":"J42*L42","v":0},0.56601562500000002,{"$f":"+J42-N42","v":0},362.25,{"$f":"+J42*E$7","v":0}]
[null,null,"Irrigation Equipment",1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,"Tractors/Self-Propelled",1,null,"Acre",10.896365765616526,null,10.896365765616526,0,0,null,0,0,10.896365765616526,0,6973.6740899945762,0]
[null,null,"Implements",1,null,"Acre",13.35616874808882,null,13.35616874808882,0,0,null,0,0,13.35616874808882,0,8547.9479987768445,0]
[null,null,null,null,null,null,null,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0,null,0,0,0,0,0,0]
[null,"Interest on Credit Line",null,null,null,null,5.7500000000000002E-2,null,1.9921217974995009,{"$f":"+SUM(J17:J47)/2*H48","v":0},null,null,0,{"$f":"+SUM(N17:N47)/2*L48","v":0},1.9921217974995009,{"$f":"+SUM(P17:P47)/2*L48","v":0},1274.9579503996806,{"$f":"+J48*E$7","v":0}]
["Total Variable Costs",null,null,null,null,null,null,null,107.56404693620486,{"$f":"SUM(J18:J48)","v":0},null,null,0,{"$f":"SUM(N18:N48)","v":0},107.56404693620486,{"$f":"SUM(P18:P48)","v":0},68840.990039171098,{"$f":"SUM(R18:R48)","v":0}]
["Planned Returns Above Variable Costs:",null,null,null,null,null,null,null,19.375953063795137,{"$f":"+J13-J49","v":0},null,null,0,{"$f":"+N13-N49","v":0},19.375953063795137,{"$f":"+P13-P49","v":0},12400.609960828908,{"$f":"+R13-R49","v":0}]
[null,"Breakeven Price to Cover Variable Costs",null,null,null,null,4.8892748607365846,{"$f":"IF(E10=0,\"n/a\",(YVarExp-(YTotExp+YTotRet-J10))/E10)","v":"n/a"},"CWT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enterprise","Enterprise"]
["FIXED COSTS",null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Share","Share","Landlord","Landlord","Tenant","Tenant","Total","Total"]
[null,"Machinery Depreciation"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0.78581835937499989,null,0.78581835937499989,{"$f":"E55*H55","v":0},0,null,0,{"$f":"J55*L55","v":0},0.78581835937499989,{"$f":"+J55-N55","v":0},502.92374999999993,{"$f":"+J55*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",1,null,"Acre",11.259577957803746,null,11.259577957803746,0,0,null,0,{"$f":"J56*L56","v":0},11.259577957803746,0,7206.1298929943969,0]
[null,null,"Implements",1,null,"Acre",16.94492461924262,null,16.94492461924262,0,0,null,0,{"$f":"J57*L57","v":0},16.94492461924262,0,10844.751756315276,0]
[null,"Equipment Investment"]
[null,null,"Pickup/General Use Equipment",5.5045019531249997,null,"Dollars",5.5E-2,null,0.30274760742187501,{"$f":"E59*H59","v":0},0,null,0,{"$f":"J59*L59","v":0},0.30274760742187501,{"$f":"+J59-N59","v":0},193.75846875000002,{"$f":"+J59*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",87.715744413213059,null,"Dollars",5.5E-2,null,4.8243659427267183,0,0,null,0,{"$f":"J60*L60","v":0},4.8243659427267183,0,3087.5942033450997,0]
[null,null,"Implements",72.486621982315654,null,"Dollars",5.5E-2,null,3.9867642090273612,0,0,null,0,{"$f":"J61*L61","v":0},3.9867642090273612,0,2551.5290937775112,0]
[null,"Salaried Labor",null,1,null,"Acre",0,null,0,0,0,null,0,{"$f":"J62*L62","v":0},0,{"$f":"+J62-N62","v":0},0,{"$f":"+J62*E$7","v":0}]
[null,"Management Fee, Owner/Operator Labor",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,"Allocated Establishment Cost",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,"Cash Rent - Grain Sorghum",null,1,null,"Acre",32,null,32,0,0,null,0,0,32,0,20480,0]
[null,"Property Taxes",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,"Whole Farm Insurance",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,1,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,1,null,null,0,null,0,{"$f":"E69*H69","v":0},0,null,0,0,0,0,0,0]
["Total Fixed Costs",null,null,null,null,null,null,null,70.104198695597319,{"$f":"+SUM(J55:J69)","v":0},null,null,0,{"$f":"+SUM(N55:N69)","v":0},70.104198695597319,{"$f":"+SUM(P55:P69)","v":0},44866.68716518228,{"$f":"+SUM(R55:R69)","v":0}]
["Total Specified Costs",null,null,null,null,null,null,null,177.66824563180217,{"$f":"+J49+J70","v":0},null,null,0,{"$f":"+N49+N70","v":0},177.66824563180217,{"$f":"+P49+P70","v":0},113707.67720435339,{"$f":"+R49+R70","v":0}]
[]
["Returns Above Specified Costs",null,null,null,null,null,null,null,-50.728245631802167,{"$f":"+J13-J71","v":0},null,null,0,{"$f":"+N13-N71","v":0},-50.728245631802167,{"$f":"+P13-P71","v":0},-32466.07720435338,{"$f":"+R13-R71","v":0}]
[]
["    Breakeven Price to Cover Total Costs",null,null,null,null,null,8.0758293469000986,{"$f":"IF(E10=0,\"n/a\",(YTotExp-(YTotExp+YTotRet-J10))/E10)","v":"n/a"},"CWT"]
[]
[null,null,null,"Example Breakeven Prices"]
[null,"Example","Example","To Cover",null,null,"To Cover"]
[null,"Yield","Yield","Variable",null,null,"Total"]
[null,"Percent","CWT","Costs",null,null,"Costs"]
[null,0.75,16.5,6.5190331476487797,null,null,10.767772462533465]
[null,0.9,19.8,5.4325276230406496,null,null,8.9731437187778873]
[null,1,22,4.8892748607365846,null,null,8.0758293469000986]
[null,1.1000000000000001,24.200000000000003,4.4447953279423489,null,null,7.3416630426364522]
[null,1.25,27.5,3.9114198885892675,null,null,6.4606634775200789]
[]
[null,null,null,"Your Breakeven Prices"]
[null,"Your","Your",null,"To Cover",null,null,"To Cover"]
[null,"Yield","Yield",null,"Variable",null,null,"Total"]
[null,"Percent","CWT",null,"Costs",null,null,"Costs"]
[null,0.75,{"$f":"E10*YPER1","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER1))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER1))","v":0}]
[null,0.9,{"$f":"E10*YPER2","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER2))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER2))","v":0}]
[null,1,{"$f":"+E10","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER3))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER3))","v":0}]
[null,1.1000000000000001,{"$f":"E10*YPER4","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER4))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER4))","v":0}]
[null,1.25,{"$f":"E10*YPER5","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER5))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER5))","v":0}]
[]
["  Developed by Extension Economists, Texas A&M AgriLife Extension Service, budgets@tamu.edu.  "]
[]
["Information presented is prepared solely as a general guide and not intended to recognize or predict the costs and returns from any one operation.  Brand names are mentioned only as examples and imply no endorsement."]

{"sheet":"WheatDryland","index":10,"n_rows":107,"n_cols":18,"rows_kept":107,"cut":false,"hidden":false,"merged":[[84,3,84,8],[94,3,94,8],[106,0,106,11],[0,0,0,11],[1,0,1,11],[2,0,2,11],[3,0,3,11]]}
["Projections for Planning Purposes Only -- Not to be Used without Updating"]
["2018 Estimated Costs and Returns per Acre"]
["Dryland Wheat"]
["Enter your name for this budget in the cell above."]
["Enter  Your Values in the cells highlighed in MAROON."]
[null,null,null,null,"Your Acres",null,null,null,null,null,null,null,null,null,null,null,null,"Your"]
[null,null,"Crop Acres",640,null,null,null,null,null,null,null,"Your",null,null,null,null,"Enterprise","Enterprise"]
[null,null,null,null,"Your",null,null,"Your","Cash","Your","Landlord","Landlord",null,"Your",null,"Your","Total","Total"]
["REVENUE",null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Share","Share","Landlord","Landlord","Tenant","Tenant","(640 acres)",{"$f":"\"(\" & E7 & \" acres)\"","v":"( acres)"}]
[null,"Wheat",null,30,null,"Bushel",4.3,null,129,{"$f":"E10*H10","v":0},0,null,0,{"$f":"J10*L10","v":0},129,{"$f":"+J10-N10","v":0},82560,{"$f":"+J10*E$7","v":0}]
[null,"Wheat Pasture",null,64,null,"Pound of Gain",0.4,null,25.6,0,0,null,0,0,25.6,{"$f":"+J11-N11","v":0},16384,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
["Total Revenue",null,null,null,null,null,null,null,154.6,{"$f":"SUM(J10:J13)","v":0},null,null,0,{"$f":"SUM(N10:N13)","v":0},154.6,{"$f":"SUM(P10:P13)","v":0},98944,{"$f":"SUM(R10:R13)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enterprise","Enterprise"]
["VARIABLE COSTS",null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Share","Share","Landlord","Landlord","Tenant","Tenant","Total","Total"]
["Production Costs"]
[null,"Herbicide"]
[null,"","Herbicide - Wheat",6.4,null,"Ounce",0.22265625,null,1.425,{"$f":"E19*H19","v":0},0,null,0,{"$f":"J19*L19","v":0},1.425,{"$f":"+J19-N19","v":0},912,{"$f":"+J19*E$7","v":0}]
[null,"Seed"]
[null,"","Wheat Seed",70,null,"Pound",0.21,null,14.7,0,0,null,0,0,14.7,0,9408,0]
[null,"Fertilizer"]
[null,"","Fertilizer (N)",100,null,"Pound",0.41,null,41,0,0,null,0,0,41,0,26240,0]
[null,"","Fertilizer (P)",50,null,"Pound",0.34,null,17,0,0,null,0,0,17,0,10880,0]
[null,"Custom"]
[null,"","Herbicide Application",1,null,"Acre",5.5,null,5.5,0,0,null,0,0,5.5,0,3520,0]
[null,"","Custom Harvest Wheat",1,null,"Acre",24,null,24,0,0,null,0,0,24,0,15360,0]
[null,"","Overage - Wheat",10,null,"Bushel",0.24,null,2.4,0,0,null,0,0,2.4,0,1536,0]
[null,"","Custom Haul Wheat",30,null,"Bushel",0.24,null,7.1999999999999993,0,0,null,0,0,7.1999999999999993,0,4608,0]
[null,"Miscellaneous"]
[null,"","Insurance - Wheat",1,null,"Acre",12,null,12,0,0,null,0,0,12,0,7680,0]
[null,"Insecticide"]
[null,"","Insecticide & Application - Wheat",1,null,"Ounce",0.25,null,0.25,0,0,null,0,0,0.25,0,160,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,0,null,null,0,null,0,{"$f":"E36*H36","v":0},0,null,0,{"$f":"J36*L36","v":0},0,{"$f":"+J36-N36","v":0},0,{"$f":"+J36*E$7","v":0}]
[null,"Machinery Labor"]
[null,null,"Tractors/Self-Propelled",0.47,null,"Hour",10,null,4.6999999999999993,{"$f":"E38*H38","v":0},0,null,0,{"$f":"J38*L38","v":0},4.6999999999999993,{"$f":"+J38-N38","v":0},3007.9999999999995,{"$f":"+J38*E$7","v":0}]
[null,null,"Other Labor",0.5,null,"Hour",10,null,5,{"$f":"E39*H39","v":0},0,null,0,{"$f":"J39*L39","v":0},5,{"$f":"+J39-N39","v":0},3200,{"$f":"+J39*E$7","v":0}]
[]
[null,"Diesel Fuel"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0,null,0,{"$f":"E42*H42","v":0},0,null,0,{"$f":"J42*L42","v":0},0,{"$f":"+J42-N42","v":0},0,{"$f":"+J42*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",1.96,null,"Gallon",2.1,null,4.1159999999999997,{"$f":"E43*H43","v":0},0,null,0,{"$f":"J43*L43","v":0},4.1159999999999997,{"$f":"+J43-N43","v":0},2634.24,{"$f":"+J43*E$7","v":0}]
[]
[null,"Gasoline"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",2.109375,null,2.109375,{"$f":"E46*H46","v":0},0,null,0,{"$f":"J46*L46","v":0},2.109375,{"$f":"+J46-N46","v":0},1350,{"$f":"+J46*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",0,null,"Gallon",2.25,null,0,{"$f":"E47*H47","v":0},0,null,0,{"$f":"J47*L47","v":0},0,{"$f":"+J47-N47","v":0},0,{"$f":"+J47*E$7","v":0}]
[]
[null,"Repairs & Maintenance"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0.56601562500000002,null,0.56601562500000002,{"$f":"E50*H50","v":0},0,null,0,{"$f":"J50*L50","v":0},0.56601562500000002,{"$f":"+J50-N50","v":0},362.25,{"$f":"+J50*E$7","v":0}]
[null,null,"Irrigation Equipment",1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,"Tractors/Self-Propelled",1,null,"Acre",3.0707500660544724,null,3.0707500660544724,0,0,null,0,0,3.0707500660544724,0,1965.2800422748624,0]
[null,null,"Implements",1,null,"Acre",6.9518268619230197,null,6.9518268619230197,0,0,null,0,0,6.9518268619230197,0,4449.1691916307327,0]
[null,null,null,null,null,null,null,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0,null,0,0,0,0,0,0]
[null,"Interest on Credit Line",null,null,null,null,5.7500000000000002E-2,null,4.3616591982689084,{"$f":"+SUM(J18:J55)/2*H56","v":0},null,null,0,{"$f":"+SUM(N18:N55)/2*L56","v":0},4.3616591982689084,{"$f":"+SUM(P18:P55)/2*L56","v":0},2791.4618868921016,{"$f":"+J56*E$7","v":0}]
["Total Variable Costs",null,null,null,null,null,null,null,156.35062675124641,{"$f":"SUM(J19:J56)","v":0},null,null,0,{"$f":"SUM(N19:N56)","v":0},156.35062675124641,{"$f":"SUM(P19:P56)","v":0},100064.4011207977,{"$f":"SUM(R19:R56)","v":0}]
["Planned Returns Above Variable Costs:",null,null,null,null,null,null,null,-1.7506267512464149,{"$f":"+J14-J57","v":0},null,null,0,{"$f":"+N14-N57","v":0},-1.7506267512464149,{"$f":"+P14-P57","v":0},-1120.4011207977019,{"$f":"+R14-R57","v":0}]
[null,"Breakeven Price to Cover Variable Costs",null,null,null,null,4.3583542250415475,{"$f":"IF(E10=0,\"n/a\",(YVarExp-(YTotExp+YTotRet-J10))/E10)","v":"n/a"},"Bushel"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enterprise","Enterprise"]
["FIXED COSTS",null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Share","Share","Landlord","Landlord","Tenant","Tenant","Total","Total"]
[null,"Machinery Depreciation"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0.78581835937499989,null,0.78581835937499989,{"$f":"E63*H63","v":0},0,null,0,{"$f":"J63*L63","v":0},0.78581835937499989,{"$f":"+J63-N63","v":0},502.92374999999993,{"$f":"+J63*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",1,null,"Acre",2.8651415477451643,null,2.8651415477451643,0,0,null,0,{"$f":"J64*L64","v":0},2.8651415477451643,0,1833.6905905569051,0]
[null,null,"Implements",1,null,"Acre",8.938063108186741,null,8.938063108186741,0,0,null,0,{"$f":"J65*L65","v":0},8.938063108186741,0,5720.360389239514,0]
[null,"Equipment Investment"]
[null,null,"Pickup/General Use Equipment",5.5045019531249997,null,"Dollars",5.5E-2,null,0.30274760742187501,{"$f":"E67*H67","v":0},0,null,0,{"$f":"J67*L67","v":0},0.30274760742187501,{"$f":"+J67-N67","v":0},193.75846875000002,{"$f":"+J67*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",22.320376896143777,null,"Dollars",5.5E-2,null,1.2276207292879078,0,0,null,0,{"$f":"J68*L68","v":0},1.2276207292879078,0,785.67726674426103,0]
[null,null,"Implements",38.235047740576618,null,"Dollars",5.5E-2,null,2.1029276257317142,0,0,null,0,{"$f":"J69*L69","v":0},2.1029276257317142,0,1345.8736804682972,0]
[null,"Salaried Labor",null,1,null,"Acre",0,null,0,0,0,null,0,{"$f":"J70*L70","v":0},0,{"$f":"+J70-N70","v":0},0,{"$f":"+J70*E$7","v":0}]
[null,"Management Fee, Owner/Operator Labor",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,"Allocated Establishment Cost",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,"Cash Rent - Wheat",null,1,null,"Acre",32,null,32,0,0,null,0,0,32,0,20480,0]
[null,"Property Taxes",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,"Whole Farm Insurance",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,1,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,1,null,null,0,null,0,{"$f":"E77*H77","v":0},0,null,0,0,0,0,0,0]
["Total Fixed Costs",null,null,null,null,null,null,null,48.222318977748401,{"$f":"+SUM(J63:J77)","v":0},null,null,0,{"$f":"+SUM(N63:N77)","v":0},48.222318977748401,{"$f":"+SUM(P63:P77)","v":0},30862.284145758975,{"$f":"+SUM(R63:R77)","v":0}]
["Total Specified Costs",null,null,null,null,null,null,null,204.5729457289948,{"$f":"+J57+J78","v":0},null,null,0,{"$f":"+N57+N78","v":0},204.5729457289948,{"$f":"+P57+P78","v":0},130926.68526655668,{"$f":"+R57+R78","v":0}]
[]
["Returns Above Specified Costs",null,null,null,null,null,null,null,-49.972945728994802,{"$f":"+J14-J79","v":0},null,null,0,{"$f":"+N14-N79","v":0},-49.972945728994802,{"$f":"+P14-P79","v":0},-31982.685266556684,{"$f":"+R14-R79","v":0}]
[]
["    Breakeven Price to Cover Total Costs",null,null,null,null,null,5.9657648576331601,{"$f":"IF(E10=0,\"n/a\",(YTotExp-(YTotExp+YTotRet-J10))/E10)","v":"n/a"},"Bushel"]
[]
[null,null,null,"Example Breakeven Prices"]
[null,"Example","Example","To Cover",null,null,"To Cover"]
[null,"Yield","Yield","Variable",null,null,"Total"]
[null,"Percent","Bushel","Costs",null,null,"Costs"]
[null,0.75,22.5,5.811138966722063,null,null,7.9543531435108799]
[null,0.9,27,4.842615805601719,null,null,6.6286276195924003]
[null,1,30,4.3583542250415475,null,null,5.9657648576331601]
[null,1.1000000000000001,33,3.9621402045832248,null,null,5.4234225978483277]
[null,1.25,37.5,3.4866833800332375,null,null,4.7726118861065281]
[]
[null,null,null,"Your Breakeven Prices"]
[null,"Your","Your",null,"To Cover",null,null,"To Cover"]
[null,"Yield","Yield",null,"Variable",null,null,"Total"]
[null,"Percent","Bushel",null,"Costs",null,null,"Costs"]
[null,0.75,{"$f":"E10*YPER1","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER1))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER1))","v":0}]
[null,0.9,{"$f":"E10*YPER2","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER2))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER2))","v":0}]
[null,1,{"$f":"+E10","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER3))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER3))","v":0}]
[null,1.1000000000000001,{"$f":"E10*YPER4","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER4))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER4))","v":0}]
[null,1.25,{"$f":"E10*YPER5","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER5))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER5))","v":0}]
[]
["  Developed by Extension Economists, Texas A&M AgriLife Extension Service, budgets@tamu.edu.  "]
[]
["Information presented is prepared solely as a general guide and not intended to recognize or predict the costs and returns from any one operation.  Brand names are mentioned only as examples and imply no endorsement."]

{"sheet":"SmallGrain","index":11,"n_rows":92,"n_cols":18,"rows_kept":92,"cut":false,"hidden":false,"merged":[[79,3,79,8],[69,3,69,8],[91,0,91,11],[0,0,0,11],[1,0,1,11],[2,0,2,11],[3,0,3,11]]}
["Projections for Planning Purposes Only -- Not to be Used without Updating"]
["2018 Estimated Costs and Returns per Acre"]
["Small Grain Grazing"]
["Enter your name for this budget in the cell above."]
["Enter  Your Values in the cells highlighed in MAROON."]
[null,null,null,null,"Your Acres",null,null,null,null,null,null,null,null,null,null,null,null,"Your"]
[null,null,"Crop Acres",640,null,null,null,null,null,null,null,"Your",null,null,null,null,"Enterprise","Enterprise"]
[null,null,null,null,"Your",null,null,"Your","Cash","Your","Landlord","Landlord",null,"Your",null,"Your","Total","Total"]
["REVENUE",null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Share","Share","Landlord","Landlord","Tenant","Tenant","(640 acres)",{"$f":"\"(\" & E7 & \" acres)\"","v":"( acres)"}]
[null,0,null,0,null,"",0,null,0,{"$f":"E10*H10","v":0},0,null,0,{"$f":"J10*L10","v":0},0,{"$f":"+J10-N10","v":0},0,{"$f":"+J10*E$7","v":0}]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,{"$f":"+J11-N11","v":0},0,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
["Total Revenue",null,null,null,null,null,null,null,0,{"$f":"SUM(J10:J12)","v":0},null,null,0,{"$f":"SUM(N10:N12)","v":0},0,{"$f":"SUM(P10:P12)","v":0},0,{"$f":"SUM(R10:R12)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enterprise","Enterprise"]
["VARIABLE COSTS",null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Share","Share","Landlord","Landlord","Tenant","Tenant","Total","Total"]
["Production Costs"]
[null,"Fertilizer"]
[null,"","Fertilizer (N) - Small Grain",50,null,"Pound",0.41,null,20.5,{"$f":"E18*H18","v":0},0,null,0,{"$f":"J18*L18","v":0},20.5,{"$f":"+J18-N18","v":0},13120,{"$f":"+J18*E$7","v":0}]
[null,"Seed"]
[null,"","Small Grain Seed",80,null,"Pound",0.21,null,16.8,0,0,null,0,0,16.8,0,10752,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,0,null,null,0,null,0,{"$f":"E23*H23","v":0},0,null,0,{"$f":"J23*L23","v":0},0,{"$f":"+J23-N23","v":0},0,{"$f":"+J23*E$7","v":0}]
[null,"Machinery Labor"]
[null,null,"Tractors/Self-Propelled",0.62,null,"Hour",10,null,6.2,{"$f":"E25*H25","v":0},0,null,0,{"$f":"J25*L25","v":0},6.2,{"$f":"+J25-N25","v":0},3968,{"$f":"+J25*E$7","v":0}]
[null,null,"Other Labor",0.68,null,"Hour",10,null,6.8000000000000007,{"$f":"E26*H26","v":0},0,null,0,{"$f":"J26*L26","v":0},6.8000000000000007,{"$f":"+J26-N26","v":0},4352,{"$f":"+J26*E$7","v":0}]
[]
[null,"Diesel Fuel"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0,null,0,{"$f":"E29*H29","v":0},0,null,0,{"$f":"J29*L29","v":0},0,{"$f":"+J29-N29","v":0},0,{"$f":"+J29*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",4.25,null,"Gallon",2.1,null,8.9250000000000007,{"$f":"E30*H30","v":0},0,null,0,{"$f":"J30*L30","v":0},8.9250000000000007,{"$f":"+J30-N30","v":0},5712,{"$f":"+J30*E$7","v":0}]
[]
[null,"Gasoline"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0,null,0,{"$f":"E33*H33","v":0},0,null,0,{"$f":"J33*L33","v":0},0,{"$f":"+J33-N33","v":0},0,{"$f":"+J33*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",0,null,"Gallon",2.25,null,0,{"$f":"E34*H34","v":0},0,null,0,{"$f":"J34*L34","v":0},0,{"$f":"+J34-N34","v":0},0,{"$f":"+J34*E$7","v":0}]
[]
[null,"Repairs & Maintenance"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0,null,0,{"$f":"E37*H37","v":0},0,null,0,{"$f":"J37*L37","v":0},0,{"$f":"+J37-N37","v":0},0,{"$f":"+J37*E$7","v":0}]
[null,null,"Irrigation Equipment",1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,"Tractors/Self-Propelled",1,null,"Acre",8.2961571855272762,null,8.2961571855272762,0,0,null,0,0,8.2961571855272762,0,5309.540598737457,0]
[null,null,"Implements",1,null,"Acre",11.232010033295463,null,11.232010033295463,0,0,null,0,0,11.232010033295463,0,7188.4864213090968,0]
[null,null,null,null,null,null,null,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0,null,0,0,0,0,0,0]
[null,"Interest on Credit Line",null,null,null,null,5.7500000000000002E-2,null,0.92422473039746289,{"$f":"+SUM(J17:J42)/2*H43","v":0},null,null,0,{"$f":"+SUM(N17:N42)/2*L43","v":0},0.92422473039746289,{"$f":"+SUM(P17:P42)/2*L43","v":0},591.50382745437628,{"$f":"+J43*E$7","v":0}]
["Total Variable Costs",null,null,null,null,null,null,null,79.677391949220208,{"$f":"SUM(J18:J43)","v":0},null,null,0,{"$f":"SUM(N18:N43)","v":0},79.677391949220208,{"$f":"SUM(P18:P43)","v":0},50993.53084750093,{"$f":"SUM(R18:R43)","v":0}]
["Planned Returns Above Variable Costs:",null,null,null,null,null,null,null,-79.677391949220208,{"$f":"+J13-J44","v":0},null,null,0,{"$f":"+N13-N44","v":0},-79.677391949220208,{"$f":"+P13-P44","v":0},-50993.53084750093,{"$f":"+R13-R44","v":0}]
[null,"Breakeven Price to Cover Variable Costs",null,null,null,null,"n/a",{"$f":"IF(E10=0,\"n/a\",(YVarExp-(YTotExp+YTotRet-J10))/E10)","v":"n/a"},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enterprise","Enterprise"]
["FIXED COSTS",null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Share","Share","Landlord","Landlord","Tenant","Tenant","Total","Total"]
[null,"Machinery Depreciation"]
[null,null,"Tractors/Self-Propelled",1,null,"Acre",8.5726957583781864,null,8.5726957583781864,{"$f":"E50*H50","v":0},0,null,0,{"$f":"J50*L50","v":0},8.5726957583781864,{"$f":"+J50-N50","v":0},5486.5252853620395,{"$f":"+J50*E$7","v":0}]
[null,null,"Implements",1,null,"Acre",13.560896281875509,null,13.560896281875509,0,0,null,0,{"$f":"J51*L51","v":0},13.560896281875509,0,8678.9736204003257,0]
[null,"Equipment Investment"]
[null,null,"Tractors/Self-Propelled",66.784065343494575,null,"Dollars",5.5E-2,null,3.6731235938922016,{"$f":"E53*H53","v":0},0,null,0,{"$f":"J53*L53","v":0},3.6731235938922016,{"$f":"+J53-N53","v":0},2350.7991000910088,{"$f":"+J53*E$7","v":0}]
[null,null,"Implements",58.01050076135634,null,"Dollars",5.5E-2,null,3.1905775418745987,0,0,null,0,{"$f":"J54*L54","v":0},3.1905775418745987,0,2041.9696267997433,0]
[null,"Salaried Labor",null,1,null,"Acre",0,null,0,0,0,null,0,{"$f":"J55*L55","v":0},0,{"$f":"+J55-N55","v":0},0,{"$f":"+J55*E$7","v":0}]
[null,"Management Fee, Owner/Operator Labor",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,"Allocated Establishment Cost",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,"Cash Rent - Small Grains",null,1,null,"Acre",32,null,32,0,0,null,0,0,32,0,20480,0]
[null,"Property Taxes",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,"Whole Farm Insurance",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,1,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,1,null,null,0,null,0,{"$f":"E62*H62","v":0},0,null,0,0,0,0,0,0]
["Total Fixed Costs",null,null,null,null,null,null,null,60.997293176020492,{"$f":"+SUM(J50:J62)","v":0},null,null,0,{"$f":"+SUM(N50:N62)","v":0},60.997293176020492,{"$f":"+SUM(P50:P62)","v":0},39038.267632653115,{"$f":"+SUM(R50:R62)","v":0}]
["Total Specified Costs",null,null,null,null,null,null,null,140.6746851252407,{"$f":"+J44+J63","v":0},null,null,0,{"$f":"+N44+N63","v":0},140.6746851252407,{"$f":"+P44+P63","v":0},90031.798480154044,{"$f":"+R44+R63","v":0}]
[]
["Returns Above Specified Costs",null,null,null,null,null,null,null,-140.6746851252407,{"$f":"+J13-J64","v":0},null,null,0,{"$f":"+N13-N64","v":0},-140.6746851252407,{"$f":"+P13-P64","v":0},-90031.798480154044,{"$f":"+R13-R64","v":0}]
[]
["    Breakeven Price to Cover Total Costs",null,null,null,null,null,"n/a",{"$f":"IF(E10=0,\"n/a\",(YTotExp-(YTotExp+YTotRet-J10))/E10)","v":"n/a"},""]
[]
[null,null,null,"Example Breakeven Prices"]
[null,"Example","Example","To Cover",null,null,"To Cover"]
[null,"Yield","Yield","Variable",null,null,"Total"]
[null,"Percent","","Costs",null,null,"Costs"]
[null,0.75,0,0,null,null,0]
[null,0.9,0,0,null,null,0]
[null,1,0,0,null,null,0]
[null,1.1000000000000001,0,0,null,null,0]
[null,1.25,0,0,null,null,0]
[]
[null,null,null,"Your Breakeven Prices"]
[null,"Your","Your",null,"To Cover",null,null,"To Cover"]
[null,"Yield","Yield",null,"Variable",null,null,"Total"]
[null,"Percent","",null,"Costs",null,null,"Costs"]
[null,0.75,{"$f":"E10*YPER1","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER1))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER1))","v":0}]
[null,0.9,{"$f":"E10*YPER2","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER2))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER2))","v":0}]
[null,1,{"$f":"+E10","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER3))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER3))","v":0}]
[null,1.1000000000000001,{"$f":"E10*YPER4","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER4))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER4))","v":0}]
[null,1.25,{"$f":"E10*YPER5","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER5))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER5))","v":0}]
[]
["  Developed by Extension Economists, Texas A&M AgriLife Extension Service, budgets@tamu.edu.  "]
[]
["Information presented is prepared solely as a general guide and not intended to recognize or predict the costs and returns from any one operation.  Brand names are mentioned only as examples and imply no endorsement."]

{"sheet":"CanolaDryland","index":12,"n_rows":104,"n_cols":18,"rows_kept":104,"cut":false,"hidden":false,"merged":[[81,3,81,8],[91,3,91,8],[103,0,103,11],[0,0,0,11],[1,0,1,11],[2,0,2,11],[3,0,3,11]]}
["Projections for Planning Purposes Only -- Not to be Used without Updating"]
["2018 Estimated Costs and Returns per Acre"]
["Dryland Canola"]
["Enter your name for this budget in the cell above."]
["Enter  Your Values in the cells highlighed in MAROON."]
[null,null,null,null,"Your Acres",null,null,null,null,null,null,null,null,null,null,null,null,"Your"]
[null,null,"Crop Acres",640,null,null,null,null,null,null,null,"Your",null,null,null,null,"Enterprise","Enterprise"]
[null,null,null,null,"Your",null,null,"Your","Cash","Your","Landlord","Landlord",null,"Your",null,"Your","Total","Total"]
["REVENUE",null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Share","Share","Landlord","Landlord","Tenant","Tenant","(640 acres)",{"$f":"\"(\" & E7 & \" acres)\"","v":"( acres)"}]
[null,"Canola",null,1000,null,"Pound",0.16,null,160,{"$f":"E10*H10","v":0},0,null,0,{"$f":"J10*L10","v":0},160,{"$f":"+J10-N10","v":0},102400,{"$f":"+J10*E$7","v":0}]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,{"$f":"+J11-N11","v":0},0,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
["Total Revenue",null,null,null,null,null,null,null,160,{"$f":"SUM(J10:J12)","v":0},null,null,0,{"$f":"SUM(N10:N12)","v":0},160,{"$f":"SUM(P10:P12)","v":0},102400,{"$f":"SUM(R10:R12)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enterprise","Enterprise"]
["VARIABLE COSTS",null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Share","Share","Landlord","Landlord","Tenant","Tenant","Total","Total"]
["Production Costs"]
[null,"Herbicide"]
[null,"","Roundup",3,null,"Pint",2.1875,null,6.5625,{"$f":"E18*H18","v":0},0,null,0,{"$f":"J18*L18","v":0},6.5625,{"$f":"+J18-N18","v":0},4200,{"$f":"+J18*E$7","v":0}]
[null,"Seed"]
[null,"","Canola Seed",5,null,"Pound",5.4,null,27,0,0,null,0,0,27,0,17280,0]
[null,"Fertilizer"]
[null,"","Fertilizer (N)",50,null,"Pound",0.41,null,20.5,0,0,null,0,0,20.5,0,13120,0]
[null,"","Fertilizer (P)",25,null,"Pound",0.34,null,8.5,0,0,null,0,0,8.5,0,5440,0]
[null,"Custom"]
[null,"","Insecticide Application",1,null,"Acre",5.5,null,5.5,0,0,null,0,0,5.5,0,3520,0]
[null,"","Swath",1,null,"Acre",12,null,12,0,0,null,0,0,12,0,7680,0]
[null,"","Combine",1,null,"Acre",24,null,24,0,0,null,0,0,24,0,15360,0]
[null,"","Hauling - Canola",1,null,"Acre",3.5,null,3.5,0,0,null,0,0,3.5,0,2240,0]
[null,"Miscellaneous"]
[null,"","Insurance - Canola",1,null,"Acre",14,null,14,0,0,null,0,0,14,0,8960,0]
[null,"Insecticide"]
[null,"","Insecticide - Canola",14,null,"Ounce",1.171875,null,16.40625,0,0,null,0,0,16.40625,0,10500,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,0,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,0,null,null,0,null,0,{"$f":"E35*H35","v":0},0,null,0,{"$f":"J35*L35","v":0},0,{"$f":"+J35-N35","v":0},0,{"$f":"+J35*E$7","v":0}]
[null,"Machinery Labor"]
[null,null,"Tractors/Self-Propelled",0.35,null,"Hour",10,null,3.5,{"$f":"E37*H37","v":0},0,null,0,{"$f":"J37*L37","v":0},3.5,{"$f":"+J37-N37","v":0},2240,{"$f":"+J37*E$7","v":0}]
[null,null,"Other Labor",0.42,null,"Hour",10,null,4.2,{"$f":"E38*H38","v":0},0,null,0,{"$f":"J38*L38","v":0},4.2,{"$f":"+J38-N38","v":0},2688,{"$f":"+J38*E$7","v":0}]
[]
[null,"Diesel Fuel"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0,null,0,{"$f":"E41*H41","v":0},0,null,0,{"$f":"J41*L41","v":0},0,{"$f":"+J41-N41","v":0},0,{"$f":"+J41*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",1.76,null,"Gallon",2.1,null,3.6960000000000002,{"$f":"E42*H42","v":0},0,null,0,{"$f":"J42*L42","v":0},3.6960000000000002,{"$f":"+J42-N42","v":0},2365.44,{"$f":"+J42*E$7","v":0}]
[]
[null,"Gasoline"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0,null,0,{"$f":"E45*H45","v":0},0,null,0,{"$f":"J45*L45","v":0},0,{"$f":"+J45-N45","v":0},0,{"$f":"+J45*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",0,null,"Gallon",2.25,null,0,{"$f":"E46*H46","v":0},0,null,0,{"$f":"J46*L46","v":0},0,{"$f":"+J46-N46","v":0},0,{"$f":"+J46*E$7","v":0}]
[]
[null,"Repairs & Maintenance"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0,null,0,{"$f":"E49*H49","v":0},0,null,0,{"$f":"J49*L49","v":0},0,{"$f":"+J49-N49","v":0},0,{"$f":"+J49*E$7","v":0}]
[null,null,"Irrigation Equipment",1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,"Tractors/Self-Propelled",1,null,"Acre",2.8048629651040962,null,2.8048629651040962,0,0,null,0,0,2.8048629651040962,0,1795.1122976666215,0]
[null,null,"Implements",1,null,"Acre",19.425805640951044,null,19.425805640951044,0,0,null,0,0,19.425805640951044,0,12432.515610208668,0]
[null,null,null,null,null,null,null,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0,null,0,0,0,0,0,0]
[null,"Interest on Credit Line",null,null,null,null,5.7500000000000002E-2,null,3.2711993403839408,{"$f":"+SUM(J17:J54)/2*H55","v":0},null,null,0,{"$f":"+SUM(N17:N54)/2*L55","v":0},3.2711993403839408,{"$f":"+SUM(P17:P54)/2*L55","v":0},2093.5675778457221,{"$f":"+J55*E$7","v":0}]
["Total Variable Costs",null,null,null,null,null,null,null,174.86661794643905,{"$f":"SUM(J18:J55)","v":0},null,null,0,{"$f":"SUM(N18:N55)","v":0},174.86661794643905,{"$f":"SUM(P18:P55)","v":0},111914.63548572101,{"$f":"SUM(R18:R55)","v":0}]
["Planned Returns Above Variable Costs:",null,null,null,null,null,null,null,-14.86661794643905,{"$f":"+J13-J56","v":0},null,null,0,{"$f":"+N13-N56","v":0},-14.86661794643905,{"$f":"+P13-P56","v":0},-9514.6354857210099,{"$f":"+R13-R56","v":0}]
[null,"Breakeven Price to Cover Variable Costs",null,null,null,null,0.17486661794643904,{"$f":"IF(E10=0,\"n/a\",(YVarExp-(YTotExp+YTotRet-J10))/E10)","v":"n/a"},"Pound"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enterprise","Enterprise"]
["FIXED COSTS",null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Share","Share","Landlord","Landlord","Tenant","Tenant","Total","Total"]
[null,"Machinery Depreciation"]
[null,null,"Tractors/Self-Propelled",1,null,"Acre",2.6743060206477103,null,2.6743060206477103,{"$f":"E62*H62","v":0},0,null,0,{"$f":"J62*L62","v":0},2.6743060206477103,{"$f":"+J62-N62","v":0},1711.5558532145346,{"$f":"+J62*E$7","v":0}]
[null,null,"Implements",1,null,"Acre",17.944920022708491,null,17.944920022708491,0,0,null,0,{"$f":"J63*L63","v":0},17.944920022708491,0,11484.748814533434,0]
[null,"Equipment Investment"]
[null,null,"Tractors/Self-Propelled",20.83370658020716,null,"Dollars",5.5E-2,null,1.1458538619113938,{"$f":"E65*H65","v":0},0,null,0,{"$f":"J65*L65","v":0},1.1458538619113938,{"$f":"+J65-N65","v":0},733.34647162329202,{"$f":"+J65*E$7","v":0}]
[null,null,"Implements",76.764380097141881,null,"Dollars",5.5E-2,null,4.2220409053428032,0,0,null,0,{"$f":"J66*L66","v":0},4.2220409053428032,0,2702.1061794193938,0]
[null,"Salaried Labor",null,1,null,"Acre",0,null,0,0,0,null,0,{"$f":"J67*L67","v":0},0,{"$f":"+J67-N67","v":0},0,{"$f":"+J67*E$7","v":0}]
[null,"Management Fee, Owner/Operator Labor",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,"Allocated Establishment Cost",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,"Cash Rent - Canola",null,1,null,"Acre",32,null,32,0,0,null,0,0,32,0,20480,0]
[null,"Property Taxes",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,"Whole Farm Insurance",null,1,null,"Acre",0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,1,null,null,0,null,0,0,0,null,0,0,0,0,0,0]
[null,null,null,1,null,null,0,null,0,{"$f":"E74*H74","v":0},0,null,0,0,0,0,0,0]
["Total Fixed Costs",null,null,null,null,null,null,null,57.987120810610399,{"$f":"+SUM(J62:J74)","v":0},null,null,0,{"$f":"+SUM(N62:N74)","v":0},57.987120810610399,{"$f":"+SUM(P62:P74)","v":0},37111.757318790653,{"$f":"+SUM(R62:R74)","v":0}]
["Total Specified Costs",null,null,null,null,null,null,null,232.85373875704946,{"$f":"+J56+J75","v":0},null,null,0,{"$f":"+N56+N75","v":0},232.85373875704946,{"$f":"+P56+P75","v":0},149026.39280451165,{"$f":"+R56+R75","v":0}]
[]
["Returns Above Specified Costs",null,null,null,null,null,null,null,-72.853738757049456,{"$f":"+J13-J76","v":0},null,null,0,{"$f":"+N13-N76","v":0},-72.853738757049456,{"$f":"+P13-P76","v":0},-46626.392804511648,{"$f":"+R13-R76","v":0}]
[]
["    Breakeven Price to Cover Total Costs",null,null,null,null,null,0.23285373875704946,{"$f":"IF(E10=0,\"n/a\",(YTotExp-(YTotExp+YTotRet-J10))/E10)","v":"n/a"},"Pound"]
[]
[null,null,null,"Example Breakeven Prices"]
[null,"Example","Example","To Cover",null,null,"To Cover"]
[null,"Yield","Yield","Variable",null,null,"Total"]
[null,"Percent","Pound","Costs",null,null,"Costs"]
[null,0.75,750,0.23315549059525206,null,null,0.31047165167606594]
[null,0.9,900,0.19429624216271005,null,null,0.25872637639672164]
[null,1,1000,0.17486661794643904,null,null,0.23285373875704946]
[null,1.1000000000000001,1100,0.15896965267858096,null,null,0.21168521705186313]
[null,1.25,1250,0.13989329435715123,null,null,0.18628299100563955]
[]
[null,null,null,"Your Breakeven Prices"]
[null,"Your","Your",null,"To Cover",null,null,"To Cover"]
[null,"Yield","Yield",null,"Variable",null,null,"Total"]
[null,"Percent","Pound",null,"Costs",null,null,"Costs"]
[null,0.75,{"$f":"E10*YPER1","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER1))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER1))","v":0}]
[null,0.9,{"$f":"E10*YPER2","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER2))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER2))","v":0}]
[null,1,{"$f":"+E10","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER3))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER3))","v":0}]
[null,1.1000000000000001,{"$f":"E10*YPER4","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER4))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER4))","v":0}]
[null,1.25,{"$f":"E10*YPER5","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER5))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER5))","v":0}]
[]
["  Developed by Extension Economists, Texas A&M AgriLife Extension Service, budgets@tamu.edu.  "]
[]
["Information presented is prepared solely as a general guide and not intended to recognize or predict the costs and returns from any one operation.  Brand names are mentioned only as examples and imply no endorsement."]

{"sheet":"CowCalf","index":13,"n_rows":92,"n_cols":14,"rows_kept":92,"cut":false,"hidden":false,"merged":[[66,7,66,8],[66,10,66,12],[0,0,0,13],[1,0,1,13],[2,0,2,13],[3,0,3,13],[65,2,65,12],[78,7,78,8],[78,10,78,12],[67,7,67,8],[67,10,67,12],[68,7,68,8],[68,10,68,12],[69,7,69,8],[69,10,69,12],[70,7,70,8],[70,10,70,12],[71,7,71,8],[71,10,71,12],[77,2,77,12],[79,7,79,8],[79,10,79,12],[80,7,80,8],[80,10,80,12],[81,7,81,8],[81,10,81,12],[82,7,82,8],[82,10,82,12],[83,7,83,8],[83,10,83,12],[91,0,91,13]]}
["Projections for Planning Purposes Only -- Not to be Used without Updating"]
["2018 Estimated Costs and Returns per Animal Unit"]
["Rolling Plains Cow-Calf Production"]
["Enter your name for this budget in the cell above."]
["Enter  Your Values in the cells highlighed in MAROON."]
[null,null,null,null,"Your Cows"]
[null,"Animal Units (AU)",null,400,null,"Animal Unit",null,null,null,null,null,null,null,"Your"]
[null,"Breeding Females",null,400,null,"Calf","Your",null,null,null,null,null,"Enterprise","Enterprise"]
[null,null,null,null,"Your","Quantity","Quantity",null,null,"Your",null,"Your","Total","Total"]
["REVENUE",null,null,"Head","Head","Per Head","Per Head","Units","$/Unit","$/Unit","Total","Total",{"$f":"\"(\" & D7 & \" AUs)\"","v":"(400 AUs)"},{"$f":"\"(\" & E7 & \" AUs)\"","v":"( AUs)"}]
[null,"Steer",null,0.41499999999999998,null,5.56,null,"CWT",140,null,323.036,{"$f":"+E11*G11*J11","v":0},129214.39999999999,{"$f":"+L11*E$7","v":0}]
[null,"Heifer",null,0.215,null,5.14,null,"CWT",126,null,139.24260000000001,{"$f":"+E12*G12*J12","v":0},55697.04,{"$f":"+L12*E$7","v":0}]
[null,"Cull Cow",null,0.15,null,10.25,null,"CWT",45,null,69.1875,0,27675,0]
[null,"Cull Bull",null,9.0000000000000011E-3,null,16.5,null,"CWT",65,null,9.6525000000000016,0,3861.0000000000005,0]
[null,null,null,0,null,0,null,null,0,null,0,0,0,0]
[null,null,null,0,null,0,null,null,0,null,0,0,0,0]
["Total Revenue",null,null,null,null,341.24999999999994,null,null,null,null,541.11860000000001,{"$f":"+SUM(L11:L16)","v":0},216447.44,{"$f":"+SUM(N11:N16)","v":0}]
[null,null,null,null,null,513.24999999999989]
[null,null,null,null,null,171.99999999999994,null,null,null,null,null,null,"Enterprise","Enterprise"]
["VARIABLE COSTS",null,null,null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Total","Total"]
["Production Costs"]
[null,"Miscellaneous"]
[null,null,null,null,null,1,null,null,0,null,0,{"$f":"+J23*G23","v":0},0,{"$f":"+L23*E$7","v":0}]
[null,null,null,null,null,1,null,null,0,null,0,0,0,0]
[null,"Marketing Expense",null,null,null,1,null,"AU",11.215,null,11.215,0,4486,0]
[null,"Feed"]
[null,null,"Supplement",null,null,500,null,"Pound",0.19600000000000001,null,98,{"$f":"+J27*G27","v":0},39200,{"$f":"+L27*E$7","v":0}]
[null,null,"Salt and Mineral",null,null,30,null,"Pound",0.45,null,13.5,0,5400,0]
[null,null,null,null,null,0,null,null,0,null,0,0,0,0]
[null,null,null,null,null,0,null,null,0,null,0,0,0,0]
[null,null,null,null,null,0,null,null,0,null,0,0,0,0]
[null,"Vet. Medicine"]
[null,null,"Vet/Medicine - Cow-Calf",null,null,1,null,"Head",32,null,32,{"$f":"+J33*G33","v":0},12800,{"$f":"+L33*E$7","v":0}]
[null,null,null,null,null,0,null,null,0,null,0,0,0,0]
[null,null,null,null,null,0,null,null,0,null,0,0,0,0]
[null,null,null,null,null,0,null,null,0,null,0,0,0,0]
[null,"Fuel",null,null,null,1,null,"AU",36.967675,null,36.967675,0,14787.07,0]
[null,"Lube (As a % of fuel)",null,null,null,0.1,null,"Percent",36.967675,null,3.6967675,0,1478.7069999999999,0]
[null,"Repairs ",null,null,null,1,null,"AU",0,null,0,0,0,0]
[null,"Labor",null,null,null,0.5,null,"Hours",15,null,7.5,0,3000,0]
[null,"Utilities",null,null,null,1,null,"AU",10,null,10,0,4000,0]
[null,null,null,null,null,null,null,null,null,null,0,{"$f":"+J42*G42","v":0},0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,"Interest on Credit Line",null,null,null,null,null,null,0.06,null,16.898506721917805,{"$f":"+SUM(L21:L44)/2*J45","v":0},6759.4026887671216,0]
["Total Variable Costs",null,null,null,null,null,null,null,null,null,229.77794922191782,{"$f":"+SUM(L23:L45)","v":0},91911.179688767123,{"$f":"+SUM(N23:N45)","v":0}]
[]
["Planned Returns Above Variable Costs:",null,null,null,null,null,null,null,null,null,311.34065077808219,{"$f":"+L17-L46","v":0},124536.26031123288,{"$f":"+N17-N46","v":0}]
[null,"Average Calf Breakeven Price to Cover Variable Costs",null,null,null,null,null,null,44.230900870891674,{"$f":"IF((E11*G11+E12*G12)=0,\"n/a\",(L46-SUM(L13:L16))/(E11*G11+E12*G12))","v":"n/a"},"CWT"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Enterprise","Enterprise"]
["FIXED COSTS",null,null,null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Total","Total"]
[null,"Depreciation - Equipment",null,null,null,1,null,"AU",62.61633333333333,null,62.61633333333333,{"$f":"+G52*J52","v":0},25046.533333333333,{"$f":"+L52*E$7","v":0}]
[null,"Depreciation - Livestock",null,null,null,1,null,"AU",41.977499999999999,null,41.977499999999999,0,16791,0]
[null,"Equipment Investment",null,null,null,1313.3175000000001,null,"dollars",5.5E-2,null,72.232462500000011,0,28892.985000000004,0]
[null,"Insurance",null,null,null,1,null,"AU",0,null,0,0,0,0]
[null,"Management Fee, Owner/Operator Labor",null,null,null,1,null,"AU",112.5,null,112.5,{"$f":"+J56*G56","v":0},45000,0]
[null,"Salaried Labor",null,null,null,1,null,"AU",37.5,null,37.5,{"$f":"+J57*G57","v":0},15000,0]
[null,"Pasture Cost",null,null,null,11.25,null,"Acres",15,null,168.75,0,67500,0]
[null,null,null,null,null,null,null,null,null,null,0,{"$f":"+G59*J59","v":0},0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0]
["Total Fixed Costs",null,null,null,null,null,null,null,null,null,495.57629583333335,{"$f":"+SUM(L52:L58)","v":0},198230.51833333334,{"$f":"+SUM(N52:N58)","v":0}]
["Total Costs",null,null,null,null,null,null,null,null,null,725.35424505525111,{"$f":"+L46+L61","v":0},290141.69802210049,{"$f":"+N46+N61","v":0}]
["Planned Returns to Management, Risk, and Profit:",null,null,null,null,null,null,null,null,null,-184.2356450552511,{"$f":"+L17-L62","v":0},-73694.25802210049,{"$f":"+N17-N62","v":0}]
[null,"Average Calf Breakeven Price to Cover Total Costs",null,null,null,null,null,null,189.45472382571461,{"$f":"IF((E11*G11+E12*G12)=0,\"n/a\",(L62-SUM(L13:L16))/(E11*G11+E12*G12))","v":"n/a"},"CWT"]
[]
[null,null,"Sensitivity Analysis for Example"]
[null,null,"Example Weaning Percent","Example Gross Sales per Animal Unit",null,"Pounds Produced per Animal Unit",null,"Example Breakeven Calf Pay Weight to Cover Total Cost",null,null,"Example Average Breakeven Price to Cover Total Cost"]
[null,null,0.89,574.53633012048192,null,537.91867469879503,null,644.93396501445295,null,null,176.68249525319456]
[null,null,0.86,557.82746506024102,null,525.58433734939752,null,672.18469593055659,null,null,182.84583811086409]
[null,null,0.83,541.11860000000001,null,513.24999999999989,null,701.83990310396348,null,null,189.45472382571464]
[null,null,0.79999999999999993,524.40973493975901,null,500.91566265060231,null,734.23251401645416,null,null,196.55927596917891]
[null,null,0.76999999999999991,507.700869879518,null,488.58132530120469,null,769.75989372692777,null,null,204.21742957836773]
[]
[null,null,null,{"$f":"\"Example Male \"&F8&\" Price\"","v":"Example Male Calf Price"},null,null,null,null,null,null,{"$f":"+I11","v":140}]
[null,null,null,{"$f":"\"Example Female \"&F8&\" Price\"","v":"Example Female Calf Price"},null,null,null,null,null,null,{"$f":"+I12","v":126}]
[null,null,null,{"$f":"\"Example Weighted Average \"&F8&\" Price ($/cwt)\"","v":"Example Weighted Average Calf Price ($/cwt)"},null,null,null,null,null,null,{"$f":"+(K11+K12)/(D11*F11+D12*F12)","v":135.46625641025642}]
[]
[null,null,"Sensitivity Analysis for Your Values"]
[null,null,"Your Weaning Percent",{"$f":"\"Your Gross Sales per \"&F7","v":"Your Gross Sales per Animal Unit"},null,{"$f":"\"Pounds Produced per \"&F7","v":"Pounds Produced per Animal Unit"},null,{"$f":"\"Your Breakeven \"&F8&\" Pay Weight to Cover Total Cost\"","v":"Your Breakeven Calf Pay Weight to Cover Total Cost"},null,null,"Your Average Breakeven Price to Cover Total Cost"]
[null,null,{"$f":"+C81+C68-C69","v":1.06},{"$f":"+IF($C$82=0,0,$L$17-$L$11-$L$12+($L$11+$L$12)*C80/$C$82)","v":0},null,{"$f":"IF($C$82=0,0,$M$86*C80/$C$82+$M$87)","v":0},null,{"$f":"IF($D$82=0,0,(YTotExp-(YTotRet+YTotExp-$L$11-$L$12))/(YPrice/100)/(C80-$E$13*$E$7/$E$8)/($E$8/$E$7))","v":0},null,null,{"$f":"IF(F80-$M$87=0,0,(YTotExp-(YTotRet+YTotExp-$L$11-$L$12))/(F80-$M$87)*100)","v":0}]
[null,null,{"$f":"+C82+C69-C70","v":1.0299999999999998},{"$f":"+IF($C$82=0,0,$L$17-$L$11-$L$12+($L$11+$L$12)*C81/$C$82)","v":0},null,{"$f":"IF($C$82=0,0,$M$86*C81/$C$82+$M$87)","v":0},null,{"$f":"IF($D$82=0,0,(YTotExp-(YTotRet+YTotExp-$L$11-$L$12))/(YPrice/100)/(C81-$E$13*$E$7/$E$8)/($E$8/$E$7))","v":0},null,null,{"$f":"IF(F81-$M$87=0,0,(YTotExp-(YTotRet+YTotExp-$L$11-$L$12))/(F81-$M$87)*100)","v":0}]
[null,null,1,{"$f":"+L17","v":0},null,{"$f":"M86+M87","v":0},null,{"$f":"IF($D$82=0,0,(YTotExp-(YTotRet+YTotExp-$L$11-$L$12))/(YPrice/100)/(C82-$E$13*$E$7/$E$8)/($E$8/$E$7))","v":0},null,null,{"$f":"IF(F82-$M$87=0,0,(YTotExp-(YTotRet+YTotExp-$L$11-$L$12))/(F82-$M$87)*100)","v":0}]
[null,null,{"$f":"+C82+C71-C70","v":0.96999999999999986},{"$f":"+IF($C$82=0,0,$L$17-$L$11-$L$12+($L$11+$L$12)*C83/$C$82)","v":0},null,{"$f":"IF($C$82=0,0,$M$86*C83/$C$82+$M$87)","v":0},null,{"$f":"IF($D$82=0,0,(YTotExp-(YTotRet+YTotExp-$L$11-$L$12))/(YPrice/100)/(C83-$E$13*$E$7/$E$8)/($E$8/$E$7))","v":0},null,null,{"$f":"IF(F83-$M$87=0,0,(YTotExp-(YTotRet+YTotExp-$L$11-$L$12))/(F83-$M$87)*100)","v":0}]
[null,null,{"$f":"+C83+C72-C71","v":0.93999999999999984},{"$f":"+IF($C$82=0,0,$L$17-$L$11-$L$12+($L$11+$L$12)*C84/$C$82)","v":0},null,{"$f":"IF($C$82=0,0,$M$86*C84/$C$82+$M$87)","v":0},null,{"$f":"IF($D$82=0,0,(YTotExp-(YTotRet+YTotExp-$L$11-$L$12))/(YPrice/100)/(C84-$E$13*$E$7/$E$8)/($E$8/$E$7))","v":0},null,null,{"$f":"IF(F84-$M$87=0,0,(YTotExp-(YTotRet+YTotExp-$L$11-$L$12))/(F84-$M$87)*100)","v":0}]
[]
[null,null,null,{"$f":"\"Your Male \"&F8&\" Price\"","v":"Your Male Calf Price"},null,null,null,null,null,null,{"$f":"+J11","v":0},null,{"$f":"(E11*G11+E12*G12)*100","v":0}]
[null,null,null,{"$f":"\"Your Female \"&F8&\" Price\"","v":"Your Female Calf Price"},null,null,null,null,null,null,{"$f":"+J12","v":0},null,{"$f":"(E13*G13+E14*G14)*100","v":0}]
[null,null,null,{"$f":"\"Your Weighted Average \"&F8&\" Price ($/cwt)\"","v":"Your Weighted Average Calf Price ($/cwt)"},null,null,null,null,null,null,{"$f":"+IF((E11*G11+E12*G12)=0,0,(L11+L12)/(E11*G11+E12*G12))","v":0}]
[]
["  Developed by Extension Economists, Texas A&M AgriLife Extension Service, budgets@tamu.edu.  "]
[]
["Information presented is prepared solely as a general guide and not intended to recognize or predict the costs and returns from any one operation.  Brand names are mentioned only as examples and imply no endorsement."]

{"sheet":"StockersMar1","index":14,"n_rows":97,"n_cols":14,"rows_kept":97,"cut":false,"hidden":false,"merged":[[84,2,84,7],[85,2,86,2],[85,5,85,7],[96,0,96,13],[0,0,0,13],[1,0,1,13],[2,0,2,13],[3,0,3,13],[70,2,70,7],[71,2,72,2],[71,5,71,7]]}
["Projections for Planning Purposes Only -- Not to be Used without Updating"]
["2018 Estimated Costs and Returns per Animal"]
["Stocker Calf Budget - Pull off Wheat March 1"]
["Enter your name for this budget in the cell above."]
["Enter  Your Values in the cells highlighed in MAROON.",null,null,null,null,null,null,null,null,null,null,null,"Stocker"]
[null,null,null,null,"Your Head",null,null,null,null,null,null,null,null,"Your"]
[null,"Number of Head",null,800,null,null,"Your",null,null,null,null,null,"Enterprise","Enterprise"]
[null,null,null,null,"Your","Pay Weight","Weight",null,null,"Your",null,"Your","Total","Total"]
["REVENUE",null,null,"Head","Head","or Amount","or Amount","Units","$/Unit","$/Unit","Total","Total",{"$f":"\"(\" & D7 & \" Head)\"","v":"(800 Head)"},{"$f":"\"(\" & E7 & \" Head)\"","v":"( Head)"}]
[]
[null,"Stocker",null,0.97499999999999998,null,6.4,null,"CWT",136,null,848.64,{"$f":"+J11*G11*E11","v":0},678912,{"$f":"+L11*E$7","v":0}]
[null,null,null,0.97499999999999998,null,0,null,null,0,null,0,0,0,0]
[null,null,null,0.97499999999999998,null,0,null,null,0,null,0,0,0,0]
["Total Revenue",null,null,null,null,null,null,null,null,null,848.64,{"$f":"+L11","v":0},678912,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Enterprise","Enterprise"]
["VARIABLE COSTS",null,null,null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Total","Total"]
["Production Costs"]
[null,"Stocker Purchase",null,null,null,4.75,null,"CWT",143,null,679.25,{"$f":"+J18*G18","v":0},543400,{"$f":"+L18*E$7","v":0}]
[null,"Stocker Delivery",null,null,null,1,null,"Head",0,null,0,{"$f":"+J19*G19","v":0},0,{"$f":"+L19*E$7","v":0}]
[null,"Grazing"]
[null,null,"Acre Lease",null,null,1.25E-3,null,"Acre",0,null,0,0,0,{"$f":"+L21*E$7","v":0}]
[null,null,"Grazing by Month",null,null,0,null,"Month",0,null,0,0,0,0]
[null,null,"Gain Contract",null,null,152.82051282051282,null,"Pounds",0.4,null,61.128205128205131,0,48902.564102564102,0]
[null,null,"On Weight Per Month",null,null,0,null,"Month",0,null,0,{"$f":"+G24*J24*G18","v":0},0,0]
[null,"Health"]
[null,null,"Vet/Medicine - Stocker",null,null,1,null,"Head",24,null,24,{"$f":"+J26*G26","v":0},19200,{"$f":"+L26*E$7","v":0}]
[null,null,null,null,null,0,null,null,0,null,0,0,0,0]
[null,null,null,null,null,0,null,null,0,null,0,0,0,0]
[null,null,null,null,null,0,null,null,0,null,0,0,0,0]
[null,"Feed"]
[null,null,"Hay",null,null,125,null,"Pound",0.08,null,10,0,8000,0]
[null,null,"Salt & Mineral - Stocker",null,null,15,null,"Pound",0.45,null,6.75,0,5400,0]
[null,null,null,null,null,0,null,null,0,null,0,0,0,0]
[null,null,null,null,null,0,null,null,0,null,0,0,0,0]
[null,null,null,null,null,0,null,null,0,null,0,0,0,0]
[null,"Miscellaneous"]
[null,null,null,null,null,1,null,null,0,null,0,{"$f":"+J37*G37","v":0},0,{"$f":"+L37*E$7","v":0}]
[null,null,null,null,null,1,null,null,0,null,0,0,0,0]
[null,"Fuel",null,null,null,1,null,"Head",8.1956249999999997,null,8.1956249999999997,0,6556.5,0]
[null,"Lube (As a % of fuel)",null,null,null,0.1,null,"Percent",8.1956249999999997,null,0.81956249999999997,0,655.65,0]
[null,"Utilities",null,null,null,1,null,"Head",0,null,0,0,0,0]
[null,"Repairs ",null,null,null,1,null,"Head",0,null,0,0,0,0]
[null,"Marketing",null,null,null,0.97499999999999998,null,"Head",12,null,11.7,0,9360,0]
[null,"Labor",null,null,null,1,null,"Head",8.4149999999999991,null,8.4149999999999991,0,6731.9999999999991,0]
[null,null,null,null,null,null,null,null,null,null,0,{"$f":"+J45*G45","v":0},0,{"$f":"+L45*E$7","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,{"$f":"+J46*G46","v":0},0,{"$f":"+L46*E$7","v":0}]
[null,"Interest on Credit Line",null,null,null,null,null,null,0.06,null,16.39185308219178,{"$f":"+SUM(L18:L44)*J47/2","v":0},13113.482465753425,0]
["Total Variable Costs",null,null,null,null,null,null,null,null,null,826.6502457103968,{"$f":"+SUM(L18:L47)","v":0},661320.19656831759,{"$f":"+SUM(N18:N47)","v":0}]
[]
["Planned Returns Above Variable Costs:",null,null,null,null,null,null,null,null,null,21.989754289603184,{"$f":"+L14-L48","v":0},17591.803431682405,{"$f":"+N14-N48","v":0}]
[]
[null,"Breakeven Price to Cover Variable Costs",null,null,null,null,null,null,132.47600091512768,{"$f":"+IF(G11=0,\"n/a\",(L48-SUM(L12:L13))/(G11*E11))","v":"n/a"},"CWT"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Enterprise","Enterprise"]
["FIXED COSTS",null,null,null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Total","Total"]
[]
[null,"Depreciation",null,null,null,1,null,"Head",12.485833333333336,null,12.485833333333336,{"$f":"+J56*G56","v":0},9988.6666666666679,{"$f":"+L56*E$7","v":0}]
[null,"Equipment Investment",null,null,null,27.215,null,"dollars",5.5E-2,null,1.4968250000000001,0,1197.46,0]
[null,"Salaried Labor",null,null,null,1,null,"Head",0,null,0,0,0,0]
[null,"Management Fee, Owner/Operator Labor",null,null,null,1,null,"Head",0,null,0,0,0,0]
[null,"Insurance",null,null,null,1,null,"Head",0,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0]
["Total Fixed Costs",null,null,null,null,null,null,null,null,null,13.982658333333335,{"$f":"+SUM(L56:L60)","v":0},11186.126666666667,{"$f":"+SUM(N56:N60)","v":0}]
[]
["Total Costs",null,null,null,null,null,null,null,null,null,840.63290404373015,{"$f":"+L48+L63","v":0},672506.3232349843,{"$f":"+N48+N63","v":0}]
[]
["Planned Returns to Management, Risk, and Profit:",null,null,null,null,null,null,null,null,null,8.0070959562698487,{"$f":"+L50-L63","v":0},6405.6767650157381,{"$f":"+N50-N63","v":0}]
[]
["    Breakeven Price to Cover Total Costs",null,null,null,null,null,null,null,134.71681154546957,{"$f":"+IF(G11=0,\"n/a\",(L65-SUM(L12:L13))/(G11*E11))","v":"n/a"},"CWT"]
[]
[null,null,"Example Break Even Sensitivity Analysis"]
[null,null,null,null,null,"Purchase Weight (Lbs/Hd): 475",null,"Sales Price/Cwt of $Total"]
[null,null,null,"Net Pay Weight",null,"Sales Price/Cwt  136.00",null,"Purchase Price/Cwt  143.00"]
[null,null,"ADG (Lbs/day)","with Shrink",null,"B/E Purchase Price ($/CWT)",null,"B/E Sales Price ($/CWT)"]
[null,null,1.4558823529411764,673,null,153.89791493816205,null,128.11108378766795]
[null,null,1.3345588235294117,656.5,null,149.29180967500417,null,131.33093585544634]
[null,null,1.213235294117647,640,null,144.68570441184627,null,134.71681154546957]
[null,null,1.0919117647058822,623.5,null,140.07959914868837,null,138.28189156231039]
[null,null,0.97058823529411764,607,null,135.4734938855305,null,142.04078976787568]
[]
[null,null,"Your Average Daily Gain",null,0,"Pounds per Day"]
[null,null,{"$f":"+\"Your Animal\"&IF(M5=\"Stocker\",\" Grazing\",\" Feeding\")&\" Days\"","v":"Your Animal Grazing Days"},null,0,"Days"]
[null,null,"Your Sale Shrink",null,0]
[]
[null,null,"Your Break Even Sensitivity Analysis"]
[null,null,null,null,null,{"$f":"+\"Purchase Weight (Lbs/Hd): \"&G18*100","v":"Purchase Weight (Lbs/Hd): 0"},null,"Sales Price/Cwt of $Total"]
[null,null,null,"Net Pay Weight",null,{"$f":"\"Sales Price/Cwt  \"&IF(J11=\"\",\".00\",TEXT(J11,\"#.00\"))","v":"Sales Price/Cwt  .00"},null,{"$f":"\"Purchase Price/Cwt  \"&IF(J18=\"\",\".00\",TEXT(J18,\"#.00\"))","v":"Purchase Price/Cwt  .00"}]
[null,null,"ADG (Lbs/day)","with Shrink",null,"B/E Purchase Price ($/CWT)",null,"B/E Sales Price ($/CWT)"]
[null,null,{"$f":"+C91*1.2","v":0},{"$f":"+C89*$E$82+$G$18*100*(1-$E$83)","v":0},null,{"$f":"IF($G$18=0,0,(((D89*$J$11/100*$E$11)-($L$48-SUM($J$12:$J$13)-$L$18)-$L$63)/(100*$G$18))*100)","v":0},null,{"$f":"IF($E$11=0,0,($L$65-SUM($J$12:$J$13))/(D89*$E$11/100))","v":0}]
[null,null,{"$f":"+C91*1.1","v":0},{"$f":"+C90*$E$82+$G$18*100*(1-$E$83)","v":0},null,{"$f":"IF($G$18=0,0,(((D90*$J$11/100*$E$11)-($L$48-SUM($J$12:$J$13)-$L$18)-$L$63)/(100*$G$18))*100)","v":0},null,{"$f":"IF($E$11=0,0,($L$65-SUM($J$12:$J$13))/(D90*$E$11/100))","v":0}]
[null,null,{"$f":"+E81","v":0},{"$f":"+C91*$E$82+$G$18*100*(1-$E$83)","v":0},null,{"$f":"IF($G$18=0,0,(((D91*$J$11/100*$E$11)-($L$48-SUM($J$12:$J$13)-$L$18)-$L$63)/(100*$G$18))*100)","v":0},null,{"$f":"IF($E$11=0,0,($L$65-SUM($J$12:$J$13))/(D91*$E$11/100))","v":0}]
[null,null,{"$f":"+C91*0.9","v":0},{"$f":"+C92*$E$82+$G$18*100*(1-$E$83)","v":0},null,{"$f":"IF($G$18=0,0,(((D92*$J$11/100*$E$11)-($L$48-SUM($J$12:$J$13)-$L$18)-$L$63)/(100*$G$18))*100)","v":0},null,{"$f":"IF($E$11=0,0,($L$65-SUM($J$12:$J$13))/(D92*$E$11/100))","v":0}]
[null,null,{"$f":"+C91*0.8","v":0},{"$f":"+C93*$E$82+$G$18*100*(1-$E$83)","v":0},null,{"$f":"IF($G$18=0,0,(((D93*$J$11/100*$E$11)-($L$48-SUM($J$12:$J$13)-$L$18)-$L$63)/(100*$G$18))*100)","v":0},null,{"$f":"IF($E$11=0,0,($L$65-SUM($J$12:$J$13))/(D93*$E$11/100))","v":0}]
[]
["  Developed by Extension Economists, Texas A&M AgriLife Extension Service, budgets@tamu.edu.  "]
[]
["Information presented is prepared solely as a general guide and not intended to recognize or predict the costs and returns from any one operation.  Brand names are mentioned only as examples and imply no endorsement."]

{"sheet":"StockersGrazeOut","index":15,"n_rows":98,"n_cols":14,"rows_kept":98,"cut":false,"hidden":false,"merged":[[85,2,85,7],[86,2,87,2],[86,5,86,7],[97,0,97,13],[0,0,0,13],[1,0,1,13],[2,0,2,13],[3,0,3,13],[71,2,71,7],[72,2,73,2],[72,5,72,7]]}
["Projections for Planning Purposes Only -- Not to be Used without Updating"]
["2018 Estimated Costs and Returns per Animal"]
["Stocker Calf Budget - Grazeout"]
["Enter your name for this budget in the cell above."]
["Enter  Your Values in the cells highlighed in MAROON.",null,null,null,null,null,null,null,null,null,null,null,"Stocker"]
[null,null,null,null,"Your Head",null,null,null,null,null,null,null,null,"Your"]
[null,"Number of Head",null,800,null,null,"Your",null,null,null,null,null,"Enterprise","Enterprise"]
[null,null,null,null,"Your","Pay Weight","Weight",null,null,"Your",null,"Your","Total","Total"]
["REVENUE",null,null,"Head","Head","or Amount","or Amount","Units","$/Unit","$/Unit","Total","Total",{"$f":"\"(\" & D7 & \" Head)\"","v":"(800 Head)"},{"$f":"\"(\" & E7 & \" Head)\"","v":"( Head)"}]
[]
[null,"Stocker",null,0.97,null,7.95,null,"CWT",130,null,1002.495,{"$f":"+J11*G11*E11","v":0},801996,{"$f":"+L11*E$7","v":0}]
[null,null,null,0.97,null,0,null,null,0,null,0,0,0,0]
[null,null,null,0.97,null,0,null,null,0,null,0,0,0,0]
["Total Revenue",null,null,null,null,null,null,null,null,null,1002.495,{"$f":"+L11","v":0},801996,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Enterprise","Enterprise"]
["VARIABLE COSTS",null,null,null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Total","Total"]
["Production Costs"]
[null,"Stocker Purchase",null,null,null,4.75,null,"CWT",143,null,679.25,{"$f":"+J18*G18","v":0},543400,{"$f":"+L18*E$7","v":0}]
[null,"Stocker Delivery",null,null,null,1,null,"Head",0,null,0,{"$f":"+J19*G19","v":0},0,{"$f":"+L19*E$7","v":0}]
[null,"Grazing"]
[null,null,"Acre Lease",null,null,1.25E-3,null,"Acre",0,null,0,0,0,{"$f":"+L21*E$7","v":0}]
[null,null,"Grazing by Month",null,null,0,null,"Month",0,null,0,0,0,0]
[null,null,"Gain Contract",null,null,305.30927835051546,null,"Pounds",0.4,null,122.12371134020619,0,97698.969072164953,0]
[null,null,"On Weight Per Month",null,null,0,null,"Month",0,null,0,{"$f":"+G24*J24*G18","v":0},0,0]
[null,"Health"]
[null,null,"Vet/Medicine - Stocker 1",null,null,1,null,"Head",12,null,12,{"$f":"+J26*G26","v":0},9600,{"$f":"+L26*E$7","v":0}]
[null,null,"Vet/Medicine - Stocker 2",null,null,0.25,null,"Head",16.8,null,4.2,0,3360,0]
[null,null,null,null,null,0,null,null,0,null,0,0,0,0]
[null,null,null,null,null,0,null,null,0,null,0,0,0,0]
[null,null,null,null,null,0,null,null,0,null,0,0,0,0]
[null,"Feed"]
[null,null,"Hay",null,null,300,null,"Pound",0.08,null,24,0,19200,0]
[null,null,"Salt & Mineral - Stocker",null,null,14,null,"Pound",0.45,null,6.3,0,5040,0]
[null,null,null,null,null,0,null,null,0,null,0,0,0,0]
[null,null,null,null,null,0,null,null,0,null,0,0,0,0]
[null,null,null,null,null,0,null,null,0,null,0,0,0,0]
[null,"Miscellaneous"]
[null,null,null,null,null,1,null,null,0,null,0,{"$f":"+J38*G38","v":0},0,{"$f":"+L38*E$7","v":0}]
[null,null,null,null,null,1,null,null,0,null,0,0,0,0]
[null,"Fuel",null,null,null,1,null,"Head",18.425000000000001,null,18.425000000000001,0,14740,0]
[null,"Lube (As a % of fuel)",null,null,null,0.1,null,"Percent",18.425000000000001,null,1.8425000000000002,0,1474.0000000000002,0]
[null,"Utilities",null,null,null,1,null,"Head",0,null,0,0,0,0]
[null,"Repairs ",null,null,null,1,null,"Head",0,null,0,0,0,0]
[null,"Marketing",null,null,null,0.97,null,"Head",15,null,14.549999999999999,0,11640,0]
[null,"Labor",null,null,null,1,null,"Head",12.55875,null,12.55875,0,10047,0]
[null,null,null,null,null,null,null,null,null,null,0,{"$f":"+J46*G46","v":0},0,{"$f":"+L46*E$7","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,{"$f":"+J47*G47","v":0},0,{"$f":"+L47*E$7","v":0}]
[null,"Interest on Credit Line",null,null,null,null,null,null,0.06,null,23.791972602739726,{"$f":"+SUM(L18:L45)*J48/2","v":0},19033.57808219178,0]
["Total Variable Costs",null,null,null,null,null,null,null,null,null,919.04193394294589,{"$f":"+SUM(L18:L48)","v":0},735233.54715435673,{"$f":"+SUM(N18:N48)","v":0}]
[]
["Planned Returns Above Variable Costs:",null,null,null,null,null,null,null,null,null,83.453066057054116,{"$f":"+L14-L49","v":0},66762.452845643274,{"$f":"+N14-N49","v":0}]
[]
[null,"Breakeven Price to Cover Variable Costs",null,null,null,null,null,null,119.17810204797327,{"$f":"+IF(G11=0,\"n/a\",(L49-SUM(L12:L13))/(G11*E11))","v":"n/a"},"CWT"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Enterprise","Enterprise"]
["FIXED COSTS",null,null,null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Total","Total"]
[]
[null,"Depreciation",null,null,null,1,null,"Head",6.4858333333333338,null,6.4858333333333338,{"$f":"+J57*G57","v":0},5188.666666666667,{"$f":"+L57*E$7","v":0}]
[null,"Equipment Investment",null,null,null,13.465,null,"dollars",5.5E-2,null,0.74057499999999998,0,592.46,0]
[null,"Salaried Labor",null,null,null,1,null,"Head",0,null,0,0,0,0]
[null,"Management Fee, Owner/Operator Labor",null,null,null,1,null,"Head",0,null,0,0,0,0]
[null,"Insurance",null,null,null,1,null,"Head",0,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0]
["Total Fixed Costs",null,null,null,null,null,null,null,null,null,7.2264083333333335,{"$f":"+SUM(L57:L61)","v":0},5781.126666666667,{"$f":"+SUM(N57:N61)","v":0}]
[]
["Total Costs",null,null,null,null,null,null,null,null,null,926.26834227627921,{"$f":"+L49+L64","v":0},741014.67382102343,{"$f":"+N49+N64","v":0}]
[]
["Planned Returns to Management, Risk, and Profit:",null,null,null,null,null,null,null,null,null,76.226657723720777,{"$f":"+L51-L64","v":0},60981.326178976611,{"$f":"+N51-N64","v":0}]
[]
["    Breakeven Price to Cover Total Costs",null,null,null,null,null,null,null,120.11519707920368,{"$f":"+IF(G11=0,\"n/a\",(L66-SUM(L12:L13))/(G11*E11))","v":"n/a"},"CWT"]
[]
[null,null,"Example Break Even Sensitivity Analysis"]
[null,null,null,null,null,"Purchase Weight (Lbs/Hd): 475",null,"Sales Price/Cwt of $Total"]
[null,null,null,"Net Pay Weight",null,"Sales Price/Cwt  130.00",null,"Purchase Price/Cwt  143.00"]
[null,null,"ADG (Lbs/day)","with Shrink",null,"B/E Purchase Price ($/CWT)",null,"B/E Sales Price ($/CWT)"]
[null,null,1.9492385786802029,859,null,176.03803320499387,null,111.16598565537477]
[null,null,1.7868020304568528,827,null,167.54287531025699,null,115.46745063841227]
[null,null,1.6243654822335025,795,null,159.04771741552017,null,120.11519707920368]
[null,null,1.4619289340101522,763,null,150.55255952078329,null,125.15279381122795]
[null,null,1.2994923857868022,731,null,142.05740162604647,null,130.63143868394931]
[]
[null,null,"Your Average Daily Gain",null,0,"Pounds per Day"]
[null,null,{"$f":"+\"Your Animal\"&IF(M5=\"Stocker\",\" Grazing\",\" Feeding\")&\" Days\"","v":"Your Animal Grazing Days"},null,0,"Days"]
[null,null,"Your Sale Shrink",null,0]
[]
[null,null,"Your Break Even Sensitivity Analysis"]
[null,null,null,null,null,{"$f":"+\"Purchase Weight (Lbs/Hd): \"&G18*100","v":"Purchase Weight (Lbs/Hd): 0"},null,"Sales Price/Cwt of $Total"]
[null,null,null,"Net Pay Weight",null,{"$f":"\"Sales Price/Cwt  \"&IF(J11=\"\",\".00\",TEXT(J11,\"#.00\"))","v":"Sales Price/Cwt  .00"},null,{"$f":"\"Purchase Price/Cwt  \"&IF(J18=\"\",\".00\",TEXT(J18,\"#.00\"))","v":"Purchase Price/Cwt  .00"}]
[null,null,"ADG (Lbs/day)","with Shrink",null,"B/E Purchase Price ($/CWT)",null,"B/E Sales Price ($/CWT)"]
[null,null,{"$f":"+C92*1.2","v":0},{"$f":"+C90*$E$83+$G$18*100*(1-$E$84)","v":0},null,{"$f":"IF($G$18=0,0,(((D90*$J$11/100*$E$11)-($L$49-SUM($J$12:$J$13)-$L$18)-$L$64)/(100*$G$18))*100)","v":0},null,{"$f":"IF($E$11=0,0,($L$66-SUM($J$12:$J$13))/(D90*$E$11/100))","v":0}]
[null,null,{"$f":"+C92*1.1","v":0},{"$f":"+C91*$E$83+$G$18*100*(1-$E$84)","v":0},null,{"$f":"IF($G$18=0,0,(((D91*$J$11/100*$E$11)-($L$49-SUM($J$12:$J$13)-$L$18)-$L$64)/(100*$G$18))*100)","v":0},null,{"$f":"IF($E$11=0,0,($L$66-SUM($J$12:$J$13))/(D91*$E$11/100))","v":0}]
[null,null,{"$f":"+E82","v":0},{"$f":"+C92*$E$83+$G$18*100*(1-$E$84)","v":0},null,{"$f":"IF($G$18=0,0,(((D92*$J$11/100*$E$11)-($L$49-SUM($J$12:$J$13)-$L$18)-$L$64)/(100*$G$18))*100)","v":0},null,{"$f":"IF($E$11=0,0,($L$66-SUM($J$12:$J$13))/(D92*$E$11/100))","v":0}]
[null,null,{"$f":"+C92*0.9","v":0},{"$f":"+C93*$E$83+$G$18*100*(1-$E$84)","v":0},null,{"$f":"IF($G$18=0,0,(((D93*$J$11/100*$E$11)-($L$49-SUM($J$12:$J$13)-$L$18)-$L$64)/(100*$G$18))*100)","v":0},null,{"$f":"IF($E$11=0,0,($L$66-SUM($J$12:$J$13))/(D93*$E$11/100))","v":0}]
[null,null,{"$f":"+C92*0.8","v":0},{"$f":"+C94*$E$83+$G$18*100*(1-$E$84)","v":0},null,{"$f":"IF($G$18=0,0,(((D94*$J$11/100*$E$11)-($L$49-SUM($J$12:$J$13)-$L$18)-$L$64)/(100*$G$18))*100)","v":0},null,{"$f":"IF($E$11=0,0,($L$66-SUM($J$12:$J$13))/(D94*$E$11/100))","v":0}]
[]
["  Developed by Extension Economists, Texas A&M AgriLife Extension Service, budgets@tamu.edu.  "]
[]
["Information presented is prepared solely as a general guide and not intended to recognize or predict the costs and returns from any one operation.  Brand names are mentioned only as examples and imply no endorsement."]

{"sheet":"Livestock Budget","index":16,"n_rows":116,"n_cols":8,"rows_kept":116,"cut":false,"hidden":false,"merged":[[94,4,94,5],[94,6,94,7],[0,0,0,6],[2,0,2,6],[92,1,92,7],[93,4,93,5],[93,6,93,7],[95,4,95,5],[95,6,95,7],[96,4,96,5],[96,6,96,7],[97,4,97,5],[97,6,97,7],[98,4,98,5],[98,6,98,7],[104,2,104,7],[108,2,110,2],[108,3,110,3],[108,4,110,4],[108,5,108,7]]}
["Estimated Costs and Returns per Animal or Breeding Female"]
[]
["Livestock Enterprise"]
[]
["Number of Head of Livestock",null,null,0]
[]
["Enter Your Values in the cells highlighed in MAROON.",null,null,null,null,null,null,"Enterprise"]
["REVENUE",null,"Head","Quantity","Units","$/Unit","Total","Total"]
[null,"Males Sold",0,0,"CWT",0,{"$f":"IF($D$5=0,0,C9/$D$5*D9*F9)","v":0},{"$f":"+G9*$D$5","v":0}]
[null,"Females Sold",0,0,"CWT",0,{"$f":"IF($D$5=0,0,C10/$D$5*D10*F10)","v":0},{"$f":"+G10*$D$5","v":0}]
[null,"Cull Breeding Females",0,0,"CWT",0,0,0]
[null,"Cull Breeding Males",0,0,"CWT",0,0,0]
[null,"Stocker or Feed Animal",0,0,"CWT",0,0,0]
[null,"Other Revenue",0,0,"CWT",0,0,0]
[null,"Other Revenue",0,0,"CWT",0,0,0]
[null,"Other Revenue",0,0,"CWT",0,0,0]
[]
["Total Revenue",null,null,null,null,null,{"$f":"+SUM(G9:G17)","v":0},{"$f":"+SUM(H9:H17)","v":0}]
[]
[null,null,null,null,null,null,null,"Enterprise"]
["VARIABLE COSTS",null,null,"Quantity","Units","$/Unit","Total","Total"]
["Production Costs"]
[null,"Animal Purchase Price, if applicable",null,0,"Cwt",0,{"$f":"D23*F23","v":0},{"$f":"+G23*$D$5","v":0}]
[null,"Pasture",{"$f":"+SUM(G25:G28)","v":0}]
[null,null,"Pasture 1",0,"Acre",0,{"$f":"D25*F25","v":0},{"$f":"+G25*$D$5","v":0}]
[null,null,"Pasture 2",0,"Acre",0,0,0]
[null,null,"Pasture 3",0,"Acre",0,0,0]
[null,null,"Pasture 4",0,"Acre",0,0,0]
[null,"Feed",{"$f":"SUM(G30:G37)","v":0}]
[null,null,"Hay",0,"Bales",0,{"$f":"D30*F30","v":0},{"$f":"+G30*$D$5","v":0}]
[null,null,"Supplement",0,"Cwt,lb,etc",0,{"$f":"D31*F31","v":0},{"$f":"+G31*$D$5","v":0}]
[null,null,"Salt Minerals",0,"Cwt",0,0,0]
[null,null,"Other Feed",0,"Cwt,lb,etc",0,0,0]
[null,null,"Other Feed",0,"Cwt,lb,etc",0,0,0]
[null,null,"Other Feed",0,"Cwt,lb,etc",0,0,0]
[null,null,"Other Feed",0,"Cwt,lb,etc",0,0,0]
[null,null,"Other Feed",0,"Cwt,lb,etc",0,0,0]
[null,"Health",{"$f":"SUM(G39:G48)","v":0}]
[null,null,"Vet/Medicine 1",0,"Visit,dose,cc's, etc.",0,{"$f":"D39*F39","v":0},{"$f":"+G39*$D$5","v":0}]
[null,null,"Vet/Medicine 2",0,"Visit,dose,cc's, etc.",0,0,0]
[null,null,"Vet/Medicine 3",0,"Visit,dose,cc's, etc.",0,0,0]
[null,null,"Vet/Medicine 4",0,"Visit,dose,cc's, etc.",0,0,0]
[null,null,"Vet/Medicine 5",0,"Visit,dose,cc's, etc.",0,0,0]
[null,null,"Vet/Medicine 6",0,"Visit,dose,cc's, etc.",0,0,0]
[null,null,"Vet/Medicine 7",0,"Visit,dose,cc's, etc.",0,0,0]
[null,null,"Vet/Medicine 8",0,"Visit,dose,cc's, etc.",0,0,0]
[null,null,"Vet/Medicine 9",0,"Visit,dose,cc's, etc.",0,0,0]
[null,null,"Vet/Medicine 10",0,"Visit,dose,cc's, etc.",0,0,0]
[]
[null,"Fuel, lube, repair",null,1,"Head",0,0,0]
[]
[null,"Labor",null,0,"Hours",0,0,0]
[]
[null,"Other Variable Expense",null,0,"Cwt,lb,etc",0,0,0]
[null,"Other Variable Expense",null,0,"Cwt,lb,etc",0,0,0]
[null,"Other Variable Expense",null,0,"Cwt,lb,etc",0,0,0]
[null,"Other Variable Expense",null,0,"Cwt,lb,etc",0,0,0]
[null,"Other Variable Expense",null,0,"Cwt,lb,etc",0,0,0]
[null,"Other Variable Expense",null,0,"Cwt,lb,etc",0,0,0]
[]
[null,"Operating Interest",null,null,null,0,{"$f":"+SUM(G23:G59)/2*F61","v":0},0]
[]
["Total Variable Costs",null,null,null,null,null,{"$f":"+SUM(G23:G62)","v":0},{"$f":"+SUM(H23:H62)","v":0}]
[]
["Planned Returns Above Variable Costs",null,null,null,null,null,{"$f":"+G18-G63","v":0},{"$f":"+H18-H63","v":0}]
[]
[null,"Breakeven Price to Cover Variable Costs",null,null,{"$f":"IF((H101/100+C13*D13)=0,0,(G63-SUM(G11:G12,G14:G16))/(H101/100+C13*D13))","v":0},{"$f":"+E9","v":"CWT"}]
[]
[null,null,null,null,null,null,null,"Enterprise"]
["FIXED COSTS",null,null,"Quantity","Units","$/Unit","Total","Total"]
[null,"Depreciation - Equipment",null,0,"Head,$,etc",0,{"$f":"D71*F71","v":0},{"$f":"+G71*$D$5","v":0}]
[null,"Depreciation - Livestock",null,0,"Head,$,etc",0,{"$f":"D72*F72","v":0},0]
[null,"Equipment Investment",null,0,"Head,$,etc",0,0,0]
[null,"Insurance",null,0,"Head,$,etc",0,0,0]
[null,"Management Fee",null,0,"Head,$,etc",0,0,0]
[null,"Owner/Operator Labor",null,0,"Head,$,etc",0,0,0]
[null,"Salaried Labor",null,0,"Head,$,etc",0,0,0]
[null,"Other Fixed Expense",null,0,"Head,$,etc",0,0,0]
[null,"Other Fixed Expense",null,0,"Head,$,etc",0,0,0]
[null,"Other Fixed Expense",null,0,"Head,$,etc",0,0,0]
[null,"Other Fixed Expense",null,0,"Head,$,etc",0,0,0]
[null,"Other Fixed Expense",null,0,"Head,$,etc",0,0,0]
[]
[null,null,null,"Total Fixed Costs",null,null,{"$f":"+SUM(G71:G83)","v":0},{"$f":"+SUM(H71:H83)","v":0}]
[]
[null,null,null,"Total Specified Costs",null,null,{"$f":"+G63+G84","v":0},{"$f":"+H63+H84","v":0}]
[]
[null,null,null,"Returns Above Specifiied Costs",null,null,{"$f":"+G18-G86","v":0},{"$f":"+H18-H86","v":0}]
[]
[null,"Breakeven Price to Cover Total Costs",null,null,{"$f":"IF((H101/100+C13*D13)=0,0,(G86-SUM(G11:G12,G14:G16))/(H101/100+C13*D13))","v":0},{"$f":"+F67","v":"CWT"}]
[]
[]
[null,"Sensitivity Analysis for Your Breeding Herd or Flock Values"]
[null,"Your Weaning Percent",{"$f":"\"Your Gross Sales per \"&F18","v":"Your Gross Sales per "},"Pounds Produced per AU",{"$f":"\"Your Breakeven \"&F19&\" Pay Weight to Cover Total Cost\"","v":"Your Breakeven  Pay Weight to Cover Total Cost"},null,"Your Average Breakeven Price to Cover Total Cost"]
[null,{"$f":"+B96-0.03","v":0.94},{"$f":"+IF($B$97=0,0,YTotRet-$L$11-$L$12+($L$11+$L$12)*B95/$B$97)","v":0},{"$f":"IF($B$97=0,0,$H$101*B95/$B$97+$H$102)","v":0},{"$f":"IF($C$97=0,0,(YTotExp-(YTotRet+YTotExp-$G$9-$G$10))/(YPrice/100)/(B95-C9/D5))","v":0},null,{"$f":"IF(D95-$H$102=0,0,(YTotExp-(YTotRet+YTotExp-$G$9-$G$10))/(D95-$H$102)*100)","v":0}]
[null,{"$f":"+B97-0.03","v":0.97},{"$f":"+IF($B$97=0,0,YTotRet-$L$11-$L$12+($L$11+$L$12)*B96/$B$97)","v":0},{"$f":"IF($B$97=0,0,$H$101*B96/$B$97+$H$102)","v":0},{"$f":"IF($C$97=0,0,(YTotExp-(YTotRet+YTotExp-$G$9-$G$10))/(YPrice/100)/(B96-C10/D5))","v":0},null,{"$f":"IF(D96-$H$102=0,0,(YTotExp-(YTotRet+YTotExp-$G$9-$G$10))/(D96-$H$102)*100)","v":0}]
[null,1,{"$f":"+YTotRet","v":0},{"$f":"H101+H102","v":0},{"$f":"IF($C$97=0,0,(YTotExp-(YTotRet+YTotExp-$G$9-$G$10))/(YPrice/100)/(B97-C11/D5))","v":0},null,{"$f":"IF(D97-$H$102=0,0,(YTotExp-(YTotRet+YTotExp-$G$9-$G$10))/(D97-$H$102)*100)","v":0}]
[null,{"$f":"+B97+0.03","v":1.03},{"$f":"+IF($B$97=0,0,YTotRet-$L$11-$L$12+($L$11+$L$12)*B98/$B$97)","v":0},{"$f":"IF($B$97=0,0,$H$101*B98/$B$97+$H$102)","v":0},{"$f":"IF($C$97=0,0,(YTotExp-(YTotRet+YTotExp-$G$9-$G$10))/(YPrice/100)/(B98-C12/D5))","v":0},null,{"$f":"IF(D98-$H$102=0,0,(YTotExp-(YTotRet+YTotExp-$G$9-$G$10))/(D98-$H$102)*100)","v":0}]
[null,{"$f":"+B98+0.03","v":1.06},{"$f":"+IF($B$97=0,0,YTotRet-$L$11-$L$12+($L$11+$L$12)*B99/$B$97)","v":0},0,{"$f":"IF($C$97=0,0,(YTotExp-(YTotRet+YTotExp-$G$9-$G$10))/(YPrice/100)/(B99-C13/D5))","v":0},null,{"$f":"IF(D99-$H$102=0,0,(YTotExp-(YTotRet+YTotExp-$G$9-$G$10))/(D99-$H$102)*100)","v":0}]
[]
[null,null,"Your Male Price",null,null,{"$f":"+F9","v":0},null,{"$f":"(C9*D9+C10*D10)*100","v":0}]
[null,null,"Your Female Price",null,null,{"$f":"+F10","v":0},null,{"$f":"(C11*D11+C12*D12)*100","v":0}]
[null,null,"Your Weighted Average Price ($/cwt)",null,null,{"$f":"+IF((C9*D9+C10*D10)=0,F13,(G9+G10)/(C9*D9+C10*D10))","v":0}]
[]
[null,null,"Your Stocker or Feeder Break Even Sensitivity Analysis"]
[null,null,"Your Average Daily Gain",null,0,"Pounds per Day"]
[null,null,{"$f":"+\"Your Animal\"&IF(M25=\"Stocker\",\" Grazing\",\" Feeding\")&\" Days\"","v":"Your Animal Feeding Days"},null,0,"Days"]
[null,null,"Your Sale Shrink",null,0]
[null,null,"Average Daily Gain    (Pounds/day)","Net Pay Weight with Shrink   (Pounds)",null,{"$f":"+\"Purchase Weight (Pounds/Head): \"&D23*100","v":"Purchase Weight (Pounds/Head): 0"},null,"Sales Price/Cwt of $Total"]
[null,null,null,null,null,{"$f":"\"Sales Price        \"&IF(F13=\"\",\".00\",TEXT(F13,\"#.00\"))","v":"Sales Price        .00"},null,{"$f":"\"Purchase Price        \"&IF(F23=\"\",\".00\",TEXT(F23,\"#.00\"))","v":"Purchase Price        .00"}]
[null,null,null,null,null,"B/E Purchase Price ($/CWT)",null,"B/E Sales Price ($/CWT)"]
[null,null,{"$f":"+C114*1.2","v":0},{"$f":"+C112*$E$107+$D$23*100*(1-$E$108)","v":0},null,{"$f":"IF($D$23=0,0,(((D112*$F$13/100*$C$13)-($G$63-SUM($F$14:$F$16)-$G$23)-$G$84)/(100*$D$23))*100)","v":0},null,{"$f":"IF($C$13=0,0,($G$86-SUM($F$14:$F$16))/(D112*$C$13/100))","v":0}]
[null,null,{"$f":"+C114*1.1","v":0},{"$f":"+C113*$E$107+$D$23*100*(1-$E$108)","v":0},null,{"$f":"IF($D$23=0,0,(((D113*$F$13/100*$C$13)-($G$63-SUM($F$14:$F$16)-$G$23)-$G$84)/(100*$D$23))*100)","v":0},null,{"$f":"IF($C$13=0,0,($G$86-SUM($F$14:$F$16))/(D113*$C$13/100))","v":0}]
[null,null,{"$f":"+E106","v":0},0,null,0,null,0]
[null,null,{"$f":"+C114*0.9","v":0},0,null,0,null,0]
[null,null,{"$f":"+C114*0.8","v":0},0,null,0,null,0]

{"sheet":"Crop Budget","index":17,"n_rows":155,"n_cols":7,"rows_kept":155,"cut":false,"hidden":false,"merged":[[0,0,0,6],[2,0,2,5],[146,1,146,6]]}
["Estimated Costs and Returns per Acre"]
[]
["Crop Enterprise"]
[]
["Number of Acres of Crop",null,null,0]
[]
["Enter Your Values in the cells highlighed in MAROON.",null,null,null,null,null,"Enterprise"]
["REVENUE",null,"Quantity","Units","$/Unit","Total","Total"]
[null,"Primary Product",0,"Cwt,lb,etc",0,{"$f":"C9*E9","v":0},{"$f":"+F9*$D$5","v":0}]
[null,"Secondary Product",0,"Cwt,lb,etc",0,{"$f":"C10*E10","v":0},{"$f":"+F10*$D$5","v":0}]
[null,"Secondary Product",0,"Cwt,lb,etc",0,0,0]
[null,"Secondary Product",0,"Cwt,lb,etc",0,0,0]
[null,"Secondary Product",0,"Cwt,lb,etc",0,0,0]
[null,"Secondary Product",0,"Cwt,lb,etc",0,0,0]
[null,"Secondary Product",0,"Cwt,lb,etc",0,0,0]
[null,"Secondary Product",0,"Cwt,lb,etc",0,0,0]
[]
["Total Revenue",null,null,null,null,{"$f":"+SUM(F9:F16)","v":0},{"$f":"+SUM(G9:G16)","v":0}]
[]
[null,null,null,null,null,null,"Enterprise"]
["VARIABLE COSTS",null,"Quantity","Units","$/Unit","Total","Total"]
[]
["Custom Field and Harvest Operations"]
[null,"Custom Field Operation 1",0,"Acre",0,{"$f":"C24*E24","v":0},{"$f":"+F24*$D$5","v":0}]
[null,"Custom Field Operation 2",0,"Acre",0,0,0]
[null,"Custom Field Operation 3",0,"Acre",0,0,0]
[null,"Custom Field Operation 4",0,"Acre",0,0,0]
[null,"Custom Field Operation 5",0,"Acre",0,0,0]
[null,"Custom Field Operation 6",0,"Acre",0,0,0]
["Machinery Expenses"]
[null,"Diesel",0,"Gallon",0,{"$f":"C31*E31","v":0},0]
[null,"Gasoline",0,"Gallon",0,0,0]
[null,"Lube",0,"Acre",0,0,0]
[null,"Repairs",0,"Acre",0,0,0]
[null,"Other Machinery Expense 1",0,"Acre",0,0,0]
[null,"Other Machinery Expense 2",0,"Acre",0,0,0]
["Labor"]
[null,"Labor 1",0,"Hour",0,{"$f":"C38*E38","v":0},0]
[null,"Labor 2",0,"Hour",0,0,0]
[null,"Labor 3",0,"Hour",0,0,0]
[null,"Labor 4",0,"Hour",0,0,0]
[null,"Labor 5",0,"Hour",0,0,0]
[null,"Irrigation Labor",0,"Hour",0,0,0]
["Seed or Transplants"]
[null,"Seed",0,"Pound",0,{"$f":"C45*E45","v":0},0]
[null,"Seed Treatment",0,"Pound",0,0,0]
[null,"Seed Fee",0,"Pound",0,0,0]
[null,"Transplants",0,"Thousand",0,0,0]
[null,"Mulch",0,"Foot",0,0,0]
[null,"Other Seed or Transplant",0,"Pound",0,0,0]
["Fertilizer and Lime"]
[null,"Fertlizer 1",0,"Pound",0,{"$f":"C52*E52","v":0},0]
[null,"Fertlizer 2",0,"Pound",0,0,0]
[null,"Fertlizer 3",0,"Pound",0,0,0]
[null,"Fertlizer 4",0,"Pound",0,0,0]
[null,"Fertlizer 5",0,"Pound",0,0,0]
[null,"Lime",0,"Ton",0,0,0]
[null,"Other Soil Amendment 1",0,"Pound",0,0,0]
[null,"Other Soil Amendment 2",0,"Pound",0,0,0]
["Herbicides"]
[null,"Herbicide 1",0,"Lb,Oz,Acre",0,{"$f":"C61*E61","v":0},0]
[null,"Herbicide 2",0,"Lb,Oz,Acre",0,0,0]
[null,"Herbicide 3",0,"Lb,Oz,Acre",0,0,0]
[null,"Herbicide 4",0,"Lb,Oz,Acre",0,0,0]
[null,"Herbicide 5",0,"Lb,Oz,Acre",0,0,0]
[null,"Herbicide 6",0,"Lb,Oz,Acre",0,0,0]
["Insecticides"]
[null,"Insecticide 1",0,"Lb,Oz,Acre",0,{"$f":"C68*E68","v":0},0]
[null,"Insecticide 2",0,"Lb,Oz,Acre",0,0,0]
[null,"Insecticide 3",0,"Lb,Oz,Acre",0,0,0]
[null,"Insecticide 4",0,"Lb,Oz,Acre",0,0,0]
[null,"Insecticide 5",0,"Lb,Oz,Acre",0,0,0]
[null,"Insecticide 6",0,"Lb,Oz,Acre",0,0,0]
["Fungicides"]
[null,"Fungicide 1",0,"Lb,Oz,Acre",0,{"$f":"C75*E75","v":0},0]
[null,"Fungicide 2",0,"Lb,Oz,Acre",0,0,0]
[null,"Fungicide 3",0,"Lb,Oz,Acre",0,0,0]
[null,"Fungicide 4",0,"Lb,Oz,Acre",0,0,0]
[null,"Fungicide 5",0,"Lb,Oz,Acre",0,0,0]
[null,"Fungicide 6",0,"Lb,Oz,Acre",0,0,0]
["Growth Regulators"]
[null,"Growth Regulator 1",0,"Lb,Oz,Acre",0,{"$f":"C82*E82","v":0},0]
[null,"Growth Regulator 2",0,"Lb,Oz,Acre",0,0,0]
[null,"Growth Regulator 3",0,"Lb,Oz,Acre",0,0,0]
[null,"Growth Regulator 4",0,"Lb,Oz,Acre",0,0,0]
[null,"Growth Regulator 5",0,"Lb,Oz,Acre",0,0,0]
[null,"Growth Regulator 6",0,"Lb,Oz,Acre",0,0,0]
["Other Chemicals"]
[null,"Fumigant",0,"Lb,Oz,Acre",0,{"$f":"C89*E89","v":0},0]
[null,"Other Chemical 1",0,"Lb,Oz,Acre",0,0,{"$f":"+F90*$D$5","v":0}]
[null,"Other Chemical 2",0,"Lb,Oz,Acre",0,0,0]
[null,"Other Chemical 3",0,"Lb,Oz,Acre",0,0,0]
[null,"Other Chemical 4",0,"Lb,Oz,Acre",0,0,0]
[null,"Other Chemical 5",0,"Lb,Oz,Acre",0,0,0]
["Irrigation"]
[null,"Well Expense",0,"Acre",0,{"$f":"C96*E96","v":0},{"$f":"+F96*$D$5","v":0}]
[null,"Pump Fuel",0,"Mcf,kWh,Gallon",0,0,0]
[null,"Pump Expense",0,"Acre",0,0,0]
[null,"Irrigation Equipment Expense",0,"Acre",0,0,0]
[null,"Repairs",0,"Acre",0,0,0]
[null,"Drip Tape",0,"Foot,Acre",0,0,0]
[null,"Water Cost",0,"AcIn,Gallon",0,0,0]
[null,"Other Irrigation Expense 1",0,"Acre",0,0,0]
[null,"Other Irrigation Expense 2",0,"Acre",0,0,0]
["Miscellaneous Expenses"]
[null,"Crop Insurance",0,"Acre",0,{"$f":"C106*E106","v":0},0]
[null,"Other Variable Expense 1",0,"Enter Unit",0,0,0]
[null,"Other Variable Expense 2",0,"Enter Unit",0,0,0]
[null,"Other Variable Expense 3",0,"Enter Unit",0,0,0]
[null,"Other Variable Expense 4",0,"Enter Unit",0,0,0]
[null,"Other Variable Expense 5",0,"Enter Unit",0,0,0]
[null,"Other Variable Expense 6",0,"Enter Unit",0,0,0]
[null,"Other Variable Expense 7",0,"Enter Unit",0,0,0]
[null,"Other Variable Expense 8",0,"Enter Unit",0,0,0]
[]
[null,"Operating Interest",null,null,0,{"$f":"+SUM(F23:F115)/2*E116","v":0},{"$f":"+F116*$D$6","v":0}]
[]
["Total Variable Costs",null,null,null,null,{"$f":"+SUM(F23:F116)","v":0},{"$f":"+SUM(G23:G116)","v":0}]
[]
["Planned Returns Above Variable Costs",null,null,null,null,{"$f":"+F18-F118","v":0},{"$f":"+G18-G118","v":0}]
[]
[null,"Breakeven Price to Cover Variable Costs",null,null,{"$f":"+IF(C9=0,0,F118-SUM(F10:F16)/C9)","v":0},{"$f":"+D9","v":"Cwt,lb,etc"}]
[]
[null,null,null,null,null,null,"Enterprise"]
["FIXED COSTS",null,"Quantity","Units","$/Unit","Total","Total"]
[null,"Land Rent or Expense",0,"Acre",0,{"$f":"C126*E126","v":0},{"$f":"+F126*$D$6","v":0}]
[null,"Depreciation - Equipment",0,"Acre,$,etc",0,{"$f":"C127*E127","v":0},0]
[null,"Equipment Investment",0,"Acre,$,etc",0,0,0]
[null,"Insurance",0,"Acre,$,etc",0,0,0]
[null,"Management Fee",0,"Acre,$,etc",0,0,0]
[null,"Owner/Operator Labor",0,"Acre,$,etc",0,0,0]
[null,"Salaried Labor",0,"Acre,$,etc",0,0,0]
[null,"Other Fixed Expense",0,"Acre,$,etc",0,0,0]
[null,"Other Fixed Expense",0,"Acre,$,etc",0,0,0]
[null,"Other Fixed Expense",0,"Acre,$,etc",0,0,0]
[null,"Other Fixed Expense",0,"Acre,$,etc",0,0,0]
[null,"Other Fixed Expense",0,"Acre,$,etc",0,0,0]
[]
[null,null,null,"Total Fixed Costs",null,{"$f":"+SUM(F126:F137)","v":0},{"$f":"+SUM(G126:G137)","v":0}]
[]
[null,null,null,"Total Specified Costs",null,{"$f":"+F118+F139","v":0},{"$f":"+G118+G139","v":0}]
[]
[null,null,null,"Returns Above Specifiied Costs",null,{"$f":"+F18-F141","v":0},{"$f":"+G18-G141","v":0}]
[]
[null,"Breakeven Price to Cover Total Costs",null,null,{"$f":"+IF(C9=0,0,F141-SUM(F10:F16)/C9)","v":0},{"$f":"+D9","v":"Cwt,lb,etc"}]
[]
[null,"Breakeven Prices for Your Crop"]
[null,null,null,null,"To Cover",null,"To Cover"]
[null,"Yield","Yield",null,"Variable",null,"Total"]
[null,"Percent",{"$f":"+D9","v":"Cwt,lb,etc"},null,"Costs",null,"Costs"]
[null,0.75,{"$f":"+$C$153*B151","v":0},null,{"$f":"+IF(C151=0,0,($F$118-SUM($F$10:$F$16))/C151)","v":0},null,{"$f":"+IF(C151=0,0,($F$141-SUM($F$10:$F$16))/C151)","v":0}]
[null,0.9,{"$f":"+$C$153*B152","v":0},null,0,null,{"$f":"+IF(C152=0,0,($F$141-SUM($F$10:$F$16))/C152)","v":0}]
[null,1,{"$f":"+C9","v":0},null,{"$f":"+IF(C153=0,0,($F$118-SUM($F$10:$F$16))/C153)","v":0},null,{"$f":"+IF(C153=0,0,($F$141-SUM($F$10:$F$16))/C153)","v":0}]
[null,1.1000000000000001,0,null,{"$f":"+IF(C154=0,0,($F$118-SUM($F$10:$F$16))/C154)","v":0},null,{"$f":"+IF(C154=0,0,($F$141-SUM($F$10:$F$16))/C154)","v":0}]
[null,1.25,0,null,0,null,{"$f":"+IF(C155=0,0,($F$141-SUM($F$10:$F$16))/C155)","v":0}]

{"sheet":"Comparative Returns - Cash Rent","index":18,"n_rows":27,"n_cols":11,"rows_kept":27,"cut":false,"hidden":false,"merged":[[2,7,2,10],[2,4,2,5],[2,1,2,2]]}
["Comparative Returns - Cash Rent"]
[]
[null,"Returns Above Total Specified Expenses",null,null,"Total Direct Expenses",null,null,"Break-Even Yield to Cover Total Costs at Price Entered"]
[null,"Total","Variable",null,"Total","Variable",null,"Price","Units","Total","Variable"]
["FORAGE CROPS"]
[]
[{"$f":"+AlfalfaDrylandEstablish!A3","v":"Dryland Alfalfa Establishment"},{"$f":"+AlfalfaDrylandEstablish!TotRet","v":-304.0545466668537},{"$f":"+AlfalfaDrylandEstablish!VarRet","v":-238.4127053658332},null,{"$f":"+AlfalfaDrylandEstablish!TotExp","v":304.0545466668537},{"$f":"+AlfalfaDrylandEstablish!VarExp","v":238.4127053658332},null,{"$f":"+AlfalfaDrylandEstablish!Price","v":0},{"$f":"+AlfalfaDrylandEstablish!Unit","v":""},{"$f":"+IF($H7=0,0,E7/$H7)","v":0},0]
[{"$f":"+AlfalfaHayDryland!A3","v":"Dryland Alfalfa Hay"},{"$f":"+AlfalfaHayDryland!TotRet","v":365.49344268621576},{"$f":"+AlfalfaHayDryland!VarRet","v":460.81571674871577},null,{"$f":"+AlfalfaHayDryland!TotExp","v":284.50655731378424},{"$f":"+AlfalfaHayDryland!VarExp","v":189.18428325128426},null,{"$f":"+AlfalfaHayDryland!Price","v":200},{"$f":"+AlfalfaHayDryland!Unit","v":"Ton"},1.4225327865689212,0.94592141625642123]
[{"$f":"+AlfalfaIrrigatedEstablish!A3","v":"Irrigated Alfalfa Establishment"},{"$f":"+AlfalfaIrrigatedEstablish!TotRet","v":-385.58845283095047},{"$f":"+AlfalfaIrrigatedEstablish!VarRet","v":-261.32161152993001},null,{"$f":"+AlfalfaIrrigatedEstablish!TotExp","v":385.58845283095047},{"$f":"+AlfalfaIrrigatedEstablish!VarExp","v":261.32161152993001},null,{"$f":"+AlfalfaIrrigatedEstablish!Price","v":0},{"$f":"+AlfalfaIrrigatedEstablish!Unit","v":""},0,0]
[{"$f":"+AlfalfaHayIrrigated!A3","v":"Irrigated Alfalfa Hay"},{"$f":"+AlfalfaHayIrrigated!TotRet","v":786.30332523812046},{"$f":"+AlfalfaHayIrrigated!VarRet","v":974.03673633187043},null,{"$f":"+AlfalfaHayIrrigated!TotExp","v":513.69667476187954},{"$f":"+AlfalfaHayIrrigated!VarExp","v":325.96326366812957},null,{"$f":"+AlfalfaHayIrrigated!Price","v":200},{"$f":"+AlfalfaHayIrrigated!Unit","v":"Ton"},2.5684833738093977,1.6298163183406478]
[{"$f":"+SmallGrain!A3","v":"Small Grain Grazing"},{"$f":"+SmallGrain!TotRet","v":-140.6746851252407},{"$f":"+SmallGrain!VarRet","v":-79.677391949220208},null,{"$f":"+SmallGrain!TotExp","v":140.6746851252407},{"$f":"+SmallGrain!VarExp","v":79.677391949220208},null,{"$f":"+SmallGrain!Price","v":0},{"$f":"+SmallGrain!Unit","v":""},{"$f":"+IF($H11=0,0,E11/$H11)","v":0},0]
[]
["FIELD CROPS"]
[]
[{"$f":"+CanolaDryland!A3","v":"Dryland Canola"},{"$f":"+CanolaDryland!TotRet","v":-72.853738757049456},{"$f":"+CanolaDryland!VarRet","v":-14.86661794643905},null,{"$f":"+CanolaDryland!TotExp","v":232.85373875704946},{"$f":"+CanolaDryland!VarExp","v":174.86661794643905},null,{"$f":"+CanolaDryland!Price","v":0.16},{"$f":"+CanolaDryland!Unit","v":"Pound"},{"$f":"+IF($H15=0,0,E15/$H15)","v":1455.3358672315592},{"$f":"+IF($H15=0,0,F15/$H15)","v":1092.916362165244}]
[{"$f":"+CottonDryland2X1!A3","v":"Dryland Cotton (2X1 Planting Pattern)"},{"$f":"+CottonDryland2X1!TotRet","v":-88.538135651361216},{"$f":"+CottonDryland2X1!VarRet","v":-8.1656364484659036},null,{"$f":"+CottonDryland2X1!TotExp","v":320.53813565136124},{"$f":"+CottonDryland2X1!VarExp","v":240.16563644846593},null,{"$f":"+CottonDryland2X1!Price","v":0.56000000000000005},{"$f":"+CottonDryland2X1!Unit","v":"Pound"},{"$f":"+IF($H16=0,0,E16/$H16)","v":572.38952794885927},{"$f":"+IF($H16=0,0,F16/$H16)","v":428.8672079436891}]
[{"$f":"+CottonDrylandSolid!A3","v":"Dryland Cotton (Solid 40\" Rows)"},{"$f":"+CottonDrylandSolid!TotRet","v":-3.4933145657802243},{"$f":"+CottonDrylandSolid!VarRet","v":72.390868549946504},null,{"$f":"+CottonDrylandSolid!TotExp","v":351.49331456578022},{"$f":"+CottonDrylandSolid!VarExp","v":275.6091314500535},null,{"$f":"+CottonDrylandSolid!Price","v":0.56000000000000005},{"$f":"+CottonDrylandSolid!Unit","v":"Pound"},{"$f":"+IF($H17=0,0,E17/$H17)","v":627.66663315317896},{"$f":"+IF($H17=0,0,F17/$H17)","v":492.1591633036669}]
[{"$f":"+CottonIrrigated!A3","v":"Sprinkler Irrigated Cotton"},{"$f":"+CottonIrrigated!TotRet","v":-108.82571393511955},{"$f":"+CottonIrrigated!VarRet","v":35.260122980905294},null,{"$f":"+CottonIrrigated!TotExp","v":676.82571393511955},{"$f":"+CottonIrrigated!VarExp","v":532.73987701909471},null,{"$f":"+CottonIrrigated!Price","v":0.56000000000000005},{"$f":"+CottonIrrigated!Unit","v":"Pound"},1208.6173463127134,951.32120896266906]
[{"$f":"+Peanuts!A3","v":"Sprinkler Irrigated Peanuts"},{"$f":"+Peanuts!TotRet","v":170.90395852396523},{"$f":"+Peanuts!VarRet","v":360.37883224046459},null,{"$f":"+Peanuts!TotExp","v":609.09604147603477},{"$f":"+Peanuts!VarExp","v":419.62116775953541},null,{"$f":"+Peanuts!Price","v":390},{"$f":"+Peanuts!Unit","v":"Ton"},1.5617847217334224,1.075951712203937]
[{"$f":"+SorghumDryland!A3","v":"Dryland Sorghum"},{"$f":"+SorghumDryland!TotRet","v":-50.728245631802167},{"$f":"+SorghumDryland!VarRet","v":19.375953063795137},null,{"$f":"+SorghumDryland!TotExp","v":177.66824563180217},{"$f":"+SorghumDryland!VarExp","v":107.56404693620486},null,{"$f":"+SorghumDryland!Price","v":5.77},{"$f":"+SorghumDryland!Unit","v":"CWT"},{"$f":"+IF($H20=0,0,E20/$H20)","v":30.79172367968842},{"$f":"+IF($H20=0,0,F20/$H20)","v":18.641949209047638}]
[{"$f":"+WheatDryland!A3","v":"Dryland Wheat"},{"$f":"+WheatDryland!TotRet","v":-49.972945728994802},{"$f":"+WheatDryland!VarRet","v":-1.7506267512464149},null,{"$f":"+WheatDryland!TotExp","v":204.5729457289948},{"$f":"+WheatDryland!VarExp","v":156.35062675124641},null,{"$f":"+WheatDryland!Price","v":4.3},{"$f":"+WheatDryland!Unit","v":"Bushel"},{"$f":"+IF($H21=0,0,E21/$H21)","v":47.575103657905771},{"$f":"+IF($H21=0,0,F21/$H21)","v":36.360610872382885}]
[]
["LIVESTOCK"]
[]
[{"$f":"+CowCalf!A3","v":"Rolling Plains Cow-Calf Production"},{"$f":"+CowCalf!TotRet","v":-184.2356450552511},{"$f":"+CowCalf!VarRet","v":311.34065077808219},null,{"$f":"+CowCalf!TotExp","v":725.35424505525111},{"$f":"+CowCalf!VarExp","v":229.77794922191782},null,{"$f":"+CowCalf!Price","v":135.46625641025642},{"$f":"+CowCalf!Unit","v":"CWT"},{"$f":"+IF($H25=0,0,E25/$H25)","v":5.3545012926210394},1.6962006281921649]
[{"$f":"+StockersMar1!A3","v":"Stocker Calf Budget - Pull off Wheat March 1"},{"$f":"+StockersMar1!TotRet","v":8.0070959562698487},{"$f":"+StockersMar1!VarRet","v":21.989754289603184},null,{"$f":"+StockersMar1!TotExp","v":840.63290404373015},{"$f":"+StockersMar1!VarExp","v":826.6502457103968},null,{"$f":"+StockersMar1!Price","v":136},{"$f":"+StockersMar1!Unit","v":"CWT"},6.1811242944391926,6.0783106302235055]
[{"$f":"+StockersGrazeOut!A3","v":"Stocker Calf Budget - Grazeout"},{"$f":"+StockersGrazeOut!TotRet","v":76.226657723720777},{"$f":"+StockersGrazeOut!VarRet","v":83.453066057054116},null,{"$f":"+StockersGrazeOut!TotExp","v":926.26834227627921},{"$f":"+StockersGrazeOut!VarExp","v":919.04193394294589},null,{"$f":"+StockersGrazeOut!Price","v":130},{"$f":"+StockersGrazeOut!Unit","v":"CWT"},7.1251410944329168,7.0695533380226605]

{"sheet":"Your Returns - Cash Rent","index":19,"n_rows":32,"n_cols":12,"rows_kept":32,"cut":false,"hidden":false,"merged":[[2,2,2,3],[2,5,2,6],[2,8,2,11]]}
["Your Returns - Cash Rent"]
[]
[null,"Quantity ","Returns Above Total Specified Expenses",null,null,"Total Direct Expenses",null,null,"Break-Even Yield to Cover Total Costs at Price Entered"]
[null,"Acres, AUs,  or Head","Total","Variable",null,"Total","Variable",null,"Price","Units","Total","Variable"]
["FORAGE CROPS"]
[]
[{"$f":"+AlfalfaDrylandEstablish!A3","v":"Dryland Alfalfa Establishment"},{"$f":"+AlfalfaDrylandEstablish!E7","v":0},{"$f":"+AlfalfaDrylandEstablish!YTotRet","v":0},{"$f":"+AlfalfaDrylandEstablish!YVarRet","v":0},null,{"$f":"+AlfalfaDrylandEstablish!YTotExp","v":0},{"$f":"+AlfalfaDrylandEstablish!YVarExp","v":0},null,{"$f":"+AlfalfaDrylandEstablish!YPrice","v":0},{"$f":"+AlfalfaDrylandEstablish!Unit","v":""},{"$f":"+IF($I7=0,0,F7/$I7)","v":0},0]
[{"$f":"+AlfalfaHayDryland!A3","v":"Dryland Alfalfa Hay"},{"$f":"+AlfalfaHayDryland!E7","v":0},{"$f":"+AlfalfaHayDryland!YTotRet","v":0},{"$f":"+AlfalfaHayDryland!YVarRet","v":0},null,{"$f":"+AlfalfaHayDryland!YTotExp","v":0},{"$f":"+AlfalfaHayDryland!YVarExp","v":0},null,{"$f":"+AlfalfaHayDryland!YPrice","v":0},{"$f":"+AlfalfaHayDryland!Unit","v":"Ton"},0,0]
[{"$f":"+AlfalfaIrrigatedEstablish!A3","v":"Irrigated Alfalfa Establishment"},{"$f":"+AlfalfaIrrigatedEstablish!E7","v":0},{"$f":"+AlfalfaIrrigatedEstablish!YTotRet","v":0},{"$f":"+AlfalfaIrrigatedEstablish!YVarRet","v":0},null,{"$f":"+AlfalfaIrrigatedEstablish!YTotExp","v":0},{"$f":"+AlfalfaIrrigatedEstablish!YVarExp","v":0},null,{"$f":"+AlfalfaIrrigatedEstablish!YPrice","v":0},{"$f":"+AlfalfaIrrigatedEstablish!Unit","v":""},0,0]
[{"$f":"+AlfalfaHayIrrigated!A3","v":"Irrigated Alfalfa Hay"},{"$f":"+AlfalfaHayIrrigated!E7","v":0},{"$f":"+AlfalfaHayIrrigated!YTotRet","v":0},{"$f":"+AlfalfaHayIrrigated!YVarRet","v":0},null,{"$f":"+AlfalfaHayIrrigated!YTotExp","v":0},{"$f":"+AlfalfaHayIrrigated!YVarExp","v":0},null,{"$f":"+AlfalfaHayIrrigated!YPrice","v":0},{"$f":"+AlfalfaHayIrrigated!Unit","v":"Ton"},0,0]
[{"$f":"+SmallGrain!A3","v":"Small Grain Grazing"},{"$f":"+SmallGrain!E7","v":0},{"$f":"+SmallGrain!YTotRet","v":0},{"$f":"+SmallGrain!YVarRet","v":0},null,{"$f":"+SmallGrain!YTotExp","v":0},{"$f":"+SmallGrain!YVarExp","v":0},null,{"$f":"+SmallGrain!YPrice","v":0},{"$f":"+SmallGrain!Unit","v":""},{"$f":"+IF($I11=0,0,F11/$I11)","v":0},0]
[]
["FIELD CROPS - IRRIGATED"]
[]
[{"$f":"+CanolaDryland!A3","v":"Dryland Canola"},{"$f":"+CanolaDryland!E7","v":0},{"$f":"+CanolaDryland!YTotRet","v":0},{"$f":"+CanolaDryland!YVarRet","v":0},null,{"$f":"+CanolaDryland!YTotExp","v":0},{"$f":"+CanolaDryland!YVarExp","v":0},null,{"$f":"+CanolaDryland!YPrice","v":0},{"$f":"+CanolaDryland!Unit","v":"Pound"},{"$f":"+IF($I15=0,0,F15/$I15)","v":0},{"$f":"+IF($I15=0,0,G15/$I15)","v":0}]
[{"$f":"+CottonDryland2X1!A3","v":"Dryland Cotton (2X1 Planting Pattern)"},{"$f":"+CottonDryland2X1!E7","v":0},{"$f":"+CottonDryland2X1!YTotRet","v":0},{"$f":"+CottonDryland2X1!YVarRet","v":0},null,{"$f":"+CottonDryland2X1!YTotExp","v":0},{"$f":"+CottonDryland2X1!YVarExp","v":0},null,{"$f":"+CottonDryland2X1!YPrice","v":0},{"$f":"+CottonDryland2X1!Unit","v":"Pound"},{"$f":"+IF($I16=0,0,F16/$I16)","v":0},{"$f":"+IF($I16=0,0,G16/$I16)","v":0}]
[{"$f":"+CottonDrylandSolid!A3","v":"Dryland Cotton (Solid 40\" Rows)"},{"$f":"+CottonDrylandSolid!E7","v":0},{"$f":"+CottonDrylandSolid!YTotRet","v":0},{"$f":"+CottonDrylandSolid!YVarRet","v":0},null,{"$f":"+CottonDrylandSolid!YTotExp","v":0},{"$f":"+CottonDrylandSolid!YVarExp","v":0},null,{"$f":"+CottonDrylandSolid!YPrice","v":0},{"$f":"+CottonDrylandSolid!Unit","v":"Pound"},{"$f":"+IF($I17=0,0,F17/$I17)","v":0},{"$f":"+IF($I17=0,0,G17/$I17)","v":0}]
[{"$f":"+CottonIrrigated!A3","v":"Sprinkler Irrigated Cotton"},{"$f":"+CottonIrrigated!E7","v":0},{"$f":"+CottonIrrigated!YTotRet","v":0},{"$f":"+CottonIrrigated!YVarRet","v":0},null,{"$f":"+CottonIrrigated!YTotExp","v":0},{"$f":"+CottonIrrigated!YVarExp","v":0},null,{"$f":"+CottonIrrigated!YPrice","v":0},{"$f":"+CottonIrrigated!Unit","v":"Pound"},0,0]
[{"$f":"+Peanuts!A3","v":"Sprinkler Irrigated Peanuts"},{"$f":"+Peanuts!E7","v":0},{"$f":"+Peanuts!YTotRet","v":0},{"$f":"+Peanuts!YVarRet","v":0},null,{"$f":"+Peanuts!YTotExp","v":0},{"$f":"+Peanuts!YVarExp","v":0},null,{"$f":"+Peanuts!YPrice","v":0},{"$f":"+Peanuts!Unit","v":"Ton"},0,0]
[{"$f":"+SorghumDryland!A3","v":"Dryland Sorghum"},{"$f":"+SorghumDryland!E7","v":0},{"$f":"+SorghumDryland!YTotRet","v":0},{"$f":"+SorghumDryland!YVarRet","v":0},null,{"$f":"+SorghumDryland!YTotExp","v":0},{"$f":"+SorghumDryland!YVarExp","v":0},null,{"$f":"+SorghumDryland!YPrice","v":0},{"$f":"+SorghumDryland!Unit","v":"CWT"},{"$f":"+IF($I20=0,0,F20/$I20)","v":0},{"$f":"+IF($I20=0,0,G20/$I20)","v":0}]
[{"$f":"+WheatDryland!A3","v":"Dryland Wheat"},{"$f":"+WheatDryland!E7","v":0},{"$f":"+WheatDryland!YTotRet","v":0},{"$f":"+WheatDryland!YVarRet","v":0},null,{"$f":"+WheatDryland!YTotExp","v":0},{"$f":"+WheatDryland!YVarExp","v":0},null,{"$f":"+WheatDryland!YPrice","v":0},{"$f":"+WheatDryland!Unit","v":"Bushel"},{"$f":"+IF($I21=0,0,F21/$I21)","v":0},{"$f":"+IF($I21=0,0,G21/$I21)","v":0}]
[]
["LIVESTOCK"]
[]
[{"$f":"+CowCalf!A3","v":"Rolling Plains Cow-Calf Production"},{"$f":"+CowCalf!E7","v":0},{"$f":"+CowCalf!YTotRet","v":0},{"$f":"+CowCalf!YVarRet","v":0},null,{"$f":"+CowCalf!YTotExp","v":0},{"$f":"+CowCalf!YVarExp","v":0},null,{"$f":"+CowCalf!YPrice","v":0},{"$f":"+CowCalf!Unit","v":"CWT"},{"$f":"+IF($I25=0,0,F25/$I25)","v":0},0]
[{"$f":"+StockersMar1!A3","v":"Stocker Calf Budget - Pull off Wheat March 1"},{"$f":"+StockersMar1!E7","v":0},{"$f":"+StockersMar1!YTotRet","v":0},{"$f":"+StockersMar1!YVarRet","v":0},null,{"$f":"+StockersMar1!YTotExp","v":0},{"$f":"+StockersMar1!YVarExp","v":0},null,{"$f":"+StockersMar1!YPrice","v":0},{"$f":"+StockersMar1!Unit","v":"CWT"},0,0]
[{"$f":"+StockersGrazeOut!A3","v":"Stocker Calf Budget - Grazeout"},{"$f":"+StockersGrazeOut!E7","v":0},{"$f":"+StockersGrazeOut!YTotRet","v":0},{"$f":"+StockersGrazeOut!YVarRet","v":0},null,{"$f":"+StockersGrazeOut!YTotExp","v":0},{"$f":"+StockersGrazeOut!YVarExp","v":0},null,{"$f":"+StockersGrazeOut!YPrice","v":0},{"$f":"+StockersGrazeOut!Unit","v":"CWT"},0,0]
[]
["OTHER BUDGETS"]
[]
[{"$f":"+'Livestock Budget'!A3","v":"Livestock Enterprise"},{"$f":"+'Livestock Budget'!D5","v":0},{"$f":"+'Livestock Budget'!YTotRet","v":0},{"$f":"+'Livestock Budget'!YVarRet","v":0},null,{"$f":"+'Livestock Budget'!YTotExp","v":0},{"$f":"+'Livestock Budget'!YVarExp","v":0},null,{"$f":"+'Livestock Budget'!YPrice","v":0},{"$f":"+'Livestock Budget'!Unit","v":"CWT"},{"$f":"+IF($I31=0,0,F31/$I31)","v":0},0]
[{"$f":"+'Crop Budget'!A3","v":"Crop Enterprise"},{"$f":"+'Crop Budget'!D5","v":0},{"$f":"+'Crop Budget'!YTotRet","v":0},{"$f":"+'Crop Budget'!YVarRet","v":0},null,{"$f":"+'Crop Budget'!YTotExp","v":0},{"$f":"+'Crop Budget'!YVarExp","v":0},null,{"$f":"+'Crop Budget'!YPrice","v":0},{"$f":"+'Crop Budget'!Unit","v":"Cwt,lb,etc"},0,0]