{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Introduction","Summary","Input","Details"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":15,"comments":2,"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":[[28,1,32,10],[45,1,47,10],[14,1,20,10],[21,1,26,10],[4,0,4,10],[5,0,5,10],[6,0,6,10],[7,0,7,10]]}
[]
[]
[". . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . "]
[]
["Guidelines For Estimating"]
["Beef Replacement Heifer Costs"]
[{"$f":"\"For Weight Range of \"&Input!D14&\" - \"&ROUND(Input!D24,0)&\" lbs\"","v":"For Weight Range of 550 - 1200 lbs"}]
[{"$f":"\"Based on \"&Input!D11&\" Head\"","v":"Based on 30 Head"}]
[]
[]
[null,null,null,null,null,null,null,"Date:",null,"September, 2024"]
[]
[]
[]
[null,"This guide is designed to provide you with planning information and a format for calculating costs of production of a replacement heifer 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,"Replacement heifers generally refers to the feeding of heifer calves from weaning until they are put onto pasture for breeding.  An example of a typical replacement heifer operation would be, feed 550 pound heifers to gain 1.25 to 1.75 pounds per day for approximately 200 to 250 days and put on pasture for 120 to 140 days to gain 1.25 to 1.75 pounds per day to produce a 1200 pound bred replacement heifer."]
[]
[]
[]
[]
[]
[]
[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":73,"n_cols":10,"rows_kept":73,"cut":false,"hidden":false,"merged":[[0,0,0,9],[72,0,72,9],[1,0,1,9],[65,0,65,9]]}
[{"$f":"\"Replacement Heifer Production Cost Summary   \"&Introduction!J11","v":"Replacement Heifer Production Cost Summary   September, 2024"}]
[{"$f":"\"Based on \"&Input!D11&\" heifers for weight range \"&Input!D14&\" to \"&ROUND(Input!D24,0)&\" lbs.\"","v":"Based on 30 heifers for weight range 550 to 1200 lbs."}]
[]
["A.  Operating Costs",null,null,null,null,"Cost/Head",null,"Total Cost","","Your Cost"]
["1.  Feed Costs",null,null,null,null,""]
["    1.01  Ground Barley",null,null,null,null,{"$f":"Details!F20","v":136.5},null,{"$f":"ROUND(F6*Input!$D$11,0)","v":4095}]
["    1.02  Hay",null,null,null,null,{"$f":"Details!F27","v":233.13},null,{"$f":"ROUND(F7*Input!$D$11,0)","v":6994}]
["    1.03  Supplement",null,null,null,null,{"$f":"Details!F34","v":61.6},null,{"$f":"ROUND(F8*Input!$D$11,0)","v":1848}]
["    1.04  Other Feed",null,null,null,null,{"$f":"Details!F48","v":0},null,{"$f":"ROUND(F9*Input!$D$11,0)","v":0}]
["    Total Feed Costs",null,null,null,null,{"$f":"SUM(F6:F9)","v":431.23},null,{"$f":"SUM(H6:H9)","v":12937}]
["2.  Other Operating Costs"]
["    2.01  Heifer Cost",null,null,null,null,{"$f":"Details!F64","v":1942.2},null,{"$f":"ROUND(F12*Input!$D$11,0)","v":58266}]
["    2.02  Breeding Cost",null,null,null,null,{"$f":"Details!F122","v":45.46},null,{"$f":"ROUND(F13*Input!$D$11,0)","v":1364}]
["    2.03  Straw",null,null,null,null,{"$f":"Details!F128","v":31.36},null,{"$f":"ROUND(F14*Input!$D$11,0)","v":941}]
["    2.04  Veterinary Medicine & Supplies",null,null,null,null,{"$f":"Details!F153","v":19.2},null,{"$f":"ROUND(F15*Input!$D$11,0)","v":576}]
["    2.05  Annual Fuel & Repair Costs",null,null,null,null,{"$f":"Details!F159","v":8.33},null,{"$f":"ROUND(F16*Input!$D$11,0)","v":250}]
["    2.06  Utilities",null,null,null,null,{"$f":"Details!F164","v":4.37},null,{"$f":"ROUND(F17*Input!$D$11,0)","v":131}]
["    2.07  Replacement Heifer Selling Cost",null,null,null,null,{"$f":"Details!F178","v":58.3},null,{"$f":"ROUND(F18*Input!$D$11,0)","v":1749}]
["    2.08  Insurance",null,null,null,null,{"$f":"Details!F197","v":15.01},null,{"$f":"ROUND(F19*Input!$D$11,0)","v":450}]
["    2.09  Manure Removal",null,null,null,null,{"$f":"Details!F202","v":11.67},null,{"$f":"ROUND(F20*Input!$D$11,0)","v":350}]
["    2.10  Pasture Costs",null,null,null,null,{"$f":"Details!F212","v":147.5},null,{"$f":"ROUND(F21*Input!$D$11,0)","v":4425}]
["    2.11  Barn & Office Supplies",null,null,null,null,{"$f":"Details!F217","v":1.2},null,{"$f":"ROUND(F22*Input!$D$11,0)","v":36}]
["    2.12  Death Loss",null,null,null,null,{"$f":"Details!F225","v":27.42},null,{"$f":"ROUND(F23*Input!$D$11,0)","v":823}]
["Subtotal Operating Costs",null,null,null,null,{"$f":"ROUND(SUM(F10:F23),2)","v":2743.25},null,{"$f":"SUM(H10:H23)","v":82298}]
["    2.13  Operating Interest",null,null,null,null,{"$f":"Details!F235","v":175.22},null,{"$f":"ROUND(F25*Input!$D$11,0)","v":5257}]
["    Total Operating Costs",null,null,null,null,{"$f":"F24+F25","v":2918.47},null,{"$f":"H24+H25","v":87555}]
["B.  Fixed Costs"]
["3.  Depreciation"]
["    3.01  Buildings",null,null,null,null,{"$f":"Details!F267","v":16.28},null,{"$f":"F29*Input!D11","v":488.40000000000003}]
["    3.02  Machinery & Equipment",null,null,null,null,{"$f":"Details!F274","v":50.4},null,{"$f":"F30*Input!D11","v":1512}]
["4.  Investment",null,null,null,null,"",null,""]
["    4.01  Buildings",null,null,null,null,{"$f":"Details!F284","v":7.96},null,{"$f":"F32*Input!D11","v":238.8}]
["    4.02  Machinery & Equipment",null,null,null,null,{"$f":"Details!F292","v":15.12},null,{"$f":"F33*Input!D11","v":453.59999999999997}]
["    4.03  Pasture Land",null,null,null,null,{"$f":"Details!F304","v":0},null,{"$f":"F34*Input!D11","v":0}]
["Total Fixed Costs",null,null,null,null,{"$f":"SUM(F29:F34)","v":89.76},null,{"$f":"F35*Input!D11","v":2692.8}]
["Total Operating and Fixed Costs",null,null,null,null,{"$f":"SUM(F26+F35)","v":3008.23},null,{"$f":"H26+H35","v":90247.8}]
[]
["C.  Owners - Labour & Living",null,null,null,null,{"$f":"Details!F316","v":58.5},null,{"$f":"F38*Input!D11","v":1755}]
["Total Cost of Production",null,null,null,null,{"$f":"F36+F38","v":3066.73},null,{"$f":"H36+H38","v":92002.8}]
[]
[null,null,null,"Profitability and Breakeven Analysis"]
[]
["Estimated Farmgate Gross Revenue",null,null,null,null,null,"","Total"]
[{"$f":"\"    \"&Input!D28&\" Bred Heifers @ $\"&Input!D30&\"/hd market price\"","v":"    26 Bred Heifers @ $3600/hd market price"},null,null,null,null,null,null,{"$f":"ROUND(Input!D28*Input!D30,0)","v":93600}]
[{"$f":"\"    \"&Input!D29&\" Cull Heifers @ $\"&Input!D32&\"/hd ($\"&Input!D31&\"/cwt) market price\"","v":"    4 Cull Heifers @ $3300/hd ($275/cwt) market price"},null,null,null,null,null,null,{"$f":"ROUND(Input!D29*(Input!D24/100)*Input!D31,0)","v":13200}]
[null,null,null,null,null,null,null,{"$f":"SUM(H44:H45)","v":106800}]
[]
[null,null,null,null,null,"Breakeven",null,"Breakeven"]
[null,null,null,null,null,"Heifer Calf Purchase",null,"Bred Heifer Selling"]
[null,null,null,null,null,"Price ($/cwt) @",null,"Price ($/hd) @"]
["Breakeven Price",null,null,null,null,{"$f":"\"$\"&Input!D30&\"/hd market price\"","v":"$3600/hd market price"},null,{"$f":"\"$\"&Input!D15&\"/cwt heifer price\"","v":"$350/cwt heifer price"}]
["  Operating Costs",null,null,null,null,{"$f":"((H46/Input!D11)-(F26-F12))/(Input!$D$14/100)","v":469.76909090909101},null,{"$f":"($H$26-$H$45)/Input!D28","v":2859.8076923076924}]
["  Operating Costs & Labour",null,null,null,null,{"$f":"((H46/Input!D11)-(F26+F38-F12))/(Input!$D$14/100)","v":459.13272727272738},null,{"$f":"($H$26+H38-$H$45)/Input!D28","v":2927.3076923076924}]
["  Operating & Fixed Costs",null,null,null,null,{"$f":"((H46/Input!D11)-(F36-F12))/(Input!$D$14/100)","v":453.44909090909096},null,{"$f":"($H$36-$H$45)/Input!D28","v":2963.376923076923}]
["  Total Costs",null,null,null,null,{"$f":"((H46/Input!D11)-(F39-F12))/(Input!$D$14/100)","v":442.81272727272733},null,{"$f":"($H$39-$H$45)/Input!D28","v":3030.876923076923}]
[]
["Marginal Returns",null,null,"Per Bred Heifer ",null,"Per Cull Heifer ",null,"Total Return"]
["  Over Operating Costs",null,null,{"$f":"(Input!$D$30-F26)","v":681.5300000000002},null,{"$f":"(Input!$D$32-F26)","v":381.5300000000002},null,{"$f":"(H46-H26)","v":19245}]
["  Over Operating Costs & Labour",null,null,{"$f":"Input!$D$30-(F26+F38)","v":623.0300000000002},null,{"$f":"Input!$D$32-(F26+F38)","v":323.0300000000002},null,{"$f":"(H46-(H26+H38))","v":17490}]
["  Over Operating & Fixed Costs",null,null,{"$f":"(Input!$D$30-F36)","v":591.77},null,{"$f":"(Input!$D$32-F36)","v":291.77},null,{"$f":"(H46-(H26+H35))","v":16552.199999999997}]
["  Over Total Costs",null,null,{"$f":"(Input!$D$30-F39)","v":533.27},null,{"$f":"(Input!$D$32-F39)","v":233.26999999999998},null,{"$f":"(H46-H39)","v":14797.199999999997}]
[]
["Estimated Return on Investment (ROI)",null,null,null,null,{"$f":"(H46-H39)/H39","v":0.1608342354797897}]
["Estimated Return on Asset (ROA)",null,null,null,null,{"$f":"((H46-H26-H38-H32-H33)/Input!D155)","v":0.56462521008403366}]
[]
["Cost Summary"]
[]
[null,null,null,null,null,"Cost/Heifer/day"]
[null,{"$f":"\"Summer grazing (based on \"&Input!D22&\" days)\"","v":"Summer grazing (based on 140 days)"},null,null,null,{"$f":"SUM((F34+F21)/Input!D22)","v":1.0535714285714286}]
[null,{"$f":"\"Winter feed (based on \"&Input!D17&\" days)\"","v":"Winter feed (based on 224 days)"},null,null,null,{"$f":"SUM(F10/Input!D17)","v":1.9251339285714286}]
[null,{"$f":"\"Yardage (based on \"&Input!D17&\" days)\"","v":"Yardage (based on 224 days)"},null,null,null,{"$f":"(F14+F16+F17+F20+F29+F30+F32+F33+F38)/(Input!D17)","v":0.91066964285714291}]
[]
["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":"Input","index":2,"n_rows":160,"n_cols":13,"rows_kept":160,"cut":false,"hidden":false,"merged":[[46,3,46,4],[47,3,47,4],[1,0,1,6],[9,0,9,6],[45,0,45,6]]}
[null,null,null,null,null,null,null,null,null,null,"HIDE"]
["                 Replacement Heifer Production Costs"]
[]
["   Assumptions"]
["   1.  This budget outlines the cost of production for a replacement heifer enterprise."]
["   2.  Buildings and equipment are valued at new cost."]
["   3.  All feed is purchased."]
[]
[]
["Herd Profile"]
["Number of Replacement Heifers Purchased",null,null,30,"  head"]
["Number of Bulls",null,null,1,"bulls"]
["Heifer Mortality Rate",null,null,1,"  %"]
["Heifer Purchased Weight",null,null,550,"  lbs"]
["Heifer Calf Price",null,null,350,"  /cwt"]
[]
["Days on Feed (feedlot)",null,null,224,"  days"]
["Average Daily Gain (feedlot)",null,null,2,"  lbs/day",null,null,""]
["Replacement Heifer Ending Feedlot Weight",null,null,{"$f":"ROUND(D17*D18+D14,0)","v":998},"  lbs"]
[]
["On Pasture Weight",null,null,1000,"  lbs"]
["Days on Pasture",null,null,140,"  days"]
["Average Daily Gain (pasture)",null,null,1.43,"  lbs/day",null,null,""]
["Off Pasture Weight",null,null,{"$f":"ROUND(D22*D23+D21,0)","v":1200},"  lbs"]
[]
["Estimated Culling rate Bred Replacement Heifers",null,null,12,"  %"]
["Calculated culling rate Bred Replacement Heifers",null,null,{"$f":"SUM(D29/D11)*100","v":13.333333333333334},"  % (due to rounding)"]
["Number Bred Heifers Marketed",null,null,{"$f":"ROUND(D11*(1-D26/100),0)","v":26}]
["Number Cull Heifers marketed",null,null,{"$f":"ROUND(D11*(D26/100),0)","v":4}]
["Bred Replacement Heifer market value",null,null,3600,"  /head"]
["Cull heifer market price",null,null,275,"  /cwt"]
["Cull heifer market value",null,null,{"$f":"SUM(D24/100*D31)","v":3300},"  /head"]
[]
["Herd Replacement  (Bulls)"]
["Bull Replacement Rate",null,null,25,"%"]
["Original Cost",null,null,5000,"/bull"]
["Price Received/Cull Bull",null,null,3500,"/bull"]
[]
["Pasture Costs",null,null,null,"Usage",""]
["Rented Pasture Costs (per head per day)",null,null,1,100,"%"]
["Owned Pasture Land Value (per acre)",null,null,1800,0,"%"]
["Owned Pasture Carrying Capacity (acres/head)",null,null,2.5,{"$f":"SUM(E40:E41)","v":100},{"$f":"IF(E42<>100,\"ERROR - Must equal 100%\",\"\")","v":""}]
["Owned Pasture Property Taxes (per acre)",null,null,10]
["Pasture checking costs (ie. fuel)",null,null,225]
[]
["Feed Costs",null,null,null,null,null,null,""]
[null,"Market",null,"Replacement Heifer",null,null,"Days on "]
[null,"Price",null,"Requirement",null,null,"Feed"]
[]
["Ground Barley",4.5,"/bu",6.5,"lbs/day",null,{"$f":"D17","v":224}]
["Hay ",115,"/ton",18.100000000000001,"lbs/day",null,{"$f":"D17","v":224}]
["Mineral/Rumensin Pre Mix",550,"/ton",1,"lbs/day",null,{"$f":"D17","v":224}]
["Other Feed #1",0,"/ton",0,"lbs/day",null,0]
["Other Feed #2",0,"/ton",0,"lbs/day",null,0]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
["FOOTNOTE:  1 bushel (bu) barley = 48 lbs = 21.8 kg"]
["                         1 kilogram (kg) = 2.2046 pounds (lbs)"]
["                         1 tonne (t) = 1,000 kg",null,null,null,null,null,null,""]
[]
["Other Operating Costs",null,null,null,null,null,""]
[]
["  Heifer Purchase Costs"]
["     Buying Commission",null,null,5,"/head"]
["     Trucking-in ",null,null,1.9,"/cwt"]
["     Insurance fee ",null,null,1.75,"/head"]
[]
["  Straw Bedding",null,"","",null,null,""]
["     Heifers number of lbs/day",null,"",4,"/head",null,""]
["     Bulls - number of tons/Bull/Year",null,null,1]
["     Cost/Ton",null,"",70,"/ton",null,""]
[]
["  Veterinary Medicine & Supplies",null,null,"","",null,""]
["   Cattle Medication",null,"","",null,null,""]
["     IBR,BVD,PI3,BRSV, Pasteurella",null,null,5,"/head"]
["     Vitamin A-D",null,null,0.5,"/head"]
["     External & Internal Parasites",null,null,0.72,"/head"]
["     Blackleg & Haemophilus",null,null,1.65,"/head"]
["     Antibiotics",null,null,0,"/head"]
[]
["   Herd Health Program",null,"","",""]
["     Professional Services",null,"","",""]
["       Total Yearly Hours",null,null,1,"hours"]
["       Rate",null,null,180,"/hour"]
["     Transportation",null,null,""]
["       Total Kilometres (round trip)",null,null,80,"km"]
["       Rate",null,null,1,"/km"]
["       Number of Yearly Visits",null,null,2]
[]
["   Annual Fuel & Repair Costs"]
["     Repairs (Machinery, Equipment & Facilities)",null,null,100]
["     Fuel Costs",null,null,150]
["",null,"","",null,null,""]
["  Utilities",null,null,null,""]
["          Hydro - Rate",null,null,9.5869999999999997E-2,"/ kWh"]
[12,"kWh per heifer ",null,{"$f":"SUM(A96*D11*D95)","v":34.513199999999998}]
[0.25,"1000 watt waterer",null,{"$f":"SUM(A97*18)*(D17)*D95","v":96.636960000000002}]
[null,null,"Total Hydro",{"$f":"SUM(D96:D97)","v":131.15016}]
[]
["  Trucking Cost",null,null,null,""]
["     Average Weight",null,null,{"$f":"D24","v":1200},"/lbs per head"]
["     Trucking Cost",null,null,1.9,"/cwt"]
[]
["  Marketing Cost",null,null,null,""]
["     MBP/NCO Levy $/Head  ",null,null,5.5,"/head"]
["     Commission on Sales",null,null,30,"/head"]
["     Market Value ",null,"",{"$f":"SUM(D30*100)/D24","v":300},"/cwt"]
[]
["  Manure Removal",null,"","","",null,""]
["     Annual Cost for Removal",null,null,350]
[]
["  Insurance"]
["     Cost per $100 Capital Invested in"]
["       a) Livestock",null,null,0.45,"/$100"]
["       b) Building & Equipment",null,null,0.4,"/$100"]
["     Additional Coverage for Liability",null,null,49,"/year"]
[]
["  Barn & Office Supplies"]
["     Total yearly expense relating to barn",null,null,36]
[null,null,null,null,null,null,null,""]
[]
["Operating Interest Rate",null,null,7.5,"%"]
["Investment Interest Rate",null,null,4,"%"]
[]
["Feed Requirement Per Bull"]
["    Barley",null,null,7," lbs/day"]
["    Days/Year on Barley",null,null,120," days"]
["    Hay (Good Quality)",null,null,4," tons/yr"]
[]
["Breeding Costs"]
["    Health Management Costs ",null,null,10,"/bull"]
["    Semen Test",null,null,60,"/bull"]
[null,null,null,null,null,null,null,""]
["FOOTNOTE:  cwt = hundred-weight = 100 lbs",null,null,null,null,null,null,""]
[]
["Capital Costs",null,null,"Original","Salvage",null,"Useful"]
[null,null,null,"Value","Value",null,"Life"]
["  Buildings,Corrals & Water System",null,null,""]
["     Windbreak fence",null,null,800,10,"%",20,"years"]
["     Pens",null,null,800,10,"%",20,"years"]
["     Handling Facilities",null,null,2000,10,"%",20,"years"]
["     Waterers",null,null,1200,10,"%",20,"years"]
["     Gates",null,null,300,10,"%",20,"years"]
["     Feeders",null,null,500,10,"%",20,"years"]
["     Bunk Feeders",null,null,1250,10,"%",20,"years"]
["     Well & Pressure System",null,null,2000,10,"%",20,"years"]
["     Grain Bin",null,null,1000,10,"%",20,"years"]
["     Landscaping",null,null,1000,10,"%",20,"years"]
["     Total",null,null,{"$f":"SUM(D139:D148)","v":10850}]
[]
["  Machinery & Equipment",null,null,"","",null,""]
[{"$f":"\"     Tractors & Loader ($\"&TEXT(K152,\"#,###\")&\" @ \"&L152&\"%)\"","v":"     Tractors & Loader ($160,000 @ 4%)"},null,null,{"$f":"SUM(K152*(L152/100))","v":6400},20,"%",10,"years",null,null,160000,4,"%"]
["     Miscellaneous",null,null,12500,20,"%",10,"years"]
[null,null,null,null,null,null,""]
["  Total Investment",null,null,{"$f":"D149+D152+D153","v":29750}]
[null,null,null,null,null,null,null,""]
["Labour Costs",null,null,null,"Total"]
["  Feedlot Labour - Hours/heifer",null,null,null,1,"hours"]
["  Pasture Labour - Hours/day",null,null,null,0.25,"hours"]
["  Labour Rate",null,null,null,27,"/hour"]

{"sheet":"Details","index":3,"n_rows":336,"n_cols":10,"rows_kept":336,"cut":false,"hidden":false,"merged":[[331,0,333,9],[318,0,319,9],[322,0,323,9],[324,0,326,9],[320,0,321,9],[0,0,0,9],[236,1,236,9],[1,1,1,9],[317,0,317,9],[328,0,328,9]]}
["    Replacement Heifer Production Cost Worksheet"]
[]
["Assumptions"]
[]
[null,{"$f":"\"1.  Feedlot average daily gain (ADG) was assumed to be \"&Input!D18&\" lbs/day.\"","v":"1.  Feedlot average daily gain (ADG) was assumed to be 2 lbs/day."}]
[null,{"$f":"\"     Pasture average daily gain (ADG) was assumed to be \"&Input!D23&\" lbs/day.\"","v":"     Pasture average daily gain (ADG) was assumed to be 1.43 lbs/day."}]
[null,{"$f":"\"2.  It was assumed the heifer calves weighed in at \"&Input!D14&\" lbs shrunk weight,\"","v":"2.  It was assumed the heifer calves weighed in at 550 lbs shrunk weight,"}]
[null,{"$f":"\"     and was raised to \"&ROUND(Input!D19,0)&\" lbs (feedlot) and \"&ROUND(Input!D24,0)&\" lbs (pasture).\"","v":"     and was raised to 998 lbs (feedlot) and 1200 lbs (pasture)."}]
[null,{"$f":"\"3.  Days on feed was \"&Input!D17&\" and days on pasture was \"&Input!D22&\".\"","v":"3.  Days on feed was 224 and days on pasture was 140."}]
[null,{"$f":"\"4.  Investment in facilities and equipment was assumed to handle \"&Input!D11&\" head.\"","v":"4.  Investment in facilities and equipment was assumed to handle 30 head."}]
[]
[null,"A.  Operating Costs",null,null,null,null,null,null,null,"Your Cost"]
[]
[null,"1.  Feed Costs"]
[null,null,"1.01  Ground Barley"]
[null,null,null,null,null,{"$f":"Input!G50","v":224},null,"days on ground barley"]
[null,null,null,"x",null,{"$f":"Input!D50","v":6.5},null,"lbs/heifer/day"]
[null,null,null,"÷",null,48,null,"lbs/bu"]
[null,null,null,"x",null,{"$f":"Input!B50","v":4.5},null,"/bu"]
[null,null,null,"=",null,{"$f":"ROUND(((F16*F17)/F18)*F19,2)","v":136.5},null,"/heifer"]
[]
[null,null,"1.02  Hay"]
[null,null,null,null,null,{"$f":"Input!G51","v":224},null,"days on hay"]
[null,null,null,"x",null,{"$f":"Input!D51","v":18.100000000000001},null,"lbs/heifer/day"]
[null,null,null,"÷",null,2000,null,"lbs/ton "]
[null,null,null,"x",null,{"$f":"Input!B51","v":115},null,"/ton"]
[null,null,null,"=",null,{"$f":"ROUND(((F23*F24)/F25)*F26,2)","v":233.13},null,"/heifer"]
[]
[null,null,"1.03  Supplement (Salt, Minerals,Vitamins, Ionophore)"]
[null,null,null,null,null,{"$f":"Input!G52","v":224},null,"days on supplement"]
[null,null,null,"x",null,{"$f":"Input!D52","v":1},null,"lbs/heifer/day"]
[null,null,null,"÷",null,2000,null,"lbs/ton "]
[null,null,null,"x",null,{"$f":"Input!B52","v":550},null,"/ton"]
[null,null,null,"=",null,{"$f":"ROUND(((F30*F31)/F32)*F33,2)","v":61.6},null,"/heifer"]
[]
[null,null,"1.04  Other Feed"]
[null,null,null,null,null,{"$f":"Input!G53","v":0},null,"days on other feed"]
[null,null,null,"x",null,{"$f":"Input!D53","v":0},null,"lbs/heifer/day"]
[null,null,null,"÷",null,2000,null,"lbs/ton "]
[null,null,null,"x",null,{"$f":"Input!B53","v":0},null,"/ton"]
[null,null,null,"=",null,{"$f":"ROUND(((F37*F38)/F39)*F40,2)","v":0},null,"/heifer"]
[]
[null,null,null,null,null,{"$f":"Input!G54","v":0},null,"days on other feed"]
[null,null,null,"x",null,{"$f":"Input!D54","v":0},null,"lbs/heifer/day"]
[null,null,null,"÷",null,2000,null,"lbs/ton "]
[null,null,null,"x",null,{"$f":"Input!B54","v":0},null,"/ton"]
[null,null,null,"=",null,{"$f":"ROUND(((F43*F44)/F45)*F46,2)","v":0},null,"/heifer"]
[null,null,"Total","=",null,{"$f":"ROUND(F47+F41,2)","v":0},null,"/heifer"]
[]
[null,"2.  Other Operating Costs"]
[null,null,"2.01  Heifer Cost"]
[null,null,"Commission",null,null,{"$f":"Input!D64","v":5},null,"/heifer"]
[null,null,"Insurance",null,null,{"$f":"Input!D66","v":1.75},null,"/heifer"]
[]
[null,null,"Trucking-in",null,null,{"$f":"Input!D65","v":1.9},null,"/cwt"]
[null,null,null,"x",null,{"$f":"Input!D14","v":550},null,"/heifer"]
[null,null,null,"÷",null,100,null,"lbs/cwt",null,""]
[null,null,null,"=",null,{"$f":"ROUND(F55*F56/F57,2)","v":10.45},null,"/heifer"]
[]
[null,null,"Heifer",null,null,{"$f":"Input!D14","v":550},null,"lbs/heifer"]
[null,null,null,"x",null,{"$f":"Input!D15","v":350},null,"/cwt"]
[null,null,null,"÷",null,100,null,"lbs/cwt",null,""]
[null,null,null,"=",null,{"$f":"ROUND(F60/100*F61,2)","v":1925},null,"/heifer"]
[null,null,"Total","=",null,{"$f":"ROUND(F52+F53+F58+F63,2)","v":1942.2},null,"/heifer"]
[]
[null,null,"2.02  Breeding Costs"]
[null,null,"Feed for Bulls"]
[null,null,null,"Hay",null,null,null,""]
[null,null,null,null,null,{"$f":"Input!D128","v":4},null,"tons good quality "]
[null,null,null,null,"x",{"$f":"F26","v":115},"","/ton"]
[null,null,null,null,"x",{"$f":"Input!D12","v":1},null,"bulls"]
[null,null,null,null,"÷",{"$f":"Input!D11","v":30},null,"replacement heifers"]
[null,null,null,null,"=",{"$f":"ROUND(((F69*F70)*F71)/F72,2)","v":15.33},null,"/heifer"]
[]
[null,null,null,"Barley",null,{"$f":"Input!D126","v":7},null,"lbs barley/bull/day"]
[null,null,null,null,"x",{"$f":"Input!D127","v":120},null,"days"]
[null,null,null,null,"÷",48,null,"lbs/bu"]
[null,null,null,null,"x",{"$f":"Input!B50","v":4.5},null,"/bushel"]
[null,null,null,null,"x",{"$f":"F71","v":1},null,"bulls"]
[null,null,null,null,"÷",{"$f":"F72","v":30},null,"replacement heifers"]
[null,null,null,null,"=",{"$f":"ROUND(((F75*F76/F77)*(F78)*F79)/F80,2)","v":2.63},null,"/heifer"]
[]
[null,null,"Total",null,"=",{"$f":"ROUND(F73+F81,2)","v":17.96},null,"/heifer"]
[]
[null,null,"Straw for Bulls"]
[null,null,null,null,null,{"$f":"Input!D70","v":1},null,"tons/bull/year"]
[null,null,null,null,"x",{"$f":"Input!D71","v":70},null,"/ton"]
[null,null,null,null,"x",{"$f":"F79","v":1},null,"bulls"]
[null,null,null,null,"÷",{"$f":"F80","v":30},null,"replacement heifers"]
[null,null,null,null,"=",{"$f":"ROUND((F86*F87*F88)/F89,2)","v":2.33},null,"/heifer"]
[]
[null,null,"Vet & Medicine for Bulls"]
[null,null,null,null,null,{"$f":"Input!D132","v":60},null,"semen test"]
[null,null,null,null,"+",{"$f":"Input!D131","v":10},null,"total vet cost/bull"]
[null,null,null,null,"x",{"$f":"F88","v":1},null,"bulls"]
[null,null,null,null,"÷",{"$f":"F89","v":30},null,"replacement heifers"]
[null,null,null,null,"=",{"$f":"ROUND(((F93+F94)*F95)/F96,2)","v":2.33},null,"/heifer"]
[]
[null,null,"Replacement of Bulls"]
[null,null,null,null,null,{"$f":"Input!D36","v":5000},null,"bull cost"]
[null,null,null,null,"-",{"$f":"Input!D37","v":3500},null,"bull salvage value"]
[null,null,null,null,"x",{"$f":"Input!D35","v":25},null,"% replacement rate"]
[null,null,null,null,"x",{"$f":"F95","v":1},null,"bulls"]
[null,null,null,null,"÷",{"$f":"F96","v":30},null,"replacement heifers"]
[null,null,null,null,"=",{"$f":"ROUND(((F100-F101)*F102)*F103/F104,2)/100","v":12.5},null,"/heifer"]
[]
[null,null,"Investment in Bulls"]
[null,null,null,null,null,{"$f":"Input!D36","v":5000},null,"bull cost"]
[null,null,null,null,"+",{"$f":"Input!D37","v":3500},null,"bull salvage value"]
[null,null,null,null,"÷",2,null,"average"]
[null,null,null,null,"x",{"$f":"Input!D123","v":4},null,"% investment rate"]
[null,null,null,null,"x",{"$f":"F103","v":1},null,"bulls"]
[null,null,null,null,"÷",{"$f":"F104","v":30},null,"replacement heifers"]
[null,null,null,null,"=",{"$f":"ROUND((((F108+F109)/F110)*F111)*F112/F113,2)/100","v":5.6666999999999996},null,"/heifer"]
[]
[null,null,"Pasture Costs for Bulls"]
[null,null,null,null,null,{"$f":"SUM(Input!D22*Input!D40)","v":140},null,"/bull pasture cost"]
[null,null,null,null,"x",{"$f":"F112","v":1},null,"bulls"]
[null,null,null,null,"÷",{"$f":"F113","v":30},null,"replacement heifers"]
[null,null,null,null,"=",{"$f":"ROUND((F117*F118)/F119,2)","v":4.67},null,"/heifer"]
[]
[null,null,"Total",null,"=",{"$f":"ROUND(F83+F90+F97+F105+F114+F120,2)","v":45.46},null,"/heifer"]
[]
[null,null,"2.03 Straw"]
[null,null,null,"Heifers",null,{"$f":"Input!D69","v":4},null,"lbs/heifer/day"]
[null,null,null,"x",null,{"$f":"Input!D17","v":224},null,"days on feed"]
[null,null,null,"x",null,{"$f":"Input!D71","v":70},null,"/ton"]
[null,null,null,"=",null,{"$f":"ROUND((F125*F126)*(F127/2000),2)","v":31.36},null,"/heifer"]
[]
[null,null,"2.04 Veterinary Medicine & Supplies"]
[null,null,"Cattle Medication"]
[null,null,null,null,null,{"$f":"Input!D75","v":5},null,"IBR,BVD,PI3,BRSV,Pasteurella"]
[null,null,null,"+",null,{"$f":"Input!D76","v":0.5},null,"Vitamin A-D"]
[null,null,null,"+",null,{"$f":"Input!D77","v":0.72},null,"External & Internal Parasites"]
[null,null,null,"+",null,{"$f":"Input!D78","v":1.65},null,"Blackleg & Haemophilus"]
[null,null,null,"+",null,{"$f":"Input!D79","v":0},null,"Antibiotics"]
[null,null,null,"=",null,{"$f":"SUM(F132:F136)","v":7.8699999999999992},null,"/heifer"]
[]
[null,null,"Herd Health Program"]
[null,null,"  Professional Services"]
[null,null,null,null,null,180,null,"/hour charge"]
[null,null,null,"x",null,{"$f":"Input!D83","v":1},null,"hours"]
[null,null,null,"÷",null,{"$f":"Input!D11","v":30},null,"replacement heifers"]
[null,null,null,"=",null,{"$f":"ROUND(F141*F142/F143,2)","v":6},null,"/heifer"]
[]
[null,null,"  Transportation Costs"]
[null,null,null,null,null,{"$f":"Input!D87","v":1},null,"/km charge"]
[null,null,null,"x",null,{"$f":"Input!D86","v":80},null,"kilometres"]
[null,null,null,"x",null,{"$f":"Input!D88","v":2},null,"visits"]
[null,null,null,"÷",null,{"$f":"Input!D11","v":30},null,"replacement heifers"]
[null,null,null,"=",null,{"$f":"ROUND(F147*F148*F149/F150,2)","v":5.33},null,"/heifer"]
[]
[null,null,"Total","=",null,{"$f":"ROUND(F137+F144+F151,2)","v":19.2},null,"/heifer"]
[]
[null,null,"2.05  Annual Fuel & Repair Costs"]
[null,null,null,null,null,{"$f":"Input!D91","v":100},null,"repairs"]
[null,null,null,"+",null,{"$f":"Input!D92","v":150},null,"fuel costs"]
[null,null,null,"÷",null,{"$f":"Input!D11","v":30},null,"replacement heifers"]
[null,null,null,"=",null,{"$f":"ROUND(SUM(F156+F157)/F158,2)","v":8.33},null,"/heifer"]
[]
[null,null,"2.06  Utilities"]
[null,null,null,null,null,{"$f":"SUM(Input!D98)","v":131.15016},null,"cost/year"]
[null,null,null,"÷",null,{"$f":"Input!D11","v":30},null,"replacement heifers"]
[null,null,null,"=",null,{"$f":"ROUND((F162)/F163,2)","v":4.37},null,"/heifer"]
[]
[null,null,"2.07 Heifer Selling Cost"]
[null,null,"Trucking"]
[null,null,null,null,null,{"$f":"Input!D101","v":1200},null,"lbs/heifer"]
[null,null,null,"÷",null,100,null,"lbs/cwt"]
[null,null,null,"x",null,{"$f":"Input!D102","v":1.9},null,"trucking cost/cwt"]
[null,null,null,"=",null,{"$f":"ROUND(F168*F170/F169,2)","v":22.8},null,"/heifer"]
[]
[null,null,"MBP levy, selling commission"]
[null,null,null,"+",null,{"$f":"Input!D105","v":5.5},null,"MBP Levy"]
[null,null,null,"+",null,{"$f":"Input!D106","v":30},null,"commission "]
[null,null,null,"=",null,{"$f":"+F174+F175","v":35.5},null,"/heifer"]
[]
[null,null,"Total","=",null,{"$f":"F171+F176","v":58.3},null,"/heifer"]
[]
[null,null,"2.08  Insurance"]
[null,null,null,null,null,{"$f":"Input!D155","v":29750},null,"building & equipment investment"]
[null,null,null,"x",null,{"$f":"Input!D115","v":0.4},null,"/$100 capital"]
[null,null,null,"÷",null,100,null,"/$100 "]
[null,null,null,"÷",null,{"$f":"Input!D11","v":30},null,"replacement heifers"]
[null,null,null,"=",null,{"$f":"ROUND(F181*F182/F183/F184,2)","v":3.97},null,"/heifer"]
[]
[null,null,null,null,null,{"$f":"SUM(Input!D11*(Input!D14/100*Input!D15))+(Input!D12*Input!D36)","v":62750},null,"herd investment"]
[null,null,null,"x",null,{"$f":"Input!D114","v":0.45},null,"/$100 capital"]
[null,null,null,"÷",null,100,null,"/$100 "]
[null,null,null,"÷",null,{"$f":"Input!D11","v":30},null,"replacement heifers"]
[null,null,null,"=",null,{"$f":"ROUND(F187*F188/F189/F190,2)","v":9.41},null,"/heifer"]
[]
[null,null,null,null,null,{"$f":"Input!D116","v":49},null,"additional coverage for liability"]
[null,null,null,"÷",null,{"$f":"Input!D11","v":30},null,"replacement heifers"]
[null,null,null,"=",null,{"$f":"F193/F194","v":1.6333333333333333},null,"/heifer"]
[]
[null,null,"Total","=",null,{"$f":"ROUND(F185+F191+F195,2)","v":15.01},null,"/heifer"]
[]
[null,null,"2.09  Manure Removal"]
[null,null,null,null,null,{"$f":"Input!D110","v":350},null,"annual removal cost"]
[null,null,null,"÷",null,{"$f":"Input!D11","v":30},null,"replacement heifers"]
[null,null,null,"=",null,{"$f":"ROUND(F200/F201,2)","v":11.67},null,"/heifer"]
[]
[null,null,"2.10  Pasture Costs"]
[null,null,null,"Pasture Rental",null,{"$f":"Input!D40","v":1},null,"cost/head/day rental"]
[null,null,null,"÷",null,{"$f":"Input!D22","v":140},null,"days on pasture"]
[null,null,null,"x",null,{"$f":"Input!E40","v":100},null,"pasture usage"]
[null,null,null,"=",null,{"$f":"IF(Input!E42<>100,\"ERROR\",SUM(F205*F206)*F207/100)","v":140},null,"/heifer"]
[null,null,null,"Pasture Checking",null,{"$f":"Input!D44","v":225},null,"cost per year"]
[null,null,null,"÷",null,{"$f":"Input!D11","v":30},null,"replacement heifers"]
[null,null,null,"=",null,{"$f":"SUM(F209/F210)","v":7.5},null,"/heifer"]
[null,null,"Total","=",null,{"$f":"F208+F211","v":147.5},null,"/heifer"]
[]
[null,null,"2.11  Barn & Office Supplies"]
[null,null,null,null,null,{"$f":"Input!D119","v":36},null,"total barn expenses"]
[null,null,null,"÷",null,{"$f":"Input!D11","v":30},null,"replacement heifers"]
[null,null,null,"=",null,{"$f":"ROUND(F215/F216,2)","v":1.2},null,"/heifer"]
[]
[null,null,"2.12  Death Loss"]
[null,null,null,null,null,{"$f":"F64","v":1942.2},null,"heifer cost"]
[null,null,null,"+",null,{"$f":"Input!D30","v":3600},null,"maximum value"]
[null,null,null,"-",null,{"$f":"Summary!F18","v":58.3},null,"selling costs"]
[null,null,null,"÷",null,2,null,"average"]
[null,null,null,"x",null,{"$f":"Input!D13","v":1},null,"% mortality rate"]
[null,null,null,"=",null,{"$f":"ROUND(((F220+(F221-F222))/F223)*F224/100,2)","v":27.42},null,"/heifer"]
[]
[null,null,"2.13  Operating Interest"]
[null,null,"(Operating interest is charged on one half the subtotal operating costs)"]
[]
[null,null,null,null,null,{"$f":"F64","v":1942.2},null,"heifer cost"]
[null,null,null,"+",null,{"$f":"(Summary!F10+SUM(Summary!F13:F23))/2","v":400.52499999999998},null,"½ of feed & other costs"]
[null,null,null,"x",null,{"$f":"Input!D122","v":7.5},null,"% operating interest"]
[null,null,null,"x",null,{"$f":"SUM(Input!D17+Input!D22)","v":364},null,"days on feed & pasture"]
[null,null,null,"÷",null,365,null,"days /year"]
[null,null,null,"=",null,{"$f":"ROUND(((F230+F231)*(F232)*(F233/F234/100)),2)","v":175.22},null,"/heifer"]
[]
[null,"Capital Costs"]
[]
[null,null,"  Buildings,Corrals & Water System"]
[null,null,"     Windbreak fence",null,null,null,null,{"$f":"Input!D139","v":800}]
[null,null,"     Pens",null,null,null,null,{"$f":"Input!D140","v":800}]
[null,null,"     Handling Facilities",null,null,null,null,{"$f":"Input!D141","v":2000}]
[null,null,"     Waterers",null,null,null,null,{"$f":"Input!D142","v":1200}]
[null,null,"     Gates",null,null,null,null,{"$f":"Input!D143","v":300}]
[null,null,"     Feeders",null,null,null,null,{"$f":"Input!D144","v":500}]
[null,null,"     Bunk Feeders",null,null,null,null,{"$f":"Input!D145","v":1250}]
[null,null,"     Well & Pressure System",null,null,null,null,{"$f":"Input!D146","v":2000}]
[null,null,"     Grain Bin",null,null,null,null,{"$f":"Input!D147","v":1000}]
[null,null,"     Landscaping",null,null,null,null,{"$f":"Input!D148","v":1000}]
[null,null,"     Total",null,null,null,null,{"$f":"SUM(H240:H249)","v":10850}]
[]
[null,null,"  Machinery & Equipment",null,null,null,""]
[null,null,"     Tractor & Loader",null,null,null,null,{"$f":"Input!D152","v":6400}]
[null,null,"     Miscellaneous",null,null,null,null,{"$f":"Input!D153","v":12500}]
[null,null,"     Total",null,null,null,null,{"$f":"SUM(H253:H254)","v":18900}]
[]
[null,null,"  Total Investment",null,null,null,null,{"$f":"H250+H255","v":29750}]
[]
[null,"B.  Fixed Costs"]
[null,"3.  Depreciation",null,null,null,"Original Cost - Salvage Value"]
[null,null,null,null,null,"Useful Life"]
[null,null,"3.01  Buildings"]
[null,null,null,null,null,{"$f":"Input!D149","v":10850},null,"original cost"]
[null,null,null,"-",null,{"$f":"ROUND(Input!D149*(Input!E139/100),2)","v":1085},null,"salvage value"]
[null,null,null,"÷",null,{"$f":"Input!G139","v":20},null,"years useful life"]
[null,null,null,"÷",null,{"$f":"Input!D11","v":30},null,"replacement heifers"]
[null,null,null,"=",null,{"$f":"ROUND(((F263-F264)/F265/F266),2)","v":16.28},null,"/heifer"]
[]
[null,null,"3.02  Machinery & Equipment"]
[null,null,null,null,null,{"$f":"Input!D152+Input!D153","v":18900},null,"original cost"]
[null,null,null,"-",null,{"$f":"ROUND(F270*(Input!E152/100),2)","v":3780},null,"salvage value"]
[null,null,null,"÷",null,{"$f":"Input!G152","v":10},null,"years useful life"]
[null,null,null,"÷",null,{"$f":"Input!D11","v":30},null,"replacement heifers"]
[null,null,null,"=",null,{"$f":"ROUND(((F270-F271)/F272/F273),2)","v":50.4},null,"/heifer"]
[]
[null,"4.  Investment",null,null,"   Original Cost + Salvage Value  x  Investment Rate"]
[null,null,null,null,null,"       2"]
[null,null,"4.01  Buildings"]
[null,null,null,null,null,{"$f":"F263","v":10850},null,"original cost"]
[null,null,null,"+",null,{"$f":"F264","v":1085},null,"salvage value"]
[null,null,null,"÷",null,2,null,"average"]
[null,null,null,"x",null,{"$f":"Input!D123","v":4},null,"% investment rate"]
[null,null,null,"÷",null,{"$f":"Input!D11","v":30},null,"replacement heifers"]
[null,null,null,"=",null,{"$f":"ROUND(((F279+F280)/F281*(F282/100)/F283),2)","v":7.96},null,"/heifer"]
[]
[null,null,"4.02  Machinery & Equipment"]
[null,null,null,null,null,{"$f":"F270","v":18900},null,"original cost "]
[null,null,null,"+",null,{"$f":"F271","v":3780},null,"salvage value"]
[null,null,null,"÷",null,2,null,"average"]
[null,null,null,"x",null,{"$f":"Input!D123","v":4},null,"% investment rate"]
[null,null,null,"÷",null,{"$f":"Input!D11","v":30},null,"replacement heifers"]
[null,null,null,"=",null,{"$f":"ROUND(((F287+F288)/F289*(F290/100)/F291),2)","v":15.12},null,"/heifer"]
[null,null,"4.03  Pasture"]
[null,null,null,"Land",null,{"$f":"Input!D42","v":2.5},null,"acres/head"]
[null,null,null,"x",null,{"$f":"Input!D41","v":1800},null,"/acre"]
[null,null,null,"x",null,{"$f":"Input!D123","v":4},null,"% investment rate"]
[null,null,null,"x",null,{"$f":"Input!E41","v":0},null,"pasture usage"]
[null,null,null,"=",null,{"$f":"(ROUND((F294*F295*(F296/100)*(F297/100)),2))","v":0},null,"/heifer"]
[]
[null,null,null,"Taxes",null,{"$f":"Input!D42","v":2.5},null,"acres/head"]
[null,null,null,"x",null,{"$f":"Input!D43","v":10},null,"/acre"]
[null,null,null,"x",null,{"$f":"Input!E41","v":0},null,"pasture usage"]
[null,null,null,"=",null,{"$f":"(ROUND((F300*F301*(F302/100)),2))","v":0},null,"/heifer"]
[null,null,"Total","=",null,{"$f":"F298+F303","v":0},null,"/heifer"]
[]
[null,"C. Labour"]
[null,null,"Feedlot",null,null,{"$f":"Input!E158","v":1},null,"hours/heifer"]
[null,null,null,"x",null,{"$f":"Input!E160","v":27},null,"/hour"]
[null,null,null,"=",null,{"$f":"ROUND(F307*F308,2)","v":27},null,"/heifer "]
[]
[null,null,"Pasture",null,null,{"$f":"Input!E159","v":0.25},null,"hours/day pasture"]
[null,null,null,"x",null,{"$f":"Input!D22","v":140},null,"days on pasture"]
[null,null,null,"÷",null,{"$f":"Input!D11","v":30},null,"replacement heifers"]
[null,null,null,"x",null,{"$f":"Input!E160","v":27},null,"/hour"]
[null,null,null,"=",null,{"$f":"ROUND(F311*F312*F314/F313,2)","v":31.5},null,"/heifer"]
[null,null,"Total","=",null,{"$f":"F309+F315","v":58.5},null,"/heifer"]
[]
["Profitability and Breakeven Analysis:"]
[{"$f":"\"Breakeven Bred Heifer Price ($/hd) = (total cost - cull heifer revenue) / # bred heifers sold \neg.($\"&TEXT(Summary!H39,\"#,###\")&\" - $\"&TEXT(Summary!H45,\"#,###\")&\") / \"&Input!D28&\" = $\"&TEXT(Summary!H55,\"#,###.##\")","v":"Breakeven Bred Heifer Price ($/hd) = (total cost - cull heifer revenue) / # bred heifers sold \neg.($92,003 - $13,200) / 26 = $3,030.88"}]
[]
[{"$f":"\"Breakeven Heifer Price ($/cwt) =(((gross revenue / # heifers) - (total cost - heifer cost)) / (heifer purchase wt. / 100))  eg.((($\"&TEXT(Summary!H46,\"#,###\")&\" / \"&Input!D11&\") - ($\"&TEXT(Summary!F39,\"#,###.##\")&\" - $\"&TEXT(Summary!F12,\"#,###.##\")&\")) / (\"&Input!D14&\" /100)) = $\"&TEXT(Summary!F55,\"#,###.##\")","v":"Breakeven Heifer Price ($/cwt) =(((gross revenue / # heifers) - (total cost - heifer cost)) / (heifer purchase wt. / 100))  eg.((($106,800 / 30) - ($3,066.73 - $1,942.2)) / (550 /100)) = $442.81"}]
[]
[{"$f":"\"Return on Investment (ROI) = (Gross Revenue - Total Cost) / Total Cost \n(eg. ($\"&TEXT(Summary!H46,\"#,###\")&\" - $\"&TEXT(Summary!H39,\"#,###\")&\") / $\"&TEXT(Summary!H39,\"#,###\")&\" = \"&TEXT(100*Summary!F63,\"0.0\")&\"%\"","v":"Return on Investment (ROI) = (Gross Revenue - Total Cost) / Total Cost \n(eg. ($106,800 - $92,003) / $92,003 = 16.1%"}]
[]
[{"$f":"\"Return on Asset (ROA) = ((Margin Over Operating - Labour - Building Depreciation - Machinery Depreciation) / Building, Machinery & Equipment Investment) \n(eg. (($\"&TEXT(Summary!H58,\"#,###\")&\" - $\"&TEXT(Summary!H38,\"#,###\")&\" - $\"&TEXT(Summary!H29,\"#,###\")&\" - $\"&TEXT(Summary!H30,\"#,###\")&\") / $\"&TEXT(Input!D155,\"#,###\")&\") = \"&TEXT(100*Summary!F64,\"0.0\")&\"%\"","v":"Return on Asset (ROA) = ((Margin Over Operating - Labour - Building Depreciation - Machinery Depreciation) / Building, Machinery & Equipment Investment) \n(eg. (($19,245 - $1,755 - $488 - $1,512) / $29,750) = 56.5%"}]
[]
[]
[]
["Cost Summary:"]
[{"$f":"\"Summer Grazing Cost Per Heifer Per Day =  pasture cost ÷ days (eg. $\"&TEXT(F304+F212, \"0.00\")&\" ÷ \"&Input!D22&\" = $\"&TEXT(Summary!F69,\"0.00\")&\")\"","v":"Summer Grazing Cost Per Heifer Per Day =  pasture cost ÷ days (eg. $147.50 ÷ 140 = $1.05)"}]
[{"$f":"\"Winter Feed Cost Per Heifer Per Day = feed cost ÷ days (eg. $\"&TEXT(F20+F27+F34+F48, \"0.00\")&\" ÷ \"&Input!D17&\" = $\"&TEXT(Summary!F70,\"0.00\")&\")\"","v":"Winter Feed Cost Per Heifer Per Day = feed cost ÷ days (eg. $431.23 ÷ 224 = $1.93)"}]
[{"$f":"\"Yardage Cost Per Heifer Per Day =  ($\"&TEXT(Summary!F14,\"0.00\")&\" straw + $\"&TEXT(Summary!F16,\"0.00\")&\" fuel & repair + $\"&TEXT(Summary!F17,\"0.00\")&\" utilities + $\"&TEXT(Summary!F20,\"0.00\")&\" manure removal + $\"&TEXT(Summary!F29,\"0.00\")&\" building depreciation+ $\"&TEXT(Summary!F30,\"0.00\")&\" machinery depreciation + $\"&TEXT(Summary!F32,\"0.00\")&\" building investment + $\"&TEXT(Summary!F33,\"0.00\")&\" machinery investment + $\"&TEXT(Summary!F38,\"0.00\")&\" labour) ÷ \"&Input!D17&\" days = $\"&TEXT(Summary!F71,\"0.00\")","v":"Yardage Cost Per Heifer Per Day =  ($31.36 straw + $8.33 fuel & repair + $4.37 utilities + $11.67 manure removal + $16.28 building depreciation+ $50.40 machinery depreciation + $7.96 building investment + $15.12 machinery investment + $58.50 labour) ÷ 224 days = $0.91"}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"September, 2024"]