{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["PastureRental","Stocking Rate","Stocker Cattle Budget","CowCalf Budget"],"not_rendered":{"charts":2,"images":3,"macros":1,"external_links":2,"defined_names":11,"comments":0,"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":"PastureRental","index":0,"n_rows":48,"n_cols":12,"rows_kept":48,"cut":false,"hidden":false,"merged":[[43,15,43,16],[44,1,44,3],[4,1,5,8],[4,13,5,23],[7,2,7,3],[7,4,7,5],[7,13,8,13],[28,1,29,11],[47,1,48,11],[30,1,30,4],[31,1,32,11],[34,1,34,10],[39,1,40,11]]}
[]
[]
[null,"KSU-Budgeting for a Pasture Rental Rate"]
[]
[null,"An Excel spreadsheet for establishing a pasture rental rate based on budgeted income and party contributions"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Version- 2.10.2016"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"INTRODUCTION"]
[null,"This tool was developed to assist landowner and tenant in determining an equitable grazing lease by considering three levels of pasture productivity. All costs and services provided by each party are taken into consideration and pricing per acre, per head, per AUM, or per pound of gain are reported."]
[]
[null,"INSTRUCTIONS FOR THE USER:"]
[null,"Be sure to \"Enable Content\" and \"Enable Macros\" for the spreadsheet to function correctly.  Blue values are inputs that should be changed from the defaults to match your operation.  Black values are automatically calculated."]
[]
[]
[null,"The companion publication with full instructions and explanations can be found by clicking",null,null,null,null,null,null,null,null,null,"HERE"]
[]
[]
[]
[null,"FOR MORE INFORMATION:"]
[null,"Developed by:"]
[]
[null,"Robin Reid",null,null,null,null,null,"Mykel Taylor Ph.D. "]
[null,"Extension Associate",null,null,null,null,null,"Assistant Professor"]
[null,"Kansas State University",null,null,null,null,null,"Kansas State University"]
[null,"robinreid@ksu.edu",null,null,null,null,null,"mtaylor@ksu.edu"]
[null,"785-532-0964",null,null,null,null,null,"785-532-3033"]
[]
[null,"Copyright 2016 AgManager.info, K-State Department of Agricultural Economics"]

{"sheet":"Stocking Rate","index":1,"n_rows":33,"n_cols":9,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,0,0,8],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[10,7,10,8],[11,7,11,8],[12,7,12,8],[28,5,28,8],[27,0,27,3],[27,5,27,7],[8,6,8,7],[13,0,13,1],[17,5,17,8]]}
["Calculating a Stocking Rate"]
[]
["Inputs"]
["Grazing Period Start","2016-05-01"]
["Grazing Period End","2016-10-31"]
["Grazing Days",{"$f":"B5-B4","v":183}]
["Total Acres of Pasture",160]
[]
[null,null,"Unfavorable Year","Normal Year","Favorable Year",null,"Assumptions:"]
["Pounds of Production per Acre",null,2500,3500,4500]
["Pounds of Grazed Forage per Acre",null,{"$f":"C10*$G$11","v":625},{"$f":"D10*$G$11","v":875},{"$f":"E10*$G$11","v":1125},null,0.25,"Harvest Efficiency"]
["AUM's available/Acre",null,{"$f":"C11/G12","v":0.68493150684931503},{"$f":"D11/G12","v":0.95890410958904104},{"$f":"E11/G12","v":1.2328767123287672},null,912.5,"Pounds per AUM"]
["Total AUM's for pasture",null,{"$f":"C12*$B$7","v":109.58904109589041},{"$f":"D12*$B$7","v":153.42465753424656},{"$f":"E12*$B$7","v":197.26027397260276},null,0.03,"Forage Consumed per Day (Percent of Body Weight)"]
["Consumed pounds of forage on pasture",null,{"$f":"C11*$B$7","v":100000},{"$f":"D11*$B$7","v":140000},180000]
[]
[]
[]
[null,null,"Forage Consumed per Day (lbs)","Total Forage For Grazing Period (lbs)",null,"Ideal Stocking Rate"]
["COW/CALF PAIRS",null,{"$f":"G13*(B20+AVERAGE(B21:B22))","v":49.5},{"$f":"C19*B6","v":9058.5},null,null,"Unfavorable Year","Normal Year","Favorable Year"]
["Mature Cow Weight",1250,null,null,null,"Number of Cow/Calf Pairs",{"$f":"IF(B27>0,(C14/($D$19+$D$23*(1/$B$27))),(C14/D19))","v":10.881084974745001},{"$f":"IF(B27>0,(D14/($D$19+$D$23*(1/$B$27))),(D14/D19))","v":15.233518964643002},{"$f":"IF(B27>0,(E14/($D$19+$D$23*(1/$B$27))),(E14/D19))","v":19.585952954541003}]
["Calf Starting Weight",250,null,null,null,"Number of Bulls",{"$f":"IF(B27>0,(C14/($D$19+$D$23*(1/$B$27)))*(1/$B$27),0)","v":0.43524339898980002},{"$f":"IF(B27>0,(D14/($D$19+$D$23*(1/$B$27)))*(1/$B$27),0)","v":0.60934075858572012},{"$f":"IF(B27>0,(E14/($D$19+$D$23*(1/$B$27)))*(1/$B$27),0)","v":0.78343811818164011}]
["Calf Ending Weight",550]
["BULLS",null,{"$f":"G13*B24","v":54},{"$f":"C23*(B26-B25)","v":3294},null,"Acres per Cow/Calf Pair & Proportion of Bull",{"$f":"IF($B$27>0,($B$7/(G20+(1/$B$27)*G21)),$B$7/G20)","v":14.680926517571885},{"$f":"IF($B$27>0,($B$7/(H20+(1/$B$27)*H21)),$B$7/H20)","v":10.486376083979918},8.1560702875399365]
["Average Weight",1800]
["Date In","2016-06-01"]
["Date Out","2016-08-01"]
["# of Cows per Bull",25]
["OR",null,null,null,null,"OR"]
[null,null,"Forage Consumed per Day (lbs)","Total Forage For Grazing Period (lbs)",null,"Ideal Stocking Rate"]
["STOCKER CATTLE",null,{"$f":"(((B32+B31)/2)*G13)","v":22.5},{"$f":"C30*B6","v":4117.5},null,"Stocker Cattle",{"$f":"C14/$D$30","v":24.286581663630844},{"$f":"D14/$D$30","v":34.001214329083183},{"$f":"E14/$D$30","v":43.715846994535518}]
["Starting Weight",600]
["Ending Weight",900,null,null,null,"Acres per Stocker ",{"$f":"$B$7/G30","v":6.5880000000000001},{"$f":"$B$7/H30","v":4.7057142857142855},{"$f":"$B$7/I30","v":3.66}]
["Average Daily Gain",{"$f":"(B32-B31)/B6","v":1.639344262295082}]

