{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Introduction","Prices","Feed","Cow-Calf","Backgrounding","Stocker","Feedlot"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":1,"defined_names":11,"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":52,"n_cols":12,"rows_kept":52,"cut":false,"hidden":false,"merged":[[51,1,51,10],[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,6,43,8],[47,1,50,11]]}
[]
[]
[null,"KSU-Beef Farm Management Guide Budgets"]
[]
[null,"Excel spreadsheets for beef cattle enterprise budgeting to evaluate potential income, costs and profitability"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Version- 12.7.2020"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,"Robin Reid",null,null,null,null,"Glynn T. Tonsor, Ph.D."]
[null,"Extension Associate",null,null,null,null,"Agricultural Economist"]
[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,"robinreid@ksu.edu",null,null,null,null,"gtonsor@k-state.edu"]
[null,"785-532-0964",null,null,null,null,"785-532-1518"]
[]
[null,"ACKNOWLEDGEMENTS:"]
[null,"The developers would like to thank the K-State Beef Team for their contributions: Dr. Sandy Johnson, Dr. Dale Blasi, Dr. Joel DeRouchey, Dr. Jaymelynn Farney, Dr. Justin Waggoner, and Dr. Bob Weaber  www.KSUBeef.org\n"]
[]
[]
[]
[null,"Copyright 2020 AgManager.info, K-State Department of Agricultural Economics"]

{"sheet":"Prices","index":1,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["2021 Production Year"]
["Five Years Out Prices"]
[null,{"$f":"A1","v":"2021 Production Year"},{"$f":"A2","v":"Five Years Out Prices"}]
[null,"(as of Dec. 7th, 2020)","(Oct. 2020 USDA)"]
["Corn ($/bu)",4.25,3.55,"http://www.usda.gov/oce/commodity/projections/"]
["Soybean Meal ($/ton)",380,341,"http://www.usda.gov/oce/commodity/projections/"]
["DDGS ($/ton)",210,175.41176470588235,"Adjust off of Corn Price"]
[]
["Silage ($/ton)",34,28.4,"Equal to 8X the corn price"]
["Prairie Hay ($/ton)",70,58.470588235294109,"Adjust off of Corn Price"]
["Alfalfa ($/ton)",160,133.64705882352939,"Adjust off of Corn Price"]
["Pasture Rental ($/acre)",20,22,"Current price *1.10"]
["Crop Residue ($/acre)",15,16.5,"Current price *1.10"]
["Beef Cow Mineral ($/ton)",850,935.00000000000011,"Current price *1.10"]
["Other Beef Mineral ($/ton)",600,660,"Current price *1.10"]
[]
["Oct. Heifer Calf Price ($/cwt)*",149.72,146.70629060447175,"Adjust off of Steer Calf price"]
["Oct. Steer Calves Price ($/cwt)*",165.93,162.59,"http://www.usda.gov/oce/commodity/projections/"]
["March Feeder Steers ($/cwt)**",145.63999999999999,138.20150000000001,"http://www.usda.gov/oce/commodity/projections/"]
["July Feeder Steers ($/cwt)***",142.30000000000001,145.12]
["Dec. Fed Cattle ($/cwt)****",116.605,114.61,"http://www.usda.gov/oce/commodity/projections/"]
["Beef Cull cow ($/cwt)",54.25,53.321834398181899,"Fed cattle change imposed"]
["One-Year-Out March Feeder Steers ($/cwt)******",149.72,{"$f":"C19","v":138.20150000000001}]
[]
["* This a predicted October price for the budget year"]
["** This is a predicted price for the production year"]
["***This is a predicted price for the production year"]
["****This a predicted price for a Dec. sale of a fed animal"]
["******This is a predicted one-year-out March feeder steer price used in the backgrounding budget"]

{"sheet":"Feed","index":2,"n_rows":30,"n_cols":10,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,1,0,11]]}
[null,"CATTLE RATIONS TO SET FEED AND GRAZING COSTS"]
[]
[null,"Cow-Calf Feed Requirements ","(per cow unit + 16% of developing heifer + 4% of bull)",null,null,null,null,"Stocker Feed Requirements ","(per animal unit)"]
[null,null,"Qty","Unit",null,null,null,null,"Qty","Unit"]
[null,"Pasture",9.5,"total acres per year",null,null,null,"Pasture",2.5,"total acres for feeding period"]
[null,"Crop Residue Grazing",2,"total acres per year",null,null,null,"Crop Residue",0,"total acres for feeding period"]
[null,"Prairie/Brome Hay",2.25,"total tons per year",null,null,null,"Prairie/Brome Hay",0,"total tons for feeding period"]
[null,"Silage",0,"total tons per year",null,null,null,"Silage",0,"total tons for feeding period"]
[null,"Alfalfa",0,"total tons per year",null,null,null,"Alfalfa",0,"total tons for feeding period"]
[null,"Total Harvested Forage",{"$f":"SUM(C7:C9)","v":2.25},"total tons per year",null,null,null,"Total Harvested Forage",{"$f":"SUM(I7:I9)","v":0},"total tons for feeding period"]
[null,"Corn",{"$f":"0.16*(3*198)","v":95.04},"total lbs per year",null,null,null,"Corn",0,"total pounds for feeding period"]
[null,"DDG's",738,"total lbs per year",null,null,null,"DDG's",0,"total pounds for feeding period"]
[null,"Soybean Meal",0,"total lbs per year",null,null,null,"Soybean Meal",0,"total pounds for feeding period"]
[null,"Total Grain/Protein Supplements",{"$f":"SUM(C11:C13)","v":833.04},"total lbs per year",null,null,null,"Total Grain/Protein Supplements",{"$f":"SUM(I11:I13)","v":0},"total pounds for feeding period"]
[null,"Salt and Mineral",100,"total lbs per year",null,null,null,"Salt and Mineral",{"$f":"0.1*120","v":12},"total pounds for feeding period"]
[]
[]
[null,"Backgrounding Feed Requirements ","(per animal unit) ",null,null,null,null,"Finishing Feed Requirements ","(per animal unit) "]
[null,null,"Qty","Unit",null,null,null,null,"Qty","Unit"]
[null,"Pasture",0,"total acres for feeding period",null,null,null,"Prairie/Brome Hay",1.5,"lbs/day"]
[null,"Crop Residue",0,"total acres for feeding period",null,null,null,"Silage",0,"lbs/day"]
[null,"Prairie/Brome Hay",3.5,"lbs/day",null,null,null,"Alfalfa",1.5,"lbs/day"]
[null,"Silage",0,"lbs/day",null,null,null,"Total Harvested Forage",{"$f":"SUM(I20:I22)","v":3},"lbs/day"]
[null,"Alfalfa",3.5,"lbs/day",null,null,null,"Corn",17,"lbs/day"]
[null,"Total Harvested Forage",{"$f":"SUM(C22:C24)","v":7},"lbs/day",null,null,null,"DDG's",5,"lbs/day"]
[null,"Corn",7,"lbs/day",null,null,null,"Soybean Meal",0,"lbs/day"]
[null,"DDG's",7,"lbs/day",null,null,null,"Total Grain/Protein Supplements",{"$f":"SUM(I24:I26)","v":22},"lbs/day"]
[null,"Soybean Meal",0,"lbs/day",null,null,null,"Salt and Mineral",0.5,"lbs/day"]
[null,"Total Grain/Protein Supplements",{"$f":"SUM(C26:C28)","v":14},"lbs/day"]
[null,"Salt and Mineral",0.3,"lbs/day"]

{"sheet":"Cow-Calf","index":3,"n_rows":136,"n_cols":12,"rows_kept":136,"cut":false,"hidden":false,"merged":[[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],[126,2,126,3],[124,2,124,3],[125,2,125,3],[45,0,45,9],[93,8,93,9],[98,1,98,7],[1,11,1,19],[135,8,135,9],[127,2,127,3],[128,2,128,3],[134,0,134,9],[95,0,95,1],[95,2,95,5],[95,6,95,9],[116,2,116,3],[117,2,117,3],[118,2,118,3],[119,2,119,3],[120,2,120,3],[121,2,121,3],[122,2,122,3],[123,2,123,3]]}
[" KSU Beef Cow-Calf Budget",null,"2021 Production Year",null,null,null,{"$f":"IF(C1=Prices!B3,TEXT(Prices!B4,\"MMM-YYYY\"),TEXT(Prices!C4,\"MMM-YYYY\"))","v":"(as of Dec. 7th, 2020)"}]
[null,null,null,null,null,null,null,null,null,null,null,"Click on \"2021 Production Year\" to change to \"Five Years Out Prices\""]
["Production Efficiency Information"]
["Weaning Percentage",0.91]
["Cow Replacement Percentage",0.16]
[]
["Revenue","Price","Unit",null,"Qty","Unit",null,null,null,"Total per Year per Cow"]
["Weaned Calf Sale",{"$f":"0.5*(IF(C1=Prices!A1,Prices!B18,Prices!C18))+0.5*(IF(C1=Prices!A1,Prices!B17,Prices!C17))","v":157.82499999999999},"per cwt"," x",550,"lbs"," x",{"$f":"B4","v":0.91}," =",{"$f":"B8*(E8/100)*H8","v":789.9141249999999}]
["Cull Cows",{"$f":"IF(C1=Prices!A1,Prices!B22,Prices!C22)","v":54.25},"per cwt"," x",1250,"lbs"," x",{"$f":"B5","v":0.16}," =",{"$f":"B9*(E9/100)*H9","v":108.5}]
["Other Income"]
["  Gross Income",null,null,null,null,null,null,null,null,{"$f":"SUM(J8:J10)","v":898.4141249999999}]
[]
["Variable Costs"]
["Pasture",{"$f":"IF(C1=Prices!A1, Prices!B12,Prices!C12)","v":20},"per acre"," x",{"$f":"Feed!C5","v":9.5},"total acres",null,null," =",{"$f":"B14*E14","v":190}]
["Crop Residue",{"$f":"IF(C1=Prices!A1, Prices!B13,Prices!C13)","v":15},"per acre"," x",{"$f":"Feed!C6","v":2},"total acres",null,null," =",{"$f":"B15*E15","v":30}]
["Harvested Forage",{"$f":"IF(C1=Prices!A1,(((Feed!C7/Feed!C10)*Prices!B10)+((Feed!C8/Feed!C10)*Prices!B9)+((Feed!C9/Feed!C10)*Prices!B11)),((Feed!C7/Feed!C10)*Prices!C10)+((Feed!C8/Feed!C10)*Prices!C9)+((Feed!C9/Feed!C10)*Prices!C11))","v":70},"per ton"," x",{"$f":"Feed!C10","v":2.25},"total tons",null,null," =",{"$f":"B16*E16","v":157.5}]
["Grain/Protein Supplements",{"$f":"IF(C1=Prices!A1,(((Feed!C13/Feed!C14)*Prices!B6)+((Feed!C12/Feed!C14)*Prices!B7)+((Feed!C11/Feed!C14)*(Prices!B5*2000)/56)),(((Feed!C13/Feed!C14)*Prices!C6)+((Feed!C12/Feed!C14)*Prices!C7)+((Feed!C11/Feed!C14)*(Prices!C5*2000)/56)))","v":203.35843931349552},"per ton"," x",{"$f":"Feed!C14","v":833.04},"total lbs",null,null," =",{"$f":"(B17/2000)*E17","v":84.702857142857155}]
["Mineral",{"$f":"IF(C1=Prices!A1,Prices!B14,Prices!C14)","v":850},"per ton"," x",{"$f":"Feed!C15","v":100},"total lbs",null,null," =",{"$f":"(B18/2000)*E18","v":42.5}]
["Other Feed",0,"per unit","x",0,"units",null,null,"=",{"$f":"B19*E19","v":0}]
["Labor",20,"per hour","x",8,"total hours",null,null," =",{"$f":"B20*E20","v":160}]
["Vet Medicine/Drugs",null,null,null,null,null,null,null,null,35]
["Replacement Females",{"$f":"((IF(C1=Prices!A1, Prices!B17,Prices!C17))/100)*E8","v":823.46},"per head"," x",{"$f":"B5","v":0.16},"hd",null,null," =",{"$f":"B22*E22","v":131.75360000000001}]
["Annual Bull Charge or A.I.",null,null,null,null,null,null,null,null,{"$f":"((6000-1700)/4)*0.04","v":43}]
["Other Livestock Breeding/Marketing",null,null,null,null,null,null,null,null,22]
["Utilities",null,null,null,null,null,null,null,null,14]
["Gas, Fuel, Oil",null,null,null,null,null,null,null,null,24]
["Machinery, Facility/Equip. Repairs",null,null,null,null,null,null,null,null,50]
["Cash Interest Paid",null,null,null,null,null,null,null,null,28]
["Other variable costs",null,null,null,null,null,null,null,null,8]
["  Total Variable Costs",null,null,null,null,null,null,null,null,{"$f":"SUM(J14:J29)","v":1020.4564571428572}]
[]
["Fixed Costs"]
["Depreciation",null,null,null,null,null,null,null,null,50]
["Taxes",null,null,null,null,null,null,null,null,12]
["Farm/Livestock Insurance",null,null,null,null,null,null,null,null,14]
["Opportunity Cost of Investment",null,null,null,null,null,null,null,null,135]
["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:J36)","v":211}]
[]
["Total Costs",null,null,null,null,null,null,null,null,{"$f":"J30+J38","v":1231.4564571428573}]
[]
["Income Over Variable Costs",null,null,null,null,null,null,null,null,{"$f":"J11-J30","v":-122.04233214285728}]
["Income Over Total Costs ",null,null,null,null,null,null,null,null,{"$f":"J11-J40","v":-333.04233214285739}]
[]
[]
["Kansas State University, Department of Agricultural Economics - www.agmanager.info"]
["Publication: AM-FMG-CowCalf",null,null,null,null,null,null,null,{"$f":"TEXT(Introduction!L8,\"MMM. DD, YYYY\")","v":"Version- 12.7.2020"}]
[]
[" KSU Beef Cow-Calf Budget"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Kansas State University, Department of Agricultural Economics - www.agmanager.info"]
["Publication: AM-FMG-CowCalf",null,null,null,null,null,null,null,{"$f":"I47","v":"Version- 12.7.2020"}]
[]
[" KSU Beef Cow-Calf Budget"]
["Budget Assumptions"]
[]
["Cow-Calf Feed Requirements ","(per cow unit + 16% of developing heifer + 4% of bull)"]
[null,"Qty","Unit"]
["Pasture",{"$f":"Feed!C5","v":9.5},"total acres per year"]
["Crop Residue Grazing",{"$f":"Feed!C6","v":2},"total acres per year"]
["Prairie/Brome Hay",{"$f":"Feed!C7","v":2.25},"total tons per year"]
["Silage",{"$f":"Feed!C8","v":0},"total tons per year"]
["Alfalfa",{"$f":"Feed!C9","v":0},"total tons per year"]
["Total Harvested Forage",{"$f":"Feed!C10","v":2.25},"total tons per year"]
["Corn",{"$f":"Feed!C11","v":95.04},"total lbs per year"]
["DDG's",{"$f":"Feed!C12","v":738},"total lbs per year"]
["Soybean Meal",{"$f":"Feed!C13","v":0},"total lbs per year"]
["Total Grain/Protein Supplements",{"$f":"Feed!C14","v":833.04},"total lbs per year"]
["Salt and Mineral",{"$f":"Feed!C15","v":100},"total lbs per year"]
[]
[]
[]
[]
["Default Cow-Calf Prices"]
[null,{"$f":"Prices!A1","v":"2021 Production Year"},"Five Years Out"]
[{"$f":"Prices!A5","v":"Corn ($/bu)"},{"$f":"Prices!B5","v":4.25},{"$f":"Prices!C5","v":3.55}]
[{"$f":"Prices!A6","v":"Soybean Meal ($/ton)"},{"$f":"Prices!B6","v":380},{"$f":"Prices!C6","v":341}]
[{"$f":"Prices!A7","v":"DDGS ($/ton)"},{"$f":"Prices!B7","v":210},{"$f":"Prices!C7","v":175.41176470588235}]
[{"$f":"Prices!A9","v":"Silage ($/ton)"},{"$f":"Prices!B9","v":34},{"$f":"Prices!C9","v":28.4}]
[{"$f":"Prices!A10","v":"Prairie Hay ($/ton)"},{"$f":"Prices!B10","v":70},{"$f":"Prices!C10","v":58.470588235294109}]
[{"$f":"Prices!A11","v":"Alfalfa ($/ton)"},{"$f":"Prices!B11","v":160},{"$f":"Prices!C11","v":133.64705882352939}]
[{"$f":"Prices!A12","v":"Pasture Rental ($/acre)"},{"$f":"Prices!B12","v":20},{"$f":"Prices!C12","v":22}]
[{"$f":"Prices!A13","v":"Crop Residue ($/acre)"},{"$f":"Prices!B13","v":15},{"$f":"Prices!C13","v":16.5}]
[{"$f":"Prices!A14","v":"Beef Cow Mineral ($/ton)"},{"$f":"Prices!B14","v":850},{"$f":"Prices!C14","v":935.00000000000011}]
[{"$f":"Prices!A17","v":"Oct. Heifer Calf Price ($/cwt)*"},{"$f":"Prices!B17","v":149.72},{"$f":"Prices!C17","v":146.70629060447175}]
[{"$f":"Prices!A18","v":"Oct. Steer Calves Price ($/cwt)*"},{"$f":"Prices!B18","v":165.93},{"$f":"Prices!C18","v":162.59}]
[{"$f":"Prices!A22","v":"Beef Cull cow ($/cwt)"},{"$f":"Prices!B22","v":54.25},{"$f":"Prices!C22","v":53.321834398181899}]
[]
[{"$f":"Prices!A25","v":"* This a predicted October price for the budget year"}]
[]
[]
[]
["Kansas State University, Department of Agricultural Economics - www.agmanager.info"]
["Publication: AM-FMG-CowCalf",null,null,null,null,null,null,null,{"$f":"I94","v":"Version- 12.7.2020"}]

{"sheet":"Backgrounding","index":4,"n_rows":132,"n_cols":12,"rows_kept":132,"cut":false,"hidden":false,"merged":[[90,0,90,9],[93,0,93,1],[93,2,93,5],[93,6,93,9],[0,0,0,1],[0,2,0,5],[0,6,0,9],[4,2,4,4],[43,0,43,9],[1,11,1,19],[130,0,130,9],[5,2,5,4],[122,2,122,3],[121,2,121,3],[119,2,119,3],[120,2,120,3],[123,2,123,3],[117,2,117,3],[118,2,118,3],[116,2,116,3],[114,2,114,3],[115,2,115,3],[46,0,46,1],[46,2,46,5],[46,6,46,9]]}
[" KSU Beef Backgrounding Budget",null,"2021 Production Year",null,null,null,{"$f":"IF(C1=Prices!B3,TEXT(Prices!B4,\"MMM-YYYY\"),TEXT(Prices!C4,\"MMM-YYYY\"))","v":"(as of Dec. 7th, 2020)"}]
[null,null,null,null,null,null,null,null,null,null,null,"Click on \"2021 Production Year\" to change to \"Five Years Out Prices\""]
["Production Efficiency Information"]
["Death Loss",0.02,null,null,null,null,null,null,null,"CWT Produced"]
["Days in Backgrounding Lot",150,"Average Daily Gain",null,null,1.25,null,null,null,{"$f":"(E9-E10)/100","v":1.875}]
[]
[]
["Gross Return","Price","Unit",null,"Qty","Unit",null,null,null,"Total per Year"]
["Feeder Animal Sale",{"$f":"(IF(C1=Prices!A1,Prices!B23,Prices!C23))+((E9-738)*-0.0842)","v":149.7621},"per cwt","x",{"$f":"E10+(B5*F5)","v":737.5},"lbs",null,null," =",{"$f":"B9*(E9/100)","v":1104.4954875000001}]
["Purchase price",{"$f":"(IF(C1=Prices!A1,Prices!B18,Prices!C18))","v":165.93},"per cwt","x",{"$f":"'Cow-Calf'!E8","v":550},"lbs",null,null,"=",{"$f":"-(B10*(E10/100))","v":-912.61500000000001}]
["Death Loss",null,null,null,null,null,null,null,null,{"$f":"(B4*J10)","v":-18.252300000000002}]
["Other"]
["Total Gross Return",null,null,null,null,null,null,null,null,{"$f":"SUM(J9:J12)","v":173.62818750000008}]
[]
["Variable Costs"]
["Pasture",{"$f":"IF(C1=Prices!A1, Prices!B12,Prices!C12)","v":20},"per acre","x",{"$f":"Feed!C20","v":0},"total acres",null,null," =",{"$f":"B16*E16","v":0}]
["Crop Residue",{"$f":"IF(C1=Prices!A1, Prices!B13,Prices!C13)","v":15},"per acre","x",{"$f":"Feed!C21","v":0},"total acres",null,null," =",{"$f":"B17*E17","v":0}]
["Harvested Forage",{"$f":"IF(C1=Prices!A1,(((Feed!C22/Feed!C25)*Prices!B10)+((Feed!C23/Feed!C25)*Prices!B9)+((Feed!C24/Feed!C25)*Prices!B11)),((Feed!C22/Feed!C25)*Prices!C10)+((Feed!C23/Feed!C25)*Prices!C9)+((Feed!C24/Feed!C25)*Prices!C11))","v":115},"per ton","x",{"$f":"(Feed!C25/2000)*B5","v":0.52500000000000002},"total tons",null,null," =",{"$f":"B18*E18","v":60.375}]
["Grain/Protein Supplements",{"$f":"IF(C1=Prices!A1,(((Feed!C28/Feed!C29)*Prices!B6)+((Feed!C27/Feed!C29)*Prices!B7)+((Feed!C26/Feed!C29)*(Prices!B5*2000)/56)),(((Feed!C28/Feed!C29)*Prices!C6)+((Feed!C27/Feed!C29)*Prices!C7)+((Feed!C26/Feed!C29)*(Prices!C5*2000)/56)))","v":180.89285714285714},"per ton","x",{"$f":"Feed!C29*B5","v":2100},"total lbs",null,null," =",{"$f":"(B19/2000)*E19","v":189.9375}]
["Mineral",{"$f":"IF(C1=Prices!A1,Prices!B15,Prices!C15)","v":600},"per ton","x",{"$f":"Feed!C30*B5","v":45},"total lbs",null,null," =",{"$f":"(B20/2000)*E20","v":13.5}]
["Other Feed",0,"per unit","x",0,"units",null,null,"=",{"$f":"B21*E21","v":0}]
["Labor",20,"per hour","x",{"$f":"(B5/30)*0.3","v":1.5},"hours",null,null," =",{"$f":"B22*E22","v":30}]
["Vet Medicine/Drugs",null,null,null,null,null,null,null,null,{"$f":"ROUND(7*J5,0)","v":13}]
["Marketing costs",null,null,null,null,null,null,null,null,{"$f":"ROUND(5*J5,0)","v":9}]
["Utilities,Gas, Fuel, Oil",null,null,null,null,null,null,null,null,{"$f":"ROUND(3*J5,0)","v":6}]
["Machinery, Facility/Equip. Repairs",null,null,null,null,null,null,null,null,{"$f":"ROUND(4*J5,0)","v":8}]
["Cash Interest Paid",null,null,null,null,null,null,null,null,{"$f":"ROUND(4.6*J5,0)","v":9}]
["Other variable costs",null,null,null,null,null,null,null,null,{"$f":"ROUND(1.25*J5,0)","v":2}]
["  Total Variable Costs",null,null,null,null,null,null,null,null,{"$f":"SUM(J16:J28)","v":340.8125}]
[]
["Fixed Costs"]
["Depreciation",null,null,null,null,null,null,null,null,6]
["Taxes",null,null,null,null,null,null,null,null,1]
["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,22]
["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":30.5}]
[]
["Total Costs",null,null,null,null,null,null,null,null,{"$f":"J29+J37","v":371.3125}]
[]
["Income Over Variable Costs",null,null,null,null,null,null,null,null,{"$f":"J13-J29","v":-167.18431249999992}]
["Income Over Total Costs ",null,null,null,null,null,null,null,null,{"$f":"J13-J39","v":-197.68431249999992}]
[]
["Kansas State University, Department of Agricultural Economics - www.agmanager.info"]
["Publication: AM-FMG-Backgrounding",null,null,null,null,null,null,null,null,{"$f":"TEXT(Introduction!L8,\"MMM. DD, YYYY\")","v":"Version- 12.7.2020"}]
[]
[" KSU Beef Backgrounding Budget"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Kansas State University, Department of Agricultural Economics - www.agmanager.info"]
["Publication: AM-FMG-Backgrounding",null,null,null,null,null,null,null,null,{"$f":"J45","v":"Version- 12.7.2020"}]
[]
[" KSU Beef Backgrounding Budget"]
["Budget Assumptions"]
[]
["Backgrounding Feed Requirements ","(per animal unit) "]
[null,"Qty","Unit"]
["Pasture",{"$f":"Feed!C20","v":0},"total acres for feeding period"]
["Crop Residue",{"$f":"Feed!C21","v":0},"total acres for feeding period"]
["Prairie/Brome Hay",{"$f":"Feed!C22","v":3.5},"lbs/day"]
["Silage",{"$f":"Feed!C23","v":0},"lbs/day"]
["Alfalfa",{"$f":"Feed!C24","v":3.5},"lbs/day"]
["Total Harvested Forage",{"$f":"Feed!C25","v":7},"lbs/day"]
["Corn",{"$f":"Feed!C26","v":7},"lbs/day"]
["DDG's",{"$f":"Feed!C27","v":7},"lbs/day"]
["Soybean Meal",{"$f":"Feed!C28","v":0},"lbs/day"]
["Total Grain/Protein Supplements",{"$f":"Feed!C29","v":14},"lbs/day"]
["Salt and Mineral",{"$f":"Feed!C30","v":0.3},"lbs/day"]
[]
[]
[]
[]
["Default Backgrounding Prices"]
[null,{"$f":"Prices!A1","v":"2021 Production Year"},"Five Years Out"]
[{"$f":"Prices!A5","v":"Corn ($/bu)"},{"$f":"Prices!B5","v":4.25},{"$f":"Prices!C5","v":3.55}]
[{"$f":"Prices!A6","v":"Soybean Meal ($/ton)"},{"$f":"Prices!B6","v":380},{"$f":"Prices!C6","v":341}]
[{"$f":"Prices!A7","v":"DDGS ($/ton)"},{"$f":"Prices!B7","v":210},{"$f":"Prices!C7","v":175.41176470588235}]
[{"$f":"Prices!A9","v":"Silage ($/ton)"},{"$f":"Prices!B9","v":34},{"$f":"Prices!C9","v":28.4}]
[{"$f":"Prices!A10","v":"Prairie Hay ($/ton)"},{"$f":"Prices!B10","v":70},{"$f":"Prices!C10","v":58.470588235294109}]
[{"$f":"Prices!A11","v":"Alfalfa ($/ton)"},{"$f":"Prices!B11","v":160},{"$f":"Prices!C11","v":133.64705882352939}]
[{"$f":"Prices!A15","v":"Other Beef Mineral ($/ton)"},{"$f":"Prices!B15","v":600},{"$f":"Prices!C15","v":660}]
[{"$f":"Prices!A18","v":"Oct. Steer Calves Price ($/cwt)*"},{"$f":"Prices!B18","v":165.93},{"$f":"Prices!C18","v":162.59}]
[{"$f":"Prices!A23","v":"One-Year-Out March Feeder Steers ($/cwt)******"},{"$f":"Prices!B23","v":149.72},{"$f":"Prices!C23","v":138.20150000000001}]
[]
[{"$f":"Prices!A25","v":"* This a predicted October price for the budget year"}]
[{"$f":"Prices!A29","v":"******This is a predicted one-year-out March feeder steer price used in the backgrounding budget"}]
[]
[]
[]
["Kansas State University, Department of Agricultural Economics - www.agmanager.info"]
["Publication: AM-FMG-Backgrounding",null,null,null,null,null,null,null,null,{"$f":"J92","v":"Version- 12.7.2020"}]

{"sheet":"Stocker","index":5,"n_rows":134,"n_cols":12,"rows_kept":134,"cut":false,"hidden":false,"merged":[[0,0,0,1],[4,2,4,4],[0,2,0,5],[0,6,0,9],[43,0,43,9],[5,2,5,4],[3,8,3,9],[93,6,93,9],[119,2,119,3],[120,2,120,3],[121,2,121,3],[118,2,118,3],[117,2,117,3],[1,11,1,19],[123,2,123,3],[44,8,44,9],[91,8,91,9],[133,8,133,9],[132,0,132,9],[122,2,122,3],[46,0,46,1],[114,2,114,3],[115,2,115,3],[116,2,116,3],[46,2,46,5],[46,6,46,9],[90,0,90,9],[93,0,93,1],[93,2,93,5]]}
[" KSU Beef Stocker Budget",null,"2021 Production Year",null,null,null,{"$f":"IF(C1=Prices!B3,TEXT(Prices!B4,\"MMM-YYYY\"),TEXT(Prices!C4,\"MMM-YYYY\"))","v":"(as of Dec. 7th, 2020)"}]
[null,null,null,null,null,null,null,null,null,null,null,"Click on \"2021 Production Year\" to change to \"Five Years Out Prices\""]
["Production Efficiency Information"]
["Death Loss",0.01,null,null,null,null,null,null,"CWT Produced"]
["Days on Grass",120,"Average Daily Gain",null,null,1.25,null,null,null,{"$f":"(E9-E10)/100","v":1.5}]
[]
[]
["Gross Return","Price","Unit",null,"Qty","Unit",null,null,null,"Total per Year"]
["Feeder Sale",{"$f":"IF(C1=Prices!A1,Prices!B20,Prices!C20)+((E9-888)*-0.0842)","v":142.34210000000002},"per cwt","x",{"$f":"E10+(B5*F5)","v":887.5},"lbs",null,null," =",{"$f":"B9*(E9/100)","v":1263.2861375000002}]
["Purchase price",{"$f":"IF(C1=Prices!A1,Prices!B19,Prices!C19)+((E10-750)*-0.0842)","v":146.6925},"per cwt","x",{"$f":"Backgrounding!E9","v":737.5},"lbs",null,null,"=",{"$f":"-(B10*(E10/100))","v":-1081.8571875}]
["Death Loss",null,null,null,null,null,null,null,null,{"$f":"(B4*J10)","v":-10.818571875}]
["Other"]
["Total Gross Return",null,null,null,null,null,null,null,null,{"$f":"SUM(J9:J12)","v":170.61037812500021}]
[]
["Variable Costs"]
["Pasture",{"$f":"IF(C1=Prices!A1, Prices!B12,Prices!C12)","v":20},"per acre","x",{"$f":"Feed!I5","v":2.5},"total acres",null,null," =",{"$f":"B16*E16","v":50}]
["Crop Residue",{"$f":"IF(C1=Prices!A1, Prices!B13,Prices!C13)","v":15},"per acre","x",{"$f":"Feed!I6","v":0},"total acres",null,null," =",{"$f":"B17*E17","v":0}]
["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)),((Feed!I7/Feed!I10)*Prices!C10)+((Feed!I8/Feed!I10)*Prices!C9)+((Feed!I9/Feed!I10)*Prices!C11))),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!I14>0,(IF(C1=Prices!A1,(((Feed!I13/Feed!I14)*Prices!B6)+((Feed!I12/Feed!I14)*Prices!B7)+((Feed!I11/Feed!I14)*(Prices!B5*2000)/56)),(((Feed!I13/Feed!I14)*Prices!C6)+((Feed!I12/Feed!I14)*Prices!C7)+((Feed!I11/Feed!I14)*(Prices!C5*2000)/56)))),0)","v":0},"per ton","x",{"$f":"Feed!I14","v":0},"total lbs",null,null," =",{"$f":"(B19/2000)*E19","v":0}]
["Mineral",{"$f":"IF(C1=Prices!A1,Prices!B15,Prices!C15)","v":600},"per ton","x",{"$f":"Feed!I15","v":12},"total lbs",null,null," =",{"$f":"(B20/2000)*E20","v":3.5999999999999996}]
["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":0.8},"hours",null,null," =",{"$f":"B22*E22","v":16}]
["Vet Medicine/Drugs",null,null,null,null,null,null,null,null,{"$f":"ROUND(4*J5,0)","v":6}]
["Marketing costs",null,null,null,null,null,null,null,null,9]
["Utilities,Gas, Fuel, Oil",null,null,null,null,null,null,null,null,{"$f":"ROUND(3*J5,0)","v":5}]
["Machinery, Facility/Equip. Repairs",null,null,null,null,null,null,null,null,{"$f":"ROUND(4.5*J5,0)","v":7}]
["Cash Interest Paid",null,null,null,null,null,null,null,null,{"$f":"ROUND(4*J5,0)","v":6}]
["Other variable costs",null,null,null,null,null,null,null,null,{"$f":"ROUND(1*J5,0)","v":2}]
["  Total Variable Costs",null,null,null,null,null,null,null,null,{"$f":"SUM(J16:J28)","v":104.6}]
[]
["Fixed Costs"]
["Depreciation",null,null,null,null,null,null,null,null,5]
["Taxes",null,null,null,null,null,null,null,null,1]
["Farm/Livestock Insurance",null,null,null,null,null,null,null,null,1]
["Opportunity Cost of Investment",null,null,null,null,null,null,null,null,15]
["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":22}]
[]
["Total Costs",null,null,null,null,null,null,null,null,{"$f":"J29+J37","v":126.6}]
[]
["Income Over Variable Costs",null,null,null,null,null,null,null,null,{"$f":"J13-J29","v":66.010378125000216}]
["Income Over Total Costs ",null,null,null,null,null,null,null,null,{"$f":"J13-J39","v":44.010378125000216}]
[]
["Kansas State University, Department of Agricultural Economics - www.agmanager.info"]
["Publication: AM-FMG-Stocker",null,null,null,null,null,null,null,{"$f":"TEXT(Introduction!L8,\"MMM. DD, YYYY\")","v":"Version- 12.7.2020"}]
[]
[" 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,{"$f":"I45","v":"Version- 12.7.2020"}]
[]
[" KSU Beef Stocker Budget"]
["Budget Assumptions"]
[]
["Stocker Feed Requirements ","(per animal unit)"]
[null,"Qty","Unit"]
["Pasture",{"$f":"Feed!I5","v":2.5},"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!I12","v":0},"total pounds for feeding period"]
["Soybean Meal",{"$f":"Feed!I13","v":0},"total pounds for feeding period"]
["Total Grain/Protein Supplements",{"$f":"Feed!I14","v":0},"total pounds for feeding period"]
["Salt and Mineral",{"$f":"Feed!I15","v":12},"total pounds for feeding period"]
[]
[]
[]
[]
["Default Stocker Prices"]
[null,{"$f":"Prices!A1","v":"2021 Production Year"},"Five Years Out"]
[{"$f":"Prices!A5","v":"Corn ($/bu)"},{"$f":"Prices!B5","v":4.25},{"$f":"Prices!C5","v":3.55}]
[{"$f":"Prices!A6","v":"Soybean Meal ($/ton)"},{"$f":"Prices!B6","v":380},{"$f":"Prices!C6","v":341}]
[{"$f":"Prices!A7","v":"DDGS ($/ton)"},{"$f":"Prices!B7","v":210},{"$f":"Prices!C7","v":175.41176470588235}]
[{"$f":"Prices!A12","v":"Pasture Rental ($/acre)"},{"$f":"Prices!B12","v":20},{"$f":"Prices!C12","v":22}]
[{"$f":"Prices!A13","v":"Crop Residue ($/acre)"},{"$f":"Prices!B13","v":15},{"$f":"Prices!C13","v":16.5}]
[{"$f":"Prices!A15","v":"Other Beef Mineral ($/ton)"},{"$f":"Prices!B15","v":600},{"$f":"Prices!C15","v":660}]
[{"$f":"Prices!A19","v":"March Feeder Steers ($/cwt)**"},{"$f":"Prices!B19","v":145.63999999999999},{"$f":"Prices!C19","v":138.20150000000001}]
[{"$f":"Prices!A20","v":"July Feeder Steers ($/cwt)***"},{"$f":"Prices!B20","v":142.30000000000001},{"$f":"Prices!C20","v":145.12}]
[]
[{"$f":"Prices!A26","v":"** This is a predicted price for the production year"}]
[{"$f":"Prices!A27","v":"***This is a predicted price for the production year"}]
[]
[]
[]
[]
[]
[]
["Kansas State University, Department of Agricultural Economics - www.agmanager.info"]
["Publication: AM-FMG-Stocker",null,null,null,null,null,null,null,{"$f":"I92","v":"Version- 12.7.2020"}]

{"sheet":"Feedlot","index":6,"n_rows":132,"n_cols":12,"rows_kept":132,"cut":false,"hidden":false,"merged":[[0,0,0,1],[0,2,0,5],[0,6,0,9],[4,2,4,4],[42,0,42,9],[3,8,3,9],[43,8,43,9],[90,8,90,9],[116,2,116,3],[113,2,113,3],[114,2,114,3],[115,2,115,3],[45,2,45,5],[1,11,1,19],[131,8,131,9],[120,2,120,3],[130,0,130,9],[45,0,45,1],[92,6,92,9],[45,6,45,9],[89,0,89,9],[92,0,92,1],[92,2,92,5],[121,2,121,3],[122,2,122,3],[123,2,123,3],[117,2,117,3],[118,2,118,3],[119,2,119,3]]}
[" KSU Beef Finishing Budget",null,"2021 Production Year",null,null,null,{"$f":"IF(C1=Prices!B3,TEXT(Prices!B4,\"MMM-YYYY\"),TEXT(Prices!C4,\"MMM-YYYY\"))","v":"(as of Dec. 7th, 2020)"}]
[null,null,null,null,null,null,null,null,null,null,null,"Click on \"2021 Production Year\" to change to \"Five Years Out Prices\""]
["Production Efficiency Information"]
["Death Loss",1.4999999999999999E-2,null,null,null,null,null,null,"CWT Produced"]
["Days on Feed",150,"Average Daily Gain",null,null,3.7,null,null,null,{"$f":"(E8-E9)/100","v":5.55}]
[]
["Gross Return","Price","Unit",null,"Qty","Unit",null,null,null,"Total per Year"]
["Fed Animal Sale",{"$f":"IF(C1=Prices!A1,Prices!B21,Prices!C21)+((E8-1400)*-0.1045)","v":112.16375000000001},"per cwt","x",{"$f":"E9+(B5*F5)","v":1442.5},"lbs",null,null,"=",{"$f":"B8*(E8/100)","v":1617.9620937500001}]
["Purchase price",{"$f":"IF(C1=Prices!A1,Prices!B20,Prices!C20)+((E9-888)*-0.0842)","v":142.34210000000002},"per cwt","x",{"$f":"Stocker!E9","v":887.5},"lbs",null,null,"=",{"$f":"-(B9*(E9/100))","v":-1263.2861375000002}]
["Death Loss",null,null,null,null,null,null,null,null,{"$f":"(B4*J9)","v":-18.949292062500003}]
["Other"]
["Total Gross Return",null,null,null,null,null,null,null,null,{"$f":"SUM(J8:J11)","v":335.72666418749992}]
[]
["Variable Costs"]
["Harvested Forage",{"$f":"IF(C1=Prices!A1,(((Feed!I20/Feed!I23)*Prices!B10)+((Feed!I21/Feed!I23)*Prices!B9)+((Feed!I22/Feed!I23)*Prices!B11)),((Feed!I20/Feed!I23)*Prices!C10)+((Feed!I21/Feed!I23)*Prices!C9)+((Feed!I22/Feed!I23)*Prices!C11))","v":115},"per ton","x",{"$f":"(Feed!I23*Feedlot!B5)/2000","v":0.22500000000000001},"total tons",null,null," =",{"$f":"B15*E15","v":25.875}]
["Grain/Protein Supplements",{"$f":"IF(C1=Prices!A1,(((Feed!I26/Feed!I27)*Prices!B6)+((Feed!I25/Feed!I27)*Prices!B7)+((Feed!I24/Feed!I27)*(Prices!B5*2000)/56)),(((Feed!I26/Feed!I27)*Prices!C6)+((Feed!I25/Feed!I27)*Prices!C7)+((Feed!I24/Feed!I27)*(Prices!C5*2000)/56)))","v":165.01623376623377},"per ton","x",{"$f":"Feed!I27*B5","v":3300},"total lbs",null,null," =",{"$f":"(B16/2000)*E16","v":272.27678571428572}]
["Mineral",{"$f":"IF(C1=Prices!A1,Prices!B15, Prices!C15)","v":600},"per ton","x",{"$f":"Feed!I28*B5","v":75},"total lbs",null,null," =",{"$f":"(B17/2000)*E17","v":22.5}]
["Other Feed",0,"per unit","x",0,"units",null,null,"=",{"$f":"B18*E18","v":0}]
["Labor",20,"per hour","x",1.5,"hours",null,null," =",{"$f":"B19*E19","v":30}]
["Vet Medicine/Drugs",null,null,null,null,null,null,null,null,5]
["Marketing costs",null,null,null,null,null,null,null,null,10]
["Utilities,Gas, Fuel, Oil",null,null,null,null,null,null,null,null,{"$f":"ROUND(1.1*J5,0)","v":6}]
["Machinery, Facility/Equip. Repairs",null,null,null,null,null,null,null,null,{"$f":"ROUND(1*J5,0)","v":6}]
["Cash Interest Paid",null,null,null,null,null,null,null,null,{"$f":"ROUND(6.5*J5,0)","v":36}]
["Other variable costs",null,null,null,null,null,null,null,null,{"$f":"ROUND(0.5*J5,0)","v":3}]
["  Total Variable Costs",null,null,null,null,null,null,null,null,{"$f":"SUM(J15:J25)","v":416.65178571428572}]
[]
["Fixed Costs"]
["Depreciation",null,null,null,null,null,null,null,null,9]
["Taxes",null,null,null,null,null,null,null,null,2]
["Farm/Livestock Insurance",null,null,null,null,null,null,null,null,3.5]
["Opportunity Cost of Investment",null,null,null,null,null,null,null,null,36]
["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":50.5}]
[]
["Total Costs",null,null,null,null,null,null,null,null,{"$f":"J26+J34","v":467.15178571428572}]
[]
["Income Over Variable Costs",null,null,null,null,null,null,null,null,{"$f":"J12-J26","v":-80.925121526785802}]
["Income Over Total Costs ",null,null,null,null,null,null,null,null,{"$f":"J12-J36","v":-131.4251215267858}]
[]
[]
[]
["Kansas State University, Department of Agricultural Economics - www.agmanager.info"]
["Publication: AM-FMG-Finishing",null,null,null,null,null,null,null,{"$f":"Introduction!L8","v":"Version- 12.7.2020"}]
[]
[" 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,{"$f":"I44","v":"Version- 12.7.2020"}]
[]
[" KSU Beef Finishing Budget"]
["Budget Assumptions"]
[]
["Finishing Feed Requirements ","(per animal unit) "]
[null,"Qty","Unit"]
["Prairie/Brome Hay",{"$f":"Feed!I20","v":1.5},"lbs/day"]
["Silage",{"$f":"Feed!I21","v":0},"lbs/day"]
["Alfalfa",{"$f":"Feed!I22","v":1.5},"lbs/day"]
["Total Harvested Forage",{"$f":"Feed!I23","v":3},"lbs/day"]
["Corn",{"$f":"Feed!I24","v":17},"lbs/day"]
["DDG's",{"$f":"Feed!I25","v":5},"lbs/day"]
["Soybean Meal",{"$f":"Feed!I26","v":0},"lbs/day"]
["Total Grain/Protein Supplements",{"$f":"Feed!I27","v":22},"lbs/day"]
["Salt and Mineral",{"$f":"Feed!I28","v":0.5},"lbs/day"]
[]
[]
[]
[]
[]
[]
["Default Beef Finishing Prices"]
[null,{"$f":"Prices!A1","v":"2021 Production Year"},"Five Years Out"]
[{"$f":"Prices!A5","v":"Corn ($/bu)"},{"$f":"Prices!B5","v":4.25},{"$f":"Prices!C5","v":3.55}]
[{"$f":"Prices!A6","v":"Soybean Meal ($/ton)"},{"$f":"Prices!B6","v":380},{"$f":"Prices!C6","v":341}]
[{"$f":"Prices!A7","v":"DDGS ($/ton)"},{"$f":"Prices!B7","v":210},{"$f":"Prices!C7","v":175.41176470588235}]
[{"$f":"Prices!A9","v":"Silage ($/ton)"},{"$f":"Prices!B9","v":34},{"$f":"Prices!C9","v":28.4}]
[{"$f":"Prices!A10","v":"Prairie Hay ($/ton)"},{"$f":"Prices!B10","v":70},{"$f":"Prices!C10","v":58.470588235294109}]
[{"$f":"Prices!A11","v":"Alfalfa ($/ton)"},{"$f":"Prices!B11","v":160},{"$f":"Prices!C11","v":133.64705882352939}]
[{"$f":"Prices!A15","v":"Other Beef Mineral ($/ton)"},{"$f":"Prices!B15","v":600},{"$f":"Prices!C15","v":660}]
[{"$f":"Prices!A20","v":"July Feeder Steers ($/cwt)***"},{"$f":"Prices!B20","v":142.30000000000001},{"$f":"Prices!C20","v":145.12}]
[{"$f":"Prices!A21","v":"Dec. Fed Cattle ($/cwt)****"},{"$f":"Prices!B21","v":116.605},{"$f":"Prices!C21","v":114.61}]
[]
[{"$f":"Prices!A27","v":"***This is a predicted price for the production year"}]
[{"$f":"Prices!A28","v":"****This a predicted price for a Dec. sale of a fed animal"}]
[]
[]
[]
[]
["Kansas State University, Department of Agricultural Economics - www.agmanager.info"]
["Publication: AM-FMG-Finishing",null,null,null,null,null,null,null,{"$f":"I91","v":"Version- 12.7.2020"}]