Question: Please help me correct this question. Thanks Problem 9-15 One unit of A is made of two units of B and one unit of C.
Please help me correct this question. Thanks
Problem 9-15 One unit of A is made of two units of B and one unit of C. B is made of three units of D and one unit of F. C is composed of three units of B, one unit of D, and four units of E. D is made of one unit of E. Item C has a lead time of one week; Items A, B, E, and F have two-week lead times, and Item D has a lead time of three weeks. Lot-for-lot (L4L) lot sizing is used for Items C, E, and F; lots of size 20, 40, and 160 are used for Items A, B, and D, respectively. Items A, B, D, and E have on-hand (beginning) inventories of 5, 10, 100, and 100, respectively; all other items have zero beginning inventories. We are scheduled to receive 10 units of Ain Week 3, 20 units of B in Week 7, 40 units of F in Week 5, and 60 units of E in Week 2; there are no other scheduled receipts. If 20 units of A are required in Week 10, use the low-level-coded bill-of-materials (product structure tree) to find the necessary planned order releases for all components. (Leave no cells blank - be certain to enter "0" wherever required.) 2 4 5 7 8 10 20 0 0 0 0 0 ol 0 0 Period Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases 10 15 0 15 15 Item A OH = 5 LT = 2 SS = 0 Q = 20 15 5 0 >>>>>> 15 0 0 15 0 0 15 0 15 5 20 0 0 0 0 0 0 0 0 0 20 0 0 0 0 0 0 0 0 20 0 0 0 0 0 0 0 0 0 Item C 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 x 0 20 20 0 0 0 01 0 0 0 0 201 0 X 0 0 0 0 0 40 0 01 0 0 0 ol 0 0 0 0 0 0 0 0 0 10 10 OOOOOOOOOOOOOOO 10 10 40 Item B OH = 10 LT = 2 SS = 0 Q = 40 40 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases 10 0 601 20 10 30 % 0 401 0 0 0 40 40 0 OOOOOOOOOOOOOOOOOO 0 0 0 0 0 0 0 0 0 0 OOO OOOOO 10 la pololololo 40 0 0 0 0 40 elop pollo 0 0 0 0 0 0 140 0 0 0 0 0 BOOOOOOOOOOOOOOOOOOOOOOO 0 0 0 100 0 1401 100 100 0 0 0 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Item D OH = 100 LT = 3 SS = 0 Q = 160 120 0 100 % 20 160 0 0 0 100 0 0 160 0 0 0 0 01 0 0 0 0 0 0 0 0 0 0 0 0 401 0 0 0 0 0 40 0 0 40 0 401 0 0 Item F OH = 0 LT = 2 SS = 0 Q = L4L 0 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases 0 0 40 401 ol 0 0 0 0 0 0 0 0 0 0 40 0 0 0 BOOOOOOOOOOO 0 160 0 801 0 0 0 0 60 x x 0 0 0 0 E 100 0 Item E OH = 100 LT = 2 SS = 0 Q = L4L 0 160 0 0 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases 0 0 801 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 80 0 0 0 0 80 0 0 0 0 0