Review Projection Dates Page
  • 24 Jun 2024
  • 5 Minutes to read
  • Dark
    Light
  • PDF

Review Projection Dates Page

  • Dark
    Light
  • PDF

Article summary

This article reviews describes the fields, controls, and columns on the Review Projection Dates page within Weekly Forecasting.


Navigation

To access the Review Projection Dates page, navigate to the Weekly Forecasting page, then click the Review Projection Dates button located above the forecast week.

The Review Projection Dates button is disabled for imported forecasts.


Security

Users with access to view the Weekly Forecasting page will have access to view the Review Projection Dates page. Only users with the following permission can make changes:

Sales & Cash → Forecasts → Weekly Forecasting → Customize Projection Dates

This permission can be added to custom user roles or single users. Learn more about managing permissions and custom user roles here. The Permission Access report can be used to determine which user roles or users already have these permissions assigned. Learn more about user setup and security here.


Review Projection Dates Fields and Buttons

Field/Button

Description

New Projection Dates Available Indicator

Indicates that new projection dates have been polled after the forecast was generated. New projection dates are not automatically included.

Learn more about new projection dates here

Apply Changes

Applies changes made to the projection dates for all days of the week.

This button is disabled if any day has changes that have not been calculated (#3).

This button is disabled if all dates in the forecast week are in the past.

X Button

Closes the Review Projection Dates page without applying changes. 

Day of the Week

Each day of the week for the week being forecasted, including weather and projected sales.

The day whose projection dates are listed is displayed in blue and underlined. Click the day of the week to change the day whose projection dates are being listed.

The projected sales amount displayed here updates after changes to the projection dates are calculated. The projected sales amount displayed in the selected date details (#4) is always the current system-generated projected amount on the Weekly Forecast page.

When there are no projected dates included for the associated day, the projected sales will be $0 and an info iconwill be displayed.

Star Icon

Indicates that new projection dates have been polled for that day after the forecast was generated.

Learn more about new projection dates here

Recalculate

Recalculates the sales projection for the displayed day after making changes.

When recalculated, the sales projection is calculated as an average of the sales from the dates in the 'Included' section.

Selecting another day will automatically recalculate the sales projection for the displayed day.

When the displayed day is recalculated, the 'Variance %' column in the selected day details (#4) will also be recalculated as the difference between the recalculated forecast projection and the current forecast projection.

Selected Day Details

Forecast details for the selected day of the week. See the 'Selected Date Row' section below for more information.

Show Removed Toggle

Shows or hides dates excluded from the sales projection calculations.

Add Date Button

Adds a custom date to the included dates.

This button is disabled if the selected forecast date is in the past.

Each forecast day can have up to 25 projection dates in the 'Included' and 'Removed' sections combined. Once this limit is reached, the Add Date button is disabled.

New Section

Lists all projection dates that have been polled after the forecast was generated.

This section is not displayed if there are no new dates associated with the day.

Add All Button

Includes all new projection dates.

This button is disabled if the selected forecast date is in the past.

Add Button

Includes the associated projection date.

This button is disabled if the selected forecast date is in the past.

Included Section

Lists all projection dates included in the sales projection calculations. The section header displays a count of the included dates.

Remove All Button

Removes all included projection dates.

This button is disabled if the selected forecast date is in the past.

Remove Projection Date Button

Removes the associated projection date.

This button is disabled if the selected forecast date is in the past.

Manually Added Date Icon

Indicates that the associated date was manually added.

Removed Section

Lists all dates that have been excluded from the sales projection calculations. The section header displays a count of the removed dates.

Historical dates are automatically excluded when they have no sales associated with them.

When the forecast week is generated, historical dates that were manually excluded from prior published forecasts are automatically excluded.

Include Projection Date Button

Returns the associated date to the 'Included' section.

Dates with no sales cannot be included in sales projection calculations.

This button is disabled if the selected forecast date is in the past.

Trashcan Button 

Deletes a manually added date from the 'Removed' section.

This button is disabled if the selected forecast date is in the past.

Learn more about adding, removing, calculating, and applying changes to projection dates here


Selected Date Row

Column Title

Description

Date

Date currently selected and displayed.

Day of the Week

Day of the week for the selected date.

Variance %

Percentage difference between the calculated sales projection after adjustments to projection dates and the currently projected sales on the Weekly Forecasting page.

The calculated sales projection is displayed under the day of the week in the header.

Projected Sales

Current system-generated sales projection on the Weekly Forecasting page.

This amount does not update as changes to projection dates are made, and is displayed as a reference only.

Weather

Weather forecast for the selected date.

Events

Number of events associated with the selected date.

Hover over to display a list of the events. Event details can be viewed by clicking the associated View Event button in the event list.

Events are only displayed when the Scheduling module is enabled.

Log Entries

Number of log entries associated with the selected date.

Hover over to display the list of log entries. Log entry details can be viewed by clicking the associated View Log Entry button.

Projection Date Sections

The following columns are displayed for the New, Included, and Removed sections:

Column Title

Description

Business Day

Date of the projection day.

Dates are sorted in descending order by the absolute value of their 'Variance %'. If dates have the same absolute variance %, the positive value is displayed first. For dates with the exact same variance %, the newest date is listed first.

Week Day

Day of the week of the projection day.

Variance %

The variance between the actual sales from the associated historical date and the projected sales for the selected forecast date.

Calculated as: (actual sales from the historical date - projected sales for selected date) / projected sales.

Sales

Actual sales for that projection day.

The selected forecast metric will determine if net sales or gross sales is displayed.

The location's start of day time may impact the displayed sales for historical dates. Sales for historical dates are calculated as sales that occurred within the location's 24-hour business day. If the DSS for a historical day was imported prior to the start of day time being configured, the sales displayed in Weekly Forecasting may not match the sales displayed in the DSS.

Weather

Actual weather for that projection day.

Events

Number of events associated with the projection date.

Hover over to display a list of the events. Event details can be viewed by clicking the associated 'View Event' button in the event list.

Events are only displayed when the Scheduling module is enabled.

Log Entries

Number of log entries associated with the projection date.

Hover over to display the list of the log entries. Log entry details can be viewed by clicking the associated View Log Entry button.


Was this article helpful?