Forecasts

Pick list used to select which type of report to generate. Options are:

• Forecast Detail - Displays an editable, detailed view of the selected or new Forecast, depending on other pre-filter options selected.
• Forecast Summary - Displays an editable, summarized view of the selected or new Forecast, depending on other pre-filter options selected.
• Forecast vs Actual - Displays a read-only report of the Forecasted Sales against the Actual Sales recorded in Deacom.

Only available with a "Forecast Source" of "Existing" or "Inactive". Search field used to select a specific Forecast.

Pick list used to determine if the selected date should be used to filter on a Forecast's start or end date.

Sets the start date for a new Forecast.

Sets the end date for a new Forecast

Search field used to filter Forecast selections/results by Bill-to Company.

Search field used to filter Forecast selections/results by Ship-to Company.

Search field used to filter Forecast selections/results by Part Number.

Used to filter Forecast selections/results by parts that start with the inputted string.

Search field used to filter Forecast selections/results by Category.

Search field used to filter Forecast selections/results by Sub-Category.

Search field used to filter Forecast selections/results by Facility.

• Forecast lines can be assigned to a specific Facility.

Search field used to filter Forecast selections/results by Facility Group.

Search field used to filter Forecast selections/results by sales for items assigned to the selected Item Planner.

Search field used to filter Forecast selections/results by sales for items within the selected account.

Search field used to filter Forecast selections/results by items within the selected group.

Pick list used to display only items within the selected cycle counting classification.

Pick list used to filter out inactive parts when creating or viewing a Forecasting sheet.

Pick list used to filter for purchased or manufactured parts. Options are: All, Manufactured, Purchased.

Determines the method that will be used to generate the Forecast in the system.

• Introduced in version 16.06.011 to support the creation of moving average forecasts.
• When this form is launched from the Foreasts pre-filter, the only option is "Manual".
• When this form is launched from Sales Order Reporting reports, the options are: Linear Regression, Moving Average, Un-Changed, and Weighted Moving Average.
• Moving Average Forecast Method Logic:
  • The system will check that the Forecast Start date is after the Historical Data Start Date. If not, the user will be prompted with "Historical data start date must be prior to the forecast start date." If this condition is satisfied, the system will check that periods considered are > 0. If not - the system will prompt the user "Periods considered must be greater than 0." Once the checks have passed the system will continue to create the forecast.
  • Generate the forecast buckets and quantities, but the first bucket of the new forecast will be based on the Historical Data Start Date, rather than Forecast Start. Then the system will populate all forecast quantities into the new "Original Quantity" field (f2_origquant) on forecast lines rather than the "Quantity" ( f2_quant.) field. f2_quant is 0 until the moving average logic below is applied.
  • If the data in the order detail report does not include data for the Historical Start Date bucket, warn the user. 'The order detail report does not contain any data for the Historical Data Start bucket. Do you want to continue? If no do not create the forecast and return to the New Forecast form. If yes, continue and create the forecast.
  • Next, the bucket containing the forecast start date will be the first date a new forecast is created for and populated into f2_quant
    • Apply Moving Average logic using numbers from f2_origquant to find the first f2_quant.
    • Any buckets prior to the forecast start date will keep f2_quant = 0.
    • Apply Moving Average logic using f2_origquant, and newly generated forecasts to generate additional periods.

• Weighted Moving Average Forecast Method Logic:
  • When calculating the moving average using the weights, the weights are rolled forward and re-applied for each bucket calculation.
  • When applying weighted moving average calculation from Apply Smoothing the changes are applied to the grid on the Edit Forecast form that is currently open.

Notes on Moving Average Options:

1. Other functional changes: When forecast lines are imported on the Forecast2 form set f2_origquant = f2_quant. When forecast lines are manually created on the Forecast4 form, the first time the line is saved set f2_origquant = f2_quant.
2. Moving Average and Weighted Moving Average: Version 17.02.008.0000 introduces a significant option that allows users to pull data from the past, and use it to generate a new forecast. This is particularly useful for when running forecasts on seasonal items. See the Creating and Modifying Forecasts - Entering Moving and Weighted Moving Average Forecasts for Seasonal Items section for additional information with an example.

