Default Forecast Layout Columns

The following table describes the columns in the default forecast layouts. For a description of these columns in the context of the Worksheet and from the perspective of a budget manager, see Columns in Forecasts.

Type	Column Name	Edit-able	Field Source and Operation
State	n/a	no	Represents the current state of the forecast. For a list and descriptions of states, see States. This column is displayed in the multiple location/single time period view.
Sales	Last Year's Actual Sales	no	Copied from LFSO Master Actuals.
Sales	This Year's Actual Sales	no	Copied from LFSO Master Actuals.
Sales	Budget Sales	no	Master version of budget.
Sales	System Forecast Sales	no	Generated system forecast.
Sales	Adjusted Forecast Sales	yes	Default is the system forecast (Working version).
Sales	Sales % Change from Budget	no	Calculated percentage based on adjustment.
Payroll Percent	Budget Payroll	no	Master version of budget.
Payroll Percent	Forecast Payroll %	yes	Calculated based on adjustment (Working version).
Payroll Percent	Payroll % Leverage	no	Master version of budget.
Payroll Percent	60% Rule Payroll %	no	Calculated based on adjustment.
Hours	Adjusted Hours	no	Calculated based on adjustment (Working) version.
Hours	Productive Hours	no	Calculated as Adjusted Hours minus Holiday Hours minus Vacation Hours minus Other Hours. If this results in a negative value, then it becomes a zero (0) value.
Hours	Holiday Hours	yes	Imported as part of the budget import (Working version).
Hours	Vacation Hours	yes	Imported as part of the budget import (Working version).
Hours	Other Hours	yes	Imported as part of the budget import (Working version).
Payroll	Budget	no	Master version.
Payroll	Adjusted Forecast Payroll	no	Calculated based on adjustment (Working version).
Payroll	60% Rule Payroll	no	Calculated based on adjustment.
AHR	Budget Average Hourly Rate	no	Master version.
AHR	Adjusted Forecast Average Hourly Rate	no	Calculated based on adjustment (Working version).
SPH	Budget Sales Per Hour	no	Master version.
SPH	Adjusted Forecast Sales Per Hour	no	Calculated based on adjustment (Working version).
Trend Values	Actual & Forecast Sales Trend	no	Various. See Forecasting Trended Values.
Trend Values	Sales Trend Variance from Budget (%)	no	Various. See Forecasting Trended Values.
Trend Values	Actual & Forecasted Payroll % Trend	no	Various. See Forecasting Trended Values.
Trend Values	Payroll % Trend Leverage to Budget	no	Various. See Forecasting Trended Values.