{"text_format":"1","workbook":"xlsx","n_sheets":23,"sheets":["Menu","Links","AlfalfaDrylandEstablish","AlfalfaHayDryland","AlfalfaIrrigatedEstablish","AlfalfaHayIrrigated","CottonDrylandSolid","Red Till Irrig Cotton","Conv M Irrig Cotton","No Till Dryland Cotton","NT Irrig M Cotton","NT-CC2 Irr M Cotton","Peanuts","SorghumDryland","WheatDryland","SmallGrain","CowCalf","StockersMar1","StockerGrazeOut","Livestock Budget","Crop Budget","Comparative Returns - Cash Rent","Your Returns - Cash Rent"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":487,"comments":19,"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":66,"n_cols":26,"rows_kept":66,"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,null,null,"Field Crops"]
[null,"Links"]
[null,null,null,{"$f":"CottonDrylandSolid!A3","v":"Dryland Cotton (Solid 40\" Rows)"}]
[null,null,null,{"$f":"'Red Till Irrig Cotton'!A3","v":"Cotton - Red Till Irrig "}]
[null,null,null,{"$f":"'Conv M Irrig Cotton'!A3","v":"Conventional Irrig Cotton"}]
[null,null,null,{"$f":"'NT Irrig M Cotton'!A3","v":"Cotton - No-Till Irrigated"}]
[null,null,null,{"$f":"'NT-CC2 Irr M Cotton'!A3","v":"Cotton NT - Cover Crop Wheat Irrig"}]
[null,null,null,{"$f":"'No Till Dryland Cotton'!A3","v":"Cotton - No Till Dryland "}]
[null,null,null,{"$f":"Peanuts!A3","v":"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":"StockerGrazeOut!A3","v":"Stocker Calf Budget - Grazeout"}]
[]
[null,null,null,"Other Budgets"]
[]
[null,null,null,{"$f":"'Livestock Budget'!A3","v":"Livestock Budget"}]
[null,null,null,{"$f":"'Crop Budget'!A3","v":"Crop Enterprise"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Francisco Abelló, Assistant Professor and Extension Specialist, Texas A&M AgriLife Extension, 940-647-3908"]

{"sheet":"Links","index":1,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[[21,1,21,2],[1,1,1,8],[2,1,2,8],[3,1,3,8],[5,1,5,8],[11,1,11,2],[7,1,7,2],[13,1,13,2],[9,1,9,2],[19,1,19,2],[17,1,17,2],[15,1,15,2]]}
[]
[null,"Texas Crop and Livestock Budgets"]
[null,"A Program of the Texas A&M AgriLife Extension Service"]
[null,"Agricultural Economics Department, The Texas A&M University System"]
[]
[null,"Developed by Texas A&M AgriLife Extension Service Economists and Other Specialists"]
[]
[null,"Contact Us",null,null,null,null,"Clickable Logos"]
[]
[null,"Resources"]
[]
[null,"Decision Aids (includes Machinery Cost Estimator)"]
[]
[null,"Custom Rate Survey"]
[]
[null,"Basis Data"]
[]
[null,"Master Marketer"]
[]
[null,"Extension Ag Economics"]
[]
[null,"Department of Agricultural Economics"]
[]
[null,"Menu Page"]
[]
[null,"Links last checked 4/17/2020"]

{"sheet":"AlfalfaDrylandEstablish","index":2,"n_rows":90,"n_cols":18,"rows_kept":90,"cut":false,"hidden":false,"merged":[[77,3,77,8],[89,0,89,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"]
["2021 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.25,null,10,{"$f":"E18*H18","v":0},0,null,0,{"$f":"J18*L18","v":0},10,{"$f":"+J18-N18","v":0},1000,{"$f":"+J18*E$7","v":0}]
[null,"","Fertilizer (P)",80,null,"Pound",0.32500000000000001,null,26,0,0,null,0,0,26,0,2600,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.22,null,2.64,0,0,null,0,0,2.64,0,264,0]
[null,"Herbicide"]
[null,"","Roundup",2,null,"Pint",1.875,null,3.75,0,0,null,0,0,3.75,0,375,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.43,null,"Hour",14,null,6.02,{"$f":"E31*H31","v":0},0,null,0,{"$f":"J31*L31","v":0},6.02,{"$f":"+J31-N31","v":0},602,{"$f":"+J31*E$7","v":0}]
[null,null,"Other Labor",0.48,null,"Hour",14,null,6.72,{"$f":"E32*H32","v":0},0,null,0,{"$f":"J32*L32","v":0},6.72,{"$f":"+J32-N32","v":0},672,{"$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",2.91,null,"Gallon",1.4,null,4.0739999999999998,{"$f":"E36*H36","v":0},0,null,0,{"$f":"J36*L36","v":0},4.0739999999999998,{"$f":"+J36-N36","v":0},407.4,{"$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,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",3,null,3,{"$f":"E43*H43","v":0},0,null,0,{"$f":"J43*L43","v":0},3,{"$f":"+J43-N43","v":0},300,{"$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",5.9599533490872689,null,5.9599533490872689,0,0,null,0,0,5.9599533490872689,0,595.99533490872693,0]
[null,null,"Implements",1,null,"Acre",5.8194665240361516,null,5.8194665240361516,0,0,null,0,0,5.8194665240361516,0,581.94665240361519,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,6.5000000000000002E-2,null,2.100656571935084,{"$f":"+SUM(J17:J48)/2*H49","v":0},null,null,0,{"$f":"+SUM(N17:N48)/2*L49","v":0},2.100656571935084,{"$f":"+SUM(P17:P48)/2*L49","v":0},210.0656571935084,{"$f":"+J49*E$7","v":0}]
["Total Variable Costs",null,null,null,null,null,null,null,217.58407644505851,{"$f":"SUM(J18:J49)","v":0},null,null,0,{"$f":"SUM(N18:N49)","v":0},217.58407644505851,{"$f":"SUM(P18:P49)","v":0},21758.407644505849,{"$f":"SUM(R18:R49)","v":0}]
["Planned Returns Above Variable Costs:",null,null,null,null,null,null,null,-217.58407644505851,{"$f":"+J13-J50","v":0},null,null,0,{"$f":"+N13-N50","v":0},-217.58407644505851,{"$f":"+P13-P50","v":0},-21758.407644505849,{"$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",4.165,null,4.165,{"$f":"E56*H56","v":0},0,null,0,{"$f":"J56*L56","v":0},4.165,{"$f":"+J56-N56","v":0},416.5,{"$f":"+J56*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",1,null,"Acre",6.1586184607235124,null,6.1586184607235124,0,0,null,0,{"$f":"J57*L57","v":0},6.1586184607235124,0,615.86184607235123,0]
[null,null,"Implements",1,null,"Acre",7.0655866562756477,null,7.0655866562756477,0,0,null,0,{"$f":"J58*L58","v":0},7.0655866562756477,0,706.55866562756478,0]
[null,"Equipment Investment"]
[null,null,"Pickup/General Use Equipment",29.175000000000001,null,"Dollars",5.5E-2,null,1.604625,{"$f":"E60*H60","v":0},0,null,0,{"$f":"J60*L60","v":0},1.604625,{"$f":"+J60-N60","v":0},160.46250000000001,{"$f":"+J60*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",47.977624460152519,null,"Dollars",5.5E-2,null,2.6387693453083885,0,0,null,0,{"$f":"J61*L61","v":0},2.6387693453083885,0,263.87693453083887,0]
[null,null,"Implements",30.225009585179166,null,"Dollars",5.5E-2,null,1.6623755271848542,0,0,null,0,{"$f":"J62*L62","v":0},1.6623755271848542,0,166.2375527184854,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",30,null,30,0,0,null,0,0,30,0,3000,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,53.294974989492403,{"$f":"+SUM(J56:J70)","v":0},null,null,0,{"$f":"+SUM(N56:N70)","v":0},53.294974989492403,{"$f":"+SUM(P56:P70)","v":0},5329.4974989492403,{"$f":"+SUM(R56:R70)","v":0}]
["Total Specified Costs",null,null,null,null,null,null,null,270.87905143455089,{"$f":"+J50+J71","v":0},null,null,0,{"$f":"+N50+N71","v":0},270.87905143455089,{"$f":"+P50+P71","v":0},27087.905143455089,{"$f":"+R50+R71","v":0}]
[]
["Returns Above Specified Costs",null,null,null,null,null,null,null,-270.87905143455089,{"$f":"+J13-J72","v":0},null,null,0,{"$f":"+N13-N72","v":0},-270.87905143455089,{"$f":"+P13-P72","v":0},-27087.905143455089,{"$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]
[]
["Francisco Abelló, Assistant Professor and Extension Specialist, Texas A&M AgriLife Extension, 940-647-3908"]
[]
["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":3,"n_rows":91,"n_cols":18,"rows_kept":91,"cut":false,"hidden":false,"merged":[[78,3,78,8],[90,0,90,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"]
["2021 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",230,null,747.5,{"$f":"E10*H10","v":0},0,null,0,{"$f":"J10*L10","v":0},747.5,{"$f":"+J10-N10","v":0},74750,{"$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,747.5,{"$f":"SUM(J10:J12)","v":0},null,null,0,{"$f":"SUM(N10:N12)","v":0},747.5,{"$f":"SUM(P10:P12)","v":0},74750,{"$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",4.5,null,4.5,{"$f":"E18*H18","v":0},0,null,0,{"$f":"J18*L18","v":0},4.5,{"$f":"+J18-N18","v":0},450,{"$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",32,null,104,0,0,null,0,0,104,0,10400,0]
[null,"Fertilizer"]
[null,"","Sulfur",12,null,"Pound",0.22,null,2.64,0,0,null,0,0,2.64,0,264,0]
[null,"","Fertilizer (N)",20,null,"Pound",0.25,null,5,0,0,null,0,0,5,0,500,0]
[null,"","Fertilizer (P)",50,null,"Pound",0.32500000000000001,null,16.25,0,0,null,0,0,16.25,0,1625,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",5.2,null,10.4,0,0,null,0,0,10.4,0,1040,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",14,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",14,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",1.4,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,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",19.5,null,19.5,{"$f":"E48*H48","v":0},0,null,0,{"$f":"J48*L48","v":0},19.5,{"$f":"+J48-N48","v":0},1950,{"$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,6.5000000000000002E-2,null,5.1256556378424669,{"$f":"+SUM(J17:J53)/2*H54","v":0},null,null,0,{"$f":"+SUM(N17:N53)/2*L54","v":0},5.1256556378424669,{"$f":"+SUM(P17:P53)/2*L54","v":0},512.56556378424671,{"$f":"+J54*E$7","v":0}]
["Total Variable Costs",null,null,null,null,null,null,null,229.06971813784247,{"$f":"SUM(J18:J54)","v":0},null,null,0,{"$f":"SUM(N18:N54)","v":0},229.06971813784247,{"$f":"SUM(P18:P54)","v":0},22906.971813784246,{"$f":"SUM(R18:R54)","v":0}]
["Planned Returns Above Variable Costs:",null,null,null,null,null,null,null,518.43028186215747,{"$f":"+J13-J55","v":0},null,null,0,{"$f":"+N13-N55","v":0},518.43028186215747,{"$f":"+P13-P55","v":0},51843.028186215757,{"$f":"+R13-R55","v":0}]
[null,"Breakeven Price to Cover Variable Costs",null,null,null,null,70.482990196259223,{"$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",28.324999999999999,null,28.324999999999999,{"$f":"E61*H61","v":0},0,null,0,{"$f":"J61*L61","v":0},28.324999999999999,{"$f":"+J61-N61","v":0},2832.5,{"$f":"+J61*E$7","v":0}]
[null,"Equipment Investment"]
[null,null,"Pickup/General Use Equipment",220.875,null,"Dollars",5.5E-2,null,12.148125,{"$f":"E63*H63","v":0},0,null,0,{"$f":"J63*L63","v":0},12.148125,{"$f":"+J63-N63","v":0},1214.8125,{"$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",60.176000000000002,null,60.176000000000002,0,0,null,0,0,60.176000000000002,0,6017.6,0]
[null,"Cash Rent - Dryland Alfalfa",null,1,null,"Acre",30,null,30,0,0,null,0,0,30,0,3000,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,130.649125,{"$f":"+SUM(J61:J71)","v":0},null,null,0,{"$f":"+SUM(N61:N71)","v":0},130.649125,{"$f":"+SUM(P61:P71)","v":0},13064.9125,{"$f":"+SUM(R61:R71)","v":0}]
["Total Specified Costs",null,null,null,null,null,null,null,359.71884313784244,{"$f":"+J55+J72","v":0},null,null,0,{"$f":"+N55+N72","v":0},359.71884313784244,{"$f":"+P55+P72","v":0},35971.884313784249,{"$f":"+R55+R72","v":0}]
[]
["Returns Above Specified Costs",null,null,null,null,null,null,null,387.78115686215756,{"$f":"+J13-J73","v":0},null,null,0,{"$f":"+N13-N73","v":0},387.78115686215756,{"$f":"+P13-P73","v":0},38778.115686215751,{"$f":"+R13-R73","v":0}]
[]
["    Breakeven Price to Cover Total Costs",null,null,null,null,null,110.68272096548998,{"$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,93.977320261678969,null,null,147.57696128731999]
[null,0.9,2.9250000000000003,78.314433551399134,null,null,122.98080107276664]
[null,1,3.25,70.482990196259223,null,null,110.68272096548998]
[null,1.1000000000000001,3.5750000000000002,64.075445632962925,null,null,100.62065542317271]
[null,1.25,4.0625,56.386392157007379,null,null,88.546176772391988]
[]
["Francisco Abelló, Assistant Professor and Extension Specialist, Texas A&M AgriLife Extension, 940-647-3908"]
[]
["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":4,"n_rows":95,"n_cols":18,"rows_kept":95,"cut":false,"hidden":false,"merged":[[82,3,82,8],[94,0,94,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"]
["2021 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.25,null,10,{"$f":"E18*H18","v":0},0,null,0,{"$f":"J18*L18","v":0},10,{"$f":"+J18-N18","v":0},1000,{"$f":"+J18*E$7","v":0}]
[null,"","Fertilizer (P)",80,null,"Pound",0.32500000000000001,null,26,0,0,null,0,0,26,0,2600,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.22,null,2.64,0,0,null,0,0,2.64,0,264,0]
[null,"Herbicide"]
[null,"","Roundup",2,null,"Pint",1.875,null,3.75,0,0,null,0,0,3.75,0,375,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",4.5,null,27,{"$f":"E31*H31","v":0},0,null,0,{"$f":"J31*L31","v":0},27,{"$f":"+J31-N31","v":0},2700,{"$f":"+J31*E$7","v":0}]
[null,null,"Irrigation Labor",0.51200000000000001,null,"Hour",14,null,7.1680000000000001,0,0,null,0,0,7.1680000000000001,0,716.80000000000007,0]
[null,"Machinery Labor"]
[null,null,"Tractors/Self-Propelled",0.43,null,"Hour",14,null,6.02,{"$f":"E34*H34","v":0},0,null,0,{"$f":"J34*L34","v":0},6.02,{"$f":"+J34-N34","v":0},602,{"$f":"+J34*E$7","v":0}]
[null,null,"Other Labor",0.48,null,"Hour",14,null,6.72,{"$f":"E35*H35","v":0},0,null,0,{"$f":"J35*L35","v":0},6.72,{"$f":"+J35-N35","v":0},672,{"$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",2.91,null,"Gallon",1.4,null,4.0739999999999998,{"$f":"E39*H39","v":0},0,null,0,{"$f":"J39*L39","v":0},4.0739999999999998,{"$f":"+J39-N39","v":0},407.4,{"$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,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",3,null,3,{"$f":"E46*H46","v":0},0,null,0,{"$f":"J46*L46","v":0},3,{"$f":"+J46-N46","v":0},300,{"$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",5.9599533490872689,null,5.9599533490872689,0,0,null,0,0,5.9599533490872689,0,595.99533490872693,0]
[null,null,"Implements",1,null,"Acre",5.8194665240361516,null,5.8194665240361516,0,0,null,0,0,5.8194665240361516,0,581.94665240361519,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,6.5000000000000002E-2,null,2.9228922179989172,{"$f":"+SUM(J17:J51)/2*H52","v":0},null,null,0,{"$f":"+SUM(N17:N51)/2*L52","v":0},2.9228922179989172,{"$f":"+SUM(P17:P51)/2*L52","v":0},292.28922179989172,{"$f":"+J52*E$7","v":0}]
["Total Variable Costs",null,null,null,null,null,null,null,262.57451209112236,{"$f":"SUM(J18:J52)","v":0},null,null,0,{"$f":"SUM(N18:N52)","v":0},262.57451209112236,{"$f":"SUM(P18:P52)","v":0},26257.451209112234,{"$f":"SUM(R18:R52)","v":0}]
["Planned Returns Above Variable Costs:",null,null,null,null,null,null,null,-262.57451209112236,{"$f":"+J13-J53","v":0},null,null,0,{"$f":"+N13-N53","v":0},-262.57451209112236,{"$f":"+P13-P53","v":0},-26257.451209112234,{"$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",4.165,null,4.165,{"$f":"E59*H59","v":0},0,null,0,{"$f":"J59*L59","v":0},4.165,{"$f":"+J59-N59","v":0},416.5,{"$f":"+J59*E$7","v":0}]
[null,null,"Irrigation Equipment",1,null,"Acre",9,null,9,0,0,null,0,{"$f":"J60*L60","v":0},9,0,900,0]
[null,null,"Tractors/Self-Propelled",1,null,"Acre",6.1586184607235124,null,6.1586184607235124,0,0,null,0,{"$f":"J61*L61","v":0},6.1586184607235124,0,615.86184607235123,0]
[null,null,"Implements",1,null,"Acre",7.0655866562756477,null,7.0655866562756477,0,0,null,0,{"$f":"J62*L62","v":0},7.0655866562756477,0,706.55866562756478,0]
[null,"Equipment Investment"]
[null,null,"Pickup/General Use Equipment",29.175000000000001,null,"Dollars",5.5E-2,null,1.604625,{"$f":"E64*H64","v":0},0,null,0,{"$f":"J64*L64","v":0},1.604625,{"$f":"+J64-N64","v":0},160.46250000000001,{"$f":"+J64*E$7","v":0}]
[null,null,"Irrigation Equipment",262.5,null,"Dollars",5.5E-2,null,14.4375,0,0,null,0,{"$f":"J65*L65","v":0},14.4375,0,1443.75,0]
[null,null,"Tractors/Self-Propelled",47.977624460152519,null,"Dollars",5.5E-2,null,2.6387693453083885,0,0,null,0,{"$f":"J66*L66","v":0},2.6387693453083885,0,263.87693453083887,0]
[null,null,"Implements",30.225009585179166,null,"Dollars",5.5E-2,null,1.6623755271848542,0,0,null,0,{"$f":"J67*L67","v":0},1.6623755271848542,0,166.2375527184854,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",90,null,90,0,0,null,0,0,90,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":"E75*H75","v":0},0,null,0,0,0,0,0,0]
["Total Fixed Costs",null,null,null,null,null,null,null,136.7324749894924,{"$f":"+SUM(J59:J75)","v":0},null,null,0,{"$f":"+SUM(N59:N75)","v":0},136.7324749894924,{"$f":"+SUM(P59:P75)","v":0},13673.24749894924,{"$f":"+SUM(R59:R75)","v":0}]
["Total Specified Costs",null,null,null,null,null,null,null,399.30698708061476,{"$f":"+J53+J76","v":0},null,null,0,{"$f":"+N53+N76","v":0},399.30698708061476,{"$f":"+P53+P76","v":0},39930.698708061478,{"$f":"+R53+R76","v":0}]
[]
["Returns Above Specified Costs",null,null,null,null,null,null,null,-399.30698708061476,{"$f":"+J13-J77","v":0},null,null,0,{"$f":"+N13-N77","v":0},-399.30698708061476,{"$f":"+P13-P77","v":0},-39930.698708061478,{"$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]
[]
["Francisco Abelló, Assistant Professor and Extension Specialist, Texas A&M AgriLife Extension, 940-647-3908"]
[]
["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":5,"n_rows":96,"n_cols":18,"rows_kept":96,"cut":false,"hidden":false,"merged":[[83,3,83,8],[95,0,95,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"]
["2021 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",230,null,1495,{"$f":"E10*H10","v":0},0,null,0,{"$f":"J10*L10","v":0},1495,{"$f":"+J10-N10","v":0},149500,{"$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,1495,{"$f":"SUM(J10:J12)","v":0},null,null,0,{"$f":"SUM(N10:N12)","v":0},1495,{"$f":"SUM(P10:P12)","v":0},149500,{"$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",4.5,null,4.5,0,0,null,0,0,4.5,0,450,0]
[null,"","Custom Baling - Alfalfa",6.5,null,"Ton",32,null,208,0,0,null,0,0,208,0,20800,0]
[null,"Fertilizer"]
[null,"","Fertilizer (N)",30,null,"Pound",0.25,null,7.5,0,0,null,0,0,7.5,0,750,0]
[null,"","Fertilizer (P)",50,null,"Pound",0.32500000000000001,null,16.25,0,0,null,0,0,16.25,0,1625,0]
[null,"","Sulfur",12,null,"Pound",0.22,null,2.64,0,0,null,0,0,2.64,0,264,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",5.2,null,10.4,0,0,null,0,0,10.4,0,1040,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",4.5,null,45,{"$f":"E36*H36","v":0},0,null,0,{"$f":"J36*L36","v":0},45,{"$f":"+J36-N36","v":0},4500,{"$f":"+J36*E$7","v":0}]
[null,null,"Irrigation Labor",0.96,null,"Hour",14,null,13.44,0,0,null,0,0,13.44,0,1344,0]
[null,"Machinery Labor"]
[null,null,"Tractors/Self-Propelled",0,null,"Hour",14,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",14,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",1.4,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,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",26.25,null,26.25,{"$f":"E51*H51","v":0},0,null,0,{"$f":"J51*L51","v":0},26.25,{"$f":"+J51-N51","v":0},2625,{"$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,6.5000000000000002E-2,null,8.0927935907534252,{"$f":"+SUM(J17:J56)/2*H57","v":0},null,null,0,{"$f":"+SUM(N17:N56)/2*L57","v":0},8.0927935907534252,{"$f":"+SUM(P17:P56)/2*L57","v":0},809.27935907534254,{"$f":"+J57*E$7","v":0}]
["Total Variable Costs",null,null,null,null,null,null,null,431.47685609075342,{"$f":"SUM(J18:J57)","v":0},null,null,0,{"$f":"SUM(N18:N57)","v":0},431.47685609075342,{"$f":"SUM(P18:P57)","v":0},43147.685609075343,{"$f":"SUM(R18:R57)","v":0}]
["Planned Returns Above Variable Costs:",null,null,null,null,null,null,null,1063.5231439092465,{"$f":"+J13-J58","v":0},null,null,0,{"$f":"+N13-N58","v":0},1063.5231439092465,{"$f":"+P13-P58","v":0},106352.31439092466,{"$f":"+R13-R58","v":0}]
[null,"Breakeven Price to Cover Variable Costs",null,null,null,null,66.381054783192837,{"$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",38.113750000000003,null,38.113750000000003,{"$f":"E64*H64","v":0},0,null,0,{"$f":"J64*L64","v":0},38.113750000000003,{"$f":"+J64-N64","v":0},3811.3750000000005,{"$f":"+J64*E$7","v":0}]
[null,null,"Irrigation Equipment",1,null,"Acre",18,null,18,0,0,null,0,{"$f":"J65*L65","v":0},18,0,1800,0]
[null,"Equipment Investment"]
[null,null,"Pickup/General Use Equipment",296.93124999999998,null,"Dollars",5.5E-2,null,16.331218749999998,{"$f":"E67*H67","v":0},0,null,0,{"$f":"J67*L67","v":0},16.331218749999998,{"$f":"+J67-N67","v":0},1633.1218749999998,{"$f":"+J67*E$7","v":0}]
[null,null,"Irrigation Equipment",525,null,"Dollars",5.5E-2,null,28.875,0,0,null,0,{"$f":"J68*L68","v":0},28.875,0,2887.5,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",85.66,null,85.66,0,0,null,0,0,85.66,0,8566,0]
[null,"Cash Rent - Irrigated Alfalfa",null,1,null,"Acre",90,null,90,0,0,null,0,0,90,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":"E76*H76","v":0},0,null,0,0,0,0,0,0]
["Total Fixed Costs",null,null,null,null,null,null,null,276.97996875000001,{"$f":"+SUM(J64:J76)","v":0},null,null,0,{"$f":"+SUM(N64:N76)","v":0},276.97996875000001,{"$f":"+SUM(P64:P76)","v":0},27697.996875000001,{"$f":"+SUM(R64:R76)","v":0}]
["Total Specified Costs",null,null,null,null,null,null,null,708.45682484075337,{"$f":"+J58+J77","v":0},null,null,0,{"$f":"+N58+N77","v":0},708.45682484075337,{"$f":"+P58+P77","v":0},70845.68248407534,{"$f":"+R58+R77","v":0}]
[]
["Returns Above Specified Costs",null,null,null,null,null,null,null,786.54317515924663,{"$f":"+J13-J78","v":0},null,null,0,{"$f":"+N13-N78","v":0},786.54317515924663,{"$f":"+P13-P78","v":0},78654.31751592466,{"$f":"+R13-R78","v":0}]
[]
["    Breakeven Price to Cover Total Costs",null,null,null,null,null,108.99335766780821,{"$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,88.508073044257117,null,null,145.32447689041095]
[null,0.9,5.8500000000000005,73.756727536880916,null,null,121.10373074200911]
[null,1,6.5,66.381054783192837,null,null,108.99335766780821]
[null,1.1000000000000001,7.15,60.346413439266207,null,null,99.084870607098367]
[null,1.25,8.125,53.104843826554266,null,null,87.194686134246567]
[]
["Francisco Abelló, Assistant Professor and Extension Specialist, Texas A&M AgriLife Extension, 940-647-3908"]
[]
["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":101,"n_cols":18,"rows_kept":101,"cut":false,"hidden":false,"merged":[[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"]
["2021 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,440,null,"Pound",0.74,null,325.60000000000002,{"$f":"E10*H10","v":0},0,null,0,{"$f":"J10*L10","v":0},325.60000000000002,{"$f":"+J10-N10","v":0},208384,{"$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,325.60000000000002,{"$f":"SUM(J10:J12)","v":0},null,null,0,{"$f":"SUM(N10:N12)","v":0},325.60000000000002,{"$f":"SUM(P10:P12)","v":0},208384,{"$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",4.5,null,4.5,{"$f":"E18*H18","v":0},0,null,0,{"$f":"J18*L18","v":0},4.5,{"$f":"+J18-N18","v":0},2880,{"$f":"+J18*E$7","v":0}]
[null,"","Custom Stripping",480,null,"Pound",0.12,null,57.599999999999994,0,0,null,0,0,57.599999999999994,0,36864,0]
[null,"Fertilizer"]
[null,"","Fertilizer (N)",57,null,"Pound",0.25,null,14.25,0,0,null,0,0,14.25,0,9120,0]
[null,"Herbicide"]
[null,"","Roundup",4,null,"Pint",1.875,null,7.5,0,0,null,0,0,7.5,0,4800,0]
[null,"","Prowl",64,null,"Ounces",0.51,null,32.64,0,0,null,0,0,32.64,0,20889.599999999999,0]
[null,"","Enlist Duo",4.7,null,"Pint",3.5150000000000001,null,16.520500000000002,0,0,null,0,0,16.520500000000002,0,10573.12,0]
[null,"","Liberty",29,null,"Ounce",0.39,null,11.31,0,0,null,0,0,11.31,0,7238.4000000000005,0]
[null,"","Harvest Aid - Prep",1,null,"Pint",3.75,null,3.75,0,0,null,0,0,3.75,0,2400,0]
[null,"","Harvest Aid -Def",1,null,"Ounce",0.546875,null,0.546875,0,0,null,0,0,0.546875,0,350,0]
[null,"","2,4D",1.5,null,"Pint",2.7475000000000001,null,4.1212499999999999,0,0,null,0,0,4.1212499999999999,0,2637.6,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,"","Prevathon",16,null,"Ounce",0.83,null,13.28,0,0,null,0,0,13.28,0,8499.1999999999989,0]
[null,"","Brigade",2,null,"Ounce",1.74875,null,3.4975000000000001,0,0,null,0,0,3.4975000000000001,0,2238.4,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",8,null,40,0,0,null,0,0,40,0,25600,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":"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,"Machinery Labor"]
[null,null,"Tractors/Self-Propelled",0.35,null,"Hour",14,null,4.8999999999999995,{"$f":"E42*H42","v":0},0,null,0,{"$f":"J42*L42","v":0},4.8999999999999995,{"$f":"+J42-N42","v":0},3135.9999999999995,{"$f":"+J42*E$7","v":0}]
[null,null,"Other Labor",0.42,null,"Hour",14,null,5.88,{"$f":"E43*H43","v":0},0,null,0,{"$f":"J43*L43","v":0},5.88,{"$f":"+J43-N43","v":0},3763.2,{"$f":"+J43*E$7","v":0}]
[]
[null,"Diesel Fuel"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0,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,null,"Tractors/Self-Propelled",5.98,null,"Gallon",1.4,null,8.3719999999999999,{"$f":"E47*H47","v":0},0,null,0,{"$f":"J47*L47","v":0},8.3719999999999999,{"$f":"+J47-N47","v":0},5358.08,{"$f":"+J47*E$7","v":0}]
[]
[null,"Gasoline"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",1.0546875,null,1.0546875,{"$f":"E50*H50","v":0},0,null,0,{"$f":"J50*L50","v":0},1.0546875,{"$f":"+J50-N50","v":0},675,{"$f":"+J50*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",0,null,"Gallon",2,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,"Repairs & Maintenance"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0.3515625,null,0.3515625,{"$f":"E54*H54","v":0},0,null,0,{"$f":"J54*L54","v":0},0.3515625,{"$f":"+J54-N54","v":0},225,{"$f":"+J54*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",16.230302974701122,null,16.230302974701122,0,0,null,0,0,16.230302974701122,0,10387.393903808717,0]
[null,null,"Implements",1,null,"Acre",6.9206151127916797,null,6.9206151127916797,0,0,null,0,0,6.9206151127916797,0,4429.193672186675,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,6.5000000000000002E-2,null,34.61467468301467,{"$f":"+SUM(J17:J59)/2*H60","v":0},null,null,0,{"$f":"+SUM(N17:N59)/2*L60","v":0},34.61467468301467,{"$f":"+SUM(P17:P59)/2*L60","v":0},22153.391797129389,{"$f":"+J60*E$7","v":0}]
["Total Variable Costs",null,null,null,null,null,null,null,306.43996777050745,{"$f":"SUM(J18:J60)","v":0},null,null,0,{"$f":"SUM(N18:N60)","v":0},306.43996777050745,{"$f":"SUM(P18:P60)","v":0},196121.57937312478,{"$f":"SUM(R18:R60)","v":0}]
["Planned Returns Above Variable Costs:",null,null,null,null,null,null,null,19.160032229492572,{"$f":"+J13-J61","v":0},null,null,0,{"$f":"+N13-N61","v":0},19.160032229492572,{"$f":"+P13-P61","v":0},12262.420626875217,{"$f":"+R13-R61","v":0}]
[null,"Breakeven Price to Cover Variable Costs",null,null,null,null,0.69645447220569878,{"$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.48808593750000001,null,0.48808593750000001,{"$f":"E67*H67","v":0},0,null,0,{"$f":"J67*L67","v":0},0.48808593750000001,{"$f":"+J67-N67","v":0},312.375,{"$f":"+J67*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",1,null,"Acre",21.005557510915416,null,21.005557510915416,0,0,null,0,{"$f":"J68*L68","v":0},21.005557510915416,0,13443.556806985867,0]
[null,null,"Implements",1,null,"Acre",9.2644159755610271,null,9.2644159755610271,0,0,null,0,{"$f":"J69*L69","v":0},9.2644159755610271,0,5929.2262243590576,0]
[null,"Equipment Investment"]
[null,null,"Pickup/General Use Equipment",3.4189453125,null,"Dollars",5.5E-2,null,0.18804199218750001,{"$f":"E71*H71","v":0},0,null,0,{"$f":"J71*L71","v":0},0.18804199218750001,{"$f":"+J71-N71","v":0},120.34687500000001,{"$f":"+J71*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",161.67269291873382,null,"Dollars",5.5E-2,null,8.8919981105303592,0,0,null,0,{"$f":"J72*L72","v":0},8.8919981105303592,0,5690.8787907394299,0]
[null,null,"Implements",39.63111278434441,null,"Dollars",5.5E-2,null,2.1797112031389427,0,0,null,0,{"$f":"J73*L73","v":0},2.1797112031389427,0,1395.0151700089234,0]
[null,"Salaried Labor",null,1,null,"Acre",0,null,0,0,0,null,0,{"$f":"J74*L74","v":0},0,{"$f":"+J74-N74","v":0},0,{"$f":"+J74*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",30,null,30,0,0,null,0,0,30,0,19200,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":"E81*H81","v":0},0,null,0,0,0,0,0,0]
["Total Fixed Costs",null,null,null,null,null,null,null,72.017810729833243,{"$f":"+SUM(J67:J81)","v":0},null,null,0,{"$f":"+SUM(N67:N81)","v":0},72.017810729833243,{"$f":"+SUM(P67:P81)","v":0},46091.398867093274,{"$f":"+SUM(R67:R81)","v":0}]
["Total Specified Costs",null,null,null,null,null,null,null,378.45777850034068,{"$f":"+J61+J82","v":0},null,null,0,{"$f":"+N61+N82","v":0},378.45777850034068,{"$f":"+P61+P82","v":0},242212.97824021807,{"$f":"+R61+R82","v":0}]
[]
["Returns Above Specified Costs",null,null,null,null,null,null,null,-52.857778500340658,{"$f":"+J13-J83","v":0},null,null,0,{"$f":"+N13-N83","v":0},-52.857778500340658,{"$f":"+P13-P83","v":0},-33828.978240218072,{"$f":"+R13-R83","v":0}]
[]
["    Breakeven Price to Cover Total Costs",null,null,null,null,null,0.86013131477350158,{"$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,330,0.92860596294093167,null,null,1.1468417530313353]
[null,0.9,396,0.77383830245077634,null,null,0.95570146085944618]
[null,1,440,0.69645447220569878,null,null,0.86013131477350158]
[null,1.1000000000000001,484.00000000000006,0.63314042927790792,null,null,0.78193755888500127]
[null,1.25,550,0.55716357776455905,null,null,0.68810505181880122]
[]
["Francisco Abelló, Assistant Professor and Extension Specialist, Texas A&M AgriLife Extension, 940-647-3908"]
[]
["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":"Red Till Irrig Cotton","index":7,"n_rows":107,"n_cols":18,"rows_kept":107,"cut":false,"hidden":false,"merged":[[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"]
["2021 Estimated Costs and Returns per Acre"]
["Cotton - Red Till Irrig "]
["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,1267,null,"Pound",0.74,null,937.58,{"$f":"E10*H10","v":0},0,null,0,{"$f":"J10*L10","v":0},937.58,{"$f":"+J10-N10","v":0},600051.20000000007,{"$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,937.58,{"$f":"SUM(J10:J12)","v":0},null,null,0,{"$f":"SUM(N10:N12)","v":0},937.58,{"$f":"SUM(P10:P12)","v":0},600051.20000000007,{"$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",4.5,null,4.5,{"$f":"E18*H18","v":0},0,null,0,{"$f":"J18*L18","v":0},4.5,{"$f":"+J18-N18","v":0},2880,{"$f":"+J18*E$7","v":0}]
[null,"","Custom Stripping",1267,null,"Pound",0.12,null,152.04,0,0,null,0,0,152.04,0,97305.599999999991,0]
[null,"Fertilizer"]
[null,"","Fertilizer (N)",100,null,"Pound",0.25,null,25,0,0,null,0,0,25,0,16000,0]
[null,"","Fertilizer (P)",50,null,"Pound",0.32500000000000001,null,16.25,0,0,null,0,0,16.25,0,10400,0]
[null,"Herbicide"]
[null,"","Roundup",4,null,"Pint",1.875,null,7.5,0,0,null,0,0,7.5,0,4800,0]
[null,"","Prowl",64,null,"Ounces",0.51,null,32.64,0,0,null,0,0,32.64,0,20889.599999999999,0]
[null,"","Enlist Duo",4.7,null,"Pint",3.5150000000000001,null,16.520500000000002,0,0,null,0,0,16.520500000000002,0,10573.12,0]
[null,"","Liberty",29,null,"Ounce",0.39,null,11.31,0,0,null,0,0,11.31,0,7238.4000000000005,0]
[null,"","Harvest Aid - Prep",1,null,"Pint",3.75,null,3.75,0,0,null,0,0,3.75,0,2400,0]
[null,"","Harvest Aid -Def",1,null,"Ounce",0.546875,null,0.546875,0,0,null,0,0,0.546875,0,350,0]
[null,"","2,4D",1.5,null,"Pint",2.7475000000000001,null,4.1212499999999999,0,0,null,0,0,4.1212499999999999,0,2637.6,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,"","Prevathon",16,null,"Ounce",0.83,null,13.28,0,0,null,0,0,13.28,0,8499.1999999999989,0]
[null,"","Brigade",2,null,"Ounce",1.74875,null,3.4975000000000001,0,0,null,0,0,3.4975000000000001,0,2238.4,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",11.5,null,"Pound",8,null,92,0,0,null,0,0,92,0,58880,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":"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,"Irrigation"]
[null,null,"Energy Cost",11.8,null,"AcreInch",4.5,null,53.1,{"$f":"E43*H43","v":0},0,null,0,{"$f":"J43*L43","v":0},53.1,{"$f":"+J43-N43","v":0},33984,{"$f":"+J43*E$7","v":0}]
[null,null,"Irrigation Labor",0.96,null,"Hour",14,null,13.44,0,0,null,0,0,13.44,0,8601.6,0]
[null,"Machinery Labor"]
[null,null,"Tractors/Self-Propelled",0.37,null,"Hour",14,null,5.18,{"$f":"E46*H46","v":0},0,null,0,{"$f":"J46*L46","v":0},5.18,{"$f":"+J46-N46","v":0},3315.2,{"$f":"+J46*E$7","v":0}]
[null,null,"Other Labor",0.45,null,"Hour",14,null,6.3,{"$f":"E47*H47","v":0},0,null,0,{"$f":"J47*L47","v":0},6.3,{"$f":"+J47-N47","v":0},4032,{"$f":"+J47*E$7","v":0}]
[]
[null,"Diesel Fuel"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0,null,0,{"$f":"E50*H50","v":0},0,null,0,{"$f":"J50*L50","v":0},0,{"$f":"+J50-N50","v":0},0,{"$f":"+J50*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",4.6399999999999997,null,"Gallon",1.4,null,6.4959999999999996,{"$f":"E51*H51","v":0},0,null,0,{"$f":"J51*L51","v":0},6.4959999999999996,{"$f":"+J51-N51","v":0},4157.4399999999996,{"$f":"+J51*E$7","v":0}]
[]
[null,"Gasoline"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",1.0546875,null,1.0546875,{"$f":"E54*H54","v":0},0,null,0,{"$f":"J54*L54","v":0},1.0546875,{"$f":"+J54-N54","v":0},675,{"$f":"+J54*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",0,null,"Gallon",2,null,0,{"$f":"E55*H55","v":0},0,null,0,{"$f":"J55*L55","v":0},0,{"$f":"+J55-N55","v":0},0,{"$f":"+J55*E$7","v":0}]
[]
[null,"Repairs & Maintenance"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0.3515625,null,0.3515625,{"$f":"E58*H58","v":0},0,null,0,{"$f":"J58*L58","v":0},0.3515625,{"$f":"+J58-N58","v":0},225,{"$f":"+J58*E$7","v":0}]
[null,null,"Irrigation Equipment",1,null,"Acre",13.113339999999999,null,13.113339999999999,0,0,null,0,0,13.113339999999999,0,8392.5375999999997,0]
[null,null,"Tractors/Self-Propelled",1,null,"Acre",12.362988753400922,null,12.362988753400922,0,0,null,0,0,12.362988753400922,0,7912.3128021765897,0]
[null,null,"Implements",1,null,"Acre",8.961917345039943,null,8.961917345039943,0,0,null,0,0,8.961917345039943,0,5735.6271008255635,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,6.5000000000000002E-2,null,12.927474961175026,{"$f":"+SUM(J17:J63)/2*H64","v":0},null,null,0,{"$f":"+SUM(N17:N63)/2*L64","v":0},12.927474961175026,{"$f":"+SUM(P17:P63)/2*L64","v":0},8273.5839751520161,{"$f":"+J64*E$7","v":0}]
["Total Variable Costs",null,null,null,null,null,null,null,534.84409605961582,{"$f":"SUM(J18:J64)","v":0},null,null,0,{"$f":"SUM(N18:N64)","v":0},534.84409605961582,{"$f":"SUM(P18:P64)","v":0},342300.22147815407,{"$f":"SUM(R18:R64)","v":0}]
["Planned Returns Above Variable Costs:",null,null,null,null,null,null,null,402.73590394038422,{"$f":"+J13-J65","v":0},null,null,0,{"$f":"+N13-N65","v":0},402.73590394038422,{"$f":"+P13-P65","v":0},257750.978521846,{"$f":"+R13-R65","v":0}]
[null,"Breakeven Price to Cover Variable Costs",null,null,null,null,0.42213425103363522,{"$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.48808593750000001,null,0.48808593750000001,{"$f":"E71*H71","v":0},0,null,0,{"$f":"J71*L71","v":0},0.48808593750000001,{"$f":"+J71-N71","v":0},312.375,{"$f":"+J71*E$7","v":0}]
[null,null,"Irrigation Equipment",1,null,"Acre",24.375,null,24.375,0,0,null,0,{"$f":"J72*L72","v":0},24.375,0,15600,0]
[null,null,"Tractors/Self-Propelled",1,null,"Acre",17.009332815571881,null,17.009332815571881,0,0,null,0,{"$f":"J73*L73","v":0},17.009332815571881,0,10885.973001966004,0]
[null,null,"Implements",1,null,"Acre",11.885442107616955,null,11.885442107616955,0,0,null,0,{"$f":"J74*L74","v":0},11.885442107616955,0,7606.6829488748508,0]
[null,"Equipment Investment"]
[null,null,"Pickup/General Use Equipment",3.4189453125,null,"Dollars",5.5E-2,null,0.18804199218750001,{"$f":"E76*H76","v":0},0,null,0,{"$f":"J76*L76","v":0},0.18804199218750001,{"$f":"+J76-N76","v":0},120.34687500000001,{"$f":"+J76*E$7","v":0}]
[null,null,"Irrigation Equipment",710.9375,null,"Dollars",5.5E-2,null,39.1015625,0,0,null,0,{"$f":"J77*L77","v":0},39.1015625,0,25025,0]
[null,null,"Tractors/Self-Propelled",130.54081343726722,null,"Dollars",5.5E-2,null,7.1797447390496973,0,0,null,0,{"$f":"J78*L78","v":0},7.1797447390496973,0,4595.0366329918061,0]
[null,null,"Implements",50.843280127028081,null,"Dollars",5.5E-2,null,2.7963804069865446,0,0,null,0,{"$f":"J79*L79","v":0},2.7963804069865446,0,1789.6834604713886,0]
[null,"Salaried Labor",null,1,null,"Acre",0,null,0,0,0,null,0,{"$f":"J80*L80","v":0},0,{"$f":"+J80-N80","v":0},0,{"$f":"+J80*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",90,null,90,0,0,null,0,0,90,0,57600,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":"E87*H87","v":0},0,null,0,0,0,0,0,0]
["Total Fixed Costs",null,null,null,null,null,null,null,193.0235904989126,{"$f":"+SUM(J71:J87)","v":0},null,null,0,{"$f":"+SUM(N71:N87)","v":0},193.0235904989126,{"$f":"+SUM(P71:P87)","v":0},123535.09791930405,{"$f":"+SUM(R71:R87)","v":0}]
["Total Specified Costs",null,null,null,null,null,null,null,727.86768655852848,{"$f":"+J65+J88","v":0},null,null,0,{"$f":"+N65+N88","v":0},727.86768655852848,{"$f":"+P65+P88","v":0},465835.31939745811,{"$f":"+R65+R88","v":0}]
[]
["Returns Above Specified Costs",null,null,null,null,null,null,null,209.71231344147157,{"$f":"+J13-J89","v":0},null,null,0,{"$f":"+N13-N89","v":0},209.71231344147157,{"$f":"+P13-P89","v":0},134215.88060254196,{"$f":"+R13-R89","v":0}]
[]
["    Breakeven Price to Cover Total Costs",null,null,null,null,null,0.57448120486071708,{"$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,950.25,0.56284566804484693,null,null,0.76597493981428932]
[null,0.9,1140.3,0.46903805670403914,null,null,0.63831244984524116]
[null,1,1267,0.42213425103363522,null,null,0.57448120486071708]
[null,1.1000000000000001,1393.7,0.38375841003057748,null,null,0.52225564078247]
[null,1.25,1583.75,0.3377074008269082,null,null,0.45958496388857362]
[]
["Francisco Abelló, Assistant Professor and Extension Specialist, Texas A&M AgriLife Extension, 940-647-3908"]
[]
["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":"Conv M Irrig Cotton","index":8,"n_rows":105,"n_cols":18,"rows_kept":105,"cut":false,"hidden":false,"merged":[[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"]
["2021 Estimated Costs and Returns per Acre"]
["Conventional Irrig 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",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,1312,null,"Pound",0.74,null,970.88,{"$f":"E10*H10","v":0},0,null,0,{"$f":"J10*L10","v":0},970.88,{"$f":"+J10-N10","v":0},621363.19999999995,{"$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,970.88,{"$f":"SUM(J10:J12)","v":0},null,null,0,{"$f":"SUM(N10:N12)","v":0},970.88,{"$f":"SUM(P10:P12)","v":0},621363.19999999995,{"$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",4.5,null,4.5,{"$f":"E18*H18","v":0},0,null,0,{"$f":"J18*L18","v":0},4.5,{"$f":"+J18-N18","v":0},2880,{"$f":"+J18*E$7","v":0}]
[null,"","Custom Stripping",1312,null,"Pound",0.12,null,157.44,0,0,null,0,0,157.44,0,100761.60000000001,0]
[null,"","Herbicide Application",4,null,"Acre",5.5,null,22,0,0,null,0,0,22,0,14080,0]
[null,"Fertilizer"]
[null,"","Fertilizer (N)",100,null,"Pound",0.25,null,25,0,0,null,0,0,25,0,16000,0]
[null,"","Fertilizer (P)",50,null,"Pound",0.32500000000000001,null,16.25,0,0,null,0,0,16.25,0,10400,0]
[null,"Herbicide"]
[null,"","Prowl",64,null,"Ounces",0.51,null,32.64,0,0,null,0,0,32.64,0,20889.599999999999,0]
[null,"","Enlist Duo",4.7,null,"Pint",3.5150000000000001,null,16.520500000000002,0,0,null,0,0,16.520500000000002,0,10573.12,0]
[null,"","Liberty",29,null,"Ounce",0.39,null,11.31,0,0,null,0,0,11.31,0,7238.4000000000005,0]
[null,"","Harvest Aid - Prep",1,null,"Pint",3.75,null,3.75,0,0,null,0,0,3.75,0,2400,0]
[null,"","Harvest Aid -Def",1,null,"Ounce",0.546875,null,0.546875,0,0,null,0,0,0.546875,0,350,0]
[null,"Insecticide"]
[null,"","Prevathon",16,null,"Ounce",0.83,null,13.28,0,0,null,0,0,13.28,0,8499.1999999999989,0]
[null,"","Brigade",2,null,"Ounce",1.74875,null,3.4975000000000001,0,0,null,0,0,3.4975000000000001,0,2238.4,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",11.5,null,"Pound",8,null,92,0,0,null,0,0,92,0,58880,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":"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,"Irrigation"]
[null,null,"Energy Cost",11.8,null,"AcreInch",4.5,null,53.1,{"$f":"E41*H41","v":0},0,null,0,{"$f":"J41*L41","v":0},53.1,{"$f":"+J41-N41","v":0},33984,{"$f":"+J41*E$7","v":0}]
[null,null,"Irrigation Labor",0.96,null,"Hour",14,null,13.44,0,0,null,0,0,13.44,0,8601.6,0]
[null,"Machinery Labor"]
[null,null,"Tractors/Self-Propelled",0.38,null,"Hour",14,null,5.32,{"$f":"E44*H44","v":0},0,null,0,{"$f":"J44*L44","v":0},5.32,{"$f":"+J44-N44","v":0},3404.8,{"$f":"+J44*E$7","v":0}]
[null,null,"Other Labor",0.46,null,"Hour",14,null,6.44,{"$f":"E45*H45","v":0},0,null,0,{"$f":"J45*L45","v":0},6.44,{"$f":"+J45-N45","v":0},4121.6000000000004,{"$f":"+J45*E$7","v":0}]
[]
[null,"Diesel Fuel"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0,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,null,"Tractors/Self-Propelled",4.6399999999999997,null,"Gallon",1.4,null,6.4959999999999996,{"$f":"E49*H49","v":0},0,null,0,{"$f":"J49*L49","v":0},6.4959999999999996,{"$f":"+J49-N49","v":0},4157.4399999999996,{"$f":"+J49*E$7","v":0}]
[]
[null,"Gasoline"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",1.0546875,null,1.0546875,{"$f":"E52*H52","v":0},0,null,0,{"$f":"J52*L52","v":0},1.0546875,{"$f":"+J52-N52","v":0},675,{"$f":"+J52*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",0,null,"Gallon",2,null,0,{"$f":"E53*H53","v":0},0,null,0,{"$f":"J53*L53","v":0},0,{"$f":"+J53-N53","v":0},0,{"$f":"+J53*E$7","v":0}]
[]
[null,"Repairs & Maintenance"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0.3515625,null,0.3515625,{"$f":"E56*H56","v":0},0,null,0,{"$f":"J56*L56","v":0},0.3515625,{"$f":"+J56-N56","v":0},225,{"$f":"+J56*E$7","v":0}]
[null,null,"Irrigation Equipment",1,null,"Acre",13.113339999999999,null,13.113339999999999,0,0,null,0,0,13.113339999999999,0,8392.5375999999997,0]
[null,null,"Tractors/Self-Propelled",1,null,"Acre",13.351506354325773,null,13.351506354325773,0,0,null,0,0,13.351506354325773,0,8544.9640667684944,0]
[null,null,"Implements",1,null,"Acre",12.449167013718727,null,12.449167013718727,0,0,null,0,0,12.449167013718727,0,7967.4668887799853,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,6.5000000000000002E-2,null,18.416979385132883,{"$f":"+SUM(J17:J61)/2*H62","v":0},null,null,0,{"$f":"+SUM(N17:N61)/2*L62","v":0},18.416979385132883,{"$f":"+SUM(P17:P61)/2*L62","v":0},11786.866806485046,{"$f":"+J62*E$7","v":0}]
["Total Variable Costs",null,null,null,null,null,null,null,557.26811775317742,{"$f":"SUM(J18:J62)","v":0},null,null,0,{"$f":"SUM(N18:N62)","v":0},557.26811775317742,{"$f":"SUM(P18:P62)","v":0},356651.59536203346,{"$f":"SUM(R18:R62)","v":0}]
["Planned Returns Above Variable Costs:",null,null,null,null,null,null,null,413.61188224682257,{"$f":"+J13-J63","v":0},null,null,0,{"$f":"+N13-N63","v":0},413.61188224682257,{"$f":"+P13-P63","v":0},264711.60463796649,{"$f":"+R13-R63","v":0}]
[null,"Breakeven Price to Cover Variable Costs",null,null,null,null,0.42474704097040961,{"$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.48808593750000001,null,0.48808593750000001,{"$f":"E69*H69","v":0},0,null,0,{"$f":"J69*L69","v":0},0.48808593750000001,{"$f":"+J69-N69","v":0},312.375,{"$f":"+J69*E$7","v":0}]
[null,null,"Irrigation Equipment",1,null,"Acre",24.375,null,24.375,0,0,null,0,{"$f":"J70*L70","v":0},24.375,0,15600,0]
[null,null,"Tractors/Self-Propelled",1,null,"Acre",13.796556566136635,null,13.796556566136635,0,0,null,0,{"$f":"J71*L71","v":0},13.796556566136635,0,8829.7962023274467,0]
[null,null,"Implements",1,null,"Acre",15.808597984880587,null,15.808597984880587,0,0,null,0,{"$f":"J72*L72","v":0},15.808597984880587,0,10117.502710323575,0]
[null,"Equipment Investment"]
[null,null,"Pickup/General Use Equipment",3.4189453125,null,"Dollars",5.5E-2,null,0.18804199218750001,{"$f":"E74*H74","v":0},0,null,0,{"$f":"J74*L74","v":0},0.18804199218750001,{"$f":"+J74-N74","v":0},120.34687500000001,{"$f":"+J74*E$7","v":0}]
[null,null,"Irrigation Equipment",710.9375,null,"Dollars",5.5E-2,null,39.1015625,0,0,null,0,{"$f":"J75*L75","v":0},39.1015625,0,25025,0]
[null,null,"Tractors/Self-Propelled",107.47962615232248,null,"Dollars",5.5E-2,null,5.9113794383777369,0,0,null,0,{"$f":"J76*L76","v":0},5.9113794383777369,0,3783.2828405617515,0]
[null,null,"Implements",67.625669157544735,null,"Dollars",5.5E-2,null,3.7194118036649604,0,0,null,0,{"$f":"J77*L77","v":0},3.7194118036649604,0,2380.4235543455748,0]
[null,"Salaried Labor",null,1,null,"Acre",0,null,0,0,0,null,0,{"$f":"J78*L78","v":0},0,{"$f":"+J78-N78","v":0},0,{"$f":"+J78*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",90,null,90,0,0,null,0,0,90,0,57600,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":"E85*H85","v":0},0,null,0,0,0,0,0,0]
["Total Fixed Costs",null,null,null,null,null,null,null,193.38863622274741,{"$f":"+SUM(J69:J85)","v":0},null,null,0,{"$f":"+SUM(N69:N85)","v":0},193.38863622274741,{"$f":"+SUM(P69:P85)","v":0},123768.72718255836,{"$f":"+SUM(R69:R85)","v":0}]
["Total Specified Costs",null,null,null,null,null,null,null,750.65675397592486,{"$f":"+J63+J86","v":0},null,null,0,{"$f":"+N63+N86","v":0},750.65675397592486,{"$f":"+P63+P86","v":0},480420.32254459185,{"$f":"+R63+R86","v":0}]
[]
["Returns Above Specified Costs",null,null,null,null,null,null,null,220.22324602407514,{"$f":"+J13-J87","v":0},null,null,0,{"$f":"+N13-N87","v":0},220.22324602407514,{"$f":"+P13-P87","v":0},140942.8774554081,{"$f":"+R13-R87","v":0}]
[]
["    Breakeven Price to Cover Total Costs",null,null,null,null,null,0.57214691614018665,{"$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,984,0.5663293879605461,null,null,0.76286255485358212]
[null,0.9,1180.8,0.47194115663378849,null,null,0.63571879571131851]
[null,1,1312,0.42474704097040961,null,null,0.57214691614018665]
[null,1.1000000000000001,1443.2,0.38613367360946327,null,null,0.52013356012744238]
[null,1.25,1640,0.33979763277632768,null,null,0.45771753291214928]
[]
["Francisco Abelló, Assistant Professor and Extension Specialist, Texas A&M AgriLife Extension, 940-647-3908"]
[]
["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":"No Till Dryland Cotton","index":9,"n_rows":102,"n_cols":18,"rows_kept":102,"cut":false,"hidden":false,"merged":[[89,3,89,8],[101,0,101,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"]
["2021 Estimated Costs and Returns per Acre"]
["Cotton - No Till Dryland "]
["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,440,null,"Pound",0.74,null,325.60000000000002,{"$f":"E10*H10","v":0},0,null,0,{"$f":"J10*L10","v":0},325.60000000000002,{"$f":"+J10-N10","v":0},208384,{"$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,325.60000000000002,{"$f":"SUM(J10:J12)","v":0},null,null,0,{"$f":"SUM(N10:N12)","v":0},325.60000000000002,{"$f":"SUM(P10:P12)","v":0},208384,{"$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",4.5,null,4.5,{"$f":"E18*H18","v":0},0,null,0,{"$f":"J18*L18","v":0},4.5,{"$f":"+J18-N18","v":0},2880,{"$f":"+J18*E$7","v":0}]
[null,"","Custom Stripping",480,null,"Pound",0.12,null,57.599999999999994,0,0,null,0,0,57.599999999999994,0,36864,0]
[null,"Fertilizer"]
[null,"","Fertilizer (N)",57,null,"Pound",0.25,null,14.25,0,0,null,0,0,14.25,0,9120,0]
[null,"Herbicide"]
[null,"","Roundup",4,null,"Pint",1.875,null,7.5,0,0,null,0,0,7.5,0,4800,0]
[null,"","Prowl",64,null,"Ounces",0.51,null,32.64,0,0,null,0,0,32.64,0,20889.599999999999,0]
[null,"","Enlist Duo",4.7,null,"Pint",3.5150000000000001,null,16.520500000000002,0,0,null,0,0,16.520500000000002,0,10573.12,0]
[null,"","Liberty",29,null,"Ounce",0.39,null,11.31,0,0,null,0,0,11.31,0,7238.4000000000005,0]
[null,"","Harvest Aid - Prep",1,null,"Pint",3.75,null,3.75,0,0,null,0,0,3.75,0,2400,0]
[null,"","Harvest Aid -Def",1,null,"Ounce",0.546875,null,0.546875,0,0,null,0,0,0.546875,0,350,0]
[null,"","2,4D",2.8,null,"Pint",2.7475000000000001,null,7.6929999999999996,0,0,null,0,0,7.6929999999999996,0,4923.5199999999995,0]
[null,"","Caparol",1.4,null,"Pint",3.75,null,5.25,0,0,null,0,0,5.25,0,3360,0]
[null,"","Dual Magnun",1.3,null,"Pint",12.75,null,16.574999999999999,0,0,null,0,0,16.574999999999999,0,10608,0]
[null,"Insecticide"]
[null,"","Prevathon",16,null,"Ounce",0.83,null,13.28,0,0,null,0,0,13.28,0,8499.1999999999989,0]
[null,"","Brigade",2,null,"Ounce",1.74875,null,3.4975000000000001,0,0,null,0,0,3.4975000000000001,0,2238.4,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",8,null,40,0,0,null,0,0,40,0,25600,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":"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,"Machinery Labor"]
[null,null,"Tractors/Self-Propelled",0.28000000000000003,null,"Hour",14,null,3.9200000000000004,{"$f":"E43*H43","v":0},0,null,0,{"$f":"J43*L43","v":0},3.9200000000000004,{"$f":"+J43-N43","v":0},2508.8000000000002,{"$f":"+J43*E$7","v":0}]
[null,null,"Other Labor",0.33,null,"Hour",14,null,4.62,{"$f":"E44*H44","v":0},0,null,0,{"$f":"J44*L44","v":0},4.62,{"$f":"+J44-N44","v":0},2956.8,{"$f":"+J44*E$7","v":0}]
[]
[null,"Diesel Fuel"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0,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,null,"Tractors/Self-Propelled",3.53,null,"Gallon",1.4,null,4.9419999999999993,{"$f":"E48*H48","v":0},0,null,0,{"$f":"J48*L48","v":0},4.9419999999999993,{"$f":"+J48-N48","v":0},3162.8799999999997,{"$f":"+J48*E$7","v":0}]
[]
[null,"Gasoline"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",1.0546875,null,1.0546875,{"$f":"E51*H51","v":0},0,null,0,{"$f":"J51*L51","v":0},1.0546875,{"$f":"+J51-N51","v":0},675,{"$f":"+J51*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",0,null,"Gallon",2,null,0,{"$f":"E52*H52","v":0},0,null,0,{"$f":"J52*L52","v":0},0,{"$f":"+J52-N52","v":0},0,{"$f":"+J52*E$7","v":0}]
[]
[null,"Repairs & Maintenance"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0.3515625,null,0.3515625,{"$f":"E55*H55","v":0},0,null,0,{"$f":"J55*L55","v":0},0.3515625,{"$f":"+J55-N55","v":0},225,{"$f":"+J55*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.9364165285067259,null,8.9364165285067259,0,0,null,0,0,8.9364165285067259,0,5719.3065782443045,0]
[null,null,"Implements",1,null,"Acre",2.8427765826146727,null,2.8427765826146727,0,0,null,0,0,2.8427765826146727,0,1819.3770128733904,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,6.5000000000000002E-2,null,8.0569059990517591,{"$f":"+SUM(J17:J60)/2*H61","v":0},null,null,0,{"$f":"+SUM(N17:N60)/2*L61","v":0},8.0569059990517591,{"$f":"+SUM(P17:P60)/2*L61","v":0},5156.4198393931256,{"$f":"+J61*E$7","v":0}]
["Total Variable Costs",null,null,null,null,null,null,null,284.63722411017318,{"$f":"SUM(J18:J61)","v":0},null,null,0,{"$f":"SUM(N18:N61)","v":0},284.63722411017318,{"$f":"SUM(P18:P61)","v":0},182167.82343051079,{"$f":"SUM(R18:R61)","v":0}]
["Planned Returns Above Variable Costs:",null,null,null,null,null,null,null,40.962775889826844,{"$f":"+J13-J62","v":0},null,null,0,{"$f":"+N13-N62","v":0},40.962775889826844,{"$f":"+P13-P62","v":0},26216.176569489209,{"$f":"+R13-R62","v":0}]
[null,"Breakeven Price to Cover Variable Costs",null,null,null,null,0.64690278206857543,{"$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.48808593750000001,null,0.48808593750000001,{"$f":"E68*H68","v":0},0,null,0,{"$f":"J68*L68","v":0},0.48808593750000001,{"$f":"+J68-N68","v":0},312.375,{"$f":"+J68*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",1,null,"Acre",14.174248922690811,null,14.174248922690811,0,0,null,0,{"$f":"J69*L69","v":0},14.174248922690811,0,9071.5193105221188,0]
[null,null,"Implements",1,null,"Acre",4.2297730169331498,null,4.2297730169331498,0,0,null,0,{"$f":"J70*L70","v":0},4.2297730169331498,0,2707.0547308372161,0]
[null,"Equipment Investment"]
[null,null,"Pickup/General Use Equipment",3.4189453125,null,"Dollars",5.5E-2,null,0.18804199218750001,{"$f":"E72*H72","v":0},0,null,0,{"$f":"J72*L72","v":0},0.18804199218750001,{"$f":"+J72-N72","v":0},120.34687500000001,{"$f":"+J72*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",108.12669935560056,null,"Dollars",5.5E-2,null,5.9469684645580312,0,0,null,0,{"$f":"J73*L73","v":0},5.9469684645580312,0,3806.0598173171402,0]
[null,null,"Implements",18.094029016880704,null,"Dollars",5.5E-2,null,0.99517159592843873,0,0,null,0,{"$f":"J74*L74","v":0},0.99517159592843873,0,636.90982139420078,0]
[null,"Salaried Labor",null,1,null,"Acre",0,null,0,0,0,null,0,{"$f":"J75*L75","v":0},0,{"$f":"+J75-N75","v":0},0,{"$f":"+J75*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",30,null,30,0,0,null,0,0,30,0,19200,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":"E82*H82","v":0},0,null,0,0,0,0,0,0]
["Total Fixed Costs",null,null,null,null,null,null,null,56.022289929797935,{"$f":"+SUM(J68:J82)","v":0},null,null,0,{"$f":"+SUM(N68:N82)","v":0},56.022289929797935,{"$f":"+SUM(P68:P82)","v":0},35854.26555507067,{"$f":"+SUM(R68:R82)","v":0}]
["Total Specified Costs",null,null,null,null,null,null,null,340.6595140399711,{"$f":"+J62+J83","v":0},null,null,0,{"$f":"+N62+N83","v":0},340.6595140399711,{"$f":"+P62+P83","v":0},218022.08898558147,{"$f":"+R62+R83","v":0}]
[]
["Returns Above Specified Costs",null,null,null,null,null,null,null,-15.059514039971077,{"$f":"+J13-J84","v":0},null,null,0,{"$f":"+N13-N84","v":0},-15.059514039971077,{"$f":"+P13-P84","v":0},-9638.0889855814748,{"$f":"+R13-R84","v":0}]
[]
["    Breakeven Price to Cover Total Costs",null,null,null,null,null,0.77422616827266155,{"$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,330,0.8625370427581005,null,null,1.0323015576968821]
[null,0.9,396,0.71878086896508375,null,null,0.86025129808073508]
[null,1,440,0.64690278206857543,null,null,0.77422616827266155]
[null,1.1000000000000001,484.00000000000006,0.58809343824415938,null,null,0.70384197115696501]
[null,1.25,550,0.51752222565486028,null,null,0.61938093461812926]
[]
["Francisco Abelló, Assistant Professor and Extension Specialist, Texas A&M AgriLife Extension, 940-647-3908"]
[]
["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":"NT Irrig M Cotton","index":10,"n_rows":108,"n_cols":18,"rows_kept":108,"cut":false,"hidden":false,"merged":[[95,3,95,8],[107,0,107,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"]
["2021 Estimated Costs and Returns per Acre"]
["Cotton - No-Till Irrigated"]
["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,1404,null,"Pound",0.74,null,1038.96,{"$f":"E10*H10","v":0},0,null,0,{"$f":"J10*L10","v":0},1038.96,{"$f":"+J10-N10","v":0},664934.40000000002,{"$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,1038.96,{"$f":"SUM(J10:J12)","v":0},null,null,0,{"$f":"SUM(N10:N12)","v":0},1038.96,{"$f":"SUM(P10:P12)","v":0},664934.40000000002,{"$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",4.5,null,4.5,{"$f":"E18*H18","v":0},0,null,0,{"$f":"J18*L18","v":0},4.5,{"$f":"+J18-N18","v":0},2880,{"$f":"+J18*E$7","v":0}]
[null,"","Custom Stripping",1404,null,"Pound",0.12,null,168.48,0,0,null,0,0,168.48,0,107827.2,0]
[null,"Fertilizer"]
[null,"","Fertilizer (N)",100,null,"Pound",0.25,null,25,0,0,null,0,0,25,0,16000,0]
[null,"","Fertilizer (P)",50,null,"Pound",0.32500000000000001,null,16.25,0,0,null,0,0,16.25,0,10400,0]
[null,"Herbicide"]
[null,"","Roundup",2,null,"Pint",1.875,null,3.75,0,0,null,0,0,3.75,0,2400,0]
[null,"","Prowl",64,null,"Ounces",0.51,null,32.64,0,0,null,0,0,32.64,0,20889.599999999999,0]
[null,"","Enlist Duo",4.7,null,"Pint",3.5150000000000001,null,16.520500000000002,0,0,null,0,0,16.520500000000002,0,10573.12,0]
[null,"","Liberty",29,null,"Ounce",0.39,null,11.31,0,0,null,0,0,11.31,0,7238.4000000000005,0]
[null,"","Harvest Aid - Prep",1,null,"Pint",3.75,null,3.75,0,0,null,0,0,3.75,0,2400,0]
[null,"","Harvest Aid -Def",1,null,"Ounce",0.546875,null,0.546875,0,0,null,0,0,0.546875,0,350,0]
[null,"","2,4D",1.4,null,"Pint",2.7475000000000001,null,3.8464999999999998,0,0,null,0,0,3.8464999999999998,0,2461.7599999999998,0]
[null,"","Caparol",1.4,null,"Pint",3.75,null,5.25,0,0,null,0,0,5.25,0,3360,0]
[null,"","Dual Magnun",1.3,null,"Pint",12.75,null,16.574999999999999,0,0,null,0,0,16.574999999999999,0,10608,0]
[null,"Insecticide"]
[null,"","Prevathon",16,null,"Ounce",0.83,null,13.28,0,0,null,0,0,13.28,0,8499.1999999999989,0]
[null,"","Brigade",2,null,"Ounce",1.74875,null,3.4975000000000001,0,0,null,0,0,3.4975000000000001,0,2238.4,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",11.5,null,"Pound",8,null,92,0,0,null,0,0,92,0,58880,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",11.8,null,"AcreInch",4.5,null,53.1,{"$f":"E44*H44","v":0},0,null,0,{"$f":"J44*L44","v":0},53.1,{"$f":"+J44-N44","v":0},33984,{"$f":"+J44*E$7","v":0}]
[null,null,"Irrigation Labor",0.96,null,"Hour",14,null,13.44,0,0,null,0,0,13.44,0,8601.6,0]
[null,"Machinery Labor"]
[null,null,"Tractors/Self-Propelled",0.27,null,"Hour",14,null,3.7800000000000002,{"$f":"E47*H47","v":0},0,null,0,{"$f":"J47*L47","v":0},3.7800000000000002,{"$f":"+J47-N47","v":0},2419.2000000000003,{"$f":"+J47*E$7","v":0}]
[null,null,"Other Labor",0.32,null,"Hour",14,null,4.4800000000000004,{"$f":"E48*H48","v":0},0,null,0,{"$f":"J48*L48","v":0},4.4800000000000004,{"$f":"+J48-N48","v":0},2867.2000000000003,{"$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",3.41,null,"Gallon",1.4,null,4.774,{"$f":"E52*H52","v":0},0,null,0,{"$f":"J52*L52","v":0},4.774,{"$f":"+J52-N52","v":0},3055.36,{"$f":"+J52*E$7","v":0}]
[]
[null,"Gasoline"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",1.0546875,null,1.0546875,{"$f":"E55*H55","v":0},0,null,0,{"$f":"J55*L55","v":0},1.0546875,{"$f":"+J55-N55","v":0},675,{"$f":"+J55*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",0,null,"Gallon",2,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",0.3515625,null,0.3515625,{"$f":"E59*H59","v":0},0,null,0,{"$f":"J59*L59","v":0},0.3515625,{"$f":"+J59-N59","v":0},225,{"$f":"+J59*E$7","v":0}]
[null,null,"Irrigation Equipment",1,null,"Acre",13.113339999999999,null,13.113339999999999,0,0,null,0,0,13.113339999999999,0,8392.5375999999997,0]
[null,null,"Tractors/Self-Propelled",1,null,"Acre",8.40897418151091,null,8.40897418151091,0,0,null,0,0,8.40897418151091,0,5381.7434761669829,0]
[null,null,"Implements",1,null,"Acre",6.3640601851851857,null,6.3640601851851857,0,0,null,0,0,6.3640601851851857,0,4072.9985185185187,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,6.5000000000000002E-2,null,14.61923329367054,{"$f":"+SUM(J17:J64)/2*H65","v":0},null,null,0,{"$f":"+SUM(N17:N64)/2*L65","v":0},14.61923329367054,{"$f":"+SUM(P17:P64)/2*L65","v":0},9356.3093079491446,{"$f":"+J65*E$7","v":0}]
["Total Variable Costs",null,null,null,null,null,null,null,555.68223266036659,{"$f":"SUM(J18:J65)","v":0},null,null,0,{"$f":"SUM(N18:N65)","v":0},555.68223266036659,{"$f":"SUM(P18:P65)","v":0},355636.62890263466,{"$f":"SUM(R18:R65)","v":0}]
["Planned Returns Above Variable Costs:",null,null,null,null,null,null,null,483.27776733963344,{"$f":"+J13-J66","v":0},null,null,0,{"$f":"+N13-N66","v":0},483.27776733963344,{"$f":"+P13-P66","v":0},309297.77109736536,{"$f":"+R13-R66","v":0}]
[null,"Breakeven Price to Cover Variable Costs",null,null,null,null,0.39578506599741209,{"$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.48808593750000001,null,0.48808593750000001,{"$f":"E72*H72","v":0},0,null,0,{"$f":"J72*L72","v":0},0.48808593750000001,{"$f":"+J72-N72","v":0},312.375,{"$f":"+J72*E$7","v":0}]
[null,null,"Irrigation Equipment",1,null,"Acre",24.375,null,24.375,0,0,null,0,{"$f":"J73*L73","v":0},24.375,0,15600,0]
[null,null,"Tractors/Self-Propelled",1,null,"Acre",12.923517757952201,null,12.923517757952201,0,0,null,0,{"$f":"J74*L74","v":0},12.923517757952201,0,8271.0513650894081,0]
[null,null,"Implements",1,null,"Acre",8.7571376488095254,null,8.7571376488095254,0,0,null,0,{"$f":"J75*L75","v":0},8.7571376488095254,0,5604.5680952380962,0]
[null,"Equipment Investment"]
[null,null,"Pickup/General Use Equipment",3.4189453125,null,"Dollars",5.5E-2,null,0.18804199218750001,{"$f":"E77*H77","v":0},0,null,0,{"$f":"J77*L77","v":0},0.18804199218750001,{"$f":"+J77-N77","v":0},120.34687500000001,{"$f":"+J77*E$7","v":0}]
[null,null,"Irrigation Equipment",710.9375,null,"Dollars",5.5E-2,null,39.1015625,0,0,null,0,{"$f":"J78*L78","v":0},39.1015625,0,25025,0]
[null,null,"Tractors/Self-Propelled",98.710996133552612,null,"Dollars",5.5E-2,null,5.4291047873453939,0,0,null,0,{"$f":"J79*L79","v":0},5.4291047873453939,0,3474.6270639010522,0]
[null,null,"Implements",37.461088831018529,null,"Dollars",5.5E-2,null,2.0603598857060192,0,0,null,0,{"$f":"J80*L80","v":0},2.0603598857060192,0,1318.6303268518523,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",90,null,90,0,0,null,0,0,90,0,57600,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,183.32281050950064,{"$f":"+SUM(J72:J88)","v":0},null,null,0,{"$f":"+SUM(N72:N88)","v":0},183.32281050950064,{"$f":"+SUM(P72:P88)","v":0},117326.59872608041,{"$f":"+SUM(R72:R88)","v":0}]
["Total Specified Costs",null,null,null,null,null,null,null,739.00504316986724,{"$f":"+J66+J89","v":0},null,null,0,{"$f":"+N66+N89","v":0},739.00504316986724,{"$f":"+P66+P89","v":0},472963.2276287151,{"$f":"+R66+R89","v":0}]
[]
["Returns Above Specified Costs",null,null,null,null,null,null,null,299.9549568301328,{"$f":"+J13-J90","v":0},null,null,0,{"$f":"+N13-N90","v":0},299.9549568301328,{"$f":"+P13-P90","v":0},191971.17237128492,{"$f":"+R13-R90","v":0}]
[]
["    Breakeven Price to Cover Total Costs",null,null,null,null,null,0.52635686835460627,{"$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,1053,0.52771342132988286,null,null,0.70180915780614173]
[null,0.9,1263.6000000000001,0.43976118444156898,null,null,0.58484096483845138]
[null,1,1404,0.39578506599741209,null,null,0.52635686835460627]
[null,1.1000000000000001,1544.4,0.35980460545219278,null,null,0.47850624395873298]
[null,1.25,1755,0.31662805279792966,null,null,0.42108549468368506]
[]
["Francisco Abelló, Assistant Professor and Extension Specialist, Texas A&M AgriLife Extension, 940-647-3908"]
[]
["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":"NT-CC2 Irr M Cotton","index":11,"n_rows":109,"n_cols":18,"rows_kept":109,"cut":false,"hidden":false,"merged":[[96,3,96,8],[108,0,108,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"]
["2021 Estimated Costs and Returns per Acre"]
["Cotton NT - Cover Crop Wheat Irrig"]
["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,1429,null,"Pound",0.74,null,1057.46,{"$f":"E10*H10","v":0},0,null,0,{"$f":"J10*L10","v":0},1057.46,{"$f":"+J10-N10","v":0},676774.40000000002,{"$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,1057.46,{"$f":"SUM(J10:J12)","v":0},null,null,0,{"$f":"SUM(N10:N12)","v":0},1057.46,{"$f":"SUM(P10:P12)","v":0},676774.40000000002,{"$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",4.5,null,4.5,{"$f":"E18*H18","v":0},0,null,0,{"$f":"J18*L18","v":0},4.5,{"$f":"+J18-N18","v":0},2880,{"$f":"+J18*E$7","v":0}]
[null,"","Custom Stripping",1429,null,"Pound",0.12,null,171.48,0,0,null,0,0,171.48,0,109747.2,0]
[null,"Fertilizer"]
[null,"","Fertilizer (N)",100,null,"Pound",0.25,null,25,0,0,null,0,0,25,0,16000,0]
[null,"","Fertilizer (P)",50,null,"Pound",0.32500000000000001,null,16.25,0,0,null,0,0,16.25,0,10400,0]
[null,"Herbicide"]
[null,"","Roundup",2,null,"Pint",1.875,null,3.75,0,0,null,0,0,3.75,0,2400,0]
[null,"","Prowl",64,null,"Ounces",0.51,null,32.64,0,0,null,0,0,32.64,0,20889.599999999999,0]
[null,"","Enlist Duo",4.7,null,"Pint",3.5150000000000001,null,16.520500000000002,0,0,null,0,0,16.520500000000002,0,10573.12,0]
[null,"","Liberty",29,null,"Ounce",0.39,null,11.31,0,0,null,0,0,11.31,0,7238.4000000000005,0]
[null,"","Harvest Aid - Prep",1,null,"Pint",3.75,null,3.75,0,0,null,0,0,3.75,0,2400,0]
[null,"","Harvest Aid -Def",1,null,"Ounce",0.546875,null,0.546875,0,0,null,0,0,0.546875,0,350,0]
[null,"","2,4D",1.4,null,"Pint",2.7475000000000001,null,3.8464999999999998,0,0,null,0,0,3.8464999999999998,0,2461.7599999999998,0]
[null,"","Caparol",1.4,null,"Pint",3.75,null,5.25,0,0,null,0,0,5.25,0,3360,0]
[null,"","Dual Magnun",1.3,null,"Pint",12.75,null,16.574999999999999,0,0,null,0,0,16.574999999999999,0,10608,0]
[null,"Insecticide"]
[null,"","Prevathon",16,null,"Ounce",0.83,null,13.28,0,0,null,0,0,13.28,0,8499.1999999999989,0]
[null,"","Brigade",2,null,"Ounce",1.74875,null,3.4975000000000001,0,0,null,0,0,3.4975000000000001,0,2238.4,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",11.5,null,"Pound",8,null,92,0,0,null,0,0,92,0,58880,0]
[null,"","Wheat Seed",60,null,"Pound",0.15,null,9,0,0,null,0,0,9,0,5760,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":"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,"Irrigation"]
[null,null,"Energy Cost",11.8,null,"AcreInch",4.5,null,53.1,{"$f":"E45*H45","v":0},0,null,0,{"$f":"J45*L45","v":0},53.1,{"$f":"+J45-N45","v":0},33984,{"$f":"+J45*E$7","v":0}]
[null,null,"Irrigation Labor",0.96,null,"Hour",14,null,13.44,0,0,null,0,0,13.44,0,8601.6,0]
[null,"Machinery Labor"]
[null,null,"Tractors/Self-Propelled",0.33,null,"Hour",14,null,4.62,{"$f":"E48*H48","v":0},0,null,0,{"$f":"J48*L48","v":0},4.62,{"$f":"+J48-N48","v":0},2956.8,{"$f":"+J48*E$7","v":0}]
[null,null,"Other Labor",0.4,null,"Hour",14,null,5.6000000000000005,{"$f":"E49*H49","v":0},0,null,0,{"$f":"J49*L49","v":0},5.6000000000000005,{"$f":"+J49-N49","v":0},3584.0000000000005,{"$f":"+J49*E$7","v":0}]
[]
[null,"Diesel Fuel"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0,null,0,{"$f":"E52*H52","v":0},0,null,0,{"$f":"J52*L52","v":0},0,{"$f":"+J52-N52","v":0},0,{"$f":"+J52*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",4.1900000000000004,null,"Gallon",1.4,null,5.8660000000000005,{"$f":"E53*H53","v":0},0,null,0,{"$f":"J53*L53","v":0},5.8660000000000005,{"$f":"+J53-N53","v":0},3754.2400000000002,{"$f":"+J53*E$7","v":0}]
[]
[null,"Gasoline"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",1.0546875,null,1.0546875,{"$f":"E56*H56","v":0},0,null,0,{"$f":"J56*L56","v":0},1.0546875,{"$f":"+J56-N56","v":0},675,{"$f":"+J56*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",0,null,"Gallon",2,null,0,{"$f":"E57*H57","v":0},0,null,0,{"$f":"J57*L57","v":0},0,{"$f":"+J57-N57","v":0},0,{"$f":"+J57*E$7","v":0}]
[]
[null,"Repairs & Maintenance"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0.3515625,null,0.3515625,{"$f":"E60*H60","v":0},0,null,0,{"$f":"J60*L60","v":0},0.3515625,{"$f":"+J60-N60","v":0},225,{"$f":"+J60*E$7","v":0}]
[null,null,"Irrigation Equipment",1,null,"Acre",13.113339999999999,null,13.113339999999999,0,0,null,0,0,13.113339999999999,0,8392.5375999999997,0]
[null,null,"Tractors/Self-Propelled",1,null,"Acre",10.632882103895721,null,10.632882103895721,0,0,null,0,0,10.632882103895721,0,6805.0445464932618,0]
[null,null,"Implements",1,null,"Acre",15.891416795267492,null,15.891416795267492,0,0,null,0,0,15.891416795267492,0,10170.506748971195,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,6.5000000000000002E-2,null,15.035949639897591,{"$f":"+SUM(J17:J65)/2*H66","v":0},null,null,0,{"$f":"+SUM(N17:N65)/2*L66","v":0},15.035949639897591,{"$f":"+SUM(P17:P65)/2*L66","v":0},9623.0077695344589,{"$f":"+J66*E$7","v":0}]
["Total Variable Costs",null,null,null,null,null,null,null,582.90221353906065,{"$f":"SUM(J18:J66)","v":0},null,null,0,{"$f":"SUM(N18:N66)","v":0},582.90221353906065,{"$f":"SUM(P18:P66)","v":0},373057.41666499892,{"$f":"SUM(R18:R66)","v":0}]
["Planned Returns Above Variable Costs:",null,null,null,null,null,null,null,474.55778646093938,{"$f":"+J13-J67","v":0},null,null,0,{"$f":"+N13-N67","v":0},474.55778646093938,{"$f":"+P13-P67","v":0},303716.9833350011,{"$f":"+R13-R67","v":0}]
[null,"Breakeven Price to Cover Variable Costs",null,null,null,null,0.40790917672432514,{"$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.48808593750000001,null,0.48808593750000001,{"$f":"E73*H73","v":0},0,null,0,{"$f":"J73*L73","v":0},0.48808593750000001,{"$f":"+J73-N73","v":0},312.375,{"$f":"+J73*E$7","v":0}]
[null,null,"Irrigation Equipment",1,null,"Acre",24.375,null,24.375,0,0,null,0,{"$f":"J74*L74","v":0},24.375,0,15600,0]
[null,null,"Tractors/Self-Propelled",1,null,"Acre",15.221555944416505,null,15.221555944416505,0,0,null,0,{"$f":"J75*L75","v":0},15.221555944416505,0,9741.7958044265633,0]
[null,null,"Implements",1,null,"Acre",17.331758597883599,null,17.331758597883599,0,0,null,0,{"$f":"J76*L76","v":0},17.331758597883599,0,11092.325502645504,0]
[null,"Equipment Investment"]
[null,null,"Pickup/General Use Equipment",3.4189453125,null,"Dollars",5.5E-2,null,0.18804199218750001,{"$f":"E78*H78","v":0},0,null,0,{"$f":"J78*L78","v":0},0.18804199218750001,{"$f":"+J78-N78","v":0},120.34687500000001,{"$f":"+J78*E$7","v":0}]
[null,null,"Irrigation Equipment",710.9375,null,"Dollars",5.5E-2,null,39.1015625,0,0,null,0,{"$f":"J79*L79","v":0},39.1015625,0,25025,0]
[null,null,"Tractors/Self-Propelled",116.61345490875036,null,"Dollars",5.5E-2,null,6.4137400199812697,0,0,null,0,{"$f":"J80*L80","v":0},6.4137400199812697,0,4104.793612788013,0]
[null,null,"Implements",74.141411779835408,null,"Dollars",5.5E-2,null,4.0777776478909473,0,0,null,0,{"$f":"J81*L81","v":0},4.0777776478909473,0,2609.7776946502063,0]
[null,"Salaried Labor",null,1,null,"Acre",0,null,0,0,0,null,0,{"$f":"J82*L82","v":0},0,{"$f":"+J82-N82","v":0},0,{"$f":"+J82*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",90,null,90,0,0,null,0,0,90,0,57600,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":"E89*H89","v":0},0,null,0,0,0,0,0,0]
["Total Fixed Costs",null,null,null,null,null,null,null,197.19752263985981,{"$f":"+SUM(J73:J89)","v":0},null,null,0,{"$f":"+SUM(N73:N89)","v":0},197.19752263985981,{"$f":"+SUM(P73:P89)","v":0},126206.41448951029,{"$f":"+SUM(R73:R89)","v":0}]
["Total Specified Costs",null,null,null,null,null,null,null,780.09973617892047,{"$f":"+J67+J90","v":0},null,null,0,{"$f":"+N67+N90","v":0},780.09973617892047,{"$f":"+P67+P90","v":0},499263.83115450921,{"$f":"+R67+R90","v":0}]
[]
["Returns Above Specified Costs",null,null,null,null,null,null,null,277.36026382107957,{"$f":"+J13-J91","v":0},null,null,0,{"$f":"+N13-N91","v":0},277.36026382107957,{"$f":"+P13-P91","v":0},177510.56884549081,{"$f":"+R13-R91","v":0}]
[]
["    Breakeven Price to Cover Total Costs",null,null,null,null,null,0.54590604351219063,{"$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,1071.75,0.54387890229910019,null,null,0.72787472468292091]
[null,0.9,1286.1000000000001,0.45323241858258345,null,null,0.60656227056910073]
[null,1,1429,0.40790917672432514,null,null,0.54590604351219063]
[null,1.1000000000000001,1571.9,0.37082652429484103,null,null,0.49627822137471878]
[null,1.25,1786.25,0.32632734137946012,null,null,0.43672483480975255]
[]
["Francisco Abelló, Assistant Professor and Extension Specialist, Texas A&M AgriLife Extension, 940-647-3908"]
[]
["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":12,"n_rows":100,"n_cols":18,"rows_kept":100,"cut":false,"hidden":false,"merged":[[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"]
["2021 Estimated Costs and Returns per Acre"]
["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",470,null,940,{"$f":"E10*H10","v":0},0,null,0,{"$f":"J10*L10","v":0},940,{"$f":"+J10-N10","v":0},112800,{"$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,940,{"$f":"SUM(J10:J12)","v":0},null,null,0,{"$f":"SUM(N10:N12)","v":0},940,{"$f":"SUM(P10:P12)","v":0},112800,{"$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,"","Drying - Peanut",2,null,"Ton",20,null,40,{"$f":"E18*H18","v":0},0,null,0,{"$f":"J18*L18","v":0},40,{"$f":"+J18-N18","v":0},4800,{"$f":"+J18*E$7","v":0}]
[null,"","Fertilizer Application",1,null,"Acre",4.5,null,4.5,0,0,null,0,0,4.5,0,540,0]
[null,"Fertilizer"]
[null,"","Fertilizer (N)",80,null,"Pound",0.25,null,20,0,0,null,0,0,20,0,2400,0]
[null,"","Fertilizer (P)",50,null,"Pound",0.32500000000000001,null,16.25,0,0,null,0,0,16.25,0,1950,0]
[null,"Herbicide"]
[null,"","Prowl",1.5,null,"Ounces",0.51,null,0.76500000000000001,0,0,null,0,0,0.76500000000000001,0,91.8,0]
[null,"","Valor SX",2,null,"Ounce",3.875,null,7.75,0,0,null,0,0,7.75,0,930,0]
[null,"","Cobra",12.5,null,"Ounce",1.8968750000000001,null,23.7109375,0,0,null,0,0,23.7109375,0,2845.3125,0]
[null,"Seed"]
[null,"","Peanut Seed",90,null,"Pound",0.95,null,85.5,0,0,null,0,0,85.5,0,10260,0]
[null,"Fungicides"]
[null,"","Folicular Fungicide-Abound",24.5,null,"Ounce",1.4839843749999999,null,36.357617187499997,0,0,null,0,0,36.357617187499997,0,4362.9140625,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",4.5,null,85.274999999999977,{"$f":"E36*H36","v":0},0,null,0,{"$f":"J36*L36","v":0},85.274999999999977,{"$f":"+J36-N36","v":0},10232.999999999996,{"$f":"+J36*E$7","v":0}]
[null,null,"Irrigation Labor",1.2080000000000002,null,"Hour",14,null,16.912000000000003,0,0,null,0,0,16.912000000000003,0,2029.4400000000003,0]
[null,"Machinery Labor"]
[null,null,"Tractors/Self-Propelled",2.84,null,"Hour",14,null,39.76,{"$f":"E39*H39","v":0},0,null,0,{"$f":"J39*L39","v":0},39.76,{"$f":"+J39-N39","v":0},4771.2,{"$f":"+J39*E$7","v":0}]
[null,null,"Other Labor",3.41,null,"Hour",14,null,47.74,{"$f":"E40*H40","v":0},0,null,0,{"$f":"J40*L40","v":0},47.74,{"$f":"+J40-N40","v":0},5728.8,{"$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",37.090000000000003,null,"Gallon",1.4,null,51.926000000000002,{"$f":"E44*H44","v":0},0,null,0,{"$f":"J44*L44","v":0},51.926000000000002,{"$f":"+J44-N44","v":0},6231.12,{"$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,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",2.1250000000000004,null,2.1250000000000004,{"$f":"E51*H51","v":0},0,null,0,{"$f":"J51*L51","v":0},2.1250000000000004,{"$f":"+J51-N51","v":0},255.00000000000006,{"$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",37.120471678129022,null,37.120471678129022,0,0,null,0,0,37.120471678129022,0,4454.4566013754829,0]
[null,null,"Implements",1,null,"Acre",15.085980763845404,null,15.085980763845404,0,0,null,0,0,15.085980763845404,0,1810.3176916614484,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,6.5000000000000002E-2,null,16.504514698891434,{"$f":"+SUM(J17:J56)/2*H57","v":0},null,null,0,{"$f":"+SUM(N17:N56)/2*L57","v":0},16.504514698891434,{"$f":"+SUM(P17:P56)/2*L57","v":0},1980.5417638669721,{"$f":"+J57*E$7","v":0}]
["Total Variable Costs",null,null,null,null,null,null,null,575.67158682836578,{"$f":"SUM(J18:J57)","v":0},null,null,0,{"$f":"SUM(N18:N57)","v":0},575.67158682836578,{"$f":"SUM(P18:P57)","v":0},69080.590419403903,{"$f":"SUM(R18:R57)","v":0}]
["Planned Returns Above Variable Costs:",null,null,null,null,null,null,null,364.32841317163422,{"$f":"+J13-J58","v":0},null,null,0,{"$f":"+N13-N58","v":0},364.32841317163422,{"$f":"+P13-P58","v":0},43719.409580596097,{"$f":"+R13-R58","v":0}]
[null,"Breakeven Price to Cover Variable Costs",null,null,null,null,287.83579341418289,{"$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.9502083333333338,null,2.9502083333333338,{"$f":"E64*H64","v":0},0,null,0,{"$f":"J64*L64","v":0},2.9502083333333338,{"$f":"+J64-N64","v":0},354.02500000000003,{"$f":"+J64*E$7","v":0}]
[null,null,"Irrigation Equipment",1,null,"Acre",25.161290322580648,null,25.161290322580648,0,0,null,0,{"$f":"J65*L65","v":0},25.161290322580648,0,3019.3548387096776,0]
[null,null,"Tractors/Self-Propelled",1,null,"Acre",109.76257919535608,null,109.76257919535608,0,0,null,0,{"$f":"J66*L66","v":0},109.76257919535608,0,13171.50950344273,0]
[null,null,"Implements",1,null,"Acre",18.526231019428835,null,18.526231019428835,0,0,null,0,{"$f":"J67*L67","v":0},18.526231019428835,0,2223.14772233146,0]
[null,"Equipment Investment"]
[null,null,"Pickup/General Use Equipment",20.665624999999999,null,"Dollars",5.5E-2,null,1.1366093749999999,{"$f":"E69*H69","v":0},0,null,0,{"$f":"J69*L69","v":0},1.1366093749999999,{"$f":"+J69-N69","v":0},136.393125,{"$f":"+J69*E$7","v":0}]
[null,null,"Irrigation Equipment",733.87096774193549,null,"Dollars",5.5E-2,null,40.362903225806456,0,0,null,0,{"$f":"J70*L70","v":0},40.362903225806456,0,4843.5483870967746,0]
[null,null,"Tractors/Self-Propelled",821.90878445242129,null,"Dollars",5.5E-2,null,45.204983144883172,0,0,null,0,{"$f":"J71*L71","v":0},45.204983144883172,0,5424.5979773859808,0]
[null,null,"Implements",236.26645738558136,null,"Dollars",5.5E-2,null,12.994655156206974,0,0,null,0,{"$f":"J72*L72","v":0},12.994655156206974,0,1559.3586187448368,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",90,null,90,0,0,null,0,0,90,0,10800,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,346.09945977259554,{"$f":"+SUM(J64:J80)","v":0},null,null,0,{"$f":"+SUM(N64:N80)","v":0},346.09945977259554,{"$f":"+SUM(P64:P80)","v":0},41531.935172711463,{"$f":"+SUM(R64:R80)","v":0}]
["Total Specified Costs",null,null,null,null,null,null,null,921.77104660096131,{"$f":"+J58+J81","v":0},null,null,0,{"$f":"+N58+N81","v":0},921.77104660096131,{"$f":"+P58+P81","v":0},110612.52559211536,{"$f":"+R58+R81","v":0}]
[]
["Returns Above Specified Costs",null,null,null,null,null,null,null,18.228953399038687,{"$f":"+J13-J82","v":0},null,null,0,{"$f":"+N13-N82","v":0},18.228953399038687,{"$f":"+P13-P82","v":0},2187.4744078846416,{"$f":"+R13-R82","v":0}]
[]
["    Breakeven Price to Cover Total Costs",null,null,null,null,null,460.88552330048066,{"$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,383.78105788557718,null,null,614.51403106730754]
[null,0.9,1.8,319.81754823798099,null,null,512.09502588942291]
[null,1,2,287.83579341418289,null,null,460.88552330048066]
[null,1.1000000000000001,2.2000000000000002,261.66890310380262,null,null,418.98683936407326]
[null,1.25,2.5,230.26863473134631,null,null,368.70841864038454]
[]
["Francisco Abelló, Assistant Professor and Extension Specialist, Texas A&M AgriLife Extension, 940-647-3908"]
[]
["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":13,"n_rows":89,"n_cols":18,"rows_kept":89,"cut":false,"hidden":false,"merged":[[76,3,76,8],[88,0,88,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"]
["2021 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,25,null,"CWT",8,null,200,{"$f":"E10*H10","v":0},0,null,0,{"$f":"J10*L10","v":0},200,{"$f":"+J10-N10","v":0},128000,{"$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,200,{"$f":"SUM(J10:J12)","v":0},null,null,0,{"$f":"SUM(N10:N12)","v":0},200,{"$f":"SUM(P10:P12)","v":0},128000,{"$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.48,null,10.559999999999999,0,0,null,0,0,10.559999999999999,0,6758.4,0]
[null,"Miscellaneous"]
[null,"","Insurance - Grain Sorghum",1,null,"Acre",12,null,12,0,0,null,0,0,12,0,7680,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.68,null,"Hour",14,null,9.5200000000000014,{"$f":"E30*H30","v":0},0,null,0,{"$f":"J30*L30","v":0},9.5200000000000014,{"$f":"+J30-N30","v":0},6092.8000000000011,{"$f":"+J30*E$7","v":0}]
[null,null,"Other Labor",0.81,null,"Hour",14,null,11.34,{"$f":"E31*H31","v":0},0,null,0,{"$f":"J31*L31","v":0},11.34,{"$f":"+J31-N31","v":0},7257.6,{"$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",4.6100000000000003,null,"Gallon",1.4,null,6.4539999999999997,{"$f":"E35*H35","v":0},0,null,0,{"$f":"J35*L35","v":0},6.4539999999999997,{"$f":"+J35-N35","v":0},4130.5599999999995,{"$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,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.703125,null,0.703125,{"$f":"E42*H42","v":0},0,null,0,{"$f":"J42*L42","v":0},0.703125,{"$f":"+J42-N42","v":0},450,{"$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",9.4454547419408925,null,9.4454547419408925,0,0,null,0,0,9.4454547419408925,0,6045.0910348421712,0]
[null,null,"Implements",1,null,"Acre",9.3369593180141202,null,9.3369593180141202,0,0,null,0,0,9.3369593180141202,0,5975.6539635290374,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,6.5000000000000002E-2,null,2.0258686403353017,{"$f":"+SUM(J17:J47)/2*H48","v":0},null,null,0,{"$f":"+SUM(N17:N47)/2*L48","v":0},2.0258686403353017,{"$f":"+SUM(P17:P47)/2*L48","v":0},1296.5559298145931,{"$f":"+J48*E$7","v":0}]
["Total Variable Costs",null,null,null,null,null,null,null,109.11978270029032,{"$f":"SUM(J18:J48)","v":0},null,null,0,{"$f":"SUM(N18:N48)","v":0},109.11978270029032,{"$f":"SUM(P18:P48)","v":0},69836.660928185811,{"$f":"SUM(R18:R48)","v":0}]
["Planned Returns Above Variable Costs:",null,null,null,null,null,null,null,90.880217299709685,{"$f":"+J13-J49","v":0},null,null,0,{"$f":"+N13-N49","v":0},90.880217299709685,{"$f":"+P13-P49","v":0},58163.339071814189,{"$f":"+R13-R49","v":0}]
[null,"Breakeven Price to Cover Variable Costs",null,null,null,null,4.364791308011613,{"$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.97617187500000002,null,0.97617187500000002,{"$f":"E55*H55","v":0},0,null,0,{"$f":"J55*L55","v":0},0.97617187500000002,{"$f":"+J55-N55","v":0},624.75,{"$f":"+J55*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",1,null,"Acre",9.7603032333389219,null,9.7603032333389219,0,0,null,0,{"$f":"J56*L56","v":0},9.7603032333389219,0,6246.5940693369103,0]
[null,null,"Implements",1,null,"Acre",11.7592659003469,null,11.7592659003469,0,0,null,0,{"$f":"J57*L57","v":0},11.7592659003469,0,7525.9301762220166,0]
[null,"Equipment Investment"]
[null,null,"Pickup/General Use Equipment",6.837890625,null,"Dollars",5.5E-2,null,0.37608398437500001,{"$f":"E59*H59","v":0},0,null,0,{"$f":"J59*L59","v":0},0.37608398437500001,{"$f":"+J59-N59","v":0},240.69375000000002,{"$f":"+J59*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",76.035910672624183,null,"Dollars",5.5E-2,null,4.1819750869943304,0,0,null,0,{"$f":"J60*L60","v":0},4.1819750869943304,0,2676.4640556763716,0]
[null,null,"Implements",50.303526351483974,null,"Dollars",5.5E-2,null,2.7666939493316187,0,0,null,0,{"$f":"J61*L61","v":0},2.7666939493316187,0,1770.6841275722359,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",30,null,30,0,0,null,0,0,30,0,19200,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,59.820494029386772,{"$f":"+SUM(J55:J69)","v":0},null,null,0,{"$f":"+SUM(N55:N69)","v":0},59.820494029386772,{"$f":"+SUM(P55:P69)","v":0},38285.116178807541,{"$f":"+SUM(R55:R69)","v":0}]
["Total Specified Costs",null,null,null,null,null,null,null,168.94027672967709,{"$f":"+J49+J70","v":0},null,null,0,{"$f":"+N49+N70","v":0},168.94027672967709,{"$f":"+P49+P70","v":0},108121.77710699335,{"$f":"+R49+R70","v":0}]
[]
["Returns Above Specified Costs",null,null,null,null,null,null,null,31.059723270322905,{"$f":"+J13-J71","v":0},null,null,0,{"$f":"+N13-N71","v":0},31.059723270322905,{"$f":"+P13-P71","v":0},19878.222893006649,{"$f":"+R13-R71","v":0}]
[]
["    Breakeven Price to Cover Total Costs",null,null,null,null,null,6.7576110691870834,{"$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,18.75,5.8197217440154834,null,null,9.0101480922494446]
[null,0.9,22.5,4.8497681200129028,null,null,7.5084567435412044]
[null,1,25,4.364791308011613,null,null,6.7576110691870834]
[null,1.1000000000000001,27.500000000000004,3.9679920981923744,null,null,6.1432827901700753]
[null,1.25,31.25,3.4918330464092899,null,null,5.4060888553496671]
[]
["Francisco Abelló, Assistant Professor and Extension Specialist, Texas A&M AgriLife Extension, 940-647-3908"]
[]
["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":14,"n_rows":98,"n_cols":18,"rows_kept":98,"cut":false,"hidden":false,"merged":[[85,3,85,8],[97,0,97,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"]
["2021 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",6,null,180,{"$f":"E10*H10","v":0},0,null,0,{"$f":"J10*L10","v":0},180,{"$f":"+J10-N10","v":0},115200,{"$f":"+J10*E$7","v":0}]
[null,"Wheat Pasture",null,64,null,"Pound of Gain",0.55000000000000004,null,35.200000000000003,0,0,null,0,0,35.200000000000003,{"$f":"+J11-N11","v":0},22528,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,215.2,{"$f":"SUM(J10:J13)","v":0},null,null,0,{"$f":"SUM(N10:N13)","v":0},215.2,{"$f":"SUM(P10:P13)","v":0},137728,{"$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,"Seed"]
[null,"","Wheat Seed",70,null,"Pound",0.15,null,10.5,{"$f":"E19*H19","v":0},0,null,0,{"$f":"J19*L19","v":0},10.5,{"$f":"+J19-N19","v":0},6720,{"$f":"+J19*E$7","v":0}]
[null,"Fertilizer"]
[null,"","Fertilizer (N)",66,null,"Pound",0.25,null,16.5,0,0,null,0,0,16.5,0,10560,0]
[null,"","Fertilizer (P)",50,null,"Pound",0.32500000000000001,null,16.25,0,0,null,0,0,16.25,0,10400,0]
[null,"Custom"]
[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,"Herbicide"]
[null,"","Herbicide - Wheat",6.4,null,"Ounce",0.171875,null,1.1000000000000001,0,0,null,0,0,1.1000000000000001,0,704,0]
[null,"","2,4D",1.4,null,"Pint",2.7475000000000001,null,3.8464999999999998,0,0,null,0,0,3.8464999999999998,0,2461.7599999999998,0]
[null,"","Roundup",2,null,"Pint",1.875,null,3.75,0,0,null,0,0,3.75,0,2400,0]
[null,"Insecticide"]
[null,"","Insecticide & Application - Wheat",1,null,"Ounce",5.5,null,5.5,0,0,null,0,0,5.5,0,3520,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":"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,"Machinery Labor"]
[null,null,"Tractors/Self-Propelled",0.32,null,"Hour",14,null,4.4800000000000004,{"$f":"E39*H39","v":0},0,null,0,{"$f":"J39*L39","v":0},4.4800000000000004,{"$f":"+J39-N39","v":0},2867.2000000000003,{"$f":"+J39*E$7","v":0}]
[null,null,"Other Labor",0.38,null,"Hour",14,null,5.32,{"$f":"E40*H40","v":0},0,null,0,{"$f":"J40*L40","v":0},5.32,{"$f":"+J40-N40","v":0},3404.8,{"$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",1.68,null,"Gallon",1.4,null,2.3519999999999999,{"$f":"E44*H44","v":0},0,null,0,{"$f":"J44*L44","v":0},2.3519999999999999,{"$f":"+J44-N44","v":0},1505.28,{"$f":"+J44*E$7","v":0}]
[]
[null,"Gasoline"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",2.109375,null,2.109375,{"$f":"E47*H47","v":0},0,null,0,{"$f":"J47*L47","v":0},2.109375,{"$f":"+J47-N47","v":0},1350,{"$f":"+J47*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",0,null,"Gallon",2,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",0.703125,null,0.703125,{"$f":"E51*H51","v":0},0,null,0,{"$f":"J51*L51","v":0},0.703125,{"$f":"+J51-N51","v":0},450,{"$f":"+J51*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.7957723695295358,null,2.7957723695295358,0,0,null,0,0,2.7957723695295358,0,1789.2943164989028,0]
[null,null,"Implements",1,null,"Acre",4.6182834309070628,null,4.6182834309070628,0,0,null,0,0,4.6182834309070628,0,2955.7013957805202,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,6.5000000000000002E-2,null,3.5861304552835818,{"$f":"+SUM(J18:J56)/2*H57","v":0},null,null,0,{"$f":"+SUM(N18:N56)/2*L57","v":0},3.5861304552835818,{"$f":"+SUM(P18:P56)/2*L57","v":0},2295.1234913814924,{"$f":"+J57*E$7","v":0}]
["Total Variable Costs",null,null,null,null,null,null,null,129.01118625572019,{"$f":"SUM(J19:J57)","v":0},null,null,0,{"$f":"SUM(N19:N57)","v":0},129.01118625572019,{"$f":"SUM(P19:P57)","v":0},82567.159203660922,{"$f":"SUM(R19:R57)","v":0}]
["Planned Returns Above Variable Costs:",null,null,null,null,null,null,null,86.188813744279798,{"$f":"+J14-J58","v":0},null,null,0,{"$f":"+N14-N58","v":0},86.188813744279798,{"$f":"+P14-P58","v":0},55160.840796339078,{"$f":"+R14-R58","v":0}]
[null,"Breakeven Price to Cover Variable Costs",null,null,null,null,3.1270395418573398,{"$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.97617187500000002,null,0.97617187500000002,{"$f":"E64*H64","v":0},0,null,0,{"$f":"J64*L64","v":0},0.97617187500000002,{"$f":"+J64-N64","v":0},624.75,{"$f":"+J64*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",1,null,"Acre",4.1459728303617043,null,4.1459728303617043,0,0,null,0,{"$f":"J65*L65","v":0},4.1459728303617043,0,2653.4226114314906,0]
[null,null,"Implements",1,null,"Acre",5.9377929825947948,null,5.9377929825947948,0,0,null,0,{"$f":"J66*L66","v":0},5.9377929825947948,0,3800.1875088606685,0]
[null,"Equipment Investment"]
[null,null,"Pickup/General Use Equipment",6.837890625,null,"Dollars",5.5E-2,null,0.37608398437500001,{"$f":"E68*H68","v":0},0,null,0,{"$f":"J68*L68","v":0},0.37608398437500001,{"$f":"+J68-N68","v":0},240.69375000000002,{"$f":"+J68*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",31.642673733244401,null,"Dollars",5.5E-2,null,1.7403470553284421,0,0,null,0,{"$f":"J69*L69","v":0},1.7403470553284421,0,1113.822115410203,0]
[null,null,"Implements",25.400558869988853,null,"Dollars",5.5E-2,null,1.3970307378493869,0,0,null,0,{"$f":"J70*L70","v":0},1.3970307378493869,0,894.09967222360763,0]
[null,"Salaried Labor",null,1,null,"Acre",0,null,0,0,0,null,0,{"$f":"J71*L71","v":0},0,{"$f":"+J71-N71","v":0},0,{"$f":"+J71*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",30,null,30,0,0,null,0,0,30,0,19200,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":"E78*H78","v":0},0,null,0,0,0,0,0,0]
["Total Fixed Costs",null,null,null,null,null,null,null,44.573399465509326,{"$f":"+SUM(J64:J78)","v":0},null,null,0,{"$f":"+SUM(N64:N78)","v":0},44.573399465509326,{"$f":"+SUM(P64:P78)","v":0},28526.97565792597,{"$f":"+SUM(R64:R78)","v":0}]
["Total Specified Costs",null,null,null,null,null,null,null,173.58458572122953,{"$f":"+J58+J79","v":0},null,null,0,{"$f":"+N58+N79","v":0},173.58458572122953,{"$f":"+P58+P79","v":0},111094.13486158689,{"$f":"+R58+R79","v":0}]
[]
["Returns Above Specified Costs",null,null,null,null,null,null,null,41.615414278770459,{"$f":"+J14-J80","v":0},null,null,0,{"$f":"+N14-N80","v":0},41.615414278770459,{"$f":"+P14-P80","v":0},26633.865138413108,{"$f":"+R14-R80","v":0}]
[]
["    Breakeven Price to Cover Total Costs",null,null,null,null,null,4.6128195240409848,{"$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,4.1693860558097864,null,null,6.1504260320546464]
[null,0.9,27,3.4744883798414885,null,null,5.1253550267122057]
[null,1,30,3.1270395418573398,null,null,4.6128195240409848]
[null,1.1000000000000001,33,2.8427632198703088,null,null,4.1934722945827136]
[null,1.25,37.5,2.5016316334858715,null,null,3.6902556192327878]
[]
["Francisco Abelló, Assistant Professor and Extension Specialist, Texas A&M AgriLife Extension, 940-647-3908"]
[]
["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":15,"n_rows":85,"n_cols":18,"rows_kept":85,"cut":false,"hidden":false,"merged":[[72,3,72,8],[84,0,84,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"]
["2021 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.25,null,12.5,{"$f":"E18*H18","v":0},0,null,0,{"$f":"J18*L18","v":0},12.5,{"$f":"+J18-N18","v":0},8000,{"$f":"+J18*E$7","v":0}]
[null,"Seed"]
[null,"","Triticale",80,null,"Pound",0.63,null,50.4,0,0,null,0,0,50.4,0,32256,0]
[null,"Herbicide"]
[null,"","Roundup",2,null,"Pint",1.875,null,3.75,0,0,null,0,0,3.75,0,2400,0]
[null,"","2,4D",1.4,null,"Pint",2.7475000000000001,null,3.8464999999999998,0,0,null,0,0,3.8464999999999998,0,2461.7599999999998,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":"E26*H26","v":0},0,null,0,{"$f":"J26*L26","v":0},0,{"$f":"+J26-N26","v":0},0,{"$f":"+J26*E$7","v":0}]
[null,"Machinery Labor"]
[null,null,"Tractors/Self-Propelled",0.34,null,"Hour",14,null,4.7600000000000007,{"$f":"E28*H28","v":0},0,null,0,{"$f":"J28*L28","v":0},4.7600000000000007,{"$f":"+J28-N28","v":0},3046.4000000000005,{"$f":"+J28*E$7","v":0}]
[null,null,"Other Labor",0.41,null,"Hour",14,null,5.7399999999999993,{"$f":"E29*H29","v":0},0,null,0,{"$f":"J29*L29","v":0},5.7399999999999993,{"$f":"+J29-N29","v":0},3673.5999999999995,{"$f":"+J29*E$7","v":0}]
[]
[null,"Diesel Fuel"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0,null,0,{"$f":"E32*H32","v":0},0,null,0,{"$f":"J32*L32","v":0},0,{"$f":"+J32-N32","v":0},0,{"$f":"+J32*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",2.41,null,"Gallon",1.4,null,3.3740000000000001,{"$f":"E33*H33","v":0},0,null,0,{"$f":"J33*L33","v":0},3.3740000000000001,{"$f":"+J33-N33","v":0},2159.36,{"$f":"+J33*E$7","v":0}]
[]
[null,"Gasoline"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",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,null,"Tractors/Self-Propelled",0,null,"Gallon",2,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,"Repairs & Maintenance"]
[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,"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",4.8204202842304831,null,4.8204202842304831,0,0,null,0,0,4.8204202842304831,0,3085.0689819075092,0]
[null,null,"Implements",1,null,"Acre",4.523425580749115,null,4.523425580749115,0,0,null,0,0,4.523425580749115,0,2894.9923716794337,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,6.5000000000000002E-2,null,0.4663755405936128,{"$f":"+SUM(J17:J45)/2*H46","v":0},null,null,0,{"$f":"+SUM(N17:N45)/2*L46","v":0},0.4663755405936128,{"$f":"+SUM(P17:P45)/2*L46","v":0},298.48034597991222,{"$f":"+J46*E$7","v":0}]
["Total Variable Costs",null,null,null,null,null,null,null,94.180721405573223,{"$f":"SUM(J18:J46)","v":0},null,null,0,{"$f":"SUM(N18:N46)","v":0},94.180721405573223,{"$f":"SUM(P18:P46)","v":0},60275.661699566866,{"$f":"SUM(R18:R46)","v":0}]
["Planned Returns Above Variable Costs:",null,null,null,null,null,null,null,-94.180721405573223,{"$f":"+J13-J47","v":0},null,null,0,{"$f":"+N13-N47","v":0},-94.180721405573223,{"$f":"+P13-P47","v":0},-60275.661699566866,{"$f":"+R13-R47","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",5.6868083665477638,null,5.6868083665477638,{"$f":"E53*H53","v":0},0,null,0,{"$f":"J53*L53","v":0},5.6868083665477638,{"$f":"+J53-N53","v":0},3639.557354590569,{"$f":"+J53*E$7","v":0}]
[null,null,"Implements",1,null,"Acre",5.6075405950777313,null,5.6075405950777313,0,0,null,0,{"$f":"J54*L54","v":0},5.6075405950777313,0,3588.8259808497478,0]
[null,"Equipment Investment"]
[null,null,"Tractors/Self-Propelled",43.974175616787008,null,"Dollars",5.5E-2,null,2.4185796589232855,{"$f":"E56*H56","v":0},0,null,0,{"$f":"J56*L56","v":0},2.4185796589232855,{"$f":"+J56-N56","v":0},1547.8909817109027,{"$f":"+J56*E$7","v":0}]
[null,null,"Implements",23.987812545610304,null,"Dollars",5.5E-2,null,1.3193296900085667,0,0,null,0,{"$f":"J57*L57","v":0},1.3193296900085667,0,844.37100160548266,0]
[null,"Salaried Labor",null,1,null,"Acre",0,null,0,0,0,null,0,{"$f":"J58*L58","v":0},0,{"$f":"+J58-N58","v":0},0,{"$f":"+J58*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",30,null,30,0,0,null,0,0,30,0,19200,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":"E65*H65","v":0},0,null,0,0,0,0,0,0]
["Total Fixed Costs",null,null,null,null,null,null,null,45.032258310557346,{"$f":"+SUM(J53:J65)","v":0},null,null,0,{"$f":"+SUM(N53:N65)","v":0},45.032258310557346,{"$f":"+SUM(P53:P65)","v":0},28820.645318756702,{"$f":"+SUM(R53:R65)","v":0}]
["Total Specified Costs",null,null,null,null,null,null,null,139.21297971613058,{"$f":"+J47+J66","v":0},null,null,0,{"$f":"+N47+N66","v":0},139.21297971613058,{"$f":"+P47+P66","v":0},89096.307018323569,{"$f":"+R47+R66","v":0}]
[]
["Returns Above Specified Costs",null,null,null,null,null,null,null,-139.21297971613058,{"$f":"+J13-J67","v":0},null,null,0,{"$f":"+N13-N67","v":0},-139.21297971613058,{"$f":"+P13-P67","v":0},-89096.307018323569,{"$f":"+R13-R67","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]
[]
["Francisco Abelló, Assistant Professor and Extension Specialist, Texas A&M AgriLife Extension, 940-647-3908"]
[]
["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":16,"n_rows":85,"n_cols":14,"rows_kept":85,"cut":false,"hidden":false,"merged":[[71,7,71,8],[71,10,71,12],[0,0,0,13],[1,0,1,13],[2,0,2,13],[3,0,3,13],[70,2,70,12],[72,7,72,8],[72,10,72,12],[73,7,73,8],[73,10,73,12],[74,7,74,8],[74,10,74,12],[75,7,75,8],[75,10,75,12],[76,7,76,8],[76,10,76,12],[84,0,84,13]]}
["Projections for Planning Purposes Only -- Not to be Used without Updating"]
["2021 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.44,null,5.56,null,"CWT",160,null,391.42399999999998,{"$f":"+E11*G11*J11","v":0},156569.59999999998,{"$f":"+L11*E$7","v":0}]
[null,"Heifer",null,0.24,null,5.14,null,"CWT",150,null,185.03999999999996,{"$f":"+E12*G12*J12","v":0},74015.999999999985,{"$f":"+L12*E$7","v":0}]
[null,"Cull Cow",null,0.15,null,11,null,"CWT",55,null,90.75,0,36300,0]
[null,"Cull Bull",null,9.0000000000000011E-3,null,16.5,null,"CWT",60,null,8.9100000000000019,0,3564.0000000000009,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,368,null,null,null,null,676.12399999999991,{"$f":"+SUM(L11:L16)","v":0},270449.59999999998,{"$f":"+SUM(N11:N16)","v":0}]
[null,null,null,null,null,547.85]
[null,null,null,null,null,179.85000000000002,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,"Brush Control",null,null,1,null,"AU",12,null,12,{"$f":"+J23*G23","v":0},4800,{"$f":"+L23*E$7","v":0}]
[null,null,"Ranch Repairs",null,null,1,null,"AU",16.25,null,16.25,0,6500,0]
[null,null,null,null,null,1,null,null,0,null,0,0,0,0]
[null,null,null,null,null,1,null,null,0,null,0,0,0,0]
[null,"Marketing Expense",null,null,null,1,null,"AU",14.361479999999998,null,14.361479999999998,0,5744.5919999999996,0]
[null,"Feed"]
[null,null,"Supplement",null,null,396,null,"Pound",0.19600000000000001,null,77.616,{"$f":"+J29*G29","v":0},31046.400000000001,{"$f":"+L29*E$7","v":0}]
[null,null,"Salt and Mineral",null,null,30,null,"Pound",0.45,null,13.5,0,5400,0]
[null,null,"Hay",null,null,1584,null,"Pound",0.09,null,142.56,0,57024,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":"+J36*G36","v":0},12800,{"$f":"+L36*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.728449999999995,null,36.728449999999995,0,14691.379999999997,0]
[null,"Lube (As a % of fuel)",null,null,null,0.1,null,"Percent",36.728449999999995,null,3.6728449999999997,0,1469.1379999999999,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":"+J45*G45","v":0},0,0]
[null,"Purchase Breeding Female",null,null,null,1,null,null,0,null,0,0,0,0]
[null,"Purchase Breeding Male",null,null,null,1,null,null,0,null,0,0,0,0]
[null,"Purchase Older Repalcement Female",null,null,null,1,null,null,0,null,0,0,0,0]
[null,"Purchase Younger Repalcement Female",null,null,null,1,null,null,0,null,0,0,0,0]
[null,"Interest on Credit Line",null,null,null,null,null,null,6.5000000000000002E-2,null,23.117292143150692,{"$f":"+SUM(L21:L49)/2*J50","v":0},9246.9168572602775,0]
["Total Variable Costs",null,null,null,null,null,null,null,null,null,389.3060671431507,{"$f":"+SUM(L23:L50)","v":0},155722.42685726029,{"$f":"+SUM(N23:N50)","v":0}]
[]
["Planned Returns Above Variable Costs:",null,null,null,null,null,null,null,null,null,286.81793285684921,{"$f":"+L17-L51","v":0},114727.17314273969,{"$f":"+N17-N51","v":0}]
[null,"Average Calf Breakeven Price to Cover Variable Costs",null,null,null,null,null,null,78.708170419334451,{"$f":"IF((E11*G11+E12*G12)=0,\"n/a\",(L51-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",70.007166666666677,null,70.007166666666677,{"$f":"+G57*J57","v":0},28002.866666666672,{"$f":"+L57*E$7","v":0}]
[null,"Depreciation - Livestock",null,null,null,1,null,"AU",62.966250000000002,null,62.966250000000002,0,25186.5,0]
[null,"Equipment Investment",null,null,null,873.04250000000002,null,"dollars",5.5E-2,null,48.017337500000004,0,19206.935000000001,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",100,null,100,{"$f":"+J61*G61","v":0},40000,0]
[null,"Salaried Labor",null,null,null,1,null,"AU",37.5,null,37.5,{"$f":"+J62*G62","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":"+G64*J64","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,487.24075416666665,{"$f":"+SUM(L57:L63)","v":0},194896.30166666667,{"$f":"+SUM(N57:N63)","v":0}]
["Total Costs",null,null,null,null,null,null,null,null,null,876.54682130981735,{"$f":"+L51+L66","v":0},350618.72852392693,{"$f":"+N51+N66","v":0}]
["Planned Returns to Management, Risk, and Profit:",null,null,null,null,null,null,null,null,null,-200.42282130981744,{"$f":"+L17-L67","v":0},-80169.128523926949,{"$f":"+N17-N67","v":0}]
[null,"Average Calf Breakeven Price to Cover Total Costs",null,null,null,null,null,null,211.11054926897214,{"$f":"IF((E11*G11+E12*G12)=0,\"n/a\",(L67-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.94000000000000006,715.42836363636366,null,572.94090909090914,null,627.77828725614495,null,null,197.63540782627175]
[null,null,0.91,695.77618181818173,null,560.39545454545464,null,652.55900912151901,null,null,204.15086083153344]
[null,null,0.88,676.12399999999991,null,547.85,null,679.37650264706099,null,null,211.11054926897214]
[null,null,0.85,656.47181818181809,null,535.3045454545454,null,708.49263847479222,null,null,218.56150983140648]
[null,null,0.82,636.81963636363628,null,522.7590909090909,null,740.21618945127545,null,null,226.55766263011645]
[]
[null,null,null,{"$f":"\"Example Male \"&F8&\" Price\"","v":"Example Male Calf Price"},null,null,null,null,null,null,{"$f":"+I11","v":160}]
[null,null,null,{"$f":"\"Example Female \"&F8&\" Price\"","v":"Example Female Calf Price"},null,null,null,null,null,null,{"$f":"+I12","v":150}]
[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":156.64782608695651}]
[]
["Francisco Abelló, Assistant Professor and Extension Specialist, Texas A&M AgriLife Extension, 940-647-3908"]
[]
["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":17,"n_rows":83,"n_cols":14,"rows_kept":83,"cut":false,"hidden":false,"merged":[[82,0,82,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"]
["2021 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.98499999999999999,null,6.9000000000000012,null,"CWT",152,null,1033.0680000000002,{"$f":"+J11*G11*E11","v":0},826454.40000000014,{"$f":"+L11*E$7","v":0}]
[null,null,null,0.98499999999999999,null,0,null,null,0,null,0,0,0,0]
[null,null,null,0.98499999999999999,null,0,null,null,0,null,0,0,0,0]
["Total Revenue",null,null,null,null,null,null,null,null,null,1033.0680000000002,{"$f":"+L11","v":0},826454.40000000014,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",160,null,760,{"$f":"+J18*G18","v":0},608000,{"$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,207.76649746192894,null,"Pounds",0.55000000000000004,null,114.27157360406092,0,91417.258883248738,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.09,null,11.25,0,9000,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",7.9637500000000001,null,7.9637500000000001,0,6371,0]
[null,"Lube (As a % of fuel)",null,null,null,0.1,null,"Percent",7.9637500000000001,null,0.79637500000000006,0,637.1,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.98499999999999999,null,"Head",12,null,11.82,0,9456,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,6.5000000000000002E-2,null,20.373327682648402,{"$f":"+SUM(L18:L44)*J47/2","v":0},16298.662146118721,0]
["Total Variable Costs",null,null,null,null,null,null,null,null,null,965.64002628670937,{"$f":"+SUM(L18:L47)","v":0},772512.02102936746,{"$f":"+SUM(N18:N47)","v":0}]
[]
["Planned Returns Above Variable Costs:",null,null,null,null,null,null,null,null,null,67.427973713290839,{"$f":"+L14-L48","v":0},53942.378970632679,{"$f":"+N14-N48","v":0}]
[]
[null,"Breakeven Price to Cover Variable Costs",null,null,null,null,null,null,142.07901512347667,{"$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",23.333333333333321,null,23.333333333333321,0,18666.666666666657,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,37.315991666666655,{"$f":"+SUM(L56:L60)","v":0},29852.793333333324,{"$f":"+SUM(N56:N60)","v":0}]
[]
["Total Costs",null,null,null,null,null,null,null,null,null,1002.956017953376,{"$f":"+L48+L63","v":0},802364.8143627008,{"$f":"+N48+N63","v":0}]
[]
["Planned Returns to Management, Risk, and Profit:",null,null,null,null,null,null,null,null,null,30.111982046624234,{"$f":"+L50-L63","v":0},24089.585637299344,{"$f":"+N50-N63","v":0}]
[]
["    Breakeven Price to Cover Total Costs",null,null,null,null,null,null,null,147.56948693494826,{"$f":"+IF(G11=0,\"n/a\",(L65-SUM(L12:L13))/(G11*E11))","v":"n/a"},"CWT"]
[]
[null,null,"Example Breakeven Sensitivity Analysis"]
[null,null,null,null,null,"Purchase Weight (Lbs/Hd): 475",null,"Sales Price/Cwt of $Total"]
[null,null,null,null,null,"Sales Price/Cwt  152.00",null,"Purchase Price/Cwt  160.00"]
[null,null,"ADG (Lbs/day)","Net Pay Weight with Shrink",null,"Breakeven Purchase Price ($/CWT)",null,"Breakeven Sales Price ($/CWT)"]
[null,null,2.0465,753.32400000000007,null,186.29908944139453,null,135.16487724420608]
[null,null,1.8759583333333334,730.13033333333328,null,178.98844570806119,null,139.45858887995018]
[null,null,1.7054166666666666,690.00000000000011,null,166.33936464139458,null,147.56948693494826]
[null,null,1.534875,683.74299999999994,null,164.36715824139449,null,148.91990994440064]
[null,null,1.3643333333333334,660.54933333333338,null,157.05651450806121,null,154.14888918483146]
[]
["Francisco Abelló, Assistant Professor and Extension Specialist, Texas A&M AgriLife Extension, 940-647-3908"]
[]
["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":"StockerGrazeOut","index":18,"n_rows":84,"n_cols":14,"rows_kept":84,"cut":false,"hidden":false,"merged":[[83,0,83,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"]
["2021 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",145,null,1118.1675,{"$f":"+J11*G11*E11","v":0},894534,{"$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,1118.1675,{"$f":"+L11","v":0},894534,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",160,null,760,{"$f":"+J18*G18","v":0},608000,{"$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.55000000000000004,null,167.92010309278351,0,134336.0824742268,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.09,null,27,0,21600,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,6.5000000000000002E-2,null,30.048030821917806,{"$f":"+SUM(L18:L45)*J48/2","v":0},24038.424657534244,0]
["Total Variable Costs",null,null,null,null,null,null,null,null,null,1054.8443839147012,{"$f":"+SUM(L18:L48)","v":0},843875.50713176106,{"$f":"+SUM(N18:N48)","v":0}]
[]
["Planned Returns Above Variable Costs:",null,null,null,null,null,null,null,null,null,63.323116085298807,{"$f":"+L14-L49","v":0},50658.492868238944,{"$f":"+N14-N49","v":0}]
[]
[null,"Breakeven Price to Cover Variable Costs",null,null,null,null,null,null,136.78848264471259,{"$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",12.485833333333336,null,12.485833333333336,{"$f":"+J57*G57","v":0},9988.6666666666679,{"$f":"+L57*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",35,null,35,0,28000,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,48.982658333333333,{"$f":"+SUM(L57:L61)","v":0},39186.126666666663,{"$f":"+SUM(N57:N61)","v":0}]
[]
["Total Costs",null,null,null,null,null,null,null,null,null,1103.8270422480346,{"$f":"+L49+L64","v":0},883061.63379842776,{"$f":"+N49+N64","v":0}]
[]
["Planned Returns to Management, Risk, and Profit:",null,null,null,null,null,null,null,null,null,14.340457751965459,{"$f":"+L51-L64","v":0},11472.366201572237,{"$f":"+N51-N64","v":0}]
[]
["    Breakeven Price to Cover Total Costs",null,null,null,null,null,null,null,143.14038024353687,{"$f":"+IF(G11=0,\"n/a\",(L66-SUM(L12:L13))/(G11*E11))","v":"n/a"},"CWT"]
[]
[null,null,"Example Breakeven Sensitivity Analysis"]
[null,null,null,null,null,"Purchase Weight (Lbs/Hd): 475",null,"Sales Price/Cwt of $Total"]
[null,null,null,null,null,"Sales Price/Cwt  145.00",null,"Purchase Price/Cwt  160.00"]
[null,null,"ADG (Lbs/day)","Net Pay Weight with Shrink",null,"Breakeven Purchase Price ($/CWT)",null,"Breakeven Sales Price ($/CWT)"]
[null,null,1.9634254143646406,861.79480662983417,null,182.79733753196365,null,132.04605251524885]
[null,null,1.7998066298342541,829.56190607734811,null,173.25300603152743,null,137.1767452916304]
[null,null,1.6361878453038672,795,null,163.01904373725588,null,143.14038024353687]
[null,null,1.4725690607734805,765.09610497237566,null,154.16434303065515,null,148.73504328939239]
[null,null,1.3089502762430938,732.86320441988948,null,144.62001153021893,null,155.276730510286]
[]
["Francisco Abelló, Assistant Professor and Extension Specialist, Texas A&M AgriLife Extension, 940-647-3908"]
[]
["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":19,"n_rows":116,"n_cols":8,"rows_kept":116,"cut":false,"hidden":false,"merged":[[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],[95,4,95,5],[95,6,95,7],[96,4,96,5],[96,6,96,7],[97,4,97,5],[97,6,97,7],[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]]}
["Estimated Costs and Returns per Animal or Breeding Female"]
[]
["Livestock Budget"]
[]
["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/D5*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/D5*D13))","v":0},{"$f":"+F67","v":"CWT"}]
[]
[]
[null,"Sensitivity Analysis for Your Breeding Herd or Flock Values"]
[null,"Your Weaning Percent","Your Gross Sales per Head","Pounds Produced per Head",{"$f":"\"Your Breakeven 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.06},{"$f":"+IF($B$97=0,0,YTotRet-$G$9-$G$10+($G$9+$G$10)*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-($G$18-$G$9-$G$10))/(YPrice/100)/(B95-$C$11/$D$5))","v":0},null,{"$f":"IF(D95-$H$102=0,0,(YTotExp-($G$18-$G$9-$G$10))/(D95-$H$102)*100)","v":0}]
[null,{"$f":"+B97-0.03","v":-0.03},{"$f":"+IF($B$97=0,0,YTotRet-$G$9-$G$10+($G$9+$G$10)*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-($G$18-$G$9-$G$10))/(YPrice/100)/(B96-$C$11/$D$5))","v":0},null,{"$f":"IF(D96-$H$102=0,0,(YTotExp-($G$18-$G$9-$G$10))/(D96-$H$102)*100)","v":0}]
[null,0,{"$f":"+G18","v":0},{"$f":"H101+H102","v":0},{"$f":"IF($C$97=0,0,(YTotExp-($G$18-$G$9-$G$10))/(YPrice/100)/(B97-$C$11/$D$5))","v":0},null,{"$f":"IF(D97-$H$102=0,0,(YTotExp-($G$18-$G$9-$G$10))/(D97-$H$102)*100)","v":0}]
[null,{"$f":"+B97+0.03","v":0.03},{"$f":"+IF($B$97=0,0,YTotRet-$G$9-$G$10+($G$9+$G$10)*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-($G$18-$G$9-$G$10))/(YPrice/100)/(B98-$C$11/$D$5))","v":0},null,{"$f":"IF(D98-$H$102=0,0,(YTotExp-($G$18-$G$9-$G$10))/(D98-$H$102)*100)","v":0}]
[null,{"$f":"+B98+0.03","v":0.06},{"$f":"+IF($B$97=0,0,YTotRet-$G$9-$G$10+($G$9+$G$10)*B99/$B$97)","v":0},{"$f":"IF($B$97=0,0,$H$101*B99/$B$97+$H$102)","v":0},{"$f":"IF($C$97=0,0,(YTotExp-($G$18-$G$9-$G$10))/(YPrice/100)/(B99-$C$11/$D$5))","v":0},null,{"$f":"IF(D99-$H$102=0,0,(YTotExp-($G$18-$G$9-$G$10))/(D99-$H$102)*100)","v":0}]
[]
[null,null,"Your Male Price",null,null,{"$f":"+F9","v":0},null,{"$f":"IF(D5=0,0,(C9*D9+C10*D10)*100/D5)","v":0}]
[null,null,"Your Female Price",null,null,{"$f":"+F10","v":0},null,{"$f":"IF(D5=0,0,(C11*D11+C12*D12)*100/D5)","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)/D5))","v":0}]
[]
[null,null,"Your Stocker or Feeder Breakeven 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,"Breakeven Purchase Price ($/CWT)",null,"Breakeven 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/$D$5))-($G$86-SUM($G$14:$G$16)-$G$23))/(100*$D$23))*100)","v":0},null,{"$f":"IF($C$13=0,0,($G$86-SUM($G$14:$G$16))/(D112*($C$13/$D$5)*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/$D$5))-($G$86-SUM($G$14:$G$16)-$G$23))/(100*$D$23))*100)","v":0},null,{"$f":"IF($C$13=0,0,($G$86-SUM($G$14:$G$16))/(D113*($C$13/$D$5)*100))","v":0}]
[null,null,{"$f":"+E106","v":0},{"$f":"+(C114*$E$107+$D$23*100)*(1-$E$108)","v":0},null,{"$f":"IF($D$23=0,0,(((D114*$F$13/100*($C$13/$D$5))-($G$86-SUM($G$14:$G$16)-$G$23))/(100*$D$23))*100)","v":0},null,{"$f":"IF($C$13=0,0,($G$86-SUM($G$14:$G$16))/(D114*($C$13/$D$5)*100))","v":0}]
[null,null,{"$f":"+C114*0.9","v":0},{"$f":"+(C115*$E$107+$D$23*100)*(1-$E$108)","v":0},null,{"$f":"IF($D$23=0,0,(((D115*$F$13/100*($C$13/$D$5))-($G$86-SUM($G$14:$G$16)-$G$23))/(100*$D$23))*100)","v":0},null,{"$f":"IF($C$13=0,0,($G$86-SUM($G$14:$G$16))/(D115*($C$13/$D$5)*100))","v":0}]
[null,null,{"$f":"+C114*0.8","v":0},{"$f":"+(C116*$E$107+$D$23*100)*(1-$E$108)","v":0},null,{"$f":"IF($D$23=0,0,(((D116*$F$13/100*($C$13/$D$5))-($G$86-SUM($G$14:$G$16)-$G$23))/(100*$D$23))*100)","v":0},null,{"$f":"IF($C$13=0,0,($G$86-SUM($G$14:$G$16))/(D116*($C$13/$D$5)*100))","v":0}]

{"sheet":"Crop Budget","index":20,"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,{"$f":"+F91*$D$5","v":0}]
[null,"Other Chemical 3",0,"Lb,Oz,Acre",0,0,{"$f":"+F92*$D$5","v":0}]
[null,"Other Chemical 4",0,"Lb,Oz,Acre",0,0,{"$f":"+F93*$D$5","v":0}]
[null,"Other Chemical 5",0,"Lb,Oz,Acre",0,0,{"$f":"+F94*$D$5","v":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",1,"Acre",0,{"$f":"C126*E126","v":0},{"$f":"+F126*$D$6","v":0}]
[null,"Depreciation - Equipment",1,"Acre",0,{"$f":"C127*E127","v":0},0]
[null,"Equipment Investment",0,"$",0,0,0]
[null,"Insurance",1,"Acre",0,0,0]
[null,"Management Fee",1,"Acre",0,0,0]
[null,"Owner/Operator Labor",0,"Acre",0,0,0]
[null,"Salaried Labor",1,"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,"Price To Cover",null,"Price 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,{"$f":"+IF(C152=0,0,($F$118-SUM($F$10:$F$16))/C152)","v":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,{"$f":"+IF(C155=0,0,($F$118-SUM($F$10:$F$16))/C155)","v":0},null,{"$f":"+IF(C155=0,0,($F$141-SUM($F$10:$F$16))/C155)","v":0}]

{"sheet":"Comparative Returns - Cash Rent","index":21,"n_rows":29,"n_cols":11,"rows_kept":29,"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,"Breakeven Yield to Cover Total Costs at Price Entered"]
[null,"Total Costs","Variable Costs",null,"Total Costs","Variable Costs",null,"Price","Units","Total Costs","Variable Costs"]
["FORAGE CROPS"]
[]
[{"$f":"+AlfalfaDrylandEstablish!A3","v":"Dryland Alfalfa Establishment"},{"$f":"+AlfalfaDrylandEstablish!TotRet","v":-270.87905143455089},{"$f":"+AlfalfaDrylandEstablish!VarRet","v":-217.58407644505851},null,{"$f":"+AlfalfaDrylandEstablish!TotExp","v":270.87905143455089},{"$f":"+AlfalfaDrylandEstablish!VarExp","v":217.58407644505851},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":387.78115686215756},{"$f":"+AlfalfaHayDryland!VarRet","v":518.43028186215747},null,{"$f":"+AlfalfaHayDryland!TotExp","v":359.71884313784244},{"$f":"+AlfalfaHayDryland!VarExp","v":229.06971813784247},null,{"$f":"+AlfalfaHayDryland!Price","v":230},{"$f":"+AlfalfaHayDryland!Unit","v":"Ton"},1.5639949701645324,0.99595529625148904]
[{"$f":"+AlfalfaIrrigatedEstablish!A3","v":"Irrigated Alfalfa Establishment"},{"$f":"+AlfalfaIrrigatedEstablish!TotRet","v":-399.30698708061476},{"$f":"+AlfalfaIrrigatedEstablish!VarRet","v":-262.57451209112236},null,{"$f":"+AlfalfaIrrigatedEstablish!TotExp","v":399.30698708061476},{"$f":"+AlfalfaIrrigatedEstablish!VarExp","v":262.57451209112236},null,{"$f":"+AlfalfaIrrigatedEstablish!Price","v":0},{"$f":"+AlfalfaIrrigatedEstablish!Unit","v":""},0,0]
[{"$f":"+AlfalfaHayIrrigated!A3","v":"Irrigated Alfalfa Hay"},{"$f":"+AlfalfaHayIrrigated!TotRet","v":786.54317515924663},{"$f":"+AlfalfaHayIrrigated!VarRet","v":1063.5231439092465},null,{"$f":"+AlfalfaHayIrrigated!TotExp","v":708.45682484075337},{"$f":"+AlfalfaHayIrrigated!VarExp","v":431.47685609075342},null,{"$f":"+AlfalfaHayIrrigated!Price","v":230},{"$f":"+AlfalfaHayIrrigated!Unit","v":"Ton"},3.0802470645250146,1.8759863308293627]
[{"$f":"+SmallGrain!A3","v":"Small Grain Grazing"},{"$f":"+SmallGrain!TotRet","v":-139.21297971613058},{"$f":"+SmallGrain!VarRet","v":-94.180721405573223},null,{"$f":"+SmallGrain!TotExp","v":139.21297971613058},{"$f":"+SmallGrain!VarExp","v":94.180721405573223},null,{"$f":"+SmallGrain!Price","v":0},{"$f":"+SmallGrain!Unit","v":""},0,0]
[]
["FIELD CROPS"]
[]
[{"$f":"+CottonDrylandSolid!A3","v":"Dryland Cotton (Solid 40\" Rows)"},{"$f":"+CottonDrylandSolid!TotRet","v":-52.857778500340658},{"$f":"+CottonDrylandSolid!VarRet","v":19.160032229492572},null,{"$f":"+CottonDrylandSolid!TotExp","v":378.45777850034068},{"$f":"+CottonDrylandSolid!VarExp","v":306.43996777050745},null,{"$f":"+CottonDrylandSolid!Price","v":0.74},{"$f":"+CottonDrylandSolid!Unit","v":"Pound"},{"$f":"+IF($H15=0,0,E15/$H15)","v":511.42943040586579},{"$f":"+IF($H15=0,0,F15/$H15)","v":414.10806455473983}]
[{"$f":"'Red Till Irrig Cotton'!A3","v":"Cotton - Red Till Irrig "},{"$f":"'Red Till Irrig Cotton'!TotRet","v":209.71231344147157},{"$f":"'Red Till Irrig Cotton'!VarRet","v":402.73590394038422},null,{"$f":"'Red Till Irrig Cotton'!TotExp","v":727.86768655852848},{"$f":"'Red Till Irrig Cotton'!VarExp","v":534.84409605961582},null,{"$f":"'Red Till Irrig Cotton'!Price","v":0.74},{"$f":"'Red Till Irrig Cotton'!Unit","v":"Pound"},{"$f":"IF(H16=0,0,E16/H16)","v":983.60498183584934},{"$f":"IF(H16=0,0,F16/H16)","v":722.7622919724538}]
[{"$f":"'Conv M Irrig Cotton'!A3","v":"Conventional Irrig Cotton"},{"$f":"'Conv M Irrig Cotton'!TotRet","v":220.22324602407514},{"$f":"'Conv M Irrig Cotton'!VarRet","v":413.61188224682257},null,{"$f":"'Conv M Irrig Cotton'!TotExp","v":750.65675397592486},{"$f":"'Conv M Irrig Cotton'!VarExp","v":557.26811775317742},null,{"$f":"'Conv M Irrig Cotton'!Price","v":0.74},{"$f":"'Conv M Irrig Cotton'!Unit","v":"Pound"},1014.4010188863849,753.06502399078033]
[{"$f":"'NT Irrig M Cotton'!A3","v":"Cotton - No-Till Irrigated"},{"$f":"'NT Irrig M Cotton'!TotRet","v":299.9549568301328},{"$f":"'NT Irrig M Cotton'!VarRet","v":483.27776733963344},null,{"$f":"'NT Irrig M Cotton'!TotExp","v":739.00504316986724},{"$f":"'NT Irrig M Cotton'!VarExp","v":555.68223266036659},null,{"$f":"'NT Irrig M Cotton'!Price","v":0.74},{"$f":"'NT Irrig M Cotton'!Unit","v":"Pound"},998.65546374306382,750.92193602752241]
[{"$f":"'NT-CC2 Irr M Cotton'!A3","v":"Cotton NT - Cover Crop Wheat Irrig"},{"$f":"'NT-CC2 Irr M Cotton'!TotRet","v":277.36026382107957},{"$f":"'NT-CC2 Irr M Cotton'!VarRet","v":474.55778646093938},null,{"$f":"'NT-CC2 Irr M Cotton'!TotExp","v":780.09973617892047},{"$f":"'NT-CC2 Irr M Cotton'!VarExp","v":582.90221353906065},null,{"$f":"'NT-CC2 Irr M Cotton'!Price","v":0.74},{"$f":"'NT-CC2 Irr M Cotton'!Unit","v":"Pound"},{"$f":"IF(H19=0,0,E19/H19)","v":1054.1888326742169},{"$f":"IF(H19=0,0,F19/H19)","v":787.70569397170357}]
[{"$f":"'No Till Dryland Cotton'!A3","v":"Cotton - No Till Dryland "},{"$f":"'No Till Dryland Cotton'!TotRet","v":-15.059514039971077},{"$f":"'No Till Dryland Cotton'!VarRet","v":40.962775889826844},null,{"$f":"'No Till Dryland Cotton'!TotExp","v":340.6595140399711},{"$f":"'No Till Dryland Cotton'!VarExp","v":284.63722411017318},null,{"$f":"'No Till Dryland Cotton'!Price","v":0.74},{"$f":"'No Till Dryland Cotton'!Unit","v":"Pound"},460.35069464860959,384.64489744617998]
[{"$f":"+Peanuts!A3","v":"Irrigated Peanuts"},{"$f":"+Peanuts!TotRet","v":18.228953399038687},{"$f":"+Peanuts!VarRet","v":364.32841317163422},null,{"$f":"+Peanuts!TotExp","v":921.77104660096131},{"$f":"+Peanuts!VarExp","v":575.67158682836578},null,{"$f":"+Peanuts!Price","v":470},{"$f":"+Peanuts!Unit","v":"Ton"},1.9612149927680027,1.2248331634646081]
[{"$f":"+SorghumDryland!A3","v":"Dryland Sorghum"},{"$f":"+SorghumDryland!TotRet","v":31.059723270322905},{"$f":"+SorghumDryland!VarRet","v":90.880217299709685},null,{"$f":"+SorghumDryland!TotExp","v":168.94027672967709},{"$f":"+SorghumDryland!VarExp","v":109.11978270029032},null,{"$f":"+SorghumDryland!Price","v":8},{"$f":"+SorghumDryland!Unit","v":"CWT"},{"$f":"+IF($H22=0,0,E22/$H22)","v":21.117534591209637},13.639972837536289]
[{"$f":"+WheatDryland!A3","v":"Dryland Wheat"},{"$f":"+WheatDryland!TotRet","v":41.615414278770459},{"$f":"+WheatDryland!VarRet","v":86.188813744279798},null,{"$f":"+WheatDryland!TotExp","v":173.58458572122953},{"$f":"+WheatDryland!VarExp","v":129.01118625572019},null,{"$f":"+WheatDryland!Price","v":6},{"$f":"+WheatDryland!Unit","v":"Bushel"},28.93076428687159,21.501864375953364]
[]
["LIVESTOCK"]
[]
[{"$f":"+CowCalf!A3","v":"Rolling Plains Cow-Calf Production"},{"$f":"+CowCalf!TotRet","v":-200.42282130981744},{"$f":"+CowCalf!VarRet","v":286.81793285684921},null,{"$f":"+CowCalf!TotExp","v":876.54682130981735},{"$f":"+CowCalf!VarExp","v":389.3060671431507},null,{"$f":"+CowCalf!Price","v":156.64782608695651},{"$f":"+CowCalf!Unit","v":"CWT"},{"$f":"+IF($H27=0,0,E27/$H27)","v":5.5956526381875156},2.4852312149358755]
[{"$f":"+StockersMar1!A3","v":"Stocker Calf Budget - Pull off Wheat March 1"},{"$f":"+StockersMar1!TotRet","v":30.111982046624234},{"$f":"+StockersMar1!VarRet","v":67.427973713290839},null,{"$f":"+StockersMar1!TotExp","v":1002.956017953376},{"$f":"+StockersMar1!VarExp","v":965.64002628670937},null,{"$f":"+StockersMar1!Price","v":152},{"$f":"+StockersMar1!Unit","v":"CWT"},6.5983948549564211,6.352894909780983]
[{"$f":"+StockerGrazeOut!A3","v":"Stocker Calf Budget - Grazeout"},{"$f":"+StockerGrazeOut!TotRet","v":14.340457751965459},{"$f":"+StockerGrazeOut!VarRet","v":63.323116085298807},null,{"$f":"+StockerGrazeOut!TotExp","v":1103.8270422480346},{"$f":"+StockerGrazeOut!VarExp","v":1054.8443839147012},null,{"$f":"+StockerGrazeOut!Price","v":145},{"$f":"+StockerGrazeOut!Unit","v":"CWT"},{"$f":"+IF($H29=0,0,E29/$H29)","v":7.612600291365756},{"$f":"+IF($H29=0,0,F29/$H29)","v":7.2747888545841466}]

{"sheet":"Your Returns - Cash Rent","index":22,"n_rows":34,"n_cols":12,"rows_kept":34,"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,"Breakeven Yield to Cover Total Costs at Price Entered"]
[null,"Acres, AUs,  or Head","Total Costs","Variable Costs",null,"Total Costs","Variable Costs",null,"Price","Units","Total Costs","Variable Costs"]
["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":""},0,0]
[]
["FIELD CROPS"]
[]
[{"$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($I15=0,0,F15/$I15)","v":0},{"$f":"+IF($I15=0,0,G15/$I15)","v":0}]
[{"$f":"'Red Till Irrig Cotton'!A3","v":"Cotton - Red Till Irrig "},{"$f":"'Red Till Irrig Cotton'!E7","v":0},{"$f":"'Red Till Irrig Cotton'!YTotRet","v":0},{"$f":"'Red Till Irrig Cotton'!YVarRet","v":0},null,{"$f":"'Red Till Irrig Cotton'!YTotExp","v":0},{"$f":"'Red Till Irrig Cotton'!YVarExp","v":0},null,{"$f":"'Red Till Irrig Cotton'!YPrice","v":0},{"$f":"'Red Till Irrig Cotton'!Unit","v":"Pound"},{"$f":"IF(I16=0,0,F16/I16)","v":0},{"$f":"IF(I16=0,0,G16/I16)","v":0}]
[{"$f":"'Conv M Irrig Cotton'!A3","v":"Conventional Irrig Cotton"},{"$f":"'Conv M Irrig Cotton'!E7","v":0},{"$f":"'Conv M Irrig Cotton'!YTotRet","v":0},{"$f":"'Conv M Irrig Cotton'!YVarRet","v":0},null,{"$f":"'Conv M Irrig Cotton'!YTotExp","v":0},{"$f":"'Conv M Irrig Cotton'!YVarExp","v":0},null,{"$f":"'Conv M Irrig Cotton'!YPrice","v":0},{"$f":"'Conv M Irrig Cotton'!Unit","v":"Pound"},0,0]
[{"$f":"'NT Irrig M Cotton'!A3","v":"Cotton - No-Till Irrigated"},{"$f":"'NT Irrig M Cotton'!E7","v":0},{"$f":"'NT Irrig M Cotton'!YTotRet","v":0},{"$f":"'NT Irrig M Cotton'!YVarRet","v":0},null,{"$f":"'NT Irrig M Cotton'!YTotExp","v":0},{"$f":"'NT Irrig M Cotton'!YVarExp","v":0},null,{"$f":"'NT Irrig M Cotton'!YPrice","v":0},{"$f":"'NT Irrig M Cotton'!Unit","v":"Pound"},0,0]
[{"$f":"'NT-CC2 Irr M Cotton'!A3","v":"Cotton NT - Cover Crop Wheat Irrig"},{"$f":"'NT-CC2 Irr M Cotton'!E7","v":0},{"$f":"'NT-CC2 Irr M Cotton'!YTotRet","v":0},{"$f":"'NT-CC2 Irr M Cotton'!YVarRet","v":0},null,{"$f":"'NT-CC2 Irr M Cotton'!YTotExp","v":0},{"$f":"'NT-CC2 Irr M Cotton'!YVarExp","v":0},null,{"$f":"'NT-CC2 Irr M Cotton'!YPrice","v":0},{"$f":"'NT-CC2 Irr M Cotton'!Unit","v":"Pound"},{"$f":"IF(I19=0,0,F19/I19)","v":0},{"$f":"IF(I19=0,0,G19/I19)","v":0}]
[{"$f":"'No Till Dryland Cotton'!A3","v":"Cotton - No Till Dryland "},{"$f":"'No Till Dryland Cotton'!E7","v":0},{"$f":"'No Till Dryland Cotton'!YTotRet","v":0},{"$f":"'No Till Dryland Cotton'!YVarRet","v":0},null,{"$f":"'No Till Dryland Cotton'!YTotExp","v":0},{"$f":"'No Till Dryland Cotton'!YVarExp","v":0},null,{"$f":"'No Till Dryland Cotton'!YPrice","v":0},{"$f":"'No Till Dryland Cotton'!Unit","v":"Pound"},0,0]
[{"$f":"+Peanuts!A3","v":"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($I22=0,0,F22/$I22)","v":0},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"},0,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":{"$error":"#NAME?"}},{"$f":"+CowCalf!Unit","v":"CWT"},{"$f":"+IF($I27=0,0,F27/$I27)","v":{"$error":"#NAME?"}},{"$error":"#NAME?"}]
[{"$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":"+StockerGrazeOut!A3","v":"Stocker Calf Budget - Grazeout"},{"$f":"+StockerGrazeOut!E7","v":0},{"$f":"+StockerGrazeOut!YTotRet","v":0},{"$f":"+StockerGrazeOut!YVarRet","v":0},null,{"$f":"+StockerGrazeOut!YTotExp","v":0},{"$f":"+StockerGrazeOut!YVarExp","v":0},null,{"$f":"+StockerGrazeOut!YPrice","v":0},{"$f":"+StockerGrazeOut!Unit","v":"CWT"},{"$f":"+IF($I29=0,0,F29/$I29)","v":0},{"$f":"+IF($I29=0,0,G29/$I29)","v":0}]
[]
["OTHER BUDGETS"]
[]
[{"$f":"+'Livestock Budget'!A3","v":"Livestock Budget"},{"$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($I33=0,0,F33/$I33)","v":0},{"$f":"+IF($I33=0,0,G33/$I33)","v":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"},{"$f":"+IF($I34=0,0,F34/$I34)","v":0},{"$f":"+IF($I34=0,0,G34/$I34)","v":0}]