• Linear Regression Forecast Method Logic:
  • When Continue is clicked, check that the Historical Data Start date is prior to the Forecast Start Date. If not - Prompt the user "Historical data start date must be prior to the forecast start date." Once the checks have passed the system will continue to create the forecast.
  • The first bucket in the new forecast should be based on the Historical Start Date rather than Forecast Start date, like Moving Average.
  • Populate all calculated bucket quantities into the "Original Quantity (f2_origquant) field for the respective bucket.
  • Any buckets prior to the Forecast Start date should have "Quant" (2_quant )set to 0.
  • The bucket containing the Forecast Start date will be the first date a new forecast is created for, and populated into f2_quant. Apply linear regression logic below using the forecast quantities in f2_origquant for the bucket containing the forecast start date, and then all remaining buckets in the forecast.
  • Populate all calculated forecasts into f2_quant for each bucket.
  • Calculate the standard error of the estimates, and store in fo_stderr.
  • The steps for performing a Linear Regression forecast is available on the Creating and Modifying Forecasts page.
• Simple Exponential Smoothing
• Double Exponential Smoothing
• Triple Exponential Smoothing
  • The three exponential smoothing methods represent time series forecasting method for univariate data that can be extended to support data with a systematic trend or seasonal component.
  • The forecast method logic when using any of these three methods is listed below.
    • The first bucket in the new forecast should be based on the Historical Start Date rather than Forecast Start date, like Moving Average or Linear Regression.
    • Populate all Un-Changed bucket quantities into the f2_origquant field for the respective bucket.
    • Any buckets prior to the Forecast Start date should have f2_quant set to 0.
    • The bucket containing the Forecast Start date will be the first date a new forecast is calculated for and populated into the f2_quant. Apply selected exponential smoothing logic. Examples of each outlined below.
    • Populate the calculated quantity into the f2_quant for the forecast start bucket.
    • Populate forecast errors into f2_stderror.
  • The apply smoothing logic (applied when the user clicks to update the forecast) will apply all the same data checks as indicated above and when all requirements are meet, will re-apply the forecast method using the f2_origquant in the forecast.
  • See the Creating and Modifying Forecasts page for examples and details on using these methods.

Sets the start date for a new Forecast.

Sets the Historical Start Date. Only available, and required, when using a Forecast Method of Linear Regression, Moving Average, and Weighted Moving Average.

• Support the creation of moving average forecasts.
• This field is set to the first bucket of the forecast and disabled when using the "Apply Smoothing" button and selecting a Forecast Method of Simple, Double, or Triple Exponential Smoothing.

Pick list used to select the time period for each bucket within the Forecast sheet. Options are: Days, Months, Weeks.

• Disabled when using the "Apply Smoothing" button and selecting a Forecast Method of Simple, Double, or Tr;iple Exp;onential Smoothing.

Used in conjunction with the "Bucket Type" to determine how many buckets are used in the Forecast sheet.

• A maximum number of 60 buckets may be displayed.

When set to true, the forecast records that will be created are going to be created by part, date, and then facility based on the facility set on the Sales Order.

When set to true, the forecast records that will be created are going to be created by part, date, and then Bill-To based on the Bill-Tos set on the Sales Order.

When set to true, the forecast records that will be created are going to be created by part, date, and then Ship-To based on the Ship-Tos set on the Sales Order.

If clicked, opens the Select a Forecast form, which is used to copy an existing Forecast sheet to use as a base.

If clicked, opens the Enter Percent Increase form, which is used to apply a percent increase to all the parts displayed in the Forecast grid.

• Also allows a user to only increase a selected bucket or period of the Forecast sheet by a given factor.
• By default, the percent increase is set across all buckets/periods.
• Additional information is available in the Utilizing percent increases section of the Utilizing Forecasts in MRP page.

