5. One unit of A is made of two units of B and one unit of C. B is made of three units of D and one unit of F. C is composed of three units of B, one unit of D, and four units of E. D is made of one unit of E. Item C has a lead time of one week; Items A, B, E, and F have two-week lead times; and Item D has a lead time of three weeks. Lot-for-lot (L4L) lot sizing is used for Items C, E, and F; lots of size 22, 50, and 200 are used for Items A, B, and D, respectively. Items A, B, D, and E have on-hand (beginning) inventories of 10, 15, 122, and 100, respectively; all other items have zero beginning inventories. We are scheduled to receive 10 units of A in Week 3, 40 units of B in Week 7, 50 units of F in Week 5, and 100 units of E in Week 2; there are no other scheduled receipts.

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
Topic Video
Question
5. One unit of A is made of two units of B and one unit of C. B is made of three units of D and one
unit of F. C is composed of three units of B, one unit of D, and four units of E. D is made of one
unit of E.
Item C has a lead time of one week; Items A, B, E, and F have two-week lead times; and Item D
has a lead time of three weeks.
Lot-for-lot (L4L) lot sizing is used for Items C, E, and F; lots of size 22, 50, and 200 are used for
Items A, B, and D, respectively.
Items A, B, D, and E have on-hand (beginning) inventories of 10, 15, 122, and 100, respectively;
all other items have zero beginning inventories.
We are scheduled to receive 10 units of A in Week 3, 40 units of B in Week 7, 50 units of F in
Week 5, and 100 units of E in Week 2; there are no other scheduled receipts.
If 22 units of A are required in Week 10:
a. Draw the low-level-code bill-of-materials here.
b. Develop an MRP table in excel.
Transcribed Image Text:5. One unit of A is made of two units of B and one unit of C. B is made of three units of D and one unit of F. C is composed of three units of B, one unit of D, and four units of E. D is made of one unit of E. Item C has a lead time of one week; Items A, B, E, and F have two-week lead times; and Item D has a lead time of three weeks. Lot-for-lot (L4L) lot sizing is used for Items C, E, and F; lots of size 22, 50, and 200 are used for Items A, B, and D, respectively. Items A, B, D, and E have on-hand (beginning) inventories of 10, 15, 122, and 100, respectively; all other items have zero beginning inventories. We are scheduled to receive 10 units of A in Week 3, 40 units of B in Week 7, 50 units of F in Week 5, and 100 units of E in Week 2; there are no other scheduled receipts. If 22 units of A are required in Week 10: a. Draw the low-level-code bill-of-materials here. b. Develop an MRP table in excel.
Expert Solution
Step 1

a. 

  Period 1 2 3 4 5 6 7 8
Item A Gross requirements 0 0 0 0 0 0 0 20
OH = 0 Scheduled receipts 0 0 0 0 0 0 0 0
LT = 1 Projected on hand 0 0 0 0 0 0 0 0
SS = 0 Net requirements 0 0 0 0 0 0 0 20
Q = L4L Planned order receipts 0 0 0 0 0 0 0 20
  Planned order releases 0 0 0 0 0 0 20 0
                   
Item B Gross requirements 0 0 0 0 0 0 40 0
OH = 0 Scheduled receipts 0 0 0 0 0 0 0 0
LT = 2 Projected on hand 0 0 0 0 0 0 0 0
SS = 0 Net requirements 0 0 0 0 0 0 40 0
Q = L4L Planned order receipts 0 0 0 0 0 0 40 0
  Planned order releases 0 0 0 0 40 0 0 0
                   
Item C Gross requirements 0 0 0 0 0 0 60 0
OH = 10 Scheduled receipts 0 0 0 0 0 0 0 0
LT = 1 Projected on hand 10 10 10 10 10 10 0 0
SS = 0 Net requirements 0 0 0 0 0 0 50 0
Q = L4L Planned order receipts 0 0 0 0 0 0 50 0
  Planned order releases 0 0 0 0 0 50 0 0
                   
Item E Gross requirements 0 0 0 0 40 0 0 0
OH = 0 Scheduled receipts 0 20 0 0 0 0 0 0
LT = 2 Projected on hand 0 20 20 20 40 40 40 40
SS = 0 Net requirements 0 0 0 0 20 0 0 0
Q = 60 Planned order receipts 0 0 0 0 60 0 0 0
  Planned order releases 0 0 60 0 0 0 0 0
                   
Item F Gross requirements 0 0 0 0 80 100 0 0
OH = 0 Scheduled receipts 0 0 0 0 0 0 0 0
LT = 1 Projected on hand 0 0 0 0 120 20 20 20
SS = 0 Net requirements 0 0 0 0 80 0 0 0
Q = 200 Planned order receipts 0 0 0 0 200 0 0 0
  Planned order releases 0 0 0 200 0 0 0 0
                   
Item D Gross requirements 0 0 120 0 0 50 40 0
OH = 50 Scheduled receipts 0 0 0 0 0 0 0 0
LT = 1 Projected on hand 50 50 0 0 0 0 0 0
SS = 0 Net requirements 0 0 70 0 0 50 40 0
Q = L4L Planned order receipts 0 0 70 0 0 50 40 0
  Planned order releases 0 70 0 0 50 40 0 0
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,
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.