Cane Sensitivity - Revision history

Admin: /* Interpreting the results */

2023-06-28T23:53:58Z

Interpreting the results

← Older revision		Revision as of 23:53, 28 June 2023
Line 24:		Line 24:

	===Interpreting the results===		===Interpreting the results===
	After entering those four values and pressing ~~submit~~, you can then examine the cane sensitivity table to determine the average gross margin at different combinations of sugar price and CCS.		After entering those four values and pressing "Submit", you can then examine the cane sensitivity table to determine the average gross margin at different combinations of sugar price and CCS.

	- For example, the worst case would be the gross margin that corresponds to the lowest sugar price and CCS combination (top-left value), while the best case would be the gross margin that corresponds to the highest sugar price and CCS (bottom-right value).		* For example, the worst case would be the gross margin that corresponds to the lowest sugar price and CCS combination (top-left value), while the best case would be the gross margin that corresponds to the highest sugar price and CCS (bottom-right value).
			* '''Note:''' The cane sensitivity analysis does not include fixed costs and therefore is not showing the true cost of production.
	- '''Note:''' The cane sensitivity analysis does not include fixed costs and therefore is not showing the true cost of production.

Admin: /* How to generate a cane sensitivity analysis */

2023-06-28T23:53:29Z

How to generate a cane sensitivity analysis

← Older revision		Revision as of 23:53, 28 June 2023
Line 18:		Line 18:


	'''5. Click the ~~‘Submit’~~ button.'''		'''5. Click the "Submit" button.'''

Admin: /* Interpreting the results */

2023-06-27T23:41:07Z

Interpreting the results

← Older revision		Revision as of 23:41, 27 June 2023
Line 24:		Line 24:

	===Interpreting the results===		===Interpreting the results===
	After entering those four values and pressing submit, you can then examine the cane sensitivity table to determine the average gross margin at different combinations of sugar price and CCS. For example, the worst case would be the gross margin that corresponds to the lowest sugar price and CCS combination (top-left value), while the best case would be the gross margin that corresponds to the highest sugar price and CCS (bottom-right value).		After entering those four values and pressing submit, you can then examine the cane sensitivity table to determine the average gross margin at different combinations of sugar price and CCS.

	~~<blockquote>~~ Note: The cane sensitivity analysis does not include fixed costs and therefore is not showing the true cost of production.~~</blockquote>~~		- For example, the worst case would be the gross margin that corresponds to the lowest sugar price and CCS combination (top-left value), while the best case would be the gross margin that corresponds to the highest sugar price and CCS (bottom-right value).

			- '''Note:''' The cane sensitivity analysis does not include fixed costs and therefore is not showing the true cost of production.

Admin: /* How to generate a cane sensitivity analysis */

2023-06-27T23:40:30Z

How to generate a cane sensitivity analysis

← Older revision		Revision as of 23:40, 27 June 2023
Line 6:		Line 6:

	===How to generate a cane sensitivity analysis===		===How to generate a cane sensitivity analysis===
	1. Enter the starting sugar price, which should be the lowest sugar price growers might expect to receive.		'''1. Enter the starting sugar price, which should be the lowest sugar price growers might expect to receive.''' For example, $380/tonne.
	~~<blockquote>~~ For example, $380/tonne.~~</blockquote>~~

	~~2. Enter the incremental change in sugar price, which is the dollar change per column moving to the right of the table.~~
	~~<blockquote>For example, if you enter $10 then the sugar price in each column to the right will increase by $10 each column ($380, $390, $400, etc.).</blockquote>~~

	3. Enter the ~~starting CCS value~~, which ~~should be~~ the ~~lowest season average CCS growers expect~~.		'''2. Enter the incremental change in sugar price, which is the dollar change per column moving to the right of the table.''' For example, if you enter $10 then the sugar price in each column to the right will increase by $10 each column ($380, $390, $400, etc.).
	~~<blockquote>~~ For example, 13.5.~~</blockquote>~~

	~~4. Enter the incremental change in CCS, which is the CCS change per row in the table moving downwards.~~
	~~<blockquote>For example, if you enter 0.25 then the CCS in each row moving downwards will increase by 0.25 each row (13.5, 13.75, 14, etc.).</blockquote>~~

	5. Click the ‘Submit’ button.		'''3. Enter the starting CCS value, which should be the lowest season average CCS growers expect.''' For example, 13.5.


			'''4. Enter the incremental change in CCS, which is the CCS change per row in the table moving downwards.''' For example, if you enter 0.25 then the CCS in each row moving downwards will increase by 0.25 each row (13.5, 13.75, 14, etc.).


			'''5. Click the ‘Submit’ button.'''


	[[File:Cane Sensitivity Input.png\|1400px\|frameless\|center\|link=]]		[[File:Cane Sensitivity Input.png\|1400px\|frameless\|center\|link=]]


	===Interpreting the results===		===Interpreting the results===

