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 20, 40, and 160 are used for Items A, B, and D, respectively. Items A, B, D, and È have on-hand (beginning) inventories of 5, 10, 100, and 100, respectively, all other items have zero beginning inventories. We are scheduled to receive 10 units of A in Week 3, 20 units of B in Week 7,40 units of F in Week 5, and 60 units of E in Week 2; there are no other scheduled receipts. If 20 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 no cells blank-be certain to enter "0" wherever required.)

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 20, 40, and 160 are used for Items A, B, and D, respectively. Items A, B, D, and È have on-hand (beginning) inventories of 5, 10, 100, and 100, respectively, all other items have zero beginning inventories. We are scheduled to receive 10 units of A in Week 3, 20 units of B in Week 7,40 units of F in Week 5, and 60 units of E in Week 2; there are no other scheduled receipts. If 20 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 no cells blank-be certain to enter "0" wherever 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...

See similar textbooks

Similar questions

One unit of A is made of three units of B, one unit of C, and two units of D. B is composed of two units of E and one unit of D. C is made of one unit of B and two units of E. E is made of one unit of F. Items B, C, E, and F have one-week lead times; A and D have lead times of two weeks. Assume that lot-for-lot (L4L) lot sizing is used for Items A, B, and F; lots of size 55, 55, and 200 are used for Items C, D, and E, respectively. Items C, E, and F have on-hand (beginning) inventories of 10, 50, and 160, respectively; all other items have zero beginning inventory. We are scheduled to receive 10 units of A in Week 2, 60 units of E in Week 1, and also 50 units of F in Week 1. There are no other scheduled receipts. If 32 units of A are required in Week 8, use the low-level-coded bill of materials to find the necessary planned order releases for all components
One unit of A is made of three units of B, one unit of C, and two units of D. B is composed of two units of E and one unit of D. C is made of one unit of B and two units of E. E is made of one unit of F. Items B, C, E, and F have one-week lead times; A and D have lead times of two weeks. Assume that lot-for-lot (L4L) lot sizing is used for Items A, B, and F; lots of size 50, 50, and 175 are used for Items C, D, and E, respectively. Items C, E, and F have on-hand (beginning) inventories of 10, 50, and 160, respectively; all other items have zero beginning inventory. We are scheduled to receive 10 units of A in Week 2, 50 units of E in Week 1, and also 40 units of F in Week 1. There are no other scheduled receipts. If 30 units of A are required in Week 8: a. Develop an MRP table in excel.
One unit of A is made of three units of B, one unit of C, and two units of D. B is composed of two units of E and one unit of D. C is made of one unit of B and two units of E. E is made of one unit of F. Items B, C, E, and F have one-week lead times; A and D have lead times of two weeks. Assume that lot-for-lot (L4L) lot sizing is used for items A, B, and F; lots of size 50, 50, and 200 are used for Items C, D, and E, respectively. Items C, E, and F have on-hand (beginning) inventories of 10, 50, and 150, respectively; all other items have zero beginning inventory. We are scheduled to receive 10 units of A in week 2, 50 units of E in week 1, and also 50 units of F in week 1. There are no other scheduled receipts. If 30 units ofA are required in week 8, use the low-level-coded bill-of-materials to find the necessaryplanned-order releases for all components.
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 20, 40, and 160 are used for items A, B, and D, respectively. Items A, B, D, and E have on-hand (beginning) inventories of 5, 10, 100, and 100, respectively; all other items have zero beginning inventories. We are scheduled to receive 10 units of A in week 3, 20 units of B in week 7, 40 units of F in week 5, and 60 units of E in week 2; there are no other scheduled receipts. If 20 units of A are required in week 10, use the low-level-coded bill-of-materials (product structure tree) to find thenecessary planned order releases for all components.
One unit of A is made of two units of B and one unit of C. B is made of three units of Dand 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 havetwo-week lead times; and Item D has a lead time of three weeks. Lot-for-lot (L4L) lot sizingis used for Items C, E, and F; lots of size 20, 40, and 160 are used for Items A, B, andD, respectively. Items A, B, D, and E have on-hand (beginning) inventories of 5, 10, 100,and 100, respectively; all other items have zero beginning inventories. We are scheduledto receive 10 units of A in Week 3, 20 units of B in Week 7, 40 units of F in Week 5, and60 units of E in Week 2; there are no other scheduled receipts. If 20 units of A are requiredin Week 10, use the low-level-coded bill-of-materials (product structure tree) to i nd thenecessary planned order releases for all components.
4. 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. C is made of two units of F and 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 60 and 200 are used for Items E and F, respectively. Item C has an on-hand (beginning) inventory of 10; 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 20 units of A are required in Week 8: C. Draw the low-level-code bill-of-materials here.
4. 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. C is made of two units of F and 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 60 and 200 are used for Items E and F, respectively. Item C has an on-hand (beginning) inventory of 10; 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 20 units of A are required in Week 8: C. Draw the low-level-code bill-of-materials here. d. Develop an MRP table in excel.
The planned order receipt for item A is 200 in week 5 and the lead time is 3 weeks. Which week should the planned order release be?
One unit of A is made of one unit of B and one unit of C. B is made of four units of C and one unit each of E and F. C is made of two units of D and one unit of E. E is made of three units of F. 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 A, D, and E; lots of sizes 50, 100, and 50 are used for items B, C, and F, respectively. Items A, C, D, and E have on-hand (beginning) inventories of 20, 50, 100, and 10, respectively; all other items have zero beginning inventory. We are scheduled to receive 10 units of A in week 1, 100 units of C in week 1, and 100 units of D in week 3; there are no other scheduled receipts. If 50 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.
One unit of A is made of one unit of B and one unit of C. B is made of four units of C and one unit each of E and F. C is made of two units of D and one unit of E. E is made of three units of F. 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 A, D, and E; lots of size 50, 100, and 50 are used for Items B, C, and F, respectively. Items A, C, D, and E have on-hand (beginning) inventories of 15, 55, 100, and 10, respectively; all other items have zero beginning inventory. We are scheduled to receive 10 units of A in Week 1, 100 units of C in Week 1, and 100 units of D in Week 3; there are no other scheduled receipts.If 50 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.)
One unit of A is made of three units of B, one unit of C, and two units of D. B is composedof two units of E and one unit of D. C is made of one unit of B and two units of E. E ismade of one unit of F.Items B, C, E, and F have one-week lead times; A and D have lead times oftwo weeks.Assume that lot-for-lot (L4L) lot sizing is used for Items A, B, and F; lots of size50, 50, and 200 are used for Items C, D, and E, respectively. Items C, E, and F have onhand(beginning) inventories of 10, 50, and 150, respectively; all other items have zerobeginning inventory. We are scheduled to receive 10 units of A in Week 2, 50 units of Ein Week 1, and also 50 units of F in Week 1. There are no other scheduled receipts. If30 units of A are required in Week 8, use the low-level-coded bill-of-materials to i nd thenecessary planned order releases for all components.
One unit of A is made of three units of B, one unit of C, and two units of D. Bis composed of two units of E and one unit of D. Cis made of one unit of B and two units of E. E is made of one unit of F. Items B. C, E, and F have one-week lesd times; A and D have lead times of two weeks. Assume that lot-for-lot (L4L) lot sizing is used for Items A, B. and F; lots of size 45, 45, and 200 are used for Items C, D. and E, respectively. Items C, E, and F have on-hand (beginning) inventories of 8, 50, and 100, respectively; all other items have zero beginning inventory. We are scheduled to receive 10 units of A in Week 2, 40 units of E in Week 1, and also 50 units of F in Week 1. There are no other scheduled receipts. If 28 units of A sre required in Week 8, use the low-level-coded bill-of-materials to find the necessary planned-order relesses for all components. Develop an MRP planning schedule showing gross and net requirements and order relesse and order receipt dates. (Leave the cells…