DEFAULT BUP CREATION EXEC GROUP 2

Description

Aggregates drivers to departments, calculates non-productive hours, retrieves event hours, and performs the corresponding calculations to create a bottom-up projection.

Parameters

This execution group has the following parameters:

Parameter Description Default Values
GROUPING The level to use when generating the forecast.

STORE

REGION

CORPORATE

Condition Class
None
Rules

This execution group includes the following rules:

Rule Description See...
LOAD AFFECTED DATA RULE Loads the data required to process the current chunk. LOAD AFFECTED DATA RULE
OVERRIDE FCST DRIVERS Loads any override values forecasted drivers. OVERRIDE FCST DRIVERS
LOAD DRIVER RULE Loads driver forecasts. LOAD DRIVER RULE
WORKLOAD GENERATION RULE Regenerates workload by distributing edited sales values on the Worksheet to their constituent drivers and then recalculating staffing requirement hours. WORKLOAD GENERATION RULE
AGGREGATE DRIVER TO DEPT Aggregate driver forecast data for exposed volume types to the department level AGGREGATE DRIVER TO DEPT
ESTIMATE NON PRODUCTIVE HOURS RULE Estimates the non-productive hours by applying a growth rate to last year's actual non-productive hours. The growth rate is the ration of this year's forecasted sales to last year's actual sales. ESTIMATE NON PRODUCTIVE HOURS RULE
RETRIEVE EVENT HOURS Loads event hours from LFSO. RETRIEVE EVENT HOURS
BUP LEAF RECALCULATION Recalculates BUP data for leaf locations. BUP LEAF RECALCULATION
BUP AGGREGATION Aggregates hours and other fields for BUP. BUP AGGREGATION
BUP NON LEAF RECALCULATION Recalculates BUP data for non-leaf locations. BUP NON LEAF RECALCULATION
VALIDATE SYSTEM MAX VALUE Verifies that values stored in the database do not exceed the specified maximum values. VALIDATE SYSTEM MAX VALUE
AUDIT HISTORY DATA RULE Constructs the data to store for auditing purposes. AUDIT HISTORY DATA RULE
RESET VALUES RULE Resets the values after a stage of the calculation. RESET VALUES RULE
SAVE AFFECTED DATA RULE Saves the data calculated in this execution group. SAVE AFFECTED DATA RULE
CLEAN AFFECTED DATA RULE Dumps the loaded location data in forecast data. CLEAN AFFECTED DATA RULE
Actions

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

User Action

Budget

Forecast

BUP

See...

Generating a BUP.

n/a

n/a

yes

Generating a BUP