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 15, 55, 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.) The image is a detailed table designed for Material Requirements Planning (MRP). It tracks various parameters for different items over a 10-period timeframe. Here's a breakdown of the table:Each section of the table corresponds to a specific item (labeled A, B, C, D, E, F) and includes several key elements:- **Gross Requirements:** This row is reserved for entering the total demand for the item in each period.- **Scheduled Receipts:** This row is for quantities that are expected to arrive at specific points in time.- **Projected Available Balance:** This cell tracks the inventory expected to be on hand at the end of each period, taking into account the receipts and requirements.- **Net Requirements:** This row calculates the actual quantities needed in each period after accounting for available inventory and scheduled receipts.- **Planned Order Receipts:** This row records the orders that need to be received to meet net requirements.- **Planned Order Releases:** This row specifies the orders that need to be released to meet the planned receipts, considering lead times.Each item section also provides specific details: - **OH:** Beginning on-hand inventory. - **LT:** Lead time, or the time needed to receive or produce the item. - **SS:** Safety stock, or the minimum inventory level to prevent stockouts. - **Q:** Order quantity, specified for the item as "L4L" (lot-for-lot) or a fixed batch size.This template helps in planning inventory and production strategies by aligning the demand with supply, ensuring efficient resource utilization across different time periods.

In assembling the product structure tree gives various leveled characterization of the things which…

Answered: One unit of A is made of one unit of B…

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 15, 55, 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.)