A record should be entered in this table if you wish frepple to calculate a safety stock or a reorder quantity for a buffer. The calculation can be done for raw materials, intermediate materials and/or end items.
Fields
| Field | Type | Description |
|---|---|---|
| buffer | non-empty string | The bufer name for which safety stock and reorder quantity should be computed |
| description | string | A description for this inventory planning record. |
| category | string | A category for this inventory planning record. |
| subcategory | string | A subcategory for this inventory planning record. |
| roq type | non-empty string | The ROQ type should be one of the following :
calculated : The ROQ is calculated to optimize your order cost.
quantity : The ROQ is a fixed quantity defined by the user.
period of cover : The ROQ covers a given number of forecast periods.
|
| roq minimum quantity | number | This field should be populated if the ROQ type is equal to “quantity”.
It reprensents the number the ROQ should be equal to.
|
| roq minimum period of cover | number | This field should be populated if the ROQ type is equal to “period of cover”.
It reprensents the number of months of forecast the ROQ should be equal to.
|
| safety stock type | non-empty string | The safety stock type should be one of the following :
calculated : The safety stock is calculated based on a service level.
quantity : The safety stock is a fixed quantity defined by the user.
period of cover : The safety stock covers a given number of forecast periods.
|
| safety stock minimum period of cover | number | This field should be populated if the safety stock type is equal to “period of cover”.
It reprensents the number of months of forecast the safety stock should be equal to.
|
| safety stock minimum quantity | number | This field should be populated if the safety stock type is equal to “quantity”.
It reprensents the number the safety stock should be equal to.
|
| service level | number | This is the desired service level percentage for that buffer, E.g : 97.5 |
| lead time deviation | number | The lead time standard deviation considered when calculating the safety stock, can be left empty. |
| demand deviation | number | The demand statndard deviation considered when calculating the safety stock, can be left empty. |
| do not stock | boolean | Indicates whether this buffer should be stocked.
Possible values are :
“TRUE” : Default ROQ of 1 and safety stock of 0 will be used.
“FALSE” : ROQ and safety stock will be calculated.
|