The gross requirements for Item X are specified for the beginning of weeks 1 through 8 in the table that follows. Theproduct structure for the item is given in the figure: The lead time of each item is specified within square brackets. Forexample, the lead time for Item X is 1 week. The number of units required for each lower level part is specified withinparentheses. For example, each unit of Item B requires 1 unit of Part C and 2 units of Part D.Product Structure for Item X4Level 0Level 1+4Level 2+4Level 3C (1)[LT 1]H (1)[LT 1]K (1)[LT 3]B (1)[LT 1]Gross RequirementOn-hand InventoryPlanned Order ReleaseD (2)[LT 2]M (2)[LT 1]X[LT 1]Z (2)[LT 1]N (1)[LT 1]What is planned order release for Item M in Week 1?0Specify the number of units.C (4)[LT 1]Item XWeek 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8000008512090What is planned order release for Item M in Week 2?450 Specify the number of units.H (1)[LT 1]The projected on hand inventory at the beginning of Week 1 (end of Week 0) for Item X is 65 units and for Item B is 30units. There are no scheduled receipts.What is planned order release for Item M in Week 3?360 Specify the number of units.K (1)[LT 3]

MRP shows the quantity and timing of materials required for production MRP Table:Consider…

Answered: The gross requirements for Item X are…

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

Product A is made of 3 units of B and 2 units of C. Each B is made up of 2 units of D and 3 units of E. Each E is made of 3 units of F and 1 unit of G. C is made of 1 unit of D and 4 units of E. Lead times for all item are 1 week except for B. The lead time for B is 3 weeks. 100 units of A are needed at the start of week 9. There are currently 32 units of B on hand, 212 units of E on hand, 75 units of F which are currently in production will be completed at the start of week 3. Assume 20 units safety stock for all components. Except for C&F which has an FOQ of 80, all components are Lot for lot. Create BOM and MRP.
Item STUVWX>N Y 2. The demand for assembly S is 100 units and it is due in Week 15. Each unit of S requires one unit of T and 0.5 units of U. Each unit of T requires one unit of V, two units of W, and one unit of X. Finally, each unit of U requires 0.5 units of Y and three units of Z. Z Item S T U V W X Y Z a) Calculate the planned orders for all the items. b) Use time phasing to determine an overall schedule. S OH Gross Requirements Inv 100 20 20 10 30 30 15 25 10 2 1 1 1 2 2 1 Lead Time Due Date (weeks) (week) 15 1 T W (2) X Net Requirements Release Date U (0.5) Y (0.5) Planned Order Z (3) Lot Size Policy L4L X10 X5 Min 50 F100 X50 F100 Min 100
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 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.
Eighty units of end item E are needed at the beginning of week 6. Three cases (30 units per case) of Jhave been ordered and one case is scheduled to arrive in week 3, one in week 4, and one in week 5.Note: J must be ordered by the case, and B must be produced in multiples of 120 units. There are 60 unitsof B and 20 units of J now on hand. Lead times are two weeks each for E and B, and one week for J.E a. Prepare a material requirements plan for component J.b. Suppose that in week 4 the quantity of E needed is changed from 80 to 70. The planned-order releasesthrough week 3 have all been executed. How many more Bs and Js will be on hand in week 6?
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.
A phone production company must prepare the production planning for the next 9 weeks. Complete the below table considering this information: Lead Time = 3 Weeks On-hand inventory of 52 phones from week 1. Receipt from an outside supplier of 15 phones at start of week 7 We need to supply 75 phones on week 4. We need to supply 120 phones on week 9. Product A Week 1 2 3 4 5 6 7 8 9 Gross Requirement On-hand inventory Planned order
The gross requirements for item A are specified for the beginning of weeks 1 through 12 in the table that follows. Item A, Level 0 01 02 03 04 05 06 07 08 09 10 11 12 0 60 0 50 0 70 0 40 0 60 0 50 60 ? ? ? ? ? ? ? ? ? ? ? ???????????? Gross requirements. Projected on hand Planned order release The lead time is 2 weeks. The current on hand inventory, at the beginning of week 1 is 60 units. If the order cost is $80 per order and the inventory cost is $1 per unit per period, and the order quantity is the computed part period (or a multiple of the computed part period) when it is necessary to place an order, what is the total cost for the 12 week period? Answer:
Develop a material requirements plan for component H. Lead times for the end item and each component except B are one week. The lead time for B is three weeks. Sixty units of A are needed at the startof week 8. There are currently 15 units of B on hand and 130 of E on hand, and 50 units of H are inproduction and will be completed by the start of week 2. Lot-for-lot ordering will be used for all items.
One unit of Part C is used in item A and in item B. Currently, we have 10 As, 20 Bs, and 100 Cs in inventory. We want to ship 60 As and 70 Bs. How many additional Cs do we need to purchase?
A table is assembled using three components, as shown in the accompanying product structure tree.The company that makes the table wants to ship 100 units at the beginning of day 4, 150 units atthe beginning of day 5, and 200 units at the beginning of day 7. Receipts of 100 wood sections arescheduled at the beginning of day 2. There are 120 legs on hand. There are 60 braces on hand. Leadtimes (in days) for all items are shown in the following table. Prepare a material requirements planusing lot-for-lot ordering.

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

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

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

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…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS