Given the following product structure, master production schedule, and inventory status below and assuming the requirements for each BOM item is 1: (a) develop a gross requirements plan for Item C; (b) develop a net requirements plan for Item C. Click the icon to view the product structure, master production schedule and inventory status. a) Develop a gross requirements plan for Items C. To do so, first find the gross requirements plans for its parents: items A and H. (Enter your responses as whole numbers). Item A Gross req Week 1 2 3 4 5 6 7 8 More Info Period Gross requirements: A Gross requirements: H Item A B с D E B E On Hand 15 110 60 40 85 8 100 Lead Time 1 2 2 1 2 Q 9 90 Item LUISX E F G H J K 10 60 F 9 On Hand 80 65 20 110 110 10 11 12 L 11 50 E H K 12 160 Lead Time 2 1 1 2 2 G F G X
Given the following product structure, master production schedule, and inventory status below and assuming the requirements for each BOM item is 1: (a) develop a gross requirements plan for Item C; (b) develop a net requirements plan for Item C. Click the icon to view the product structure, master production schedule and inventory status. a) Develop a gross requirements plan for Items C. To do so, first find the gross requirements plans for its parents: items A and H. (Enter your responses as whole numbers). Item A Gross req Week 1 2 3 4 5 6 7 8 More Info Period Gross requirements: A Gross requirements: H Item A B с D E B E On Hand 15 110 60 40 85 8 100 Lead Time 1 2 2 1 2 Q 9 90 Item LUISX E F G H J K 10 60 F 9 On Hand 80 65 20 110 110 10 11 12 L 11 50 E H K 12 160 Lead Time 2 1 1 2 2 G F G X
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...
Related questions
Question
![**Product Structure and Inventory Management**
**Scenario:**
Given the following product structure, master production schedule, and inventory status, you are tasked with developing a gross requirements plan for items C and H. Assume the requirements for each BOM item are 1.
**Objective:**
- Develop a gross requirements plan for Item C.
- Develop a net requirements plan for Item C.
### Gross Requirements Plan Development
**Instructions:**
1. Review the gross requirements for Items A and H for weeks 8 to 12.
2. Determine the gross requirements for their parent and child items.
**Weekly Gross Requirements for Item A:**
- Week 8: [Data missing]
- Week 9: 100 units
- Week 10: [Data missing]
- Week 11: 60 units
- Week 12: 160 units
### Detailed Information
**Period Requirements:**
- **Period 8:**
- Gross requirements for A: 100 units
- Gross requirements for H: 90 units
- **Period 12:**
- Gross requirements for H: 50 units
**Current Inventory and Lead Times:**
- **Item A:**
- On Hand: 15
- Lead Time: 1 week
- **Item B:**
- On Hand: 110
- Lead Time: 2 weeks
- **Item C:**
- On Hand: 60
- Lead Time: 2 weeks
- **Item D:**
- On Hand: 40
- Lead Time: 1 week
- **Item E:**
- On Hand: 85
- Lead Time: 2 weeks
- **Item F:**
- On Hand: 80
- Lead Time: 2 weeks
- **Item G:**
- On Hand: 65
- Lead Time: 1 week
- **Item H:**
- On Hand: 20
- Lead Time: 1 week
- **Item J:**
- On Hand: 110
- Lead Time: 2 weeks
- **Item K:**
- On Hand: 110
- Lead Time: 2 weeks
### Diagrams
**Diagram Explanation:**
- **Left Diagram (Hierarchy of A):**
- A splits into B and C.
- B further splits into](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fab8d1990-9470-48d9-a994-5cc30863c13e%2F746841bc-fbdb-4c57-843f-7b0e409f98ad%2Fht7q2qf_processed.png&w=3840&q=75)
Transcribed Image Text:**Product Structure and Inventory Management**
**Scenario:**
Given the following product structure, master production schedule, and inventory status, you are tasked with developing a gross requirements plan for items C and H. Assume the requirements for each BOM item are 1.
**Objective:**
- Develop a gross requirements plan for Item C.
- Develop a net requirements plan for Item C.
### Gross Requirements Plan Development
**Instructions:**
1. Review the gross requirements for Items A and H for weeks 8 to 12.
2. Determine the gross requirements for their parent and child items.
**Weekly Gross Requirements for Item A:**
- Week 8: [Data missing]
- Week 9: 100 units
- Week 10: [Data missing]
- Week 11: 60 units
- Week 12: 160 units
### Detailed Information
**Period Requirements:**
- **Period 8:**
- Gross requirements for A: 100 units
- Gross requirements for H: 90 units
- **Period 12:**
- Gross requirements for H: 50 units
**Current Inventory and Lead Times:**
- **Item A:**
- On Hand: 15
- Lead Time: 1 week
- **Item B:**
- On Hand: 110
- Lead Time: 2 weeks
- **Item C:**
- On Hand: 60
- Lead Time: 2 weeks
- **Item D:**
- On Hand: 40
- Lead Time: 1 week
- **Item E:**
- On Hand: 85
- Lead Time: 2 weeks
- **Item F:**
- On Hand: 80
- Lead Time: 2 weeks
- **Item G:**
- On Hand: 65
- Lead Time: 1 week
- **Item H:**
- On Hand: 20
- Lead Time: 1 week
- **Item J:**
- On Hand: 110
- Lead Time: 2 weeks
- **Item K:**
- On Hand: 110
- Lead Time: 2 weeks
### Diagrams
**Diagram Explanation:**
- **Left Diagram (Hierarchy of A):**
- A splits into B and C.
- B further splits into
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
![Operations Management](https://www.bartleby.com/isbn_cover_images/9781259667473/9781259667473_smallCoverImage.gif)
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
![Operations and Supply Chain Management (Mcgraw-hi…](https://www.bartleby.com/isbn_cover_images/9781259666100/9781259666100_smallCoverImage.gif)
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](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
![Operations Management](https://www.bartleby.com/isbn_cover_images/9781259667473/9781259667473_smallCoverImage.gif)
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
![Operations and Supply Chain Management (Mcgraw-hi…](https://www.bartleby.com/isbn_cover_images/9781259666100/9781259666100_smallCoverImage.gif)
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](https://www.bartleby.com/isbn_cover_images/9780135198100/9780135198100_smallCoverImage.gif)
![Purchasing and Supply Chain Management](https://www.bartleby.com/isbn_cover_images/9781285869681/9781285869681_smallCoverImage.gif)
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…](https://www.bartleby.com/isbn_cover_images/9781478623069/9781478623069_smallCoverImage.gif)
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.