Forecast Review/Edit

Jump to: navigation, search
Forecast Entry edit screen
With the Forecast Plugin, the forecast entry (renamed the Forecast Review/Edit) form shows the sales forecasts and makes it possible to edit the forecasted sales amounts of items within each period in the forecast. The product amounts in the Forecast entry can be either derived from Demand Foresight, the previous year's values, or user-created values.

Forecasts are created in months but are managed in weekly quantities. Because not all weeks are finished by the last day of the month, the periods are divided into two parts. Periods and their parts are setup in the Forecast Records. The part amounts placed in the records will correlate with the the total amounts per part allowed. The forecast information is exported to Miller with the File>Interface>Miller>Export Forecasts to Miller with the splits in the Miller forecast as a three point percentage based on the amounts in the parts. In the Forecast Entry, it is possible to add values for both or either parts in case quantities. The parts can be viewed and edited by checking the checkbox Display in 2-part format.

To total the forecasts by brand, check the checkbox Show & Group By Brand. When in the editing format, clicking on the hyperlink at the bottom of a brand will allow the user to add a brand total which will be split between all products in that brand. The total for each product will be based on the item's share of the forecasted total for the brand. This total is compared to the other items in the brand.

The same ideology is added for the item totals. Each total added will split that total across all of the periods for that item.

Locked periods cannot be edited in the forecast entry. Periods can be locked by clicking on the period's column header (i.e. Q1, Q2, Q3, etc.) and selecting Set Status - Locked.

To add the previous year's forecasted quantities, click the hyperlink RESET From Prior Year Values. This only works if the previous year's forecast is located in the Period Panel on the selected Forecast Record.

With the addition of the Demand Foresight Plugin, it is possible to import information from the Demand Foresight software into the Forecast entry. These files contain demand planning information to add to the overall forecast to create a more accurate estimate on the amounts. To import files, click the hyperlink Import From Foresight. The importing of files will overwrite all previously created forecasts in the entry.

Values may be entered in Case equivalencies (CE) or cases rather than in just cases; however, the underlying data is in primary packs. This means that the values will be altered slightly to equate to the nearest primary pack amount. The screen will list if the amounts are to be added in cases or Case equivalencies (CE).

After beginning a Forecast edit, it is possible to add additional comparison columns into the grid. To add the columns, click the hyperlink Add/Hide Additional Comparative Columns. This popup allows the addition of two different types of columns - Difference columns and comparative forecast total columns. The difference columns are extra columns which display the difference between the forecasted value and the sales of the previous year. This column can be shown as a percentage or as a numeral. The difference column will appear next to each period and total columns, so that, for example, if there were 5 period columns and one total column then there would be 6 difference columns to the right of each other column. The comparative forecast total columns adds additional columns to the far right that contain data from other forecast records. These records must use the same warehouse and year. To add a comparative forecast total column, from the popup, use the drop down arrow to select the record, type in a caption and click Add. When finished, click the command button Apply.

How-to Edit Sales Forecasts

  1. Go to Inventory>Forecast>Entry.
  2. Using the drop down arrows, select the warehouse, forecast, and year.
  3. Click the command button Start Edit.
  4. Either edit the cells by typing in the amounts directly, or use the cell editor located at the bottom.
    1. To pre-load amounts from Demand Foresight, click the hyperlink Import From Foresight (if available).
    2. To load the forecasted amounts taken from the previous years, click the hyperlink Reset from Prior Year Values.
    3. Type in the Item number and the forecast quantity and click the command button Enter.
  5. When finished making changes, click the command button Stop Edit.