{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Introduction","Summary","Risk Analysis","Charts","Input","Feed Rations","Ration Data","Fixed","Breakeven","Facilities","Chart data (HIDE)","More...Breakeven (HIDE)"],"not_rendered":{"charts":3,"images":4,"macros":1,"external_links":1,"defined_names":84,"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":45,"n_cols":10,"rows_kept":45,"cut":false,"hidden":false,"merged":[[27,1,31,10],[44,1,46,10],[14,1,20,10],[21,1,26,10],[4,0,4,10],[5,0,5,10],[6,0,6,10],[7,0,7,10]]}
[]
[]
[". . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . "]
[]
["Guidelines For Estimating"]
["Beef Backgrounding Costs"]
[{"$f":"\"For Weight Range of \"&Input!D14&\" - \"&Input!D16&\" lbs\"","v":"For Weight Range of 500 - 900 lbs"}]
[{"$f":"\"Based on \"&Input!D12&\" Head\"","v":"Based on 500 Head"}]
[]
[]
[null,null,null,null,null,null,null,"Date:",null,"September, 2025"]
[]
[]
[]
[null,"This guide is designed to provide you with planning information and a format for calculating costs of production of a backgrounding feeder calf enterprise in Manitoba.  General Manitoba Agriculture  recommendations are assumed in using feed and veterinary inputs. These figures provide an economic evaluation of the livestock and estimated prices required to cover all costs.  Costs include labour, investment and depreciation, but do not include management costs, nor do they necessarily represent the average cost of production in Manitoba."]
[]
[]
[]
[]
[]
[]
[null,"Backgrounding generally refers to the feeding of calves from weaning until they are put onto a high concentrate finishing ration.  An example of a typical backgrounding operation would be, feed 500 pound steers to gain 1.5 to 2.5 pounds per day for approximately 100-200 days to produce 800 to 900 pound backgrounded feeders."]
[]
[]
[]
[]
[]
[null,"These budgets may be adjusted by putting in your own figures.  As a producer you are encouraged to calculate your own costs of production.  Good management is assumed in that a balanced ration is being fed, livestock are on a herd health program and handling facilities are included.  "]
[]
[]
[]
[]
[]
[null,"This tool is available as an Excel worksheet at: "]
[]
[]
[]
[]
[]
[]
[]
[null,"                                                                                                is also available to help"]
[null,"determine machinery costs."]
[]
[null,"Note: This budget is only a guide and is not intended as an in-depth study of the cost of production of this industry. Interpretation and use of this information is the responsibility of the user.  If you need help with a budget, contact a Farm Management Specialist."]

{"sheet":"Summary","index":1,"n_rows":68,"n_cols":15,"rows_kept":68,"cut":false,"hidden":false,"merged":[[0,0,0,9],[67,0,67,9],[1,0,1,9]]}
[{"$f":"\"Backgrounding Cattle Production Cost Summary -  \"&Introduction!J11","v":"Backgrounding Cattle Production Cost Summary -  September, 2025"}]
[{"$f":"\"Based on \"&Input!D12&\" feeders, weight range \"&Input!D14&\" to \"&Input!D16&\" lbs, \"&Input!C24&\" ration @ \"&Input!D23&\" lbs. ADG\"","v":"Based on 500 feeders, weight range 500 to 900 lbs, Corn Silage ration @ 2.5 lbs. ADG"}]
[]
["A.  Operating Costs",null,null,null,null,"Cost/Head",null,"Total Cost","","Your Cost"]
["1.  Feed Costs",null,null,null,null,""]
[{"$f":"\"    1.01  \"&Input!A28&\" (\"&Input!G28*100&\" % TDN, \"&Input!H28*100&\" % CP)\"","v":"    1.01  Alfalfa Grass Hay (57.8 % TDN, 13.7 % CP)"},null,null,null,null,{"$f":"Input!F28","v":48},null,{"$f":"IF(Input!$C$24=\"Barley Silage\",'Feed Rations'!$L9,IF(Input!$C$24=\"Corn Silage\",'Feed Rations'!L27,'Feed Rations'!L45))","v":24000}]
[{"$f":"\"    1.02  \"&Input!A29&\" (\"&Input!G29*100&\" % TDN, \"&Input!H29*100&\" % CP)\"","v":"    1.02  Corn Silage (65.2 % TDN, 8.7 % CP)"},null,null,null,null,{"$f":"Input!F29","v":79.8},null,{"$f":"IF(Input!$C$24=\"Barley Silage\",'Feed Rations'!$L10,IF(Input!$C$24=\"Corn Silage\",'Feed Rations'!L28,'Feed Rations'!L46))","v":39920}]
[{"$f":"\"    1.03  \"&Input!A30&\" (\"&Input!G30*100&\" % TDN, \"&Input!H30*100&\" % CP)\"","v":"    1.03  Barley Silage (63 % TDN, 11 % CP)"},null,null,null,null,{"$f":"Input!F30","v":0},null,{"$f":"IF(Input!$C$24=\"Barley Silage\",'Feed Rations'!$L11,IF(Input!$C$24=\"Corn Silage\",'Feed Rations'!L29,'Feed Rations'!L47))","v":0}]
[{"$f":"\"    1.04  \"&Input!A31&\" (\"&Input!G31*100&\" % TDN, \"&Input!H31*100&\" % CP)\"","v":"    1.04  Barley Grain (83.1 % TDN, 12.5 % CP)"},null,null,null,null,{"$f":"Input!F31","v":77.08},null,{"$f":"IF(Input!$C$24=\"Barley Silage\",'Feed Rations'!$L12,IF(Input!$C$24=\"Corn Silage\",'Feed Rations'!L30,'Feed Rations'!L48))","v":38439}]
[{"$f":"\"    1.05  \"&Input!A32","v":"    1.05  Greenfeed"},null,null,null,null,{"$f":"Input!F32","v":0},null,{"$f":"IF(Input!$C$24=\"Barley Silage\",'Feed Rations'!$L13,IF(Input!$C$24=\"Corn Silage\",'Feed Rations'!L31,'Feed Rations'!L49))","v":0}]
[{"$f":"\"    1.06  \"&Input!A33","v":"    1.06  Straw"},null,null,null,null,{"$f":"Input!F33","v":0},null,{"$f":"IF(Input!$C$24=\"Barley Silage\",'Feed Rations'!$L14,IF(Input!$C$24=\"Corn Silage\",'Feed Rations'!L32,'Feed Rations'!L50))","v":0}]
[{"$f":"\"    1.07  \"&Input!A34&\" (\"&ROUND(Input!G34*100,1)&\"%TDN, \"&Input!H34*100&\"%CP)\"","v":"    1.07  32-20% Feedlot Suppl. (61.7%TDN, 35.6%CP)"},null,null,null,null,{"$f":"Input!F34","v":0},null,{"$f":"IF(Input!$C$24=\"Barley Silage\",'Feed Rations'!$L15,IF(Input!$C$24=\"Corn Silage\",'Feed Rations'!L33,'Feed Rations'!L51))","v":0}]
[{"$f":"\"    1.08  \"&Input!A35&\" (\"&Input!G35*100&\" % TDN, \"&Input!H35*100&\" % CP)\"","v":"    1.08  DDGS Corn/Wheat (77 % TDN, 33.9 % CP)"},null,null,null,null,{"$f":"Input!F35","v":14.69},null,{"$f":"IF(Input!$C$24=\"Barley Silage\",'Feed Rations'!$L16,IF(Input!$C$24=\"Corn Silage\",'Feed Rations'!L34,'Feed Rations'!L52))","v":7500}]
[{"$f":"\"    1.09  \"&Input!A36","v":"    1.09  1:1 Premix"},null,null,null,null,{"$f":"Input!F36","v":0},null,{"$f":"IF(Input!$C$24=\"Barley Silage\",'Feed Rations'!$L17,IF(Input!$C$24=\"Corn Silage\",'Feed Rations'!L35,'Feed Rations'!L53))","v":0}]
[{"$f":"\"    1.10  \"&Input!A37","v":"    1.10  2:1 Premix"},null,null,null,null,{"$f":"Input!F37","v":40.909999999999997},null,{"$f":"IF(Input!$C$24=\"Barley Silage\",'Feed Rations'!$L18,IF(Input!$C$24=\"Corn Silage\",'Feed Rations'!L36,'Feed Rations'!L54))","v":20500}]
[{"$f":"\"    1.11  \"&Input!A38","v":"    1.11  Limestone"},null,null,null,null,{"$f":"Input!F38","v":5.0999999999999996},null,{"$f":"IF(Input!$C$24=\"Barley Silage\",'Feed Rations'!$L19,IF(Input!$C$24=\"Corn Silage\",'Feed Rations'!L37,'Feed Rations'!L55))","v":2560}]
[{"$f":"\"    1.12  \"&Input!A39","v":"    1.12  Other"},null,null,null,null,{"$f":"Input!F39","v":0},null,{"$f":"IF(Input!$C$24=\"Barley Silage\",'Feed Rations'!$L20,IF(Input!$C$24=\"Corn Silage\",'Feed Rations'!L38,'Feed Rations'!L56))","v":0}]
["    Total Feed Costs",null,null,null,null,{"$f":"SUM(F6:F16)","v":265.58000000000004},null,{"$f":"SUM(H6:H16)","v":132919}]
["2.  Other Operating Costs"]
["    2.01  Feeder Cost",null,null,null,null,{"$f":"Input!D71","v":3415.25},null,{"$f":"ROUND(F20*Input!$D$12,0)","v":1707625}]
["    2.02  Straw",null,null,null,null,{"$f":"Input!D76","v":22.4},null,{"$f":"ROUND(F21*Input!$D$12,0)","v":11200},null,null,null,null,null,{"$f":"F21","v":22.4},"straw"]
["    2.03  Veterinary Medicine & Supplies",null,null,null,null,{"$f":"Input!D97","v":26.24},null,{"$f":"ROUND(F22*Input!$D$12,0)","v":13120},null,null,null,null,null,{"$f":"Input!D163","v":1.54},"building ins"]
["    2.04  Annual Fuel & Repair Costs",null,null,null,null,{"$f":"SUM(Input!D109+Input!D115+Input!D121)","v":10.059379999999999},null,{"$f":"ROUND(F23*Input!$D$12,0)","v":5030},null,null,null,null,null,{"$f":"F23","v":10.059379999999999},"fuel and repair"]
["    2.05  Utilities",null,null,null,null,{"$f":"Input!D129","v":3.4548624000000001},null,{"$f":"ROUND(F24*Input!$D$12,0)","v":1727},null,null,null,null,null,{"$f":"F24","v":3.4548624000000001},"utili"]
["    2.06  Feeder Selling Cost",null,null,null,null,{"$f":"Input!D148","v":36.950000000000003},null,{"$f":"ROUND(F25*Input!$D$12,0)","v":18475}]
["    2.07  Insurance",null,null,null,null,{"$f":"Input!D174","v":1.64},null,{"$f":"ROUND(F26*Input!$D$12,0)","v":820}]
["    2.08  Manure Removal",null,null,null,null,{"$f":"Input!D156","v":18.834479999999999},null,{"$f":"ROUND(F27*Input!$D$12,0)","v":9417},null,null,null,null,null,{"$f":"F27","v":18.834479999999999},"manure"]
["    2.09  Barn & Office Supplies",null,null,null,null,{"$f":"Input!D179","v":1.2},null,{"$f":"ROUND(F28*Input!$D$12,0)","v":600},null,null,null,null,null,{"$f":"Fixed!D13","v":7.2},"building dep"]
["    2.10  Death Loss",null,null,null,null,{"$f":"Input!D187","v":71.8},null,{"$f":"ROUND(F29*Input!$D$12,0)","v":35900},null,null,null,null,null,{"$f":"Fixed!I13","v":18},"mach dep"]
["Subtotal Operating Costs",null,null,null,null,{"$f":"ROUND(SUM(F18:F29),2)","v":3873.41},null,{"$f":"SUM(H18:H29)","v":1936833},null,null,null,null,null,{"$f":"Fixed!D12","v":4.3375197723671057},"building inv"]
["    2.11  Operating Interest",null,null,null,null,{"$f":"Input!D196","v":107.83},null,{"$f":"ROUND(F31*Input!$D$12,0)","v":53915},null,null,null,null,null,{"$f":"Fixed!I12","v":8.1328495731883219},"mach inv"]
["    Total Operating Costs",null,null,null,null,{"$f":"F30+F31","v":3981.24},null,{"$f":"H30+H31","v":1990748},null,null,null,null,null,{"$f":"SUM(F21:F29)*(Input!D193/100)*(Input!B50/365)","v":5.6982197312876712},"op interest"]
["B.  Fixed Costs",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F28","v":1.2},"misc"]
[null,"    Buildings",null,null,null,{"$f":"Fixed!D15","v":11.537519772367105},null,{"$f":"ROUND(F34*Input!$D$12,0)","v":5769},null,null,null,null,null,{"$f":"F39","v":28},"labour"]
[null,"    Machinery & Equipment",null,null,null,{"$f":"Fixed!I15","v":26.132849573188324},null,{"$f":"ROUND(F35*Input!$D$12,0)","v":13066},null,null,null,null,null,{"$f":"SUM(N21:N34)","v":128.85731147684311}]
[null,"Total Fixed Costs",null,null,null,{"$f":"SUM(F34:F35)","v":37.670369345555429},null,{"$f":"SUM(H34:H35)","v":18835},null,null,null,null,null,{"$f":"N35/Input!B50","v":0.80535819673026943},"yardage per day"]
["Total Operating and Fixed Costs",null,null,null,null,{"$f":"SUM(F32+F36)","v":4018.9103693455554},null,{"$f":"H32+H36","v":2009583}]
[]
["C.  Owners - Labour & Living",null,null,null,null,{"$f":"Input!D203","v":28},null,{"$f":"F39*Input!D12","v":14000}]
["Total Cost of Production",null,null,null,null,{"$f":"F37+F39","v":4046.9103693455554},null,{"$f":"H37+H39","v":2023583}]
[]
[null,null,null,"Profitability and Breakeven Analysis"]
[]
["Estimated Farmgate",null,null,null,null," Per Head","","Total"]
[{"$f":"\"    Gross Revenue @ $\"&Input!D17&\"/cwt market price\"","v":"    Gross Revenue @ $455/cwt market price"},null,null,null,null,{"$f":"Breakeven!F48","v":3972.15},null,{"$f":"ROUND(F45*Input!D12,0)","v":1986075}]
[]
[]
[null,null,null,null,null,"Breakeven Purchase",null,"Breakeven Selling"]
[null,null,null,null,null,"Price ($/cwt) @",null,"Price ($/cwt) @"]
[null,null,null,null,null,{"$f":"\"$\"&Input!D17&\"/cwt market price\"","v":"$455/cwt market price"},null,{"$f":"\"$\"&Input!D15&\"/cwt feeder price\"","v":"$680/cwt feeder price"}]
["     Operating Costs",null,null,null,null,{"$f":"Breakeven!F51*100","v":678.18200000000002},null,{"$f":"Breakeven!F31*100","v":456.04123711340208}]
["     Operating Costs & Labour",null,null,null,null,{"$f":"Breakeven!F58*100","v":672.58200000000011},null,{"$f":"Breakeven!F35*100","v":459.24856815578465}]
["     Operating & Fixed Costs",null,null,null,null,{"$f":"Breakeven!F65*100","v":670.64792613088889},null,{"$f":"Breakeven!F39*100","v":460.35628514840266}]
["     Total Costs",null,null,null,null,{"$f":"Breakeven!F72*100","v":665.04792613088887},null,{"$f":"Breakeven!F43*100","v":463.56361619078524}]
[]
[null,null,null,null,null,"Cost per lb of",null,"Marginal Returns per head"]
[null,null,null,null,null,"gain sold ($/cwt)",null,{"$f":"\"@ $\"&Input!D17&\"/cwt market price\"","v":"@ $455/cwt market price"}]
["     Feed Costs",null,null,null,null,{"$f":"Breakeven!F7*100","v":71.201072386058996},null,{"$f":"F45-F20-F18","v":291.32000000000005}]
["     Operating Costs",null,null,null,null,{"$f":"Breakeven!F12*100","v":155.82841823056296},null,{"$f":"Breakeven!F48-F32","v":-9.0899999999996908}]
["     Operating Costs & Labour",null,null,null,null,{"$f":"Breakeven!F17*100","v":163.33512064343159},null,{"$f":"Breakeven!F55-(F32+F39)","v":-37.089999999999691}]
["     Operating & Fixed Costs",null,null,null,null,{"$f":"Breakeven!F22*100","v":165.92771296127492},null,{"$f":"Breakeven!F62-(F32+F36)","v":-46.760369345555318}]
["     Total Costs",null,null,null,null,{"$f":"Breakeven!F27*100","v":173.43441537414355},null,{"$f":"Breakeven!F69-F40","v":-74.760369345555318}]
[]
[{"$f":"\"Yardage per Feeder per Day (based on \"&Input!B50&\" days)\"","v":"Yardage per Feeder per Day (based on 160 days)"},null,null,null,null,{"$f":"(F21+Input!D163+F23+F24+F27+Fixed!D13+Fixed!I13+Fixed!D12+Fixed!I12+F28+F39+(SUM(F21:F29)*(Input!D193/100)*(Input!B50/365)))/Input!B50","v":0.80535819673026943}]
["Return on Investment (ROI)",null,null,null,null,{"$f":"(F45-F40)/F40","v":-1.8473443324035162E-2}]
["Estimated Return on Asset (ROA)",null,null,null,null,{"$f":"((F45-F32-F39-Fixed!D13-Fixed!I13)/(Fixed!D19/Input!D12))","v":-0.16170820353063264}]
[]
["Note: This budget is only a guide and is not intended as an in-depth study of the cost of production of this industry. Interpretation and utilization of this information is the responsibility of the user. No liability for decisions based on this publication is assumed. "]

{"sheet":"Risk Analysis","index":2,"n_rows":48,"n_cols":7,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,0,0,6],[35,0,35,6],[37,2,37,6],[47,0,49,6]]}
["Risk & Sensitivity Analysis (Stress Test)"]
["A.  Operating Costs",null,null,null,"***HIDE***"]
[null,"Feed cost",{"$f":"Summary!F18","v":265.58000000000004}]
[null,"Feeder Cost",{"$f":"Summary!F20","v":3415.25}]
[null,"Other Operating Costs",{"$f":"SUM(Summary!F32-Summary!F20-Summary!F18)","v":300.40999999999974}]
[null,"Subtotal",{"$f":"SUM(C3:C5)","v":3981.24}]
["B.  Fixed Costs",null,{"$f":"Summary!F36","v":37.670369345555429}]
["C.  Labour",null,{"$f":"Summary!F39","v":28}]
["Total Costs",null,{"$f":"SUM(C6:C8)","v":4046.9103693455554}]
[]
["Estimated Farmgate"]
[null,"Price ($ per cwt)",{"$f":"Input!D17","v":455}]
[]
[]
[null,"Percent Market Price Change",-0.1]
[null,"Percent Feed Cost Change",0.05]
[null,"Percent Feeder Cost Change",0.05]
[]
[]
[null,null,"Per Head"]
[null,"Market Price ($ per cwt)",{"$f":"SUM(C12*(1+C15))","v":409.5}]
[null,"Feed Cost",{"$f":"SUM(C3+(C3*C16))","v":278.85900000000004}]
[null,"Feeder Cost",{"$f":"SUM(C4+(C4*C17))","v":3586.0124999999998}]
[]
[{"$f":"\"Stress Test Scenario = Market Price \"&IF(C15<0,\"Down\",\"Up\")&\" \"&ABS(C15*100)&\"%, Feed Price \"&IF(C16<0,\"Down\",\"Up\")&\" \"&ABS(C16*100)&\"% and Feeder Cost \"&IF(C17<0,\"Down\",\"Up\")&\" \"&ABS(C17*100)&\"%\"","v":"Stress Test Scenario = Market Price Down 10%, Feed Price Up 5% and Feeder Cost Up 5%"}]
[null,"Operating Costs",{"$f":"SUM(C5+C22+C23)","v":4165.2814999999991}]
[null,"Total Costs",{"$f":"C7+C8+C26","v":4230.9518693455548}]
[null,"Gross Revenue / feeder",{"$f":"(Breakeven!F46/100)*'Risk Analysis'!C21","v":3574.9350000000004}]
[null,"Marginal Returns "]
[null,"   Over Operating Costs",{"$f":"SUM(C28-C26)","v":-590.34649999999874}]
[null,"   Over Operating & Labour Costs",{"$f":"SUM(C28-C26-C8)","v":-618.34649999999874}]
[null,"   Over Total Costs (Net Profit)",{"$f":"SUM(C28-C27)","v":-656.01686934555437}]
[]
[null,"Operating Expense Ratio",{"$f":"SUM(C26/C28)","v":1.1651348905644434}]
[]
["Estimated Breakeven Canadian Dollar Analysis"]
[]
[null,null,{"$f":"\"Est. Market Price ($/cwt Cdn) @ \"&TEXT(Input!D18,\"0.0000\")&\" Cdn per USD\"","v":"Est. Market Price ($/cwt Cdn) @ 0.7300 Cdn per USD"}]
[null,null,{"$f":"SUM($E$39-10)","v":445},{"$f":"SUM($E$39-5)","v":450},{"$f":"Input!D17","v":455},{"$f":"SUM($E$39+5)","v":460},{"$f":"SUM($E$39+10)","v":465}]
["Breakeven CDN Dollar ($1 Cdn = $ USD)"]
[null,"Operating Costs",{"$f":"SUM((C39/100)*Breakeven!$F$46*Input!$D$18)/Summary!$F$32","v":0.71232593362871877},{"$f":"SUM((D39/100)*Breakeven!$F$46*Input!$D$18)/Summary!$F$32","v":0.72032959580432232},{"$f":"SUM((E39/100)*Breakeven!$F$46*Input!$D$18)/Summary!$F$32","v":0.72833325797992576},{"$f":"SUM((F39/100)*Breakeven!$F$46*Input!$D$18)/Summary!$F$32","v":0.73633692015552943},{"$f":"SUM((G39/100)*Breakeven!$F$46*Input!$D$18)/Summary!$F$32","v":0.74434058233113309}]
[null,"Operating & Labour Costs",{"$f":"SUM((C39/100)*Breakeven!$F$46*Input!$D$18)/(Summary!$F$32+Summary!$F$39)","v":0.70735114385768882},{"$f":"SUM((D39/100)*Breakeven!$F$46*Input!$D$18)/(Summary!$F$32+Summary!$F$39)","v":0.71529890951901109},{"$f":"SUM((E39/100)*Breakeven!$F$46*Input!$D$18)/(Summary!$F$32+Summary!$F$39)","v":0.72324667518033336},{"$f":"SUM((F39/100)*Breakeven!$F$46*Input!$D$18)/(Summary!$F$32+Summary!$F$39)","v":0.73119444084165575},{"$f":"SUM((G39/100)*Breakeven!$F$46*Input!$D$18)/(Summary!$F$32+Summary!$F$39)","v":0.73914220650297824}]
[null,"Operating, Fixed & Labour Costs",{"$f":"SUM((C39/100)*Breakeven!$F$46*Input!$D$18)/Summary!$F$40","v":0.70076681744216962},{"$f":"SUM((D39/100)*Breakeven!$F$46*Input!$D$18)/Summary!$F$40","v":0.70864060190781197},{"$f":"SUM((E39/100)*Breakeven!$F$46*Input!$D$18)/Summary!$F$40","v":0.71651438637345422},{"$f":"SUM((F39/100)*Breakeven!$F$46*Input!$D$18)/Summary!$F$40","v":0.72438817083909657},{"$f":"SUM((G39/100)*Breakeven!$F$46*Input!$D$18)/Summary!$F$40","v":0.73226195530473903}]
[]
[{"$f":"\"Breakeven Canadian Dollar = (Est. Market Price ($/lb) x Shrunk Wt. (lbs) x $ Cdn per USD) / Cost\"","v":"Breakeven Canadian Dollar = (Est. Market Price ($/lb) x Shrunk Wt. (lbs) x $ Cdn per USD) / Cost"}]
[{"$f":"\"   (eg. ($\"&TEXT(E39/100,\"0.00\")&\" x \"&ROUND(Breakeven!F46,0)&\" lbs x $\"&TEXT(Input!D18,\"0.0000\")&\") / $\"&TEXT(Summary!F40,\"0.00\")&\") = $\"&TEXT(E43,\"0.0000\")","v":"   (eg. ($4.55 x 873 lbs x $0.7300) / $4046.91) = $0.7165"}]
[]
["Note: This budget is only a guide and is not intended as an in depth study of the cost of production of this industry. Interpretation and utilization of this information is the responsibility of the user."]

{"sheet":"Charts","index":3,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,""]

{"sheet":"Input","index":4,"n_rows":203,"n_cols":12,"rows_kept":203,"cut":false,"hidden":false,"merged":[[0,0,0,6],[9,0,9,6],[23,2,23,3]]}
["                 Backgrounding Feeder Cattle Production Costs",null,null,null,null,null,null,null,null,"HIDE"]
[]
["   Assumptions"]
["   1.  This budget outlines the cost of production for backgrounding cattle."]
["   2.  Buildings and equipment are valued at new cost."]
["   3.  All feed is purchased."]
[]
[]
[]
["Herd Profile"]
[]
["Number of Feeders Purchased",null,null,500,"  head"]
["Feeder Cattle Mortality Rate",null,null,2,"  %"]
["Feeder Purchased Weight",null,null,500,"  lbs"]
["Feeder Cattle Price",null,null,680,"  /cwt"]
["Finish Weight (Maximum 900 lbs.)",null,null,900,"  lbs"]
["Feeder Selling Price (WLPIP insured value)",null,null,455,"  /cwt"]
["$1 Canadian Dollar",null,{"$f":"\"($\"&TEXT(1/D18,\"#.####\")&\" CDN )\"","v":"($1.3699 CDN )"},0.73,"/ $1 USD"]
["WLPIP Insurance Premium",null,null,0,"  /cwt"]
["Percent Shrink at Sale",null,null,3,"  %"]
["Percent Shrink Feeder",null,null,0,"  %",null,"****HIDE****"]
[]
["Average Daily Gain ",null,null,2.5,"  lbs/day",null,null,"",null,{"$f":"'Ration Data'!C2","v":1.5},{"$f":"'Ration Data'!K2","v":2},{"$f":"'Ration Data'!S2","v":2.5}]
["Type of Feed Ration",null,"Corn Silage",null,null,null,null,null,null,"Barley Silage","Corn Silage","Alfalfa Grass Hay"]
[]
[null,null,null,null,null,null,null,"(Analysis Assumed)"]
["Feed Costs","$/unit","lbs/Unit","$/lb","lbs/feeder","$/feeder","TDN","CP"]
["Alfalfa Grass Hay",120,2000,{"$f":"ROUND(B28/C28,3)","v":0.06},{"$f":"IF(Input!$C$24=\"Barley Silage\",'Feed Rations'!I9,IF(Input!$C$24=\"Corn Silage\",'Feed Rations'!I27,'Feed Rations'!I45))","v":800},{"$f":"ROUND(D28*E28,2)","v":48},0.57799999999999996,0.13700000000000001]
["Corn Silage",40,2000,{"$f":"ROUND(B29/C29,3)","v":0.02},{"$f":"IF(Input!$C$24=\"Barley Silage\",'Feed Rations'!I10,IF(Input!$C$24=\"Corn Silage\",'Feed Rations'!I28,'Feed Rations'!I46))","v":3990},{"$f":"ROUND(D29*E29,2)","v":79.8},0.65200000000000002,8.6999999999999994E-2]
["Barley Silage",50,2000,2.5000000000000001E-2,{"$f":"IF(Input!$C$24=\"Barley Silage\",'Feed Rations'!I11,IF(Input!$C$24=\"Corn Silage\",'Feed Rations'!I29,'Feed Rations'!I47))","v":0},0,0.63,0.11]
["Barley Grain",4.5,48,9.4E-2,{"$f":"IF(Input!$C$24=\"Barley Silage\",'Feed Rations'!I12,IF(Input!$C$24=\"Corn Silage\",'Feed Rations'!I30,'Feed Rations'!I48))","v":820},77.08,0.83099999999999996,0.125]
["Greenfeed",115,2000,{"$f":"ROUND(B32/C32,3)","v":5.8000000000000003E-2},{"$f":"IF(Input!$C$24=\"Barley Silage\",'Feed Rations'!I13,IF(Input!$C$24=\"Corn Silage\",'Feed Rations'!I31,'Feed Rations'!I49))","v":0},0]
["Straw",70,2000,{"$f":"ROUND(B33/C33,3)","v":3.5000000000000003E-2},{"$f":"IF(Input!$C$24=\"Barley Silage\",'Feed Rations'!I14,IF(Input!$C$24=\"Corn Silage\",'Feed Rations'!I32,'Feed Rations'!I50))","v":0},0]
["32-20% Feedlot Suppl.",600,2205,0.27200000000000002,{"$f":"IF(Input!$C$24=\"Barley Silage\",'Feed Rations'!I15,IF(Input!$C$24=\"Corn Silage\",'Feed Rations'!I33,'Feed Rations'!I51))","v":0},0,0.61650000000000005,0.35599999999999998]
["DDGS Corn/Wheat",250,2205,0.113,{"$f":"IF(Input!$C$24=\"Barley Silage\",'Feed Rations'!I16,IF(Input!$C$24=\"Corn Silage\",'Feed Rations'!I34,'Feed Rations'!I52))","v":130},14.69,0.77,0.33900000000000002]
["1:1 Premix",50,55,0.90900000000000003,{"$f":"IF(Input!$C$24=\"Barley Silage\",'Feed Rations'!I17,IF(Input!$C$24=\"Corn Silage\",'Feed Rations'!I35,'Feed Rations'!I53))","v":0},0]
["2:1 Premix",50,55,0.90900000000000003,{"$f":"IF(Input!$C$24=\"Barley Silage\",'Feed Rations'!I18,IF(Input!$C$24=\"Corn Silage\",'Feed Rations'!I36,'Feed Rations'!I54))","v":45},40.909999999999997]
["Limestone",20,55,0.36399999999999999,{"$f":"IF(Input!$C$24=\"Barley Silage\",'Feed Rations'!I19,IF(Input!$C$24=\"Corn Silage\",'Feed Rations'!I37,'Feed Rations'!I55))","v":14},5.0999999999999996]
["Other",0,2000,{"$f":"ROUND(B39/C39,3)","v":0},{"$f":"IF(Input!$C$24=\"Barley Silage\",'Feed Rations'!I20,IF(Input!$C$24=\"Corn Silage\",'Feed Rations'!I38,'Feed Rations'!I56))","v":0},0]
[null,null,null,null,null,{"$f":"SUM(F28:F39)","v":265.58000000000004}]
["FOOTNOTE:  1 bushel (bu) barley = 48 lbs = 21.8 kg"]
["                         1 kilogram (kg) = 2.2046 pounds (lbs)"]
["                         1 tonne (t) = 1,000 kg",null,null,null,null,null,null,""]
[null,null,null,"Feed Cost"]
["Weight Range","Days on Feed",null,"$/Steer/Day"]
["500 to 600 lbs.",{"$f":"ROUND(IF(SUM((600-D14))<=0,0,IF(D16<=600,SUM((D16-D14)/D23),SUM(600-D14)/D23)),0)","v":40},null,{"$f":"IF(B46>0,IF(Input!$C$24=\"Barley Silage\",'Feed Rations'!E$21,IF(Input!$C$24=\"Corn Silage\",'Feed Rations'!E$39,'Feed Rations'!E$57)),0)","v":1.41991}]
["600 to 700 lbs.",{"$f":"ROUND(IF(D16<600,0,IF(SUM(700-D14)<=0,0,IF(D14>=600,IF(D16>=700,SUM((700-D14)/D23),SUM(D16-D14)/D23),IF(D16>=700,SUM(100/D23),SUM(D16-600)/D23)))),0)","v":40},null,{"$f":"IF(B47>0,IF(Input!$C$24=\"Barley Silage\",'Feed Rations'!F$21,IF(Input!$C$24=\"Corn Silage\",'Feed Rations'!F$39,'Feed Rations'!F$57)),0)","v":1.6102799999999999}]
["700 to 800 lbs.",{"$f":"ROUND(IF(D16<700,0,IF(SUM(800-D14)<=0,0,IF(D14>=700,IF(D16>=800,SUM((800-D14)/D23),SUM(D16-D14)/D23),IF(D16>=800,SUM(100/D23),SUM(D16-700)/D23)))),0)","v":40},null,{"$f":"IF(B48>0,IF(Input!$C$24=\"Barley Silage\",'Feed Rations'!G$21,IF(Input!$C$24=\"Corn Silage\",'Feed Rations'!G$39,'Feed Rations'!G$57)),0)","v":1.7335750000000003}]
["800 to 900 lbs.",{"$f":"ROUND(IF(D16<800,0,IF(D14>=800,IF(D16>=900,SUM((900-D14)/D23),SUM(D16-D14)/D23),IF(D16>=900,SUM(100/D23),SUM(D16-800)/D23))),0)","v":40},null,{"$f":"IF(B49>0,IF(Input!$C$24=\"Barley Silage\",'Feed Rations'!H$21,IF(Input!$C$24=\"Corn Silage\",'Feed Rations'!H$39,'Feed Rations'!H$57)),0)","v":1.880055}]
["TOTAL",{"$f":"SUM(B46:B49,0)","v":160}]
[]
["Total Feed Cost per Steer",null,null,{"$f":"IF(B50>0,IF(Input!$C$24=\"Barley Silage\",'Feed Rations'!J21,IF(Input!$C$24=\"Corn Silage\",'Feed Rations'!J39,'Feed Rations'!J57)),0)","v":265.57100000000003},"/feeder"]
["Average Feed Cost per Day",null,null,{"$f":"SUM(D52/B50)","v":1.6598187500000001}]
["Feed Cost per lb. of Gain Sold (shrunk weight)",null,null,{"$f":"(D52/ROUND((Input!$D$16-(Input!$D$16*Input!$D$20/100))-(Input!$D$14-(Input!$D$14*Input!$D$21/100)),0))","v":0.71198659517426277}]
[]
["Total Pounds of Gain",null,null,{"$f":"ROUND(D16-D14,0)","v":400},"  lbs"]
["Total Pounds of Gain (Shrunk Weight)",null,null,{"$f":"ROUND((Input!$D$16-(Input!$D$16*Input!$D$20/100))-(Input!$D$14-(Input!$D$14*Input!$D$21/100)),0)","v":373},"  lbs"]
[null,null,null,null,null,null,null,""]
["Other Operating Costs",null,null,null,null,null,""]
["  Feeder Purchase Costs"]
["    Feeder",null,null,{"$f":"D14","v":500},"lbs/feeder"]
[null,null,"x",{"$f":"D15","v":680},"/cwt"]
[null,null,"÷",100,"lbs/cwt",null,""]
[null,null,"=",{"$f":"ROUND(D61/100*D62,2)","v":3400},"/feeder"]
["     Buying Commission",null,"+",5,"/feeder"]
["     Insurance fee ",null,"+",1.75,"/feeder"]
["     Trucking-in ",null,null,1.7,"/cwt"]
[null,null,"x",{"$f":"D14","v":500},"lbs/feeder"]
[null,null,"÷",100,"lbs/cwt",null,null,""]
[null,null,"=",{"$f":"ROUND(D67*D68/D69,2)","v":8.5},"/feeder"]
[null,"    Total","=",{"$f":"ROUND(D70+D66+D65+D64,2)","v":3415.25},"/feeder"]
[null,null,"","",null,null,""]
["  Straw Bedding",null,"=",4,"lbs/feeder/day"]
[null,null,"x",{"$f":"Input!B50","v":160},"days on feed"]
[null,null,"x",70,"/ton"]
[null,null,"=",{"$f":"ROUND((D73*D74)*(D75/2000),2)","v":22.4},"/feeder"]
["  Veterinary Medicine & Supplies",null,null,"","",null,""]
["   Cattle Medication",null,"","",null,null,""]
["     IBR,BVD,PI3,BRSV, Pasteurella",null,null,5,"/feeder"]
["     Vitamin A-D",null,"+",0.5,"/feeder"]
["     External & Internal Parasites",null,"+",0.72,"/feeder"]
["     Blackleg & Haemophilus",null,"+",1.26,"/feeder"]
["     Growth Implants",null,"+",2,"/feeder"]
["     Antibiotics",null,"+",15,"/feeder"]
[null,null,"=",{"$f":"SUM(D79:D84)","v":24.48},"/feeder"]
["   Herd Health Program",null,"","",""]
["     Professional Services",null,null,240,"/hour charge"]
[null,null,"x",3,"Total Yearly Hours"]
[null,null,"÷",{"$f":"Input!D12","v":500},"feeder cattle"]
[null,null,"=",{"$f":"ROUND(D87*D88/D89,2)","v":1.44},"/feeder "]
[null,null,null,""]
["     Transportation",null,null,1,"Rate/km charge"]
[null,null,"x",80,"Total Kilometres (round trip)"]
[null,null,"x",2,"Number of Yearly Visits"]
[null,null,"÷",{"$f":"Input!D12","v":500},"feeder cattle"]
[null,null,"=",{"$f":"ROUND(D92*D93*D94/D95,2)","v":0.32},"/feeder "]
[null,"    Total","=",{"$f":"ROUND(D96+D90+D85,2)","v":26.24},"/feeder"]
[]
["Fuel, Oil, Repairs & Maintenance"]
[" Machinery Fuel Cost"]
["  Tractor with Loader PTO hp",null,null,120]
["  Average HP required",null,"÷",2.5]
["  Litres fuel / Hour / HP",null,"x",0.1665576]
["  Tractor Hours Per Day (avg)",null,"x",1.5]
["  Diesel Fuel Cost / litre",null,"x",1.2]
["  Days on feed",null,"x",{"$f":"B50","v":160}]
["  Annual fuel cost",null,null,{"$f":"IF(D106=\"ERROR\",\"ERROR\",ROUND(((D101/D102)*D103*D104*D105*D106),2))","v":2302.4899999999998}]
[null,null,"÷",{"$f":"D12","v":500},"feeders"]
[null,"    Total","=",{"$f":"IF(D106=\"ERROR\",\"ERROR\",SUM(D107/D108))","v":4.6049799999999994},"/feeder"]
[" Machinery repair & maintenance"]
["  Machinery capital cost",null,null,{"$f":"SUM(Fixed!J24:J39)","v":112500}]
["  Machinery Repair (% of investment cost)",null,"x",1.2,"%"]
["  Oil, repairs & maintenance",null,"=",{"$f":"SUM(D111*(D112/100))","v":1350}]
[null,null,"÷",{"$f":"D12","v":500},"feeders"]
["","    Total","=",{"$f":"SUM(D113/D114)","v":2.7},"/feeder",null,""]
[" Building repair & maintenance"]
["  Building capital cost",null,null,{"$f":"SUM(Fixed!E24:E39)-Fixed!E33","v":62600}]
["  Building  maintenance (% of inv.cost)",null,"x",2.2000000000000002]
["  Repairs & maintenance",null,"=",{"$f":"SUM(D117*(D118/100))","v":1377.2}]
[null,null,"÷",{"$f":"D12","v":500},"feeders"]
[null,"    Total","=",{"$f":"SUM(D119/D120)","v":2.7544},"/feeder"]
["  Utilities",null,null,null,""]
["          Hydro - Rate",null,null,9.5869999999999997E-2,"/ kWh"]
[12,"kWh per feeder",null,{"$f":"SUM(A124*D12*D123)","v":575.22}]
[2,"1000 watt waterer",null,{"$f":"SUM(A125*18)*(B50)*D123","v":552.21119999999996}]
[null,null,"Total Hydro",{"$f":"SUM(D124:D125)","v":1127.4312}]
["          Telephone",null,null,600]
[null,null,"÷",{"$f":"D12","v":500},"feeders"]
[null,"    Total","=",{"$f":"SUM(D126+D127)/D128","v":3.4548624000000001},"/feeder"]
[]
["Feeder Selling Cost",null,null,null,""]
["   Trucking Cost"]
[null,"    Trucking Distance",null,75,"miles"]
[null,"     Rate",null,7,"/loaded mile"]
[null,null,null,{"$f":"Input!D12-((Input!D13/100)*Input!D12)","v":490},"feeders"]
[null,"     Average Weight",null,{"$f":"D16","v":900},"lbs/head"]
[null,"     Truck Capacity",null,54000,"lbs/load"]
[null,"     Number of head",null,{"$f":"D137/D136","v":60},"per load"]
[null,null,"=",{"$f":"ROUNDUP((D135)/D138,0)","v":9},"loads"]
[null,null,"÷",{"$f":"Input!D12","v":500},"feeders"]
[null,null,"=",{"$f":"SUM(D139*D134*D133)/D140","v":9.4499999999999993},"/feeder"]
[]
["  Marketing Cost"]
[null,"MBP/NCO Levy ",null,5.5,"/feeder"]
[null,"LPI Insurance Premium",null,{"$f":"Input!D19*Breakeven!F30/100","v":0},"/feeder"]
[null,"Commission on Sales",null,22,"/feeder"]
[null,null,null,{"$f":"D144+D145+D146","v":27.5},"/feeder"]
[null,"    Total","=",{"$f":"SUM(D141+D147)","v":36.950000000000003},"/feeder"]
["  Manure Removal"]
[null,"Days on Feed","=",{"$f":"B50","v":160},"days"]
[null,"   Manure volume produced","x",2.4E-2,"m3/feeder/day"]
[null,null,"=",{"$f":"IF(D150=\"ERROR\",\"ERROR\",SUM(D150*D151))","v":3.84},"m3 manure volume"]
[null,"   Manure volume shrinkage","x",75,"% volume shrink"]
[null,null,"x",1.3079499999999999,"yd3 per m3"]
[null,"   Cost for manure removal & application","x",15,"yd3 manure removal cost"]
[null,"    Total","=",{"$f":"IF(D150=\"ERROR\",\"ERROR\",SUM(D152*(1-(D153/100))*D154*D155))","v":18.834479999999999},"/feeder"]
[]
["  Insurance"]
["     Building & Equipment Capital Invested",null,"=",{"$f":"Fixed!D19","v":192600}]
["     Insurance Cost per $100",null,"x",0.4,"$/$100"]
[null,null,"÷",100]
[null,null,"÷",{"$f":"Input!D12","v":500},"feeder cattle"]
[null,null,"=",{"$f":"ROUND(D159*D160/D161/D162,2)","v":1.54},"/feeder"]
[]
["    Livestock Capital Invested",null,"=",{"$f":"ROUND((((Input!D14*Input!D15/100)+(Input!D16*Input!D17/100))/2)*Input!D12,2)","v":1873750},"herd investment"]
["     Insurance Cost per $100",null,"x",0,"$/$100"]
[null,null,"÷",100]
[null,null,"÷",{"$f":"Input!D12","v":500},"feeder cattle"]
[null,null,"=",{"$f":"ROUND(D165*D166/D167/D168,2)","v":0},"/feeder"]
[]
["     Additional Coverage for Liability",null,null,49]
[null,null,"÷",{"$f":"Input!D12","v":500},"feeder cattle"]
[null,null,"=",{"$f":"D171/D172","v":9.8000000000000004E-2},"/feeder"]
[null,"Total","=",{"$f":"ROUND(D163+D169+D173,2)","v":1.64},"/feeder"]
[]
["  Barn & Office Supplies"]
["     Total yearly expense relating to barn",null,null,600]
[null,null,"÷",{"$f":"Input!D12","v":500},"feeder cattle"]
[null,"Total","=",{"$f":"D177/D178","v":1.2},"/feeder"]
[null,null,null,null,null,null,null,""]
["    Death Loss"]
[null,null,null,{"$f":"D71","v":3415.25},"feeder cattle cost"]
[null,null,"+",{"$f":"SUM(Summary!F18:F28)","v":3801.6087223999994},"maximum value"]
[null,null,"-",{"$f":"Summary!F25","v":36.950000000000003},"selling costs"]
[null,null,"÷",2,"average"]
[null,null,"x",{"$f":"D13","v":2},"% mortality rate"]
[null,"Total","=",{"$f":"ROUND(((D182+(D183-D184))/D185)*D186/100,2)","v":71.8},"/feeder"]
[]
["  Operating Interest"]
["     (Operating interest is charged on one half the subtotal operating costs)"]
[null,null,null,{"$f":"D71","v":3415.25},"feeder cost"]
[null,null,"+",{"$f":"(Summary!F18+SUM(Summary!F21:F29))/2","v":229.07936120000002},"½ of feed & other costs"]
[null,null,"x",6.75,"% operating interest"]
[null,null,"x",{"$f":"B50","v":160},"days on feed"]
[null,null,"÷",365,"days /year"]
[null,null,"=",{"$f":"ROUND(((D191+D192)*(D193)*(D194/D195/100)),2)","v":107.83},"/feeder"]
[null,null,null,null,null,""]
["FOOTNOTE:  cwt = hundred-weight = 100 lbs",null,null,null,null,null,null,""]
[]
["Labour Costs"]
["  Hours/Head",null,null,1,"hours/feeder/year"]
["  Labour Rate",null,"x",28,"/hour "]
[null,null,"=",{"$f":"ROUND(D201*D202,2)","v":28},"/feeder"]

