{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Introduction","Summary","Risk Analysis","Charts","Input","Feed Rations","Ration Data","Details","Breakeven","Facilities","Chart data (HIDE)","More...Breakeven (HIDE)"],"not_rendered":{"charts":3,"images":4,"macros":1,"external_links":0,"defined_names":76,"comments":2,"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, 2023"]
[]
[]
[]
[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":71,"n_cols":10,"rows_kept":71,"cut":false,"hidden":false,"merged":[[0,0,0,9],[70,0,70,9],[1,0,1,9]]}
[{"$f":"\"Backgrounding Cattle Production Cost Summary -  \"&Introduction!J11","v":"Backgrounding Cattle Production Cost Summary -  September, 2023"}]
[{"$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!A43&\" (\"&Input!E43*100&\" % TDN, \"&Input!G43*100&\" % CP)\"","v":"    1.01  Alfalfa Grass Hay (57.8 % TDN, 13.7 % CP)"},null,null,null,null,{"$f":"Details!F18","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!A44&\" (\"&Input!E44*100&\" % TDN, \"&Input!G44*100&\" % CP)\"","v":"    1.02  Corn Silage (65.2 % TDN, 8.7 % CP)"},null,null,null,null,{"$f":"Details!F23","v":91.77},null,{"$f":"IF(Input!$C$24=\"Barley Silage\",'Feed Rations'!$L10,IF(Input!$C$24=\"Corn Silage\",'Feed Rations'!L28,'Feed Rations'!L46))","v":44910}]
[{"$f":"\"    1.03  \"&Input!A45&\" (\"&Input!E45*100&\" % TDN, \"&Input!G45*100&\" % CP)\"","v":"    1.03  Barley Silage (63 % TDN, 11 % CP)"},null,null,null,null,{"$f":"Details!F28","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!A46&\" (\"&Input!E46*100&\" % TDN, \"&Input!G46*100&\" % CP)\"","v":"    1.04  Barley Grain (83.1 % TDN, 12.5 % CP)"},null,null,null,null,{"$f":"Details!F33","v":106.6},null,{"$f":"IF(Input!$C$24=\"Barley Silage\",'Feed Rations'!$L12,IF(Input!$C$24=\"Corn Silage\",'Feed Rations'!L30,'Feed Rations'!L48))","v":53387.5}]
[{"$f":"\"    1.05  \"&Input!A47","v":"    1.05  Greenfeed"},null,null,null,null,{"$f":"Details!F38","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!A48","v":"    1.06  Straw"},null,null,null,null,{"$f":"Details!F43","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!A49&\" (\"&ROUND(Input!E49*100,1)&\"%TDN, \"&Input!G49*100&\"%CP)\"","v":"    1.07  32-20% Feedlot Suppl. (61.7%TDN, 35.6%CP)"},null,null,null,null,{"$f":"Details!F48","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!A50&\" (\"&Input!E50*100&\" % TDN, \"&Input!G50*100&\" % CP)\"","v":"    1.08  DDGS Corn/Wheat (77 % TDN, 33.9 % CP)"},null,null,null,null,{"$f":"Details!F53","v":20.67},null,{"$f":"IF(Input!$C$24=\"Barley Silage\",'Feed Rations'!$L16,IF(Input!$C$24=\"Corn Silage\",'Feed Rations'!L34,'Feed Rations'!L52))","v":10500}]
[{"$f":"\"    1.09  \"&Input!A51","v":"    1.09  1:1 Premix"},null,null,null,null,{"$f":"Details!F58","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!A52","v":"    1.10  2:1 Premix"},null,null,null,null,{"$f":"Details!F63","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!A53","v":"    1.11  Limestone"},null,null,null,null,{"$f":"Details!F68","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!A54","v":"    1.12  Other"},null,null,null,null,{"$f":"Details!F73","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":313.04999999999995},null,{"$f":"SUM(H6:H16)","v":155857.5}]
["2.  Other Operating Costs"]
["    2.01  Feeder Cost",null,null,null,null,{"$f":"Details!F90","v":1965.25},null,{"$f":"ROUND(F20*Input!$D$12,0)","v":982625}]
["    2.02  Straw",null,null,null,null,{"$f":"Details!F96","v":22.4},null,{"$f":"ROUND(F21*Input!$D$12,0)","v":11200}]
["    2.03  Veterinary Medicine & Supplies",null,null,null,null,{"$f":"Details!F122","v":25.76},null,{"$f":"ROUND(F22*Input!$D$12,0)","v":12880}]
["    2.04  Annual Fuel & Repair Costs",null,null,null,null,{"$f":"Details!F148","v":10.826879999999999},null,{"$f":"ROUND(F23*Input!$D$12,0)","v":5413}]
["    2.05  Utilities",null,null,null,null,{"$f":"Details!F153","v":3.39},null,{"$f":"ROUND(F24*Input!$D$12,0)","v":1695}]
["    2.06  Feeder Selling Cost",null,null,null,null,{"$f":"Details!F170","v":34.950000000000003},null,{"$f":"ROUND(F25*Input!$D$12,0)","v":17475}]
["    2.07  Insurance",null,null,null,null,{"$f":"Details!F189","v":1.64},null,{"$f":"ROUND(F26*Input!$D$12,0)","v":820}]
["    2.08  Manure Removal",null,null,null,null,{"$f":"Details!F198","v":18.834479999999999},null,{"$f":"ROUND(F27*Input!$D$12,0)","v":9417}]
["    2.09  Barn & Office Supplies",null,null,null,null,{"$f":"Details!F203","v":1.2},null,{"$f":"ROUND(F28*Input!$D$12,0)","v":600}]
["    2.10  Death Loss",null,null,null,null,{"$f":"Details!F211","v":43.28},null,{"$f":"ROUND(F29*Input!$D$12,0)","v":21640}]
["Subtotal Operating Costs",null,null,null,null,{"$f":"ROUND(SUM(F18:F29),2)","v":2440.58},null,{"$f":"SUM(H18:H29)","v":1219622.5}]
["    2.11  Operating Interest",null,null,null,null,{"$f":"Details!F221","v":86.91},null,{"$f":"ROUND(F31*Input!$D$12,0)","v":43455}]
["    Total Operating Costs",null,null,null,null,{"$f":"F30+F31","v":2527.4899999999998},null,{"$f":"H30+H31","v":1263077.5}]
["B.  Fixed Costs"]
["3.  Depreciation"]
["    3.01  Buildings",null,null,null,null,{"$f":"Details!F254","v":7.21},null,{"$f":"F35*Input!D12","v":3605}]
["    3.02  Machinery & Equipment",null,null,null,null,{"$f":"Details!F261","v":18},null,{"$f":"F36*Input!D12","v":9000}]
["4.  Investment",null,null,null,null,"",null,""]
["    4.01  Buildings",null,null,null,null,{"$f":"Details!F271","v":3.52},null,{"$f":"F38*Input!D12","v":1760}]
["    4.02  Machinery & Equipment",null,null,null,null,{"$f":"Details!F279","v":5.4},null,{"$f":"F39*Input!D12","v":2700}]
["Total Fixed Costs",null,null,null,null,{"$f":"SUM(F35:F39)","v":34.130000000000003},null,{"$f":"F40*Input!D12","v":17065}]
["Total Operating and Fixed Costs",null,null,null,null,{"$f":"SUM(F32+F40)","v":2561.62},null,{"$f":"H32+H40","v":1280142.5}]
[]
["C.  Owners - Labour & Living",null,null,null,null,{"$f":"Details!F284","v":27},null,{"$f":"F43*Input!D12","v":13500}]
["Total Cost of Production",null,null,null,null,{"$f":"F41+F43","v":2588.62},null,{"$f":"H41+H43","v":1293642.5}]
[]
[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 @ $330/cwt market price"},null,null,null,null,{"$f":"Breakeven!F48","v":2880.9},null,{"$f":"ROUND(F49*Input!D12,0)","v":1440450}]
[]
[]
[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":"$330/cwt market price"},null,{"$f":"\"$\"&Input!D15&\"/cwt feeder price\"","v":"$390/cwt feeder price"}]
["     Operating Costs",null,null,null,null,{"$f":"Breakeven!F51*100","v":460.68200000000007},null,{"$f":"Breakeven!F31*100","v":289.51775486827034}]
["     Operating Costs & Labour",null,null,null,null,{"$f":"Breakeven!F58*100","v":455.28200000000004},null,{"$f":"Breakeven!F35*100","v":292.61053837342496}]
["     Operating & Fixed Costs",null,null,null,null,{"$f":"Breakeven!F65*100","v":453.85600000000005},null,{"$f":"Breakeven!F39*100","v":293.42726231386024}]
["     Total Costs",null,null,null,null,{"$f":"Breakeven!F72*100","v":448.45600000000002},null,{"$f":"Breakeven!F43*100","v":296.52004581901485}]
[]
[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":"@ $330/cwt market price"}]
["     Feed Costs",null,null,null,null,{"$f":"Breakeven!F7*100","v":83.927613941018748},null,{"$f":"F49-F20-F18","v":602.60000000000014}]
["     Operating Costs",null,null,null,null,{"$f":"Breakeven!F12*100","v":154.82305630026804},null,{"$f":"Breakeven!F48-F32","v":353.41000000000031}]
["     Operating Costs & Labour",null,null,null,null,{"$f":"Breakeven!F17*100","v":162.06166219839136},null,{"$f":"Breakeven!F55-(F32+F43)","v":326.41000000000031}]
["     Operating & Fixed Costs",null,null,null,null,{"$f":"Breakeven!F22*100","v":163.97319034852543},null,{"$f":"Breakeven!F62-(F32+F40)","v":319.2800000000002}]
["     Total Costs",null,null,null,null,{"$f":"Breakeven!F27*100","v":171.21179624664876},null,{"$f":"Breakeven!F69-F44","v":292.2800000000002}]
[]
["Return on Investment (ROI)",null,null,null,null,{"$f":"(F49-F44)/F44","v":0.11290958116679937}]
["Estimated Return on Asset (ROA)",null,null,null,null,{"$f":"((F49-F32-F43-F35-F36)/(Input!D156/Input!D12))","v":0.78193146417445569}]
[]
["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":313.04999999999995}]
[null,"Feeder Cost",{"$f":"Summary!F20","v":1965.25}]
[null,"Other Operating Costs",{"$f":"SUM(Summary!F32-Summary!F20-Summary!F18)","v":249.18999999999983}]
[null,"Subtotal",{"$f":"SUM(C3:C5)","v":2527.4899999999998}]
["B.  Fixed Costs",null,{"$f":"Summary!F40","v":34.130000000000003}]
["C.  Labour",null,{"$f":"Summary!F43","v":27}]
["Total Costs",null,{"$f":"SUM(C6:C8)","v":2588.62}]
[]
["Estimated Farmgate"]
[null,"Price ($ per cwt)",{"$f":"Input!D17","v":330}]
[]
[]
[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":297}]
[null,"Feed Cost",{"$f":"SUM(C3+(C3*C16))","v":328.70249999999993}]
[null,"Feeder Cost",{"$f":"SUM(C4+(C4*C17))","v":2063.5124999999998}]
[]
[{"$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":2641.4049999999997}]
[null,"Total Costs",{"$f":"C7+C8+C26","v":2702.5349999999999}]
[null,"Gross Revenue / feeder",{"$f":"(Breakeven!F46/100)*'Risk Analysis'!C21","v":2592.81}]
[null,"Marginal Returns "]
[null,"   Over Operating Costs",{"$f":"SUM(C28-C26)","v":-48.5949999999998}]
[null,"   Over Operating & Labour Costs",{"$f":"SUM(C28-C26-C8)","v":-75.5949999999998}]
[null,"   Over Total Costs (Net Profit)",{"$f":"SUM(C28-C27)","v":-109.72499999999991}]
[]
[null,"Operating Expense Ratio",{"$f":"SUM(C26/C28)","v":1.0187422140457649}]
[]
["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.7500 Cdn per USD"}]
[null,null,{"$f":"SUM($E$39-10)","v":320},{"$f":"SUM($E$39-5)","v":325},{"$f":"Input!D17","v":330},{"$f":"SUM($E$39+5)","v":335},{"$f":"SUM($E$39+10)","v":340}]
["Breakeven CDN Dollar ($1 Cdn = $ USD)"]
[null,"Operating Costs",{"$f":"SUM((C39/100)*Breakeven!$F$46*Input!$D$18)/Summary!$F$32","v":0.82896470411356737},{"$f":"SUM((D39/100)*Breakeven!$F$46*Input!$D$18)/Summary!$F$32","v":0.84191727761534174},{"$f":"SUM((E39/100)*Breakeven!$F$46*Input!$D$18)/Summary!$F$32","v":0.85486985111711611},{"$f":"SUM((F39/100)*Breakeven!$F$46*Input!$D$18)/Summary!$F$32","v":0.86782242461889092},{"$f":"SUM((G39/100)*Breakeven!$F$46*Input!$D$18)/Summary!$F$32","v":0.88077499812066506}]
[null,"Operating & Labour Costs",{"$f":"SUM((C39/100)*Breakeven!$F$46*Input!$D$18)/(Summary!$F$32+Summary!$F$43)","v":0.82020285849621666},{"$f":"SUM((D39/100)*Breakeven!$F$46*Input!$D$18)/(Summary!$F$32+Summary!$F$43)","v":0.83301852816021993},{"$f":"SUM((E39/100)*Breakeven!$F$46*Input!$D$18)/(Summary!$F$32+Summary!$F$43)","v":0.8458341978242232},{"$f":"SUM((F39/100)*Breakeven!$F$46*Input!$D$18)/(Summary!$F$32+Summary!$F$43)","v":0.8586498674882268},{"$f":"SUM((G39/100)*Breakeven!$F$46*Input!$D$18)/(Summary!$F$32+Summary!$F$43)","v":0.87146553715222996}]
[null,"Operating, Fixed & Labour Costs",{"$f":"SUM((C39/100)*Breakeven!$F$46*Input!$D$18)/Summary!$F$44","v":0.80938878630312694},{"$f":"SUM((D39/100)*Breakeven!$F$46*Input!$D$18)/Summary!$F$44","v":0.82203548608911314},{"$f":"SUM((E39/100)*Breakeven!$F$46*Input!$D$18)/Summary!$F$44","v":0.83468218587509946},{"$f":"SUM((F39/100)*Breakeven!$F$46*Input!$D$18)/Summary!$F$44","v":0.847328885661086},{"$f":"SUM((G39/100)*Breakeven!$F$46*Input!$D$18)/Summary!$F$44","v":0.85997558544707209}]
[]
[{"$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!F44,\"0.00\")&\") = $\"&TEXT(E43,\"0.0000\")","v":"   (eg. ($3.30 x 873 lbs x $0.7500) / $2588.62) = $0.8347"}]
[]
["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":161,"n_cols":12,"rows_kept":161,"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,390,"  /cwt"]
["Finish Weight (Maximum 900 lbs.)",null,null,900,"  lbs"]
["Feeder Selling Price (WLPIP insured value)",null,null,330,"  /cwt"]
["$1 Canadian Dollar",null,{"$f":"\"($\"&TEXT(1/D18,\"#.####\")&\" CDN )\"","v":"($1.3333 CDN )"},0.75,"/ $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,"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(B28>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.6669100000000001}]
["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(B29>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.90228}]
["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(B30>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":2.0470750000000004}]
["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(B31>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":2.2143049999999995}]
["TOTAL",{"$f":"SUM(B28:B31,0)","v":160}]
[]
["Total Feed Cost per Steer",null,null,{"$f":"IF(B32>0,IF(Input!$C$24=\"Barley Silage\",'Feed Rations'!J21,IF(Input!$C$24=\"Corn Silage\",'Feed Rations'!J39,'Feed Rations'!J57)),0)","v":313.04100000000005},"/head"]
["Average Feed Cost per Day",null,null,{"$f":"SUM(D34/B32)","v":1.9565062500000003}]
["Feed Cost per lb. of Gain Sold (shrunk weight)",null,null,{"$f":"(D34/ROUND((Input!$D$16-(Input!$D$16*Input!$D$20/100))-(Input!$D$14-(Input!$D$14*Input!$D$21/100)),0))","v":0.83925201072386069}]
[]
["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,""]
[null,null,null,null,"(Analysis Assumed)"]
["Feed Costs","$/unit","lbs/Unit","$/lb","TDN",null,"CP"]
["Alfalfa Grass Hay",120,2000,{"$f":"ROUND(B43/C43,3)","v":0.06},0.57799999999999996,null,0.13700000000000001]
["Corn Silage",45,2000,{"$f":"ROUND(B44/C44,3)","v":2.3E-2},0.65200000000000002,null,8.6999999999999994E-2]
["Barley Silage",55,2000,2.8000000000000001E-2,0.63,null,0.11]
["Barley Grain",6.25,48,0.13,0.83099999999999996,null,0.125]
["Greenfeed",120,2000,{"$f":"ROUND(B47/C47,3)","v":0.06}]
["Straw",70,2000,{"$f":"ROUND(B48/C48,3)","v":3.5000000000000003E-2}]
["32-20% Feedlot Suppl.",500,2205,0.22700000000000001,0.61650000000000005,null,0.35599999999999998]
["DDGS Corn/Wheat",350,2205,0.159,0.77,null,0.33900000000000002]
["1:1 Premix",50,55,0.90900000000000003]
["2:1 Premix",50,55,0.90900000000000003]
["Limestone",20,55,0.36399999999999999]
["Other",0,2000,{"$f":"ROUND(B54/C54,3)","v":0}]
[]
["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,""]
[]
["Other Operating Costs",null,null,null,null,null,""]
[]
["  Feeder Purchase Costs"]
["     Buying Commission",null,null,5,"/head"]
["     Trucking-in ",null,null,1.7,"/cwt"]
["     Insurance fee ",null,null,1.75,"/head"]
[]
["  Straw Bedding",null,"","",null,null,""]
["     lbs/day",null,"",4,"/head",null,""]
["     cost",null,"",70,"/ton",null,""]
[]
["  Veterinary Medicine & Supplies",null,null,"","",null,""]
["   Cattle Medication",null,"","",null,null,""]
["     IBR,BVD,PI3,BRSV, Pasteurella",null,null,5,"/head"]
["     Vitamin A-D",null,null,0.5,"/head"]
["     External & Internal Parasites",null,null,0.72,"/head"]
["     Blackleg & Haemophilus",null,null,1.26,"/head"]
["     Growth Implants",null,null,2,"/head"]
["     Antibiotics",null,null,15,"/head"]
[]
["   Herd Health Program",null,"","",""]
["     Professional Services",null,"","",""]
["       Total Yearly Hours",null,null,3,"hours"]
["       Rate",null,null,160,"/hour"]
["     Transportation",null,null,""]
["       Total Kilometres (round trip)",null,null,80,"km"]
["       Rate",null,null,1,"/km"]
["       Number of Yearly Visits",null,null,2]
[]
["   Annual Fuel & Repair Costs"]
["   a)  Machinery Fuel Costs - Winter Feeding"]
["              Tractor with Loader PTO hp",null,null,120]
["              Diesel Fuel Cost",null,null,1.4,"/litre"]
["              Tractor Hours Per Day (average)",null,null,1.5,"hours"]
["   b) Machinery Repair (% of investment cost)",null,null,1.2,"%"]
["   c) Building  maintenance (% of investment cost)",null,null,2.2000000000000002,"%"]
["",null,"","",null,null,""]
["  Utilities",null,null,null,""]
["          Hydro - Rate",null,null,9.3240000000000003E-2,"/ kWh"]
[12,"kWh per feeder",null,{"$f":"SUM(A99*D12*D98)","v":559.44000000000005}]
[2,"1000 watt waterer",null,{"$f":"SUM(A100*18)*(B32)*D98","v":537.06240000000003}]
[null,null,"Total Hydro",{"$f":"SUM(D99:D100)","v":1096.5024000000001}]
["          Telephone",null,null,600]
[]
["  Trucking Cost",null,null,null,""]
["     Average Weight",null,null,{"$f":"D16","v":900},"lbs/head"]
["     Distance",null,null,75,"miles"]
["     Rate",null,null,7,"/loaded mile"]
["     Truck Capacity",null,null,54000,"lbs/load"]
["     Number of head per load - calves",null,null,{"$f":"D108/D105","v":60},"per load"]
[]
["  Marketing Cost",null,null,null,""]
["     MBP/NCO Levy $/Head ",null,null,5.5,"/head"]
["     Commission on Sales",null,null,20,"/head"]
["     Market Value ",null,"",{"$f":"D17","v":330},"/cwt"]
[]
[]
["  Manure Removal"]
["   Manure volume produced",null,null,2.4E-2,"m3/feeder/day"]
["   Manure volume shrinkage",null,null,75,"%"]
["   Cost for manure removal & application",null,null,15,"/cubic yard"]
[]
[]
["  Insurance"]
["     Cost per $100 Capital Invested in"]
["       a) Livestock",null,null,0,"/$100"]
["       b) Building & Equipment",null,null,0.4,"/$100"]
["     Additional Coverage for Liability",null,null,49,"/year"]
[]
["  Barn & Office Supplies"]
["     Total yearly expense relating to barn",null,null,600]
[null,null,null,null,null,null,null,""]
["  Operating Interest Rate",null,null,9,"%"]
["  Investment Interest Rate",null,null,4,"%"]
[null,null,null,null,null,null,null,""]
["FOOTNOTE:  cwt = hundred-weight = 100 lbs",null,null,null,null,null,null,""]
[]
["Capital Costs",null,null,"Original","Salvage",null,"Useful"]
[null,null,null,"Value","Value",null,"Life"]
["  Buildings,Corrals & Water System",null,null,""]
["     Windbreak fence",null,null,6300,10,"%",20,"years"]
["     Pens",null,null,5300,10,"%",20,"years"]
["     Handling Facilities",null,null,7500,10,"%",20,"years"]
["     Waterers",null,null,6000,10,"%",20,"years"]
["     Gates",null,null,2000,10,"%",20,"years"]
["     Feeders",null,null,1500,10,"%",20,"years"]
["     Bunk Feeders",null,null,21000,10,"%",20,"years"]
["     Well & Pressure System",null,null,8000,10,"%",20,"years"]
["     Grain Bin",null,null,5000,10,"%",20,"years"]
["     Landscaping",null,null,17500,10,"%",20,"years"]
["     Total",null,null,{"$f":"SUM(D140:D149)","v":80100}]
[]
["  Machinery & Equipment",null,null,"","",null,""]
[{"$f":"\"     Tractors & Loader ($\"&TEXT(J153,\"#,###\")&\" @ \"&K153&\"%)\"","v":"     Tractors & Loader ($175,000 @ 30%)"},null,null,{"$f":"SUM(J153*(K153/100))","v":52500},20,"%",10,"years",null,175000,30,"%"]
["     Miscellaneous",null,null,60000,20,"%",10,"years"]
[null,null,null,null,null,null,""]
["  Total Investment",null,null,{"$f":"D150+D153+D154","v":192600}]
[null,null,null,null,null,null,null,""]
["Labour Costs",null,null,null,"Total"]
[]
["  Hours/Head",null,null,null,1,"hours"]
["  Labour Rate",null,null,null,27,"/hour"]

{"sheet":"Feed Rations","index":5,"n_rows":66,"n_cols":12,"rows_kept":66,"cut":false,"hidden":false,"merged":[[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],[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]]}
["Feed Costs & Requirements Worksheet"]
[]
[{"$f":"\"Total Days on Feed = \"&Input!B32&\" 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!B28","v":40},{"$f":"Input!B29","v":40},{"$f":"Input!B30","v":40},{"$f":"Input!B31","v":40}]
["Feed Name","$/unit","lbs/Unit","$/lb","As Fed Lbs/Head/Day"]
[{"$f":"Input!A43","v":"Alfalfa Grass Hay"},{"$f":"Input!B43","v":120},{"$f":"Input!C43","v":2000},{"$f":"Input!D43","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!A44","v":"Corn Silage"},{"$f":"Input!B44","v":45},{"$f":"Input!C44","v":2000},{"$f":"Input!D44","v":2.3E-2},{"$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!A45","v":"Barley Silage"},{"$f":"Input!B45","v":55},{"$f":"Input!C45","v":2000},{"$f":"Input!D45","v":2.8000000000000001E-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,123.76,{"$f":"ROUNDUP((I11*Input!$D$12)/C11,0)","v":1105},60775]
[{"$f":"Input!A46","v":"Barley Grain"},{"$f":"Input!B46","v":6.25},{"$f":"Input!C46","v":48},{"$f":"Input!D46","v":0.13},{"$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,135.20000000000002,{"$f":"ROUNDUP((I12*Input!$D$12)/C12,0)","v":10834},67712.5]
[{"$f":"Input!A47","v":"Greenfeed"},{"$f":"Input!B47","v":120},{"$f":"Input!C47","v":2000},{"$f":"Input!D47","v":0.06},{"$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!A48","v":"Straw"},{"$f":"Input!B48","v":70},{"$f":"Input!C48","v":2000},{"$f":"Input!D48","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!A49","v":"32-20% Feedlot Suppl."},{"$f":"Input!B49","v":500},{"$f":"Input!C49","v":2205},{"$f":"Input!D49","v":0.22700000000000001},{"$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!A50","v":"DDGS Corn/Wheat"},{"$f":"Input!B50","v":350},{"$f":"Input!C50","v":2205},{"$f":"Input!D50","v":0.159},{"$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!A51","v":"1:1 Premix"},{"$f":"Input!B51","v":50},{"$f":"Input!C51","v":55},{"$f":"Input!D51","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!A52","v":"2:1 Premix"},{"$f":"Input!B52","v":50},{"$f":"Input!C52","v":55},{"$f":"Input!D52","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!A53","v":"Limestone"},{"$f":"Input!B53","v":20},{"$f":"Input!C53","v":55},{"$f":"Input!D53","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!A54","v":"Other"},{"$f":"Input!B54","v":0},{"$f":"Input!C54","v":2000},{"$f":"Input!D54","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.7230900000000002},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!C19,IF(Input!$D$23=2,'Ration Data'!K19,'Ration Data'!S19))","v":1.9573700000000001},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!D19,IF(Input!$D$23=2,'Ration Data'!L19,'Ration Data'!T19))","v":2.1917399999999998},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!E19,IF(Input!$D$23=2,'Ration Data'!M19,'Ration Data'!U19))","v":2.4082000000000003},null,{"$f":"SUM(J9:J20)","v":331.43400000000003},null,{"$f":"SUM(L9:L20)","v":164777.5}]
[]
["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!A44","v":"Corn Silage"},45,2000,2.3E-2,{"$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":91.77},{"$f":"ROUNDUP((I28*Input!$D$12)/C28,0)","v":998},{"$f":"SUM(K28*B28)","v":44910}]
[{"$f":"Input!A45","v":"Barley Silage"},55,2000,2.8000000000000001E-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!A46","v":"Barley Grain"},6.25,48,0.13,{"$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,106.60000000000001,{"$f":"ROUNDUP((I30*Input!$D$12)/C30,0)","v":8542},53387.5]
[{"$f":"Input!A47","v":"Greenfeed"},120,2000,0.06,{"$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!A48","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!A49","v":"32-20% Feedlot Suppl."},{"$f":"B15","v":500},2205,0.22700000000000001,{"$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!A50","v":"DDGS Corn/Wheat"},350,2205,0.159,{"$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,20.67,{"$f":"ROUNDUP((I34*Input!$D$12)/C34,0)","v":30},10500]
[{"$f":"Input!A51","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!A52","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!A53","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!A54","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.6669100000000001},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!C36,IF(Input!$D$23=2,'Ration Data'!K36,'Ration Data'!S36))","v":1.90228},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!D36,IF(Input!$D$23=2,'Ration Data'!L36,'Ration Data'!T36))","v":2.0470750000000004},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!E36,IF(Input!$D$23=2,'Ration Data'!M36,'Ration Data'!U36))","v":2.2143049999999995},null,{"$f":"SUM(J27:J38)","v":313.04100000000005},null,{"$f":"SUM(L27:L38)","v":155857.5}]
[]
["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!A43","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!A44","v":"Corn Silage"},45,2000,2.3E-2,{"$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!A45","v":"Barley Silage"},55,2000,2.8000000000000001E-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!A46","v":"Barley Grain"},6.25,48,0.13,{"$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,171.34,{"$f":"ROUNDUP((I48*Input!$D$12)/C48,0)","v":13730},85812.5]
[{"$f":"Input!A47","v":"Greenfeed"},120,2000,0.06,{"$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!A48","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!A49","v":"32-20% Feedlot Suppl."},{"$f":"B15","v":500},2205,0.22700000000000001,{"$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!A50","v":"DDGS Corn/Wheat"},350,2205,0.159,{"$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!A51","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!A52","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!A53","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!A54","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.7797499999999999},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!C53,IF(Input!$D$23=2,'Ration Data'!K53,'Ration Data'!S53))","v":2.00943},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!D53,IF(Input!$D$23=2,'Ration Data'!L53,'Ration Data'!T53))","v":2.2527900000000001},{"$f":"IF(Input!$D$23=1.5,'Ration Data'!E53,IF(Input!$D$23=2,'Ration Data'!M53,'Ration Data'!U53))","v":2.4609699999999997},null,{"$f":"SUM(J45:J56)","v":339.75400000000002},null,{"$f":"SUM(L45:L56)","v":170122.5}]
[]
[{"$f":"\"Feed Summary - \"&Input!B32&\" 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":331.43400000000003},null,null,{"$f":"E61/Input!$B$32","v":2.0714625},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.88856300268096522}]
[{"$f":"A23","v":"Corn Silage Ration"},null,null,null,{"$f":"J39","v":313.04100000000005},null,null,{"$f":"E62/Input!$B$32","v":1.9565062500000003},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.83925201072386069}]
[{"$f":"A41","v":"Alfalfa Grass Hay Ration"},null,null,null,{"$f":"J57","v":339.75400000000002},null,null,{"$f":"E63/Input!$B$32","v":2.1234625},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.91086863270777485}]
[]
[]
["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":[[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],[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],[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]]}
[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!A43","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!D43)","v":71.08874999999999},null,{"$f":"Input!A43","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!D43)","v":31.5},null,{"$f":"Input!A43","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!D43)","v":25.2}]
[{"$f":"Input!A44","v":"Corn Silage"},0,0,0,0,0,{"$f":"SUM(F8*Input!D44)","v":0},null,{"$f":"Input!A44","v":"Corn Silage"},0,0,0,0,0,{"$f":"SUM(N8*Input!D44)","v":0},null,{"$f":"Input!A44","v":"Corn Silage"},0,0,0,0,0,{"$f":"SUM(V8*Input!D44)","v":0}]
[{"$f":"Input!A45","v":"Barley Silage"},24,28.25,35.25,40,8510.625,{"$f":"SUM(F9*Input!D45)","v":238.29750000000001},null,{"$f":"Input!A45","v":"Barley Silage"},25.5,28.25,34,38.5,6312.5,{"$f":"SUM(N9*Input!D45)","v":176.75},null,{"$f":"Input!A45","v":"Barley Silage"},23,25.75,29.25,32.5,4420,{"$f":"SUM(V9*Input!D45)","v":123.76}]
[{"$f":"Input!A46","v":"Barley Grain"},1.5,1.5,1.5,1.5,400.5,{"$f":"SUM(F10*Input!D46)","v":52.065000000000005},null,{"$f":"Input!A46","v":"Barley Grain"},3,3.75,4,4.5,762.5,{"$f":"SUM(N10*Input!D46)","v":99.125},null,{"$f":"Input!A46","v":"Barley Grain"},5,6,7,8,1040,{"$f":"SUM(V10*Input!D46)","v":135.20000000000002}]
[{"$f":"Input!A47","v":"Greenfeed"},0,0,0,0,0,{"$f":"SUM(F11*Input!D47)","v":0},null,{"$f":"Input!A47","v":"Greenfeed"},0,0,0,0,0,{"$f":"SUM(N11*Input!D47)","v":0},null,{"$f":"Input!A47","v":"Greenfeed"},0,0,0,0,0,{"$f":"SUM(V11*Input!D47)","v":0}]
[{"$f":"Input!A48","v":"Straw"},0,0,0,0,0,{"$f":"SUM(F12*Input!D48)","v":0},null,{"$f":"Input!A48","v":"Straw"},0,0,0,0,0,{"$f":"SUM(N12*Input!D48)","v":0},null,{"$f":"Input!A48","v":"Straw"},0,0,0,0,0,{"$f":"SUM(V12*Input!D48)","v":0}]
[{"$f":"Input!A49","v":"32-20% Feedlot Suppl."},0,0,0,0,0,{"$f":"SUM(F13*Input!D49)","v":0},null,{"$f":"Input!A49","v":"32-20% Feedlot Suppl."},0,0,0,0,0,{"$f":"SUM(N13*Input!D49)","v":0},null,{"$f":"Input!A49","v":"32-20% Feedlot Suppl."},0,0,0,0,0,{"$f":"SUM(V13*Input!D49)","v":0}]
[{"$f":"Input!A50","v":"DDGS Corn/Wheat"},0,0,0,0,0,{"$f":"SUM(F14*Input!D50)","v":0},null,{"$f":"Input!A50","v":"DDGS Corn/Wheat"},0,0,0,0,0,{"$f":"SUM(N14*Input!D50)","v":0},null,{"$f":"Input!A50","v":"DDGS Corn/Wheat"},0,0,0,0,0,{"$f":"SUM(V14*Input!D50)","v":0}]
[{"$f":"Input!A51","v":"1:1 Premix"},0.25,0.25,0.27500000000000002,0.3,71.756249999999994,{"$f":"SUM(F15*Input!D51)","v":65.22643124999999},null,{"$f":"Input!A51","v":"1:1 Premix"},0.25,0.255,0.28000000000000003,0.31,54.75,{"$f":"SUM(N15*Input!D51)","v":49.767749999999999},null,{"$f":"Input!A51","v":"1:1 Premix"},0.25,0.27,0.3,0.32,45.599999999999994,{"$f":"SUM(V15*Input!D51)","v":41.450399999999995}]
[{"$f":"Input!A52","v":"2:1 Premix"},0,0,0,0,0,{"$f":"SUM(F16*Input!D52)","v":0},null,{"$f":"Input!A52","v":"2:1 Premix"},0,0,0,0,0,{"$f":"SUM(N16*Input!D52)","v":0},null,{"$f":"Input!A52","v":"2:1 Premix"},0,0,0,0,0,{"$f":"SUM(V16*Input!D52)","v":0}]
[{"$f":"Input!A53","v":"Limestone"},0,0,0,0,0,{"$f":"SUM(F17*Input!D53)","v":0},null,{"$f":"Input!A53","v":"Limestone"},3.5000000000000003E-2,0.05,7.0000000000000007E-2,0.09,12.25,{"$f":"SUM(N17*Input!D53)","v":4.4589999999999996},null,{"$f":"Input!A53","v":"Limestone"},0.06,8.5000000000000006E-2,0.11,0.13,15.400000000000002,{"$f":"SUM(V17*Input!D53)","v":5.6056000000000008}]
[{"$f":"Input!A54","v":"Other"},0,0,0,0,0,{"$f":"SUM(F18*Input!D54)","v":0},null,{"$f":"Input!A54","v":"Other"},0,0,0,0,0,{"$f":"SUM(N18*Input!D54)","v":0},null,{"$f":"Input!A54","v":"Other"},0,0,0,0,0,{"$f":"SUM(V18*Input!D54)","v":0}]
["$/head/day",{"$f":"SUM((B7*Input!D43)+(B8*Input!D44)+(B9*Input!D45)+(B10*Input!D46)+(B11*Input!D47)+(B12*Input!D48)+(B13*Input!D49)+(B14*Input!D50)+(B15*Input!D51)+(B16*Input!D52)+(B17*Input!D53)+(B18*Input!D54))","v":1.3792500000000001},{"$f":"SUM((C7*Input!D43)+(C8*Input!D44)+(C9*Input!D45)+(C10*Input!D46)+(C11*Input!D47)+(C12*Input!D48)+(C13*Input!D49)+(C14*Input!D50)+(C15*Input!D51)+(C16*Input!D52)+(C17*Input!D53)+(C18*Input!D54))","v":1.51325},{"$f":"SUM((D7*Input!D43)+(D8*Input!D44)+(D9*Input!D45)+(D10*Input!D46)+(D11*Input!D47)+(D12*Input!D48)+(D13*Input!D49)+(D14*Input!D50)+(D15*Input!D51)+(D16*Input!D52)+(D17*Input!D53)+(D18*Input!D54))","v":1.671975},{"$f":"SUM((E7*Input!D43)+(E8*Input!D44)+(E9*Input!D45)+(E10*Input!D46)+(E11*Input!D47)+(E12*Input!D48)+(E13*Input!D49)+(E14*Input!D50)+(E15*Input!D51)+(E16*Input!D52)+(E17*Input!D53)+(E18*Input!D54))","v":1.8277000000000001},null,{"$f":"SUM(G7:G18)","v":426.67768124999998},null,"$/head/day",{"$f":"SUM((J7*Input!D43)+(J8*Input!D44)+(J9*Input!D45)+(J10*Input!D46)+(J11*Input!D47)+(J12*Input!D48)+(J13*Input!D49)+(J14*Input!D50)+(J15*Input!D51)+(J16*Input!D52)+(J17*Input!D53)+(J18*Input!D54))","v":1.5239899999999997},{"$f":"SUM((K7*Input!D43)+(K8*Input!D44)+(K9*Input!D45)+(K10*Input!D46)+(K11*Input!D47)+(K12*Input!D48)+(K13*Input!D49)+(K14*Input!D50)+(K15*Input!D51)+(K16*Input!D52)+(K17*Input!D53)+(K18*Input!D54))","v":1.7084950000000001},{"$f":"SUM((L7*Input!D43)+(L8*Input!D44)+(L9*Input!D45)+(L10*Input!D46)+(L11*Input!D47)+(L12*Input!D48)+(L13*Input!D49)+(L14*Input!D50)+(L15*Input!D51)+(L16*Input!D52)+(L17*Input!D53)+(L18*Input!D54))","v":1.9020000000000001},{"$f":"SUM((M7*Input!D43)+(M8*Input!D44)+(M9*Input!D45)+(M10*Input!D46)+(M11*Input!D47)+(M12*Input!D48)+(M13*Input!D49)+(M14*Input!D50)+(M15*Input!D51)+(M16*Input!D52)+(M17*Input!D53)+(M18*Input!D54))","v":2.09755},null,{"$f":"SUM(O7:O18)","v":361.60174999999998},null,"$/head/day",{"$f":"SUM((R7*Input!D43)+(R8*Input!D44)+(R9*Input!D45)+(R10*Input!D46)+(R11*Input!D47)+(R12*Input!D48)+(R13*Input!D49)+(R14*Input!D50)+(R15*Input!D51)+(R16*Input!D52)+(R17*Input!D53)+(R18*Input!D54))","v":1.7230900000000002},{"$f":"SUM((S7*Input!D43)+(S8*Input!D44)+(S9*Input!D45)+(S10*Input!D46)+(S11*Input!D47)+(S12*Input!D48)+(S13*Input!D49)+(S14*Input!D50)+(S15*Input!D51)+(S16*Input!D52)+(S17*Input!D53)+(S18*Input!D54))","v":1.9573700000000001},{"$f":"SUM((T7*Input!D43)+(T8*Input!D44)+(T9*Input!D45)+(T10*Input!D46)+(T11*Input!D47)+(T12*Input!D48)+(T13*Input!D49)+(T14*Input!D50)+(T15*Input!D51)+(T16*Input!D52)+(T17*Input!D53)+(T18*Input!D54))","v":2.1917399999999998},{"$f":"SUM((U7*Input!D43)+(U8*Input!D44)+(U9*Input!D45)+(U10*Input!D46)+(U11*Input!D47)+(U12*Input!D48)+(U13*Input!D49)+(U14*Input!D50)+(U15*Input!D51)+(U16*Input!D52)+(U17*Input!D53)+(U18*Input!D54))","v":2.4082000000000003},null,{"$f":"SUM(W7:W18)","v":331.21600000000001}]
[]
["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!A43","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!D43)","v":126.1575},null,{"$f":"Input!A43","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!D43)","v":60},null,{"$f":"Input!A43","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!D43)","v":48}]
[{"$f":"Input!A44","v":"Corn Silage"},18,22.5,27.5,32,6675,{"$f":"SUM(F25*Input!D44)","v":153.52500000000001},null,{"$f":"Input!A44","v":"Corn Silage"},23,28,34,39,6200,{"$f":"SUM(N25*Input!D44)","v":142.6},null,{"$f":"Input!A44","v":"Corn Silage"},19,22,27,31.75,3990,{"$f":"SUM(V25*Input!D44)","v":91.77}]
[{"$f":"Input!A45","v":"Barley Silage"},0,0,0,0,0,{"$f":"SUM(F26*Input!D45)","v":0},null,{"$f":"Input!A45","v":"Barley Silage"},0,0,0,0,0,{"$f":"SUM(N26*Input!D45)","v":0},null,{"$f":"Input!A45","v":"Barley Silage"},0,0,0,0,0,{"$f":"SUM(V26*Input!D45)","v":0}]
[{"$f":"Input!A46","v":"Barley Grain"},1.5,1.5,1.5,1.5,400.5,{"$f":"SUM(F27*Input!D46)","v":52.065000000000005},null,{"$f":"Input!A46","v":"Barley Grain"},2.5,2.5,2.5,2.5,500,{"$f":"SUM(N27*Input!D46)","v":65},null,{"$f":"Input!A46","v":"Barley Grain"},4,5,5.5,6,820,{"$f":"SUM(V27*Input!D46)","v":106.60000000000001}]
[{"$f":"Input!A47","v":"Greenfeed"},0,0,0,0,0,{"$f":"SUM(F28*Input!D47)","v":0},null,{"$f":"Input!A47","v":"Greenfeed"},0,0,0,0,0,{"$f":"SUM(N28*Input!D47)","v":0},null,{"$f":"Input!A47","v":"Greenfeed"},0,0,0,0,0,{"$f":"SUM(V28*Input!D47)","v":0}]
[{"$f":"Input!A48","v":"Straw"},0,0,0,0,0,{"$f":"SUM(F29*Input!D48)","v":0},null,{"$f":"Input!A48","v":"Straw"},0,0,0,0,0,{"$f":"SUM(N29*Input!D48)","v":0},null,{"$f":"Input!A48","v":"Straw"},0,0,0,0,0,{"$f":"SUM(V29*Input!D48)","v":0}]
[{"$f":"Input!A49","v":"32-20% Feedlot Suppl."},0,0,0,0,0,{"$f":"SUM(F30*Input!D49)","v":0},null,{"$f":"Input!A49","v":"32-20% Feedlot Suppl."},0.5,0.55000000000000004,0.6,0.65,115,{"$f":"SUM(N30*Input!D49)","v":26.105},null,{"$f":"Input!A49","v":"32-20% Feedlot Suppl."},0,0,0,0,0,{"$f":"SUM(V30*Input!D49)","v":0}]
[{"$f":"Input!A50","v":"DDGS Corn/Wheat"},0,0,0,0,0,{"$f":"SUM(F31*Input!D50)","v":0},null,{"$f":"Input!A50","v":"DDGS Corn/Wheat"},0,0,0,0,0,{"$f":"SUM(N31*Input!D50)","v":0},null,{"$f":"Input!A50","v":"DDGS Corn/Wheat"},1,1,0.75,0.5,130,{"$f":"SUM(V31*Input!D50)","v":20.67}]
[{"$f":"Input!A51","v":"1:1 Premix"},0,0,0,0,0,{"$f":"SUM(F32*Input!D51)","v":0},null,{"$f":"Input!A51","v":"1:1 Premix"},0,0,0,0,0,{"$f":"SUM(N32*Input!D51)","v":0},null,{"$f":"Input!A51","v":"1:1 Premix"},0,0,0,0,0,{"$f":"SUM(V32*Input!D51)","v":0}]
[{"$f":"Input!A52","v":"2:1 Premix"},0.25,0.25,0.27500000000000002,0.3,71.756249999999994,{"$f":"SUM(F33*Input!D52)","v":65.22643124999999},null,{"$f":"Input!A52","v":"2:1 Premix"},0,0,0,0,0,{"$f":"SUM(N33*Input!D52)","v":0},null,{"$f":"Input!A52","v":"2:1 Premix"},0.25,0.28000000000000003,0.28499999999999998,0.315,45.2,{"$f":"SUM(V33*Input!D52)","v":41.086800000000004}]
[{"$f":"Input!A53","v":"Limestone"},0,0,0,0,0,{"$f":"SUM(F34*Input!D53)","v":0},null,{"$f":"Input!A53","v":"Limestone"},0,0,0,0,0,{"$f":"SUM(N34*Input!D53)","v":0},null,{"$f":"Input!A53","v":"Limestone"},6.5000000000000002E-2,0.09,0.09,0.105,14,{"$f":"SUM(V34*Input!D53)","v":5.0960000000000001}]
[{"$f":"Input!A54","v":"Other"},0,0,0,0,0,{"$f":"SUM(F35*Input!D54)","v":0},null,{"$f":"Input!A54","v":"Other"},0,0,0,0,0,{"$f":"SUM(N35*Input!D54)","v":0},null,{"$f":"Input!A54","v":"Other"},0,0,0,0,0,{"$f":"SUM(V35*Input!D54)","v":0}]
["$/head/day",{"$f":"SUM((B24*Input!D43)+(B25*Input!D44)+(B26*Input!D45)+(B27*Input!D46)+(B28*Input!D47)+(B29*Input!D48)+(B30*Input!D49)+(B31*Input!D50)+(B32*Input!D51)+(B33*Input!D52)+(B34*Input!D53)+(B35*Input!D54))","v":1.2862499999999999},{"$f":"SUM((C24*Input!D43)+(C25*Input!D44)+(C26*Input!D45)+(C27*Input!D46)+(C28*Input!D47)+(C29*Input!D48)+(C30*Input!D49)+(C31*Input!D50)+(C32*Input!D51)+(C33*Input!D52)+(C34*Input!D53)+(C35*Input!D54))","v":1.4197499999999998},{"$f":"SUM((D24*Input!D43)+(D25*Input!D44)+(D26*Input!D45)+(D27*Input!D46)+(D28*Input!D47)+(D29*Input!D48)+(D30*Input!D49)+(D31*Input!D50)+(D32*Input!D51)+(D33*Input!D52)+(D34*Input!D53)+(D35*Input!D54))","v":1.5574749999999999},{"$f":"SUM((E24*Input!D43)+(E25*Input!D44)+(E26*Input!D45)+(E27*Input!D46)+(E28*Input!D47)+(E29*Input!D48)+(E30*Input!D49)+(E31*Input!D50)+(E32*Input!D51)+(E33*Input!D52)+(E34*Input!D53)+(E35*Input!D54))","v":1.6837},null,{"$f":"SUM(G24:G35)","v":396.97393124999996},null,"$/head/day",{"$f":"SUM((J24*Input!D43)+(J25*Input!D44)+(J26*Input!D45)+(J27*Input!D46)+(J28*Input!D47)+(J29*Input!D48)+(J30*Input!D49)+(J31*Input!D50)+(J32*Input!D51)+(J33*Input!D52)+(J34*Input!D53)+(J35*Input!D54))","v":1.2674999999999998},{"$f":"SUM((K24*Input!D43)+(K25*Input!D44)+(K26*Input!D45)+(K27*Input!D46)+(K28*Input!D47)+(K29*Input!D48)+(K30*Input!D49)+(K31*Input!D50)+(K32*Input!D51)+(K33*Input!D52)+(K34*Input!D53)+(K35*Input!D54))","v":1.39385},{"$f":"SUM((L24*Input!D43)+(L25*Input!D44)+(L26*Input!D45)+(L27*Input!D46)+(L28*Input!D47)+(L29*Input!D48)+(L30*Input!D49)+(L31*Input!D50)+(L32*Input!D51)+(L33*Input!D52)+(L34*Input!D53)+(L35*Input!D54))","v":1.5432000000000001},{"$f":"SUM((M24*Input!D43)+(M25*Input!D44)+(M26*Input!D45)+(M27*Input!D46)+(M28*Input!D47)+(M29*Input!D48)+(M30*Input!D49)+(M31*Input!D50)+(M32*Input!D51)+(M33*Input!D52)+(M34*Input!D53)+(M35*Input!D54))","v":1.6695500000000001},null,{"$f":"SUM(O24:O35)","v":293.70500000000004},null,"$/head/day",{"$f":"SUM((R24*Input!D43)+(R25*Input!D44)+(R26*Input!D45)+(R27*Input!D46)+(R28*Input!D47)+(R29*Input!D48)+(R30*Input!D49)+(R31*Input!D50)+(R32*Input!D51)+(R33*Input!D52)+(R34*Input!D53)+(R35*Input!D54))","v":1.6669100000000001},{"$f":"SUM((S24*Input!D43)+(S25*Input!D44)+(S26*Input!D45)+(S27*Input!D46)+(S28*Input!D47)+(S29*Input!D48)+(S30*Input!D49)+(S31*Input!D50)+(S32*Input!D51)+(S33*Input!D52)+(S34*Input!D53)+(S35*Input!D54))","v":1.90228},{"$f":"SUM((T24*Input!D43)+(T25*Input!D44)+(T26*Input!D45)+(T27*Input!D46)+(T28*Input!D47)+(T29*Input!D48)+(T30*Input!D49)+(T31*Input!D50)+(T32*Input!D51)+(T33*Input!D52)+(T34*Input!D53)+(T35*Input!D54))","v":2.0470750000000004},{"$f":"SUM((U24*Input!D43)+(U25*Input!D44)+(U26*Input!D45)+(U27*Input!D46)+(U28*Input!D47)+(U29*Input!D48)+(U30*Input!D49)+(U31*Input!D50)+(U32*Input!D51)+(U33*Input!D52)+(U34*Input!D53)+(U35*Input!D54))","v":2.2143049999999995},null,{"$f":"SUM(W24:W35)","v":313.22280000000001}]
[]
["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!A43","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!D43)","v":258.12225000000001},null,{"$f":"Input!A43","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!D43)","v":189.75},null,{"$f":"Input!A43","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!D43)","v":126.6}]
[{"$f":"Input!A44","v":"Corn Silage"},0,0,0,0,0,{"$f":"SUM(F42*Input!D44)","v":0},null,{"$f":"Input!A44","v":"Corn Silage"},0,0,0,0,0,{"$f":"SUM(N42*Input!D44)","v":0},null,{"$f":"Input!A44","v":"Corn Silage"},0,0,0,0,0,{"$f":"SUM(V42*Input!D44)","v":0}]
[{"$f":"Input!A45","v":"Barley Silage"},0,0,0,0,0,{"$f":"SUM(F43*Input!D45)","v":0},null,{"$f":"Input!A45","v":"Barley Silage"},0,0,0,0,0,{"$f":"SUM(N43*Input!D45)","v":0},null,{"$f":"Input!A45","v":"Barley Silage"},0,0,0,0,0,{"$f":"SUM(V43*Input!D45)","v":0}]
[{"$f":"Input!A46","v":"Barley Grain"},3,3.5,3.5,4,934.5,{"$f":"SUM(F44*Input!D46)","v":121.485},null,{"$f":"Input!A46","v":"Barley Grain"},4.5,5,5.5,6,1050,{"$f":"SUM(N44*Input!D46)","v":136.5},null,{"$f":"Input!A46","v":"Barley Grain"},6.75,7.8,8.6999999999999993,9.6999999999999993,1318,{"$f":"SUM(V44*Input!D46)","v":171.34}]
[{"$f":"Input!A47","v":"Greenfeed"},0,0,0,0,0,{"$f":"SUM(F45*Input!D47)","v":0},null,{"$f":"Input!A47","v":"Greenfeed"},0,0,0,0,0,{"$f":"SUM(N45*Input!D47)","v":0},null,{"$f":"Input!A47","v":"Greenfeed"},0,0,0,0,0,{"$f":"SUM(V45*Input!D47)","v":0}]
[{"$f":"Input!A48","v":"Straw"},0,0,0,0,0,{"$f":"SUM(F46*Input!D48)","v":0},null,{"$f":"Input!A48","v":"Straw"},0,0,0,0,0,{"$f":"SUM(N46*Input!D48)","v":0},null,{"$f":"Input!A48","v":"Straw"},0,0,0,0,0,{"$f":"SUM(V46*Input!D48)","v":0}]
[{"$f":"Input!A49","v":"32-20% Feedlot Suppl."},0,0,0,0,0,{"$f":"SUM(F47*Input!D49)","v":0},null,{"$f":"Input!A49","v":"32-20% Feedlot Suppl."},0,0,0,0,0,{"$f":"SUM(N47*Input!D49)","v":0},null,{"$f":"Input!A49","v":"32-20% Feedlot Suppl."},0,0,0,0,0,{"$f":"SUM(V47*Input!D49)","v":0}]
[{"$f":"Input!A50","v":"DDGS Corn/Wheat"},0,0,0,0,0,{"$f":"SUM(F48*Input!D50)","v":0},null,{"$f":"Input!A50","v":"DDGS Corn/Wheat"},0,0,0,0,0,{"$f":"SUM(N48*Input!D50)","v":0},null,{"$f":"Input!A50","v":"DDGS Corn/Wheat"},0,0,0,0,0,{"$f":"SUM(V48*Input!D50)","v":0}]
[{"$f":"Input!A51","v":"1:1 Premix"},0.25,0.25,0.28000000000000003,0.3,72.09,{"$f":"SUM(F49*Input!D51)","v":65.529810000000012},null,{"$f":"Input!A51","v":"1:1 Premix"},0.25,0.27,0.3,0.33,57.5,{"$f":"SUM(N49*Input!D51)","v":52.267499999999998},null,{"$f":"Input!A51","v":"1:1 Premix"},0.25,0.27,0.31,0.33,46.400000000000006,{"$f":"SUM(V49*Input!D51)","v":42.177600000000005}]
[{"$f":"Input!A52","v":"2:1 Premix"},0,0,0,0,0,{"$f":"SUM(F50*Input!D52)","v":0},null,{"$f":"Input!A52","v":"2:1 Premix"},0,0,0,0,0,{"$f":"SUM(N50*Input!D52)","v":0},null,{"$f":"Input!A52","v":"2:1 Premix"},0,0,0,0,0,{"$f":"SUM(V50*Input!D52)","v":0}]
[{"$f":"Input!A53","v":"Limestone"},0,0,0,0,0,{"$f":"SUM(F51*Input!D53)","v":0},null,{"$f":"Input!A53","v":"Limestone"},0,0,0,0,0,{"$f":"SUM(N51*Input!D53)","v":0},null,{"$f":"Input!A53","v":"Limestone"},0,0,0,0,0,{"$f":"SUM(V51*Input!D53)","v":0}]
[{"$f":"Input!A54","v":"Other"},0,0,0,0,0,{"$f":"SUM(F52*Input!D54)","v":0},null,{"$f":"Input!A54","v":"Other"},0,0,0,0,0,{"$f":"SUM(N52*Input!D54)","v":0},null,{"$f":"Input!A54","v":"Other"},0,0,0,0,0,{"$f":"SUM(V52*Input!D54)","v":0}]
["$/head/day",{"$f":"SUM((B41*Input!D43)+(B42*Input!D44)+(B43*Input!D45)+(B44*Input!D46)+(B45*Input!D47)+(B46*Input!D48)+(B47*Input!D49)+(B48*Input!D50)+(B49*Input!D51)+(B50*Input!D52)+(B51*Input!D53)+(B52*Input!D54))","v":1.4272499999999999},{"$f":"SUM((C41*Input!D43)+(C42*Input!D44)+(C43*Input!D45)+(C44*Input!D46)+(C45*Input!D47)+(C46*Input!D48)+(C47*Input!D49)+(C48*Input!D50)+(C49*Input!D51)+(C50*Input!D52)+(C51*Input!D53)+(C52*Input!D54))","v":1.5942499999999999},{"$f":"SUM((D41*Input!D43)+(D42*Input!D44)+(D43*Input!D45)+(D44*Input!D46)+(D45*Input!D47)+(D46*Input!D48)+(D47*Input!D49)+(D48*Input!D50)+(D49*Input!D51)+(D50*Input!D52)+(D51*Input!D53)+(D52*Input!D54))","v":1.7445200000000001},{"$f":"SUM((E41*Input!D43)+(E42*Input!D44)+(E43*Input!D45)+(E44*Input!D46)+(E45*Input!D47)+(E46*Input!D48)+(E47*Input!D49)+(E48*Input!D50)+(E49*Input!D51)+(E50*Input!D52)+(E51*Input!D53)+(E52*Input!D54))","v":1.9026999999999998},null,{"$f":"SUM(G41:G51)","v":445.13706000000002},null,"$/head/day",{"$f":"SUM((J41*Input!D43)+(J42*Input!D44)+(J43*Input!D45)+(J44*Input!D46)+(J45*Input!D47)+(J46*Input!D48)+(J47*Input!D49)+(J48*Input!D50)+(J49*Input!D51)+(J50*Input!D52)+(J51*Input!D53)+(J52*Input!D54))","v":1.5922499999999999},{"$f":"SUM((K41*Input!D43)+(K42*Input!D44)+(K43*Input!D45)+(K44*Input!D46)+(K45*Input!D47)+(K46*Input!D48)+(K47*Input!D49)+(K48*Input!D50)+(K49*Input!D51)+(K50*Input!D52)+(K51*Input!D53)+(K52*Input!D54))","v":1.7954299999999999},{"$f":"SUM((L41*Input!D43)+(L42*Input!D44)+(L43*Input!D45)+(L44*Input!D46)+(L45*Input!D47)+(L46*Input!D48)+(L47*Input!D49)+(L48*Input!D50)+(L49*Input!D51)+(L50*Input!D52)+(L51*Input!D53)+(L52*Input!D54))","v":1.9926999999999999},{"$f":"SUM((M41*Input!D43)+(M42*Input!D44)+(M43*Input!D45)+(M44*Input!D46)+(M45*Input!D47)+(M46*Input!D48)+(M47*Input!D49)+(M48*Input!D50)+(M49*Input!D51)+(M50*Input!D52)+(M51*Input!D53)+(M52*Input!D54))","v":2.1899699999999998},null,{"$f":"SUM(O41:O52)","v":378.51749999999998},null,"$/head/day",{"$f":"SUM((R41*Input!D43)+(R42*Input!D44)+(R43*Input!D45)+(R44*Input!D46)+(R45*Input!D47)+(R46*Input!D48)+(R47*Input!D49)+(R48*Input!D50)+(R49*Input!D51)+(R50*Input!D52)+(R51*Input!D53)+(R52*Input!D54))","v":1.7797499999999999},{"$f":"SUM((S41*Input!D43)+(S42*Input!D44)+(S43*Input!D45)+(S44*Input!D46)+(S45*Input!D47)+(S46*Input!D48)+(S47*Input!D49)+(S48*Input!D50)+(S49*Input!D51)+(S50*Input!D52)+(S51*Input!D53)+(S52*Input!D54))","v":2.00943},{"$f":"SUM((T41*Input!D43)+(T42*Input!D44)+(T43*Input!D45)+(T44*Input!D46)+(T45*Input!D47)+(T46*Input!D48)+(T47*Input!D49)+(T48*Input!D50)+(T49*Input!D51)+(T50*Input!D52)+(T51*Input!D53)+(T52*Input!D54))","v":2.2527900000000001},{"$f":"SUM((U41*Input!D43)+(U42*Input!D44)+(U43*Input!D45)+(U44*Input!D46)+(U45*Input!D47)+(U46*Input!D48)+(U47*Input!D49)+(U48*Input!D50)+(U49*Input!D51)+(U50*Input!D52)+(U51*Input!D53)+(U52*Input!D54))","v":2.4609699999999997},null,{"$f":"SUM(W41:W52)","v":340.11759999999998}]