{"sheet":"Stocker Cattle Budget","index":2,"n_rows":100,"n_cols":15,"rows_kept":100,"cut":false,"hidden":false,"merged":[[10,3,10,4],[47,0,47,8],[79,6,79,10],[85,7,85,10],[95,7,95,10],[55,7,55,10],[0,0,0,8],[7,9,8,9],[79,0,79,1],[2,7,2,9],[1,14,1,15],[4,9,5,9],[8,3,8,4],[9,3,9,4],[76,0,76,8],[2,0,2,4],[65,7,65,10],[13,11,13,12],[31,7,32,7],[31,8,32,8],[49,6,49,10],[49,0,49,4]]}
["Budgeting for Stocker Cattle Grazing-Inputs",null,null,null,null,null,null,null,null,null,null,null,null,null,"Internal Notes:"]
[]
["Inputs from Stocking Rate Page",null,null,null,null,null,null,"Expected Cattle Returns"]
["Grazing Period Start",{"$f":"'Stocking Rate'!B4","v":"2016-05-01"},null,null,null,null,null,null,null,"Per Head"]
["Grazing Period End",{"$f":"'Stocking Rate'!B5","v":"2016-10-31"},null,null,null,null,null,"Beginning Weight (lbs)",{"$f":"'Stocking Rate'!B31","v":600},{"$f":"-I5/100*I6","v":-1008}]
["Grazing Days",{"$f":"B5-B4","v":183},null,null,null,null,null,"Beginning Cost ($/cwt)",168]
["Total Acres of Pasture",{"$f":"'Stocking Rate'!B7","v":160},null,null,null,null,null,"Death Loss",0.01,{"$f":"J5*I7","v":-10.08}]
[null,null,null,null,null,null,null,"Ending Weight (lbs)",{"$f":"'Stocking Rate'!B32","v":900},{"$f":"I8/100*I9","v":1287}]
["Growing Season","Unfavorable","Normal","Favorable",null,null,null,"Expected Ending Price ($/cwt)",143]
["# of head",{"$f":"ROUND('Stocking Rate'!G30,0)","v":24},{"$f":"ROUND('Stocking Rate'!H30,0)","v":34},{"$f":"ROUND('Stocking Rate'!I30,0)","v":44}]
["Acres per Head",{"$f":"B7/B10","v":6.666666666666667},{"$f":"B7/C10","v":4.7058823529411766},{"$f":"B7/D10","v":3.6363636363636362},null,null,null,"Gross Income per head",null,{"$f":"SUM(J5:J9)","v":268.91999999999996}]
[]
["Livestock Costs"]
[null,null,null,null,null,null,null,null,"Total for Herd",null,null,"Cost Paid by"]
["Category:",null,null,null,null,null,null,"$/head","Unfavorable","Normal","Favorable","Producer %","Landowner %"]
["Harvested Forage",0,"per ton","x",0,"total lbs"," =",{"$f":"(B16/2000)*E16","v":0},{"$f":"H16*B10","v":0},{"$f":"H16*C10","v":0},{"$f":"H16*D10","v":0},1,{"$f":"1-L16","v":0}]
["Grain/Protein Supplements",150,"per ton","x",{"$f":"90*3","v":270},"total lbs"," =",{"$f":"(B17/2000)*E17","v":20.25},{"$f":"$H$17*B10","v":486},{"$f":"$H$17*C10","v":688.5},{"$f":"$H$17*D10","v":891},1,{"$f":"1-L17","v":0}]
["Mineral",550,"per ton","x",{"$f":"0.25*B6","v":45.75},"total lbs"," =",{"$f":"(B18/2000)*E18","v":12.581250000000001},{"$f":"$H$18*B10","v":301.95000000000005},{"$f":"$H$18*C10","v":427.76250000000005},{"$f":"$H$18*D10","v":553.57500000000005},1,0]
["Labor (towards cattle)",20,"per hour","x",1.2,"hours"," =",{"$f":"B19*E19","v":24},{"$f":"J19-(0.5*(J19-(H19*B10)))","v":696},{"$f":"$H$19*C10","v":816},{"$f":"J19+(0.5*((H19*D10)-J19))","v":936},1,0]
["Vet Medicine/Drugs",null,null,null,null,null,null,7,{"$f":"$H$20*B10","v":168},{"$f":"$H$20*C10","v":238},{"$f":"$H$20*D10","v":308},1,0]
["Marketing",null,null,null,null,null,null,11,{"$f":"$H$21*B10","v":264},{"$f":"$H$21*C10","v":374},{"$f":"$H$21*D10","v":484},1,0]
["Utilities,Gas, Fuel, Oil",null,null,null,null,null,null,6,{"$f":"J22-(0.5*(J22-(H22*B10)))","v":174},{"$f":"$H$22*C10","v":204},{"$f":"J22+(0.5*((H22*D10)-J22))","v":234},1,0]
["Machinery charge",null,null,null,null,null,null,{"$f":"10","v":10},{"$f":"J23-(0.5*(J23-(H23*B10)))","v":290},{"$f":"$H$23*C10","v":340},{"$f":"J23+(0.5*((H23*D10)-J23))","v":390},1,0]
["Cash Interest on Cattle Investment",{"$f":"-J5","v":1008},"purchased cost","x",0.05,"operating interest",null,{"$f":"B24*E24*(B6/365)","v":25.269041095890415},{"$f":"$H$24*B10","v":606.45698630136997},{"$f":"$H$24*C10","v":859.14739726027415},{"$f":"$H$24*D10","v":1111.8378082191782},1,0]
["Miscellaneous",null,null,null,null,null,null,2,{"$f":"$H$25*B10","v":48},{"$f":"$H$25*C10","v":68},{"$f":"$H$25*D10","v":88},1,0]
["Fixed Overhead","Total dollars",null,null,null,null,null,"--",{"$f":"SUM(B27:B29)","v":433.5},{"$f":"SUM(B27:B29)","v":433.5},{"$f":"SUM(B27:B29)","v":433.5},1,0]
["Taxes",42.5,null,null,null,null,null,"Total Costs",{"$f":"SUM(I16:I26)","v":3467.9069863013697},{"$f":"SUM(J16:J26)","v":4448.9098972602742},{"$f":"SUM(K16:K26)","v":5429.9128082191783}]
["Insurance",51,null,null,null,null,null,"Per Head",{"$f":"I27/B10","v":144.49612442922373},{"$f":"J27/C10","v":130.85029109589041},{"$f":"K27/D10","v":123.4071092777086}]
["Depreciation",340,null,null,null,null,null,"Per Head plus beg. Value",{"$f":"I28+-$J$5","v":1152.4961244292238},{"$f":"J28+-$J$5","v":1138.8502910958905},1131.4071092777085]
[]
["Land Costs"]
[null,null,null,null,null,null,null,"$/acre","Total for Pasture","Cost Paid by"]
["Category:",null,null,null,null,null,null,null,null,"Producer %","Landowner %"]
["Water Source Maintenance",null,null,null,null,null,null,0.89,{"$f":"H34*$B$7","v":142.4},0,{"$f":"1-J34","v":1}]
["Spraying Weeds",null,null,null,null,null,null,3.55,{"$f":"H35*$B$7","v":568},1,0]
["Fertilizer",null,null,null,null,null,null,0,0,1,0]
["Burning Pasture",null,null,null,null,null,null,0.56000000000000005,{"$f":"H37*$B$7","v":89.600000000000009},1,0]
["Maintaining Fence",null,null,null,null,null,null,2.84,{"$f":"H38*$B$7","v":454.4},1,0]
["New Fence Construction",null,null,null,null,null,null,2,{"$f":"H39*$B$7","v":320},0,1]
["Corrals",null,null,null,null,null,null,0.45,{"$f":"H40*$B$7","v":72},1,0]
["Other land costs",null,null,null,null,null,null,0,{"$f":"H41*$B$7","v":0},1,0]
["  Total Costs",null,null,null,null,null,null,{"$f":"SUM(H34:H41)","v":10.29},{"$f":"SUM(I34:I41)","v":1646.4}]
[]
["Interest on Land",2000,"Land Value per acre",null,0.01,"rent/value ratio","=",{"$f":"B44*E44","v":20},{"$f":"H44*B7","v":3200}]
[]
[]
[]
["Budgeting for Stocker Cattle Grazing -Results"]
[]
["Graphical Depiction of Rental Rates",null,null,null,null,null,"Budgeting a Rental Rate-Stocker Cattle"]
[null,null,null,null,null,null,null,null,"Unfavorable","Normal","Favorable"]
[null,null,null,null,null,null,"Producers Share of Cost",null,{"$f":"SUMPRODUCT(I16:I26,$L$16:$L$26)+SUMPRODUCT($I$34:$I$41,$J$34:$J$41)","v":4651.9069863013701},{"$f":"SUMPRODUCT(J16:J26,$L$16:$L$26)+SUMPRODUCT($I$34:$I$41,$J$34:$J$41)","v":5632.9098972602742},{"$f":"SUMPRODUCT(K16:K26,$L$16:$L$26)+SUMPRODUCT($I$34:$I$41,$J$34:$J$41)","v":6613.9128082191783}]
[null,null,null,null,null,null,"Gross Income",null,{"$f":"J11*B10","v":6454.079999999999},{"$f":"J11*C10","v":9143.2799999999988},{"$f":"J11*D10","v":11832.479999999998}]
[null,null,null,null,null,null,"Return over Producer Cost",null,{"$f":"I53-I52","v":1802.1730136986289},{"$f":"J53-J52","v":3510.3701027397246},{"$f":"K53-K52","v":5218.5671917808195}]
[]
[null,null,null,null,null,null,null,"Amount Producer Could Afford to Pay"]
[null,null,null,null,null,null,null,"Rent per Acre",{"$f":"I54/$B$7","v":11.263581335616431},{"$f":"J54/$B$7","v":21.939813142123278},{"$f":"K54/$B$7","v":32.616044948630119}]
[null,null,null,null,null,null,null,"Rent per Head",{"$f":"I54/B10","v":75.090542237442875},{"$f":"J54/C10","v":103.24617949234484},{"$f":"K54/D10","v":118.60379981320044}]
[null,null,null,null,null,null,null,"Rent per Pound of Gain",{"$f":"I54/(($I$8-$I$5)*B10)","v":0.2503018074581429},{"$f":"J54/(($I$8-$I$5)*C10)","v":0.34415393164114949},{"$f":"K54/(($I$8-$I$5)*D10)","v":0.39534599937733483}]
[null,null,null,null,null,null,null,"Rent per AUM",{"$f":"I54/'Stocking Rate'!C13","v":16.444828749999989},{"$f":"J54/'Stocking Rate'!D13","v":22.88009084821428},{"$f":"K54/'Stocking Rate'!E13","v":26.455236458333317}]
[]
[null,null,null,null,null,null,"Landowner Share of Cost",null,{"$f":"SUMPRODUCT(I16:I26,$M$16:$M$26)+SUMPRODUCT($I$34:$I$41,$K$34:$K$41)+$I$44","v":3662.4},{"$f":"SUMPRODUCT(J16:J26,$M$16:$M$26)+SUMPRODUCT($I$34:$I$41,$K$34:$K$41)+$I$44","v":3662.4},{"$f":"SUMPRODUCT(K16:K26,$M$16:$M$26)+SUMPRODUCT($I$34:$I$41,$K$34:$K$41)+$I$44","v":3662.4}]
[null,null,null,null,null,null,"Gross Income",null,{"$f":"I53","v":6454.079999999999},{"$f":"J53","v":9143.2799999999988},11832.479999999998]
[null,null,null,null,null,null,"Return over Landowner Cost",null,{"$f":"I63-I62","v":2791.6799999999989},{"$f":"J63-J62","v":5480.8799999999992},8170.0799999999981]
[]
[null,null,null,null,null,null,null,"Landowner Cost"]
[null,null,null,null,null,null,null,"Rent per Acre",{"$f":"I62/$B$7","v":22.89},{"$f":"J62/$B$7","v":22.89},22.89]
[null,null,null,null,null,null,null,"Rent per Head",{"$f":"I62/B10","v":152.6},{"$f":"J62/C10","v":107.71764705882353},{"$f":"K62/D10","v":83.236363636363635}]
[null,null,null,null,null,null,null,"Rent per Pound of Gain",{"$f":"I62/(($I$8-$I$5)*B10)","v":0.50866666666666671},{"$f":"J62/(($I$8-$I$5)*C10)","v":0.35905882352941176},{"$f":"K62/(($I$8-$I$5)*D10)","v":0.27745454545454545}]
[null,null,null,null,null,null,null,"Rent per AUM",{"$f":"I62/'Stocking Rate'!C13","v":33.419400000000003},{"$f":"J62/'Stocking Rate'!D13","v":23.871000000000002},{"$f":"K62/'Stocking Rate'!E13","v":18.566333333333333}]
[]
[]
[]
[]
[]
[]
["Budgeting for Stocker Cattle Grazing -Production Risk"]
[]
[]
["Production Variables",null,null,null,null,null,"Stocker Cattle Production Risk"]
["Death Loss","Normal",{"$f":"IF(B81=\"Normal\", I7, IF(B81=\"1% lower\", (MAX(I7-0.01,0)),IF(B81=\"5% lower\", (MAX(I7-0.05,0)),IF(B81=\"1% higher\", (I7+0.01),IF(B81=\"5% higher\", (I7+0.05),0)))))","v":0.01},null,null,null,null,null,"Unfavorable","Normal","Favorable"]
["Stocker Ending Weight","1% higher",{"$f":"IF(B82=\"Normal\",I8,IF(B82=\"1% lower\",(I8*0.99),IF(B82=\"5% lower\",(I8*0.95),IF(B82=\"1% higher\",(I8*1.01),IF(B82=\"5% higher\",(I8*1.05),FALSE)))))","v":909},null,null,null,"Producers Share of Cost",null,{"$f":"SUMPRODUCT(I16:I26,$L$16:$L$26)+SUMPRODUCT($I$34:$I$41,$J$34:$J$41)","v":4651.9069863013701},{"$f":"SUMPRODUCT(J16:J26,$L$16:$L$26)+SUMPRODUCT($I$34:$I$41,$J$34:$J$41)","v":5632.9098972602742},6613.9128082191783]
["Stocker Selling Price","5% lower",{"$f":"IF(B83=\"Normal\",I9,IF(B83=\"1% lower\",(I9*0.99),IF(B83=\"5% lower\",(I9*0.95),IF(B83=\"1% higher\",(I9*1.01),IF(B83=\"5% higher\",(I9*1.05),FALSE)))))","v":135.85},null,null,null,"Gross Income",null,{"$f":"($J$5+($C$81*$J$5)+($C$82*$C$83/100))*B10","v":5203.1159999999954},{"$f":"($J$5+($C$81*$J$5)+($C$82*$C$83/100))*C10","v":7371.0809999999938},9539.0459999999912]
[null,null,null,null,null,null,"Return over Producer Cost",null,{"$f":"I83-I82","v":551.20901369862531},{"$f":"J83-J82","v":1738.1711027397196},{"$f":"K83-K82","v":2925.1331917808129}]
[]
[null,null,null,null,null,null,null,"Amount Producer Could Afford to Pay"]
[null,null,null,null,null,null,null,"Rent per Acre",{"$f":"I84/$B$7","v":3.4450563356164081},{"$f":"J84/$B$7","v":10.863569392123248},{"$f":"K84/$B$7","v":18.282082448630081}]
[null,null,null,null,null,null,null,"Rent per Head",{"$f":"I84/B10","v":22.967042237442723},{"$f":"J84/C10","v":51.122679492344695},66.48029981320029]
[null,null,null,null,null,null,null,"Rent per Pound of Gain",{"$f":"I84/(($I$8-$I$5)*B10)","v":7.6556807458142404E-2},{"$f":"J84/(($I$8-$I$5)*C10)","v":0.17040893164114898},0.22160099937733432]
[null,null,null,null,null,null,null,"Rent per AUM",{"$f":"I84/'Stocking Rate'!C30","v":24.49817838660557},{"$f":"J84/'Stocking Rate'!D13","v":11.329150937499959},{"$f":"K84/'Stocking Rate'!E13","v":14.828800208333286}]
[]
[null,null,null,null,null,null,"Landowner Share of Cost",null,{"$f":"SUMPRODUCT(I16:I26,$M$16:$M$26)+SUMPRODUCT($I$34:$I$41,$K$34:$K$41)+$I$44","v":3662.4},{"$f":"SUMPRODUCT(J16:J26,$M$16:$M$26)+SUMPRODUCT($I$34:$I$41,$K$34:$K$41)+$I$44","v":3662.4},{"$f":"SUMPRODUCT(K16:K26,$M$16:$M$26)+SUMPRODUCT($I$34:$I$41,$K$34:$K$41)+$I$44","v":3662.4}]
[null,null,null,null,null,null,"Gross Income",null,{"$f":"I83","v":5203.1159999999954},{"$f":"J83","v":7371.0809999999938},9539.0459999999912]
[null,null,null,null,null,null,"Return over Landowner Cost",null,{"$f":"I93-I92","v":1540.7159999999953},{"$f":"J93-J92","v":3708.6809999999937},5876.6459999999915]
[]
[null,null,null,null,null,null,null,"Landowner Cost"]
[null,null,null,null,null,null,null,"Rent per Acre",{"$f":"I92/$B$7","v":22.89},{"$f":"J92/$B$7","v":22.89},22.89]
[null,null,null,null,null,null,null,"Rent per Head",{"$f":"I92/B10","v":152.6},{"$f":"J92/C10","v":107.71764705882353},{"$f":"K92/D10","v":83.236363636363635}]
[null,null,null,null,null,null,null,"Rent per Pound of Gain",{"$f":"I92/(($I$8-$I$5)*B10)","v":0.50866666666666671},{"$f":"J92/(($I$8-$I$5)*C10)","v":0.35905882352941176},0.27745454545454545]
[null,null,null,null,null,null,null,"Rent per AUM",{"$f":"I92/'Stocking Rate'!C13","v":33.419400000000003},{"$f":"J92/'Stocking Rate'!D13","v":23.871000000000002},{"$f":"K92/'Stocking Rate'!E13","v":18.566333333333333}]

