1. User's Guide
  2. Working with Detailed Profitability
  3. Creating Detailed Profitability Reports
  4. Detailed Profitability Stage Balancing Report

Detailed Profitability Stage Balancing Report

After calculating the model, use the Stage Balancing Report to validate the results by balancing input values to account for any unassigned costs.

To generate the Stage Balancing report, the following conditions must be satisfied:

  • Data must be loaded

  • Model data must be registered and calculated

The Stage Balancing structure provides the following information:

Measure Description
Stage Name The name of the Source stage is displayed.
Input This value is the Summary of the values associated with the Input balancing measure.
Total Output The sum of all values assigned from the Source Stage.

This value is associated with the AssignedPostStage balancing measure.
Idle Input that is not assigned to the destination is the IdleCost value. Calculated results for IdleCost are assigned depending on the driver type:

  • For ratio-based drivers, if Allow Idle is selected, IdleCost is generated using the formula IdleDriverValue/OverrideTotalDriverValue.

  • For rate-based drivers, IdleCost is generated if the sum of allocates values is less than the source object's input value.
OverDriven The OverDriven amount displayed on the Stage Balancing Report is the sum of all the calculated OverDriven values.

This amount is associated with the OverDriven balancing measure.
Unassigned The formula for the Unassigned values is equal to the following calculation:

"Total IN" - "Total OUT" - "Idle" + "OverDriven"

For additional information on the Stage Balancing measures, see the following sections: