{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Introduction","Prices","Feed","Once a Year Lambing","Stocker","Feedlot"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":1,"defined_names":10,"comments":1,"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":"Introduction","index":0,"n_rows":49,"n_cols":12,"rows_kept":49,"cut":false,"hidden":false,"merged":[[48,1,49,12],[4,1,5,8],[4,13,5,23],[7,2,7,3],[7,4,7,5],[7,13,8,13],[28,1,29,11],[30,1,30,4],[31,1,32,11],[37,1,38,11],[43,1,43,3],[43,6,43,8]]}
[]
[]
[null,"KSU-Sheep Farm Management Guide Budgets"]
[]
[null,"Excel spreadsheet for sheep enterprise budgeting to evaluate potential income, costs and profitability"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Version- 3.2.2017"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"INTRODUCTION"]
[null,"The Kansas State University cost-return budgets were developed to serve as a barometer of profitability for various livestock industry enterprises.  These budgets are NOT intended to represent any one operation.  Each individual operation should adjust key inputs to reflect their own situation."]
[]
[null,"INSTRUCTIONS FOR THE USER:"]
[null,"Be sure to \"Enable Content\" and \"Enable Macros\" for the spreadsheet to function correctly.  Blue values are inputs that should be changed from the defaults to match your operation.  Black values are automatically calculated."]
[]
[]
[]
[]
[null,"FOR MORE INFORMATION:"]
[null,"Developed by:"]
[]
[null,"Dustin L. Pendell, Ph.D.",null,null,null,null,"Robin Reid"]
[null,"Agricultural Economist",null,null,null,null,"Extension Associate"]
[null,"Department of Agricultural Economics",null,null,null,null,"Department of Agricultural Economics"]
[null,"Kansas State University",null,null,null,null,"Kansas State University"]
[null,"dpendell@k-state.edu",null,null,null,null,"robinreid@ksu.edu"]
[null,"785-532-3525",null,null,null,null,"785-532-0964"]
[]
[]
[null,"ACKNOWLEDGEMENTS:"]
[null,"The authors would like to thank DeWayne Craghead, Hodgeman County Extension Agent, for assistance in developing this budget."]

{"sheet":"Prices","index":1,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Current Prices"]
["One Year Out Prices"]
[]
[null,{"$f":"A1","v":"Current Prices"},{"$f":"A2","v":"One Year Out Prices"}]
[null,"(as of March 1st, 2017)",{"$f":"B5","v":"(as of March 1st, 2017)"},"Notes/source"]
["Protein Supplement ($/ton)",316.8,319.10000000000002,"USE deferred CME C to Adjust off of Current price",null,"http://www.usda.gov/oce/commodity/projections/"]
["Grain Sorghum ($/cwt)",5.76,6.3226820809248565,"USE deferred CME SB to Adjust off of Current price",null,"http://www.usda.gov/oce/commodity/projections/"]
[]
["Silage ($/ton)",27.68,30.384000000000004,0,null,"Equal to 8X the corn price"]
["Prairie Hay ($/ton)",65,71.349710982658976,0,null,"Adjust off of Corn Price"]
["Alfalfa ($/ton)",100,109.76878612716764,0,null,"Adjust off of Corn Price"]
["Pasture Rental ($/acre)",20,20.399999999999999,0,null,"Current price *1.10"]
["Sheep Mineral ($/lb)",0.5,0.51,0,null,"Current price *1.10"]
[]
["Sept. Slaughter Lamb Price ($/cwt)",145.47,143.69]
["Current Cull Ewe Price ($/cwt)",46.82,46.18,0,null,"http://www.usda.gov/oce/commodity/projections/"]

{"sheet":"Feed","index":2,"n_rows":28,"n_cols":10,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,1,0,11]]}
[null,"SHEEP RATIONS TO SET FEED AND GRAZING COSTS"]
[]
[null,"Ewe Feed Requirements ","(per ewe unit: ewes, rams, retained/replaced ewes, and lambs)",null,null,null,null,"Stocker Feed Requirements ","(per animal unit)"]
[null,null,"Qty","Unit",null,null,null,null,"Qty","Unit"]
[null,"Pasture",1,"total acres per year",null,null,null,"Pasture",4,"total acres for feeding period"]
[null,"Silage",730,"total lbs per year",null,null,null,"Crop Residue",0,"total acres for feeding period"]
[null,"Alfalfa",457,"total lbs per year",null,null,null,"Prairie/Brome Hay",0,"total tons for feeding period"]
[null,"Prairie Hay",0,"total lbs per year",null,null,null,"Silage",0,"total tons for feeding period"]
[null,"Total Harvested Forage",{"$f":"SUM(C6:C8)","v":1187},"total lbs per year",null,null,null,"Alfalfa",0,"total tons for feeding period"]
[null,"Grain Sorghum",630,"total lbs per year",null,null,null,"Total Harvested Forage",{"$f":"SUM(I7:I9)","v":0},"total tons for feeding period"]
[null,"Protein Supplement",42,"total lbs per year",null,null,null,"Corn",0,"total pounds for feeding period"]
[null,"Total Grain/Protein Supplements",{"$f":"SUM(C10:C11)","v":672},"total lbs per year",null,null,null,"Soybean Meal",0,"total pounds for feeding period"]
[null,"Mineral",19,"total lbs per year",null,null,null,"Total Grain/Protein Supplements",{"$f":"SUM(I11:I12)","v":0},"total pounds for feeding period"]
[null,null,null,null,null,null,null,"Salt and Mineral",{"$f":"0.25*150","v":37.5},"total pounds for feeding period"]
[]
[null,"Backgrounding Feed Requirements ","(per animal unit) "]
[null,null,"Qty","Unit",null,null,null,"Finishing Feed Requirements ","(per animal unit) "]
[null,"Pasture",0,"total acres for feeding period",null,null,null,null,"Qty","Unit"]
[null,"Crop Residue",0,"total acres for feeding period",null,null,null,"Prairie/Brome Hay",1.5,"lbs/day"]
[null,{"$f":"IF(C1=Prices!A1,((Feed!C13*Prices!B11)),IF(C1=Prices!A2,((Feed!C13*Prices!C12)),IF(C1=Prices!A3,((Feed!C9/Feed!#REF!)*Prices!#REF!)+((Feed!C10/Feed!#REF!)*Prices!#REF!)+((Feed!C11/Feed!#REF!)*Prices!#REF!),\"\")))","v":{"$error":"#REF!"}},3.5,"lbs/day",null,null,null,"Silage",0,"lbs/day"]
[null,"Silage",0,"lbs/day",null,null,null,"Alfalfa",1.5,"lbs/day"]
[null,"Alfalfa",3.5,"lbs/day",null,null,null,"Total Harvested Forage",{"$f":"SUM(I19:I21)","v":3},"lbs/day"]
[null,"Total Harvested Forage",{"$f":"SUM(C20:C22)","v":7},"lbs/day",null,null,null,"Corn",17,"lbs/day"]
[null,"Corn",7,"lbs/day",null,null,null,"DDG's",5,"lbs/day"]
[null,"DDG's",7,"lbs/day",null,null,null,"Soybean Meal",0,"lbs/day"]
[null,"Soybean Meal",0,"lbs/day",null,null,null,"Total Grain/Protein Supplements",{"$f":"SUM(I23:I25)","v":22},"lbs/day"]
[null,"Total Grain/Protein Supplements",{"$f":"SUM(C24:C26)","v":14},"lbs/day",null,null,null,"Salt and Mineral",0.5,"lbs/day"]
[null,"Salt and Mineral",0.3,"lbs/day"]