{"sheet":"Feed Rations","index":5,"n_rows":66,"n_cols":12,"rows_kept":66,"cut":false,"hidden":false,"merged":[[2,0,2,11],[0,0,0,11],[5,10,7,10],[5,11,7,11],[41,8,43,8],[41,9,43,9],[4,0,4,11],[23,11,25,11],[65,0,66,11],[58,0,58,11],[59,9,59,11],[59,3,59,4],[5,8,7,8],[5,9,7,9],[40,0,40,11],[23,9,25,9],[25,4,25,7],[43,4,43,7],[7,4,7,7],[23,8,25,8],[41,10,43,10],[41,11,43,11],[22,0,22,11],[23,10,25,10]]}
["Feed Costs & Requirements Worksheet"]
[]
[{"$f":"\"Total Days on Feed = \"&Input!B50&\" days @ \"&Input!D23&\" lbs. Average Daily Gain (ADG) Per Day\"","v":"Total Days on Feed = 160 days @ 2.5 lbs. Average Daily Gain (ADG) Per Day"}]
[]
["Barley Silage Ration"]
["Weight Range (lbs)",null,null,null,"500 to 600","600 to 700","700-800","800-900","Total lbs /steer","Feed Cost $/steer",{"$f":"\"Total Units Required\n(\"&Input!D12&\" steers)\"","v":"Total Units Required\n(500 steers)"},{"$f":"\"Total Feed Cost\n(\"&Input!D12&\" steers)\"","v":"Total Feed Cost\n(500 steers)"}]
["Days on Feed",null,null,null,{"$f":"Input!B46","v":40},{"$f":"Input!B47","v":40},{"$f":"Input!B48","v":40},{"$f":"Input!B49","v":40}]
["Feed Name","$/unit","lbs/Unit","$/lb","As Fed Lbs/Head/Day"]
[{"$f":"Input!A28","v":"Alfalfa Grass Hay"},{"$f":"Input!B28","v":120},{"$f":"Input!C28","v":2000},{"$f":"Input!D28","v":0.06},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!B7,IF(Input!$D$23=2,'Ration Data'!J7,'Ration Data'!R7))","v":3},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!C7,IF(Input!$D$23=2,'Ration Data'!K7,'Ration Data'!S7))","v":3},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!D7,IF(Input!$D$23=2,'Ration Data'!L7,'Ration Data'!T7))","v":2.5},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!E7,IF(Input!$D$23=2,'Ration Data'!M7,'Ration Data'!U7))","v":2},{"$f":"ROUND(($E$7*E9)+($F$7*F9)+($G$7*G9)+($H$7*H9),0)","v":420},{"$f":"SUM(I9*D9)","v":25.2},{"$f":"ROUNDUP((I9*Input!$D$12)/C9,0)","v":105},{"$f":"SUM(K9*B9)","v":12600}]
[{"$f":"Input!A29","v":"Corn Silage"},{"$f":"Input!B29","v":40},{"$f":"Input!C29","v":2000},{"$f":"Input!D29","v":0.02},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!B8,IF(Input!$D$23=2,'Ration Data'!J8,'Ration Data'!R8))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!C8,IF(Input!$D$23=2,'Ration Data'!K8,'Ration Data'!S8))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!D8,IF(Input!$D$23=2,'Ration Data'!L8,'Ration Data'!T8))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!E8,IF(Input!$D$23=2,'Ration Data'!M8,'Ration Data'!U8))","v":0},{"$f":"ROUND(($E$7*E10)+($F$7*F10)+($G$7*G10)+($H$7*H10),0)","v":0},{"$f":"SUM(I10*D10)","v":0},{"$f":"ROUNDUP((I10*Input!$D$12)/C10,0)","v":0},{"$f":"SUM(K10*B10)","v":0}]
[{"$f":"Input!A30","v":"Barley Silage"},{"$f":"Input!B30","v":50},{"$f":"Input!C30","v":2000},{"$f":"Input!D30","v":2.5000000000000001E-2},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!B9,IF(Input!$D$23=2,'Ration Data'!J9,'Ration Data'!R9))","v":23},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!C9,IF(Input!$D$23=2,'Ration Data'!K9,'Ration Data'!S9))","v":25.75},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!D9,IF(Input!$D$23=2,'Ration Data'!L9,'Ration Data'!T9))","v":29.25},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!E9,IF(Input!$D$23=2,'Ration Data'!M9,'Ration Data'!U9))","v":32.5},4420,110.5,{"$f":"ROUNDUP((I11*Input!$D$12)/C11,0)","v":1105},55250]
[{"$f":"Input!A31","v":"Barley Grain"},{"$f":"Input!B31","v":4.5},{"$f":"Input!C31","v":48},{"$f":"Input!D31","v":9.4E-2},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!B10,IF(Input!$D$23=2,'Ration Data'!J10,'Ration Data'!R10))","v":5},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!C10,IF(Input!$D$23=2,'Ration Data'!K10,'Ration Data'!S10))","v":6},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!D10,IF(Input!$D$23=2,'Ration Data'!L10,'Ration Data'!T10))","v":7},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!E10,IF(Input!$D$23=2,'Ration Data'!M10,'Ration Data'!U10))","v":8},1040,97.76,{"$f":"ROUNDUP((I12*Input!$D$12)/C12,0)","v":10834},48753]
[{"$f":"Input!A32","v":"Greenfeed"},{"$f":"Input!B32","v":115},{"$f":"Input!C32","v":2000},{"$f":"Input!D32","v":5.8000000000000003E-2},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!B11,IF(Input!$D$23=2,'Ration Data'!J11,'Ration Data'!R11))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!C11,IF(Input!$D$23=2,'Ration Data'!K11,'Ration Data'!S11))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!D11,IF(Input!$D$23=2,'Ration Data'!L11,'Ration Data'!T11))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!E11,IF(Input!$D$23=2,'Ration Data'!M11,'Ration Data'!U11))","v":0},{"$f":"ROUND(($E$7*E13)+($F$7*F13)+($G$7*G13)+($H$7*H13),0)","v":0},{"$f":"SUM(I13*D13)","v":0},{"$f":"ROUNDUP((I13*Input!$D$12)/C13,0)","v":0},{"$f":"SUM(K13*B13)","v":0}]
[{"$f":"Input!A33","v":"Straw"},{"$f":"Input!B33","v":70},{"$f":"Input!C33","v":2000},{"$f":"Input!D33","v":3.5000000000000003E-2},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!B12,IF(Input!$D$23=2,'Ration Data'!J12,'Ration Data'!R12))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!C12,IF(Input!$D$23=2,'Ration Data'!K12,'Ration Data'!S12))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!D12,IF(Input!$D$23=2,'Ration Data'!L12,'Ration Data'!T12))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!E12,IF(Input!$D$23=2,'Ration Data'!M12,'Ration Data'!U12))","v":0},{"$f":"ROUND(($E$7*E14)+($F$7*F14)+($G$7*G14)+($H$7*H14),0)","v":0},{"$f":"SUM(I14*D14)","v":0},{"$f":"ROUNDUP((I14*Input!$D$12)/C14,0)","v":0},{"$f":"SUM(K14*B14)","v":0}]
[{"$f":"Input!A34","v":"32-20% Feedlot Suppl."},{"$f":"Input!B34","v":600},{"$f":"Input!C34","v":2205},{"$f":"Input!D34","v":0.27200000000000002},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!B13,IF(Input!$D$23=2,'Ration Data'!J13,'Ration Data'!R13))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!C13,IF(Input!$D$23=2,'Ration Data'!K13,'Ration Data'!S13))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!D13,IF(Input!$D$23=2,'Ration Data'!L13,'Ration Data'!T13))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!E13,IF(Input!$D$23=2,'Ration Data'!M13,'Ration Data'!U13))","v":0},0,0,{"$f":"ROUNDUP((I15*Input!$D$12)/C15,0)","v":0},0]
[{"$f":"Input!A35","v":"DDGS Corn/Wheat"},{"$f":"Input!B35","v":250},{"$f":"Input!C35","v":2205},{"$f":"Input!D35","v":0.113},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!B14,IF(Input!$D$23=2,'Ration Data'!J14,'Ration Data'!R14))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!C14,IF(Input!$D$23=2,'Ration Data'!K14,'Ration Data'!S14))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!D14,IF(Input!$D$23=2,'Ration Data'!L14,'Ration Data'!T14))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!E14,IF(Input!$D$23=2,'Ration Data'!M14,'Ration Data'!U14))","v":0},0,0,{"$f":"ROUNDUP((I16*Input!$D$12)/C16,0)","v":0},0]
[{"$f":"Input!A36","v":"1:1 Premix"},{"$f":"Input!B36","v":50},{"$f":"Input!C36","v":55},{"$f":"Input!D36","v":0.90900000000000003},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!B15,IF(Input!$D$23=2,'Ration Data'!J15,'Ration Data'!R15))","v":0.25},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!C15,IF(Input!$D$23=2,'Ration Data'!K15,'Ration Data'!S15))","v":0.27},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!D15,IF(Input!$D$23=2,'Ration Data'!L15,'Ration Data'!T15))","v":0.3},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!E15,IF(Input!$D$23=2,'Ration Data'!M15,'Ration Data'!U15))","v":0.32},46,41.814,{"$f":"ROUNDUP((I17*Input!$D$12)/C17,0)","v":419},20950]
[{"$f":"Input!A37","v":"2:1 Premix"},{"$f":"Input!B37","v":50},{"$f":"Input!C37","v":55},{"$f":"Input!D37","v":0.90900000000000003},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!B16,IF(Input!$D$23=2,'Ration Data'!J16,'Ration Data'!R16))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!C16,IF(Input!$D$23=2,'Ration Data'!K16,'Ration Data'!S16))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!D16,IF(Input!$D$23=2,'Ration Data'!L16,'Ration Data'!T16))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!E16,IF(Input!$D$23=2,'Ration Data'!M16,'Ration Data'!U16))","v":0},0,0,{"$f":"ROUNDUP((I18*Input!$D$12)/C18,0)","v":0},0]
[{"$f":"Input!A38","v":"Limestone"},{"$f":"Input!B38","v":20},{"$f":"Input!C38","v":55},{"$f":"Input!D38","v":0.36399999999999999},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!B17,IF(Input!$D$23=2,'Ration Data'!J17,'Ration Data'!R17))","v":0.06},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!C17,IF(Input!$D$23=2,'Ration Data'!K17,'Ration Data'!S17))","v":8.5000000000000006E-2},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!D17,IF(Input!$D$23=2,'Ration Data'!L17,'Ration Data'!T17))","v":0.11},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!E17,IF(Input!$D$23=2,'Ration Data'!M17,'Ration Data'!U17))","v":0.13},15,5.46,{"$f":"ROUNDUP((I19*Input!$D$12)/C19,0)","v":137},2740]
[{"$f":"Input!A39","v":"Other"},{"$f":"Input!B39","v":0},{"$f":"Input!C39","v":2000},{"$f":"Input!D39","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!B18,IF(Input!$D$23=2,'Ration Data'!J18,'Ration Data'!R18))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!C18,IF(Input!$D$23=2,'Ration Data'!K18,'Ration Data'!S18))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!D18,IF(Input!$D$23=2,'Ration Data'!L18,'Ration Data'!T18))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!E18,IF(Input!$D$23=2,'Ration Data'!M18,'Ration Data'!U18))","v":0},{"$f":"ROUND(($E$7*E20)+($F$7*F20)+($G$7*G20)+($H$7*H20),0)","v":0},{"$f":"SUM(I20*D20)","v":0},{"$f":"ROUNDUP((I20*Input!$D$12)/C20,0)","v":0},{"$f":"SUM(K20*B20)","v":0}]
[null,null,null,"$/head/day",{"$f":"IF(Input!$D$23=1.5,'Ration Data'!B19,IF(Input!$D$23=2,'Ration Data'!J19,'Ration Data'!R19))","v":1.4740900000000001},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!C19,IF(Input!$D$23=2,'Ration Data'!K19,'Ration Data'!S19))","v":1.66412},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!D19,IF(Input!$D$23=2,'Ration Data'!L19,'Ration Data'!T19))","v":1.85199},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!E19,IF(Input!$D$23=2,'Ration Data'!M19,'Ration Data'!U19))","v":2.0226999999999999},null,{"$f":"SUM(J9:J20)","v":280.73399999999998},null,{"$f":"SUM(L9:L20)","v":140293}]
[]
["Corn Silage Ration"]
["Weight Range (lbs)",null,null,null,"500 to 600","600 to 700","700-800","800-900","Total lbs /steer","Feed Cost $/steer",{"$f":"\"Total Units Required\n(\"&Input!D12&\" steers)\"","v":"Total Units Required\n(500 steers)"},{"$f":"\"Total Feed Cost\n(\"&Input!D12&\" steers)\"","v":"Total Feed Cost\n(500 steers)"}]
["Days on Feed",null,null,null,{"$f":"E7","v":40},{"$f":"F7","v":40},{"$f":"G7","v":40},{"$f":"H7","v":40}]
["Feed Name","$/unit","lbs/Unit","$/lb","As Fed Lbs/Head/Day"]
[{"$f":"A45","v":"Alfalfa Grass Hay"},{"$f":"B9","v":120},2000,0.06,{"$f":"IF(Input!$D$23=1.5,'Ration Data'!B24,IF(Input!$D$23=2,'Ration Data'!J24,'Ration Data'!R24))","v":5},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!C24,IF(Input!$D$23=2,'Ration Data'!K24,'Ration Data'!S24))","v":5},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!D24,IF(Input!$D$23=2,'Ration Data'!L24,'Ration Data'!T24))","v":5},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!E24,IF(Input!$D$23=2,'Ration Data'!M24,'Ration Data'!U24))","v":5},{"$f":"ROUND(($E$25*E27)+($F$25*F27)+($G$25*G27)+($H$25*H27),0)","v":800},{"$f":"SUM(I27*D27)","v":48},{"$f":"ROUNDUP((I27*Input!$D$12)/C27,0)","v":200},{"$f":"SUM(K27*B27)","v":24000}]
[{"$f":"Input!A29","v":"Corn Silage"},40,2000,0.02,{"$f":"IF(Input!$D$23=1.5,'Ration Data'!B25,IF(Input!$D$23=2,'Ration Data'!J25,'Ration Data'!R25))","v":19},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!C25,IF(Input!$D$23=2,'Ration Data'!K25,'Ration Data'!S25))","v":22},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!D25,IF(Input!$D$23=2,'Ration Data'!L25,'Ration Data'!T25))","v":27},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!E25,IF(Input!$D$23=2,'Ration Data'!M25,'Ration Data'!U25))","v":31.75},{"$f":"ROUND(($E$25*E28)+($F$25*F28)+($G$25*G28)+($H$25*H28),0)","v":3990},{"$f":"SUM(I28*D28)","v":79.8},{"$f":"ROUNDUP((I28*Input!$D$12)/C28,0)","v":998},{"$f":"SUM(K28*B28)","v":39920}]
[{"$f":"Input!A30","v":"Barley Silage"},50,2000,2.5000000000000001E-2,{"$f":"IF(Input!$D$23=1.5,'Ration Data'!B26,IF(Input!$D$23=2,'Ration Data'!J26,'Ration Data'!R26))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!C26,IF(Input!$D$23=2,'Ration Data'!K26,'Ration Data'!S26))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!D26,IF(Input!$D$23=2,'Ration Data'!L26,'Ration Data'!T26))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!E26,IF(Input!$D$23=2,'Ration Data'!M26,'Ration Data'!U26))","v":0},0,0,{"$f":"ROUNDUP((I29*Input!$D$12)/C29,0)","v":0},0]
[{"$f":"Input!A31","v":"Barley Grain"},4.5,48,9.4E-2,{"$f":"IF(Input!$D$23=1.5,'Ration Data'!B27,IF(Input!$D$23=2,'Ration Data'!J27,'Ration Data'!R27))","v":4},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!C27,IF(Input!$D$23=2,'Ration Data'!K27,'Ration Data'!S27))","v":5},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!D27,IF(Input!$D$23=2,'Ration Data'!L27,'Ration Data'!T27))","v":5.5},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!E27,IF(Input!$D$23=2,'Ration Data'!M27,'Ration Data'!U27))","v":6},820,77.08,{"$f":"ROUNDUP((I30*Input!$D$12)/C30,0)","v":8542},38439]
[{"$f":"Input!A32","v":"Greenfeed"},115,2000,5.8000000000000003E-2,{"$f":"IF(Input!$D$23=1.5,'Ration Data'!B28,IF(Input!$D$23=2,'Ration Data'!J28,'Ration Data'!R28))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!C28,IF(Input!$D$23=2,'Ration Data'!K28,'Ration Data'!S28))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!D28,IF(Input!$D$23=2,'Ration Data'!L28,'Ration Data'!T28))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!E28,IF(Input!$D$23=2,'Ration Data'!M28,'Ration Data'!U28))","v":0},{"$f":"ROUND(($E$25*E31)+($F$25*F31)+($G$25*G31)+($H$25*H31),0)","v":0},{"$f":"SUM(I31*D31)","v":0},{"$f":"ROUNDUP((I31*Input!$D$12)/C31,0)","v":0},{"$f":"SUM(K31*B31)","v":0}]
[{"$f":"Input!A33","v":"Straw"},70,2000,3.5000000000000003E-2,{"$f":"IF(Input!$D$23=1.5,'Ration Data'!B29,IF(Input!$D$23=2,'Ration Data'!J29,'Ration Data'!R29))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!C29,IF(Input!$D$23=2,'Ration Data'!K29,'Ration Data'!S29))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!D29,IF(Input!$D$23=2,'Ration Data'!L29,'Ration Data'!T29))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!E29,IF(Input!$D$23=2,'Ration Data'!M29,'Ration Data'!U29))","v":0},{"$f":"ROUND(($E$25*E32)+($F$25*F32)+($G$25*G32)+($H$25*H32),0)","v":0},{"$f":"SUM(I32*D32)","v":0},{"$f":"ROUNDUP((I32*Input!$D$12)/C32,0)","v":0},{"$f":"SUM(K32*B32)","v":0}]
[{"$f":"Input!A34","v":"32-20% Feedlot Suppl."},{"$f":"B15","v":600},2205,0.27200000000000002,{"$f":"IF(Input!$D$23=1.5,'Ration Data'!B30,IF(Input!$D$23=2,'Ration Data'!J30,'Ration Data'!R30))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!C30,IF(Input!$D$23=2,'Ration Data'!K30,'Ration Data'!S30))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!D30,IF(Input!$D$23=2,'Ration Data'!L30,'Ration Data'!T30))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!E30,IF(Input!$D$23=2,'Ration Data'!M30,'Ration Data'!U30))","v":0},0,0,{"$f":"ROUNDUP((I33*Input!$D$12)/C33,0)","v":0},0]
[{"$f":"Input!A35","v":"DDGS Corn/Wheat"},250,2205,0.113,{"$f":"IF(Input!$D$23=1.5,'Ration Data'!B31,IF(Input!$D$23=2,'Ration Data'!J31,'Ration Data'!R31))","v":1},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!C31,IF(Input!$D$23=2,'Ration Data'!K31,'Ration Data'!S31))","v":1},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!D31,IF(Input!$D$23=2,'Ration Data'!L31,'Ration Data'!T31))","v":0.75},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!E31,IF(Input!$D$23=2,'Ration Data'!M31,'Ration Data'!U31))","v":0.5},130,14.690000000000001,{"$f":"ROUNDUP((I34*Input!$D$12)/C34,0)","v":30},7500]
[{"$f":"Input!A36","v":"1:1 Premix"},50,55,0.90900000000000003,{"$f":"IF(Input!$D$23=1.5,'Ration Data'!B32,IF(Input!$D$23=2,'Ration Data'!J32,'Ration Data'!R32))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!C32,IF(Input!$D$23=2,'Ration Data'!K32,'Ration Data'!S32))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!D32,IF(Input!$D$23=2,'Ration Data'!L32,'Ration Data'!T32))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!E32,IF(Input!$D$23=2,'Ration Data'!M32,'Ration Data'!U32))","v":0},0,0,{"$f":"ROUNDUP((I35*Input!$D$12)/C35,0)","v":0},0]
[{"$f":"Input!A37","v":"2:1 Premix"},50,55,0.90900000000000003,{"$f":"IF(Input!$D$23=1.5,'Ration Data'!B33,IF(Input!$D$23=2,'Ration Data'!J33,'Ration Data'!R33))","v":0.25},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!C33,IF(Input!$D$23=2,'Ration Data'!K33,'Ration Data'!S33))","v":0.28000000000000003},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!D33,IF(Input!$D$23=2,'Ration Data'!L33,'Ration Data'!T33))","v":0.28499999999999998},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!E33,IF(Input!$D$23=2,'Ration Data'!M33,'Ration Data'!U33))","v":0.315},45,40.905000000000001,{"$f":"ROUNDUP((I36*Input!$D$12)/C36,0)","v":410},20500]
[{"$f":"Input!A38","v":"Limestone"},20,55,0.36399999999999999,{"$f":"IF(Input!$D$23=1.5,'Ration Data'!B34,IF(Input!$D$23=2,'Ration Data'!J34,'Ration Data'!R34))","v":6.5000000000000002E-2},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!C34,IF(Input!$D$23=2,'Ration Data'!K34,'Ration Data'!S34))","v":0.09},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!D34,IF(Input!$D$23=2,'Ration Data'!L34,'Ration Data'!T34))","v":0.09},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!E34,IF(Input!$D$23=2,'Ration Data'!M34,'Ration Data'!U34))","v":0.105},14,5.0960000000000001,{"$f":"ROUNDUP((I37*Input!$D$12)/C37,0)","v":128},2560]
[{"$f":"Input!A39","v":"Other"},0,2000,0,{"$f":"IF(Input!$D$23=1.5,'Ration Data'!B35,IF(Input!$D$23=2,'Ration Data'!J35,'Ration Data'!R35))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!C35,IF(Input!$D$23=2,'Ration Data'!K35,'Ration Data'!S35))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!D35,IF(Input!$D$23=2,'Ration Data'!L35,'Ration Data'!T35))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!E35,IF(Input!$D$23=2,'Ration Data'!M35,'Ration Data'!U35))","v":0},{"$f":"ROUND(($E$25*E38)+($F$25*F38)+($G$25*G38)+($H$25*H38),0)","v":0},{"$f":"SUM(I38*D38)","v":0},{"$f":"ROUNDUP((I38*Input!$D$12)/C38,0)","v":0},{"$f":"SUM(K38*B38)","v":0}]
[null,null,null,"$/head/day",{"$f":"IF(Input!$D$23=1.5,'Ration Data'!B36,IF(Input!$D$23=2,'Ration Data'!J36,'Ration Data'!R36))","v":1.41991},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!C36,IF(Input!$D$23=2,'Ration Data'!K36,'Ration Data'!S36))","v":1.6102799999999999},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!D36,IF(Input!$D$23=2,'Ration Data'!L36,'Ration Data'!T36))","v":1.7335750000000003},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!E36,IF(Input!$D$23=2,'Ration Data'!M36,'Ration Data'!U36))","v":1.880055},null,{"$f":"SUM(J27:J38)","v":265.57100000000003},null,{"$f":"SUM(L27:L38)","v":132919}]
[]
["Alfalfa Grass Hay Ration"]
["Weight Range (lbs)",null,null,null,"500 to 600","600 to 700","700-800","800-900","Total lbs /steer","Feed Cost $/steer",{"$f":"\"Total Units Required\n(\"&Input!D12&\" steers)\"","v":"Total Units Required\n(500 steers)"},{"$f":"\"Total Feed Cost\n(\"&Input!D12&\" steers)\"","v":"Total Feed Cost\n(500 steers)"}]
["Days on Feed",null,null,null,{"$f":"E7","v":40},{"$f":"F7","v":40},{"$f":"G7","v":40},{"$f":"H7","v":40}]
["Feed Name","$/unit","lbs/Unit","$/lb","As Fed Lbs/Head/Day"]
[{"$f":"Input!A28","v":"Alfalfa Grass Hay"},{"$f":"B9","v":120},2000,0.06,{"$f":"IF(Input!$D$23=1.5,'Ration Data'!B41,IF(Input!$D$23=2,'Ration Data'!J41,'Ration Data'!R41))","v":11.25},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!C41,IF(Input!$D$23=2,'Ration Data'!K41,'Ration Data'!S41))","v":12.5},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!D41,IF(Input!$D$23=2,'Ration Data'!L41,'Ration Data'!T41))","v":14},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!E41,IF(Input!$D$23=2,'Ration Data'!M41,'Ration Data'!U41))","v":15},{"$f":"ROUND(($E$43*E45)+($F$43*F45)+($G$43*G45)+($H$43*H45),0)","v":2110},{"$f":"SUM(I45*D45)","v":126.6},{"$f":"ROUNDUP((I45*Input!$D$12)/C45,0)","v":528},{"$f":"SUM(K45*B45)","v":63360}]
[{"$f":"Input!A29","v":"Corn Silage"},40,2000,0.02,{"$f":"IF(Input!$D$23=1.5,'Ration Data'!B42,IF(Input!$D$23=2,'Ration Data'!J42,'Ration Data'!R42))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!C42,IF(Input!$D$23=2,'Ration Data'!K42,'Ration Data'!S42))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!D42,IF(Input!$D$23=2,'Ration Data'!L42,'Ration Data'!T42))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!E42,IF(Input!$D$23=2,'Ration Data'!M42,'Ration Data'!U42))","v":0},{"$f":"ROUND(($E$43*E46)+($F$43*F46)+($G$43*G46)+($H$43*H46),0)","v":0},{"$f":"SUM(I46*D46)","v":0},{"$f":"ROUNDUP((I46*Input!$D$12)/C46,0)","v":0},{"$f":"SUM(K46*B46)","v":0}]
[{"$f":"Input!A30","v":"Barley Silage"},50,2000,2.5000000000000001E-2,{"$f":"IF(Input!$D$23=1.5,'Ration Data'!B43,IF(Input!$D$23=2,'Ration Data'!J43,'Ration Data'!R43))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!C43,IF(Input!$D$23=2,'Ration Data'!K43,'Ration Data'!S43))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!D43,IF(Input!$D$23=2,'Ration Data'!L43,'Ration Data'!T43))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!E43,IF(Input!$D$23=2,'Ration Data'!M43,'Ration Data'!U43))","v":0},0,0,{"$f":"ROUNDUP((I47*Input!$D$12)/C47,0)","v":0},0]
[{"$f":"Input!A31","v":"Barley Grain"},4.5,48,9.4E-2,{"$f":"IF(Input!$D$23=1.5,'Ration Data'!B44,IF(Input!$D$23=2,'Ration Data'!J44,'Ration Data'!R44))","v":6.75},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!C44,IF(Input!$D$23=2,'Ration Data'!K44,'Ration Data'!S44))","v":7.8},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!D44,IF(Input!$D$23=2,'Ration Data'!L44,'Ration Data'!T44))","v":8.6999999999999993},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!E44,IF(Input!$D$23=2,'Ration Data'!M44,'Ration Data'!U44))","v":9.6999999999999993},1318,123.892,{"$f":"ROUNDUP((I48*Input!$D$12)/C48,0)","v":13730},61785]
[{"$f":"Input!A32","v":"Greenfeed"},115,2000,5.8000000000000003E-2,{"$f":"IF(Input!$D$23=1.5,'Ration Data'!B45,IF(Input!$D$23=2,'Ration Data'!J45,'Ration Data'!R45))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!C45,IF(Input!$D$23=2,'Ration Data'!K45,'Ration Data'!S45))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!D45,IF(Input!$D$23=2,'Ration Data'!L45,'Ration Data'!T45))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!E45,IF(Input!$D$23=2,'Ration Data'!M45,'Ration Data'!U45))","v":0},{"$f":"ROUND(($E$43*E49)+($F$43*F49)+($G$43*G49)+($H$43*H49),0)","v":0},{"$f":"SUM(I49*D49)","v":0},{"$f":"ROUNDUP((I49*Input!$D$12)/C49,0)","v":0},{"$f":"SUM(K49*B49)","v":0}]
[{"$f":"Input!A33","v":"Straw"},70,2000,3.5000000000000003E-2,{"$f":"IF(Input!$D$23=1.5,'Ration Data'!B46,IF(Input!$D$23=2,'Ration Data'!J46,'Ration Data'!R46))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!C46,IF(Input!$D$23=2,'Ration Data'!K46,'Ration Data'!S46))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!D46,IF(Input!$D$23=2,'Ration Data'!L46,'Ration Data'!T46))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!E46,IF(Input!$D$23=2,'Ration Data'!M46,'Ration Data'!U46))","v":0},{"$f":"ROUND(($E$43*E50)+($F$43*F50)+($G$43*G50)+($H$43*H50),0)","v":0},{"$f":"SUM(I50*D50)","v":0},{"$f":"ROUNDUP((I50*Input!$D$12)/C50,0)","v":0},{"$f":"SUM(K50*B50)","v":0}]
[{"$f":"Input!A34","v":"32-20% Feedlot Suppl."},{"$f":"B15","v":600},2205,0.27200000000000002,{"$f":"IF(Input!$D$23=1.5,'Ration Data'!B47,IF(Input!$D$23=2,'Ration Data'!J47,'Ration Data'!R47))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!C47,IF(Input!$D$23=2,'Ration Data'!K47,'Ration Data'!S47))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!D47,IF(Input!$D$23=2,'Ration Data'!L47,'Ration Data'!T47))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!E47,IF(Input!$D$23=2,'Ration Data'!M47,'Ration Data'!U47))","v":0},0,0,{"$f":"ROUNDUP((I51*Input!$D$12)/C51,0)","v":0},0]
[{"$f":"Input!A35","v":"DDGS Corn/Wheat"},250,2205,0.113,{"$f":"IF(Input!$D$23=1.5,'Ration Data'!B48,IF(Input!$D$23=2,'Ration Data'!J48,'Ration Data'!R48))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!C48,IF(Input!$D$23=2,'Ration Data'!K48,'Ration Data'!S48))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!D48,IF(Input!$D$23=2,'Ration Data'!L48,'Ration Data'!T48))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!E48,IF(Input!$D$23=2,'Ration Data'!M48,'Ration Data'!U48))","v":0},0,0,{"$f":"ROUNDUP((I52*Input!$D$12)/C52,0)","v":0},0]
[{"$f":"Input!A36","v":"1:1 Premix"},50,55,0.90900000000000003,{"$f":"IF(Input!$D$23=1.5,'Ration Data'!B49,IF(Input!$D$23=2,'Ration Data'!J49,'Ration Data'!R49))","v":0.25},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!C49,IF(Input!$D$23=2,'Ration Data'!K49,'Ration Data'!S49))","v":0.27},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!D49,IF(Input!$D$23=2,'Ration Data'!L49,'Ration Data'!T49))","v":0.31},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!E49,IF(Input!$D$23=2,'Ration Data'!M49,'Ration Data'!U49))","v":0.33},46,41.814,{"$f":"ROUNDUP((I53*Input!$D$12)/C53,0)","v":419},20950]
[{"$f":"Input!A37","v":"2:1 Premix"},50,55,0.90900000000000003,{"$f":"IF(Input!$D$23=1.5,'Ration Data'!B50,IF(Input!$D$23=2,'Ration Data'!J50,'Ration Data'!R50))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!C50,IF(Input!$D$23=2,'Ration Data'!K50,'Ration Data'!S50))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!D50,IF(Input!$D$23=2,'Ration Data'!L50,'Ration Data'!T50))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!E50,IF(Input!$D$23=2,'Ration Data'!M50,'Ration Data'!U50))","v":0},0,0,{"$f":"ROUNDUP((I54*Input!$D$12)/C54,0)","v":0},0]
[{"$f":"Input!A38","v":"Limestone"},20,55,0.36399999999999999,{"$f":"IF(Input!$D$23=1.5,'Ration Data'!B51,IF(Input!$D$23=2,'Ration Data'!J51,'Ration Data'!R51))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!C51,IF(Input!$D$23=2,'Ration Data'!K51,'Ration Data'!S51))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!D51,IF(Input!$D$23=2,'Ration Data'!L51,'Ration Data'!T51))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!E51,IF(Input!$D$23=2,'Ration Data'!M51,'Ration Data'!U51))","v":0},0,0,{"$f":"ROUNDUP((I55*Input!$D$12)/C55,0)","v":0},0]
[{"$f":"Input!A39","v":"Other"},0,2000,0,{"$f":"IF(Input!$D$23=1.5,'Ration Data'!B52,IF(Input!$D$23=2,'Ration Data'!J52,'Ration Data'!R52))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!C52,IF(Input!$D$23=2,'Ration Data'!K52,'Ration Data'!S52))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!D52,IF(Input!$D$23=2,'Ration Data'!L52,'Ration Data'!T52))","v":0},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!E52,IF(Input!$D$23=2,'Ration Data'!M52,'Ration Data'!U52))","v":0},{"$f":"ROUND(($E$43*E56)+($F$43*F56)+($G$43*G56)+($H$43*H56),0)","v":0},{"$f":"SUM(I56*D56)","v":0},{"$f":"ROUNDUP((I56*Input!$D$12)/C56,0)","v":0},{"$f":"SUM(K56*B56)","v":0}]
[null,null,null,"$/head/day",{"$f":"IF(Input!$D$23=1.5,'Ration Data'!B53,IF(Input!$D$23=2,'Ration Data'!J53,'Ration Data'!R53))","v":1.5367499999999998},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!C53,IF(Input!$D$23=2,'Ration Data'!K53,'Ration Data'!S53))","v":1.7286300000000001},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!D53,IF(Input!$D$23=2,'Ration Data'!L53,'Ration Data'!T53))","v":1.9395899999999999},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!E53,IF(Input!$D$23=2,'Ration Data'!M53,'Ration Data'!U53))","v":2.1117699999999999},null,{"$f":"SUM(J45:J56)","v":292.30599999999998},null,{"$f":"SUM(L45:L56)","v":146095}]
[]
[{"$f":"\"Feed Summary - \"&Input!B50&\" Days\"","v":"Feed Summary - 160 Days"}]
[null,null,null,"Total Feed Cost per Steer",null,null,"Average Feed Cost/Day",null,null,"Feed Cost per lb. of Gain Sold (shrunk weight)"]
[{"$f":"A5","v":"Barley Silage Ration"},null,null,null,{"$f":"J21","v":280.73399999999998},null,null,{"$f":"E61/Input!$B$50","v":1.7545875},null,null,{"$f":"(E61/ROUND((Input!$D$16-(Input!$D$16*Input!$D$20/100))-(Input!$D$14-(Input!$D$14*Input!$D$21/100)),0))","v":0.75263806970509373}]
[{"$f":"A23","v":"Corn Silage Ration"},null,null,null,{"$f":"J39","v":265.57100000000003},null,null,{"$f":"E62/Input!$B$50","v":1.6598187500000001},null,null,{"$f":"(E62/ROUND((Input!$D$16-(Input!$D$16*Input!$D$20/100))-(Input!$D$14-(Input!$D$14*Input!$D$21/100)),0))","v":0.71198659517426277}]
[{"$f":"A41","v":"Alfalfa Grass Hay Ration"},null,null,null,{"$f":"J57","v":292.30599999999998},null,null,{"$f":"E63/Input!$B$50","v":1.8269124999999999},null,null,{"$f":"(E63/ROUND((Input!$D$16-(Input!$D$16*Input!$D$20/100))-(Input!$D$14-(Input!$D$14*Input!$D$21/100)),0))","v":0.78366219839142082}]
[]
[]
["Note: The suggested feed rations above were formulated using Cowbytes Beef Ration Balancer software with no included allowance for wastage during feeding.   Feed ration quantity and costs should be adjusted accordingly.  If you need help with a budget, contact your local Manitoba Agriculture office."]