Admin at 00:39, 30 March 2023

2023-03-30T00:39:45Z

← Older revision		Revision as of 00:39, 30 March 2023
Line 1:		Line 1:
	This page provides a cane sensitivity analysis table, which shows the cane average gross margin at different sugar prices and CCS values. Given uncertainty around the price growers will receive for their sugar and their season average CCS, sensitivity analysis is useful to explore the impact to profitability (gross margin) if the sugar price and CCS vary from what is expected.		===What is this page?===
			This page provides a cane sensitivity analysis table, which shows the cane average gross margin at different sugar prices and CCS values.

	~~You can generate a cane~~ sensitivity analysis ~~by:~~		===Why is sensitivity analysis important?===
			Given uncertainty around the price growers will receive for their sugar and their season average CCS, sensitivity analysis is useful to explore the impact to profitability (gross margin) if the sugar price and CCS vary from what is expected.

	1. ~~Entering~~ the starting sugar price, which should be the lowest sugar price growers might expect to receive.		===How to generate a cane sensitivity analysis===
			1. Enter the starting sugar price, which should be the lowest sugar price growers might expect to receive.
	<blockquote> For example, $380/tonne.</blockquote>		<blockquote> For example, $380/tonne.</blockquote>

	2. ~~Entering~~ the incremental change in sugar price, which is the dollar change per column moving to the right of the table.		2. Enter the incremental change in sugar price, which is the dollar change per column moving to the right of the table.
	<blockquote>For example, if you enter $10 then the sugar price in each column to the right will increase by $10 each column ($380, $390, $400, etc.).</blockquote>		<blockquote>For example, if you enter $10 then the sugar price in each column to the right will increase by $10 each column ($380, $390, $400, etc.).</blockquote>

	3. ~~Entering~~ the starting CCS value, which should be the lowest season average CCS growers expect.		3. Enter the starting CCS value, which should be the lowest season average CCS growers expect.
	<blockquote> For example, 13.5.</blockquote>		<blockquote> For example, 13.5.</blockquote>

	4. ~~Entering~~ the incremental change in CCS, which is the CCS change per row in the table moving downwards.		4. Enter the incremental change in CCS, which is the CCS change per row in the table moving downwards.
	<blockquote>For example, if you enter 0.25 then the CCS in each row moving downwards will increase by 0.25 each row (13.5, 13.75, 14, etc.).</blockquote>		<blockquote>For example, if you enter 0.25 then the CCS in each row moving downwards will increase by 0.25 each row (13.5, 13.75, 14, etc.).</blockquote>

	5. ~~Clicking~~ the ‘Submit’ button.		5. Click the ‘Submit’ button.


Line 21:		Line 24:


			===Interpreting the results===
	After entering those four values and pressing submit, you can then examine the cane sensitivity table to determine the average gross margin at different combinations of sugar price and CCS. For example, the worst case would be the gross margin that corresponds to the lowest sugar price and CCS combination (top-left value), while the best case would be the gross margin that corresponds to the highest sugar price and CCS (bottom-right value).		After entering those four values and pressing submit, you can then examine the cane sensitivity table to determine the average gross margin at different combinations of sugar price and CCS. For example, the worst case would be the gross margin that corresponds to the lowest sugar price and CCS combination (top-left value), while the best case would be the gross margin that corresponds to the highest sugar price and CCS (bottom-right value).

Admin at 23:10, 29 March 2023

2023-03-29T23:10:31Z

Admin at 03:06, 7 February 2023

2023-02-07T03:06:48Z

