{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Introduction","Table of Contents","CowCalf Spring","CowCalf Fall","Replacement Beef Heifer","Steer Backgrounding","Summer Grazing"],"not_rendered":{"charts":0,"images":17,"macros":1,"external_links":0,"defined_names":3,"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":53,"n_cols":5,"rows_kept":53,"cut":false,"hidden":false,"merged":[[23,0,23,10],[34,0,34,10],[26,0,26,10],[27,0,27,10],[8,2,8,7],[9,4,9,5],[31,0,31,10],[30,0,30,10],[37,0,37,10],[11,1,11,8],[18,0,18,10],[19,0,19,10],[20,0,20,10],[21,0,21,10],[12,2,12,7],[13,2,13,7],[24,0,24,10],[16,3,16,6],[15,3,15,6],[22,0,22,10],[32,0,32,10],[52,0,59,9],[14,2,14,7],[45,3,45,5],[44,3,44,5],[38,0,38,10],[39,0,39,10],[42,3,42,5],[43,3,43,5],[40,0,40,10],[33,0,33,10],[35,0,35,10],[36,0,36,10],[25,0,25,10],[28,0,28,10],[29,0,29,10]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Beef Enterprise Budgets"]
[]
[]
[null,"Richard Trimble  Kenneth Burdine  Greg Halich  "]
[null,null,"Lee Meyer      Steve Isaacs     "]
[]
[null,null,"Department of Agricultural Economics"]
[]
[]
[]
["This publication contains budgets for production of selected livestock enterprises in Kentucky.    "]
["The purpose of these budgets is to serve as a management and decision-making guide for current and "]
["prospective producers of these enterprises."]
["These budgets are not intended to replace a producer's own records and estimates.  "]
["Producers are strongly encouraged to adapt these budgets to their specific situation."]
["In the absence of such data, however, these budgets can serve as a reasonably accurate cost and income guide."]
[]
["These budget estimates are based on input cost information and livestock price projections available"]
["at the time of release.  Further, costs and returns are based on production practices and yield "]
["levels thought to be representative of typical producers in Kentucky given normal growing conditions and markets. This "]
["publication allows producers to change prices and quantities for easy adaptation of the budgets to their own farming "]
["situation."]
[]
["All of the blue numbers are input cells.  These are the numbers you can change.  Due to formulas, every cell  "]
["cannot be manipulated.  Also, remember that enterprise budgets are calculated on a per head basis."]
["Therefore, costs that are expressed on a per head basis have the quantity column fixed at 1 head."]
[]
["The budgets are listed on the Table of Contents page. There are instructions for navigating between budgets on"]
["that page."]
[]
["Users who desire to change budget formats or formulas must remove sheet protection first. The password to remove"]
["sheet protection is uk ."]
[]
[]
[null,null,null,"Questions or Comments?"]
[null,null,null,"Kenny Burdine"]
[null,null,null,"kburdine@uky.edu"]
[null,null,null,"University of Kentucky"]
[null,null,null,null,"Department of Agricultural Economics"]
[null,null,null,null,"415 Charles E. Barnhart Building"]
[null,null,null,null,"Lexington, KY 40546-0276"]
[null,null,null,null,"Phone: (859) 257-7273"]
[]
[]
["Educational programs of Kentucky Cooperative Extension serve all people regardless of economic or social status and will not discriminate on the basis of race, color, ethnic origin, national origin, creed, religion, political belief, sex, sexual orientation, gender identity, gender expression, pregnancy, marital status, genetic information, age, veteran status, physical or mental disability or reprisal or retaliation for prior civil rights activity. Reasonable accommodation of disability may be available with prior notice. Program information may be available in languages other than English. University of Kentucky, Kentucky State University, U.S. Department of Agriculture, and Kentucky Counties, Cooperating."]