{"sheet":"Ration Data","index":6,"n_rows":53,"n_cols":23,"rows_kept":53,"cut":false,"hidden":false,"merged":[[21,13,22,13],[21,14,22,14],[22,9,22,12],[3,0,3,6],[4,5,5,5],[4,6,5,6],[5,1,5,4],[20,0,20,6],[21,5,22,5],[21,6,22,6],[22,1,22,4],[3,8,3,14],[4,13,5,13],[4,14,5,14],[5,9,5,12],[20,8,20,14],[37,0,37,6],[38,5,39,5],[38,6,39,6],[39,1,39,4],[37,8,37,14],[38,13,39,13],[38,14,39,14],[39,9,39,12],[38,22,39,22],[39,17,39,20],[3,16,3,22],[4,21,5,21],[4,22,5,22],[5,17,5,20],[20,16,20,22],[21,21,22,21],[21,22,22,22],[22,17,22,20],[37,16,37,22],[38,21,39,21]]}
[null,{"$f":"ROUND(400/C2,0)","v":267},{"$f":"SUM(B1/4)","v":66.75},"days on feed",null,null,null,null,null,{"$f":"ROUND(400/K2,0)","v":200},{"$f":"SUM(J1/4)","v":50},"days on feed",null,null,null,null,null,{"$f":"ROUND(400/S2,0)","v":160},{"$f":"SUM(R1/4)","v":40},"days on feed"]
[null,"ADG",1.5,"lbs per day",null,null,null,null,null,"ADG",2,"lbs per day",null,null,null,null,null,"ADG",2.5,"lbs per day"]
[]
["Barley Silage Ration",null,null,null,null,null,null,null,"Barley Silage Ration",null,null,null,null,null,null,null,"Barley Silage Ration"]
["Weight Range (lbs)","500 to 600","600 to 700","700-800","800-900","Total lbs /steer","Total Cost /steer",null,"Weight Range (lbs)","500 to 600","600 to 700","700-800","800-900","Total lbs /steer","Total Cost /steer",null,"Weight Range (lbs)","500 to 600","600 to 700","700-800","800-900","Total lbs /steer","Total Cost /steer"]
["Feed Name","As Fed Lbs/Head/Day",null,null,null,null,null,null,"Feed Name","As Fed Lbs/Head/Day",null,null,null,null,null,null,"Feed Name","As Fed Lbs/Head/Day"]
[{"$f":"Input!A28","v":"Alfalfa Grass Hay"},4.75,5,4,4,{"$f":"SUM(($C$1*B7)+(C7*$C$1)+(D7*$C$1)+(E7*$C$1))","v":1184.8125},{"$f":"SUM(F7*Input!D28)","v":71.08874999999999},null,{"$f":"Input!A28","v":"Alfalfa Grass Hay"},3,3,2.5,2,{"$f":"SUM(($K$1*J7)+(K7*$K$1)+(L7*$K$1)+(M7*$K$1))","v":525},{"$f":"SUM(N7*Input!D28)","v":31.5},null,{"$f":"Input!A28","v":"Alfalfa Grass Hay"},3,3,2.5,2,{"$f":"SUM(($S$1*R7)+(S7*$S$1)+(T7*$S$1)+(U7*$S$1))","v":420},{"$f":"SUM(V7*Input!D28)","v":25.2}]
[{"$f":"Input!A29","v":"Corn Silage"},0,0,0,0,0,{"$f":"SUM(F8*Input!D29)","v":0},null,{"$f":"Input!A29","v":"Corn Silage"},0,0,0,0,0,{"$f":"SUM(N8*Input!D29)","v":0},null,{"$f":"Input!A29","v":"Corn Silage"},0,0,0,0,0,{"$f":"SUM(V8*Input!D29)","v":0}]
[{"$f":"Input!A30","v":"Barley Silage"},24,28.25,35.25,40,8510.625,{"$f":"SUM(F9*Input!D30)","v":212.765625},null,{"$f":"Input!A30","v":"Barley Silage"},25.5,28.25,34,38.5,6312.5,{"$f":"SUM(N9*Input!D30)","v":157.8125},null,{"$f":"Input!A30","v":"Barley Silage"},23,25.75,29.25,32.5,4420,{"$f":"SUM(V9*Input!D30)","v":110.5}]
[{"$f":"Input!A31","v":"Barley Grain"},1.5,1.5,1.5,1.5,400.5,{"$f":"SUM(F10*Input!D31)","v":37.646999999999998},null,{"$f":"Input!A31","v":"Barley Grain"},3,3.75,4,4.5,762.5,{"$f":"SUM(N10*Input!D31)","v":71.674999999999997},null,{"$f":"Input!A31","v":"Barley Grain"},5,6,7,8,1040,{"$f":"SUM(V10*Input!D31)","v":97.76}]
[{"$f":"Input!A32","v":"Greenfeed"},0,0,0,0,0,{"$f":"SUM(F11*Input!D32)","v":0},null,{"$f":"Input!A32","v":"Greenfeed"},0,0,0,0,0,{"$f":"SUM(N11*Input!D32)","v":0},null,{"$f":"Input!A32","v":"Greenfeed"},0,0,0,0,0,{"$f":"SUM(V11*Input!D32)","v":0}]
[{"$f":"Input!A33","v":"Straw"},0,0,0,0,0,{"$f":"SUM(F12*Input!D33)","v":0},null,{"$f":"Input!A33","v":"Straw"},0,0,0,0,0,{"$f":"SUM(N12*Input!D33)","v":0},null,{"$f":"Input!A33","v":"Straw"},0,0,0,0,0,{"$f":"SUM(V12*Input!D33)","v":0}]
[{"$f":"Input!A34","v":"32-20% Feedlot Suppl."},0,0,0,0,0,{"$f":"SUM(F13*Input!D34)","v":0},null,{"$f":"Input!A34","v":"32-20% Feedlot Suppl."},0,0,0,0,0,{"$f":"SUM(N13*Input!D34)","v":0},null,{"$f":"Input!A34","v":"32-20% Feedlot Suppl."},0,0,0,0,0,{"$f":"SUM(V13*Input!D34)","v":0}]
[{"$f":"Input!A35","v":"DDGS Corn/Wheat"},0,0,0,0,0,{"$f":"SUM(F14*Input!D35)","v":0},null,{"$f":"Input!A35","v":"DDGS Corn/Wheat"},0,0,0,0,0,{"$f":"SUM(N14*Input!D35)","v":0},null,{"$f":"Input!A35","v":"DDGS Corn/Wheat"},0,0,0,0,0,{"$f":"SUM(V14*Input!D35)","v":0}]
[{"$f":"Input!A36","v":"1:1 Premix"},0.25,0.25,0.27500000000000002,0.3,71.756249999999994,{"$f":"SUM(F15*Input!D36)","v":65.22643124999999},null,{"$f":"Input!A36","v":"1:1 Premix"},0.25,0.255,0.28000000000000003,0.31,54.75,{"$f":"SUM(N15*Input!D36)","v":49.767749999999999},null,{"$f":"Input!A36","v":"1:1 Premix"},0.25,0.27,0.3,0.32,45.599999999999994,{"$f":"SUM(V15*Input!D36)","v":41.450399999999995}]
[{"$f":"Input!A37","v":"2:1 Premix"},0,0,0,0,0,{"$f":"SUM(F16*Input!D37)","v":0},null,{"$f":"Input!A37","v":"2:1 Premix"},0,0,0,0,0,{"$f":"SUM(N16*Input!D37)","v":0},null,{"$f":"Input!A37","v":"2:1 Premix"},0,0,0,0,0,{"$f":"SUM(V16*Input!D37)","v":0}]
[{"$f":"Input!A38","v":"Limestone"},0,0,0,0,0,{"$f":"SUM(F17*Input!D38)","v":0},null,{"$f":"Input!A38","v":"Limestone"},3.5000000000000003E-2,0.05,7.0000000000000007E-2,0.09,12.25,{"$f":"SUM(N17*Input!D38)","v":4.4589999999999996},null,{"$f":"Input!A38","v":"Limestone"},0.06,8.5000000000000006E-2,0.11,0.13,15.400000000000002,{"$f":"SUM(V17*Input!D38)","v":5.6056000000000008}]
[{"$f":"Input!A39","v":"Other"},0,0,0,0,0,{"$f":"SUM(F18*Input!D39)","v":0},null,{"$f":"Input!A39","v":"Other"},0,0,0,0,0,{"$f":"SUM(N18*Input!D39)","v":0},null,{"$f":"Input!A39","v":"Other"},0,0,0,0,0,{"$f":"SUM(V18*Input!D39)","v":0}]
["$/head/day",{"$f":"SUM((B7*Input!D28)+(B8*Input!D29)+(B9*Input!D30)+(B10*Input!D31)+(B11*Input!D32)+(B12*Input!D33)+(B13*Input!D34)+(B14*Input!D35)+(B15*Input!D36)+(B16*Input!D37)+(B17*Input!D38)+(B18*Input!D39))","v":1.25325},{"$f":"SUM((C7*Input!D28)+(C8*Input!D29)+(C9*Input!D30)+(C10*Input!D31)+(C11*Input!D32)+(C12*Input!D33)+(C13*Input!D34)+(C14*Input!D35)+(C15*Input!D36)+(C16*Input!D37)+(C17*Input!D38)+(C18*Input!D39))","v":1.3745000000000001},{"$f":"SUM((D7*Input!D28)+(D8*Input!D29)+(D9*Input!D30)+(D10*Input!D31)+(D11*Input!D32)+(D12*Input!D33)+(D13*Input!D34)+(D14*Input!D35)+(D15*Input!D36)+(D16*Input!D37)+(D17*Input!D38)+(D18*Input!D39))","v":1.5122250000000002},{"$f":"SUM((E7*Input!D28)+(E8*Input!D29)+(E9*Input!D30)+(E10*Input!D31)+(E11*Input!D32)+(E12*Input!D33)+(E13*Input!D34)+(E14*Input!D35)+(E15*Input!D36)+(E16*Input!D37)+(E17*Input!D38)+(E18*Input!D39))","v":1.6536999999999999},null,{"$f":"SUM(G7:G18)","v":386.72780624999996},null,"$/head/day",{"$f":"SUM((J7*Input!D28)+(J8*Input!D29)+(J9*Input!D30)+(J10*Input!D31)+(J11*Input!D32)+(J12*Input!D33)+(J13*Input!D34)+(J14*Input!D35)+(J15*Input!D36)+(J16*Input!D37)+(J17*Input!D38)+(J18*Input!D39))","v":1.3394900000000001},{"$f":"SUM((K7*Input!D28)+(K8*Input!D29)+(K9*Input!D30)+(K10*Input!D31)+(K11*Input!D32)+(K12*Input!D33)+(K13*Input!D34)+(K14*Input!D35)+(K15*Input!D36)+(K16*Input!D37)+(K17*Input!D38)+(K18*Input!D39))","v":1.488745},{"$f":"SUM((L7*Input!D28)+(L8*Input!D29)+(L9*Input!D30)+(L10*Input!D31)+(L11*Input!D32)+(L12*Input!D33)+(L13*Input!D34)+(L14*Input!D35)+(L15*Input!D36)+(L16*Input!D37)+(L17*Input!D38)+(L18*Input!D39))","v":1.6559999999999999},{"$f":"SUM((M7*Input!D28)+(M8*Input!D29)+(M9*Input!D30)+(M10*Input!D31)+(M11*Input!D32)+(M12*Input!D33)+(M13*Input!D34)+(M14*Input!D35)+(M15*Input!D36)+(M16*Input!D37)+(M17*Input!D38)+(M18*Input!D39))","v":1.8200499999999999},null,{"$f":"SUM(O7:O18)","v":315.21424999999999},null,"$/head/day",{"$f":"SUM((R7*Input!D28)+(R8*Input!D29)+(R9*Input!D30)+(R10*Input!D31)+(R11*Input!D32)+(R12*Input!D33)+(R13*Input!D34)+(R14*Input!D35)+(R15*Input!D36)+(R16*Input!D37)+(R17*Input!D38)+(R18*Input!D39))","v":1.4740900000000001},{"$f":"SUM((S7*Input!D28)+(S8*Input!D29)+(S9*Input!D30)+(S10*Input!D31)+(S11*Input!D32)+(S12*Input!D33)+(S13*Input!D34)+(S14*Input!D35)+(S15*Input!D36)+(S16*Input!D37)+(S17*Input!D38)+(S18*Input!D39))","v":1.66412},{"$f":"SUM((T7*Input!D28)+(T8*Input!D29)+(T9*Input!D30)+(T10*Input!D31)+(T11*Input!D32)+(T12*Input!D33)+(T13*Input!D34)+(T14*Input!D35)+(T15*Input!D36)+(T16*Input!D37)+(T17*Input!D38)+(T18*Input!D39))","v":1.85199},{"$f":"SUM((U7*Input!D28)+(U8*Input!D29)+(U9*Input!D30)+(U10*Input!D31)+(U11*Input!D32)+(U12*Input!D33)+(U13*Input!D34)+(U14*Input!D35)+(U15*Input!D36)+(U16*Input!D37)+(U17*Input!D38)+(U18*Input!D39))","v":2.0226999999999999},null,{"$f":"SUM(W7:W18)","v":280.51599999999996}]
[]
["Corn Silage Ration",null,null,null,null,null,null,null,"Corn Silage Ration",null,null,null,null,null,null,null,"Corn Silage Ration"]
["Weight Range (lbs)","500 to 600","600 to 700","700-800","800-900","Total lbs /steer","Total Cost /steer",null,"Weight Range (lbs)","500 to 600","600 to 700","700-800","800-900","Total lbs /steer","Total Cost /steer",null,"Weight Range (lbs)","500 to 600","600 to 700","700-800","800-900","Total lbs /steer","Total Cost /steer"]
["Feed Name","As Fed Lbs/Head/Day",null,null,null,null,null,null,"Feed Name","As Fed Lbs/Head/Day",null,null,null,null,null,null,"Feed Name","As Fed Lbs/Head/Day"]
[{"$f":"Input!A28","v":"Alfalfa Grass Hay"},7.5,8,8,8,{"$f":"SUM(($C$1*B24)+(C24*$C$1)+(D24*$C$1)+(E24*$C$1))","v":2102.625},{"$f":"SUM(F24*Input!D28)","v":126.1575},null,{"$f":"Input!A28","v":"Alfalfa Grass Hay"},5,5,5,5,{"$f":"SUM(($K$1*J24)+(K24*$K$1)+(L24*$K$1)+(M24*$K$1))","v":1000},{"$f":"SUM(N24*Input!D28)","v":60},null,{"$f":"Input!A28","v":"Alfalfa Grass Hay"},5,5,5,5,{"$f":"SUM(($S$1*R24)+(S24*$S$1)+(T24*$S$1)+(U24*$S$1))","v":800},{"$f":"SUM(V24*Input!D28)","v":48}]
[{"$f":"Input!A29","v":"Corn Silage"},18,22.5,27.5,32,6675,{"$f":"SUM(F25*Input!D29)","v":133.5},null,{"$f":"Input!A29","v":"Corn Silage"},23,28,34,39,6200,{"$f":"SUM(N25*Input!D29)","v":124},null,{"$f":"Input!A29","v":"Corn Silage"},19,22,27,31.75,3990,{"$f":"SUM(V25*Input!D29)","v":79.8}]
[{"$f":"Input!A30","v":"Barley Silage"},0,0,0,0,0,{"$f":"SUM(F26*Input!D30)","v":0},null,{"$f":"Input!A30","v":"Barley Silage"},0,0,0,0,0,{"$f":"SUM(N26*Input!D30)","v":0},null,{"$f":"Input!A30","v":"Barley Silage"},0,0,0,0,0,{"$f":"SUM(V26*Input!D30)","v":0}]
[{"$f":"Input!A31","v":"Barley Grain"},1.5,1.5,1.5,1.5,400.5,{"$f":"SUM(F27*Input!D31)","v":37.646999999999998},null,{"$f":"Input!A31","v":"Barley Grain"},2.5,2.5,2.5,2.5,500,{"$f":"SUM(N27*Input!D31)","v":47},null,{"$f":"Input!A31","v":"Barley Grain"},4,5,5.5,6,820,{"$f":"SUM(V27*Input!D31)","v":77.08}]
[{"$f":"Input!A32","v":"Greenfeed"},0,0,0,0,0,{"$f":"SUM(F28*Input!D32)","v":0},null,{"$f":"Input!A32","v":"Greenfeed"},0,0,0,0,0,{"$f":"SUM(N28*Input!D32)","v":0},null,{"$f":"Input!A32","v":"Greenfeed"},0,0,0,0,0,{"$f":"SUM(V28*Input!D32)","v":0}]
[{"$f":"Input!A33","v":"Straw"},0,0,0,0,0,{"$f":"SUM(F29*Input!D33)","v":0},null,{"$f":"Input!A33","v":"Straw"},0,0,0,0,0,{"$f":"SUM(N29*Input!D33)","v":0},null,{"$f":"Input!A33","v":"Straw"},0,0,0,0,0,{"$f":"SUM(V29*Input!D33)","v":0}]
[{"$f":"Input!A34","v":"32-20% Feedlot Suppl."},0,0,0,0,0,{"$f":"SUM(F30*Input!D34)","v":0},null,{"$f":"Input!A34","v":"32-20% Feedlot Suppl."},0.5,0.55000000000000004,0.6,0.65,115,{"$f":"SUM(N30*Input!D34)","v":31.28},null,{"$f":"Input!A34","v":"32-20% Feedlot Suppl."},0,0,0,0,0,{"$f":"SUM(V30*Input!D34)","v":0}]
[{"$f":"Input!A35","v":"DDGS Corn/Wheat"},0,0,0,0,0,{"$f":"SUM(F31*Input!D35)","v":0},null,{"$f":"Input!A35","v":"DDGS Corn/Wheat"},0,0,0,0,0,{"$f":"SUM(N31*Input!D35)","v":0},null,{"$f":"Input!A35","v":"DDGS Corn/Wheat"},1,1,0.75,0.5,130,{"$f":"SUM(V31*Input!D35)","v":14.690000000000001}]
[{"$f":"Input!A36","v":"1:1 Premix"},0,0,0,0,0,{"$f":"SUM(F32*Input!D36)","v":0},null,{"$f":"Input!A36","v":"1:1 Premix"},0,0,0,0,0,{"$f":"SUM(N32*Input!D36)","v":0},null,{"$f":"Input!A36","v":"1:1 Premix"},0,0,0,0,0,{"$f":"SUM(V32*Input!D36)","v":0}]
[{"$f":"Input!A37","v":"2:1 Premix"},0.25,0.25,0.27500000000000002,0.3,71.756249999999994,{"$f":"SUM(F33*Input!D37)","v":65.22643124999999},null,{"$f":"Input!A37","v":"2:1 Premix"},0,0,0,0,0,{"$f":"SUM(N33*Input!D37)","v":0},null,{"$f":"Input!A37","v":"2:1 Premix"},0.25,0.28000000000000003,0.28499999999999998,0.315,45.2,{"$f":"SUM(V33*Input!D37)","v":41.086800000000004}]
[{"$f":"Input!A38","v":"Limestone"},0,0,0,0,0,{"$f":"SUM(F34*Input!D38)","v":0},null,{"$f":"Input!A38","v":"Limestone"},0,0,0,0,0,{"$f":"SUM(N34*Input!D38)","v":0},null,{"$f":"Input!A38","v":"Limestone"},6.5000000000000002E-2,0.09,0.09,0.105,14,{"$f":"SUM(V34*Input!D38)","v":5.0960000000000001}]
[{"$f":"Input!A39","v":"Other"},0,0,0,0,0,{"$f":"SUM(F35*Input!D39)","v":0},null,{"$f":"Input!A39","v":"Other"},0,0,0,0,0,{"$f":"SUM(N35*Input!D39)","v":0},null,{"$f":"Input!A39","v":"Other"},0,0,0,0,0,{"$f":"SUM(V35*Input!D39)","v":0}]
["$/head/day",{"$f":"SUM((B24*Input!D28)+(B25*Input!D29)+(B26*Input!D30)+(B27*Input!D31)+(B28*Input!D32)+(B29*Input!D33)+(B30*Input!D34)+(B31*Input!D35)+(B32*Input!D36)+(B33*Input!D37)+(B34*Input!D38)+(B35*Input!D39))","v":1.17825},{"$f":"SUM((C24*Input!D28)+(C25*Input!D29)+(C26*Input!D30)+(C27*Input!D31)+(C28*Input!D32)+(C29*Input!D33)+(C30*Input!D34)+(C31*Input!D35)+(C32*Input!D36)+(C33*Input!D37)+(C34*Input!D38)+(C35*Input!D39))","v":1.2982499999999999},{"$f":"SUM((D24*Input!D28)+(D25*Input!D29)+(D26*Input!D30)+(D27*Input!D31)+(D28*Input!D32)+(D29*Input!D33)+(D30*Input!D34)+(D31*Input!D35)+(D32*Input!D36)+(D33*Input!D37)+(D34*Input!D38)+(D35*Input!D39))","v":1.4209750000000001},{"$f":"SUM((E24*Input!D28)+(E25*Input!D29)+(E26*Input!D30)+(E27*Input!D31)+(E28*Input!D32)+(E29*Input!D33)+(E30*Input!D34)+(E31*Input!D35)+(E32*Input!D36)+(E33*Input!D37)+(E34*Input!D38)+(E35*Input!D39))","v":1.5337000000000001},null,{"$f":"SUM(G24:G35)","v":362.53093124999998},null,"$/head/day",{"$f":"SUM((J24*Input!D28)+(J25*Input!D29)+(J26*Input!D30)+(J27*Input!D31)+(J28*Input!D32)+(J29*Input!D33)+(J30*Input!D34)+(J31*Input!D35)+(J32*Input!D36)+(J33*Input!D37)+(J34*Input!D38)+(J35*Input!D39))","v":1.131},{"$f":"SUM((K24*Input!D28)+(K25*Input!D29)+(K26*Input!D30)+(K27*Input!D31)+(K28*Input!D32)+(K29*Input!D33)+(K30*Input!D34)+(K31*Input!D35)+(K32*Input!D36)+(K33*Input!D37)+(K34*Input!D38)+(K35*Input!D39))","v":1.2446000000000002},{"$f":"SUM((L24*Input!D28)+(L25*Input!D29)+(L26*Input!D30)+(L27*Input!D31)+(L28*Input!D32)+(L29*Input!D33)+(L30*Input!D34)+(L31*Input!D35)+(L32*Input!D36)+(L33*Input!D37)+(L34*Input!D38)+(L35*Input!D39))","v":1.3781999999999999},{"$f":"SUM((M24*Input!D28)+(M25*Input!D29)+(M26*Input!D30)+(M27*Input!D31)+(M28*Input!D32)+(M29*Input!D33)+(M30*Input!D34)+(M31*Input!D35)+(M32*Input!D36)+(M33*Input!D37)+(M34*Input!D38)+(M35*Input!D39))","v":1.4918},null,{"$f":"SUM(O24:O35)","v":262.27999999999997},null,"$/head/day",{"$f":"SUM((R24*Input!D28)+(R25*Input!D29)+(R26*Input!D30)+(R27*Input!D31)+(R28*Input!D32)+(R29*Input!D33)+(R30*Input!D34)+(R31*Input!D35)+(R32*Input!D36)+(R33*Input!D37)+(R34*Input!D38)+(R35*Input!D39))","v":1.41991},{"$f":"SUM((S24*Input!D28)+(S25*Input!D29)+(S26*Input!D30)+(S27*Input!D31)+(S28*Input!D32)+(S29*Input!D33)+(S30*Input!D34)+(S31*Input!D35)+(S32*Input!D36)+(S33*Input!D37)+(S34*Input!D38)+(S35*Input!D39))","v":1.6102799999999999},{"$f":"SUM((T24*Input!D28)+(T25*Input!D29)+(T26*Input!D30)+(T27*Input!D31)+(T28*Input!D32)+(T29*Input!D33)+(T30*Input!D34)+(T31*Input!D35)+(T32*Input!D36)+(T33*Input!D37)+(T34*Input!D38)+(T35*Input!D39))","v":1.7335750000000003},{"$f":"SUM((U24*Input!D28)+(U25*Input!D29)+(U26*Input!D30)+(U27*Input!D31)+(U28*Input!D32)+(U29*Input!D33)+(U30*Input!D34)+(U31*Input!D35)+(U32*Input!D36)+(U33*Input!D37)+(U34*Input!D38)+(U35*Input!D39))","v":1.880055},null,{"$f":"SUM(W24:W35)","v":265.75279999999998}]
[]
["Alfalfa Grass Hay Ration",null,null,null,null,null,null,null,"Alfalfa Grass Hay Ration",null,null,null,null,null,null,null,"Alfalfa Grass Hay Ration"]
["Weight Range (lbs)","500 to 600","600 to 700","700-800","800-900","Total lbs /steer","Total Cost /steer",null,"Weight Range (lbs)","500 to 600","600 to 700","700-800","800-900","Total lbs /steer","Total Cost /steer",null,"Weight Range (lbs)","500 to 600","600 to 700","700-800","800-900","Total lbs /steer","Total Cost /steer"]
["Feed Name","As Fed Lbs/Head/Day",null,null,null,null,null,null,"Feed Name","As Fed Lbs/Head/Day",null,null,null,null,null,null,"Feed Name","As Fed Lbs/Head/Day"]
[{"$f":"Input!A28","v":"Alfalfa Grass Hay"},13.5,15.2,17.25,18.5,{"$f":"SUM(($C$1*B41)+(C41*$C$1)+(D41*$C$1)+(E41*$C$1))","v":4302.0375000000004},{"$f":"SUM(F41*Input!D28)","v":258.12225000000001},null,{"$f":"Input!A28","v":"Alfalfa Grass Hay"},13,15,16.75,18.5,{"$f":"SUM(($K$1*J41)+(K41*$K$1)+(L41*$K$1)+(M41*$K$1))","v":3162.5},{"$f":"SUM(N41*Input!D28)","v":189.75},null,{"$f":"Input!A28","v":"Alfalfa Grass Hay"},11.25,12.5,14,15,{"$f":"SUM(($S$1*R41)+(S41*$S$1)+(T41*$S$1)+(U41*$S$1))","v":2110},{"$f":"SUM(V41*Input!D28)","v":126.6}]
[{"$f":"Input!A29","v":"Corn Silage"},0,0,0,0,0,{"$f":"SUM(F42*Input!D29)","v":0},null,{"$f":"Input!A29","v":"Corn Silage"},0,0,0,0,0,{"$f":"SUM(N42*Input!D29)","v":0},null,{"$f":"Input!A29","v":"Corn Silage"},0,0,0,0,0,{"$f":"SUM(V42*Input!D29)","v":0}]
[{"$f":"Input!A30","v":"Barley Silage"},0,0,0,0,0,{"$f":"SUM(F43*Input!D30)","v":0},null,{"$f":"Input!A30","v":"Barley Silage"},0,0,0,0,0,{"$f":"SUM(N43*Input!D30)","v":0},null,{"$f":"Input!A30","v":"Barley Silage"},0,0,0,0,0,{"$f":"SUM(V43*Input!D30)","v":0}]
[{"$f":"Input!A31","v":"Barley Grain"},3,3.5,3.5,4,934.5,{"$f":"SUM(F44*Input!D31)","v":87.843000000000004},null,{"$f":"Input!A31","v":"Barley Grain"},4.5,5,5.5,6,1050,{"$f":"SUM(N44*Input!D31)","v":98.7},null,{"$f":"Input!A31","v":"Barley Grain"},6.75,7.8,8.6999999999999993,9.6999999999999993,1318,{"$f":"SUM(V44*Input!D31)","v":123.892}]
[{"$f":"Input!A32","v":"Greenfeed"},0,0,0,0,0,{"$f":"SUM(F45*Input!D32)","v":0},null,{"$f":"Input!A32","v":"Greenfeed"},0,0,0,0,0,{"$f":"SUM(N45*Input!D32)","v":0},null,{"$f":"Input!A32","v":"Greenfeed"},0,0,0,0,0,{"$f":"SUM(V45*Input!D32)","v":0}]
[{"$f":"Input!A33","v":"Straw"},0,0,0,0,0,{"$f":"SUM(F46*Input!D33)","v":0},null,{"$f":"Input!A33","v":"Straw"},0,0,0,0,0,{"$f":"SUM(N46*Input!D33)","v":0},null,{"$f":"Input!A33","v":"Straw"},0,0,0,0,0,{"$f":"SUM(V46*Input!D33)","v":0}]
[{"$f":"Input!A34","v":"32-20% Feedlot Suppl."},0,0,0,0,0,{"$f":"SUM(F47*Input!D34)","v":0},null,{"$f":"Input!A34","v":"32-20% Feedlot Suppl."},0,0,0,0,0,{"$f":"SUM(N47*Input!D34)","v":0},null,{"$f":"Input!A34","v":"32-20% Feedlot Suppl."},0,0,0,0,0,{"$f":"SUM(V47*Input!D34)","v":0}]
[{"$f":"Input!A35","v":"DDGS Corn/Wheat"},0,0,0,0,0,{"$f":"SUM(F48*Input!D35)","v":0},null,{"$f":"Input!A35","v":"DDGS Corn/Wheat"},0,0,0,0,0,{"$f":"SUM(N48*Input!D35)","v":0},null,{"$f":"Input!A35","v":"DDGS Corn/Wheat"},0,0,0,0,0,{"$f":"SUM(V48*Input!D35)","v":0}]
[{"$f":"Input!A36","v":"1:1 Premix"},0.25,0.25,0.28000000000000003,0.3,72.09,{"$f":"SUM(F49*Input!D36)","v":65.529810000000012},null,{"$f":"Input!A36","v":"1:1 Premix"},0.25,0.27,0.3,0.33,57.5,{"$f":"SUM(N49*Input!D36)","v":52.267499999999998},null,{"$f":"Input!A36","v":"1:1 Premix"},0.25,0.27,0.31,0.33,46.400000000000006,{"$f":"SUM(V49*Input!D36)","v":42.177600000000005}]
[{"$f":"Input!A37","v":"2:1 Premix"},0,0,0,0,0,{"$f":"SUM(F50*Input!D37)","v":0},null,{"$f":"Input!A37","v":"2:1 Premix"},0,0,0,0,0,{"$f":"SUM(N50*Input!D37)","v":0},null,{"$f":"Input!A37","v":"2:1 Premix"},0,0,0,0,0,{"$f":"SUM(V50*Input!D37)","v":0}]
[{"$f":"Input!A38","v":"Limestone"},0,0,0,0,0,{"$f":"SUM(F51*Input!D38)","v":0},null,{"$f":"Input!A38","v":"Limestone"},0,0,0,0,0,{"$f":"SUM(N51*Input!D38)","v":0},null,{"$f":"Input!A38","v":"Limestone"},0,0,0,0,0,{"$f":"SUM(V51*Input!D38)","v":0}]
[{"$f":"Input!A39","v":"Other"},0,0,0,0,0,{"$f":"SUM(F52*Input!D39)","v":0},null,{"$f":"Input!A39","v":"Other"},0,0,0,0,0,{"$f":"SUM(N52*Input!D39)","v":0},null,{"$f":"Input!A39","v":"Other"},0,0,0,0,0,{"$f":"SUM(V52*Input!D39)","v":0}]
["$/head/day",{"$f":"SUM((B41*Input!D28)+(B42*Input!D29)+(B43*Input!D30)+(B44*Input!D31)+(B45*Input!D32)+(B46*Input!D33)+(B47*Input!D34)+(B48*Input!D35)+(B49*Input!D36)+(B50*Input!D37)+(B51*Input!D38)+(B52*Input!D39))","v":1.31925},{"$f":"SUM((C41*Input!D28)+(C42*Input!D29)+(C43*Input!D30)+(C44*Input!D31)+(C45*Input!D32)+(C46*Input!D33)+(C47*Input!D34)+(C48*Input!D35)+(C49*Input!D36)+(C50*Input!D37)+(C51*Input!D38)+(C52*Input!D39))","v":1.4682499999999998},{"$f":"SUM((D41*Input!D28)+(D42*Input!D29)+(D43*Input!D30)+(D44*Input!D31)+(D45*Input!D32)+(D46*Input!D33)+(D47*Input!D34)+(D48*Input!D35)+(D49*Input!D36)+(D50*Input!D37)+(D51*Input!D38)+(D52*Input!D39))","v":1.61852},{"$f":"SUM((E41*Input!D28)+(E42*Input!D29)+(E43*Input!D30)+(E44*Input!D31)+(E45*Input!D32)+(E46*Input!D33)+(E47*Input!D34)+(E48*Input!D35)+(E49*Input!D36)+(E50*Input!D37)+(E51*Input!D38)+(E52*Input!D39))","v":1.7586999999999997},null,{"$f":"SUM(G41:G51)","v":411.49506000000002},null,"$/head/day",{"$f":"SUM((J41*Input!D28)+(J42*Input!D29)+(J43*Input!D30)+(J44*Input!D31)+(J45*Input!D32)+(J46*Input!D33)+(J47*Input!D34)+(J48*Input!D35)+(J49*Input!D36)+(J50*Input!D37)+(J51*Input!D38)+(J52*Input!D39))","v":1.43025},{"$f":"SUM((K41*Input!D28)+(K42*Input!D29)+(K43*Input!D30)+(K44*Input!D31)+(K45*Input!D32)+(K46*Input!D33)+(K47*Input!D34)+(K48*Input!D35)+(K49*Input!D36)+(K50*Input!D37)+(K51*Input!D38)+(K52*Input!D39))","v":1.6154299999999999},{"$f":"SUM((L41*Input!D28)+(L42*Input!D29)+(L43*Input!D30)+(L44*Input!D31)+(L45*Input!D32)+(L46*Input!D33)+(L47*Input!D34)+(L48*Input!D35)+(L49*Input!D36)+(L50*Input!D37)+(L51*Input!D38)+(L52*Input!D39))","v":1.7946999999999997},{"$f":"SUM((M41*Input!D28)+(M42*Input!D29)+(M43*Input!D30)+(M44*Input!D31)+(M45*Input!D32)+(M46*Input!D33)+(M47*Input!D34)+(M48*Input!D35)+(M49*Input!D36)+(M50*Input!D37)+(M51*Input!D38)+(M52*Input!D39))","v":1.97397},null,{"$f":"SUM(O41:O52)","v":340.71749999999997},null,"$/head/day",{"$f":"SUM((R41*Input!D28)+(R42*Input!D29)+(R43*Input!D30)+(R44*Input!D31)+(R45*Input!D32)+(R46*Input!D33)+(R47*Input!D34)+(R48*Input!D35)+(R49*Input!D36)+(R50*Input!D37)+(R51*Input!D38)+(R52*Input!D39))","v":1.5367499999999998},{"$f":"SUM((S41*Input!D28)+(S42*Input!D29)+(S43*Input!D30)+(S44*Input!D31)+(S45*Input!D32)+(S46*Input!D33)+(S47*Input!D34)+(S48*Input!D35)+(S49*Input!D36)+(S50*Input!D37)+(S51*Input!D38)+(S52*Input!D39))","v":1.7286300000000001},{"$f":"SUM((T41*Input!D28)+(T42*Input!D29)+(T43*Input!D30)+(T44*Input!D31)+(T45*Input!D32)+(T46*Input!D33)+(T47*Input!D34)+(T48*Input!D35)+(T49*Input!D36)+(T50*Input!D37)+(T51*Input!D38)+(T52*Input!D39))","v":1.9395899999999999},{"$f":"SUM((U41*Input!D28)+(U42*Input!D29)+(U43*Input!D30)+(U44*Input!D31)+(U45*Input!D32)+(U46*Input!D33)+(U47*Input!D34)+(U48*Input!D35)+(U49*Input!D36)+(U50*Input!D37)+(U51*Input!D38)+(U52*Input!D39))","v":2.1117699999999999},null,{"$f":"SUM(W41:W52)","v":292.6696}]

