If 22 units of A are required in Week 10, use the low-level-coded bill-of-materials (product structure tree) to find the necessary planned order releases for all components. (Leave the cells blank, whenever zero (0) is required.)

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

4.

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, use the low-level-coded bill-of-materials (product structure tree) to find the necessary planned order releases for all components. (Leave the cells blank, whenever zero (0) is required.)

Perlod:
2
7
10
Grass requirements
Scheduled receipts
Item: A
ОН: 10
LT: 2
SS: 0
Q: 22
Prajected available balance
Net requirements
Planned arder receipts
Planned arder releases
Grass requirements
Scheduled receipts
Iterm: C
OH: 0
Prajected available balance
LT: 1
SS: 0
Q: L4L
Net requirements
Planned arder receipts
Planned arder releases
requirements
Scheduled receipts
Item: B
он: 15
LT: 2
SS: 0
Q: 50
Prajected available balance
Net requirements
Planned arder receipts
Planned arder releases
Grass requirements
Scheduled receipts
Item: D
Он: 122
LT: 3
SS: 0
Q: 200
Prajected available balance
Net requirements
Planned arder receipts
Planned arder releases
Grass requirements
Scheduled receipts
Item: F
OH: 0
LT: 2
SS: 0
Q: L4L
Prajected available balance
Net requirements
Planned arder receipts
Planned arder releases
Grass requirements
Scheduled receipts
Item: E
он: 100
LT: 2
SS: 0
Q: L4L
Prajected available balance
Net requirements
Planned arder receipts
Planned arder releases
Transcribed Image Text:Perlod: 2 7 10 Grass requirements Scheduled receipts Item: A ОН: 10 LT: 2 SS: 0 Q: 22 Prajected available balance Net requirements Planned arder receipts Planned arder releases Grass requirements Scheduled receipts Iterm: C OH: 0 Prajected available balance LT: 1 SS: 0 Q: L4L Net requirements Planned arder receipts Planned arder releases requirements Scheduled receipts Item: B он: 15 LT: 2 SS: 0 Q: 50 Prajected available balance Net requirements Planned arder receipts Planned arder releases Grass requirements Scheduled receipts Item: D Он: 122 LT: 3 SS: 0 Q: 200 Prajected available balance Net requirements Planned arder receipts Planned arder releases Grass requirements Scheduled receipts Item: F OH: 0 LT: 2 SS: 0 Q: L4L Prajected available balance Net requirements Planned arder receipts Planned arder releases Grass requirements Scheduled receipts Item: E он: 100 LT: 2 SS: 0 Q: L4L Prajected available balance Net requirements Planned arder receipts Planned arder releases
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 6 images

Blurred answer
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.