{"sheet":"Table of Contents","index":1,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[9,3,9,9],[3,5,3,7],[5,3,5,9],[6,3,6,9],[7,3,7,9],[8,3,8,9]]}
[]
[]
[]
[null,null,null,null,null,"Table of Contents"]
[]
[null,null,null,"The boxes below contain links to each of the livestock budgets. Click on "]
[null,null,null,"the desired budget below, and it will take you to that particular budget."]
[null,null,null,"Once on the budget sheet, you can click on the Table of Contents button to"]
[null,null,null,"return to this page to select a different budget, or simply click on the name "]
[null,null,null,"of the budget along the bottom of the screen to navigate to a different budget."]

{"sheet":"CowCalf Spring","index":2,"n_rows":47,"n_cols":8,"rows_kept":47,"cut":false,"hidden":false,"merged":[[0,0,0,7],[4,0,4,2],[5,0,5,2],[6,0,6,2],[7,0,7,2],[41,0,41,4],[43,0,43,6],[48,0,48,7],[10,0,10,2],[39,0,39,1],[31,0,31,4],[33,0,33,2],[34,0,34,1],[35,0,35,1]]}
["COMMERCIAL COW-CALF BUDGET, SPRING CALVING HERD"]
[]
["Projected Costs and Returns per Cow",null,null,null,null,null,"",""]
[]
["  Calving Rate (live births/cow)",null,null,null,0.85,""]
["  Death Rate (birth to market)",null,null,null,0]
["  Cow Replacement Rate",null,null,null,0.15]
["  Breeding Herd Death Rate",null,null,null,0.01]
[]
[null,null,null,null,"AMOUNT","UNIT","PRICE","TOTAL"]
["Expected Returns per Cow"]
[null,"","Number","Weight","","","",""]
["Steer Calf",null,{"$f":"E5/2-((E5*E6)/2)","v":0.42499999999999999},575,{"$f":"C13*D13","v":244.375},"lb",2.4500000000000002,{"$f":"E13*G13","v":598.71875}]
["Heifer Calf",null,{"$f":"(E5/2-((E5*E6)/2)-E7)","v":0.27500000000000002},550,{"$f":"C14*D14","v":151.25},"lb",2.25,{"$f":"E14*G14","v":340.3125}]
["Cull Cow",null,{"$f":"E7-E8","v":0.13999999999999999},1300,{"$f":"C15*D15","v":181.99999999999997},"lb",0.8,{"$f":"E15*G15","v":145.6}]
["TOTAL RETURNS",null,null,null,"","","",{"$f":"SUM(H13:H15)","v":1084.6312499999999}]
[""]
["VARIABLE COSTS PER COW"]
["Pasture Maintenance",null,null,null,2,"acre",40,{"$f":"E19*G19","v":80}]
["Hay",null,"",null,2.5,"ton",90,{"$f":"E20*G20","v":225}]
["Grain",null,null,"",0,"lb",0,0]
["Salt and Mineral",null,null,"",91.25,"lb",0.4,36.5]
["Vet and Medical",null,null,"",1,"head",30,30]
["Breeding",null,"","",1,"head",50,50]
["Marketing",null,"","",1,"head",40,{"$f":"E25*G25","v":40}]
["Main of Replacement Heifer",null,null,null,{"$f":"E7","v":0.15},"head",{"$f":"'Replacement Beef Heifer'!H37","v":451.07499999999999},67.661249999999995]
["Mach & Equip (Fuel/Rep/Main)",null,null,null,1,"head",40,40]
["Other",null,null,"",1,"head",15,15]
["Interest on Operating Capital",null,null,null,{"$f":"SUM(H19:H28)","v":584.16125},"dollars",0.08,{"$f":"(9/12)*G29*E29","v":35.049675000000001}]
["Total Variable Costs Per Cow",null,null,null,null,null,null,{"$f":"SUM(H19:H29)","v":619.21092499999997}]
[]
["RETURN ABOVE VARIABLE COSTS PER COW",null,null,null,null,null,null,{"$f":"H16-H30","v":465.42032499999993}]
[]
["FIXED COSTS PER COW"]
["Depreciation",null,null,null,null,null,null,150]
["Taxes and Insurance",null,null,null,null,null,null,30]
["Operator / Family Labor",null,null,null,0,"hours",20,{"$f":"E37*G37","v":0}]
["Total Fixed Cost per Cow",null,null,null,null,null,null,{"$f":"SUM(H35:H37)","v":180}]
[]
["Total Cost per Cow",null,null,null,null,null,null,{"$f":"H30+H38","v":799.21092499999997}]
[]
["RETURN TO LAND, CAPITAL, AND MANAGEMENT",null,null,null,null,null,null,{"$f":"H32-H38","v":285.42032499999993}]
[]
["BREAKEVEN PRICES PER POUND TO COVER VARIABLE COSTS:"]
[null,"Cull Cows =",{"$f":"(H30/H16)*G15","v":0.45671627108291413}," Heifers =",{"$f":"(H30/H16)*G14","v":1.2845145124206958},"  Steers =",{"$f":"(H30/H16)*G13","v":1.3986935801914246}]
["BREAKEVEN PRICES PER POUND TO COVER ALL SPECIFIED COSTS:"]
[null,"Cull Cows =",{"$f":"(H40/H16)*G15","v":0.5894802865029013}," Heifers =",{"$f":"(H40/H16)*G14","v":1.65791330578941},"Steers =",{"$f":"(H40/H16)*G13","v":1.8052833774151353}]

