14. Item A has a gross requirement of 2,000 in week 6. Currently, 500 units of Item A are onhand, with a scheduled receipt of 500 items in week 3. The lead time for item A is threeweeks with an order quantity of 500. Complete the MRP record for item A.

Starting with gross needs (GR), scheduled receipts (SR), and on-hand inventory (OH), we calculate…

Answered: 14. Item A has a gross requirement of…

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

Similar questions

MRP Logic 13. Item A has a gross requirement for 1,000 in week 5. There are currently 300 of the item on hand, with a scheduled receipt of 100 items in week 2. The order quantity is lot for lot, and there is a two-week lead time. Complete the MRP record for item A.
You are supposed to find the gross requirements for all of them.
Discuss the meaning of MRP terms such as planned order release and the scheduled order receipt.
Develop a material requirements plan for component H. Lead times for the end item and each component except B are one week. The lead time for B is three weeks. Sixty units of A are needed at the startof week 8. There are currently 15 units of B on hand and 130 of E on hand, and 50 units of H are inproduction and will be completed by the start of week 2. Lot-for-lot ordering will be used for all items.
What will be projected on hand inventory of item S in week6?
Product A is made from components B and C. Item B, inturn, is made from D and E. Item C also is an intermediateitem, made from F and H. Finally, intermediate item E ismade from H and G. Note that item H has two parents. Thefollowing are item lead times:a. What lead time (in weeks) is needed to respond to a cus-tomer order for product A, assuming no existing invento-ries or scheduled receipts?b. What is the customer response time if all purchased items(i.e., D, F, G, and H) are in inventory?c. If you are allowed to keep just one purchased item instock, which one would you choose?
Product A is made from components B and C. Item B, inturn, is made from D and E. Item C also is an intermediateitem, made from F and H. Finally, intermediate item E ismade from H and G. Note that item H has two parents. Thefollowing are item lead times: a. What lead time (in weeks) is needed to respond to a cus-tomer order for product A, assuming no existing invento-ries or scheduled receipts?b. What is the customer response time if all purchased items(i.e., D, F, G, and H) are in inventory?c. If you are allowed to keep just one purchased item instock, which one would you choose?
Distinguish between the meanings of MRP words such as scheduled order release and scheduled order receipt.
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…
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 sizes 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.
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.)
Material Requirements Management MRP Logic 13. Item A has a gross requirement for 1,000 in week 5. There are currently 300 of the item on hand, with a scheduled receipt of 100 items in week 2. The order quantity is lot for lot, and there is a two-week lead time. Complete the MRP record for item A.

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS

14. Item A has a gross requirement of 2,000 in week 6. Currently, 500 units of Item A are on hand, with a scheduled receipt of 500 items in week 3. The lead time for item A is three weeks with an order quantity of 500. Complete the MRP record for item A.