{"sheet":"Fixed","index":7,"n_rows":42,"n_cols":20,"rows_kept":42,"cut":false,"hidden":false,"merged":[[0,0,0,9],[20,0,20,9],[21,3,21,4],[21,8,21,9]]}
["Fixed Costs"]
[]
["Buildings & Facilities",null,null,null,null,"Machinery & Equipment"]
[null,"  Total Investment ($/feeder)",null,{"$f":"ROUND((SUM(E24:E39)/(Input!D12)),0)","v":160},null,null,"  Total Investment ($/feeder)",null,{"$f":"ROUND((SUM(J24:J39)/(Input!D12)),0)","v":225},null,null,"*HIDE*"]
[null,"  Residual Value (End of Useful Life)",null,0.1,null,null,"  Residual Value (End of Useful Life)",null,0.2,null,null,{"$f":"(#REF!-#REF!)/(#REF!+#REF!)","v":{"$error":"#REF!"}}]
[null,"  Useful Life (years)",null,20,null,null,"  Useful Life (years)",null,10]
[null,"  Owned Building Equity",null,0.85,null,null,"  Owned Machinery Equity",null,0.8]
[null,{"$f":"\"  Building Financed (\"&TEXT((D4)*D8,\"$#,###\")&\" per feeder)\"","v":"  Building Financed ($24 per feeder)"},null,{"$f":"SUM(1-D7)","v":0.15000000000000002},null,null,{"$f":"\"  Machinery Financed (\"&TEXT((I4)*I8,\"$#,###\")&\" per feeder)\"","v":"  Machinery Financed ($45 per feeder)"},null,{"$f":"SUM(1-I7)","v":0.19999999999999996}]
[null,"  Building Opportunity Cost (Investment Rate) ",null,0,null,null,"  Machinery Opportunity Cost (Investment Rate) ",null,0]
[null,"Building & Water System Cost ($/feeder)",null,null,null,null,"Machinery & Equipment Cost ($/feeder)"]
[null,"  Finance Rate & Term",6.25E-2,7,"Years",null,"  Finance Rate & Term",6.25E-2,7,"Years"]
[null,"  Principle & Interest Cost",null,{"$f":"-PMT(C11,D11,D4*D8,0)","v":4.3375197723671057},null,null,"  Principle & Interest Cost",null,{"$f":"-PMT(H11,I11,I4*I8,0)","v":8.1328495731883219}]
[null,"  Building Depreciation Cost",null,{"$f":"(D4-(D4*D5))/D6","v":7.2},null,null,"  Machinery Depreciation Cost",null,{"$f":"(I4-(I4*I5))/I6","v":18}]
[null,"  Owned Building Opportunity Cost ",null,{"$f":"SUM(D4*D7)*(D9)","v":0},null,null,"  Owned Machinery Opportunity Cost ",null,{"$f":"SUM(I4*I7)*(I9)","v":0}]
[null,"  Total Cost",null,{"$f":"SUM(D12:D14)","v":11.537519772367105},null,null,"  Total Cost",null,{"$f":"SUM(I12:I14)","v":26.132849573188324}]
[]
["Total Principle & Interest Cost ($/feeder)",null,null,{"$f":"SUM(I12+D12)","v":12.470369345555428}]
[{"$f":"\"Total Principle & Interest Cost (\"&Input!D12&\" feeders)\"","v":"Total Principle & Interest Cost (500 feeders)"},null,null,{"$f":"D17*Input!D12","v":6235.1846727777138}]
["Total Fixed Investment",null,null,{"$f":"SUM(E24:E39)+SUM(J24:J39)","v":192600}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.75E-2]
["Capital Value"]
[null,null,"Market","Cow-calf",null,null,null,"Market","Cow-calf"]
["Buildings & Facilities",null,"Value","Usage %","Allocation",null,"Machinery & Equipment","Value","Usage %","Allocation"]
[null,"Windbreak Fence",6300,1,{"$f":"SUM(C24*D24)","v":6300},null,"Miscellaneous Machinery",17500,1,{"$f":"SUM(H24*I24)","v":17500}]
[null,"Pens",5300,1,5300,null,"Tractor & Loader ",175000,0.3,52500]
[null,"Handling Facilities",7500,1,7500,null,"Bale Shredder",25000,0.5,12500]
[null,"Waterers",6000,1,6000,null,"Tractor & Feed Wagon (silage)",60000,0.5,30000]
[null,"Gates",2000,1,2000,null,null,0,1,0]
[null,"Feeders",1500,1,1500,null,null,0,1,0]
[null,"Bunk Feeders",21000,1,21000,null,null,0,1,0]
[null,"Well & Pressure System",8000,1,8000,null,null,0,1,0]
[null,"Grain Bin",5000,1,5000,null,null,0,1,0]
[null,"Landscaping",17500,1,17500,null,null,0,1,0]
[null,null,0,1,0,null,null,0,1,0]
[null,null,0,1,0,null,null,0,1,0]
[null,null,0,1,0,null,null,0,1,0]
[null,null,0,1,0,null,null,0,1,0]
[null,null,0,1,0,null,null,0,1,0]
[null,null,0,0,0,null,null,0,1,0]
[null,null,null,null,{"$f":"\"Total Inv. = $\"&TEXT(SUM(E24:E39),\"#,###\")&\" ($\"&ROUND(SUM(E24:E39)/(Input!D12),0)&\"/feeder)\"","v":"Total Inv. = $80,100 ($160/feeder)"},null,null,null,null,{"$f":"\"Total Inv. = $\"&TEXT(SUM(J24:J39),\"#,###\")&\" ($\"&ROUND(SUM(J24:J39)/(Input!D12),0)&\"/feeder)\"","v":"Total Inv. = $112,500 ($225/feeder)"}]
[null,"Buildings & Water - Target $/cow",350,null,null,null,"Machinery - Target $/cow",750]
[null,{"$f":"IF(ROUND(SUM(E24:E39)/([1]Input!E13),0)<C41,\"(Under Invested by\",IF(ROUND(SUM(E24:E39)/([1]Input!E13),0)=C41,\"(On Target\",\"(Over Invested by\"))","v":"(Under Invested by"},{"$f":"\"$\"&TEXT(ABS((ROUND(SUM(E24:E39)/([1]Input!$E$13),2)-C41)*([1]Input!$E$13)),\"#,###\")&\")\"","v":"$24,900)"},null,null,null,{"$f":"IF(ROUND(SUM(J24:J39)/([1]Input!E13),0)<H41,\"(Under Invested by\",IF(ROUND(SUM(J24:J39)/([1]Input!E13),0)=H41,\"(On Target\",\"(Over Invested by\"))","v":"(Under Invested by"},{"$f":"\"$\"&TEXT(ABS((ROUND(SUM(J24:J39)/([1]Input!E13),2)-H41)*([1]Input!E13)),\"#,###\")&\")\"","v":"$112,500)"}]

