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

Fill the following MRP record and determine the planned order releases for item X225 for each week. ITEM: X225 Lot Size: Multiple of 50 Description: Lead Time: 2 weeks Week 1 2 3 4 5 6 7 8 Gross requirements 60 90 40 55 65 90 70 80 Scheduled receipts 100 50 Projected on Hand 15 Net requirements Planned order receipts Planned order releases
Given the following MRP matrix: LLC: 0 ITEM: X LOT SIZE: MIN 100 Gross Requirements Gross Scheduled Receipts Projected on Hand Net Requirements Net Planned Order Receipts Planned Order Releases Shown smaller: ITEM: X LOT SIZE: MIN 100 Requirements Scheduled Receipts Projected on Hand Requirements Planned Order Receipts Planned Order Releases Answer: LLC: 0 LT: 2 LT: 2 30 PERIOD 1 2 100 PERIOD 50 1 20 10 100 20 2 30 100 50 100 100 30 3 If the ordering cost is $176 and the carrying cost is $1 per unit per period, what is the total inventory related cost for periods 1 through 7? Give answer to 2 decimal WITHOUT the $ symbol. 50 80 20 20 30 50 50 60 80 80 100 30 10 30 80 30 70 90 10 100 100 7 30 10 4 100 100 50 30 5 60 70 6 80 90 30 10 100 100 7 80 10
Should an MRP be used with dependent or independent demand items?
15-12. Complete the following MRP matrix for item A: Item: A LLC: 1 Period Lot Size: Mult 50 LT: 2 1 2 3 4 5 67 8 10 15 25 75 60 85 45 60 Gross Requirements Scheduled Receipts Projected on Hand Net Requirements Planned Order Receipts 50 Planned Order Releases
1. Speedy, Inc. is a company that produces automotive electrical components. AI5I is a common part for all its products. Consider the following grass requirements and inventory data for AISI part: Week 3 6 7 Grass requirements 40 30 30 70 20 Inventory Data: Lead time Beginning inventorry Scheduled receipts Holding cost Setup cost 1 week 40 $2.50/unit/week S150 Based on the L4L. lot-sizing rule, develop a Material Requirements Plan (MRP) for the next 8 weeks for A15I part. Item: A151 Week 5 Lot size: L4L 1 2 4 7 8 Lead time: 1 Gross Requirements Scheduled Receipts On Hand Inventory Net Requirements Planned Order Receipts Planned Order Releases (ii) Based on the FOQ - 57 units lot-sizing rule, develop a Material Requirements Plan (MRP) for the next 8 weeks for A151 part. Item: A151 Lot size: FOQ 57 Lead time: 1 Gross Requirements Scheduled Receipts On Hand Inventory Net Requirements Planned Order Receipts |Planned Order Releases Week 1 2 4 5 7 8
4.11 Given the following product tree, complete the MRP records for parts X, Y, and Z. Note that parts X and Y have specified order quantities. Y(3) Z(1) W(1) Part X Week Gross Requirements Scheduled Receipts Lead Time: 1 week Projected Available Net Requirements Planned Order Receipt Planned Order Release Z(2) 1 2 3 4 5 20 225 15 5 15 10 15 10 Part Y Gross Requirements Scheduled Receipts 50 Lead Time: 2 weeks Projected Available 30 Net Requirements Lot Size: 50 Planned Order Receipt Planned Order Release Part J Gross Requirements Scheduled Receipts Lead Time: 1 week Projected Available Net Requirements Lot Size: lot-for-lot Planned Order Receipt Planned Order Release Part K Gross Requirements Scheduled Receipts Lead Time: 1 week Projected Available Lot Size: 400 Net Requirements Planned Order Receipt Planned Order Release 90
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?
Product A Order Qty = 400 Order Lead Time = 2 Forecast Demand Scheduled Receipts Projected Available Inventory 400 Planned Order Receipts Planned Order Releases 1 300 OD 4, 6, 2 300 400 Sketch and fill in the grid on scrap paper to use on upcoming questions In what periods would you incur a planned order release? OA 1.3, and 4 2.4, and 5 OC 3,5, and 6 and 7 3 300 PERIODS 4 300 5 300 6 300 7 100 8 100
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
What do you understand by Materials requirements planning (MRP)?
Completely fill in the MRP matrices for items J, K, and L. Do not complete the matrix for M and be careful to watch lot size restrictions. Item J LLC 0 Lot Size L4L LT 3 1 2 3 4 5 6 7 8 9 Gross Requirements Scheduled Receipts Projected on Hand 100 Net Requirements Planned Order Receipts Planned Order Releases Item K LLC _ Lot Size Mult 200 LT 2 1 2 3 4 5 6 7 8 9 Gross Requirements Scheduled Receipts Projected on Hand 110 Net Requirements Planned…
Table B shows a partially completed MPS record for ball Develop the MPS for ball Four customer orders arrived in the following sequences (Table B). Table A Order Quantity Week desired 1 500 4 2 400 5 3 300 1 4 300 7 Assume that you must commit to the orders in the sequence of arrival and cannot change the desired shipping dates or your MPS. Which orders should you accept? Table B Item: Ball bearings Quantity on hand: 400 Order policy: 500 units Lead time: 1 week Week 1 2 3 4 5 6 7 8 9 10 Forecast 550 300 400 450 300 350 200 300 450 400 Customer order booked 300 350 250 250 200 150 100 100 100 100 Projected on-hand inventory MPS quantity 500 MPS start Available to promise (ATP)

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