In: Operations Management
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, 40, 60, 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 85, respectively, to be purchased. B has scheduled receipts of 30 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, 20 units in Period 2, 50 units in Period 6, and 40 units in Period 8.
Period | 1 |
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 = 40 LT = 1 SS = 0 Q = L4L |
Gross requirements | ||||||||||
Scheduled receipts | |||||||||||
Projected available balance | |||||||||||
Net requirements | |||||||||||
Planned order receipts | |||||||||||
Planned order releases | |||||||||||
Item C OH = 60 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 = 85 |
Gross requirements | ||||||||||
Scheduled receipts | |||||||||||
Projected available balance | |||||||||||
Net requirements | |||||||||||
Planned order receipts | |||||||||||
Planned order releases | |||||||||||
Hints
References
Item = A; OH = 20,LT=1,Q=L4L | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
Gross requirements | 20 | 20 | 0 | 0 | 0 | 50 | 0 | 40 |
Scheduled receipts | ||||||||
Projected available balance | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Net requirements | 20 | 0 | 0 | 0 | 50 | 0 | 40 | |
Planned order receipts | 20 | 0 | 0 | 0 | 50 | 0 | 40 | |
Planned order releases | 20 | 0 | 0 | 0 | 50 | 0 | 40 | |
Item = B; OH = 40,LT=1,Q=L4L | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
Gross requirements | 40 | 0 | 0 | 0 | 100 | 0 | 80 | 0 |
Scheduled receipts | 30 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Projected available balance | 30 | 30 | 30 | 30 | 0 | 0 | 0 | 0 |
Net requirements | 0 | 0 | 0 | 0 | 70 | 0 | 80 | 0 |
Planned order receipts | 0 | 0 | 0 | 0 | 70 | 0 | 80 | 0 |
Planned order releases | 0 | 0 | 0 | 70 | 0 | 80 | 0 | 0 |
Item = C; OH = 60,LT=2,Q=L4L | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
Gross requirements | 60 | 0 | 0 | 0 | 150 | 0 | 120 | 0 |
Scheduled receipts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Projected available balance | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Net requirements | 0 | 0 | 0 | 0 | 150 | 0 | 120 | 0 |
Planned order receipts | 0 | 0 | 0 | 0 | 150 | 0 | 120 | 0 |
Planned order releases | 0 | 0 | 150 | 0 | 120 | 0 | 0 | 0 |
Item = D; OH = 25,LT=1,Q=50 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
Gross requirements | 0 | 0 | 150 | 0 | 120 | 0 | 0 | 0 |
Scheduled receipts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Projected available balance | 25 | 25 | 25 | 25 | 5 | 5 | 5 | 5 |
Net requirements | 0 | 0 | 125 | 0 | 95 | 0 | 0 | 0 |
Planned order receipts | 0 | 0 | 150 | 0 | 100 | 0 | 0 | 0 |
Planned order releases | 0 | 150 | 0 | 100 | 0 | 0 | 0 | 0 |
Item = E; OH = 0,LT=2,Q=100 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
Gross requirements | 0 | 0 | 150 | 0 | 120 | 0 | 0 | 0 |
Scheduled receipts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Projected available balance | 0 | 0 | 50 | 50 | 30 | 30 | 30 | 30 |
Net requirements | 0 | 0 | 150 | 0 | 70 | 0 | 0 | 0 |
Planned order receipts | 0 | 0 | 200 | 0 | 100 | 0 | 0 | 0 |
Planned order releases | 200 | 0 | 100 | 0 | 0 | 0 | 0 | 0 |
Item = F; OH = 0,LT=2,Q=85 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
Gross requirements | 0 | 0 | 300 | 70 | 240 | 80 | 0 | 0 |
Scheduled receipts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Projected available balance | 0 | 0 | 40 | 55 | 70 | 75 | 75 | 75 |
Net requirements | 0 | 0 | 300 | 30 | 185 | 10 | 0 | 0 |
Planned order receipts | 0 | 0 | 340 | 85 | 255 | 85 | 0 | 0 |
Planned order releases | 340 | 85 | 255 | 85 | 0 | 0 | 0 | 0 |