Concept explainers
a)
To develop: A gross requirements plan for all the items.
Introduction:
Gross requirements plan:
The gross requirements plan is the plan where the independent and dependent demand for a product or a component before the on-hand inventory and the scheduled receipts are netted with.
a)
Explanation of Solution
Given information:
Product structure:
Master production
MPS for X1 | ||||||
Period | 7 | 8 | 9 | 10 | 11 | 12 |
Gross requirements | 50 | 20 | 100 |
Inventory and lead time:
Item | X1 | B1 | B2 | A1 | C | D | E |
Lead time | 1 | 2 | 2 | 1 | 1 | 1 | 3 |
On hand | 50 | 20 | 20 | 5 | 0 | 0 | 10 |
Item X1:
Week | ||||||||||||
Item X1 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
Gross requirements | 50 | 20 | 100 | |||||||||
Order release | 50 | 20 | 100 |
The gross requirements are 50, 20 and 100 (1 assembly of X1) in weeks 8, 10 and 12 respectively derived from the master production schedule of X1. The lead time is 1 week. Therefore, the order release will be 50, 20 and 100 in weeks 7, 9 and 11 respectively.
Item B1:
Week | ||||||||||||
Item B1 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
Gross requirements | 50 | 20 | 100 | |||||||||
Order release | 50 | 20 | 100 |
The order release of X1 will become the gross requirements of B1. The gross requirements are 50, 20 and 100 (1 assembly of B1) in weeks 7, 9 and 11 respectively. The lead time is 2 weeks. Therefore, the order release will be 50, 20 and 100 in weeks 5, 7 and 9 respectively.
Item B2:
Week | ||||||||||||
Item B2 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
Gross requirements | 100 | 40 | 200 | |||||||||
Order release | 100 | 40 | 200 |
The order release of X1 will become the gross requirements of B2. The gross requirements are 100, 40 and 200 (2 assemblies of B2) in weeks 7, 9 and 11 respectively. The lead time is 2 weeks. Therefore, the order release will be 100, 40 and 200 in weeks 5, 7 and 9 respectively.
Item A1:
Week | ||||||||||||
Item A1 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
Gross requirements | 50 | 20 | 100 | |||||||||
Order release | 50 | 20 | 100 |
The order release of B1 will become the gross requirements of A1. The gross requirements are 50, 20 and 100 (1 assembly of A1) in weeks 5, 7 and 9 respectively. The lead time is 1 week. Therefore, the order release will be 50, 20 and 100 in weeks 4, 6 and 8 respectively.
Item C:
Week | ||||||||||||
Item C | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
Gross requirements | 200 | 80 | 400 | |||||||||
Order release | 200 | 80 | 400 |
The order release of B2 will become the gross requirements of C. The gross requirements are 200, 80 and 400 (2 assemblies of C) in weeks 5, 7 and 9 respectively. The lead time is 1 week. Therefore, the order release will be 200, 80 and 400 in weeks 4, 6 and 8 respectively.
Item D:
Week | ||||||||||||
Item D | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
Gross requirements | 100 | 40 | 200 | |||||||||
Order release | 100 | 40 | 200 |
The order release of B2 will become the gross requirements of D. The gross requirements are 100, 40 and 200 (2 assemblies of C) in weeks 5, 7 and 9 respectively. The lead time is 1 week. Therefore, the order release will be 100, 40 and 200 in weeks 4, 6 and 8 respectively.
Item E:
Week | ||||||||||||
Item E | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
Gross requirements | 200 | 50 | 80 | 20 | 400 | 100 | ||||||
Order release | 200 | 50 | 80 | 20 | 400 | 100 |
The order release of B1 and D will become the gross requirements of E. The gross requirements are 50, 20 and 100 (1 assembly of E) in weeks 5, 7 and 9 respectively. The lead time is 3 weeks. Therefore, the order release will be 50, 20 and 100 in weeks 2, 4 and 6 respectively.
The gross requirements are 200, 80 and 400 (2 assembly of E) in weeks 4, 6 and 8 respectively. The lead time is 3 weeks. Therefore, the order release will be 200, 80 and 400 in weeks 1, 3 and 5 respectively.
b)
To develop: A net requirements plan for all the items.
Introduction:
Net requirements plan:
The net requirements plan is the plan which is established on the gross requirements plan formed by deducting the stock on and the scheduled receipts. If the total requirement is below the safety stock levels, a planned order is made based on the given lot sizing technique.
b)
Explanation of Solution
Given information:
Product structure:
Master production schedule for X1:
MPS for X1 | ||||||
Period | 7 | 8 | 9 | 10 | 11 | 12 |
Gross requirements | 50 | 20 | 100 |
Inventory and lead time:
Item | X1 | B1 | B2 | A1 | C | D | E |
Lead time | 1 | 2 | 2 | 1 | 1 | 1 | 3 |
On hand | 50 | 20 | 20 | 5 | 0 | 0 | 10 |
Item X1:
Week | ||||||||||||
Item X1 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
Gross requirements | 50 | 20 | 100 | |||||||||
Scheduled receipt | ||||||||||||
On hand (50) | 50 | 0 | 0 | |||||||||
Net requirement | 0 | 20 | 100 | |||||||||
Planned order receipt | 20 | 100 | ||||||||||
Planned order release | 20 | 100 |
Week 8:
The gross requirement is 50 (1 assembly)derived from the master production schedule of X1. The on hand inventory is 50. Hence, the net requirement is 0. The lead time is 1 week. Therefore, there will be no planned order release.
Week 10:
The gross requirement is 20 (1 assembly) derived from the master production schedule of X1. The on hand inventory is 0. Hence, the net requirement is 20. The lead time is 1 week. Therefore, the planned order release will be 20 in week 9 which will be the planned order receipt in week 10.
Week 12:
The gross requirement is 100 (1 assembly) derived from the master production schedule of X1. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 1 week. Therefore, the planned order release will be 100 in week 11 which will be the planned order receipt in week 12.
Item B1:
Week | ||||||||||||
Item B1 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
Gross requirements | 20 | 100 | ||||||||||
Scheduled receipt | ||||||||||||
On hand (20) | 20 | 0 | ||||||||||
Net requirement | 0 | 100 | ||||||||||
Planned order receipt | 100 | |||||||||||
Planned order release | 100 |
Week 9:
The gross requirement is 20 (1 assembly) derived from the planned order release of X1. The on hand inventory is 20. Hence, the net requirement is 0. The lead time is 2 weeks. Therefore, there will be no planned order release.
Week 11:
The gross requirement is 100 (1 assembly) derived from planned order release of X1. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 2 weeks. Therefore, the planned order release will be 100 in week 9 which will be the planned order receipt in week 11.
Item B2:
Week | ||||||||||||
Item B2 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
Gross requirements | 40 | 200 | ||||||||||
Scheduled receipt | ||||||||||||
On hand (20) | 20 | 0 | ||||||||||
Net requirement | 20 | 200 | ||||||||||
Planned order receipt | 20 | 200 | ||||||||||
Planned order release | 20 | 200 |
Week 9:
The gross requirement is 40 (2 assembly) derived from the planned order release of X1. The on hand inventory is 20. Hence, the net requirement is 20. The lead time is 2 weeks. Therefore, the planned order release will be 20 in week 7 which will be the planned order receipt in week 9.
Week 11:
The gross requirement is 200 (2 assembly) derived from planned order release of X1. The on hand inventory is 0. Hence, the net requirement is 200. The lead time is 2 weeks. Therefore, the planned order release will be 200 in week 9 which will be the planned order receipt in week 11.
Item A1:
Week | ||||||||||||
Item A1 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
Gross requirements | 100 | |||||||||||
Scheduled receipt | ||||||||||||
On hand (5) | 5 | |||||||||||
Net requirement | 95 | |||||||||||
Planned order receipt | 95 | |||||||||||
Planned order release | 95 |
Week 9:
The gross requirement is 100 (1 assembly) derived from the planned order release of B1. The on hand inventory is 5. Hence, the net requirement is 95. The lead time is 1 week. Therefore, the planned order release will be 95 in week 8 which will be the planned order receipt in week 9.
Item C:
Week | ||||||||||||
Item C | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
Gross requirements | 40 | 400 | ||||||||||
Scheduled receipt | ||||||||||||
On hand (0) | 0 | 0 | ||||||||||
Net requirement | 40 | 400 | ||||||||||
Planned order receipt | 40 | 400 | ||||||||||
Planned order release | 40 | 400 |
Week 7:
The gross requirement is 40 (2 assembly) derived from the planned order release of B2. The on hand inventory is 0. Hence, the net requirement is 40. The lead time is 1 week. Therefore, the planned order release will be 40 in week 6 which will be the planned order receipt in week 7.
Week 9:
The gross requirement is 400 (2 assembly) derived from planned order release of B2. The on hand inventory is 0. Hence, the net requirement is 400. The lead time is 1 week. Therefore, the planned order release will be 400 in week 8 which will be the planned order receipt in week 9.
Item D:
Week | ||||||||||||
Item D | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
Gross requirements | 20 | 200 | ||||||||||
Scheduled receipt | ||||||||||||
On hand (0) | 0 | 0 | ||||||||||
Net requirement | 20 | 200 | ||||||||||
Planned order receipt | 20 | 200 | ||||||||||
Planned order release | 20 | 200 |
Week 7:
The gross requirement is 20 (1 assembly) derived from the planned order release of B2. The on hand inventory is 0. Hence, the net requirement is 20. The lead time is 1 week. Therefore, the planned order release will be 20 in week 6 which will be the planned order receipt in week 7.
Week 9:
The gross requirement is 200 (1 assembly) derived from planned order release of B2. The on hand inventory is 0. Hence, the net requirement is 200. The lead time is 1 week. Therefore, the planned order release will be 200 in week 8 which will be the planned order receipt in week 9.
Item E:
Week | ||||||||||||
Item E | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
Gross requirements | 40 | 400 | 100 | |||||||||
Scheduled receipt | ||||||||||||
On hand (10) | 10 | 0 | 0 | |||||||||
Net requirement | 30 | 400 | 100 | |||||||||
Planned order receipt | ||||||||||||
Planned order release | 30 | 400 | 100 |
Week 6:
The gross requirement is 40 (2 assembly) derived from the planned order release of B2. The on hand inventory is 10. Hence, the net requirement is 30. The lead time is 3 weeks. Therefore, the planned order release will be 30 in week 3 which will be the planned order receipt in week 6.
Week 8:
The gross requirement is 400 (2 assembly) derived from the planned order release of B2. The on hand inventory is 0. Hence, the net requirement is 400. The lead time is 3 weeks. Therefore, the planned order release will be 400 in week 5 which will be the planned order receipt in week 8.
Week 9:
The gross requirement is 100 (1 assembly) derived from the master production schedule of B1. The on hand inventory is 0. Hence, the net requirement is 100. The lead time is 3 weeks. Therefore, the planned order release will be 100 in week 6 which will be the planned order receipt in week 9.
Want to see more full solutions like this?
Chapter 14 Solutions
PRIN.OF OPERATIONS MANAGEMENT-MYOMLAB
- Build a gross requirements planarrow_forwardUsing the information in(You need to schedule I0 units of product Alpha fordelivery in 6 weeks. Three units of D and 2 units ofF are requiredfor each Alpha. The lead time for Alpha is I week. Lead time forD is I week, and lead time for F is 2 weeks.a) Construct a product structure.b) Prepare a time-phased product structure.c) Prepare a gross requirements plan for Alpha. ), construct a netmaterial requirements plan. There are 2 Alphas on hand and 4 Ds.arrow_forwardopm please help ....arrow_forward
- Explain how is safety stock included in a material requirements plan ?arrow_forwardHelp me to solve thisarrow_forwardYou need to schedule I 0 units of product Alpha fordelivery in 6 weeks. Three units of D and 2 units ofF are requiredfor each Alpha. The lead time for Alpha is I week. Lead time forD is I week, and lead time for F is 2 weeks.a) Construct a product structure.b) Prepare a time-phased product structure.c) Prepare a gross requirements plan for Alpha.arrow_forward
- Mr. Brown owns a fashion boutique in Ipoh. He has to install a security system and also wind-resistant windows. He also has to prepare ahead of the market for the expected trends. Mr. Brown prepares for future events. After Mr. Brown has plan to meets goals of his establishment. He decides to put together all the records of purchase and sales in a special folder. Mr. Brown decides on the items on 20% sales in the boutique for 3 weeks. Mr. Brown assigns the tasks to the customer service personnel to ensure all goals are met and consumers are being satisfied. QuestionExplain FOUR (4) basic management functions performed by Mr. Brown, supporting your answer with appropriate examples from the scenario.arrow_forward4)Demand for product XYZ is following: Week 2 3 4 5 6 7 8 Demand 70 80 60 60 70 80 90 80 Order cost : $8, Inventory holding cost: $3/year. a) Make MRP records for product XYZ using Economic Order Quantity techniques. b) Make MRP records for product XYZ using Least Unit Cost techniques.arrow_forwardhelp please I need it to be done in excelarrow_forward
- Wal Mart, although they are not a manufacturing company, uses sophisticated computer software to forecast sales and order products to be stocked in their stores so that they do not run out of the things shoppers are looking for. What kind of software system does Wal Mart likely use? Group of answer choices a) Inventory control b) Just-in-time ordering c) E-procurement d) Materials Requirement Planning (MRP)arrow_forwardPlease assist with Homework Chapter 21 Problem 6 . I keep getting the calculations mixed up. Thank you. Please provide step by step explantion so I can use it for notesarrow_forwardDraw an approximate bill-of-materials (BOM) for a kid’s toy of your choice following these requirements: I would like to use the Jollibee plush Bee toy. (a) clearly label the end item and each component, (b) the BOM must contain no more than 20 items, (c) the BOM must contain at least three levels (you may count the end-item level zero).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.