{"sheet":"CowCalf Fall","index":3,"n_rows":47,"n_cols":8,"rows_kept":47,"cut":false,"hidden":false,"merged":[[10,0,10,2],[0,0,0,7],[4,0,4,2],[5,0,5,2],[6,0,6,2],[7,0,7,2],[48,0,48,7],[39,0,39,1],[41,0,41,4],[43,0,43,6],[31,0,31,4],[33,0,33,2]]}
["COMMERCIAL COW-CALF BUDGET, FALL CALVING HERD"]
[null,null,null,null,null,null,"",""]
["Projected Costs and Returns per Cow"]
[]
["  Calving Rate (live births/cow)",null,null,null,0.85]
["  Death Rate (birth to market)",null,null,null,0]
["  Cow Replacement Rate",null,null,null,0.15,""]
["  Breeding Herd Death Rate",null,null,null,0.01]
[]
[null,null,null,null,"AMOUNT","UNIT","PRICE","TOTAL"]
["Expected Returns per Cow"]
["","","Number","Weight",null,"","",""]
[" Steer Calf",null,{"$f":"E5/2-((E5*E6)/2)","v":0.42499999999999999},575,{"$f":"C13*D13","v":244.375},"lb",2.65,{"$f":"E13*G13","v":647.59375}]
[" Heifer Calf",null,{"$f":"(E5/2-((E5*E6)/2)-E7)","v":0.27500000000000002},550,{"$f":"C14*D14","v":151.25},"lb",2.4500000000000002,{"$f":"E14*G14","v":370.5625}]
[" Cull Cow",null,{"$f":"E7-E8","v":0.13999999999999999},1300,{"$f":"C15*D15","v":181.99999999999997},"lb",0.85,{"$f":"E15*G15","v":154.69999999999996}]
["TOTAL RETURNS",null,null,null,"","","",{"$f":"SUM(H13:H15)","v":1172.85625}]
[""]
["VARIABLE COSTS PER COW"]
["  Pasture Maintenance",null,null,null,2,"acre",40,{"$f":"E19*G19","v":80}]
["  Hay",null,"",null,3,"ton",90,270]
["  Grain",null,null,"",0,"lb",0,0]
["  Salt and Mineral",null,null,"",91.25,"lb",0.4,36.5]
["  Vet and Medical",null,null,"",1,"head",30,30]
["  Breeding",null,"","",1,"head",50,50]
["  Marketing",null,"","",1,"head",40,{"$f":"E25*G25","v":40}]
["  Main of Replacement Heifer",null,null,null,{"$f":"E7","v":0.15},"head",{"$f":"'Replacement Beef Heifer'!H37","v":451.07499999999999},67.661249999999995]
[" Mach & Equip (Fuel/Rep/Main)",null,null,null,1,"head",40,40]
["  Other",null,null,"",1,"head",15,15]
["  Interest on Operating Capital",null,null,null,{"$f":"SUM(H19:H28)","v":629.16125},"dollars",0.08,{"$f":"(10/12)*G29*E29","v":41.944083333333332}]
["Total Variable Costs per Cow",null,null,null,null,null,null,{"$f":"SUM(H19:H29)","v":671.10533333333331}]
[]
["RETURN ABOVE VARIABLE COSTS PER COW",null,null,null,null,null,null,{"$f":"H16-H30","v":501.75091666666674}]
[]
["FIXED COSTS PER COW"]
["  Depreciation",null,null,null,null,null,null,150]
["  Taxes and Insurance",null,null,null,null,null,null,30]
["  Operator / Family Labor",null,null,null,0,"hours",20,{"$f":"E37*G37","v":0}]
["Total Fixed Cost per Cow",null,null,null,null,null,null,{"$f":"SUM(H35:H37)","v":180}]
[]
["Total Cost per Cow",null,null,null,null,null,null,{"$f":"H30+H38","v":851.10533333333331}]
[]
["RETURN TO LAND, CAPITAL, AND MANAGEMENT",null,null,null,null,null,null,{"$f":"H16-H40","v":321.75091666666674}]
[]
["BREAKEVEN PRICES PER POUND TO COVER VARIABLE COSTS:"]
["     Cull Cows =",{"$f":"H30/H16*G15","v":0.48636781645946231}," Heifers =",{"$f":"H30/H16*G14","v":1.4018837062655092},"    Steers =",{"$f":"(H30/H16)*G13","v":1.5163231924912648}]
["BREAKEVEN PRICES PER POUND TO COVER ALL SPECIFIED COSTS:"]
["  Cull Cows =",{"$f":"(H40/H16)*G15","v":0.61681858568203329}," Heifers =",{"$f":"(H40/H16)*G14","v":1.7778888646129196},"  Steers =",{"$f":"(H40/H16)*G13","v":1.9230226494792801}]