{"sheet":"Breakeven","index":8,"n_rows":85,"n_cols":10,"rows_kept":85,"cut":false,"hidden":false,"merged":[[77,0,79,9],[1,0,1,9],[73,0,73,9],[75,0,76,9],[80,0,83,9]]}
[]
["Breakeven Calculations"]
[]
["    Cost per lb of gain sold (shrunk weight)"]
[null,"Feed Costs",null,null,null,{"$f":"Summary!F18","v":265.58000000000004},null,"feed cost"]
[null,null,null,null,"÷",{"$f":"ROUND((Input!$D$16-(Input!$D$16*Input!$D$20/100))-(Input!$D$14-(Input!$D$14*Input!$D$21/100)),0)","v":373},null,"lbs gained weight"]
[null,null,null,null,"=",{"$f":"F5/F6","v":0.71201072386058994},null,"/lb (gain sold)"]
[]
[null,"Operating Costs",null,null,null,{"$f":"Summary!F32","v":3981.24},null,"operating costs"]
[null,null,null,null,"-",{"$f":"Input!D64","v":3400},null,"feeder cost"]
[null,null,null,null,"÷",{"$f":"ROUND((Input!$D$16-(Input!$D$16*Input!$D$20/100))-(Input!$D$14-(Input!$D$14*Input!$D$21/100)),0)","v":373},null,"lbs gained weight"]
[null,null,null,null,"=",{"$f":"(F9-F10)/F11","v":1.5582841823056295},null,"/lb (gain sold)"]
[]
[null,"Operating & Labour Costs",null,null,null,{"$f":"Summary!F32+Summary!F39","v":4009.24},null,"operating costs"]
[null,null,null,null,"-",{"$f":"F10","v":3400},null,"feeder cost"]
[null,null,null,null,"÷",{"$f":"F11","v":373},null,"lbs gained weight"]
[null,null,null,null,"=",{"$f":"(F14-F15)/F16","v":1.6333512064343159},null,"/lb (gain sold)"]
[]
[null,"Operating & Fixed",null,null,null,{"$f":"Summary!F37","v":4018.9103693455554},null,"oper.  & fixed costs"]
[null,null,null,null,"-",{"$f":"Input!D64","v":3400},null,"feeder cost"]
[null,null,null,null,"÷",{"$f":"ROUND((Input!$D$16-(Input!$D$16*Input!$D$20/100))-(Input!$D$14-(Input!$D$14*Input!$D$21/100)),0)","v":373},null,"lbs gained weight"]
[null,null,null,null,"=",{"$f":"(F19-F20)/F21","v":1.6592771296127491},null,"/lb (gain sold)"]
[]
[null,"Total Costs",null,null,null,{"$f":"Summary!F40","v":4046.9103693455554},null,"total costs"]
[null,null,null,null,"-",{"$f":"Input!D64","v":3400},null,"feeder cost"]
[null,null,null,null,"÷",{"$f":"ROUND((Input!$D$16-(Input!$D$16*Input!$D$20/100))-(Input!$D$14-(Input!$D$14*Input!$D$21/100)),0)","v":373},null,"lbs gained weight"]
[null,null,null,null,"=",{"$f":"(F24-F25)/F26","v":1.7343441537414355},null,"/lb (gain sold)"]
["    Breakeven selling price (shrunk weight)"]
[null,"Operating Costs",null,null,null,{"$f":"Summary!F32","v":3981.24},null,"operating costs"]
[null,null,null,null,"÷",{"$f":"Input!$D$16-(Input!$D$16*Input!$D$20/100)","v":873},null,"lbs shrunk weight"]
[null,null,null,null,"=",{"$f":"F29/F30","v":4.5604123711340208},null,"/lb "]
[]
[null,"Operating & Labour Costs",null,null,null,{"$f":"Summary!F32+Summary!F39","v":4009.24},null,"operating & labour "]
[null,null,null,null,"÷",{"$f":"F30","v":873},null,"lbs shrunk weight"]
[null,null,null,null,"=",{"$f":"F33/F34","v":4.5924856815578465},null,"/lb "]
[]
[null,"Operating & Fixed",null,null,null,{"$f":"Summary!F37","v":4018.9103693455554},null,"oper. & fixed costs"]
[null,null,null,null,"÷",{"$f":"Input!$D$16-(Input!$D$16*Input!$D$20/100)","v":873},null,"lbs shrunk weight"]
[null,null,null,null,"=",{"$f":"F37/F38","v":4.6035628514840266},null,"/lb "]
[]
[null,"Total Costs",null,null,null,{"$f":"Summary!F40","v":4046.9103693455554},null,"total costs"]
[null,null,null,null,"÷",{"$f":"Input!$D$16-(Input!$D$16*Input!$D$20/100)","v":873},null,"lbs shrunk weight"]
[null,null,null,null,"=",{"$f":"F41/F42","v":4.6356361619078523},null,"/lb "]
[]
["    Breakeven purchase price (shrunk weight)"]
[null,"Operating Costs",null,null,null,{"$f":"Input!$D$16-(Input!$D$16*Input!$D$20/100)","v":873},null,"lbs shrunk weight"]
[null,null,null,null,"x",{"$f":"Input!$D$17","v":455},null,"$/cwt selling price"]
[null,null,null,null,"=",{"$f":"F46*F47/100","v":3972.15},null,"income"]
[null,null,null,null,"-",{"$f":"Summary!F32-Input!D64","v":581.23999999999978},null,"operating less feeder cost"]
[null,null,null,null,"÷",{"$f":"Input!$D$14","v":500},null,"lbs purchase weight"]
[null,null,null,null,"=",{"$f":"(F48-F49)/F50","v":6.7818200000000006},null,"/lb "]
[]
[null,"Operating & Labour Costs",null,null,null,{"$f":"F46","v":873},null,"lbs shrunk weight"]
[null,null,null,null,"x",{"$f":"F47","v":455},null,"$/cwt selling price"]
[null,null,null,null,"=",{"$f":"F48","v":3972.15},null,"income"]
[null,null,null,null,"-",{"$f":"(Summary!F32+Summary!F39)-Input!D64","v":609.23999999999978},null,"operating less feeder cost"]
[null,null,null,null,"÷",{"$f":"F50","v":500},null,"lbs purchase weight"]
[null,null,null,null,"=",{"$f":"(F55-F56)/F57","v":6.7258200000000006},null,"/lb "]
[]
[null,"Operating & Fixed",null,null,null,{"$f":"Input!$D$16-(Input!$D$16*Input!$D$20/100)","v":873},null,"lbs shrunk weight"]
[null,null,null,null,"x",{"$f":"Input!$D$17","v":455},null,"$/cwt selling price"]
[null,null,null,null,"=",{"$f":"F60*F61/100","v":3972.15},null,"income"]
[null,null,null,null,"-",{"$f":"Summary!F37-Input!D64","v":618.91036934555541},null,"op. & fixed less feeder cost"]
[null,null,null,null,"÷",{"$f":"Input!$D$14","v":500},null,"lbs purchase weight"]
[null,null,null,null,"=",{"$f":"(F62-F63)/F64","v":6.7064792613088891},null,"/lb "]
[]
[null,"Total Costs",null,null,null,{"$f":"Input!$D$16-(Input!$D$16*Input!$D$20/100)","v":873},null,"lbs shrunk weight"]
[null,null,null,null,"x",{"$f":"Input!$D$17","v":455},null,"$/cwt selling price"]
[null,null,null,null,"=",{"$f":"F67*F68/100","v":3972.15},null,"income"]
[null,null,null,null,"-",{"$f":"Summary!F40-Input!D64","v":646.91036934555541},null,"total less feeder cost"]
[null,null,null,null,"÷",{"$f":"Input!$D$14","v":500},null,"lbs purchase weight"]
[null,null,null,null,"=",{"$f":"(F69-F70)/F71","v":6.650479261308889},null,"/lb "]
[]
["Profitability and Breakeven Analysis:"]
[{"$f":"\"Gross Revenue =  Shrunk weight (lbs) x $/lb price (eg. \"&F46&\" x $\"&TEXT(F47/100,\"0.00\")&\"/lb = $\"&TEXT(F48,\"0.00\")&\")\"","v":"Gross Revenue =  Shrunk weight (lbs) x $/lb price (eg. 873 x $4.55/lb = $3972.15)"}]
[{"$f":"\"Return on Investment (ROI) = (Gross Revenue - Total Cost) / Total Cost \n(eg. ($\"&TEXT(Summary!F45,\"0.00\")&\" - $\"&TEXT(Summary!F40,\"0.00\")&\") / $\"&TEXT(Summary!F40,\"0.00\")&\" = \"&TEXT(100*Summary!F65,\"0.0\")&\"%\"","v":"Return on Investment (ROI) = (Gross Revenue - Total Cost) / Total Cost \n(eg. ($3972.15 - $4046.91) / $4046.91 = -1.8%"}]
[]
[{"$f":"\"Return on Asset (ROA) = (Margin Over Operating - Labour - Building Depreciation - Machinery Depreciation) / (Building, Machinery & Equipment Investment / Herd Size) (eg. ($\"&TEXT(Summary!H59,\"0.00\")&\" - $\"&TEXT(Summary!F39,\"0.00\")&\" - $\"&TEXT(Fixed!D13,\"0.00\")&\" - $\"&TEXT(Fixed!I13,\"0.00\")&\") / ($\"&TEXT(Fixed!D19,\"#,###\")&\" / \"&Input!D12&\") = \"&TEXT(100*Summary!F66,\"0.0\")&\"%\"","v":"Return on Asset (ROA) = (Margin Over Operating - Labour - Building Depreciation - Machinery Depreciation) / (Building, Machinery & Equipment Investment / Herd Size) (eg. ($-9.09 - $28.00 - $7.20 - $18.00) / ($192,600 / 500) = -16.2%"}]
[]
[]
[{"$f":"\"Yardage Cost Per Feeder Per Day =  ($\"&TEXT(Summary!F21,\"0.00\")&\" straw + $\"&TEXT(Summary!F23,\"0.00\")&\" fuel & repair + $\"&TEXT(Input!D163,\"0.00\")&\" building insurance + $\"&TEXT(Summary!F24,\"0.00\")&\" utilities + $\"&TEXT(Summary!F27,\"0.00\")&\" manure removal + $\"&TEXT(Fixed!D13,\"0.00\")&\" building depreciation+ $\"&TEXT(Fixed!I13,\"0.00\")&\" machinery depreciation + $\"&TEXT(Fixed!D12,\"0.00\")&\" building investment + $\"&TEXT(Fixed!I12,\"0.00\")&\" machinery investment + $\"&TEXT((((SUM(Summary!F21:F29)*(Input!D193/100)*(Input!B50/365)))),\"0.00\")&\" operating interest + $\"&TEXT(Summary!F28,\"0.00\")&\" misc. + $\"&TEXT(Summary!F39,\"0.00\")&\" labour) ÷ \"&Input!B50&\" days = $\"&TEXT(Summary!F64,\"0.000\")","v":"Yardage Cost Per Feeder Per Day =  ($22.40 straw + $10.06 fuel & repair + $1.54 building insurance + $3.45 utilities + $18.83 manure removal + $7.20 building depreciation+ $18.00 machinery depreciation + $4.34 building investment + $8.13 machinery investment + $5.70 operating interest + $1.20 misc. + $28.00 labour) ÷ 160 days = $0.805"}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"September, 2025"]

