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
EBK PRINCIPLES OF OPERATIONS MANAGEMENT
- 1. Speedy, Inc. is a company that produces automotive electrical components. AI5I is a common part for all its products. Consider the following grass requirements and inventory data for AISI part: Week 3 6 7 Grass requirements 40 30 30 70 20 Inventory Data: Lead time Beginning inventorry Scheduled receipts Holding cost Setup cost 1 week 40 $2.50/unit/week S150 Based on the L4L. lot-sizing rule, develop a Material Requirements Plan (MRP) for the next 8 weeks for A15I part. Item: A151 Week 5 Lot size: L4L 1 2 4 7 8 Lead time: 1 Gross Requirements Scheduled Receipts On Hand Inventory Net Requirements Planned Order Receipts Planned Order Releases (ii) Based on the FOQ - 57 units lot-sizing rule, develop a Material Requirements Plan (MRP) for the next 8 weeks for A151 part. Item: A151 Lot size: FOQ 57 Lead time: 1 Gross Requirements Scheduled Receipts On Hand Inventory Net Requirements Planned Order Receipts |Planned Order Releases Week 1 2 4 5 7 8arrow_forwardWhat is material requirement planning?arrow_forward: University plans to launch its new cam: University plans to launch its new campus at Bahria Town Karachi. This campus will facilitate media science and business studies. For a complete setup, the procurement department will have to facilitate a number of purchases including equipment, lab facilities and general items. Develop a procurement strategy for this new campus. You are required to made a matrix showing, the nature of purchases, Kinds and requisitions required for the complete setup.pus at Bahria Town Karachi. This campus will facilitate media science and business studies. For a complete setup, the procurement department will have to facilitate a number of purchases including equipment, lab facilities and general items. Develop a procurement strategy for this new campus. You are required to made a matrix showing, the nature of purchases, Kinds and requisitions required for the complete setup.arrow_forward
- What are examples of three tasks involved in the requirements-gathering and analysis phase?arrow_forwardExplain how is safety stock included in a material requirements plan ?arrow_forwardWhat are the other managerial applications that might be found once the material requirements plan technique is established ?arrow_forward
- Explain Material Requirements Planning?arrow_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_forwardConsider the bill of materials (BOM) in Figure 11.33.a. How many immediate parents (one level above) does item I have? How many immediate parents does item E have?b. How many unique components does product A have at all levels?c. Which of the components are purchased items?d. How many intermediate items does product A have at all levels?e. Given the lead times (LT) in weeks noted on Figure 11.33, how far in advance of shipment must a purchase commitment be for any of the purchased items identified in part (c)?arrow_forward
- What will be projected on hand inventory of item S in week6?arrow_forwardMr. 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_forwardWal 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_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.