please help answer the following Q-3 One unit of A is made of three units of B,
ID: 328722 • Letter: P
Question
please help answer the following
Q-3 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 50, 50, and 200 are used for Items C, D, and E, respectively. Items C, E, and F have on hand (beginning) inventories of 10, 50, and 150, respectively; all other items have zero beginning inventory. We are scheduled to receive 10 units of A in Week 2, 50 units of E in Week 1, and also 50 units of F in Week 1. There are no other scheduled receipts. If 30 units of A are required in Week 8, use the low-level-coded bill- of-materials (product structure tree) and MRP table to find the necessary planned order releases for all components. 30 points Period 4 7 Item ?? LT: Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Q: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 30 30 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 20 Planned order receipts 0 0 0 0 0 0 0 20 Planned order releases 0 0 0 0 0 20 0 0 C, LT - 1, Lot - 50 On Hand 1 2 3 4 5 6 7 8 Total Gross Requirements 0 0 0 0 0 20 0 0 20 Scheduled Receipts 0 0 0 0 0 0 0 0 Projected On Hand 10 10 10 10 10 10 40 40 40 Net requirements 0 0 0 0 0 10 0 0 Planned order receipts 0 0 0 0 0 50 0 0 Planned order releases 0 0 0 0 50 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 50 60 0 0 110 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 50 60 0 0 Planned order receipts 0 0 0 0 50 60 0 0 Planned order releases 0 0 0 50 60 0 0 0 D, LT - 2, Lot - 50 On Hand 1 2 3 4 5 6 7 8 Total Gross Requirements 0 0 0 50 60 40 0 0 150 Scheduled Receipts 0 0 0 0 0 0 0 0 Projected On Hand 0 0 0 0 0 40 0 0 0 Net requirements 0 0 0 50 60 0 0 0 Planned order receipts 0 0 0 50 100 0 0 0 Planned order releases 0 50 100 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 100 220 0 0 0 320 Scheduled Receipts 50 0 0 0 0 0 0 0 Projected On Hand 50 100 100 100 0 180 180 180 180 Net requirements 0 0 0 0 220 0 0 0 Planned order receipts 0 0 0 0 400 0 0 0 Planned order releases 0 0 0 400 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 400 0 0 0 0 400 Scheduled Receipts 50 0 0 0 0 0 0 0 Projected On Hand 150 200 200 200 0 0 0 0 0 Net requirements 0 0 0 200 0 0 0 0 Planned order receipts 0 0 0 200 0 0 0 0 Planned order releases 0 0 200 0 0 0 0 0Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.