DFT FORECAST WORKSHEET EXEC GRP 2

Description

Performs calculations on the Worksheet that must occur after the set of calculations performed by the execution group DFT FORECAST WORKSHEET EXEC GRP 1. The calculations are performed on these fields:
  • Payroll Percent Leverage
  • Sales Percent Change
  • Payroll Percent Trend
  • Payroll Percent Trend Leverage
  • Sales Trend Variance
Parameters

None

Condition Class

com.workbrain.app.modules.budgeting.rules.IsRecalculationCondition

Rules

This execution group includes the following rules:

Rule Description See...
PAYROLL PERCENT LEVERAGE Calculates the leverage between original and adjusted payroll percent. PAYROLL PERCENT LEVERAGE
SALES PERCENT CHANGE Calculates the percentage change from original sales. SALES PERCENT CHANGE
PAYROLL ADJUST RULE Adjusts the payroll and payroll percent values based on an adjustment factor. PAYROLL ADJUST RULE
PAYROLL PERCENT TREND Calculates the actual and forecast payroll percent. PAYROLL PERCENT TREND
PAYROLL PERCENT TREND LEVERAGE Calculates the leverage to budget for trend payroll percentage. PAYROLL PERCENT TREND LEVERAGE
SALES TREND VARIANCE Calculates the variance of sales from budget. SALES TREND VARIANCE
Actions

This execution group is executed as part of the following user actions:

User Action Budget Forecast BUP See...
Updating the view on the Worksheet. no yes no Updating the View on the Worksheet
Recalculating data on the Worksheet. no yes no Recalculating the worksheet
Saving data on the Worksheet. no yes no Saving the worksheet
Locking the Worksheet. no yes no Locking the worksheet:
Releasing down the hierarchy. no yes n/a Releasing Down the Hierarchy
Submitting up the hierarchy. no yes n/a Submitting Up the Hierarchy
Mass-editing data on the Worksheet. no yes no Mass-editing the worksheet