{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Menu","Soybeans","RRSoybeans","Rice","Livestock Budget","Crop Budget","Comparative Returns - Cash Rent","Your Returns - Cash Rent"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":172,"comments":5,"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":73,"n_cols":26,"rows_kept":73,"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]
[]
["      Southeast Extension District - 9      "]
[]
[null,null,null,"Budgets"]
[]
[]
[null,null,null,"Field Crops"]
[]
[null,null,null,{"$f":"+Soybeans!A3","v":"Soybeans"}]
[null,null,null,{"$f":"RRSoybeans!A3","v":"Roundup Ready Soybeans"}]
[null,null,null,{"$f":"Rice!A3","v":"First Crop Rice (Jefferson-Liberty Counties)"}]
[]
[null,null,null,"Other Budgets"]
[null,"Comparative Returns"]
[null,null,null,{"$f":"'Livestock Budget'!A3","v":"Livestock Enterprise"}]
[null,null,null,{"$f":"'Crop Budget'!A3","v":"Crop Enterprise"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["  Developed by Extension Economists, Texas A&M AgriLife Extension Service, budgets@tamu.edu.  "]

{"sheet":"Soybeans","index":1,"n_rows":156,"n_cols":33,"rows_kept":156,"cut":false,"hidden":false,"merged":[[87,3,87,8],[97,3,97,8],[109,0,109,11],[0,0,0,11],[1,0,1,11],[2,0,2,11],[3,0,3,11]]}
["Projections for Planning Purposes Only -- Not to be Used without Updating"]
["2018 Estimated Costs and Returns per Acre"]
["Soybeans"]
["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",500,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","(500 acres)",{"$f":"\"(\" & E7 & \" acres)\"","v":"( acres)"}]
[null,"Soybeans",null,25,null,"Bushel",9,null,225,{"$f":"E10*H10","v":0},0,null,0,{"$f":"J10*L10","v":0},225,{"$f":"+J10-N10","v":0},112500,{"$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,225,{"$f":"SUM(J10:J12)","v":0},null,null,0,{"$f":"SUM(N10:N12)","v":0},225,{"$f":"SUM(P10:P12)","v":0},112500,{"$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,"","Ground Fertilizer",1,null,"Acre",7,null,7,{"$f":"E18*H18","v":0},0,null,0,{"$f":"J18*L18","v":0},7,{"$f":"+J18-N18","v":0},3500,{"$f":"+J18*E$7","v":0}]
[null,"","Ground Herbicide",1,null,"Acre",7,null,7,0,0,null,0,0,7,0,3500,0]
[null,"","Herbicide Application",2,null,"Acre",7,null,14,0,0,null,0,0,14,0,7000,0]
[null,"","Air Insecticide",1,null,"Acre",9,null,9,0,0,null,0,0,9,0,4500,0]
[null,"","Custom Grain Haul",25,null,"Bushel",0.2,null,5,0,0,null,0,0,5,0,2500,0]
[null,"","Drying Soybeans",12.5,null,"Bushel",0.5,null,6.25,0,0,null,0,0,6.25,0,3125,0]
[null,"Fertilizer"]
[null,"","DAP (18-46-0)",100,null,"Pound",0.21,null,21,0,0,null,0,0,21,0,10500,0]
[null,"","Potash (0-0-60)",100,null,"Pound",0.13,null,13,0,0,null,0,0,13,0,6500,0]
[null,"Herbicide"]
[null,"","Valor SX",2,null,"Ounce",4.2562499999999996,null,8.5124999999999993,0,0,null,0,0,8.5124999999999993,0,4256.25,0]
[null,"","Select Max",20,null,"Ounce",0.72265625,null,14.453125,0,0,null,0,0,14.453125,0,7226.5625,0]
[null,"","Ultra Blazer",1,null,"Pint",10,null,10,0,0,null,0,0,10,0,5000,0]
[null,"Seed"]
[null,"","Seed - Soybeans",1,null,"Bag",44,null,44,0,0,null,0,0,44,0,22000,0]
[null,"Insecticide"]
[null,"","Mustang Max",3.2,null,"Ounce",1.1328125,null,3.625,0,0,null,0,0,3.625,0,1812.5,0]
[null,"Other Chemicals"]
[null,"","Surfactant",1,null,"Acre",1.5,null,1.5,0,0,null,0,0,1.5,0,750,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,"Machinery Labor"]
[null,null,"Tractors/Self-Propelled",1.46,null,"Hour",13.75,null,20.074999999999999,{"$f":"E41*H41","v":0},0,null,0,{"$f":"J41*L41","v":0},20.074999999999999,{"$f":"+J41-N41","v":0},10037.5,{"$f":"+J41*E$7","v":0}]
[null,null,"Other Labor",0,null,"Hour",13.75,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,"Diesel Fuel"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0,null,0,{"$f":"E45*H45","v":0},0,null,0,{"$f":"J45*L45","v":0},0,{"$f":"+J45-N45","v":0},0,{"$f":"+J45*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",5.87,null,"Gallon",2,null,11.74,{"$f":"E46*H46","v":0},0,null,0,{"$f":"J46*L46","v":0},11.74,{"$f":"+J46-N46","v":0},5870,{"$f":"+J46*E$7","v":0}]
[]
[null,"Gasoline"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0.95,null,0.95,{"$f":"E49*H49","v":0},0,null,0,{"$f":"J49*L49","v":0},0.95,{"$f":"+J49-N49","v":0},475,{"$f":"+J49*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",0,null,"Gallon",1.9,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,"Repairs & Maintenance"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0.61199999999999999,null,0.61199999999999999,{"$f":"E53*H53","v":0},0,null,0,{"$f":"J53*L53","v":0},0.61199999999999999,{"$f":"+J53-N53","v":0},306,{"$f":"+J53*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",20.433498399056109,null,20.433498399056109,0,0,null,0,0,20.433498399056109,0,10216.749199528054,0]
[null,null,"Implements",1,null,"Acre",18.657318560943889,null,18.657318560943889,0,0,null,0,0,18.657318560943889,0,9328.6592804719439,0]
[null,null,null,null,null,null,null,null,0,0,0,null,0,0,0,0,0,{"$f":"+J57*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,0.05,null,4.5009580058274237,{"$f":"+SUM(J17:J58)/2*H59","v":0},null,null,0,{"$f":"+SUM(N17:N58)/2*L59","v":0},4.5009580058274237,{"$f":"+SUM(P17:P58)/2*L59","v":0},2250.4790029137116,{"$f":"+J59*E$7","v":0}]
["Total Variable Costs",null,null,null,null,null,null,null,241.30939996582737,{"$f":"SUM(J18:J59)","v":0},null,null,0,{"$f":"SUM(N18:N59)","v":0},241.30939996582737,{"$f":"SUM(P18:P59)","v":0},120654.69998291371,{"$f":"SUM(R18:R59)","v":0}]
["Planned Returns Above Variable Costs:",null,null,null,null,null,null,null,-16.309399965827367,{"$f":"+J13-J60","v":0},null,null,0,{"$f":"+N13-N60","v":0},-16.309399965827367,{"$f":"+P13-P60","v":0},-8154.6999829137058,{"$f":"+R13-R60","v":0}]
[null,"Breakeven Price to Cover Variable Costs",null,null,null,null,9.6523759986330955,{"$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",null,"Total","Share","Share","Landlord","Landlord","Tenant","Tenant","Total","Total"]
[null,"Machinery Depreciation"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0.64260000000000006,null,0.64260000000000006,{"$f":"E66*H66","v":0},0,null,0,{"$f":"J66*L66","v":0},0.64260000000000006,{"$f":"+J66-N66","v":0},321.3,{"$f":"+J66*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",1,null,"Acre",19.261188007229773,null,19.261188007229773,0,0,null,0,{"$f":"J67*L67","v":0},19.261188007229773,0,9630.5940036148859,0]
[null,null,"Implements",1,null,"Acre",23.741379702981252,null,23.741379702981252,0,0,null,0,{"$f":"J68*L68","v":0},23.741379702981252,0,11870.689851490626,0]
[null,"Equipment Investment"]
[null,null,"Pickup/General Use Equipment",4.4370000000000003,null,"Dollars",0.05,null,0.22185000000000002,{"$f":"E70*H70","v":0},0,null,0,{"$f":"J70*L70","v":0},0.22185000000000002,{"$f":"+J70-N70","v":0},110.92500000000001,{"$f":"+J70*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",146.34558722009396,null,"Dollars",0.05,null,7.3172793610046982,0,0,null,0,{"$f":"J71*L71","v":0},7.3172793610046982,0,3658.6396805023492,0]
[null,null,"Implements",109.90243226743148,null,"Dollars",0.05,null,5.4951216133715741,0,0,null,0,{"$f":"J72*L72","v":0},5.4951216133715741,0,2747.5608066857872,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 - Soybeans",null,1,null,"Acre",21,null,21,0,0,null,0,0,21,0,10500,0]
[null,"Property Taxes",null,1,null,"Acre",0,null,0,{"$f":"E77*H77","v":0},0,null,0,0,0,0,0,{"$f":"+J77*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,77.679418684587304,{"$f":"+SUM(J66:J80)","v":0},null,null,0,{"$f":"+SUM(N66:N80)","v":0},77.679418684587304,{"$f":"+SUM(P66:P80)","v":0},38839.709342293645,{"$f":"+SUM(R66:R80)","v":0}]
["Total Specified Costs",null,null,null,null,null,null,null,318.98881865041466,{"$f":"+J60+J81","v":0},null,null,0,{"$f":"+N60+N81","v":0},318.98881865041466,{"$f":"+P60+P81","v":0},159494.40932520735,{"$f":"+R60+R81","v":0}]
[]
["Returns Above Specified Costs",null,null,null,null,null,null,null,-93.988818650414657,{"$f":"+J13-J82","v":0},null,null,0,{"$f":"+N13-N82","v":0},-93.988818650414657,{"$f":"+P13-P82","v":0},-46994.409325207351,{"$f":"+R13-R82","v":0}]
[]
["    Breakeven Price to Cover Total Costs",null,null,null,null,null,12.759552746016587,{"$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,18.75,12.869834664844126,null,null,17.012736994688783]
[null,0.9,22.5,10.724862220703439,null,null,14.177280828907318]
[null,1,25,9.6523759986330955,null,null,12.759552746016587]
[null,1.1000000000000001,27.500000000000004,8.77488727148463,null,null,11.599593405469623]
[null,1.25,31.25,7.7219007989064758,null,null,10.20764219681327]
[]
[null,null,null,"Your Breakeven Prices"]
[null,"Your","Your",null,"To Cover",null,null,"To Cover"]
[null,"Yield","Yield",null,"Variable",null,null,"Total"]
[null,"Percent","Bushel",null,"Costs",null,null,"Costs"]
[null,0.75,{"$f":"E10*YPER1","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER1))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER1))","v":0}]
[null,0.9,{"$f":"E10*YPER2","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER2))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER2))","v":0}]
[null,1,{"$f":"+E10","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER3))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER3))","v":0}]
[null,1.1000000000000001,{"$f":"E10*YPER4","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER4))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER4))","v":0}]
[null,1.25,{"$f":"E10*YPER5","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER5))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER5))","v":0}]
[]
["  Developed by Extension Economists, Texas A&M AgriLife Extension Service, budgets@tamu.edu.  "]
[]
["Information presented is prepared solely as a general guide and not intended to recognize or predict the costs and returns from any one operation.  Brand names are mentioned only as examples and imply no endorsement."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,{"$f":"IF(#REF!=0,0,#REF!)","v":{"$error":"#REF!"}},null,{"$f":"IF(Y156=0,0,LOOKUP(Y156,#REF!,#REF!))","v":0},{"$f":"IF(Y156=0,0,LOOKUP(Y156,#REF!,#REF!))","v":0},null,{"$f":"Z156*AC156","v":{"$error":"#REF!"}},{"$f":"AA156*AD156","v":0},{"$f":"+#REF!","v":{"$error":"#REF!"}}]

{"sheet":"RRSoybeans","index":2,"n_rows":109,"n_cols":18,"rows_kept":109,"cut":false,"hidden":false,"merged":[[86,3,86,8],[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"]
["2018 Estimated Costs and Returns per Acre"]
["Roundup Ready Soybeans"]
["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",500,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","(500 acres)",{"$f":"\"(\" & E7 & \" acres)\"","v":"( acres)"}]
[null,"Soybeans",null,22,null,"Bushel",9,null,198,{"$f":"E10*H10","v":0},0,null,0,{"$f":"J10*L10","v":0},198,{"$f":"+J10-N10","v":0},99000,{"$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,198,{"$f":"SUM(J10:J12)","v":0},null,null,0,{"$f":"SUM(N10:N12)","v":0},198,{"$f":"SUM(P10:P12)","v":0},99000,{"$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,"","Ground Fertilizer",1,null,"Acre",7,null,7,{"$f":"E18*H18","v":0},0,null,0,{"$f":"J18*L18","v":0},7,{"$f":"+J18-N18","v":0},3500,{"$f":"+J18*E$7","v":0}]
[null,"","Air Herbicide",2,null,"Acre",9,null,18,0,0,null,0,0,18,0,9000,0]
[null,"","Air Insecticide",1,null,"Acre",9,null,9,0,0,null,0,0,9,0,4500,0]
[null,"","Custom Grain Haul",22,null,"Bushel",0.2,null,4.4000000000000004,0,0,null,0,0,4.4000000000000004,0,2200,0]
[null,"","Drying Soybeans",11,null,"Bushel",0.5,null,5.5,0,0,null,0,0,5.5,0,2750,0]
[null,"Fertilizer"]
[null,"","DAP (18-46-0)",100,null,"Pound",0.21,null,21,0,0,null,0,0,21,0,10500,0]
[null,"","Potash (0-0-60)",100,null,"Pound",0.13,null,13,0,0,null,0,0,13,0,6500,0]
[null,"Herbicide"]
[null,"","Glyphosphate",2,null,"Quart",2.5,null,5,0,0,null,0,0,5,0,2500,0]
[null,"","Classic",0.25,null,"Ounce",17.100000000000001,null,4.2750000000000004,0,0,null,0,0,4.2750000000000004,0,2137.5,0]
[null,"","Ultra Blazer",0.5,null,"Pint",10,null,5,0,0,null,0,0,5,0,2500,0]
[null,"Insecticide"]
[null,"","Mustang Max",3.2,null,"Ounce",1.1328125,null,3.625,0,0,null,0,0,3.625,0,1812.5,0]
[null,"Seed"]
[null,"","Seed - Roundup Ready Soybean",1,null,"Bag",66,null,66,0,0,null,0,0,66,0,33000,0]
[null,"Other Chemicals"]
[null,"","Surfactant",1,null,"Acre",1.5,null,1.5,0,0,null,0,0,1.5,0,750,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":"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,"Machinery Labor"]
[null,null,"Tractors/Self-Propelled",1.22,null,"Hour",13.75,null,16.774999999999999,{"$f":"E40*H40","v":0},0,null,0,{"$f":"J40*L40","v":0},16.774999999999999,{"$f":"+J40-N40","v":0},8387.5,{"$f":"+J40*E$7","v":0}]
[null,null,"Other Labor",0,null,"Hour",13.75,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,"Diesel Fuel"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0,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,null,"Tractors/Self-Propelled",5.0999999999999996,null,"Gallon",2,null,10.199999999999999,{"$f":"E45*H45","v":0},0,null,0,{"$f":"J45*L45","v":0},10.199999999999999,{"$f":"+J45-N45","v":0},5100,{"$f":"+J45*E$7","v":0}]
[]
[null,"Gasoline"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0.95,null,0.95,{"$f":"E48*H48","v":0},0,null,0,{"$f":"J48*L48","v":0},0.95,{"$f":"+J48-N48","v":0},475,{"$f":"+J48*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",0,null,"Gallon",1.9,null,0,{"$f":"E49*H49","v":0},0,null,0,{"$f":"J49*L49","v":0},0,{"$f":"+J49-N49","v":0},0,{"$f":"+J49*E$7","v":0}]
[]
[null,"Repairs & Maintenance"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",0.61199999999999999,null,0.61199999999999999,{"$f":"E52*H52","v":0},0,null,0,{"$f":"J52*L52","v":0},0.61199999999999999,{"$f":"+J52-N52","v":0},306,{"$f":"+J52*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",18.732208900138524,null,18.732208900138524,0,0,null,0,0,18.732208900138524,0,9366.1044500692624,0]
[null,null,"Implements",1,null,"Acre",9.7457868808270227,null,9.7457868808270227,0,0,null,0,0,9.7457868808270227,0,4872.8934404135116,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,0.05,null,4.2253971534662611,{"$f":"+SUM(J17:J57)/2*H58","v":0},null,null,0,{"$f":"+SUM(N17:N57)/2*L58","v":0},4.2253971534662611,{"$f":"+SUM(P17:P57)/2*L58","v":0},2112.6985767331307,{"$f":"+J58*E$7","v":0}]
["Total Variable Costs",null,null,null,null,null,null,null,224.54039293443179,{"$f":"SUM(J18:J58)","v":0},null,null,0,{"$f":"SUM(N18:N58)","v":0},224.54039293443179,{"$f":"SUM(P18:P58)","v":0},112270.19646721591,{"$f":"SUM(R18:R58)","v":0}]
["Planned Returns Above Variable Costs:",null,null,null,null,null,null,null,-26.540392934431793,{"$f":"+J13-J59","v":0},null,null,0,{"$f":"+N13-N59","v":0},-26.540392934431793,{"$f":"+P13-P59","v":0},-13270.196467215908,{"$f":"+R13-R59","v":0}]
[null,"Breakeven Price to Cover Variable Costs",null,null,null,null,10.206381497019628,{"$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.64260000000000006,null,0.64260000000000006,{"$f":"E65*H65","v":0},0,null,0,{"$f":"J65*L65","v":0},0.64260000000000006,{"$f":"+J65-N65","v":0},321.3,{"$f":"+J65*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",1,null,"Acre",17.50318885834827,null,17.50318885834827,0,0,null,0,{"$f":"J66*L66","v":0},17.50318885834827,0,8751.5944291741343,0]
[null,null,"Implements",1,null,"Acre",11.852216244129693,null,11.852216244129693,0,0,null,0,{"$f":"J67*L67","v":0},11.852216244129693,0,5926.1081220648466,0]
[null,"Equipment Investment"]
[null,null,"Pickup/General Use Equipment",4.4370000000000003,null,"Dollars",0.05,null,0.22185000000000002,{"$f":"E69*H69","v":0},0,null,0,{"$f":"J69*L69","v":0},0.22185000000000002,{"$f":"+J69-N69","v":0},110.92500000000001,{"$f":"+J69*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",132.65020675380742,null,"Dollars",0.05,null,6.6325103376903716,0,0,null,0,{"$f":"J70*L70","v":0},6.6325103376903716,0,3316.2551688451858,0]
[null,null,"Implements",59.04323302678872,null,"Dollars",0.05,null,2.952161651339436,0,0,null,0,{"$f":"J71*L71","v":0},2.952161651339436,0,1476.080825669718,0]
[null,"Salaried Labor",null,1,null,"Acre",0,null,0,0,0,null,0,{"$f":"J72*L72","v":0},0,{"$f":"+J72-N72","v":0},0,{"$f":"+J72*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 - Soybeans",null,1,null,"Acre",21,null,21,0,0,null,0,0,21,0,10500,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":"E79*H79","v":0},0,null,0,0,0,0,0,0]
["Total Fixed Costs",null,null,null,null,null,null,null,60.804527091507772,{"$f":"+SUM(J65:J79)","v":0},null,null,0,{"$f":"+SUM(N65:N79)","v":0},60.804527091507772,{"$f":"+SUM(P65:P79)","v":0},30402.263545753882,{"$f":"+SUM(R65:R79)","v":0}]
["Total Specified Costs",null,null,null,null,null,null,null,285.34492002593959,{"$f":"+J59+J80","v":0},null,null,0,{"$f":"+N59+N80","v":0},285.34492002593959,{"$f":"+P59+P80","v":0},142672.46001296979,{"$f":"+R59+R80","v":0}]
[]
["Returns Above Specified Costs",null,null,null,null,null,null,null,-87.344920025939587,{"$f":"+J13-J81","v":0},null,null,0,{"$f":"+N13-N81","v":0},-87.344920025939587,{"$f":"+P13-P81","v":0},-43672.460012969794,{"$f":"+R13-R81","v":0}]
[]
["    Breakeven Price to Cover Total Costs",null,null,null,null,null,12.970223637542709,{"$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,16.5,13.608508662692836,null,null,17.293631516723611]
[null,0.9,19.8,11.340423885577362,null,null,14.411359597269676]
[null,1,22,10.206381497019628,null,null,12.970223637542709]
[null,1.1000000000000001,24.200000000000003,9.2785286336542061,null,null,11.791112397766097]
[null,1.25,27.5,8.1651051976157021,null,null,10.376178910034167]
[]
[null,null,null,"Your Breakeven Prices"]
[null,"Your","Your",null,"To Cover",null,null,"To Cover"]
[null,"Yield","Yield",null,"Variable",null,null,"Total"]
[null,"Percent","Bushel",null,"Costs",null,null,"Costs"]
[null,0.75,{"$f":"E10*YPER1","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER1))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER1))","v":0}]
[null,0.9,{"$f":"E10*YPER2","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER2))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER2))","v":0}]
[null,1,{"$f":"+E10","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER3))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER3))","v":0}]
[null,1.1000000000000001,{"$f":"E10*YPER4","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER4))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER4))","v":0}]
[null,1.25,{"$f":"E10*YPER5","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER5))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER5))","v":0}]
[]
["  Developed by Extension Economists, Texas A&M AgriLife Extension Service, budgets@tamu.edu.  "]
[]
["Information presented is prepared solely as a general guide and not intended to recognize or predict the costs and returns from any one operation.  Brand names are mentioned only as examples and imply no endorsement."]

{"sheet":"Rice","index":3,"n_rows":116,"n_cols":18,"rows_kept":116,"cut":false,"hidden":false,"merged":[[93,3,93,8],[103,3,103,8],[115,0,115,11],[0,0,0,11],[1,0,1,11],[2,0,2,11],[3,0,3,11]]}
["Projections for Planning Purposes Only -- Not to be Used without Updating"]
["2018 Estimated Costs and Returns per Acre"]
["First Crop Rice (Jefferson-Liberty Counties)"]
["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",450,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","(450 acres)",{"$f":"\"(\" & E7 & \" acres)\"","v":"( acres)"}]
[null,"Rice 1st Crop Loan",null,55,null,"CWT",7,null,385,{"$f":"E10*H10","v":0},0,null,0,{"$f":"J10*L10","v":0},385,{"$f":"+J10-N10","v":0},173250,{"$f":"+J10*E$7","v":0}]
[null,"Rice 1st Crop Premium",null,55,null,"CWT",5.5,null,302.5,0,0,null,0,0,302.5,{"$f":"+J11-N11","v":0},136125,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,687.5,{"$f":"SUM(J10:J13)","v":0},null,null,0,{"$f":"SUM(N10:N13)","v":0},687.5,{"$f":"SUM(P10:P13)","v":0},309375,{"$f":"SUM(R10:R13)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enterprise","Enterprise"]
["VARIABLE COSTS",null,null,"Quantity","Quantity","Units","$/Unit","$/Unit","Total","Total","Share","Share","Landlord","Landlord","Tenant","Tenant","Total","Total"]
["Production Costs"]
[null,"Custom"]
[null,"","Pre-Plant Fertilization",1,null,"Acre",9.36,null,9.36,{"$f":"E19*H19","v":0},0,null,0,{"$f":"J19*L19","v":0},9.36,{"$f":"+J19-N19","v":0},4212,{"$f":"+J19*E$7","v":0}]
[null,"","Survey Levees",1,null,"Acre",6,null,6,0,0,null,0,0,6,0,2700,0]
[null,"","Air Herbicide",1,null,"Acre",9,null,9,0,0,null,0,0,9,0,4050,0]
[null,"","Top Dress Fertilization",330,null,"Pound",0.09,null,29.7,0,0,null,0,0,29.7,0,13365,0]
[null,"","Air Insecticide",1,null,"Acre",9,null,9,0,0,null,0,0,9,0,4050,0]
[null,"","Rice Hauling",62.37,null,"CWT",0.3,null,18.710999999999999,0,0,null,0,0,18.710999999999999,0,8419.9499999999989,0]
[null,"","Rice Drying",62.37,null,"CWT",1.4,null,87.317999999999998,0,0,null,0,0,87.317999999999998,0,39293.1,0]
[null,"","Commission",55,null,"CWT",0.08,null,4.4000000000000004,0,0,null,0,0,4.4000000000000004,0,1980.0000000000002,0]
[null,"Fertilizer"]
[null,"","DAP (18-46-0)",100,null,"Pound",0.21,null,21,0,0,null,0,0,21,0,9450,0]
[null,"","Potash (0-0-60)",50,null,"Pound",0.13,null,6.5,0,0,null,0,0,6.5,0,2925,0]
[null,"","Urea (46-0-0)",330,null,"Pound",0.15,null,49.5,0,0,null,0,0,49.5,0,22275,0]
[null,"Herbicide"]
[null,"","Propanil",2,null,"Gallon",27.75,null,55.5,0,0,null,0,0,55.5,0,24975,0]
[null,"","Facet",1,null,"Quart",28.23,null,28.23,0,0,null,0,0,28.23,0,12703.5,0]
[null,"","Permit",1,null,"Ounce",21.25,null,21.25,0,0,null,0,0,21.25,0,9562.5,0]
[null,"Insecticide"]
[null,"","Mustang Max",3.2,null,"Ounce",1.1328125,null,3.625,0,0,null,0,0,3.625,0,1631.25,0]
[null,"Seed"]
[null,"","Seed - Rice",0.7,null,"CWT",53,null,37.099999999999994,0,0,null,0,0,37.099999999999994,0,16694.999999999996,0]
[null,"Fungicides"]
[null,"","Quilt XL",17,null,"Ounce",1.8,null,30.6,0,0,null,0,0,30.6,0,13770,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,"Water Cost",1,null,"Acre",45,null,45,{"$f":"E45*H45","v":0},0,null,0,{"$f":"J45*L45","v":0},45,{"$f":"+J45-N45","v":0},20250,{"$f":"+J45*E$7","v":0}]
[null,"Machinery Labor"]
[null,null,"Tractors/Self-Propelled",3.96,null,"Hour",13.75,null,54.45,{"$f":"E47*H47","v":0},0,null,0,{"$f":"J47*L47","v":0},54.45,{"$f":"+J47-N47","v":0},24502.5,{"$f":"+J47*E$7","v":0}]
[null,null,"Other Labor",0,null,"Hour",13.75,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,"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",14.77,null,"Gallon",2,null,29.54,{"$f":"E52*H52","v":0},0,null,0,{"$f":"J52*L52","v":0},29.54,{"$f":"+J52-N52","v":0},13293,{"$f":"+J52*E$7","v":0}]
[]
[null,"Gasoline"]
[null,null,"Pickup/General Use Equipment",1,null,"Acre",1.5833333333333333,null,1.5833333333333333,{"$f":"E55*H55","v":0},0,null,0,{"$f":"J55*L55","v":0},1.5833333333333333,{"$f":"+J55-N55","v":0},712.5,{"$f":"+J55*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",0,null,"Gallon",1.9,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",1.02,null,1.02,{"$f":"E59*H59","v":0},0,null,0,{"$f":"J59*L59","v":0},1.02,{"$f":"+J59-N59","v":0},459,{"$f":"+J59*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",35.439819229230423,null,35.439819229230423,0,0,null,0,0,35.439819229230423,0,15947.918653153691,0]
[null,null,"Implements",1,null,"Acre",28.899925117547202,null,28.899925117547202,0,0,null,0,0,28.899925117547202,0,13004.96630289624,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,0.05,null,8.4781315672458692,{"$f":"+SUM(J18:J64)/2*H65","v":0},null,null,0,{"$f":"+SUM(N18:N64)/2*L65","v":0},8.4781315672458692,{"$f":"+SUM(P18:P64)/2*L65","v":0},3815.1592052606411,{"$f":"+J65*E$7","v":0}]
["Total Variable Costs",null,null,null,null,null,null,null,631.20520924735706,{"$f":"SUM(J19:J65)","v":0},null,null,0,{"$f":"SUM(N19:N65)","v":0},631.20520924735706,{"$f":"SUM(P19:P65)","v":0},284042.34416131058,{"$f":"SUM(R19:R65)","v":0}]
["Planned Returns Above Variable Costs:",null,null,null,null,null,null,null,56.294790752642939,{"$f":"+J14-J66","v":0},null,null,0,{"$f":"+N14-N66","v":0},56.294790752642939,{"$f":"+P14-P66","v":0},25332.655838689418,{"$f":"+R14-R66","v":0}]
[null,"Breakeven Price to Cover Variable Costs",null,null,null,null,5.9764583499519466,{"$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",1.071,null,1.071,{"$f":"E72*H72","v":0},0,null,0,{"$f":"J72*L72","v":0},1.071,{"$f":"+J72-N72","v":0},481.95,{"$f":"+J72*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",1,null,"Acre",33.132473028501082,null,33.132473028501082,0,0,null,0,{"$f":"J73*L73","v":0},33.132473028501082,0,14909.612862825486,0]
[null,null,"Implements",1,null,"Acre",37.435455649154953,null,37.435455649154953,0,0,null,0,{"$f":"J74*L74","v":0},37.435455649154953,0,16845.955042119727,0]
[null,"Equipment Investment"]
[null,null,"Pickup/General Use Equipment",7.3949999999999987,null,"Dollars",0.05,null,0.36974999999999997,{"$f":"E76*H76","v":0},0,null,0,{"$f":"J76*L76","v":0},0.36974999999999997,{"$f":"+J76-N76","v":0},166.38749999999999,{"$f":"+J76*E$7","v":0}]
[null,null,"Tractors/Self-Propelled",255.02491891764882,null,"Dollars",0.05,null,12.751245945882442,0,0,null,0,{"$f":"J77*L77","v":0},12.751245945882442,0,5738.0606756470988,0]
[null,null,"Implements",171.77193913496532,null,"Dollars",0.05,null,8.5885969567482672,0,0,null,0,{"$f":"J78*L78","v":0},8.5885969567482672,0,3864.86863053672,0]
[null,"Salaried Labor",null,1,null,"Acre",0,null,0,0,0,null,0,{"$f":"J79*L79","v":0},0,{"$f":"+J79-N79","v":0},0,{"$f":"+J79*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 - Rice",null,1,null,"Acre",55,null,55,0,0,null,0,0,55,0,24750,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":"E86*H86","v":0},0,null,0,0,0,0,0,0]
["Total Fixed Costs",null,null,null,null,null,null,null,148.34852158028673,{"$f":"+SUM(J72:J86)","v":0},null,null,0,{"$f":"+SUM(N72:N86)","v":0},148.34852158028673,{"$f":"+SUM(P72:P86)","v":0},66756.834711129035,{"$f":"+SUM(R72:R86)","v":0}]
["Total Specified Costs",null,null,null,null,null,null,null,779.55373082764379,{"$f":"+J66+J87","v":0},null,null,0,{"$f":"+N66+N87","v":0},779.55373082764379,{"$f":"+P66+P87","v":0},350799.1788724396,{"$f":"+R66+R87","v":0}]
[]
["Returns Above Specified Costs",null,null,null,null,null,null,null,-92.05373082764379,{"$f":"+J14-J88","v":0},null,null,0,{"$f":"+N14-N88","v":0},-92.05373082764379,{"$f":"+P14-P88","v":0},-41424.178872439603,{"$f":"+R14-R88","v":0}]
[]
["    Breakeven Price to Cover Total Costs",null,null,null,null,null,8.6737041968662503,{"$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,41.25,7.9686111332692624,null,null,11.564938929155002]
[null,0.9,49.5,6.6405092777243855,null,null,9.637449107629168]
[null,1,55,5.9764583499519466,null,null,8.6737041968662503]
[null,1.1000000000000001,60.500000000000007,5.4331439545017686,null,null,7.8851856335147721]
[null,1.25,68.75,4.7811666799615571,null,null,6.9389633574930007]
[]
[null,null,null,"Your Breakeven Prices"]
[null,"Your","Your",null,"To Cover",null,null,"To Cover"]
[null,"Yield","Yield",null,"Variable",null,null,"Total"]
[null,"Percent","CWT",null,"Costs",null,null,"Costs"]
[null,0.75,{"$f":"E10*YPER1","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER1))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER1))","v":0}]
[null,0.9,{"$f":"E10*YPER2","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER2))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER2))","v":0}]
[null,1,{"$f":"+E10","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER3))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER3))","v":0}]
[null,1.1000000000000001,{"$f":"E10*YPER4","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER4))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER4))","v":0}]
[null,1.25,{"$f":"E10*YPER5","v":0},null,{"$f":"IF($E$10=0,0,(YVarExp-(YTotExp+YTotRet-J10))/($E$10*YPER5))","v":0},null,null,{"$f":"IF($E$10=0,0,(YTotExp-(YTotExp+YTotRet-J10))/($E$10*YPER5))","v":0}]
[]
["  Developed by Extension Economists, Texas A&M AgriLife Extension Service, budgets@tamu.edu.  "]
[]
["Information presented is prepared solely as a general guide and not intended to recognize or predict the costs and returns from any one operation.  Brand names are mentioned only as examples and imply no endorsement."]

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

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

{"sheet":"Comparative Returns - Cash Rent","index":6,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[[2,7,2,10],[2,4,2,5],[2,1,2,2]]}
["Comparative Returns - Cash Rent"]
[]
[null,"Returns Above Total Specified Expenses",null,null,"Total Direct Expenses",null,null,"Break-Even Yield to Cover Total Costs at Price Entered"]
[null,"Total","Variable",null,"Total","Variable",null,"Price","Units","Total","Variable"]
["CROPS"]
[]
[{"$f":"+Soybeans!A3","v":"Soybeans"},{"$f":"+Soybeans!TotRet","v":-93.988818650414657},{"$f":"+Soybeans!VarRet","v":-16.309399965827367},null,{"$f":"+Soybeans!TotExp","v":318.98881865041466},{"$f":"+Soybeans!VarExp","v":241.30939996582737},null,{"$f":"+Soybeans!Price","v":9},{"$f":"+Soybeans!Unit","v":"Bushel"},{"$f":"+IF($H7=0,0,E7/$H7)","v":35.443202072268292},{"$f":"+IF($H7=0,0,F7/$H7)","v":26.812155551758597}]
[{"$f":"+RRSoybeans!A3","v":"Roundup Ready Soybeans"},{"$f":"+RRSoybeans!TotRet","v":-87.344920025939587},{"$f":"+RRSoybeans!VarRet","v":-26.540392934431793},null,{"$f":"+RRSoybeans!TotExp","v":285.34492002593959},{"$f":"+RRSoybeans!VarExp","v":224.54039293443179},null,{"$f":"+RRSoybeans!Price","v":9},{"$f":"+RRSoybeans!Unit","v":"Bushel"},{"$f":"+IF($H8=0,0,E8/$H8)","v":31.704991113993287},{"$f":"+IF($H8=0,0,F8/$H8)","v":24.9489325482702}]
[{"$f":"+Rice!A3","v":"First Crop Rice (Jefferson-Liberty Counties)"},{"$f":"+Rice!TotRet","v":-92.05373082764379},{"$f":"+Rice!VarRet","v":56.294790752642939},null,{"$f":"+Rice!TotExp","v":779.55373082764379},{"$f":"+Rice!VarExp","v":631.20520924735706},null,{"$f":"+Rice!Price","v":7},{"$f":"+Rice!Unit","v":"CWT"},{"$f":"+IF($H9=0,0,E9/$H9)","v":111.36481868966339},{"$f":"+IF($H9=0,0,F9/$H9)","v":90.172172749622433}]

{"sheet":"Your Returns - Cash Rent","index":7,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[2,2,2,3],[2,5,2,6],[2,8,2,11]]}
["Your Returns - Cash Rent"]
[]
[null,"Quantity ","Returns Above Total Specified Expenses",null,null,"Total Direct Expenses",null,null,"Break-Even Yield to Cover Total Costs at Price Entered"]
[null,"Acres, AUs,  or Head","Total","Variable",null,"Total","Variable",null,"Price","Units","Total","Variable"]
["CROPS"]
[]
[{"$f":"+Soybeans!A3","v":"Soybeans"},{"$f":"+Soybeans!E7","v":0},{"$f":"+Soybeans!YTotRet","v":0},{"$f":"+Soybeans!YVarRet","v":0},null,{"$f":"+Soybeans!YTotExp","v":0},{"$f":"+Soybeans!YVarExp","v":0},null,{"$f":"+Soybeans!YPrice","v":0},{"$f":"+Soybeans!Unit","v":"Bushel"},{"$f":"+IF($I7=0,0,F7/$I7)","v":0},{"$f":"+IF($I7=0,0,G7/$I7)","v":0}]
[{"$f":"+RRSoybeans!A3","v":"Roundup Ready Soybeans"},{"$f":"+RRSoybeans!E7","v":0},{"$f":"+RRSoybeans!YTotRet","v":0},{"$f":"+RRSoybeans!YVarRet","v":0},null,{"$f":"+RRSoybeans!YTotExp","v":0},{"$f":"+RRSoybeans!YVarExp","v":0},null,{"$f":"+RRSoybeans!YPrice","v":0},{"$f":"+RRSoybeans!Unit","v":"Bushel"},{"$f":"+IF($I8=0,0,F8/$I8)","v":0},{"$f":"+IF($I8=0,0,G8/$I8)","v":0}]
[{"$f":"+Rice!A3","v":"First Crop Rice (Jefferson-Liberty Counties)"},{"$f":"+Rice!E7","v":0},{"$f":"+Rice!YTotRet","v":0},{"$f":"+Rice!YVarRet","v":0},null,{"$f":"+Rice!YTotExp","v":0},{"$f":"+Rice!YVarExp","v":0},null,{"$f":"+Rice!YPrice","v":0},{"$f":"+Rice!Unit","v":"CWT"},{"$f":"+IF($I9=0,0,F9/$I9)","v":0},{"$f":"+IF($I9=0,0,G9/$I9)","v":0}]
[]
["OTHER BUDGETS"]
[]
[{"$f":"+'Livestock Budget'!A3","v":"Livestock Enterprise"},{"$f":"+'Livestock Budget'!D5","v":0},{"$f":"+'Livestock Budget'!YTotRet","v":0},{"$f":"+'Livestock Budget'!YVarRet","v":0},null,{"$f":"+'Livestock Budget'!YTotExp","v":0},{"$f":"+'Livestock Budget'!YVarExp","v":0},null,{"$f":"+'Livestock Budget'!YPrice","v":0},{"$f":"+'Livestock Budget'!Unit","v":"CWT"},{"$f":"+IF($I13=0,0,F13/$I13)","v":0},{"$f":"+IF($I13=0,0,G13/$I13)","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"},0,0]