Create a Production Forecast using Component History
You can create a production forecast using component history. When the process is run, JustFood will look at the value selected for the Forecast Based on field to determine which ledger entries to use in the forecast:
If the Forecast Based on field is Receipts only, then Purchase ledger entries, for the selected date range and location, are used in the calculation. If adjustments are being included in the calculation, then Positive Adjmt. entries will also be used. If production is being included in the calculation, then Output entries will also be used.
If the Forecast Based on field is Usage only, then Sales ledger entries, for the selected date range and location, are used in the calculation. If adjustments are being included in the calculation, then Negative Adjmt. entries will also be used. If production is being included in the calculation, then Consumption entries will also be used.
Note
Values entered in the Forecast fields on the Planning FastTab of the Item Card page will impact the calculated forecast entries.
To create a production forecast using component history
Choose the Search icon, enter production forecast, and select Production Forecasts.
In the Home tab, choose New. The Production Forecast Names page opens.
Enter the name and description of the production forecast.
On the Home tab, choose Edit Production Forecast. The Production Forecast page opens.
Populate the General FastTab.
Location Filter: Select the location to which this forecast will apply. This field must be entered.
Customer Filter: (Optional) Select the customer to which this forecast will apply.
View by: Select the time interval that will be displayed in each column. You can select from the following intervals: Day, Week, Month, Quarter, Year, or the Accounting Period, as set up in Financial Management.
You should consider which time interval that you want to use for future forecasts so that the time interval is consistent throughout. When you enter a forecast quantity, it is valid on the first day of the time interval that you select. For example, if you select a month, then the forecast quantity is for the first day of the month. If you select a quarter, then the forecast quantity is for the first day of the first month in the quarter.
View as: Select how the forecast quantities are shown for the time interval. If you select Net Change, then the net change in balance is displayed for the time interval. If you select Balance at Date, then the page displays the balance as of the last day in the time interval.
Forecast Type: Select Component.
Date Filter: Enter a date if you want to limit the amount of data displayed.
Entry Type Filter: Select Component History if you only want to see entries based on the calculated component history. Otherwise, leave the value as All.
On the Actions tab, choose Import History. The Create Production Forecast page opens.
Populate the Create Production Forecast page.
Item Analysis Date Filter: Enter the date range of the records you want JustFood to look at. For example, 01/01/18..12/31/18.
Item Analysis Period Type: Enter the time interval that will be analyzed. The value defaults in from the View by field. The number of periods is used when calculating an Average forecast.
If the date filter is 01/01/18..01/31/18 and the Item Analysis Period Type is Day, then there would be 31 periods.
If the date filter is 01/01/18..01/31/18 and the Item Analysis Period Type is Week, then there would be 5 periods (since the weeks in January cover 5 weeks).
If the date filter is 01/01/18..01/31/18 and the Item Analysis Period Type is Month, then there would be 1 period for the month of January.
If the date filter is 01/01/18..01/31/18 and the Item Analysis Period Type is Year, then there would be 1 period for 2018.
Item UOM: Select the item unit of measure to use, either the base UOM or the sales UOM.
Forecast Type: Ensure the value is Component. The value defaults in from the Production Forecast page. The Sales Item value means that JustFood will look at the Sale entries in the item ledger for the defined date range and location.
Include Adjustments: Select the check box if you want JustFood to include Positive Adjmt. entries when the forecast is based on Receipts Only, or Negative Adjmt. entries when the forecast is based on Usage Only.
Include Production Select the check box if you want JustFood to include Output entries when the forecast is based on Receipts Only, or Consumption entries when the forecast is based on Usage Only.
Forecast Based On: Select the type of components that you want to use in the calculation.
Receipts Only: JustFood will use the Purchase entries in the item ledger for the defined date range and location.
Usage Only: JustFood will use the Sales entries in the item ledger for the defined date range and location.
Net: JustFood will subtract the Usage values from the Receipts values.
The selected value also impacts the type of entries that are used when Include Adjustments or Include Production is selected.
Forecast Calc. Source: Select how you want the forecast entries to be calculated.
Average: The total for the selected date range divided by the number of periods (as determined from the values in the Item Analysis Date Filter field and Item Analysis Period Type field). For Net based forecasts, the average is the average receipts minus the average usage.
Low: The lowest entry in the selected date range. For Net based forecasts, the lowest is the lowest receipt minus the lowest usage.
High: The highest entry in the selected date range. For Net based forecasts, the highest is the highest receipt minus the highest usage.
Total: The total entries for the selected date range. For Net based forecasts, the total is the total receipts minus the total usage.
Spread Qty. Over Forecast Period(s): Select the check box if you want to spread the forecast over the selected periods defined on the Production Forecast page.
For example, if your entry has a forecast of 200, if you select this check box, 200 will be divided over the forecast periods. If you do not select this check box, each forecast period will show 200.
Action Type: Select what action should occur when the forecast is calculated.
Append to Existing Forecast: Select if you are adding months onto an existing forecast. Note: The new data that is being calculated should not be a duplicate of the date/time you already forecast otherwise you will double-up your forecast.
Delete Existing Forecast: Select if you are recreating an entire forecast, or creating a new forecast from scratch.
Click OK on the Create Production Forecast page. The production forecast is calculated, and the Production Forecast page is populated.
Note
Values entered in the Forecast fields on the Planning FastTab of the Item Card page will impact the forecast entries.
The value in the Forecast Multiplier field will be multiplied by the average, low, high or total value (for example, if a 2 is entered in the Forecast Multiplier field, and the total entry is 4, then the calculated entry will be 8).
The value in the Forecast Rounding Precision field is used to round up the average, low, high or total value (for example, if a 3 is entered for Forecast Rounding Precision field and the total entry is 1, then the calculated entry will be 3. If a 3 is entered for Forecast Rounding Precision field and the total entry is 4, then the calculated entry will be 6).