{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Instructions","Feed Requirements Tool","data","Brassica Forage Crop Planner","NOTES TO CONSIDER","Beef Marginal Profit Calculator","Sheep Marginal Profit Calculato","Feed Cost Calc","Beef Marginal Profit Demo","Sheep Marginal Profit Demo","Drop box definitions"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":2,"defined_names":0,"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":"Instructions","index":0,"n_rows":60,"n_cols":2,"rows_kept":60,"cut":false,"hidden":false,"merged":[[19,1,20,17],[5,1,5,13]]}
[]
[]
[]
[]
[]
[null,"Grazing Management Tools"]
[null,"Version 1.1 March 2018"]
[]
[null,"The purpose of the Grazing Management Tools is to assist producers to optimise production of brassica forage crops, better understand the costs     "]
[null,"of different feeds and provide guidance on the financial implications of trading of livestock (sheep and beef). "]
[null,"Clicking on the blue buttons below will take you to the tool you are interested in."]
[null,"When you are in a tool, to return to this page click on the blue \"Instructions\" button"]
[null,"In each tool, the green cells require you to input information, while the yellow cells automatically calculate answers."]
[null,"To prevent users over-writing formulas in the tools, the tools are protected, so that only the green cells can be edited by users. However, for those proficient in excel"]
[null,"who may wish to modify the tools the password to unprotect tools is \"livestock\". It is recommended that users who do modify the tool retain a back up copy of the original."]
[]
[]
[]
[]
[null,"The Feed Requirements Tool calculates how much dry matter is required to increase an animal's live weight, including the maintenance requirements."]
[]
[]
[]
[]
[null,"The Brassica Forage Crop Planner is a guide to assist in planning animal numbers and finishing times for optimal liveweight gains on brassica crops."]
[null,"This tool has 2 tabs - the Brassica Forage Crop Planner and the NOTES TO CONSIDER tabs. It is recommended to read the 'notes to consider' before trying to use the tool."]
[]
[" "]
[]
[]
[null,"The Beef Marginal Profit Calculator is designed as a guide to assist with making the decision of whether to sell your cattle now or to sell later. It can be used with the feed cost calculator."]
[]
[]
[]
[]
[null,"The Sheep Marginal Profit Calculator is designed as a guide to assist with making the decision of whether to sell your sheep now or to sell later. It can be used with the feed cost calculator."]
[]
[]
[]
[]
[null,"The Feed Cost Calculator is a tool designed to make it easy to calculate the cost of feed ($/kg DM) for silage, hay, grains and pellets, nitrogen application to pasture and irrigation of pasture."]
[]
[]
[]
[]
[null,"The Beef Marginal Profit Calculator Demo has been included to demonstrate the outcomes which can be generated using on-farm data."]
[]
[]
[]
[]
[null,"The Sheep Marginal Profit Calculator Demo has been included to demonstrate the outcomes which can be generated using on-farm data."]
[]
[null,"Disclaimer"]
[null,"Macquarie Franklin, who developed the Grazing Management Tools, expressly disclaim all and any legal liability and responsibility whatsoever arising from or connected with:"]
[null,"•  the accuracy, reliability, validity, currency or completeness of the base assumptions supplied;"]
[null,"•  the accuracy, reliability, validity, currency or completeness of any results obtained from the use of the tool;"]
[null,"•  the consequences of anything done or omitted to be done by any person, either in whole or in part, in reliance of any such information, model spreadsheet or results; and"]
[null,"•  any combination of any of the above."]
[]
[null,"Copyright"]

{"sheet":"Feed Requirements Tool","index":1,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[7,1,7,2],[4,1,5,6],[0,1,2,6]]}
[null,"Feed Requirements Tool"]
[]
[]
[]
[null,"To use this tool, insert your own figures into the green boxes.  Figures highlighted in the yellow boxes will be automatically calculated for you."]
[]
[]
[null,"Dry matter requirement tool"]
[null,"Animal class"]
[null,"Liveweight (kg)"]
[null,"Liveweight gain required (kg/day)"]
[null,"Dry matter required (kg/head/day)",{"$f":"IFERROR(((VLOOKUP(C9,data!A3:B4,2,FALSE))+(C11*4)),0)","v":0}]
[]
[null,"Please note that the feed requirement tool is based on 1kg DM = 10.5ME"]

