{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Main","Yardage","FeederMarketing","FinishedMarketing","Cost of gain","BrEv COG","BrEv Feeder","BrEv Finished"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Main","index":0,"n_rows":31,"n_cols":10,"rows_kept":31,"cut":false,"hidden":false,"merged":[[15,1,15,3],[0,2,0,3],[2,1,2,3],[20,3,20,5],[24,3,24,7]]}
["Breakeven Prices","Date:",{"$f":"TODAY()","v":"2015-10-18"}]
["Created: 20 February 2012","Copyright © 2015 by Michael L. Thonney"]
["Updated:","2015-10-18"]
["Cells in green can be changed."]
[]
["Terminal market feeder lamb price:",2.6,"/lb"]
["Terminal market finished price:",2.2599999999999998,"/lb"]
[]
["Feeder lamb price per pound:",2.9609989439275823,"Initial wt:",65,"lb"]
["Finished lamb price per pound:",2.2599999999999998,"Final wt:",100,"lb"]
["Price of feed, $/ton:",300,"Gain:",{"$f":"D10-D9","v":35},"lb"]
["Feed/gain:",4,"Death loss:",0.02]
["ADG, lb/day:",0.6,"Gained:",0.25,"(Proportion of possible gain made before death.)"]
["Days fed:",{"$f":"(D10-D9)/B13","v":58.333333333333336},"Interest rate:",0.05,"per year on feeder lamb value"]
[]
[null,"Break even costs (in red)"]
["Pound of gain:",{"$f":"'BrEv COG'!B13","v":0.93837033657818225},{"$f":"'Cost of gain'!B12","v":0.93837033657818159},{"$f":"C17","v":0.93837033657818159},{"$f":"\"=> Sell finished lambs at Finished lamb price if cost of gain is less than $\" & FIXED(B17,2) &\"/pound.\"","v":"=> Sell finished lambs at Finished lamb price if cost of gain is less than $0.94/pound."}]
["Pound of feeder lamb:",{"$f":"B9","v":2.9609989439275823},{"$f":"'BrEv Feeder'!B13","v":2.9609989439275828},{"$f":"B18","v":2.9609989439275823},{"$f":"\"=> Sell feeders at Feeder lamb price  if expected price is equal to or greater than $\" & FIXED(C18,2) &\"/pound.\"","v":"=> Sell feeders at Feeder lamb price  if expected price is equal to or greater than $2.96/pound."}]
["Pound of finished lamb:",{"$f":"B10","v":2.2599999999999998},{"$f":"B19","v":2.2599999999999998},{"$f":"'BrEv Finished'!B14","v":2.2599999999999993},{"$f":"\"=> Sell finished lambs at Finished lamb price if expected price is more than $\" & FIXED(D19,2) &\"/pound.\"","v":"=> Sell finished lambs at Finished lamb price if expected price is more than $2.26/pound."}]
[]
["Number of feeders:",60,"Per lamb","Farm price discount for feeders:",null,null,0,"/lb (off Terminal market price)"]
["Value if sold as feeders:",{"$f":"(B18-B27)*D9*B21","v":9623.6062931858141},{"$f":"B22/B$21","v":160.39343821976357},null,null,"Farm price discount for finished:",0,null,"Value","Per lamb"]
["Value if sold as finished:",{"$f":"((B19-B31)*(1-D12)*D10-D11*B30)*B21","v":9623.6062931858178},{"$f":"B23/B$21","v":160.39343821976362},null,null,"Farm feeder price:",{"$f":"B6-G21","v":2.6},"/lb",{"$f":"G23*D9*B21","v":10140},{"$f":"I23/B21","v":169}]
["Profit from marketing finished lambs:",{"$f":"B23-B22","v":0},{"$f":"C23-C22","v":0},null,null,"Farm finished price:",{"$f":"B7-G22","v":2.2599999999999998},"/lb",{"$f":"G24*D10*B21","v":13559.999999999998},{"$f":"I24/B21","v":225.99999999999997}]
[null,null,null,"Difference (finished lambs minus feeder lambs):",null,null,null,null,{"$f":"I24-I23","v":3419.9999999999982},{"$f":"J24-J23","v":56.999999999999972}]
[]
["Cost of marketing feeder lambs:",{"$f":"FeederMarketing!C12","v":0.49340758670045054},"/lb marketed (see FeederMarketing sheet)"]
["Yardage:",{"$f":"Yardage!B8","v":0.29142857142857143},"/lb (see Yardage sheet)"]
["Feed cost of gain:",{"$f":"'Cost of gain'!B8","v":0.60299999999999987},"/lb (includes Yardage; see Cost of gain sheet)"]
["Total cost of gain:",{"$f":"'Cost of gain'!B12","v":0.93837033657818159},"/lb (see Cost of gain sheet)"]
["Cost of marketing finished lambs:",{"$f":"FinishedMarketing!C12","v":0.28820000000000001},"/lb marketed (see FinishedMarketing sheet)"]

