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.