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

Given the following MRP matrix for Item D: The planned order release for period 3 is
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?
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:
The product structure for product X is illustrated below. Level 0 Level 1 4 Level 2 Level 3 Part H B C D H K M N X Z с K B Lead Time (in weeks) 1 1 3 2 3 2 3 3 4 M D N The lead time for manufacturing any number units for an item and the required number of units for the lower level part in the product structure are reported in the following table. For example, each unit of Part X requires 1 units of Part C and, in turn, each unit of Part C requires 2 units of Part H and 2 units of Part K. 2 1 4 2 2 2 4 1 2 Required number of units X Z H K 100 units of product X are to shipped at the end of week 25. There is no inventory on hand. How many units of part N are required for production? 3200 Specify only the number.
You have just been notified that the lead time forcomponent G of product A ( You are product pla nner for product A (in Problem(A part structure, lead time (weeks), and on-handquantities for product A are shown in Figure 14. 14. From theinformation shown, generate:a) An indented bill of material fo r product A b) Net requirements for each part to produce I0 As in week 8using lot-for-lot. IP).) The field service manager, Mark Moon,has just called and told you that the requirements for B and Fshould each be increased by I 0 units for his repair requi rements inthe field.a) Prepare a list showing the quantity of each part required to produce the requirements for the service manager and the production request of I 0 Bs and Fs. b) Prepare a net requirement plan by date for the new requirements (for both production and field service), assuming that the field service manager wants his 10 units ofB and F in week 6 and the 10 production…
Aggregate planning deals with a number of constraints.These typically are:a) job assignments, job ordering, dispatching, and overtime help.b) part-time help, weekly scheduling, and SKU production scheduling.c) subcontracting, employment levels, inventory levels, and capacity.d) capital investment, expansion or contracting capacity, and R&D.e) facility location, production budgeting, overtime, and R&D.
The BOM for product A is shown in Figure 2, and data from the inventory records are shown in Table 3. In the master production schedule for product A, the MPS start row has 150 units in week 3 and 300 in week 5. Develop the material requirements plan for the next 6 weeks for items B, C, and D.
Each unit of A is composed of one unit of B, two units of C, and one unit of D. C is composed of two units of D and three units of E. Items A, C, D, and E have on-hand inventories of 20, 10, 20, and 10 units, respectively. Item B has a scheduled receipt of 10 units in Period 1, and C has a scheduled receipt of 50 units in Period 1. Lot-for-lot (L4L) lot sizing is used for Items A and B. Item C requires a minimum lot size of 50 units. D and E are required to be purchased in multiples of 100 and 50, respectively. Lead times are one period for Items A, B, and C, and two periods for Items D and E. The gross requirements for A are 30 in Period 2, 30 in Period 5, and 40 in Period 8. Find the planned-order releases for all items
A toy car is composed of a body assembly and four wheels. The body assembly includes a hood, a top, a base, two sides, and a trunk. Inventories and lead times for each part are shown below. 675 toy cars are needed for an order in week 12. Part Inventory Lead Time (weeks) Toy car 100 2 Body assembly 175 4 Hood 100 3 Top 100 2 Base 175 4 Side 150 3 Trunk 300 2 Wheels 575 3 A. The net requirement for bodies is ___ units in week ___. B. In the toy car example above, the planned order release for sides is ___ units in week ___. C. In the toy car example above, the planned order release for wheels is ___ units in week ___. D. In the toy car example above, the planned order release for wheels is ___ units in week ___.
You are supposed to find the gross requirements for all of them.
Prepare a master schedule given this information: It is now the end of week 1; customer orders are 25 for week 2, 16 for week 3, 11 for week 4, 8 for week 5, and 3 for week 6. Use the MPS rule of ordering production when projected on-hand inventory would be negative without production. Suppose that there were 64 pumps in inventory at the beginning of week 1. A production lot size of 70 pumps is used. (Leave no cells blank - be certain to enter "0" wherever required.)
Consider the bill of material for product P and the data given in the following table. The master schedule requirements for P are 60 units in week 6. Items Q and Rare manufactured internally by the firm and use the lot-for-lot lot-sizing rule. Item is purchased from a local distributor, and has a Fixed Order Quantity of 50 pieces per order. Use a blank matrix to solve for the MRP requirements. Q(2) S(3) R(3) Quantity on Hand 5. Scheduled reccipts Item Lead Time 15 20 in week 2 R. S. 25 15 in week 1 Given the following information, how many R's should be ordered? O 180 O 330 O 360 O 165 O 225 -/2/2

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