{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Notes","Prices","Feed","Cow-Calf","Backgrounding","Stocker","Feedlot"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":8,"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":"Notes","index":0,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,"Welcome to the Kansas State University Farm Management Guides for Beef Enterprises"]
[null,"Last Updated Date:",null,"2015-12-01"]
[null,"The Kansas State University cost-return budgets were developed to serve as a barometer of profitability for various livestock industry enterprises."]
[null,"These budgets are NOT intended to represent any one operation.  "]
[null,"Each individual operation should adjust key inputs to reflect their own situation."]
[null,"Any number that is blue and bolded is an input the user can adjust."]
[]
[]
[null,"This spreadsheet is brought to you by:"]
[]
[]
[]
[]
[]
[]
[null,"AND"]

{"sheet":"Prices","index":1,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Current Prices"]
["One Year Out Prices"]
["Five Years Out Prices"]
[null,{"$f":"A1","v":"Current Prices"},null,{"$f":"A2","v":"One Year Out Prices"},null,null,{"$f":"A3","v":"Five Years Out Prices"}]
[null,"(as of December 1, 2015)","Notes/source",{"$f":"B5","v":"(as of December 1, 2015)"},"Notes/source",null,{"$f":"'[1]Master Prices'!$G$5","v":"(Nov. 2014 USDA)"}]
[{"$f":"'[1]Master Prices'!$A$26","v":"Corn ($/bu)"},3.77,"USDA St. Joseph, MO SJ_GR851 Report (http://www.ams.usda.gov/mnreports/sj_gr851.txt)",4.0660000000000007,"USE deferred CME C to Adjust off of Current price",null,3.55,"http://www.usda.gov/oce/commodity/projections/"]
[{"$f":"'[1]Master Prices'!$A$28","v":"Soybean Meal ($/ton)"},281.60000000000002,"USDA St. Joseph, MO SJ_GR210 Report (http://www.ams.usda.gov/mnreports/sj_gr210.txt)",291.7,"USE deferred CME SB to Adjust off of Current price",null,326,"http://www.usda.gov/oce/commodity/projections/"]
[{"$f":"'[1]Master Prices'!$A$29","v":"DDGS ($/ton)"},147.5,"USDA St. Joseph, MO NW_GR112 Report (http://www.ams.usda.gov/mnreports/nw_gr112.txt)",159.08090185676394,"Adjust off of Corn Price",null,138.89257294429709,"Adjust off of Corn Price"]
[]
[{"$f":"'[1]Master Prices'!A30","v":"Silage ($/ton)"},30.16,{"$f":"'[1]Master Prices'!C30","v":0},32.528000000000006,{"$f":"'[1]Master Prices'!E30","v":0},null,28.4,"Equal to 8X the corn price"]
[{"$f":"'[1]Master Prices'!A31","v":"Prairie Hay ($/ton)"},60,{"$f":"'[1]Master Prices'!C31","v":0},64.710875331564992,{"$f":"'[1]Master Prices'!E31","v":0},null,56.49867374005305,"Adjust off of Corn Price"]
[{"$f":"'[1]Master Prices'!A32","v":"Alfalfa ($/ton)"},115,{"$f":"'[1]Master Prices'!C32","v":0},124.0291777188329,{"$f":"'[1]Master Prices'!E32","v":0},null,108.28912466843501,"Adjust off of Corn Price"]
[{"$f":"'[1]Master Prices'!A34","v":"Pasture Rental ($/acre)"},18.059999999999999,{"$f":"'[1]Master Prices'!C34","v":0},18.421199999999999,{"$f":"'[1]Master Prices'!E34","v":0},null,19.866,"Current price *1.10"]
[{"$f":"'[1]Master Prices'!A35","v":"Crop Residue ($/acre)"},15,{"$f":"'[1]Master Prices'!C35","v":0},15.3,{"$f":"'[1]Master Prices'!E35","v":0},null,16.5,"Current price *1.10"]
[{"$f":"'[1]Master Prices'!A36","v":"Beef Cow Mineral ($/ton)"},800,{"$f":"'[1]Master Prices'!C36","v":0},816,{"$f":"'[1]Master Prices'!E36","v":0},null,880.00000000000011,"Current price *1.10"]
[{"$f":"'[1]Master Prices'!A37","v":"Other Beef Mineral ($/ton)"},550,{"$f":"'[1]Master Prices'!C37","v":0},561,{"$f":"'[1]Master Prices'!E37","v":0},null,605,"Current price *1.10"]
[]
[{"$f":"'[1]Master Prices'!A12","v":"Heifer Calf Price ($/cwt)"},189.01480000000001,{"$f":"'[1]Master Prices'!C12","v":0},183.53980000000001,{"$f":"'[1]Master Prices'!E12","v":0},null,217.07534340665507,"Adjust off of Steer Calf price"]
[{"$f":"'[1]Master Prices'!A13","v":"Steer Calves Price ($/cwt)"},206.45964910000001,{"$f":"'[1]Master Prices'!C13","v":0},200.98464910000001,{"$f":"'[1]Master Prices'!E13","v":0},null,237.11,"http://www.usda.gov/oce/commodity/projections/"]
[{"$f":"'[1]Master Prices'!A14","v":"Feeder Steers ($/cwt)"},180.75,{"$f":"'[1]Master Prices'!C14","v":0},175.27500000000001,{"$f":"'[1]Master Prices'!E14","v":0},null,193.23,"http://www.usda.gov/oce/commodity/projections/"]
[{"$f":"'[1]Master Prices'!A15","v":"5-area Fed Cattle ($/cwt)"},126.34,{"$f":"'[1]Master Prices'!C15","v":0},120.36499999999999,{"$f":"'[1]Master Prices'!E15","v":0},null,158.41999999999999,"http://www.usda.gov/oce/commodity/projections/"]
[{"$f":"'[1]Master Prices'!A16","v":"Beef Cull cow ($/cwt)"},75,{"$f":"'[1]Master Prices'!C16","v":0},71.453023587145793,{"$f":"'[1]Master Prices'!E16","v":0},null,94.043849928763635,"Fed cattle change imposed"]

{"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",10,"total acres per year",null,null,null,"Pasture",4,"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,"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},"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",{"$f":"(3*60)+(0.16*(0.2*198))","v":186.33600000000001},"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":281.37600000000003},"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",{"$f":"(0.25*365)","v":91.25},"total lbs per year",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,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":[[126,4,126,5],[127,4,127,5],[124,2,124,3],[125,2,125,3],[126,2,126,3],[127,2,127,3],[124,4,124,5],[125,4,125,5],[119,4,119,5],[120,4,120,5],[121,4,121,5],[122,4,122,5],[123,4,123,5],[118,2,118,3],[94,0,94,1],[94,2,94,5],[94,6,94,9],[115,2,115,3],[115,4,115,5],[116,4,116,5],[117,4,117,5],[118,4,118,5],[134,0,134,9],[44,0,44,9],[0,0,0,1],[0,2,0,5],[0,6,0,9],[91,0,91,9],[47,0,47,1],[47,2,47,5],[47,6,47,9],[119,2,119,3],[120,2,120,3],[121,2,121,3],[122,2,122,3],[123,2,123,3],[116,2,116,3],[117,2,117,3]]}
[" KSU Beef Cow-Calf Budget",null,"Current Prices",null,null,null,{"$f":"IF(C1=Prices!B4,TEXT(Prices!B5,\"MMM-YYYY\"),IF(C1=Prices!D4,TEXT(Prices!D5,\"MMM-YYYY\"),TEXT(Prices!G5,\"MMM-YYYY\")))","v":"(as of December 1, 2015)"}]
[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"]
["Weaning Percentage",0.89]
["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!B19,IF(C1=Prices!A2,Prices!D19,IF(C1=Prices!A3,Prices!G19,\"\"))))+0.5*(IF(C1=Prices!A1,Prices!B18,IF(C1=Prices!A2,Prices!D18,IF(C1=Prices!A3,Prices!G18,\"\"))))","v":197.73722455000001},"per cwt"," x",550,"lbs"," x",{"$f":"B4","v":0.89}," =",{"$f":"B8*(E8/100)*H8","v":967.92371417225013}]
["Cull Cows",{"$f":"IF(C1=Prices!A1, Prices!B22, IF(C1=Prices!A2, Prices!D22, IF(C1=Prices!A3, Prices!G22, \"\")))","v":75},"per cwt"," x",1250,"lbs"," x",{"$f":"B5","v":0.16}," =",{"$f":"B9*(E9/100)*H9","v":150}]
["Other Income"]
["  Gross Income",null,null,null,null,null,null,null,null,{"$f":"SUM(J8:J10)","v":1117.9237141722501}]
[]
["Variable Costs"]
["Pasture",{"$f":"IF(C1=Prices!A1, Prices!B13, IF(C1=Prices!A2, Prices!D13, IF(C1=Prices!A3,Prices!G13, \"\")))","v":18.059999999999999},"per acre"," x",{"$f":"Feed!C5","v":10},"total acres",null,null," =",{"$f":"B14*E14","v":180.6}]
["Crop Residue",{"$f":"IF(C1=Prices!A1, Prices!B14, IF(C1=Prices!A2, Prices!D14, IF(C1=Prices!A3,Prices!G14, \"\")))","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!B11)+((Feed!C8/Feed!C10)*Prices!B10)+((Feed!C9/Feed!C10)*Prices!B12)),IF(C1=Prices!A2,(((Feed!C7/Feed!C10)*Prices!D11)+((Feed!C8/Feed!C10)*Prices!D10)+((Feed!C9/Feed!C10)*Prices!D12)),IF(C1=Prices!A3,((Feed!C7/Feed!C10)*Prices!G11)+((Feed!C8/Feed!C10)*Prices!G10)+((Feed!C9/Feed!C10)*Prices!G12),\"\")))","v":60},"per ton"," x",{"$f":"Feed!C10","v":2},"total tons",null,null," =",{"$f":"B16*E16","v":120}]
["Grain/Protein Supplements",{"$f":"IF(C1=Prices!A1,(((Feed!C13/Feed!C14)*Prices!B7)+((Feed!C12/Feed!C14)*Prices!B8)+((Feed!C11/Feed!C14)*(Prices!B6*2000)/56)),IF(C1=Prices!A2,(((Feed!C13/Feed!C14)*Prices!D7)+((Feed!C12/Feed!C14)*Prices!D8)+((Feed!C11/Feed!C14)*(Prices!D6*2000)/56)),IF(C1=Prices!A3,(((Feed!C13/Feed!C14)*Prices!G7)+((Feed!C12/Feed!C14)*Prices!G8)+((Feed!C11/Feed!C14)*(Prices!G6*2000)/56)),\"\")))","v":143.15725983330896},"per ton"," x",{"$f":"Feed!C14","v":281.37600000000003},"total lbs",null,null," =",{"$f":"(B17/2000)*E17","v":20.140508571428573}]
["Mineral",{"$f":"IF(C1=Prices!A1,Prices!B15, IF(C1=Prices!A2,Prices!D15, IF(C1=Prices!A3,Prices!G15, \"\")))","v":800},"per ton"," x",{"$f":"Feed!C15","v":91.25},"total lbs",null,null," =",{"$f":"(B18/2000)*E18","v":36.5}]
["Other Feed",0,"per unit","x",0,"units",null,null,"=",{"$f":"B19*E19","v":0}]
["Labor",20,"per hour","x",5.9,"total hours",null,null," =",{"$f":"B20*E20","v":118}]
["Vet Medicine/Drugs",null,null,null,null,null,null,null,null,28]
["Replacement Females",{"$f":"((IF(C1=Prices!A1, Prices!B18, IF(C1=Prices!A2, Prices!D18, IF(C1=Prices!A3,Prices!G18, \"\"))))/100)*E8","v":1039.5814},"per head"," x",{"$f":"B5","v":0.16},"hd",null,null," =",{"$f":"B22*E22","v":166.33302399999999}]
["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,21]
["Utilities,Gas, Fuel, Oil",null,null,null,null,null,null,null,null,47]
["Machinery, Facility/Equip. Repairs",null,null,null,null,null,null,null,null,52]
["Cash Interest Paid",null,null,null,null,null,null,null,null,28]
["Other variable costs",null,null,null,null,null,null,null,null,21]
["  Total Variable Costs",null,null,null,null,null,null,null,null,{"$f":"SUM(J14:J28)","v":911.57353257142859}]
[]
["Fixed Costs"]
["Depreciation",null,null,null,null,null,null,null,null,43]
["Taxes",null,null,null,null,null,null,null,null,7]
["Farm/Livestock Insurance",null,null,null,null,null,null,null,null,13]
["Opportunity Cost of Investment",null,null,null,null,null,null,null,null,122]
["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:J35)","v":185}]
[]
["Total Costs",null,null,null,null,null,null,null,null,{"$f":"J29+J37","v":1096.5735325714286}]
[]
["Income Over Variable Costs",null,null,null,null,null,null,null,null,{"$f":"J11-J29","v":206.35018160082154}]
["Income Over Total Costs ",null,null,null,null,null,null,null,null,{"$f":"J11-J39","v":21.350181600821543}]
[]
[]
["Kansas State University, Department of Agricultural Economics - www.agmanager.info"]
["Publication: AM-FMG-CowCalf",null,null,null,null,null,null,null,null,{"$f":"TEXT(Notes!D2,\"MMM. DD, YYYY\")","v":"Dec. 01, 2015"}]
[]
[" 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,null,{"$f":"J46","v":"Dec. 01, 2015"}]
[]
[" 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":10},"total acres per year"]
["Crop Residue Grazing",{"$f":"Feed!C6","v":2},"total acres per year"]
["Prairie/Brome Hay",{"$f":"Feed!C7","v":2},"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},"total tons per year"]
["Corn",{"$f":"Feed!C11","v":95.04},"total lbs per year"]
["DDG's",{"$f":"Feed!C12","v":186.33600000000001},"total lbs per year"]
["Soybean Meal",{"$f":"Feed!C13","v":0},"total lbs per year"]
["Total Grain/Protein Supplements",{"$f":"Feed!C14","v":281.37600000000003},"total lbs per year"]
["Salt and Mineral",{"$f":"Feed!C15","v":91.25},"total lbs per year"]
[]
[]
[]
[]
["Default Cow-Calf Prices"]
[null,"Current","One Year Out",null,"Five Years Out"]
["Heifer Calf Price ($/cwt)",{"$f":"Prices!B18","v":189.01480000000001},{"$f":"Prices!D18","v":183.53980000000001},null,{"$f":"Prices!G18","v":217.07534340665507}]
["Steer Calf Price ($/cwt)",{"$f":"Prices!B19","v":206.45964910000001},{"$f":"Prices!D19","v":200.98464910000001},null,{"$f":"Prices!G19","v":237.11}]
["Cull cow($/cwt)",{"$f":"Prices!B22","v":75},{"$f":"Prices!D22","v":71.453023587145793},null,{"$f":"Prices!G22","v":94.043849928763635}]
["Corn ($/bu)",{"$f":"Prices!B6","v":3.77},{"$f":"Prices!D6","v":4.0660000000000007},null,{"$f":"Prices!G6","v":3.55}]
["Soybean meal ($/ton)",{"$f":"Prices!B7","v":281.60000000000002},{"$f":"Prices!D7","v":291.7},null,{"$f":"Prices!G7","v":326}]
["Distillers Grains ($/ton)",{"$f":"Prices!B8","v":147.5},{"$f":"Prices!D8","v":159.08090185676394},null,{"$f":"Prices!G8","v":138.89257294429709}]
["Silage ($/ton)",{"$f":"Prices!B10","v":30.16},{"$f":"Prices!D10","v":32.528000000000006},null,{"$f":"Prices!G10","v":28.4}]
["Prairie Hay ($/ton)",{"$f":"Prices!B11","v":60},{"$f":"Prices!D11","v":64.710875331564992},null,{"$f":"Prices!G11","v":56.49867374005305}]
["Alfalfa ($/ton)",{"$f":"Prices!B12","v":115},{"$f":"Prices!D12","v":124.0291777188329},null,{"$f":"Prices!G12","v":108.28912466843501}]
["Pasture Rental ($/acre)",{"$f":"Prices!B13","v":18.059999999999999},{"$f":"Prices!D13","v":18.421199999999999},null,{"$f":"Prices!G13","v":19.866}]
["Crop Residue ($/acre)",{"$f":"Prices!B14","v":15},{"$f":"Prices!D14","v":15.3},null,{"$f":"Prices!G14","v":16.5}]
["Mineral ($/ton)",{"$f":"Prices!B15","v":800},{"$f":"Prices!D15","v":816},null,{"$f":"Prices!G15","v":880.00000000000011}]
[]
[]
[]
[]
[]
[]
["Kansas State University, Department of Agricultural Economics - www.agmanager.info"]
["Publication: AM-FMG-CowCalf",null,null,null,null,null,null,null,null,{"$f":"J93","v":"Dec. 01, 2015"}]

{"sheet":"Backgrounding","index":4,"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],[4,2,4,4],[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],[119,2,119,3],[119,4,119,5],[120,2,120,3],[120,4,120,5],[117,2,117,3],[117,4,117,5],[134,0,134,9],[5,2,5,4],[124,2,124,3],[124,4,124,5],[125,2,125,3],[125,4,125,5],[126,2,126,3],[126,4,126,5],[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]]}
[" KSU Beef Backgrounding Budget",null,"Current Prices",null,null,null,{"$f":"IF(C1=Prices!B4,TEXT(Prices!B5,\"MMM-YYYY\"),IF(C1=Prices!D4,TEXT(Prices!D5,\"MMM-YYYY\"),TEXT(Prices!G5,\"MMM-YYYY\")))","v":"(as of December 1, 2015)"}]
[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.02,null,null,null,null,null,null,null,"CWT Produced"]
["Days in Backgrounding Lot",120,"Average Daily Gain",null,null,2.25,null,null,null,{"$f":"(E9-E10)/100","v":2.7}]
[]
[]
["Gross Return","Price","Unit",null,"Qty","Unit",null,null,null,"Total per Year"]
["Feeder Animal Sale",{"$f":"(IF(C1=Prices!A1,Prices!B20,IF(C1=Prices!A2,Prices!D20,IF(C1=Prices!A3,Prices!G20,\"\"))))","v":180.75},"per cwt","x",{"$f":"E10+(B5*F5)","v":820},"lbs",null,null," =",{"$f":"B9*(E9/100)","v":1482.1499999999999}]
["Purchase price",{"$f":"(IF(C1=Prices!A1,Prices!B19,IF(C1=Prices!A2,Prices!D19,IF(C1=Prices!A3,Prices!G19,\"\"))))","v":206.45964910000001},"per cwt","x",{"$f":"'Cow-Calf'!E8","v":550},"lbs",null,null,"=",{"$f":"-(B10*(E10/100))","v":-1135.52807005}]
["Death Loss",null,null,null,null,null,null,null,null,{"$f":"(B4*J10)","v":-22.710561401}]
["Other"]
["Total Gross Return",null,null,null,null,null,null,null,null,{"$f":"SUM(J9:J12)","v":323.91136854899986}]
[]
["Variable Costs"]
["Pasture",{"$f":"IF(C1=Prices!A1, Prices!B13, IF(C1=Prices!A2, Prices!D13, IF(C1=Prices!A3,Prices!G13, \"\")))","v":18.059999999999999},"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!B14, IF(C1=Prices!A2, Prices!D14, IF(C1=Prices!A3,Prices!G14, \"\")))","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!B11)+((Feed!C23/Feed!C25)*Prices!B10)+((Feed!C24/Feed!C25)*Prices!B12)),IF(C1=Prices!A2,(((Feed!C22/Feed!C25)*Prices!D11)+((Feed!C23/Feed!C25)*Prices!D10)+((Feed!C24/Feed!C25)*Prices!D12)),IF(C1=Prices!A3,((Feed!C22/Feed!C25)*Prices!G11)+((Feed!C23/Feed!C25)*Prices!G10)+((Feed!C24/Feed!C25)*Prices!G12),\"\")))","v":87.5},"per ton","x",{"$f":"(Feed!C25/2000)*B5","v":0.42},"total tons",null,null," =",{"$f":"B18*E18","v":36.75}]
["Grain/Protein Supplements",{"$f":"IF(C1=Prices!A1,(((Feed!C28/Feed!C29)*Prices!B7)+((Feed!C27/Feed!C29)*Prices!B8)+((Feed!C26/Feed!C29)*(Prices!B6*2000)/56)),IF(C1=Prices!A2,(((Feed!C28/Feed!C29)*Prices!D7)+((Feed!C27/Feed!C29)*Prices!D8)+((Feed!C26/Feed!C29)*(Prices!D6*2000)/56)),IF(C1=Prices!A3,(((Feed!C28/Feed!C29)*Prices!G7)+((Feed!C27/Feed!C29)*Prices!G8)+((Feed!C26/Feed!C29)*(Prices!G6*2000)/56)),\"\")))","v":141.07142857142856},"per ton","x",{"$f":"Feed!C29*B5","v":1680},"total lbs",null,null," =",{"$f":"(B19/2000)*E19","v":118.49999999999997}]
["Mineral",{"$f":"IF(C1=Prices!A1,Prices!B16, IF(C1=Prices!A2,Prices!D16, IF(C1=Prices!A3,Prices!G16, \"\")))","v":550},"per ton","x",{"$f":"Feed!C30*B5","v":36},"total lbs",null,null," =",{"$f":"(B20/2000)*E20","v":9.9}]
["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.2},"hours",null,null," =",{"$f":"B22*E22","v":24}]
["Vet Medicine/Drugs",null,null,null,null,null,null,null,null,{"$f":"ROUND(9.29*J5,0)","v":25}]
["Marketing costs",null,null,null,null,null,null,null,null,{"$f":"ROUND(5.21*J5,0)","v":14}]
["Utilities,Gas, Fuel, Oil",null,null,null,null,null,null,null,null,{"$f":"ROUND(3.43*J5,0)","v":9}]
["Machinery, Facility/Equip. Repairs",null,null,null,null,null,null,null,null,{"$f":"ROUND(4.48*J5,0)","v":12}]
["Cash Interest Paid",null,null,null,null,null,null,null,null,{"$f":"ROUND(4.82*J5,0)","v":13}]
["Other variable costs",null,null,null,null,null,null,null,null,{"$f":"ROUND(1.59*J5,0)","v":4}]
["  Total Variable Costs",null,null,null,null,null,null,null,null,{"$f":"SUM(J16:J28)","v":266.14999999999998}]
[]
["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,2]
["Opportunity Cost of Investment",null,null,null,null,null,null,null,null,38]
["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":51}]
[]
["Total Costs",null,null,null,null,null,null,null,null,{"$f":"J29+J37","v":317.14999999999998}]
[]
["Income Over Variable Costs",null,null,null,null,null,null,null,null,{"$f":"J13-J29","v":57.761368548999883}]
["Income Over Total Costs ",null,null,null,null,null,null,null,null,{"$f":"J13-J39","v":6.7613685489998829}]
[]
["Kansas State University, Department of Agricultural Economics - www.agmanager.info"]
["Publication: AM-FMG-Backgrounding",null,null,null,null,null,null,null,null,{"$f":"TEXT(Notes!D2,\"MMM. DD, YYYY\")","v":"Dec. 01, 2015"}]
[]
[" 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":"Dec. 01, 2015"}]
[]
[" 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,"Current","One Year Out",null,"Five Years Out"]
["Heifer Calf Price ($/cwt)",{"$f":"Prices!B18","v":189.01480000000001},{"$f":"Prices!D18","v":183.53980000000001},null,{"$f":"Prices!G18","v":217.07534340665507}]
["Steer Calf Price ($/cwt)",{"$f":"Prices!B19","v":206.45964910000001},{"$f":"Prices!D19","v":200.98464910000001},null,{"$f":"Prices!G19","v":237.11}]
["Feeder Steers($/cwt)",{"$f":"Prices!B20","v":180.75},{"$f":"Prices!D20","v":175.27500000000001},null,{"$f":"Prices!G20","v":193.23}]
["Corn ($/bu)",{"$f":"Prices!B6","v":3.77},{"$f":"Prices!D6","v":4.0660000000000007},null,{"$f":"Prices!G6","v":3.55}]
["Soybean meal ($/ton)",{"$f":"Prices!B7","v":281.60000000000002},{"$f":"Prices!D7","v":291.7},null,{"$f":"Prices!G7","v":326}]
["Distillers Grains ($/ton)",{"$f":"Prices!B8","v":147.5},{"$f":"Prices!D8","v":159.08090185676394},null,{"$f":"Prices!G8","v":138.89257294429709}]
["Silage ($/ton)",{"$f":"Prices!B10","v":30.16},{"$f":"Prices!D10","v":32.528000000000006},null,{"$f":"Prices!G10","v":28.4}]
["Hay ($/ton)",{"$f":"Prices!B11","v":60},{"$f":"Prices!D11","v":64.710875331564992},null,{"$f":"Prices!G11","v":56.49867374005305}]
["Alfalfa ($/ton)",{"$f":"Prices!B12","v":115},{"$f":"Prices!D12","v":124.0291777188329},null,{"$f":"Prices!G12","v":108.28912466843501}]
["Pasture Rental ($/acre)",{"$f":"Prices!B13","v":18.059999999999999},{"$f":"Prices!D13","v":18.421199999999999},null,{"$f":"Prices!G13","v":19.866}]
["Crop Residue ($/acre)",{"$f":"Prices!B14","v":15},{"$f":"Prices!D14","v":15.3},null,{"$f":"Prices!G14","v":16.5}]
["Mineral ($/ton)",{"$f":"Prices!B16","v":550},{"$f":"Prices!D16","v":561},null,{"$f":"Prices!G16","v":605}]
[]
[]
[]
[]
[]
[]
[]
["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":"Dec. 01, 2015"}]

{"sheet":"Stocker","index":5,"n_rows":136,"n_cols":12,"rows_kept":136,"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],[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!D4,TEXT(Prices!D5,\"MMM-YYYY\"),TEXT(Prices!G5,\"MMM-YYYY\")))","v":"(as of December 1, 2015)"}]
[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":1.875}]
[]
[]
["Gross Return","Price","Unit",null,"Qty","Unit",null,null,null,"Total per Year"]
["Feeder Sale",{"$f":"(IF(C1=Prices!A1,Prices!B20,IF(C1=Prices!A2,Prices!D20,IF(C1=Prices!A3,Prices!G20,\"\"))))","v":180.75},"per cwt","x",{"$f":"E10+(B5*F5)","v":737.5},"lbs",null,null," =",{"$f":"B9*(E9/100)","v":1333.03125}]
["Purchase price",{"$f":"(IF(C1=Prices!A1,Prices!B19,IF(C1=Prices!A2,Prices!D19,IF(C1=Prices!A3,Prices!G19,\"\"))))","v":206.45964910000001},"per cwt","x",{"$f":"'Cow-Calf'!E8","v":550},"lbs",null,null,"=",{"$f":"-(B10*(E10/100))","v":-1135.52807005}]
["Death Loss",null,null,null,null,null,null,null,null,{"$f":"(B4*J10)","v":-11.3552807005}]
["Other"]
["Total Gross Return",null,null,null,null,null,null,null,null,{"$f":"SUM(J9:J12)","v":186.1478992495}]
[]
["Variable Costs"]
["Pasture",{"$f":"IF(C1=Prices!A1, Prices!B13, IF(C1=Prices!A2, Prices!D13, IF(C1=Prices!A3,Prices!G13, \"\")))","v":18.059999999999999},"per acre","x",{"$f":"Feed!I5","v":4},"total acres",null,null," =",{"$f":"B16*E16","v":72.239999999999995}]
["Crop Residue",{"$f":"IF(C1=Prices!A1, Prices!B14, IF(C1=Prices!A2, Prices!D14, IF(C1=Prices!A3,Prices!G14, \"\")))","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!B11)+((Feed!I8/Feed!I10)*Prices!B10)+((Feed!I9/Feed!I10)*Prices!B12)),IF(C1=Prices!A2,(((Feed!I7/Feed!I10)*Prices!D11)+((Feed!I8/Feed!I10)*Prices!D10)+((Feed!I9/Feed!I10)*Prices!D12)),IF(C1=Prices!A3,((Feed!I7/Feed!I10)*Prices!G11)+((Feed!I8/Feed!I10)*Prices!G10)+((Feed!I9/Feed!I10)*Prices!G12),\"\")))),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!B7)+((Feed!I12/Feed!I14)*Prices!B8)+((Feed!I11/Feed!I14)*(Prices!B6*2000)/56)),IF(C1=Prices!A2,(((Feed!I13/Feed!I14)*Prices!D7)+((Feed!I12/Feed!I14)*Prices!D8)+((Feed!I11/Feed!I14)*(Prices!D6*2000)/56)),IF(C1=Prices!A3,(((Feed!I13/Feed!I14)*Prices!G7)+((Feed!I12/Feed!I14)*Prices!G8)+((Feed!I11/Feed!I14)*(Prices!G6*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!B16, IF(C1=Prices!A2,Prices!D16, IF(C1=Prices!A3,Prices!G16, \"\")))","v":550},"per ton","x",{"$f":"Feed!I15","v":37.5},"total lbs",null,null," =",{"$f":"(B20/2000)*E20","v":10.3125}]
["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":7}]
["Marketing costs",null,null,null,null,null,null,null,null,{"$f":"ROUND(5.61*J5,0)","v":11}]
["Utilities,Gas, Fuel, Oil",null,null,null,null,null,null,null,null,{"$f":"ROUND(3.25*J5,0)","v":6}]
["Machinery, Facility/Equip. Repairs",null,null,null,null,null,null,null,null,{"$f":"ROUND(5.46*J5,0)","v":10}]
["Cash Interest Paid",null,null,null,null,null,null,null,null,{"$f":"ROUND(3.55*J5,0)","v":7}]
["Other variable costs",null,null,null,null,null,null,null,null,{"$f":"ROUND(1.29*J5,0)","v":2}]
["  Total Variable Costs",null,null,null,null,null,null,null,null,{"$f":"SUM(J16:J28)","v":145.55250000000001}]
[]
["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":181.30250000000001}]
[]
["Income Over Variable Costs",null,null,null,null,null,null,null,null,{"$f":"J13-J29","v":40.595399249499991}]
["Income Over Total Costs ",null,null,null,null,null,null,null,null,{"$f":"J13-J39","v":4.8453992494999909}]
[]
["Kansas State University, Department of Agricultural Economics - www.agmanager.info"]
["Publication: AM-FMG-Stocker",null,null,null,null,null,null,null,null,{"$f":"TEXT(Notes!D2,\"MMM. DD, YYYY\")","v":"Dec. 01, 2015"}]
[]
[" 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":"Dec. 01, 2015"}]
[]
[" 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!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":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!B18","v":189.01480000000001},{"$f":"Prices!D18","v":183.53980000000001},null,{"$f":"Prices!G18","v":217.07534340665507}]
["Steer Calf Price ($/cwt)",{"$f":"Prices!B19","v":206.45964910000001},{"$f":"Prices!D19","v":200.98464910000001},null,{"$f":"Prices!G19","v":237.11}]
["Feeder Steers($/cwt)",{"$f":"Prices!B20","v":180.75},{"$f":"Prices!D20","v":175.27500000000001},null,{"$f":"Prices!G20","v":193.23}]
["Corn ($/bu)",{"$f":"Prices!B6","v":3.77},{"$f":"Prices!D6","v":4.0660000000000007},null,{"$f":"Prices!G6","v":3.55}]
["Soybean meal ($/ton)",{"$f":"Prices!B7","v":281.60000000000002},{"$f":"Prices!D7","v":291.7},null,{"$f":"Prices!G7","v":326}]
["Distillers Grains ($/ton)",{"$f":"Prices!B8","v":147.5},{"$f":"Prices!D8","v":159.08090185676394},null,{"$f":"Prices!G8","v":138.89257294429709}]
["Silage ($/ton)",{"$f":"Prices!B10","v":30.16},{"$f":"Prices!D10","v":32.528000000000006},null,{"$f":"Prices!G10","v":28.4}]
["Hay ($/ton)",{"$f":"Prices!B11","v":60},{"$f":"Prices!D11","v":64.710875331564992},null,{"$f":"Prices!G11","v":56.49867374005305}]
["Alfalfa ($/ton)",{"$f":"Prices!B12","v":115},{"$f":"Prices!D12","v":124.0291777188329},null,{"$f":"Prices!G12","v":108.28912466843501}]
["Pasture Rental ($/acre)",{"$f":"Prices!B13","v":18.059999999999999},{"$f":"Prices!D13","v":18.421199999999999},null,{"$f":"Prices!G13","v":19.866}]
["Crop Residue ($/acre)",{"$f":"Prices!B14","v":15},{"$f":"Prices!D14","v":15.3},null,{"$f":"Prices!G14","v":16.5}]
["Mineral ($/ton)",{"$f":"Prices!B16","v":550},{"$f":"Prices!D16","v":561},null,{"$f":"Prices!G16","v":605}]
[]
[]
[]
[]
[]
[]
[]
["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":"Dec. 01, 2015"}]

