Difference between revisions of "Cane Sensitivity"
| 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. | ||
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 | <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 | <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, | 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> | ||
Revision as of 23:10, 29 March 2023
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.
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.
For example, $380/tonne.
2. Entering 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.).
3. Entering the starting CCS value, which should be the lowest season average CCS growers expect.
For example, 13.5.
4. Entering 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. Clicking the ‘Submit’ button.

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).
Note: The cane sensitivity analysis does not include fixed costs and therefore is not showing the true cost of production.