{"sheet":"Once a Year Lambing","index":3,"n_rows":131,"n_cols":12,"rows_kept":131,"cut":false,"hidden":false,"merged":[[93,8,93,9],[130,8,130,9],[122,2,122,3],[121,2,121,3],[95,0,95,1],[95,2,95,5],[95,6,95,9],[113,2,113,3],[129,0,129,9],[116,2,116,3],[117,2,117,3],[118,2,118,3],[119,2,119,3],[120,2,120,3],[114,2,114,3],[115,2,115,3],[45,0,45,9],[0,0,0,1],[0,2,0,5],[0,6,0,9],[92,0,92,9],[48,0,48,1],[48,2,48,5],[48,6,48,9],[46,8,46,9]]}
[" KSU Once-a-Year Lambing Budget",null,"Current Prices",null,null,null,{"$f":"IF(C1=Prices!B4,TEXT(Prices!B5,\"MMM-YYYY\"),IF(C1=Prices!C4,TEXT(Prices!C5,\"MMM-YYYY\"),TEXT(Prices!#REF!,\"MMM-YYYY\")))","v":"(as of March 1st, 2017)"}]
[null,null,null,null,null,null,null,null,null,null,null,"Click on \"Current Prices\" to change to \"One Year Out Prices \" or \"Five Years Out Prices\"\n"]
["Production Efficiency Information"]
["Lamb Crop Percentage",1.8]
["Ewe Replacement Percentage",0.15]
[]
["Revenue","Price","Unit",null,"Lbs.","Unit",null,null,null,"Total per Year per Ewe"]
["Slaughter Lambs",{"$f":"IF(C1=Prices!A1,Prices!B15,IF(C1=Prices!A2,Prices!C15,\"\"))","v":145.47},"per cwt"," x",130,"lbs."," x",{"$f":"B4-IF(B21=0,B5,0)","v":1.6500000000000001}," =",{"$f":"B8*(E8/100)*H8","v":312.03315000000003}]
["Cull Ewes",{"$f":"IF(C1=Prices!A1, Prices!B16, IF(C1=Prices!A2, Prices!C16, \"\"))","v":46.82},"per cwt"," x",150,"lbs."," x",{"$f":"B5","v":0.15}," =",{"$f":"B9*(E9/100)*H9","v":10.5345}]
["Other Income",null,null,null,null,null,null,null,null,0]
[]
["  Gross Income",null,null,null,null,null,null,null,null,{"$f":"SUM(J8:J10)","v":322.56765000000001}]
[]
["Variable Costs"]
["Pasture",{"$f":"IF(C1=Prices!A1, Prices!B12, IF(C1=Prices!A2, Prices!C12, \"\"))","v":20},"per acre"," x",{"$f":"Feed!C5","v":1},"total acres",null,null,"=",{"$f":"B15*E15","v":20}]
["Harvested Forage",{"$f":"IF(C1=Prices!A1,(((Feed!C8/Feed!C9)*Prices!B10)+((Feed!C6/Feed!C9)*Prices!B9)+((Feed!C7/Feed!C9)*Prices!B11)),IF(C1=Prices!A2,(((Feed!C8/Feed!C9)*Prices!C10)+((Feed!C6/Feed!C9)*Prices!C9)+((Feed!C7/Feed!C9)*Prices!C11)),\"\"))","v":55.523504633529903},"per ton"," x",{"$f":"Feed!C9","v":1187},"total lbs",null,null,"=",{"$f":"B16*E16/2000","v":32.953199999999995}]
["Grain/Protein Supplements",{"$f":"IF(C1=Prices!A1,(((Feed!C10/Feed!C12)*(Prices!B7*2000/100))+((Feed!C11/Feed!C12)*Prices!B6)),IF(C1=Prices!A2,(((Feed!C10/Feed!C12)*(Prices!C7*2000/100))+((Feed!C11/Feed!C12)*Prices!C6)),\"\"))","v":127.8},"per ton","X",{"$f":"Feed!C12","v":672},"total lbs",null,null,"=",{"$f":"B17*E17/2000","v":42.940799999999996}]
["Mineral",{"$f":"IF(C1=Prices!A1,Prices!B13, IF(C1=Prices!A2,Prices!C13, \"\"))","v":0.5},"per ton","X",{"$f":"Feed!C13","v":19},"total lbs",null,null,"=",{"$f":"B18*E18/2000","v":4.7499999999999999E-3}]
["Other Feed",0,"per unit","X",0,"units",null,null,"=",{"$f":"B19*E19","v":0}]
["Labor",20,"per hour","x",4.2,"total hours",null,null,"=",{"$f":"B20*E20","v":84}]
["Replacement Ewe",0,"per head","x",{"$f":"B5","v":0.15},"hd",null,null,null,{"$f":"E21*B21","v":0}]
["Ram Charge",null,null,null,null,null,null,null,null,{"$f":"(550-65)/5*2.5%","v":2.4250000000000003}]
["Vet Medicine/Drugs",null,null,null,null,null,null,null,null,6]
["Other Livestock Breeding/Marketing",null,null,null,null,null,null,null,null,4]
["Shearing",null,null,null,null,null,null,null,null,5]
["Utilities,Gas, Fuel, Oil",null,null,null,null,null,null,null,null,6.5]
["Machinery, Facility/Equip. Repairs",null,null,null,null,null,null,null,null,6]
["Other Variable Costs",null,null,null,null,null,null,null,null,0]
["Cash Interest Paid",null,null,null,null,null,null,null,null,8.5]
["  Total Variable Costs",null,null,null,null,null,null,null,null,{"$f":"SUM(J15:J29)","v":218.32375000000002}]
[]
["Fixed Costs"]
["Depreciation - Buildings/Equipment",null,null,null,null,null,null,null,null,15]
["Depreciation - Livestock",null,null,null,null,null,null,null,null,1]
["Taxes/Insurance - Farm & Livestock",null,null,null,null,null,null,null,null,5]
["Interest - Buildings/Equipment & Livestock",null,null,null,null,null,null,null,null,17]
["Other Fixed Costs",null,null,null,null,null,null,null,null,0]
["  Total Fixed Costs",null,null,null,null,null,null,null,null,{"$f":"SUM(J33:J37)","v":38}]
[]
["Total Costs",null,null,null,null,null,null,null,null,{"$f":"J30+J38","v":256.32375000000002}]
[]
["Income Over Variable Costs",null,null,null,null,null,null,null,null,{"$f":"J12-J30","v":104.2439}]
["Income Over Total Costs ",null,null,null,null,null,null,null,null,{"$f":"J12-J40","v":66.243899999999996}]
[]
[]
["Kansas State University, Department of Agricultural Economics - www.agmanager.info"]
["Publication: AM-FMG-Once-a-Year Lambing",null,null,null,null,null,null,null,{"$f":"Introduction!L8","v":"Version- 3.2.2017"}]
[]
[" KSU Once-a-Year Lambing Budget"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Kansas State University, Department of Agricultural Economics - www.agmanager.info"]
[{"$f":"A47","v":"Publication: AM-FMG-Once-a-Year Lambing"},null,null,null,null,null,null,null,{"$f":"I47","v":"Version- 3.2.2017"}]
[]
[" KSU Ewe Once-a-Year Lambing Budget"]
["Budget Assumptions"]
[]
["Per Ewe Feed Requirements ","(ewe, ram, retained/replaced ewes, lamb)"]
[null,"Qty","Unit"]
[{"$f":"Feed!B5","v":"Pasture"},{"$f":"Feed!C5","v":1},{"$f":"Feed!D5","v":"total acres per year"}]
[{"$f":"Feed!B6","v":"Silage"},{"$f":"Feed!C6","v":730},{"$f":"Feed!D6","v":"total lbs per year"}]
[{"$f":"Feed!B7","v":"Alfalfa"},{"$f":"Feed!C7","v":457},{"$f":"Feed!D7","v":"total lbs per year"}]
[{"$f":"Feed!B8","v":"Prairie Hay"},{"$f":"Feed!C8","v":0},{"$f":"Feed!D8","v":"total lbs per year"}]
[{"$f":"Feed!B9","v":"Total Harvested Forage"},{"$f":"Feed!C9","v":1187},{"$f":"Feed!D9","v":"total lbs per year"}]
[{"$f":"Feed!B10","v":"Grain Sorghum"},{"$f":"Feed!C10","v":630},{"$f":"Feed!D10","v":"total lbs per year"}]
[{"$f":"Feed!B11","v":"Protein Supplement"},{"$f":"Feed!C11","v":42},{"$f":"Feed!D11","v":"total lbs per year"}]
[{"$f":"Feed!B12","v":"Total Grain/Protein Supplements"},{"$f":"Feed!C12","v":672},{"$f":"Feed!D12","v":"total lbs per year"}]
[{"$f":"Feed!B13","v":"Mineral"},{"$f":"Feed!C13","v":19},{"$f":"Feed!D13","v":"total lbs per year"}]
[]
[]
[]
["Default Sheep Prices"]
[null,"Current","One Year Out"]
[{"$f":"Prices!A6","v":"Protein Supplement ($/ton)"},{"$f":"Prices!B6","v":316.8},{"$f":"Prices!C6","v":319.10000000000002}]
[{"$f":"Prices!A7","v":"Grain Sorghum ($/cwt)"},{"$f":"Prices!B7","v":5.76},{"$f":"Prices!C7","v":6.3226820809248565}]
[{"$f":"Prices!A9","v":"Silage ($/ton)"},{"$f":"Prices!B9","v":27.68},{"$f":"Prices!C9","v":30.384000000000004}]
[{"$f":"Prices!A10","v":"Prairie Hay ($/ton)"},{"$f":"Prices!B10","v":65},{"$f":"Prices!C10","v":71.349710982658976}]
[{"$f":"Prices!A11","v":"Alfalfa ($/ton)"},{"$f":"Prices!B11","v":100},{"$f":"Prices!C11","v":109.76878612716764}]
[{"$f":"Prices!A12","v":"Pasture Rental ($/acre)"},{"$f":"Prices!B12","v":20},{"$f":"Prices!C12","v":20.399999999999999}]
[{"$f":"Prices!A13","v":"Sheep Mineral ($/lb)"},{"$f":"Prices!B13","v":0.5},{"$f":"Prices!C13","v":0.51}]
[{"$f":"Prices!A15","v":"Sept. Slaughter Lamb Price ($/cwt)"},{"$f":"Prices!B15","v":145.47},{"$f":"Prices!C15","v":143.69}]
[{"$f":"Prices!A16","v":"Current Cull Ewe Price ($/cwt)"},{"$f":"Prices!B16","v":46.82},{"$f":"Prices!C16","v":46.18}]
[]
[]
[]
[]
[]
[]
["Kansas State University, Department of Agricultural Economics - www.agmanager.info"]
[{"$f":"A47","v":"Publication: AM-FMG-Once-a-Year Lambing"},null,null,null,null,null,null,null,{"$f":"I94","v":"Version- 3.2.2017"}]

{"sheet":"Stocker","index":4,"n_rows":136,"n_cols":12,"rows_kept":136,"cut":false,"hidden":true,"merged":[[0,0,0,1],[4,2,4,4],[0,2,0,5],[0,6,0,9],[43,0,43,9],[46,0,46,1],[46,2,46,5],[46,6,46,9],[90,0,90,9],[93,0,93,1],[93,2,93,5],[93,6,93,9],[114,2,114,3],[114,4,114,5],[115,2,115,3],[115,4,115,5],[116,2,116,3],[116,4,116,5],[122,4,122,5],[117,2,117,3],[117,4,117,5],[118,2,118,3],[118,4,118,5],[119,2,119,3],[119,4,119,5],[126,2,126,3],[126,4,126,5],[134,0,134,9],[5,2,5,4],[3,8,3,9],[123,2,123,3],[123,4,123,5],[124,2,124,3],[124,4,124,5],[125,2,125,3],[125,4,125,5],[120,2,120,3],[120,4,120,5],[121,2,121,3],[121,4,121,5],[122,2,122,3]]}
[" KSU Beef Stocker Budget",null,"Current Prices",null,null,null,{"$f":"IF(C1=Prices!B4,TEXT(Prices!B5,\"MMM-YYYY\"),IF(C1=Prices!C4,TEXT(Prices!C5,\"MMM-YYYY\"),TEXT(Prices!#REF!,\"MMM-YYYY\")))","v":"(as of March 1st, 2017)"}]
[null,null,null,null,null,null,null,null,null,null,null,"Click on \"Current Prices\" to change to \"One Year Out Prices \" or \"Five Years Out Prices\"\n"]
["Production Efficiency Information"]
["Death Loss",0.01,null,null,null,null,null,null,"CWT Produced"]
["Days on Grass",150,"Average Daily Gain",null,null,1.25,null,null,null,{"$f":"(E9-E10)/100","v":{"$error":"#REF!"}}]
[]
[]
["Gross Return","Price","Unit",null,"Qty","Unit",null,null,null,"Total per Year"]
["Feeder Sale",{"$f":"(IF(C1=Prices!A1,Prices!#REF!,IF(C1=Prices!A2,Prices!#REF!,IF(C1=Prices!A3,Prices!#REF!,\"\"))))","v":{"$error":"#REF!"}},"per cwt","x",{"$f":"E10+(B5*F5)","v":{"$error":"#REF!"}},"lbs",null,null," =",{"$f":"B9*(E9/100)","v":{"$error":"#REF!"}}]
["Purchase price",{"$f":"(IF(C1=Prices!A1,Prices!B16,IF(C1=Prices!A2,Prices!C16,IF(C1=Prices!A3,Prices!#REF!,\"\"))))","v":46.82},"per cwt","x",{"$f":"'Once a Year Lambing'!#REF!","v":{"$error":"#REF!"}},"lbs",null,null,"=",{"$f":"-(B10*(E10/100))","v":{"$error":"#REF!"}}]
["Death Loss",null,null,null,null,null,null,null,null,{"$f":"(B4*J10)","v":{"$error":"#REF!"}}]
["Other"]
["Total Gross Return",null,null,null,null,null,null,null,null,{"$f":"SUM(J9:J12)","v":{"$error":"#REF!"}}]
[]
["Variable Costs"]
["Pasture",{"$f":"IF(C1=Prices!A1, Prices!B12, IF(C1=Prices!A2, Prices!C12, IF(C1=Prices!A3,Prices!#REF!, \"\")))","v":20},"per acre","x",{"$f":"Feed!I5","v":4},"total acres",null,null," =",{"$f":"B16*E16","v":80}]
["Crop Residue",{"$f":"IF(C1=Prices!A1, Prices!#REF!, IF(C1=Prices!A2, Prices!#REF!, IF(C1=Prices!A3,Prices!#REF!, \"\")))","v":{"$error":"#REF!"}},"per acre","x",{"$f":"Feed!I6","v":0},"total acres",null,null," =",{"$f":"B17*E17","v":{"$error":"#REF!"}}]
["Harvested Forage",{"$f":"IF(Feed!I10>0,(IF(C1=Prices!A1,(((Feed!I7/Feed!I10)*Prices!B10)+((Feed!I8/Feed!I10)*Prices!B9)+((Feed!I9/Feed!I10)*Prices!B11)),IF(C1=Prices!A2,(((Feed!I7/Feed!I10)*Prices!C10)+((Feed!I8/Feed!I10)*Prices!C9)+((Feed!I9/Feed!I10)*Prices!C11)),IF(C1=Prices!A3,((Feed!I7/Feed!I10)*Prices!#REF!)+((Feed!I8/Feed!I10)*Prices!#REF!)+((Feed!I9/Feed!I10)*Prices!#REF!),\"\")))),0)","v":0},"per ton","x",{"$f":"Feed!I10","v":0},"total tons",null,null," =",{"$f":"B18*E18","v":0}]
["Grain/Protein Supplements",{"$f":"IF(Feed!I13>0,(IF(C1=Prices!A1,(((Feed!I12/Feed!I13)*Prices!B7)+((Feed!#REF!/Feed!I13)*Prices!#REF!)+((Feed!I11/Feed!I13)*(Prices!B6*2000)/56)),IF(C1=Prices!A2,(((Feed!I12/Feed!I13)*Prices!C7)+((Feed!#REF!/Feed!I13)*Prices!#REF!)+((Feed!I11/Feed!I13)*(Prices!C6*2000)/56)),IF(C1=Prices!A3,(((Feed!I12/Feed!I13)*Prices!#REF!)+((Feed!#REF!/Feed!I13)*Prices!#REF!)+((Feed!I11/Feed!I13)*(Prices!#REF!*2000)/56)),\"\")))),0)","v":0},"per ton","x",{"$f":"Feed!I13","v":0},"total lbs",null,null," =",{"$f":"(B19/2000)*E19","v":0}]
["Mineral",{"$f":"IF(C1=Prices!A1,Prices!#REF!, IF(C1=Prices!A2,Prices!#REF!, IF(C1=Prices!A3,Prices!#REF!, \"\")))","v":{"$error":"#REF!"}},"per ton","x",{"$f":"Feed!I14","v":37.5},"total lbs",null,null," =",{"$f":"(B20/2000)*E20","v":{"$error":"#REF!"}}]
["Other Feed",0,"per unit","x",0,"units",null,null,"=",{"$f":"B21*E21","v":0}]
["Labor",20,"per hour","x",{"$f":"0.2*(B5/30)","v":1},"hours",null,null," =",{"$f":"B22*E22","v":20}]
["Vet Medicine/Drugs",null,null,null,null,null,null,null,null,{"$f":"ROUND(3.99*J5,0)","v":{"$error":"#REF!"}}]
["Marketing costs",null,null,null,null,null,null,null,null,{"$f":"ROUND(5.61*J5,0)","v":{"$error":"#REF!"}}]
["Utilities,Gas, Fuel, Oil",null,null,null,null,null,null,null,null,{"$f":"ROUND(3.25*J5,0)","v":{"$error":"#REF!"}}]
["Machinery, Facility/Equip. Repairs",null,null,null,null,null,null,null,null,{"$f":"ROUND(5.46*J5,0)","v":{"$error":"#REF!"}}]
["Cash Interest Paid",null,null,null,null,null,null,null,null,{"$f":"ROUND(3.55*J5,0)","v":{"$error":"#REF!"}}]
["Other variable costs",null,null,null,null,null,null,null,null,{"$f":"ROUND(1.29*J5,0)","v":{"$error":"#REF!"}}]
["  Total Variable Costs",null,null,null,null,null,null,null,null,{"$f":"SUM(J16:J28)","v":{"$error":"#REF!"}}]
[]
["Fixed Costs"]
["Depreciation",null,null,null,null,null,null,null,null,10]
["Taxes",null,null,null,null,null,null,null,null,1.25]
["Farm/Livestock Insurance",null,null,null,null,null,null,null,null,1.5]
["Opportunity Cost of Investment",null,null,null,null,null,null,null,null,23]
["Other fixed costs",null,null,null,null,null,null,null,null,0]
["  Total Fixed Costs",null,null,null,null,null,null,null,null,{"$f":"SUM(J32:J36)","v":35.75}]
[]
["Total Costs",null,null,null,null,null,null,null,null,{"$f":"J29+J37","v":{"$error":"#REF!"}}]
[]
["Income Over Variable Costs",null,null,null,null,null,null,null,null,{"$f":"J13-J29","v":{"$error":"#REF!"}}]
["Income Over Total Costs ",null,null,null,null,null,null,null,null,{"$f":"J13-J39","v":{"$error":"#REF!"}}]
[]
["Kansas State University, Department of Agricultural Economics - www.agmanager.info"]
["Publication: AM-FMG-Stocker",null,null,null,null,null,null,null,null,{"$f":"TEXT(#REF!,\"MMM. DD, YYYY\")","v":{"$error":"#REF!"}}]
[]
[" KSU Beef Stocker Budget"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Kansas State University, Department of Agricultural Economics - www.agmanager.info"]
["Publication: AM-FMG-Stocker",null,null,null,null,null,null,null,null,{"$f":"J45","v":{"$error":"#REF!"}}]
[]
[" KSU Beef Stocker Budget"]
["Budget Assumptions"]
[]
["Stocker Feed Requirements ","(per animal unit)"]
[null,"Qty","Unit"]
["Pasture",{"$f":"Feed!I5","v":4},"total acres for feeding period"]
["Crop Residue",{"$f":"Feed!I6","v":0},"total acres for feeding period"]
["Prairie/Brome Hay",{"$f":"Feed!I7","v":0},"total tons for feeding period"]
["Silage",{"$f":"Feed!I8","v":0},"total tons for feeding period"]
["Alfalfa",{"$f":"Feed!I9","v":0},"total tons for feeding period"]
["Total Harvested Forage",{"$f":"Feed!I10","v":0},"total tons for feeding period"]
["Corn",{"$f":"Feed!I11","v":0},"total pounds for feeding period"]
["DDG's",{"$f":"Feed!#REF!","v":{"$error":"#REF!"}},"total pounds for feeding period"]
["Soybean Meal",{"$f":"Feed!I12","v":0},"total pounds for feeding period"]
["Total Grain/Protein Supplements",{"$f":"Feed!I13","v":0},"total pounds for feeding period"]
["Salt and Mineral",{"$f":"Feed!I14","v":37.5},"total pounds for feeding period"]
[]
[]
[]
[]
["Default Stocker Prices"]
[null,"Current","One Year Out",null,"Five Years Out"]
["Heifer Calf Price ($/cwt)",{"$f":"Prices!#REF!","v":{"$error":"#REF!"}},{"$f":"Prices!#REF!","v":{"$error":"#REF!"}},null,{"$f":"Prices!#REF!","v":{"$error":"#REF!"}}]
["Steer Calf Price ($/cwt)",{"$f":"Prices!B16","v":46.82},{"$f":"Prices!C16","v":46.18},null,{"$f":"Prices!#REF!","v":{"$error":"#REF!"}}]
["Feeder Steers($/cwt)",{"$f":"Prices!#REF!","v":{"$error":"#REF!"}},{"$f":"Prices!#REF!","v":{"$error":"#REF!"}},null,{"$f":"Prices!#REF!","v":{"$error":"#REF!"}}]
["Corn ($/bu)",{"$f":"Prices!B6","v":316.8},{"$f":"Prices!C6","v":319.10000000000002},null,{"$f":"Prices!#REF!","v":{"$error":"#REF!"}}]
["Soybean meal ($/ton)",{"$f":"Prices!B7","v":5.76},{"$f":"Prices!C7","v":6.3226820809248565},null,{"$f":"Prices!#REF!","v":{"$error":"#REF!"}}]
["Distillers Grains ($/ton)",{"$f":"Prices!#REF!","v":{"$error":"#REF!"}},{"$f":"Prices!#REF!","v":{"$error":"#REF!"}},null,{"$f":"Prices!#REF!","v":{"$error":"#REF!"}}]
["Silage ($/ton)",{"$f":"Prices!B9","v":27.68},{"$f":"Prices!C9","v":30.384000000000004},null,{"$f":"Prices!#REF!","v":{"$error":"#REF!"}}]
["Hay ($/ton)",{"$f":"Prices!B10","v":65},{"$f":"Prices!C10","v":71.349710982658976},null,{"$f":"Prices!#REF!","v":{"$error":"#REF!"}}]
["Alfalfa ($/ton)",{"$f":"Prices!B11","v":100},{"$f":"Prices!C11","v":109.76878612716764},null,{"$f":"Prices!#REF!","v":{"$error":"#REF!"}}]
["Pasture Rental ($/acre)",{"$f":"Prices!B12","v":20},{"$f":"Prices!C12","v":20.399999999999999},null,{"$f":"Prices!#REF!","v":{"$error":"#REF!"}}]
["Crop Residue ($/acre)",{"$f":"Prices!#REF!","v":{"$error":"#REF!"}},{"$f":"Prices!#REF!","v":{"$error":"#REF!"}},null,{"$f":"Prices!#REF!","v":{"$error":"#REF!"}}]
["Mineral ($/ton)",{"$f":"Prices!#REF!","v":{"$error":"#REF!"}},{"$f":"Prices!#REF!","v":{"$error":"#REF!"}},null,{"$f":"Prices!#REF!","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
[]
["Kansas State University, Department of Agricultural Economics - www.agmanager.info"]
["Publication: AM-FMG-Stocker",null,null,null,null,null,null,null,null,{"$f":"J92","v":{"$error":"#REF!"}}]

{"sheet":"Feedlot","index":5,"n_rows":134,"n_cols":12,"rows_kept":134,"cut":false,"hidden":true,"merged":[[0,0,0,1],[0,2,0,5],[0,6,0,9],[4,2,4,4],[42,0,42,9],[45,0,45,1],[45,2,45,5],[45,6,45,9],[89,0,89,9],[92,0,92,1],[92,2,92,5],[92,6,92,9],[116,2,116,3],[116,4,116,5],[117,2,117,3],[117,4,117,5],[113,2,113,3],[113,4,113,5],[114,2,114,3],[114,4,114,5],[115,2,115,3],[115,4,115,5],[124,2,124,3],[124,4,124,5],[132,0,132,9],[3,8,3,9],[121,2,121,3],[121,4,121,5],[122,2,122,3],[122,4,122,5],[123,2,123,3],[123,4,123,5],[118,2,118,3],[118,4,118,5],[119,2,119,3],[119,4,119,5],[120,2,120,3],[120,4,120,5]]}
[" KSU Beef Finishing Budget",null,"Current Prices",null,null,null,{"$f":"IF(C1=Prices!B4,TEXT(Prices!B5,\"MMM-YYYY\"),IF(C1=Prices!C4,TEXT(Prices!C5,\"MMM-YYYY\"),TEXT(Prices!#REF!,\"MMM-YYYY\")))","v":"(as of March 1st, 2017)"}]
[null,null,null,null,null,null,null,null,null,null,null,"Click on \"Current Prices\" to change to \"One Year Out Prices \" or \"Five Years Out Prices\"\n"]
["Production Efficiency Information"]
["Death Loss",1.4999999999999999E-2,null,null,null,null,null,null,"CWT Produced"]
["Days on Feed",160,"Average Daily Gain",null,null,3.7,null,null,null,{"$f":"(E8-E9)/100","v":5.92}]
[]
["Gross Return","Price","Unit",null,"Qty","Unit",null,null,null,"Total per Year"]
["Fed Animal Sale",{"$f":"(IF(C1=Prices!A1,Prices!#REF!,IF(C1=Prices!A2,Prices!#REF!,IF(C1=Prices!A3,Prices!#REF!,\"\"))))","v":{"$error":"#REF!"}},"per cwt","x",{"$f":"E9+(B5*F5)","v":1367},"lbs",null,null,"=",{"$f":"B8*(E8/100)","v":{"$error":"#REF!"}}]
["Purchase price",{"$f":"(IF(C1=Prices!A1,Prices!#REF!,IF(C1=Prices!A2,Prices!#REF!,IF(C1=Prices!A3,Prices!#REF!,\"\"))))","v":{"$error":"#REF!"}},"per cwt","x",775,"lbs",null,null,"=",{"$f":"-(B9*(E9/100))","v":{"$error":"#REF!"}}]
["Death Loss",null,null,null,null,null,null,null,null,{"$f":"(B4*J9)","v":{"$error":"#REF!"}}]
["Other"]
["Total Gross Return",null,null,null,null,null,null,null,null,{"$f":"SUM(J8:J11)","v":{"$error":"#REF!"}}]
[]
["Variable Costs"]
["Harvested Forage",{"$f":"IF(C1=Prices!A1,(((Feed!I19/Feed!I22)*Prices!B10)+((Feed!I20/Feed!I22)*Prices!B9)+((Feed!I21/Feed!I22)*Prices!B11)),IF(C1=Prices!A2,(((Feed!I19/Feed!I22)*Prices!C10)+((Feed!I20/Feed!I22)*Prices!C9)+((Feed!I21/Feed!I22)*Prices!C11)),IF(C1=Prices!A3,((Feed!I19/Feed!I22)*Prices!#REF!)+((Feed!I20/Feed!I22)*Prices!#REF!)+((Feed!I21/Feed!I22)*Prices!#REF!),\"\")))","v":82.5},"per ton","x",{"$f":"(Feed!I22*Feedlot!B5)/2000","v":0.24},"total tons",null,null," =",{"$f":"B15*E15","v":19.8}]
["Grain/Protein Supplements",{"$f":"IF(C1=Prices!A1,(((Feed!I25/Feed!I26)*Prices!B7)+((Feed!I24/Feed!I26)*Prices!#REF!)+((Feed!I23/Feed!I26)*(Prices!B6*2000)/56)),IF(C1=Prices!A2,(((Feed!I25/Feed!I26)*Prices!C7)+((Feed!I24/Feed!I26)*Prices!#REF!)+((Feed!I23/Feed!I26)*(Prices!C6*2000)/56)),IF(C1=Prices!A3,(((Feed!I25/Feed!I26)*Prices!#REF!)+((Feed!I24/Feed!I26)*Prices!#REF!)+((Feed!I23/Feed!I26)*(Prices!#REF!*2000)/56)),\"\")))","v":{"$error":"#REF!"}},"per ton","x",{"$f":"Feed!I26*B5","v":3520},"total lbs",null,null," =",{"$f":"(B16/2000)*E16","v":{"$error":"#REF!"}}]
["Mineral",{"$f":"IF(C1=Prices!A1,Prices!#REF!, IF(C1=Prices!A2,Prices!#REF!, IF(C1=Prices!A3,Prices!#REF!, \"\")))","v":{"$error":"#REF!"}},"per ton","x",{"$f":"Feed!I27*B5","v":80},"total lbs",null,null," =",{"$f":"(B17/2000)*E17","v":{"$error":"#REF!"}}]
["Other Feed",0,"per unit","x",0,"units",null,null,"=",{"$f":"B18*E18","v":0}]
["Labor",20,"per hour","x",{"$f":"(B5/30)*0.15","v":0.79999999999999993},"hours",null,null," =",{"$f":"B19*E19","v":15.999999999999998}]
["Vet Medicine/Drugs",null,null,null,null,null,null,null,null,{"$f":"ROUND(3.39*J5,0)","v":20}]
["Marketing costs",null,null,null,null,null,null,null,null,{"$f":"ROUND(1.91*J5,0)","v":11}]
["Utilities,Gas, Fuel, Oil",null,null,null,null,null,null,null,null,{"$f":"ROUND(2.18*J5,0)","v":13}]
["Machinery, Facility/Equip. Repairs",null,null,null,null,null,null,null,null,{"$f":"ROUND(2.7*J5,0)","v":16}]
["Cash Interest Paid",null,null,null,null,null,null,null,null,{"$f":"ROUND(2.85*J5,0)","v":17}]
["Other variable costs",null,null,null,null,null,null,null,null,{"$f":"ROUND(1.42*J5,0)","v":8}]
["  Total Variable Costs",null,null,null,null,null,null,null,null,{"$f":"SUM(J15:J25)","v":{"$error":"#REF!"}}]
[]
["Fixed Costs"]
["Depreciation",null,null,null,null,null,null,null,null,13]
["Taxes",null,null,null,null,null,null,null,null,1.25]
["Farm/Livestock Insurance",null,null,null,null,null,null,null,null,4.5]
["Opportunity Cost of Investment",null,null,null,null,null,null,null,null,51]
["Other fixed costs",null,null,null,null,null,null,null,null,0]
["  Total Fixed Costs",null,null,null,null,null,null,null,null,{"$f":"SUM(J29:J32)","v":69.75}]
[]
["Total Costs",null,null,null,null,null,null,null,null,{"$f":"J26+J34","v":{"$error":"#REF!"}}]
[]
["Income Over Variable Costs",null,null,null,null,null,null,null,null,{"$f":"J12-J26","v":{"$error":"#REF!"}}]
["Income Over Total Costs ",null,null,null,null,null,null,null,null,{"$f":"J12-J36","v":{"$error":"#REF!"}}]
[]
[]
[]
["Kansas State University, Department of Agricultural Economics - www.agmanager.info"]
["Publication: AM-FMG-Finishing",null,null,null,null,null,null,null,null,{"$f":"TEXT(#REF!,\"MMM. DD, YYYY\")","v":{"$error":"#REF!"}}]
[]
[" KSU Beef Finishing Budget"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Kansas State University, Department of Agricultural Economics - www.agmanager.info"]
["Publication: AM-FMG-Finishing",null,null,null,null,null,null,null,null,{"$f":"J44","v":{"$error":"#REF!"}}]
[]
[" KSU Beef Finishing Budget"]
["Budget Assumptions"]
[]
["Finishing Feed Requirements ","(per animal unit) "]
[null,"Qty","Unit"]
["Prairie/Brome Hay",{"$f":"Feed!I19","v":1.5},"lbs/day"]
["Silage",{"$f":"Feed!I20","v":0},"lbs/day"]
["Alfalfa",{"$f":"Feed!I21","v":1.5},"lbs/day"]
["Total Harvested Forage",{"$f":"Feed!I22","v":3},"lbs/day"]
["Corn",{"$f":"Feed!I23","v":17},"lbs/day"]
["DDG's",{"$f":"Feed!I24","v":5},"lbs/day"]
["Soybean Meal",{"$f":"Feed!I25","v":0},"lbs/day"]
["Total Grain/Protein Supplements",{"$f":"Feed!I26","v":22},"lbs/day"]
["Salt and Mineral",{"$f":"Feed!I27","v":0.5},"lbs/day"]
[]
[]
[]
[]
[]
[]
["Default Beef Finishing Prices"]
[null,"Current","One Year Out",null,"Five Years Out"]
["Feeder Steers ($/cwt)",{"$f":"Prices!#REF!","v":{"$error":"#REF!"}},{"$f":"Prices!#REF!","v":{"$error":"#REF!"}},null,{"$f":"Prices!#REF!","v":{"$error":"#REF!"}}]
["5-area Fed Cattle ($/cwt)",{"$f":"Prices!#REF!","v":{"$error":"#REF!"}},{"$f":"Prices!#REF!","v":{"$error":"#REF!"}},null,{"$f":"Prices!#REF!","v":{"$error":"#REF!"}}]
["Corn ($/bu)",{"$f":"Prices!B6","v":316.8},{"$f":"Prices!C6","v":319.10000000000002},null,{"$f":"Prices!#REF!","v":{"$error":"#REF!"}}]
["Soybean meal ($/ton)",{"$f":"Prices!B7","v":5.76},{"$f":"Prices!C7","v":6.3226820809248565},null,{"$f":"Prices!#REF!","v":{"$error":"#REF!"}}]
["Distillers Grains ($/ton)",{"$f":"Prices!#REF!","v":{"$error":"#REF!"}},{"$f":"Prices!#REF!","v":{"$error":"#REF!"}},null,{"$f":"Prices!#REF!","v":{"$error":"#REF!"}}]
["Silage ($/ton)",{"$f":"Prices!B9","v":27.68},{"$f":"Prices!C9","v":30.384000000000004},null,{"$f":"Prices!#REF!","v":{"$error":"#REF!"}}]
["Hay ($/ton)",{"$f":"Prices!B10","v":65},{"$f":"Prices!C10","v":71.349710982658976},null,{"$f":"Prices!#REF!","v":{"$error":"#REF!"}}]
["Alfalfa ($/ton)",{"$f":"Prices!B11","v":100},{"$f":"Prices!C11","v":109.76878612716764},null,{"$f":"Prices!#REF!","v":{"$error":"#REF!"}}]
["Pasture Rental ($/acre)",{"$f":"Prices!B12","v":20},{"$f":"Prices!C12","v":20.399999999999999},null,{"$f":"Prices!#REF!","v":{"$error":"#REF!"}}]
["Crop Residue ($/acre)",{"$f":"Prices!#REF!","v":{"$error":"#REF!"}},{"$f":"Prices!#REF!","v":{"$error":"#REF!"}},null,{"$f":"Prices!#REF!","v":{"$error":"#REF!"}}]
["Mineral ($/ton)",{"$f":"Prices!#REF!","v":{"$error":"#REF!"}},{"$f":"Prices!#REF!","v":{"$error":"#REF!"}},null,{"$f":"Prices!#REF!","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
[]
["Kansas State University, Department of Agricultural Economics - www.agmanager.info"]
["Publication: AM-FMG-Finishing",null,null,null,null,null,null,null,null,{"$f":"J91","v":{"$error":"#REF!"}}]