{"sheet":"Replacement Beef Heifer","index":4,"n_rows":39,"n_cols":8,"rows_kept":39,"cut":false,"hidden":false,"merged":[[11,0,11,7],[13,0,13,1],[0,0,0,7],[1,0,1,5],[5,0,5,3],[12,0,12,2],[40,0,40,7],[33,0,33,2],[36,0,36,2],[26,0,26,4],[28,0,28,2],[29,0,29,1]]}
["REPLACEMENT BEEF HEIFER GROWTH AND MAINTENANCE "]
["BUDGET"]
["Weaning to 18 Months of Age"]
[]
[]
["Projected Costs and Returns per Head",null,null,null,null,null,"",""]
[]
["","","","","AMOUNT","UNIT","PRICE","TOTAL"]
["","","","","","","",""]
["EXPECTED RETURNS PER HEAD",null,null,null,null,"","","N/A"]
[]
[""]
["VARIABLE COSTS PER HEAD"]
["Pasture Maintenance",null,null,null,1,"acre",40,{"$f":"E14*G14","v":40}]
["Hay",null,"",null,1,"ton",90,{"$f":"E15*G15","v":90}]
["Grain",null,null,"",1000,"lb",0.14000000000000001,140]
["Soybean Oil Meal",null,null,null,0,"lb",0.2,0]
["Salt and Mineral",null,null,"",91.25,"lb",0.4,36.5]
["Vet and Medical",null,null,"",1,"head",50,50]
["Breeding",null,"","",1,"head",0,0]
["Mach & Equip (Fuel/Rep/Main)",null,null,null,1,"head",20,20]
["Other",null,null,"",1,"head",15,15]
["Interest on Operating Capital",null,null,null,{"$f":"SUM(H14:H22)","v":391.5},"dollars",0.05,{"$f":"G23*E23","v":19.575000000000003}]
["","","","","","","",""]
["TOTAL VARIABLE COSTS PER HEAD",null,null,null,null,null,null,{"$f":"SUM(H14:H23)","v":411.07499999999999}]
[]
["RETURN ABOVE VARIABLE COSTS PER HEAD",null,null,null,null,null,null,"N/A"]
[]
["FIXED COSTS PER HEAD"]
["Depreciation",null,null,null,null,null,null,30]
["Taxes and Insurance",null,null,null,null,null,null,10]
["Operator / Family Labor",null,null,null,0,"hours",20,{"$f":"E32*G32","v":0}]
[]
["TOTAL FIXED COST PER HEAD",null,null,null,null,null,null,{"$f":"SUM(H30:H32)","v":40}]
[]
[]
["TOTAL COST PER HEAD",null,null,null,null,null,null,{"$f":"H25+H34","v":451.07499999999999}]
["",null,null,null,null,null,null,""]
["RETURN TO LAND, CAPITAL, AND MANAGEMENT",null,null,null,null,null,null,"N/A"]