{"sheet":"Feedlot","index":6,"n_rows":134,"n_cols":12,"rows_kept":134,"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],[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!D4,TEXT(Prices!D5,\"MMM-YYYY\"),TEXT(Prices!G5,\"MMM-YYYY\")))","v":"(as of December 1, 2015)"}]
[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!B21,IF(C1=Prices!A2,Prices!D21,IF(C1=Prices!A3,Prices!G21,\"\"))))","v":126.34},"per cwt","x",{"$f":"E9+(B5*F5)","v":1367},"lbs",null,null,"=",{"$f":"B8*(E8/100)","v":1727.0678}]
["Purchase price",{"$f":"(IF(C1=Prices!A1,Prices!B20,IF(C1=Prices!A2,Prices!D20,IF(C1=Prices!A3,Prices!G20,\"\"))))","v":180.75},"per cwt","x",775,"lbs",null,null,"=",{"$f":"-(B9*(E9/100))","v":-1400.8125}]
["Death Loss",null,null,null,null,null,null,null,null,{"$f":"(B4*J9)","v":-21.0121875}]
["Other"]
["Total Gross Return",null,null,null,null,null,null,null,null,{"$f":"SUM(J8:J11)","v":305.24311250000005}]
[]
["Variable Costs"]
["Harvested Forage",{"$f":"IF(C1=Prices!A1,(((Feed!I20/Feed!I23)*Prices!B11)+((Feed!I21/Feed!I23)*Prices!B10)+((Feed!I22/Feed!I23)*Prices!B12)),IF(C1=Prices!A2,(((Feed!I20/Feed!I23)*Prices!D11)+((Feed!I21/Feed!I23)*Prices!D10)+((Feed!I22/Feed!I23)*Prices!D12)),IF(C1=Prices!A3,((Feed!I20/Feed!I23)*Prices!G11)+((Feed!I21/Feed!I23)*Prices!G10)+((Feed!I22/Feed!I23)*Prices!G12),\"\")))","v":87.5},"per ton","x",{"$f":"(Feed!I23*Feedlot!B5)/2000","v":0.24},"total tons",null,null," =",{"$f":"B15*E15","v":21}]
["Grain/Protein Supplements",{"$f":"IF(C1=Prices!A1,(((Feed!I26/Feed!I27)*Prices!B7)+((Feed!I25/Feed!I27)*Prices!B8)+((Feed!I24/Feed!I27)*(Prices!B6*2000)/56)),IF(C1=Prices!A2,(((Feed!I26/Feed!I27)*Prices!D7)+((Feed!I25/Feed!I27)*Prices!D8)+((Feed!I24/Feed!I27)*(Prices!D6*2000)/56)),IF(C1=Prices!A3,(((Feed!I26/Feed!I27)*Prices!G7)+((Feed!I25/Feed!I27)*Prices!G8)+((Feed!I24/Feed!I27)*(Prices!G6*2000)/56)),\"\")))","v":137.56493506493507},"per ton","x",{"$f":"Feed!I27*B5","v":3520},"total lbs",null,null," =",{"$f":"(B16/2000)*E16","v":242.11428571428576}]
["Mineral",{"$f":"IF(C1=Prices!A1,Prices!B16, IF(C1=Prices!A2,Prices!D16, IF(C1=Prices!A3,Prices!G16, \"\")))","v":550},"per ton","x",{"$f":"Feed!I28*B5","v":80},"total lbs",null,null," =",{"$f":"(B17/2000)*E17","v":22}]
["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":386.11428571428576}]
[]
["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":455.86428571428576}]
[]
["Income Over Variable Costs",null,null,null,null,null,null,null,null,{"$f":"J12-J26","v":-80.871173214285704}]
["Income Over Total Costs ",null,null,null,null,null,null,null,null,{"$f":"J12-J36","v":-150.6211732142857}]
[]
[]
[]
["Kansas State University, Department of Agricultural Economics - www.agmanager.info"]
["Publication: AM-FMG-Finishing",null,null,null,null,null,null,null,null,{"$f":"TEXT(Notes!D2,\"MMM. DD, YYYY\")","v":"Dec. 01, 2015"}]
[]
[" 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":"Dec. 01, 2015"}]
[]
[" 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,"Current","One Year Out",null,"Five Years Out"]
["Feeder Steers ($/cwt)",{"$f":"Prices!B20","v":180.75},{"$f":"Prices!D20","v":175.27500000000001},null,{"$f":"Prices!G20","v":193.23}]
["5-area Fed Cattle ($/cwt)",{"$f":"Prices!B21","v":126.34},{"$f":"Prices!D21","v":120.36499999999999},null,{"$f":"Prices!G21","v":158.41999999999999}]
["Corn ($/bu)",{"$f":"Prices!B6","v":3.77},{"$f":"Prices!D6","v":4.0660000000000007},null,{"$f":"Prices!G6","v":3.55}]
["Soybean meal ($/ton)",{"$f":"Prices!B7","v":281.60000000000002},{"$f":"Prices!D7","v":291.7},null,{"$f":"Prices!G7","v":326}]
["Distillers Grains ($/ton)",{"$f":"Prices!B8","v":147.5},{"$f":"Prices!D8","v":159.08090185676394},null,{"$f":"Prices!G8","v":138.89257294429709}]
["Silage ($/ton)",{"$f":"Prices!B10","v":30.16},{"$f":"Prices!D10","v":32.528000000000006},null,{"$f":"Prices!G10","v":28.4}]
["Hay ($/ton)",{"$f":"Prices!B11","v":60},{"$f":"Prices!D11","v":64.710875331564992},null,{"$f":"Prices!G11","v":56.49867374005305}]
["Alfalfa ($/ton)",{"$f":"Prices!B12","v":115},{"$f":"Prices!D12","v":124.0291777188329},null,{"$f":"Prices!G12","v":108.28912466843501}]
["Pasture Rental ($/acre)",{"$f":"Prices!B13","v":18.059999999999999},{"$f":"Prices!D13","v":18.421199999999999},null,{"$f":"Prices!G13","v":19.866}]
["Crop Residue ($/acre)",{"$f":"Prices!B14","v":15},{"$f":"Prices!D14","v":15.3},null,{"$f":"Prices!G14","v":16.5}]
["Mineral ($/ton)",{"$f":"Prices!B16","v":550},{"$f":"Prices!D16","v":561},null,{"$f":"Prices!G16","v":605}]
[]
[]
[]
[]
[]
[]
[]
["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":"Dec. 01, 2015"}]