Forecasting Trended Values

The Trend Values columns display the forecasted totals for the end of the selected time period. This enables a budget manager to predict weekly, monthly, quarterly, or yearly outcomes based on a combination of business performance to date and forecasted data for the rest of the period. Trend values display actual values for past periods and forecasted values for future periods. The totals are a combination of both actual and forecasted values.

These columns are refreshed at every recalculation and whenever new sales and payroll actuals are imported into the system. The Worksheet then displays the data aggregated to a weekly level for display and calculations.

Infor Consulting Services imports the sales and payroll actuals.

The following four columns hold forecast trended values:

• Actual & Forecast Sales Trend Column
• Sales Trend Variance from Budget Column
• Actual & Forecast Payroll % Trend Column
• Payroll % Trend Leverage to Budget Column