{"sheet":"Yardage","index":1,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[6,3,6,6],[2,3,3,5],[5,3,5,4]]}
["Yardage cost"]
["Cells in green can be changed."]
["Yardage:",10000,"per year","Yardage covers cost of management, labor, bedding, capital equipment."]
["Lambs:",1000,"per year"]
["Yardage:",{"$f":"B3/B4","v":10},"/lamb per head of capacity"]
["Yardage:",{"$f":"B5/Main!B14","v":0.17142857142857143},"/lamb/day","(No death losses.)"]
["Yardage:",{"$f":"B6+B6*Main!D12","v":0.17485714285714285},"/lamb/day","(Includes death losses.)"]
["Yardage",{"$f":"B7/Main!B13","v":0.29142857142857143},"/lb gain","(Includes death losses.)"]

{"sheet":"FeederMarketing","index":2,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Feeder marketing costs"]
["Cells in green can be changed."]
["Shrinkage",0.1]
["Shrink",{"$f":"B3*Main!D9","v":6.5},"lb"]
[null,null,"Per lb marketed"]
["Shrinkage cost",{"$f":"B4*Main!B9","v":19.246493135529285},{"$f":"B6/Main!D$9","v":0.29609989439275824},"/lb marketed"]
["Commision",5,{"$f":"B7/Main!D$9","v":7.6923076923076927E-2},"/lb marketed"]
["Feed at yards",0.5,{"$f":"B8/Main!D$9","v":7.6923076923076927E-3},"/lb marketed"]
["Trucking",7,{"$f":"B9/Main!D$9","v":0.1076923076923077},"/lb marketed"]
["Checkoff per pound",null,5.0000000000000001E-3,"($0.005 per pound marketed)"]
[]
[null,"Total:",{"$f":"SUM(C6:C10)","v":0.49340758670045054},"/lb marketed"]
[null,"Amount:",{"$f":"C12*Main!D9","v":32.071493135529288}]

{"sheet":"FinishedMarketing","index":3,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Finished marketing costs"]
["Cells in green can be changed."]
["Shrinkage",7.0000000000000007E-2]
["Shrink",{"$f":"B3*Main!D10","v":7.0000000000000009},"lb"]
[null,null,"Per lb marketed"]
["Shrinkage cost",{"$f":"B4*Main!B10","v":15.82},{"$f":"B6/Main!D$10","v":0.15820000000000001},"/lb marketed"]
["Commision",5,{"$f":"B7/Main!D$10","v":0.05},"/lb marketed"]
["Feed at yards",0.5,{"$f":"B8/Main!D$10","v":5.0000000000000001E-3},"/lb marketed"]
["Trucking",7,{"$f":"B9/Main!D$10","v":7.0000000000000007E-2},"/lb marketed"]
["Checkoff per pound",null,5.0000000000000001E-3,"($0.005 per pound marketed)"]
[]
[null,"Total:",{"$f":"SUM(C6:C10)","v":0.28820000000000001},"/lb marketed"]

{"sheet":"Cost of gain","index":4,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Cost of gain"]
[]
["Feed price/ton",{"$f":"Main!B11","v":300}]
["Price",{"$f":"B3/2000","v":0.15},"/lb feed"]
["Feed/gain",{"$f":"Main!B12","v":4},"(No death loss.)"]
["Feed cost",{"$f":"B4*B5","v":0.6},"/lb gain"]
["Feed/gain",{"$f":"B5+B5*Main!D12*Main!D13","v":4.0199999999999996},"(With death loss.)"]
["Feed cost/gain",{"$f":"B4*B7","v":0.60299999999999987},"/lb gain (all feed charged to marketed lambs)"]
["Yardage/lb gain",{"$f":"Yardage!B8","v":0.29142857142857143},"(With death loss. See Yardage sheet.)"]
["Interest on feeder lamb",{"$f":"Main!B9*Main!D9*Main!B14*Main!D14/365","v":1.5379617802363585},"(per days fed)"]
["Interest on feeder lamb",{"$f":"B10/Main!D11","v":4.3941765149610242E-2},"/lb gain"]
["Total cost",{"$f":"B8+B9+B11","v":0.93837033657818159},"/lb gain"]

{"sheet":"BrEv COG","index":5,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Break-even cost of gain"]
[]
["NH value of finished lambs",{"$f":"Main!B19*Main!D10","v":225.99999999999997}]
["minus",{"$f":"Main!D10*Main!B10*Main!D12","v":4.5199999999999996},"(loss of lamb weight due to death losses)"]
["minus",{"$f":"(Main!D10-Main!D10*Main!D12)*Main!B31","v":28.243600000000001},"(Cost of marketing)"]
["equals",{"$f":"B3-B4-B5","v":193.23639999999995},"(minimum farm value of finished lamb)"]
[]
["NH value of feeder lambs",{"$f":"Main!B9*Main!D9","v":192.46493135529286}]
["minus",{"$f":"Main!D9*Main!B27","v":32.071493135529288},"(Cost of marketing)"]
["equals",{"$f":"B8-B9","v":160.39343821976357},"(minimum farm value of feeder lamb)"]
[]
["Net value",{"$f":"B6-B10","v":32.842961780236379}]
["Value per pound of gain",{"$f":"B12/Main!D11","v":0.93837033657818225}]

{"sheet":"BrEv Feeder","index":6,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Break-even value of feeder lambs"]
[]
["NH value of finished lambs",{"$f":"Main!B19*Main!D10","v":225.99999999999997}]
["minus",{"$f":"Main!D10*Main!B10*Main!D12","v":4.5199999999999996},"(loss of lamb weight due to death losses)"]
["minus",{"$f":"(Main!D10-Main!D10*Main!D12)*Main!B31","v":28.243600000000001},"(Cost of marketing)"]
["equals",{"$f":"B3-B4-B5","v":193.23639999999995},"(minimum farm value of finished lamb)"]
[]
["Cost of gain",{"$f":"Main!B30*Main!D11","v":32.842961780236358}]
[]
["Break-even value of feeder lamb",{"$f":"B6-B8","v":160.3934382197636}]
["plus",{"$f":"Main!D9*Main!B27","v":32.071493135529288},"(Cost of marketing; include because we want the potential value of the lamb)"]
["equals",{"$f":"B10+B11","v":192.46493135529289},"(maximum farm value of feeder lambs to break even selling finished lambs)"]
["Feeder lamb value per pound",{"$f":"B12/Main!D9","v":2.9609989439275828}]

{"sheet":"BrEv Finished","index":7,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Break-even value of finished lambs"]
[]
["NH value of feeder lambs",{"$f":"Main!B9*Main!D9","v":192.46493135529286}]
["minus",{"$f":"Main!D9*Main!B27","v":32.071493135529288},"(Cost of marketing)"]
["equals",{"$f":"B3-B4","v":160.39343821976357},"(minimum farm value of feeder lambs)"]
[]
["Cost of gain",{"$f":"Main!B30*Main!D11","v":32.842961780236358}]
[]
["Break-even value of finished lamb",{"$f":"B5+B7","v":193.23639999999992}]
["plus",{"$f":"Main!B10*Main!D10*Main!D12","v":4.5199999999999996},"(death loss)"]
["plus",{"$f":"Main!D10*Main!B31","v":28.82},"(Cost of marketing)"]
["minus",{"$f":"B11*Main!D12","v":0.57640000000000002},"(No marketing cost for dead lambs)"]
["equals",{"$f":"B9+B10+B11-B12","v":225.99999999999991},"(minimum farm value of finished lambs to break even)"]
["per pound",{"$f":"B13/Main!D10","v":2.2599999999999993}]