DEFAULT REPORT CALCULATE EXEC GRP

Description

Performs calculations required for the Department Type Totals Report that must occur after the set of calculations performed by the DEFAULT REPORT CREATION EXEC GRP execution group. See DEFAULT REPORT CREATION EXEC GRP

The calculations are performed on these fields: .
  • Payroll Percent Leverage
  • Sales Percent Change
  • Payroll Percent Trend
  • Payroll Percent Trend Leverage
  • Sales Trend Variance

See Viewing Plan Data by Department Type.

Parameters

None

Condition Class

None

Rules

This execution group includes the following rules:

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

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

User Action

Budget

Forecast

BUP

See...

Viewing plan data by department type.

yes

yes

yes

Viewing Plan Data by Department Type