Forecasts

A new home for the Coupa Supply Chain documentation

Starting with Supply Chain 42, our documentation will be located on Coupa Compass. The help here will continue to be accessible for the foreseeable future, but will no longer be updated. If you need a Compass user account, contact your company’s Designated Support Contact (DSC).

You can access new and updated Supply Chain documentation in the following location on Compass:

https://compass.coupa.com/en-us/products/supply-chain-design-and-planning

Forecasts

Internal Table Name: Forecasts

Name

Technology: S

Table: Forecasts

Internal Name: ForecastName

Type: Short Text (100)

Enter a descriptive name for the forecast you are specifying.

Basis

Technology: S

Table: Forecasts

Internal Name: ForecastBasis

Type: Short Text (50)

One of Period Length, Day, Week, Month (30 Day), Quarter (91 Day), Year.

Enter the length of the time periods for which you are forecasting demand or setting the Reorder Point and Reorder/Order Up to Qty for R,Q-Targets and s,S-Targets inventory policies. This is one of:

Period Length – If you have defined periods, this is the length of the defined period. In a single period model, it is the model horizon.
Day – This is a single day.
Week – The first day of the week is based on the model horizon. For example, if your model horizon starts on 1/1/2015, this is a Thursday, so your forecast week will be Thursday through Wednesday.
Month (30 Day) – The first day of the month is based on the model horizon. For example, if your model horizon starts on 1/7/2015, the 30 day period will start on this date. An average of 30 days is used, rather than months of varying lengths.
Quarter (91 Day) – The first day of the quarter is based on the model horizon. For example, if your model horizon starts on 1/7/2015, the 91 day period will start on this date.
Year – This is a year starting on the first day of the model horizon.

Default: Month (30 Day)

Type

Technology: S

Table: Forecasts

Internal Name: ForecastType

Type: Short Text (50)

One of Forecast, Targets.

Choose whether you are using forecasting or targets. If an "s,S targets" or an "R,Q targets" inventory policy is being used, then you must select Targets.

Default: Forecast

Quantities

Technology: S

Table: Forecasts

Internal Name: ForecastQuantities

Type: Memo

Enter the anticipated quantities of product needed for each period (forecasting) or the Reorder Point and Reorder/Order up to Qty (targets). Enter a value, then optionally select a quantity, weight or volume unit of measure. If you do not select a unit of measure, the default Quantity Unit Of Measure from Model Settings is used. Commas should be used to separate numbers.

The number of quantities you enter depends on the period you choose and how long your simulation will run. The table below provides examples of how many requirements would be needed for specific simulation lengths and forecast periods (type is set to forecast in these examples).

If Simulation Lasts:	Forecast Period is:	Enter At Least This Many Quantities:
30 Days	Day	30
30 Days	Week	5
1 Year	Day	365
1 Year	Month	12
1 Year	Quarter	4
5 Years	Year	5

The DOS Window setting in the Inventory Policies data table also affects how many forecast quantities you should set. You should enter enough quantities to cover your simulation duration plus your DOS Window. For example, if your simulation lasts 30 days, your Forecast Period is Day, and your DOS Window is 7 days, then you should enter 37 Quantities, not 30 as shown above.

Use the name of the forecast specified in this table in the Forecast Name field of the Inventory Policies table for the product-site combination(s) that this forecast applies to.

Notes

Technology: S

Table: Forecasts

Internal Name: ForecastNotes

Type: Memo

Enter optional descriptive notes about the forecast.

Last modified: Wednesday May 15, 2024

Is this useful?

Yes No