Analyzing the Impact of Assumptions Changes

  To analyze the impact of changes to an assumption:

  1. Access the appropriate assumptions sheet by performing an action:

    • In Excel, open a Margin Planning Analysis Sheet and click Show Impact button. In the Show Impact dialog box, click a Key Assumption.

    • Click the tab corresponding to the assumption at the bottom of Excel.

  2. Optional: On the Assumptions sheet, click Apply Filter button to filter the information displayed.

  3. On the Assumptions sheet, make the desired changes.

  4. Click Apply Changes button to apply the changes to the database.

  5. Return to a Margin Planning Analysis Sheet to see the impact on your plan.

For example, assume that you want to change some unit costs in China because you anticipate a price increase. To do this you would:

  1. Click the Material Details tab at the bottom of Excel.

  2. Click Apply Filter button

  3. Limit the location to China by selecting CHN as the filter for the Location assumption.

    Figure 1. Location Assumption Filtered by China

    Location assumptions filtered by China

  4. Change the desired unit costs.

  5. Click Apply Changes button.

  6. Click Show Impact button to show the plan with the changes incorporated.