I need someone to help me with part K specially... I did the problem but I\'m no
ID: 460117 • Letter: I
Question
I need someone to help me with part K specially... I did the problem but I'm not sure about that last part... Please
Master Schedule for End Item D One hundred units of end itemD are needed at the beginning of Week 5. Three cases (30 units per case) of K have been ordered and one case is scheduled to arrive in Week 1, one in week 2, and one in week 5. Note: K must be ordered by the case, and B must be produced in multiples of 140 units. There are 65 units of B and 20 units of K now on hand. Lead times are two weeks for both E and B, and only one week for K. Create a master schedule for ONLY End Item D. B (4) K (5) MRP Master Schedule Week Number Quantity LOO Gross requirements Scheduled receipts Quantity = Projected on hand LT = 2wxces Net requirements Lot Size = Planned-order receipts On hand = 0 Planned-order releases BE Gross requirements a Scheduled receipts Quantity = Projected on hand LT Net requirements Lot Size Planned-order receipts On hand =o 5 Planned-order releases = Gross requirements Scheduled receipts Quantity = Projected on hand LT -McL Net requirements Lot Size = Planned-order receipts On hand = IO Planned-order releasesExplanation / Answer
MPS for Item D
Week Number
1
2
3
4
5
6
Quantity
100
Item
D
1
2
3
4
5
6
Quantity
Gross Req.
100
LT
2
Scheduled receipts
0
Lot Size
L4L
Projected-on-hand
0
On hand
0
Net Requirement
100
Planned order Receipts
100
Planned order releases
100
Item
B
1
2
3
4
5
6
Quantity
4 per D
Gross Req.
400
LT
2
Scheduled receipts
Lot Size
140
Projected-on-hand
65
65
65
On hand
65
Net Requirement
335
Planned order Receipts
140*3=420
Planned order releases
420
Item
K
1
2
3
4
5
6
Quantity
5 per D
Gross Req.
500
LT
1
Scheduled receipts
30
30
30
Lot Size
30
Projected-on-hand
20
50
80
On hand
20
Net Requirement
420
Planned order Receipts
30*14 = 420
Planned order releases
420
Note: Order 14 cases of Item K in week 2
MPS for Item D
Week Number
1
2
3
4
5
6
Quantity
100
Item
D
1
2
3
4
5
6
Quantity
Gross Req.
100
LT
2
Scheduled receipts
0
Lot Size
L4L
Projected-on-hand
0
On hand
0
Net Requirement
100
Planned order Receipts
100
Planned order releases
100
Item
B
1
2
3
4
5
6
Quantity
4 per D
Gross Req.
400
LT
2
Scheduled receipts
Lot Size
140
Projected-on-hand
65
65
65
On hand
65
Net Requirement
335
Planned order Receipts
140*3=420
Planned order releases
420
Item
K
1
2
3
4
5
6
Quantity
5 per D
Gross Req.
500
LT
1
Scheduled receipts
30
30
30
Lot Size
30
Projected-on-hand
20
50
80
On hand
20
Net Requirement
420
Planned order Receipts
30*14 = 420
Planned order releases
420
Note: Order 14 cases of Item K in week 2