Operations Management - With Connect (Custom)
13th Edition
ISBN: 9781260226072
Author: Stevenson
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 12, Problem 18P
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 start of week 8. There are currently 15 units of B on hand and 130 of E on hand, and 50 units of H are in production and will be completed by the start of week 2. Lot-for-lot ordering will be used for all items.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
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.
One unit of A is made of three units of B, one unit of C, and two units of D. B is composed of two units of E and one unit of D. C is made of one unit of B and two units of E. E is made of one unit of F. Items B, C, E, and F have one-week lead times; A and D have lead times of two weeks. Assume that lot-for-lot (L4L) lot sizing is used for Items A, B, and F; lots of size 55, 55, and 200 are used for Items C, D, and E, respectively. Items C, E, and F have on-hand (beginning) inventories of 10, 50, and 160, respectively; all other items have zero beginning inventory. We are scheduled to receive 10 units of A in Week 2, 60 units of E in Week 1, and also 50 units of F in Week 1. There are no other scheduled receipts. If 32 units of A are required in Week 8, use the low-level-coded bill of materials to find the necessary planned order releases for all components
One unit of A is made of three units of B, one unit of C, and two units of D. B is composed of two
units of E and one unit of D. C is made of one unit of B and two units of E. E is made of one unit
of F.
Items B, C, E, and F have one-week lead times; A and D have lead times of two weeks.
Assume that lot-for-lot (L4L) lot sizing is used for Items A, B, and F; lots of size 50, 50, and 175
are used for Items C, D, and E, respectively.
Items C, E, and F have on-hand (beginning) inventories of 10, 50, and 160, respectively; all
other items have zero beginning inventory. We are scheduled to receive 10 units of A in Week 2,
50 units of E in Week 1, and also 40 units of F in Week 1. There are no other scheduled receipts.
If 30 units of A are required in Week 8:
a. Develop an MRP table in excel.
Chapter 12 Solutions
Operations Management - With Connect (Custom)
Ch. 12.11 - What is ERP?Ch. 12.11 - What are the three main reasons firms adopt ERP?Ch. 12.11 - What are some hidden costs of ERP?Ch. 12.11 - How does ERP fit with e-commerce and supply chain...Ch. 12 - Contrast independent and dependent demand.Ch. 12 - When is MRP appropriate?Ch. 12 - Briefly define or explain each of these terms: a....Ch. 12 - Prob. 4DRQCh. 12 - Prob. 5DRQCh. 12 - What is meant by the term safety time?
Ch. 12 - Prob. 7DRQCh. 12 - Briefly discuss the requirements for effective...Ch. 12 - Prob. 9DRQCh. 12 - How can the use of MRP contribute to productivity?Ch. 12 - Prob. 11DRQCh. 12 - What is lot sizing. what is its goal, and why is...Ch. 12 - Contrast planned-order receipts and scheduled...Ch. 12 - If seasonal variations are present, is their...Ch. 12 - Prob. 15DRQCh. 12 - What are some unforeseen costs of ERP?Ch. 12 - What trade-offs are involved in the decision to...Ch. 12 - Who in the organization needs to be involved in...Ch. 12 - Prob. 3TSCh. 12 - Prob. 1CTECh. 12 - Give one example of unethical behavior involving...Ch. 12 - a. Given the following diagram for a product,...Ch. 12 - Prob. 2PCh. 12 - Prob. 3PCh. 12 - Eighty units of end item E are needed at the...Ch. 12 - a. One hundred twenty units of end item Z are...Ch. 12 - A table is assembled using three components, as...Ch. 12 - Eighty units of end item X are needed at the...Ch. 12 - Oh No!, Inc., sells three models of radar detector...Ch. 12 - Assume that you are the manager of a shop that...Ch. 12 - Assume that you are the manager of Assembly, Inc....Ch. 12 - Determine material requirements plans for pans N...Ch. 12 - A firm that produces electric golf carts has just...Ch. 12 - Refer to Problem 12. Assume that unusually mild...Ch. 12 - Using the accompanying diagram, do the following:...Ch. 12 - A company that manufactures paving material for...Ch. 12 - Prob. 16PCh. 12 - The MRP Department has a problem. Its computer...Ch. 12 - Develop a material requirements plan for component...Ch. 12 - How many wheels sets should the manager order?Ch. 12 - When should the wheel sets be ordered?Ch. 12 - Prob. 2.1CQCh. 12 - Prob. 1OTQCh. 12 - Prob. 2OTQCh. 12 - Suppose the company has just received an order for...Ch. 12 - Prob. 4OTQCh. 12 - Prob. 5OTQ
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.Similar questions
- One unit of A is made of three units of B, one unit of C, and two units of D. B is composed of two units of E and one unit of D. C is made of one unit of B and two units of E. E is made of one unit of F. Items B, C, E, and F have one-week lead times; A and D have lead times of two weeks. Assume that lot-for-lot (L4L) lot sizing is used for items A, B, and F; lots of size 50, 50, and 200 are used for Items C, D, and E, respectively. Items C, E, and F have on-hand (beginning) inventories of 10, 50, and 150, respectively; all other items have zero beginning inventory. We are scheduled to receive 10 units of A in week 2, 50 units of E in week 1, and also 50 units of F in week 1. There are no other scheduled receipts. If 30 units ofA are required in week 8, use the low-level-coded bill-of-materials to find the necessaryplanned-order releases for all components.arrow_forwardOne 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.)arrow_forwardOne 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.arrow_forward
- The planned order receipt for item A is 200 in week 5 and the lead time is 3 weeks. Which week should the planned order release be?arrow_forwardItem A has a gross requirement of 2,400 in week 6. Currently, there are 200 Item A's on hand with a scheduled receipt of 2,100 items in week 3. The lead time for item A is 2 weeks with an order quantity of 900. Complete the MRP record for Item A. Complete the MRP record for Item A (enter your responses as whole numbers). Week 0 1 2 3 4 5 6 Item A LT=2 Quantity: FOQ=900 Gross Requirementsarrow_forward4. One unit of A is made of two units of B, three units of C, and two units of D. B is composed of one unit of E and two units of F. C is made of two units of F and one unit of D. E is made of two units of D. Items A, C, D, and F have one-week lead times; B and E have lead times of two weeks. Lot-for-lot (L4L) lot sizing is used for Items A, B, C, and D; lots of size 60 and 200 are used for Items E and F, respectively. Item C has an on-hand (beginning) inventory of 10; D has an on-hand inventory of 50; all other items have zero beginning inventories. We are scheduled to receive 20 units of Item E in Week 2; there are no other scheduled receipts. If 20 units of A are required in Week 8: C. Draw the low-level-code bill-of-materials here.arrow_forward
- 4. One unit of A is made of two units of B, three units of C, and two units of D. B is composed of one unit of E and two units of F. C is made of two units of F and one unit of D. E is made of two units of D. Items A, C, D, and F have one-week lead times; B and E have lead times of two weeks. Lot-for-lot (L4L) lot sizing is used for Items A, B, C, and D; lots of size 60 and 200 are used for Items E and F, respectively. Item C has an on-hand (beginning) inventory of 10; D has an on-hand inventory of 50; all other items have zero beginning inventories. We are scheduled to receive 20 units of Item E in Week 2; there are no other scheduled receipts. If 20 units of A are required in Week 8: C. Draw the low-level-code bill-of-materials here. d. Develop an MRP table in excel.arrow_forwardOne 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 A in 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 thenecessary planned order releases for all components.arrow_forwardOne unit of A is made of two units of B and one unit of C. B is made of three units of Dand 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 havetwo-week lead times; and Item D has a lead time of three weeks. Lot-for-lot (L4L) lot sizingis used for Items C, E, and F; lots of size 20, 40, and 160 are used for Items A, B, andD, 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 scheduledto receive 10 units of A in Week 3, 20 units of B in Week 7, 40 units of F in Week 5, and60 units of E in Week 2; there are no other scheduled receipts. If 20 units of A are requiredin Week 10, use the low-level-coded bill-of-materials (product structure tree) to i nd thenecessary planned order releases for all components.arrow_forward
- Jenny Malone works for the Columbus based Cummins Diesel Engine company. Jenny works in the production scheduling department and she is developing an MRP planning schedule for Item J. Please assist Jenny by developing the correct net requirements, planned order receipts, and planned order releases to meet the gross requirements. The lead time is one week. (Leave no cells blank - be certain to enter "0" in all open cells as required.) ITEM J Gross requirements On hand Net requirements Planned order receipt Planned order release Item J LT=1 Q = L4L 0 32 Period Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases 1 WEEK NUMBER 2 3 76 4 48 5 72 2 76 3 48 72arrow_forwardThe three tables above show the master production schedule and the bill of materials of part A, and the inventory records of all the parts. There are no scheduled receipts. Given this information, what is the net requirement of part A in Week 4?arrow_forwardIn reference to the attached image: What would be the impact of a scheduled receipt of 200 units for item B in week 3 (and allother data remained the same) on your calculated planned order receipts and releases?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Operations ManagementOperations ManagementISBN:9781259667473Author:William J StevensonPublisher:McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi...Operations ManagementISBN:9781259666100Author:F. Robert Jacobs, Richard B ChasePublisher:McGraw-Hill Education
Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage Learning
Production and Operations Analysis, Seventh Editi...Operations ManagementISBN:9781478623069Author:Steven Nahmias, Tava Lennon OlsenPublisher:Waveland Press, Inc.
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Operations Management
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
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.
Inventory Management | Concepts, Examples and Solved Problems; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=2n9NLZTIlz8;License: Standard YouTube License, CC-BY