We are going live shortly. Can i upload last four years material consumption statistics in the sytem?. Please explain how to upload the same.
Syed Hussain replied
For automatic, these values are estimated by SAP as a function of the forecast (coming from historical data), so the base-quantities for the calculation of the reorder are not fixed but dynamic.
If available stock falls below the reorder point, then an entry is made in the MRP file indicating that the material is to be included in the next planning run. Then during the next planning run a procurement proposal is created.
The reorder point stock level are automatically determined by the forecast program.
Reorder point planning
In reorder point planning, SAP checks whether the available stocks are below the reorder point that has been set for the material. If they are, SAP will create procurement proposal.
We can determine the reorder point manually (u201CVB-Manual reorder point planningu201D MRP Type in standard SAP R/3) or, it can also be calculated automatically using the material forecast (u201CVM-Automatic reorder point planningu201D MRP Type in standard SAP R/3).
The reorder point should cover the average material requirement/consumption expected during the replenishment lead time (procurement processing time + planned delivery time + GR processing time). Besides the average consumption, we also should consider safety stock. The safety stock exists to cover both excess material consumption within the replenishment lead time and any additional requirements that may occur due to delivery delays. Therefore, the safety stock is included in the reorder level.
The following values are important for defining the safety stock:
Past consumption values (historical data) or future requirements
Vendor/production delivery timelines
Service level to be achieved
Forecast error, that is, the deviation from the expected requirements
In standard SAP R/3 system, besides u201CVB u2013 Manual Reorder Pointu201D and u201CVM u2013 Automatic Reorder Pointu201D MRP Type, there are also other MRP Types that have reorder point as its basis to calculate requirement with additional procedure which count external requirement (sales order and manual reservation) as a requirement. The MRP Type are: u201CV1-Manual reorder point with external requirementsu201D and u201CV2-Automatic reorder point with external requirementsu201D.