{"sheet":"Steer Backgrounding","index":5,"n_rows":51,"n_cols":7,"rows_kept":51,"cut":false,"hidden":false,"merged":[[52,0,52,6],[40,0,40,3],[50,0,50,3],[46,0,46,3],[48,0,48,2],[0,5,0,6],[31,0,31,1],[32,0,32,1],[9,0,9,1],[30,0,30,1],[23,0,23,1],[24,0,24,1],[21,4,21,6],[0,0,0,4],[21,0,21,2],[14,0,14,1],[28,0,28,1],[29,0,29,1],[25,0,25,1],[26,0,26,1],[27,0,27,1],[38,0,38,3],[35,0,35,3],[34,0,34,3],[36,0,36,3]]}
["STEER BACKGROUNDING BUDGET  "]
[]
["Projected Costs and Returns per Steer,"]
["Various Feeding Programs"]
[]
[]
[null,null,null,null,"Silage &","Corn & Hay","Corn & Hay"]
[null,null,null,null,"Protein","(limited)","(full feed)"]
[]
["Average Daily Gain (lbs)",null,null,null,2.1,1.5,2]
["Purch. Weight (lbs)",450]
["Sales Weight (lbs)",750]
["Days in Program",null,null,null,{"$f":"(B12-B11)/E10","v":142.85714285714286},{"$f":"($B$12-$B$11)/F10","v":200},{"$f":"(B12-B11)/G10","v":150}]
[]
["RATIONS AND FEED USES"]
["Feed/day (lbs)","Corn",null,null,0,3,7.5]
[null,"Alfalfa Hay"]
[null,"Mixed Hay",null,null,0,8.5,6]
[null,"Silage",null,null,40,0]
[null,"Soybean meal",null,null,1.5,0.5,1]
[]
["PRICES:",null,null,null,"    COST FOR WEIGHT GAINED"]
[]
["Stocker calf",null,2.65,null,{"$f":"+B11*C24","v":1192.5},{"$f":"+$B$11*$C$24","v":1192.5},{"$f":"+B11*C24","v":1192.5}]
["Corn",null,5,null,{"$f":"(C25/56)*E16*E13","v":0},{"$f":"($C$25/56)*F16*F13","v":53.571428571428569},{"$f":"(C25/56)*G16*G13","v":100.44642857142858}]
["Hay",null,90,null,{"$f":"(C26/2000)*E18*E13","v":0},{"$f":"(C26/2000)*F18*F13","v":76.5},{"$f":"(C26/2000)*G18*G13","v":40.5}]
["Silage",null,35,null,{"$f":"(C27/2000)*E19*E13","v":100.00000000000001},{"$f":"(C27/2000)*F19*F13","v":0},{"$f":"(C27/2000)*G19*G13","v":0}]
["SBM",null,0.18,null,{"$f":"(C28*E20*E13)","v":38.571428571428577},{"$f":"(C28*F20*F13)","v":18},{"$f":"(C28*G20*G13)","v":27}]
["Misc/day (hay)",null,0.1,null,null,{"$f":"+$C$29*F13","v":20},{"$f":"+C29*G13","v":15}]
["Misc/day (silage)",null,0.15,null,{"$f":"C30*E13","v":21.428571428571427}]
["Misc/head (med, imp.etc.)",null,10,null,{"$f":"C31","v":10},{"$f":"C31","v":10},{"$f":"C31","v":10}]
["Interest (calf)",null,0.08,null,{"$f":"(E13/365)*C32*E24","v":37.338551859099809},{"$f":"(F13/365)*$C$32*F24","v":52.273972602739725},{"$f":"(G13/365)*C32*G24","v":39.205479452054789}]
["Death Loss (%)",null,0.02,null,{"$f":"+C33*(E24+E31)","v":24.05},{"$f":"+$C$33*(F24+F31)","v":24.05},{"$f":"+C33*(G24+G31)","v":24.05}]
[]
["Feed Cost per Day",null,null,null,{"$f":"SUM(E25:E28)/E13","v":0.97000000000000008},{"$f":"SUM(F25:F28)/F13","v":0.74035714285714282},{"$f":"SUM(G25:G28)/G13","v":1.1196428571428572}]
["Feed Cost - Total",null,null,null,{"$f":"SUM(E25:E28)","v":138.57142857142858},{"$f":"SUM(F25:F28)","v":148.07142857142856},{"$f":"SUM(G25:G28)","v":167.94642857142858}]
["Feed Cost/lb gain",null,null,null,{"$f":"+E36/(B12-B11)","v":0.46190476190476193},{"$f":"+F36/($B$12-$B$11)","v":0.49357142857142849},{"$f":"+G36/(B12-B11)","v":0.55982142857142858}]
[]
["TOTAL COST",null,null,null,{"$f":"SUM(E24:E33)","v":1423.8885518590998},{"$f":"SUM(F24:F33)","v":1446.8954011741685},{"$f":"SUM(G24:G33)","v":1448.7019080234834}]
[]
["Non-calf costs",null,null,null,{"$f":"E39-E24","v":231.38855185909983},{"$f":"F39-F24","v":254.39540117416846},{"$f":"G39-G24","v":256.20190802348338}]
["Cash Costs (feed,misc)",null,null,null,{"$f":"E25+E26+E27+E28+E31","v":148.57142857142858},{"$f":"F25+F26+F27+F28+F31","v":158.07142857142856},{"$f":"G25+G26+G27+G28+G31","v":177.94642857142858}]
["All cash costs",null,null,null,{"$f":"E24+E42","v":1341.0714285714287},{"$f":"F24+F42","v":1350.5714285714284},{"$f":"G24+G42","v":1370.4464285714287}]
["COST / POUND OF GAIN",null,null,null,{"$f":"(E39-E24)/(B12-B11)","v":0.77129517286366611},{"$f":"(F39-F24)/($B$12-$B$11)","v":0.84798467058056148},{"$f":"(G39-G24)/(B12-B11)","v":0.8540063600782779}]
["SELLING PRICE",null,2.2999999999999998,null,{"$f":"C45*B12","v":1724.9999999999998},{"$f":"$C$45*$B$12","v":1724.9999999999998},{"$f":"C45*B12","v":1724.9999999999998}]
[]
["Returns over listed expenses:",null,null,null,{"$f":"+E45-E39","v":301.11144814089994},{"$f":"+F45-F39","v":278.10459882583132},{"$f":"+G45-G39","v":276.29809197651639}]
[]
["Breakeven",null,null,null,{"$f":"E39/B12","v":1.8985180691454664},{"$f":"F39/$B$12","v":1.9291938682322247},{"$f":"G39/B12","v":1.9316025440313112}]
[]
["Cash cost breakeven",null,null,null,{"$f":"E43/B12","v":1.7880952380952382},{"$f":"F43/$B$12","v":1.8007619047619046},{"$f":"G43/B12","v":1.827261904761905}]

