Question

Problem 9 Assume that Product Z is made of two units of A and three units of B. A is made of hree units of C and four of D. D is made of two units of E Lead times for purchase or fabrication of each unit to final assembly are Z takes wo weeks: A, B. C and D take one week each; and E takes three weeks Fifty five units of Product Z are required in Period 10.(Assume that there is b. Develop an MRP planning schedule showing gross and net requirements and order release and oder recept dates. Mave no cells blank .becertain to erter O wherever required.)

Answer 1

Steps to create the MRP table. 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 requirement 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 Projedt On Hand remains greater than or equal to safety stock as specified.

MRP TABLE Item Beg. Inv.1 10 Gross Requirement Scheduled Receipt Proiected on Hand Net Requirement Planned Order Receipt Planned Order Release SOR ss = L4L Item Beg. Inv.1 10 Gross Requirement Scheduled Receipt Proiected on Hand Net Requirement Planned Order Receipt Planned Order Release 110 SOR 110 110 L4L 110 Item Beg. Inv.1 10 165 Gross Requirement Scheduled Receipt Proiected on Hand Net Requirement Planned Order Receipt Planned Order Release SOR 165 165 L4L 165 Item Beg. Inv.1 10 Gross Requirement Scheduled Receipt Proiected on Hand Net Requirement Planned Order Receipt Planned Order Release 330 SOR ss = 330 330 L4L 330 Item Beg. Inv.1 10 Gross Requirement Scheduled Receipt Proiected on Hand Net Requirement Planned Order Receipt Planned Order Release 440 SOR ss = L4L 440 Item Beg. Inv.1 10 Gross Requirement Scheduled Receipt Proiected on Hand Net Requirement Planned Order Receipt Planned Order Release 880 SOR = ss = 880 3 880 L4L 880