Question: I need help understanding what I am doing wrong.I will give a thumbs up Each unit of A is composed of one unit of B,


I need help understanding what I am doing wrong.I will give a thumbs up
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 10, 10, 40, and 20 units, respectively. Item B has a scheduled receipt of 20 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 75 units. D and E are required to be purchased in multiples of 140 and 80, 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 30 in Period 2, 30 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.) 3 4 5 30 0 30 40 0 0 01 0 Period Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Item A OH = 10 LT = 1 SS = 0 Q = L4L 01 10 OOOOO 0 0 0 0 0 20 20 0 >>>>>> * * * OOOOOO 01 30 301 OOOOOO 01 0 40 0 0 301 0 0 0 01 20 401 0 0 011 0 401 0 O o 401 0 20 20 301 0 0 01 0 0 01 O O1 0 Item B OH = 0 LT = 1 SS = 0 Q = L4L 01 0 0 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases OOOOOO @ @ @ @ 0 0 301 301 OOOOOO 01 0 01 0 O 401 401 0 0 0 O 01 301 01 O1 401 0 0C 801 0 Item C OH = 10 LT=1 SS = 0 Q = 75 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases 401 50 101 101 X SS-U Q=L4L TURTLYGITTIS Planned order receipts Planned order releases 0 20 0 > 0 20 0 30 0 A0 0 30 0 40 0 20 20 0 0 0 30 0 40 0 0 0 0 0 Item B OH = 0 LT = 1 SS = 0 Q=L4L 0 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases 0 0 0 0 0 01 0 0 0 0 OOOO 01 0 OOOO 0 0 0 40 40 30 30 0 0 0 0 0 30 0 01 40 0 Item C OH = 10 LT = 1 SS = 0 Q = 75 80 0 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases 40 50 101 X 101 X Item D OH = 40 LT= 2 SS = 0 Q = 140 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Item E OH = 20 LT = 2 SS = 0 Q = 80 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releasesStep by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
