4.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 22, 50, and 200 are used for Items A, B, and D, respectively. Items A, B, D, and E have on-hand (beginning) inventories of 10, 15, 122, and 100, respectively; all other items have zero beginning inventories. We are scheduled to receive 10 units of A in Week 3, 40 units of B in Week 7, 50 units of F in Week 5, and 100 units of E in Week 2; there are no other scheduled receipts.If 22 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 the cells blank, whenever zero (0) is required.) This image displays a series of tables organized to represent material requirements planning for various items (A, B, C, D, E, F) over 10 periods. The tables are divided into columns for each period, containing the following rows for each item:1. **Gross Requirements**2. **Scheduled Receipts**3. **Projected Available Balance**4. **Net Requirements**5. **Planned Order Receipts**6. **Planned Order Releases**Each item has parameters listed which include:- **On-hand (OH):** Current inventory.- **Lead Time (LT):** Time needed to receive orders.- **Safety Stock (SS):** Minimum inventory to keep on hand.- **Order Quantity (Q):** Lot size for orders.For example:- **Item A:** OH: 10, LT: 2, SS: 0, Q: 22- **Item B:** OH: 15, LT: 2, SS: 0, Q: 50- **Item C:** OH: 0, LT: 1, SS: 0, Q: L4L (Lot-for-Lot)- **Item D:** OH: 122, LT: 3, SS: 0, Q: 200- **Item E:** OH: 0, LT: 2, SS: 0, Q: L4L- **Item F:** OH: 100, LT: 2, SS: 0, Q: 44Each table is designed for tracking and planning inventory and order management, ensuring that materials are ordered in time to meet production requirements while maintaining optimal inventory levels.

Answered: If 22 units of A are required in Week…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Related questions

Question

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 22, 50, and 200 are used for Items A, B, and D, respectively. Items A, B, D, and E have on-hand (beginning) inventories of 10, 15, 122, and 100, respectively; all other items have zero beginning inventories. We are scheduled to receive 10 units of A in Week 3, 40 units of B in Week 7, 50 units of F in Week 5, and 100 units of E in Week 2; there are no other scheduled receipts.

If 22 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 the cells blank, whenever zero (0) is required.)