← Older revision		Revision as of 03:06, 7 February 2023
Line 4:		Line 4:

	1. Entering the starting sugar price, which should be the lowest sugar price growers might expect to receive.		1. Entering the starting sugar price, which should be the lowest sugar price growers might expect to receive.
	<blockquote> For example, $~~340~~/tonne.</blockquote>		<blockquote> For example, $380/tonne.</blockquote>

	2. Entering the incremental change in sugar price, which is the dollar change per column moving to the right of the table.		2. Entering the incremental change in sugar price, which is the dollar change per column moving to the right of the table.
	<blockquote>For example, if a user enters $20 then the sugar price in each column to the right will increase by $20 each column ($~~340~~, $~~360~~, $~~380~~, etc.).</blockquote>		<blockquote>For example, if a user enters $10 then the sugar price in each column to the right will increase by $10 each column ($380, $390, $400, etc.).</blockquote>

	3. Entering the starting CCS value, which should be the lowest season average CCS growers expect.		3. Entering the starting CCS value, which should be the lowest season average CCS growers expect.
	<blockquote> For example, 12.</blockquote>		<blockquote> For example, 13.5.</blockquote>

	4. Entering the incremental change in CCS, which is the CCS change per row in the table moving downwards.		4. Entering the incremental change in CCS, which is the CCS change per row in the table moving downwards.
	<blockquote>For example, if a user enters 0.4 then the CCS in each row moving downwards will increase by 0.4 each row (12, 12.4, ~~12.8~~, etc.).</blockquote>		<blockquote>For example, if a user enters 0.25 then the CCS in each row moving downwards will increase by 0.25 each row (13.5, 13.75, 14, etc.).</blockquote>

	5. Clicking the ‘Submit’ button.		5. Clicking the ‘Submit’ button.

Admin at 00:05, 7 February 2023

2023-02-07T00:05:45Z

← Older revision		Revision as of 00:05, 7 February 2023
Line 18:		Line 18:


	[[File:Cane Sensitivity Input.png\|1400px\|frameless\|center]]		[[File:Cane Sensitivity Input.png\|1400px\|frameless\|center\|link=]]


Line 26:		Line 26:


	[[File:Cane Sensitivity Table.png\|1400px\|frameless\|center]]		[[File:Cane Sensitivity Table.png\|1400px\|frameless\|center\|link=]]


	[[File:Cane Sensitivity Graph.png\|1400px\|frameless\|center]]		[[File:Cane Sensitivity Graph.png\|1400px\|frameless\|center\|link=]]


	[[Farm Performance Indicators]] ⇐\|⇒ [[Other Crop Sensitivity]]		[[Farm Performance Indicators]] ⇐\|⇒ [[Other Crop Sensitivity]]

Admin at 04:11, 13 December 2022

2022-12-13T04:11:45Z

← Older revision		Revision as of 04:11, 13 December 2022
Line 3:		Line 3:
	Users can generate a cane sensitivity analysis by:		Users can generate a cane sensitivity analysis by:

	# Entering the starting sugar price, which should be the lowest sugar price growers might expect to receive ~~(e.g~~. $340/tonne).		1. Entering the starting sugar price, which should be the lowest sugar price growers might expect to receive.
	# Entering the incremental change in sugar price, which is the dollar change per column moving to the right of the table. For example, if a user enters $20 then the sugar price in each column to the right will increase by $20 each column (~~e.g.~~ $340, $360, $380, etc.).		<blockquote> For example, $340/tonne.</blockquote>
	# Entering the starting CCS value, which should be the lowest season average CCS growers expect ~~(e.g~~. 12).
	# Entering the incremental change in CCS, which is the CCS change per row in the table moving downwards. For example, if a user enters 0.4 then the CCS in each row moving downwards will increase by 0.4 each row (~~e.g.~~ 12, 12.4, 12.8, etc.).		2. Entering the incremental change in sugar price, which is the dollar change per column moving to the right of the table.
	# Clicking the ‘Submit’ button.		<blockquote>For example, if a user enters $20 then the sugar price in each column to the right will increase by $20 each column ($340, $360, $380, etc.).</blockquote>

			3. Entering the starting CCS value, which should be the lowest season average CCS growers expect.
			<blockquote> For example, 12.</blockquote>

			4. Entering the incremental change in CCS, which is the CCS change per row in the table moving downwards.
			<blockquote>For example, if a user enters 0.4 then the CCS in each row moving downwards will increase by 0.4 each row (12, 12.4, 12.8, etc.).</blockquote>

			5. Clicking the ‘Submit’ button.

Admin at 00:31, 13 December 2022

2022-12-13T00:31:22Z

← Older revision		Revision as of 00:31, 13 December 2022
Line 14:		Line 14:

	After entering those four values and pressing submit, users can then examine the cane sensitivity table to determine the average gross margin at different combinations of sugar price and CCS. For example, the worst case would be the gross margin that corresponds to the lowest sugar price and CCS combination (top-left value), while the best case would be the gross margin that corresponds to the highest sugar price and CCS (bottom-right value).		After entering those four values and pressing submit, users can then examine the cane sensitivity table to determine the average gross margin at different combinations of sugar price and CCS. For example, the worst case would be the gross margin that corresponds to the lowest sugar price and CCS combination (top-left value), while the best case would be the gross margin that corresponds to the highest sugar price and CCS (bottom-right value).

			<blockquote> Note: The cane sensitivity analysis does not include fixed costs and therefore is not showing the true cost of production.</blockquote>

