{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["Introduction","Summary","Summary (2)","Charts","Charts (2)","Risk Analysis","Input","Operating ","Pasture","Winter Feed Rations","Fixed","Extended Grazing","Details","Housing","Chart data (HIDE)","Cow Lease","Cow Overwinter","Cow Value"],"not_rendered":{"charts":19,"images":4,"macros":1,"external_links":0,"defined_names":131,"comments":5,"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":47,"n_cols":9,"rows_kept":47,"cut":false,"hidden":false,"merged":[[46,1,48,8],[4,0,4,9],[5,0,5,9],[6,0,6,9],[15,1,22,8],[24,1,28,8]]}
[]
[]
[". . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . "]
[]
["Guidelines For Estimating"]
["Beef Cow-Calf Production Costs"]
[{"$f":"\"Based on a \"&Input!E13&\" Head Cow Herd - \"&IF('Winter Feed Rations'!E9>0,'Winter Feed Rations'!E10,IF('Winter Feed Rations'!F9>0,'Winter Feed Rations'!F10,IF('Winter Feed Rations'!G9>0,'Winter Feed Rations'!G10,IF('Winter Feed Rations'!H9>0,'Winter Feed Rations'!H10,IF('Winter Feed Rations'!I9>0,'Winter Feed Rations'!I10,IF('Winter Feed Rations'!J9>0,'Winter Feed Rations'!J10,IF('Winter Feed Rations'!K9>0,'Winter Feed Rations'!K10,IF('Winter Feed Rations'!L9>0,'Winter Feed Rations'!L10,\"Custom\"))))))))&\" Ration\"","v":"Based on a 150 Head Cow Herd - Hay Ration"}]
[]
[]
[null,null,null,null,null,null,"Date:",null,"September, 2024"]
[]
[]
[]
[]
[]
[null,"This guide is designed to provide you with planning information and a format for calculating costs of production of a cow 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,"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,null,null,null,null,null,"is also available to "]
[null,"help 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":82,"n_cols":12,"rows_kept":82,"cut":false,"hidden":false,"merged":[[1,1,1,9],[0,1,0,9],[81,1,83,9],[73,0,73,9]]}
[null,{"$f":"\"Cow-Calf Production Costs - \"&Introduction!I10&\"\"","v":"Cow-Calf Production Costs - September, 2024"}]
[null,{"$f":"\"Based on a \"&Input!E13&\" Cow Herd\"","v":"Based on a 150 Cow Herd"}]
[]
["A.  Operating Costs",null,null,null,null,"Cost/Cow","","Total Cost",null,"Your Cost"]
[null,"1.  Feed Costs"]
[null,"   Grain and Concentrates",null,null,null,{"$f":"SUM('Winter Feed Rations'!O40:O43)+SUM('Winter Feed Rations'!O19:O22)","v":27.120535714285715},null,{"$f":"ROUND(F6*Input!$E$13,0)","v":4068}]
[null,"   Forages",null,null,null,{"$f":"SUM('Winter Feed Rations'!O33:O39)+SUM('Winter Feed Rations'!O12:O18)","v":408.36294642857143},null,{"$f":"ROUND(F7*Input!$E$13,0)","v":61254}]
[null,"   Salt & Minerals",null,null,null,{"$f":"SUM('Winter Feed Rations'!O44:O47)+SUM('Winter Feed Rations'!O23:O26)+SUM((((Pasture!G3+Pasture!G4)*0.07)/'Winter Feed Rations'!C26)*'Winter Feed Rations'!B26)+SUM((((Pasture!G3+Pasture!G4)*0.12)/'Winter Feed Rations'!C23)*'Winter Feed Rations'!B23)","v":47.086688311688313},null,{"$f":"ROUND(F8*Input!$E$13,0)","v":7063}]
[null,"   Extended Grazing Forages",null,null,null,{"$f":"IF('Extended Grazing'!G49=\"ERROR\",\"ERROR\",'Extended Grazing'!G53)","v":41.65468833333334},null,{"$f":"ROUND(F9*Input!$E$13,0)","v":6248}]
[null,"Total Feed Cost",null,null,null,{"$f":"IF('Winter Feed Rations'!H54=Pasture!G5,F6+F7+F8+F9,\"ERROR\")","v":524.22485878787882},null,{"$f":"SUM(H6:H9)","v":78633}]
[]
[null,"2.  Other Operating Costs",null,null,null,""]
[null,"    Straw",null,null,null,{"$f":"'Operating '!D26*'Operating '!D25","v":70},null,{"$f":"ROUND(F13*Input!$E$13,0)","v":10500}]
[null,"    Veterinary Medicine & Supplies",null,null,null,{"$f":"'Operating '!G21","v":30.676666666666662},null,{"$f":"ROUND(F14*Input!$E$13,0)","v":4602}]
[null,"    Breeding Costs",null,null,null,{"$f":"Input!G91","v":46.42},null,{"$f":"ROUND(F15*Input!$E$13,0)","v":6963}]
[null,"    Fuel, Maintenance & Repairs",null,null,null,{"$f":"'Operating '!G48","v":42.717300000000002},null,{"$f":"ROUND(F16*Input!$E$13,0)","v":6408}]
[null,"    Utilities",null,null,null,{"$f":"'Operating '!G59","v":11.688774},null,{"$f":"ROUND(F17*Input!$E$13,0)","v":1753}]
[null,"    Marketing & Transportation",null,null,null,{"$f":"'Operating '!G93","v":39.598333333333329},null,{"$f":"ROUND(F18*Input!$E$13,0)","v":5940}]
[null,"    Death Loss",null,null,null,{"$f":"'Operating '!G97","v":32.5},null,{"$f":"ROUND(F19*Input!$E$13,0)","v":4875}]
[null,"    Manure Removal",null,null,null,{"$f":"'Operating '!G108","v":10.839635625},null,{"$f":"ROUND(F20*Input!$E$13,0)","v":1626}]
[null,"    Insurance",null,null,null,{"$f":"'Operating '!G122","v":18.829999999999998},null,{"$f":"ROUND(F21*Input!$E$13,0)","v":2825}]
[null,"    Herd Replacement",null,null,null,{"$f":"Input!E38","v":148.5},null,{"$f":"ROUND(F22*Input!$E$13,0)","v":22275}]
[null,"    Pasture Rental",null,null,null,{"$f":"Pasture!J122","v":59.375},null,{"$f":"ROUND(F23*Input!$E$13,0)","v":8906}]
[null,"    Pasture Operating",null,null,null,{"$f":"Pasture!J121","v":34.765106382978729},null,{"$f":"ROUND(F24*Input!$E$13,0)","v":5215}]
[null,"    Labour - Hired",null,null,null,{"$f":"'Operating '!G136","v":0},null,{"$f":"ROUND(F25*Input!$E$13,0)","v":0}]
[null,"    Miscellaneous",null,null,null,{"$f":"'Operating '!G126","v":6.67},null,{"$f":"ROUND(F26*Input!$E$13,0)","v":1001}]
[null,"Subtotal Operating Costs",null,null,null,{"$f":"SUM(F10:F26)","v":1076.8056747958576},null,{"$f":"SUM(H10:H26)","v":161522}]
[null,"    Operating Interest",null,null,null,{"$f":"'Operating '!G132","v":40.380200000000002},null,{"$f":"ROUND(F28*Input!$E$13,0)","v":6057}]
[null,"Total Operating Costs",null,null,null,{"$f":"F27+F28","v":1117.1858747958577},null,{"$f":"SUM(H27:H28)","v":167579}]
[]
["B.  Fixed Costs"]
[null,"    Livestock",null,null,null,{"$f":"Fixed!D12","v":72.365755656152146},null,{"$f":"ROUND(F32*Input!$E$13,0)","v":10855}]
[null,"    Buildings",null,null,null,{"$f":"Fixed!I29","v":35.06965218239641},null,{"$f":"ROUND(F33*Input!$E$13,0)","v":5260}]
[null,"    Machinery & Equipment",null,null,null,{"$f":"Fixed!I15","v":138.54189176473227},null,{"$f":"ROUND(F34*Input!$E$13,0)","v":20781}]
[null,"    Pasture Land & Fencing",null,null,null,{"$f":"IF(Pasture!J114=Input!E13,Pasture!J123,\"ERROR\")","v":64.403002546173056},null,{"$f":"ROUND(F35*Input!$E$13,0)","v":9660}]
[null,"Total Fixed Costs",null,null,null,{"$f":"SUM(F32:F35)","v":310.38030214945388},null,{"$f":"SUM(H32:H35)","v":46556}]
[]
["C. Owners -  Labour & Living",null,null,null,null,{"$f":"'Operating '!G137","v":216},null,{"$f":"ROUND(F38*Input!$E$13,0)","v":32400}]
[]
["Total Cost of Production",null,null,null,null,{"$f":"F38+F36+F29","v":1643.5661769453116},null,{"$f":"H38+H36+H29","v":246535}]
[]
[null,null,null,"Profitability and Breakeven Analysis"]
["Estimated Farmgate",null,null,null,null," Per Cow","","Total",null,"Per Acre"]
[null,"Price ($ per cwt)",null,null,null,{"$f":"Input!E24","v":365.65}]
[null,"Calf weight (lbs)",null,null,null,{"$f":"Input!E23","v":575}]
[null,"Gross Revenue  / cow",null,null,null,{"$f":"SUM((Input!E24/100)*Input!E23)*(Input!E17/100)","v":1997.3631249999996},null,{"$f":"ROUND(F46*Input!$E$13,0)","v":299604},null,{"$f":"H46/(((Details!$J$40-'Extended Grazing'!$D$50-'Extended Grazing'!$F$50)/Input!$E$13)*Input!$E$13)","v":342.89312945597254}]
[]
[null,"Operating Expense Ratio",null,null,null,{"$f":"SUM(F29/F46)","v":0.55933037954521059}]
[]
["Marginal Returns "]
[null,"Over Feed Costs",null,null,null,{"$f":"SUM(F46-F10)","v":1473.1382662121209},null,{"$f":"ROUND(F51*Input!$E$13,0)","v":220971},null,{"$f":"H51/(((Details!$J$40-'Extended Grazing'!$D$50-'Extended Grazing'!$F$50)/Input!$E$13)*Input!$E$13)","v":252.89861853985829}]
[null,"Over Operating Costs",null,null,null,{"$f":"SUM(F46-F29)","v":880.17725020414196},null,{"$f":"ROUND(F52*Input!$E$13,0)","v":132027},null,{"$f":"H52/(((Details!$J$40-'Extended Grazing'!$D$50-'Extended Grazing'!$F$50)/Input!$E$13)*Input!$E$13)","v":151.10329368994968}]
[null,"Over Operating & Fixed Costs",null,null,null,{"$f":"SUM(F46-F29-F36)","v":569.79694805468807},null,{"$f":"ROUND(F53*Input!$E$13,0)","v":85470},null,{"$f":"H53/(((Details!$J$40-'Extended Grazing'!$D$50-'Extended Grazing'!$F$50)/Input!$E$13)*Input!$E$13)","v":97.819374155892348}]
[null,"Over Total Costs (Net Profit)",null,null,null,{"$f":"SUM(F46-F40)","v":353.79694805468807},null,{"$f":"ROUND(F54*Input!$E$13,0)","v":53070},null,{"$f":"H54/(((Details!$J$40-'Extended Grazing'!$D$50-'Extended Grazing'!$F$50)/Input!$E$13)*Input!$E$13)","v":60.73796871947124}]
[]
[null,null,null,null,null,"Price"]
["Breakeven (Lb. weaned calf) ",null,null,null,null,"($/cwt)"]
[null,"Over Feed & Operating Costs",null,null,null,{"$f":"($F$29/(Input!$E$17/100)/(Input!$E$23/100))","v":204.51915328070623}]
[null,"Over Feed, Operating & Fixed Costs",null,null,null,{"$f":"(($F$29+$F$36)/(Input!$E$17/100)/(Input!$E$23/100))","v":261.33934589387854}]
[null,"Over Total Costs",null,null,null,{"$f":"(($F$40)/(Input!$E$17/100)/(Input!$E$23/100))","v":300.88167998998836}]
[]
[null,"Over Feed Costs",null,null,null,{"$f":"($F$10/(Input!$E$17/100)/(Input!$E$23/100))","v":95.967937535538468},null,{"$f":"($F$10/(Input!$E$24/100))","v":143.36793621984927},null,null,null,"**Ben - Do you like this 'Darren' version of B/E??  Or the revised old version above?"]
[null,"Over Operating Costs",null,null,null,{"$f":"(($F$29-$F$10)/(Input!$E$17/100)/(Input!$E$23/100))","v":108.55121574516777},null,{"$f":"(($F$29-$F$10)/(Input!$E$24/100))","v":162.16628360672198}]
[null,"Over Livestock (Fixed) Costs",null,null,null,{"$f":"(($F$32)/(Input!$E$17/100)/(Input!$E$23/100))","v":13.247735589226938},null,{"$f":"(($F$32)/(Input!$E$24/100))","v":19.790990197224708}]
[null,"Over Building (Fixed) Costs",null,null,null,{"$f":"(($F$33)/(Input!$E$17/100)/(Input!$E$23/100))","v":6.4200736260679925},null,{"$f":"(($F$33)/(Input!$E$24/100))","v":9.5910439443173559}]
[null,"Over Machinery (Fixed) Costs",null,null,null,{"$f":"(($F$34)/(Input!$E$17/100)/(Input!$E$23/100))","v":25.362360048463575},null,{"$f":"(($F$34)/(Input!$E$24/100))","v":37.889208741893142}]
[null,"Over Pasture (Fixed) Costs",null,null,null,{"$f":"(($F$35)/(Input!$E$17/100)/(Input!$E$23/100))","v":11.790023349413833},null,{"$f":"(($F$35)/(Input!$E$24/100))","v":17.613292095220309}]
[null,"Over Labour - Owner Living ",null,null,null,{"$f":"(($F$38)/(Input!$E$17/100)/(Input!$E$23/100))","v":39.54233409610984},null,{"$f":"($F$38/(Input!$E$24/100))","v":59.072883905373992}]
[null,"Over Total Costs",null,null,null,{"$f":"(($F$40)/(Input!$E$17/100)/(Input!$E$23/100))","v":300.88167998998836},null,{"$f":"($F$40/(Input!$E$24/100))","v":449.49163871060074}]
[]
["Estimated Return on Investment (ROI)",null,null,null,null,{"$f":"(F46-F40)/F40","v":0.21526176007846892}]
["Estimated Return on Asset (ROA)",null,null,null,null,{"$f":"((F46-F29)-F38-Fixed!I27-Fixed!I13-Fixed!I41)/(SUM(Details!E12:E17)/Input!E13)","v":7.8331324145353751E-2}]
[]
["Cost Summary Per Cow Per Day"]
[]
[null,{"$f":"\"Summer grazing (based on \"&Pasture!G3&\" days)\"","v":"Summer grazing (based on 135 days)"},null,null,null,{"$f":"SUM((F35+F23+F24)/Pasture!G3)","v":1.1743933994751985}]
[null,{"$f":"\"Extended grazing (based on \"&Pasture!G4&\" days)\"","v":"Extended grazing (based on 35 days)"},null,null,null,{"$f":"IF('Extended Grazing'!G54=\"\",0,'Extended Grazing'!G54)","v":1.1901339523809527}]
[null,{"$f":"\"Winter feed (based on \"&Pasture!G5&\" days)\"","v":"Winter feed (based on 195 days)"},null,null,null,{"$f":"'Winter Feed Rations'!K54+((Input!G46+Input!G53)/Pasture!G5)","v":2.4606209207459209}]
[null,{"$f":"\"Yardage (based on \"&Pasture!G5+Pasture!G4&\" days)\"","v":"Yardage (based on 230 days)"},null,null,null,{"$f":"((H13+(Input!G59*Input!E13)+('Operating '!G118*Input!E13)+((H27-H14-H15-H18-H19-H22-H23-H24)/2*('Operating '!E131/100))+(H26*((Pasture!G4+Pasture!G5)/365))+H16+H17+(H20)+H33+H34+((H25+H38)*0.625))/(Input!E13))/(Pasture!G5+Pasture!G4)","v":2.0994562934286281}]
[null,{"$f":"\"Total Overwinter Costs (based on \"&Pasture!G5+Pasture!G4&\" days)\"","v":"Total Overwinter Costs (based on 230 days)"},null,null,null,{"$f":"SUM(((F78*Pasture!G5)+(F79*(Pasture!G5+Pasture!G4))+(F77*Pasture!G4))/(Pasture!G4+Pasture!G5))","v":4.3667422407277057}]
[]
[null,"Note: This budget is only a guide and is not intended to be 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":"Summary (2)","index":2,"n_rows":68,"n_cols":11,"rows_kept":68,"cut":false,"hidden":false,"merged":[[0,1,0,10],[1,1,1,10],[67,1,69,10]]}
[null,{"$f":"\"Cow-Calf Standardized Operating Statement - \"&Introduction!I10&\"\"","v":"Cow-Calf Standardized Operating Statement - September, 2024"}]
[null,{"$f":"\"Based on a \"&Input!E13&\" Cow Herd\"","v":"Based on a 150 Cow Herd"}]
[]
[null,null,null,null,null,"Per Cow","",null,"Total",null,"Your Farm"]
[" =","Revenue",null,null,null,{"$f":"Summary!F46","v":1997.3631249999996},null,null,{"$f":"Summary!H46","v":299604}]
[{"$f":"\" -\"","v":" -"},"Cost of Goods Sold (CoGS)"]
[null,null,null,"   Grain and Concentrates",null,{"$f":"SUM('Winter Feed Rations'!O40:O43)+SUM('Winter Feed Rations'!O19:O22)","v":27.120535714285715},{"$f":"SUM(F7/$F$5)","v":1.3578169825422065E-2},null,{"$f":"ROUND(F7*Input!$E$13,0)","v":4068}]
[null,null,null,"   Forages",null,{"$f":"SUM('Winter Feed Rations'!O33:O39)+SUM('Winter Feed Rations'!O12:O18)","v":408.36294642857143},0.20445102911798851,null,{"$f":"ROUND(F8*Input!$E$13,0)","v":61254}]
[null,null,null,"   Salt & Minerals",null,{"$f":"SUM('Winter Feed Rations'!O44:O47)+SUM('Winter Feed Rations'!O23:O26)+SUM((((Pasture!G3+Pasture!G4)*0.07)/'Winter Feed Rations'!C26)*'Winter Feed Rations'!B26)+SUM((((Pasture!G3+Pasture!G4)*0.12)/'Winter Feed Rations'!C23)*'Winter Feed Rations'!B23)","v":47.086688311688313},2.357442556254678E-2,null,{"$f":"ROUND(F9*Input!$E$13,0)","v":7063}]
[null,null,null,"   Extended Grazing Forages",null,{"$f":"IF('Extended Grazing'!G49=\"ERROR\",\"ERROR\",'Extended Grazing'!G53)","v":41.65468833333334},2.0854839969739278E-2,null,{"$f":"ROUND(F10*Input!$E$13,0)","v":6248}]
[null,null,null,"    Pasture Operating",null,{"$f":"Pasture!J121","v":34.765106382978729},1.7405501257052963E-2,null,{"$f":"ROUND(F11*Input!$E$13,0)","v":5215}]
[null,null,null,"    Straw",null,{"$f":"'Operating '!D26*'Operating '!D25","v":70},3.5046206232529707E-2,null,{"$f":"ROUND(F12*Input!$E$13,0)","v":10500}]
[null,null,null,"    Veterinary Medicine & Supplies",null,{"$f":"'Operating '!G21","v":30.676666666666662},1.5358582664665279E-2,null,{"$f":"ROUND(F13*Input!$E$13,0)","v":4602}]
[null,null,null,"    Death Loss",null,{"$f":"'Operating '!G97","v":32.5},{"$f":"SUM(F14/$F$5)","v":1.6271452893674508E-2},null,{"$f":"ROUND(F14*Input!$E$13,0)","v":4875}]
[null,null,null,"    Herd Replacement",null,{"$f":"Input!E38","v":148.5},{"$f":"SUM(F15/$F$5)","v":7.4348023221866594E-2},null,{"$f":"ROUND(F15*Input!$E$13,0)","v":22275}]
[null,null,null,"    Breeding Costs",null,{"$f":"Input!G91","v":46.42},2.3240641333057557E-2,null,{"$f":"ROUND(F16*Input!$E$13,0)","v":6963}]
[null,null,null,"    Manure Removal",null,{"$f":"'Operating '!G108","v":10.839635625},5.4269729371318005E-3,null,{"$f":"ROUND(F17*Input!$E$13,0)","v":1626}]
[null,null,null,null,null,{"$f":"SUM(F7:F17)","v":897.92626746252415},0.44955584501567503,null,{"$f":"SUM(I7:I17)","v":134689}]
[]
[" =","Gross Margin (GM)",null,null,null,{"$f":"SUM(F5-F18)","v":1099.4368575374756},{"$f":"SUM(F20/$F$5)","v":0.55044415498432508},null,{"$f":"SUM(I5-I18)","v":164915}]
[]
[{"$f":"\" -\"","v":" -"}," Direct Operating Expenses (DOE)"]
[null,null,null,"    Labour - Hired",null,{"$f":"'Operating '!G136","v":0},{"$f":"SUM(F23/$F$5)","v":0},null,{"$f":"ROUND(F23*Input!$E$13,0)","v":0}]
[null,null,null,"Owners -  Labour & Living",null,{"$f":"'Operating '!G137","v":216},0.10814257923180595,null,{"$f":"ROUND(F24*Input!$E$13,0)","v":32400}]
[null,null,null,"    Fuel, Maintenance & Repairs",null,{"$f":"'Operating '!G48","v":42.717300000000002},2.1386847221383447E-2,null,{"$f":"ROUND(F25*Input!$E$13,0)","v":6408}]
[null,null,null,"    Utilities",null,{"$f":"'Operating '!G59","v":11.688774},5.852102631563303E-3,null,{"$f":"ROUND(F26*Input!$E$13,0)","v":1753}]
[null,null,null,"    Marketing & Transportation",null,{"$f":"'Operating '!G93","v":39.598333333333329},1.9825305092349362E-2,null,{"$f":"ROUND(F27*Input!$E$13,0)","v":5940}]
[null,null,null,null,null,{"$f":"SUM(F23:F27)","v":310.00440733333335},0.15520683417710207,null,{"$f":"SUM(I23:I27)","v":46501}]
[]
[" =","Contribution Margin (CM)",null,null,null,{"$f":"SUM(F20-F28)","v":789.43245020414224},0.39523732080722296,null,{"$f":"SUM(I20-I28)","v":118414}]
[]
[{"$f":"\" -\"","v":" -"},"Operating Overheads (OH)"]
[null,null,null,"    Insurance",null,{"$f":"'Operating '!G122","v":18.829999999999998},9.4274294765504911E-3,null,{"$f":"ROUND(F33*Input!$E$13,0)","v":2825}]
[null,null,null,"    Miscellaneous",null,{"$f":"'Operating '!G126","v":6.67},3.3394027938710449E-3,null,{"$f":"ROUND(F34*Input!$E$13,0)","v":1001}]
[null,null,null,null,null,{"$f":"SUM(F33:F34)","v":25.5},1.2766832270421536E-2,null,{"$f":"SUM(I33:I34)","v":3826}]
[]
[" =","Earnings Before Interest Taxes Depreciation Amortization Rent (EBITDAR) or Operating Income"]
[null,"EBITDAR",null,null,null,{"$f":"SUM(F30-F35)","v":763.93245020414224},{"$f":"SUM(F38/$F$5)","v":0.38247048853680143},null,{"$f":"SUM(I30-I35)","v":114588}]
[]
[{"$f":"\" -\"","v":" -"},"Cost of Capital (CoC) or Depreciation/Amortization/Lease/Rent"]
[null,null,null,"Owned Cows Amortization Costs",null,{"$f":"-CUMPRINC(Fixed!C9,Fixed!D9,Fixed!D4*Fixed!D6,1,Fixed!D9,0)/Fixed!D9","v":55.714285714285722},{"$f":"SUM(F41/$F$5)","v":2.7893919246299158E-2},null,{"$f":"ROUND(F41*Input!$E$13,0)","v":8357}]
[null,null,null,"  Owned Cows Opportunity Cost",null,{"$f":"Fixed!D11","v":0},0,null,{"$f":"ROUND(F42*Input!$E$13,0)","v":0}]
[null,null,null,"Pasture & Fencing Depreciation Costs",null,{"$f":"Pasture!J135","v":9.3810638297872373},4.696724252274978E-3,null,{"$f":"ROUND(F43*Input!$E$13,0)","v":1407}]
[null,null,null,"Pasture & Fencing Amortization Costs",null,{"$f":"Pasture!J132","v":29.572948328267479},1.4805994943091524E-2,null,{"$f":"ROUND(F44*Input!$E$13,0)","v":4436}]
[null,null,null,"Pasture & Fencing Opportunity Costs",null,{"$f":"Pasture!J145","v":0},0,null,{"$f":"ROUND(F45*Input!$E$13,0)","v":0}]
[null,null,null,"    Pasture Rental",null,{"$f":"Pasture!J122","v":59.375},{"$f":"SUM(F46/$F$5)","v":2.9726692786520733E-2},null,{"$f":"ROUND(F46*Input!$E$13,0)","v":8906}]
[null,null,null,"  Building Depreciation Cost",null,{"$f":"Fixed!I27","v":20.68},1.0353650641267347E-2,null,{"$f":"ROUND(F47*Input!$E$13,0)","v":3102}]
[null,null,null," Building Amortization Costs ",null,{"$f":"-CUMPRINC(Fixed!H25,Fixed!I25,Fixed!I18*Fixed!I22,1,Fixed!I25,0)/Fixed!I25","v":11.078571428571431},5.5465985578217946E-3,null,{"$f":"ROUND(F48*Input!$E$13,0)","v":1662}]
[null,null,null," Building Opportunity Costs",null,{"$f":"Fixed!I28","v":0},0,null,{"$f":"ROUND(F49*Input!$E$13,0)","v":0}]
[null,null,null,"    Machinery & Eq. Depreciation Costs",null,{"$f":"Fixed!I13","v":94.64},4.7382470826380162E-2,null,{"$f":"ROUND(F50*Input!$E$13,0)","v":14196}]
[null,null,null,"    Machinery & Eq. Amortization Costs",null,{"$f":"-CUMPRINC(Fixed!H11,Fixed!I11,Fixed!I4*Fixed!I8,1,Fixed!I11,0)/Fixed!I11","v":33.79999999999999},1.6922311009421483E-2,null,{"$f":"ROUND(F51*Input!$E$13,0)","v":5070}]
[null,null,null,"Machinery & Eq. Opportunity Costs",null,{"$f":"Fixed!I14","v":0},0,null,{"$f":"ROUND(F52*Input!$E$13,0)","v":0}]
[null,null,null,null,null,{"$f":"SUM(F41:F51)","v":314.2418693009119},0.1573283622630772,null,{"$f":"SUM(I41:I51)","v":47136}]
[]
[" =","Earnings Before Interest Taxes (EBIT)",null,null,null,{"$f":"SUM(F38-F53)","v":449.69058090323034},0.22514212627372424,null,{"$f":"SUM(I38-I53)","v":67452}]
[]
[{"$f":"\" -\"","v":" -"},"Interest Expenses"]
[null,null,null,"    Operating Interest",null,{"$f":"'Operating '!G132","v":40.380200000000002},{"$f":"SUM(F58/$F$5)","v":2.0216754527297088E-2},null,{"$f":"ROUND(F58*Input!$E$13,0)","v":6057}]
[null,null,null,"  Owned Cows Interest Cost",null,{"$f":"-CUMIPMT(Fixed!C9,Fixed!D9,Fixed!D4*Fixed!D6,1,Fixed!D9,0)/Fixed!D9","v":16.651469941866424},8.3367264236774308E-3,null,{"$f":"ROUND(F59*Input!$E$13,0)","v":2498}]
[null,null,null,"Pasture & Fencing Interest Costs",null,{"$f":"Pasture!J140","v":25.448990388118339},1.2741293793595166E-2,null,{"$f":"ROUND(F60*Input!$E$13,0)","v":3817}]
[null,null,null," Building Interest Cost ",null,{"$f":"-CUMIPMT(Fixed!H25,Fixed!I25,Fixed!I18*Fixed!I22,1,Fixed!I25,0)/Fixed!I25","v":3.3110807538249776},1.6577259850158585E-3,null,{"$f":"ROUND(F61*Input!$E$13,0)","v":497}]
[null,null,null,"    Machinery & Equipment Interest Costs",null,{"$f":"-CUMIPMT(Fixed!H11,Fixed!I11,Fixed!I4*Fixed!I8,1,Fixed!I11,0)/Fixed!I11","v":10.101891764732297},5.0576140303643076E-3,null,{"$f":"ROUND(F62*Input!$E$13,0)","v":1515}]
[null,null,null,null,null,{"$f":"SUM(F58:F62)","v":95.893632848542055},4.801011475994986E-2,null,{"$f":"SUM(I58:I62)","v":14384}]
[]
[" =","Earnings Before Taxes (EBT)",null,null,null,{"$f":"SUM(F55-F63)","v":353.7969480546883},0.17713201151377436,null,{"$f":"SUM(I55-I63)","v":53068}]
[]
[]
[null,"Note: This budget is only a guide and is not intended to be 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":"Charts","index":3,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,""]

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

{"sheet":"Risk Analysis","index":5,"n_rows":109,"n_cols":13,"rows_kept":109,"cut":false,"hidden":false,"merged":[[108,0,109,9],[78,1,78,10],[0,0,0,10],[67,0,67,10],[69,3,69,7]]}
["Risk & Sensitivity Analysis (Stress Test)"]
["A.  Operating Costs",null,null,null,"***Hide***"]
[null,"Feed cost",{"$f":"Summary!F10","v":524.22485878787882}]
[null,"Other Operating Costs",{"$f":"Summary!F29-Summary!F10","v":592.96101600797886}]
[null,"Subtotal",{"$f":"SUM(C3:C4)","v":1117.1858747958577}]
["B.  Fixed Costs",null,{"$f":"Summary!F36","v":310.38030214945388}]
["C.  Labour",null,{"$f":"Summary!F38","v":216}]
["Total Costs",null,{"$f":"SUM(C5:C7)","v":1643.5661769453116}]
[]
[null,"Calf Crop %",{"$f":"Input!E17","v":95}]
[null,"Calf weight (lbs)",{"$f":"Summary!F45","v":575}]
[]
["Estimated Farmgate"]
[null,"Price ($ per cwt)",{"$f":"Input!E24","v":365.65}]
[]
[]
[null,"Percent Operating Cost Change",null,null,null,"Percent Sale Price Change"]
[null,"Percent Weaning Weight Change",null,null,null,"Percent Calf Crop Change",null,"?? Any point in this included??"]
[]
[]
[null,null,"Percent",null,null,"Change  from",null,"Change in",null,"Change in"]
[null,null," Change","Per Head",null,"Baseline Value",null,"Profit/Cow",null,"Total Profit"]
[]
[null," Operating Costs",-0.05,{"$f":"SUM(C5*(1+C24))","v":1061.3265810560647},null,{"$f":"SUM(D24-C5)","v":-55.859293739792975},null,{"$f":"-SUM(D24-C5)","v":55.859293739792975},null,{"$f":"SUM(H24*Input!$E$13)","v":8378.8940609689453}]
[null,"Sale Price ($ per cwt)",0.05,{"$f":"SUM(C14*(1+C25))","v":383.9325},null,{"$f":"SUM(D25-C14)","v":18.282500000000027},null,{"$f":"SUM((D25-C14)/100)*C11","v":105.12437500000016},null,{"$f":"SUM(H25*Input!$E$13)","v":15768.656250000024}]
[null," Calf Weaning Weight (lbs)",0.05,{"$f":"SUM(C11+(C11*C26))","v":603.75},null,{"$f":"SUM(D26-C11)","v":28.75},null,{"$f":"SUM(D26-C11)*(C14/100)","v":105.124375},null,{"$f":"SUM(H26*Input!$E$13)","v":15768.65625}]
[null," Calf Crop %",0.01,{"$f":"SUM(C10+(C27*100))","v":96},null,{"$f":"SUM(D27-C10)","v":1},null,{"$f":"(($C$11/100)*$C$14*(($D$27-C10)/100))","v":21.024874999999998},null,{"$f":"SUM(H27*Input!$E$13)","v":3153.7312499999998}]
[null,null,null,null,null,null,null,{"$f":"SUM(H24:H27)","v":287.13291873979313},null,{"$f":"SUM(J24:J27)","v":43069.937810968964}]
[]
[null,"Gross Revenue / Cow",{"$f":"(($D$26/100)*$D$25*($D$27/100))","v":2225.2727699999996},null,{"$f":"SUM(C34-Summary!F46)","v":227.90964499999995},null,null,"**if we add these two lines here, we can delete the rest below??"]
[null,"   Over Total Costs (Net Profit)",{"$f":"SUM($C$34-$D$24-$C$6-$C$7)","v":637.565886794481},null,{"$f":"SUM(C38-Summary!F54)","v":283.76893873979293},null,null,"**or do we even need these line or the stuff below??"]
[]
[{"$f":"\"Stress Test Scenario = Market Price \"&IF(C25<0,\"Down\",\"Up\")&\" \"&ABS(C25*100)&\"%, Calf Crop \"&IF(C27<0,\"Down\",\"Up\")&\" \"&ABS(C27*100)&\"% and Calf Weight \"&IF(C26<0,\"Down\",\"Up\")&\" \"&ABS(C26*100)&\"%\"","v":"Stress Test Scenario = Market Price Up 5%, Calf Crop Up 1% and Calf Weight Up 5%"}]
[null,"Gross Revenue / Cow",{"$f":"(($D$26/100)*$D$25*($D$27/100))","v":2225.2727699999996},null,{"$f":"SUM(C34-Summary!F46)","v":227.90964499999995}]
[null,"Marginal Returns "]
[null,"   Over Operating Costs",{"$f":"SUM(C34-D24)","v":1163.9461889439349},null,{"$f":"SUM(C36-Summary!F52)","v":283.76893873979293}]
[null,"   Over Operating & Fixed Costs",{"$f":"SUM(C34-C6-D24)","v":853.565886794481},null,{"$f":"SUM(C37-Summary!F53)","v":283.76893873979293}]
[null,"   Over Total Costs (Net Profit)",{"$f":"SUM($C$34-$D$24-$C$6-$C$7)","v":637.565886794481},null,{"$f":"SUM(C38-Summary!F54)","v":283.76893873979293}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Estimated Breakeven Canadian Dollar Analysis",null,null,null,null,null,null,null,null,null,null,null,"hide???"]
[]
[null,null,null,{"$f":"\"Est. Market Price ($/cwt Cdn) @ \"&TEXT(Input!E22,\"0.0000\")&\" Cdn per USD\"","v":"Est. Market Price ($/cwt Cdn) @ 0.8200 Cdn per USD"}]
[null,null,null,{"$f":"SUM($F$71-10)","v":355.65},{"$f":"SUM($F$71-5)","v":360.65},{"$f":"Input!E24","v":365.65},{"$f":"SUM($F$71+5)","v":370.65},{"$f":"SUM($F$71+10)","v":375.65}]
["Breakeven CDN Dollar ($1 Cdn = $ USD)"]
[null,"Operating Costs",null,{"$f":"SUM((D71/100)*Input!$E$23*Input!$E$22)/Summary!$F$29","v":1.5009944073150909},{"$f":"SUM((E71/100)*Input!$E$23*Input!$E$22)/Summary!$F$29","v":1.52209653591505},{"$f":"SUM((F71/100)*Input!$E$23*Input!$E$22)/Summary!$F$29","v":1.5431986645150091},{"$f":"SUM((G71/100)*Input!$E$23*Input!$E$22)/Summary!$F$29","v":1.5643007931149682},{"$f":"SUM((H71/100)*Input!$E$23*Input!$E$22)/Summary!$F$29","v":1.5854029217149275}]
[null,"Operating & Labour Costs",null,{"$f":"SUM((D71/100)*Input!$E$23*Input!$E$22)/(Summary!$F$29+Summary!$F$38)","v":1.2578064182211437},{"$f":"SUM((E71/100)*Input!$E$23*Input!$E$22)/(Summary!$F$29+Summary!$F$38)","v":1.2754896238758764},{"$f":"SUM((F71/100)*Input!$E$23*Input!$E$22)/(Summary!$F$29+Summary!$F$38)","v":1.2931728295306091},{"$f":"SUM((G71/100)*Input!$E$23*Input!$E$22)/(Summary!$F$29+Summary!$F$38)","v":1.310856035185342},{"$f":"SUM((H71/100)*Input!$E$23*Input!$E$22)/(Summary!$F$29+Summary!$F$38)","v":1.3285392408400749}]
[null,"Operating, Fixed & Labour Costs",null,{"$f":"SUM((D71/100)*Input!$E$23*Input!$E$22)/(Summary!$F$40)","v":1.0202751635572245},{"$f":"SUM((E71/100)*Input!$E$23*Input!$E$22)/(Summary!$F$40)","v":1.0346189729703725},{"$f":"SUM((F71/100)*Input!$E$23*Input!$E$22)/(Summary!$F$40)","v":1.0489627823835206},{"$f":"SUM((G71/100)*Input!$E$23*Input!$E$22)/(Summary!$F$40)","v":1.0633065917966686},{"$f":"SUM((H71/100)*Input!$E$23*Input!$E$22)/(Summary!$F$40)","v":1.0776504012098169}]
[]
[{"$f":"\"Breakeven Canadian Dollar = (Est. Market Price ($/lb) x Calf Wt. (lbs) x $ Cdn per USD) / Cost    (eg. ($\"&TEXT(F71/100,\"0.0000\")&\" x \"&ROUND(Input!E23,0)&\" lbs x $\"&TEXT(Input!E22,\"0.0000\")&\") / $\"&TEXT(Summary!F40,\"0.00\")&\") = $\"&TEXT(F75,\"0.0000\")&\")\"","v":"Breakeven Canadian Dollar = (Est. Market Price ($/lb) x Calf Wt. (lbs) x $ Cdn per USD) / Cost    (eg. ($3.6565 x 575 lbs x $0.8200) / $1643.57) = $1.0490)"}]
[]
[null,"Risk Management Analysis"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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":"Input","index":6,"n_rows":105,"n_cols":9,"rows_kept":105,"cut":false,"hidden":false,"merged":[[0,0,0,8],[39,0,39,8],[25,0,25,8],[10,0,10,8],[92,0,92,8]]}
["Cow-Calf Production Costs - Herd Input"]
[]
["Assumptions"]
["1.  This budget outlines the cost of production for a cow-calf operation."]
["2.  Buildings and equipment are valued at new cost."]
["3.  All feed is purchased."]
["4.  Manure removal is contracted out."]
["5.  Replacement heifers are valued at fair market value"]
[{"$f":"\"6.  This budget assumes an average weaning weight of \"&Input!E23&\" lbs. (steer calves \"&E18&\" lbs and heifer calves \"&E20&\" lbs.)\"","v":"6.  This budget assumes an average weaning weight of 575 lbs. (steer calves 600 lbs and heifer calves 550 lbs.)"}]
[]
["Cow-Calf Production Costs - Herd Profile"]
[null,null,null,null,"Total"]
["Number of Cows",null,null,null,150,"head"]
["Average Cow Weight",null,null,null,1350,"lbs"]
["Number of Bulls",null,null,null,{"$f":"IF(E13<151,E13/30,IF(E13<241,(E13/30)+1,(E13/30)+2))","v":5},"bulls"]
[]
["Calf Crop",null,null,null,95,"%"]
["Steer Calf Weight",null,null,null,600,"lbs"]
["Steer Calf Market Price",null,null,null,380,"/cwt"]
["Heifer Calf Weight",null,null,null,550,"lbs"]
["Heifer Calf Market Price",null,null,null,350,"/cwt"]
["$1 Canadian Dollar",null,null,{"$f":"\"($\"&TEXT(1/E22,\"#.####\")&\" CDN )\"","v":"($1.2195 CDN )"},0.82,"/ $1 USD"]
["Average Calf Weight",null,null,null,{"$f":"AVERAGE(E18,E20)","v":575},"lbs"]
["Weighted Average Calf Market Price",null,null,null,{"$f":"ROUND((((E19*(E18/100))+(E21*(E20/100)))/2)/(E23/100),2)","v":365.65},"/cwt"]
[]
["Cow-Calf Production Costs - Herd Replacement"]
["Herd Replacement  (Cows)"]
["Average Value/Cow",null,null,null,2600,{"$f":"\"(bred cow to steer calf price ratio = \"&TEXT((E28/(E18*(E19/100))),\"#.##\")&\")\"","v":"(bred cow to steer calf price ratio = 1.14)"}]
[null,null,null,null,null,null,null,null,{"$f":"\"   (bred cow to steer calf price ratio range is often 1.1 to 1.5 = estimated cow value range of $\"&TEXT(1.1*(($E$18*($E$19/100))),\"#,###\")&\" to $\"&TEXT(1.5*(($E$18*($E$19/100))),\"#,###\")&\")\"","v":"   (bred cow to steer calf price ratio range is often 1.1 to 1.5 = estimated cow value range of $2,508 to $3,420)"}]
["Cull Cow Market Price",null,null,null,175,"/cwt"]
["Cow Mortality Rate",null,null,null,1.25,"%"]
[]
["Herd Replacement (Cows)"]
[null,"Replacement Cost/Heifer",null,null,3600]
[null,"Cull Cow Market Value",null,"-",{"$f":"SUM(E14/100)*E30","v":2362.5}]
[null,null,null,null,{"$f":"\"(\"&E14&\"lb cow / 100 x $\"&E30&\"/cwt cull price = $\"&TEXT(E35,\"0.00\")&\")\"","v":"(1350lb cow / 100 x $175/cwt cull price = $2362.50)"}]
[null,"Cow replacement rate (%)",null,"x",12]
[null,null,null,"=",{"$f":"ROUND((E34-E35)*(E37),2)/100","v":148.5},"/cow"]
[]
["Cow-Calf Production Costs - Breeding"]
["Breeding Costs",null,null,null,null,null,"Cost Per Cow"]
[" Feed for Bulls"]
["      Hay","Good Quality (tons/yr)",null,null,4]
[null,"Hay Price ($/ton)",null,"x",{"$f":"'Winter Feed Rations'!B13","v":115}]
[null,"Number of Bulls",null,"x",{"$f":"Input!E15","v":5}]
[null,null,null,"÷",{"$f":"Input!E13","v":150},"cows = ",{"$f":"ROUND(((E43*E44)*E45)/E46,2)","v":15.33}]
[]
["      Barley","Per Bull (lbs/day)",null,null,7]
[null,"Days/Year on Barley",null,"x",120]
[null,"Pounds per bushel",null,"÷",48]
[null,"Barley Price ($/bu)",null,"x",{"$f":"'Winter Feed Rations'!B19","v":4.5}]
[null,"Number of Bulls",null,"x",{"$f":"Input!E15","v":5}]
[null,null,null,"÷",{"$f":"Input!E13","v":150},"cows = ",{"$f":"ROUND(((E48*E49/E50)*(E51)*E52)/E53,2)","v":2.63}]
[null,null,null,null,null," = Total",{"$f":"ROUND(G46+G53,2)","v":17.96}]
[" Straw for Bulls"]
[null,"Number of Tons/Bull/Year",null,null,1,"tons/bull/year"]
[null,"Hay Price ($/ton)",null,"x",{"$f":"'Operating '!D25","v":70},"/ton"]
[null,"Number of Bulls",null,"x",{"$f":"Input!E15","v":5},"bulls"]
[null,null,null,"÷",{"$f":"Input!E13","v":150},"cows = ",{"$f":"ROUND((Input!E56*'Operating '!D25*Input!E15)/Input!E13,2)","v":2.33}]
[" Vet & Medicine for Bulls"]
[null,"Semen Test",null,null,60]
[null,"Health Management Costs ",null,"+",10]
[null,"Number of Bulls",null,"x",{"$f":"Input!E15","v":5},"bulls"]
[null,null,null,"÷",{"$f":"Input!E13","v":150},"cows = ",{"$f":"ROUND(((E61+E62)*E63)/E64,2)","v":2.33}]
[" Herd Replacement  (Bulls)"]
[null,"Original Cost/Bull",null,null,5000]
[null,"Price Received/Cull Bull",null,"-",3500]
[null,"Bull Replacement Rate (%)",null,"x",25]
[null,"Number of Bulls",null,"x",{"$f":"Input!E15","v":5},"bulls"]
[null,null,null,"÷",{"$f":"Input!E13","v":150},"cows = ",{"$f":"ROUND(((E66-E67)*E68)*E69/E70,2)/100","v":12.5}]
[" Investment in Bulls"]
[null,"Original Cost/Bull",null,null,{"$f":"Input!E66","v":5000}]
[null,"Price Received/Cull Bull",null,"+",{"$f":"Input!E67","v":3500}]
[null,"Average - charged on 1/2 ",null,"÷",2]
[null,"Investment Rate  ",null,"x",4]
[null,"Number of Bulls",null,"x",{"$f":"Input!E15","v":5}]
[null,null,null,"÷",{"$f":"Input!E13","v":150},"cows = ",{"$f":"ROUND((((E72+E73)/E74)*E75)*E76/E77,2)/100","v":5.6666999999999996}]
[" Pasture Costs for Bulls"]
[null,"Pasture Cost ($/season)",null,null,{"$f":"Pasture!E92","v":168.77704286610722},"/bull pasture cost"]
[null,"Number of Bulls",null,"x",{"$f":"Input!E15","v":5},"bulls"]
[null,null,null,"÷",{"$f":"Input!E13","v":150},"cows = ",{"$f":"ROUND((E79*E80)/E81,2)","v":5.63}]
[" Other Breeding Alternatives"]
["    Artificial Insemination"]
[null,"Cost/Cow or Heifer Exposed",null,null,0]
[null,"Number Inseminated",null,"x",0]
[null,null,null,"÷",{"$f":"Input!E13","v":150},"cows = ",{"$f":"ROUND((E84*E85)/E86,2)","v":0}]
["   Community Pasture"]
[null,"Cost/Cow or Heifer Exposed",null,null,0]
[null,"Number of Cows placed in Pasture",null,null,0]
[null,null,null,"÷",{"$f":"Input!E13","v":150},"cows = ",{"$f":"ROUND((E88*E89)/E90,2)","v":0}]
[null,null,null,null,null," = Total",{"$f":"ROUND(G54+G59+G64+G70+G77+G81+G86+G90,2)","v":46.42}]
[]
["Cow-Calf Production Costs - Facilities"]
[]
["   Waterers",null,"Cows per waterer",null,100]
[null,null,"Cost per waterer",null,2000," = Total",{"$f":"ROUNDUP((E13+E15)/E95,0)*E96","v":4000}]
[]
["   Windbreak Fence",null,"Feet per Cow",null,1.5]
[null,null,"Cost per Foot",null,25," = Total",{"$f":"ROUNDUP(($E$13+$E$15)*E98,1)*E99","v":5812.5}]
[]
["   Feedlot Fence/Bunk",null,"Feet per Cow",null,2]
[null,null,"Cost per Foot",null,15," = Total",{"$f":"ROUNDUP(($E$13+$E$15)*E101,1)*E102","v":4650}]
[]
["   Calf Shelters",null,"Calves per shelter",null,50]
[null,null,"Cost per shelter",null,3000," = Total",{"$f":"ROUNDUP(($E$13+$E$15)/E104,1)*E105","v":9300}]

{"sheet":"Operating ","index":7,"n_rows":138,"n_cols":7,"rows_kept":138,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["Cow-Calf Production Costs - Operating"]
[]
["Veterinary Medicine & Supplies"]
["     Calf Medication",null,null,null,null,null,"Cost Per Cow"]
["        Blackleg (8 way vaccine)",null,null,1,{"$f":"\"/head  x \"&Input!E17&\"% calf crop = \"","v":"/head  x 95% calf crop = "},null,{"$f":"SUM(D5*(Input!E17/100))","v":0.95}]
["        Tags (CCIA & ID)",null,null,4.8,{"$f":"\"/head  x \"&Input!E17&\"% calf crop = \"","v":"/head  x 95% calf crop = "},null,{"$f":"SUM(D6*(Input!E17/100))","v":4.5599999999999996}]
["     Cow Medication"]
["         5-Way fetal protection",null,null,null,null,null,5]
["        Scourguard",null,null,null,null,null,5]
["        Internal/external parasite control, antibiotics, etc.",null,null,null,null,null,4]
["        Vitamin A & D",null,null,null,null,null,0.5]
["     Herd Health Program"]
["        Professional Services",null,null,8,"hours @"]
["            Rate",null,"x",180,"/hour"]
[null,null,"÷",{"$f":"Input!E13","v":150},"cows = ",null,{"$f":"SUM(D13*D14)/Input!E13","v":9.6}]
["        Transportation",null,null,null,""]
["            Total Kilometers (round trip)",null,null,80,"km "]
["            Rate",null,"x",1,"/km"]
["            Number of yearly visits",null,null,2]
[null,null,"÷",{"$f":"Input!E13","v":150},"cows = ",null,{"$f":"SUM(D17*D18*D19)/Input!E13","v":1.0666666666666667}]
[null,null,null,null,null," = Total",{"$f":"SUM(G20+G15+G11+G10+G9+G8+G6+G5)","v":30.676666666666662}]
[]
["Other Operating Costs"]
["Straw"]
["  Cost ($/Ton)",null,null,70]
["  Number of Tons/Cow/Year",null,null,1]
[]
["Fuel, Oil, Repairs & Maintenance"]
[" Machinery Fuel Cost",null,null,null,null,null,"Cost Per Cow"]
["  Tractor with Loader PTO hp",null,null,null,120]
["  Average HP required",null,null,"÷",2.5]
["  Litres fuel / Hour / HP",null,null,"x",0.1665576]
["  Tractor Hours Per Day (avg)",null,null,"x",1.5]
["  Diesel Fuel Cost / litre",null,null,"x",1.1000000000000001]
["  Days on feed",null,null,"x",{"$f":"IF(Pasture!G10=365,Pasture!G5-Pasture!G7,\"ERROR\")","v":195}]
["  Annual fuel cost",null,null,null,{"$f":"IF(E35=\"ERROR\",\"ERROR\",ROUND(((E30/E31)*E32*E33*E34*E35),2))","v":2572.3200000000002}]
[null,null,null,"÷",{"$f":"Input!E13","v":150},"cows = ",{"$f":"IF(E35=\"ERROR\",\"ERROR\",SUM(E36/E37))","v":17.148800000000001}]
[" Machinery repair & maintenance"]
["  Machinery capital cost",null,null,null,{"$f":"SUM(Fixed!J48:J63)","v":177500}]
["  Machinery Repair (% of investment cost)",null,null,"x",1.2,"%"]
["  Oil, repairs & maintenance",null,null,"=",{"$f":"SUM(E39*(E40/100))","v":2130}]
[null,null,null,"÷",{"$f":"Input!E13","v":150},"cows = ",{"$f":"SUM(E41/E42)","v":14.2}]
[" Building repair & maintenance"]
["  Building capital cost",null,null,null,{"$f":"SUM(Fixed!E48:E63)","v":77512.5}]
["  Building  maintenance (% of inv.cost)",null,null,"x",2.2000000000000002]
["  Repairs & maintenance",null,null,"=",{"$f":"SUM(E44*(E45/100))","v":1705.2750000000001}]
[null,null,null,"÷",{"$f":"Input!E13","v":150},"cows = ",{"$f":"SUM(E46/E47)","v":11.368500000000001}]
[null,null,null,null,null," = Total",{"$f":"IF(G37=\"ERROR\",\"ERROR\",SUM(G47+G42+G37))","v":42.717300000000002}]
[]
["Other Operating Costs"]
["  Utilities",null,null,null,null,null,"Cost Per Cow"]
["          Hydro",null," Rate ($/kWh)",null,9.5869999999999997E-2]
[null,25,"kWh per cow ","=",{"$f":"SUM(B53*Input!E13*E52)","v":359.51249999999999}]
[null,{"$f":"ROUNDUP((Input!E13+Input!E15)/Input!E95,0)","v":2},"1000 watt waterer",null,{"$f":"SUM(B54*18)*(Pasture!G4+Pasture!G5)*E52","v":793.80359999999996}]
[null,null,null,"Total Hydro     = ",{"$f":"SUM(E53:E54)","v":1153.3161}]
[null,null,null,"÷",{"$f":"Input!E13","v":150},"cows = ",{"$f":"IF(E54=\"ERROR\",\"ERROR\",SUM(E55/E56))","v":7.6887740000000004}]
["        Telephone",null,null,null,600]
[null,null,null,"÷",{"$f":"Input!E13","v":150},"cows = ",{"$f":"IF(E56=\"ERROR\",\"ERROR\",SUM(E57/E58))","v":4}]
[null,null,null,null,null," = Total",{"$f":"SUM(G58+G56)","v":11.688774}]
[]
["Marketing & Transportation",null,null,null,null,null,"Cost Per Cow"]
[" Trucking"]
["   Calves:","Number marketed per year",null,null,{"$f":"ROUND(Input!E13*Input!E17/100,0)","v":143}]
[null,"Truck Capacity (lbs/load)",null,null,54000]
[null,"Number of head per load - calves",null,null,{"$f":"E64/Input!E23","v":93.913043478260875}]
[null,"Loads",null,"=",{"$f":"ROUNDUP(('Operating '!E63)/'Operating '!E65,0)","v":2}]
[null,"Distance (miles)",null,"x",75]
[null,"Rate / Loaded Mile",null,"x",7]
[null,null,null,"÷",{"$f":"Input!E13","v":150},"cows = ",{"$f":"SUM(E67*E68*E66)/E69","v":7}]
[]
["   Cull cows:","Number per year",null,null,{"$f":"ROUND(Input!E13*Input!E37/100,0)","v":18}]
[null,"Number cows died",null,"-",{"$f":"ROUND(Input!E13*Input!E31/100,0)","v":2}]
[null,"Number of head per load - cull cows",null,null,{"$f":"E64/Input!E14","v":40}]
[null,"Loads",null,"=",{"$f":"ROUNDUP(('Operating '!E71-'Operating '!E72)/'Operating '!E73,0)","v":1}]
[null,"Distance (miles)",null,"x",{"$f":"E67","v":75}]
[null,"Rate / Loaded Mile",null,"x",{"$f":"E68","v":7}]
[null,null,null,"÷",{"$f":"Input!E13","v":150},"cows = ",{"$f":"SUM(E75*E76*E74)/E77","v":3.5}]
[" MBP Levy, selling commission & insurance "]
["Calves","MBP/NCO Levy ($/Head) ",null,"+",5.5]
[null,"WLPIP Insurance Premium ($/cwt)",null,null,0]
[null,"Average Calf Weight (cwt)",null,"x",{"$f":"Input!E23/100","v":5.75}]
["+","WLPIP Insurance Premium",null,"=",{"$f":"'Operating '!E80*E81","v":0}]
[null,"Insurance per Head",null,"+",1.75]
[null,"Commission on Calves ",null,null,20]
[null,"Number marketed per year",null,"x",{"$f":"ROUND(Input!E13*Input!E17/100,0)","v":143}]
[null,null,null,"÷",{"$f":"Input!E13","v":150},"cows = ",{"$f":"((E79+E82+E83+E84)*E85)/E86","v":25.978333333333332}]
[]
["Cull Cows","MBP/NCO Levy ($/Head) ",null,null,{"$f":"E79","v":5.5}]
[null,"Insurance per Head",null,"+",{"$f":"E83","v":1.75}]
[null,"Commission on Cows",null,null,22]
[null,"Number marketed per year",null,"x",{"$f":"ROUND(((Input!E13*Input!E37)/100)-((Input!E13*Input!E31)/100),0)","v":16}]
[null,null,null,"÷",{"$f":"Input!E13","v":150},"cows = ",{"$f":"(((E88+E89+E90)*E91)/E92)","v":3.12}]
[null,null,null,null,null," = Total",{"$f":"G69+G77+G86+G92","v":39.598333333333329}]
[]
["Death Loss",null,null,null,null,null,"Cost Per Cow"]
[null,"Cow investment ($/Head)",null,"x",{"$f":"Input!E28","v":2600}]
[null,"Cow Mortality Rate (%)",null,"x",{"$f":"Input!E31","v":1.25},"=",{"$f":"ROUND(E96*E97,2)/100","v":32.5}]
[]
["Manure Removal",null,null,null,null,null,"Cost Per Cow"]
[" Number winter feeding days",null,null,null,{"$f":"Pasture!G5","v":195}]
[" Non-confined winter feeding - feed delivered",null,null,"-",{"$f":"Pasture!G6","v":130}]
[" Non-confined winter feeding - bale grazing",null,null,"-",{"$f":"Pasture!G7","v":0}]
[" Days confined winter feeding",null,null,"=",{"$f":"IF(Pasture!G10=365,SUM(E100-E101-E102),\"ERROR\")","v":65}]
[" Manure volume produced (m3/cow/day)",null,null,"x",3.4000000000000002E-2]
[" Manure volume (m3) ",null,null,"=",{"$f":"IF(E103=\"ERROR\",\"ERROR\",SUM(E103*E104))","v":2.21}]
[" Manure volume shrinkage (%)",null,null,"x",75]
[" Conversion - yd3 per m3",null,null,"x",1.3079499999999999]
[" Manure removal & application ($/yd3) ",null,null,"x",15,"=",{"$f":"IF(E103=\"ERROR\",\"ERROR\",SUM(E105*(1-(E106/100))*E107*E108))","v":10.839635625}]
[]
["Insurance",null,null,null,null,null,"Cost Per Cow"]
["  Cow Investment ($/Head)",null,null,null,{"$f":"Input!E28","v":2600}]
["  Cost per $100 Livestock",null,null,"x",0.45]
[null,null,null,"÷",100,"=",{"$f":"(E111*E112)/E113","v":11.7}]
[]
["  Buildings & Equipment Investment",null,null,null,{"$f":"SUM(Fixed!E48:E63)+SUM(Fixed!J48:J63)","v":255012.5}]
["  Cost per $100 Buildings",null,null,"x",0.4]
[null,null,null,"÷",100]
[null,null,null,"÷",{"$f":"Input!E13","v":150},"cows = ",{"$f":"ROUND(E115*(E116/E117)/E118,2)","v":6.8}]
[]
["   Additional coverage for liability ",null,null,null,49]
[null,null,null,"÷",{"$f":"Input!E13","v":150},"cows = ",{"$f":"ROUND(E120/E121,2)","v":0.33}]
[null,null,null,null,null," = Total",{"$f":"ROUND(G113+G118+G121,2)","v":18.829999999999998}]
[]
["Miscellaneous",null,null,null,null,null,"Cost Per Cow"]
[null," Total office expenses",null,null,1000]
[null,null,null,"÷",{"$f":"Input!E13","v":150},"cows = ",{"$f":"ROUND(E125/E126,2)","v":6.67}]
[]
["Operating Interest"]
[null,"Subtotal operating costs",null,null,{"$f":"Summary!F27","v":1076.8056747958576}]
[null,"Average - charged on 1/2 ",null,"÷",2]
[null,"Operating Interest Rate",null,"x",7.5]
[null,null,null,null,null," = Total",{"$f":"ROUND((E129/E130)*(E131),2)/100","v":40.380200000000002}]
[]
["Labour Costs",null,null,null,null,null,"Cost Per Cow"]
[null,"Labour Rate ($/hour)",null,null,27]
[null,"Hired - Labour Hours/Cow/Year",null,null,0,"=",{"$f":"ROUND(E136*E135,2)","v":0}]
[null,"Owner - Labour Hours/Cow/Year",null,null,8,"=",{"$f":"ROUND(E137*E135,2)","v":216}]
[null,null,null,null,null," = Total",{"$f":"SUM(G136:G137)","v":216}]

{"sheet":"Pasture","index":8,"n_rows":145,"n_cols":12,"rows_kept":145,"cut":false,"hidden":false,"merged":[[73,0,73,9],[94,0,94,9],[110,0,110,9],[11,0,11,9],[0,0,0,9],[34,4,34,6],[43,4,43,6],[33,0,33,9],[50,4,50,6]]}
["Annual Days on Pasture and Winter Feeding"]
["Total Days Per Year",null,null,null,null,null,365]
["Pasture Grazing ",null,{"$f":"IF(G3>365,\"ERROR - More Than 365 Days\",IF(G3<0,\"ERROR, less than 0\",\"\"))","v":""},null,null,"minus",135,"days",{"$f":"ROUND(G3/30,2)","v":4.5},"months"]
["Extended Grazing",null,{"$f":"IF(G4>(365-G3),\"ERROR - Too Many Days\",IF(G4<0,\"ERROR, less than 0\",\"\"))","v":""},null,null,"minus",35,"days"]
["Total Winter Feeding",null,"(see Ration Worksheet for more detail)",null,null," =",{"$f":"IF(SUM(G2-(G3+G4))<0,\"ERROR\",SUM(G2-(G3+G4)))","v":195},"days"]
["    Non-confined winter feeding (feed delivered to pasture)",null,null,null,null,"minus",130,"days"]
["    Non-confined winter feeding (bale grazing)",null,null,null,null,"minus",0,"days"]
["    Confined winter feeding - feed delivered",null,null,null,null," =",{"$f":"IF(G5=\"ERROR\",\"ERROR\",IF(SUM(G5-(G6+G7))<0,0,SUM(G5-(G6+G7))))","v":65},"days"]
[]
[null,null,null,null,null,{"$f":"IF(G10=\"ERROR\",\"\",IF(G10>365,\"ERROR - More Than 365 Days\",IF(G10<365,\"ERROR - Less Than 365 Days\",\"\")))","v":""},{"$f":"IF(G5=\"ERROR\",\"ERROR\",SUM(G4+G3+G6+G7+G8))","v":365},"Total Days"]
[]
["Pasture Options - Input "]
["Land Base",null,null,null,"Marginal Pasture","Improved Pasture","Crown Lands","Community Pasture","Rented Pasture"]
["Number of cows pastured/season",null,null,null,{"$f":"Input!E13","v":150},{"$f":"Input!E13","v":150},{"$f":"Input!E13","v":150},{"$f":"Input!E13","v":150},{"$f":"Input!E13","v":150}]
["Number of cows/quarter",null,null,null,32,94,12," - ",32]
["Number of pasture acres/head",null,null,null,{"$f":"SUM(160/E15)","v":5},{"$f":"SUM(160/F15)","v":1.7021276595744681},{"$f":"SUM(160/G15)","v":13.333333333333334}," - ",{"$f":"SUM(160/I15)","v":5}]
["Total Acres Required",null,null,null,{"$f":"ROUND(E16*E14,0)","v":750},{"$f":"ROUND(F16*F14,0)","v":255},{"$f":"ROUND(G16*G14,0)","v":2000}," - ",{"$f":"ROUND(I16*I14,0)","v":750}]
[]
["Rental Rate ($/quarter)",null,null,null," - "," - ",662," - ",4750]
["Rate ($/cow/day)",null,null,null," - "," - "," - ",0.9," - "]
["Rate ($/calf/season)",null,null,null," - "," - "," - ",55," - "]
[]
["Pasture Land Value "]
[null,"($/acre, excl. fence, water, facilities)",null,null,800,1800," - "," - "," - "]
[null,"Owned Land Equity",null,0.75]
[null,"Land Financed",null,{"$f":"SUM(1-D25)","v":0.25}]
[null,"Land Opportunity Cost (Investment Rate) ",null,0]
[null,"Land cost ($/acre)"]
[null,"Finance Rate & Term",6.5000000000000002E-2,25,"years"]
[null,"Principle & Interest Cost",null,null,{"$f":"-PMT(C29,D29,E24*D26,0)","v":16.396296216796987},{"$f":"-PMT(C29,D29,F24*D26,0)","v":36.891666487793223}," - "," - "," - "]
[null,"Owned Land Opportunity Cost",null,null,{"$f":"SUM(E24*D25)*(D27)","v":0},{"$f":"SUM(F24*D25)*(D27)","v":0}," - "," - "," - "]
[null,"Total Cost ($/acre)",null,null,{"$f":"SUM(E30:E31)","v":16.396296216796987},{"$f":"SUM(F30:F31)","v":36.891666487793223}," - "," - "," - "]
[]
["Pasture Fencing - Input "]
[null,null,null,null,"Fence Cost Per Mile"]
[null,null,null,null,"Materials","Labour","Equipment","Total"]
[null,"Barbed Wire (4 strand)",null,null,4812,1118,1514,{"$f":"SUM(E37:G37)","v":7444}]
[null,"Electric Wire (4 strand)",null,null,2389,500,635,{"$f":"SUM(E38:G38)","v":3524}]
[null,"Electric Wire (2 strand)",null,null,2042,412,561,{"$f":"SUM(E39:G39)","v":3015}]
[null,"Electric Wire (1 strand)",null,null,1730,370,523,{"$f":"SUM(E40:G40)","v":2623}]
[null,"Page Wire (w/optional top wire)",null,null,9139,1974,2527,{"$f":"SUM(E41:G41)","v":13640}]
[]
[null,null,null,null,"Marginal Pasture","Improved Pasture","Crown Lands"]
[null,null,null,null,"Fence Miles per Quarter (160 ac)"]
[null,"Barbed Wire (4 strand)",null,null,2,0,1]
[null,"Electric Wire (4 strand)",null,null,0,0,0]
[null,"Electric Wire (2 strand)",null,null,0,0,0]
[null,"Electric Wire (1 strand)",null,null,0,4,0]
[null,"Page Wire (w/optional top wire)",null,null,0,0,0]
[]
[null,null,null,null,"Cost Per Quarter (160 acres)"]
[null,"Barbed Wire (4 strand)",null,null,{"$f":"SUM(E37:G37)*E45","v":14888},{"$f":"SUM(E37:G37)*F45","v":0},{"$f":"SUM(E37:G37)*G45","v":7444}]
[null,"Electric Wire (4 strand)",null,null,{"$f":"SUM(E38:G38)*E46","v":0},{"$f":"SUM(E38:G38)*F46","v":0},{"$f":"SUM(E38:G38)*G46","v":0}]
[null,"Electric Wire (2 strand)",null,null,{"$f":"SUM(E39:G39)*E47","v":0},{"$f":"SUM(E39:G39)*F47","v":0},{"$f":"SUM(E39:G39)*G47","v":0}]
[null,"Electric Wire (1 strand)",null,null,{"$f":"SUM(E40:G40)*E48","v":0},{"$f":"SUM(E40:G40)*F48","v":10492},{"$f":"SUM(E40:G40)*G48","v":0}]
[null,"Page Wire (w/optional top wire)",null,null,{"$f":"SUM(E41:G41)*E49","v":0},{"$f":"SUM(E41:G41)*F49","v":0},{"$f":"SUM(E41:G41)*G49","v":0}]
[null,null,null,null,{"$f":"SUM(E52:E56)","v":14888},{"$f":"SUM(F52:F56)","v":10492},{"$f":"SUM(G52:G56)","v":7444}]
[]
[null,"Total Fence Cost",null,null,{"$f":"ROUND((E17/160)*E57,0)","v":69788},{"$f":"ROUND((F17/160)*F57,0)","v":16722},{"$f":"ROUND((G17/160)*G57,0)","v":93050}]
[null,"Total Fence Investment ($/acre)",null,null,{"$f":"ROUND(E59/E17,0)","v":93},{"$f":"ROUND(F59/F17,0)","v":66},{"$f":"ROUND(G59/G17,0)","v":47}]
[null,"Residual Value (End of Useful Life)",null,null,0.1,0.1,0.1]
[null,"Useful Life (years)",null,20]
[null,"Owned Fence Equity",null,0.75]
[null,"Fence Financed",null,{"$f":"SUM(1-D63)","v":0.25}]
[null,"Fencing Cost ($/acre)"]
[null,"Finance Rate & Term",7.0000000000000007E-2,7,"years"]
[null,"Principle & Interest Cost",null,null,{"$f":"-PMT($C$66,$D$66,E60*$D$64,0)","v":4.3141123564244541},{"$f":"-PMT($C$66,$D$66,F60*$D$64,0)","v":3.061628123914129},{"$f":"-PMT($C$66,$D$66,G60*$D$64,0)","v":2.1802503306661221}]
[null,"Fencing Depreciation Cost",null,null,{"$f":"(E60-(E60*$E$61))/$D$62","v":4.1850000000000005},{"$f":"(F60-(F60*$F$61))/$D$62","v":2.9699999999999998},{"$f":"(G60-(G60*$G$61))/$D$62","v":2.1149999999999998}]
[null,"Owned Fence Opportunity Cost ",null,null,{"$f":"SUM(E60*D63)*(D27)","v":0},{"$f":"SUM(F60*D63)*(D27)","v":0},{"$f":"SUM(G60*D63)*(D27)","v":0}]
[null,"Total Cost",null,null,{"$f":"SUM(E67:E69)","v":8.4991123564244546},{"$f":"SUM(F67:F69)","v":6.0316281239141283},{"$f":"SUM(G67:G69)","v":4.2952503306661214}]
[]
["Fence Maintenance (% of investment cost)",null,null,null,0.02]
[]
["Pasture Options - Cost Summary"]
["A. Operating Costs",null,null,null,"Marginal Pasture","Improved Pasture","Crown Lands","Community Pasture","Rented Pasture"]
[null,"Land Development ($/acre)",null,null,0,17.75," - "," - "," - "]
[null,"Fertilizer - Annual ($/acre)",null,null,0,20," - "," - "," - "]
[null,"Herbicide ($/acre)",null,null,1,1,0," - ",0]
[null,"Fence Maintenance ($/acre)",null,null,{"$f":"SUM(E60*$E$72)","v":1.86},{"$f":"SUM(F60*$E$72)","v":1.32},{"$f":"SUM(G60*$E$72)","v":0.94000000000000006}," - ",0]
[null,"Pasture Rental",null,null," - "," - ",{"$f":"SUM(G19/160)","v":4.1375000000000002}," - ",{"$f":"SUM(I19/160)","v":29.6875}]
[null,"Taxes ($/acre)",null,null,6,10," - "," - "," - "]
[null,"Miscellaneous ($/acre)",null,null,0,0,0," - ",0]
[null,"Total Operating Costs ($/acre)",null,null,{"$f":"SUM(E76:E82)","v":8.86},{"$f":"SUM(F76:F82)","v":50.07},{"$f":"SUM(G76:G82)","v":5.0775000000000006}," - ",{"$f":"SUM(I76:I82)","v":29.6875}]
["B. Fixed Costs"]
[null,"Land ($/acre)",null,null,{"$f":"E32","v":16.396296216796987},{"$f":"F32","v":36.891666487793223}," - "," - "," - "]
[null,"Fencing ($/acre)",null,null,{"$f":"E70","v":8.4991123564244546},{"$f":"F70","v":6.0316281239141283},{"$f":"G70","v":4.2952503306661214}," - "," - "]
[null,"Total  Fixed Costs ($/acre)",null,null,{"$f":"SUM(E85:E86)","v":24.895408573221442},{"$f":"SUM(F85:F86)","v":42.923294611707348},{"$f":"SUM(G85:G86)","v":4.2952503306661214}," - ",{"$f":"SUM(I85:I86)","v":0}]
[]
["Total Operating and Fixed ($/acre)",null,null,null,{"$f":"SUM(E87+E83)","v":33.755408573221445},{"$f":"SUM(F87+F83)","v":92.993294611707341},{"$f":"SUM(G87+G83)","v":9.372750330666122}," - ",{"$f":"SUM(I87+I83)","v":29.6875}]
["Total Operating and Fixed ($/year)",null,null,null,{"$f":"SUM(E89*E17)","v":25316.556429916083},{"$f":"SUM(F89*F17)","v":23713.290125985372},{"$f":"SUM(G89*G17)","v":18745.500661332244},{"$f":"SUM(H92*Input!E13)","v":26090},{"$f":"SUM(I89*I17)","v":22265.625}]
[]
[{"$f":"\"Cost per cow (\"&Pasture!G3&\" days pasture)\"","v":"Cost per cow (135 days pasture)"},null,null,null,{"$f":"E89*E16","v":168.77704286610722},{"$f":"F89*F16","v":158.28645891354441},{"$f":"G89*G16","v":124.97000440888164},{"$f":"SUM(H20*G3)+((H21*ROUND(Input!E13*Input!E17/100,0))/Input!E13)","v":173.93333333333334},{"$f":"I89*I16","v":148.4375}]
[{"$f":"\"Cost per cow per day (\"&Pasture!G3&\" days pasture)\"","v":"Cost per cow per day (135 days pasture)"},null,null,null,{"$f":"SUM(E92/$G$3)","v":1.2502003175267202},{"$f":"SUM(F92/$G$3)","v":1.1724922882484772},{"$f":"SUM(G92/$G$3)","v":0.92570373636208614},{"$f":"SUM(H92/$G$3)","v":1.288395061728395},{"$f":"SUM(I92/$G$3)","v":1.099537037037037}]
[]
["Pasture Options - Carrying Capacity and AUM Analysis"]
["Carrying Capacity"]
["Number of head pastured/acre",null,null,null,{"$f":"ROUND(E14/E17,3)","v":0.2},{"$f":"ROUND(F14/F17,3)","v":0.58799999999999997},{"$f":"ROUND(G14/G17,2)","v":0.08}," - ",{"$f":"ROUND(I14/I17,2)","v":0.2}]
["Metabolic Animal Unit Value",null,null,null,{"$f":"ROUND((Input!$E$14^0.75/1000^0.75),2)","v":1.25},{"$f":"ROUND((Input!$E$14^0.75/1000^0.75),2)","v":1.25},{"$f":"ROUND((Input!$E$14^0.75/1000^0.75),2)","v":1.25},{"$f":"ROUND((Input!$E$14^0.75/1000^0.75),2)","v":1.25},{"$f":"ROUND((Input!$E$14^0.75/1000^0.75),2)","v":1.25}]
[]
["AUM Analysis"]
["Total Animal Unit Months (AUM's) ",null,null,null,{"$f":"ROUND(E14*(E98)*$I$3,0)","v":844},{"$f":"ROUND(F14*(F98)*$I$3,0)","v":844},{"$f":"ROUND(G14*(G98)*$I$3,0)","v":844},{"$f":"ROUND(H14*(H98)*$I$3,0)","v":844},{"$f":"ROUND(I14*(I98)*$I$3,0)","v":844}]
["Total AUM's - Available Per Acre ",null,null,null,{"$f":"ROUND(E101/E17,2)","v":1.1299999999999999},{"$f":"ROUND(F101/F17,2)","v":3.31},{"$f":"ROUND(G101/G17,2)","v":0.42},null,{"$f":"ROUND(I101/I17,2)","v":1.1299999999999999}]
["Pasture Investment per AUM",null,null,null,{"$f":"(E24*E17)/E101","v":710.90047393364932},{"$f":"(F24*F17)/F101","v":543.83886255924176}," - "," - "," - "]
["Total Pasture Cost Per AUM",null,null,null,{"$f":"ROUND(E90/E101,2)","v":30},{"$f":"ROUND(F90/F101,2)","v":28.1},{"$f":"ROUND(G90/G101,2)","v":22.21},{"$f":"ROUND(H90/H101,2)","v":30.91},{"$f":"ROUND(I90/I101,2)","v":26.38}]
[]
["Pasture Efficiency Analysis"]
["Pounds liveweight per acre",null,null,null,{"$f":"Input!$E$14*E97","v":270},{"$f":"Input!$E$14*F97","v":793.8},{"$f":"Input!$E$14*G97","v":108}," - ",{"$f":"Input!$E$14*I97","v":270}]
[]
["Pasture Investment per Cow on Pasture",null,null,null,{"$f":"SUM((E24*E17)/E14)","v":4000},{"$f":"SUM((F24*F17)/F14)","v":3060}," - "," - "," - "]
[]
["Pasture Options - Usage Planner"]
[null,null,null,null,"Marginal Pasture","Improved Pasture","Crown Lands","Community Pasture","Rented Pasture","Total"]
[]
["Planned number of cows",null,null,null,60,30,0,0,60,{"$f":"IF(SUM(E114:I114)<Input!E13,\"ERROR\",IF(SUM(E114:I114)>Input!E13,\"ERROR\",SUM(Pasture!E114:I114)))","v":150}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(J114=\"ERROR\",\"(total must = \"&Input!E13&\" cows)\",\"\")","v":""}]
["Acres Required",null,null,null,{"$f":"SUM(E119*E17)","v":300},{"$f":"SUM(F119*F17)","v":51},{"$f":"SUM(G119*G17)","v":0}," - ",{"$f":"SUM(I119*I17)","v":300}]
[]
[]
["percentage of total cost",null,null,null,{"$f":"SUM(E114/E14)","v":0.4},{"$f":"SUM(F114/F14)","v":0.2},{"$f":"SUM(G114/G14)","v":0},{"$f":"SUM(H114/H14)","v":0},{"$f":"SUM(I114/I14)","v":0.4},null,null,"***HIDE**"]
["Cost per Cow",null,null,null,null,null,null,null,null,null,null,"***HIDE**"]
[null,"Pasture op Costs",null,null,{"$f":"E83*E16*E119","v":17.72},{"$f":"F83*F16*F119","v":17.045106382978727},{"$f":"G83*G16*G119","v":0},null,{"$f":"(I83-I80)*I119*I16","v":0},{"$f":"SUM(E121:I121)","v":34.765106382978729},null,"***HIDE**"]
[null,"Pasture Rental",null,null," - "," - "," - ",{"$f":"H92*H119","v":0},{"$f":"I92*I119","v":59.375},{"$f":"SUM(E122:I122)","v":59.375},null,"***HIDE**"]
[null,"3 Pasture Land & Fencing",null,null,{"$f":"SUM(E87*$E$16*$E$119)","v":49.79081714644289},{"$f":"SUM(F87*$F$16*$F$119)","v":14.61218539973016},{"$f":"SUM(G87*$G$16*$G$119)","v":0}," - "," - ",{"$f":"SUM(E123:I123)","v":64.403002546173056},null,"***HIDE**"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J121:J123)","v":158.5431089291518},null,"***HIDE**"]
[null,null,null,null,null,null,null,null,null,null,null,"***HIDE**"]
[null,null,null,null,null,null,null,null,null,null,null,"***HIDE**"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J145,J140,J135,J132)","v":64.403002546173056},null,"***HIDE**"]
[null,null,null,null,null,null,null,null,null,null,null,"***HIDE**"]
[null,"Fencing Principle Cost",null,null,{"$f":"-CUMPRINC($C$66,$D$66,E60*$D$64,1,$D$66,0)/$D$66","v":3.3214285714285716},{"$f":"-CUMPRINC($C$66,$D$66,F60*$D$64,1,$D$66,0)/$D$66","v":2.3571428571428572},{"$f":"-CUMPRINC($C$66,$D$66,G60*$D$64,1,$D$66,0)/$D$66","v":1.6785714285714286},null,null,null,null,"***HIDE**"]
[null,"Land Principle Cost",null,null,{"$f":"-CUMPRINC($C$29,$D$29,E24*$D$26,1,$D$29,0)/$D$29","v":8},{"$f":"-CUMPRINC($C$29,$D$29,F24*$D$26,1,$D$29,0)/$D$29","v":18},null,null,null,null,null,"***HIDE**"]
[null,null,null,null,{"$f":"SUM(E129:E130)","v":11.321428571428571},{"$f":"SUM(F129:F130)","v":20.357142857142858},{"$f":"SUM(G129:G130)","v":1.6785714285714286},null,null,null,null,"***HIDE**"]
[null,null,null,null,{"$f":"SUM(E131*$E$16*$E$119)","v":22.642857142857142},{"$f":"SUM(F131*$F$16*$F$119)","v":6.9300911854103351},{"$f":"SUM(G131*$G$16*$G$119)","v":0},null,null,{"$f":"SUM(E132:I132)","v":29.572948328267479},null,"***HIDE**"]
[null,null,null,null,null,null,null,null,null,null,null,"***HIDE**"]
[null,"Fencing Depreciation Cost",null,null,{"$f":"(E60-(E60*$E$61))/$D$62","v":4.1850000000000005},{"$f":"(F60-(F60*$F$61))/$D$62","v":2.9699999999999998},{"$f":"(G60-(G60*$G$61))/$D$62","v":2.1149999999999998},null,null,null,null,"***HIDE**"]
[null,null,null,null,{"$f":"SUM(E134*$E$16*$E$119)","v":8.3700000000000028},{"$f":"SUM(F134*$F$16*$F$119)","v":1.0110638297872341},{"$f":"SUM(G134*$G$16*$G$119)","v":0},null,null,{"$f":"SUM(E135:I135)","v":9.3810638297872373},null,"***HIDE**"]
[null,null,null,null,null,null,null,null,null,null,null,"***HIDE**"]
[null,"Land Interest Cost",null,null,{"$f":"-CUMIPMT($C$29,$D$29,E24*$D$26,1,$D$29,0)/$D$29","v":8.396296216796987},{"$f":"-CUMIPMT($C$29,$D$29,F24*$D$26,1,$D$29,0)/$D$29","v":18.891666487793223},null,null,null,null,null,"***HIDE**"]
[null,"Fencing Interest Cost",null,null,{"$f":"-CUMIPMT($C$66,$D$66,E60*$D$64,1,$D$66,0)/$D$66","v":0.99268378499588295},{"$f":"-CUMIPMT($C$66,$D$66,F60*$D$64,1,$D$66,0)/$D$66","v":0.70448526677127177},{"$f":"-CUMIPMT($C$66,$D$66,G60*$D$64,1,$D$66,0)/$D$66","v":0.50167890209469335},null,null,null,null,"***HIDE**"]
[null,null,null,null,{"$f":"SUM(E137:E138)","v":9.38898000179287},{"$f":"SUM(F137:F138)","v":19.596151754564495},{"$f":"SUM(G137:G138)","v":0.50167890209469335},null,null,null,null,"***HIDE**"]
[null,null,null,null,{"$f":"SUM(E139*$E$16*$E$119)","v":18.777960003585743},{"$f":"SUM(F139*$F$16*$F$119)","v":6.6710303845325942},{"$f":"SUM(G139*$G$16*$G$119)","v":0},null,null,{"$f":"SUM(E140:I140)","v":25.448990388118339},null,"***HIDE**"]
[null,null,null,null,null,null,null,null,null,null,null,"***HIDE**"]
[null,"Owned Land Opportunity Cost",null,null,{"$f":"SUM(E24*D25)*(D27)","v":0},{"$f":"SUM(F24*D25)*(D27)","v":0}," - "," - "," - ",null,null,"***HIDE**"]
[null,"Owned Fence Opportunity Cost ",null,null,{"$f":"SUM(E60*D63)*(D27)","v":0},{"$f":"SUM(F60*D63)*(D27)","v":0},{"$f":"SUM(G60*D63)*(D27)","v":0},null,null,null,null,"***HIDE**"]
[null,null,null,null,{"$f":"SUM(E142:E143)","v":0},{"$f":"SUM(F142:F143)","v":0},{"$f":"SUM(G142:G143)","v":0},null,null,null,null,"***HIDE**"]
[null,null,null,null,{"$f":"SUM(E144*$E$16*$E$119)","v":0},{"$f":"SUM(F144*$F$16*$F$119)","v":0},{"$f":"SUM(G144*$G$16*$G$119)","v":0},null,null,{"$f":"SUM(E145:I145)","v":0},null,"***HIDE**"]

{"sheet":"Winter Feed Rations","index":9,"n_rows":61,"n_cols":15,"rows_kept":61,"cut":false,"hidden":false,"merged":[[0,0,0,14],[6,0,6,14],[28,0,28,14],[2,0,2,14],[26,1,26,3],[8,1,8,3],[4,0,4,14],[7,13,10,13],[7,14,10,14],[29,14,31,14],[30,1,30,3],[60,0,62,14],[49,0,49,14],[7,1,7,3],[47,1,47,3],[57,0,58,14],[29,1,29,3],[29,13,31,13]]}
["Winter Feed Costs & Requirements Worksheet"]
[]
[{"$f":"\"Total Winter Feeding = \"&Pasture!G5&\" days\"","v":"Total Winter Feeding = 195 days"}]
[]
["Enter your days on feed for each selected ration number in the \"blue\" numbers in the \"gray\" shaded area"]
[]
["Pre Calving - Cows"]
[null,"Ration Number",null,null,"#1","#2","#3","#4","#5","#6","#7","#8","#9","Total lbs /cow","Total Cost /cow2"]
[{"$f":"IF(H54=Pasture!G5,\"\",\"ERROR\")","v":""},"Days on Feed",null,null,135,0,0,0,0,0,0,0,0]
[null,null,null,null,"Hay","Barley Silage","Corn Silage","Straw & Grain","Greenfeed & Hay","Straw, Grain & Suppl.","Corn Silage & Hay","Straw & Pellets"]
["Feed Type","$/unit","lbs/Unit","$/lb",null,null,null,null,null,"Ration - Feed Per Day (lbs based on",1400,"lb cow)"]
["Alfalfa Hay",155,2000,{"$f":"SUM(B12/C12)","v":7.7499999999999999E-2},0,0,0,0,0,0,0,0,0,{"$f":"SUM((E9*E12)+(F12*F9)+(G12*G9)+(H12*H9)+(I12*I9)+(J12*J9)+(K12*K9)+(L12*L9)+(M12*M9))*(Input!E14/K11)","v":0},{"$f":"SUM(N12*D12)","v":0}]
["Alfalfa Grass Hay",115,2000,{"$f":"SUM(B13/C13)","v":5.7500000000000002E-2},35,0,0,0,16,0,10,0,0,{"$f":"SUM((E13*E9)+(F13*F9)+(G13*G9)+(H13*H9)+(I13*I9)+(J13*J9)+(K13*K9)+(L13*L9)+(M13*M9))*(Input!E14/K11)","v":4556.25},261.984375]
["Grass Hay",95,2000,{"$f":"SUM(B14/C14)","v":4.7500000000000001E-2},0,0,0,0,0,0,0,0,0,{"$f":"SUM((E14*E9)+(F14*F9)+(G14*G9)+(H14*H9)+(I14*I9)+(J14*J9)+(K14*K9)+(L14*L9)+(M14*M9))*(Input!E14/K11)","v":0},0]
["Barley Straw",70,2000,3.5000000000000003E-2,0,17,19,23,0,23,15,23,0,{"$f":"SUM((E15*E9)+(F15*F9)+(G15*G9)+(H15*H9)+(I15*I9)+(J15*J9)+(K15*K9)+(L15*L9)+(M15*M9))*(Input!E14/K11)","v":0},0]
["Barley Greenfeed",115,2000,5.7500000000000002E-2,0,0,0,0,19,0,0,0,0,{"$f":"SUM((E16*E9)+(F16*F9)+(G16*G9)+(H16*H9)+(I16*I9)+(J16*J9)+(K16*K9)+(L16*L9)+(M16*M9))*(Input!E14/K11)","v":0},0]
["Corn Silage",40,2000,0.02,0,0,47,0,0,0,32,0,0,{"$f":"SUM((E17*E9)+(F17*F9)+(G17*G9)+(H17*H9)+(I17*I9)+(J17*J9)+(K17*K9)+(L17*L9)+(M17*M9))*(Input!E14/K11)","v":0},0]
["Barley Silage",50,2000,2.5000000000000001E-2,0,48,0,0,0,0,0,0,0,{"$f":"SUM((E18*E9)+(F18*F9)+(G18*G9)+(H18*H9)+(I18*I9)+(J18*J9)+(K18*K9)+(L18*L9)+(M18*M9))*(Input!E14/K11)","v":0},0]
["Barley Grain",4.5,48,9.375E-2,0,0,0,11,0,10,0,0,0,{"$f":"SUM((E19*E9)+(F19*F9)+(G19*G9)+(H19*H9)+(I19*I9)+(J19*J9)+(K19*K9)+(L19*L9)+(M19*M9))*(Input!E14/K11)","v":0},0]
["32% Feedlot Suppl.",550,2205,0.24943310657596371,0,0.5,0.5,1,0,0,0,0,0,{"$f":"SUM((E20*E9)+(F20*F9)+(G20*G9)+(H20*H9)+(I20*I9)+(J20*J9)+(K20*K9)+(L20*L9)+(M20*M9))*(Input!E14/K11)","v":0},0]
["32% Liquid Suppl.",500,2205,0.22675736961451248,0,0,0,0,0,2.9,0,0,0,{"$f":"SUM((E21*E9)+(F21*F9)+(G21*G9)+(H21*H9)+(I21*I9)+(J21*J9)+(K21*K9)+(L21*L9)+(M21*M9))*(Input!E14/K11)","v":0},0]
["20% Grain Pellets",300,2205,0.1360544217687075,0,0,0,0,0,0,0,14,0,{"$f":"SUM((E22*E9)+(F22*F9)+(G22*G9)+(H22*H9)+(I22*I9)+(J22*J9)+(K22*K9)+(L22*L9)+(M22*M9))*(Input!E14/K11)","v":0},0]
["1:1 Mineral",50,55,0.90909090909090906,0.12,0,0,0,0,0,0,0,0,{"$f":"SUM((E23*E9)+(F23*F9)+(G23*G9)+(H23*H9)+(I23*I9)+(J23*J9)+(K23*K9)+(L23*L9)+(M23*M9))*(Input!E14/K11)","v":15.621428571428572},14.2012987012987]
["2:1 Mineral",50,55,0.90909090909090906,0,0.06,0.06,0.06,0.12,0.2,0.2,0.06,0,{"$f":"SUM((E24*E9)+(F24*F9)+(G24*G9)+(H24*H9)+(I24*I9)+(J24*J9)+(K24*K9)+(L24*L9)+(M24*M9))*(Input!E14/K11)","v":0},0]
["Limestone",20,55,0.36363636363636365,0,0,0,0,0,0.2,0,0.2,0,{"$f":"SUM((E25*E9)+(F25*F9)+(G25*G9)+(H25*H9)+(I25*I9)+(J25*J9)+(K25*K9)+(L25*L9)+(M25*M9))*(Input!E14/K11)","v":0},0]
["Blue Salt",10,55,0.18181818181818182,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,0,{"$f":"SUM((E26*E9)+(F26*F9)+(G26*G9)+(H26*H9)+(I26*I9)+(J26*J9)+(K26*K9)+(L26*L9)+(M26*M9))*(Input!E14/K11)","v":9.1125000000000007},1.656818181818182]
[null,"$/head/day",null,null,{"$f":"SUM((E12*$D$12)+(E13*$D$13)+(E14*$D$14)+(E15*$D$15)+(E16*$D$16)+(E17*$D$17)+(E18*$D$18)+(E19*$D$19)+(E20*$D$20)+(E21*$D$21)+(E22*$D$22)+(E23*$D$23)+(E24*$D$24)+(E25*$D$25+(E26*$D$26)))","v":2.1343181818181818},{"$f":"SUM((F12*$D$12)+(F13*$D$13)+(F14*$D$14)+(F15*$D$15)+(F16*$D$16)+(F17*$D$17)+(F18*$D$18)+(F19*$D$19)+(F20*$D$20)+(F21*$D$21)+(F22*$D$22)+(F23*$D$23)+(F24*$D$24)+(F25*$D$25+(F26*$D$26)))","v":1.9869892805607094},1.7969892805607091,2.1529558338486914,2.1343181818181818,2.6673690991548136,1.9345454545454548,2.8497619047619049,0,null,{"$f":"SUM(O12:O26)","v":277.84249188311691}]
[]
["Post Calving - Cows"]
[null,"Ration Number",null,null,"#1","#2","#3","#4","#5","#6","#7","#8","#9","Total lbs /cow","Total Cost /cow2"]
[{"$f":"IF(H54=Pasture!G5,\"\",\"ERROR\")","v":""},"Days on Feed",null,null,60,0,0,0,0,0,0,0,0]
["Feed Type","$/unit","lbs/Unit","$/lb",null,null,null,null,null,"Ration - Feed Per Day (lbs based on",1400,"lb cow)"]
[{"$f":"A12","v":"Alfalfa Hay"},155,2000,{"$f":"SUM(B33/C33)","v":7.7499999999999999E-2},0,0,0,0,0,0,0,0,0,{"$f":"SUM((E31*E33)+(F33*F31)+(G33*G31)+(H33*H31)+(I33*I31)+(J33*J31)+(K33*K31)+(L33*L31)+(M33*M31))*(Input!E14/K32)","v":0},{"$f":"SUM(N33*D33)","v":0}]
["Alfalfa Grass Hay",115,2000,{"$f":"SUM(B34/C34)","v":5.7500000000000002E-2},44,0,0,0,20,0,20,15,0,{"$f":"SUM((E34*E31)+(F34*F31)+(G34*G31)+(H34*H31)+(I34*I31)+(J34*J31)+(K34*K31)+(L34*L31)+(M34*M31))*(Input!E14/K32)","v":2545.7142857142858},146.37857142857143]
["Grass Hay",95,2000,{"$f":"SUM(B35/C35)","v":4.7500000000000001E-2},0,0,0,0,0,0,0,0,0,{"$f":"SUM((E35*E31)+(F35*F31)+(G35*G31)+(H35*H31)+(I35*I31)+(J35*J31)+(K35*K31)+(L35*L31)+(M35*M31))*(Input!E14/K32)","v":0},0]
["Barley Straw",70,2000,3.5000000000000003E-2,0,12,12,24,0,23,8,11,0,{"$f":"SUM((E36*E31)+(F36*F31)+(G36*G31)+(H36*H31)+(I36*I31)+(J36*J31)+(K36*K31)+(L36*L31)+(M36*M31))*(Input!E14/K32)","v":0},0]
["Barley Greenfeed",115,2000,5.7500000000000002E-2,0,0,0,0,16,0,0,0,0,{"$f":"SUM((E37*E31)+(F37*F31)+(G37*G31)+(H37*H31)+(I37*I31)+(J37*J31)+(K37*K31)+(L37*L31)+(M37*M31))*(Input!E14/K32)","v":0},0]
["Corn Silage",40,2000,0.02,0,0,48,0,0,0,40,0,0,{"$f":"SUM((E38*E31)+(F38*F31)+(G38*G31)+(H38*H31)+(I38*I31)+(J38*J31)+(K38*K31)+(L38*L31)+(M38*M31))*(Input!E14/K32)","v":0},0]
["Barley Silage",50,2000,2.5000000000000001E-2,0,45,0,0,0,0,0,0,0,{"$f":"SUM((E39*E31)+(F39*F31)+(G39*G31)+(H39*H31)+(I39*I31)+(J39*J31)+(K39*K31)+(L39*L31)+(M39*M31))*(Input!E14/K32)","v":0},0]
["Barley Grain",4.5,48,9.375E-2,5,12,7,15,5,15,0,0,0,{"$f":"SUM((E40*E31)+(F40*F31)+(G40*G31)+(H40*H31)+(I40*I31)+(J40*J31)+(K40*K31)+(L40*L31)+(M40*M31))*(Input!E14/K32)","v":289.28571428571428},27.120535714285715]
["32% Feedlot Suppl.",550,2205,0.24943310657596371,0,0,2,2.5,0,0,0,0,0,{"$f":"SUM((E41*E31)+(F41*F31)+(G41*G31)+(H41*H31)+(I41*I31)+(J41*J31)+(K41*K31)+(L41*L31)+(M41*M31))*(Input!E14/K32)","v":0},0]
["32% Liquid Suppl.",500,2205,0.22675736961451248,0,0,0,0,0,3.5,0,0,0,{"$f":"SUM((E42*E31)+(F42*F31)+(G42*G31)+(H42*H31)+(I42*I31)+(J42*J31)+(K42*K31)+(L42*L31)+(M42*M31))*(Input!E14/K32)","v":0},0]
["20% Grain Pellets",300,2205,0.1360544217687075,0,0,0,0,0,0,0,15,0,{"$f":"SUM((E43*E31)+(F43*F31)+(G43*G31)+(H43*H31)+(I43*I31)+(J43*J31)+(K43*K31)+(L43*L31)+(M43*M31))*(Input!E14/K32)","v":0},0]
["1:1 Mineral",50,55,0.90909090909090906,0.18,0,0,0,0,0,0,0,0,{"$f":"SUM((E44*E31)+(F44*F31)+(G44*G31)+(H44*H31)+(I44*I31)+(J44*J31)+(K44*K31)+(L44*L31)+(M44*M31))*(Input!E14/K32)","v":10.414285714285713},9.4675324675324664]
["2:1 Mineral",50,{"$f":"C24","v":55},0.90909090909090906,0,0.18,0.18,0.18,0.18,0.18,0.18,0.18,0,{"$f":"SUM((E45*E31)+(F45*F31)+(G45*G31)+(H45*H31)+(I45*I31)+(J45*J31)+(K45*K31)+(L45*L31)+(M45*M31))*(Input!E14/K32)","v":0},0]
[{"$f":"A25","v":"Limestone"},{"$f":"B25","v":20},{"$f":"C25","v":55},0.36363636363636365,0,0.1,0.1,0.1,0,0.3,0,0.1,0,{"$f":"SUM((E46*E31)+(F46*F31)+(G46*G31)+(H46*H31)+(I46*I31)+(J46*J31)+(K46*K31)+(L46*L31)+(M46*M31))*(Input!E14/K32)","v":0},0]
[{"$f":"A26","v":"Blue Salt"},{"$f":"B26","v":10},{"$f":"C26","v":55},0.18181818181818182,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0,{"$f":"SUM((E47*E31)+(F47*F31)+(G47*G31)+(H47*H31)+(I47*I31)+(J47*J31)+(K47*K31)+(L47*L31)+(M47*M31))*(Input!E14/K32)","v":5.7857142857142856},1.051948051948052]
[null,"$/head/day",null,null,{"$f":"SUM((E33*$D$33)+(E34*$D$34)+(E35*$D$35)+(E36*$D$36)+(E37*$D$37)+(E38*$D$38)+(E39*$D$39)+(E40*$D$40)+(E41*$D$41)+(E42*$D$42)+(E43*$D$43)+(E44*$D$44)+(E45*$D$45)+(E46*$D$46+(E47*$D$47)))","v":3.1805681818181819},{"$f":"SUM((F33*$D$33)+(F34*$D$34)+(F35*$D$35)+(F36*$D$36)+(F37*$D$37)+(F38*$D$38)+(F39*$D$39)+(F40*$D$40)+(F41*$D$41)+(F42*$D$42)+(F43*$D$43)+(F44*$D$44)+(F45*$D$45)+(F46*$D$46+(F47*$D$47)))","v":2.8881818181818182},2.7532980313337454,3.0880145846217273,2.7205681818181819,3.2958098845598851,2.4118181818181821,3.5064981447124306,0,null,{"$f":"SUM(O33:O47)","v":184.01858766233767}]
[]
["Winter Feed Summary"]
[null,null,null,null,null,null,null,"Total Days on Feed1",null,null,"Average Cost/Day",null,null,null,"Feed Cost per Cow2"]
[null,null,null,"Pre Calving - Cows",null,null,null,{"$f":"SUM(E9:M9)","v":135},null,null,{"$f":"IF(O52=0,0,SUM(O52/H52))","v":2.0580925324675325},null,null,null,{"$f":"O27","v":277.84249188311691}]
[null,null,null,"Post Calving - Cows",null,null,null,{"$f":"SUM(E31:M31)","v":60},null,null,{"$f":"IF(O53=0,0,SUM(O53/H53))","v":3.0669764610389612},null,null,null,{"$f":"O48","v":184.01858766233767}]
[null,null,null,null,null,null,null,{"$f":"SUM(H52:H53)","v":195},null,null,{"$f":"IF(O54=0,0,SUM(O54/H54))","v":2.368518356643357},null,null,null,{"$f":"SUM(O52:O53)","v":461.86107954545457}]
[null,null,null,null,null,{"$f":"IF(H54=Pasture!G5,\"\",\"# DAYS ON FEED RATION ERROR\")","v":""}]
[{"$f":"\"1.  Total Days on Feed Must = \"&Pasture!G5&\" Days (as calculated on Input worksheet)\"","v":"1.  Total Days on Feed Must = 195 Days (as calculated on Input worksheet)"}]
[{"$f":"\"2.  Feed Cost Per Cow Based on \"&Input!E14&\" lb Cow\"","v":"2.  Feed Cost Per Cow Based on 1350 lb Cow"}]
[{"$f":"IF(OR(F9>0,G9>0,K9>0,F31>0,G31>0,K31>0),\"Note: When selecting silage based feed rations, please input all required equipment capital costs on the 'Input' worksheet associated with feeding and feed delivery for silage.\",\"\")","v":""}]
[]
[]
["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 ration, contact a Manitoba Agriculture Livestock Specialist."]

{"sheet":"Fixed","index":10,"n_rows":66,"n_cols":20,"rows_kept":66,"cut":false,"hidden":false,"merged":[[0,0,0,9],[44,0,44,9],[45,3,45,4],[45,8,45,9]]}
["Fixed Costs"]
[]
["Cows",null,null,null,null,"Machinery & Equipment"]
[null,"  Cow value ($/head)",null,{"$f":"Input!E28","v":2600},null,null,"  Total Investment ($/cow)",null,{"$f":"ROUND((SUM(J48:J63)/(Input!E13)),0)","v":1183},null,null,"*HIDE*"]
[null,"  Owned Cow Equity",null,0.85,null,null,"  Residual Value (End of Useful Life)",null,0.2,null,null,{"$f":"(#REF!-#REF!)/(#REF!+D17)","v":{"$error":"#REF!"}}]
[null,{"$f":"\"  Cows Financed (\"&TEXT(D4*D6,\"$#,###\")&\" per head)\"","v":"  Cows Financed ($390 per head)"},null,{"$f":"SUM(1-D5)","v":0.15000000000000002},null,null,"  Useful Life (years)",null,10]
[null,"  Cow Opportunity Cost (Investment Rate) ",null,0,null,null,"  Owned Machinery Equity",null,0.8]
[null,"Cow cost ($/head)",null,null,null,null,{"$f":"\"  Machinery Financed (\"&TEXT((I4)*I8,\"$#,###\")&\" per head)\"","v":"  Machinery Financed ($237 per head)"},null,{"$f":"SUM(1-I7)","v":0.19999999999999996}]
[null,"  Finance Rate & Term",7.0000000000000007E-2,7,"Years",null,"  Machinery Opportunity Cost (Investment Rate) ",null,0]
[null,"  Principle & Interest Cost",null,{"$f":"-PMT(C9,D9,D4*D6,0)","v":72.365755656152146},null,null,"Machinery & Equipment Cost ($/cow)"]
[null,"  Owned Cows Opportunity Cost",null,{"$f":"SUM(D4*D5)*(D7)","v":0},null,null,"  Finance Rate & Term",7.0000000000000007E-2,7,"Years"]
[null,"  Total Cost",null,{"$f":"SUM(D10:D11)","v":72.365755656152146},null,null,"  Principle & Interest Cost",null,{"$f":"-PMT(H11,I11,I4*I8,0)","v":43.901891764732284}]
[null,null,null,null,null,null,"  Machinery Depreciation Cost",null,{"$f":"(I4-(I4*I5))/I6","v":94.64}]
[null,null,null,null,null,null,"  Owned Machinery Opportunity Cost ",null,{"$f":"SUM(I4*I7)*(I9)","v":0}]
["Marginal Pasture Land",null,null,null,null,null,"  Total Cost",null,{"$f":"SUM(I12:I14)","v":138.54189176473227}]
[null,"  Average Land value ($/acre)",null,{"$f":"Pasture!E24","v":800}]
[null,"  Pasture acres",null,{"$f":"Pasture!E116","v":300},null,"Buildings & Facilities"]
[null,"  Owned Land Equity",null,{"$f":"Pasture!D25","v":0.75},null,null,"  Total Investment ($/cow)",null,{"$f":"ROUND((SUM(E48:E63)/(Input!E13)),0)","v":517}]
[null,{"$f":"\"  Land Financed (\"&TEXT(D16*D19,\"$#,###\")&\" per acre)\"","v":"  Land Financed ($200 per acre)"},null,{"$f":"SUM(1-D18)","v":0.25},null,null,"  Residual Value (End of Useful Life)",null,0.2]
[null,"  Land Opportunity Cost (Investment Rate) ",null,{"$f":"Pasture!D27","v":0},null,null,"  Useful Life (years)",null,20,null,null,"w/o harvest"]
[null,"Land cost ($/acre)",null,null,null,null,"  Owned Building Equity",null,0.85,null,null,{"$f":"-PMT($H$25,$I$25,L5*$I$22,0)","v":{"$error":"#REF!"}}]
[null,"  Finance Rate & Term",{"$f":"Pasture!C29","v":6.5000000000000002E-2},{"$f":"Pasture!D29","v":25},"Years",null,{"$f":"\"  Building Financed (\"&TEXT((I18)*I22,\"$#,###\")&\" per head)\"","v":"  Building Financed ($78 per head)"},null,{"$f":"SUM(1-I21)","v":0.15000000000000002},null,null,{"$f":"(L5-(L5*$I$19))/$I$20","v":{"$error":"#REF!"}}]
[null,"  Principle & Interest Cost",null,{"$f":"-PMT(C22,D22,D16*D19,0)","v":16.396296216796987},null,null,"  Building Opportunity Cost (Investment Rate) ",null,0,null,null,{"$f":"SUM(L5*$I$21)*($I$23)","v":{"$error":"#REF!"}}]
[null,"  Owned Land Opportunity Cost",null,{"$f":"SUM(D16*D18)*(D20)","v":0},null,null,"Building & Water System Cost ($/cow)",null,null,null,null,{"$f":"SUM(L21:L23)","v":{"$error":"#REF!"}}]
[null,"  Total Cost",null,{"$f":"SUM(D23:D24)","v":16.396296216796987},null,null,"  Finance Rate & Term",7.0000000000000007E-2,7,"Years"]
[null,null,null,null,null,null,"  Principle & Interest Cost",null,{"$f":"-PMT(H25,I25,I18*I22,0)","v":14.389652182396407}]
[null,null,null,null,null,null,"  Building Depreciation Cost",null,{"$f":"(I18-(I18*I19))/I20","v":20.68}]
[null,null,null,null,null,null,"  Owned Building Opportunity Cost ",null,{"$f":"SUM(I18*I21)*(I23)","v":0}]
["Improved Pasture Land",null,null,null,null,null,"  Total Cost",null,{"$f":"SUM(I26:I28)","v":35.06965218239641}]
[null,"  Average Land value ($/acre)",null,{"$f":"Pasture!F24","v":1800}]
[null,"  Pasture acres",null,{"$f":"Pasture!F116","v":51},null,"Fencing"]
[null,"  Owned Land Equity",null,{"$f":"Pasture!D25","v":0.75},null,null,"  Total Investment ($/cow)",null,{"$f":"SUM((Pasture!E59*Pasture!E119)+(Pasture!F59*Pasture!F119)+(Pasture!G59*Pasture!G119))/Input!E13","v":208.39733333333334}]
[null,{"$f":"\"  Land Financed (\"&TEXT(D30*D33,\"$#,###\")&\" per acre)\"","v":"  Land Financed ($450 per acre)"},null,{"$f":"SUM(1-D32)","v":0.25},null,null,"  Residual Value (End of Useful Life)",null,{"$f":"Pasture!E61","v":0.1}]
[null,"  Land Opportunity Cost (Investment Rate) ",null,{"$f":"Pasture!D27","v":0},null,null,"  Useful Life (years)",null,{"$f":"Pasture!D62","v":20}]
[null,"Land cost ($/acre)",null,null,null,null,"  Owned Fence Equity",null,{"$f":"Pasture!D63","v":0.75}]
[null,"  Finance Rate & Term",{"$f":"Pasture!C29","v":6.5000000000000002E-2},{"$f":"Pasture!D29","v":25},"Years",null,{"$f":"\"  Fence Financed (\"&TEXT((I32)*I36,\"$#,###\")&\" per head)\"","v":"  Fence Financed ($52 per head)"},null,{"$f":"SUM(1-I35)","v":0.25}]
[null,"  Principle & Interest Cost",null,{"$f":"-PMT(C36,D36,D30*D33,0)","v":36.891666487793223},null,null,"  Fence Opportunity Cost (Investment Rate) ",null,{"$f":"Pasture!D27","v":0}]
[null,"  Owned Land Opportunity Cost",null,{"$f":"SUM(D30*D32)*(D34)","v":0},null,null,"Fencing Cost ($/cow)"]
[null,"  Total Cost",null,{"$f":"SUM(D37:D38)","v":36.891666487793223},null,null,"  Finance Rate & Term",{"$f":"Pasture!C66","v":7.0000000000000007E-2},{"$f":"Pasture!D66","v":7}]
[null,null,null,null,null,null,"  Principle & Interest Cost",null,{"$f":"-PMT(H39,I39,I32*I36,0)","v":9.6671990406369801}]
["Total Principle & Interest Cost ($/cow)",null,null,{"$f":"SUM(D10+I12+I26+I40+D37+D23)","v":193.61246134850805},null,null,"  Fence Depreciation Cost",null,{"$f":"(I32-(I32*I33))/I34","v":9.3778800000000011}]
[{"$f":"\"Total Principle & Interest Cost (\"&Input!E13&\" cows)\"","v":"Total Principle & Interest Cost (150 cows)"},null,null,{"$f":"D41*Input!E13","v":29041.869202276208},null,null,"  Owned Fence Opportunity Cost ",null,{"$f":"SUM(I32*I35)*(I37)","v":0}]
[null,null,null,null,null,null,"  Total Cost",null,{"$f":"SUM(I40:I42)","v":19.045079040636981}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.75E-2]
["Capital Value"]
[null,null,"Market","Cow-calf",null,null,null,"Market","Cow-calf"]
["Buildings & Facilities",null,"Value","Usage %","Allocation",null,"Machinery & Equipment","Value","Usage %","Allocation"]
[null,"Windbreak Fence",{"$f":"Input!G99","v":5812.5},1,{"$f":"SUM(C48*D48)","v":5812.5},null,"Miscellaneous Machinery",10000,1,{"$f":"SUM(H48*I48)","v":10000}]
[null,"Feedlot Fence",{"$f":"Input!G102","v":4650},1,4650,null,"Tractor & Loader ",175000,0.5,87500]
[null,"Calf Shelters",{"$f":"Input!G105","v":9300},1,9300,null,"Bale Shredder",25000,1,25000]
[null,"Handling Facilities",15000,1,15000,null,"Tractor & Feed Wagon (silage)",0,1,0]
[null,"Calving Facility ",12500,1,12500,null,"Stock Trailer",25000,1,25000]
[null,"Waterers",{"$f":"Input!G96","v":4000},1,4000,null,"Truck",60000,0.5,30000]
[null,"Pasture Watering System",4000,1,4000,null,null,0,1,0]
[null,"Pasture Water Source ",3000,1,3000,null,null,0,1,0]
[null,"Gates",1450,1,1450,null,null,0,1,0]
[null,"Feeders",2400,1,2400,null,null,0,1,0]
[null,"Well & Pressure System",8000,1,8000,null,null,0,1,0]
[null,"Hydro (6 poles @ $400)",2400,1,2400,null,null,0,1,0]
[null,"Storage Bins",5000,1,5000,null,null,0,1,0]
[null,null,0,1,0,null,null,0,1,0]
[null,null,0,1,0,null,null,0,1,0]
[null,null,0,0,0,null,null,0,1,0]
[null,null,null,null,{"$f":"\"Total Inv. = $\"&TEXT(SUM(E48:E63),\"#,###\")&\" ($\"&ROUND(SUM(E48:E63)/(Input!E13),0)&\"/cow)\"","v":"Total Inv. = $77,513 ($517/cow)"},null,null,null,null,{"$f":"\"Total Inv. = $\"&TEXT(SUM(J48:J63),\"#,###\")&\" ($\"&ROUND(SUM(J48:J63)/(Input!E13),0)&\"/cow)\"","v":"Total Inv. = $177,500 ($1183/cow)"}]
[null,"Buildings & Water - Target $/cow",350,null,null,null,"Machinery - Target $/cow",750]
[null,{"$f":"IF(ROUND(SUM(E48:E63)/(Input!E13),0)<C65,\"(Under Invested by\",IF(ROUND(SUM(E48:E63)/(Input!E13),0)=C65,\"(On Target\",\"(Over Invested by\"))","v":"(Over Invested by"},{"$f":"\"$\"&TEXT(ABS((ROUND(SUM(E48:E63)/(Input!$E$13),2)-C65)*(Input!$E$13)),\"#,###\")&\")\"","v":"$25,013)"},null,null,null,{"$f":"IF(ROUND(SUM(J48:J63)/(Input!E13),0)<H65,\"(Under Invested by\",IF(ROUND(SUM(J48:J63)/(Input!E13),0)=H65,\"(On Target\",\"(Over Invested by\"))","v":"(Over Invested by"},{"$f":"\"$\"&TEXT(ABS((ROUND(SUM(J48:J63)/(Input!E13),2)-H65)*(Input!E13)),\"#,###\")&\")\"","v":"$65,000)"}]

{"sheet":"Extended Grazing","index":11,"n_rows":57,"n_cols":7,"rows_kept":57,"cut":false,"hidden":false,"merged":[[0,0,0,7],[43,0,43,7],[56,0,57,7],[32,0,32,7],[6,0,6,7]]}
["Extended Grazing Costs & Requirements Worksheet"]
[]
["Extended Grazing Days ",null,{"$f":"Pasture!G4","v":35}]
["Number of Cows",null,{"$f":"Input!E13","v":150}]
["Number of Cow Grazing Days",null,{"$f":"SUM(C3*C4)","v":5250}]
[]
["Extended Grazing Options - Costs"]
[null,null,"Corn Grazing","Stockpiled Forage","Swath Grazing","Crop Residue"]
[]
[]
["Standing Forage Cost ($/lb)",null,"n/a",2.5000000000000001E-2,"n/a",1.4999999999999999E-2]
[]
["Input Costs ($/acre)"]
[null,"Seed",96,null,32]
[null,"Fertilizer (incl. applic.)",147,null,81]
[null,"Herbicide",16,null,16]
[null,"Custom tillage",12,null,12]
[null,"Custom seeding",25,null,25]
[null,"Custom spraying",9,null,9]
[null,"Miscellaneous",7.75,null,7.75]
[null,"Land taxes",15,null,15]
[null,"Land Costs",75,null,75]
[null,"Labour",{"$f":"SUM(0.75*'Operating '!E135)","v":20.25},null,{"$f":"C23","v":20.25}]
[null,"Subtotal",{"$f":"SUM(C14:C23)","v":423},{"$f":"SUM(D34*2000*D11)","v":50},{"$f":"SUM(E14:E23)","v":293},{"$f":"SUM(F34*2000*F11)","v":7.5}]
[]
["Fencing Costs"]
[null,"Estimated miles of fence required",{"$f":"SUM(C38/80)","v":0.17499999999999999},{"$f":"SUM(D38/80)","v":1.4750000000000001},{"$f":"SUM(E38/80)","v":0.3},{"$f":"SUM(F38/80)","v":5.7750000000000004}]
[null,"Fence Investment Cost/acre",{"$f":"SUM(C27*Pasture!$H$40*(Input!$E$75/100))/C38","v":1.3115000000000001},{"$f":"SUM(D27*Pasture!$H$40*(Input!$E$75/100))/D38","v":1.3115000000000001},{"$f":"SUM(E27*Pasture!$H$40*(Input!$E$75/100))/E38","v":1.3114999999999999},{"$f":"SUM(F27*Pasture!$H$40*(Input!$E$75/100))/F38","v":1.3115000000000001}]
[null,"Fence Depreciation Cost/acre",{"$f":"SUM((C27*Pasture!$H$40)/Pasture!$D$62)/C38","v":1.6393749999999998},{"$f":"SUM((D27*Pasture!$H$40)/Pasture!$D$62)/D38","v":1.6393750000000002},{"$f":"SUM((E27*Pasture!$H$40)/Pasture!$D$62)/E38","v":1.639375},{"$f":"SUM((F27*Pasture!$H$40)/Pasture!$D$62)/F38","v":1.639375}]
[]
["Total cost per acre",null,{"$f":"SUM(C29+C28+C24)","v":425.950875},{"$f":"SUM(D29+D28+D24)","v":52.950875000000003},{"$f":"SUM(E29+E28+E24)","v":295.950875},{"$f":"SUM(F29+F28+F24)","v":10.450875}]
[]
["Extended Grazing Options - Yields & Cost Comparison"]
["Grazing Yield (wet tons/acre)",null,15,1,7.5,0.25]
["% moisture",null,50,10,40,8]
[null,"Yield (tons dry matter/acre)",{"$f":"SUM(1-(C35/100))*C34","v":7.5},{"$f":"SUM(1-(D35/100))*D34","v":0.9},{"$f":"SUM(1-(E35/100))*E34","v":4.5},{"$f":"SUM(1-(F35/100))*F34","v":0.23}]
[null,"Total # cow grazing days/acre",{"$f":"SUM(C36*2000)/40.5","v":370.37037037037038},{"$f":"SUM(D36*2000)/40.5","v":44.444444444444443},{"$f":"SUM(E36*2000)/40.5","v":222.22222222222223},{"$f":"SUM(F36*2000)/40.5","v":11.358024691358025}]
[null,"Acres Req'd for Option",{"$f":"ROUND($C$5/C37,0)","v":14},{"$f":"ROUND($C$5/D37,0)","v":118},{"$f":"ROUND($C$5/E37,0)","v":24},{"$f":"ROUND($C$5/F37,0)","v":462}]
[]
["Total Extended Grazing Cost",null,{"$f":"SUM(C31*C38)","v":5963.3122499999999},{"$f":"SUM(D31*D38)","v":6248.2032500000005},{"$f":"SUM(E31*E38)","v":7102.8209999999999},{"$f":"SUM(F31*F38)","v":4828.3042500000001}]
["Cost per cow",null,{"$f":"SUM(C40/Input!$E$13)","v":39.755414999999999},{"$f":"SUM(D40/Input!$E$13)","v":41.65468833333334},{"$f":"SUM(E40/Input!$E$13)","v":47.352139999999999},{"$f":"SUM(F40/Input!$E$13)","v":32.188695000000003}]
[{"$f":"\"Cost/cow/day (based on \"&C3&\" days)\"","v":"Cost/cow/day (based on 35 days)"},null,{"$f":"C41/$C$3","v":1.135869},{"$f":"D41/$C$3","v":1.1901339523809527},{"$f":"E41/$C$3","v":1.3529182857142856},{"$f":"F41/$C$3","v":0.91967700000000008}]
[]
["Extended Grazing - Usage Planner"]
[]
[null,null,"Corn Grazing","Stockpiled Forage","Swath Grazing","Crop Residue","Total"]
[]
[]
["Planned extended grazing days",null,0,35,0,0,{"$f":"IF(C3=0,0,IF(SUM(C49:F49)<C3,\"ERROR\",IF(SUM(C49:F49)>C3,\"ERROR\",SUM(C49:F49))))","v":35}]
[null,{"$f":"ROUND(SUM(C50:F50),0)","v":118},{"$f":"SUM(C49/$C$3)*C38","v":0},{"$f":"SUM(D49/$C$3)*D38","v":118},0,0,{"$f":"IF(G49=\"ERROR\",\"(total must = \"&C3&\" days)\",\"\")","v":""}]
[]
[]
["Cost per cow",null,{"$f":"SUM(C42*C49)","v":0},{"$f":"SUM(D42*D49)","v":41.65468833333334},{"$f":"SUM(E42*E49)","v":0},{"$f":"SUM(F42*F49)","v":0},{"$f":"IF(C3=0,0,SUM(C53:F53))","v":41.65468833333334}]
[{"$f":"\"Cost/cow/day (based on \"&C3&\" days)\"","v":"Cost/cow/day (based on 35 days)"},null,null,null,null,null,{"$f":"IF(G53=0,0,SUM(G53/C3))","v":1.1901339523809527}]
[]
[]
["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":"Details","index":12,"n_rows":61,"n_cols":14,"rows_kept":61,"cut":false,"hidden":false,"merged":[[0,0,0,9],[50,0,50,9],[52,0,52,9],[56,0,58,9],[9,0,9,9],[41,0,41,9],[43,0,44,9],[45,0,47,9],[48,0,49,9],[27,0,27,9]]}
["Assumptions"]
[]
[{"$f":"\"1.  This budget outlines the cost of production for a cow-calf operation with \"&Input!E13&\" cows, \"&Input!E15&\" bulls and \"&Input!E17&\"% calf crop weaned.\"","v":"1.  This budget outlines the cost of production for a cow-calf operation with 150 cows, 5 bulls and 95% calf crop weaned."}]
["2.  Building and equipment are valued at new cost."]
["3.  Feed cost is a combined value of market price and on-farm production costs."]
["4.  Manure removal is contracted out."]
["5.  Replacement heifers are valued at fair market value."]
[{"$f":"\"6.  This budget assumes an average weaning weight of \"&Input!E23&\" lbs. (steer calves 600 lbs and heifer calves 550 lbs.)\"","v":"6.  This budget assumes an average weaning weight of 575 lbs. (steer calves 600 lbs and heifer calves 550 lbs.)"}]
[]
["Capital and Debt Summary:"]
["Capital Summary",null,null,"$/cow","Total",null,"Debt Summary",null,"$/cow","Total"]
["Breeding Herd Value",null,null,{"$f":"SUM(E12/Input!$E$13)","v":2766.6666666666665},{"$f":"(Input!E66*Input!E15)+(Input!E28*Input!E13)","v":415000},null,"Cows",null,{"$f":"(Fixed!D4*Fixed!D6)","v":390.00000000000006},{"$f":"I12*Input!E13","v":58500.000000000007}]
["Marginal Pasture Land",null,null,{"$f":"SUM(E13/Input!$E$13)","v":1600},{"$f":"Fixed!D16*Fixed!D17","v":240000},null,"Marginal Pasture Land",null,{"$f":"J13/Input!$E$13","v":400},{"$f":"SUM(Fixed!D16*Fixed!D19*Fixed!D17)","v":60000}]
["Improved Pasture Land",null,null,{"$f":"SUM(E14/Input!$E$13)","v":612},{"$f":"SUM(Fixed!D30*Fixed!D31)","v":91800},null,"Improved Pasture Land",null,{"$f":"J14/Input!E13","v":153},{"$f":"SUM(Fixed!D30*Fixed!D33*Fixed!D31)","v":22950}]
["Machinery & Equipment",null,null,{"$f":"SUM(E15/Input!$E$13)","v":1183.3333333333333},{"$f":"SUM(Fixed!J48:J63)","v":177500},null,"Machinery & Equipment",null,{"$f":"(Fixed!I4*Fixed!I8)","v":236.59999999999994},{"$f":"I15*Input!E13","v":35489.999999999993}]
["Fencing",null,null,{"$f":"Fixed!I32","v":208.39733333333334},{"$f":"SUM(D16*Input!E13)","v":31259.599999999999},null,"Fencing",null,{"$f":"Fixed!I32*Fixed!I36","v":52.099333333333334},{"$f":"I16*Input!E13","v":7814.9}]
["Buildings & Facilities",null,null,{"$f":"SUM(E17/Input!$E$13)","v":516.75},{"$f":"SUM(Fixed!E48:E63)","v":77512.5},null,"Buildings & Facilities",null,{"$f":"(Fixed!I18*Fixed!I22)","v":77.550000000000011},{"$f":"I17*Input!E13","v":11632.500000000002}]
["Hay Land",null,null,{"$f":"SUM(E18/Input!$E$13)","v":0},0,null,"Hay Land",null,{"$f":"J18/Input!$E$13","v":0},0,null,null,null,"**just pondering this idea for a total debt per cowwith all in??"]
["Silage Land",null,null,{"$f":"SUM(E19/Input!$E$13)","v":0},0,null,"Silage Land",null,{"$f":"J19/Input!$E$13","v":0},0]
["Forage Equipment",null,null,{"$f":"SUM(E20/Input!$E$13)","v":0},0,null,"Forage Equipment",null,{"$f":"J20/Input!$E$13","v":0},0]
["Grain Land",null,null,{"$f":"SUM(E21/Input!$E$13)","v":0},0,null,"Grain Land",null,{"$f":"J21/Input!$E$13","v":0},0]
["Grain Machinery & Equipment",null,null,{"$f":"SUM(E22/Input!$E$13)","v":0},0,null,"Grain Machinery & Equipment",null,{"$f":"J22/Input!$E$13","v":0},0]
["Total Capital Investment",null,null,{"$f":"SUM(D12:D17)","v":6887.1473333333324},{"$f":"SUM(E12:E17)","v":1033072.1},null,"Total Debt",null,{"$f":"SUM(I12:I17)","v":1309.2493333333332},{"$f":"SUM(J12:J17)","v":196387.4}]
[]
[null,null,null,null,null,null,{"$f":"\"Debt/EBITDAR ratio = \"&ROUND(I23/'Summary (2)'!F38,2)&\":1\"","v":"Debt/EBITDAR ratio = 1.71:1"}]
[null,null,null,null,null,null,"Cow Calf Equity",null,{"$f":"SUM(E23-J23)/E23","v":0.8098996188165376}]
[]
["Land Use Efficiency and Feed Security Analysis:"]
[null,null,null,null,null,null,null,null,"Acres/cow","Total  Acres"]
[null,"Pasture (Marginal, Improved, Crown Land and Rented Pasture)",null,null,null,null,{"$f":"Pasture!G3","v":135},"Days",{"$f":"J30/Input!$E$13","v":4.34},{"$f":"Pasture!E116+Pasture!F116+Pasture!G116+Pasture!I116","v":651}]
[null,"Extended Grazing (Corn, Stockpiled, Swath and Crop Residue)",null,null,null,null,{"$f":"Pasture!G4","v":35},"Days",{"$f":"J31/Input!$E$13","v":0.78666666666666663},{"$f":"'Extended Grazing'!C50+'Extended Grazing'!D50+'Extended Grazing'!E50+'Extended Grazing'!F50","v":118}]
[null,"Planned forage & feed waste amount ",null,null,0.1,1500,"pound bales"]
[null,"Alfalfa Hay",null,{"$f":"(('Winter Feed Rations'!N12+'Winter Feed Rations'!N33+(('Winter Feed Rations'!N12+'Winter Feed Rations'!N33)*$E$32))*Input!$E$13)/2000","v":0},"Total Tons @",3.5,{"$f":"\"tons/acre (\"&TEXT((F33*2000)/$F$32,\"#.#\")&\" bales/ac)\"","v":"tons/acre (4.7 bales/ac)"},null,{"$f":"J33/Input!$E$13","v":0},{"$f":"IF(F33=0,0,SUM(D33/F33))","v":0}]
[null,"Alfalfa Grass Hay",null,{"$f":"(('Winter Feed Rations'!N13+'Winter Feed Rations'!N34+(('Winter Feed Rations'!N13+'Winter Feed Rations'!N34)*$E$32))*Input!$E$13)/2000","v":585.9120535714286},"Total Tons @",2.79,{"$f":"\"tons/acre (\"&TEXT((F34*2000)/$F$32,\"#.#\")&\" bales/ac)\"","v":"tons/acre (3.7 bales/ac)"},null,{"$f":"J34/Input!$E$13","v":1.400028801843318},{"$f":"IF(F34=0,0,SUM(D34/F34))","v":210.00432027649771}]
[null,"Grass Hay",null,{"$f":"(('Winter Feed Rations'!N14+'Winter Feed Rations'!N35+(('Winter Feed Rations'!N14+'Winter Feed Rations'!N35)*$E$32))*Input!$E$13)/2000","v":0},"Total Tons @",2,"tons/acre (2.7 bales/ac)",null,{"$f":"J35/Input!$E$13","v":0},0]
[null,"Barley Greenfeed",null,{"$f":"(('Winter Feed Rations'!N16+'Winter Feed Rations'!N37+(('Winter Feed Rations'!N16+'Winter Feed Rations'!N37)*$E$32))*Input!$E$13)/2000","v":0},"Total Tons @",2.83,"tons/acre (3.8 bales/ac)",null,{"$f":"J36/Input!$E$13","v":0},0]
[null,"Corn Silage",null,{"$f":"(('Winter Feed Rations'!N17+'Winter Feed Rations'!N38+(('Winter Feed Rations'!N17+'Winter Feed Rations'!N38)*$E$32))*Input!$E$13)/2000","v":0},"Total Tons @",15,"tons/acre",null,{"$f":"J37/Input!$E$13","v":0},0]
[null,"Barley Silage",null,{"$f":"(('Winter Feed Rations'!N18+'Winter Feed Rations'!N39+(('Winter Feed Rations'!N18+'Winter Feed Rations'!N39)*$E$32))*Input!$E$13)/2000","v":0},"Total Tons @",7.5,"tons/acre",null,{"$f":"J38/Input!$E$13","v":0},0]
[null,"Barley Grain",null,{"$f":"(('Winter Feed Rations'!N19+'Winter Feed Rations'!N40+(('Winter Feed Rations'!N19+'Winter Feed Rations'!N40)*$E$32))*Input!$E$13)/48","v":994.41964285714278},"Total bu @",78,"bu/acre",null,{"$f":"J39/Input!$E$13","v":8.4993131868131858E-2},12.748969780219779]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I30:I39)","v":6.611688600378117},{"$f":"SUM(J30:J39)","v":991.75329005671756}]
[]
["Profitability and Breakeven Analysis:"]
[{"$f":"\"Gross Revenue =  calf weight (lbs) x $/lb x % calf crop (eg. \"&Input!E23&\" x $\"&TEXT(Input!E24/100,\"0.00\")&\"/lb x \"&Input!E17&\"% = $\"&TEXT(Summary!F46,\"0.00\")&\")\"","v":"Gross Revenue =  calf weight (lbs) x $/lb x % calf crop (eg. 575 x $3.66/lb x 95% = $1997.36)"}]
[{"$f":"\"Return on Investment (ROI) = (Gross Revenue - Total Cost) / Total Cost\n(eg. ($\"&TEXT(Summary!F46,\"0,000.00\")&\" - $\"&TEXT(Summary!F40,\"0,000.00\")&\") / $\"&TEXT(Summary!F40,\"0.00\")&\" = \"&TEXT(100*Summary!F71,\"0.0\")&\"%\"","v":"Return on Investment (ROI) = (Gross Revenue - Total Cost) / Total Cost\n(eg. ($1,997.36 - $1,643.57) / $1643.57 = 21.5%"}]
[]
[{"$f":"\"Return on Asset (ROA) = (Margin Over Operating - Owners Labour - Building Depreciation - Machinery Depreciation - Fence Depreciation) / ((Building, Machinery & Equipment Investment + Pasture Investment + Breeding Herd Investment) / Herd Size) (eg. ($\"&TEXT(Summary!F52,\"0.00\")&\" - $\"&TEXT(Summary!F38,\"0.00\")&\" - $\"&TEXT(Fixed!I27,\"0.00\")&\" - $\"&TEXT(Fixed!I13,\"0.00\")&\" - $\"&TEXT(Fixed!I41,\"0.00\")&\") / (($\"&TEXT(Details!E17+Details!E16+Details!E15,\"#,###\")&\" + $\"&TEXT(E13+E14,\"#,###\")&\" + $\"&TEXT(E12,\"#,###\")&\") / \"&Input!E13&\") = \"&TEXT(100*Summary!F72,\"0.0\")&\"%\"","v":"Return on Asset (ROA) = (Margin Over Operating - Owners Labour - Building Depreciation - Machinery Depreciation - Fence Depreciation) / ((Building, Machinery & Equipment Investment + Pasture Investment + Breeding Herd Investment) / Herd Size) (eg. ($880.18 - $216.00 - $20.68 - $94.64 - $9.38) / (($286,272 + $331,800 + $415,000) / 150) = 7.8%"}]
[]
[]
[{"$f":"\"Operating Expense Ratio =  (operating  cost ÷ gross revenue) x 100 \n(eg. ($\"&TEXT(Summary!F29, \"0.00\")&\" ÷ $\"&TEXT(Summary!F46,\"0.00\")&\" ) x 100 = \"&ROUND(Summary!F48*100,0)&\"%)\"","v":"Operating Expense Ratio =  (operating  cost ÷ gross revenue) x 100 \n(eg. ($1117.19 ÷ $1997.36 ) x 100 = 56%)"}]
[]
[{"$f":"\"Breakeven Price $/cwt = Cost ÷ % calf crop ÷ calf weight cwt (eg. $\"&TEXT(Summary!F40,\"0.00\")&\" ÷ \"&Input!E17&\"% ÷  \"&Input!E23/100&\" = $\"&ROUND(Summary!F60,0)&\")\"","v":"Breakeven Price $/cwt = Cost ÷ % calf crop ÷ calf weight cwt (eg. $1643.57 ÷ 95% ÷  5.75 = $301)"}]
[]
["Cost Summary:"]
[{"$f":"\"Summer Grazing Cost Per Cow Per Day =  pasture cost ÷ days (eg. $\"&TEXT(Pasture!J124, \"0.00\")&\" ÷ \"&Pasture!G3&\" = $\"&TEXT(Summary!F76,\"0.00\")&\")\"","v":"Summer Grazing Cost Per Cow Per Day =  pasture cost ÷ days (eg. $158.54 ÷ 135 = $1.17)"}]
[{"$f":"\"Extended Grazing Cost Per Cow Per Day =   grazing cost ÷ days (eg. $\"&TEXT('Extended Grazing'!G53, \"0.00\")&\" ÷ \"&Pasture!G4&\" = $\"&TEXT(Summary!F77,\"0.00\")&\")\"","v":"Extended Grazing Cost Per Cow Per Day =   grazing cost ÷ days (eg. $41.65 ÷ 35 = $1.19)"}]
[{"$f":"\"Winter Feed Cost Per Cow Per Day = feed cost ÷ days (eg. $\"&TEXT('Winter Feed Rations'!O54+((Input!G46+Input!G53)), \"0.00\")&\" ÷ \"&Pasture!G5&\" = $\"&TEXT(Summary!F78,\"0.00\")&\")\"","v":"Winter Feed Cost Per Cow Per Day = feed cost ÷ days (eg. $479.82 ÷ 195 = $2.46)"}]
[{"$f":"\"Yardage Cost Per Cow Per Day =  ($\"&TEXT('Operating '!D25*'Operating '!D26+Input!G59,\"0.00\")&\" straw + $\"&TEXT('Operating '!G48,\"0.00\")&\" fuel & repair + $\"&TEXT('Operating '!G118,\"0.00\")&\" building insurance + $\"&TEXT('Operating '!G59,\"0.00\")&\" utilities + $\"&TEXT('Operating '!G108,\"0.00\")&\" manure removal + $\"&TEXT(Fixed!I27,\"0.00\")&\" building depreciation+ $\"&TEXT(Fixed!I13,\"0.00\")&\" machinery depreciation + $\"&TEXT(Fixed!I26,\"0.00\")&\" building investment + $\"&TEXT(Fixed!I12,\"0.00\")&\" machinery investment + $\"&TEXT((((Summary!H27-Summary!H14-Summary!H15-Summary!H18-Summary!H19-Summary!H22-Summary!H23)/2*('Operating '!E131/100)/(Input!E13))),\"0.00\")&\" operating interest + $\"&TEXT(((Summary!H26*((Pasture!G5+Pasture!G4)/365))/Input!E13),\"0.00\")&\" misc. + $\"&TEXT(('Operating '!G138)*0.625,\"0.00\")&\" labour) ÷ \"&Pasture!G5+Pasture!G4&\" days = $\"&TEXT(Summary!F79,\"0.000\")","v":"Yardage Cost Per Cow Per Day =  ($72.33 straw + $42.72 fuel & repair + $6.80 building insurance + $11.69 utilities + $10.84 manure removal + $20.68 building depreciation+ $94.64 machinery depreciation + $14.39 building investment + $43.90 machinery investment + $26.99 operating interest + $4.21 misc. + $135.00 labour) ÷ 230 days = $2.099"}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"September, 2024"]

{"sheet":"Housing","index":13,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,0,1,8]]}
[]
["Cow-Calf Operating Facilities"]

{"sheet":"Chart data (HIDE)","index":14,"n_rows":309,"n_cols":19,"rows_kept":309,"cut":false,"hidden":true,"merged":[[28,11,28,17],[48,12,50,17],[127,10,129,15]]}
[{"$f":"Input!E13&\" Head Beef Cow Calf - Total Production Costs ($/cow)\"","v":"150 Head Beef Cow Calf - Total Production Costs ($/cow)"},null,null,null,null,"150 Cow COP Changes",null,null,null,null,null,"Year","Million Head","$/cwt",{"$f":"\"$/cwt (\"&SUM(Input!E75/2)&\"% Inflation)\"","v":"$/cwt (2% Inflation)"}]
["Feed Cost",{"$f":"Summary!F10","v":524.22485878787882},{"$f":"SUM(B2/$B$9)","v":0.31895573548622747},null,null,"Input - 150 cows",null,null,null,null,1,2019,93,{"$f":"Input!E24","v":365.65},{"$f":"N2","v":365.65}]
["Other Operating Cost",{"$f":"Summary!F29-Summary!F10","v":592.96101600797886},0.36077708602524333,null,null,"Input - 5 bulls",null,null,null,null,2,2020,94,187,{"$f":"SUM((N3-N2)+O2)*(1+(Input!$E$75/100)/2)","v":190.74}]
["Fixed Cost - Livestock",{"$f":"Summary!F32","v":72.365755656152146},4.4029718225675113E-2,null,null,"Operating - 6 hours vet",null,null,null,null,3,2021,93.5,185,{"$f":"SUM((N4-N3)+O3)*(1+(Input!$E$75/100)/2)","v":192.51480000000001}]
["Fixed Cost - Buildings",{"$f":"Summary!F33","v":35.06965218239641},2.1337535825649526E-2,null,null,"Operating - 1.5 hours tractor time",null,null,null,null,4,2022,92,187,{"$f":"SUM((N5-N4)+O4)*(1+(Input!$E$75/100)/2)","v":198.40509600000001}]
["Fixed Cost - Machinery",{"$f":"Summary!F34","v":138.54189176473227},8.4293467283576354E-2,null,null,"Operating - 0 hrs hired, 8 hours owner",null,null,null,null,5,2023,91,192,{"$f":"SUM((N6-N5)+O5)*(1+(Input!$E$75/100)/2)","v":207.47319792000002}]
["Fixed Cost - Pasture Land & Fencing",{"$f":"Summary!F35","v":64.403002546173056},3.9184915976958577E-2,null,null,"Pasture - cow number allocation",null,null,null,null,6,2024,90,197,{"$f":"SUM((N7-N6)+O6)*(1+(Input!$E$75/100)/2)","v":216.72266187840003}]
["Owners-Labour & Living",{"$f":"Summary!F38","v":216},0.13142154117666979,null,null,"Winter Feed - 135 days to ration#1, pre and post",null,null,null,null,7,2025,89,206,{"$f":"SUM((N8-N7)+O7)*(1+(Input!$E$75/100)/2)","v":230.23711511596804}]
[null,{"$f":"SUM(B2:B8)","v":1643.5661769453113},null,null,null,"Fixed - remove tractor and silage wagon cost ($0)",null,null,null,null,8,2026,87,210,{"$f":"SUM((N9-N8)+O8)*(1+(Input!$E$75/100)/2)","v":238.9218574182874}]
[null,null,null,null,null,"Fixed - reduce tractor cost to $120,000",null,null,null,null,9,2027,87.5,207,{"$f":"SUM((N10-N9)+O9)*(1+(Input!$E$75/100)/2)","v":240.64029456665315}]
[null,null,null,null,null,null,null,null,null,null,10,2028,88,202,{"$f":"SUM((N11-N10)+O10)*(1+(Input!$E$75/100)/2)","v":240.35310045798622}]
[]
[]
[{"$f":"Input!E13&\" Head Beef Cow Calf - Other Operating Costs ($/cow)\"","v":"150 Head Beef Cow Calf - Other Operating Costs ($/cow)"}]
[]
["Straw",{"$f":"Summary!F13","v":70}]
["Veterinary Medicine & Supplies",{"$f":"Summary!F14","v":30.676666666666662}]
["Breeding Costs",{"$f":"Summary!F15","v":46.42},null,null,null,null,null,null,null,null,"From the meeting"]
["Fuel, Maintenance & Repairs",{"$f":"Summary!F16","v":42.717300000000002},null,null,null,null,null,null,null,null,"years","calf prices from meeting","cull","diff","%"]
["Utilities",{"$f":"Summary!F17","v":11.688774},null,null,null,null,null,null,null,null,1,180.43,80,{"$f":"SUM(L20-M20)","v":100.43},{"$f":"SUM(M20/L20)","v":0.44338524635592746}]
["Marketing & Transportation",{"$f":"Summary!F18","v":39.598333333333329},null,null,null,null,null,null,null,null,2,170,80,{"$f":"SUM(L21-M21)","v":90},{"$f":"SUM(M21/L21)","v":0.47058823529411764}]
["Death Loss",{"$f":"Summary!F19","v":32.5},null,null,null,null,null,null,null,null,3,175,85,90,0.48571428571428571]
["Manure Removal",{"$f":"Summary!F20","v":10.839635625},null,null,null,null,null,null,null,null,4,175,85,90,0.48571428571428571]
["Insurance",{"$f":"Summary!F21","v":18.829999999999998},null,null,null,null,null,null,null,null,5,175,90,85,0.51428571428571423]
["Herd Replacement",{"$f":"Summary!F22","v":148.5},null,null,null,null,null,null,null,null,6,180,95,85,0.52777777777777779]
["Pasture Rental",{"$f":"Summary!F23","v":59.375},null,null,null,null,null,null,null,null,7,190,95,95,0.5]
["Pasture Operating",{"$f":"Summary!F24","v":34.765106382978729},null,null,null,null,null,null,null,null,8,200,100,100,0.5]
["Labour - Hired",{"$f":"Summary!F25","v":0}]
["Miscellaneous",{"$f":"Summary!F26","v":6.67},null,null,null,null,null,null,null,null,"calves","Year 2 to 8 prices",null,null,null,null,null,null,"AVG"]
["Operating Interest",{"$f":"Summary!F28","v":40.380200000000002},null,null,null,null,null,null,null,null,"trend",{"$f":"N3","v":187},{"$f":"N4","v":185},{"$f":"N5","v":187},{"$f":"N6","v":192},{"$f":"N7","v":197},{"$f":"N8","v":206},{"$f":"N9","v":210},{"$f":"AVERAGE(L30:R30)","v":194.85714285714286}]
[null,{"$f":"SUM(B16:B30)","v":592.96101600797851},null,null,null,null,null,null,null,null,"with inflation",{"$f":"ROUND($O3,0)","v":191},{"$f":"ROUND($O4,0)","v":193},{"$f":"ROUND($O5,0)","v":198},{"$f":"ROUND($O6,0)","v":207},{"$f":"ROUND($O7,0)","v":217},{"$f":"ROUND($O8,0)","v":230},{"$f":"ROUND($O9,0)","v":239},{"$f":"AVERAGE(L31:R31)","v":210.71428571428572}]
[]
[null,null,null,null,null,null,null,null,null,null,"culls",100,"($/cwt discount from average calf prices)"]
[null,null,null,null,null,null,null,null,null,null,"trend",{"$f":"SUM(L30-L33)","v":87},{"$f":"SUM(M30-L33)","v":85},{"$f":"SUM(N30-L33)","v":87},{"$f":"SUM(O30-L33)","v":92},{"$f":"SUM(P30-L33)","v":97},{"$f":"SUM(Q30-L33)","v":106},{"$f":"SUM(R30-L33)","v":110},{"$f":"AVERAGE(L34:R34)","v":94.857142857142861}]
[{"$f":"Input!E13&\" Head Beef Cow Calf - Cost Summary ($/cow/day)\"","v":"150 Head Beef Cow Calf - Cost Summary ($/cow/day)"},null,null,null,null,null,null,null,null,null,"with inflation",{"$f":"SUM(L31-L33)","v":91},{"$f":"SUM(M31-L33)","v":93},{"$f":"SUM(N31-L33)","v":98},{"$f":"SUM(O31-L33)","v":107},{"$f":"SUM(P31-L33)","v":117},{"$f":"SUM(Q31-L33)","v":130},{"$f":"SUM(R31-L33)","v":139},{"$f":"AVERAGE(L35:R35)","v":110.71428571428571}]
[{"$f":"\"Grazing (\"&Pasture!G3&\" days)\"","v":"Grazing (135 days)"},{"$f":"Summary!F76","v":1.1743933994751985}]
[{"$f":"\"Extended grazing (\"&Pasture!G4&\" days)\"","v":"Extended grazing (35 days)"},{"$f":"Summary!F77","v":1.1901339523809527},null,null,null,null,null,null,null,null,"culls",0.55000000000000004,"($/cwt percentage of average calf prices)"]
[{"$f":"\"Yardage (based on \"&Pasture!G5+Pasture!G4&\" days)\"","v":"Yardage (based on 230 days)"},{"$f":"Summary!F79","v":2.0994562934286281},null,null,null,null,null,null,null,null,"trend",{"$f":"SUM(L30*$L$37)","v":102.85000000000001},101.75000000000001,102.85000000000001,105.60000000000001,108.35000000000001,113.30000000000001,115.50000000000001,{"$f":"AVERAGE(L38:R38)","v":107.17142857142858}]
[{"$f":"\"Winter feed (\"&Pasture!G5&\" days)\"","v":"Winter feed (195 days)"},{"$f":"Summary!F78","v":2.4606209207459209},null,null,null,null,null,null,null,null,"with inflation",105.05000000000001,106.15,108.9,113.85000000000001,119.35000000000001,126.50000000000001,131.45000000000002,{"$f":"AVERAGE(L39:R39)","v":115.89285714285715}]
[{"$f":"\"Total Overwinter Costs (\"&Pasture!G5+Pasture!G4&\" days)\"","v":"Total Overwinter Costs (230 days)"},{"$f":"Summary!F80","v":4.3667422407277057}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Feed",355,{"$f":"SUM(L43*(1+(Input!$E$75/100)/2))","v":362.1},{"$f":"SUM(M43*(1+(Input!$E$75/100)/2))","v":369.34200000000004},{"$f":"SUM(N43*(1+(Input!$E$75/100)/2))","v":376.72884000000005},{"$f":"SUM(O43*(1+(Input!$E$75/100)/2))","v":384.26341680000007},{"$f":"SUM(P43*(1+(Input!$E$75/100)/2))","v":391.94868513600011},{"$f":"SUM(Q43*(1+(Input!$E$75/100)/2))","v":399.78765883872012},{"$f":"AVERAGE(L43:R43)","v":377.02437153924581}]
[]
[]
[{"$f":"Input!E13&\" Head Beef Cow Calf - Costs Not Covered (\"&Input!E23&\" lb. avg. steers & heifers)\"","v":"150 Head Beef Cow Calf - Costs Not Covered (575 lb. avg. steers & heifers)"}]
["Calf Price","Gross revenue",{"$f":"\"Operating Costs = $\"&ROUND(Summary!F29,0)","v":"Operating Costs = $1117"},{"$f":"\"Fixed Costs = $\"&ROUND(Summary!F36,0)","v":"Fixed Costs = $310"},{"$f":"\"Labour (Owners Living) Cost = $\"&ROUND(Summary!F38,0)","v":"Labour (Owners Living) Cost = $216"},"Total",null,null,{"$f":"C47","v":"Operating Costs = $1117"},{"$f":"D47","v":"Fixed Costs = $310"},{"$f":"A47","v":"Calf Price"}]
[]
[{"$f":"SUM(A50+$A$62)","v":370},{"$f":"SUM((A49/100)*Input!$E$23)*(Input!$E$17/100)","v":2021.125},{"$f":"IF(Summary!$F$29-B49<0,0,SUM(Summary!$F$29-B49))","v":0},{"$f":"IF(Summary!$F$29+Summary!$F$36-B49<0,0,SUM(Summary!$F$29+Summary!$F$36-B49-C49))","v":0},{"$f":"IF(Summary!$F$29+Summary!$F$36+Summary!$F$38-B49<0,0,SUM(Summary!$F$29+Summary!$F$36+Summary!$F$38-B49-C49-D49))","v":0},{"$f":"SUM(C49:E49)","v":0},null,null,{"$f":"C49","v":0},{"$f":"D49","v":0},{"$f":"A49","v":370},null,{"$f":"\"Market prices of $\"&ROUND(Summary!F59,0)&\"/cwt and lower do not cover both operating and fixed costs.  This can indicate the potential need for LPI coverage and is an important step in Risk Management Planning.\"","v":"Market prices of $261/cwt and lower do not cover both operating and fixed costs.  This can indicate the potential need for LPI coverage and is an important step in Risk Management Planning."}]
[358,{"$f":"SUM((A50/100)*Input!$E$23)*(Input!$E$17/100)","v":1955.5749999999998},{"$f":"IF(Summary!$F$29-B50<0,0,SUM(Summary!$F$29-B50))","v":0},{"$f":"IF(Summary!$F$29+Summary!$F$36-B50<0,0,SUM(Summary!$F$29+Summary!$F$36-B50-C50))","v":0},{"$f":"IF(Summary!$F$29+Summary!$F$36+Summary!$F$38-B50<0,0,SUM(Summary!$F$29+Summary!$F$36+Summary!$F$38-B50-C50-D50))","v":0},0,null,null,0,0,358]
[{"$f":"ROUND(Input!E24+A63,0)","v":346},{"$f":"SUM((A51/100)*Input!$E$23)*(Input!$E$17/100)","v":1890.0249999999999},{"$f":"IF(Summary!$F$29-B51<0,0,SUM(Summary!$F$29-B51))","v":0},{"$f":"IF(Summary!$F$29+Summary!$F$36-B51<0,0,SUM(Summary!$F$29+Summary!$F$36-B51-C51))","v":0},{"$f":"IF(Summary!$F$29+Summary!$F$36+Summary!$F$38-B51<0,0,SUM(Summary!$F$29+Summary!$F$36+Summary!$F$38-B51-C51-D51))","v":0},0,null,null,0,0,346]
[{"$f":"SUM(A51-$A$62)","v":334},{"$f":"SUM((A52/100)*Input!$E$23)*(Input!$E$17/100)","v":1824.4749999999999},{"$f":"IF(Summary!$F$29-B52<0,0,SUM(Summary!$F$29-B52))","v":0},{"$f":"IF(Summary!$F$29+Summary!$F$36-B52<0,0,SUM(Summary!$F$29+Summary!$F$36-B52-C52))","v":0},{"$f":"IF(Summary!$F$29+Summary!$F$36+Summary!$F$38-B52<0,0,SUM(Summary!$F$29+Summary!$F$36+Summary!$F$38-B52-C52-D52))","v":0},0,null,null,0,0,334]
[{"$f":"SUM(A52-$A$62)","v":322},{"$f":"SUM((A53/100)*Input!$E$23)*(Input!$E$17/100)","v":1758.925},{"$f":"IF(Summary!$F$29-B53<0,0,SUM(Summary!$F$29-B53))","v":0},{"$f":"IF(Summary!$F$29+Summary!$F$36-B53<0,0,SUM(Summary!$F$29+Summary!$F$36-B53-C53))","v":0},{"$f":"IF(Summary!$F$29+Summary!$F$36+Summary!$F$38-B53<0,0,SUM(Summary!$F$29+Summary!$F$36+Summary!$F$38-B53-C53-D53))","v":0},0,null,null,0,0,322]
[{"$f":"SUM(A53-$A$62)","v":310},{"$f":"SUM((A54/100)*Input!$E$23)*(Input!$E$17/100)","v":1693.375},{"$f":"IF(Summary!$F$29-B54<0,0,SUM(Summary!$F$29-B54))","v":0},{"$f":"IF(Summary!$F$29+Summary!$F$36-B54<0,0,SUM(Summary!$F$29+Summary!$F$36-B54-C54))","v":0},{"$f":"IF(Summary!$F$29+Summary!$F$36+Summary!$F$38-B54<0,0,SUM(Summary!$F$29+Summary!$F$36+Summary!$F$38-B54-C54-D54))","v":0},0,null,null,0,0,310]
[298,{"$f":"SUM((A55/100)*Input!$E$23)*(Input!$E$17/100)","v":1627.8249999999998},{"$f":"IF(Summary!$F$29-B55<0,0,SUM(Summary!$F$29-B55))","v":0},{"$f":"IF(Summary!$F$29+Summary!$F$36-B55<0,0,SUM(Summary!$F$29+Summary!$F$36-B55-C55))","v":0},{"$f":"IF(Summary!$F$29+Summary!$F$36+Summary!$F$38-B55<0,0,SUM(Summary!$F$29+Summary!$F$36+Summary!$F$38-B55-C55-D55))","v":15.741176945311736},15.741176945311736,null,null,0,0,298]
[286,{"$f":"SUM((A56/100)*Input!$E$23)*(Input!$E$17/100)","v":1562.2749999999999},{"$f":"IF(Summary!$F$29-B56<0,0,SUM(Summary!$F$29-B56))","v":0},{"$f":"IF(Summary!$F$29+Summary!$F$36-B56<0,0,SUM(Summary!$F$29+Summary!$F$36-B56-C56))","v":0},{"$f":"IF(Summary!$F$29+Summary!$F$36+Summary!$F$38-B56<0,0,SUM(Summary!$F$29+Summary!$F$36+Summary!$F$38-B56-C56-D56))","v":81.29117694531169},81.29117694531169,null,null,0,0,286]
[274,{"$f":"SUM((A57/100)*Input!$E$23)*(Input!$E$17/100)","v":1496.7250000000001},{"$f":"IF(Summary!$F$29-B57<0,0,SUM(Summary!$F$29-B57))","v":0},{"$f":"IF(Summary!$F$29+Summary!$F$36-B57<0,0,SUM(Summary!$F$29+Summary!$F$36-B57-C57))","v":0},{"$f":"IF(Summary!$F$29+Summary!$F$36+Summary!$F$38-B57<0,0,SUM(Summary!$F$29+Summary!$F$36+Summary!$F$38-B57-C57-D57))","v":146.84117694531142},146.84117694531142,null,null,0,0,274]
[262,{"$f":"SUM((A58/100)*Input!$E$23)*(Input!$E$17/100)","v":1431.175},{"$f":"IF(Summary!$F$29-B58<0,0,SUM(Summary!$F$29-B58))","v":0},{"$f":"IF(Summary!$F$29+Summary!$F$36-B58<0,0,SUM(Summary!$F$29+Summary!$F$36-B58-C58))","v":0},{"$f":"IF(Summary!$F$29+Summary!$F$36+Summary!$F$38-B58<0,0,SUM(Summary!$F$29+Summary!$F$36+Summary!$F$38-B58-C58-D58))","v":212.3911769453116},212.3911769453116,null,null,0,0,262]
[250,{"$f":"SUM((A59/100)*Input!$E$23)*(Input!$E$17/100)","v":1365.625},{"$f":"IF(Summary!$F$29-B59<0,0,SUM(Summary!$F$29-B59))","v":0},{"$f":"IF(Summary!$F$29+Summary!$F$36-B59<0,0,SUM(Summary!$F$29+Summary!$F$36-B59-C59))","v":61.941176945311554},{"$f":"IF(Summary!$F$29+Summary!$F$36+Summary!$F$38-B59<0,0,SUM(Summary!$F$29+Summary!$F$36+Summary!$F$38-B59-C59-D59))","v":216},277.94117694531155,null,null,0,61.941176945311554,250]
[238,{"$f":"SUM((A60/100)*Input!$E$23)*(Input!$E$17/100)","v":1300.075},{"$f":"IF(Summary!$F$29-B60<0,0,SUM(Summary!$F$29-B60))","v":0},{"$f":"IF(Summary!$F$29+Summary!$F$36-B60<0,0,SUM(Summary!$F$29+Summary!$F$36-B60-C60))","v":127.49117694531151},{"$f":"IF(Summary!$F$29+Summary!$F$36+Summary!$F$38-B60<0,0,SUM(Summary!$F$29+Summary!$F$36+Summary!$F$38-B60-C60-D60))","v":216},343.49117694531151,null,null,0,127.49117694531151,238]
[]
[12,"price change"]
[-20,"initial mod."]
[]
[]
[]
[]
[{"$f":"\"2021 Beef Cow Calf - Risk & Reward (\"&Input!E23&\" lb. avg. steers & heifers)\"","v":"2021 Beef Cow Calf - Risk & Reward (575 lb. avg. steers & heifers)"}]
["Calf Price","Gross revenue","Operating Cost","Fixed Cost","Labour","Margin Over Operating & Fixed Cost"]
[]
[{"$f":"SUM(A72-5)","v":346},{"$f":"SUM((A71/100)*Input!$E$23)*(Input!$E$17/100)","v":1890.0249999999999},{"$f":"Summary!$F$29","v":1117.1858747958577},{"$f":"Summary!$F$36","v":310.38030214945388},{"$f":"Summary!$F$38","v":216},{"$f":"SUM(B71-(C71+D71))","v":462.45882305468831}]
[{"$f":"SUM(A73-5)","v":351},{"$f":"SUM((A72/100)*Input!$E$23)*(Input!$E$17/100)","v":1917.3374999999996},{"$f":"Summary!$F$29","v":1117.1858747958577},{"$f":"Summary!$F$36","v":310.38030214945388},{"$f":"Summary!$F$38","v":216},{"$f":"SUM(B72-(C72+D72))","v":489.77132305468808}]
[{"$f":"SUM(A74-5)","v":356},{"$f":"SUM((A73/100)*Input!$E$23)*(Input!$E$17/100)","v":1944.6499999999999},{"$f":"Summary!$F$29","v":1117.1858747958577},{"$f":"Summary!$F$36","v":310.38030214945388},{"$f":"Summary!$F$38","v":216},517.08382305468831]
[{"$f":"SUM(A75-5)","v":361},{"$f":"SUM((A74/100)*Input!$E$23)*(Input!$E$17/100)","v":1971.9624999999999},{"$f":"Summary!$F$29","v":1117.1858747958577},{"$f":"Summary!$F$36","v":310.38030214945388},{"$f":"Summary!$F$38","v":216},544.39632305468831]
[{"$f":"ROUND(Input!E24,0)","v":366},{"$f":"SUM((A75/100)*Input!$E$23)*(Input!$E$17/100)","v":1999.2749999999999},{"$f":"Summary!$F$29","v":1117.1858747958577},{"$f":"Summary!$F$36","v":310.38030214945388},{"$f":"Summary!$F$38","v":216},571.70882305468831]
[{"$f":"SUM(A75+5)","v":371},{"$f":"SUM((A76/100)*Input!$E$23)*(Input!$E$17/100)","v":2026.5874999999999},{"$f":"Summary!$F$29","v":1117.1858747958577},{"$f":"Summary!$F$36","v":310.38030214945388},{"$f":"Summary!$F$38","v":216},599.02132305468831]
[376,{"$f":"SUM((A77/100)*Input!$E$23)*(Input!$E$17/100)","v":2053.9},{"$f":"Summary!$F$29","v":1117.1858747958577},{"$f":"Summary!$F$36","v":310.38030214945388},{"$f":"Summary!$F$38","v":216},626.33382305468854]
[381,{"$f":"SUM((A78/100)*Input!$E$23)*(Input!$E$17/100)","v":2081.2125000000001},{"$f":"Summary!$F$29","v":1117.1858747958577},{"$f":"Summary!$F$36","v":310.38030214945388},{"$f":"Summary!$F$38","v":216},653.64632305468854]
[386,{"$f":"SUM((A79/100)*Input!$E$23)*(Input!$E$17/100)","v":2108.5250000000001},{"$f":"Summary!$F$29","v":1117.1858747958577},{"$f":"Summary!$F$36","v":310.38030214945388},{"$f":"Summary!$F$38","v":216},680.95882305468854]
[391,{"$f":"SUM((A80/100)*Input!$E$23)*(Input!$E$17/100)","v":2135.8375000000001},{"$f":"Summary!$F$29","v":1117.1858747958577},{"$f":"Summary!$F$36","v":310.38030214945388},{"$f":"Summary!$F$38","v":216},708.27132305468854]
[396,{"$f":"SUM((A81/100)*Input!$E$23)*(Input!$E$17/100)","v":2163.15},{"$f":"Summary!$F$29","v":1117.1858747958577},{"$f":"Summary!$F$36","v":310.38030214945388},{"$f":"Summary!$F$38","v":216},735.58382305468854]
[401,{"$f":"SUM((A82/100)*Input!$E$23)*(Input!$E$17/100)","v":2190.4625000000001},{"$f":"Summary!$F$29","v":1117.1858747958577},{"$f":"Summary!$F$36","v":310.38030214945388},{"$f":"Summary!$F$38","v":216},762.89632305468854]
[]
[]
[]
[]
[{"$f":"Input!E13&\" Head Beef Cow Calf - Change to Profit Margin Over Operating & Fixed Costs\"","v":"150 Head Beef Cow Calf - Change to Profit Margin Over Operating & Fixed Costs"}]
[null,"Base Margin"]
[null,null,"Change"]
["Baseline",{"$f":"Summary!F53","v":569.79694805468807}]
[{"$f":"\"Cost\n(\"&'Risk Analysis'!$C$24*100&\"%)\"","v":"Cost\n(-5%)"},{"$f":"B90","v":569.79694805468807},{"$f":"'Risk Analysis'!H24","v":55.859293739792975}]
[{"$f":"\"Production\n(\"&'Risk Analysis'!$C$26*100&\"% Weaning Weight)\"","v":"Production\n(5% Weaning Weight)"},{"$f":"B90","v":569.79694805468807},{"$f":"'Risk Analysis'!H26","v":105.124375}]
[{"$f":"\"Price\n(\"&'Risk Analysis'!$C$25*100&\"% or $\"&TEXT(ROUND('Risk Analysis'!F25/100,2),\"0.00\")&\"/lb)\"","v":"Price\n(5% or $0.18/lb)"},{"$f":"B90","v":569.79694805468807},{"$f":"'Risk Analysis'!H25","v":105.12437500000016}]
["Cost & Production",{"$f":"B90","v":569.79694805468807},{"$f":"C91+C92","v":160.98366873979296}]
["Cost, Production & Price",{"$f":"B90","v":569.79694805468807},{"$f":"C91+C92+C93","v":266.10804373979312}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["2021 Beef Cow Calf - Cumulative, Multiplicative, Compounding Effects: Change to Margin Over Operating & Fixed Costs "]
[null,"Base Margin"]
[null,null,"Change",null,null,null,null,null,null,null,{"$f":"\"Market prices of $\"&ROUND(Summary!D138,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 $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)."}]
["Baseline",{"$f":"Summary!F53","v":569.79694805468807}]
[{"$f":"\"Cost\n (\"&'Risk Analysis'!$C$24*100&\"%)\"","v":"Cost\n (-5%)"},{"$f":"B129","v":569.79694805468807},{"$f":"'Risk Analysis'!H24","v":55.859293739792975}]
[{"$f":"\"Production\n (\"&'Risk Analysis'!$C$26*100&\"% Weaning Weight)\"","v":"Production\n (5% Weaning Weight)"},{"$f":"B129","v":569.79694805468807},{"$f":"'Risk Analysis'!H26","v":105.124375}]
[{"$f":"\"Production \n(\"&'Risk Analysis'!$C$27*100&\"% Calf Crop)\"","v":"Production \n(1% Calf Crop)"},{"$f":"B129","v":569.79694805468807},{"$f":"'Risk Analysis'!H27","v":21.024874999999998}]
[{"$f":"\"Price \n(\"&'Risk Analysis'!$C$25*100&\"% or $\"&TEXT(ROUND('Risk Analysis'!F25/100,2),\"0.00\")&\"/lb)\"","v":"Price \n(5% or $0.18/lb)"},{"$f":"B129","v":569.79694805468807},{"$f":"'Risk Analysis'!H25","v":105.12437500000016}]
["Cost & Production",{"$f":"B129","v":569.79694805468807},{"$f":"C130+C131+C132","v":182.00854373979297}]
["Cost, Production & Price",{"$f":"B129","v":569.79694805468807},{"$f":"C130+C131+C133+C132","v":287.13291873979313}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["equity",1,{"$f":"SUM(B174-0.05)","v":0.95},0.89999999999999991,0.84999999999999987,0.79999999999999982,0.74999999999999978,0.69999999999999973,0.64999999999999969,0.59999999999999964,0.5499999999999996,0.49999999999999961]
["financed",{"$f":"SUM(1-B174)","v":0},5.0000000000000044E-2,0.10000000000000009,0.15000000000000013,0.20000000000000018,0.25000000000000022,0.30000000000000027,0.35000000000000031,0.40000000000000036,0.4500000000000004,0.50000000000000044]
[]
[]
["Debt Summary","$/cow"]
["Cows",{"$f":"(Fixed!$D$4*B175)","v":0},{"$f":"(Fixed!$D$4*C175)","v":130.00000000000011},{"$f":"(Fixed!$D$4*D175)","v":260.00000000000023},{"$f":"(Fixed!$D$4*E175)","v":390.00000000000034},{"$f":"(Fixed!$D$4*F175)","v":520.00000000000045},{"$f":"(Fixed!$D$4*G175)","v":650.00000000000057},{"$f":"(Fixed!$D$4*H175)","v":780.00000000000068},{"$f":"(Fixed!$D$4*I175)","v":910.0000000000008},{"$f":"(Fixed!$D$4*J175)","v":1040.0000000000009},{"$f":"(Fixed!$D$4*K175)","v":1170.0000000000011},{"$f":"(Fixed!$D$4*L175)","v":1300.0000000000011}]
["Marginal Pasture Land",{"$f":"SUM(Fixed!$D$16*B175*Fixed!$D$17)/Input!$E$13","v":0},{"$f":"SUM(Fixed!$D$16*C175*Fixed!$D$17)/Input!$E$13","v":80.000000000000071},{"$f":"SUM(Fixed!$D$16*D175*Fixed!$D$17)/Input!$E$13","v":160.00000000000014},{"$f":"SUM(Fixed!$D$16*E175*Fixed!$D$17)/Input!$E$13","v":240.00000000000026},{"$f":"SUM(Fixed!$D$16*F175*Fixed!$D$17)/Input!$E$13","v":320.00000000000028},{"$f":"SUM(Fixed!$D$16*G175*Fixed!$D$17)/Input!$E$13","v":400.00000000000034},{"$f":"SUM(Fixed!$D$16*H175*Fixed!$D$17)/Input!$E$13","v":480.00000000000051},{"$f":"SUM(Fixed!$D$16*I175*Fixed!$D$17)/Input!$E$13","v":560.00000000000045},{"$f":"SUM(Fixed!$D$16*J175*Fixed!$D$17)/Input!$E$13","v":640.00000000000057},{"$f":"SUM(Fixed!$D$16*K175*Fixed!$D$17)/Input!$E$13","v":720.00000000000068},{"$f":"SUM(Fixed!$D$16*L175*Fixed!$D$17)/Input!$E$13","v":800.00000000000068}]
["Improved Pasture Land",{"$f":"SUM(Fixed!$D$30*B175*Fixed!$D$31)/Input!$E$13","v":0},{"$f":"SUM(Fixed!$D$30*C175*Fixed!$D$31)/Input!$E$13","v":30.60000000000003},{"$f":"SUM(Fixed!$D$30*D175*Fixed!$D$31)/Input!$E$13","v":61.20000000000006},{"$f":"SUM(Fixed!$D$30*E175*Fixed!$D$31)/Input!$E$13","v":91.800000000000068},{"$f":"SUM(Fixed!$D$30*F175*Fixed!$D$31)/Input!$E$13","v":122.40000000000012},{"$f":"SUM(Fixed!$D$30*G175*Fixed!$D$31)/Input!$E$13","v":153.00000000000014},{"$f":"SUM(Fixed!$D$30*H175*Fixed!$D$31)/Input!$E$13","v":183.60000000000014},{"$f":"SUM(Fixed!$D$30*I175*Fixed!$D$31)/Input!$E$13","v":214.20000000000019},{"$f":"SUM(Fixed!$D$30*J175*Fixed!$D$31)/Input!$E$13","v":244.80000000000024},{"$f":"SUM(Fixed!$D$30*K175*Fixed!$D$31)/Input!$E$13","v":275.40000000000026},{"$f":"SUM(Fixed!$D$30*L175*Fixed!$D$31)/Input!$E$13","v":306.00000000000028}]
["Machinery & Equipment",{"$f":"(Fixed!$I$4*B175)","v":0},{"$f":"(Fixed!$I$4*C175)","v":59.150000000000055},{"$f":"(Fixed!$I$4*D175)","v":118.30000000000011},{"$f":"(Fixed!$I$4*E175)","v":177.45000000000016},{"$f":"(Fixed!$I$4*F175)","v":236.60000000000022},{"$f":"(Fixed!$I$4*G175)","v":295.75000000000028},{"$f":"(Fixed!$I$4*H175)","v":354.90000000000032},{"$f":"(Fixed!$I$4*I175)","v":414.05000000000035},{"$f":"(Fixed!$I$4*J175)","v":473.20000000000044},{"$f":"(Fixed!$I$4*K175)","v":532.35000000000048},{"$f":"(Fixed!$I$4*L175)","v":591.50000000000057}]
["Fencing",{"$f":"Fixed!$I$32*B175","v":0},{"$f":"Fixed!$I$32*C175","v":10.419866666666676},{"$f":"Fixed!$I$32*D175","v":20.839733333333353},{"$f":"Fixed!$I$32*E175","v":31.259600000000027},{"$f":"Fixed!$I$32*F175","v":41.679466666666706},{"$f":"Fixed!$I$32*G175","v":52.099333333333384},{"$f":"Fixed!$I$32*H175","v":62.519200000000055},{"$f":"Fixed!$I$32*I175","v":72.939066666666733},{"$f":"Fixed!$I$32*J175","v":83.358933333333411},{"$f":"Fixed!$I$32*K175","v":93.778800000000089},{"$f":"Fixed!$I$32*L175","v":104.19866666666677}]
["Buildings & Facilities",{"$f":"(Fixed!$I$18*B175)","v":0},{"$f":"(Fixed!$I$18*C175)","v":25.850000000000023},{"$f":"(Fixed!$I$18*D175)","v":51.700000000000045},{"$f":"(Fixed!$I$18*E175)","v":77.550000000000068},{"$f":"(Fixed!$I$18*F175)","v":103.40000000000009},{"$f":"(Fixed!$I$18*G175)","v":129.25000000000011},{"$f":"(Fixed!$I$18*H175)","v":155.10000000000014},{"$f":"(Fixed!$I$18*I175)","v":180.95000000000016},{"$f":"(Fixed!$I$18*J175)","v":206.80000000000018},{"$f":"(Fixed!$I$18*K175)","v":232.6500000000002},{"$f":"(Fixed!$I$18*L175)","v":258.50000000000023}]
["Total Debt Per Cow",{"$f":"SUM(B179:B184)","v":0},336.01986666666693,672.03973333333386,1008.0596000000008,1344.0794666666677,1680.0993333333349,2016.1192000000017,2352.1390666666689,2688.1589333333354,3024.1788000000024,3360.1986666666699]
[]
["Gross Revenue",{"$f":"Summary!F46","v":1997.3631249999996},{"$f":"$B$187","v":1997.3631249999996},1997.3631249999996,1997.3631249999996,1997.3631249999996,1997.3631249999996,1997.3631249999996,1997.3631249999996,1997.3631249999996,1997.3631249999996,1997.3631249999996]
[]
["Total Operating Costs",{"$f":"Summary!F29","v":1117.1858747958577},{"$f":"$B$189","v":1117.1858747958577},1117.1858747958577,1117.1858747958577,1117.1858747958577,1117.1858747958577,1117.1858747958577,1117.1858747958577,1117.1858747958577,1117.1858747958577,1117.1858747958577]
[]
["Total Fixed Costs",{"$f":"SUM(B192:B197)","v":124.69788},175.59241383671542,226.48694767343085,277.38148151014633,328.27601534686175,379.17054918357712,430.0650830202926,480.95961685700803,531.85415069372334,582.74868453043882,633.6432183671543]
["Cows",{"$f":"-PMT(Fixed!$C$9,Fixed!$D$9,Fixed!$D$4*B175,0)+SUM(Fixed!$D$4*B174)*(Fixed!$D$7)","v":0},{"$f":"-PMT(Fixed!$C$9,Fixed!$D$9,Fixed!$D$4*C175,0)+SUM(Fixed!$D$4*C174)*(Fixed!$D$7)","v":24.121918552050733},{"$f":"-PMT(Fixed!$C$9,Fixed!$D$9,Fixed!$D$4*D175,0)+SUM(Fixed!$D$4*D174)*(Fixed!$D$7)","v":48.243837104101466},{"$f":"-PMT(Fixed!$C$9,Fixed!$D$9,Fixed!$D$4*E175,0)+SUM(Fixed!$D$4*E174)*(Fixed!$D$7)","v":72.365755656152203},{"$f":"-PMT(Fixed!$C$9,Fixed!$D$9,Fixed!$D$4*F175,0)+SUM(Fixed!$D$4*F174)*(Fixed!$D$7)","v":96.487674208202932},{"$f":"-PMT(Fixed!$C$9,Fixed!$D$9,Fixed!$D$4*G175,0)+SUM(Fixed!$D$4*G174)*(Fixed!$D$7)","v":120.60959276025366},{"$f":"-PMT(Fixed!$C$9,Fixed!$D$9,Fixed!$D$4*H175,0)+SUM(Fixed!$D$4*H174)*(Fixed!$D$7)","v":144.73151131230441},{"$f":"-PMT(Fixed!$C$9,Fixed!$D$9,Fixed!$D$4*I175,0)+SUM(Fixed!$D$4*I174)*(Fixed!$D$7)","v":168.85342986435515},{"$f":"-PMT(Fixed!$C$9,Fixed!$D$9,Fixed!$D$4*J175,0)+SUM(Fixed!$D$4*J174)*(Fixed!$D$7)","v":192.97534841640586},{"$f":"-PMT(Fixed!$C$9,Fixed!$D$9,Fixed!$D$4*K175,0)+SUM(Fixed!$D$4*K174)*(Fixed!$D$7)","v":217.09726696845664},{"$f":"-PMT(Fixed!$C$9,Fixed!$D$9,Fixed!$D$4*L175,0)+SUM(Fixed!$D$4*L174)*(Fixed!$D$7)","v":241.21918552050732}]
["Marginal Pasture Land",{"$f":"(-PMT(Fixed!$C$22,Fixed!$D$22,Fixed!$D$16*Fixed!$D$17*B175,0)+SUM(Fixed!$D$16*Fixed!$D$17*B174)*(Fixed!$D$20))/Input!$E$13","v":0},{"$f":"(-PMT(Fixed!$C$22,Fixed!$D$22,Fixed!$D$16*Fixed!$D$17*C175,0)+SUM(Fixed!$D$16*Fixed!$D$17*C174)*(Fixed!$D$20))/Input!$E$13","v":6.5585184867188016},{"$f":"(-PMT(Fixed!$C$22,Fixed!$D$22,Fixed!$D$16*Fixed!$D$17*D175,0)+SUM(Fixed!$D$16*Fixed!$D$17*D174)*(Fixed!$D$20))/Input!$E$13","v":13.117036973437603},{"$f":"(-PMT(Fixed!$C$22,Fixed!$D$22,Fixed!$D$16*Fixed!$D$17*E175,0)+SUM(Fixed!$D$16*Fixed!$D$17*E174)*(Fixed!$D$20))/Input!$E$13","v":19.675555460156403},{"$f":"(-PMT(Fixed!$C$22,Fixed!$D$22,Fixed!$D$16*Fixed!$D$17*F175,0)+SUM(Fixed!$D$16*Fixed!$D$17*F174)*(Fixed!$D$20))/Input!$E$13","v":26.234073946875206},{"$f":"(-PMT(Fixed!$C$22,Fixed!$D$22,Fixed!$D$16*Fixed!$D$17*G175,0)+SUM(Fixed!$D$16*Fixed!$D$17*G174)*(Fixed!$D$20))/Input!$E$13","v":32.792592433594002},{"$f":"(-PMT(Fixed!$C$22,Fixed!$D$22,Fixed!$D$16*Fixed!$D$17*H175,0)+SUM(Fixed!$D$16*Fixed!$D$17*H174)*(Fixed!$D$20))/Input!$E$13","v":39.351110920312806},{"$f":"(-PMT(Fixed!$C$22,Fixed!$D$22,Fixed!$D$16*Fixed!$D$17*I175,0)+SUM(Fixed!$D$16*Fixed!$D$17*I174)*(Fixed!$D$20))/Input!$E$13","v":45.909629407031609},{"$f":"(-PMT(Fixed!$C$22,Fixed!$D$22,Fixed!$D$16*Fixed!$D$17*J175,0)+SUM(Fixed!$D$16*Fixed!$D$17*J174)*(Fixed!$D$20))/Input!$E$13","v":52.468147893750412},{"$f":"(-PMT(Fixed!$C$22,Fixed!$D$22,Fixed!$D$16*Fixed!$D$17*K175,0)+SUM(Fixed!$D$16*Fixed!$D$17*K174)*(Fixed!$D$20))/Input!$E$13","v":59.026666380469216},{"$f":"(-PMT(Fixed!$C$22,Fixed!$D$22,Fixed!$D$16*Fixed!$D$17*L175,0)+SUM(Fixed!$D$16*Fixed!$D$17*L174)*(Fixed!$D$20))/Input!$E$13","v":65.585184867188005}]
["Improved Pasture Land",{"$f":"(-PMT(Fixed!$C$36,Fixed!$D$36,Fixed!$D$30*Fixed!$D$31*B175,0)+SUM(Fixed!$D$30*Fixed!$D$31*B174)*(Fixed!$D$34))/Input!$E$13","v":0},{"$f":"(-PMT(Fixed!$C$36,Fixed!$D$36,Fixed!$D$30*Fixed!$D$31*C175,0)+SUM(Fixed!$D$30*Fixed!$D$31*C174)*(Fixed!$D$34))/Input!$E$13","v":2.508633321169941},{"$f":"(-PMT(Fixed!$C$36,Fixed!$D$36,Fixed!$D$30*Fixed!$D$31*D175,0)+SUM(Fixed!$D$30*Fixed!$D$31*D174)*(Fixed!$D$34))/Input!$E$13","v":5.017266642339882},{"$f":"(-PMT(Fixed!$C$36,Fixed!$D$36,Fixed!$D$30*Fixed!$D$31*E175,0)+SUM(Fixed!$D$30*Fixed!$D$31*E174)*(Fixed!$D$34))/Input!$E$13","v":7.5258999635098247},{"$f":"(-PMT(Fixed!$C$36,Fixed!$D$36,Fixed!$D$30*Fixed!$D$31*F175,0)+SUM(Fixed!$D$30*Fixed!$D$31*F174)*(Fixed!$D$34))/Input!$E$13","v":10.034533284679764},{"$f":"(-PMT(Fixed!$C$36,Fixed!$D$36,Fixed!$D$30*Fixed!$D$31*G175,0)+SUM(Fixed!$D$30*Fixed!$D$31*G174)*(Fixed!$D$34))/Input!$E$13","v":12.543166605849708},{"$f":"(-PMT(Fixed!$C$36,Fixed!$D$36,Fixed!$D$30*Fixed!$D$31*H175,0)+SUM(Fixed!$D$30*Fixed!$D$31*H174)*(Fixed!$D$34))/Input!$E$13","v":15.051799927019649},{"$f":"(-PMT(Fixed!$C$36,Fixed!$D$36,Fixed!$D$30*Fixed!$D$31*I175,0)+SUM(Fixed!$D$30*Fixed!$D$31*I174)*(Fixed!$D$34))/Input!$E$13","v":17.56043324818959},{"$f":"(-PMT(Fixed!$C$36,Fixed!$D$36,Fixed!$D$30*Fixed!$D$31*J175,0)+SUM(Fixed!$D$30*Fixed!$D$31*J174)*(Fixed!$D$34))/Input!$E$13","v":20.069066569359528},{"$f":"(-PMT(Fixed!$C$36,Fixed!$D$36,Fixed!$D$30*Fixed!$D$31*K175,0)+SUM(Fixed!$D$30*Fixed!$D$31*K174)*(Fixed!$D$34))/Input!$E$13","v":22.577699890529473},{"$f":"(-PMT(Fixed!$C$36,Fixed!$D$36,Fixed!$D$30*Fixed!$D$31*L175,0)+SUM(Fixed!$D$30*Fixed!$D$31*L174)*(Fixed!$D$34))/Input!$E$13","v":25.086333211699415}]
["Machinery & Equipment",{"$f":"-PMT(Fixed!$H$11,Fixed!$I$11,Fixed!$I$4*B175,0)+((Fixed!$I$4-(Fixed!$I$4*Fixed!$I$5))/Fixed!$I$6)+(SUM(Fixed!$I$4*B174)*(Fixed!$I$9))","v":94.64},{"$f":"-PMT(Fixed!$H$11,Fixed!$I$11,Fixed!$I$4*C175,0)+((Fixed!$I$4-(Fixed!$I$4*Fixed!$I$5))/Fixed!$I$6)+(SUM(Fixed!$I$4*C174)*(Fixed!$I$9))","v":105.61547294118309},{"$f":"-PMT(Fixed!$H$11,Fixed!$I$11,Fixed!$I$4*D175,0)+((Fixed!$I$4-(Fixed!$I$4*Fixed!$I$5))/Fixed!$I$6)+(SUM(Fixed!$I$4*D174)*(Fixed!$I$9))","v":116.59094588236617},{"$f":"-PMT(Fixed!$H$11,Fixed!$I$11,Fixed!$I$4*E175,0)+((Fixed!$I$4-(Fixed!$I$4*Fixed!$I$5))/Fixed!$I$6)+(SUM(Fixed!$I$4*E174)*(Fixed!$I$9))","v":127.56641882354926},{"$f":"-PMT(Fixed!$H$11,Fixed!$I$11,Fixed!$I$4*F175,0)+((Fixed!$I$4-(Fixed!$I$4*Fixed!$I$5))/Fixed!$I$6)+(SUM(Fixed!$I$4*F174)*(Fixed!$I$9))","v":138.54189176473233},{"$f":"-PMT(Fixed!$H$11,Fixed!$I$11,Fixed!$I$4*G175,0)+((Fixed!$I$4-(Fixed!$I$4*Fixed!$I$5))/Fixed!$I$6)+(SUM(Fixed!$I$4*G174)*(Fixed!$I$9))","v":149.51736470591544},{"$f":"-PMT(Fixed!$H$11,Fixed!$I$11,Fixed!$I$4*H175,0)+((Fixed!$I$4-(Fixed!$I$4*Fixed!$I$5))/Fixed!$I$6)+(SUM(Fixed!$I$4*H174)*(Fixed!$I$9))","v":160.4928376470985},{"$f":"-PMT(Fixed!$H$11,Fixed!$I$11,Fixed!$I$4*I175,0)+((Fixed!$I$4-(Fixed!$I$4*Fixed!$I$5))/Fixed!$I$6)+(SUM(Fixed!$I$4*I174)*(Fixed!$I$9))","v":171.46831058828158},{"$f":"-PMT(Fixed!$H$11,Fixed!$I$11,Fixed!$I$4*J175,0)+((Fixed!$I$4-(Fixed!$I$4*Fixed!$I$5))/Fixed!$I$6)+(SUM(Fixed!$I$4*J174)*(Fixed!$I$9))","v":182.44378352946467},{"$f":"-PMT(Fixed!$H$11,Fixed!$I$11,Fixed!$I$4*K175,0)+((Fixed!$I$4-(Fixed!$I$4*Fixed!$I$5))/Fixed!$I$6)+(SUM(Fixed!$I$4*K174)*(Fixed!$I$9))","v":193.41925647064775},{"$f":"-PMT(Fixed!$H$11,Fixed!$I$11,Fixed!$I$4*L175,0)+((Fixed!$I$4-(Fixed!$I$4*Fixed!$I$5))/Fixed!$I$6)+(SUM(Fixed!$I$4*L174)*(Fixed!$I$9))","v":204.39472941183084}]
["Fencing",{"$f":"-PMT(Fixed!$H$39,Fixed!$I$39,Fixed!$I$32*B175,0)+((Fixed!$I$32-(Fixed!$I$32*Fixed!$I$33))/Fixed!$I$34)+(SUM(Fixed!$I$32*B174)*(Fixed!$I$37))","v":9.3778800000000011},{"$f":"-PMT(Fixed!$H$39,Fixed!$I$39,Fixed!$I$32*C175,0)+((Fixed!$I$32-(Fixed!$I$32*Fixed!$I$33))/Fixed!$I$34)+(SUM(Fixed!$I$32*C174)*(Fixed!$I$37))","v":11.311319808127399},{"$f":"-PMT(Fixed!$H$39,Fixed!$I$39,Fixed!$I$32*D175,0)+((Fixed!$I$32-(Fixed!$I$32*Fixed!$I$33))/Fixed!$I$34)+(SUM(Fixed!$I$32*D174)*(Fixed!$I$37))","v":13.244759616254797},{"$f":"-PMT(Fixed!$H$39,Fixed!$I$39,Fixed!$I$32*E175,0)+((Fixed!$I$32-(Fixed!$I$32*Fixed!$I$33))/Fixed!$I$34)+(SUM(Fixed!$I$32*E174)*(Fixed!$I$37))","v":15.178199424382194},{"$f":"-PMT(Fixed!$H$39,Fixed!$I$39,Fixed!$I$32*F175,0)+((Fixed!$I$32-(Fixed!$I$32*Fixed!$I$33))/Fixed!$I$34)+(SUM(Fixed!$I$32*F174)*(Fixed!$I$37))","v":17.111639232509592},{"$f":"-PMT(Fixed!$H$39,Fixed!$I$39,Fixed!$I$32*G175,0)+((Fixed!$I$32-(Fixed!$I$32*Fixed!$I$33))/Fixed!$I$34)+(SUM(Fixed!$I$32*G174)*(Fixed!$I$37))","v":19.045079040636992},{"$f":"-PMT(Fixed!$H$39,Fixed!$I$39,Fixed!$I$32*H175,0)+((Fixed!$I$32-(Fixed!$I$32*Fixed!$I$33))/Fixed!$I$34)+(SUM(Fixed!$I$32*H174)*(Fixed!$I$37))","v":20.978518848764388},{"$f":"-PMT(Fixed!$H$39,Fixed!$I$39,Fixed!$I$32*I175,0)+((Fixed!$I$32-(Fixed!$I$32*Fixed!$I$33))/Fixed!$I$34)+(SUM(Fixed!$I$32*I174)*(Fixed!$I$37))","v":22.911958656891784},{"$f":"-PMT(Fixed!$H$39,Fixed!$I$39,Fixed!$I$32*J175,0)+((Fixed!$I$32-(Fixed!$I$32*Fixed!$I$33))/Fixed!$I$34)+(SUM(Fixed!$I$32*J174)*(Fixed!$I$37))","v":24.845398465019183},{"$f":"-PMT(Fixed!$H$39,Fixed!$I$39,Fixed!$I$32*K175,0)+((Fixed!$I$32-(Fixed!$I$32*Fixed!$I$33))/Fixed!$I$34)+(SUM(Fixed!$I$32*K174)*(Fixed!$I$37))","v":26.778838273146583},{"$f":"-PMT(Fixed!$H$39,Fixed!$I$39,Fixed!$I$32*L175,0)+((Fixed!$I$32-(Fixed!$I$32*Fixed!$I$33))/Fixed!$I$34)+(SUM(Fixed!$I$32*L174)*(Fixed!$I$37))","v":28.712278081273979}]
["Buildings & Facilities",{"$f":"-PMT(Fixed!$H$25,Fixed!$I$25,Fixed!$I$18*B175,0)+((Fixed!$I$18-(Fixed!$I$18*Fixed!$I$19))/Fixed!$I$20)+(SUM(Fixed!$I$18*B174)*(Fixed!$I$23))","v":20.68},{"$f":"-PMT(Fixed!$H$25,Fixed!$I$25,Fixed!$I$18*C175,0)+((Fixed!$I$18-(Fixed!$I$18*Fixed!$I$19))/Fixed!$I$20)+(SUM(Fixed!$I$18*C174)*(Fixed!$I$23))","v":25.476550727465472},{"$f":"-PMT(Fixed!$H$25,Fixed!$I$25,Fixed!$I$18*D175,0)+((Fixed!$I$18-(Fixed!$I$18*Fixed!$I$19))/Fixed!$I$20)+(SUM(Fixed!$I$18*D174)*(Fixed!$I$23))","v":30.273101454930945},{"$f":"-PMT(Fixed!$H$25,Fixed!$I$25,Fixed!$I$18*E175,0)+((Fixed!$I$18-(Fixed!$I$18*Fixed!$I$19))/Fixed!$I$20)+(SUM(Fixed!$I$18*E174)*(Fixed!$I$23))","v":35.069652182396418},{"$f":"-PMT(Fixed!$H$25,Fixed!$I$25,Fixed!$I$18*F175,0)+((Fixed!$I$18-(Fixed!$I$18*Fixed!$I$19))/Fixed!$I$20)+(SUM(Fixed!$I$18*F174)*(Fixed!$I$23))","v":39.86620290986189},{"$f":"-PMT(Fixed!$H$25,Fixed!$I$25,Fixed!$I$18*G175,0)+((Fixed!$I$18-(Fixed!$I$18*Fixed!$I$19))/Fixed!$I$20)+(SUM(Fixed!$I$18*G174)*(Fixed!$I$23))","v":44.66275363732737},{"$f":"-PMT(Fixed!$H$25,Fixed!$I$25,Fixed!$I$18*H175,0)+((Fixed!$I$18-(Fixed!$I$18*Fixed!$I$19))/Fixed!$I$20)+(SUM(Fixed!$I$18*H174)*(Fixed!$I$23))","v":49.459304364792843},{"$f":"-PMT(Fixed!$H$25,Fixed!$I$25,Fixed!$I$18*I175,0)+((Fixed!$I$18-(Fixed!$I$18*Fixed!$I$19))/Fixed!$I$20)+(SUM(Fixed!$I$18*I174)*(Fixed!$I$23))","v":54.255855092258308},{"$f":"-PMT(Fixed!$H$25,Fixed!$I$25,Fixed!$I$18*J175,0)+((Fixed!$I$18-(Fixed!$I$18*Fixed!$I$19))/Fixed!$I$20)+(SUM(Fixed!$I$18*J174)*(Fixed!$I$23))","v":59.052405819723781},{"$f":"-PMT(Fixed!$H$25,Fixed!$I$25,Fixed!$I$18*K175,0)+((Fixed!$I$18-(Fixed!$I$18*Fixed!$I$19))/Fixed!$I$20)+(SUM(Fixed!$I$18*K174)*(Fixed!$I$23))","v":63.848956547189253},{"$f":"-PMT(Fixed!$H$25,Fixed!$I$25,Fixed!$I$18*L175,0)+((Fixed!$I$18-(Fixed!$I$18*Fixed!$I$19))/Fixed!$I$20)+(SUM(Fixed!$I$18*L174)*(Fixed!$I$23))","v":68.645507274654733}]
[]
["C.  Labour - Owners Living",{"$f":"Summary!F38","v":216},{"$f":"$B$199","v":216},216,216,216,216,216,216,216,216,216]
["Profit"]
["over op & fixed",{"$f":"SUM(B187-B189-B191)","v":755.47937020414201},704.58483636742653,653.69030253071105,602.79576869399557,551.9012348572802,501.00670102056483,450.11216718384935,399.21763334713393,348.32309951041861,297.42856567370313,246.53403183698765]
["over total costs",{"$f":"SUM(B187-B189-B191-B199)","v":539.47937020414201},488.58483636742653,437.69030253071105,386.79576869399557,335.9012348572802,285.00670102056483,234.11216718384935,183.21763334713393,132.32309951041861,81.428565673703133,30.534031836987651]
[]
[null,{"$f":"TEXT(B185,\"$0\")&\" (\"&B174*100&\"%)\"","v":"$0 (100%)"},"$336 (95%)","$672 (90%)","$1008 (85%)","$1344 (80%)","$1680 (75%)","$2016 (70%)","$2352 (65%)","$2688 (60%)","$3024 (55%)","$3360 (50%)"]
[]
[]
[]
[{"$f":"Input!E13&\" Head Beef Cow Calf - Profitability vs. Debt per Cow\"","v":"150 Head Beef Cow Calf - Profitability vs. Debt per Cow"}]
[null,null,"Debt/Cow","Profit (over Operating & Fixed Costs)","Profit (over Total Costs)","Total Fixed Costs"]
[{"$f":"B204","v":"$0 (100%)"},{"$f":"B$174","v":1},{"$f":"B$185","v":0},{"$f":"B$201","v":755.47937020414201},{"$f":"B$202","v":539.47937020414201},{"$f":"B$191","v":124.69788}]
[{"$f":"C204","v":"$336 (95%)"},{"$f":"C$174","v":0.95},{"$f":"C$185","v":336.01986666666693},{"$f":"C$201","v":704.58483636742653},{"$f":"C$202","v":488.58483636742653},{"$f":"C$191","v":175.59241383671542}]
[{"$f":"D204","v":"$672 (90%)"},{"$f":"D$174","v":0.89999999999999991},{"$f":"D$185","v":672.03973333333386},{"$f":"D$201","v":653.69030253071105},{"$f":"D$202","v":437.69030253071105},{"$f":"D$191","v":226.48694767343085}]
[{"$f":"E204","v":"$1008 (85%)"},{"$f":"E$174","v":0.84999999999999987},{"$f":"E$185","v":1008.0596000000008},{"$f":"E$201","v":602.79576869399557},{"$f":"E$202","v":386.79576869399557},{"$f":"E$191","v":277.38148151014633}]
[{"$f":"F204","v":"$1344 (80%)"},{"$f":"F$174","v":0.79999999999999982},{"$f":"F$185","v":1344.0794666666677},{"$f":"F$201","v":551.9012348572802},{"$f":"F$202","v":335.9012348572802},{"$f":"F$191","v":328.27601534686175}]
[{"$f":"G204","v":"$1680 (75%)"},{"$f":"G$174","v":0.74999999999999978},{"$f":"G$185","v":1680.0993333333349},{"$f":"G$201","v":501.00670102056483},{"$f":"G$202","v":285.00670102056483},{"$f":"G$191","v":379.17054918357712}]
[{"$f":"H204","v":"$2016 (70%)"},{"$f":"H$174","v":0.69999999999999973},{"$f":"H$185","v":2016.1192000000017},{"$f":"H$201","v":450.11216718384935},{"$f":"H$202","v":234.11216718384935},{"$f":"H$191","v":430.0650830202926}]
[{"$f":"I204","v":"$2352 (65%)"},{"$f":"I$174","v":0.64999999999999969},{"$f":"I$185","v":2352.1390666666689},{"$f":"I$201","v":399.21763334713393},{"$f":"I$202","v":183.21763334713393},{"$f":"I$191","v":480.95961685700803}]
[{"$f":"J204","v":"$2688 (60%)"},{"$f":"J$174","v":0.59999999999999964},{"$f":"J$185","v":2688.1589333333354},{"$f":"J$201","v":348.32309951041861},{"$f":"J$202","v":132.32309951041861},{"$f":"J$191","v":531.85415069372334}]
[{"$f":"K204","v":"$3024 (55%)"},{"$f":"K$174","v":0.5499999999999996},{"$f":"K$185","v":3024.1788000000024},{"$f":"K$201","v":297.42856567370313},{"$f":"K$202","v":81.428565673703133},{"$f":"K$191","v":582.74868453043882}]
[{"$f":"L204","v":"$3360 (50%)"},{"$f":"L$174","v":0.49999999999999961},{"$f":"L$185","v":3360.1986666666699},{"$f":"L$201","v":246.53403183698765},{"$f":"L$202","v":30.534031836987651},{"$f":"L$191","v":633.6432183671543}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"Input!E13&\" Head Beef  - Debt per Cow (\"&TEXT(B238,\"$0\")&\"/cow @ \"&ROUND(Details!I26*100,0)&\"% Equity)\"","v":"150 Head Beef  - Debt per Cow ($1309/cow @ 81% Equity)"}]
["Debt Summary","$/cow","Total"]
["Cows",{"$f":"Details!I12","v":390.00000000000006},{"$f":"Details!J12","v":58500.000000000007}]
["Marginal Pasture Land",{"$f":"Details!I13","v":400},{"$f":"Details!J13","v":60000}]
["Improved Pasture Land",{"$f":"Details!I14","v":153},{"$f":"Details!J14","v":22950}]
["Machinery & Equipment",{"$f":"Details!I15","v":236.59999999999994},{"$f":"Details!J15","v":35489.999999999993}]
["Fencing",{"$f":"Details!I16","v":52.099333333333334},{"$f":"Details!J16","v":7814.9}]
["Buildings & Facilities",{"$f":"Details!I17","v":77.550000000000011},{"$f":"Details!J17","v":11632.500000000002}]
["Total Debt",{"$f":"SUM(B232:B237)","v":1309.2493333333332},{"$f":"SUM(C232:C237)","v":196387.4}]
[]
[]
[{"$f":"\"Managing total debt per cow is a important step to maintain profitability in a cow calf production enterprise. Total P & I Cost = $\"&ROUND(Fixed!D41,0)&\"/cow.\"","v":"Managing total debt per cow is a important step to maintain profitability in a cow calf production enterprise. Total P & I Cost = $194/cow."}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"\"What Can you Profitably Pay for Cows? (\"&Fixed!D6*100&\"% financed)\"","v":"What Can you Profitably Pay for Cows? (15% financed)"}]
[null,null,"Purchase Price (over Operating & Fixed costs)",null,null,null,"Purchase Price (over Total Costs)"]
[null,"Target Profit/Cow","Cow PMT","Loan Value","Cow",null,"Cow PMT","Loan Value","Cow","gross","op cost",null,"Pasture","Machinery & Equipment","Buildings & Facilities",null,null,"Labour-Owner Living"]
[null,75,{"$f":"SUM($J$256-B253-$K$256-$M$256-$N$256-$O$256)","v":567.16270371084022},{"$f":"-PV(Fixed!$C$9,Fixed!$D$9,SUM(C253-((Fixed!$D$4*Fixed!$D$5)*(Fixed!$D$7))))","v":3056.6039481192515},{"$f":"SUM(D253+(Fixed!$D$4*Fixed!$D$5))","v":5266.6039481192511},null,{"$f":"SUM($J$256-B253-$K$256-$M$256-$N$256-$O$256-$R$256)","v":351.16270371084022},{"$f":"-PV(Fixed!$C$9,Fixed!$D$9,SUM(G253-((Fixed!$D$4*Fixed!$D$5)*(Fixed!$D$7))))","v":1892.517437363133},{"$f":"SUM(H253+(Fixed!$D$4*Fixed!$D$5))","v":4102.5174373631326}]
[null,50,592.16270371084022,{"$f":"-PV(Fixed!$C$9,Fixed!$D$9,SUM(C254-((Fixed!$D$4*Fixed!$D$5)*(Fixed!$D$7))))","v":3191.3361831604693},{"$f":"SUM(D254+(Fixed!$D$4*Fixed!$D$5))","v":5401.3361831604689},null,376.16270371084022,{"$f":"-PV(Fixed!$C$9,Fixed!$D$9,SUM(G254-((Fixed!$D$4*Fixed!$D$5)*(Fixed!$D$7))))","v":2027.2496724043506},{"$f":"SUM(H254+(Fixed!$D$4*Fixed!$D$5))","v":4237.2496724043503}]
[null,25,617.16270371084022,{"$f":"-PV(Fixed!$C$9,Fixed!$D$9,SUM(C255-((Fixed!$D$4*Fixed!$D$5)*(Fixed!$D$7))))","v":3326.0684182016871},{"$f":"SUM(D255+(Fixed!$D$4*Fixed!$D$5))","v":5536.0684182016867},null,401.16270371084022,{"$f":"-PV(Fixed!$C$9,Fixed!$D$9,SUM(G255-((Fixed!$D$4*Fixed!$D$5)*(Fixed!$D$7))))","v":2161.9819074455681},{"$f":"SUM(H255+(Fixed!$D$4*Fixed!$D$5))","v":4371.9819074455681}]
[null,0,642.16270371084022,{"$f":"-PV(Fixed!$C$9,Fixed!$D$9,SUM(C256-((Fixed!$D$4*Fixed!$D$5)*(Fixed!$D$7))))","v":3460.800653242904},{"$f":"SUM(D256+(Fixed!$D$4*Fixed!$D$5))","v":5670.8006532429044},null,426.16270371084022,{"$f":"-PV(Fixed!$C$9,Fixed!$D$9,SUM(G256-((Fixed!$D$4*Fixed!$D$5)*(Fixed!$D$7))))","v":2296.7141424867855},{"$f":"SUM(H256+(Fixed!$D$4*Fixed!$D$5))","v":4506.7141424867859},{"$f":"Summary!F46","v":1997.3631249999996},{"$f":"Summary!F29","v":1117.1858747958577},null,{"$f":"Summary!F35","v":64.403002546173056},{"$f":"Summary!F34","v":138.54189176473227},{"$f":"Summary!F33","v":35.06965218239641},null,null,{"$f":"Summary!F38","v":216}]
[null,-25,667.16270371084022,{"$f":"-PV(Fixed!$C$9,Fixed!$D$9,SUM(C257-((Fixed!$D$4*Fixed!$D$5)*(Fixed!$D$7))))","v":3595.5328882841213},{"$f":"SUM(D257+(Fixed!$D$4*Fixed!$D$5))","v":5805.5328882841213},null,451.16270371084022,{"$f":"-PV(Fixed!$C$9,Fixed!$D$9,SUM(G257-((Fixed!$D$4*Fixed!$D$5)*(Fixed!$D$7))))","v":2431.4463775280028},{"$f":"SUM(H257+(Fixed!$D$4*Fixed!$D$5))","v":4641.4463775280028}]
[null,-50,692.16270371084022,{"$f":"-PV(Fixed!$C$9,Fixed!$D$9,SUM(C258-((Fixed!$D$4*Fixed!$D$5)*(Fixed!$D$7))))","v":3730.2651233253391},{"$f":"SUM(D258+(Fixed!$D$4*Fixed!$D$5))","v":5940.2651233253391},null,476.16270371084022,{"$f":"-PV(Fixed!$C$9,Fixed!$D$9,SUM(G258-((Fixed!$D$4*Fixed!$D$5)*(Fixed!$D$7))))","v":2566.1786125692206},{"$f":"SUM(H258+(Fixed!$D$4*Fixed!$D$5))","v":4776.1786125692206}]
[null,-75,717.16270371084045,{"$f":"-PV(Fixed!$C$9,Fixed!$D$9,SUM(C259-((Fixed!$D$4*Fixed!$D$5)*(Fixed!$D$7))))","v":3864.9973583665578},{"$f":"SUM(D259+(Fixed!$D$4*Fixed!$D$5))","v":6074.9973583665578},null,501.16270371084045,{"$f":"-PV(Fixed!$C$9,Fixed!$D$9,SUM(G259-((Fixed!$D$4*Fixed!$D$5)*(Fixed!$D$7))))","v":2700.9108476104389},{"$f":"SUM(H259+(Fixed!$D$4*Fixed!$D$5))","v":4910.9108476104393}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"gross","op cost",null,"Pasture","Machinery & Equipment","Buildings & Facilities",null,null,"Labour-Owner Living"]
[null,{"$f":"Summary!$F$46","v":1997.3631249999996},{"$f":"Summary!$F$29","v":1117.1858747958577},null,{"$f":"Summary!$F$35","v":64.403002546173056},{"$f":"Summary!$F$34","v":138.54189176473227},{"$f":"Summary!$F$33","v":35.06965218239641},null,null,{"$f":"Summary!$F$38","v":216}]
[]
[]
[null,{"$f":"\"What Can you Profitably Pay for Cows? (over Total Costs)\"","v":"What Can you Profitably Pay for Cows? (over Total Costs)"}]
[null,null,"Equity","Financed",null,"Equity","Financed",null,"Equity","Financed",null,"Equity","Financed"]
[null,null,0,{"$f":"1-C288","v":1},{"$f":"D288*100&\"% Financed\"","v":"100% Financed"},0.25,{"$f":"1-F288","v":0.75},{"$f":"G288*100&\"% Financed\"","v":"75% Financed"},0.5,{"$f":"1-I288","v":0.5},{"$f":"J288*100&\"% Financed\"","v":"50% Financed"},0.75,{"$f":"1-L288","v":0.25},{"$f":"M288*100&\"% Financed\"","v":"25% Financed"}]
[null,null,"Purchase Price (over Total Costs)",null,null,"Purchase Price (over Total Costs)",null,null,"Purchase Price (over Total Costs)",null,null,"Purchase Price (over Total Costs)"]
[null,"Target Profit/Cow","Cow PMT","Loan Value","Cow","Cow PMT","Loan Value","Cow","Cow PMT","Loan Value","Cow","Cow PMT","Loan Value","Cow"]
[null,300,{"$f":"SUM($B$283-$B$291-$C$283-$E$283-$F$283-$G$283-$J$283)","v":126.16270371084022},{"$f":"-PV(Fixed!$C$9,Fixed!$D$9,SUM(C291-((Fixed!$D$4*C288)*(Fixed!$D$7))))","v":679.92732199217596},{"$f":"SUM(D291+(Fixed!$D$4*C288))","v":679.92732199217596},{"$f":"SUM($B$283-$B$291-$C$283-$E$283-$F$283-$G$283-$J$283)","v":126.16270371084022},{"$f":"-PV(Fixed!$C$9,Fixed!$D$9,SUM(F291-((Fixed!$D$4*F288)*(Fixed!$D$7))))","v":679.92732199217596},{"$f":"SUM(G291+(Fixed!$D$4*F288))","v":1329.9273219921761},{"$f":"SUM($B$283-$B$291-$C$283-$E$283-$F$283-$G$283-$J$283)","v":126.16270371084022},{"$f":"-PV(Fixed!$C$9,Fixed!$D$9,SUM(I291-((Fixed!$D$4*I288)*(Fixed!$D$7))))","v":679.92732199217596},{"$f":"SUM(J291+(Fixed!$D$4*I288))","v":1979.9273219921761},{"$f":"SUM($B$283-$B$291-$C$283-$E$283-$F$283-$G$283-$J$283)","v":126.16270371084022},{"$f":"-PV(Fixed!$C$9,Fixed!$D$9,SUM(L291-((Fixed!$D$4*L288)*(Fixed!$D$7))))","v":679.92732199217596},{"$f":"SUM(M291+(Fixed!$D$4*L288))","v":2629.9273219921761}]
[null,250,{"$f":"SUM($B$283-$B$292-$C$283-$E$283-$F$283-$G$283-$J$283)","v":176.16270371084022},{"$f":"-PV(Fixed!$C$9,Fixed!$D$9,SUM(C292-((Fixed!$D$4*C288)*(Fixed!$D$7))))","v":949.39179207461086},{"$f":"SUM(D292+(Fixed!$D$4*C288))","v":949.39179207461086},{"$f":"SUM($B$283-$B$292-$C$283-$E$283-$F$283-$G$283-$J$283)","v":176.16270371084022},{"$f":"-PV(Fixed!$C$9,Fixed!$D$9,SUM(F292-((Fixed!$D$4*F288)*(Fixed!$D$7))))","v":949.39179207461086},{"$f":"SUM(G292+(Fixed!$D$4*F288))","v":1599.3917920746107},{"$f":"SUM($B$283-$B$292-$C$283-$E$283-$F$283-$G$283-$J$283)","v":176.16270371084022},{"$f":"-PV(Fixed!$C$9,Fixed!$D$9,SUM(I292-((Fixed!$D$4*I288)*(Fixed!$D$7))))","v":949.39179207461086},{"$f":"SUM(J292+(Fixed!$D$4*I288))","v":2249.3917920746107},{"$f":"SUM($B$283-$B$292-$C$283-$E$283-$F$283-$G$283-$J$283)","v":176.16270371084022},{"$f":"-PV(Fixed!$C$9,Fixed!$D$9,SUM(L292-((Fixed!$D$4*L288)*(Fixed!$D$7))))","v":949.39179207461086},{"$f":"SUM(M292+(Fixed!$D$4*L288))","v":2899.3917920746107}]
[null,200,{"$f":"SUM($B$283-$B$293-$C$283-$E$283-$F$283-$G$283-$J$283)","v":226.16270371084022},{"$f":"-PV(Fixed!$C$9,Fixed!$D$9,SUM(C293-((Fixed!$D$4*C288)*(Fixed!$D$7))))","v":1218.8562621570459},{"$f":"SUM(D293+(Fixed!$D$4*C288))","v":1218.8562621570459},{"$f":"SUM($B$283-$B$293-$C$283-$E$283-$F$283-$G$283-$J$283)","v":226.16270371084022},{"$f":"-PV(Fixed!$C$9,Fixed!$D$9,SUM(F293-((Fixed!$D$4*F288)*(Fixed!$D$7))))","v":1218.8562621570459},{"$f":"SUM(G293+(Fixed!$D$4*F288))","v":1868.8562621570459},{"$f":"SUM($B$283-$B$293-$C$283-$E$283-$F$283-$G$283-$J$283)","v":226.16270371084022},{"$f":"-PV(Fixed!$C$9,Fixed!$D$9,SUM(I293-((Fixed!$D$4*I288)*(Fixed!$D$7))))","v":1218.8562621570459},{"$f":"SUM(J293+(Fixed!$D$4*I288))","v":2518.8562621570459},{"$f":"SUM($B$283-$B$293-$C$283-$E$283-$F$283-$G$283-$J$283)","v":226.16270371084022},{"$f":"-PV(Fixed!$C$9,Fixed!$D$9,SUM(L293-((Fixed!$D$4*L288)*(Fixed!$D$7))))","v":1218.8562621570459},{"$f":"SUM(M293+(Fixed!$D$4*L288))","v":3168.8562621570459}]
[null,150,{"$f":"SUM($B$283-$B$294-$C$283-$E$283-$F$283-$G$283-$J$283)","v":276.16270371084028},{"$f":"-PV(Fixed!$C$9,Fixed!$D$9,SUM(C294-((Fixed!$D$4*C288)*(Fixed!$D$7))))","v":1488.320732239481},{"$f":"SUM(D294+(Fixed!$D$4*C288))","v":1488.320732239481},{"$f":"SUM($B$283-$B$294-$C$283-$E$283-$F$283-$G$283-$J$283)","v":276.16270371084028},{"$f":"-PV(Fixed!$C$9,Fixed!$D$9,SUM(F294-((Fixed!$D$4*F288)*(Fixed!$D$7))))","v":1488.320732239481},{"$f":"SUM(G294+(Fixed!$D$4*F288))","v":2138.320732239481},{"$f":"SUM($B$283-$B$294-$C$283-$E$283-$F$283-$G$283-$J$283)","v":276.16270371084028},{"$f":"-PV(Fixed!$C$9,Fixed!$D$9,SUM(I294-((Fixed!$D$4*I288)*(Fixed!$D$7))))","v":1488.320732239481},{"$f":"SUM(J294+(Fixed!$D$4*I288))","v":2788.320732239481},{"$f":"SUM($B$283-$B$294-$C$283-$E$283-$F$283-$G$283-$J$283)","v":276.16270371084028},{"$f":"-PV(Fixed!$C$9,Fixed!$D$9,SUM(L294-((Fixed!$D$4*L288)*(Fixed!$D$7))))","v":1488.320732239481},{"$f":"SUM(M294+(Fixed!$D$4*L288))","v":3438.320732239481}]
[null,100,{"$f":"SUM($B$283-$B$295-$C$283-$E$283-$F$283-$G$283-$J$283)","v":326.16270371084022},{"$f":"-PV(Fixed!$C$9,Fixed!$D$9,SUM(C295-((Fixed!$D$4*C288)*(Fixed!$D$7))))","v":1757.7852023219157},{"$f":"SUM(D295+(Fixed!$D$4*C288))","v":1757.7852023219157},{"$f":"SUM($B$283-$B$295-$C$283-$E$283-$F$283-$G$283-$J$283)","v":326.16270371084022},{"$f":"-PV(Fixed!$C$9,Fixed!$D$9,SUM(F295-((Fixed!$D$4*F288)*(Fixed!$D$7))))","v":1757.7852023219157},{"$f":"SUM(G295+(Fixed!$D$4*F288))","v":2407.7852023219157},{"$f":"SUM($B$283-$B$295-$C$283-$E$283-$F$283-$G$283-$J$283)","v":326.16270371084022},{"$f":"-PV(Fixed!$C$9,Fixed!$D$9,SUM(I295-((Fixed!$D$4*I288)*(Fixed!$D$7))))","v":1757.7852023219157},{"$f":"SUM(J295+(Fixed!$D$4*I288))","v":3057.7852023219157},{"$f":"SUM($B$283-$B$295-$C$283-$E$283-$F$283-$G$283-$J$283)","v":326.16270371084022},{"$f":"-PV(Fixed!$C$9,Fixed!$D$9,SUM(L295-((Fixed!$D$4*L288)*(Fixed!$D$7))))","v":1757.7852023219157},{"$f":"SUM(M295+(Fixed!$D$4*L288))","v":3707.7852023219157}]
[null,50,{"$f":"SUM($B$283-$B$296-$C$283-$E$283-$F$283-$G$283-$J$283)","v":376.16270371084022},{"$f":"-PV(Fixed!$C$9,Fixed!$D$9,SUM(C296-((Fixed!$D$4*C288)*(Fixed!$D$7))))","v":2027.2496724043506},{"$f":"SUM(D296+(Fixed!$D$4*C288))","v":2027.2496724043506},{"$f":"SUM($B$283-$B$296-$C$283-$E$283-$F$283-$G$283-$J$283)","v":376.16270371084022},{"$f":"-PV(Fixed!$C$9,Fixed!$D$9,SUM(F296-((Fixed!$D$4*F288)*(Fixed!$D$7))))","v":2027.2496724043506},{"$f":"SUM(G296+(Fixed!$D$4*F288))","v":2677.2496724043503},{"$f":"SUM($B$283-$B$296-$C$283-$E$283-$F$283-$G$283-$J$283)","v":376.16270371084022},{"$f":"-PV(Fixed!$C$9,Fixed!$D$9,SUM(I296-((Fixed!$D$4*I288)*(Fixed!$D$7))))","v":2027.2496724043506},{"$f":"SUM(J296+(Fixed!$D$4*I288))","v":3327.2496724043503},{"$f":"SUM($B$283-$B$296-$C$283-$E$283-$F$283-$G$283-$J$283)","v":376.16270371084022},{"$f":"-PV(Fixed!$C$9,Fixed!$D$9,SUM(L296-((Fixed!$D$4*L288)*(Fixed!$D$7))))","v":2027.2496724043506},{"$f":"SUM(M296+(Fixed!$D$4*L288))","v":3977.2496724043503}]
[null,0,{"$f":"SUM($B$283-$B$297-$C$283-$E$283-$F$283-$G$283-$J$283)","v":426.16270371084022},{"$f":"-PV(Fixed!$C$9,Fixed!$D$9,SUM(C297-((Fixed!$D$4*C288)*(Fixed!$D$7))))","v":2296.7141424867855},{"$f":"SUM(D297+(Fixed!$D$4*C288))","v":2296.7141424867855},{"$f":"SUM($B$283-$B$297-$C$283-$E$283-$F$283-$G$283-$J$283)","v":426.16270371084022},{"$f":"-PV(Fixed!$C$9,Fixed!$D$9,SUM(F297-((Fixed!$D$4*F288)*(Fixed!$D$7))))","v":2296.7141424867855},{"$f":"SUM(G297+(Fixed!$D$4*F288))","v":2946.7141424867855},{"$f":"SUM($B$283-$B$297-$C$283-$E$283-$F$283-$G$283-$J$283)","v":426.16270371084022},{"$f":"-PV(Fixed!$C$9,Fixed!$D$9,SUM(I297-((Fixed!$D$4*I288)*(Fixed!$D$7))))","v":2296.7141424867855},{"$f":"SUM(J297+(Fixed!$D$4*I288))","v":3596.7141424867855},{"$f":"SUM($B$283-$B$297-$C$283-$E$283-$F$283-$G$283-$J$283)","v":426.16270371084022},{"$f":"-PV(Fixed!$C$9,Fixed!$D$9,SUM(L297-((Fixed!$D$4*L288)*(Fixed!$D$7))))","v":2296.7141424867855},{"$f":"SUM(M297+(Fixed!$D$4*L288))","v":4246.7141424867859}]
[]
[null,"****NOT COMPLETED***",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Based on \"&Input!$E$18&\" lb steers @ $\"&Input!$E$19&\"/cwt & \"&Input!$E$20&\" lb heifers @ $\"&Input!$E$21&\"/cwt = $\"&ROUND(Summary!$F$54,0)&\" net profit\"","v":"Based on 600 lb steers @ $380/cwt & 550 lb heifers @ $350/cwt = $354 net profit"}]
[null,{"$f":"\"What Can you Pay for Marginal Pasture? (@ \"&Fixed!D18*100&\"% equity, \"&Fixed!D19*100&\"% financed)\"","v":"What Can you Pay for Marginal Pasture? (@ 75% equity, 25% financed)"}]
[null,null,"B/E Over op. & fixed costs",null,null,null,"B/E Over total costs"]
[null,"Target Profit/Cow","Cow PMT","Loan Value","Cow",null,"Cow PMT","Loan Value","Cow","gross","op cost",null,"Livestock","Machinery & Equipment","Buildings & Facilities",null,null,"Labour-Owner Living"]
[null,75,{"$f":"SUM($J$306-B303-$K$306-$M$306-$N$306-$O$306)","v":559.19995060086114},{"$f":"-PV(Fixed!$C$22,Fixed!$D$22,SUM(C303-((Fixed!$D$16*Fixed!$D$18)*(Fixed!$D$20))))","v":6821.0520620869884},{"$f":"SUM(D303+(Fixed!$D$16*Fixed!$D$18))","v":7421.0520620869884},null,{"$f":"SUM($J$306-B303-$K$306-$M$306-$N$306-$O$306-$R$306)","v":343.19995060086114},{"$f":"-PV(Fixed!$C$22,Fixed!$D$22,SUM(G303-((Fixed!$D$16*Fixed!$D$18)*(Fixed!$D$20))))","v":4186.3106894747843},{"$f":"SUM(H303+(Fixed!$D$16*Fixed!$D$18))","v":4786.3106894747843}]
[null,50,584.19995060086114,{"$f":"-PV(Fixed!$C$22,Fixed!$D$22,SUM(C304-((Fixed!$D$16*Fixed!$D$18)*(Fixed!$D$20))))","v":7125.9989802134005},{"$f":"SUM(D304+(Fixed!$D$16*Fixed!$D$18))","v":7725.9989802134005},null,368.19995060086114,{"$f":"-PV(Fixed!$C$22,Fixed!$D$22,SUM(G304-((Fixed!$D$16*Fixed!$D$18)*(Fixed!$D$20))))","v":4491.2576076011965},{"$f":"SUM(H304+(Fixed!$D$16*Fixed!$D$18))","v":5091.2576076011965}]
[null,25,609.19995060086114,{"$f":"-PV(Fixed!$C$22,Fixed!$D$22,SUM(C305-((Fixed!$D$16*Fixed!$D$18)*(Fixed!$D$20))))","v":7430.9458983398135},{"$f":"SUM(D305+(Fixed!$D$16*Fixed!$D$18))","v":8030.9458983398135},null,393.19995060086114,{"$f":"-PV(Fixed!$C$22,Fixed!$D$22,SUM(G305-((Fixed!$D$16*Fixed!$D$18)*(Fixed!$D$20))))","v":4796.2045257276086},{"$f":"SUM(H305+(Fixed!$D$16*Fixed!$D$18))","v":5396.2045257276086}]
[null,0,634.19995060086114,{"$f":"-PV(Fixed!$C$22,Fixed!$D$22,SUM(C306-((Fixed!$D$16*Fixed!$D$18)*(Fixed!$D$20))))","v":7735.8928164662248},{"$f":"SUM(D306+(Fixed!$D$16*Fixed!$D$18))","v":8335.8928164662248},null,418.19995060086114,{"$f":"-PV(Fixed!$C$22,Fixed!$D$22,SUM(G306-((Fixed!$D$16*Fixed!$D$18)*(Fixed!$D$20))))","v":5101.1514438540216},{"$f":"SUM(H306+(Fixed!$D$16*Fixed!$D$18))","v":5701.1514438540216},{"$f":"Summary!F46","v":1997.3631249999996},{"$f":"Summary!F29","v":1117.1858747958577},null,{"$f":"Summary!F32","v":72.365755656152146},{"$f":"Summary!F34","v":138.54189176473227},{"$f":"Summary!F33","v":35.06965218239641},null,null,{"$f":"Summary!F38","v":216}]
[null,-25,659.19995060086114,{"$f":"-PV(Fixed!$C$22,Fixed!$D$22,SUM(C307-((Fixed!$D$16*Fixed!$D$18)*(Fixed!$D$20))))","v":8040.8397345926378},{"$f":"SUM(D307+(Fixed!$D$16*Fixed!$D$18))","v":8640.8397345926387},null,443.19995060086114,{"$f":"-PV(Fixed!$C$22,Fixed!$D$22,SUM(G307-((Fixed!$D$16*Fixed!$D$18)*(Fixed!$D$20))))","v":5406.0983619804338},{"$f":"SUM(H307+(Fixed!$D$16*Fixed!$D$18))","v":6006.0983619804338}]
[null,-50,684.19995060086114,{"$f":"-PV(Fixed!$C$22,Fixed!$D$22,SUM(C308-((Fixed!$D$16*Fixed!$D$18)*(Fixed!$D$20))))","v":8345.786652719049},{"$f":"SUM(D308+(Fixed!$D$16*Fixed!$D$18))","v":8945.786652719049},null,468.19995060086114,{"$f":"-PV(Fixed!$C$22,Fixed!$D$22,SUM(G308-((Fixed!$D$16*Fixed!$D$18)*(Fixed!$D$20))))","v":5711.0452801068459},{"$f":"SUM(H308+(Fixed!$D$16*Fixed!$D$18))","v":6311.0452801068459}]
[null,-75,709.19995060086137,{"$f":"-PV(Fixed!$C$22,Fixed!$D$22,SUM(C309-((Fixed!$D$16*Fixed!$D$18)*(Fixed!$D$20))))","v":8650.7335708454666},{"$f":"SUM(D309+(Fixed!$D$16*Fixed!$D$18))","v":9250.7335708454666},null,493.19995060086137,{"$f":"-PV(Fixed!$C$22,Fixed!$D$22,SUM(G309-((Fixed!$D$16*Fixed!$D$18)*(Fixed!$D$20))))","v":6015.9921982332617},{"$f":"SUM(H309+(Fixed!$D$16*Fixed!$D$18))","v":6615.9921982332617}]

{"sheet":"Cow Lease","index":15,"n_rows":73,"n_cols":15,"rows_kept":73,"cut":false,"hidden":true,"merged":[[1,1,1,9],[72,1,74,9]]}
[]
[null,{"$f":"\"Cow Share Lease Calculation Worksheet  \"&Introduction!I10&\"\"","v":"Cow Share Lease Calculation Worksheet  September, 2024"}]
[null,null,null,null,"****HIDE in FINAL VERSION*****"]
["A.  Operating Costs",null,null,null,null,"Owner","","Leasee",null,"Total Cost",null,null,null,null,"Owner"]
[null,"1.  Feed Costs",null,null,null,null,null,null,null,null,null,null,null,null,"Leasee"]
[null,"    1.01   Grain and Concentrates",null,null,"Leasee",{"$f":"IF(E6=\"Owner\",Summary!F6,0)","v":0},null,{"$f":"IF(E6=\"Leasee\",Summary!F6,0)","v":27.120535714285715},null,{"$f":"SUM(H6+F6)","v":27.120535714285715}]
[null,"    1.02   Forages",null,null,"Leasee",{"$f":"IF(E7=\"Owner\",Summary!F7,0)","v":0},null,{"$f":"IF(E7=\"Leasee\",Summary!F7,0)","v":408.36294642857143},null,{"$f":"SUM(H7+F7)","v":408.36294642857143}]
[null,"    1.03   Salt & Minerals",null,null,"Leasee",{"$f":"IF(E8=\"Owner\",Summary!F8,0)","v":0},null,{"$f":"IF(E8=\"Leasee\",Summary!F8,0)","v":47.086688311688313},null,{"$f":"SUM(H8+F8)","v":47.086688311688313}]
[null,"    1.04   Extended Grazing Forages",null,null,"Leasee",{"$f":"IF(E9=\"Owner\",Summary!F9,0)","v":0},null,{"$f":"IF(E9=\"Leasee\",IF('Extended Grazing'!G53=\"ERROR\",\"ERROR\",Summary!F9),0)","v":41.65468833333334},null,{"$f":"SUM(H9+F9)","v":41.65468833333334}]
[null,"Total Feed Cost",null,null,null,{"$f":"IF('Winter Feed Rations'!H54=Pasture!G5,F6+F7+F8+F9,\"ERROR\")","v":0},null,{"$f":"IF('Winter Feed Rations'!H54=Pasture!G5,H6+H7+H8+H9,\"ERROR\")","v":524.22485878787882},null,{"$f":"SUM(H10+F10)","v":524.22485878787882}]
[]
[null,"2.  Other Operating Costs",null,null,null,""]
[null,"    2.01   Straw",null,null,"Leasee",{"$f":"IF(E13=\"Owner\",Summary!F13,0)","v":0},null,{"$f":"IF(E13=\"Leasee\",Summary!F13,0)","v":70},null,{"$f":"SUM(H13+F13)","v":70}]
[null,"    2.02   Veterinary Medicine & Supplies",null,null,"Leasee",{"$f":"IF(E14=\"Owner\",Summary!F14,0)","v":0},null,{"$f":"IF(E14=\"Leasee\",Summary!F14,0)","v":30.676666666666662},null,30.676666666666662]
[null,"    2.03   Bull Operating Costs",null,null,"Leasee",{"$f":"IF(E15=\"Owner\",Input!G54+Input!G59+Input!G64+Input!G81,0)","v":0},null,{"$f":"IF(E15=\"Leasee\",Input!G54+Input!G59+Input!G64+Input!G81,0)","v":28.249999999999996},null,28.249999999999996]
[null,"    2.04   Fuel, Maintenance & Repairs",null,null,null,null,null,{"$f":"'Operating '!G48","v":42.717300000000002},null,42.717300000000002]
[null,"    2.05   Utilities",null,null,null,null,null,{"$f":"Summary!F17","v":11.688774},null,11.688774]
[null,"    2.06   Marketing & Transportation",null,null,null,null,null,{"$f":"'Operating '!G93","v":39.598333333333329},null,39.598333333333329]
[null,"    2.07   Death Loss",null,null,null,{"$f":"'Operating '!G97","v":32.5},null,null,null,32.5]
[null,"    2.08   Manure Removal",null,null,null,null,null,{"$f":"'Operating '!G108","v":10.839635625},null,10.839635625]
[null,"    2.09   Insurance",null,null,null,{"$f":"'Operating '!G113","v":11.7},null,{"$f":"'Operating '!G118+'Operating '!G121","v":7.13},null,18.829999999999998]
[null,"    2.10   Herd Replacement - Cows",null,null,null,{"$f":"Input!E38","v":148.5},null,null,null,148.5]
[null,"    2.11   Herd Replacement - Bulls",null,null,"Owner",{"$f":"IF(E23=\"Owner\",Input!G70+Input!G77,0)","v":18.166699999999999},null,{"$f":"IF(E23=\"Leasee\",Input!G70+Input!G77,0)","v":0},null,{"$f":"SUM(H23+F23)","v":18.166699999999999}]
[null,"    2.12   Pasture Rental",null,null,null,null,null,{"$f":"Summary!F23","v":59.375},null,59.375]
[null,"    2.13   Pasture Operating",null,null,null,null,null,{"$f":"Summary!F24","v":34.765106382978729},null,{"$f":"SUM(H25+F25)","v":34.765106382978729}]
[null,"    2.13   Miscellaneous",null,null,null,null,null,{"$f":"'Operating '!G126","v":6.67},null,6.67]
[null,"Subtotal Operating Costs",null,null,null,{"$f":"SUM(F10:F26)","v":210.86669999999998},null,{"$f":"SUM(H10:H26)","v":865.93567479585749},null,1076.8023747958575]
[null,"    2.13   Operating Interest",null,null,null,{"$f":"SUM(F27/2)*'Operating '!$E$131/100","v":7.9075012499999993},null,{"$f":"SUM(H27/2)*'Operating '!$E$131/100","v":32.472587804844657},null,40.38008905484466]
[null,"Total Operating Costs",null,null,null,{"$f":"F27+F28","v":218.77420124999998},null,{"$f":"SUM(H27:H28)","v":898.40826260070219},null,{"$f":"SUM(J27:J28)","v":1117.1824638507021}]
[]
["B.  Fixed Costs"]
[null,"    3.01   Livestock",null,null,null,{"$f":"Summary!F32","v":72.365755656152146},null,null,null,{"$f":"SUM(H32+F32)","v":72.365755656152146}]
[null,"    3.02   Buildings",null,null,null,null,null,{"$f":"Summary!F33","v":35.06965218239641},null,35.06965218239641]
[null,"    3.03   Machinery & Equipment",null,null,null,null,null,{"$f":"Summary!F34","v":138.54189176473227},null,138.54189176473227]
[null,"    3.04   Pasture Land & Fencing",null,null,null,null,null,{"$f":"Summary!F35","v":64.403002546173056},null,64.403002546173056]
[null,"Total Fixed Costs",null,null,null,{"$f":"SUM(F32:F35)","v":72.365755656152146},null,{"$f":"SUM(H32:H35)","v":238.01454649330174},null,310.38030214945388]
[null,"Total Operating and Fixed Costs",null,null,null,{"$f":"F29+F36","v":291.13995690615212},null,{"$f":"H29+H36","v":1136.4228090940039},null,1427.562766000156]
[]
["C.  Labour",null,null,null,null,null,null,{"$f":"'Operating '!G136+'Operating '!G137","v":216},null,{"$f":"SUM(H39+F39)","v":216}]
["Total Contributions",null,null,null,null,{"$f":"F37+F39","v":291.13995690615212},null,{"$f":"H37+J39","v":1352.4228090940039},null,{"$f":"SUM(H40+F40)","v":1643.562766000156}]
[]
["Total Contributions ",null,null,null,null,{"$f":"ROUND(F40/J40,3)","v":0.17699999999999999},null,{"$f":"ROUND(H40/J40,3)","v":0.82299999999999995}]
[]
[null,null,null,"Estimated Farmgate Revenue"]
["Estimated Farmgate",null,null,null,null,null,"",null,null," Per Cow"]
[null,"Price ($ per cwt)",null,null,null,null,null,null,null,{"$f":"Input!E24","v":365.65}]
[null,"Calf weight (lbs)",null,null,null,null,null,null,null,{"$f":"Input!E23","v":575}]
[null,"Gross Revenue  / cow",null,null,null,null,null,null,null,{"$f":"SUM((Input!E24/100)*Input!E23)*(Input!E17/100)","v":1997.3631249999996}]
[]
[null,null,null,"Lease Calculation #1 - Share Split Method"]
[null,null,null,null,null,"Owner","","Leasee"]
["Share Split",null,null,null,null,{"$f":"F42","v":0.17699999999999999},null,{"$f":"H42","v":0.82299999999999995}]
["Share of Revenue",null,null,null,null,{"$f":"SUM(F42*J48)","v":353.53327312499994},null,{"$f":"SUM(H42*J48)","v":1643.8298518749996}]
[]
["Net Return Per Cow",null,null,null,null,{"$f":"SUM(F53-F40)","v":62.393316218847815},null,{"$f":"SUM(H53-H40)","v":291.40704278099565}]
["Cash Rental Per Cow",null,null,null,null,{"$f":"F40","v":291.13995690615212}]
["Return to Assets (ROA)",null,null,null,null,{"$f":"IF($E$23=\"Owner\",SUM(($F$32+F55)/(Input!$E$28+(Input!$E$66*(Input!$E$15/Input!$E$13)))),SUM(($F$32+F55)/(Input!$E$28)))","v":4.8708098268072278E-2}]
[]
[null,null,null,"Lease Calculation #2 - Flexible Share Calculation Method"]
[null,null,null,null,null,"Owner","","Leasee",null,"Total"]
["Contribution Share",null,null,null,null,{"$f":"F40","v":291.13995690615212},null,{"$f":"H40","v":1352.4228090940039},null,{"$f":"SUM(H61+F61)","v":1643.562766000156}]
["Remaining Revenue",null,null,null,null,null,null,null,null,{"$f":"SUM(J48-J61)","v":353.80035899984364}]
["Distribution of Surplus Revenue",null,null,null,null,0.5,null,{"$f":"SUM(1-F63)","v":0.5}]
["Share of Surplus Revenue",null,null,null,null,{"$f":"SUM(J62*F63)","v":176.90017949992182},null,{"$f":"SUM(J62*H63)","v":176.90017949992182}]
["Total Revenue Earned",null,null,null,null,{"$f":"SUM(F61+F64)","v":468.04013640607394},null,{"$f":"SUM(H61+H64)","v":1529.3229885939259},null,{"$f":"SUM(H65+F65)","v":1997.3631249999999}]
[]
["Percent Share of Revenue (Total)",null,null,null,null,{"$f":"SUM(F65/J65)","v":0.23432901636555145},null,{"$f":"SUM(H65/J65)","v":0.76567098363444852}]
[]
["Net Return Per Cow",null,null,null,null,{"$f":"SUM(F65-F61)","v":176.90017949992182},null,{"$f":"SUM(H65-H61)","v":176.90017949992193}]
["Cash Rental Per Cow",null,null,null,null,{"$f":"F40","v":291.13995690615212}]
["Return to Assets (ROA)",null,null,null,null,{"$f":"IF($E$23=\"Owner\",SUM(($F$32+F69)/(Input!$E$28+(Input!$E$66*(Input!$E$15/Input!$E$13)))),SUM(($F$32+F69)/(Input!$E$28)))","v":9.0096121140749635E-2}]
[]
[null,"Note: This budget is only a guide and is not intended to be 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":"Cow Overwinter","index":16,"n_rows":87,"n_cols":12,"rows_kept":87,"cut":false,"hidden":true,"merged":[[2,10,2,11],[15,6,15,7],[29,6,29,7],[72,0,72,11],[80,0,81,11]]}
[null,null,"****HIDE in FINAL VERSION*****"]
[". . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ."]
["Beef Cow Overwinter Cost Calculator",null,null,null,null,null,null,null,null,"Printed:",{"$f":"TODAY()","v":"2025-04-14"}]
[null,null,"*** Enter changes to BLUE values only ***"]
["Input Data:"]
[null,"Number of cows to be wintered",{"$f":"Input!E13","v":150},null,"Operating Interest",null,{"$f":"'Operating '!E131/100","v":7.4999999999999997E-2}]
[null,"Average weight of cows",{"$f":"Input!E14","v":1350},null,null,"Daily Feed Intake @",2.5999999999999999E-2,{"$f":"\"of body weight = \"&C7*G7&\" lbs. \"","v":"of body weight = 35.1 lbs. "}]
[null,"Number of bulls to be wintered",{"$f":"Input!E15","v":5}]
[null,"Number of days in winter feeding period",{"$f":"Pasture!G5","v":195}]
[null,"Number of days in extended grazing",{"$f":"Pasture!G4","v":35}]
[]
["For more information on production costs, "]
[]
["A. Operating Costs:"]
["1. Feed Costs Per Cow:"]
[null,"Item","$/unit",null,"lbs/day","Days","Feed Required",null,null,"Total Cost",null,"$/cow/day"]
[null,"Ground Barley",{"$f":"'Winter Feed Rations'!B19","v":4.5},"/bus",5,60,{"$f":"E17/48*F17*C6","v":937.5},"bus",null,{"$f":"ROUND(G17*C17,0)","v":4219},null,{"$f":"SUM(J17/$C$6)/$C$9","v":0.14423931623931624}]
[null,"32% Feedlot Supplement",{"$f":"'Winter Feed Rations'!B20","v":550},"/ton",0.5,60,{"$f":"E18*C6*C9/2000","v":7.3125},"tons",null,{"$f":"ROUND(G18*C18,0)","v":4022},null,{"$f":"SUM(J18/$C$6)/$C$9","v":0.13750427350427349}]
[null,"Good quality hay",{"$f":"'Winter Feed Rations'!B13","v":115},"/ton*",0,{"$f":"$C$9","v":195},{"$f":"E19*C6*C9/2000","v":0},"tons",null,0,null,{"$f":"SUM(J19/$C$6)/$C$9","v":0}]
[null,"Low quality hay",{"$f":"'Winter Feed Rations'!B14","v":95},"/ton *",0,195,{"$f":"E20*C6*C9/2000","v":0},"tons",null,0,null,0]
[null,"Salt (winter only)",{"$f":"'Winter Feed Rations'!D26","v":0.18181818181818182},"/lb",7.0000000000000007E-2,195,{"$f":"E21*C6*C9","v":2047.5000000000005},"lbs",null,372,null,1.2717948717948718E-2]
[null,"Mineral (winter only)",{"$f":"'Winter Feed Rations'!D23","v":0.90909090909090906},"/lb",0.156,195,{"$f":"E22*C6*C9","v":4563},"lbs",null,4148,null,0.14181196581196581]
[null,"Barley Silage",{"$f":"'Winter Feed Rations'!B18","v":50},"/ton",47,195,{"$f":"(E23*F23*C6)/2000","v":687.375},"tons",null,34369,null,1.175008547008547]
[null,"Feed Straw",{"$f":"'Winter Feed Rations'!B15","v":70},"/ton",19,195,{"$f":"E24*C6*C9/2000","v":277.875},"tons",null,19451,null,0.66499145299145301]
[null,"Total Feed per Cow",null,null,{"$f":"SUM(E17:E24)","v":71.725999999999999},null,null,null,null,{"$f":"SUM(J17:J24)","v":66581},null,2.2762735042735045]
[null,"Bedding (straw)",{"$f":"'Operating '!D25","v":70},"/ton*",null,null,{"$f":"C6","v":150},"tons",null,{"$f":"ROUND(G26*C26,0)","v":10500},null,0.35897435897435898]
[null,{"$f":"\"Total Feed Cost & Bedding (for Cows) - based on \"&C9&\" days\"","v":"Total Feed Cost & Bedding (for Cows) - based on 195 days"},null,null,null,null,null,null,null,{"$f":"SUM(J25:J26)","v":77081},null,2.6352478632478631]
[]
["2. Feed Costs For Breeding Bulls:"]
[null,"Item","$/unit",null,"lbs/hd/day","Days","Feed Required",null,null,"Total Cost",null,"$/cow/day"]
[null,"Ground Barley",{"$f":"C17","v":4.5},"/bus",7,120,{"$f":"(E31/48)*F31*C8","v":87.5},"bus",null,{"$f":"ROUND(G31*C31,0)","v":394},null,{"$f":"SUM(J31/$C$6)/$C$9","v":1.3470085470085469E-2}]
[null,"Good quality hay",{"$f":"C19","v":115},"/ton*",42,{"$f":"$C$9","v":195},{"$f":"ROUND((E32/2000)*C9*C8,0)","v":20},"tons*",null,{"$f":"ROUND(G32*C32,0)","v":2300},null,7.8632478632478631E-2]
[null,"Total Feed per Bull",null,null,{"$f":"SUM(E31:E32)","v":49},null,null,null,null,{"$f":"SUM(J31:J32)","v":2694},null,9.2102564102564108E-2]
[null,"Bedding (straw)",{"$f":"C26","v":70},"/ton*",null,null,{"$f":"C8","v":5},"tons*",null,{"$f":"ROUND(G34*C34,0)","v":350},null,1.1965811965811967E-2]
[null,{"$f":"\"Total Feed & Bedding (for Breeding Bulls) per cow per day based on \"&C9&\" days\"","v":"Total Feed & Bedding (for Breeding Bulls) per cow per day based on 195 days"},null,null,null,null,null,null,null,{"$f":"SUM(J33:J34)","v":3044},null,0.10406837606837607]
[]
[null,"Total All Feed & Bedding for Cows and Bulls",null,null,null,null,null,null,null,{"$f":"J27+J35","v":80125},null,2.7393162393162389]
[]
["3. Extended Grazing Costs:",null,"$/cow/yr",null,null,"Days",null,null,null,"Total Cost",null,"$/cow/day"]
[null,"Extended grazing",{"$f":"'Extended Grazing'!G53","v":41.65468833333334},null,null,{"$f":"C10","v":35},null,null,null,{"$f":"IF(F40<1,0,ROUND(C40*C6,0))","v":6248},null,{"$f":"IF(F40<1,0,SUM(C40/F40))","v":1.1901339523809527}]
[]
["4. Other Operating Costs:",null,"$/cow/yr",null,null,null,null,null,null,"Total Cost",null,"$/cow/day"]
[null,"Veterinary Medicine & Supplies: ",0,null,null,null,null,null,null,{"$f":"ROUND(C43*C6,0)","v":0},null,{"$f":"SUM(J43/$C$6)/($C$9+$C$10)","v":0}]
[null,"Specialized Vet Services",null,null,null,null,null,null,null,0,null,{"$f":"SUM(J44/$C$6)/($C$9+$C$10)","v":0}]
[null,"Utilities",null,null,null,null,null,null,null,{"$f":"Summary!H17","v":1753},null,5.0811594202898554E-2]
[null,"Equipment fuel & repairs",null,null,null,null,null,null,null,{"$f":"'Operating '!E36+'Operating '!E41","v":4702.32},null,0.13629913043478259]
[null,"Building and fences repair",null,null,null,null,null,null,null,{"$f":"'Operating '!E46","v":1705.2750000000001},null,4.942826086956522E-2]
[null,"Building and equipment insurance",null,null,null,null,null,null,null,{"$f":"'Operating '!G118*'Operating '!E118","v":1020},null,2.9565217391304348E-2]
[null,"Manure Removal",null,null,null,null,null,null,null,{"$f":"Summary!H20","v":1626},null,4.7130434782608692E-2]
[" ","Miscellaneous",null,null,null,null,null,null,null,{"$f":"SUM(Summary!H26*((Pasture!G5+Pasture!G4)/365))","v":630.76712328767121},null,1.828310502283105E-2]
[null,"Total Other Operating Costs",null,null,null,null,null,null,null,{"$f":"ROUND(SUM(J43:J50),0)","v":11437},null,0.33150724637681162]
[]
["Subtotal Operating Costs",null,null,null,null,null,null,null,null,{"$f":"ROUND(J27+J35+J51+J40,0)","v":97810},null,2.8350724637681162]
[null,"Operating Interest",null,null,null,null,null,null,null,{"$f":"ROUND((J53/2)*G6,0)","v":3668},null,0.10631884057971014]
["Total Operating Costs for Winter Period",null,null,null,null,null,null,null,null,{"$f":"ROUND(J53+J54,0)","v":101478},null,2.9413913043478259]
[]
["B. Fixed Costs:"]
[null,"Livestock",null,null,null,null,null,null,null,{"$f":"Summary!H32","v":10855}]
[null,"Buildings",null,null,null,null,null,null,null,{"$f":"Summary!H33","v":5260}]
[null,"Machinery & Equipment",null,null,null,null,null,null,null,{"$f":"Summary!H34","v":20781}]
[null,"Pasture Land & Fencing",null,null,null,null,null,null,null,{"$f":"Summary!H35","v":9660},null,"$/cow/day"]
["Total Fixed Costs",null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(J58:J61),0)","v":46556},null,{"$f":"SUM(J62/$C$6)/($C$9+$C$10)","v":1.3494492753623188}]
[]
["C. Labour:",null,null,null,null,null,null,null,null,"Total Cost",null,"$/cow/day"]
[null,"Feeding, bedding",{"$f":"SUM(('Operating '!E136+'Operating '!E137)*0.625)","v":5},"hr/cow",{"$f":"'Operating '!E135","v":27},"/hr",{"$f":"\"(\"&TEXT(((C65*C6)/((C9+C10)/7)),\"#.#\")&\" hrs per week)\"","v":"(22.8 hrs per week)"},null,null,{"$f":"SUM(C65*E65*C6)","v":20250},null,{"$f":"SUM(J65/$C$6)/($C$9+$C$10)","v":0.58695652173913049}]
[null,"Optional Calving Management Fee",null,null,0,"/cow",null,null,null,{"$f":"SUM(E66*C6)","v":0},null,{"$f":"SUM(J66/$C$6)/($C$9+$C$10)","v":0}]
[null,"Calf Crop Bonus",1,"/rate",0,"/calf",null,null,null,{"$f":"SUM(C67*E67*C6)","v":0},null,{"$f":"SUM(J67/$C$6)/($C$9+$C$10)","v":0}]
["Total Labour Costs for Winter Period",null,null,null,null,null,null,null,null,{"$f":"ROUND(J66+J67+J65,0)","v":20250},null,{"$f":"SUM(J68/$C$6)/($C$9+$C$10)","v":0.58695652173913049}]
[]
[null,null,null,null,null,null,null,null,null,"Total Cost",null,"$/cow/day"]
["Total Cost of Production (Winter Feed, Extended Grazing, Operating, Fixed & Labour) ",null,null,null,null,null,null,null,null,{"$f":"SUM(J68+J62+J55)","v":168284},null,{"$f":"SUM(J71/$C$6)/($C$9+$C$10)","v":4.8777971014492758}]
[]
["Cost Summary"]
[null,null,null,null,"Cost/cow/day"]
[null,{"$f":"\"Extended grazing (based on \"&C10&\" days)\"","v":"Extended grazing (based on 35 days)"},null,null,{"$f":"L40","v":1.1901339523809527}]
[null,{"$f":"\"Winter Feed (based on \"&C9&\" days)\"","v":"Winter Feed (based on 195 days)"},null,null,{"$f":"ROUND((J25+J33)/C9/C6,3)","v":2.3679999999999999}]
[null,{"$f":"\"Yardage (not including labour, based on \"&C9+C10&\" days)\"","v":"Yardage (not including labour, based on 230 days)"},null,null,{"$f":"ROUND((((J26+J34+J51+J54+J62)/C6)/(C9+C10)),3)","v":2.1019999999999999}]
[null,{"$f":"\"Labour (based on \"&C9+C10&\" days)\"","v":"Labour (based on 230 days)"},null,null,{"$f":"ROUND((J68)/(C9+C10)/C6,3)","v":0.58699999999999997}]
[null,{"$f":"\"Total Overwinter Costs (based on \"&C9+C10&\" days)\"","v":"Total Overwinter Costs (based on 230 days)"},null,null,{"$f":"SUM(((J40+(E76*C9*C6)+((E77*(C9+C10)*C6)+J65))/C6)/(C9+C10))","v":4.8777101449275362}]
[]
["Note: This budget is only a guide and is not intended to be an in-depth study of the cost of production of this industry. Interpretation and utilization of this information is the responsibility of the user. "]
[]
[]
["Created and maintained by ",null,null,null,null,null,null,null,null,null,null,"September, 2015"]
["For more information, contact your local "]
["Benjamin Hamm",null,"Bob Gwyer",null,null,null,"Roy Arnott"]
["Farm Management Specialist         ",null,"Farm Management Specialist         ",null,null,null,"Farm Management Specialist         "]

{"sheet":"Cow Value","index":17,"n_rows":52,"n_cols":10,"rows_kept":52,"cut":false,"hidden":true,"merged":[[51,0,52,10],[0,0,0,10],[14,1,14,10],[39,0,39,10],[47,0,48,0],[47,1,48,10]]}
[{"$f":"\"Cow Replacement Value Calculation Worksheet - \"&Introduction!I10&\"\"","v":"Cow Replacement Value Calculation Worksheet - September, 2024"}]
[]
["Average Cow Weight",null,{"$f":"Input!E14","v":1350},"lbs",null,"Operating Interest Rate",null,null,{"$f":"'Operating '!E131","v":7.5},"%"]
["Cull Cow Market Price (current)",null,{"$f":"Input!E30","v":175},"/cwt",null,"Investment Rate  ",null,null,{"$f":"Input!E75","v":4},"%"]
["Cull Cow Market Value",null,{"$f":"SUM(C3/100)*C4","v":2362.5}]
[]
["Calf Crop",null,{"$f":"Input!E17","v":95},"%",null,"****HIDE in FINAL VERSION*****"]
["Steer Calf Weight",null,{"$f":"Input!E18","v":600},"lbs"]
["Steer Calf Market Price (current)",null,{"$f":"Input!E19","v":380},"/cwt"]
["Heifer Calf Weight",null,{"$f":"Input!E20","v":550},"lbs"]
["Heifer Calf Market Price (current)",null,{"$f":"Input!E21","v":350},"/cwt"]
["Average Calf Weight",null,{"$f":"AVERAGE(C8,C10)","v":575},"lbs"]
["Weighted Average Calf Market Price",null,{"$f":"SUM(((C9*(C8/100))+(C11*(C10/100)))/2)/(C12/100)","v":365.6521739130435},"/cwt"]
[]
[null,"Estimated Production Costs and Income"]
[null,null,"1 Year","2 Years","3 Years","4 Years","5 Years","6 Years","7 Years","8 Years"]
["Operating Expense (per Cow)"]
[null,"Feed Cost",{"$f":"Summary!F10","v":524.22485878787882},355,359.88124999999997,364.82961718749993,369.84602442382806,374.93140725965566,380.08671410947591,385.3129064284812]
[null,"Other Operating Cost2",{"$f":"SUM(Summary!F27-Summary!F10-Summary!F22)","v":404.0808160079788},{"$f":"SUM(C19*(1+($I$4/100/2)))","v":412.16243232813838},420.40568097470117,428.8137945941952,437.39007048607914,446.13787189580074,455.06062933371675,464.16184192039111]
[null,"Operating Interest",{"$f":"SUM((C18+C19)/2)*I3/100","v":34.811462804844659},{"$f":"SUM((D18+D19)/2)*$I$3/100","v":28.768591212305193},29.260759911551293,29.761627941813568,30.271353559121522,30.790097968329615,31.318025379119728,31.855303063082712]
["Total Operating Cost",null,{"$f":"SUM(C18:C20)","v":963.11713760070222},{"$f":"SUM(D18:D20)","v":795.93102354044356},809.54769088625244,823.40503972350871,837.50744846902876,851.85937712378598,866.46536882231237,881.33005141195497]
["Total Fixed Cost2",null,{"$f":"Summary!F36","v":310.38030214945388},{"$f":"SUM(C22*(1+($I$4/100/2)))","v":316.58790819244297},322.91966635629183,329.37805968341769,335.96562087708605,342.6849332946278,349.53863196052038,356.52940459973081]
["Total Operating and Fixed Cost",null,{"$f":"SUM(C21:C22)","v":1273.497439750156},{"$f":"SUM(D21:D22)","v":1112.5189317328866},{"$f":"SUM(E21:E22)","v":1132.4673572425443},1152.7830994069263,1173.4730693461147,1194.5443104184137,1216.0040007828327,1237.8594560116858]
["Total Labour (Living) Cost2",null,{"$f":"Summary!F38","v":216},{"$f":"SUM(C24*(1+($I$4/100/2)))","v":220.32},224.72639999999998,229.22092799999999,233.80534656,238.4814534912,243.25108256102399,248.11610421224447]
["Total Cost Per Cow",null,{"$f":"SUM(C24+C23)","v":1489.497439750156},{"$f":"SUM(D24+D23)","v":1332.8389317328865},1357.1937572425443,1382.0040274069263,1407.2784159061148,1433.0257639096137,1459.2550833438568,1485.9755602239302]
[]
["Income (per Cow)"]
[null,"Calf Market Price ($/cwt)",{"$f":"C13","v":365.6521739130435},190,190,195,203,210,222,230]
[null,"Calf Revenue",{"$f":"SUM((C28/100)*$C$12)*($C$7/100)","v":1997.375},1037.875,1037.875,1065.1875,1108.8875,1147.125,1212.675,1256.375]
[]
[null,"Calf Marginal Returns "]
[null,"  Over Operating Costs",{"$f":"SUM(C29-C21)","v":1034.2578623992977},{"$f":"SUM(D29-D21)","v":241.94397645955644},228.32730911374756,241.78246027649129,271.38005153097129,295.26562287621402,346.20963117768758,375.04494858804503]
[null,"  Over Operating & Labour Costs",{"$f":"SUM(C29-C21-C24)","v":818.25786239929766},{"$f":"SUM(D29-D21-D24)","v":21.623976459556445},3.6009091137475764,12.561532276491306,37.574704970971283,56.784169385014025,102.95854861666359,126.92884437580057]
[null,"  Over Operating & Fixed Costs",{"$f":"SUM(C29-C21-C22)","v":723.87756024984378},{"$f":"SUM(D29-D21-D22)","v":-74.643931732886529},-94.592357242544267,-87.595599406926397,-64.585569346114767,-47.419310418413772,-3.329000782832793,18.515543988314221]
[null,"  Over Total Costs (Net Profit)",{"$f":"SUM(C29-C25)","v":507.87756024984401},{"$f":"SUM(D29-D25)","v":-294.96393173288652},-319.31875724254428,-316.8165274069263,-298.39091590611474,-285.90076390961372,-246.58008334385681,-229.60056022393019]
[]
[null,"Cull Cow Market Price ($/cwt)",{"$f":"C4","v":175},90,90,95,103,110,122,130]
[null,"Cull Cow Revenue",{"$f":"SUM($C$3/100)*C37","v":2362.5},1215,1215,1282.5,1390.5,1485,1647,1755]
[]
["Estimated Breakeven Replacement Purchase Values1 - Number of Years Before Culling"]
[null,null,"1 Year","2 Years","3 Years","4 Years","5 Years","6 Years","7 Years","8 Years"]
[]
[null,"Over Operating Costs",{"$f":"NPV(I4/100,(C29-C21)+C38)","v":3266.1133292300938},{"$f":"NPV(I4/100,C29-C21,D29-D21+$D$38)","v":2341.5053192999499},{"$f":"NPV(I4/100,C29-C21,D29-D21,E29-E21+$E$38)","v":2501.2822426557932},{"$f":"NPV(I4/100,C29-C21,D29-D21,E29-E21,F29-F21+$F$38)","v":2724.1147022280784},{"$f":"NPV(I4/100,C29-C21,D29-D21,E29-E21,F29-F21,G29-G21+$G$38)","v":2993.7725897683886},{"$f":"NPV(I4/100,C29-C21,D29-D21,E29-E21,F29-F21,G29-G21,H29-H21+$H$38)","v":3257.852729236608},{"$f":"NPV(I4/100,C29-C21,D29-D21,E29-E21,F29-F21,G29-G21,H29-H21,I29-I21+$I$38)","v":3598.9111627051807},{"$f":"NPV(I4/100,C29-C21,D29-D21,E29-E21,F29-F21,G29-G21,H29-H21,I29-I21,J29-J21+$J$38)","v":3903.7295045086207}]
[null,"Over Operating & Labour Costs",{"$f":"NPV(I4/100,(C29-C21-C24)+C38)","v":3058.4210215377861},{"$f":"NPV(I4/100,C29-C21-C24,D29-D21-D24+$D$38)","v":1930.1147867555712},{"$f":"NPV(I4/100,C29-C21-C24,D29-D21-D24,E29-E21-E24+$E$38)","v":1890.1107588141913},{"$f":"NPV(I4/100,C29-C21-C24,D29-D21-D24,E29-E21-E24,F29-F21-F24+$F$38)","v":1917.0042084603531},{"$f":"NPV(I4/100,C29-C21-C24,D29-D21-D24,E29-E21-E24,F29-F21-F24,G29-G21-G24+$G$38)","v":1994.4911439577349},{"$f":"NPV(I4/100,C29-C21-C24,D29-D21-D24,E29-E21-E24,F29-F21-F24,G29-G21-G24,H29-H21-H24+$H$38)","v":2070.0959266146206},{"$f":"NPV(I4/100,C29-C21-C24,D29-D21-D24,E29-E21-E24,F29-F21-F24,G29-G21-G24,H29-H21-H24,I29-I21-I24+$I$38)","v":2226.3035293643852},{"$f":"NPV(I4/100,C29-C21-C24,D29-D21-D24,E29-E21-E24,F29-F21-F24,G29-G21-G24,H29-H21-H24,I29-I21-I24,J29-J21-J24+$J$38)","v":2349.8258641166872}]
[null,"Over Operating & Fixed Costs",{"$f":"NPV(I4/100,C29-C21-C22+C38)","v":2967.6707310094648},{"$f":"NPV(I4/100,C29-C21-C22,D29-D21-D22+$D$38)","v":1750.3594035937047},{"$f":"NPV(I4/100,C29-C21-C22,D29-D21-D22,E29-E21-E22+$E$38)","v":1623.0619194155779},{"$f":"NPV(I4/100,C29-C21-C22,D29-D21-D22,E29-E21-E22,F29-F21-F22+$F$38)","v":1564.340633137238},{"$f":"NPV(I4/100,C29-C21-C22,D29-D21-D22,E29-E21-E22,F29-F21-F22,G29-G21-G22+$G$38)","v":1557.8592699394355},{"$f":"NPV(I4/100,C29-C21-C22,D29-D21-D22,E29-E21-E22,F29-F21-F22,G29-G21-G22,H29-H21-H22+$H$38)","v":1551.1105288760443},{"$f":"NPV(I4/100,C29-C21-C22,D29-D21-D22,E29-E21-E22,F29-F21-F22,G29-G21-G22,H29-H21-H22,I29-I21-I22+$I$38)","v":1626.5483295155379},{"$f":"NPV(I4/100,C29-C21-C22,D29-D21-D22,E29-E21-E22,F29-F21-F22,G29-G21-G22,H29-H21-H22,I29-I21-I22,J29-J21-J22+$J$38)","v":1670.8541275827656}]
[null,"Over Total Costs (Net Profit)",{"$f":"NPV(I4/100,(C29-C25)+C38)","v":2759.9784233171576},{"$f":"NPV(I4/100,C29-C25,D29-D25+$D$38)","v":1338.9688710493263},{"$f":"NPV(I4/100,C29-C25,D29-D25,E29-E25+$E$38)","v":1011.8904355739759},{"$f":"NPV(I4/100,C29-C25,D29-D25,E29-E25,F29-F25+$F$38)","v":757.23013936951327},{"$f":"NPV(I4/100,C29-C25,D29-D25,E29-E25,F29-F25,G29-G25+$G$38)","v":558.57782412878248},{"$f":"NPV(I4/100,C29-C25,D29-D25,E29-E25,F29-F25,G29-G25,H29-H25+$H$38)","v":363.35372625405773},{"$f":"NPV(I4/100,C29-C25,D29-D25,E29-E25,F29-F25,G29-G25,H29-H25,I29-I25+$I$38)","v":253.94069617474335},{"$f":"NPV(I4/100,C29-C25,D29-D25,E29-E25,F29-F25,G29-G25,H29-H25,I29-I25,J29-J25+$J$38)","v":116.95048719083292}]
[]
[1,{"$f":"\"Yearly replacement value is calculated by adding the marginal returns from the current and each of the previous years and cull cow revenue in the current year at net present value (based on \"&I4&\"% annual investment cost)\"","v":"Yearly replacement value is calculated by adding the marginal returns from the current and each of the previous years and cull cow revenue in the current year at net present value (based on 4% annual investment cost)"}]
[]
[2,{"$f":"\"Costs estimates are increased annually by \"&I4/2&\"% inflation rate\"","v":"Costs estimates are increased annually by 2% inflation rate"}]
[]
["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 your local Manitoba Agriculture, Food and Rural Development (MAFRD) GO Office."]