{"sheet":"data","index":2,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
[]
["Animal class"]
["Cattle",{"$f":"('Feed Requirements Tool'!C10/100)+1","v":1}]
["Sheep",{"$f":"('Feed Requirements Tool'!C10*2)/100","v":0}]

{"sheet":"Brassica Forage Crop Planner","index":3,"n_rows":52,"n_cols":8,"rows_kept":52,"cut":false,"hidden":false,"merged":[[0,1,2,5],[3,1,4,5],[17,1,17,3],[35,1,35,3],[6,1,6,3],[17,5,17,7],[35,5,35,7]]}
[null,"Brassica Forage Crop Planner - Multi Graze"]
[]
[]
[null,"To use this tool, insert your own figures into the green boxes.  Figures highlighted in the yellow boxes will be automatically calculated for you."]
[]
[]
[null,"Crop Data"]
[null,"Forage crop type"]
[null,"Forage crop variety"]
[null,"Multiple Grazing Option"]
[null,"Paddock area",null,"ha"]
[null,"Seed sowing rate",null,"kg/ha"]
[null,"Total seed required",{"$f":"SUM(C12*C11)","v":0},"kg"]
[null,"Crop maturity period",null,"days"]
[null,"Crop regrowth period",null,"days"]
[null,"Sowing date"]
[]
[null,"1st Grazing",null,null,null,"Yield Assessment Tool (further detail in 'notes to consider tab' on how to use this tool)"]
[null,"Start grazing date",{"$f":"C16+C14","v":"00:00:00"},null,null,"Sample wet weight #1",null,"kg/m2"]
[null,"Finish grazing date",{"$f":"C19+C34","v":"00:00:00"},null,null,"Sample wet weight #2",null,"kg/m2"]
[null,"Predicted/measured grazing crop yield",null,"kg DM/ha",null,"Sample wet weight #3",null,"kg/m2"]
[null,"Predicted/measured crop growth rate during grazing",null,"kg DM/ha/day",null,"Sample wet weight #4",null,"kg/m2"]
[null,"Total predicted/measured grazing crop yield",{"$f":"SUM(C21*C11)+(C22*C34*C11)","v":0},"kg DM",null,"Sample wet weight #5",null,"kg/m2"]
[null,"Livestock type ",null,null,null,"Average wet weight",{"$f":"IFERROR((AVERAGE(G19:G23)),0)","v":0},"kg/m2"]
[null,"Stock numbers "]
[null,"Grazing efficiency",null,null,null,"Total average wet weight",{"$f":"G24*10000","v":0},"kg/ha"]
[null,"Daily feed requirement",null,"kg DM/head/day"]
[null,"Per head crop daily allocation",{"$f":"IFERROR((C27/C26),0)","v":0},"kg DM/head/day",null,"Crop DM",null,"see notes to consider sheet"]
[null,"Mob crop daily allocation",{"$f":"C28*C25","v":0},"kg DM/mob/day"]
[null,"Mob crop area allocation",{"$f":"IFERROR((C29/(C21)),0)","v":0},"ha/day",null,"Measured crop yield",{"$f":"G26*G28","v":0},"kg DM/ha"]
[null,"Rumen adjustment period",null,"days"]
[null,"Full crop allocation period",{"$f":"IFERROR((SUM((C11/C30)-(C31*0.5*C30))),0)","v":0},"days"]
[]
[null,"Total mob days first grazing",{"$f":"C32+C31","v":0},"days"]
[]
[null,"2nd Grazing",null,null,null,"Yield Assessment Tool (further detail in 'notes to consider tab' on how to use this tool)"]
[null,"Start grazing date",{"$f":"C20+C15","v":"00:00:00"},null,null,"Sample wet weight #1",null,"kg/m2"]
[null,"Finish grazing date",{"$f":"IFERROR((C37+C52),0)","v":"00:00:00"},null,null,"Sample wet weight #2",null,"kg/m2"]
[null,"Predicted/measured grazing crop yield",null,"kg DM/ha",null,"Sample wet weight #3",null,"kg/m2"]
[null,"Predicted/measured crop growth rate during grazing",null,"kg DM/ha/day",null,"Sample wet weight #4",null,"kg/m2"]
[null,"Total predicted/measured grazing crop yield",{"$f":"IFERROR(((C39*C11)+(C40*C52*C11)),0)","v":0},"kg DM",null,"Sample wet weight #5",null,"kg/m2"]
[null,"Livestock type ",null,null,null,"Average wet weight",{"$f":"IFERROR((AVERAGE(G37:G41)),0)","v":0},"kg/m2"]
[null,"Stock numbers "]
[null,"Grazing efficiency",null,null,null,"Total average wet weight",{"$f":"G42*10000","v":0},"kg/ha"]
[null,"Daily feed requirement",null,"kg DM/head/day"]
[null,"Per head crop daily allocation",{"$f":"IFERROR((C45/C44),0)","v":0},"kg DM/head/day",null,"Crop DM",null,"see notes to consider sheet"]
[null,"Mob crop daily allocation",{"$f":"C46*C43","v":0},"kg DM/mob/day"]
[null,"Mob crop area allocation",{"$f":"IFERROR((C47/C39),0)","v":0},"ha/day",null,"Measured crop yield",{"$f":"G44*G46","v":0},"kg DM/ha"]
[null,"Rumen adjustment period",0,"days"]
[null,"Full crop allocation period",{"$f":"IFERROR(((C11/C48)+(C49*0.5*C48)),0)","v":0},"days"]
[]
[null,"Total mob days second grazing",{"$f":"C49+C50","v":0},"days"]

{"sheet":"NOTES TO CONSIDER","index":4,"n_rows":56,"n_cols":1,"rows_kept":56,"cut":false,"hidden":false,"merged":[[11,0,12,2],[0,0,0,2],[1,0,2,2],[3,0,5,2],[6,0,8,2],[9,0,10,2],[13,0,14,2],[18,0,19,2],[26,0,27,2],[42,0,43,2],[55,0,55,2],[28,0,28,2],[29,0,30,2],[31,0,33,2],[48,0,54,2],[41,0,41,2],[15,0,17,2]]}
["Notes to consider for the Brassica Forage Crop Planner"]
["Beef cattle should only be allocated a maximum of 70% of their total daily dietary DM intake as a forage brassica."]
[]
["Dairy cattle (milking) should only be allocated a maximum of 33% of their total daily dietary DM intake as a forage brassica crop. Avoid feeding brassicas for 2 weeks after cows have calved."]
[]
[]
["Dairy cattle (dry) should only be allocated a maximum of 70% of their total daily dietary DM intake as a forage brassica crop. During late pregnancy avoid feeding brassicas to cows due to the increased risk of metabolic disorders."]
[]
[]
["Sheep, as ewes (dry), lambs and wethers can be allocated up to 90-100% of their daily dietary DM intake as a forage brassica crop.  "]
[]
["Ewes in late pregnancy and during lambing should not be fed brassicas due to the risk of calcium deficiency and other metabolic disorders."]
[]
["Seek professional animal nutrition advice to ensure the livestock feed allocations match the animal performance expectations, and the risk of negative animal health issues are able to be prevented."]
[]
["The rumen adjustment period is the time required for an animal's rumen microbes to be able to fully breakdown and enable the absorption of the nutrients within the brassica feed. Typically this will take at least 7 days."]
[]
[]
["Seed sowing rates vary with the type of forage crops being grown, seed coating used, sowing method and seedbed quality. Typical rates are as follows:"]
[]
["Fodder radish: 3-4 kg/ha"]
["Leafy turnip: 2-3 kg/ha"]
["Kale: 3-5 kg/ha"]
["Rape: 3-5 kg/ha"]
["Swedes: 1.5-2 kg/ha"]
["Turnips: 1.5 - 2kg/ha"]
["For a well prepared seedbed, and if drilling seed, use the lower sowing rate. Seek agronomic advice for confirmation."]
[]
["Yield Assessment Tool"]
["1. Obtain 3 to 5 representative 1m2 crop samples. Avoid sampling near water troughs, gate ways or areas of the crop that are not typical of the majority of the paddock."]
[]
["2. Weigh each of the samples to obtain a wet weight yield                                                                 3. Use the yield assessment tool (in the Brassica Forage Crop Planner Tool) to give an accurate value for crop yield (kg DM/ha)"]
[]
[]
["Typical brassica crop dry matter values are;"]
["Fodder radish: 13%"]
["Kale: 13%"]
["Leafy turnip: 13%"]
["Rape: 13%"]
["Swedes: 10%"]
["Turnips: 10%"]
["A feed test can be used to determine the exact crop dry matter values."]
["Grazing efficiency varies with the grazing method, crop quality & maturity (rotting bulbs & decayed leaves) and weather conditions during grazing, consider;"]
[]
["Strip grazing: 80-90% utilisation"]
["Set stocking: 70-80% utilisation"]
["Over mature crop: reduce utilisation by 10-20%"]
["Waterlogged soils: reduce utilisation by 10-20%"]
["The re-growth period for fodder radish, leafy turnip and rape crops can vary considerably depending upon seasonal conditions, available soil moisture and soil fertility (especially nitrogen). From mid spring to mid autumn, with good soil fertility and under irrigation it is reasonable to consider the opportunity to re-graze these crops in approximately 40-50 days. During cooler growing conditions the re-growth period can be extended by up to double the time frame. If the soils become too wet or too dry then the brassica recovery post grazing can be minimal."]
[]
[]
[]
[]
[]
[]
["Ensure all livestock grazing on forage brassica crops have unrestricted access to water."]

{"sheet":"Beef Marginal Profit Calculator","index":5,"n_rows":61,"n_cols":12,"rows_kept":61,"cut":false,"hidden":false,"merged":[[0,1,2,9],[21,8,21,10],[22,8,22,10],[23,8,23,10],[20,8,20,10]]}
[null,"Beef Trading Marginal Profit Calculator - sell now or sell later"]
[]
[]
[null,"To use this tool, insert your own figures into the green boxes.  Figures highlighted in the yellow boxes will be automatically calculated for you."]
[null,"In the composition and cost of diet table, the pale green cells (\"your $/kg DM\") are linked to the Feed Cost Calculator. Either use the Feed Cost Calculator to determine your own feed costs, or "]
[null,"average feed costs will be used (the grey cells, \"average $/kg DM\")"]
[]
[null,"Sell Now"]
[null,"Current individual live weight",null,"x price $/kg LW",null,"=",{"$f":"C9*E9","v":0},"per head"]
[null,"Sell now date"]
[null,"Number of animals",null,null,null,null,{"$f":"G9*C11","v":0},"mob value"]
[]
[null,"Weight Gain"]
[null,"Number of days to sale if selling later",null,"days"]
[null,"Sell later date",{"$f":"C10+C14","v":"00:00:00"}]
[null,"Target weight at sale",null,"kg LW/head"]
[null,"Average weight now",{"$f":"C9","v":0},"kg LW/head"]
[null,"Average liveweight gain",{"$f":"IFERROR((SUM((C16-C17)/C14)),0)","v":0},"kg LWG/day"]
[null,"Average daily feed requirement per head",{"$f":"L24","v":1},"kg DM/hd/day"]
[]
[null,"Composition and Cost of Diet","kg DM/day","your $/kg DM","average $/kg DM"," $/day/head",null,null,"Average Daily Feed Requirement",null,null,"kg DM/hd/day"]
[null,"Dryland pasture",null,0.02,0.02,{"$f":"IF(D22>0,D22*C22,E22*C22)","v":0},null,null,"Maintenance",null,null,{"$f":"SUM(((C16/2)+(C17/2))/100)+1","v":1}]
[null,"Dryland pasture + N fert",null,{"$f":"D22+'Feed Cost Calc'!K23","v":0.02},0.17,{"$f":"IF(D23>0,D23*C23,E23*C23)","v":0},null,null,"LWG",null,null,{"$f":"C18*4","v":0}]
[null,"Irrigated pasture",null,{"$f":"'Feed Cost Calc'!G44","v":0},0.12,{"$f":"IF(D24>0,D24*C24,E24*C24)","v":0},null,null,"Total Daily Requirement",null,null,{"$f":"SUM(L22:L23)","v":1}]
[null,"Irrigated pasture + N fert",null,{"$f":"'Feed Cost Calc'!G44+'Feed Cost Calc'!K23","v":0},0.28999999999999998,{"$f":"C25*E25","v":0}]
[null,"Brassica crop",null,{"$f":"'Feed Cost Calc'!C69","v":0},0.15,{"$f":"C26*E26","v":0}]
[null,"Grain/pellets",null,{"$f":"'Feed Cost Calc'!K40","v":0},0.35,{"$f":"C27*E27","v":0}]
[null,"Hay",null,{"$f":"'Feed Cost Calc'!G26","v":0},0.35,{"$f":"C28*E28","v":0}]
[null,"Silage",null,{"$f":"'Feed Cost Calc'!C26","v":0},0.6,{"$f":"C29*E29","v":0}]
[null,"Total daily allocation",{"$f":"SUM(C22:C29)","v":0},null,null,{"$f":"SUM(F22:F29)","v":0}]
[]
[null,"Balance Sheet"]
[null,"Income"]
[null,"Liveweight",{"$f":"C16","v":0},"x price $/kg LW",null,"=",{"$f":"C34*E34","v":0},"per head"]
[null,"Number of animals finished"]
[null,"Production Cost"]
[null,"Number of days to sale",{"$f":"C14","v":0},"x feed cost $/head/day",{"$f":"F30","v":0},"plus additional labour ($/head)",null,"plus additional animal health ($/head)",null,"=",{"$f":"(C37*E37)+G37+I37","v":0},"per head"]
[null,"Margin"]
[null,"Gross margin income (per head)",{"$f":"G34","v":0},"less buy in price",{"$f":"G9","v":0},"less production costs",{"$f":"K37","v":0},"less finance costs",null,"=",{"$f":"SUM(C39-E39-G39-I39)","v":0},"per head"]
[]
[null,"Gross margin income (per mob)",{"$f":"C39*C35","v":0},"less buy in price",{"$f":"E39*C11","v":0},"less production costs",{"$f":"G39*C35","v":0},"less finance costs",{"$f":"I39*C11","v":0},"=",{"$f":"SUM(C41-E41-G41-I41)","v":0},"per mob"]
[]
[]
[null,"Additional considerations"]
[null,"This margin does not include any transport and sales commission costs."]
[]
[null,"Ensure the average liveweight gain of your animals is realistic and achievable, relative to feed quality and quatity (<2.0kg/day). Your liveweight gain is highlighted in orange, so you can quickly check it."]
[]
[null,"Compostion and cost of diet is calculated based on kg dry matter intake per day per head. The pale green cells (\"your $/kg DM\") are linked to the Feed Cost Calculator. Either use the Feed Cost Calculator to determine your own feed costs, or"]
[null,"average feed costs will be used (grey cells, \"average $/kg DM\")"]
[]
[null,"Total daily feed requirement MUST be the same value as total daily allocation.  If animals are underfed, liveweight gain and selling date will not be reached. If animals are overfed, the gross margins will not be accurate "]
[null,"and animals may fall outside market specs, resulting in price penalties."]
[]
[null,"Be aware and understand the opportunity cost of finishing animals and the negative impact this may have on total feed availability on your property, and feed allocations to other animals (e.g. the breeding herd)"]
[]
[null,"Are you sure about the sell price ?"]
[]
[null,"What happens if your feed cost increases ?"]
[]
[null,"What if some of the animals die? Have you considered a mortality percentage when entering the number of animals that will be finished into the balance sheet?"]

{"sheet":"Sheep Marginal Profit Calculato","index":6,"n_rows":65,"n_cols":14,"rows_kept":65,"cut":false,"hidden":false,"merged":[[21,9,21,10],[22,9,22,10],[23,9,23,10],[0,1,2,9],[20,9,20,10]]}
[null,"Sheep Trading Marginal Profit Calculator - sell now or sell later"]
[]
[]
[null,"To use this tool, insert your own figures into the green boxes.  Figures highlighted in the yellow boxes will be automatically calculated for you."]
[null,"In the composition and cost of diet table, the pale green cells (\"your $/kg DM\") are linked to the Feed Cost Calculator. Either use the Feed Cost Calculator to determine your own feed costs, or "]
[null,"average feed costs will be used (the grey cells, \"average $/kg DM\")"]
[]
[null,"Sell Now"]
[null,"Current live weight",null,"x price $/kg LW",null,"=",{"$f":"C9*E9","v":0},"per head"]
[null,"Sell now date"]
[null,"Number of animals",null,null,null,null,{"$f":"G9*C11","v":0},"mob value"]
[]
[null,"Weight Gain"]
[null,"Number of days to sale if selling later",null,"days"]
[null,"Sell later date",{"$f":"C10+C14","v":"00:00:00"}]
[null,"Target weight at sale",null,"kg LW/head"]
[null,"Average weight now",{"$f":"C9","v":0},"kg LW/head"]
[null,"Average liveweight gain",{"$f":"IFERROR(((C16-C17)/C14),0)","v":0},"kg LWG/day"]
[null,"Average daily feed requirement per head",{"$f":"L24","v":0},"kg DM/hd/day"]
[]
[null,"Composition and Cost of Diet","kg DM/day","your $/kg DM","average $/kg DM"," $/day/head",null,null,null,"Average Daily Feed Requirements",null,"kg DM/hd/day"]
[null,"Dryland pasture",null,0.02,0.02,{"$f":"IF(D22>0,D22*C22,E22*C22)","v":0},null,null,null,"Maintenance",null,{"$f":"(((C16/2)+(C17/2))*2)/100","v":0}]
[null,"Dryland pasture + N fert",null,{"$f":"D22+'Feed Cost Calc'!K21","v":0.02},0.17,{"$f":"IF(D23>0,D23*C23,E23*C23)","v":0},null,null,null,"LWG",null,{"$f":"C18*4","v":0}]
[null,"Irrigated pasture",null,{"$f":"'Feed Cost Calc'!G42","v":0},0.12,{"$f":"IF(D24>0,D24*C24,E24*C24)","v":0},null,null,null,"Total Daily Requirement",null,{"$f":"SUM(L22:L23)","v":0}]
[null,"Irrigated pasture + N fert",null,{"$f":"'Feed Cost Calc'!G42+'Feed Cost Calc'!K21","v":0},0.28999999999999998,{"$f":"C25*E25","v":0}]
[null,"Brassica crop",null,{"$f":"'Feed Cost Calc'!C67","v":0},0.15,{"$f":"C26*E26","v":0}]
[null,"Grain/pellets",null,{"$f":"'Feed Cost Calc'!K38","v":0},0.35,{"$f":"C27*E27","v":0}]
[null,"Hay",null,{"$f":"'Feed Cost Calc'!G24","v":0},0.35,{"$f":"C28*E28","v":0}]
[null,"Silage",null,{"$f":"'Feed Cost Calc'!C24","v":0},0.6,{"$f":"C29*E29","v":0}]
[null,"Total daily allocation",{"$f":"SUM(C22:C29)","v":0},null,null,{"$f":"SUM(F22:F29)","v":0}]
[]
[null,"Balance Sheet"]
[null,"Income"]
[null,"Liveweight",{"$f":"C16","v":0},"x price $/kg LW",null,"=",{"$f":"C34*E34","v":0},"per head"]
[null,"Number of animals finished"]
[null,"Production Cost"]
[null,"Number of days to sale",{"$f":"C14","v":0},"x feed cost $/head/day",{"$f":"F30","v":0},"plus additional labour ($/head)",null,"plus additional animal health ($/head)",null,null,null,"=",{"$f":"(E37*C37)+I37+G37","v":0},"per head"]
[null,"Margin"]
[null,"Gross margin income (per head)",{"$f":"G34","v":0},"less buy in price",{"$f":"G9","v":0},"less production costs",{"$f":"M37","v":0},"less finance costs",null,"plus skin value ",null,"=",{"$f":"(C39-(E39+G39+I39))+K39","v":0},"per head"]
[]
[null,"Gross margin income (per mob)",{"$f":"C39*C35","v":0},"less buy in price",{"$f":"E39*C11","v":0},"less production costs",{"$f":"G39*C35","v":0},"less finance costs",{"$f":"I39*C11","v":0},"plus skin value",{"$f":"K39*C35","v":0},"=",{"$f":"(C41-(E41+G41+I41))+K41","v":0},"per mob"]
[]
[null,"Additional considerations"]
[null,"This margin does not include any transport and sales commission costs."]
[]
[null,"Ensure the average liveweight gain of your animals is realistic and achievable, relative to feed quality and quatity (<0.4kg/day). Your liveweight gain is highlighted in orange, so you can quickly check it."]
[]
[null,"Compostion and cost of diet is calculated based on kg dry matter intake per day per head. The pale green cells (\"your $/kg DM\") are linked to the Feed Cost Calculator. Either use the Feed Cost Calculator to determine your own feed costs, or"]
[null,"average feed costs will be used (grey cells, \"average $/kg DM\")"]
[]
[null,"Total daily feed requirement MUST be the same value as total daily allocation.  If animals are underfed, liveweight gain and selling date will not be reached. If animals are overfed, the gross margins will not be accurate "]
[null,"and animals may fall outside market specs, resulting in price penalties."]
[]
[null,"Be aware and understand the opportunity cost of finishing animals and the negative impact this may have on total feed availability on your property, and feed allocations to other animals (e.g. the breeding herd)"]
[]
[null,"Are you sure about the sell price ?"]
[]
[null,"What happens if your feed cost increases ?"]
[]
[null,"What if some of the animals die? Have you considered a mortality percentage when entering the number of animals that will be finished into the balance sheet?"]
[null,"Are you sure about the sell price ?"]
[]
[null,"What happens if your feed cost increases ?"]
[]
[null,"What if some of the animals die? Have you considered a mortality percentage when entering the number of animals that will be finished into the balance sheet?"]

{"sheet":"Feed Cost Calc","index":7,"n_rows":69,"n_cols":15,"rows_kept":69,"cut":false,"hidden":false,"merged":[[0,1,2,9],[7,1,7,3],[7,5,7,7],[7,9,7,11],[8,13,8,14],[7,13,7,14],[27,9,27,11],[27,1,27,3],[27,5,27,7]]}
[null,"Feed Cost Calculator"]
[]
[]
[null,"To use this tool, insert your own figures into the green boxes.  Figures highlighted in the yellow boxes will be automatically calculated for you."]
[null,"Use the feed wastage rules of thumb table to estimate the waste at feed out for silage, hay, and grain/pellets (wastage varies depending on the method of feeding used)"]
[null,"For irrigation costing it is recommended to use a full season of data (i.e. amount of water applied and amount of feed consumed)."]
[]
[null,"Silage",null,null,null,"Hay",null,null,null,"N Fertiliser",null,null,null,"Feed wastage rules of thumb (%)"]
[null,null,null,"units",null,null,null,"units",null,null,null,"units",null,"Use this information  when estimating the waste at feed out"]
[null,"Mow, rake, bale, wrap & transport",null,"$/bale",null,"Mow, rake, bale & transport",null,"$/bale",null,"Fert cost ",null,"$/T",null,"Feed ring",15]
[null,"Feeding cost/bale",null,"$/bale",null,"Feeding cost/bale",null,"$/bale",null,"Spreading cost ",null,"$/ha",null,"Lick feeder",5]
[null,"Cost per bale",{"$f":"C10+C11","v":0},"$/bale",null,"Cost per bale",{"$f":"G10+G11","v":0},"$/bale",null,null,null,null,null,"Trail grain",20]
[null,null,null,null,null,null,null,null,null,"Fert rate ",null,"kg/ha",null,"Trail hay or silage",30]
[null,"Bale wet weight",null,"kg/bale",null,"Bale wet weight",null,"kg/bale",null,"Fert analysis ",null,"% N",null,"Trough",10]
[null,"Silage DM",null,"%",null,"Hay DM",0.4,"%",null,"N Applied ",{"$f":"K14*K13","v":0},"kg/ha"]
[null,"Silage DM per bale",{"$f":"C14*C15","v":0},"kg DM/bale",null,"Hay DM per bale",{"$f":"G14*G15","v":0},"kg DM/bale",null,"DM response (typically 10:1 for pasture)",null,":1"]
[null,null,null,null,null,null,null,null,null,"DM grown ",{"$f":"K15*K16","v":0},"kg/DM"]
[null,"Cost per kg DM",{"$f":"IFERROR(C12/C16,0)","v":0},"$/kgDM",null,"Cost per kg DM",{"$f":"IFERROR(G12/G16,0)","v":0},"$/kg DM"]
[null,null,null,null,null,null,null,null,null,"N Cost ",{"$f":"IFERROR((K10/(K14*1000)),0)","v":0},"$/kg"]
[null,"Energy value of silage",null,"MJ ME/kg DM",null,"Energy value of hay",null,"MJ ME/kg DM",null,"N Cost ",{"$f":"K19*K15","v":0},"$/ha"]
[null,null,null,null,null,null,null,null,null,"N + spreading cost ",{"$f":"K20+K11","v":0},"$/ha"]
[null,"Adjusted cost",{"$f":"IFERROR((C18/(C20/13)),0)","v":0},"$/kg DM",null,"Adjusted cost",{"$f":"IFERROR((G18/(G20/13)),0)","v":0},"$/kg DM"]
[null,null,null,null,null,null,null,null,null,"Cost as fed",{"$f":"IFERROR((K21/K17),0)","v":0},"$/kg DM"]
[null,"Waste at feed out",null,"%",null,"Waste at feed out",null,"%"]
[]
[null,"Cost as fed",{"$f":"IFERROR((C22/(1-C24)),0)","v":0},"$/kg DM",null,"Cost as fed",{"$f":"G22/(1-G24)","v":0},"$/kg DM"]
[]
[null,"Brassica",null,null,null,"Irrigation (pasture or clover)",null,null,null,"Grain/Pellets "]
[null,null,null,"units",null,null,null,"units",null,null,null,"units"]
[null,"Crop yield (wet weight)",null,"kg/ha",null,"Pasture consumed",null,"kg DM/ha",null,"Cost per tonne wet weight",null,"$/T"]
[null,null,null,null,null,"Water applied (100mm=1ML)",null,"ML/ha",null,"Grain DM",null,"%"]
[null,"Paddock preparation",null,null,null,null,null,null,null,"Grain/pellets DM per tonne",{"$f":"K31*1000","v":0},"kg DM/T"]
[null,"Application + chemical",null,"$/ha",null,"Water delivery",null,"$/ML"]
[null,"Initial cultivation",null,"$/ha",null,"Water application",null,"$/ML",null,"Energy value of grain/pellets",null,"MJ ME/kg DM"]
[null,"Seed"]
[null,"Sowing rate",null,"kg/ha",null,"Irrigated pasture cost",{"$f":"(G31*G33)+(C26*G34)","v":0},"$/ha",null,"Cost per kg DM",{"$f":"(K30/1000)*K31","v":0},"$/kg"]
[null,"Seed cost",null,"$/ha"]
[null,"Sowing (one pass)",null,null,null,"Cost per kg DM",{"$f":"IFERROR(G36/G30,0)","v":0},"$/kg DM",null,"Waste at feed out",null,"%"]
[null,"Airseed + cultivation",null,"$/ha"]
[null,null,null,null,null,"Energy value of irrigated pasture",null,"MJ ME/kg DM",null,"Cost as fed",{"$f":"SUM(K36/(1-K38))","v":0},"$/kg DM"]
[null,"Fertiliser at sowing "]
[null,"DAP",null,"$/T",null,"Adjusted cost",{"$f":"IFERROR(((G38)/(G40/13)),0)","v":0},"$/kg DM"]
[null,"Rate",null,"kg/ha"]
[null,"Fertiliser - topdressing",null,null,null,"Cost as fed",{"$f":"G42","v":0},"$/kg DM"]
[null,"Urea",null,"$/T"]
[null,"Rate",null,"kg/ha"]
[]
[null,"Pest Control (chem + application)"]
[null,"Cutworm "]
[null,"Chlorprifos+ application",null,"$/ha"]
[null,"Diamond Back Moth"]
[null,"SuccessNEO+application",null,"$/ha"]
[]
[null,"Irrigation"]
[null,"Water delivery",null,"$/ML"]
[null,"Water application",null,"$/ML"]
[null,"Water applied (100mm=1ML)",null,"ML/ha"]
[]
[null,"Crop Cost",{"$f":"C33+C34+(C36*C37)+C39+((C42/1000)*C43)+((C45/1000)*C46)+C50+C52+((C55*C57)+(C56*C57))","v":0},"$/kg DM"]
[]
[null,"Cost per kg DM",{"$f":"IFERROR((C59/C30),0)","v":0},"$/kg DM"]
[]
[null,"Energy value of crop",null,"MJ ME/kg DM"]
[]
[null,"Adjusted cost",{"$f":"IFERROR(((C61/(C63/13))),0)","v":0},"$/kg DM"]
[]
[null,"Waste at feed out (refer to Notes to Consider tab for more information)",null,"%"]
[]
[null,"Cost as fed",{"$f":"(C65)/(1-C67)","v":0},"$/kg DM"]

{"sheet":"Beef Marginal Profit Demo","index":8,"n_rows":60,"n_cols":12,"rows_kept":60,"cut":false,"hidden":false,"merged":[[0,1,2,9],[21,7,21,9],[22,7,22,9],[23,7,23,9]]}
[null,"Beef Trading Marginal Profit Calculator Demo - sell now or sell later"]
[]
[]
[null,"To use this tool, insert your own figures into the green boxes.  Figures highlighted in the yellow boxes will be automatically calculated for you."]
[null,"In the composition and cost of diet table, the pale green cells (\"your $/kg DM\") are linked to the Feed Cost Calculator. Either use the Feed Cost Calculator to determine your own feed costs, or "]
[null,"average feed costs will be used (the grey cells, \"average $/kg DM\")"]
[]
[null,"Sell Now"]
[null,"Current individual live weight",350,"x price $/kg LW",3,"=",{"$f":"C9*E9","v":1050},"per head"]
[null,"Sell now date","2018-03-02"]
[null,"Number of animals",100,null,null,null,{"$f":"G9*C11","v":105000},"mob value"]
[]
[null,"Weight Gain"]
[null,"Number of days to sale if selling later",50,"days"]
[null,"Sell later date",{"$f":"C10+C14","v":"2018-04-21"}]
[null,"Target weight at sale",450,"kg LW/head"]
[null,"Average weight now",{"$f":"C9","v":350},"kg LW/head"]
[null,"Average liveweight gain",{"$f":"SUM((C16-C17)/C14)","v":2},"kg LWG/day"]
[null,"Average daily feed requirement per head",{"$f":"K24","v":13},"kg DM/hd/day","daily feed requirement and total kg DM/day in "]
[]
[null,"Composition and Cost of Diet","kg DM/day","your $/kg DM","average $/kg DM"," $/day/head",null,null,null,"Average Daily Feed Requirements","kg DM/hd/day"]
[null,"Dryland pasture",10.5,0.02,0.02,{"$f":"IF(D22>0,D22*C22,E22*C22)","v":0.21},null,"Maintenance",null,null,{"$f":"SUM(((C16/2)+(C17/2))/100)+1","v":5}]
[null,"Dryland pasture + N fert",null,{"$f":"D22+'Feed Cost Calc'!K23","v":0.02},0.17,{"$f":"IF(D23>0,D23*C23,E23*C23)","v":0},null,"LWG",null,null,{"$f":"C18*4","v":8}]
[null,"Irrigated pasture",null,{"$f":"'Feed Cost Calc'!G44","v":0},0.12,{"$f":"IF(D24>0,D24*C24,E24*C24)","v":0},null,"Total Daily Requirement",null,null,{"$f":"SUM(K22:K23)","v":13}]
[null,"Irrigated pasture + N fert",null,{"$f":"'Feed Cost Calc'!G44+'Feed Cost Calc'!K23","v":0},0.28999999999999998,{"$f":"C25*E25","v":0}]
[null,"Brassica crop",null,{"$f":"'Feed Cost Calc'!C69","v":0},0.15,{"$f":"C26*E26","v":0}]
[null,"Grain/pellets",null,{"$f":"'Feed Cost Calc'!K40","v":0},0.35,{"$f":"C27*E27","v":0}]
[null,"Hay",null,{"$f":"'Feed Cost Calc'!G26","v":0},0.35,{"$f":"C28*E28","v":0}]
[null,"Silage",2.5,{"$f":"'Feed Cost Calc'!C26","v":0},0.6,{"$f":"C29*E29","v":1.5}]
[null,"Total daily allocation",{"$f":"SUM(C22:C29)","v":13},null,null,{"$f":"SUM(F22:F29)","v":1.71}]
[]
[null,"Balance Sheet"]
[null,"Income"]
[null,"Live weight",{"$f":"C16","v":450},"x price $/kg LW",3,"=",{"$f":"C34*E34","v":1350},"per head"]
[null,"Number of animals finished",99]
[null,"Production Cost"]
[null,"Number of days to sale",{"$f":"C14","v":50},"x feed cost $/head/day",{"$f":"F30","v":1.71},"plus additional labour ($/head)",null,"plus additional animal health ($/head)",null,"=",{"$f":"(C37*E37)+G37+I37","v":85.5},"per head"]
[null,"Margin"]
[null,"Gross margin income (per head)",{"$f":"G34","v":1350},"less buy in price",{"$f":"G9","v":1050},"less production costs",{"$f":"K37","v":85.5},"less finance costs",null,"=",{"$f":"SUM(C39-E39-G39-I39)","v":214.5},"per head"]
[]
[null,"Gross margin income (per mob)",{"$f":"C39*C35","v":133650},"less buy in price",{"$f":"E39*C11","v":105000},"less production costs",{"$f":"G39*C35","v":8464.5},"less finance costs",{"$f":"I39*C11","v":0},"=",{"$f":"SUM(C41-E41-G41-I41)","v":20185.5},"per mob"]
[]
[null,"Additional considerations"]
[null,"This margin does not include any transport and sales commission costs."]
[]
[null,"Ensure the average liveweight gain of your animals is realistic and achievable, relative to feed quality and quatity (<2.0kg/day). Your liveweight gain is highlighted in orange, so you can quickly check it."]
[]
[null,"Compostion and cost of diet is calculated based on kg dry matter intake per day per head. The pale green cells (\"your $/kg DM\") are linked to the Feed Cost Calculator. Either use the Feed Cost Calculator to determine your own feed costs, or"]
[null,"average feed costs will be used (grey cells, \"average $/kg DM\")"]
[]
[null,"Total daily feed requirement MUST be the same value as total daily allocation.  If animals are underfed, liveweight gain and selling date will not be reached. If animals are overfed, the gross margins will not be accurate "]
[null,"and animals may fall outside market specs, resulting in price penalties."]
[]
[null,"Be aware and understand the opportunity cost of finishing animals and the negative impact this may have on total feed availability on your property, and feed allocations to other animals (e.g. the breeding herd)"]
[]
[null,"Are you sure about the sell price ?"]
[]
[null,"What happens if your feed cost increases ?"]
[]
[null,"What if some of the animals die? Have you considered a mortality percentage when entering the number of animals that will be finished into the balance sheet?"]

{"sheet":"Sheep Marginal Profit Demo","index":9,"n_rows":60,"n_cols":14,"rows_kept":60,"cut":false,"hidden":false,"merged":[[0,1,2,9],[21,7,21,9],[22,7,22,9],[23,7,23,9]]}
[null,"Sheep Trading Marginal Profit Calculator Demo - sell now or sell later"]
[]
[]
[null,"To use this tool, insert your own figures into the green boxes.  Figures highlighted in the yellow boxes will be automatically calculated for you."]
[null,"In the composition and cost of diet table, the pale green cells (\"your $/kg DM\") are linked to the Feed Cost Calculator. Either use the Feed Cost Calculator to determine your own feed costs, or "]
[null,"average feed costs will be used (the grey cells, \"average $/kg DM\")"]
[]
[null,"Sell Now"]
[null,"Current live weight",35,"x price $/kg LW",3.5,"=",{"$f":"C9*E9","v":122.5},"per head"]
[null,"Sell now date","2018-03-02"]
[null,"Number of animals",100,null,null,null,{"$f":"G9*C11","v":12250},"mob value"]
[]
[null,"Weight Gain"]
[null,"Number of days to sale if selling later",60,"days"]
[null,"Sell later date",{"$f":"C10+C14","v":"2018-05-01"}]
[null,"Target weight at sale",50,"kg LW/head"]
[null,"Average weight now",{"$f":"C9","v":35},"kg LW/head"]
[null,"Average liveweight gain",{"$f":"SUM((C16-C17)/C14)","v":0.25},"kg LWG/day"]
[null,"Average daily feed requirement per head",{"$f":"K24","v":1.85},"kg DM/hd/day"]
[]
[null,"Composition and Cost of Diet","kg DM/day","your $/kg DM","average $/kg DM"," $/day/head",null,null,null,"Average Daily Feed Requirements","kg DM/hd/day"]
[null,"Dryland pasture",null,0.02,0.02,{"$f":"IF(D22>0,D22*C22,E22*C22)","v":0},null,"Maintenance",null,null,{"$f":"(((C16/2)+(C17/2))*2)/100","v":0.85}]
[null,"Dryland pasture + N fert",null,{"$f":"D22+'Feed Cost Calc'!K21","v":0.02},0.17,{"$f":"IF(D23>0,D23*C23,E23*C23)","v":0},null,"LWG",null,null,{"$f":"C18*4","v":1}]
[null,"Irrigated pasture",2.1,{"$f":"'Feed Cost Calc'!G42","v":0},0.12,{"$f":"IF(D24>0,D24*C24,E24*C24)","v":0.252},null,"Total Daily Requirement",null,null,{"$f":"SUM(K22:K23)","v":1.85}]
[null,"Irrigated pasture + N fert",null,{"$f":"'Feed Cost Calc'!G42+'Feed Cost Calc'!K21","v":0},0.28999999999999998,{"$f":"C25*E25","v":0}]
[null,"Brassica crop",null,{"$f":"'Feed Cost Calc'!C67","v":0},0.15,{"$f":"C26*E26","v":0}]
[null,"Grain/pellets",null,{"$f":"'Feed Cost Calc'!K38","v":0},0.35,{"$f":"C27*E27","v":0}]
[null,"Hay",null,{"$f":"'Feed Cost Calc'!G24","v":0},0.35,{"$f":"C28*E28","v":0}]
[null,"Silage",null,{"$f":"'Feed Cost Calc'!C24","v":0},0.6,{"$f":"C29*E29","v":0}]
[null,"Total daily allocation",{"$f":"SUM(C22:C29)","v":2.1},null,null,{"$f":"SUM(F22:F29)","v":0.252}]
[]
[null,"Balance Sheet"]
[null,"Income"]
[null,"Liveweight",{"$f":"C16","v":50},"x price $/kg LW",5.5,"=",{"$f":"C34*E34","v":275},"per head"]
[null,"Number of animals finished",95]
[null,"Production Cost"]
[null,"Number of days to sale",{"$f":"C14","v":60},"x feed cost $/head/day",{"$f":"F30","v":0.252},"plus additional labour ($/head)",null,"plus additional animal health ($/head)",null,null,null,"=",{"$f":"(E37*C37)+I37+G37","v":15.120000000000001},"per head"]
[null,"Margin"]
[null,"Gross margin income (per head)",{"$f":"G34","v":275},"less buy in price",{"$f":"G9","v":122.5},"less production costs",{"$f":"M37","v":15.120000000000001},"less finance costs",null,"plus skin value ",1.25,"=",{"$f":"(C39-(E39+G39+I39))+K39","v":138.63},"per head"]
[]
[null,"Gross margin income (per mob)",{"$f":"C39*C35","v":26125},"less buy in price",{"$f":"E39*C11","v":12250},"less production costs",{"$f":"G39*C35","v":1436.4},"less finance costs",{"$f":"I39*C11","v":0},"plus skin value",{"$f":"K39*C35","v":118.75},"=",{"$f":"(C41-(E41+G41+I41))+K41","v":12557.35},"per mob"]
[]
[null,"Additional considerations"]
[null,"This margin does not include any transport and sales commission costs."]
[]
[null,"Ensure the average liveweight gain of your animals is realistic and achievable, relative to feed quality and quatity (<0.4kg/day). Your liveweight gain is highlighted in orange, so you can quickly check it."]
[]
[null,"Compostion and cost of diet is calculated based on kg dry matter intake per day per head. The pale green cells (\"your $/kg DM\") are linked to the Feed Cost Calculator. Either use the Feed Cost Calculator to determine your own feed costs, or"]
[null,"average feed costs will be used (grey cells, \"average $/kg DM\")"]
[]
[null,"Total daily feed requirement MUST be the same value as total daily allocation.  If animals are underfed, liveweight gain and selling date will not be reached. If animals are overfed, the gross margins will not be accurate "]
[null,"and animals may fall outside market specs, resulting in price penalties."]
[]
[null,"Be aware and understand the opportunity cost of finishing animals and the negative impact this may have on total feed availability on your property, and feed allocations to other animals (e.g. the breeding herd)"]
[]
[null,"Are you sure about the sell price ?"]
[]
[null,"What happens if your feed cost increases ?"]
[]
[null,"What if some of the animals die? Have you considered a mortality percentage when entering the number of animals that will be finished into the balance sheet?"]

{"sheet":"Drop box definitions","index":10,"n_rows":65,"n_cols":2,"rows_kept":65,"cut":false,"hidden":true,"merged":[]}
[]
["Livestock type","Beef cattle"]
[null,"Dairy cattle - milking"]
[null,"Dairy cattle - dry"]
[null,"Sheep - lambs"]
[null,"Sheep - ewes (dry), wethers etc…"]
[]
[]
[]
["Forage crop type","Fodder radish"]
[null,"Kale"]
[null,"Leafy turnip"]
[null,"Rape"]
[null,"Swede"]
[null,"Turnip"]
[]
["Multi graze crop type","Foder radish"]
[null,"Leafy turnip"]
[null,"Rape"]
[]
["Multiple Grazing Option","Yes"]
[null,"No"]
[]
["Grazing efficiency",0.5]
[null,0.55000000000000004]
[null,0.6]
[null,0.65]
[null,0.7]
[null,0.75]
[null,0.8]
[null,0.85]
[null,0.9]
[null,0.95]
[null,1]
[]
["Daily feed requirements",0.5]
[null,1]
[null,1.5]
[null,2]
[null,2.5]
[null,3]
[null,3.5]
[null,4]
[null,4.5]
[null,5]
[null,5.5]
[null,6]
[null,6.5]
[null,7]
[null,7.5]
[null,8]
[null,8.5]
[null,9]
[null,9.5]
[null,10]
[null,10.5]
[null,11]
[null,11.5]
[null,12]
[null,12.5]
[null,13]
[null,13.5]
[null,14]
[null,14.5]
[null,15]