Historical Data

It is recommended that you have at least two years of historical sales and inventory data for creating MFP targets. Less data can be used, but the more data that is available, the more statistical significance can be given to the MFP targets.

It is also important to have two years of history to produce an optimal forecast.

Note:

Ty BOS measures (drtybos*) are optional. These measures are the very first week BOP values within the domain. If they are not loaded, it will only affect the very first period inventory within the domain. For the rest of the weeks, the loaded previous period EOP will be used as BOP after the weekly batch. When the calendar is purged, Ty BOS will be reset by the weekly batch.