{"sheet":"Details","index":7,"n_rows":284,"n_cols":10,"rows_kept":284,"cut":false,"hidden":false,"merged":[[0,1,0,9],[222,1,222,9],[1,1,1,9]]}
[null,"    Backgrounding Cattle Production Cost Worksheet"]
[]
["Assumptions"]
[]
[null,{"$f":"\"1.  Average daily gain (ADG) was assumed to be \"&Input!D23&\" lbs/day.\"","v":"1.  Average daily gain (ADG) was assumed to be 2.5 lbs/day."}]
[null,{"$f":"\"2.  It was assumed the feeder steer weighed in at \"&Input!D14&\" lbs shrunk weight,\"","v":"2.  It was assumed the feeder steer weighed in at 500 lbs shrunk weight,"}]
[null,{"$f":"\"     and was raised to \"&Input!D16&\" lbs (\"&Input!D16-(Input!D16*Input!D20/100)&\" lbs after \"&Input!D20&\" % shrink).\"","v":"     and was raised to 900 lbs (873 lbs after 3 % shrink)."}]
[null,{"$f":"\"3.  Days on feed was \"&Input!B32&\".\"","v":"3.  Days on feed was 160."}]
[null,{"$f":"\"4.  Investment in facilities and equipment was assumed to handle \"&Input!D12&\" head.\"","v":"4.  Investment in facilities and equipment was assumed to handle 500 head."}]
[]
[]
[null,"A.  Operating Costs",null,null,null,null,null,null,null,"Your Cost"]
[]
[null,"1.  Feed Costs"]
[null,null,{"$f":"Summary!A6","v":"    1.01  Alfalfa Grass Hay (57.8 % TDN, 13.7 % CP)"}]
[null,null,null,null,null,{"$f":"IF(Input!$C$24=\"Barley Silage\",'Feed Rations'!I9,IF(Input!$C$24=\"Corn Silage\",'Feed Rations'!I27,'Feed Rations'!I45))","v":800},null,"lbs/feeder"]
[null,null,null,"x",null,{"$f":"Input!D43","v":0.06},null,"$/lb"]
[null,null,null,"=",null,{"$f":"ROUND(F16*F17,2)","v":48},null,"/feeder"]
[]
[null,null,{"$f":"Summary!A7","v":"    1.02  Corn Silage (65.2 % TDN, 8.7 % CP)"}]
[null,null,null,null,null,{"$f":"IF(Input!$C$24=\"Barley Silage\",'Feed Rations'!I10,IF(Input!$C$24=\"Corn Silage\",'Feed Rations'!I28,'Feed Rations'!I46))","v":3990},null,"lbs/feeder"]
[null,null,null,"x",null,{"$f":"Input!D44","v":2.3E-2},null,"$/lb"]
[null,null,null,"=",null,{"$f":"ROUND(F21*F22,2)","v":91.77},null,"/feeder"]
[]
[null,null,{"$f":"Summary!A8","v":"    1.03  Barley Silage (63 % TDN, 11 % CP)"}]
[null,null,null,null,null,{"$f":"IF(Input!$C$24=\"Barley Silage\",'Feed Rations'!I11,IF(Input!$C$24=\"Corn Silage\",'Feed Rations'!I29,'Feed Rations'!I47))","v":0},null,"lbs/feeder"]
[null,null,null,"x",null,{"$f":"Input!D45","v":2.8000000000000001E-2},null,"$/lb"]
[null,null,null,"=",null,{"$f":"ROUND(F26*F27,2)","v":0},null,"/feeder"]
[]
[null,null,{"$f":"Summary!A9","v":"    1.04  Barley Grain (83.1 % TDN, 12.5 % CP)"}]
[null,null,null,null,null,{"$f":"IF(Input!$C$24=\"Barley Silage\",'Feed Rations'!I12,IF(Input!$C$24=\"Corn Silage\",'Feed Rations'!I30,'Feed Rations'!I48))","v":820},null,"lbs/feeder"]
[null,null,null,"x",null,{"$f":"Input!D46","v":0.13},null,"$/lb"]
[null,null,null,"=",null,{"$f":"ROUND(F31*F32,2)","v":106.6},null,"/feeder"]
[]
[null,null,{"$f":"Summary!A10","v":"    1.05  Greenfeed"}]
[null,null,null,null,null,{"$f":"IF(Input!$C$24=\"Barley Silage\",'Feed Rations'!I13,IF(Input!$C$24=\"Corn Silage\",'Feed Rations'!I31,'Feed Rations'!I49))","v":0},null,"lbs/feeder"]
[null,null,null,"x",null,{"$f":"Input!D47","v":0.06},null,"$/lb"]
[null,null,null,"=",null,{"$f":"ROUND(F36*F37,2)","v":0},null,"/feeder"]
[]
[null,null,{"$f":"Summary!A11","v":"    1.06  Straw"}]
[null,null,null,null,null,{"$f":"IF(Input!$C$24=\"Barley Silage\",'Feed Rations'!I14,IF(Input!$C$24=\"Corn Silage\",'Feed Rations'!I32,'Feed Rations'!I50))","v":0},null,"lbs/feeder"]
[null,null,null,"x",null,{"$f":"Input!D48","v":3.5000000000000003E-2},null,"$/lb"]
[null,null,null,"=",null,{"$f":"ROUND(F41*F42,2)","v":0},null,"/feeder"]
[]
[null,null,{"$f":"Summary!A12","v":"    1.07  32-20% Feedlot Suppl. (61.7%TDN, 35.6%CP)"}]
[null,null,null,null,null,{"$f":"IF(Input!$C$24=\"Barley Silage\",'Feed Rations'!I15,IF(Input!$C$24=\"Corn Silage\",'Feed Rations'!I33,'Feed Rations'!I51))","v":0},null,"lbs/feeder"]
[null,null,null,"x",null,{"$f":"Input!D49","v":0.22700000000000001},null,"$/lb"]
[null,null,null,"=",null,{"$f":"ROUND(F46*F47,2)","v":0},null,"/feeder"]
[]
[null,null,{"$f":"Summary!A13","v":"    1.08  DDGS Corn/Wheat (77 % TDN, 33.9 % CP)"}]
[null,null,null,null,null,{"$f":"IF(Input!$C$24=\"Barley Silage\",'Feed Rations'!I16,IF(Input!$C$24=\"Corn Silage\",'Feed Rations'!I34,'Feed Rations'!I52))","v":130},null,"lbs/feeder"]
[null,null,null,"x",null,{"$f":"Input!D50","v":0.159},null,"$/lb"]
[null,null,null,"=",null,{"$f":"ROUND(F51*F52,2)","v":20.67},null,"/feeder"]
[]
[null,null,{"$f":"Summary!A14","v":"    1.09  1:1 Premix"}]
[null,null,null,null,null,{"$f":"IF(Input!$C$24=\"Barley Silage\",'Feed Rations'!I17,IF(Input!$C$24=\"Corn Silage\",'Feed Rations'!I35,'Feed Rations'!I53))","v":0},null,"lbs/feeder"]
[null,null,null,"x",null,{"$f":"Input!D51","v":0.90900000000000003},null,"$/lb"]
[null,null,null,"=",null,{"$f":"ROUND(F56*F57,2)","v":0},null,"/feeder"]
[]
[null,null,{"$f":"Summary!A15","v":"    1.10  2:1 Premix"}]
[null,null,null,null,null,{"$f":"IF(Input!$C$24=\"Barley Silage\",'Feed Rations'!I18,IF(Input!$C$24=\"Corn Silage\",'Feed Rations'!I36,'Feed Rations'!I54))","v":45},null,"lbs/feeder"]
[null,null,null,"x",null,{"$f":"Input!D52","v":0.90900000000000003},null,"$/lb"]
[null,null,null,"=",null,{"$f":"ROUND(F61*F62,2)","v":40.909999999999997},null,"/feeder"]
[]
[null,null,{"$f":"Summary!A16","v":"    1.11  Limestone"}]
[null,null,null,null,null,{"$f":"IF(Input!$C$24=\"Barley Silage\",'Feed Rations'!I19,IF(Input!$C$24=\"Corn Silage\",'Feed Rations'!I37,'Feed Rations'!I55))","v":14},null,"lbs/feeder"]
[null,null,null,"x",null,{"$f":"Input!D53","v":0.36399999999999999},null,"$/lb"]
[null,null,null,"=",null,{"$f":"ROUND(F66*F67,2)","v":5.0999999999999996},null,"/feeder"]
[]
[null,null,{"$f":"Summary!A17","v":"    1.12  Other"}]
[null,null,null,null,null,{"$f":"IF(Input!$C$24=\"Barley Silage\",'Feed Rations'!I20,IF(Input!$C$24=\"Corn Silage\",'Feed Rations'!I38,'Feed Rations'!I56))","v":0},null,"lbs/feeder"]
[null,null,null,"x",null,{"$f":"Input!D54","v":0},null,"$/lb"]
[null,null,null,"=",null,{"$f":"ROUND(F71*F72,2)","v":0},null,"/feeder"]
[]
[null,"2.  Other Operating Costs"]
[null,null,"2.01  Feeder Cattle Cost"]
[null,null,"Commission",null,null,{"$f":"Input!D63","v":5},null,"/feeder"]
[null,null,"Insurance",null,null,{"$f":"Input!D65","v":1.75},null,"/feeder"]
[]
[null,null,"Trucking-in",null,null,{"$f":"Input!D64","v":1.7},null,"/cwt"]
[null,null,null,"x",null,{"$f":"Input!D14","v":500},null,"lbs/feeder"]
[null,null,null,"÷",null,100,null,"lbs/cwt",null,""]
[null,null,null,"=",null,{"$f":"ROUND(F80*F81/F82,2)","v":8.5},null,"/feeder"]
[]
[null,null,"Feeder",null,null,{"$f":"Input!D14","v":500},null,"lbs/feeder"]
[null,null,null,"x",null,{"$f":"Input!D15","v":390},null,"/cwt"]
[null,null,null,"÷",null,100,null,"lbs/cwt",null,""]
[null,null,null,"=",null,{"$f":"ROUND(F85/100*F86,2)","v":1950},null,"/feeder"]
[]
[null,null,"Total","=",null,{"$f":"ROUND(F77+F78+F83+F88,2)","v":1965.25},null,"/feeder"]
[]
[null,null,"2.02 Straw"]
[null,null,null,null,null,{"$f":"Input!D68","v":4},null,"lbs/feeder/day"]
[null,null,null,"x",null,{"$f":"Input!B32","v":160},null,"days on feed"]
[null,null,null,"x",null,{"$f":"Input!D69","v":70},null,"/ton"]
[null,null,null,"=",null,{"$f":"ROUND((F93*F94)*(F95/2000),2)","v":22.4},null,"/feeder"]
[]
[null,null,"2.03 Veterinary Medicine & Supplies"]
[null,null,"Cattle Medication"]
[null,null,null,null,null,{"$f":"Input!D73","v":5},null,"IBR,BVD,PI3,BRSV,Pasteurella"]
[null,null,null,"+",null,{"$f":"Input!D74","v":0.5},null,"Vitamin A-D"]
[null,null,null,"+",null,{"$f":"Input!D75","v":0.72},null,"External & Internal Parasites"]
[null,null,null,"+",null,{"$f":"Input!D76","v":1.26},null,"Blackleg & Haemophilus"]
[null,null,null,"+",null,{"$f":"Input!D77","v":2},null,"Growth Implants"]
[null,null,null,"+",null,{"$f":"Input!D78","v":15},null,"Antibiotics"]
[null,null,null,"=",null,{"$f":"SUM(F100:F105)","v":24.48},null,"/feeder "]
[]
[null,null,"Herd Health Program"]
[null,null,"  Professional Services"]
[null,null,null,null,null,{"$f":"Input!D83","v":160},null,"/hour charge"]
[null,null,null,"x",null,{"$f":"Input!D82","v":3},null,"hours"]
[null,null,null,"÷",null,{"$f":"Input!D12","v":500},null,"feeder cattle"]
[null,null,null,"=",null,{"$f":"ROUND(F110*F111/F112,2)","v":0.96},null,"/feeder "]
[]
[null,null,"  Transportation Costs"]
[null,null,null,null,null,{"$f":"Input!D86","v":1},null,"/km charge"]
[null,null,null,"x",null,{"$f":"Input!D85","v":80},null,"kilometres"]
[null,null,null,"x",null,{"$f":"Input!D87","v":2},null,"visits"]
[null,null,null,"÷",null,{"$f":"Input!D12","v":500},null,"feeder cattle"]
[null,null,null,"=",null,{"$f":"ROUND(F116*F117*F118/F119,2)","v":0.32},null,"/feeder "]
[]
[null,null,"Total","=",null,{"$f":"ROUND(F106+F113+F120,2)","v":25.76},null,"/feeder"]
[]
[null,null,"2.04  Annual Fuel & Repair Costs"]
[null,null,"Machinery fuel cost"]
[null,null,null,null,null,{"$f":"Input!D91","v":120},null,"PTO hp"]
[null,null,null,"÷",null,2.5,null,"avg HP required"]
[null,null,null,"x",null,0.1665576,null,"litres fuel/hour/hp"]
[null,null,null,"x",null,{"$f":"Input!D93","v":1.5},null,"hours per day"]
[null,null,null,"x",null,{"$f":"Input!D92","v":1.4},null,"diesel / litre"]
[null,null,null,"x",null,{"$f":"Input!B32","v":160},null,"days on feed"]
[null,null,null,null,null,{"$f":"IF(F131=\"ERROR\",\"ERROR\",ROUND(((F126/F127)*F128*F129*F130*F131),2))","v":2686.24},null,"annual fuel cost"]
[null,null,null,"÷",null,{"$f":"Input!D12","v":500},null,"feeders"]
[null,null,null,"=",null,{"$f":"SUM(F132/F133)","v":5.3724799999999995},null,"/feeder"]
[null,null,"Machinery repair & maintenance"]
[null,null,null,null,null,{"$f":"SUM(Input!D153+Input!D154)","v":112500},null,"machinery capital cost"]
[null,null,null,"x",null,{"$f":"Input!D94","v":1.2},null,"% repair rate"]
[null,null,null,"=",null,{"$f":"SUM(F136*(F137/100))","v":1350},null,"oil, repairs & maintenance"]
[null,null,null,"÷",null,{"$f":"Input!D12","v":500},null,"feeders"]
[null,null,null,"=",null,{"$f":"SUM(F138/F139)","v":2.7},null,"/feeder"]
[null,null,"Building repair & maintenance"]
[null,null,null,null,null,{"$f":"Input!D150-Input!D149","v":62600},null,"building capital cost"]
[null,null,null,"x",null,{"$f":"Input!D95","v":2.2000000000000002},null,"% repair rate"]
[null,null,null,"=",null,{"$f":"SUM(F142*(F143/100))","v":1377.2},null,"oil, repairs & maintenance"]
[null,null,null,"÷",null,{"$f":"Input!D12","v":500},null,"feeders"]
[null,null,null,"=",null,{"$f":"SUM(F144/F145)","v":2.7544},null,"/feeder"]
[]
[null,null,null,"=",null,{"$f":"SUM(F146+F140+F134)","v":10.826879999999999},null,"/feeder"]
[]
[null,null,"2.05  Utilities"]
[null,null,null,null,null,{"$f":"SUM(Input!D101:D102)","v":1696.5024000000001},null,"cost/year"]
[null,null,null,"÷",null,{"$f":"Input!D12","v":500},null,"feeder cattle"]
[null,null,null,"=",null,{"$f":"ROUND((F151)/F152,2)","v":3.39},null,"/feeder"]
[]
[null,null,"2.06  Feeder Selling Cost"]
[null,null,"Trucking"]
[null,null,null,"Calves",null,{"$f":"Input!D106","v":75},null,"miles"]
[null,null,null,"x",null,{"$f":"Input!D107","v":7},null,"/loaded mile"]
[null,null,null,null,null,{"$f":"Input!D12-((Input!D13/100)*Input!D12)","v":490},null,"feeders"]
[null,null,null,"=",null,{"$f":"ROUNDUP((F159)/Input!D109,0)","v":9},null,"loads"]
[null,null,null,"÷",null,{"$f":"Input!D12","v":500},null,"feeders"]
[null,null,null,"=",null,{"$f":"SUM(F157*F158*F160)/F161","v":9.4499999999999993},null,"/feeder"]
[]
[null,null,"MBP levy, WLPIP, selling commission"]
[null,null,null,"+",null,{"$f":"Input!D112","v":5.5},null,"MBP Levy"]
[null,null,null,"+",null,{"$f":"Input!D19*Breakeven!F30/100","v":0},null,"WLPIP Insurance Premium"]
[null,null,null,"+",null,{"$f":"Input!D113","v":20},null,"commission "]
[null,null,null,"=",null,{"$f":"+F165+F167+F166","v":25.5},null,"/feeder"]
[]
[null,null,"Total","=",null,{"$f":"F162+F168","v":34.950000000000003},null,"/feeder"]
[]
[null,null,"2.07  Insurance"]
[null,null,null,null,null,{"$f":"Input!D156","v":192600},null,"building & equipment investment"]
[null,null,null,"x",null,{"$f":"Input!D126","v":0.4},null,"/$100 capital"]
[null,null,null,"÷",null,100,null,"/$100 "]
[null,null,null,"÷",null,{"$f":"Input!D12","v":500},null,"feeder cattle"]
[null,null,null,"=",null,{"$f":"ROUND(F173*F174/F175/F176,2)","v":1.54},null,"/feeder"]
[]
[null,null,null,null,null,{"$f":"ROUND((((Input!D14*Input!D15/100)+(Input!D16*Input!D17/100))/2)*Input!D12,2)","v":1230000},null,"herd investment"]
[null,null,null,"x",null,{"$f":"Input!D125","v":0},null,"/$100 capital"]
[null,null,null,"÷",null,100,null,"/$100 "]
[null,null,null,"÷",null,{"$f":"Input!D12","v":500},null,"feeder cattle"]
[null,null,null,"=",null,{"$f":"ROUND(F179*F180/F181/F182,2)","v":0},null,"/feeder"]
[]
[null,null,null,null,null,{"$f":"Input!D127","v":49},null,"additional coverage for liability"]
[null,null,null,"÷",null,{"$f":"Input!D12","v":500},null,"feeder cattle"]
[null,null,null,"=",null,{"$f":"F185/F186","v":9.8000000000000004E-2},null,"/feeder"]
[]
[null,null,"Total","=",null,{"$f":"ROUND(F177+F183+F187,2)","v":1.64},null,"/feeder"]
[]
[null,null,"2.08  Manure Removal"]
[null,null,null,null,"=",{"$f":"Input!B32","v":160},null,"days on feed"]
[null,null,null,null,"x",{"$f":"Input!D118","v":2.4E-2},null,"m3/feeder/day"]
[null,null,null,null,"=",{"$f":"IF(F192=\"ERROR\",\"ERROR\",SUM(F192*F193))","v":3.84},null,"m3 manure volume"]
[null,null,null,null,"x",{"$f":"Input!D119","v":75},null,"% volume shrink"]
[null,null,null,null,"x",1.3079499999999999,null,"yd3 per m3"]
[null,null,null,null,"x",{"$f":"Input!D120","v":15},null,"yd3 manure removal cost"]
[null,null,null,null,"=",{"$f":"IF(F192=\"ERROR\",\"ERROR\",SUM(F194*(1-(F195/100))*F196*F197))","v":18.834479999999999},null,"/feeder"]
[]
[null,null,"2.09  Barn & Office Supplies"]
[null,null,null,null,null,{"$f":"Input!D130","v":600},null,"total barn expenses"]
[null,null,null,"÷",null,{"$f":"Input!D12","v":500},null,"feeder cattle"]
[null,null,null,"=",null,{"$f":"ROUND(F201/F202,2)","v":1.2},null,"/feeder"]
[]
[null,null,"2.10  Death Loss"]
[null,null,null,null,null,{"$f":"F90","v":1965.25},null,"feeder cattle cost"]
[null,null,null,"+",null,{"$f":"SUM(Summary!F18:F28)","v":2397.3013599999999},null,"maximum value"]
[null,null,null,"-",null,{"$f":"Summary!F25","v":34.950000000000003},null,"selling costs"]
[null,null,null,"÷",null,2,null,"average"]
[null,null,null,"x",null,{"$f":"Input!D13","v":2},null,"% mortality rate"]
[null,null,null,"=",null,{"$f":"ROUND(((F206+(F207-F208))/F209)*F210/100,2)","v":43.28},null,"/feeder"]
[]
[null,null,"2.11  Operating Interest"]
[null,null,"(Operating interest is charged on one half the subtotal operating costs)"]
[]
[null,null,null,null,null,{"$f":"F90","v":1965.25},null,"feeder cost"]
[null,null,null,"+",null,{"$f":"(Summary!F18+SUM(Summary!F21:F29))/2","v":237.66567999999998},null,"½ of feed & other costs"]
[null,null,null,"x",null,{"$f":"Input!D132","v":9},null,"% operating interest"]
[null,null,null,"x",null,{"$f":"Input!B32","v":160},null,"days on feed"]
[null,null,null,"÷",null,365,null,"days /year"]
[null,null,null,"=",null,{"$f":"ROUND(((F216+F217)*(F218)*(F219/F220/100)),2)","v":86.91},null,"/feeder"]
[]
[null,"Capital Costs"]
[]
[null,null,"  Buildings,Corrals & Water System"]
[null,null,"     Windbreak fence",null,null,null,null,{"$f":"Input!D140","v":6300}]
[null,null,"     Pens",null,null,null,null,{"$f":"Input!D141","v":5300}]
[null,null,"     Handling Facilities",null,null,null,null,{"$f":"Input!D142","v":7500}]
[null,null,"     Waterers",null,null,null,null,{"$f":"Input!D143","v":6000}]
[null,null,"     Gates",null,null,null,null,{"$f":"Input!D144","v":2000}]
[null,null,"     Feeders",null,null,null,null,{"$f":"Input!D145","v":1500}]
[null,null,"     Bunk Feeders",null,null,null,null,{"$f":"Input!D146","v":21000}]
[null,null,"     Well & Pressure System",null,null,null,null,{"$f":"Input!D147","v":8000}]
[null,null,"     Grain Bin",null,null,null,null,{"$f":"Input!D148","v":5000}]
[null,null,"     Landscaping",null,null,null,null,{"$f":"Input!D149","v":17500}]
[null,null,"     Total",null,null,null,null,{"$f":"SUM(H226:H235)","v":80100}]
[]
[null,null,"  Machinery & Equipment",null,null,null,""]
[null,null,"     Tractor & Loader",null,null,null,null,{"$f":"Input!D153","v":52500}]
[null,null,"     Miscellaneous",null,null,null,null,{"$f":"Input!D154","v":60000}]
[null,null,"     Total",null,null,null,null,{"$f":"SUM(H239:H240)","v":112500}]
[]
[null,null,"  Total Investment",null,null,null,null,{"$f":"H236+H241","v":192600}]
[]
[]
[null,"B.  Fixed Costs"]
[null,"3.  Depreciation",null,null,null,"Original Cost - Salvage Value"]
[null,null,null,null,null,"Useful Life"]
[null,null,"3.01  Buildings"]
[null,null,null,null,null,{"$f":"Input!D150","v":80100},null,"original cost"]
[null,null,null,"-",null,{"$f":"ROUND(Input!D150*(Input!E140/100),2)","v":8010},null,"salvage value"]
[null,null,null,"÷",null,{"$f":"Input!G140","v":20},null,"years useful life"]
[null,null,null,"÷",null,{"$f":"Input!D12","v":500},null,"feeder cattle"]
[null,null,null,"=",null,{"$f":"ROUND(((F250-F251)/F252/F253),2)","v":7.21},null,"/feeder"]
[]
[null,null,"3.02  Machinery & Equipment"]
[null,null,null,null,null,{"$f":"Input!D153+Input!D154","v":112500},null,"original cost"]
[null,null,null,"-",null,{"$f":"ROUND(F257*(Input!E153/100),2)","v":22500},null,"salvage value"]
[null,null,null,"÷",null,{"$f":"Input!G153","v":10},null,"years useful life"]
[null,null,null,"÷",null,{"$f":"Input!D12","v":500},null,"feeder cattle"]
[null,null,null,"=",null,{"$f":"ROUND(((F257-F258)/F259/F260),2)","v":18},null,"/feeder"]
[]
[null,"4.  Investment",null,null,"   Original Cost + Salvage Value  x  Investment Rate"]
[null,null,null,null,null,"       2"]
[null,null,"4.01  Buildings"]
[null,null,null,null,null,{"$f":"F250","v":80100},null,"original cost"]
[null,null,null,"+",null,{"$f":"F251","v":8010},null,"salvage value"]
[null,null,null,"÷",null,2,null,"average"]
[null,null,null,"x",null,{"$f":"Input!D133","v":4},null,"% investment rate"]
[null,null,null,"÷",null,{"$f":"Input!D12","v":500},null,"feeder cattle"]
[null,null,null,"=",null,{"$f":"ROUND(((F266+F267)/F268*(F269/100)/F270),2)","v":3.52},null,"/feeder"]
[]
[null,null,"4.02  Machinery & Equipment"]
[null,null,null,null,null,{"$f":"F257","v":112500},null,"original cost "]
[null,null,null,"+",null,{"$f":"F258","v":22500},null,"salvage value"]
[null,null,null,"÷",null,2,null,"average"]
[null,null,null,"x",null,{"$f":"Input!D133","v":4},null,"% investment rate"]
[null,null,null,"÷",null,{"$f":"Input!D12","v":500},null,"feeder cattle"]
[null,null,null,"=",null,{"$f":"ROUND(((F274+F275)/F276*(F277/100)/F278),2)","v":5.4},null,"/feeder"]
[]
[null,"C. Labour"]
[null,null,null,null,null,{"$f":"Input!E160","v":1},null,"hours/feeder/year"]
[null,null,null,"÷",null,{"$f":"Input!E161","v":27},null,"/hour"]
[null,null,null,"=",null,{"$f":"ROUND(F282*F283,2)","v":27},null,"/feeder"]

{"sheet":"Breakeven","index":8,"n_rows":82,"n_cols":10,"rows_kept":82,"cut":false,"hidden":false,"merged":[[77,0,79,9],[1,0,1,9],[73,0,73,9],[75,0,76,9]]}
[]
["Breakeven Calculations"]
[]
["    Cost per lb of gain sold (shrunk weight)"]
[null,"Feed Costs",null,null,null,{"$f":"Summary!F18","v":313.04999999999995},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.83927613941018753},null,"/lb (gain sold)"]
[]
[null,"Operating Costs",null,null,null,{"$f":"Summary!F32","v":2527.4899999999998},null,"operating costs"]
[null,null,null,null,"-",{"$f":"Details!$F$88","v":1950},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.5482305630026805},null,"/lb (gain sold)"]
[]
[null,"Operating & Labour Costs",null,null,null,{"$f":"Summary!F32+Summary!F43","v":2554.4899999999998},null,"operating costs"]
[null,null,null,null,"-",{"$f":"F10","v":1950},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.6206166219839135},null,"/lb (gain sold)"]
[]
[null,"Operating & Fixed",null,null,null,{"$f":"Summary!F41","v":2561.62},null,"oper.  & fixed costs"]
[null,null,null,null,"-",{"$f":"Details!$F$88","v":1950},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.6397319034852544},null,"/lb (gain sold)"]
[]
[null,"Total Costs",null,null,null,{"$f":"Summary!F44","v":2588.62},null,"total costs"]
[null,null,null,null,"-",{"$f":"Details!$F$88","v":1950},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.7121179624664877},null,"/lb (gain sold)"]
["    Breakeven selling price (shrunk weight)"]
[null,"Operating Costs",null,null,null,{"$f":"Summary!F32","v":2527.4899999999998},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":2.8951775486827032},null,"/lb "]
[]
[null,"Operating & Labour Costs",null,null,null,{"$f":"Summary!F32+Summary!F43","v":2554.4899999999998},null,"operating & labour "]
[null,null,null,null,"÷",{"$f":"F30","v":873},null,"lbs shrunk weight"]
[null,null,null,null,"=",{"$f":"F33/F34","v":2.9261053837342494},null,"/lb "]
[]
[null,"Operating & Fixed",null,null,null,{"$f":"Summary!F41","v":2561.62},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":2.9342726231386025},null,"/lb "]
[]
[null,"Total Costs",null,null,null,{"$f":"Summary!F44","v":2588.62},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":2.9652004581901488},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":330},null,"$/cwt selling price"]
[null,null,null,null,"=",{"$f":"F46*F47/100","v":2880.9},null,"income"]
[null,null,null,null,"-",{"$f":"Summary!F32-Details!$F$88","v":577.48999999999978},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":4.6068200000000008},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":330},null,"$/cwt selling price"]
[null,null,null,null,"=",{"$f":"F48","v":2880.9},null,"income"]
[null,null,null,null,"-",{"$f":"(Summary!F32+Summary!F43)-Details!F88","v":604.48999999999978},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":4.5528200000000005},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":330},null,"$/cwt selling price"]
[null,null,null,null,"=",{"$f":"F60*F61/100","v":2880.9},null,"income"]
[null,null,null,null,"-",{"$f":"Summary!F41-Details!$F$88","v":611.61999999999989},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":4.5385600000000004},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":330},null,"$/cwt selling price"]
[null,null,null,null,"=",{"$f":"F67*F68/100","v":2880.9},null,"income"]
[null,null,null,null,"-",{"$f":"Summary!F44-Details!$F$88","v":638.61999999999989},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":4.4845600000000001},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 $3.30/lb = $2880.90)"}]
[{"$f":"\"Return on Investment (ROI) = (Gross Revenue - Total Cost) / Total Cost \n(eg. ($\"&TEXT(Summary!F49,\"0.00\")&\" - $\"&TEXT(Summary!F44,\"0.00\")&\") / $\"&TEXT(Summary!F44,\"0.00\")&\" = \"&TEXT(100*Summary!F68,\"0.0\")&\"%\"","v":"Return on Investment (ROI) = (Gross Revenue - Total Cost) / Total Cost \n(eg. ($2880.90 - $2588.62) / $2588.62 = 11.3%"}]
[]
[{"$f":"\"Return on Asset (ROA) = (Margin Over Operating - Labour - Building Depreciation - Machinery Depreciation) / (Building, Machinery & Equipment Investment / Herd Size) (eg. ($\"&TEXT(Summary!H63,\"0.00\")&\" - $\"&TEXT(Summary!F43,\"0.00\")&\" - $\"&TEXT(Summary!F35,\"0.00\")&\" - $\"&TEXT(Summary!F36,\"0.00\")&\") / ($\"&TEXT(Input!D156,\"#,###\")&\" / \"&Input!D12&\") = \"&TEXT(100*Summary!F69,\"0.0\")&\"%\"","v":"Return on Asset (ROA) = (Margin Over Operating - Labour - Building Depreciation - Machinery Depreciation) / (Building, Machinery & Equipment Investment / Herd Size) (eg. ($353.41 - $27.00 - $7.21 - $18.00) / ($192,600 / 500) = 78.2%"}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"September, 2023"]

