{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Bull Cost per Cow","Sheet1"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":1,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Bull Cost per Cow","index":0,"n_rows":101,"n_cols":10,"rows_kept":101,"cut":false,"hidden":false,"merged":[[90,2,90,7],[43,1,43,8],[86,2,86,7],[1,0,2,8]]}
[]
["Bull Investment Cost Analysis\nTexas Agrilife Extension and Oklahoma State University\n\nOriginally developed by\nJames McGrann, Professor Emeritus, Texas A&M University and Christy Waggoner, Former Programmer, Texas A&M University\nUpdate by\nDamona Doye and Roger Sahs, Agricultural Economics, Oklahoma State University, and Lawrence Falconer, Mississippi State University\n"]
[]
[]
[null,"Purchase Price of Bull",null,null,3250]
[null,"Useful Life (Years)",null,null,4]
[null,null,null,null,"Wt. Lb./Hd.","$/cwt","  $/Head"]
[null,"Bull Salvage Value ",null,null,1800,93,{"$f":"E8*F8*0.01","v":1674}]
[null,"Interest Rate Used for Opportunity Cost",null,null,7,"%"]
[null,"Average Investment for Bull",null,null,null,null,{"$f":"(E5+G8)/2","v":2462}]
[]
[null,"Cows Exposed to Bull Annually",null,null,30]
[null,"Weaned Calf Crop %",null,null,90,"%"]
[null,"Average Weaning Weight",null,null,525,"Lb."]
[null,"Weaned Calf Price",null,null,170,"$/cwt"]
[null,"Calves Weaned Per Year",null,null,{"$f":"ROUND(+E12*E13*0.01,0)","v":27}]
[null,"Calves Weaned During Useful Life of Bull",null,null,{"$f":"E6*E16","v":108}]
[null,"Pounds Weaned per Exposed Female",null,null,{"$f":"ROUND(E13*E14*0.01,0)","v":473},"Lb.",{"$f":"E14*E15*0.01","v":892.5}]
[]
[null,"Operating Cost Item",null,null,"Annual Bull Cost",null,"Annual Bull Cost per Cow Exposed","Annual Bull Cost per Calf Weaned","Annual Bull Cost per Cwt. Weaned","Percent of Total Cost"]
[null,"Grazing and Supplemental Feed",null,null,475,null,{"$f":"ROUND(E21/$E$12,2)","v":15.83},{"$f":"ROUND(E21/$E$16,2)","v":17.59},{"$f":"ROUND(+H21/($E$14*0.01),2)","v":3.35}]
[null,"Veterinary Medicine",null,null,35,null,{"$f":"ROUND(E22/$E$12,2)","v":1.17},{"$f":"ROUND(E22/$E$16,2)","v":1.3},{"$f":"ROUND(+H22/($E$14*0.01),2)","v":0.25}]
[null,"Other Cost",null,null,0,null,{"$f":"ROUND(E23/$E$12,2)","v":0},{"$f":"ROUND(E23/$E$16,2)","v":0},{"$f":"ROUND(+H23/($E$14*0.01),2)","v":0}]
[null,"Annual Interest on 1/2 of Operating Cost",null,null,{"$f":"ROUND((SUM(E21:E23)*0.5*E9*0.01),2)","v":17.850000000000001},null,{"$f":"ROUND(E24/$E$12,2)","v":0.6},{"$f":"ROUND(E24/$E$16,2)","v":0.66},{"$f":"ROUND(+H24/($E$14*0.01),2)","v":0.13}]
[null,"Annual Operating Cost",null,null,{"$f":"SUM(E21:E24)","v":527.85},null,{"$f":"SUM(G21:G24)","v":17.600000000000001},{"$f":"SUM(H21:H24)","v":19.55},{"$f":"SUM(I21:I24)","v":3.73},{"$f":"E25/E33","v":0.46849621457543777}]
[]
[null,"Ownership Cost"]
[null,"Depreciation",null,null,{"$f":"ROUND((E5-G8)/E6,2)","v":394},null,{"$f":"ROUND(E28/$E$12,2)","v":13.13},{"$f":"ROUND(E28/$E$16,2)","v":14.59},{"$f":"ROUND(+H28/($E$14*0.01),2)","v":2.78}]
[null,"Average Annual Interest Cost*",null,null,{"$f":"ROUND(G10*E9*0.01,2)","v":172.34},null,{"$f":"ROUND(E29/$E$12,2)","v":5.74},{"$f":"ROUND(E29/$E$16,2)","v":6.38},{"$f":"ROUND(+H29/($E$14*0.01),2)","v":1.22}]
[null,"Death Loss (% of  Purchase Cost)",null,1,{"$f":"ROUND(E5*D30*0.01,2)","v":32.5},null,{"$f":"ROUND(E30/$E$12,2)","v":1.08},{"$f":"ROUND(E30/$E$16,2)","v":1.2},{"$f":"ROUND(+H30/($E$14*0.01),2)","v":0.23}]
[null,"Annual Ownership Cost",null,null,{"$f":"SUM(E28:E30)","v":598.84},null,{"$f":"SUM(G28:G30)","v":19.950000000000003},{"$f":"SUM(H28:H30)","v":22.169999999999998},{"$f":"SUM(I28:I30)","v":4.2300000000000004},{"$f":"E31/E33","v":0.53150378542456223}]
[]
[null,"Annual Total Cost",null,null,{"$f":"E25+E31","v":1126.69},null,{"$f":"G25+G31","v":37.550000000000004},{"$f":"H25+H31","v":41.72},{"$f":"I25+I31","v":7.9600000000000009}]
[]
[null,"-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Annual Bull Cost for Various Bull Purchase Prices"]
[]
[null,null,null,null,"Annual Bull Cost per Cow","Annual Bull Cost per Cwt. Weaned","Change in  Bull Cost per Cow","Pounds of Weaned Calf per Cow*"]
[null,"Purchase Price Increment",250,"per head"]
[null,"Price of Weaned Calf",{"$f":"E15","v":170},"per cwt"]
[null,null,null,null,"$/Cow","$/Cwt.","$/Cow","Lb."]
[null,"Bull Purchase Price",{"$f":"$C51-$C$47","v":2500},null,{"$f":"((($C50+$G$8)/2)*$E$9*0.01+$D$30*0.01*$C50+$E$25+($C50-$G$8)/$E$6)/$E$12","v":30.181333333333335},{"$f":"E50/$E$18*100","v":6.3808315715292467},{"$f":"E50-E53","v":-7.375},{"$f":"G50/($E$15*0.01)","v":-4.3382352941176467}]
[null,null,{"$f":"$C52-$C$47","v":2750},null,32.63966666666667,6.9005637773079638,{"$f":"E51-E53","v":-4.9166666666666643},{"$f":"G51/($E$15*0.01)","v":-2.8921568627450966}]
[null,null,{"$f":"$C53-$C$47","v":3000},null,35.097999999999999,7.4202959830866808,{"$f":"E52-E53","v":-2.4583333333333357},{"$f":"G52/($E$15*0.01)","v":-1.4460784313725505}]
[null,"Base Price",{"$f":"E5","v":3250},null,37.556333333333335,7.9400281888653987]
[null,null,{"$f":"$C53+$C$47","v":3500},null,40.01466666666667,8.4597603946441176,{"$f":"E54-E53","v":2.4583333333333357},{"$f":"G54/($E$15*0.01)","v":1.4460784313725505}]
[null,null,{"$f":"$C54+$C$47","v":3750},null,42.472999999999999,8.9794926004228319,{"$f":"E55-E53","v":4.9166666666666643},{"$f":"G55/($E$15*0.01)","v":2.8921568627450966}]
[null,null,{"$f":"$C55+$C$47","v":4000},null,44.931333333333335,9.4992248062015499,{"$f":"E56-E53","v":7.375},{"$f":"G56/($E$15*0.01)","v":4.3382352941176467}]
[]
[null,"*Change in pounds weaned per exposed female or percent weaned times average weaning weight"]
[]
[null,"---------------------------------------------------------------------------------------------------------------------------------------------------------------------------"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Sensitivity Analysis to Number of Cows Serviced"]
[]
[null,"Number of Cows Serviced Increment",null,10,"Head Annually"]
[]
[null,null,"Number of Cows Serviced Annually and Cost per Cow"]
[null,"Head Serviced Annually",null,{"$f":"E92-D89","v":10},{"$f":"(F92-D89)","v":20},{"$f":"E12","v":30},{"$f":"(F92+D89)","v":40},{"$f":"G92+D89","v":50}]
[null,null,"  $/Head",null,null,"$/Cow"]
[null,null,{"$f":"$C95-$C$47","v":2500},{"$f":"((($C94+$G$8)/2)*$E$9*0.01+0.01*$C94+$E$25+($C94-$G$8)/$E$6)/$D$92","v":90.544000000000011},{"$f":"((($C94+$G$8)/2)*$E$9*0.01+0.01*$C94+$E$25+($C94-$G$8)/$E$6)/$E$92","v":45.272000000000006},{"$f":"((($C94+$G$8)/2)*$E$9*0.01+0.01*$C94+$E$25+($C94-$G$8)/$E$6)/$F$92","v":30.181333333333335},{"$f":"((($C94+$G$8)/2)*$E$9*0.01+0.01*$C94+$E$25++($C94-$G$8)/$E$6)/G$92","v":22.636000000000003},{"$f":"((($C94+$G$8)/2)*$E$9*0.01+0.01*$C94+$E$25+($C94-$G$8)/$E$6)/H$92","v":18.108800000000002}]
[null,null,{"$f":"$C96-$C$47","v":2750},97.919000000000011,48.959500000000006,32.63966666666667,24.479750000000003,19.5838]
[null,null,{"$f":"$C97-$C$47","v":3000},105.29400000000001,52.647000000000006,35.097999999999999,26.323500000000003,21.058800000000002]
[null,"Base Purchase cost",{"$f":"E5","v":3250},112.66900000000001,56.334500000000006,37.556333333333335,28.167250000000003,22.533799999999999]
[null,null,{"$f":"$C97+$C$47","v":3500},120.04400000000001,60.022000000000006,40.01466666666667,30.011000000000003,24.008800000000001]
[null,null,{"$f":"$C98+$C$47","v":3750},127.41900000000001,63.709500000000006,42.472999999999999,31.854750000000003,25.483800000000002]
[null,null,{"$f":"$C99+$C$47","v":4000},134.79400000000001,67.397000000000006,44.931333333333335,33.698500000000003,26.9588]
[null,"-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"]

{"sheet":"Sheet1","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}