Homework Help is Here – Start Your Trial Now!
Business
Operations Management
One unit of A is made of two units of B, three units of C. and two units of D. B is composed of one unit of E and two units of F.Cis made of two units of Fand one unit of D. E is made of two units of D. Items A, C. D. and F have one-week lead times; B and E have lead times of two weeks. Lot-for-lot (L4L) lot sizing is used for Items A, B. C, and D: lots of size 50 and 220 are used for Items E and F. respectively. Item C has an on-hand (beginning) inventory of 20; D has an on-hand inventory of 50; all other items have zero beginning inventories. We are scheduled to receive 20 units of Item E in Week 2: there are no other scheduled receipts. If 25 units of A are required in Week 8, use the low-level-coded bill-of-materials to find the necessary planned-order relesses for all components. (Leave the cells blank, whenever zero (0) is required.) Perlod: Gross requirements Scheduled receipts Item A OH 0 LT. 1 SS. 0 O LAL Projected available balance Net requirements Planned order receipts Planned order releases Gross requirements hem: B OH:0 LT. 2 SS. 0 Q LAL Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Gross requirements Scheduled receipts tem: C OH 20 LT. 1 Projected available balance Net requirements SS: 0 Q LAL Planned order receipts Planned order releases Gross requirements Scheduled receipts hem E OH: 0 LT. 2 SS: 0 Q. 50 Projected available balance Net requirements Planned order receipts Planned order releases Gross requirements Scheduled receipts em: F OH:0 LT. 1 SS: 0 Q. 220 Projected available balance Net requirements Planned order receipts Planned order releases Gross requirements Scheduled receipts em: D OH: 50 LT. 1 SS: 0 Q LAL Projected available balance Net requirements Planned order receipts Planned order releases

One unit of A is made of two units of B, three units of C. and two units of D. B is composed of one unit of E and two units of F.Cis made of two units of Fand one unit of D. E is made of two units of D. Items A, C. D. and F have one-week lead times; B and E have lead times of two weeks. Lot-for-lot (L4L) lot sizing is used for Items A, B. C, and D: lots of size 50 and 220 are used for Items E and F. respectively. Item C has an on-hand (beginning) inventory of 20; D has an on-hand inventory of 50; all other items have zero beginning inventories. We are scheduled to receive 20 units of Item E in Week 2: there are no other scheduled receipts. If 25 units of A are required in Week 8, use the low-level-coded bill-of-materials to find the necessary planned-order relesses for all components. (Leave the cells blank, whenever zero (0) is required.) Perlod: Gross requirements Scheduled receipts Item A OH 0 LT. 1 SS. 0 O LAL Projected available balance Net requirements Planned order receipts Planned order releases Gross requirements hem: B OH:0 LT. 2 SS. 0 Q LAL Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Gross requirements Scheduled receipts tem: C OH 20 LT. 1 Projected available balance Net requirements SS: 0 Q LAL Planned order receipts Planned order releases Gross requirements Scheduled receipts hem E OH: 0 LT. 2 SS: 0 Q. 50 Projected available balance Net requirements Planned order receipts Planned order releases Gross requirements Scheduled receipts em: F OH:0 LT. 1 SS: 0 Q. 220 Projected available balance Net requirements Planned order receipts Planned order releases Gross requirements Scheduled receipts em: D OH: 50 LT. 1 SS: 0 Q LAL Projected available balance Net requirements Planned order receipts Planned order releases

Practical Management Science
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...
See similar textbooks
icon
Related questions
Question
One unit of A is made of two units of B, three units of C, and two units of D. B is composed of one unit of E and two units of F. Cis made of two units of Fand one unit of D. E is made of two units of D. Items A. C. D. snd F have one-week lesd times; B and E have lead times of two weeks. Lot-for-lot (L4L) lot sizing is used for Items A, B, C, and D: lots of size 50 and 220 are used for Items E and F. respectively. Item C has an on-hand (beginning) inventory of 20; D has an on-hand inventory of 50; all other items have zero beginning inventories. We are scheduled to receive 20 units of Item E in Week 2; there are no other scheduled receipts. If 25 units of A sre required in Week 8, use the low-level-coded bill-of-materials to find the necessory planned-order relesses for all components. (Leave the cells blank, whenever zero (0) is required.) Perlod: 2 4 5 7 Grass requirements Scheduled receipts Item: A OH: 0 LT: 1 SS: 0 Q: L4L Prajected available balance Net requirements Planned arder receipts Planned arder releases Item: B OH: 0 LT: 2 SS: 0 Q: L4L Grass requirements Scheduled receipts Prajected available balance Net requirements Planned arder receipts Planned arder releases Grass requirements Scheduled receipts Iterm: C ОН: 20 LT: 1 SS: 0 Q: L4L Prajected available balance Net requirements Planned arder receipts Planned arder releases Grass requirements Item: E OH: 0 LT: 2 SS: 0 Q: 50 Scheduled receipts Prajected available balance Net requirements Planned arder receipts Planned arder releases Grass requirements Scheduled receipts Item: F OH: 0 LT: 1 SS: 0 Q: 220 Prajected available balance Net requirements Planned arder receipts Planned arder releases Grass requirerments Scheduled receipts Item: D Он: 50 LT: 1 SS: 0 Q: L4L Prajected available balance Net requirements Planned arder receipts Planned arder releases
Transcribed Image Text:One unit of A is made of two units of B, three units of C, and two units of D. B is composed of one unit of E and two units of F. Cis made of two units of Fand one unit of D. E is made of two units of D. Items A. C. D. snd F have one-week lesd times; B and E have lead times of two weeks. Lot-for-lot (L4L) lot sizing is used for Items A, B, C, and D: lots of size 50 and 220 are used for Items E and F. respectively. Item C has an on-hand (beginning) inventory of 20; D has an on-hand inventory of 50; all other items have zero beginning inventories. We are scheduled to receive 20 units of Item E in Week 2; there are no other scheduled receipts. If 25 units of A sre required in Week 8, use the low-level-coded bill-of-materials to find the necessory planned-order relesses for all components. (Leave the cells blank, whenever zero (0) is required.) Perlod: 2 4 5 7 Grass requirements Scheduled receipts Item: A OH: 0 LT: 1 SS: 0 Q: L4L Prajected available balance Net requirements Planned arder receipts Planned arder releases Item: B OH: 0 LT: 2 SS: 0 Q: L4L Grass requirements Scheduled receipts Prajected available balance Net requirements Planned arder receipts Planned arder releases Grass requirements Scheduled receipts Iterm: C ОН: 20 LT: 1 SS: 0 Q: L4L Prajected available balance Net requirements Planned arder receipts Planned arder releases Grass requirements Item: E OH: 0 LT: 2 SS: 0 Q: 50 Scheduled receipts Prajected available balance Net requirements Planned arder receipts Planned arder releases Grass requirements Scheduled receipts Item: F OH: 0 LT: 1 SS: 0 Q: 220 Prajected available balance Net requirements Planned arder receipts Planned arder releases Grass requirerments Scheduled receipts Item: D Он: 50 LT: 1 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

SEE SOLUTIONCheck out a sample Q&A here
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.
SEE MORE TEXTBOOKS