← Older revision		Revision as of 00:05, 7 February 2023
Line 18:		Line 18:


	[[File:Cane Sensitivity Input.png\|1400px\|frameless\|center]]		[[File:Cane Sensitivity Input.png\|1400px\|frameless\|center\|link=]]


Line 26:		Line 26:


	[[File:Cane Sensitivity Table.png\|1400px\|frameless\|center]]		[[File:Cane Sensitivity Table.png\|1400px\|frameless\|center\|link=]]


	[[File:Cane Sensitivity Graph.png\|1400px\|frameless\|center]]		[[File:Cane Sensitivity Graph.png\|1400px\|frameless\|center\|link=]]


	[[Farm Performance Indicators]] ⇐\|⇒ [[Other Crop Sensitivity]]		[[Farm Performance Indicators]] ⇐\|⇒ [[Other Crop Sensitivity]]

← Older revision		Revision as of 23:10, 29 March 2023
Line 1:		Line 1:
	This page provides a cane sensitivity analysis table, which shows the cane average gross margin at different sugar prices and CCS values. Given uncertainty around the price growers will receive for their sugar and their season average CCS, sensitivity analysis is useful to explore the impact to profitability (gross margin) if the sugar price and CCS vary from what is expected.		This page provides a cane sensitivity analysis table, which shows the cane average gross margin at different sugar prices and CCS values. Given uncertainty around the price growers will receive for their sugar and their season average CCS, sensitivity analysis is useful to explore the impact to profitability (gross margin) if the sugar price and CCS vary from what is expected.

	~~Users~~ can generate a cane sensitivity analysis by:		You can generate a cane sensitivity analysis by:

	1. Entering the starting sugar price, which should be the lowest sugar price growers might expect to receive.		1. Entering the starting sugar price, which should be the lowest sugar price growers might expect to receive.
Line 7:		Line 7:

	2. Entering the incremental change in sugar price, which is the dollar change per column moving to the right of the table.		2. Entering the incremental change in sugar price, which is the dollar change per column moving to the right of the table.
	<blockquote>For example, if ~~a user enters~~ $10 then the sugar price in each column to the right will increase by $10 each column ($380, $390, $400, etc.).</blockquote>		<blockquote>For example, if you enter $10 then the sugar price in each column to the right will increase by $10 each column ($380, $390, $400, etc.).</blockquote>

	3. Entering the starting CCS value, which should be the lowest season average CCS growers expect.		3. Entering the starting CCS value, which should be the lowest season average CCS growers expect.
Line 13:		Line 13:

	4. Entering the incremental change in CCS, which is the CCS change per row in the table moving downwards.		4. Entering the incremental change in CCS, which is the CCS change per row in the table moving downwards.
	<blockquote>For example, if ~~a user enters~~ 0.25 then the CCS in each row moving downwards will increase by 0.25 each row (13.5, 13.75, 14, etc.).</blockquote>		<blockquote>For example, if you enter 0.25 then the CCS in each row moving downwards will increase by 0.25 each row (13.5, 13.75, 14, etc.).</blockquote>

	5. Clicking the ‘Submit’ button.		5. Clicking the ‘Submit’ button.
Line 21:		Line 21:


	After entering those four values and pressing submit, ~~users~~ can then examine the cane sensitivity table to determine the average gross margin at different combinations of sugar price and CCS. For example, the worst case would be the gross margin that corresponds to the lowest sugar price and CCS combination (top-left value), while the best case would be the gross margin that corresponds to the highest sugar price and CCS (bottom-right value).		After entering those four values and pressing submit, you can then examine the cane sensitivity table to determine the average gross margin at different combinations of sugar price and CCS. For example, the worst case would be the gross margin that corresponds to the lowest sugar price and CCS combination (top-left value), while the best case would be the gross margin that corresponds to the highest sugar price and CCS (bottom-right value).

	<blockquote> Note: The cane sensitivity analysis does not include fixed costs and therefore is not showing the true cost of production.</blockquote>		<blockquote> Note: The cane sensitivity analysis does not include fixed costs and therefore is not showing the true cost of production.</blockquote>