Forecasting Setup

From Wiki-eostar.com
Jump to: navigation, search

The addition of the Forecast Plugin permits eoStar to forecast sales and purchases for products.

Forecasts are broken into periods within the year, to better fit with the sales patterns associated with beer and wine sales.Through the forecast type, the user can create a new type with a specific number of periods within a year, as well as add products to that type. The Forecast Entry allows for the editing of these periods to project sale possibilities per period.

Additionally, the forecasts generated through the forecast plugin can be used in exports to third party software. For example, forecasts can be sent to the Miller Brewing Company using the File>Interface>Miller>Export Forecasts to Miller menu option.

Inventory>Forecast>Setup Forecast Owners
This screen is used to create forecast owners. Forecast owners are a way of grouping forecast records.

Forecast Owner

Add a Forecast Owner

  1. Go to Records>Forecasting>Setup Forecast Owners.
  2. Click the command button New.
  3. Specify record number, either by selecting the provided number or creating your own.
  4. Enter information - name.
  5. When finished making changes, click the command button Post.
Inventory>Forecast>Setup Forecast Record
Product Selection (Include or Exclude) Popup
Forecast records are any parameters set up for a forecast. This selection becomes available with the Forecast Plugin. The Forecast Owner is used to categorize the records. There are two types of forecast records available - sales and purchase. Sales forecasts are estimates on the amount of products that will be sold. Purchase forecasts deal with the amount of products purchased by the company to meet future demands.

Each forecast may have a different amount of periods per year. After the periods are set up, years may be added to the forecast on the Periods Panel.

All available items may be added to the forecast records. However, if two records have the same Forecast owner, then the same item cannot be on both records.

If there is a forecast record for the current year, that year will now be shown as the default in the forecast entry screen.

Forecast Record

Add a Forecast Record

  1. Go to Records>Forecasting>Setup Forecast Record.
  2. Click the command button New on top bar.
  3. Specify record number, either by selecting the provided number or creating your own.
  4. Add information- Name, Parameters (Sales or Purchase), the number of periods per year, and Forecast Owner.
  5. Click the command button Save on top bar when finished.
  6. To add items to the forecast type, go to the Inventory>Forecast>Setup Forecast Records Items Panel
    1. Either use the drop down arrow to select the items, or click Add Items via Product Selector.
  7. When finished making changes, click the command button Post.

Additional Information

Items Panel

The items panel is used to add items to the Forecast record. To add items, either use the product selector or add individual items using the drop down arrow. To delete an item from the list, highlight the item and click Delete.

Periods Panel

The periods panel both shows and allows editing for the chosen periods per year.

To edit a period, select the area you wish to change and use the drop down arrows to change either the date or the status. To Change the Caption, select the area and type in a new caption. The three status types are - enter original, enter modified, or locked.

The forecast record can span many years. To add another year, click the command button Add #### at the bottom of the screen. The new year will pop into the center screen with the same number of periods. When a new year is added, the previous year as well as the following year become available. For example, if 2008 is added, then both 2007 and 2009 will become available to be added. If 2009 is added, then 2010 will become available.

Forecasting Review and Edit

Edit or Review a Forecast

Inventory>Forecast>Entry
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.

Sales Forecasts

Edit a Sales Forecast

  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.

EDI Trading Partners

Setup EDI Sales and Purchase Forecast Record

EDI>Trading Partners
Trading Partners are any organizations that will be exchanging EDI documents or data with your company. For example, any customers in the chains of CVS Pharmacy or Target. There are two types of Trading Partners: Retail and Suppliers.

The EDI Item map permits multiple items to share the same code as long as one of them is tagged as outbound. The Item map panel will not pull up tap handles and billing codes.

Note: "Trading Partners" is an EDI term implying organizations that exchange EDI documents.

For more information, see EDI Trading Partners.