{"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":38,"n_cols":13,"rows_kept":38,"cut":false,"hidden":true,"merged":[[26,12,28,17]]}
["2023 Beef Background Calves - Total Production Costs (cost/feeder)"]
["Feed Cost",{"$f":"Summary!F18","v":313.04999999999995},{"$f":"SUM(B2/$B$8)","v":0.12093316129829793}]
["Feeder Cost",{"$f":"Summary!F20","v":1965.25},0.7591882933763936]
["Other Operating Cost",{"$f":"Summary!F32-Summary!F20-Summary!F18","v":249.18999999999983},9.6263646267122957E-2]
["Fixed Cost - Depreciation",{"$f":"Summary!F35+Summary!F36","v":25.21},9.7387797359210701E-3]
["Fixed Cost - Investment",{"$f":"SUM(Summary!F38+Summary!F39)","v":8.92},3.4458514575333578E-3]
["Labour",{"$f":"SUM(Summary!F43)","v":27},1.0430267864731016E-2]
[null,{"$f":"SUM(B2:B7)","v":2588.62}]
[]
["2023 Beef Background Calves - Other Operating Costs (cost/feeder)"]
["Straw",{"$f":"Summary!F21","v":22.4}]
["Veterinary Medicine & Supplies",{"$f":"Summary!F22","v":25.76}]
["Fuel, Maintenance & Repairs",{"$f":"Summary!F23","v":10.826879999999999}]
["Utilities",{"$f":"Summary!F24","v":3.39}]
["Feeder Selling Cost",{"$f":"Summary!F25","v":34.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":43.28}]
["Operating Interest",{"$f":"Summary!F31","v":86.91}]
[null,{"$f":"SUM(B11:B20)","v":249.19136}]
[]
[]
[{"$f":"\"2023 Beef Backgrounding - Costs Not Covered (\"&Input!D16&\" lb. steers)\"","v":"2023 Beef Backgrounding - Costs Not Covered (900 lb. steers)"}]
["Calf Price","Gross revenue",{"$f":"\"Operating Costs = $\"&ROUND(Summary!F32,0)","v":"Operating Costs = $2527"},{"$f":"\"Fixed Costs = $\"&ROUND(Summary!F40,0)","v":"Fixed Costs = $34"},{"$f":"\"Labour Cost = $\"&ROUND(Summary!F43,0)","v":"Labour Cost = $27"},"Total",null,null,{"$f":"C25","v":"Operating Costs = $2527"},{"$f":"D25","v":"Fixed Costs = $34"},{"$f":"A25","v":"Calf Price"}]
[]
[{"$f":"SUM(A28+2)","v":340},{"$f":"SUM((A27/100)*(Input!$D$39+Input!$D$14))","v":2968.2},{"$f":"IF(Summary!$F$32-B27<0,0,SUM(Summary!$F$32-B27))","v":0},{"$f":"IF(Summary!$F$32+Summary!$F$40-B27<0,0,SUM(Summary!$F$32+Summary!$F$40-B27-C27))","v":0},{"$f":"IF(Summary!$F$32+Summary!$F$40+Summary!$F$43-B27<0,0,SUM(Summary!$F$32+Summary!$F$40+Summary!$F$43-B27-C27-D27))","v":0},{"$f":"SUM(C27:E27)","v":0},null,null,{"$f":"C27","v":0},0,{"$f":"A27","v":340},null,{"$f":"\"Market prices of $\"&ROUND(Summary!H57,0)&\"/cwt and lower do not cover both operating and fixed costs.  This can indicate the potential need for WLPIP coverage and is an important step in Risk Management Planning).\"","v":"Market prices of $293/cwt and lower do not cover both operating and fixed costs.  This can indicate the potential need for WLPIP coverage and is an important step in Risk Management Planning)."}]
[{"$f":"SUM(A29+2)","v":338},{"$f":"SUM((A28/100)*(Input!$D$39+Input!$D$14))","v":2950.74},{"$f":"IF(Summary!$F$32-B28<0,0,SUM(Summary!$F$32-B28))","v":0},{"$f":"IF(Summary!$F$32+Summary!$F$40-B28<0,0,SUM(Summary!$F$32+Summary!$F$40-B28-C28))","v":0},{"$f":"IF(Summary!$F$32+Summary!$F$40+Summary!$F$43-B28<0,0,SUM(Summary!$F$32+Summary!$F$40+Summary!$F$43-B28-C28-D28))","v":0},0,null,null,0,0,338]
[{"$f":"SUM(A30+2)","v":336},{"$f":"SUM((A29/100)*(Input!$D$39+Input!$D$14))","v":2933.2799999999997},{"$f":"IF(Summary!$F$32-B29<0,0,SUM(Summary!$F$32-B29))","v":0},{"$f":"IF(Summary!$F$32+Summary!$F$40-B29<0,0,SUM(Summary!$F$32+Summary!$F$40-B29-C29))","v":0},{"$f":"IF(Summary!$F$32+Summary!$F$40+Summary!$F$43-B29<0,0,SUM(Summary!$F$32+Summary!$F$40+Summary!$F$43-B29-C29-D29))","v":0},0,null,null,0,0,336]
[{"$f":"SUM(A31+2)","v":334},{"$f":"SUM((A30/100)*(Input!$D$39+Input!$D$14))","v":2915.8199999999997},{"$f":"IF(Summary!$F$32-B30<0,0,SUM(Summary!$F$32-B30))","v":0},{"$f":"IF(Summary!$F$32+Summary!$F$40-B30<0,0,SUM(Summary!$F$32+Summary!$F$40-B30-C30))","v":0},{"$f":"IF(Summary!$F$32+Summary!$F$40+Summary!$F$43-B30<0,0,SUM(Summary!$F$32+Summary!$F$40+Summary!$F$43-B30-C30-D30))","v":0},0,null,null,0,0,334]
[{"$f":"SUM(A32+2)","v":332},{"$f":"SUM((A31/100)*(Input!$D$39+Input!$D$14))","v":2898.3599999999997},{"$f":"IF(Summary!$F$32-B31<0,0,SUM(Summary!$F$32-B31))","v":0},{"$f":"IF(Summary!$F$32+Summary!$F$40-B31<0,0,SUM(Summary!$F$32+Summary!$F$40-B31-C31))","v":0},{"$f":"IF(Summary!$F$32+Summary!$F$40+Summary!$F$43-B31<0,0,SUM(Summary!$F$32+Summary!$F$40+Summary!$F$43-B31-C31-D31))","v":0},0,null,null,0,0,332]
[{"$f":"ROUND(Input!D17,0)","v":330},{"$f":"SUM((A32/100)*(Input!$D$39+Input!$D$14))","v":2880.8999999999996},{"$f":"IF(Summary!$F$32-B32<0,0,SUM(Summary!$F$32-B32))","v":0},{"$f":"IF(Summary!$F$32+Summary!$F$40-B32<0,0,SUM(Summary!$F$32+Summary!$F$40-B32-C32))","v":0},{"$f":"IF(Summary!$F$32+Summary!$F$40+Summary!$F$43-B32<0,0,SUM(Summary!$F$32+Summary!$F$40+Summary!$F$43-B32-C32-D32))","v":0},0,null,null,0,0,330]
[{"$f":"SUM(A32-2)","v":328},{"$f":"SUM((A33/100)*(Input!$D$39+Input!$D$14))","v":2863.44},{"$f":"IF(Summary!$F$32-B33<0,0,SUM(Summary!$F$32-B33))","v":0},{"$f":"IF(Summary!$F$32+Summary!$F$40-B33<0,0,SUM(Summary!$F$32+Summary!$F$40-B33-C33))","v":0},{"$f":"IF(Summary!$F$32+Summary!$F$40+Summary!$F$43-B33<0,0,SUM(Summary!$F$32+Summary!$F$40+Summary!$F$43-B33-C33-D33))","v":0},0,null,null,0,0,328]
[326,{"$f":"SUM((A34/100)*(Input!$D$39+Input!$D$14))","v":2845.98},{"$f":"IF(Summary!$F$32-B34<0,0,SUM(Summary!$F$32-B34))","v":0},{"$f":"IF(Summary!$F$32+Summary!$F$40-B34<0,0,SUM(Summary!$F$32+Summary!$F$40-B34-C34))","v":0},{"$f":"IF(Summary!$F$32+Summary!$F$40+Summary!$F$43-B34<0,0,SUM(Summary!$F$32+Summary!$F$40+Summary!$F$43-B34-C34-D34))","v":0},0,null,null,0,0,326]
[324,{"$f":"SUM((A35/100)*(Input!$D$39+Input!$D$14))","v":2828.52},{"$f":"IF(Summary!$F$32-B35<0,0,SUM(Summary!$F$32-B35))","v":0},{"$f":"IF(Summary!$F$32+Summary!$F$40-B35<0,0,SUM(Summary!$F$32+Summary!$F$40-B35-C35))","v":0},{"$f":"IF(Summary!$F$32+Summary!$F$40+Summary!$F$43-B35<0,0,SUM(Summary!$F$32+Summary!$F$40+Summary!$F$43-B35-C35-D35))","v":0},0,null,null,0,0,324]
[322,{"$f":"SUM((A36/100)*(Input!$D$39+Input!$D$14))","v":2811.06},{"$f":"IF(Summary!$F$32-B36<0,0,SUM(Summary!$F$32-B36))","v":0},{"$f":"IF(Summary!$F$32+Summary!$F$40-B36<0,0,SUM(Summary!$F$32+Summary!$F$40-B36-C36))","v":0},{"$f":"IF(Summary!$F$32+Summary!$F$40+Summary!$F$43-B36<0,0,SUM(Summary!$F$32+Summary!$F$40+Summary!$F$43-B36-C36-D36))","v":0},0,null,null,0,0,322]
[320,{"$f":"SUM((A37/100)*(Input!$D$39+Input!$D$14))","v":2793.6000000000004},{"$f":"IF(Summary!$F$32-B37<0,0,SUM(Summary!$F$32-B37))","v":0},{"$f":"IF(Summary!$F$32+Summary!$F$40-B37<0,0,SUM(Summary!$F$32+Summary!$F$40-B37-C37))","v":0},{"$f":"IF(Summary!$F$32+Summary!$F$40+Summary!$F$43-B37<0,0,SUM(Summary!$F$32+Summary!$F$40+Summary!$F$43-B37-C37-D37))","v":0},0,null,null,0,0,320]
[318,{"$f":"SUM((A38/100)*(Input!$D$39+Input!$D$14))","v":2776.1400000000003},{"$f":"IF(Summary!$F$32-B38<0,0,SUM(Summary!$F$32-B38))","v":0},{"$f":"IF(Summary!$F$32+Summary!$F$40-B38<0,0,SUM(Summary!$F$32+Summary!$F$40-B38-C38))","v":0},{"$f":"IF(Summary!$F$32+Summary!$F$40+Summary!$F$43-B38<0,0,SUM(Summary!$F$32+Summary!$F$40+Summary!$F$43-B38-C38-D38))","v":0},0,null,null,0,0,318]

{"sheet":"More...Breakeven (HIDE)","index":11,"n_rows":93,"n_cols":10,"rows_kept":93,"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":330},"  /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.39812556674006239},null,null,{"$f":"F64","v":233.25555492554412}]
["     Operating Costs & Labour",null,null,null,null,{"$f":"F36","v":0.39417955321178016},null,null,{"$f":"F71","v":235.59060647193584}]
["     Operating & Fixed Costs",null,null,null,null,{"$f":"F46","v":0.3931505348167551},null,null,{"$f":"F78","v":236.20723304696449}]
["     Total Costs",null,null,null,null,{"$f":"F56","v":0.38930204830689558},null,null,{"$f":"F85","v":238.54228459335621}]
[]
[" 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":2527.4899999999998},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":308.94775486827035},null,"/cwt cost"]
[]
[null,null,null,null,"=",{"$f":"SUM(F18/F24)","v":0.39812556674006239},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!F43","v":2554.4899999999998},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":312.04053837342497},null,"/cwt cost"]
[]
[null,null,null,null,"=",{"$f":"SUM(F28/F34)","v":0.39417955321178016},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!F41","v":2561.62},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":312.85726231386025},null,"/cwt cost"]
[]
[null,null,null,null,"=",{"$f":"SUM(F38/F44)","v":0.3931505348167551},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!F44","v":2588.62},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":315.95004581901486},null,"/cwt cost"]
[]
[null,null,null,null,"=",{"$f":"SUM(F48/F54)","v":0.38930204830689558},null,"  /USD"]
[]
["    Breakeven US Futures (shrunk weight)"]
[null,"Operating Costs",null,null,null,{"$f":"Summary!F32","v":2527.4899999999998},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":233.25555492554412},null,"/cwt (USD)"]
[]
[null,"Operating & Labour Costs",null,null,null,{"$f":"Summary!F32+Summary!F43","v":2554.4899999999998},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":235.59060647193584},null,"/cwt (USD)"]
[]
[null,"Operating & Fixed",null,null,null,{"$f":"Summary!F41","v":2561.62},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":236.20723304696449},null,"/cwt (USD)"]
[]
[null,"Total Costs",null,null,null,{"$f":"Summary!F44","v":2588.62},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":238.54228459335621},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",null,null,null,"Bob Gwyer"]
["Farm Management Specialist         ",null,null,null,"Farm Management Specialist         ",null,null,null,"Farm Management Specialist         "]
[]
["Greg Fedak",null,null,null,"Wayne Tomlinson",null,null,null,"Ray Bittner"]
["Farm Management Specialist         ",null,null,null,"Extension Veterinarian",null,null,null,"Farm Production Extension"]