MRP Planning, Processing and Results: MRP Results Listing

Part number

Parts Master. Part number unique identifier. {PTMFILE.PTMPTNO char 18}

Description

Parts Master. Part description. {PTMFILE.PTMDESC char 30}

Stock UoM

Parts Master. Standard stock unit of measure. {PTMFILE.PTMSTUM char 6}

List

The list provides the entire MRP results for the part. Double-click to drill down to the selected order.

Total direct

The total direct demand listed.

Total dependant

The total dependant demand listed.

Total due

The total due from current amended orders.

Total MRP orders

The total recommended MRP order deliveries.

Final quantity

The predicted final quantity in stock for the part.

Final Date

The last date in the plan for this part.

Include Run Criteria

Check this option if you want the report to contain a listing of the MRP run criteria that produced the results.

Fuzzy Pegging

Will provide a demand list of assemblies that may be contributing to dependant demand for the selected part. It opens the MRP Fuzzy Pegging Analysis window.

Print List

To print a report of the listed items.

Part number

Part Number of the component or assembly for which a forecast action or demand has been identified by MRP.

NOTE: If you use the Ad Hoc Reports to produce your own results reports, bear in mind that a blank part number is used to identify that the record is unused for the current set of results.

Action date

The date on which there is direct demand, from one of the selected criteria, dependant demand, from the Bill of Materials requirements to manufacture the demand items to the lowest level, receipt from a current Purchase or Works Order, recommended change in timing of orders or MRP recommendations for orders and their delivery.

Part supply type

B = Buy component where recommended orders are Purchase Orders.
O = Outwork assemblies where recommended orders are Purchase Orders but that have constituent components that must be available before placing the order.
M = Make assemblies where orders are Work Orders and where all constituent components are required.
K = Kitted Works Orders that are committed in manufacture and where no components are needed. A cancelled Kitted Work Order does not release components.

NOTE: If you use the Ad Hoc Reports to produce your own results reports, you will find that the Part supply type is held in the data file as an integer number. 0 = Buy, 1 = Outwork assembly, 2 = Manufactured, 3 = Kitted Work Order. You can add a calculated field that interprets the number to a more meaningful B, O, M or K with the function pick(MRPMKFL,’B’,’O’,’M’,’K’).

Adjustment code

This is an action identifier that has the following meaning:

0 = No change to order, simply a prediction of inventory movement.

1 = Cancel Purchase or Work Order. Cancellation is recommended if future projected stock quantity does not fall below Re-order Level. The recommended quantity to cancel is shown as a negative MRP Order quantity and the balance to leave on order will show in the Order delivery quantity.

2 = Push Purchase or Work Order to a later receipt date. A Push recommendation is made if the order delivery can be delayed, without the projected stock quantity falling below Minimum Stock, beyond a date after the threshold days have been added to the current delivery date.

3 = Pull Purchase or Work Order for earlier receipt. A Pull recommendation is made if the order delivery is needed earlier than the current delivery date, due to the projected stock potentially falling below Minimum Stock.

4 = Shortage order recommendation. This is an MRP suggested order where there is less available calendar days than the part’s lead time between ordering and need for delivery.

5 = MRP recommended Purchase or Work Order. This is a normal MRP suggested order where the normal part lead time is available. MRP recommended order quantities are either the Order Quantity for the part or such greater quantity that will leave the projected quantity at the Re-order Level.

Start quantity

The predicted physical stock at the start of the Action Date.

WARNING: If you use the Ad Hoc Reports or a Custom Report to produce your own results reports, bear in mind that the Start Quantity is only appropriate if all the result records for a part are included and the sort order for the records is:
MRPPTNO = Part Number
MRPACDT = Action Date
MRPMKFL (Descending) = Part Supply Type
MRPOQTY (Descending) = MRP Order Quantity
MRPMODL (Descending) = MRP Order Delivery
MRPODEL (Descending) = Current Order Delivery
MRPREF = Reference

Dependant demand

Consumption quantity predicted due to dependant requirement to the lowest level (i.e. demand from a Bill of Material) for direct demand items.

Order delivery quantity

Delivery quantity from already prepared Purchase or Work Orders, if MRP recommends cancellation this value may be zero.

MRP Order quantity

MRP proposed order quantity. For cancelled orders, the quantity recommended to be cancelled from the order is shown as a negative value.

MRP Order delivery

Quantity of receipt from an MRP proposed order. This should always be the number of lead days ahead of the MRP Order quantity for normal order recommendations but will be less for shortage orders.

Reference

This field is automatically filled under the following circumstances:
“Pnnnnnn” = Purchase Order item from PO number “nnnnnn”.
“Rnnnnnn” = Request for Quotation item from RFQ number “nnnnnn”.
“Wnnnnnn” = Work Order (both kitted and un-kitted) from WO number “nnnnnn”.
“M” = MRP recommended order or order receipt where the part has no primary supplier.
“Mxxxxxx” = MRP recommended order or order receipt where the part has a primary supplier with Supplier Code “xxxxxx”.

Implemented

This flag (Yes/No) field is automatically set when Purchase or Work Orders are generated from the recommendations in one of the “MRP Results” functions. Once they have been marked as implemented, further listings of PO or WO recommendations will exclude them. This avoids duplications of orders.

• MRP Fuzzy Pegging Analysis
• Review MRP Results