One unit of A is composed of two units of B and three units of C. Each B is comp

Question

One unit of A is composed of two units of B and three units of C. Each B is composed of one unit of F. C is made of one unit of D, one unit of E, and two units of F. Items A, B, C, and D have 20, 50, 30, and 25 units of on-hand inventory, respectively. Items A, B, and C use lot-for-lot (L4L) as their lot-sizing technique, while D, E, and F require multiples of 50, 100, and 90, respectively, to be purchased. B has scheduled receipts of 20 units in Period 1. No other scheduled receipts exist. Lead times are one period for Items A, B, and D, and two periods for Items C, E, and F. Gross requirements for A are 20 units in Period 1, 10 units in Period 2, 55 units in Period 6, and 50 units 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 = 50
LT = 1
SS = 0
Q = L4L Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Item C
OH = 30
LT = 2
SS = 0
Q = L4L Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Item D
OH = 25
LT = 1
SS = 0
Q = 50 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Item E
OH = 0
LT = 2
SS = 0
Q = 100 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Item F
OH = 0
LT = 2
SS = 0
Q = 90 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 20 10 0 0 0 55 0 50 135 Scheduled Receipts 0 0 0 0 0 0 0 0 Projected On Hand 20 0 0 0 0 0 0 0 0 Net requirements 0 10 0 0 0 55 0 50 Planned order receipts 0 10 0 0 0 55 0 50 Planned order releases 10 0 0 0 55 0 50 0 B, LT - 1, Lot - L4L On Hand 1 2 3 4 5 6 7 8 Total Gross Requirements 20 0 0 0 110 0 100 0 230 Scheduled Receipts 20 0 0 0 0 0 0 0 Projected On Hand 50 50 50 50 50 0 0 0 0 Net requirements 0 0 0 0 60 0 100 0 Planned order receipts 0 0 0 0 60 0 100 0 Planned order releases 0 0 0 60 0 100 0 0 C, LT - 2, Lot - L4L On Hand 1 2 3 4 5 6 7 8 Total Gross Requirements 30 0 0 0 165 0 150 0 345 Scheduled Receipts 0 0 0 0 0 0 0 0 Projected On Hand 30 0 0 0 0 0 0 0 0 Net requirements 0 0 0 0 165 0 150 0 Planned order receipts 0 0 0 0 165 0 150 0 Planned order releases 0 0 165 0 150 0 0 0 D, LT - 1, Lot - 50 On Hand 1 2 3 4 5 6 7 8 Total Gross Requirements 0 0 165 0 150 0 0 0 315 Scheduled Receipts 0 0 0 0 0 0 0 0 Projected On Hand 25 25 25 10 10 10 10 10 10 Net requirements 0 0 140 0 140 0 0 0 Planned order receipts 0 0 150 0 150 0 0 0 Planned order releases 0 150 0 150 0 0 0 0 E, LT - 2, Lot - 100 On Hand 1 2 3 4 5 6 7 8 Total Gross Requirements 0 0 165 0 150 0 0 0 315 Scheduled Receipts 0 0 0 0 0 0 0 0 Projected On Hand 0 0 0 35 35 85 85 85 85 Net requirements 0 0 165 0 115 0 0 0 Planned order receipts 0 0 200 0 200 0 0 0 Planned order releases 200 0 200 0 0 0 0 0 F, LT - 2, Lot - 90 On Hand 1 2 3 4 5 6 7 8 Total Gross Requirements 0 0 330 60 300 100 0 0 790 Scheduled Receipts 0 0 0 0 0 0 0 0 Projected On Hand 0 0 0 30 60 30 20 20 20 Net requirements 0 0 330 30 240 70 0 0 Planned order receipts 0 0 360 90 270 90 0 0 Planned order releases 360 90 270 90 0 0 0 0

Related Questions

Navigate

• Browse (All)
• Browse O
• Subjects

---

---

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