Question
Show work on excel QM to do this thanks
Consider the bill of material for Product Th: To make one unit ofT, it needs one unit ofx and two units ofM. To make one unit of K, it requires 4 units (Corrected) of . The gross requirements for J are 200 units in week 6 and 250 units in week 8. Use the data given in the following table, develop the MRP tables for each item for an 8-week planning perlod. Use the lot-for-lot lot-sixing rule (Please Item Lead Time Quantity on HandScheduled receipts 20 30 in week 2 20 10 in week 1 Consider the bill of material for Product J and the data given in the following table The gross requirements for J are 200 units in week 6 and 250 units in week 8. Develop the MRP tables for each item for an 8-week planning period. Use the lot-for-lot lot-sizing rule. L(4) tM (2) Time Quantity on Hand Scheduled receipts 30 in week 10 in week 1 Beginning1 Gross GIVE) Requirerments Scheduled
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Steps to create the MRP table 1) Enter the gross requirement as per Master Planning Schedule (MPS). Gross requirement of comp

answered by: ANURANJAN SARSAM
Add a comment
Know the answer?
Add Answer to:
Show work on excel QM to do this thanks Consider the bill of material for Product...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Chapter 6 problemi (please use the MRP table for your answer -tae le r r Consider...

    Chapter 6 problemi (please use the MRP table for your answer -tae le r r Consider the bill of material for Product J and the data given in the following table. The gross requirements for J are 200 units in week 6 and 250 units in week 8. Develop the MRP tables for each item for an 8-week planning period. Use the lot-for-lot lot-sizing rule (net requirement). L (4) M (2) Item Lead Time Quantity on Hand Scheduled receipts 0...

  • Material Requirements Planning (MRP) Given the product tree diagram and develop a material requirements plan for...

    Material Requirements Planning (MRP) Given the product tree diagram and develop a material requirements plan for item D. A 400 unit-delivery of product P is due at the beginning of week 7. Use the worksheet Product Structure Tree Inventory Information P Order Currently Scheduled Lead Item On-Hand Recpt (wk) Time Qty LAL P 100 L4L A A FIxed Q 450 Fixed Q = 600 L4L 0 C 90 100 (wk 2) 80 (wk 2) 2 50 2 C D(2 Beg...

  • The bill of materials and the data from the inventory records for product A are shown in the figu...

    The bill of materials and the data from the inventory records for product A are shown in the figure to the right. Assume that the MPS start quantities for A are 100 units in weeks 1, 2, and 7. Derive an MRP plan for the components going into product A using the data in the table below Item Data Category L4L 2 weeks 100 (week 2) 350 L4L 1 week None 215 Lot-sizing rule Lead time Scheduled receipts Beginning inventory...

  • One unit of A is made of three units of B, one unit of C, and...

    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...

  • One unit of A is made of three units of B, one unit of C, and two units of D. B is composed of tw...

    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...

  • sement 5. [Lot Sizing in Material Requirement System (MRP) (10 pts) Type: C Michael Jordan, senior...

    sement 5. [Lot Sizing in Material Requirement System (MRP) (10 pts) Type: C Michael Jordan, senior in the department of management at ISU, recently got a job as a production planner at Honda Automotive Assembly Plant in Lincoln. Alabama. His first task on the job training is to review the master production plan shown below. (Initial inventory = 160 units, Ordering cost = $200 per order Lead time = 1 week, Holding cost = $1 per unit per week. No...

  • Problem 14-5 To simplify data handling to include the receipt of orders that have actually been...

    Problem 14-5 To simplify data handling to include the receipt of orders that have actually been placed in previous periods, the following six-level scheme can be used. (A number of different techniques are used in practice, but the important issue is to keep track of what is on hand, what is expected to arrive, what is needed, and what size orders should be placed.)      One unit of A is made of three units of B, one unit of C, and...

  • Please show all work. Thanks in advance Complete the MRP record for a bicycle frame using...

    Please show all work. Thanks in advance Complete the MRP record for a bicycle frame using a L4L lot-sizing strategy. Repeat using a fixed order quantity of 106 frames. Compare and contrast the results. What are the benefits and drawbacks to each approach? (Leave no cells blank - be certain to enter "O" wherever required.) picture Click here for the Excel Data File Part Name: Bicycle frame Week 6 Week 5 Week 7 Week 8 Week 1 Week 3 Week...

  • Extra Credit MRP Exercise (15 Points) Given: Indented Bill of Material Master Production Schedule (MPS) and...

    Extra Credit MRP Exercise (15 Points) Given: Indented Bill of Material Master Production Schedule (MPS) and Material Requirements Planning (MRP) Tables Bill of Material (QPA) A =Finished Good LT=1 B (1 LT-3 C(2) LT=2 D(1) LT 2 LT-2 F (2) LT-2 G (1) LT=1 Answer the following questions: 1). Fill in MPS/MRP tables provided 2). For Part Number B: What is the first period in which there is a net requirement ?:_AND, What is the net requirement Quantity (in the...

  • One unit of A is made of two units of B and one unit of C....

    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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT