2. Suppose a company needs to assemble 100 units of product A in week 4, 300 units in week 6, and 200 units in week 10. Items that are assembled are sent immediately to customers after they are assembled. To assemble product A, three units of item B, and two units of item C are needed (item B and C go directly into A on the assembly line). The lead times, on-hand, and scheduled receipts for items B and C are shown below. Assignment Assuming the company wants to keep inventory as low as possible, complete the following MRP schedules for items B and C. Item A- Master Assembly Schedule Week 3 4 10 11 12 Quantity 100 300 200 Item B - Lead Time = 2 weeks Week 3 5 10 11 12 Gross requirements On-hand 40 Scheduled receipts 5 Net requirements Planned order release Item C - Lead Time = 3 weeks Week 2 3 4 6 10 11 12 Gross requirements On-hand 400 Scheduled receipts 20 Net requirements Planned order release

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
icon
Concept explainers
Question

I am not even sure I understand how to begin to  this question and to fill out this sheet. 

2. Suppose a company needs to assemble 100 units of product A in week 4, 300
units in week 6, and 200 units in week 10. Items that are assembled are sent
immediately to customers after they are assembled. To assemble product A,
three units of item B, and two units of item C are needed (item B and C go
directly into A on the assembly line). The lead times, on-hand, and scheduled
receipts for items B and C are shown below.
Assignment
Assuming the company wants to keep inventory as low as possible, complete the
following MRP schedules for items B and C.
Item A- Master Assembly Schedule
Week
3
4
10
11
12
Quantity
100
300
200
Item B - Lead Time = 2 weeks
Week
3
5
10
11
12
Gross requirements
On-hand 40
Scheduled receipts
5
Net requirements
Planned order
release
Item C - Lead Time = 3 weeks
Week
2
3
4
6
10
11
12
Gross requirements
On-hand 400
Scheduled receipts
20
Net requirements
Planned order
release
Transcribed Image Text:2. Suppose a company needs to assemble 100 units of product A in week 4, 300 units in week 6, and 200 units in week 10. Items that are assembled are sent immediately to customers after they are assembled. To assemble product A, three units of item B, and two units of item C are needed (item B and C go directly into A on the assembly line). The lead times, on-hand, and scheduled receipts for items B and C are shown below. Assignment Assuming the company wants to keep inventory as low as possible, complete the following MRP schedules for items B and C. Item A- Master Assembly Schedule Week 3 4 10 11 12 Quantity 100 300 200 Item B - Lead Time = 2 weeks Week 3 5 10 11 12 Gross requirements On-hand 40 Scheduled receipts 5 Net requirements Planned order release Item C - Lead Time = 3 weeks Week 2 3 4 6 10 11 12 Gross requirements On-hand 400 Scheduled receipts 20 Net requirements Planned order release
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Knowledge Booster
Recruitment
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
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.