6. One unit of A is made of one unit of B and one unit of C. B is made of four units of C and one unit each of E and F. C is made of two units of D and one unit of E. E is made of three units of F. 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 A, D, and E; lots of size 50, 100, and 50 are used for Items B, C, and F, respectively. Items A, C, D, and E have on-hand (beginning) inventories of 20, 50, 100, and 10, respectively; all other items have zero beginning inventory. We are scheduled to receive 10 units of A in Week 1, 100 units of C in Week 1, and 100 units of D in Week 3; there are no other scheduled receipts.If 50 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.) ## Material Requirements Planning (MRP) TableThis table represents a Material Requirements Planning (MRP) schedule over a 10-period time frame. It includes essential data for items labeled A through F. Each item has specific parameters: on-hand inventory, lead time, safety stock, and order quantity.### Columns:- **Period:** Marks time periods from 1 to 10.- **Rows for Each Item:** - **Gross Requirements:** Demand during each period. - **Scheduled Receipts:** Expected delivery of orders in each period. - **Projected Available Balance:** Forecasted inventory after accounting for gross requirements and scheduled receipts. - **Net Requirements:** Calculated shortage based on projected available balance. - **Planned Order Receipts:** Orders to be received in future periods, fulfilling net requirements. - **Planned Order Releases:** Planned initiation of orders considering lead time and order receipt schedule.### Item Details:- **Item A** - On-Hand Inventory (OHt): 20 - Lead Time (LT): 2 - Safety Stock (SS): 1 - Order Quantity (Q): L4L (Lot-for-Lot) - **Item B** - On-Hand Inventory (OHt): 0 - Lead Time (LT): 2 - Safety Stock (SS): 0 - Order Quantity (Q): 50- **Item C** - On-Hand Inventory (OHt): 50 - Lead Time (LT): 1 - Safety Stock (SS): 0 - Order Quantity (Q): 100- **Item D** - On-Hand Inventory (OHt): 100 - Lead Time (LT): 3 - Safety Stock (SS): 0 - Order Quantity (Q): L4L- **Item E** - On-Hand Inventory (OHt): 10 - Lead Time (LT): 2 - Safety Stock (SS): 0 - Order Quantity (Q): 20- **Item F** - On-Hand Inventory (OHt): 0 - Lead Time (LT): 2 - Safety Stock (SS): 0 - Order Quantity (Q): 50### Explanation:This table is designed to help in planning production and inventory by ensuring that the supply

Draw a bill of material product structure as shown below:

Answered: 6. One unit of A is made of one unit…

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 one unit of B and one unit of C. B is made of four units of C and one unit each of E and F. C is made of two units of D and one unit of E. E is made of three units of F. 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 A, D, and E; lots of size 50, 100, and 50 are used for Items B, C, and F, respectively. Items A, C, D, and E have on-hand (beginning) inventories of 20, 50, 100, and 10, respectively; all other items have zero beginning inventory. We are scheduled to receive 10 units of A in Week 1, 100 units of C in Week 1, and 100 units of D in Week 3; there are no other scheduled receipts.

If 50 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.)