One unit of A is made of three units of B, one unit of C, and two units of D. B
ID: 354999 • Letter: O
Question
One unit of A is made of three units of B, one unit of C, and two units of D. B is composed of two units of E and one unit of D. C is made of one unit of B and two units of E. E is made of one unit of F.
Items B, C, E, and F have one-week lead times; A and D have lead times of two weeks.
Assume that lot-for-lot (L4L) lot sizing is used for Items A, B, and F; lots of size 45, 45, and 200 are used for Items C, D, and E, respectively. Items C, E, and F have on-hand (beginning) inventories of 8, 50, and 100, respectively; all other items have zero beginning inventory. We are scheduled to receive 10 units of A in Week 2, 40 units of E in Week 1, and also 50 units of F in Week 1. There are no other scheduled receipts. If 28 units of A are required in Week 8, use the low-level-coded bill of materials to find the necessary planned order releases for all components.
Develop an MRP planning schedule showing gross and net requirements and order release and order receipt dates. (Leave no cells blank - be certain to enter "0" wherever required.)
References
WorksheetDifficulty: 3 Challenge
Period 1 2 3 4 5 6 7 8 Item AOH = 0
LT = 2
SS = 0
Q = L4L Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Item C
OH = 8
LT = 1
SS = 0
Q = 45 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Item B
OH = 0
LT = 1
SS = 0
Q = L4L Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Item D
OH = 0
LT = 2
SS = 0
Q = 45 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Item E
OH = 50
LT = 1
SS = 0
Q = 200 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Item F
OH = 100
LT = 1
SS = 0
Q = L4L Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases
Explanation / Answer
Solution :
A, LT - 2, Lot - L4L On Hand 1 2 3 4 5 6 7 8 Total Gross Requirements 0 0 0 0 0 0 0 28 28 Scheduled Receipts 0 10 0 0 0 0 0 0 Projected On Hand 0 0 10 10 10 10 10 10 0 Net requirements 0 0 0 0 0 0 0 18 Planned order receipts 0 0 0 0 0 0 0 18 Planned order releases 0 0 0 0 0 18 0 0 C, LT - 1, Lot - 45 On Hand 1 2 3 4 5 6 7 8 Total Gross Requirements 0 0 0 0 0 18 0 0 18 Scheduled Receipts 0 0 0 0 0 0 0 0 Projected On Hand 8 8 8 8 8 8 35 35 35 Net requirements 0 0 0 0 0 10 0 0 Planned order receipts 0 0 0 0 0 45 0 0 Planned order releases 0 0 0 0 45 0 0 0 B, LT - 1, Lot - L4L On Hand 1 2 3 4 5 6 7 8 Total Gross Requirements 0 0 0 0 45 54 0 0 99 Scheduled Receipts 0 0 0 0 0 0 0 0 Projected On Hand 0 0 0 0 0 0 0 0 0 Net requirements 0 0 0 0 45 54 0 0 Planned order receipts 0 0 0 0 45 54 0 0 Planned order releases 0 0 0 45 54 0 0 0 D, LT - 2, Lot - 45 On Hand 1 2 3 4 5 6 7 8 Total Gross Requirements 0 0 0 45 54 36 0 0 135 Scheduled Receipts 0 0 0 0 0 0 0 0 Projected On Hand 0 0 0 0 0 36 0 0 0 Net requirements 0 0 0 45 54 0 0 0 Planned order receipts 0 0 0 45 90 0 0 0 Planned order releases 0 45 90 0 0 0 0 0 E, LT - 1, Lot - 200 On Hand 1 2 3 4 5 6 7 8 Total Gross Requirements 0 0 0 90 198 0 0 0 288 Scheduled Receipts 40 0 0 0 0 0 0 0 Projected On Hand 50 90 90 90 0 2 2 2 2 Net requirements 0 0 0 0 198 0 0 0 Planned order receipts 0 0 0 0 200 0 0 0 Planned order releases 0 0 0 200 0 0 0 0 F, LT - 1, Lot - L4L On Hand 1 2 3 4 5 6 7 8 Total Gross Requirements 0 0 0 200 0 0 0 0 200 Scheduled Receipts 50 0 0 0 0 0 0 0 Projected On Hand 100 150 150 150 0 0 0 0 0 Net requirements 0 0 0 50 0 0 0 0 Planned order receipts 0 0 0 50 0 0 0 0 Planned order releases 0 0 50 0 0 0 0 0Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.