Question: I had some help from another tutor on this same question but unfortunately a majority of the answers were wrong I literally went back and


I had some help from another tutor on this same question but unfortunately a majority of the answers were wrong I literally went back and guessed and changed the answers. Is there anyone who can save me? Please?
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.) 4 0 301 5 30 01 0 0 40 0 Item A OH = 10 LT = 1 SS=0 Q = L4L 0 Period Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases 01 01 10 0 OOOOO 0 0 20 0 20 201 OOOOOO OOOOOO OOOOOO O 40 401 0 40 0 20 20 401 ni Ol 0 Item B OH = 0 LT = 1 SS = 0 Q = L4L 01 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases BOOOOO OOOO * * * 0 0 0 0 0 01 01 01 BOOOOO 01 01 40 0 01 0 401 Og 40 01 0 01 0 601 40 50 80 80 3 0 0 O 0 01 30 20 20 OOOOO 35 35 Item C OH = 10 LT = 1 SS=0 Q = 75 301 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases 30 35 40 75 & OOOOO 0 0 451 01 0 0 01 0 75 01 01 751 01 0 0 0 X 0 0 201 30 01 018 1508 4018 0 0 0 Ol Gross requirements Scheduled receipts Projected available balance Net requirements Item D OH = 40 LT = 2 SS=0 0 201 WOO OOOO 150 01 120 X 01 X 20 0 1108 3018 120 701 70 110 30 01 018 0 0 ezto.mheducation.com/hmtex Gross requirements Item A Scheduled receipts OH = 10 LT = 1 Projected available balance SS=0 Net requirements Q=L4L Planned order receipts Planned order releases 10 0 OOOOO 0 0 0 0 20 20 0 0 20 30 30 ol 0 30 20 20 0 0 0 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 0 0 0 OOOOOO ol 01 30 ol olo 30 30 01 0 0 0 0 30 10 40 80 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 20 50 201 0 0 60 0 35 09 0 0 35 83 40 753 0 % 30 30 01 OOOOOO 0 0 75 01 150 o o 20 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 20 0 20 oo o o 140 150 0 120 0 03 0 30 01 1200 0 01 0 01 0 110 30 110 30 140 01 140 140 O 0 225 0 351 501 Item E OH = 20 LT = 2 SS=0 Q = 80 Gross requirements Scheduled receipts Projeded available balance Net requirements Planned order receipts Planned order releases olo 20 o 0 0 240 0 0 20 o ol 0 0 225 01 35 2051 240 0 501 1901 01 2401Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
