Each unit of A is composed of one unit of B, two units of C, and one unit of D.

Question

Each unit of A is composed of one unit of B, two units of C, and one unit of D. C is composed of two units of D and three units of E. Items A, C, D, and E have on-hand inventories of 20, 10, 20, and 10 units, respectively. Item B has a scheduled receipt of 5 units in Period 1, and C has a scheduled receipt of 50 units in Period 1. Lot-for-lot (L4L) is used for Items A and B. Item C requires a minimum lot size of 50 units. D and E are required to be purchased in multiples of 90 and 60, respectively. Lead times are one period for Items A, B, and C, and two periods for Items D and E. The gross requirements for A are 25 in Period 2, 35 in Period 5, and 40 in Period 8.

Find the planned order releases for all items. (Leave no cells blank - be certain to enter "0" wherever required.)

Period 1 2 3 4 5 6 7 8 Item A
OH = 20
LT = 1
SS = 0
Q = L4L 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 C
OH = 10
LT = 1
SS = 0
Q = 50 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Item D
OH = 20
LT = 2
SS = 0
Q = 90 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Item E
OH = 10
LT = 2
SS = 0
Q = 60 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases

Explanation / Answer

Solution :

A, LT - 1, Lot - L4L On Hand 1 2 3 4 5 6 7 8 Total Gross Requirements 0 25 0 0 35 0 0 40 100 Scheduled Receipts 0 0 0 0 0 0 0 0 Projected On Hand 20 20 0 0 0 0 0 0 0 Net requirements 0 5 0 0 35 0 0 40 Planned order receipts 0 5 0 0 35 0 0 40 Planned order releases 5 0 0 35 0 0 40 0 B, LT - 1, Lot - L4L On Hand 1 2 3 4 5 6 7 8 Total Gross Requirements 5 0 0 35 0 0 40 0 80 Scheduled Receipts 5 0 0 0 0 0 0 0 Projected On Hand 0 0 0 0 0 0 0 0 0 Net requirements 0 0 0 35 0 0 40 0 Planned order receipts 0 0 0 35 0 0 40 0 Planned order releases 0 0 35 0 0 40 0 0 C, LT - 1, Lot - MIN 50 On Hand 1 2 3 4 5 6 7 8 Total Gross Requirements 10 0 0 70 0 0 80 0 160 Scheduled Receipts 50 0 0 0 0 0 0 0 Projected On Hand 10 50 50 50 30 30 30 0 0 Net requirements 0 0 0 20 0 0 50 0 Planned order receipts 0 0 0 50 0 0 50 0 Planned order releases 0 0 50 0 0 50 0 0 D, LT - 2, Lot - 90 On Hand 1 2 3 4 5 6 7 8 Total Gross Requirements 5 0 100 35 0 100 40 0 280 Scheduled Receipts 0 0 0 0 0 0 0 0 Projected On Hand 20 15 15 5 60 60 50 10 10 Net requirements 0 0 85 30 0 40 0 0 Planned order receipts 0 0 90 90 0 90 0 0 Planned order releases 90 90 0 90 0 0 0 0 E, LT - 2, Lot - 60 On Hand 1 2 3 4 5 6 7 8 Total Gross Requirements 0 0 150 0 0 150 0 0 300 Scheduled Receipts 0 0 0 0 0 0 0 0 Projected On Hand 10 10 10 40 40 40 10 10 10 Net requirements 0 0 140 0 0 110 0 0 Planned order receipts 0 0 180 0 0 120 0 0 Planned order releases 180 0 0 120 0 0 0 0

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.