Assume that Product Z is made of two units of A and three units of B. A is made of four units of C and four of D. D is made of two units of E Lead times for purchase or fabrication of each unit to final assembly are: Z takes two weeks; A, B, C, and D take one week each; and E takes three weeks. Fifty one units of Product Z are required in Period 10. (Assume that there is currently no inventory on hand of any of these items.) b. Develop an MRP planning schedule showing gross and net requirements and order release and order receipt dates. (Leave no cells blank - be certain to enter "0" wherever required.) Period 10 Gross requirements Item Z OH = 0 LT = 2 Scheduled receipts Projected available balance Net requirements SS = 0 Q = L4L Planned order receipts Planned order releases Gross requirements Item A OH = 0 LT = 1 SS = 0 Q = L4L Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Gross requirements Item B OH = 0 LT = 1 SS = 0 Q = L4L Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Gross requirements Scheduled receipts Item C OH = 0 LT = 1 SS = 0 Q = L4L Projected available balance Net requirements Planned order receipts Planned order releases Gross requirements Scheduled receipts Item D OH = 0 LT =1 SS = 0 Q = L4L Projected available balance Net requirements Planned order receipts Planned order releases

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter4: Linear Programming Models
Section: Chapter Questions
Problem 111P
icon
Related questions
icon
Concept explainers
Topic Video
Question
Assume that Product Z is made of two units of A and three units of B. A is made of four units of C and four of D. D is made of two units of E
Lead times for purchase or fabrication of each unit to final assembly are: Z takes two weeks; A, B, C, and D take one week each; and E takes three weeks.
Fifty one units of Product Z are required in Period 10. (Assume that there is currently no inventory on hand of any of these items.)
b. Develop an MRP planning schedule showing gross and net requirements and order release and order receipt dates. (Leave no cells blank - be certain to enter "0" wherever required.)
Period
6
8
10
Gross requirements
Scheduled receipts
Item Z
OH = 0
LT = 2
SS = 0
Q = L4L
Projected available balance
Net requirements
Planned order receipts
Planned order releases
Gross requirements
Item A
OH = 0
LT = 1
SS = 0
Q = L4L
Scheduled receipts
Projected available balance
Net requirements
Planned order receipts
Planned order releases
Gross requirements
Scheduled receipts
Item B
OH = 0
LT = 1
SS = 0
Q = L4L
Projected available balance
Net requirements
Planned order receipts
Planned order releases
Gross requirements
Item C
OH = 0
LT = 1
SS = 0
Q = L4L
Scheduled receipts
Projected available balance
Net requirements
Planned order receipts
Planned order releases
Gross requirements
Item D
OH = 0
LT = 1
SS = 0
Q = L4L
Scheduled receipts
Projected available balance
Net requirements
Planned order receipts
Planned order releases
Transcribed Image Text:Assume that Product Z is made of two units of A and three units of B. A is made of four units of C and four of D. D is made of two units of E Lead times for purchase or fabrication of each unit to final assembly are: Z takes two weeks; A, B, C, and D take one week each; and E takes three weeks. Fifty one units of Product Z are required in Period 10. (Assume that there is currently no inventory on hand of any of these items.) b. Develop an MRP planning schedule showing gross and net requirements and order release and order receipt dates. (Leave no cells blank - be certain to enter "0" wherever required.) Period 6 8 10 Gross requirements Scheduled receipts Item Z OH = 0 LT = 2 SS = 0 Q = L4L Projected available balance Net requirements Planned order receipts Planned order releases Gross requirements Item A OH = 0 LT = 1 SS = 0 Q = L4L Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Gross requirements Scheduled receipts Item B OH = 0 LT = 1 SS = 0 Q = L4L Projected available balance Net requirements Planned order receipts Planned order releases Gross requirements Item C OH = 0 LT = 1 SS = 0 Q = L4L Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Gross requirements Item D OH = 0 LT = 1 SS = 0 Q = L4L Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases
Gross requirements
Item E
OH = 0
LT = 3
SS = 0
Q = L4L
Scheduled receipts
Projected available balance
Net requirements
Planned order receipts
Planned order releases
Transcribed Image Text:Gross requirements Item E OH = 0 LT = 3 SS = 0 Q = L4L Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Inventory management
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,