R-Software to estimate minimum cost of supplying DIN credits from practice change in cane production in the Wet Tropics (NESP TWQ 3.1.6, GU)
Published by Australian Ocean Data Network
About this dataset
P2R.data.reader.v041220 with Header.R This is a block of R code written for NESP Tropical Water Quality Hub Project 3.1.6 The software uses data supplied from the Queensland Government’s Paddock to Reef (P2R) modelling system, and other publicly available data, to generate plots of supply curves for water quality credits in dissolved inorganic nitrogen (DIN) for the main catchments in the Wet Tropics. The aim of Project 3.1.6 was to compare the cost of supplying DIN credits from various sources with the prices that potential credit buyers would be willing to pay for those credits. This R-code estimates the minimum cost of supplying DIN credits via fertiliser practice change in sugarcane production in the main Wet Tropics catchments (Daintree, Mossman, Barron, Mulgrave-Russell, Johnstone, Tully, Murray and Herbert). Key data inputs on reductions in cane yield and reductions in DIN loss from 563 individual cane land management units[1] in the Wet Tropics are obtained from the Queensland Government’s Paddock to Reef (P2R) modelling program. Data on fertiliser cost, sugar prices, sugar content in cane, equipment cost and growers’ ‘transaction cost’ in engaging in water quality credit trading are obtained from public sources and the literature. Results are produced in the form of estimated supply curves for DIN credits from practice change in cane for the main Wet Tropics catchments. [1] The Queensland Government’s Paddock to Reef (P2R) modelling and monitoring program (The Australian and Queensland Governments, 2018) defines unique combinations of soil type, soil permeability, climate zone and sub-catchment in sugarcane land in the Wet Tropics catchments as separate cane ‘management units’. Methods: The Queensland Government’s Paddock to Reef (P2R) modelling and monitoring program (The Australian and Queensland Governments, 2018) defines unique combinations of soil type, soil permeability, climate zone and sub-catchment in sugarcane land in the Wet Tropics catchments as separate cane ‘management units’. P2R’s mapping produces 563 separate cane management units for which full cane yield and DIN loss predictions are available over the time period 1987-2013. In Project 3.1.6, the minimum cost of supplying DIN credits from practice change in cane in the Wet Tropics at management unit resolution is calculated as the sum of the following four components: Opportunity cost: the reduction in average annual farm gross margin that follows from a reduction in fertiliser application rate. Average farm gross margin is derived from average P2R-simulated cane yields over the period 1987-2013 (Fraser et al., 2013). Opportunity cost is calculated on an annual basis. Compensation for increased exposure to risk of reduced yield: the average reduction in farm gross margin from years containing the top 10% of P2R-simulated yields over the period 1987-2013 that follows from a reduction in fertiliser application rate (Fraser et al., 2013). Compensation for increased exposure to risk is calculated on an annual basis. Transition cost: the annualised cost of equipment purchases required to implement each step improvement in fertiliser practice. Transition cost data are drawn from van Grieken et al., (2019; Table 2, p.4), inflated to 2018AUD using the Reserve Bank of Australia’s inflation calculator (https://www.rba.gov.au/calculator/ ).Transition cost is annualised over the 6-year cane cycle at a discount rate of 7% per annum, to produce an annualised equivalent transition cost that is compatible with the annual timeframe over which opportunity cost and the compensation required for increased exposure to risk are calculated. Transaction cost: the annualised cost of the resources, including time, that a landholder has to commit to learn about and engage with water quality credit trading. Transaction cost data are drawn from (Coggan et al., 2014; Table 5, p.512), inflated to 2018AUD using the Reserve Bank of Australia’s inflation calculator (https://www.rba.g