If clicked, recalculates the price of each Forecast line shown on the grid, respecting advanced filters, based on the Forecast's start date.

If clicked, opens the Import File form, which is used to import an Excel spreadsheet. Multiple sheets with multiple forecast lines can be imported at the same time. The required columns on each sheet are as follows, using an example with 3 buckets: pr_codenum Bucket_A Bucket_B Bucket_C

pr_codenum Bucket_A Bucket_B Bucket_C

(PartID)-------- int------- int---------- int

Note that the string after "Bucket_" will be accepted of what comes after, but it is recommended to use a simple convention to keep track. Optional columns include:

Column Name Description

f2_biid Bill-To Company ID

f2_shid Ship-To Company ID

f2_waid Forecast Line Facility

Notes:

• If no forecast name is entered, the user will be prompted to enter a name and the process will stop.
• If the bucket count is incorrect on any of the sheets, the user will be prompted and the process will stop.
• The data will fail validation if there is invalid bucket data, an invalid or non-saleable part, or a part duplicate based on the f2_biid, f2_shid, or f2_waid.

Displays the name of the Forecast.

Pick list used to determine how the Buckets are broken down. Options are Dollars and Units, with "Units" being the standard option, particularly if price fluctuations exist within a manufacturing organization.

Pick list used to determine how the Forecast will be applied to MRP reports. If forecast quantities exist that are prior to the start date of the MRP report, they will be ignored. Options are:

• Days - For a monthly forecast, the quantity for each month is divided evenly by the number of days in the month. For a weekly forecast, the quantity is divided by the number of days remaining in each week.
• Weeks - For a monthly forecast, the quantity for each month is divided evenly by the number of weeks remaining in the month for the MRP report, where Monday is considered the first day of the week.
• Months - For a weekly forecast, all of the quantities in that month will be summed and placed in one lump sum on the MRP report.

Pick list used to determine where the Forecast quantity will be placed in MRP. Options are First Day and Last Day. This field has no effect when "MRP Bucket Type" is set to "Days".

Used to change the Currency rate that will be used when creating and saving the Forecast.

Memo field used to add Notes to the Forecast.

If checked, this Forecast is factored into MRP.

Pick list used to select if the exclusion is based on a day of the week or specific date.

Sets a specific date excluded from the Forecast.

If clicked, applies the selected changes to the Forecast line.

If clicked, recalculates the "Price" of the selected Forecast line based on the Forecast's start date.

Search field used to select the appropriate Part Number.

Search field used to assign items to a specific Bill-to or Ship-to Company. When calculating Forecast sums for a part in MRP, the system will also sum the Forecast lines assigned to a specific Bill-to or Ship-to.

Search field used to assign items to a specific Facility. When calculating Forecast sums for a part in MRP, the system will also sum the Forecast lines assigned to a Facility.

• Useful in situations where customers wish to break Forecasts up over Facilities while forecasting.
• The system will filter out Forecast lines based on the Facility selected on the pre-filter form.
• If MRP is run without a Facility filter, the system will get all Forecasts whether or not they have a Facility selected.
• If MRP is run with a Facility filter, the system will get all Forecasts without a Facility filter, and all Forecasts with the Facility specified on the pre-filter.

Pick list used to scale the Forecast line. Options are:

• Percent Increase - Increases each bucket total in the grid by the "Factor" specified. If the Factor is negative, the lines will be decreased.
• Proportional Total - Scales each bucket proportionally so that the total over the entire time period is equal to the "Factor" specified.
• Straight Line Total - Sets each bucket at the same value so that the total over the entire time period is equal to the "Factor" specified.

Number used to determine the factor that will be applied to the "Change Type" selected above.

Displays the "List Sale Price" of the selected Part Number as defined on its Item Master Costs 2 tab.

Uses the Deacom Pricing Hierarchy to calculate the price for the Part selected.

Enter appropriate value. Uses a mask of 9.99

Enter appropriate value. Uses a mask of 9.99

Enter appropriate value. Uses a mask of 9.99