{"sheet":"Summer Grazing","index":6,"n_rows":50,"n_cols":6,"rows_kept":50,"cut":false,"hidden":false,"merged":[[21,10,21,12],[23,10,23,12],[55,9,55,14],[46,0,46,2],[36,0,36,1],[24,10,24,12],[28,9,28,10],[30,10,30,11],[18,10,18,12],[11,10,11,12],[1,9,1,10],[3,10,3,12],[0,0,0,1]]}
["SUMMER GRAZING BUDGET"]
[]
["Projected Costs and Returns per Calf and Herd Total   "]
[]
[]
[]
["Buy Date:",null,"2024-04-15","Sell Date:","2024-10-15"]
[]
[]
["Avg. Daily Gain    ",1.4,"lbs"]
["Days in program    ",{"$f":"E7-C7","v":183},"days"]
["Sale Weight    ",{"$f":"B24+B11*B10","v":706.2},"lbs"]
["Weight Gain    ",{"$f":"B10*B11","v":256.2},"lbs"]
["Death Loss    ",0.02]
["Number of Cattle    ",60,"head"]
["Pasture-acres used    ",60,"acres"]
["Stocking Rate   ",{"$f":"B16/B15","v":1},"ac/hd"]
[]
["Expected Returms","AMOUNT","UNIT","PRICE","PER CALF","HERD TOTAL"]
["Feeder Calf",{"$f":"B12","v":706.2},"lbs",2.2999999999999998,{"$f":"B20*D20","v":1624.26},{"$f":"E20*B15","v":97455.6}]
["TOTAL RETURNS",null,null,null,{"$f":"SUM(E20:E20)","v":1624.26},{"$f":"SUM(F20:F20)","v":97455.6}]
[]
["VARIABLE COSTS"]
["Purchase of  Feeder Calf",450,"lbs",2.7,{"$f":"B24*D24","v":1215},{"$f":"E24*B15","v":72900}]
["Pasture Maintenance",{"$f":"B17","v":1},"acre",45,45,{"$f":"E25*B15","v":2700}]
["Hay",0,"ton",90,0,{"$f":"E26*B15","v":0}]
["Grain",0,"lbs",0.1,0,{"$f":"E27*B15","v":0}]
["Salt and Mineral",50,"lbs",0.4,20,{"$f":"E28*B15","v":1200}]
["Vet and Medical",1,"head",30,30,{"$f":"E29*B15","v":1800}]
["Marketing",1,"head",{"$f":"SUM(5+0.025*(E21))","v":45.606500000000004},45.606500000000004,{"$f":"E30*B15","v":2736.3900000000003}]
["Mach & Equip (Fuel/Rep/Main)",1,"head",20,20,{"$f":"E31*B15","v":1200}]
["Death Loss Expense",null,null,null,{"$f":"B14*(E24+E29)","v":24.900000000000002},{"$f":"B14*(F24+F29)","v":1494}]
["Other",1,"head",10,{"$f":"B33*D33","v":10},{"$f":"E33*B15","v":600}]
["Interest on Operating Capital",{"$f":"SUM(E24:E29)","v":1310},"dollars",0.08,{"$f":"(B11/365)*D34*B34","v":52.543561643835631},{"$f":"E34*B15","v":3152.6136986301381}]
["TOTAL VARIABLE COSTS:",null,null,null,{"$f":"SUM(E24:E34)","v":1463.0500616438358},{"$f":"SUM(F24:F34)","v":87783.003698630142}]
[]
["RETURN ABOVE VARIABLE COSTS",null,null,null,{"$f":"E21-E35","v":161.20993835616423},{"$f":"F21-F35","v":9672.5963013698638}]
[]
["FIXED COSTS"]
["Depreciation",null,null,null,30,{"$f":"E40*B15","v":1800}]
["Taxes/Insurance",null,null,null,15,{"$f":"E41*B15","v":900}]
["Operator/Family Labor",1,"hours",10,{"$f":"B42*D42","v":10},{"$f":"E42*B15","v":600}]
["TOTAL FIXED COSTS",null,null,null,{"$f":"SUM(E40:E42)","v":55},{"$f":"SUM(F40:F42)","v":3300}]
[]
["TOTAL COST",null,null,null,{"$f":"E35+E43","v":1518.0500616438358},{"$f":"F35+F43","v":91083.003698630142}]
[]
["RETURN TO LAND, CAPITAL, AND MANAGEMENT",null,null,null,{"$f":"E21-E45","v":106.20993835616423},{"$f":"F21-F45","v":6372.5963013698638}]
[]
[null,"Breakeven Price to cover variable costs",null,null,{"$f":"E35/B12","v":2.0717219791048365}]
[null,"Breakeven Price to cover all costs",null,null,{"$f":"E45/B12","v":2.1496035990425315}]