{"sheet":"Facilities","index":9,"n_rows":1,"n_cols":3,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,2,0,7]]}
[null,null,"Backgrounding Feedlot Facilities"]

{"sheet":"Chart data (HIDE)","index":10,"n_rows":41,"n_cols":13,"rows_kept":41,"cut":false,"hidden":true,"merged":[[26,12,28,17]]}
["2025 Beef Background Calves - Total Production Costs (cost/feeder)"]
["Feed Cost",{"$f":"Summary!F18","v":265.58000000000004},{"$f":"SUM(B2/$B$8)","v":6.5625372385736389E-2}]
["Feeder Cost",{"$f":"Summary!F20","v":3415.25},0.84391540417345501]
["Other Operating Cost",{"$f":"Summary!F32-Summary!F20-Summary!F18","v":300.40999999999974},7.4231938091720198E-2]
["Fixed Cost - Buildings",{"$f":"Summary!F34","v":11.537519772367105},2.8509452197808109E-3]
["Fixed Cost - Machinery",{"$f":"Summary!F35","v":26.132849573188324},6.457481680626989E-3]
["Labour",{"$f":"SUM(Summary!F39)","v":28},6.9188584486806941E-3]
[null,{"$f":"SUM(B2:B7)","v":4046.910369345555}]
[]
["2025 Beef Background Calves - Other Operating Costs (cost/feeder)"]
["Straw",{"$f":"Summary!F21","v":22.4}]
["Veterinary Medicine & Supplies",{"$f":"Summary!F22","v":26.24}]
["Fuel, Maintenance & Repairs",{"$f":"Summary!F23","v":10.059379999999999}]
["Utilities",{"$f":"Summary!F24","v":3.4548624000000001}]
["Feeder Selling Cost",{"$f":"Summary!F25","v":36.950000000000003}]
["Insurance",{"$f":"Summary!F26","v":1.64}]
["Manure Removal",{"$f":"Summary!F27","v":18.834479999999999}]
["Barn & Office Supplies",{"$f":"Summary!F28","v":1.2}]
["Death Loss",{"$f":"Summary!F29","v":71.8}]
["Operating Interest",{"$f":"Summary!F31","v":107.83}]
[null,{"$f":"SUM(B11:B20)","v":300.40872239999999}]
[]
[]
[{"$f":"\"2025 Beef Backgrounding - Costs Not Covered (\"&Input!D16&\" lb. steers)\"","v":"2025 Beef Backgrounding - Costs Not Covered (900 lb. steers)"}]
["Calf Price","Gross revenue",{"$f":"\"Operating Costs = $\"&ROUND(Summary!F32,0)","v":"Operating Costs = $3981"},{"$f":"\"Fixed Costs = $\"&ROUND(Summary!F36,0)","v":"Fixed Costs = $38"},{"$f":"\"Labour Cost = $\"&ROUND(Summary!F39,0)","v":"Labour Cost = $28"},"Total",null,null,{"$f":"C25","v":"Operating Costs = $3981"},{"$f":"D25","v":"Fixed Costs = $38"},{"$f":"A25","v":"Calf Price"}]
[]
[{"$f":"SUM(A28+$A$40)","v":545},{"$f":"SUM((A27/100)*(Input!$D$57+Input!$D$14))","v":4757.8500000000004},{"$f":"IF(Summary!$F$32-B27<0,0,SUM(Summary!$F$32-B27))","v":0},{"$f":"IF(Summary!$F$32+Summary!$F$36-B27<0,0,SUM(Summary!$F$32+Summary!$F$36-B27-C27))","v":0},{"$f":"IF(Summary!$F$32+Summary!$F$36+Summary!$F$39-B27<0,0,SUM(Summary!$F$32+Summary!$F$36+Summary!$F$39-B27-C27-D27))","v":0},{"$f":"SUM(C27:E27)","v":0},null,null,{"$f":"C27","v":0},0,{"$f":"A27","v":545},null,{"$f":"\"Market prices of $\"&ROUND(Summary!H53,0)&\"/cwt and lower do not cover both operating and fixed costs.  This can indicate the potential need for LPI coverage and is an important step in Risk Management Planning.\"","v":"Market prices of $460/cwt and lower do not cover both operating and fixed costs.  This can indicate the potential need for LPI coverage and is an important step in Risk Management Planning."}]
[{"$f":"SUM(A29+$A$40)","v":495},{"$f":"SUM((A28/100)*(Input!$D$57+Input!$D$14))","v":4321.3500000000004},{"$f":"IF(Summary!$F$32-B28<0,0,SUM(Summary!$F$32-B28))","v":0},{"$f":"IF(Summary!$F$32+Summary!$F$36-B28<0,0,SUM(Summary!$F$32+Summary!$F$36-B28-C28))","v":0},{"$f":"IF(Summary!$F$32+Summary!$F$36+Summary!$F$39-B28<0,0,SUM(Summary!$F$32+Summary!$F$36+Summary!$F$39-B28-C28-D28))","v":0},0,null,null,0,0,495]
[{"$f":"ROUND(Input!D17+A41,0)","v":445},{"$f":"SUM((A29/100)*(Input!$D$57+Input!$D$14))","v":3884.8500000000004},{"$f":"IF(Summary!$F$32-B29<0,0,SUM(Summary!$F$32-B29))","v":96.389999999999418},{"$f":"IF(Summary!$F$32+Summary!$F$36-B29<0,0,SUM(Summary!$F$32+Summary!$F$36-B29-C29))","v":37.670369345555628},{"$f":"IF(Summary!$F$32+Summary!$F$36+Summary!$F$39-B29<0,0,SUM(Summary!$F$32+Summary!$F$36+Summary!$F$39-B29-C29-D29))","v":28},162.06036934555505,null,null,96.389999999999418,37.670369345555628,445]
[{"$f":"SUM(A29-$A$40)","v":395},{"$f":"SUM((A30/100)*(Input!$D$57+Input!$D$14))","v":3448.3500000000004},{"$f":"IF(Summary!$F$32-B30<0,0,SUM(Summary!$F$32-B30))","v":532.88999999999942},{"$f":"IF(Summary!$F$32+Summary!$F$36-B30<0,0,SUM(Summary!$F$32+Summary!$F$36-B30-C30))","v":37.670369345555628},{"$f":"IF(Summary!$F$32+Summary!$F$36+Summary!$F$39-B30<0,0,SUM(Summary!$F$32+Summary!$F$36+Summary!$F$39-B30-C30-D30))","v":28},598.56036934555505,null,null,532.88999999999942,37.670369345555628,395]
[{"$f":"SUM(A30-$A$40)","v":345},{"$f":"SUM((A31/100)*(Input!$D$57+Input!$D$14))","v":3011.8500000000004},{"$f":"IF(Summary!$F$32-B31<0,0,SUM(Summary!$F$32-B31))","v":969.38999999999942},{"$f":"IF(Summary!$F$32+Summary!$F$36-B31<0,0,SUM(Summary!$F$32+Summary!$F$36-B31-C31))","v":37.670369345555628},{"$f":"IF(Summary!$F$32+Summary!$F$36+Summary!$F$39-B31<0,0,SUM(Summary!$F$32+Summary!$F$36+Summary!$F$39-B31-C31-D31))","v":28},1035.060369345555,null,null,969.38999999999942,37.670369345555628,345]
[295,{"$f":"SUM((A32/100)*(Input!$D$57+Input!$D$14))","v":2575.3500000000004},{"$f":"IF(Summary!$F$32-B32<0,0,SUM(Summary!$F$32-B32))","v":1405.8899999999994},{"$f":"IF(Summary!$F$32+Summary!$F$36-B32<0,0,SUM(Summary!$F$32+Summary!$F$36-B32-C32))","v":37.670369345555628},{"$f":"IF(Summary!$F$32+Summary!$F$36+Summary!$F$39-B32<0,0,SUM(Summary!$F$32+Summary!$F$36+Summary!$F$39-B32-C32-D32))","v":28},1471.560369345555,null,null,1405.8899999999994,37.670369345555628,295]
[245,{"$f":"SUM((A33/100)*(Input!$D$57+Input!$D$14))","v":2138.8500000000004},{"$f":"IF(Summary!$F$32-B33<0,0,SUM(Summary!$F$32-B33))","v":1842.3899999999994},{"$f":"IF(Summary!$F$32+Summary!$F$36-B33<0,0,SUM(Summary!$F$32+Summary!$F$36-B33-C33))","v":37.670369345555628},{"$f":"IF(Summary!$F$32+Summary!$F$36+Summary!$F$39-B33<0,0,SUM(Summary!$F$32+Summary!$F$36+Summary!$F$39-B33-C33-D33))","v":28},1908.060369345555,null,null,1842.3899999999994,37.670369345555628,245]
[195,{"$f":"SUM((A34/100)*(Input!$D$57+Input!$D$14))","v":1702.35},{"$f":"IF(Summary!$F$32-B34<0,0,SUM(Summary!$F$32-B34))","v":2278.89},{"$f":"IF(Summary!$F$32+Summary!$F$36-B34<0,0,SUM(Summary!$F$32+Summary!$F$36-B34-C34))","v":37.670369345555628},{"$f":"IF(Summary!$F$32+Summary!$F$36+Summary!$F$39-B34<0,0,SUM(Summary!$F$32+Summary!$F$36+Summary!$F$39-B34-C34-D34))","v":28},2344.5603693455555,null,null,2278.89,37.670369345555628,195]
[145,{"$f":"SUM((A35/100)*(Input!$D$57+Input!$D$14))","v":1265.8499999999999},{"$f":"IF(Summary!$F$32-B35<0,0,SUM(Summary!$F$32-B35))","v":2715.39},{"$f":"IF(Summary!$F$32+Summary!$F$36-B35<0,0,SUM(Summary!$F$32+Summary!$F$36-B35-C35))","v":37.670369345555628},{"$f":"IF(Summary!$F$32+Summary!$F$36+Summary!$F$39-B35<0,0,SUM(Summary!$F$32+Summary!$F$36+Summary!$F$39-B35-C35-D35))","v":28},2781.0603693455555,null,null,2715.39,37.670369345555628,145]
[95,{"$f":"SUM((A36/100)*(Input!$D$57+Input!$D$14))","v":829.34999999999991},{"$f":"IF(Summary!$F$32-B36<0,0,SUM(Summary!$F$32-B36))","v":3151.89},{"$f":"IF(Summary!$F$32+Summary!$F$36-B36<0,0,SUM(Summary!$F$32+Summary!$F$36-B36-C36))","v":37.670369345555628},{"$f":"IF(Summary!$F$32+Summary!$F$36+Summary!$F$39-B36<0,0,SUM(Summary!$F$32+Summary!$F$36+Summary!$F$39-B36-C36-D36))","v":28},3217.5603693455555,null,null,3151.89,37.670369345555628,95]
[45,{"$f":"SUM((A37/100)*(Input!$D$57+Input!$D$14))","v":392.85},{"$f":"IF(Summary!$F$32-B37<0,0,SUM(Summary!$F$32-B37))","v":3588.39},{"$f":"IF(Summary!$F$32+Summary!$F$36-B37<0,0,SUM(Summary!$F$32+Summary!$F$36-B37-C37))","v":37.670369345555628},{"$f":"IF(Summary!$F$32+Summary!$F$36+Summary!$F$39-B37<0,0,SUM(Summary!$F$32+Summary!$F$36+Summary!$F$39-B37-C37-D37))","v":28},3654.0603693455555,null,null,3588.39,37.670369345555628,45]
[-5,{"$f":"SUM((A38/100)*(Input!$D$57+Input!$D$14))","v":-43.650000000000006},{"$f":"IF(Summary!$F$32-B38<0,0,SUM(Summary!$F$32-B38))","v":4024.89},{"$f":"IF(Summary!$F$32+Summary!$F$36-B38<0,0,SUM(Summary!$F$32+Summary!$F$36-B38-C38))","v":37.670369345555628},{"$f":"IF(Summary!$F$32+Summary!$F$36+Summary!$F$39-B38<0,0,SUM(Summary!$F$32+Summary!$F$36+Summary!$F$39-B38-C38-D38))","v":28},4090.5603693455555,null,null,4024.89,37.670369345555628,-5]
[]
[50,"price change"]
[-10,"initial mod."]

