MRP Planning Engine Availability Check

The “MRP Planning Engine Availability Check” tool supports the customer promise delivery date

determination in Customer Request for Quotation process by taking into account the projected stock

quantity compared to customer requested quantity at all BoM’s level.

The MRP Parameter attributes, the main master data involved in MRP Planning Engine run, are considered.

The lead time, the cumulative lead time along the overall BoM and the decoupled lead time for are

calculated also.

The critical path is shown to have an immediate overview where procurement issues can be faced.

The tool consists of two main sections:

·        BOM explosion

·        Availability Check Result

Two printouts are available also:

·        BoM Explosion report to provide an overview of all BoM structure with its main procurement attributes

·        Availability Check report to list all quantities figures related to a component’s replenishment

In detail, we have as follows:

BOM Explosion section

BOM is exploded till the final level and the requested quantity is calculated for all the components.

For each component, its main procurements attributes are provided:

·        Product Type, to distinguish between storable products and consumables and serviced

·        MRP parameter indicator to check whether the MRP parameter master data has been created

·        Make product, so its procurement is achieved internally by executing a production order

·        Buy product, so a purchase order has to be created for its procurement

·        Subcontracting product, so a subcontracting purchase order has to be created for its procurement

·        Reorder point replenishment model related to the MRP type Reorder Point

·        Lead Time calculated according the supply method

·        Cumulative lead Time taking into account the lead time of BoM’s components

·        Decoupled Lead Time taking into account the buffer stock due to a reorder point

·        Critical path indicator

The critical path for calculating the decoupled lead time is pointed out in red color.

Availability Check Result section

All components’ requirements are summarized, i.e. components in different BoM level are listed in only one

row with all its requirements summarized. The storable products are reported only.

For each item the following stock quantities are provided for the selected location (its children are taken into account also):

·        Requested Quantity based on BOM explosion

·        On hand Quantity

·        Available Quantity, i.e. the projected stock quantity

·        Free to Use Quantity, i.e. the on hand stock minus the reserved one

·        Incoming Quantity, i.e. all incoming goods movement are summarized

·        Outgoing Quantity, i.e. all issue goods movements are considered

·        Forecast Quantity, achieved as the “Free to Use” quantity minus requested quantity

The forecast report is available also for checking the projected stock over the time and to trigger a manual

replenishment also.

Component’s shortage is pointed out in red color, i.e. the forecast quantity is negative so the requested

production is not feasible and procurement has to be activated.

BOM Explosion Report

Availability Check Report