{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Partial budget tool"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":1,"defined_names":58,"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":"Partial budget tool","index":0,"n_rows":44,"n_cols":6,"rows_kept":44,"cut":false,"hidden":false,"merged":[[1,1,1,5],[2,4,2,5],[4,1,4,2],[4,4,4,5],[5,1,5,2],[5,4,5,5],[43,1,45,5],[6,1,6,2],[6,4,6,5],[7,1,7,2],[7,4,7,5],[39,1,41,5]]}
[]
[null,"Partial budget activity tool"]
[null,"Partial budget activity descriptor (decribe the activity being considered):",null,null,"Fallow spraying 200 hectares of crop area in a mixed farm system rather than leaving the weeds grow for sheep feed"]
[]
[null,"Benefits (List the anticipated benefits of the activity below)",null,null,"Costs (List the anticipated costs of the activity below)"]
[null,"Stored soil moisture for following crop",null,null,"Weed growth providing maintenance feed for livestock production"]
[]
[]
[null,"Additional revenue generated from change","Value",null,"Revenue reduced or eliminated","Value"]
[null,"Yield due to 40mm additional stored moisture"]
[null,"40mm x 30kg/ha/mm x $300/t x 200ha",{"$f":"40*30/1000*300*200","v":72000}]
[]
[]
[]
[]
[]
[]
[]
[null,"Total additional revenue from activity",{"$f":"SUM(C10:C18)","v":72000},null,"Total additional revenue foregone from activity",{"$f":"SUM(F10:F18)","v":0}]
[]
[null,"Existing costs reduced","Value",null,"Additional costs incurred"]
[null,"The value of stored soil nitrogen",null,null,"The value of the grazing foregone from spraying"]
[null," 40kg N/ha = 87kg/ha Urea @ $650/t  x 200ha",{"$f":"87*650/1000*200","v":11310},null,"1000kg DM/ha x 50% utilisation"]
[null,null,null,null,"20 DSE/ha stocking rate x 30 days grazing x $0.15/DSE/day grain x 200ha",{"$f":"20*30*0.15*200","v":18000}]
[null,null,null,null,"Labour cost to feed 800DSE x 30 days (15 days x 2hrs/feed x $40/hr)",{"$f":"15*2*40","v":1200}]
[null,null,null,null,"Cost of spraying"]
[null,null,null,null,"200ha sprayed x $15/ha (herbicide cost)",{"$f":"200*15","v":3000}]
[null,null,null,null,"Contract spraying "]
[null,null,null,null,"200ha sprayed x $12/ha (herbicide cost)",{"$f":"200*12","v":2400}]
[]
[]
[]
[null,"Total existing costs reduced",{"$f":"SUM(C22:C32)","v":11310},null,"Additional costs incurred",{"$f":"SUM(F22:F32)","v":24600}]
[]
[null,"Total benefits from activity",{"$f":"C19+C33","v":83310},null,"Total costs due to activity",{"$f":"F19+F33","v":24600}]
[]
[null,"Net value of change",{"$f":"C35-F35","v":58710}]
[null,"Does the benefit of this activity exceed the cost?",{"$f":"IF(C37>0,\"Yes\",\"No\")","v":"Yes"}]
[]
[null,"Example activity: The example provided in this tool can be overwritten with alternative partial budget assumptions. The aim of providing the example is to demonstrate that a number of calculations for each component of the tool may be necessary to determine the additional revenue generated, the existing costs reduced, revenue reduced and additional costs incurred. The example uses production research findings and 2021 approximate commodity values as the basis for assumptions."]
[]
[]
[]
[null,"Disclaimer: This decision support tool is produced by Agrista. The contents do not constitute management or business advice and should not be relied on as such. Before taking any action in relation to a matter described in this decision support tool, you should seek independent advice from a qualified professional. Agrista accepts no responsibility for any loss or damage resulting from reliance on the contents of this tool."]