Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Problem 21-16 (Algo) One unit of A is composed of two units of B and three units of C. Each B is composed of
Problem 21-16 (Algo) 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 15, 40, 36, and 25 units of on-hand inventory. Items A, B, and C use lot-for-lot (L4L) as their lot-sizing technique, while D, E, and F require multiples of 62, 100, and 90, respectively, to be purchased. B has scheduled receipts of 15 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 15 units in Period 1, 12 units in Period 2, 50 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 56 7 8 Item A OH = 15 |LT = 1 SS=0 Q = L4L Item B OH = 40 LT=1 |SS=0 Q = L4L Item C OH 36 LT=2 |SS=0 Q = L4L Item D OH = 25 LT=1 SS=0 Q = 62 Item E OH = 0 LT=2 SS=0 Q = 100 Item F OH = 0 LT=2 SS=0 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Q = 90 Planned order releases
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started