The Demand Variances: Revenue Worksheet enables you to compare plans in revenue terms.

Edit the comparison periods in the Edit Parameters panel.

ParametersValues
Compare From

Select what you're comparing from:

  • Statistical Forecast
  • Demand Forecast
  • Prior Demand Forecast
  • Commercial Plan
  • Prior Commercial Plan
  • Consensus Plan
  • Prior Consensus Plan
  • Budget
Compare To

Select what you're comparing to:

  • Statistical Forecast
  • Demand Forecast
  • Prior Demand Forecast
  • Commercial Plan
  • Prior Commercial Plan
  • Consensus Plan
  • Prior Consensus Plan
  • Budget
Start PeriodSelect the period you're comparing from.
End PeriodSelect the period you're comparing to.
Medium DeltaSpecify the percentage value used to highlight a medium variance. Values that exceed this value are displayed in yellow.
High DeltaSpecify the percentage value used to highlight a high variance. Values that exceed this value are displayed in red.

The table displays:

ColumnDescription
PlanThe plan values using the Compare From parameter value.
ComparisonThe plan values using the Compare To parameter value.
ABS DeltaTThe variance between the Plan and Comparison values.
Net DeltaTThe variance between the Plan and Comparison values.
Net % DeltaThe variance between Plan and Comparison values in percentage terms.
ABS % DeltaThe absolute variance between Plan and Comparison values in percentage terms.
Stat Forecast BasisThe statistical forecast basis as specified in D1000 - Global Parameters Dashboard.

The Comparison chart provides a graphical view of the selected plan and comparison values for the defined planning horizon.

Hover the cursor over a chart legend to display the legend's values in the chart. Hover the cursor over the data curve to display the data point values.