Product A is an end item and is made from two units of B and four of C. B is made of three units of D and two of E. C is made of t units of F and two of E. A has a lead time of one week. B, C, and E have lead times of two weeks, and D and F have lead times of three weeks. If 110 units of A are required in Week 10. develop the MRP planning schedule, specifying when items are to be ordered and receiv There are currently no units of inventory on hand. (Leave no cells blank-be certain to enter "0" wherever required.) Item A OH=0 LT=1 SS-0 Q=LAL Item B OH=0 LT=2 SS-0 Q=LAL Item C OH=0 LT=2 SS=0 Q=L4L Item D OH=0 LT=3 Period Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Gross requirements Scheduled receipts Projected available balance Net requirements 1 2 3 4 5 6 7 8 9 10

Product A is an end item and is made from two units of B and four of C. B is made of three units of D and two of E. C is made of t units of F and two of E. A has a lead time of one week. B, C, and E have lead times of two weeks, and D and F have lead times of three weeks. If 110 units of A are required in Week 10. develop the MRP planning schedule, specifying when items are to be ordered and receiv There are currently no units of inventory on hand. (Leave no cells blank-be certain to enter "0" wherever required.) Item A OH=0 LT=1 SS-0 Q=LAL Item B OH=0 LT=2 SS-0 Q=LAL Item C OH=0 LT=2 SS=0 Q=L4L Item D OH=0 LT=3 Period Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Gross requirements Scheduled receipts Projected available balance Net requirements 1 2 3 4 5 6 7 8 9 10

Name: Product A is an end item and is made from two units of B and four of C. B is made of three units of D and two of E. C is made of t units of F and two of E. A has a lead time of one…
Rating: 5 (1 reviews)

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 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 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 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.
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.
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.
Jenny Malone works for the Columbus based Cummins Diesel Engine company. Jenny works in the production scheduling department and she is developing an MRP planning schedule for Item J. Please assist Jenny by developing the correct net requirements, planned order receipts, and planned order releases to meet the gross requirements. The lead time is one week. (Leave no cells blank - be certain to enter "0" in all open cells as required.) ITEM J Gross requirements On hand Net requirements Planned order receipt Planned order release Item J LT=1 Q = L4L 0 32 Period Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases 1 WEEK NUMBER 2 3 76 4 48 5 72 2 76 3 48 72
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.
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?
Item A has a gross requirement of 2,400 in week 6. Currently, there are 200 Item A's on hand with a scheduled receipt of 2,100 items in week 3. The lead time for item A is 2 weeks with an order quantity of 900. Complete the MRP record for Item A. Complete the MRP record for Item A (enter your responses as whole numbers). Week 0 1 2 3 4 5 6 Item A LT=2 Quantity: FOQ=900 Gross Requirements
Lead time for a certain part is 2 weeks, and the order quantity is 50. By completing this MRP record below, answer the following question: What are the Net requirements of the part in Week 3? What action should be taken? O Week Gross Requirements Projected Available Net Requirements Planned Order Receipt Planned Order Release 50 30 O 25 O None of the above 40 1 20 2 15 3 25 4 25
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.