Columns on the Labor Budgeting Worksheet

Locations, State, Time Periods, Sales, Drivers, and Productive Hours Columns.


Column Group Heading	Single Column Heading	Name on the Layouts Detail Page	Column Name on the Layouts Detail Page	Editable by Default	Source
Locations					This column is displayed only if you specified the Worksheet to display data for a single time period and multiple locations. The location for which generated data is displayed for the specified time period.
State					This column is displayed only if you specified the Worksheet to display data for a single time period and multiple locations. The state of each location displayed on the Worksheet , as described above. For information on states, see States.
Time Periods					This column is displayed only if you specified the Worksheet to display data for a single location and multiple time periods. The time period for which generated data is displayed for the specified location.
Sales	Budget Sales	SALES	FCIT_SALES	yes	The sum of all drivers based on the sales/revenue volume type. For information on volume types, see Setting Up Volume Types in LFSO.
Drivers	Budget Average Hourly Rate	AHR	FCIT_AHR	yes	The weighted average of AHR forecasts for all child locations. Note: You can configure the Worksheet to display other drivers, such as the number of items, customer traffic, and returns.
Productive Hours	Staffing Requirements Hours	STAFF REQUIREMENT HOURS	FCIT_STF_ REQ_HRS	no	The total workload required. This value is based on workload generation data from LFSO that is aggregated to the SO_RESULTS_SUMMARY table. This field uses the same workload generation mechanism as in LFSO, and the same staffing requirements. The exception is that in LFSO this value is calculated for a week, and in the Budget Creation module value is calculated for a year.
	Variable Coefficient	VARIABLE COEFFICIENT	FCIT_PR_ FACTOR	no	This value is calculated in the layout as the ratio between Staffing Requirement Hours, above, and Volume Driven Hours, below. See Variable Coefficient Column.
	Variable Hours	VARIABLE HOURS	FCIT_VAR_ HRS	yes	This value is the difference between Staffing Requirement Hours, above, and Minimum Hours, below: Variable Hours = Staffing Requirement Hours - Minimum Hours Increasing this value increases the amount of hours dedicated to events and volume-driven work, which are in addition to the minimum required hours. Decreasing this value indicates that fewer hours are required than indicated by workload generation.
	Minimum Hours	MINIMUM HOURS	FCIT_MIN_ HOURS	no	This number originates in the reference budget. The number indicates the minimum hours for fixed-shift, permanent employees at a location, according to the Corporate Finance office. If the total hours is less than this number, then by default, you cannot lock the budget. This number is specified by the VALIDATE MIN HOURS business rule. See VALIDATE MIN HOURS Rule.