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...
icon
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
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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
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
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
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…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.