- SOIL3000 - Soil Fertility Nutrient Mgmt (Sec 1) - 2020 Winter Using the Economics of Nutrient Response excel sheet consider the following scenario... assume a 50% increase in the cost of nutrient inputs from $1.50 per kg to 2.25 per kg. Compare the profitability of two producers. The first, a conventional grower responds to the increased price of fertilizer by purchasing a more expensive hybrid that is more efficient (growth response = 0.006) resulting in a $10 increase in fixed costs and applies nutrient (inputs) at a level to maximize the net profit per hectare. What is the input level for this producer and what is the net profit per hectare? The second grower is an organic farmer who relies on manure to increase the base nutrient level from 30 to 60 kg/ha but applies no fertilizer nutrient (input level = 0). Manure application results in an increased fixed cost of $25 per hectare. Because the crop is organic there is a 50% increase in the yield value. What is their net profit per hectare for this producer? Note that if you scroll down to rows 41 - 72 you can see the values for inputs and net profit per hectare. Calculation of the Week: The Economics of Nutrient Response O Tune here to search LLLLLLLLLLLLLLLLwwwwwwwwwwwwwwwwwwwwwwwwwww Crop growth and economic returns model equation with growth response Factor, toxicity factor and base nutrient specification: Y=A11-10-C[x+b))*(10^-*(x+b)) Edit yellow fields and see what happens Growth Parameters Economic Parameters base nutrient level, b Maximum yield, A Fixed cost $250.00 per hectare Input cost $1.50 per kg 10 kg/ha available in soil 10,000 kgha 0.001 to 0.01; higher number produces 0.0050 greater growth response generates toxicity 0.00015 sooner Growth response constant, C Yield value $0.10 per kg Toxicity constant, Input level yield 1084 $1,000 2043 $800 $600 - Value $400 list pe $200 2890 3640 4302 4886 5401 5855 6254 6606 6914 7184 7421 7627 7807 7963 8098 8214 ile aralit per SO 15200 0 50 100 150 200 250 300 Input level 8314 8399 8471 8532 8582 8624 8657 8683 8703 factor and base nutrient Y=A[1-10^-C(x+b}}" (10^-k[x+b]) base nutrient level, b Growth model een 9 Fored cost per hectare 39 $276! 99 CURS 188BE8338868BRERE total cost per hectar vield per veld value net profit per input level input cost per hectare e hectare per hectare hectare $250 $0.00 $250 1084 108 37 - 4142 $250 $15.00 $265 2043 204 26 - $61 $250 $30.00 $280 2890 $288.04 $250 $45.00 3295 3640 $363.98 $69: $250 $60.00 $310 4302 $430.17 $120H $250 $75.00 $325 4886 488.58 $1641 $250 $90.00 $340 5401 $540.10 $200 $250 $105.00 $355 5855 $585.43 $230; $250 $120.00 $370 6254 $625.44 $255 $250 $135.00 $385 6606 $660.56 $250 $150.00 $400 6914 691.39 $291 $250 $165.00 $415 2184 $718.41 $303 1250 $180.00 $430 7421 74205 $312! $250 $195.00 $445 7627576269 $318 1250 140 $210.00 $460 7807 $780.66 $321 $250 $225.00 $475 7963 $796.27 $321 $250 160 $240.00 $490 8098 $809.78 $320 $250 170 $255.00 $505 8214 $821.42 $316! $250 180 $270.00 520 8314 083141 $250 $285.00 535 8399 $839.93 $305 $250 $300.00 1550 8471 $347.15 $297 $250 $315.00 $565 8532 $853.21 $288 $250 $330.00 $580 8582958.25 $278 $250 230 $345.00 595 8624 1862.37 $250 240 $36000 $610 8657 $865.69 $256 $250 $375.00 $625 8683 3868.30 $243; $250 $330.00 $640 8703 3870.27 $230 $250 1405.00 $655 8717 $871.68 $217! $250 3420.00 3670 8726 $872.59 $203 $250 290 $435.00 $685 8731 $873.06 $188 $250 $450.00 $700 8731 873.14 $173 $3731 190 $267! 250 260 270 280 300 Growth model sheet 2 - SOIL3000 - Soil Fertility Nutrient Mgmt (Sec 1) - 2020 Winter Using the Economics of Nutrient Response excel sheet consider the following scenario... assume a 50% increase in the cost of nutrient inputs from $1.50 per kg to 2.25 per kg. Compare the profitability of two producers. The first, a conventional grower responds to the increased price of fertilizer by purchasing a more expensive hybrid that is more efficient (growth response = 0.006) resulting in a $10 increase in fixed costs and applies nutrient (inputs) at a level to maximize the net profit per hectare. What is the input level for this producer and what is the net profit per hectare? The second grower is an organic farmer who relies on manure to increase the base nutrient level from 30 to 60 kg/ha but applies no fertilizer nutrient (input level = 0). Manure application results in an increased fixed cost of $25 per hectare. Because the crop is organic there is a 50% increase in the yield value. What is their net profit per hectare for this producer? Note that if you scroll down to rows 41 - 72 you can see the values for inputs and net profit per hectare. Calculation of the Week: The Economics of Nutrient Response O Tune here to search LLLLLLLLLLLLLLLLwwwwwwwwwwwwwwwwwwwwwwwwwww Crop growth and economic returns model equation with growth response Factor, toxicity factor and base nutrient specification: Y=A11-10-C[x+b))*(10^-*(x+b)) Edit yellow fields and see what happens Growth Parameters Economic Parameters base nutrient level, b Maximum yield, A Fixed cost $250.00 per hectare Input cost $1.50 per kg 10 kg/ha available in soil 10,000 kgha 0.001 to 0.01; higher number produces 0.0050 greater growth response generates toxicity 0.00015 sooner Growth response constant, C Yield value $0.10 per kg Toxicity constant, Input level yield 1084 $1,000 2043 $800 $600 - Value $400 list pe $200 2890 3640 4302 4886 5401 5855 6254 6606 6914 7184 7421 7627 7807 7963 8098 8214 ile aralit per SO 15200 0 50 100 150 200 250 300 Input level 8314 8399 8471 8532 8582 8624 8657 8683 8703 factor and base nutrient Y=A[1-10^-C(x+b}}" (10^-k[x+b]) base nutrient level, b Growth model een 9 Fored cost per hectare 39 $276! 99 CURS 188BE8338868BRERE total cost per hectar vield per veld value net profit per input level input cost per hectare e hectare per hectare hectare $250 $0.00 $250 1084 108 37 - 4142 $250 $15.00 $265 2043 204 26 - $61 $250 $30.00 $280 2890 $288.04 $250 $45.00 3295 3640 $363.98 $69: $250 $60.00 $310 4302 $430.17 $120H $250 $75.00 $325 4886 488.58 $1641 $250 $90.00 $340 5401 $540.10 $200 $250 $105.00 $355 5855 $585.43 $230; $250 $120.00 $370 6254 $625.44 $255 $250 $135.00 $385 6606 $660.56 $250 $150.00 $400 6914 691.39 $291 $250 $165.00 $415 2184 $718.41 $303 1250 $180.00 $430 7421 74205 $312! $250 $195.00 $445 7627576269 $318 1250 140 $210.00 $460 7807 $780.66 $321 $250 $225.00 $475 7963 $796.27 $321 $250 160 $240.00 $490 8098 $809.78 $320 $250 170 $255.00 $505 8214 $821.42 $316! $250 180 $270.00 520 8314 083141 $250 $285.00 535 8399 $839.93 $305 $250 $300.00 1550 8471 $347.15 $297 $250 $315.00 $565 8532 $853.21 $288 $250 $330.00 $580 8582958.25 $278 $250 230 $345.00 595 8624 1862.37 $250 240 $36000 $610 8657 $865.69 $256 $250 $375.00 $625 8683 3868.30 $243; $250 $330.00 $640 8703 3870.27 $230 $250 1405.00 $655 8717 $871.68 $217! $250 3420.00 3670 8726 $872.59 $203 $250 290 $435.00 $685 8731 $873.06 $188 $250 $450.00 $700 8731 873.14 $173 $3731 190 $267! 250 260 270 280 300 Growth model sheet 2