{"sheet":"CowCalf Budget","index":3,"n_rows":75,"n_cols":15,"rows_kept":75,"cut":false,"hidden":false,"merged":[[1,12,1,13],[2,0,2,4],[2,7,2,9],[44,7,44,10],[7,9,8,9],[13,7,14,7],[13,8,14,8],[29,6,29,10],[62,7,62,10],[71,7,71,10],[0,0,0,8],[8,3,8,4],[9,3,9,4],[10,3,10,4],[56,0,56,1],[27,0,27,8],[29,0,29,4],[53,0,53,8],[56,6,56,10],[35,7,35,10]]}
["Budgeting for Cow/Calf Grazing- Inputs",null,null,null,null,null,null,null,null,null,null,null,"Internal Notes:"]
[]
["Inputs from Stocking Rate Page",null,null,null,null,null,null,"Expected Cattle Returns"]
["Grazing Period Start",{"$f":"'Stocking Rate'!B4","v":"2016-05-01"},null,null,null,null,null,null,null,"Per Head"]
["Grazing Period End",{"$f":"'Stocking Rate'!B5","v":"2016-10-31"},null,null,null,null,null,"Cow Yearly Cost (w/o pasture)",null,600,null,null,"Cow/Calf Livestock Budget"]
["Grazing Days",{"$f":"B5-B4","v":183},null,null,null,null,null,null,null,null,null,null,"$1,123.36 total cost +226 cull cow income + 158.8 pasture cost (leave heifer cost in)="]
["Total Acres of Pasture",{"$f":"'Stocking Rate'!B7","v":160},null,null,null,null,null,"Weaning Percentage",0.89,null,null,null,{"$f":"-1123.36+226+158.8","v":-738.56}]
[null,null,null,null,null,null,null,"Ending Weight (lbs)",{"$f":"'Stocking Rate'!B22","v":550},{"$f":"I8/100*I9*I7","v":763.62},null,null,"Pasture cost w/o taking heifer out 180.6/(1400+.16*750+.04*1800)"]
["Growing Season","Unfavorable","Normal","Favorable",null,null,null,"Expected Ending Price ($/cwt)",156,null,null,null,{"$f":"180.6/(1400+0.16*750+0.04*1800)","v":0.11344221105527638},"per pound"]
["# of head",{"$f":"ROUND('Stocking Rate'!G20,0)","v":11},{"$f":"ROUND('Stocking Rate'!H20,0)","v":15},{"$f":"ROUND('Stocking Rate'!I20,0)","v":20},null,null,null,null,null,null,null,null,{"$f":"M9*1400","v":158.81909547738692}]
["Acres per Head",{"$f":"B7/B10","v":14.545454545454545},{"$f":"B7/C10","v":10.666666666666666},{"$f":"B7/D10","v":8},null,null,null,"Gross Income per head",null,{"$f":"J8-J5","v":163.62}]
[]
["Land Costs"]
[null,null,null,null,null,null,null,"$/acre","Total for Pasture","Cost Paid by"]
["Category:",null,null,null,null,null,null,null,null,"Producer %","Landowner %"]
["Water Source Maintenance",null,null,null,null,null,null,0.89,{"$f":"H16*$B$7","v":142.4},0,{"$f":"1-J16","v":1}]
["Spraying Weeds",null,null,null,null,null,null,3.55,{"$f":"H17*$B$7","v":568},1,0]
["Fertilizer",null,null,null,null,null,null,0,0,1,0]
["Burning Pasture",null,null,null,null,null,null,0.56000000000000005,{"$f":"H19*$B$7","v":89.600000000000009},1,0]
["Maintaining Fence",null,null,null,null,null,null,1.47,{"$f":"H20*$B$7","v":235.2},1,0]
["New Fence Construction",null,null,null,null,null,null,2,{"$f":"H21*$B$7","v":320},0,1]
["Corrals",null,null,null,null,null,null,0.45,{"$f":"H22*$B$7","v":72},1,0]
["Other land costs",null,null,null,null,null,null,0,{"$f":"H23*$B$7","v":0},1,0]
["  Total Costs",null,null,null,null,null,null,{"$f":"SUM(H16:H23)","v":8.9199999999999982},{"$f":"SUM(I16:I23)","v":1427.2}]
[]
["Interest on Land",2000,"Land Value per acre",null,0.01,"rent/value ratio","=",{"$f":"B26*E26","v":20},{"$f":"H26*B7","v":3200}]
[]
["Budgeting for Cow/Calf Grazing -Results"]
[]
["Graphical Depiction of Rental Rates",null,null,null,null,null,"Budgeting a Rental Rate-Cow/Calf Pairs",null,null,null,null,null,null,null,"15% lower"]
[null,null,null,null,null,null,null,null,"Unfavorable","Normal","Favorable",null,null,null,"10% lower"]
[null,null,null,null,null,null,"Producers Share of Cost",null,{"$f":"SUMPRODUCT($I$16:$I$23,$J$16:$J$23)","v":964.8},{"$f":"SUMPRODUCT($I$16:$I$23,$J$16:$J$23)","v":964.8},{"$f":"SUMPRODUCT($I$16:$I$23,$J$16:$J$23)","v":964.8},null,null,null,"5% lower"]
[null,null,null,null,null,null,"Gross Income",null,{"$f":"J11*B10","v":1799.8200000000002},{"$f":"J11*C10","v":2454.3000000000002},{"$f":"J11*D10","v":3272.4},null,null,null,"Normal"]
[null,null,null,null,null,null,"Return over Producer Cost",null,{"$f":"I33-I32","v":835.02000000000021},{"$f":"J33-J32","v":1489.5000000000002},{"$f":"K33-K32","v":2307.6000000000004},null,null,null,"5% higher"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10% higher"]
[null,null,null,null,null,null,null,"Amount Producer Could Afford to Pay",null,null,null,null,null,null,"15% higher"]
[null,null,null,null,null,null,null,"Rent per Acre",{"$f":"I34/$B$7","v":5.2188750000000015},{"$f":"J34/$B$7","v":9.3093750000000011},{"$f":"K34/$B$7","v":14.422500000000003}]
[null,null,null,null,null,null,null,"Rent per Pair",{"$f":"I34/B10","v":75.910909090909115},{"$f":"J34/C10","v":99.300000000000011},{"$f":"K34/D10","v":115.38000000000002},null,null,null,"5% lower"]
[null,null,null,null,null,null,null,"Rent per AUM",{"$f":"I34/'Stocking Rate'!C13","v":7.6195575000000018},{"$f":"J34/'Stocking Rate'!D13","v":9.7083482142857171},{"$f":"K34/'Stocking Rate'!E13","v":11.69825},null,null,null,"1% lower"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Normal"]
[null,null,null,null,null,null,"Landowner Share of Cost",null,{"$f":"SUMPRODUCT($I$16:$I$23,$K$16:$K$23)+$I$26","v":3662.4},{"$f":"SUMPRODUCT($I$16:$I$23,$K$16:$K$23)+$I$26","v":3662.4},{"$f":"SUMPRODUCT($I$16:$I$23,$K$16:$K$23)+$I$26","v":3662.4},null,null,null,"1% higher"]
[null,null,null,null,null,null,"Gross Income",null,{"$f":"I33","v":1799.8200000000002},{"$f":"J33","v":2454.3000000000002},{"$f":"K33","v":3272.4},null,null,null,"5% higher"]
[null,null,null,null,null,null,"Return over Landowner Cost",null,{"$f":"I42-I41","v":-1862.58},{"$f":"J42-J41","v":-1208.0999999999999},-390]
[]
[null,null,null,null,null,null,null,"Landowner Cost"]
[null,null,null,null,null,null,null,"Rent per Acre",{"$f":"I41/$B$7","v":22.89},{"$f":"J41/$B$7","v":22.89},22.89]
[null,null,null,null,null,null,null,"Rent per Pair",{"$f":"I41/B10","v":332.94545454545454},{"$f":"J41/C10","v":244.16},{"$f":"K41/D10","v":183.12}]
[null,null,null,null,null,null,null,"Rent per AUM",{"$f":"I41/'Stocking Rate'!C13","v":33.419400000000003},{"$f":"J41/'Stocking Rate'!D13","v":23.871000000000002},{"$f":"K41/'Stocking Rate'!E13","v":18.566333333333333}]
[]
[]
[]
[]
[]
["Budgeting for Cow/Calf Grazing -Production Risk"]
[]
[]
["Production Variables",null,null,null,null,null,"Table 4: Budgeting a Rental Rate"]
["Weaning Percentage","5% lower",{"$f":"IF(B58=\"Normal\", I7, IF(B58=\"1% lower\", (I7-0.01),IF(B58=\"5% lower\", (I7-0.05),IF(B58=\"1% higher\", (I7+0.01),IF(B58=\"5% higher\", (I7+0.05),0)))))","v":0.84},null,null,null,null,null,"Unfavorable","Normal","Favorable"]
["Selling Calf Weight","5% higher",{"$f":"IF(B59=\"Normal\",I8,IF(B59=\"1% lower\",(I8*0.99),IF(B59=\"5% lower\",(I8*0.95),IF(B59=\"1% higher\",(I8*1.01),IF(B59=\"5% higher\",(I8*1.05),FALSE)))))","v":577.5},null,null,null,"Producers Share of Cost",null,{"$f":"SUMPRODUCT($I$16:$I$23,$J$16:$J$23)","v":964.8},{"$f":"SUMPRODUCT($I$16:$I$23,$J$16:$J$23)","v":964.8},{"$f":"SUMPRODUCT($I$16:$I$23,$J$16:$J$23)","v":964.8}]
["Selling Calf Price","5% higher",{"$f":"IF(B60=\"Normal\",I9,IF(B60=\"1% lower\",(I9*0.99),IF(B60=\"5% lower\",(I9*0.95),IF(B60=\"1% higher\",(I9*1.01),IF(B60=\"5% higher\",(I9*1.05),FALSE)))))","v":163.80000000000001},null,null,null,"Gross Income",null,{"$f":"(($C$58*$C$59*$C$60/100)-$C$61)*B10","v":2140.5318000000011},{"$f":"(($C$58*$C$59*$C$60/100)-$C$61)*C10","v":2918.9070000000015},3891.876000000002]
["Yearly Cow Cost","Normal",{"$f":"IF(B61=\"Normal\",J5,IF(B61=\"1% lower\",(J5*0.99),IF(B61=\"5% lower\",(J5*0.95),IF(B61=\"1% higher\",(J5*1.01),IF(B61=\"5% higher\",(J5*1.05),FALSE)))))","v":600},null,null,null,"Return over Producer Cost",null,{"$f":"I60-I59","v":1175.7318000000012},{"$f":"J60-J59","v":1954.1070000000016},{"$f":"K60-K59","v":2927.0760000000018}]
[]
[null,null,null,null,null,null,null,"Amount Producer Could Afford to Pay"]
[null,null,null,null,null,null,null,"Rent per Acre",{"$f":"I61/$B$7","v":7.3483237500000076},{"$f":"J61/$B$7","v":12.21316875000001},{"$f":"K61/$B$7","v":18.294225000000012}]
[null,null,null,null,null,null,null,"Rent per Pair",{"$f":"I61/B10","v":106.8847090909092},{"$f":"J61/C10","v":130.27380000000011},146.35380000000009]
[null,null,null,null,null,null,null,"Rent per AUM",{"$f":"I61/'Stocking Rate'!C13","v":10.72855267500001},{"$f":"J61/'Stocking Rate'!D13","v":12.736590267857155},{"$f":"K61/'Stocking Rate'!E13","v":14.838649166666674}]
[]
[null,null,null,null,null,null,"Landowner Share of Cost",null,{"$f":"SUMPRODUCT($I$16:$I$23,$K$16:$K$23)+$I$26","v":3662.4},{"$f":"SUMPRODUCT($I$16:$I$23,$K$16:$K$23)+$I$26","v":3662.4},{"$f":"SUMPRODUCT($I$16:$I$23,$K$16:$K$23)+$I$26","v":3662.4}]
[null,null,null,null,null,null,"Gross Income",null,{"$f":"I60","v":2140.5318000000011},{"$f":"J60","v":2918.9070000000015},{"$f":"K60","v":3891.876000000002}]
[null,null,null,null,null,null,"Return over Landowner Cost",null,{"$f":"I69-I68","v":-1521.868199999999},{"$f":"J69-J68","v":-743.49299999999857},229.47600000000193]
[]
[null,null,null,null,null,null,null,"Landowner Cost"]
[null,null,null,null,null,null,null,"Rent per Acre",{"$f":"I68/$B$7","v":22.89},{"$f":"J68/$B$7","v":22.89},22.89]
[null,null,null,null,null,null,null,"Rent per Pair",{"$f":"I68/B10","v":332.94545454545454},{"$f":"J68/C10","v":244.16},183.12]
[null,null,null,null,null,null,null,"Rent per AUM",{"$f":"I68/'Stocking Rate'!C13","v":33.419400000000003},{"$f":"J68/'Stocking Rate'!D13","v":23.871000000000002},{"$f":"K68/'Stocking Rate'!E13","v":18.566333333333333}]