Sensitivity Summary

The sensitivity summary allows you to perform a sensitivity analysis by changing one variable at a time and comparing how different strategic alternatives perform based on the outcome.

The results are displayed in a sensitivity summary report, which shows a ranked table of alternatives based on changes in key variables.



How sensitivity analysis works

Assumptions and calculations

  • Sensitivity analysis is available at group and division level.

  • Sensitivity variables are defined per project version in the model builder on the Group/Division sheet.

  • Variable variation is fixed at ±10% for all project versions.

  • Results are presented in the Sensitivity summary report only.

  • For each variable, two columns are shown:

    • Value with +10% change.

    • Value with −10% change.

  • The base column shows the original Value Development without sensitivity applied.

Time horizons

You can view sensitivity results for one of the following time periods at a time:

  • 10 years

  • 20 years

  • 30 years

These time periods are calculated forward from the start year of Period 3 (P3SY).

Ranking alternatives

Alternatives are ranked based on the Value Development result under each sensitivity scenario. The top 5 alternatives are highlighted using color codes:

  • 🟩 Green

  • 🟨 Yellow

  • 🟦 Cyan

  • 🔵 Blue

  • ⬜ Gray


Accessing the Sensitivity summary report

  1. Navigate to Capex Strategy and open the Reports section.

  2. Select Sensitivity summary from the list of available reports.

The report will only appear if Use sensitivity has been enabled in the project settings. If it is not visible, contact your administrator to enable it.


Selecting sensitivity configuration and variables

To generate the Sensitivity summary report, ensure the following configuration steps are completed.

Enable sensitivity in project settings

Sensitivity analysis must be activated at the project level:

  1. Go to Administration > Capex Strategy > Project.

  2. Enable the checkbox for Use sensitivity.

The Sensitivity summary report will only be available if this setting is enabled.

Select sensitivity variables in the model builder

Sensitivity variables are selected from model rows in the Group level sheet. These rows must meet both of the following criteria:

  • The Allow sensitivity property is set to true.

  • The Sensitivity for group property is also set to true.

Only rows with both properties enabled will be available for selection in the sensitivity analysis.

Required row codes for sensitivity reporting

To ensure the Sensitivity summary report functions correctly, make sure the following model row codes are configured:

Code

Description

VAL_DEV

Add this to the Value development model row. This identifies the row used for value development reporting.

CF_TOTAL

Add this to the Cash flow total row. This code must be present on both the Group and Site levels.

If these codes are missing or misconfigured, the report may fail to generate or display incorrect data.


How sensitivity values are calculated

The system performs sensitivity calculations as follows:

  1. For each alternative:

    • For each sensitivity variable:

      • For each time horizon (10, 20, or 30 years):

        • For each site:

          • Find the variable's row in the cash flow model.

          • Calculate the base NPV at the selected time horizon.

          • Increase the variable by 10% and calculate the NPV again.

          • Decrease the variable by 10% and calculate the NPV again.

        • Aggregate the site-level results to the scope or division level.

      • Move to the next time horizon.

    • Move to the next sensitivity variable.

  2. Move to the next alternative.

This approach ensures that sensitivity results reflect realistic site-level performance before rolling up to the division or group levels.


Viewing the Sensitivity summary report

You can view the results of your sensitivity analysis in the Sensitivity summary report, where you can:

  • Compare all active alternatives side-by-side.

  • Identify which alternatives are most resilient to changes in specific variables.

  • Focus on the best-performing options based on your strategic priorities.

When you open the Sensitivity summary report, the calculations are performed in real time. Depending on the number of active alternatives, this calculation process might take some time.

All active alternatives are automatically included in the sensitivity summary. Currently, there is no option to filter or limit the alternatives being compared.

Column configuration

You can customise which columns are displayed in the report using the column selector. This allows you to show or hide specific variables or sensitivity outcomes, keeping the report focused on the metrics most relevant to your analysis.

Exporting the report

The Sensitivity summary report can be exported for use outside of Weissr. The exported file name includes the datatype name to help you identify the contents. You can access the export option from the Presentations menu.


Troubleshooting

The Sensitivity summary report is not visible
The report only appears when Use sensitivity is enabled in the project settings. Go to Administration > Capex Strategy > Project and enable the Use sensitivity checkbox.

The report shows an error about CF_TOTAL
If you see: "Configuration problem: Total cash flow row not found for group or mill block. Make sure block rows with code CF_TOTAL exist." — check that the CF_TOTAL code has been added to the Cash flow total row at both the Group and Site levels in the model builder.

The report is slow to load
Calculations are performed in real time when the report is opened. For projects with a large number of active alternatives, this can take some time. Wait for the calculation to complete before interacting with the results.

Sensitivity settings appear available even when sensitivity is disabled
In some cases, sensitivity configuration options in strategy development and presentations may still be visible after sensitivity has been deactivated at the admin level. This is a known display issue and does not affect the availability of the Sensitivity summary report itself.