PS: Flow Through Report Reference

 

Purpose:

• The Flow Through report allows users to analyze flow through performance by selecting specific accounts and comparing them against chosen benchmarks (such as Last Year or Budget). The report displays the calculated Flow Through, the standard calculation, and the variance.

Location & Access: 

• Users can customize these data views and report calculations by utilizing the Options icon within the report.

 

The Data: Report Customizations

Use this table to understand the configurable settings available within the Flow Through report's Options menu.

Setting	Definition / Function
Accounts	Allows the user to select the specific accounts they would like to review.
Data Sets	Defines the comparison dataset used to gauge flow through (e.g., Prior Year or Budget).
Standard Driven By	Allows the user to choose if the "Standard" is driven by the revenue variance or the profit variance.
Variance Standard	Allows the user to adjust the required positive or negative variance standard.
Variance Colors	Dictates the color-coding logic of the report. Colors can be based on either the number's sign (positive/negative) or the Flow Through Standard.

---

The Data: Variance Calculation Options

The variance calculation has two distinct options you can choose from to dictate how the variance is computed:

Option	Formula
Option 1	ProfitVariance - (Revenue Variance * Standard)
Option 2	RevenueVariance - (Profit Variance * Standard)

---

The Data: Standard Flow Through Formulas

Flow is calculated using a complex formula. For most clients, if the revenue is the first column and the GOP is the second column, the system uses the following conditional logic:

Condition	Calculation Formula
Total Revenue Var > 0 AND GOP Var > 0	Flow ThruPercent = sDiv(GOP Var, Total Revenue Var) * 100
Total Revenue Var < 0 AND GOP Var < 0	Flow ThruPercent = -sDiv(GOP Var, Total Revenue Var) * 100
Total Revenue Var > 0 AND GOP Var < 0	Flow ThruPercent = (sDiv(GOP Var, Total Revenue Var) - 1) * 100
Total Revenue Var < 0 AND GOP Var > 0	Flow ThruPercent = (1 - sDiv(GOP Var, Total Revenue Var)) * 100

---

System Limits & Constraints

• Custom Company Formulas: Please note that some clients have a specific flow calculation designated for their company that utilizes a different formula than the standard logic noted above. If you need to know your company's exact formula, please reach out to the ProfitSword Support team.