Planned order releases(partial solution) Week: 1 2 3 4 5 6 Item D 250 640 2100 2
ID: 463391 • Letter: P
Question
Planned order releases(partial solution)
Week:
1
2
3
4
5
6
Item D
250
640
2100
240
400
0
Item E
580
880
600
0
0
0
Week:
1
2
3
4
5
6
Item D
250
640
2100
240
400
0
Item E
580
880
600
0
0
0
pevelop a complete netmaterial requirements plan for the production of following MPs and prepare the "exceptions" report. Master production schedule Week: 200 200 100 200 MPs for A 200 80 100 80 MPs for B ata Item Lead time Available Scheduled Receipts 750 400 in week th1 300 in week #2 500 600 in week #1 E 3 2000 in week #1 2000 in week #2 2000 Bill of Materials:Explanation / Answer
MPS Week 1 2 3 4 5 6 A 200 100 200 200 B 200 80 100 80 Data: Item LT AVAIABLE SCHEDULED RECIEPTS C 2 750 400 WEEK1, 300 WEEK 2 D 1 500 600 WEEK1 E 3 2000 2000 WEEK1, 2000 WEEK2 MRP ITEM A LT = 0 GR= 700 WEEK 1 2 3 4 5 6 GROSS REQUIREMENT 200 100 200 0 0 200 SCHEDULED RECIEPTS 0 0 0 0 0 0 PROJECTED ON HAND 0 0 0 0 0 0 NET REQUIREMENT 200 100 200 0 0 200 PLANNED RECEIPTS 200 100 200 0 0 200 PLANNED ORDER RELEASES 200 100 200 0 0 200 ITEM B LT = 0 GR= 460 WEEK 1 2 3 4 5 6 GROSS REQUIREMENT 0 200 80 100 80 0 SCHEDULED RECIEPTS 0 0 0 0 0 0 PROJECTED ON HAND 0 0 0 0 0 0 NET REQUIREMENT 0 200 80 100 80 0 PLANNED RECEIPTS 0 200 80 100 80 0 PLANNED ORDER RELEASES 0 200 80 100 80 0 ITEM C LT = 2 GR= 2100 WEEK 1 2 3 4 5 6 GROSS REQUIREMENT 600 300 600 0 0 600 (3*Planned Release A) SCHEDULED RECIEPTS 400 300 0 0 0 0 PROJECTED ON HAND 750 550 550 0 0 0 NET REQUIREMENT 0 0 50 0 0 600 PLANNED RECEIPTS 0 0 50 0 0 600 PLANNED ORDER RELEASES 50 0 0 600 0 0 ITEM D LT = 1 GR= 4730 WEEK 1 2 3 4 5 6 GROSS REQUIREMENT 550 800 640 2100 240 400 (3* PR C+ 2 * PR A+ 3* PR B) SCHEDULED RECIEPTS 600 0 0 0 0 0 PROJECTED ON HAND 500 550 0 0 0 0 NET REQUIREMENT 0 250 640 2100 240 400 PLANNED RECEIPTS 0 250 640 2100 240 400 PLANNED ORDER RELEASES 250 640 2100 240 400 0 ITEM E LT = 3 GR= 9820 WEEK 1 2 3 4 5 6 GROSS REQUIREMENT 1100 1780 4880 580 880 600 (3* PR A+ 2 * PR D+ 1* PR B) SCHEDULED RECIEPTS 2000 2000 0 0 0 0 PROJECTED ON HAND 2000 2900 3120 0 0 0 NET REQUIREMENT 0 0 1760 580 880 600 PLANNED RECEIPTS 0 0 1760 580 880 600 PLANNED ORDER RELEASES 580 880 600 0 0 0 Exception: Item E: 1760 units to be ordered prior to week 1 to be received in week 3