Concept explainers
a. One hundred twenty units of end item Z are needed at the beginning of week 7. Prepare a material requirements plan for component C. Take into account that on hand there are 40 units of Z, 70 units of A, 100 units of B, and 30 units of C. Also, there is a
b. Ninety-five units of end item E are needed at the beginning of week 7. Prepare a material requirements plan for component D. Take into account that 5 units of E are currently on hand, as well as 50 units of B, 100 units of C, and 80 units of D. Also, 30 units of C have been outsourced and are expected to arrive in week 4. Lead times are two weeks for E and C. and one week for the other components. Assume lot-for-lot ordering except for D. where multiples of 40 must be used.
a)
To prepare: A material requirements plan for Component C.
Introduction: Materials Requirement Planning (MRP) is the planning or scheduling system, which can be used in the manufacturing process. It is used to plan the number of items required to produce one unit of finished goods (end item)
Explanation of Solution
Given information:
120 units of end item (Z) are required at the beginning of Week 7. It is given that 40 units of Component Z, 100 units of Component B, 70 units of Component A, and 30 units of Component C are available on hand. Scheduled receipt is 20 units of Component C in Week 4. Lead-time is given as 2 weeks for Component Z and Component B and 1 week for other components. Lot size is lot-for-lot.
In addition to the above information, the following diagram is given:
Prepare a Material Requirement Plan (MRP) for Component Z:
- Gross requirement is given as 120 units at the beginning of Week 7.
- On-hand inventory is 40 units. It remains same until Week 6, as there is no demand.
- Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.
- 80 units are required at the beginning of Week 7. Hence, they need to order for 80 units (as the lot size is lot-for-lot) before two weeks (as the lead-time is 2 weeks), which means on Week 5.
- Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.
Prepare a Material Requirement Plan (MRP) for Component A (2):
- Component Z is the parent item of Component A (2). As the number of Component A is 2, the planned order release should be multiplied with 2 to determine the gross requirement of Component A.
- On-hand inventory is 70 units. It remains same until Week 4, as there is no demand.
- Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.
- 90 units are required at the beginning of Week 5. Hence, they need to order for 90 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 weeks), which means on Week 4.
- Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.
Prepare a Material Requirement Plan (MRP) for Component B (4):
- Component Z is the parent item of Component B (4). As the number of Component B is 4, the planned order release should be multiplied with 4 to determine the gross requirement of Component B.
- On-hand inventory is 100 units. It remains same until Week 4, as there is no demand.
- Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.
- 220 units are required at the beginning of Week 5. Hence, they need to order for 220 units (as the lot size is lot-for-lot) on two weeks before (as the lead-time is 2 weeks), which means on Week 3.
- Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.
Prepare a Material Requirement Plan (MRP) for Component C (3) and C (2):
- Component A (2) is the parent item of Component C (3) and Component B (4) is the parent item of Component C (2). As the number of Component C is 3, the planned order release of Component A should be multiplied with 3 to determine the gross requirement of Component C. The same should be followed for Component C (2) with its parent item B (4).
- On-hand inventory is 30 units. It remains same until Week 3, as there is no demand.
- Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.
- 410 units are required at the beginning of Week 3. Hence, they need to order for 410 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 week), which means on Week 2.
- Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.
- Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.
b)
To prepare: A material requirements plan for Component D.
Introduction: Materials Requirement Planning (MRP) is the planning or scheduling system, which can be used in the manufacturing process. It is used to plan the number of items required to produce one unit of finished goods (end item)
Explanation of Solution
Given information:
95 units of end item (E) are required at the beginning of Week 7. It is given that 5 units of Component E, 50 units of Component B, 80 units of Component D, and 100 units of Component C are available on hand. Scheduled receipt is 30 units of Component C in Week 4. Lead-time is given as 2 weeks for Component E and Component C and 1 week for other components. Lot size is lot-for-lot for all the components except Component D. Lot size for Component C is multiples of 40.
In addition to the above information, the following diagram is given:
Prepare a Material Requirement Plan (MRP) for Component E:
- Gross requirement is given as 95 units at the beginning of Week 7.
- On-hand inventory is 5 units. It remains same until Week 6, as there is no demand.
- Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.
- 90 units are required at the beginning of Week 7. Hence, they need to order for 90 units (as the lot size is lot-for-lot) before two weeks (as the lead-time is 2 weeks), which means on Week 5.
- Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.
Prepare a Material Requirement Plan (MRP) for Component B (3):
- Component E is the parent item of Component B (3). As the number of Component B is 3, the planned order release should be multiplied with 3 to determine the gross requirement of Component 3.
- On-hand inventory is 50 units. It remains same until Week 4, as there is no demand.
- Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.
- 220 units are required at the beginning of Week 5. Hence, they need to order for 220 units (as the lot size is lot-for-lot) on previous week (as the lead-time is 1 weeks), which means on Week 4.
- Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.
Prepare a Material Requirement Plan (MRP) for Component C (2):
- Component E is the parent item of Component C (2). As the number of Component C is 2, the planned order release should be multiplied with 2 to determine the gross requirement of Component C.
- On-hand inventory is 100 units. It remains same until Week 3, as there is no demand. Scheduled receipts of 30 units arrived on Week 4. Hence, the on-hand inventory is 130 units on Week 4.
- Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.
- 50 units are required at the beginning of Week 5. Hence, they need to order for 50 units (as the lot size is lot-for-lot) on two weeks before (as the lead-time is 2 weeks), which means on Week 3.
- Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.
- Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.
Prepare a Material Requirement Plan (MRP) for Component D (2) and D (2):
- Component B (3) is the parent item of Component D (2) and Component C (2) is the parent item of Component D (2). As the number of Component D is 2, the planned order release of Component B should be multiplied with 2 to determine the gross requirement of Component D. The same should be followed for Component D (2) with its parent item C (2).
- On-hand inventory is 80 units. It remains same until Week 3, as there is no demand.
- Net requirement can be calculated by subtracting the projected on hand inventory of previous week from the gross requirement of current week.
- 20 units are required at the beginning of Week 3. Hence, they need to order for 40 units (as the lot size is multiples of 40) on previous week (as the lead-time is 1 week), which means on Week 2.
- Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.
- Projected on-hand inventory is calculated by adding the scheduled receipts and the value attained by subtracting gross requirements from the sum of projected on-hand of previous week and planned order receipt of previous week.
Want to see more full solutions like this?
Chapter 12 Solutions
GEN COMBO CONNECT AC OPERATIONS MANAGEMENT; PRACTICE OP MANAGEMENT AC
Additional Business Textbook Solutions
Operations and Supply Chain Management 9th edition
Business in Action
Principles Of Operations Management
Operations Management
Operations Management: Processes and Supply Chains (12th Edition) (What's New in Operations Management)
Operations Management: Sustainability and Supply Chain Management (12th Edition)
- 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.)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_forward4. 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…arrow_forward
- Product A is an end item and is made from two units of B and four of C. B is made of three units of D and two of E. A has a lead time of 1 week, B,C AND E have a lead time of 2 weeks and D and F have a lead time of 3 weeks. Assume we are using L4L. question: If 100 units of A are required in Week 10, develop the MRP schedule, specifying when items are to be ordered and recieved. There are currently no units of inventory on hand.arrow_forwardOne 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 componentsarrow_forwardOne 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_forward
- Eighty units of end item E are needed at the beginning of week 6. Three cases (30 units per case) of Jhave been ordered and one case is scheduled to arrive in week 3, one in week 4, and one in week 5.Note: J must be ordered by the case, and B must be produced in multiples of 120 units. There are 60 unitsof B and 20 units of J now on hand. Lead times are two weeks each for E and B, and one week for J.E a. Prepare a material requirements plan for component J.b. Suppose that in week 4 the quantity of E needed is changed from 80 to 70. The planned-order releasesthrough week 3 have all been executed. How many more Bs and Js will be on hand in week 6?arrow_forwardProduct 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?arrow_forwardGiven the product structure, master productionschedule, and inventory status in Figure 14.13, and assuming therequirements for each BOM item is I:a) develop a gross requirements plan for Item C;b) develop a net requirements plan for Item C.arrow_forward
- The 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_forward1-Develop the production schedule for each component in parent item A.Make sure the independent demand for B and C are also included in theschedule.arrow_forwardWhat will be projected on hand inventory of item S in week6?arrow_forward
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,Operations ManagementOperations ManagementISBN:9781259667473Author:William J StevensonPublisher:McGraw-Hill EducationOperations 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 LearningProduction and Operations Analysis, Seventh Editi...Operations ManagementISBN:9781478623069Author:Steven Nahmias, Tava Lennon OlsenPublisher:Waveland Press, Inc.