Material Requirements Planning

State the timing and quantities of the recommended work order releases and purchase order releases to Warren. Describe and discuss MRP

On mrp talk about the planned order release only

Ex If they release these work orders and purchase orders,they will be able to achieve the dollar profit we promised in the linear programming section

The On Order for Part E should be 2,000 in Week 1 not week 2. The solution shows 2000 units of E being received in week 2.

on the part e should be 2000 in week 1 not week 2 the solution shows 2000 units of e being received in week 2

Precision Auto Clone Section 4 - Material Requirements Planning Bill of Material for P-10 Bill of Material for P-20 Level Part Number Quantity Level Part Number Quantity P-10 P-20 1 P-50 1 P-SO 2 2 P-30 2 P. 40 2 2 P-70 1 P-30 6 1 P-40 0 0 Inventory Status Order Policy Part Number P-10 P-20 P-30 P-40 P-50 P-70 P-SO Lead Time (weeks) 0 0 1 1 0 1 0 Quantity On Hand 0 0 0 1.300 0 2.300 0 a Quantity On Order 0 0 3,000 - May Week 4 0 0 0 0 Lot Size Method Lot For Lot Lot-For-Lot Economic Order Quantity (3,000+) Fixed Period Quantity (3 weeks) Lot-For-Lot Fixed Order Quantity(500) Lot-For-Lot . Precision Auto Clone Section 4 - Material Requirements Planning Bill of Material for P-10 Bill of Material for P-20 Level Part Number Quantity Level Part Number Quantity P-10 P-20 1 P-50 1 P-SO 2 2 P-30 2 P. 40 2 2 P-70 1 P-30 6 1 P-40 0 0 Inventory Status Order Policy Part Number P-10 P-20 P-30 P-40 P-50 P-70 P-SO Lead Time (weeks) 0 0 1 1 0 1 0 Quantity On Hand 0 0 0 1.300 0 2.300 0 a Quantity On Order 0 0 3,000 - May Week 4 0 0 0 0 Lot Size Method Lot For Lot Lot-For-Lot Economic Order Quantity (3,000+) Fixed Period Quantity (3 weeks) Lot-For-Lot Fixed Order Quantity(500) Lot-For-Lot . Precision Auto Clone. Material Requirements Planning May Week 4 June Week 1 500 June Week 2 June Week 3 June Week 4 500 500 500 Part P-10 LFL Gross Requirements (From MPS) Scheduled Receipts Projected on Hand Net Requirements Planned Order Receipts Planned Order Releases 500 500 500 500 500 500 500 500 500 500 500 500 May Week 4 June Week 1 100 June Week 2 100 June Week 3 100 June Week 4 100 Part. P-20 LFL Gross Requirements (From MPS) Scheduled Receipts Projected on Hand Net Requirements Planned Order Receipts Planned Order Releases 100 100 100 100 100 100 100 100 100 100 100 100 May Week 4 June Week 1 1.000 June Week 2 1.000 June Week 3 June Week 4 1.000 1.000 Part P-50 LFL Gross Requirements (From P-10 X 2) Scheduled Receipts Projected on Hand Net Requirements Planned Order Receipts Planned Order Releases 1.000 1 000 1,000 1000 1.000 1.000 1.000 1.000 1,000 1,000 1,000 1000 May Week 4 June Week 1 200 June Week 2 200 June Week 3 June Week 4 200 200 Part: P-80 LFL Gross Requirements (From P-20 X 2) Scheduled Receipts Projected on Hand Net Requirements Planned Order Receipts Planned Order Releases 200 200 200 200 200 200 200 200 200 200 200 200 June Week 1 500 400 900 June Week 2 500 400 900 June Week 3 June Week 4 500 500 400 400 900 900 Part. P-40 FPO(3 Weeks) May Week 4 From P-10 X 1 From P-80 X 2 Gross Requirements Scheduled Receipts Projected on Hand 1300 1300 Net Requirements Planned Order Receipts Planned Order Releases 400 900 0 1800 500 2,300 2,300 June Week 1 4,000 600 4.600 June Week 2 4,000 600 4600 June Week 3 June Week 4 4.000 4000 600 600 4.600 4,600 Part P-30 EOQ (3.000+) May Week 4 From P-50 X4 From P-20 X 6 Gross Requirements Scheduled Receipts 3.000 Projected on Hand Net Requirements Planned Order Receipts Planned Order Releases 3,000 1.400 1,600 3.000 3 200 3,200 3.200 4,600 4600 4,600 4,600 4,600 4,600 June Week 1 2000 June Week 2 2.000 June Week 3 June Week 4 2,000 2.000 300 Part: P.70 FOQ (500) May Week 4 Gross Requirements (From P-50 X 2) Scheduled Receipts Projected on Hand 2,300 2.300 Net Requirements Planned Order Receipts Planned Order Releases 300 1.700 2000 2,000 300 1,700 2,000 2.000 300 1,700 2,000 2.000 Simula ON Task Description A Requirements Definition B Obtain Vendor Proposals Select Vendor Design and Layout the new Faciliti E Remodel Plant F Order and Receive Manufacturing Equipment G Install Manufacturing Equipment Order and Receive Computer Hardware I Customize Manufacturing Software Determine and Document Operational Sequence K Load Manufacturing Data Base Develop and Test Training Simulator Train Staff N Switchover Plant Immediate Time Predecessors Weeks) Cost 3 20.000 A 4 0 B 2 5,000 C 4 50.000 D 10 400,000 D 8 2.100.000 EF 3 40,000 C 2 500.000 400,000 12 100.000 H.LU 2 30,000 K 3 90,000 1 220,000 GM 1 145,000 4.100.000 00 MHZ Tec A Earlin La La Scan This Puth 1 C B 10 13 12 16 1 M D E H 12 0 . c 12 1 X 11 19 11 10 90 22 CV 10 The available budget is 54,300,000 to complete this project. Certain tasks be expedited at aditional con Task can be cut by 1 week at madal cost of $50,000. Task I can be reduced by 1 week at a cost of $80,000. Task F can be cut by week for an additional 540,000. Task can be cut by 2 wees by working tertime at an additional cost of $130,000. Task can be cut by 1 week cost of $90,000 and the optimal project plan that will result completing the project at the chest possible time while remaining within the budget. Indicate the corresponding length of the project and identify the tasks at shald he expedited. Task Espediting Cost Per Week E S50 000 150.000 550.000 150.000 F $40,0001 - 510000 M $120.000 250.000 I 59000071590.000 Critical path Expedietas Mandi Precision Auto Clone Section 4 - Material Requirements Planning Bill of Material for P-10 Bill of Material for P-20 Level Part Number Quantity Level Part Number Quantity P-10 P-20 1 P-50 1 P-SO 2 2 P-30 2 P. 40 2 2 P-70 1 P-30 6 1 P-40 0 0 Inventory Status Order Policy Part Number P-10 P-20 P-30 P-40 P-50 P-70 P-SO Lead Time (weeks) 0 0 1 1 0 1 0 Quantity On Hand 0 0 0 1.300 0 2.300 0 a Quantity On Order 0 0 3,000 - May Week 4 0 0 0 0 Lot Size Method Lot For Lot Lot-For-Lot Economic Order Quantity (3,000+) Fixed Period Quantity (3 weeks) Lot-For-Lot Fixed Order Quantity(500) Lot-For-Lot . Precision Auto Clone Section 4 - Material Requirements Planning Bill of Material for P-10 Bill of Material for P-20 Level Part Number Quantity Level Part Number Quantity P-10 P-20 1 P-50 1 P-SO 2 2 P-30 2 P. 40 2 2 P-70 1 P-30 6 1 P-40 0 0 Inventory Status Order Policy Part Number P-10 P-20 P-30 P-40 P-50 P-70 P-SO Lead Time (weeks) 0 0 1 1 0 1 0 Quantity On Hand 0 0 0 1.300 0 2.300 0 a Quantity On Order 0 0 3,000 - May Week 4 0 0 0 0 Lot Size Method Lot For Lot Lot-For-Lot Economic Order Quantity (3,000+) Fixed Period Quantity (3 weeks) Lot-For-Lot Fixed Order Quantity(500) Lot-For-Lot . Precision Auto Clone. Material Requirements Planning May Week 4 June Week 1 500 June Week 2 June Week 3 June Week 4 500 500 500 Part P-10 LFL Gross Requirements (From MPS) Scheduled Receipts Projected on Hand Net Requirements Planned Order Receipts Planned Order Releases 500 500 500 500 500 500 500 500 500 500 500 500 May Week 4 June Week 1 100 June Week 2 100 June Week 3 100 June Week 4 100 Part. P-20 LFL Gross Requirements (From MPS) Scheduled Receipts Projected on Hand Net Requirements Planned Order Receipts Planned Order Releases 100 100 100 100 100 100 100 100 100 100 100 100 May Week 4 June Week 1 1.000 June Week 2 1.000 June Week 3 June Week 4 1.000 1.000 Part P-50 LFL Gross Requirements (From P-10 X 2) Scheduled Receipts Projected on Hand Net Requirements Planned Order Receipts Planned Order Releases 1.000 1 000 1,000 1000 1.000 1.000 1.000 1.000 1,000 1,000 1,000 1000 May Week 4 June Week 1 200 June Week 2 200 June Week 3 June Week 4 200 200 Part: P-80 LFL Gross Requirements (From P-20 X 2) Scheduled Receipts Projected on Hand Net Requirements Planned Order Receipts Planned Order Releases 200 200 200 200 200 200 200 200 200 200 200 200 June Week 1 500 400 900 June Week 2 500 400 900 June Week 3 June Week 4 500 500 400 400 900 900 Part. P-40 FPO(3 Weeks) May Week 4 From P-10 X 1 From P-80 X 2 Gross Requirements Scheduled Receipts Projected on Hand 1300 1300 Net Requirements Planned Order Receipts Planned Order Releases 400 900 0 1800 500 2,300 2,300 June Week 1 4,000 600 4.600 June Week 2 4,000 600 4600 June Week 3 June Week 4 4.000 4000 600 600 4.600 4,600 Part P-30 EOQ (3.000+) May Week 4 From P-50 X4 From P-20 X 6 Gross Requirements Scheduled Receipts 3.000 Projected on Hand Net Requirements Planned Order Receipts Planned Order Releases 3,000 1.400 1,600 3.000 3 200 3,200 3.200 4,600 4600 4,600 4,600 4,600 4,600 June Week 1 2000 June Week 2 2.000 June Week 3 June Week 4 2,000 2.000 300 Part: P.70 FOQ (500) May Week 4 Gross Requirements (From P-50 X 2) Scheduled Receipts Projected on Hand 2,300 2.300 Net Requirements Planned Order Receipts Planned Order Releases 300 1.700 2000 2,000 300 1,700 2,000 2.000 300 1,700 2,000 2.000 Simula ON Task Description A Requirements Definition B Obtain Vendor Proposals Select Vendor Design and Layout the new Faciliti E Remodel Plant F Order and Receive Manufacturing Equipment G Install Manufacturing Equipment Order and Receive Computer Hardware I Customize Manufacturing Software Determine and Document Operational Sequence K Load Manufacturing Data Base Develop and Test Training Simulator Train Staff N Switchover Plant Immediate Time Predecessors Weeks) Cost 3 20.000 A 4 0 B 2 5,000 C 4 50.000 D 10 400,000 D 8 2.100.000 EF 3 40,000 C 2 500.000 400,000 12 100.000 H.LU 2 30,000 K 3 90,000 1 220,000 GM 1 145,000 4.100.000 00 MHZ Tec A Earlin La La Scan This Puth 1 C B 10 13 12 16 1 M D E H 12 0 . c 12 1 X 11 19 11 10 90 22 CV 10 The available budget is 54,300,000 to complete this project. Certain tasks be expedited at aditional con Task can be cut by 1 week at madal cost of $50,000. Task I can be reduced by 1 week at a cost of $80,000. Task F can be cut by week for an additional 540,000. Task can be cut by 2 wees by working tertime at an additional cost of $130,000. Task can be cut by 1 week cost of $90,000 and the optimal project plan that will result completing the project at the chest possible time while remaining within the budget. Indicate the corresponding length of the project and identify the tasks at shald he expedited. Task Espediting Cost Per Week E S50 000 150.000 550.000 150.000 F $40,0001 - 510000 M $120.000 250.000 I 59000071590.000 Critical path Expedietas Mandi