Problem 3: MRP Based on the BOM tree below and associated table of information f
ID: 421286 • Letter: P
Question
Problem 3: MRP Based on the BOM tree below and associated table of information from the ERP database, compute the MRP [PN 1000, 2000, 3003, and 3004 only.] based on a requirement for 100 units of PN 1000 in week 10. No other products share the same pert numbers and there are no requirements prior to week 10. There are no scheduled receipts during this period. There are no tetbook definition of On Hand Inventory and Safety Stock. Order policy is LOT FOR LOT on all PN. 20 points allocations. NOTE: Use the PN 1000 PN Safety Stock On Hand 20 70 3001 003 PN 2000 3001 PN 3000 120 PN 3003 PN 3004 Numbers in parenthesis indicate QTY required per parent unitExplanation / Answer
Problem 3 : MRP
MPS for End-Product PN 1000:
Week number
0
1
2
3
4
5
6
7
8
9
10
Quantity
0
0
0
0
0
0
0
0
0
0
100
Item PN 1000
OH =25
LT=1
SS=0
Q=LFL
Gross reqmts.
0
0
0
0
0
0
0
0
0
0
100
Scheduled receipts
0
0
0
0
0
0
0
0
0
0
0
Projected on hand
25
25
25
25
25
25
25
25
25
25
25
Net reqmts.
0
0
0
0
0
0
0
0
0
0
75
Planned-order receipts
0
0
0
0
0
0
0
0
0
0
75
Planned-order releases
0
0
0
0
0
0
0
0
0
75
0
Item PN 2000
OH =90
LT=2
SS=40
Q=LFL
Gross reqmts.
0
0
0
0
0
0
0
0
0
300
0
Scheduled receipts
0
0
0
0
0
0
0
0
0
0
0
Projected on hand
90
90
90
90
90
90
90
90
90
90
40
Net reqmts.
0
0
0
0
0
0
0
0
0
210
0
Planned-order receipts
0
0
0
0
0
0
0
0
0
250
0
Planned-order releases
0
0
0
0
0
0
0
250
0
0
0
Item PN 3003
OH =120
LT=1
SS=20
Q=LFL
Gross reqmts.
0
0
0
0
0
0
0
500
0
0
0
Scheduled receipts
0
0
0
0
0
0
0
0
0
0
0
Projected on hand
120
120
120
120
120
120
120
120
20
20
20
Net reqmts.
0
0
0
0
0
0
0
380
0
0
0
Planned-order receipts
0
0
0
0
0
0
0
400
0
0
0
Planned-order releases
0
0
0
0
0
0
400
0
0
0
0
Item PN 3004
OH =580
LT=3
SS=30
Q=LFL
Gross reqmts.
0
0
0
0
0
0
0
750
0
0
0
Scheduled receipts
0
0
0
0
0
0
0
0
0
0
0
Projected on hand
580
580
580
580
580
580
580
580
30
30
30
Net reqmts.
0
0
0
0
0
0
0
170
0
0
0
Planned-order receipts
0
0
0
0
0
0
0
200
0
0
0
Planned-order releases
0
0
0
0
200
0
0
0
0
0
0
Formula:
Net requirements = Gross requirements – On hand inventory – Scheduled receipts.
Week number
0
1
2
3
4
5
6
7
8
9
10
Quantity
0
0
0
0
0
0
0
0
0
0
100
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.