{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Introduction","Summary","Risk Analysis","Input","Details","Breakeven"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":42,"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":"Introduction","index":0,"n_rows":46,"n_cols":10,"rows_kept":46,"cut":false,"hidden":false,"merged":[[29,1,34,10],[45,1,47,10],[4,0,4,10],[5,0,5,10],[6,0,6,10],[7,0,7,10],[14,1,21,10],[22,1,27,10]]}
[]
[]
[". . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . "]
[]
["Guidelines For Estimating"]
["Bison Bull Finishing Costs"]
[{"$f":"\"For Weight Range of  \"&Input!E7& \" -\"&Input!E9& \" lbs\"","v":"For Weight Range of  750 -1100 lbs"}]
[{"$f":"\"Based on \"&Input!E5&\" Head\"","v":"Based on 300 Head"}]
[]
[]
[null,null,null,null,null,null,null,"Date:",null,"October, 2022"]
[]
[]
[]
[null,"This guide is designed to provide you with planning information and a format for calculating costs of production of a bison bull finishing 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,"Finishing  generally refers to the feeding of bulls from backgrounding until they are ready for market on a high concentrate finishing ration.  An example of a typical finishing operation would be, feed 750 pound bulls to gain 1.75 to 2.0 pounds per day for approximately 200 days to produce 1000 to 1100 pound finished feeders."]
[]
[]
[]
[]
[]
[]
[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,"                                                                                          is also available to help"]
[null,"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":65,"n_cols":9,"rows_kept":65,"cut":false,"hidden":false,"merged":[[40,0,40,8],[64,0,66,8],[0,0,0,8],[1,0,1,8]]}
[{"$f":"\"Bison Bull Finishing Production Cost Summary   \"&Introduction!J11","v":"Bison Bull Finishing Production Cost Summary   October, 2022"}]
[{"$f":"\"Based on \"&Input!E5&\" feeders, weight range \"&Input!E7&\" to \"&Input!E9&\" lbs,  @ \"&Input!E14&\" lbs. ADG\"","v":"Based on 300 feeders, weight range 750 to 1100 lbs,  @ 1.85 lbs. ADG"}]
[]
["A.  Operating Costs",null,null,null,"Cost/Head",null,"Total Cost",null,"Your Cost"]
["1.  Feed Costs"]
["    1.01  Forage",null,null,null,{"$f":"Details!E38","v":80.400000000000006},null,{"$f":"ROUND(E6*Input!$E$5,0)","v":24120}]
["    1.02  Grain/Concentrates",null,null,null,{"$f":"Details!E44","v":663.30000000000007},null,{"$f":"ROUND(E7*Input!$E$5,0)","v":198990}]
["    1.03  Salt & Minerals",null,null,null,{"$f":"Details!E55","v":37.659999999999997},null,{"$f":"ROUND(E8*Input!$E$5,0)","v":11298}]
["Total Feed Costs",null,null,null,{"$f":"SUM(E6:E8)","v":781.36},null,{"$f":"SUM(G6:G8)","v":234408}]
["2.  Other Operating Costs"]
["    2.01  Feeder Cost",null,null,null,{"$f":"Details!E70","v":1553.6538461538462},null,{"$f":"ROUND(E11*Input!$E$5,0)","v":466096}]
["    2.02  Straw",null,null,null,{"$f":"Details!E75","v":8.75},null,{"$f":"ROUND(E12*Input!$E$5,0)","v":2625}]
["    2.03  Veterinary Medicine & Supplies",null,null,null,{"$f":"Details!E97","v":5.74},null,{"$f":"ROUND(E13*Input!$E$5,0)","v":1722}]
["    2.04  Annual Fuel & Repair Costs",null,null,null,{"$f":"Details!E123","v":21.923999999999999},null,{"$f":"ROUND(E14*Input!$E$5,0)","v":6577}]
["    2.05  Utilities",null,null,null,{"$f":"Details!E128","v":5.64},null,{"$f":"ROUND(E15*Input!$E$5,0)","v":1692}]
["    2.06  Trucking Costs",null,null,null,{"$f":"Details!E134","v":105},null,{"$f":"ROUND(E16*Input!$E$5,0)","v":31500}]
["    2.07  Insurance",null,null,null,{"$f":"Details!E148","v":17.43},null,{"$f":"ROUND(E17*Input!$E$5,0)","v":5229}]
["    2.08  Manure Removal",null,null,null,{"$f":"Details!E157","v":23.660815499999998},null,{"$f":"ROUND(E18*Input!$E$5,0)","v":7098}]
["    2.09  Barn & Office Supplies",null,null,null,{"$f":"Details!E162","v":4.67},null,{"$f":"ROUND(E19*Input!$E$5,0)","v":1401}]
["    2.10  Death Loss",null,null,null,{"$f":"Details!E170","v":9.94},null,{"$f":"ROUND(E20*Input!$E$5,0)","v":2982}]
["Subtotal Operating Costs",null,null,null,{"$f":"SUM(E9:E20)","v":2537.7686616538458},null,{"$f":"SUM(G11:G20)+G9","v":761330}]
["    2.11  Operating Interest",null,null,null,{"$f":"Details!E178","v":86.407972602739719},null,{"$f":"ROUND(E22*Input!$E$5,0)","v":25922}]
["Total Operating Costs",null,null,null,{"$f":"E21+E22","v":2624.1766342565857},null,{"$f":"G21+G22","v":787252}]
[]
["B.  Fixed Costs"]
["3.  Depreciation"]
["    3.01  Buildings",null,null,null,{"$f":"Details!E211","v":14.33},null,{"$f":"ROUND(E27*Input!$E$5,0)","v":4299}]
["    3.02  Equipment",null,null,null,{"$f":"Details!E218","v":4.2699999999999996},null,{"$f":"ROUND(E28*Input!$E$5,0)","v":1281}]
["    3.03  Machinery ",null,null,null,{"$f":"Details!E225","v":7.54},null,{"$f":"ROUND(E29*Input!$E$5,0)","v":2262}]
["4.  Investment",null,null,null,""]
["    4.01  Buildings",null,null,null,{"$f":"Details!E236","v":4.3},null,{"$f":"ROUND(E31*Input!$E$5,0)","v":1290}]
["    4.02  Machinery & Equipment",null,null,null,{"$f":"Details!E244","v":4.76},null,{"$f":"ROUND(E32*Input!$E$5,0)","v":1428}]
["Total Fixed Costs",null,null,null,{"$f":"SUM(E27:E32)","v":35.200000000000003},null,{"$f":"SUM(G27:G32)","v":10560}]
[]
["Total Operating and Fixed Costs",null,null,null,{"$f":"E23+E33","v":2659.3766342565855},null,{"$f":"G23+G33","v":797812}]
[]
["C.  Labour",null,null,null,{"$f":"Details!E248","v":78},null,{"$f":"E37*Input!$E$5","v":23400}]
[]
["Total Cost of Production",null,null,null,{"$f":"E35+E37","v":2737.3766342565855},null,{"$f":"G35+G37","v":821212}]
[]
["Profitability and Breakeven Analysis"]
[]
["Estimated Farmgate",null,null,null," Per Head",null,"Total"]
[{"$f":"\"    Gross Revenue @ $\"&Input!E10&\"/cwt market price\"","v":"    Gross Revenue @ $200/cwt market price"},null,null,null,{"$f":"Breakeven!F47","v":2024},null,{"$f":"ROUND(E44*Input!E5,0)","v":607200}]
[]
["Operating Expense Ratio",null,null,null,{"$f":"SUM(E23/E44)","v":1.2965299576366529}]
[]
[]
[null,null,null,"Breakeven Purchase",null,null,"Breakeven Selling",null,"Breakeven Selling"]
[null,null,null,"Price ($/cwt) @",null,null,"Price ($/cwt) @",null,"Price ($/lb)"]
[null,null,null,{"$f":"\"$\"&Input!E10&\"/cwt market price\"","v":"$200/cwt market price"},null,null,{"$f":"\"$\"&Input!E8&\"/cwt feeder price\"","v":"$205/cwt feeder price"},null,"Dressed"]
["     Operating Costs",null,null,{"$f":"Breakeven!F50*100","v":127.13029491963475},null,null,{"$f":"Breakeven!F30*100","v":259.3059915273306},null,{"$f":"G52/((Input!$E$15))","v":4.5492279215321156}]
["     Operating Costs & Labour",null,null,{"$f":"Breakeven!F57*100","v":116.73029491963473},null,null,{"$f":"Breakeven!F34*100","v":267.01350140875354},null,{"$f":"G53/((Input!$E$15))","v":4.6844473931360273}]
["     Operating & Fixed Costs",null,null,{"$f":"Breakeven!F64*100","v":122.43696158630142},null,null,{"$f":"Breakeven!F38*100","v":262.78425239689579},null,{"$f":"G54/((Input!$E$15))","v":4.6102500420508035}]
["     Total Costs",null,null,{"$f":"Breakeven!F71*100","v":112.03696158630143},null,null,{"$f":"Breakeven!F42*100","v":270.49176227831873},null,{"$f":"G55/((Input!$E$15))","v":4.7454695136547143}]
[]
[null,null,null,"Cost per lb of",null,null,"Marginal Returns per head"]
[null,null,null,"gain sold ($/cwt)",null,null,{"$f":"\"@ $\"&Input!E10&\"/cwt market price\"","v":"@ $200/cwt market price"}]
["     Feed Costs",null,null,{"$f":"Breakeven!F6*100","v":274.16140350877191},null,null,{"$f":"E44-E11-E9","v":-311.0138461538462}]
["     Operating Costs",null,null,{"$f":"Breakeven!F11*100","v":375.62203091324193},null,null,{"$f":"Breakeven!F47-Summary!E23","v":-600.17663425658566}]
["     Operating Costs & Labour",null,null,{"$f":"Breakeven!F16*100","v":402.99045196587349},null,null,{"$f":"Breakeven!F47-(E23+E37)","v":-678.17663425658566}]
["     Operating & Fixed Costs",null,null,{"$f":"Breakeven!F21*100","v":387.97290810622428},null,null,{"$f":"Breakeven!F47-(E35)","v":-635.37663425658548}]
["     Total Costs",null,null,{"$f":"Breakeven!F26*100","v":415.3413291588559},null,null,{"$f":"Breakeven!F47-(E39)","v":-713.37663425658548}]
[]
["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. No liability for decisions based on this publication is assumed. "]

{"sheet":"Risk Analysis","index":2,"n_rows":48,"n_cols":7,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,0,0,6],[35,0,35,6],[37,2,37,6],[47,0,49,6]]}
["Risk & Sensitivity Analysis (Stress Test)"]
["A.  Operating Costs"]
[null,"Feed cost",{"$f":"Summary!E9","v":781.36}]
[null,"Weanling cost",{"$f":"Summary!E11","v":1553.6538461538462}]
[null,"Other Operating Costs",{"$f":"Summary!E23-Summary!E11-Summary!E9","v":289.16278810273946}]
[null,"Subtotal",{"$f":"SUM(C3:C5)","v":2624.1766342565857}]
["B.  Fixed Costs",null,{"$f":"Summary!E33","v":35.200000000000003}]
["C.  Labour",null,{"$f":"Summary!E37","v":78}]
["Total Costs",null,{"$f":"SUM(C6:C8)","v":2737.3766342565855}]
[]
["Estimated Farmgate"]
[null,"Price ($ per cwt)",{"$f":"Input!E10","v":200}]
[]
[]
[null,"Percent Market Price Change",-0.1]
[null,"Percent Feed Cost Change",0.1]
[null,"Percent Feeder Cost Change",0.05]
[]
[]
[null,null,"Per Head"]
[null,"Market Price ($ per cwt)",{"$f":"SUM(C12*(1+C15))","v":180}]
[null,"Feed Cost",{"$f":"SUM(C3+(C3*C16))","v":859.49599999999998}]
[null,"Feeder Cost",{"$f":"SUM(C4+(C4*C17))","v":1631.3365384615386}]
[]
[{"$f":"\"Stress Test Scenario = Market Price \"&IF(C15<0,\"Down\",\"Up\")&\" \"&ABS(C15*100)&\"%, Feed Price \"&IF(C16<0,\"Down\",\"Up\")&\" \"&ABS(C16*100)&\"% and Feeder Cost \"&IF(C17<0,\"Down\",\"Up\")&\" \"&ABS(C17*100)&\"%\"","v":"Stress Test Scenario = Market Price Down 10%, Feed Price Up 10% and Feeder Cost Up 5%"}]
[null,"Operating Costs",{"$f":"SUM(C5+C22+C23)","v":2779.995326564278}]
[null,"Total Costs",{"$f":"C7+C8+C26","v":2893.1953265642778}]
[null,"Gross Revenue / feeder",{"$f":"(Breakeven!F45/100)*'Risk Analysis'!C21","v":1821.6}]
[null,"Marginal Returns "]
[null,"   Over Operating Costs",{"$f":"SUM(C28-C26)","v":-958.39532656427809}]
[null,"   Over Operating & Labour Costs",{"$f":"SUM(C28-C26-C8)","v":-1036.3953265642781}]
[null,"   Over Total Costs (Net Profit)",{"$f":"SUM(C28-C27)","v":-1071.5953265642779}]
[]
[null,"Operating Expense Ratio",{"$f":"SUM(C26/C28)","v":1.5261283083905788}]
[]
["Estimated Breakeven Canadian Dollar Analysis*"]
[]
[null,null,{"$f":"\"Est. Market Price ($/cwt Cdn) @ \"&TEXT(Input!E11,\"0.0000\")&\" Cdn per USD\"","v":"Est. Market Price ($/cwt Cdn) @ 0.7300 Cdn per USD"}]
[null,null,{"$f":"SUM($E$39-10)","v":190},{"$f":"SUM($E$39-5)","v":195},{"$f":"Input!E10","v":200},{"$f":"SUM($E$39+5)","v":205},{"$f":"SUM($E$39+10)","v":210}]
["Breakeven CDN Dollar ($1 Cdn = $ USD)"]
[null,"Operating Costs",{"$f":"SUM((C39/100)*Breakeven!$F$45*Input!$E$11)/Summary!$E$23","v":0.53488929886674508},{"$f":"SUM((D39/100)*Breakeven!$F$45*Input!$E$11)/Summary!$E$23","v":0.54896533304744888},{"$f":"SUM((E39/100)*Breakeven!$F$45*Input!$E$11)/Summary!$E$23","v":0.56304136722815268},{"$f":"SUM((F39/100)*Breakeven!$F$45*Input!$E$11)/Summary!$E$23","v":0.57711740140885648},{"$f":"SUM((G39/100)*Breakeven!$F$45*Input!$E$11)/Summary!$E$23","v":0.59119343558956039}]
[null,"Operating & Labour Costs",{"$f":"SUM((C39/100)*Breakeven!$F$45*Input!$E$11)/(Summary!$E$23+Summary!$E$37)","v":0.51944938839505805},{"$f":"SUM((D39/100)*Breakeven!$F$45*Input!$E$11)/(Summary!$E$23+Summary!$E$37)","v":0.53311910914229643},{"$f":"SUM((E39/100)*Breakeven!$F$45*Input!$E$11)/(Summary!$E$23+Summary!$E$37)","v":0.54678882988953481},{"$f":"SUM((F39/100)*Breakeven!$F$45*Input!$E$11)/(Summary!$E$23+Summary!$E$37)","v":0.56045855063677319},{"$f":"SUM((G39/100)*Breakeven!$F$45*Input!$E$11)/(Summary!$E$23+Summary!$E$37)","v":0.57412827138401168}]
[null,"Operating, Fixed & Labour Costs",{"$f":"SUM((C39/100)*Breakeven!$F$45*Input!$E$11)/(Summary!$E$39)","v":0.51276977469386509},{"$f":"SUM((D39/100)*Breakeven!$F$45*Input!$E$11)/(Summary!$E$39)","v":0.52626371613317724},{"$f":"SUM((E39/100)*Breakeven!$F$45*Input!$E$11)/(Summary!$E$39)","v":0.5397576575724895},{"$f":"SUM((F39/100)*Breakeven!$F$45*Input!$E$11)/(Summary!$E$39)","v":0.55325159901180176},{"$f":"SUM((G39/100)*Breakeven!$F$45*Input!$E$11)/(Summary!$E$39)","v":0.56674554045111414}]
[]
[{"$f":"\"Breakeven Canadian Dollar = (Est. Market Price ($/lb) x Shrunk Wt. (lbs) x $ Cdn per USD) / Cost\"","v":"Breakeven Canadian Dollar = (Est. Market Price ($/lb) x Shrunk Wt. (lbs) x $ Cdn per USD) / Cost"}]
[{"$f":"\"   (eg. ($\"&TEXT(E39/100,\"0.00\")&\" x \"&ROUND(Breakeven!F45,0)&\" lbs x $\"&TEXT(Input!E11,\"0.0000\")&\") / $\"&TEXT(Summary!E39,\"0.00\")&\") = $\"&TEXT(E43,\"0.0000\")","v":"   (eg. ($2.00 x 1012 lbs x $0.7300) / $2737.38) = $0.5398"}]
[]
["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":3,"n_rows":130,"n_cols":9,"rows_kept":130,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["Bison Bull Finishing Costs - Input"]
[]
[null,"Herd Profile"]
[]
[null,"Number of Feeders Purchased",null,null,300,"  head"]
[null,"Feeder Bull Mortality Rate ",null,null,0.5,"  %"]
[null,"Feeder Purchased Weight",null,null,750,"  lbs"]
[null,"Feeder Bull Price",null,null,205,"  /cwt"]
[null,"Finish Weight",null,null,1100,"  lbs"]
[null,"Finish Selling Price",null,null,200,"  /cwt"]
[null,"$1 Canadian Dollar",null,{"$f":"\"($\"&TEXT(1/E11,\"#.####\")&\" CDN )\"","v":"($1.3699 CDN )"},0.73,"/ $1 USD"]
[null,"Percent Shrink - finished",null,null,8,"  %"]
[null,"Percent Shrink - feeder",null,null,3,"  %"]
[null,"Average Daily Gain ",null,null,1.85,"  lbs/day"]
[null,"Dressing Percentage",null,null,57,"  %"]
[]
[null,"Days On Feed",null,null,{"$f":"ROUND((E9-(E7-(E7*E13/100)))/E14,0)","v":201},"  days"]
[]
[null,"Total Feed Cost per Bull",null,null,{"$f":"Summary!E9","v":781.36}]
[null,"Average Feed Cost per Day",null,null,{"$f":"SUM(E19/E17)","v":3.8873631840796019}]
[null,"Feed Cost per lb. of Gain Sold (shrunk weight)",null,null,{"$f":"(E19/ROUND((E9-(E9*Input!$E$12/100))-(E7-(E7*E13/100)),0))","v":2.7416140350877192}]
[]
[null,"Total Pounds of Gain",null,null,{"$f":"ROUND(E9-E7,0)","v":350}]
[null,"Total Pounds of Gain (Shrunk Weight)",null,null,{"$f":"ROUND((E9-(E9*E12/100))-(E7-(E7*E13/100)),0)","v":285}]
[]
[]
[null,"Footnote:  1 kilogram (kg) = 2.2046 pounds (lbs)"]
[]
[null,"Feed Costs","Cost",null,null,null,"    Feeder Bison Requirement",null,"Days Fed"]
[null,"Grass Hay",100,"/ton",8,"lbs/day",null,null,{"$f":"E17","v":201}]
[null,"Alfalfa Grass Hay ",0,"/ton",0,"lbs/day",null,null,0]
[null,"Silage",0,"/ton",0,"lbs/day",null,null,{"$f":"E17","v":201}]
[null,"Grain/concentrate",0.2,"/lb",16.5,"lbs/day",null,null,{"$f":"E17","v":201}]
[null,"Salt",0.14000000000000001,"/lb",9,"lbs/feeder "]
[null,"Mineral",0.91,"/lb",40,"lbs/feeder "]
[null,null,null,null,null,null,null,null,""]
[null,"Other Operating Costs"]
[null,null,null,null,null,null,null,""]
[null,"  Straw",null,"","",null,null,""]
[null,"     Annual Requirement",null,null,0.125,"tonnes/feeder"]
[null,"     Cost",null,"",70,"/tonne",null,""]
[null,"",null,"","",null,null,""]
[null,"  Veterinary Medicine & Supplies"]
[null,"     Feeder Medication"]
[null,"        Blackleg (8 way vaccine)",null,null,0.83,"/feeder"]
[null,"        Vitamin",null,null,0,"/feeder"]
[null,"        Parasite Control",null,null,3.8,"/feeder"]
[]
[null,"     Herd Health Program"]
[null,"        Professional Services",null,null,""]
[null,"          Total Yearly Hours",null,null,1,"hours"]
[null,"          Rate",null,null,175,"/hour"]
[null,null,null,null,""]
[null,"        Transportation",null,null,""]
[null,"          Total Distance (round trip)",null,null,160,"km"]
[null,"          Charge per km",null,null,1]
[null,"          Number of yearly visits",null,null,1]
[]
[null,"   Annual Fuel & Repair Costs"]
["   a)  Machinery Fuel Costs - Winter Feeding"]
["              Tractor with Loader PTO hp",null,null,null,120]
["              Diesel Fuel Cost",null,null,null,1.65,"/litre"]
["              Tractor Hours Per Day (average)",null,null,null,1.5,"hours"]
["   b) Machinery Repair (% of investment cost)",null,null,null,1,"%"]
["   c) Building & fence repair (% of investment cost)",null,null,null,2,"%"]
[null,"  Utilities",null,null,""]
["          Hydro"," - Rate",null,null,9.3240000000000003E-2,"/ kWh"]
[null,15,"kWh per feeder",null,{"$f":"SUM(B68*E5*E67)","v":419.58000000000004}]
[null,2,"1000 watt waterer",null,{"$f":"SUM(B69*18)*(E10)*E67","v":671.32799999999997}]
[null,null,null,"Total Hydro",{"$f":"SUM(E68:E69)","v":1090.9079999999999}]
["        Water",null,null,null,0]
["        Telephone",null,null,null,600]
[]
[null,"  Trucking to Feedlot",null,null,""]
[null,"     Distance to packing plant",null,null,150,"miles"]
[null,"     Trucking cost",null,null,7,"/loaded mile"]
[null,"     Number of head per load",null,null,65]
[]
[null,"  Trucking Cost",null,null,""]
[null,"     Trucking cost","Rate/loaded mile",null,7,"/loaded mile"]
[null,null,"Milage, distance to market",null,750,"miles"]
[null,null,"Truck capacity # head",null,50,"head"]
[]
[null,"  Manure Removal",null,"","",null,null,""]
["         Manure volume produced",null,null,null,2.4E-2,"m3/feeder/day"]
["         Manure volume shrinkage",null,null,null,75,"%"]
["         Cost for manure removal & application",null,null,null,15,"/cubic yard"]
[]
[null,"  Insurance"]
[null,"     Cost per $100 Capital Invested in:"]
[null,"       Livestock",null,null,0.45]
[null,"       Buildings & Equipment",null,null,0.4]
[null,"     Additional Coverage for Liability",null,null,49]
[]
[null,"  Barn & Office Supplies"]
[null,"     Total yearly expense relating to barn",null,null,1400]
[]
[null,"  Operating Interest Rate",null,null,7.75,"%"]
[null,"  Investment Interest Rate",null,null,3,"%"]
[null,null,null,null,null,null,null,null,""]
[null,"Footnote:  cwt = hundred-weight = 100 lbs"]
[null,null,null,null,null,null,null,null,""]
[null,null,null,"Capital Costs"]
[null,null,null,""]
[null,null,null,"Original","Salvage",null,"Useful"]
[null,null,null,"Value","Value",null,"Life"]
[null,"Handling Facilities",null,""]
[null,"        Land & Landscaping",null,10000]
[null,"        Waterers",null,6000]
[null,"        Squeeze, Gates & Scale",null,20000]
[null,"        Well & Pressure System",null,8000]
[null,"        Pens (Working & Sorting)",null,42000]
[null,"Total Building Cost",null,{"$f":"SUM(D108:D112)","v":86000},0,"%",20,"years"]
[]
[null,"   Equipment",null,null,"",null,""]
[null,"        Self Feeder",null,27000]
[null,"        Hay Feeders ",null,2500]
[null,"        Miscellaneous",null,2500]
[null,"Total Equipment Cost",null,{"$f":"SUM(D116:D118)","v":32000},0,"%",25,"years"]
[]
[null,"   Machinery"]
[null,"     Tractors & Loader ($120,000 @ 30%)",null,36000,20,"%",15,"years"]
["         Miscellaneous",null,null,20000,20,"%",10,"years"]
[]
[null,"Total Capital Investment",null,{"$f":"D122+D119+D113","v":154000}]
[]
[null,"Labour Costs"]
[]
[null,"  Hours",null,null,3,"head/year"]
[null,"  Wage",null,null,26,"/hour"]

{"sheet":"Details","index":4,"n_rows":248,"n_cols":10,"rows_kept":248,"cut":false,"hidden":false,"merged":[[4,1,5,9],[7,1,8,9],[0,0,0,9],[1,0,1,9],[179,1,179,9],[202,4,202,7],[203,4,203,7],[226,4,226,9],[227,4,227,8],[10,1,10,9],[15,1,15,9],[17,1,17,9],[12,1,13,9]]}
["    Bison Bull Finishing Cost Worksheet"]
[{"$f":"\"Based on \"&Input!E5&\" head\"","v":"Based on 300 head"}]
[]
[null,"Assumptions"]
[null,{"$f":"\"1. This budget assumes the weaning and/or purchase weight of bison bull calves to be approximately \"&Input!E7&\" lbs. Finish weight would be assumed to be \"&Input!E9&\" lbs.\"","v":"1. This budget assumes the weaning and/or purchase weight of bison bull calves to be approximately 750 lbs. Finish weight would be assumed to be 1100 lbs."}]
[]
[]
[null,{"$f":"\"2.  This budget assumes a shrink (lot to slaughter plant) of \"&Input!E12&\"%. Shrunk Weight weight = \"&ROUND(Input!E9-(Input!E9*(Input!E12/100)),0)&\" lbs.\"","v":"2.  This budget assumes a shrink (lot to slaughter plant) of 8%. Shrunk Weight weight = 1012 lbs."}]
[]
[]
[null,{"$f":"\"3.  Average Daily Gain = \"&Input!E14&\" lbs per day. \"","v":"3.  Average Daily Gain = 1.85 lbs per day. "}]
[]
[null,{"$f":"\"4.  Time frame from start to finish is approximately \"&Input!E17&\" days, \"&Input!I30&\" days on finishing ration and moderate quality hay and \"&Input!I31&\" days with supplemental good quality hay.\"","v":"4.  Time frame from start to finish is approximately 201 days, 201 days on finishing ration and moderate quality hay and 0 days with supplemental good quality hay."}]
[]
[]
[null,"5.  Grain ration is prepared (minerals and salt included)."]
[]
[null,{"$f":"\"6.  This budget is based an a finishing enterprise of \"&Input!E5&\"  bulls.\"","v":"6.  This budget is based an a finishing enterprise of 300  bulls."}]
[]
[null,"A.  Operating Costs",null,null,null,null,null,null,null,"Your Cost"]
[null,"1.  Feed Costs"]
[null,"    1.01  Forage"]
[null,null,"Grass Hay",null,{"$f":"Input!I30","v":201},null,"days on ration"]
[null,null,null,"x",{"$f":"Input!E30","v":8},null,"lbs/feeder/day"]
[null,null,null,"x",{"$f":"Input!C30","v":100},null,"/ton"]
[null,null,null,"=",{"$f":"ROUND((E23*E24)*E25/2000,2)","v":80.400000000000006},null,"/feeder",""]
[]
[null,null,"Other Hay",null,{"$f":"Input!I31","v":0},null,"days on hay"]
[null,null,null,"x",{"$f":"Input!E31","v":0},null,"lbs/feeder/day"]
[null,null,null,"x",{"$f":"Input!C31","v":0},null,"/ton"]
[null,null,null,"=",{"$f":"(E28*E29)*E30/2000","v":0},null,"/feeder"]
[]
[null,null,"Silage",null,{"$f":"Input!I32","v":201},null,"days on hay"]
[null,null,null,"x",{"$f":"Input!E32","v":0},null,"lbs/feeder/day"]
[null,null,null,"x",{"$f":"Input!C32","v":0},null,"/ton"]
[null,null,null,"=",{"$f":"(E33*E34)*E35/2000","v":0},null,"/feeder"]
[]
[null,null,null,"=",{"$f":"E26+E31+E36","v":80.400000000000006},null,"/feeder"]
[]
[null,"    1.02  Grain/Concentrate"]
[null,null,null,null,{"$f":"Input!I33","v":201},null,"days on feed"]
[null,null,null,"x",{"$f":"Input!E33","v":16.5},null,"lbs/feeder/day"]
[null,null,null,"x",{"$f":"Input!C33","v":0.2},null,"/lb"]
[null,null,null,"=",{"$f":"SUM(E41*E42*E43)","v":663.30000000000007},null,"/feeder",""]
[]
[null,"    1.03  Salt & Minerals"]
[null,null,null,null,{"$f":"Input!E34","v":9},null,"lbs salt/feeder"]
[null,null,null,"x",{"$f":"Input!C34","v":0.14000000000000001},null,"$/lb"]
[null,null,null,"=",{"$f":"E47*E48","v":1.2600000000000002},null,"/feeder"]
[]
[null,null,null,null,{"$f":"Input!E35","v":40},null,"lbs mineral/feeder"]
[null,null,null,"x",{"$f":"Input!C35","v":0.91},null,"$/lb"]
[null,null,null,"=",{"$f":"E51*E52","v":36.4},null,"/feeder"]
[]
[null,null,null,"=",{"$f":"E49+E53","v":37.659999999999997},null,"/feeder"]
[]
[null,"2.  Other Operating Costs"]
[]
[null,"    2.01  Feeder Bison Cost"]
[null,null,null,null,{"$f":"Input!E7","v":750},null,"lbs/feeder"]
[null,null,null,"x",{"$f":"Input!E8","v":205},null,"/cwt"]
[null,null,null,"÷",100,null,"lbs/cwt",""]
[null,null,null,"=",{"$f":"ROUND(E60/100*E61,2)","v":1537.5},null,"/feeder"]
[]
[null,null,null,null,{"$f":"Input!E75","v":150},null,"miles"]
[null,null,null,"x",{"$f":"Input!E76","v":7},null,"$/loaded mile"]
[null,null,null,"÷",{"$f":"Input!E77","v":65},null,"head load capacity"]
[null,null,null,"=",{"$f":"(E65*E66)/E67","v":16.153846153846153},null,"/feeder"]
[]
[null,null,null,"=",{"$f":"E63+E68","v":1553.6538461538462},null,"/feeder"]
[]
[null,"    2.02  Straw"]
[null,null,null,null,{"$f":"Input!E40","v":0.125},null,"tonnes/feeder/year"]
[null,null,null,"x",{"$f":"Input!E41","v":70},null,"/tonne"]
[null,null,null,"=",{"$f":"ROUND(E73*E74,2)","v":8.75},null,"/feeder"]
[]
[null,"    2.03  Veterinary Medicine & Supplies"]
[null,null,"Medication"]
[null,null,null,null,{"$f":"Input!E45","v":0.83},null,"blackleg"]
[null,null,null,"+",{"$f":"Input!E46","v":0},null,"vitamin"]
[null,null,null,"+",{"$f":"Input!E47","v":3.8},null,"parasite control"]
[null,null,null,"=",{"$f":"ROUND(E79+E80+E81,2)","v":4.63},null,"/feeder"]
[null,null,null,null,null,null,""]
[null,null,"Herd health program"]
[null,null,null,null,{"$f":"Input!E52","v":175},null,"/hour charge"]
[null,null,null,"x",{"$f":"Input!E51","v":1},null,"hours"]
[null,null,null,"÷",{"$f":"Input!E5","v":300},null,"feeders"]
[null,null,null,"=",{"$f":"ROUND(E85*E86/E87,2)","v":0.57999999999999996},null,"/feeder"]
[null,null,null,null,null,null,null,""]
[null,null,"Mileage"]
[null,null,null,null,{"$f":"Input!E56","v":1},null,"/km charge"]
[null,null,null,"x",{"$f":"Input!E55","v":160},null,"kilometres"]
[null,null,null,"x",{"$f":"Input!E57","v":1},null,"visits"]
[null,null,null,"÷",{"$f":"Input!E5","v":300},null,"feeders"]
[null,null,null,"=",{"$f":"ROUND(E91*E92*E93/E94,2)","v":0.53},null,"/feeder"]
[]
[null,null,"Total","=",{"$f":"E82+E88+E95","v":5.74},null,"/feeder"]
[]
[null,"    2.04  Annual Fuel & Repair Costs"]
[null,"      Machinery fuel cost"]
[null,null,null,null,{"$f":"Input!E61","v":120},null,"PTO hp"]
[null,null,null,"÷",2.5,null,"avg HP required"]
[null,null,null,"x",0.1665576,null,"litres fuel/hour/hp"]
[null,null,null,"x",{"$f":"Input!E63","v":1.5},null,"hours per day"]
[null,null,null,"x",{"$f":"Input!E62","v":1.65},null,"diesel / litre"]
[null,null,null,"x",{"$f":"Input!E17","v":201},null,"days on feed"]
[null,null,null,null,{"$f":"IF(E106=\"ERROR\",\"ERROR\",ROUND(((E101/E102)*E103*E104*E105*E106),2))","v":3977.2},null,"annual fuel cost"]
[null,null,null,"÷",{"$f":"Input!E5","v":300},null,"feeders"]
[null,null,null,"=",{"$f":"IF(E106=\"ERROR\",\"ERROR\",SUM(E107/E108))","v":13.257333333333333},null,"/feeder"]
[null,"      Machinery repair & maintenance"]
[null,null,null,null,{"$f":"Input!D122+Input!D123+Input!D119","v":88000},null,"machinery capital cost"]
[null,null,null,"x",{"$f":"Input!E64","v":1},null,"% repair rate"]
[null,null,null,"=",{"$f":"SUM(E111*(E112/100))","v":880},null,"oil, repairs & maintenance"]
[null,null,null,"÷",{"$f":"Input!E5","v":300},null,"feeders"]
[null,null,null,"=",{"$f":"SUM(E113/E114)","v":2.9333333333333331},null,"/feeder"]
[null,"      Building & fence repair"]
[null,null,null,null,{"$f":"Input!D113","v":86000},null,"building capital cost"]
[null,null,null,"x",{"$f":"Input!E65","v":2},null,"% repair rate"]
[null,null,null,"=",{"$f":"SUM(E117*(E118/100))","v":1720},null,"oil, repairs & maintenance"]
[null,null,null,"÷",{"$f":"Input!E5","v":300},null,"feeders"]
[null,null,null,"=",{"$f":"SUM(E119/E120)","v":5.7333333333333334},null,"/feeder"]
[]
[null,null,"Total","=",{"$f":"SUM(E121+E115+E109)","v":21.923999999999999},null,"/feeder"]
[]
[null,"    2.05  Utilities"]
[null,null,null,null,{"$f":"Input!E72+Input!E70+Input!E71","v":1690.9079999999999},null,"cost/year"]
[null,null,null,"÷",{"$f":"Input!E5","v":300},null,"feeders"]
[null,null,null,"=",{"$f":"ROUND((E126)/E127,2)","v":5.64},null,"/feeder"]
[]
[null,"    2.06  Trucking Costs"]
[null,null,null,null,{"$f":"Input!E80","v":7},null,"$/loaded mile"]
[null,null,null,"x",{"$f":"Input!E81","v":750},null,"distance miles"]
[null,null,null,"÷",{"$f":"Input!E82","v":50},null,"head load capacity"]
[null,null,null,"=",{"$f":"(E131*E132)/E133","v":105},null,"/feeder"]
[]
[null,"    2.07  Insurance"]
[null,null,null,null,{"$f":"Input!D113+Input!D119+Input!D122","v":154000},null,"building & equipment value"]
[null,null,null,"x",{"$f":"Input!E92","v":0.4},null,"cost/$100 capital"]
[null,null,null,"÷",100]
[null,null,null,"÷",{"$f":"Input!E5","v":300},null,"feeders"]
[null,null,null,"=",{"$f":"ROUND(E137*E138/E139/E140,2)","v":2.0499999999999998},null,"/feeder "]
[]
[null,null,null,null,{"$f":"(Input!E7*Input!E8)/100","v":1537.5},null,"feeder investment"]
[null,null,null,"x",{"$f":"Input!E56","v":1},null,"cost/$100 capital"]
[null,null,null,"÷",100]
[null,null,null,"=",{"$f":"ROUND(E143*E144/E145,2)","v":15.38},null,"/feeder"]
[]
[null,null,"Total","=",{"$f":"E141+E146","v":17.43},null,"/feeder"]
[]
[null,"    2.08  Manure Removal"]
[null,null,null,"=",{"$f":"Input!E17","v":201},null,"days on feed"]
[null,null,null,"x",{"$f":"Input!E85","v":2.4E-2},null,"m3/feeder/day"]
[null,null,null,"=",{"$f":"SUM(E151*E152)","v":4.8239999999999998},null,"m3 manure volume"]
[null,null,null,"x",{"$f":"Input!E86","v":75},null,"% volume shrink"]
[null,null,null,"x",1.3079499999999999,null,"yd3 per m3"]
[null,null,null,"x",{"$f":"Input!E87","v":15},null,"yd3 manure removal cost"]
[null,null,null,"=",{"$f":"SUM(E153*(1-(E154/100))*E155*E156)","v":23.660815499999998},null,"/feeder"]
[]
[null,"    2.09  Barn & Office Supplies"]
[null,null,null,null,{"$f":"Input!E96","v":1400},null,"total barn expenses"]
[null,null,null,"÷",{"$f":"Input!E5","v":300},null,"feeders"]
[null,null,null,"=",{"$f":"ROUND(E160/E161,2)","v":4.67},null,"/feeder"]
[]
[null,"    2.10  Death Loss"]
[null,null,null,null,{"$f":"Summary!E11","v":1553.6538461538462},null,"feeder cost"]
[null,null,null,"+",{"$f":"SUM(Summary!E9:E19)","v":2527.8286616538458},null,"maximum value"]
[null,null,null,"-",{"$f":"Summary!E16","v":105},null,"marketing cost"]
[null,null,null,"÷",2,null,"average value"]
[null,null,null,"x",{"$f":"Input!E6","v":0.5},null,"% mortality"]
[null,null,null,"=",{"$f":"ROUND(((E165+E166-E167)/E168)*E169/100,2)","v":9.94},null,"/feeder"]
[]
[null,"    2.11  Operating Interest"]
[null,null,null,null,{"$f":"(Input!E7*Input!E8)/100","v":1537.5},null,"feeder cost"]
[null,null,null,"+",{"$f":"(Summary!E9+SUM(Summary!E12:E19))/2","v":487.08740775000001},null,"½ of feed & other costs"]
[null,null,null,"x",{"$f":"Input!E98","v":7.75},null,"% operating interest"]
[null,null,null,"x",{"$f":"Input!E17","v":201},null,"days on feed"]
[null,null,null,"÷",365,null,"365 days per year"]
[null,null,null,"=",{"$f":"ROUND((E173+E174)*(E175/100),2)*E176/365","v":86.407972602739719},null,"/feeder"]
[]
[null,"Capital Investment"]
[]
[null,"Handling Facilities"]
[null,"        Land & Landscaping",null,null,null,null,null,{"$f":"Input!D108","v":10000}]
[null,"        Waterers",null,null,null,null,null,{"$f":"Input!D109","v":6000}]
[null,"        Squeeze, Gates & Scale",null,null,null,null,null,{"$f":"Input!D110","v":20000}]
[null,"        Well & Pressure System",null,null,null,null,null,{"$f":"Input!D111","v":8000}]
[null,"        Pens (Working & Sorting)",null,null,null,null,null,{"$f":"Input!D112","v":42000}]
[null,"Total Building Cost",null,null,null,null,null,{"$f":"SUM(H183:H187)","v":86000}]
[]
[null,"  Machinery & Equipment"]
[null,"        Self Feeder",null,null,null,null,null,{"$f":"Input!D116","v":27000}]
[null,"        Hay Feeders & Miscellaneous",null,null,null,null,null,{"$f":"Input!D117","v":2500}]
[null,"        Miscellaneous",null,null,null,null,null,{"$f":"Input!D118","v":2500}]
[null,"        Tractor & Loader",null,null,null,null,null,{"$f":"Input!D122","v":36000}]
[null,"        Miscellaneous",null,null,null,null,null,{"$f":"Input!D123","v":20000}]
[null,"Total ",null,null,null,null,null,{"$f":"SUM(H191:H195)","v":88000}]
[]
[null,"Total Capital Investment",null,null,null,null,null,{"$f":"H188+H196","v":174000}]
[]
[null,"B.  Fixed Costs"]
[]
[null,"3.  Depreciation"]
[null,null,null,null,"Original Cost - Salvage Value"]
[null,null,null,null,"Useful Life"]
[]
[null,"    3.01  Buildings"]
[null,null,null,null,{"$f":"Input!D113","v":86000},null,"original value"]
[null,null,null,"-",{"$f":"(Input!E113/100)*Input!D113","v":0},null,"salvage value"]
[null,null,null,"÷",{"$f":"Input!G113","v":20},null,"years useful life"]
[null,null,null,"÷",{"$f":"Input!E5","v":300},null,"feeders"]
[null,null,null,"=",{"$f":"ROUND((E207-E208)/E209/E210,2)","v":14.33},null,"/feeder"]
[]
[null,"    3.02  Equipment"]
[null,null,null,null,{"$f":"Input!D119","v":32000},null,"original value"]
[null,null,null,"-",{"$f":"(Input!E119/100)*Input!D119","v":0},null,"salvage value"]
[null,null,null,"÷",{"$f":"Input!G119","v":25},null,"years useful life"]
[null,null,null,"÷",{"$f":"Input!E5","v":300},null,"feeders"]
[null,null,null,"=",{"$f":"ROUND((E214-E215)/E216/E217,2)","v":4.2699999999999996},null,"/feeder"]
[]
[null,"    3.02  Machinery"]
[null,null,null,null,{"$f":"Input!D122","v":36000},null,"original value"]
[null,null,null,"-",{"$f":"(Details!E97/100)*Input!D122","v":2066.4},null,"salvage value"]
[null,null,null,"÷",{"$f":"Input!G122","v":15},null,"years useful life"]
[null,null,null,"÷",{"$f":"Input!E5","v":300},null,"feeders"]
[null,null,null,"=",{"$f":"ROUND((E221-E222)/E223/E224,2)","v":7.54},null,"/feeder"]
[null,"4.  Investment"]
[null,null,null,null,"Original Cost + Salvage Value  x Investment Rate"]
[null,null,null,null,"                        2"]
[]
[null,"    4.01  Buildings"]
[null,null,null,null,{"$f":"Input!D113","v":86000},null,"total building value"]
[null,null,null,"+",{"$f":"Input!D113*Input!E113","v":0},null,"salvage value"]
[null,null,null,"÷",2,null,"average"]
[null,null,null,"x",{"$f":"Input!E99","v":3},null,"% investment interest"]
[null,null,null,"÷",{"$f":"Input!E5","v":300},null,"feeders"]
[null,null,null,"=",{"$f":"ROUND((E231+E232)/E233*(E234/100)/E235,2)","v":4.3},null,"/feeder"]
[]
[null,"    4.02  Machinery & Equipment"]
[null,null,null,null,{"$f":"Input!D122+Input!D119+Input!D123","v":88000},null,"original value"]
[null,null,null,"+",{"$f":"(Input!$D$116*Input!$E$119)+(Input!$D$122*Input!$E$122/100)","v":7200},null,"salvage value"]
[null,null,null,"÷",2,null,"average"]
[null,null,null,"x",{"$f":"Input!E99","v":3},null,"% investment interest"]
[null,null,null,"÷",{"$f":"Input!E5","v":300},null,"feeders"]
[null,null,null,"=",{"$f":"ROUND((E239+E240)/E241*(E242/100)/E243,2)","v":4.76},null,"/feeder"]
[null,"C. Labour"]
[null,null,null,null,{"$f":"Input!E129","v":3},null,"hours/feeder/year"]
[null,null,null,"x",{"$f":"Input!E130","v":26},null,"/hour"]
[null,null,null,"=",{"$f":"ROUND(E246*E247,2)","v":78},null,"/feeder"]

{"sheet":"Breakeven","index":5,"n_rows":74,"n_cols":10,"rows_kept":74,"cut":false,"hidden":false,"merged":[[0,0,0,9]]}
["Breakeven Calculations"]
[]
["    Cost per lb of gain sold (shrunk weight)"]
[null,"Feed Costs",null,null,null,{"$f":"Summary!E9","v":781.36},null,"feed cost"]
[null,null,null,null,"÷",{"$f":"Input!E24","v":285},null,"lbs gained weight"]
[null,null,null,null,"=",{"$f":"F4/F5","v":2.7416140350877192},null,"/lb (gain sold)"]
[]
[null,"Operating Costs",null,null,null,{"$f":"Summary!E23","v":2624.1766342565857},null,"operating costs"]
[null,null,null,null,"-",{"$f":"Summary!E11","v":1553.6538461538462},null,"feeder cost"]
[null,null,null,null,"÷",{"$f":"Input!E24","v":285},null,"lbs gained weight"]
[null,null,null,null,"=",{"$f":"(F8-F9)/F10","v":3.7562203091324191},null,"/lb (gain sold)"]
[]
[null,"Operating & Labour Costs",null,null,null,{"$f":"Summary!E23+Summary!E37","v":2702.1766342565857},null,"operating costs"]
[null,null,null,null,"-",{"$f":"Summary!E11","v":1553.6538461538462},null,"feeder cost"]
[null,null,null,null,"÷",{"$f":"Input!E24","v":285},null,"lbs gained weight"]
[null,null,null,null,"=",{"$f":"(F13-F14)/F15","v":4.0299045196587349},null,"/lb (gain sold)"]
[]
[null,"Operating & Fixed",null,null,null,{"$f":"Summary!E35","v":2659.3766342565855},null,"oper.  & fixed costs"]
[null,null,null,null,"-",{"$f":"Summary!E11","v":1553.6538461538462},null,"feeder cost"]
[null,null,null,null,"÷",{"$f":"Input!E24","v":285},null,"lbs gained weight"]
[null,null,null,null,"=",{"$f":"(F18-F19)/F20","v":3.8797290810622429},null,"/lb (gain sold)"]
[]
[null,"Total Costs",null,null,null,{"$f":"Summary!E39","v":2737.3766342565855},null,"total costs"]
[null,null,null,null,"-",{"$f":"Summary!E11","v":1553.6538461538462},null,"feeder cost"]
[null,null,null,null,"÷",{"$f":"Input!E24","v":285},null,"lbs gained weight"]
[null,null,null,null,"=",{"$f":"(F23-F24)/F25","v":4.1534132915885591},null,"/lb (gain sold)"]
["    Breakeven selling price (shrunk weight)"]
[null,"Operating Costs",null,null,null,{"$f":"Summary!E23","v":2624.1766342565857},null,"operating costs"]
[null,null,null,null,"÷",{"$f":"Input!E9-(Input!E9*(Input!E12/100))","v":1012},null,"lbs shrunk weight"]
[null,null,null,null,"=",{"$f":"F28/F29","v":2.5930599152733058},null,"/lb "]
[]
[null,"Operating & Labour Costs",null,null,null,{"$f":"Summary!E23+Summary!E37","v":2702.1766342565857},null,"operating & labour "]
[null,null,null,null,"÷",{"$f":"Input!E9-(Input!E9*(Input!E12/100))","v":1012},null,"lbs shrunk weight"]
[null,null,null,null,"=",{"$f":"F32/F33","v":2.6701350140875353},null,"/lb "]
[]
[null,"Operating & Fixed",null,null,null,{"$f":"Summary!E35","v":2659.3766342565855},null,"oper. & fixed costs"]
[null,null,null,null,"÷",{"$f":"Input!E9-(Input!E9*(Input!E12/100))","v":1012},null,"lbs shrunk weight"]
[null,null,null,null,"=",{"$f":"F36/F37","v":2.6278425239689578},null,"/lb "]
[]
[null,"Total Costs",null,null,null,{"$f":"Summary!E39","v":2737.3766342565855},null,"total costs"]
[null,null,null,null,"÷",{"$f":"Input!E9-(Input!E9*(Input!E12/100))","v":1012},null,"lbs shrunk weight"]
[null,null,null,null,"=",{"$f":"F40/F41","v":2.7049176227831873},null,"/lb "]
[]
["    Breakeven purchase price (shrunk weight)"]
[null,"Operating Costs",null,null,null,{"$f":"Input!E9-(Input!E9*(Input!E12/100))","v":1012},null,"lbs shrunk weight"]
[null,null,null,null,"x",{"$f":"Input!E10","v":200},null,"$/cwt selling price"]
[null,null,null,null,"=",{"$f":"F45*F46/100","v":2024},null,"income"]
[null,null,null,null,"-",{"$f":"Summary!E23-Summary!E11","v":1070.5227881027395},null,"operating less feeder cost"]
[null,null,null,null,"÷",{"$f":"Input!E7","v":750},null,"lbs purchase weight"]
[null,null,null,null,"=",{"$f":"(F47-F48)/F49","v":1.2713029491963475},null,"/lb "]
[]
[null,"Operating & Labour Costs",null,null,null,{"$f":"F45","v":1012},null,"lbs shrunk weight"]
[null,null,null,null,"x",{"$f":"F46","v":200},null,"$/cwt selling price"]
[null,null,null,null,"=",{"$f":"F47","v":2024},null,"income"]
[null,null,null,null,"-",{"$f":"Summary!E23+Summary!E37-Summary!E11","v":1148.5227881027395},null,"operating less feeder cost"]
[null,null,null,null,"÷",{"$f":"F49","v":750},null,"lbs purchase weight"]
[null,null,null,null,"=",{"$f":"(F54-F55)/F56","v":1.1673029491963474},null,"/lb "]
[]
[null,"Operating & Fixed",null,null,null,{"$f":"F45","v":1012},null,"lbs shrunk weight"]
[null,null,null,null,"x",{"$f":"F46","v":200},null,"$/cwt selling price"]
[null,null,null,null,"=",{"$f":"F59*F60/100","v":2024},null,"income"]
[null,null,null,null,"-",{"$f":"Summary!E35-Summary!E11","v":1105.7227881027393},null,"op. & fixed less feeder cost"]
[null,null,null,null,"÷",{"$f":"F49","v":750},null,"lbs purchase weight"]
[null,null,null,null,"=",{"$f":"(F61-F62)/F63","v":1.2243696158630142},null,"/lb "]
[]
[null,"Total Costs",null,null,null,{"$f":"F45","v":1012},null,"lbs shrunk weight"]
[null,null,null,null,"x",{"$f":"F46","v":200},null,"$/cwt selling price"]
[null,null,null,null,"=",{"$f":"F66*F67/100","v":2024},null,"income"]
[null,null,null,null,"-",{"$f":"Summary!E39-Summary!E11","v":1183.7227881027393},null,"total less feeder cost"]
[null,null,null,null,"÷",{"$f":"F49","v":750},null,"lbs purchase weight"]
[null,null,null,null,"=",{"$f":"(F68-F69)/F70","v":1.1203696158630143},null,"/lb "]
[]
[]
[null,null,null,null,null,null,null,null,null,"October, 2022"]