Question

Problem 14.9 The demand for subassembly S is 120 units in week 7, Each unit of S requires 2 units of T and 1 unit of U. Each unit of T requires 1 unit of V, 1 unit of W, and 1 unit of X. Finally, each unit of U requires 2 units of Y and 2 units of Z One firm manufactures all items. It takes 2 weeks to make S. 1 week to make T, 2 weeks to make U, 2 weeks to make V, 3 weeks to make W, 1 week to make X, 2 weeks to make Y, and 1 week to make Z. Click the icon to view the product structure and the time-phased product structure Click the icon to view the on-hand inventory Suppose that in addition to 120 units of S, there is also a demand for 20 units of U, which is a component of S. The 20 units of U are needed for maintenance purposes. These units are needed in week 6. Modify the net material requirements plan to reflect this change. Construct a new net material requirements plan (enter your responses as whole numbers) Week Item Lead Time 1 2345 6 7(weeks) 120 ross req n hand et req 100 2 100 rder receipt rder release 100 200 ross rea n hand 180 et req 180 rder receipt 180 rder release 100 20 ross rea n hand 400 60 20 et req 2 rder receipt 60 20 60 20 rder release ross rea n hand 150 et req 2 rder receipt 150 150 rder release ross req n hand 25 rder receipt 150 150 rder release 180 ross req n hand 25 155 et req 3 155 rder receipt 155 rder release 180 ross req n hand et req 150 150 rder receipt rder release 150 120 40 ross req n hand 120 0 et req 0 40 2 rder receipt 0 40 rder release 0 40 120 40 ross req n hand 40 et req 80 40 rder receipt 80 40 rder release 80 40

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) Project On hand is calculated by this formula Previous period project on hand + Scheduled receipts+ Planned order receipts - gross requirement 3) Net requirement Gross requirement - Projected on hand 4) Planned Order Relese (POR) is manually entered such that time phased planned order receipt is equal to net requirement. MRP SCHEDULE Item Beg. Inv.1 Gross re 120 On hand 20 20 20 20 20 20 20 Net Req 100 L=| 2 |Order Receipt 100 Order Release 100 Gross re 200 On hand 20 20 Net Req 180 L=| | |Order Receipt 180 Order Release 180

100 20 Gross re 40 40 On hand 20 Net Req 20 L2 Order Receipt 20 Order Release 180 Gross re 30 30 30 On hand 150 Net Req 150 L2 Order Receipt 150 Order Release 180 Gross re 25 25 25 25 25 On hand 155 Net Req 155 L=| 3 |Order Receipt 155 Order Release 180 Gross re 30 On hand 150 Net Req 150 L1 Order Receipt 150 Order Release

Gross re 180 On hand 30 Net Req 150 L=| | |Order Receipt 150 Order Release 150 Gross re 120 120 120120 On hand 120 Net Req L=| 2 |Order Receipt 40 Order Release Gross re 120 40 On hand 40 40 40 40 Net Req 40 L1 Order Receipt 40 Order Release