Difference between revisions of "Cane Sensitivity"
| 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) | # Entering the starting sugar price, which should be the lowest sugar price growers might expect to receive (e.g. $340/tonne). | ||
# 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.) | # 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.). | ||
# Entering the starting CCS value, which should be the lowest season average CCS growers expect (e.g. 12) | # 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.) | # 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.). | ||
# Clicking the ‘Submit’ button. | # Clicking the ‘Submit’ button. | ||
Revision as of 02:42, 22 February 2022
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:
- Entering the starting sugar price, which should be the lowest sugar price growers might expect to receive (e.g. $340/tonne).
- 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.).
- 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.).
- Clicking the ‘Submit’ button.
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).
Farm Performance Indicators ⇐|⇒ Cash Flow OR if have Other Crops ⇒ Other Crop Sensitivity