{"sheet":"More...Breakeven (HIDE)","index":11,"n_rows":90,"n_cols":10,"rows_kept":90,"cut":false,"hidden":true,"merged":[[0,0,0,9],[14,0,14,9]]}
["Estimated Breakeven Canadian Dollar & US Futures Price Analysis*"]
["Feeder Selling Price (WLPIP insured value)",null,null,null,null,{"$f":"Input!D17","v":455},"  /cwt"]
["Estimated Feeder Cattle Basis (5 yr. Avg.) ",null,null,null,null,19.43,"  /cwt"]
["Canadian Dollar",null,null,null,null,0.755,"  /USD"]
["Estimated US Futures",null,null,null,null,123,"  /cwt"]
[]
[null,null,null,null,null,"Breakeven CDN  ",null,null,"Breakeven US"]
[null,null,null,null,null,{"$f":"\" Dollar @ $\"&F5&\"/cwt.\"","v":" Dollar @ $123/cwt."},null,null,{"$f":"\" Futures Price\"","v":" Futures Price"}]
[null,null,null,null,null,{"$f":"\"Est. US Futures Price\"","v":"Est. US Futures Price"},null,null,{"$f":"\"@ $\"&TEXT(F4,\"#.####\")&\" CDN Dollar.\"","v":"@ $.755 CDN Dollar."}]
["     Operating Costs",null,null,null,null,{"$f":"F26","v":0.25869072700745499},null,null,{"$f":"F64","v":358.98078402061856}]
["     Operating Costs & Labour",null,null,null,null,{"$f":"F36","v":0.25695739935440348},null,null,{"$f":"F71","v":361.40231895761741}]
["     Operating & Fixed Costs",null,null,null,null,{"$f":"F46","v":0.2563641433851217},null,null,{"$f":"F78","v":362.23864528704399}]
["     Total Costs",null,null,null,null,{"$f":"F56","v":0.25466175095658883},null,null,{"$f":"F85","v":364.66018022404285}]
[]
[" Breakeven Calculation Worksheet"]
[]
["    Breakeven Canadian Dollar (shrunk weight)"]
[null,"Operating Costs",null,null,null,{"$f":"F5","v":123},null,"Estimated US Futures"]
[null,null,null,null,"÷"]
[null,null,null,null,null,{"$f":"Summary!F32","v":3981.24},null,"operating costs"]
[null,null,null,null,"÷",{"$f":"Input!$D$16-(Input!$D$16*Input!$D$20/100)","v":873},null,"lbs shrunk weight"]
[null,null,null,null,"x",100,null,"cwt"]
[null,null,null,null,"+",{"$f":"F3","v":19.43},null,"basis"]
[null,null,null,null,"=",{"$f":"SUM((F20/F21)*F22)+F23","v":475.47123711340208},null,"/cwt cost"]
[]
[null,null,null,null,"=",{"$f":"SUM(F18/F24)","v":0.25869072700745499},null,"  /USD"]
[]
[null,"Operating & Labour Costs",null,null,null,{"$f":"F5","v":123},null,"Estimated US Futures"]
[null,null,null,null,"÷"]
[null,null,null,null,null,{"$f":"Summary!F32+Summary!F39","v":4009.24},null,"operating & labour "]
[null,null,null,null,"÷",{"$f":"Input!$D$16-(Input!$D$16*Input!$D$20/100)","v":873},null,"lbs shrunk weight"]
[null,null,null,null,"x",100,null,"cwt"]
[null,null,null,null,"+",{"$f":"F3","v":19.43},null,"basis"]
[null,null,null,null,"=",{"$f":"SUM((F30/F31)*F32)+F33","v":478.67856815578466},null,"/cwt cost"]
[]
[null,null,null,null,"=",{"$f":"SUM(F28/F34)","v":0.25695739935440348},null,"  /USD"]
[]
[null,"Operating & Fixed",null,null,null,{"$f":"F5","v":123},null,"Estimated US Futures"]
[null,null,null,null,"÷"]
[null,null,null,null,null,{"$f":"Summary!F37","v":4018.9103693455554},null,"oper. & fixed costs"]
[null,null,null,null,"÷",{"$f":"Input!$D$16-(Input!$D$16*Input!$D$20/100)","v":873},null,"lbs shrunk weight"]
[null,null,null,null,"x",100,null,"cwt"]
[null,null,null,null,"+",{"$f":"F23","v":19.43},null,"basis"]
[null,null,null,null,"=",{"$f":"SUM((F40/F41)*F42)+F43","v":479.78628514840267},null,"/cwt cost"]
[]
[null,null,null,null,"=",{"$f":"SUM(F38/F44)","v":0.2563641433851217},null,"  /USD"]
[]
[null,"Total Costs",null,null,null,{"$f":"F5","v":123},null,"Estimated US Futures"]
[null,null,null,null,"÷"]
[null,null,null,null,null,{"$f":"Summary!F40","v":4046.9103693455554},null,"total costs"]
[null,null,null,null,"÷",{"$f":"Input!$D$16-(Input!$D$16*Input!$D$20/100)","v":873},null,"lbs shrunk weight"]
[null,null,null,null,"x",100,null,"cwt"]
[null,null,null,null,"+",{"$f":"F33","v":19.43},null,"basis"]
[null,null,null,null,"=",{"$f":"SUM((F50/F51)*F52)+F53","v":482.99361619078525},null,"/cwt cost"]
[]
[null,null,null,null,"=",{"$f":"SUM(F48/F54)","v":0.25466175095658883},null,"  /USD"]
[]
["    Breakeven US Futures (shrunk weight)"]
[null,"Operating Costs",null,null,null,{"$f":"Summary!F32","v":3981.24},null,"operating costs"]
[null,null,null,null,"÷",{"$f":"Input!$D$16-(Input!$D$16*Input!$D$20/100)","v":873},null,"lbs shrunk weight"]
[null,null,null,null,"x",100,null,"cwt"]
[null,null,null,null,"+",{"$f":"F3","v":19.43},null,"basis"]
[null,null,null,null,"x",{"$f":"F4","v":0.755},null,"CDN Dollar value"]
[null,null,null,null,"=",{"$f":"SUM(((F59/F60)*F61)+F62)*F63","v":358.98078402061856},null,"/cwt (USD)"]
[]
[null,"Operating & Labour Costs",null,null,null,{"$f":"Summary!F32+Summary!F39","v":4009.24},null,"operating & labour "]
[null,null,null,null,"÷",{"$f":"Input!$D$16-(Input!$D$16*Input!$D$20/100)","v":873},null,"lbs shrunk weight"]
[null,null,null,null,"x",100,null,"cwt"]
[null,null,null,null,"+",{"$f":"F3","v":19.43},null,"basis"]
[null,null,null,null,"x",{"$f":"F4","v":0.755},null,"CDN Dollar value"]
[null,null,null,null,"=",{"$f":"SUM(((F66/F67)*F68)+F69)*F70","v":361.40231895761741},null,"/cwt (USD)"]
[]
[null,"Operating & Fixed",null,null,null,{"$f":"Summary!F37","v":4018.9103693455554},null,"oper. & fixed costs"]
[null,null,null,null,"÷",{"$f":"Input!$D$16-(Input!$D$16*Input!$D$20/100)","v":873},null,"lbs shrunk weight"]
[null,null,null,null,"x",100,null,"cwt"]
[null,null,null,null,"+",{"$f":"F3","v":19.43},null,"basis"]
[null,null,null,null,"x",{"$f":"F4","v":0.755},null,"CDN Dollar value"]
[null,null,null,null,"=",{"$f":"SUM(((F73/F74)*F75)+F76)*F77","v":362.23864528704399},null,"/cwt (USD)"]
[]
[null,"Total Costs",null,null,null,{"$f":"Summary!F40","v":4046.9103693455554},null,"oper. & fixed costs"]
[null,null,null,null,"÷",{"$f":"Input!$D$16-(Input!$D$16*Input!$D$20/100)","v":873},null,"lbs shrunk weight"]
[null,null,null,null,"x",100,null,"cwt"]
[null,null,null,null,"+",{"$f":"F3","v":19.43},null,"basis"]
[null,null,null,null,"x",{"$f":"F4","v":0.755},null,"CDN Dollar value"]
[null,null,null,null,"=",{"$f":"SUM(((F80/F81)*F82)+F83)*F84","v":364.66018022404285},null,"/cwt (USD)"]
[]
["Created and maintained by ",null,null,null,null,null,null,null,null,"September, 2016"]
["For more information, contact your local "]
["Benjamin Hamm",null,null,null,"Roy Arnott"]
["Farm Management Specialist         ",null,null,null,"Farm Management Specialist         "]