Question

i Data Table Table 2. INVENTORY RECORD DATA F G C Data Category Lot-sizing rule Lead time Safety stock Scheduled receipts Beginning inventory L4L 3 weeks 0 150 (week 2) 125 D FOQ = 800 3 weeks 0 300 (week 2) 0 Item E FOQ = 600 4 weeks 0 600 (week 1) 255 L4L 2 weeks 70 None 670 L4L 1 week 0 1,200 (week 1) 0 Print Done Done nd then click Check Answer. Clear All

Answer 1

Steps to create the MRP 1) Enter the gross requirement as per Master Planning Schedule (MPS). Gross requirement of components is calculated as per usage in parent item. 2) Enter Schedule Order Receipts (SOR), if there are any. 3) Project On hand is calculated by this formula = Previous period project on hand + Scheduled receipts + Planned order receipts - gross requirement 4) Net requirement = Gross requirement - Projected on hand 5) Planned Order Release (POR) is manually entered such that time phased planned order receipt is equal to net For example, if lead time is 1 period, and there is net requirement of 80 units in period 3, then there is a planned order release for 80 units in period 2, i.e. 1 period prior to the period in which requirement occurs. Planned Order Release quantity is as per the Lot size specified, i.e. LFL, or Fixed Order Quantity, or POQ or EOQ or in Multiples of a specified quantity. 6) If there is safety stock specified for an item, then safety stock quantity is added in Planned Order Release so that Project On Hand remains greater than or equal to safety stock as specified.

Item o 1 2 3 4 5 6 7 8 0 220 0 0 220 |С SR = 0 0 0 0 0 125 SS = 125 0 0 0 Gross Requirement 150(2) Scheduled Receipt Projected on Hand Net Requirement 3 Planned Order Receipt L4L Planned Order Release 220 150 55 0 0 220 0 0 55 0 0 0 220 0 0 165 165 0 0 220 0 220 0 0 L = 220 0 0 0 165 220 0 Q= 220 0 0 Item 0 1 2 3 4 5 6 7 00 0 0 330 330 0 0 330 0 0 0 0 SS= 0 0 330 300 0 30 0 110 110 D Gross Requirement SR = 300(2) Scheduled Receipt Projected on Hand Net Requirement L= 3 Planned Order Receipt Q = FOQ=800 Planned Order Release 110 0 0 30 0 440 360 0 0 0 0 580 220 800 0 800 0 0 0 800 o 800 0 0 0 Item 0 1 3 4 5 6 7 8 N 0 0 220 165 600 690 0 E Gross Requirement SR = 600(1) Scheduled Receipt SS = Projected on Hand Net Requirement L = 4 Planned Order Receipt Q = FOQ=600 Planned Order Release 440 0 250 0 255 0 0 250 0 0 0 220 0 30 0 0 440 0 190 410 600 0 0 190 0 0 190 0 0 570 30 600 0 0 0 0 600 0 600 0 0

Item 0 1 2 3 4 5 6 7 8 600 0 0 600 0 0 0 F SR = 0 0 0 0 0 0 0 0 none 70 SS= 670 70 70 Gross Requirement Scheduled Receipt Projected on Hand Net Requirement Planned Order Receipt Planned Order Release 70 0 0 70 0 70 0 0 70 530 600 70 0 70 0 0 0 2 0 0 0 0 L = Q= 0 0 L4L 0 600 0 0 0 0 1 2 3 4 5 6 7 00 1200 0 0 1200 0 0 0 0 1200 0 0 0 0 0 0 0 Item G Gross Requirement SR = 1200(1) Scheduled Receipt Projected on Hand Net Requirement L = 1 Planned Order Receipt Q= L4L Planned Order Release SS = 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1200 1200 0 0 0 0 0 0 0 0 1200 0 0 0 0