4.11 Given the following product tree, complete the MRP records for parts X, Y, and Z. Notethat parts X and Y have specified order quantities.Y(3)Z(1)W(1)Part XWeekGross RequirementsScheduled ReceiptsLead Time: 1 week Projected Available 10Net RequirementsPlanned Order ReceiptPlanned Order ReleasePart YGross RequirementsScheduled ReceiptsLead Time: 2 weeks Projected Available 30Net RequirementsLot Size: 50Planned Order ReceiptPart JPlanned Order ReleaseGross RequirementsScheduled ReceiptsLead Time: 1 week Projected AvailableNet RequirementsLot Size: lot-for-lot Planned Order ReceiptPart KPlanned Order ReleaseGross RequirementsScheduled ReceiptsLead Time: 1 week Projected AvailableLot Size: 400Net RequirementsPlanned Order ReceiptPlanned Order ReleaseZ(2)12345285155151010152050

Part XWeek12345LT: 1 weekGross requirement1510151015 Scheduled Receipts200000 Projected available…

Answered: 4.11 Given the following product tree,…

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

snip
1.
8. Ajax produces two basic products called A and B. Each week, Paul, the owner, plans to assemble 20 product As and 8 product Bs. a. Given this information and the following product structure diagrams for A and B, fill out the MRP records (inventory status files) for component parts G and Y for the next seven weeks. X A Part G Gross requirements Y Scheduled receipts Projected available balance Planned order release Q = lot for lot; LT = 1; SS=0. 0 Y (2 required) G 10 B Z F Week 1 2 3 4 5 6 7 Part Y Gross requirements Scheduled receipts Projected available balance 67 Planned order release 1 10 Week 23 4 5 6 7 Q=lot-for-lot; LT=2; SS=0. b. Suppose 10 units of safety stock are required for part Y. What changes would result in the records? Would the MRP system produce any exception messages?
You are supposed to find the gross requirements for all of them.
1. Identify some reasons for ERP failures? 2. Explain the chain of events from quality to profits. 3. Why is defining service quality is difficult?
The MRP gross requirements for Item X are shown here for the next 10 weeks. Lead time for A is two weeks, and setup cost is $10. There is a carrying cost of $0.02 per unit per week. Beginning inventory is 72 units. WEEK 1 2 3 4 5 6 7 8 9 10 Gross requirements 21 12 15 45 10 30 100 20 40 150 Use the least total cost lot-sizing method to determine when and for what quantity the first order should be released. Least total cost method indicates that periods units should be ordered to cover the needs for
MRP Logic 13. Item A has a gross requirement for 1,000 in week 5. There are currently 300 of the item on hand, with a scheduled receipt of 100 items in week 2. The order quantity is lot for lot, and there is a two-week lead time. Complete the MRP record for item A.
Complete the following MRP record. Note that the minimum order quantity is 100. What is the average ending inventory over the six weeks? Click the icon to view the MRP record. Complete the material requirements plan (enter your responses as whole numbers). Week ***83*** LT(weeks) 1 Gross requirements Scheduled receipts Projected ending inventory: 0 Net requirements Min. order = 100 Planned receipts 1 0 2 500 3 600 000 4 5 600 250 6 200

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